XL Audit Commander
Supported platforms
What's the catch?
System limitations
Is it really free?
Is the software "crippled" in any way?
Test Compliance with Benford's Law
Types of tests
Data Sources
What is SQLite?
Supported Platforms
Audit Commander is in alpha testing and has been tested under Microsoft
Windows XP and Vista. There is no support for Macintosh or Unix, nor are there any current plans to do so. The software does require the Microsoft ADODB (Microsoft ActiveX Data Objects), for which there is no direct charge from Microsoft.
What's the catch?
The software is free, but training and support are not.
What are the limitations of 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.
Is it really free?
The software is free and can be used for any purpose (including personal, educational and commercial). License can be viewed. Training and support are not free.
Can I include the code in my software and/or redistribute it at no cost?
Yes, although there are some restrictions.
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.
Is the source included and if so what language is it written in?
All the source code is included. Most of the code is written in Visual Basic 6. The forms and certain processing is written in AutoIt version 3.
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.
The Duplicate Payment Detector is a collection of SQL scripts and a dialog which
can be used to build and query an SQLite database in order to detect
duplicate payments (and other transactions).
Comments, suggestions and user experiences are welcomed and can be sent
to Mike.Blakley AT ezrstats.com.