Software:List of spreadsheet mistakes

From HandWiki
Short description: none

A 2017 study concluded that up to 90% of spreadsheets had errors that affected their results.[1]

Below is a list of examples of spreadsheet mistakes that are caused by a variety of reasons.

Date Organization Description Issue Reference
January 1995 Fidelity Investments A $2.6 billion miscalculation after an accountant accountant omitted the minus sign on a net capital loss of $1.3 billion Omitted minus sign [2]
June 2003 TransAlta A $24 million loss from buying more US power transmission hedging contracts at higher prices Cut and paste issue [3]
October 2008 Barclays Unintentionally revealing 179 contracts Lehman Brothers had intended to trade Hidden columns [4]
May 2012 JPMorgan Chase A $6 billion loss when a Value-at-Risk model was miscalculated Cut and paste issue [5]
August 2016 N/A Research on estimating that one-fifth of papers with supplementary material containing Excel gene lists to have erroneous gene name conversions Automatic formatting [6][7]
December 2021 Crypto.com Accidental manual entry caused a $100 refund to be a $10.47 million transfer Manual data entry [8][9]

See also

References

  1. ↑ "Excel errors: How Microsoft's spreadsheet may be hazardous to your health" (in en). https://www.zdnet.com/article/excel-errors-microsofts-spreadsheet-may-be-hazardous-to-your-health/. 
  2. ↑ Godfrey, Kathy (1995-01-06). "Computing error at Fidelity's Magellan fund" (in en). The RISKS Digest 16 (72). https://catless.ncl.ac.uk/Risks/16.72.html#subj1. 
  3. ↑ Cullen, Drew (June 19, 2003). "Excel snafu costs firm $24m" (in en). The Register. https://www.theregister.com/2003/06/19/excel_snafu_costs_firm_24m/. 
  4. ↑ "Barclays Spreadsheet Error Results In Lehman Chaos" (in en-US). Oct 16, 2008. https://www.businessinsider.com/2008/10/barclays-excel-error-results-in-lehman-chaos. 
  5. ↑ Whittall, Christopher. "Value-at-Risk model masked JP Morgan $2 bln loss" (in en-US). U.S.. https://www.reuters.com/article/jpmorgan-var-idUSL1E8GBKS920120511. 
  6. ↑ Ziemann, Mark; Eren, Yotam; El-Osta, Assam (2016-08-23). "Gene name errors are widespread in the scientific literature" (in en). Genome Biology 17 (1). doi:10.1186/s13059-016-1044-7. ISSN 1474-760X. PMID 27552985. 
  7. ↑ "Scientists rename human genes to stop Microsoft Excel from misreading them as dates" (in en-US). The Verge. 2020-08-06. https://www.theverge.com/2020/8/6/21355674/human-genes-rename-microsoft-excel-misreading-dates. 
  8. ↑ Taylor, Josh (2023-09-24). "A crypto firm sent a disability worker $10m by mistake. Months later she was arrested at an Australian airport" (in en-GB). The Guardian. ISSN 0261-3077. https://www.theguardian.com/australia-news/2023/sep/24/a-crypto-firm-sent-a-disability-worker-10m-by-mistake-months-later-she-was-arrested-at-an-australian-airport. 
  9. ↑ Thorne, Simon (2024-01-25). "Spreadsheet errors can have disastrous consequences – yet we keep making the same mistakes" (in en-US). http://theconversation.com/spreadsheet-errors-can-have-disastrous-consequences-yet-we-keep-making-the-same-mistakes-219356. 



Retrieved from "https://handwiki.org/wiki/index.php?title=Software:List_of_spreadsheet_mistakes&oldid=4230895"