vlookup errors

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

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

Education
Risks Digest 10 Mar 2002

Excel suggestions affects the inputs of education grades. Excel often attempts to guess what you would like to type. If you hit enter without noticing the suggestion you may enter Excel’s suggestion and not what you want.

Risks Digest 16 April 1999

A space entered in a number resulted in Excel assuming the cell was text and ignoring it in the calculation. To see how this happens, watch the video clip of how spaces affect IF statements.

Toledo Blade May 1, 2004

A spreadsheet error results in the University of Toledo overstating projected revenue by $2.4 million.

October 2003, The Tennessean

Spreadsheet errors in the bids by ISIS meant that their proposal, that appeared the cheapest, became more expensive once the spreadsheet errors were corrected. This is a typical example of undercharging due to spreadsheet errors in a tender process. 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

2002: Australasian intervarsity debating association

Debating association makes a spreadsheet error in the tabulation due to the incorrect sorting of the data.

 

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