EZ-R Stats, LLC

The main form consists of six tabbed sheets where the auditor can specify the process to be performed. Each tab consists of drop down lists, text boxes, check boxes, command buttons, etc. This provides a familiar working environment for the auditor.

1. "Form" - the sheet which specifies the data to be analyzed and the audit procedure to be performed
2. "Report" - a sheet with the results of the test (results are also written to work papers, chart and text file)
3. "Chart Parameters" - title, color etc for charts to be produced
4. "Audit Information" - name, number of the audit and location where the information is to be stored
5. "Errors" - describe any errors encountered in the processing
6. "About" - version information

On the "form" tab, there will be at least the following elements:

• Type of data source (e.g. Excel, Access, text, etc)
• Name of the file containing the data being audited
• Name of the work sheet or table containing the data of specific interest
• Name of the column containing the audit data being tested
• Type of audit procedure being performed (e.g. duplicates, summarization, Benford's law, etc.)
• Any additional information relating to this specific command (e.g. starting date, date format, etc.)

The information is entered using drop down lists, command buttons or by entering text. Once all the information has been entered, the audit procedure can then be performed by clicking the "Process" button. Summary results will be displayed on the status bar at the bottom of the form.

Output will be written to the work papers in the directory specified. The commands will be logged so that they can be re performed, if desired. The auditor can view the results and perform additional tests, as needed.