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.
Catherine Mondragon MFA, BA

Sheetcast Product Ambassador and Advocate for the Excel Community!

1 年

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!

回复
Sue Bayes

Microsoft Data Platform MVP | Microsoft Certified: Fabric Analytics Engineer Associate, Azure Enterprise Data Analyst Associate, Power BI Data Analyst Associate | Power BI & Excel Developer | Paginated Report Builder

4 年

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.

Ben Currier

????Excel Exposure ??Failure Guy Podcast ?? MBA ?? ADHD ?? 4x MSFT MVP ?? AI Tech Enthusiast ?? Amateur Actor ??? Witch ???? "Comedian" ??

4 年

Keep it up Oz!

Lev Solodkin

Senior Product Manager, Excel at Microsoft

4 年

Don't mess with the Excel gang!!!

要查看或添加评论,请登录

Oz du Soleil的更多文章

  • Apple iOS, Facebook & Privacy

    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 条评论
  • My Latest Course: Excel VBA for the curious and uncommitted

    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 条评论
  • Excel Weekly Challenge: Filtering with Dynamic Arrays

    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…

    6 条评论
  • Excel Weekly Challenge: Find the Power Query Result

    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 条评论
  • Excel Weekly Challenge: Pivot Table Prep

    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 条评论
  • Extract the 7 Largest Donations (plus BONUS VIDEO!)

    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 条评论
  • Excel Weekly Challenge: Tables & Hyperlinks

    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 条评论
  • Excel Weekly Challenge: COUNTIFS with Wildcards

    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 条评论
  • Excel Challenge: What Does this Formula Do?

    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 条评论
  • Excel Weekly Challenge: Dropdown Lists

    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 条评论

社区洞察

其他会员也浏览了