Excel & the Missing Covid Cases

Excel & the Missing Covid Cases

I've seen the articles about Excel being blamed for 15,841 lost Covid cases in England. Here's what I see:

A clickbait headline that's sure to rouse Excel lovers and Excel haters. Good practice for engagement.

However, the articles underneath the clickbait are more interesting. They point to a really old version of Excel being used to compile data from .csv files.

That leads me to more questions than conclusions and answers.

  • Why was Excel being used?
  • Why the old .xls version of Excel?
  • Why not a database or dedicated software?

Having worked with Excel and data in lots of different situations, I can't wag my finger at someone else and say, "well, you should have _____ !" Sometimes there are good reasons why someone is doing something that makes no sense to outsiders.

 I did a project for a company that was stuck on an old version of Excel because it was compatible with a critical software they used, but not compatible with .xlsx versions. They hated the situation and were looking for a solution.

 I've seen dedicated softwares that weren't adopted because they were too damned complicated, and people went back to Excel.

Public Health England (PHE) was using a version of Excel that's at least 13 years old. Why? I don't know. One article says that the PHE "suggests" it was part of a legacy system that they'd recently planned to upgrade. Is that true? I don't know.

 This leaves me with some of my concerns about the future we're living into:

  •  More and more clickbait.
  • More and more finger-wagging from journalists and people who claim to have an Excel-killer for sale. It's great engagement. Clicks, shares, likes, and nasty comments FTW!
  • Software is flimsy and we need to look at this because we're all vulnerable as we rush into the cloud and Internet-of-Things. We've got all these different versions of things; stuff gets hacked; websites crash; plugins and apps get abandoned; one company after another apologizes for security blunders; UX updates that users didn't expect, want or ask for.

This is the future: clickbait and an increasingly flimsy ecosystem of software.

As we stand back and gawk at PHE. Remember this:

There but for the grace of God go I.

That is so insightful and I am sure there are admin staff at Public Health UK who have been wanting the same thing! They should hire you Oz du Soleil to train their staff and help them update their systems!

Like
Reply

Completely agree Oz , rather than understand the why and how to improve, there's a culture for sensationalism which in this current climate is unproductive.

Don't mess with the Excel gang!!!

To view or add a comment, sign in

More articles by Oz du Soleil

  • Apple iOS, Facebook & Privacy

    Have you been paying attention to the battle Apple started when it announced that the forthcoming iOS 14.5 will require…

    16 Comments
  • My Latest Course: Excel VBA for the curious and uncommitted

    I'm writing this article about this course because it speaks to something more broadly about learning. Have you ever…

    13 Comments
  • Excel Weekly Challenge: Filtering with Dynamic Arrays

    This week's challenge involves the new Dynamic Arrays function: FILTER. We want to filter a list of venues based on the…

    7 Comments
  • Excel Weekly Challenge: Find the Power Query Result

    This short challenge is to find the result of a Power Query query and load it onto a worksheet. Our friend Tony insists…

    3 Comments
  • Excel Weekly Challenge: Pivot Table Prep

    Back in the olden days, when I taught pivot tables in live sessions there was always a disappointed groan. This weekly…

    12 Comments
  • Extract the 7 Largest Donations (plus BONUS VIDEO!)

    This week's challenge asks users to extract the Top 7 Donations from a list and specifically, use the LARGE function…

    9 Comments
  • Excel Weekly Challenge: Tables & Hyperlinks

    Excel is more than formulas and pivot tables. There's a lot that we can do in Excel to customize our experience.

    11 Comments
  • Excel Weekly Challenge: COUNTIFS with Wildcards

    This week's challenge is a short one: count the number of projects that contain FF2W and projects that end with W. (And…

    9 Comments
  • Excel Challenge: What Does this Formula Do?

    The Scenario We're taking over a workbook that someone else was using and there's an important but complicated formula…

    5 Comments
  • Excel Weekly Challenge: Dropdown Lists

    This week, users are challenged to create dropdown lists in order to simplify and control inputs. This is all about…

    15 Comments

Others also viewed

Explore content categories