Оказывается, не все проблемы можно просто взять и решить с помощью экселя. Из статьи по ссылке: The health secretary has said a technical glitch that saw nearly 16,000 Covid-19 cases go unreported in England "should never have happened". ... The issue was caused by the way the agency brought together logs produced by the commercial firms paid to carry out swab tests for the virus. Public Health England (PHE) had set up an automatic process to pull this data together into Excel templates .... The problem is that the PHE 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. ... Labour's shadow health secretary Jonathan Ashworth said the unreported cases meant as many as 48,000 contacts had not been traced and therefore not been isolating, with "thousands blissfully unaware they've been exposed to Covid, potentially spreading this deadly virus". https://www.bbc.com/news/uk-54422505

Теги других блогов: Excel Covid-19 Public Health England