Great article in wired.co.uk:
"Research suggests more than 90 per cent of spreadsheets have errors, and half of spreadsheet models used in large businesses have “material defects” "
And here are only several flops that made headlines:
"Last year, Canadian marijuana grower Canopy Growth had to correct its quarterly earnings after incorrectly posting a £40 million loss — the real figure was £88m, miscalculated by a formula error.
Boeing leaked employees’ personal data in a hidden spreadsheet column.
An investment bank analysis of Tesla’s purchase of Solar City undervalued the company by $400m after double counting its debt in a spreadsheet."
But there is a fix:
"The European Spreadsheet Risks Interest Group (EUSpRig) runs an annual conference to gather research, and collates best practice, training materials, and horror stories on its website — and there’s also a Yahoo Groups mailing list, where members offer tips and tricks, share links to resources and pick apart press coverage of the contact tracing debacle. In short, they can’t figure out what the real problem was because the reporting is so disjointed and unclear."
The conclusion:
" Until we get better at Excel, we’ll need people to protect the world from its own dependence on poorly designed spreadsheets."
So here you have the Excel Warriors saving the world (from spreadsheet disaster).
Shortlist in 10–15 working days
Fixed fees, agreed upon the start
Free recruiting guarantee 12 months
Link to full article:
https://www.wired.co.uk/article/spreadsheet-excel-errors?
Comments