Archive for the Validation Category

An alternative for complex formulae in Excel Worksheets

Excel is among the most common platforms for analysis by auditors, analysts and researchers. I have established a beta site for development/testing of various types of data extracts using PHP. In order to use this, upload your Excel data to the server and then code and test the PHP script to perform the analysis. Results are returned in a format that can then be pasted back into Excel. Examples and help screens are provided.

Cross check zip code, telephone area code, state code

If you audit Telco or other records with zip code and area code information, you may want to cross-check the data to ensure it is valid. I have contributed code to the public domain 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.

Cross check zip code, telephone area code, state code

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.

|