Does "spreadsheet horror story" seem ridiculous? After all, spreadsheets are just a tool for crunching numbers and keeping track of data. Don't horror stories involve blood and guts or at least ghosts?
Mistakes from spreadsheets can indeed be very scary. To make the point, the European Spreadsheet Risks Interest Group (EuSpRIG) has posted spreadsheet horror stories. (An older list, with stories from 2006 and earlier, is here.) A few examples:
- April 2013: A student shows that spreadsheet errors skewed the results in an article by Harvard economists.
- Jan. 2012: A spreadsheet error leads to four Olympics events being oversold by 10,000 tickets.
- Dec. 2011: The admissions process for the Oxford history program was gummed up by errors entering test scores onto spreadsheets.
- Nov. 2011: A spreadsheet error made it falsely appear that a cement factory was polluting and owed a $350,000 fine.
- July 2011: An employee in Clallam County, WA, hides embezzlement by hiding spreadsheet rows.
UW students, faculty, and staff have access to the Microsoft IT Academy at the UW. "The courses range from the very basics to expert to computer professional." UW Information Technology also offers free workshops on a variety of topics, including Intro to Microsoft Excel.
No matter how precise a spreadsheet appears, if you type in the wrong formula or the wrong numbers, you'll end up with bad results. Remember the old programmer's slogan: Garbage in, garbage out.