Decision Mechanics

Insight. Applied.

  • Services
    • Decision analysis
    • Big data analysis
    • Software development
  • Articles
  • Blog
  • Privacy
  • Hire us

Spreadsheet disasters

February 13, 2023 By editor

Matt Parker describes what happens when spreadsheets go wrong in the BBC's "More or Less: Behind the Stats" podcast. I've been writing about this for over a decade and, sadly, little progress had been made. The cartoon is from xkcd, obviously. … [Read more...]

Filed Under: Data analysis Tagged With: data quality, spreadsheets

And if thine data offend Excel, change it

August 4, 2021 By editor

I've written numerous articles on issues with spreadsheets and why they shouldn't play any part in a data analytics pipeline. However, trying to persuade people to stop defaulting to Excel is a thankless task. So, it was no surprise (but very depressing) to read that geneticists changed their naming conventions to prevent Excel mangling their data. My dismay was alleviated, partially, by a great … [Read more...]

Filed Under: Data analysis, Data science Tagged With: Excel, genetics, spreadsheets

Spreadsheet error delays opening of children’s hospital

October 26, 2020 By editor

An audit report has blamed a spreadsheet "copy and paste" error for cost overruns and delays at an Edinburgh children's hospital. A local politician called it [...] one of the most expensive typos in history. How many more high-profile spreadsheet failures is it going to take before we deem the inappropriate use of them to be professional malpractice? … [Read more...]

Filed Under: Data analysis, Software Tagged With: spreadsheet abuse, spreadsheets

16,000 coronavirus cases missed by Excel

October 5, 2020 By editor

When the lead story in the Daily Mail complains about Excel misuse in its headline you know things have gone too far. 15,841 coronavirus cases were excluded from UK government figures as a result of ...an Excel spreadsheet reaching its maximum file size, which stopped new names being added in an automated process. Apparently these details were not supplied to the "track and trace" … [Read more...]

Filed Under: Data analysis Tagged With: Excel, spreadsheets

When Spreadsheets Attack!

May 7, 2020 By editor

Stand-up comedian Matt Parker talks about when "spreadsheets hit the fan". … [Read more...]

Filed Under: General Tagged With: spreadsheets

  • 1
  • 2
  • Next Page »

Search

Subscribe to blog via e-mail

Subscribe via RSS

Recent posts

  • Accuracy vs precision
  • It’s not because we have insufficient data…
  • Large Language Models
  • Spreadsheet disasters
  • 10 ways to mislead with data visualization

Copyright © 2023 · Decision Mechanics Limited · info@decisionmechanics.com