Warning: A Saturday morning rant about one of my favourite topics, with added political spice.
During this year’s Conservative Party Conference, leader Kemi (Kaze) Badencoch touted the Party’s new no-net-zero chops. Unfortunately, they came with a £500 billion maths cockupup resulting from an apparent spreadsheet error. It would be funny if it wasn’t serious. Here’s why.
Spreadsheet errors are normal
In mid-1996, two things happened that I am truly proud of. First, I earned a first-class honours degree at uni; second, I had the cover story for the launch of Information Week in the UK. That story was about data warehouses and their potential to replace spreadsheets, a tool I consider one of the most dangerous in the global financial management arsenal. Fast forward 30 years and I see the Conservatives have made a bet based on a massive spreadsheet error. Some people never learn, right?
So what is my issue with the software tool that truly cemented Microsoft’s ability to own the global business desktop landscape? As I said back in ‘96, and as I still say today, a spreadsheet is a general-purpose computational tool with the magical ability to convince unwary users they’ve become financial ninjas who can sidestep all the caveats, documentation, and testing requirements that come with 99.9% of all other software development.
Back then, I already knew the perils of spreadsheet error from bitter personal experience. Academic research from Hawaii supported that view, suggesting that up to 90% of business-critical spreadsheets contain material errors. In plain language, treat spreadsheets with extreme caution.
Examples like PG&E overestimating $9bn in gas contract bids, a well-known building society overpaying £135 million for a mortgage book, and Heineken’s finance department faithfully recording a £1 million-a-month interest calculation error were my throwback proof points. Heck, one of the Big Four accounting firms even ran an annual business event on the topic.
At the time, I searched high and low for a bulletproof replacement as a financial analysis engine. Over time and despite many failed efforts to punch down on spreadsheets, I learned that the so-called ‘market’ often trumps facts when a stock price is involved. Ideological dogma seems to continue leaving a trail of destruction, as the Conservatives recently discovered.
The Conservative cockup
In an under-reported topic, The Guardian picked up that:
Kemi Badenoch’s flagship party conference policy document overestimated the cost of net zero by nearly £500bn, seemingly after someone accidentally double-counted figures on a spreadsheet.
The apparent error appears in a chapter on net zero in The Right Way, a 100-page policy document produced for the Conservative conference in Birmingham. Badenoch repeatedly used the phrase in her main speech.
We are told from time to time that Badenoch is something of an engineering genius, something she touted as part of her anti-net zero pitch:
In a foreword, Badenoch notes that “as an engineer”, she is used to correctly diagnosing issues so they can be addressed. A later part of the report says: “To fix a problem we must first have an accurate understanding of what is causing it.”
I nearly spat out my morning tea when I read that last paragraph. Satire doesn’t come much drier does it?
Methinks it’s time for Kemi to go back to school. In the meantime, I still nurture an animus for spreadsheets even though I have to use them. Thankfully, mine are small affairs and built by robots. After all, they never go wrong, do they?
P.S. Thanks to my long-time colleague and investment partner, Dr Thomas Otter, who correctly predicted I’d have a belly laugh at KemiKaze’s cockup, especially as it relates to my all-time favourite nerdy bugbear. The error could not have happened to a more self-indulgent waste of political space.
Endnote: that last sentence is a fact because I say it is…