Command Overview

Note: this feature is only available in version 1.3 and above

The round number command is used to select data which meets a specified criteria based upon data in the input source. The command supports three sources of data for testing:

1. Data file in tab separated value format
2. WorkSheet
3. Selected range within a worksheet

The round number command can be used to identify and quantify the extent to which round numbers (often estimates) are being used. A round number is a currency amount with no pennies, i.e. amounts to the right of the decimal point. Round numbers are then classified using the number of zeros to the immediate left of the decimal point. For example, the amount 500.00 is round number, type 2, because it has no pennies, and contains two zeros to the left of the deciaml point.

The round number command will produce a report which shows both counts and percentages for the following:

• numbers which are not round
• round numbers from type 2 to 10

Syntax

The command is entered on the command line as the command name ("rn") followed by one or more command parameters. Each command parameter consists of an argument name, immediately followed by an equal sign ("=") and then immediately followed by a value. The value may be enclosed with quotation marks, and must be enclosed by quotation marks if the value consists of any embedded spaces.

An example of a command parameter to specify that the file name to be processed is test.txt is entered as "file=test.txt" (without the quotations). Each argument on the command line must consist of only valid parameter names. If a required parameter name is missing, then the command line will be colored yellow, an error message will be displayed on the Excel status bar and an audible tone will be sounded.

The following is a listing of all parameter values for the round number command:

An example

The command to be perform a round number analysis on the file named \test\invoice\tran.txt , storing the results on the worksheet named "Round Numbers" is as follows:

rn ds=file file=\test\invoice\tran.txt recap="Extract Data" col="Invoice Amount"

The same command for a data range on a sheet would be:

rn ds=rng sheet=t_CMAData ulc=a1 recap=Extract Data" col="Invoice Amount"

The same command for a selected data range on a sheet would be:

extract ds=rng recap=Extract Data" col="Invoice Amount"

Below is an example of a report produced

Input data sheet used:

Report produced:

During processing, a graphic is displayed, an example of which is shown below:

Main Form