Excel & data
A Spreadsheet Limit Hid 15,841 COVID Cases. What Small Teams Can Learn
In 2020 an old file format's row limit caused thousands of positive tests to go unreported for days. The lesson is to know your tool's limits.
What happened
In early October 2020, Public Health England said that 15,841 positive COVID-19 cases recorded between 25 September and 2 October had not been included in the daily reported figures. The cause was a spreadsheet: results from testing labs were being collected in a file in an older Excel format, which could hold only about 65,000 rows. When that limit was reached, new records were not added.
Why it matters beyond the headline
The people who tested positive were told. But their contacts, who should have been traced within a short window, were not passed on in time. A technical limit turned into a real-world delay. Nobody planned for the failure, and the system did not warn anyone that it had happened.
Three habits that would have caught it
Know the limit. Every tool has one: rows, columns, file size, number of users. Look it up before a process depends on it. Reconcile counts. Compare the number of records that went in with the number that came out. A simple check that the totals match would have shown a gap on the first day. Make failure loud. A process that silently drops data is more dangerous than one that stops with an error.
Applying it to a small business
You probably do not run a national testing system, but the same pattern appears in order logs, customer lists and stock files. At MayTech Labs we add record counts, validation and visible error messages to the tools we build, so that a limit or a mistake is noticed in minutes and not discovered weeks later.
