October 28, 2007 by Mike.Blakley.

Updates

Version 1.34 adds chart results for certain of the audit commands, such as population statistics, weekday analysis, Benford’s Law, etc. These charts are produced in industry standard GIF format and may optionally be saved or stored on the computer for inclusion in reports or used as the basis for editing.

Version 1.34 also includes two additional audit commands used for running a series of command language statements at once. This facilitates performing a series of analytical procedures in a documented and standard manner. The new audit command is called “bc” for batch command, and executes a series of commands on consecutive rows in a worksheet. There are examples provided in the QuickStart workbook at http://ezrstats.com/online/inno/QS.xls.

Version 1.36 adds three commands: query, graphics and trendline. The purpose of the query command is to import data from databases to a worksheet for further analysis. The trendline command is used to chart a series of points. Also, in version 1.36, the charts have been made a little larger, along with the option to specify a title, using the title= parameter. The graphics command is used to set the color theme of the charts displayed

Software is an Excel addin, which is available for free download.

Posted in Data Extraction, Audit sampling, Audit Software | No Comments »

October 5, 2007 by Mike.Blakley.

The latest version has been upgraded to include the ability to obtain cross-tabulations, test for round numbers, do data extractions and perform calculations. Several mini “Audit Guides” have been released - including “Round Numbers” , “Holiday Date testing“, and “Data Stratification“. There is no charge for the software which can be downloaded and installed using a standard setup.exe. An Operation Guide is available with details, as well as online help.

Posted in Data Extraction, Audit Software | No Comments »