• Corpus ID: 28392655

Spreadsheet Errors: What We Know. What We Think We Can Do

  title={Spreadsheet Errors: What We Know. What We Think We Can Do},
  author={Raymond R. Panko},
  • R. Panko
  • Published 23 February 2008
  • Business
  • ArXiv
Fifteen years of research studies have concluded unanimously that spreadsheet errors are both common and non-trivial. Now w e must seek ways to reduce spreadsheet errors. Several approaches have been suggested, some of which are promising and others, while appealing because they are easy to do, are not likely to be effective. To date, only one technique, cell-by-cell code inspection, has been demonstrated to be effective. We need to conduct further r esearch to determine the degree to which… 

Tables from this paper

Training Gamble leads to Corporate Grumble?
To date, only one technique, cell-by-cell code inspection, has been demonstrated to be effective, and further research is needed to determine the degree to which other techniques can reduce spreadsheet errors.
What we understand is what we get: Assessment in Spreadsheets
This paper evaluates the (comprehension) coverage of SACHS on an Excel-based financial controlling system via a "Wizard-of-Oz" experiment, and shows that SAC HS adds significant value, but systematically misses important classes of explanations.
Spreadsheet Auditing Software
This paper documents and tests office software tools designed to assist in the audit of spreadsheets to identify the success of software tools in detecting different types of errors, to identify how the software tools assist the auditor and to determine the usefulness of the tools.
Auditing spreadsheets: With or without a tool?
The results of these interviews indicate that spreadsheet tools support a more effective and efficient audit of spreadsheets; the visualization feature in particular is mentioned by the auditors as being highly supportive for their audit task, whereas the risk feature was deemed of lesser value.
Spreadsheet Programming
How spreadsheet programs are actually functional programs is discussed, followed by concepts in spreadsheet programming, and an overview of research effort that seeks to rectify this problem.
UCheck: A spreadsheet type checker for end users
Do Spreadsheet Errors Lead to Bad Decisions: Perspectives of Executives and Senior Managers
Executives and senior managers / analysts in the private, public, and non-profit sectors interviewed about their experiences with spreadsheet quality control and with errors affecting decision making believed spreadsheet errors were a significant problem and that more formal spreadsheetquality control could be beneficial.
Smelling Faults in Spreadsheets
A technique to automatically pinpoint potential faults in spreadsheets is proposed, which combines a catalog of spreadsheet smells that provide a first indication of a potential fault, with a generic spectrum-based fault localization strategy in order to improve on these initial results.
Sharing reasoning about faults in spreadsheets: An empirical study
By evaluating the visual feedback from each fault localization system, light is shed on where these different forms of reasoning and combinations of them complement - and contradict - one another, and which heuristics can be used to generate the best advice from a combination of these systems.
Spreadsheet Error Categorization and Audit Documentation
Background Studies suggest that spreadsheet development and usage is error-prone and spreadsheet errors are “common and non-trivial” (Panko 2000). Overviews published by Kruck (2006) and Panko


Quantitative and qualitative errors in spreadsheet development
It is shown that spreadsheet errors can be difficult to detect during "what-if" analysis (i.e. when design parameters are changed) when the spreadsheets are not properly designed, and that most students do not take due care in designing their spreadsheets.
Two corpuses of spreadsheet errors
  • R. Panko
  • Education
    Proceedings of the 33rd Annual Hawaii International Conference on System Sciences
  • 2000
This paper presents two corpora of errors seen in spreadsheet experiments, hoping these corpora will help assess the claims of spreadsheet reduction approaches and should guide theory creation and testing.
Spreadsheet Presentation and Error Detection: An Experimental Study
The pervasiveness and impact of electronic spreadsheets have generated serious concerns about their integrity and validity when used in significant decision-making settings. Previous studies have
An experimental study of people creating spreadsheets
It was found that experienced spreadsheet users spend a large percentage of their time using the cursor keys, primarily for the purpose of moving the cursor around the spreadsheet.
Twinkling Lights and Nested Loops: Distributed Problem Solving and Spreadsheet Development
Spreadsheet Modelling Abuse: An Opportunity for OR?
An investigation was conducted into the spreadsheet practices in ten firms, with an emphasis on the process of building spreadsheet models, and showed that spreadsheet models were usually built in an informal, iterative manner, by people from all organizational levels.
The Relationship of Application Risks to Application Controls: A Study of Microcomputer-based Spreadsheet Applications
The most serious risks occur, however, when the outputs of user-developed systems are invalid and when these data are used to make management decisions with financial impact on the business.
Spreadsheet analysis and design
Several different contexts for the development of spreadsheet models are discussed and structured design techniques for these models are presented.