Share This Author
Classification of Spreadsheet Errors
A framework for a systematic classification of spreadsheet errors is described, aimed at facilitating analysis and comprehension of the different types of spreadsheeterrors.
Quality control in spreadsheets: a software engineering-based approach to spreadsheet development
- Kamalasen Rajalingham, David R. Chadwick, B. Knight, D. Edwards
- Computer ScienceProceedings of the 33rd Annual Hawaii…
- 4 January 2000
The principles and techniques of tree-based formula representation, unique definition of spreadsheet elements, and separation of data and operations are among the main features explored.
Quality Control in Spreadsheets: A Visual Approach using Color Codings to Reduce Errors in Formulae
The framework for spreadsheet quality control is mainly aimed at addressing the widespread problem of errors in spreadsheet formulae, and two approaches are considered herein.
Does an awareness of differing types of spreadsheet errors aid end-users in identifying spreadsheets errors?
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.
Stop that Subversive Spreadsheet!
- David R. Chadwick
- 16 December 2007
This paper documents the formation of the European Spreadsheet Risks Interest Group (EuSpRIG www.eusprig.org) and outlines some of the research undertaken and reported upon by interested parties in…
A Structured Methodology for Spreadsheet Modelling
A methodology for structured software development is proposed, which is based on structured analysis of data, represented as Jackson diagrams, and it is shown that this analysis allows a straightforward modularisation, and that individual modules may be represented with indentation in the block-structured form of structured programs.
Integrity Control of Spreadsheets: Organisation & Tools
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.
Information Integrity in End-User Systems
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’.
Efficient Methods for Checking Integrity: An Integrated Spreadsheet Engineering Methodology (ISEM)
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).
Teaching spreadsheet development using peer audit and self-audit methods for reducing error
A teaching approach has been devised which aids students to reduce their likelihood of making common errors during development by educating students in a set of structured, transferable skills for spreadsheet error-checking which are useful for increasing error-awareness in the classroom and for reducing business risk in the workplace.