Single Commands

Command Overview

Single commands are those entered without any parameters other than the work sheet name. The data source is always a single highlighted area on a worksheet within the workbook.

Output from the command is shown on the status bar, in summary format. Currently there are eleven such commands, which are described below briefly:

Command name	Description of output
be*	Benford's law - shows high digit, chi square and d-statistic for the first digit test
b5*	Bottom 5 - lowest numbers within the range highlighted
ch	Chi Square calculation - chi square, degrees of freedom, critical value
ga	Gaps check - shows count of gaps identified as well as number of missing items
ho	Identify dates falling on a federal holiday (US only)
ks	Financial statement comparison - identifies row with the largest difference, expressed as a percentage, during two periods
lu	Check credit card numbers for validity
po*	Population distribution - count and sum, positive, zero and negative
t5*	Top 5 - five largest numbers in the selected range, shown in descending order
un*	Percentiles for the data highlighted - 10, 25, 50 75, 90, 95, 99
wd*	Weekday distribution - count by day of week

Commands marked with * can have a title specified for the chart generated by using the title="Name of Title to Display". For example, the Benford's Law test may be specified either as simply "be sheet=SheetName " or else "be sheet=Sheetname title="Benford's Law Test Title to Display" ". Note that the title and sheetname must be enclosed in quotation marks if they contain any embedded spaces.

Command	Example output
BE	The Benford command is used to analyze the data highlighted on the worksheet. The results indicate the digit with the largest variance from that expected, as well as the measure (both Chi Square and the K-S d-statistic).
BE
B5	The bottom 5 command lists the five smallest amounts within the area highlighted on the worksheet, in ascending order.
B5
CH	The Chi Square command determines the chi square value for the amounts shown in the area highlighted.
CH
GA	The Gaps command determines the number of gaps between numbers which should be sequential, as well as a count of the number missing. Note that the data does not have to be sorted beforehand.
GA
HO	The holidays command counts the number of days in the highlighted are which fall on a federally scheduled holiday. Generally this command will be used as an initial test to determine if there any holidays. If holidays are identified, then a detailed list can be obtained with the holidays command and the necessary command line parameters.
HO
KS	The KS command is used to perform a comparative analysis between two columns of numeric data and identify the row which contains amounts which vary the most, expressed as a percentage. The comparative analysis is does on the highlighted area only, which is assumed to have an account description in the left most column. Only the two rightmost columns are analyzed. This, the section of the worksheet that is highlighted is critical for controlling what analysis is done. In the example below, the line item "data" is shown to have the most variance of the amounts listed.
KS
LU	The LU command is used to verify that numbers (most commonly credit card numbers such as Visa and Master card) are potentially valid numbers, i.e. they adhere to the LUHN-10 checking algorithm. Of course, numbers identified as potentially valid are not necessarily actually valid. The test indicates only if they are potentially valid, according to the LUHN-10 algorithm.
LU
PO	The population command is used to list basic population statistics for the numeric variables within the selected range.
PO
T5	The top 5 command lists the five largest amounts within the area highlighted on the worksheet, in descending order.
T5
UN	The UN command is used to obtain a quick stratification of the numeric values, classified as to percentiles. Only the numeric values within the highlighted range are analyzed.
UN
WD	The WD (weekday) command is used to classify the dates within the area selected as to their counts by day of week. For example, this command can be used to readily determine the number of days which happen to fall on a Tuesday, etc.
WD

Complete Auditor resources
Links \| Privacy Policy \| FAQ \| Downloads \| Trademarks