Welcome to DU! The truly grassroots left-of-center political community where regular people, not algorithms, drive the discussions and set the standards. Join the community: Create a free account Support DU (and get rid of ads!): Become a Star Member Latest Breaking News General Discussion The DU Lounge All Forums Issue Forums Culture Forums Alliance Forums Region Forums Support Forums Help & Search

muriel_volestrangler

(101,322 posts)
3. Excel: Why using Microsoft's tool caused Covid-19 results to be lost
Wed Oct 7, 2020, 08:41 AM
Oct 2020
The issue was caused by the way the agency brought together logs produced by commercial firms paid to analyse swab tests of the public, to discover who has the virus.

They filed their results in the form of text-based lists - known as CSV files - without issue.
...
The problem is that PHE's own developers picked an old file format to do this - known as XLS.

As a consequence, each template could handle only about 65,000 rows of data rather than the one million-plus rows that Excel is actually capable of.

https://www.bbc.co.uk/news/technology-54423988

Latest Discussions»Region Forums»United Kingdom»(UK) Covid: 16,000 corona...»Reply #3