An auditing protocol for spreadsheet models

Errors are prevalent in spreadsheets and can be extremely difficult to find. A number of audits of existing spreadsheets have been reported, but few details have been given about how the audits were performed. We developed and tested a new spreadsheet auditing protocol designed to find errors in operational spreadsheets. Our work showed which auditing procedures, used in what sequence and combination, were most effective across a wide range of spreadsheets. It also provided useful information on the size and complexity of operational spreadsheets, as well as the frequency with which certain types of errors occur.

[1]  Joline Morrison,et al.  Using a structured design approach to reduce risks in end user spreadsheet development , 2000, Inf. Manag..

[2]  Roland Mittermeir,et al.  A Spreadsheet Auditing Tool Evaluated in an Industrial Context , 2008, ArXiv.

[3]  Ralph H. Sprague,et al.  Hitting the wall: errors in developing and code inspecting a 'simple' spreadsheet model , 1998, Decis. Support Syst..

[4]  Raymond J. Butler.  Risk Assessment For Spreadsheet Developments: Choosing Which Models to Audit , 2008, ArXiv.

[5]  J.Steve Davis.  Tools for spreadsheet auditing , 1996, Int. J. Hum. Comput. Stud..

[6]  Ian Sommerville,et al.  Software Engineering (7th Edition) , 2004 .

[7]  Stephen G. Powell,et al.  Errors in Operational Spreadsheets , 2009, J. Organ. End User Comput..

[8]  Thompson S. H. Teo,et al.  Effects of error factors and prior incremental practice on spreadsheet error detection: an experimental study , 2001 .

[9]  H. C. Chan,et al.  Strategies and visualization tools for enhancing user auditing of spreadsheet models , 2000, Inf. Softw. Technol..

[10]  Malcolm King,et al.  Spreadsheet Modelling Abuse: An Opportunity for OR? , 1993 .

[11]  Dennis F. Galletta,et al.  An empirical study of spreadsheet error-finding performance , 1993 .

[12]  Raymond R. Panko,et al.  What we know about spreadsheet errors , 1998 .

[13]  Mark G. Simkin,et al.  Factors Affecting the Ability to Detect Spreadsheet Errors , 2006 .

[14]  S. E. Kruck,et al.  Testing spreadsheet accuracy theory , 2006, Inf. Softw. Technol..

[15]  Stephen G. Powell,et al.  A critical review of the literature on spreadsheet errors , 2008, Decis. Support Syst..

[16]  Dennis F. Galletta,et al.  Spreadsheet Presentation and Error Detection: An Experimental Study , 1997, J. Manag. Inf. Syst..

[17]  Veda C. Storey,et al.  The use of spreadsheets in organizations: Determinants and consequences , 1996, Inf. Manag..

[18]  Raymond J. Butler,et al.  Is this spreadsheet a tax evader? How HM Customs and Excise test spreadsheet applications , 2000, Proceedings of the 33rd Annual Hawaii International Conference on System Sciences.

[19]  Raymond R. Panko,et al.  Applying Code Inspection to Spreadsheet Testing , 1999, J. Manag. Inf. Syst..