
Cautionary Tales with Tim Harford Wrong Tools Cost Lives
16 snips
May 21, 2021 The podcast dives into the British Government's overly optimistic promise of a contact tracing system during the COVID-19 pandemic, revealing a critical failure involving outdated Excel software. It highlights the disastrous consequences of using unsuitable tools, leading to unreported cases and critical data loss. The discussion extends to the importance of effective communication in healthcare, with historical anecdotes on vaccination strategies. Ultimately, it stresses the dire need for precision in data management to avoid severe public health implications.
AI Snips
Chapters
Books
Transcript
Episode notes
Excel's Limitations
- Public Health England lost COVID cases due to an Excel file format limitation.
- The older XLS format has a row limit, causing data to disappear.
Enron Spreadsheet Errors
- Felina Hermans studied Enron's spreadsheets and found frequent errors.
- Spreadsheets with errors averaged over 750 mistakes.
JP Morgan Loss
- JPMorgan Chase lost $6 billion due to spreadsheet errors, one involving a risk indicator.
- The error made risks appear half as large as they actually were.





