Here’s a list of publicly-reported spreadsheet mistakes, compiled by the European Spreadsheet Risk Interest Group.
These stories illustrate common problems that occur with the uncontrolled use of spreadsheets. We say how we think the problem might have been avoided.
An obvious form of risk avoidance is simply to check your work before sending it out. For important spreadsheets, a second pair of eyes (‘peer review’) is even better. Where stakes are high, a thorough test and audit is a further defence.
How about some personal anecdotes. Have you ever been embarrassed by a serious spreadsheet error?