The XL Audit Commander is an Excel add-in and requires Excel 2003 or later. It also requires Windows XP (Vista not supported). There is no support for the Macintosh, nor are there any current plans to do so. The software does require the Microsoft MDAC (Microsoft Data Access Component), for which there is no direct charge from Microsoft.
What's the cost?
The XL Audit Commander is offered free for any use, including commercial, educational and personal.
What are the limitations of the included database (SQLite)?
SQlite is generally SQL92 compliant.
Although there are few theoretical
limitations as to the size of databases and tables that can be supported,
our experience has been that databases of more than 40 - 60 GB, or tables
with more than 30 million rows tend to become unwieldy.
For the typical analytical tasks performed by many users, SQLite is more than adequate.
Further details are available at the SQLite site.
System limitations
The system does have limitations which are described in some detail.
Is it really free?
The
software is free and can be used for any purpose (including personal,
educational and commercial). The intent is that some users will wish to purchase training modules.
Is the software "crippled" in any way
There is no intention to "cripple" the software in any way, but there
are currently some design limitations.
What types of tests can be performed for Benford's Law?
The types of tests which can be performed to determine compliance with Benford's Law include the following six:
- Test of the first digit only
- Test of the first two digits
- Test of the first three digits
- Test of the last digit
- Test of the last two digits
- Test of the second digit
Datasources
In order to run Benford tests, the data must first be converted to the
industry standard "Tab separated format (TSV)". There are instructions on how to do this for various data sources.
What is SQLite?
SQLite is an open source (public domain)
database system which conforms with most of the SQL92 standards
(principal difference is lack of an "ALTER" command). There is complete
information available at the SQLite home page.
