• Corpus ID: 2620844

In Search of a Taxonomy for Classifying Qualitative Spreadsheet Errors

@article{Przasnyski2011InSO,
  title={In Search of a Taxonomy for Classifying Qualitative Spreadsheet Errors},
  author={Zbigniew H. Przasnyski and Linda A. Leon and Kala Chand Seal},
  journal={ArXiv},
  year={2011},
  volume={abs/1111.6909}
}
Most organizations use large and complex spreadsheets that are embedded in their mission-critical processes and are used for decision-making purposes. Identification of the various types of errors that can be present in these spreadsheets is, therefore, an important control that organizations can use to govern their spreadsheets. In this paper, we propose a taxonomy for categorizing qualitative errors in spreadsheet models that offers a framework for evaluating the readiness of a spreadsheet… 

Figures and Tables from this paper

Investigating Effects of Common Spreadsheet Design Practices on Correctness and Maintainability
TLDR
Analysis of the obtained spreadsheets indicates that the correctness of "bottom-line" results is not affected by the observance of the three Best Practices, however, initially correct spreadsheets with high observances of these Best Practices tend to be the ones whose later modifications yield the most correct results.
Improvement of Spreadsheet Quality through Reduction of End-User Overconfidence: Case Study
This paper is prompted by and based on earlier research into developers' overconfidence as one of the main causes of spreadsheet errors. Similar to related research, the aim of the paper was to
Introducing Morphit, a new type of spreadsheet technology
TLDR
A new type of spreadsheet which mitigates the errors caused by incorrect range referencing in formulae, composed of structured worksheets called tables which contain a hierarchical organization of fields.
Identify and understand the difficulties of the students in class by analysing their activity in the case of prescribed tasks with the spreadsheet
TLDR
Teachers are provided with indicators to help them take into account the difficulties’ students face when performing tasks prescribed with a computer tool like the spreadsheet to better understand why students learn or not.

References

SHOWING 1-10 OF 23 REFERENCES
Does an awareness of differing types of spreadsheet errors aid end-users in identifying spreadsheets errors?
TLDR
A valid, and simplified, revision of previous spreadsheet error classifications is established and it is shown that spreadsheet error-type awareness significantly improves the user’s ability to identify, the more surreptitious, qualitative error.
Classification of Spreadsheet Errors
TLDR
A framework for a systematic classification of spreadsheet errors is described, aimed at facilitating analysis and comprehension of the different types of spreadsheeterrors.
A critical review of the literature on spreadsheet errors
Spreadsheet Errors and Decision Making: Evidence from Field Interviews
TLDR
Interviewing executives and senior managers/analysts in the private, public, and non-profit sectors about their experiences with spreadsheet errors and quality control procedures found that opinions differ as to whether the consequences of spreadsheet errors are severe.
The impact of training in financial modelling principles on the incidence of spreadsheet errors
TLDR
The findings show that spreadsheet errors and, in particular, spreadsheet design errors are prolific even for a simple domain-free exercise, and support the contention that accounting educators should include a course in spreadsheet design principles and problem-solving techniques as part of an undergraduate accounting program.
Spreadsheets on trial: a survey of research on spreadsheet risks
  • R. Panko, R. Halverson
  • Economics
    Proceedings of HICSS-29: 29th Hawaii International Conference on System Sciences
  • 1996
TLDR
The paper presents a framework for risks in spreadsheeting and organizes selected research findings in terms of this framework.
Modeling Optimization Problems in the Unstructured World of Spreadsheets
Revising the Panko-Halverson taxonomy of spreadsheet errors
Hitting the wall: errors in developing and debugging a "simple" spreadsheet model
  • R. Panko
  • Computer Science
    Proceedings of HICSS-29: 29th Hawaii International Conference on System Sciences
  • 1996
TLDR
Undergraduate MIS business students developed and debugged a spreadsheet model from a word problem that consisted of a bid to build a wall to address the concern that past spreadsheet experiments may have used problems that were too difficult or that required domain knowledge that subjects did not have.
...
...