A Review of Spreadsheet Error Reduction Techniques

@article{Thorne2009ARO,
  title={A Review of Spreadsheet Error Reduction Techniques},
  author={Simon Thorne},
  journal={Commun. Assoc. Inf. Syst.},
  year={2009},
  volume={25},
  pages={34}
}
  • Simon Thorne
  • Published 2009
  • Economics
  • Commun. Assoc. Inf. Syst.
Full text not available from this repository.The definitive version is available at http://aisel.aisnet.org/cais/vol25/iss1/34/ 

Figures from this paper

Reducing Error in Spreadsheets: Example Driven Modeling Versus Traditional Programming

TLDR
Experimental data supporting an alternative approach to developing decision support spreadsheets using a Programming by Demonstration paradigm is presented and benefits and limitations this method offers are described through statistical analysis of the experimental results.

A Case Study of Spreadsheet Use within the Finance and Academic Registry units within a Higher Education Institution

TLDR
The results show a large volume of spreadsheets being created and used, that the profile of spreadsheet developers is typical of other studies of spreadsheet use and the need for the organisation to have clear principles and guidelines for the development of spreadsheet models in the organisation.

Spreadsheets as User Interfaces v5 post-sub-edit

TLDR
Four vignettes related to musicological data demonstrate how spreadsheets can be used as an integral part of interactive processes, for activities from simple data entry, to more complex grouping and linking of datasets, both as fully functional prototypes and as part of a final system.

Spreadsheets as User Interfaces

TLDR
This paper shows how spreadsheets can be used as an integral part of interactive processes, for activities from simple data entry, to more complex grouping and linking of datasets, both as fully functional prototypes and as part of a final system.

Spreadsheet Risk Management in Organisations

TLDR
Findings support previous findings of Panko (1998), that errors occur frequently in spreadsheets and that there is little or unenforced controls employed, however this research finds that attitudes are changing with regard to spreadsheet risk.

References

SHOWING 1-10 OF 53 REFERENCES

Factors Affecting the Ability to Detect Spreadsheet Errors

TLDR
The subject of spreadsheet error detection is examined in detail and an experiment designed to identify those factors influencing the error-detection capabilities of a sample of spreadsheet users is described.

Spreadsheets on trial: a survey of research on spreadsheet risks

  • R. PankoR. 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.

Recommended Practices for Spreadsheet Testing

TLDR
This paper presents the authors recommended practices for spreadsheet testing, and logic inspection appears to be feasible for spreadsheet developers to do and safe and effective for module testing.

Correctness is not enough

TLDR
This paper presents the key criteria for judging a spreadsheet and discusses how those criteria can be achieved.

Principles of program design

TLDR
This book is about programming for data processing applications, and its purpose is to present a coherent method and procedure for designing systems, programs, and components that are transparently simple and self-evidently correct.

A methodology for testing spreadsheets

TLDR
A testing methodology that adapts data flow adequacy criteria and coverage monitoring to the task of testing spreadsheets is presented and it is found that test suites created according to the methodology detected, on average, 81% of the faults in a set of faulty spreadsheets, significantly outperforming randomly generated test suites.

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.

When, why and how to test spreadsheets

TLDR
This paper discusses the testing of spreadsheets in the light of one practitioner’s experience, and considers the concept of software testing and how it differs from reviewing, and describes when it might take place.

What we know about spreadsheet errors

TLDR
Although spreadsheet programs are used for small "scratchpad" applications, they are also used to develop many large applications, and error rates are in line with those in programming and other human cognitive domains.

Spreadsheet Debugging

TLDR
The fault tracing technique proposed uses the dataflow information and cell marks to identify the most influential faulty cell(s) for a given formula cell containing a propagated fault in spreadsheet programs.
...