November 21, 2006 by Mike.Blakley.

By carefully monitoring web logs, it is possible to optimize your web site in order to obtain a better ranking with the various search engines. I use the WebLog program to monitor traffic to my site, and I have experienced a compound rate of growth in excess of 38% monthly (as measured by both data transfer and total HTTP requests). The links below are to the host provided statistics, charts of growth and to the code itself, which is written in standard C++. In order to use the code, you will need to tailor it for your own purposes. Identify unique visitors, classify visits by hour of day, gather statistics for downloads of exe files. Report on visits to web pages, ranked by popularity. Quantify search engine referrals by the major engines (Google, Yahoo, MSN). Program code, documentation with screen shots is available as a “setup” file for downloading and installation.

Posted in SEO Optimization | 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 »

November 20, 2006 by Mike.Blakley.

Shows an example of how to extract data from a file with fixed length records, using the ScriptBasic language.

Posted in Data Extraction | No Comments »

November 20, 2006 by Mike.Blakley.

Identification of transactions which may be errors as they do not match the values stored in a lookup table. Routine is written in ScriptBasic.

Posted in Error identification | No Comments »

November 20, 2006 by Mike.Blakley.

Identify transactions which originated on a Federal Holiday, using the ScriptBasic language. Note that the routine uses a lookup table which can be modified to include dates other than Federal Holidays. No cost. Holiday dates can be customized, if they differ from Federal holidays.  Code is available in  “setup” format.

Posted in Error identification | No Comments »

November 20, 2006 by Mike.Blakley.

Merge two files based upon key field common to both files.

Posted in Data Extraction | No Comments »

November 20, 2006 by Mike.Blakley.

Extract audit data stored in MySQL database using a query. Write results out for further analysis using Excel or EZ-R Stats for Windows. No cost for any of the software.

Posted in Database | No Comments »

November 20, 2006 by Mike.Blakley.

Sample transactions using the cumulative monetary amount (dollar unit sampling) method.  View example screen shots.

Posted in Audit sampling | No Comments »

November 20, 2006 by Mike.Blakley.

Age transaction amounts based upon the numeric field specified. Categorizes transactions based upon date. Excel support function.

Posted in Audit Software | No Comments »