New! March 22, 2004.  Here is a student (or trial) version of the Excel program that does the Data Profile, and Benford's Law First Digit, Second Digit, and First-Two Digits test with output statistics.  The ProfileFirSecFir2 file works with Excel 2000, 2002, or 2003.  Set Security to Medium if prompted.  Enter data in column B starting at B2.  Use Tools/Macro/Macros/Run to run.  If you need a test data set here is a Data Set of 1,000 Census Numbers.

The Student/Trial version will process the first 999 records in your data set correctly (unless you find the line of code where I limit the program to the first 999 records and change it to 65,536 records!)

DATAS ADDRESS is an address matching program that matches addresses by stripping away all characters from address fields except for the digits in the street address and the zip (or postal) code.  This means that the programs will detect a match even with different spellings of the street name, different indicators for a subunit (suite, apartment, #), and different spellings of the city or state. Program will therefore match 123 N. Main Str., Cincinnati  OH  45201 with 123 North Main Road Cincinnati  Ohio  45201.  The program is used to match employee address and vendor addresses.  There is also a program that looks for matches within one data set and here an analyst can look for multiple vendors at the same address.

DATAS for IDEA is comprehensive data analysis suite of programs running on IDEA as a platform.  The tests include all the tests from Chapter 5 to Chapter 11 in my Using Microsoft Access for Data Analysis and Interrogation book.  Also included is an address matching routine that has the same functionality and uses the same matching logic as DATAS ADDRESS above.

DATAS for IDEA can only be ordered from Audimation Services, Inc. in Houston, Texas hence the link above to Audimation's website.

This set of programs runs using any recent version of SAS.  These programs run using the full complement of digital analysis tests described in Digital Analysis Using Benford’s Law.  The advantage of these programs is that the code can be changed by the user if deemed beneficial and SAS can process large data sets very efficiently.

This program analyzes the first, second, first-two, and last-two digits of the numbers in a data set.  The program runs on Windows and so no special platform is needed.  Program executes very quickly.  Excel files are included to produce neat graphs.

 For a comprehensive listing of accounting and auditing software see,

 http://www.accountingsoftwaresdirectory.com/