vlookup errors

Examples of what goes wrong with Spreadsheets in Construction
    Below are stories relating to spreadsheet errors found in construction.

Remember also, that these are the published stories only. We know of many other that cannot be published, and it would surprise us if any large organisation could claim to never having a spreadsheet error in the years they have been operating.

If you already know that spreadsheet errors are an issue, then why not see how a tool like Spreadsheet Professional can assist you. See more on the Spreadsheet Professional pages.

 

 

 

 

All stories courtesy the European Spreadsheet Risks Interest Group Site www.eusprig.org

Construction
March 28, 2004

Transposition error in a spreadsheet results in investigators making incorrect accusations relating to fraud in the Highway Department of Brookhaven.

October 10, 2003

Emerson’s bid was understated by $3.7 million due to an item not being included in the totals. To see how errors can result in the totals, view or download the Insert Row Errors clip.

This is extremely likely in a tender process as any errors made in the companies favor will result in the company losing the tender. If the errors are the other way, it is likely the tender will be won, and the losses will materialize

Orlando Sentinel September 12 2003

Duplicated costs within a Henderson Young & Co spreadsheet for Lake County Public Schools resulted in inflated school impact fees of $12 million

September 2000: An extract from the proceedings of the Public Accounts committee in Ireland

Spreadsheet errors in tenders cause additional costs.

 

Quick Links:

Main War Stories Page
Agriculture
Biotechnology/ Pharmaceutical/ Medical/ Science
Charity
Construction
Consulting
Education
Environment
Financial institutions/ Asset Management/ Private Equity/ Mergers and Acquisitions etc
Insurance
Mining
Storage
Technology
Telecommunication
Transportation
Utility
Government

 

Home | Contact Us | Sitemap | Training | Sarbanes Oxley | Articles | Links | Blog