What we know about spreadsheet errors

@article{Panko1998WhatWK,
  title={What we know about spreadsheet errors},
  author={Raymond R. Panko},
  journal={Journal of Organizational and End User Computing},
  year={1998},
  volume={10},
  pages={15-21}
}
  • R. Panko
  • Published 1 May 1998
  • Education
  • Journal of Organizational and End User Computing
Although spreadsheet programs are used for small "scratchpad" applications, they are also used to develop many large applications. In recent years, we have learned a good deal about the errors that people make when they develop spreadsheets. In general, errors seem to occur in a few percent of all cells, meaning that for large spreadsheets, the issue is how many errors there are, not whether an error exists. These error rates, although troubling, are in line with those in programming and other… 

Tables from this paper

A graphical approach for reducing spreadsheet linking errors
TLDR
A code inspection approach is described that visually represents the structure of a linked spreadsheet and graphically identifies linked cells and their sources and indicates that subjects who used the approach made significantly fewer errors and experienced no decrease in speed of spreadsheet production or satisfaction with the production process.
A User-Centered Approach for Testing Spreadsheets
TLDR
This paper presents an approach for checking spreadsheets on the premises that their developers are not software professionals and takes inherent characteristics of spreadsheets as well as the conceptual models of spreadsheet programmers into account and incorporates ideas from symbolic testing and interval analysis.
Detecting Errors in Spreadsheets
TLDR
The paper presents two complementary strategies for identifying errors in spreadsheet programs, grounded on the assumption that spreadsheets are software, albeit of a different nature than conventional procedural software.
Validating the unit correctness of spreadsheet programs
TLDR
XeLda, the authors' tool for unit checking Excel spreadsheets, is described, which highlights cells if their formulas process values with incorrect units and if derived units clash with unit annotations.
Errors in Operational Spreadsheets: A Review of the State of the Art
TLDR
The existing state of understanding of spreadsheet errors is reviewed, concentrating on two recent studies that suggest that counts of error cells are not sufficient to understand the problem of errors.
Heuristics for the automatic identification of irregularities in spreadsheets
TLDR
It is found that most end users are willing to verify their spreadsheets, but only view have the time and skills to do really systematic testing of spreadsheets.
Spreadsheets are Code: An Overview of Software Engineering Approaches Applied to Spreadsheets
TLDR
A comparison of spreadsheets to software is compared: spreadsheets are similar in terms of applications domains, expressive power and maintainability problems, and what makes spreadsheets successful is reflected upon.
Finding errors in the Enron spreadsheet corpus
  • T. Schmitz, D. Jannach
  • Computer Science
    2016 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)
  • 2016
TLDR
This work proposes a method and tool to identify realworld formula errors within the Enron spreadsheet corpus based on heuristics that help us identify versions of the same spreadsheet and software helps the user identify spreadsheets of which they assume that they contain error corrections.
Analyzing large spreadsheet programs
  • Markus Clermont
  • Computer Science
    10th Working Conference on Reverse Engineering, 2003. WCRE 2003. Proceedings.
  • 2003
TLDR
An approach is introduced that enables the decomposing of large spreadsheets into self contained parts, that are similar to modules in conventional software, and which can be considered orthogonal to semanticclasses, that have been introduced in prior work.
Type inference for spreadsheets
TLDR
A type system and a type inference algorithm are introduced and it is demonstrated how this algorithm and the underlying typing concept can identify programming errors in spreadsheets.
...
...

References

SHOWING 1-10 OF 101 REFERENCES
How to Make Spreadsheets Error-Proof
TLDR
It's possible to make spreadsheets not only virtually error-proof, but easier to use and more understandable, and to exploit the three-dimensional capabilities of today's popular spreadsheets--using multiple worksheets in the same file.
Quantitative and qualitative errors in spreadsheet development
TLDR
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.
An experimental study of people creating spreadsheets
TLDR
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.
Applying Code Inspection to Spreadsheet Testing
  • R. Panko
  • Business
    J. Manag. Inf. Syst.
  • 1999
TLDR
Findings were that subjects were overconfident when inspecting alone, that certain types of errors are especially difficult to detect, and that the benefits of the group phase is greatest for these difficult-to-detect type of errors.
Two corpuses of spreadsheet errors
  • R. Panko
  • Education
    Proceedings of the 33rd Annual Hawaii International Conference on System Sciences
  • 2000
TLDR
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
...
...