The IRMA Community
Newsletters
Research IRM
Click a keyword to search titles using our InfoSci-OnDemand powered search:
|
Errors in Operational Spreadsheets
Abstract
Spreadsheets are used in almost all businesses, for applications ranging from the mundane to the mission-critical. Errors in the data, formulas, or manipulation of spreadsheets could be costly, even devastating. The received wisdom is that about 5% of all formulas in spreadsheets contain errors, and this rate is consistent across spreadsheets. However, this estimate is based on five studies, some of which are quite informal, and a total of only 43 spreadsheets. Our research was designed to deepen our understanding of spreadsheet errors. Specifically, we address three questions about errors in operational spreadsheets: what is the average cell error rate, how does it differ among spreadsheets, and what types of errors are most prevalent? We created a spreadsheet auditing protocol and applied it to 50 diverse operational spreadsheets. We found errors in 0.9% to 1.8% of all formula cells, depending on how errors are defined. We also found that the error rate differed widely from spreadsheet to spreadsheet.
Related Content
|
Rod D. Roscoe, Russell J. Branaghan, Nancy J. Cooke, Scotty D. Craig.
© 2018.
34 pages.
|
|
Steve Ritter, R. Charles Murray, Robert G. M. Hausmann.
© 2018.
17 pages.
|
|
Yvonne S. Kao, Bryan J. Matlen, Michelle Tiu, Linlin Li.
© 2018.
24 pages.
|
|
Melissa L. Stone, Kevin M. Kent, Rod D. Roscoe, Kathleen M. Corley, Laura K. Allen, Danielle S. McNamara.
© 2018.
23 pages.
|
|
Elizabeth R. Kazakoff, Melissa Orkin, Kristine Bundschuh, Rachel L. Schechter.
© 2018.
24 pages.
|
|
Irfan Kula, Russell J. Branaghan, Robert K. Atkinson, Rod D. Roscoe.
© 2018.
17 pages.
|
|
Erin Walker, Ruth Wylie, Andreea Danielescu, James P. Rodriguez III, Ed Finn.
© 2018.
19 pages.
|
|
|