You are currently browsing the Audit Commander weblog archives for November, 2006.
November 24, 2006 by Mike.Blakley.
Code written in C++ to enable cross checking and validation of zip codes, telephone number area codes and state codes (US only). Useful for data integrity checking. Zip code database required (not provided) but there is a link to a no cost zip code database. Download.
Posted in Validation | No Comments »
November 23, 2006 by Mike.Blakley.
Web Log 1.6 includes tracking for RSS files, OPML and also other search engines such as AllTheWeb, Ask, Netscape, Alexa, etc. Further, there is additional documentation on auditing Internet logs, such as obtaining data from the regional internet registries (RIR), along with programs to build the IP address to country code lookup table. I post all the recent data on the site. All this software is open source and I contribute it to the public domain.
Posted in Web Log Analytics | No Comments »
November 21, 2006 by Mike.Blakley.
Techniques to convert data from a variety of sources (e.g. Excel, MS-Access, database ODBC, text files, etc. into the industry standard tab separated value format. Once data has been converted into this format, it may then be loaded into databases such as SQLite, MySQL, and is also in the proper format for data analysis using software packages such as EZ-R Stats for Windows and other software packages. View PDF
Posted in Data Validation | No Comments »
November 21, 2006 by Mike.Blakley.
Documentation showing audit techniques for the commonly used Internal Audit software functions. View document.
Posted in Data Validation | No Comments »
November 21, 2006 by Mike.Blakley.
Documentation showing audit techniques for the application of Benford’s Law.
Posted in Data Validation | No Comments »
November 21, 2006 by Mike.Blakley.
Documentation showing techniques used to identify duplicate payments. View document.
Posted in Data Validation | No Comments »
November 21, 2006 by Mike.Blakley.
Documentation showing how to use the open source SQLite database to perform common audit functions. View.
Posted in Data Validation | No Comments »
November 21, 2006 by Mike.Blakley.
Documentation showing example screen shots for all of the menu selections for EZ-R Stats for Windows.
Posted in Audit Software | No Comments »
November 20, 2006 by Mike.Blakley.
Shows how to perform various audit tests using MySQL aggregate functions to obtain totals, minima, maxima, etc. Also illustrates the “where” clause which can further isolate or identify the population to be tested.
Posted in Database functions | No Comments »
November 20, 2006 by Mike.Blakley.
Shows an example of how to extract data from a file with variable length records, each line terminated by a carriage return/linefeed, using the ScriptBasic language.
Posted in Data Extraction | No Comments »