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.
Ask episode
AI Snips
Chapters
Books
Transcript
Episode notes
INSIGHT

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.
ANECDOTE

Enron Spreadsheet Errors

  • Felina Hermans studied Enron's spreadsheets and found frequent errors.
  • Spreadsheets with errors averaged over 750 mistakes.
ANECDOTE

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.
Get the Snipd Podcast app to discover more snips from this episode
Get the app