Skip to main content

Press: Why you should never use Microsoft Excel to count coronavirus cases

Why you should never use Microsoft Excel to count coronavirus cases

Professor Paul Clough


Public Health England has admitted that 16,000 confirmed coronavirus cases in the UK were missed from daily figures being reported between September 25 and October 2. The missing figures were subsequently added to the daily totals, but given the importance of these numbers for monitoring the outbreak and making key decisions, the results of the error are far-reaching.

Not only does it lead to underestimating the scale of coronavirus in the UK, but perhaps more important is the subsequent delay in entering the details of positive cases into the NHS Test and Trace system which is used by a team of contact tracers. Although all those who tested positive had been informed of their results, other people in close contact with them and potentially at risk of exposure were not immediately followed up (ideally within 48 hours). This was a serious error. What could have caused it?

It emerged later that that day a “technical glitch” was to blame. To be more specific, the lab test results were being transferred to Excel templates. The templates hit a limit in the number of rows they could handle and then failed to update with more cases added. The issue was resolved with all new cases added to the totals reported over the weekend by breaking the data down across smaller spreadsheets.

Labels:

Comments

Post a Comment

Popular posts from this blog

My Time in Sheffield as a Visiting Researcher - Dr Abdulhalik Pinar

Returning to Sheffield after more than a decade has been a mixture of nostalgia and new opportunities. I first came here in 2011 to complete my MA in Librarianship, and now, I find myself back as a visiting scholar at the Information School. My time as a visiting researcher at the University of Sheffield has been truly rewarding. I am an academic staff at Harran University in Turkey supported for this visit by Tubitak (The Scientific and Technological Research Council of Turkey). This visit has been a great opportunity for my academic and professional development. I am conducting research on artificial intelligence within GLAM (Galleries, Libraries, Archives, and Museums) institutions. I have especially valued the support of my supervisor Dr. Andrew Cox who has guided me through this process. He is an extremely helpful, supportive and understanding person. The University of Sheffield has provided me with an excellent working environment, surrounded by helpful staff and dynamic research...
Post a Comment
Read more

Tools for Life: Data Sharing and Public Health

 Data is the lifeblood of our digital society, but how our personal information is stored and shared is an understandably contentious issue. ‘ Tools for Life: Data Sharing and Public Health ’, a 20-month public engagement project which concluded in March 2021 and was headed by Information School Lecturer Dr Jonathan Foster, looked into the issues surrounding this idea in the context of patient data, with consideration of this issue being particularly important against the backdrop of the current NHS opt-out system for consent. Dr Jonathan Foster Alongside Dr Foster, the project involved fellow Information School Lecturer and expert in Health Informatics Dr Laura Sbaffi, and Professor Suzanne Mason, a clinician academic and Professor of Emergency Medicine based at the University’s School of Health and Related Research (ScHARR). With Jonathan’s expertise being in Information Management, the project had a broad knowledge base from both the health and the data side of the equation. The...
Post a Comment
Read more

Dr Kate Miltner joins UK Young Academy

We are pleased to announce that Dr Kate Miltner has joined the UK Young Academy, an interdisciplinary network of early-career professionals and researchers working together to tackle pressing global and local challenges and promote lasting change. Dr Miltner is among the 42 emerging leaders from across the UK selected as the newest members of the UK Young Academy. The new members come from a wide range of sectors, with backgrounds in political science, engineering, government, communications and the creative and performing industries, and more. As members of the UK Young Academy, they will have the opportunity to take action on both local and global issues. Through interdisciplinary projects and working across sectors, they will bridge gaps, drive innovation, and develop the solutions needed to address critical challenges – all while advancing their professional development and contributing to a global network of Young Academies focused on achieving positive outcomes. "I'm tru...
Post a Comment
Read more