Round numbers are those with one or more zeros immediately to the left of the decimal point. Round numbers are indicative of estimates and thus may be of special interest to auditors.
The purpose of the rn command is to prepare a schedule of transactions which have round numbers. The type of round number may be specified using the specification criteria.
To perform such a test and have the results available in electronic work paper format, the following processing information is explained below:
|
|
| Description | Value |
|---|
| Select | Specify 'OK' to have this row processed, otherwise it will be skipped |
| Data Source | Specify the name of the Excel workbook, including directory or the name of the Access database which has the data to be analyzed |
| Command Name | rn |
| Command Description | Check for round numbers of the type specified |
| Table | Must enter either a sheet name followed by $ or else enter an Access table name |
| Where | An optional row selection statement may be made to narrow the analysis to just certain rows |
| Column | The name of a numeric column must be specified here |
| Column String | This command does not accept group of column names |
| Parm1 |
specs - the types of round numbers to be selected. This consists of seven digits of 0 or 1 which are interpreted from left to right as follows:
Not round
Round type 1 (e.g. 5010)
Round type 2 (e.g. 7,500)
Round type 3 (e.g. 8,000)
For example to extract only round numbers of type 1 or 2 the specification would be entered as "0110000" (without the quotes). To extract all round numbers the specification would be "0111111". To extract only numbers which are NOT round, the specification would be "1000000". |
| parm2 | This command does not accept a second parameter |
| Theme | No chart is produced, so this value is not applicable |
| Title | No chart is produced, so this value is not applicable |
Return to electronic work paper home page
|
