Revising the Panko-Halverson taxonomy of spreadsheet errors

Error taxonomies are useful because different types of errors have different commission and detection rates and because error mitigation techniques often are only useful for some types of errors. In the early 1990s, Panko and Halverson developed a spreadsheet error taxonomy. This paper updates that taxonomy to reflect human error research more fully. The taxonomy focuses on quantitative errors during development and testing but notes that qualitative errors are very important and that errors occur in all stages of the system development life cycle.

[1]  Kevin McDaid,et al.  An Empirical Study of End-User Behaviour in Spreadsheet Error Detection & Correction , 2008, ArXiv.

[2]  Hayes.  identifying the organization of wi iiing processes , 1980 .

[3]  Graham Allison,et al.  Essence of Decision: Explaining the Cuban Missile Crisis , 1972 .

[4]  Raymond R. Panko.  End user computing: management applications and technology , 1988 .

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

[6]  Brian Knight,et al.  Classification of Spreadsheet Errors , 2008, ArXiv.

[7]  J. Shaoul.  Human Error , 1973, Nature.

[8]  Francis JAMBON,et al.  Taxonomy for Human Error and System Fault Recovery from the Engineering Perspective , 1998 .

[9]  O. Holsti,et al.  Essence of Decision: Explaining the Cuban Missile Crisis , 1972 .

[10]  Louise Pryor,et al.  Correctness is not enough , 2008, ArXiv.

[11]  Stephen G. Powell,et al.  An auditing protocol for spreadsheet models , 2008, Inf. Manag..

[12]  David Ball,et al.  Categorisation of Spreadsheet Use within Organisations, Incorporating Risk: A Progress Report , 2008, ArXiv.

[13]  Grenville J. Croll.  The Importance and Criticality of Spreadsheets in the City of London , 2007, ArXiv.

[14]  Boris Beizer,et al.  Software testing techniques (2. ed.) , 1990 .

[15]  D. Gentner.  Expertise in Typewriting. , 1984 .

[16]  J. Rasmussen,et al.  Mental procedures in real-life tasks: a case study of electronic trouble shooting. , 1974, Ergonomics.

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

[18]  Jens Rasmussen,et al.  Skills, rules, and knowledge; signals, signs, and symbols, and other distinctions in human performance models , 1983, IEEE Transactions on Systems, Man, and Cybernetics.

[19]  Thomas A. Grossman,et al.  Research Strategy and Scoping Survey on Spreadsheet Practices , 2008, ArXiv.

[20]  Raymond R. Panko,et al.  An Experiment In Collaborative Spreadsheet Development , 2001, J. Assoc. Inf. Syst..

[21]  A. Edmondson.  Learning from Mistakes is Easier Said Than Done: Group and Organizational Influences on the Detection and Correction of Human Error , 1996 .

[22]  Boris Beizer,et al.  Software Testing Techniques , 1983 .

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

[24]  D. Norman.  Categorization of action slips. , 1981 .

[25]  John W. Senders,et al.  Human Error: Cause, Prediction, and Reduction , 1991 .

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

[27]  Raymond R. Panko,et al.  Spreadsheets on trial: a survey of research on spreadsheet risks , 1996, Proceedings of HICSS-29: 29th Hawaii International Conference on System Sciences.

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

[29]  Stephen G. Powell,et al.  Impact of errors in operational spreadsheets , 2009, Decis. Support Syst..

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

[31]  Capers Jones,et al.  Programming Productivity , 1986 .

[32]  Carl Martin Allwood,et al.  Error Detection Processes in Statistical Problem Solving , 1984, Cogn. Sci..

[33]  Michael Fagan.  Design and Code Inspections to Reduce Errors in Program Development , 1976, IBM Syst. J..

[34]  Raymond R. Panko,et al.  Two Experiments in Reducing Overconfidence in Spreadsheet Development , 2007, J. Organ. End User Comput..

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

[36]  Linda Flower,et al.  The Dynamics of Composing : Making Plans and Juggling Constraints , 1980 .

[37]  Margaret Tan,et al.  Spreadsheet development and ‘what-if’ analysis: quantitative versus qualitative errors , 1999 .

[38]  Herbert Solomon,et al.  Two models of group behavior in the solution of eureka-type problems , 1955 .

[39]  Margaret Tan,et al.  Quantitative and qualitative errors in spreadsheet development , 1997, Proceedings of the Thirtieth Hawaii International Conference on System Sciences.

[40]  Brian Knight,et al.  Quality control in spreadsheets: a software engineering-based approach to spreadsheet development , 2000, Proceedings of the 33rd Annual Hawaii International Conference on System Sciences.

[41]  Raymond R. Panko,et al.  Are Two Heads Better than One? (At Reducing Errors in Spreadsheet Modeling). , 1997 .