Spreadsheet bibliography

Title Spreadsheet accuracy theory
Authors Susan E. Kruck & Steven D. Sheetz
Year 2001
Type Article
Publication Journal of Information Systems Education
Series Volume 12, Number 2, pages 93-106
Abstract

Electronic spreadsheets have made a major contribution to financial analysis and problem solving processes. Decisions made using these tools often involve substantive consequences for the organizations.

However, academic literature reveals that experienced professionals and students make many errors when developing spreadsheets. Practitioners recognize the importance of accuracy and have published many techniques they use for improving the accuracy of their spreadsheets.

Systematic evaluation of this literature provides a basis for understanding practitioners' perceptions of how and why errors occur in spreadsheets and is also valuable source from which to identify a theory of spreadsheet accuracy and capture the knowledge of experienced spreadsheet developers.

The analysis of this literature suggests three categories of issues spreadsheet developers must address to create more accurate spreadsheets including:

  • Planning and design.
  • Formula complexity.
  • Testing/debugging.

Spreadsheet accuracy theory explains and predicts how changes in development processes can be expected to impact spreadsheet accuracy.

Full version Available
Sample
Spreadsheet error reduction model
Spreadsheet error reduction model

The spreadsheet accuracy theory's constructs and propositions are presented graphically in this figure.

The design/planning and testing/debugging constructs have positive relationships with the spreadsheet accuracy construct, while the formula complexity construct has an inverse relationship with spreadsheet accuracy.