Current Feed Content from 3 Nov 08 13:51
Account Ageing
Mon, 20 Nov 2006 00:00:00 ESTAge transaction amounts based upon the numeric field specified. Categorizes transactions based upon date. No cost.Mike.Blakley@ezrstats.comCumulative Monetary Amount sampling
Mon, 20 Nov 2006 00:00:00 ESTSample transactions using the cumulative monetary amount (dollar unit sampling) method.Mike.Blakley@ezrstats.comRun Queries against MySQL databases using ScriptBasic
Mon, 20 Nov 2006 00:00:00 ESTExtract 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.Mike.Blakley@ezrstats.comMerge match of two files using a key field value
Mon, 20 Nov 2006 00:00:00 ESTMerge two files based upon key field common to both files.Mike.Blakley@ezrstats.comCheck transactions for dates occurring on a weekend
Mon, 20 Nov 2006 00:00:00 ESTIdentify transactions which originated on a weekend, using the ScriptBasic language. Unrestricted use, no cost.Mike.Blakley@ezrstats.comCheck transactions for dates occurring on a Federal holiday
Mon, 20 Nov 2006 00:00:00 ESTIdentify 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.Mike.Blakley@ezrstats.comIdentification/extraction of transactions using a lookup table
Mon, 20 Nov 2006 00:00:00 ESTIdentification of transactions which may be errors as they do not match the values stored in a lookup table. Routine is written in ScriptBasic.Mike.Blakley@ezrstats.comExtraction of data from a file with fixed length records
Mon, 20 Nov 2006 00:00:00 ESTShows an example of how to extract data from a file with fixed length records, using the ScriptBasic language.Mike.Blakley@ezrstats.comExtraction of data from a file with variable length records terminated by CR/LF
Mon, 20 Nov 2006 00:00:00 ESTShows 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.Mike.Blakley@ezrstats.comAudit of transactions using MySQL aggregate queries
Mon, 20 Nov 2006 00:00:00 ESTShows 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.Mike.Blakley@ezrstats.comCross check zip code, telephone area code, state code
Fri, 24 Nov 2006 00:00:00 ESTCode 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.Mike.Blakley@ezrstats.com
Audit routines for account ageing, identification of transactions initiated on Weekends or Federal Holidays, stratification of population prior to sampling, performing cumulative monetary amount (CMA) sampling, interval sampling, etc. Available at no charge. ScriptBasic is open source, no cost (licensed under LGPL).
feedcat.net promotes your content, measures audiences
and saving load of your server resources!
*