Excel: Why using Microsoft's tool caused Covid-19 results to be lost
have seen folks sorting Excel tables on one column (thinking it's Access!) and muddling up the details; happened once with my Bank's CC Autodebit
www.bbc.com/news/technology-54423988
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.
And since each test result created several rows of data, in practice it meant that each template was limited to about 1,400 cases.
When that total was reached, further cases were simply left off.
Excel: Why using Microsoft's tool caused Covid-19 results to be lost
have seen folks sorting Excel tables on one column (thinking it's Access!) and muddling up the details; happened once with my Bank's CC Autodebit
www.bbc.com/news/technology-54423988
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.
And since each test result created several rows of data, in practice it meant that each template was limited to about 1,400 cases.
When that total was reached, further cases were simply left off.