Authors
Stephen G. Powell, Kenneth R. Baker, & Barry Lawson
Abstract
All users of spreadsheets struggle with the problem of errors. Errors are thought to be prevalent in spreadsheets, and in some instances they have cost organizations millions of dollars.
In a previous study of 50 operational spreadsheets we found errors in 0.8% to 1.8% of all formula cells, depending on how errors are defined. In the current study we estimate the quantitative impacts of errors in 25 operational spreadsheets from five different organizations.
Within these 25 spreadsheets we identified 381 potential errors, of which 117 (31%) were confirmed as errors by the developers of the spreadsheet. Among these confirmed errors, 47 (40%) had no quantitative impact on the results. Among the remaining 70 confirmed errors, the largest error was $100 million; however, 9 of the 25 spreadsheets tested had no errors at all.
Sample
Within this sample of 25 spreadsheets we identified 381 issues.
After we discussed these issues with the developers we found that nine spreadsheets had no errors; among the remaining 16 spreadsheets we found a total of 117 errors.
Of these 117 errors, 47 had zero quantitative impact, leaving 70 errors with non-zero impact.
Publication
2009, Decision Support Systems, Volume 47, Issue 2, May, pages 126-132
