Spreadsheet Errors and Decision Making: Evidence from Field Interviews

@article{Caulkins2007SpreadsheetEA,
  title={Spreadsheet Errors and Decision Making: Evidence from Field Interviews},
  author={Jonathan P. Caulkins and Erica Layne Morrison and Timothy Weidemann},
  journal={J. Organ. End User Comput.},
  year={2007},
  volume={19},
  pages={1-23}
}
There is consensus in the literature that spreadsheets are both ubiquitous and error-prone, but little direct evidence concerning whether spreadsheet errors frequently lead to bad decision making. [] Key Result Others thought more formal spreadsheet quality control processes could be beneficial.

Tables from this paper

A critical review of the literature on spreadsheet errors

Improving Efficiency in Budgeting – An Interventionist Approach to Spreadsheet Accuracy Testing

TLDR
It is shown that later spreadsheet error in budgeting is already rooted in a poor conceptualization of the budget template, in non-workflow-oriented imputation of data and poor documentation of data requirements, and illustrated how the accuracy of spreadsheets substantially improves by introducing even simplistic VBA.

Impact of errors in operational spreadsheets

Controls over Spreadsheets for Financial Reporting in Practice

TLDR
It is indicated that there are problems in all stages of a spreadsheet’s life cycle and several important areas for future research are suggested.

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.

Accountants’ Perceptions of the Use of Excel Spreadsheet in Financial Reporting: A Survey of Accounts Personnel in Manufacturing Firms

Spreadsheet, a widely accepted critical business application tool with its benefits and unavoidable inadequacies is relied on by many accountants for financial reporting and operational processes

Introducing a Taxonomy for Classifying Qualitative Spreadsheet Errors

TLDR
A taxonomy for categorizing qualitative errors in spreadsheet models is proposed that offers an exploratory framework for evaluating the quality of a spreadsheet model before it is released for use by others in the organization.

Beyond Regulatory Compliance for Spreadsheet Controls: A Tutorial to Assist Practitioners and a Call for Research

TLDR
An analysis of the prior work on error prevention and detection in spreadsheets as it relates to SOX and IT governance frameworks, more generally and suggestions to help IT practitioners in organizations look beyond SOX regulations at governance of end-user developed content are provided.
...

References

SHOWING 1-10 OF 36 REFERENCES

Spreadsheet Accuracy Theory

TLDR
The analysis of academic literature suggests three categories of issues spreadsheet developers must address to create more accurate spreadsheets including: planning and design; formula complexity; and testing/debugging.

The use of spreadsheets in organizations: Determinants and consequences

Bad numbers: coping with flawed decision support

TLDR
A case study is presented in which an experiment in visual support for a sequential decision-making task was tainted by bad numbers, indicating a robust human ability to overcome flawed decision support.

Framework for Cognitive Skill Acquisition and Spreadsheet Training

TLDR
Investigating how several important cognitive skills are affected by formalized spreadsheet training indicates one cognitive skill, logical reasoning, significantly increases after a six-week training period, and the greater the increase in logical reasoning skill, the more effectively the subject developed competent spreadsheet models.

A survey of contingency factors affecting the validation of end-user spreadsheet-based decision support systems

TLDR
The second phase of a 3-phase approach towards devising a practical validation methodology for decision support systems involving a spreadsheet model is described, reporting as it does on a survey that has been undertaken to unearth the contingency factors that influence how the process of validation, employing the validity framework, will be carried out.

Computer assisted decision support systems: their use in strategic decision making

TLDR
The results suggest that computers and computer generated information are used to a great degree by decision makers to enhance their own abilities.

A Spreadsheet Auditing Tool Evaluated in an Industrial Context

TLDR
The evaluated auditing tool offers the auditor a new view on the formula structure of the spreadsheet by grouping similar formulas into equivalence classes, and the auditing approach helps to find irregularities in the geometrical pattern of similar formulas.

Validation of decision-aiding spreadsheets: the influence of contingency factors

TLDR
A methodological framework for validation that takes account of the effect of contingency factors is developed, designed to enable managers, decision-makers, project leaders and other non-OR specialists to identify the extent of validation effort likely to be required to ensure that the spreadsheet models that they build are valid.