3. Case Studies in Auditing Case studies for duplicate invoice payment recovery, identifying journal entries on weekends, testing to detect curb-stoning in surveys and a variety of audit related scripts written in Script Basic. From:http://www.ezrstats.com Added on: 2006-12-29 17:44:26 Language:English News > Economy & Business
4. SEO Optimization through Web Log Analysis Procedures and source code written in standard C++ for analysis of Web Server Logs. All code is open source, public domain (no cost). 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. From:http://www.ezrstats.com Added on: 2006-12-29 17:36:14 Language:English Internet > S.E.O
The purpose of EZ-R Excel is to simplify and facilitate the analysis and audit of data contained in Excel spreadsheets (or loaded into Excel spreadsheets) by providing an intuitive, easy to use menu system of all the commonly needed analytical and audit tools. EZ-R Excel is free software and may be used for any purpose. To use it, start by selecting or highlighting the area to be analyzed within an Excel spreadsheet, copying that data to the clipboard (either by selecting the menu item Edit | Copy) or else use the shortcut Ctrl-C. Once the data has been copied from the needed are on the Excel spreadsheet, it can then be "pasted" into the EZ-R Excel dialog, by either of three means: 1) click on the "Paste" button, 2) click in the Excel window and press Ctrl-V, or 3) select the menu item Edit | Paste. At this point a menu of analytical functions can be performed, and the results will be displayed in the Chart Box, and can also be saved for printing or further analysis. The results of processing can also be pasted back into Excel.
The key functionality of EZ-R Excel includes the following components
Benford's law
Outlier identification
Identifying duplicate (character) items
Identifying duplicate integers
Gap identification (e.g. check numbers)
Population totals
Linear regression
EZ-R Excel is available at no cost and may be downloaded.