• Corpus ID: 18564799

Classification of Spreadsheet Errors

@article{Rajalingham2008ClassificationOS,
  title={Classification of Spreadsheet Errors},
  author={Kamalasen Rajalingham and David R. Chadwick and Brian Knight},
  journal={ArXiv},
  year={2008},
  volume={abs/0805.4224}
}
This paper describes a framework for a systematic classification of spreadsheet errors. This classification or taxonomy of errors is aimed at facilitating analysis and comprehension of the different types of spreadsheet errors. The taxonomy is an outcome of an investigation of the widespread problem of spreadsheet errors and an analysis of specific types of these errors. This paper contains a description of the various elements and categories of the classification and is supported by… 

Figures from this paper

In Search of a Taxonomy for Classifying Qualitative Spreadsheet Errors
TLDR
A taxonomy for categorizing qualitative errors in spreadsheet models that offers a framework for evaluating the readiness of a spreadsheet model before it is released for use by others in the organization is proposed.
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.
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
A critical review of the literature on spreadsheet errors
Comprehensive review for common types of errors using spreadsheets
TLDR
This research work is a comprehensive review that describes and classifies approaches on finding and fixing errors in spreadsheet in terms of definition, how they work, and kinds of errors they can find in spreadsheets.
Spreadsheet Auditing Software
TLDR
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.
An Evaluation of a Structured Spreadsheet Development Methodology
TLDR
An empirical evaluation of the quality of a structured methodology for the development of spreadsheet models, proposed in numerous previous papers by Rajalingham K, Knight B and Chadwick D et al, and an improved version of their methodology, supported by appropriate examples are presented.
Categorisation of Spreadsheet Use within Organisations, Incorporating Risk: A Progress Report
TLDR
The authors present and analyse three proposed models for categorisation of spreadsheet use and the level of risks involved and the models are analysed in the light of current knowledge and the general risks associated with organisations.
Towards a Catalog of Spreadsheet Smells
TLDR
This work tries to identify spreadsheet smells, a concept adapted from software, which consists of a surface indication that usually corresponds to a deeper problem.
...
...

References

SHOWING 1-10 OF 15 REFERENCES
Integrity Control of Spreadsheets: Organisation & Tools
TLDR
A new approach to the provision of a software engineering discipline for the spreadsheet life-cycle: from requirements, to design, implementation and subsequent maintenance is described, which addresses the widespread problem of spreadsheet errors.
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.
Efficient Methods for Checking Integrity: An Integrated Spreadsheet Engineering Methodology (ISEM)
TLDR
The proposed methodology is mainly based on the classical systems development life cycle and addresses the widespread problem of spreadsheet errors and is an extension to published work by Chadwick et al (1997), Rajalingham & Chadwick (1998) and Rajalingam et al(1999).
Information Integrity in End-User Systems
TLDR
Many errors occurring in end-user applications such as spreadsheets that are not developed under formal system development guidelines are due to an education process that concentrates on teaching ‘how to do things correctly’ but ignores ‘ how to avoid doing things incorrectly’.
Spreadsheet Modelling Best Practice, Accountants Digest
  • Spreadsheet Modelling Best Practice, Accountants Digest
  • 1991
An Integrated Spreadsheet Engineering Methodology
  • (3) Encyclopaedia Britannica Online Proceedings of the Third Annual IFIP TC-11 Working Group 11.5 Working Conference on Integrity and Internal Control in Information Systems
  • 1999
Executive Summary: Financial Model Review Survey
  • KPMG Management Consulting
  • 1997
Integrity Control of Spreadsheet: Organisation & Tools, Proceedings of the Second Annual IFIP TC- 11 Working Group 11.5
  • Working Conference on Integrity and Internal Control in Information Systems, Virginia,
  • 1998
Spreadsheet Modelling Best Practice, Accountants
  • 1991
...
...