Saturday, October 1, 2022
Published 2 Years Ago on Friday, Oct 16 2020 By Adnan Kayyali
The UK’s Public Health England (PHE) used Excel to store COVID-19 test results, which resulted in 16,000 coronavirus cases going unreported due to an Excel error.
The agency used commercial firms to consolidate and analyze patient test samples in text-based files called CSV files. The source of the problem was suggested to be PHE’s use of an outdated system that could not accommodate the data, according to Matt Hancock, Health Secretary. He added that it was supposed to be replaced 2 months ago.
“Thousands of people [were] blissfully unaware they’ve been exposed to Covid, potentially spreading this deadly virus at a time when hospital admissions are increasing,” Hancock said to the House of Commons. “This isn’t just a shambles. It’s so much worse.”
PHE automated the process of entering data into excel sheets; the format known as XLS to be exact, an older format, capable of handling only about 65,000 rows of data as opposed to current formats capable of holding a million-plus.
Since every case can take up multiple rows, the format chosen to store the data could only handle about 1,400. In other words, the sheet they selected had gone beyond its capabilities, resulting in the loss of many cases.
“Excel was always meant for people mucking around with a bunch of data for their small company to see what it looked like,” said Jon Crowcroft, Professor at the University of Cambridge. “And then when you need to do something more serious, you build something bespoke that works – there’s dozens of other things you could do. But you wouldn’t use XLS. Nobody would start with that.”
The issue which stemmed from a simple Excel error, should be a lesson to many in the future: a modern problem requires a modern solution and modern tools.
Artificial intelligence (AI) systems are already seeing huge adoption by businesses big and small. Its ability to enhance marketing tactics, customer service, business strategy, market analytics, preventive maintenance, autonomous vehicles, video surveillance, medical, and much more. Making AI technology invaluable across all sectors. Here are the fastest advancing AI trends to watch for in 2022. Small […]
Stay tuned with our weekly newsletter on all telecom and tech related news.
© Copyright 2022, All Rights Reserved