🚀 go-pugleaf

The Shareware version CrossTab ver 1.0 is now available for
downloading from the SimTel Coast to Coast Repository(tm) mirror
sites.

What does CrossTab do?

CrossTab is a program which will analyse the data from any three
columns from a dBASE compatible database table and produce a crosstab
analysis based on these columns.  One field becomes the Row Column,
the second field will be used to create as many Column (Field)
Headings as are necessary and the final (Values) field contains the
data that will be intersected between the row and column fields. 

For an example, let us say the sales manager of company A has
extracted the following information from his accounting
database pertaining to his salesmen's performance: 

 SALESMAN     TURNOVER MONTH    
 Jones          800.00		 Jan      
 Peter          750.00 		Jan      
 David          700.00 		Jan      
 Peter          250.00 		Jan      
 Peter          800.00			 Feb      
 Jones          600.00		 Feb      
 David          800.00		 Feb      
 Jones          400.00 		Feb      
 Jones          200.00 		Feb      
 Jones          500.00		 Mar      
 Peter          700.00 		Mar      
 Jones          500.00 		Mar      
 David          500.00 		Mar      
 David          400.00 		Apr      
 Peter          400.00 		Apr      
 Jones          500.00 		Apr      
 David          100.00		 Apr      

He now wants to know the performance of his salesmen for the
four months January to April and runs CrossTab. 

Resulting CrossTab analysis:
	
 SALESMAN	    TOTAL        APR        FEB        JAN        MAR 
 Jones		     3500.00     500.00    1200.00     800.00    1000.00 
 Peter		     2900.00     400.00     800.00    1000.00     700.00 
 David 		    2500.00     500.00     800.00     700.00     500.00 

If he now wants to know the total sales results of each month and
changes a few parameters (just by swapping the Row and Column
Fields) CrossTab produces the following results:  

 MONTH         TOTAL      DAVID      JONES      PETER 
 Feb	         2800.00     800.00    1200.00     800.00 
 Jan		         2500.00     700.00     800.00    1000.00 
 Mar		         2200.00     500.00    1000.00     700.00 
 Apr		         1400.00     500.00     500.00     400.00 

Column headings are created dynamically.

CrossTab will read dBASE ver III+ and higher *.dbf files.
  
You can create your own dBASE IV *.dbf compatible files. 


You can download file crstab10.zip (if you can not locate this file,
it will have been replaced by an update version crstab11.zip) from any
of the following sites in the /msdos/database/ directory:


SimTel, the Coast to Coast Software Repository (tm), is located on
SimTel.Coast.NET, a host that cannot be accessed by anonymous ftp
users, however its files are available by anonymous ftp in directories
/SimTel/msdos, /SimTel/win3, /SimTel/nt, and /SimTel/vendors on
SimTel's
primary mirror site ftp.coast.net (205.137.48.28) located in Detroit,
Michigan, and from the secondary mirror sites:

    Canberra, Australia: archie.au (139.130.23.2)
                           /micros/pc/SimTel
         Beijing, China: ftp.pku.edu.cn (162.105.129.30)
                           /pub/simtel
     Lancaster, England: micros.hensa.ac.uk (194.80.32.51)
                           /mirrors/simtel
        London, England: src.doc.ic.ac.uk (155.198.1.40)
                           /pub/packages/simtel
                           /pub/packages/simtel-win3
        London, England: ftp.demon.co.uk (158.152.1.44)
                           /pub/mirrors/simtel
         Espoo, Finland: ftp.funet.fi (128.214.248.6)
                           /mirrors/simtel.coast.net/Simtel
          Paris, France: ftp.ibp.fr (132.227.60.2)
                           /pub/pc/SimTel
        Bochum, Germany: ftp.ruhr-uni-bochum.de (134.147.32.42)
                           /mirrors/simtel.coast.net/SimTel
         Mainz, Germany: ftp.uni-mainz.de (134.93.8.129)
                           /pub/pc/mirrors/simtel
     Paderborn, Germany: ftp.uni-paderborn.de (131.234.10.42)
                           /SimTel
     Tuebingen, Germany: ftp.uni-tuebingen.de (134.2.2.60)
                           /pub/simtel
              Hong Kong: ftp.cs.cuhk.hk (137.189.4.110)
                           /pub/simtel
          Haifa, Israel: ftp.technion.ac.il (132.68.7.8)
                           /pub/unsupported/simtel
            Pisa, Italy: cnuce-arch.cnr.it (131.114.1.10)
                           /pub/msdos/simtel
         Saitama, Japan: ftp.saitama-u.ac.jp (133.38.200.1)
                           /pub/simtel
         Saitama, Japan: ftp.riken.go.jp (134.160.41.2)
                           /pub/SimTel
           Seoul, Korea: ftp.nuri.net (203.255.112.4)
                           /pub/Simtel
            Netherlands: ftp.nic.surfnet.nl (192.87.46.3)
                           /mirror-archive/software/simtel-msdos
                           /mirror-archive/software/simtel-win3
        Craycow, Poland: ftp.cyf-kr.edu.pl (149.156.1.8)
                           /pub/mirror/simtel
         Warsaw, Poland: ftp.icm.edu.pl (148.81.209.3)
                           /pub/simtel
       Aveiro, Portugal: ftp.ua.pt (193.136.80.6)
                           /pub/simtel
           South Africa: ftp.sun.ac.za (146.232.212.21)
                           /pub/simtel
               Slovenia: ftp.arnes.si (193.2.1.72)
                           /software/SimTel
      Stockholm, Sweden: ftp.sunet.se (130.238.127.3)
                           /pub/pc/mirror/SimTel
    Zurich, Switzerland: ftp.switch.ch (130.59.1.40)
                           /mirror/simtel
         Taipei, Taiwan: NCTUCCCA.edu.tw (140.111.1.10)
                           /PC/simtel
                           /PC/windows/simtel
   Nonthaburi, Thailand: ftp.nectec.or.th (192.150.251.33)
                           /pub/mirrors/SimTel
         Ankara, Turkey: ftp.metu.edu.tr (144.122.1.101)
                           /pub/mirrors/simtel
       Concord, CA, USA: ftp.cdrom.com (192.216.191.11)
                           /pub/simtel
        Urbana, IL, USA: uiarchive.cso.uiuc.edu (128.174.5.14)
                           /pub/systems/pc/simtel
     Rochester, MI, USA: OAK.Oakland.Edu (141.210.10.117)
                           /SimTel
     St. Louis, MO, USA: wuarchive.wustl.edu (128.252.135.4)
                           /systems/ibmpc/simtel
        Norman, OK, USA: ftp.uoknor.edu (129.15.2.20)
                           /mirrors/SimTel
     Corvallis, OR, USA: ftp.orst.edu (128.193.4.2)
                           /pub/mirrors/simtel
Salt Lake City, UT, USA: ftp.pht.com (198.60.59.5)
                           /pub/mirrors/simtel

There are other sites (more than 60, and growing) that mirror SimTel's
collections.  Many serve only their own country or region and do not
wish to receive International traffic.  At their request they are not
listed above.

SimTel files may obtained by e-mail from various ftp-mail servers
or through the BITNET/EARN file servers.  For details send e-mail
to listserv@SimTel.Coast.NET with this command in the body of the
message:  get simtel-mailserver.info

World Wide Web (WWW) users can access SimTel files via these URLs:

 ftp://ftp.coast.net/SimTel/
http://www.coast.net/SimTel/

Choose a site nearest to you, it might respond quicker.


Douglas Marko Yobe
email : dyobe@harare.iafrica.com