home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Bila Vrana
/
BILA_VRANA.iso
/
004A
/
CRSTAB11.ZIP
/
MANUAL.DOC
< prev
next >
Wrap
Text File
|
1996-02-16
|
50KB
|
1,037 lines
CrossTab ver 1.1 Manual Page :1
-------------------------------------------------------------------
CrossTab ver 1.1 Manual Contents
MANUAL PAGE
INTRODUCTION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
INSTALLATION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
HARDWARE AND SOFTWARE REQUIREMENTS . . . . . . . . . . . . . . . . . 3
Operating System . . . . . . . . . . . . . . . . . . . . . . . 3
System Files . . . . . . . . . . . . . . . . . . . . . . . . . 3
CONFIG.SYS . . . . . . . . . . . . . . . . . . . . . 3
AUTOEXEC.BAT . . . . . . . . . . . . . . . . . . . . 3
CONFIG.DB . . . . . . . . . . . . . . . . . . . . . . 3
Hardware . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
Installing CrossTab onto Your Hard Disk . . . . . . . . . . . . . . 4
RUNNING CrossTab . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
QUICK TUTORIAL . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
Generating CrossTab From Previously Saved Selections . . . . . . . . 5
Modifying/Defining New Parameters To Generate a Crosstab . . . . . . 6
CrossTab MENUS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
FILE MENU . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
Create New File . . . . . . . . . . . . . . . . . . . . . . . . 7
Open Existing File . . . . . . . . . . . . . . . . . . . . . . 8
Selecting a DRIVE . . . . . . . . . . . . . . . . . . . . 8
Selecting a SUBDIRECTORY . . . . . . . . . . . . . . . . . 9
Selecting a FILE To Use . . . . . . . . . . . . . . . . . 9
Load Previous Selections . . . . . . . . . . . . . . . . . . . 9
Save Current Selections . . . . . . . . . . . . . . . . . . . . 9
Exit . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
DATABASE FILE MAINTENANCE MENU . . . . . . . . . . . . . . . . . . 10
Add/Modify/Delete Records . . . . . . . . . . . . . . . . . . 10
View Records . . . . . . . . . . . . . . . . . . . . . . . . 10
Pack Database . . . . . . . . . . . . . . . . . . . . . . . . 11
FIELD SELECTION MENU . . . . . . . . . . . . . . . . . . . . . . . 11
Row Field . . . . . . . . . . . . . . . . . . . . . . . . . . 12
Column Field . . . . . . . . . . . . . . . . . . . . . . . . 12
Values Field . . . . . . . . . . . . . . . . . . . . . . . . 13
PROCESS MENU . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
Generate CrossTab . . . . . . . . . . . . . . . . . . . . . . 13
Save CrossTab Results . . . . . . . . . . . . . . . . . . . . 14
Print CrossTab Results . . . . . . . . . . . . . . . . . . . 14
OPTIONS MENU . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
Set/Reset Sort Flag . . . . . . . . . . . . . . . . . . . . . 15
Printer Options . . . . . . . . . . . . . . . . . . . . . . . 15
Edit Printer Heading 1 . . . . . . . . . . . . . . . . . 16
Edit Printer Heading 2 . . . . . . . . . . . . . . . . . 16
Edit Printer Settings . . . . . . . . . . . . . . . . . 16
Select Printer Driver . . . . . . . . . . . . . . . . . 17
Output Destination . . . . . . . . . . . . . . . . . . . 17
View Current Selections - (CTRL+F5) . . . . . . . . . . . . . 18
REVISION HISTORY . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 CrossTab ver 1.1 Manual Page :2
-------------------------------------------------------------------
CrossTab ver 1.1
^^^^^^^^^^^^^^^^
Copyright (c) 1995, 1996 Douglas Marko Yobe
t/a DougSoft Systems
dBASE File Compatible Crosstab Program
MANUAL
------
INTRODUCTION
------------
What is CrossTab?
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 CrossTab ver 1.1 Manual Page :3
-------------------------------------------------------------------
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 creat