HomeLatest ThreadsGreatest ThreadsForums & GroupsMy SubscriptionsMy Posts
DU Home » Latest Threads » Forums & Groups » Places » International » United Kingdom (Group) » (UK) Covid: 16,000 corona... » Reply #3

Response to muriel_volestrangler (Original post)

Wed Oct 7, 2020, 07:41 AM

3. Excel: Why using Microsoft's tool caused Covid-19 results to be lost

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

Reply to this post

Back to OP Alert abuse Link to post in-thread

Always highlight: 10 newest replies | Replies posted after I mark a forum
Replies to this discussion thread
Arrow 3 replies Author Time Post
muriel_volestrangler Oct 2020 OP
The King of Prussia Oct 2020 #1
T_i_B Oct 2020 #2
LineNew Reply Excel: Why using Microsoft's tool caused Covid-19 results to be lost
muriel_volestrangler Oct 2020 #3
Please login to view edit histories.