• Corpus ID: 18233918

Reducing Overconfidence in Spreadsheet Development

@article{Panko2008ReducingOI,
  title={Reducing Overconfidence in Spreadsheet Development},
  author={Raymond R. Panko},
  journal={ArXiv},
  year={2008},
  volume={abs/0804.0941}
}
  • R. Panko
  • Published 6 April 2008
  • Economics
  • ArXiv
Despite strong evidence of widespread errors, spreadsheet developers rarely subject their spreadsheets to post-development testing to reduce errors. This may be because spreadsheet developers are overconfident in the accuracy of their spreadsheets. This conjecture is plausible because overconfidence is present in a wide variety of human cognitive domains, even among experts. This paper describes two experiments in overconfidence in spreadsheet development. The first is a pilot study to… 
From Good Practices to Effective Policies for Preventing Errors in Spreadsheets
TLDR
An expert-based, retrospective approach to the identification of good practices for spreadsheets is proposed, based on an evaluation loop that cross-validates the findings of human domain experts against rules implemented in a semi-automated spreadsheet workbench, taking into account the context in which the spreadsheets are used.
The Reification of an Incorrect and Inappropriate Spreadsheet Model
TLDR
A case study is described through which it was able to observe at close hand the reification of a demonstrably incorrect and inappropriate spreadsheet model within a small non profit organisation.
How do Range Names Hinder Novice Spreadsheet Debugging Performance?
TLDR
Range names are investigated in a more structured and controlled manner the effect they have on the debugging performance of novice spreadsheet users.
Spreadsheets and the Financial Collapse
TLDR
There is a link between the use of spreadsheets and the recent collapse of the global financial system, and governments and regulating authorities are provided with some simple recommendations to reduce the risks of continued overdependence on unreliable spreadsheets.
Introducing Morphit, a new type of spreadsheet technology
TLDR
A new type of spreadsheet which mitigates the errors caused by incorrect range referencing in formulae, composed of structured worksheets called tables which contain a hierarchical organization of fields.
Automating Spreadsheet Discovery & Risk Assessment
TLDR
This paper proposes an automated approach to the initial stages of the spreadsheet management lifecycle - discovery, inventory and risk assessment - and shows how by leveraging technology, these phases become a sustainable business process.
An approach for the automated risk assessment of structural differences between spreadsheets (DiffXL)
TLDR
An approach to manage and quantify the risks associated with changes made to spreadsheets and suggests a technique by which a risk analysis can be achieved in an automated environment is outlined.
Effect of Range Naming Conventions on Reliability and Development Time for Simple Spreadsheet Formulas
TLDR
It is found that the choice of naming convention can have a significant impact on novice and intermediate users' performance in formula development, with less structured naming conventions resulting in poorer performance by users.
Investigating Effects of Common Spreadsheet Design Practices on Correctness and Maintainability
TLDR
Analysis of the obtained spreadsheets indicates that the correctness of "bottom-line" results is not affected by the observance of the three Best Practices, however, initially correct spreadsheets with high observances of these Best Practices tend to be the ones whose later modifications yield the most correct results.
The Importance and Criticality of Spreadsheets in the City of London
TLDR
The author suggests that the City of London is presently exposed to significant reputational risk through the continued uncontrolled use of critical spreadsheets in the financial markets and elsewhere.
...
...

References

SHOWING 1-10 OF 52 REFERENCES
An experimental study of people creating spreadsheets
TLDR
It was found that experienced spreadsheet users spend a large percentage of their time using the cursor keys, primarily for the purpose of moving the cursor around the spreadsheet.
Spreadsheet investment, criticality, and control
  • G. Gable, C. Yap, M. Eng
  • Business, Economics
    Proceedings of the Twenty-Fourth Annual Hawaii International Conference on System Sciences
  • 1991
TLDR
Investment in spreadsheet applications in a medium-sized contract construction company in Singapore is a case study of investment in, criticality of, and control over spreadsheet applications, and little control is exercised at either the organizational or individual employee level.
The use of spreadsheets in organizations: Determinants and consequences
Creating, comprehending and explaining spreadsheets: a cognitive interpretation of what discretionary users think of the spreadsheet model
TLDR
The strengths of the spreadsheet model allow quick gratification of immediate needs, while the weaknesses are such as make subsequent debugging and interpretation difficult, suggesting a situated view of spreadsheet usage in which present needs outweigh future needs.
Spreadsheet Modelling Abuse: An Opportunity for OR?
TLDR
An investigation was conducted into the spreadsheet practices in ten firms, with an emphasis on the process of building spreadsheet models, and showed that spreadsheet models were usually built in an informal, iterative manner, by people from all organizational levels.
The Relationship of Application Risks to Application Controls: A Study of Microcomputer-based Spreadsheet Applications
TLDR
The most serious risks occur, however, when the outputs of user-developed systems are invalid and when these data are used to make management decisions with financial impact on the business.
A comparison of strategies for reducing interval overconfidence in group judgments
The present experiments examined several strategies designed to reduce interval overconfidence in group judgments. Results consistently indicated that 3-4-person nominal groups (whose members made
A risk and control-oriented study of the practices of spreadsheet application developers
  • M. Hall
  • Computer Science
    Proceedings of HICSS-29: 29th Hawaii International Conference on System Sciences
  • 1996
TLDR
The significance to the management of end-user computing of tolerating a high level of risk is discussed and the need for an end- user spreadsheet control model is established.
...
...