figmentPez
Staff member
Excel spreadsheet issue blamed for missing COVID-19 cases in UK
"PHE said that from Sept. 25 to Oct. 2, those cases were not reported in the daily figures announced to the public. It was later revealed that a 'technical issue' had occurred when the Excel spreadsheet used to tally the figures ran out of space."
“The problem is that the PHE developers picked an old file format to do this — known as XLS,” wrote the BBC. “As a consequence, each template could handle only about 65,000 rows of data rather than the 1 million-plus rows that Excel is actually capable of.” It’s now reported that the data had been portioned off into smaller Excel batches.
"PHE said that from Sept. 25 to Oct. 2, those cases were not reported in the daily figures announced to the public. It was later revealed that a 'technical issue' had occurred when the Excel spreadsheet used to tally the figures ran out of space."
“The problem is that the PHE developers picked an old file format to do this — known as XLS,” wrote the BBC. “As a consequence, each template could handle only about 65,000 rows of data rather than the 1 million-plus rows that Excel is actually capable of.” It’s now reported that the data had been portioned off into smaller Excel batches.