Picture,Of,Stressed,Businesswoman,With,Computer,At,Work

Spreadsheet Horror Stories

Spreadsheet errors have contributed to arrests, collapsing businesses, diplomatic incidents and more.

We have compiled, and continue to compile, a list of Spreadsheet Horror stories reported in the media, both online and in traditional outlets. 

There is a good chance that you will have suffered from the knock-on effects of a spreadsheet error, but has it ever been as bad as any of these?

Fishing Boat Diplomacy

ITV News – 29 October, 2021

UK ‘spreadsheet error’ keeping British trawler detained in France, say sources
https://www.itv.com

Bank of England Fine

The Guardian – 20 December, 2021

Standard Chartered fined £46.5m by Bank of England over reporting failures.
https://www.theguardian.com

Empty Hospital

The Scotsman -20 April, 2022

Hospital lies empty for two years whilst costing NHS trust £1.4m per month.
https://www.scotsman.com

Research Grants

The Irish Times – 19 October, 2021

Government grants awarded to researchers in error due to spreadsheet mistake
https://www.irishtimes.com

Vaccination Records Leaked

Newswatch 12 – 19 October, 2021
OSP officers’ union hints at legal action after state official accidentally shares state employee vaccination info
https://www.kdrv.com

Covid Assistance Payments

The Colorado Sun – 25 October, 2021
Colorado’s COVID rent-assistance program may have paid up to $4.4 million in error, audit finds
https://coloradosun.com

Incorrect taxes levied

The Gazette – 1 October, 2021
Council charges incorrect taxes
https://www.thegazette.com

Grant Thornton fined £2.3m

Daily Telegraph – 27 September, 2021
Grant Thornton fined £2.3m for Patisserie Valerie failures
https://www.telegraph.co.uk

Travel Traffic Lights

The Independent – 24 July, 2021
Is France on the Amber Plus list due to a spreadsheet error?
https://www.independent.co.uk

Canadian Furlough Errors

Vaughan Today – 25 January, 2021
The spreadsheet that Canadian employers were required to fill in to apply for Emergency Wage Support was full of errors.
https://www.vaughantoday.ca

Flight delays

CBS Chicago – 13 January, 2021
Flight delays caused by spreadsheet error.
https://chicago.cbslocal.com

Covid Infection Rates

Perry County News – 29 December, 2020
Positivity rates could rise statewide due to miscalculation
https://www.perrycountynews.com

Data Security Issues with ICO

Computer Weekly – 7 December, 2020
HMRC referred 11 data security incidents to ICO in 2019-20
https://www.computerweekly.com

ITV breach Ofcom rules

BBC News – 7 December, 2020
ITV breached Ofcom competition rules over postal votes
https://www.bbc.co.uk

Law students receive wrong grades.

The Lane Report – 7 December, 2020
Law students receive wrong results from state
https://www.lanereport.com

Covid Fatalities

Guardian – 25 November, 2020
Data glitch ‘may have led to more than 1,500 Covid deaths in England’
https://www.theguardian.com

Brazil Health Dept. Data Leak

Tech Times – 26 November, 2020
Brazil’s Health Ministry Password Leak
https://www.techtimes.com

NHS Patient Data Exposed

Infosecurity Magazine – 27 November, 2020
NHS Error Exposes Data on Hundreds of Patients and Staff
https://www.infosecurity-magazine.com

Unreported Covid Cases

The Daily Telegraph – 4 November, 2020
Thousands of positive Covid19 tests go unreported for days due to spreadsheet error
https://www.telegraph.co.uk

US Voting Fraud Accusations

Politifact – 7 November, 2020
Spreadsheet error causes accusation of voting fraud in US 2020 Presidential election
https://www.politifact.com

US Voting Recount Required

Des Moines Register – 6 November, 2020
Vote recount required in US 2020 election after spreadsheet error during copy and paste!
https://eu.desmoinesregister.com

Hospital Opening Delayed

BBC News – 26 August, 2020
Spreadsheet error led to Edinburgh hospital opening delay. https://www.bbc.com

Maths Errors

The Sunday Times – 14 April, 2019
Humble Pi author Matt Parker’s comedy of maths errors. https://www.thetimes.co.uk

School Construction Halted

The Brookings Register – 27 March, 2019
School construction halted due to incorrect bids. https://brookingsregister.com

Patient Data Leaked

Health IT Security – 13 Dec 2018
Patient Data leaked due to emailing of unencrypted spreadsheet.
https://healthitsecurity.com

Council Payment Errors

The Times Record – 07 Dec 2018
City Council Budget & Payment Errors https://www.timesrecord.com

Festival Budget Overspend

The Canberra Times – 23 July 2018
Festival budget overspend due to Excel error https://www.canberratimes.com.au

Council Overspends

Deeside.com – 12 July 2018
Council accidentally breaches its lending limit by £2 million http://www.deeside.com

KPMG Audits Error-ridden

Independent – 03 July 2018
KPMG audits full of spreadsheet errors https://www.independent.co.uk

Wrong Exam Results

Komo News – 19 Feb 2016
Seattle students sent wrong exam results
http://komonews.com

ESRIG Conference

Financial Times – 21 Jul 2015
FT reports from 16th Annual conference of the European Spreadsheet Risks Interest Group in London
http://www.ft.com

Share Trading Suspended

Financial Times Blog ‘Alphaville’ – 29 Jun 2015
Law firm Slater and Gordon share trading suspended due to accidental mis-reporting due to spreadsheet error
http://ftalphaville.ft.com

Cycling Statistics Wrong

StreetsBlog San Fransisco – 22 Jun 2015
Cycling statistics misreported when traffic lane layouts changed
http://sf.streetsblog.org

Evidence Not Supplied

Guardian – 19 Jun 2015
Sydney Siege review not given letter because of spreadsheet tab error
http://www.theguardian.com

Public Body Overcharges

Melbourne Herald Sun – 25 May 2015
Local Government Association overcharges councils for membership over a 10 year period
http://www.heraldsun.com.au/

WI Miss Buck House Invite

Telegraph – 16 May 2015
WI members miss out on Buck House tea party due to admin spreadsheet error
http://www.telegraph.co.uk

Business Losses Suffered

Telegraph – 7 Apr 2015
20% of large businesses have suffered losses due to spreadsheet errors.
http://www.telegraph.co.uk

Spreadsheet Errors cost UK

The Actuary – 8 Apr 2015
Spreadsheet errors prove costly for UK companies
http://www.theactuary.com

Awards Error

Stuff.co.nz – 2 Apr 2015
Winner of Glammies forced to return trophy
http://www.stuff.co.nz

Sharesholders lose $Millions

Wall Street Journal – 16 Oct 2014
Spreadsheet Mistake Costs Tibco Shareholders $100 Million
http://blogs.wsj.com

Austerity Policy Evidence

Guardian – 18 Apr 2013
Austerity policy based on error-strewn economic paper
http://www.theguardian.com

Cyber Attack Threats

Guardian 4 Apr 2013
Spreadsheet risk and the threat of cyber attacks in finance
http://www.theguardian.com

Rail Franchising Process

Accounting Web – 10 Oct 2012
West Coast mainline franchising process restarted
http://www.accountingweb.co.uk

Olympic Tickets Over-Sold

Telegraph – 4 Jan 2012
London 2012 Olympics tickets over-sold
http://www.telegraph.co.uk

Incorrect ONS Figures

Telegraph – 30 Sep 2011
Office for National Statistics releases incorrect figures
http://www.telegraph.co.uk

Erroneuous Arrest

Telegraph – 1 Nov 2010
Bus driver arrested for stealing fares
http://www.telegraph.co.uk

MI5 Wasting Time

Guardian – 1 Jul 2011
MI5 track wrong phone numbers
http://www.theguardian.com

Incorrect Vote Counting

Guardian – 20 Jun 2007
Votes not initially counted in election
http://www.theguardian.com

Upgrade From Spreadsheets

Reduce errors and improve sharing of information

Automate Business Processes

Software can automate many manual and time-consuming processes.  Discover how processes in your business can be automated by software.

Who We Work With

Working Data have designed, built and supported bespoke business software for companies from all sectors and of all sizes.

Request a Consultation