vlookup errors

Examples of what goes wrong with Spreadsheets in Biotechnology/ Pharmaceutical/ Medical/ Science
    Below are stories relating to spreadsheet errors found in biotechnology/ pharmaceutical/ medical/ science.

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

 

 

Biotechnology/ Pharmaceutical/ Medical/ Science
Mistaken Identifiers: Gene name errors can be introduced inadvertently when using Excel in bioinformatics. Barry R Zeeberg et al.BMC Bioinformatics, June 2004

Gene names that are similar to dates results in Excel assuming the cell is a date field and making the relevant changes. These Excel ‘suggestions’ could not be reversed and the data was lost.
Aug. 27, 2003 Kansas City

HealthSouth executives committed fraud and boosted reported earnings by preparing false spreadsheets for the auditors to make the company appear worth more than it was.
June 1998 LIMSList

Problem with spreadsheet macro causes estimated loss of $1 million PER WEEK.
 

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