Quick Start

To get an introduction into the use of XL Audit Commander, download the QuickStart Excel workbook and then do the following:

1. Open the WorkBook in order to experiment with the software. When XL Audit Commander is installed, test data files are stored into the "data" directory selected for the application install. In addition registry entries are written to provide one example of each command. These command all reference either WorkSheets within the QuickStart WorkBook (QS.xls) or else data files installed with the application.
2. Start XL Audit Commander by entering the command "Control - E ", i.e. hold down the control key and the letter E at the same time. As an alternative, the menu option, XLAC | About | Switch On can also be selected.
3. The toolbar default command is "LC name=cmd" which is the command to load the toolbar with commands installed in the registry under the name "cmd". Click the process button on the right side of the toolbar to load the commands. The status bar will now display the number of commands loaded.
4. Now select any command from the drop down list and run it. Once the command is run, there should be a message on the status bar.
5. For example, if the Benford's Law analysis is run against the MS-Access database provided, the results will be shown as follows:
7. 

The separate components of the command are as follows:

• the command "BE" - the Benford's Law command
• ds=db which specifies that the data source (ds) is a database (db)
• conn= the connection string to connect to the database, in this case the MS-Access file name
• sql= the sql to be used to obtain a record set for analysis
• fldno=0 the sequence of the sql columns returned which contains the numeric data to be analyzed using benford's law
• type=F1 - the type of test to perform, in this case F1 - the first digit
• recap=res the name of the sheet to contain the results, in this case "res"

The output from the analysis is written to the sheet named "Res". Summary processing statistics are also written to the application status bar as follows:

• Cmd: BE - the name of the command processed
• processed; 551 items - the number of rows of data which were processed (i.e. the population)
• report is at res - the name of the worksheet containing the report
• rps: 905 - the speed of query, in this case 905 rows per second
• elapsed: .609 - the number of seconds required to process the query (in this case less than one second)