• Corpus ID: 13111228

A Novel Approach to Formulae Production and Overconfidence Measurement to Reduce Risk in Spreadsheet Modelling

@article{Thorne2008ANA,
  title={A Novel Approach to Formulae Production and Overconfidence Measurement to Reduce Risk in Spreadsheet Modelling},
  author={Simon Thorne and David Ball and Zoe Lawson},
  journal={ArXiv},
  year={2008},
  volume={abs/0803.1754}
}
Research on formulae production in spreadsheets has established the practice as high risk yet unrecognised as such by industry. There are numerous software applications that are designed to audit formulae and find errors. However these are all post creation, designed to catch errors before the spreadsheet is deployed. As a general conclusion from EuSpRIG 2003 conference it was decided that the time has come to attempt novel solutions based on an understanding of human factors. Hence in… 

Figures from this paper

Considering Functional Spreadsheet Operator Usage Suggests the Value of Example Driven Modelling for Decision Support Systems
TLDR
It is concluded that a deeper understanding of the use of operators and the operator's relationship to error would provide fresh insight into the spreadsheet error problem.
Automated model-based spreadsheet debugging
TLDR
Several new algorithmic enhancements of the general MBD approach are combined in this thesis to allow spreadsheet users to debug their spreadsheets and to efficiently find the reason of the observed unexpected output values.
Investigating the Potential of Test-Driven Development for Spreadsheet Engineering
TLDR
Through a pair of case studies it is demonstrated that Test-Driven Development can be applied to the development of spreadsheets and a supporting tool under development by the authors is documented along with proposed research to determine the effectiveness of the methodology and the associated tool.
Concerning the Feasibility of Example-driven Modelling Techniques
TLDR
The main aim was to establish experimentally within an academic environment; the relationship between error and task complexity using a) Traditional spreadsheet modelling, b) example driven techniques.
Test-driven development: can it work for spreadsheets?
TLDR
Through a set of case studies it is demonstrated that Test-Driven Development can be applied to the development of spreadsheets and a supporting tool under development by the authors is documented along with proposed research to determine the effectiveness of the methodology and the associated tool.
Exploring Human Factors in Spreadsheet Development
TLDR
How human factors affect a simplified development cycle and what the potential consequences are are investigated are investigated.

References

SHOWING 1-10 OF 30 REFERENCES
Quantitative and qualitative errors in spreadsheet development
TLDR
It is shown that spreadsheet errors can be difficult to detect during "what-if" analysis (i.e. when design parameters are changed) when the spreadsheets are not properly designed, and that most students do not take due care in designing their spreadsheets.
Is this spreadsheet a tax evader? How HM Customs and Excise test spreadsheet applications
  • Raymond J. Butler
  • Business
    Proceedings of the 33rd Annual Hawaii International Conference on System Sciences
  • 2000
TLDR
The audit experience is briefly summarised, the methodology is described and the results to date of a campaign of spreadsheet testing that started in July 1999 are outlined.
Using a structured design approach to reduce risks in end user spreadsheet development
Spreadsheets on trial: a survey of research on spreadsheet risks
  • R. Panko, R. 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.
Spreadsheet Presentation and Error Detection: An Experimental Study
The pervasiveness and impact of electronic spreadsheets have generated serious concerns about their integrity and validity when used in significant decision-making settings. Previous studies have
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.
Hitting the wall: errors in developing and code inspecting a 'simple' spreadsheet model
The Wall and The Ball: A Study of Domain Referent Spreadsheet Errors
TLDR
The results show that domain referent knowledge influences participants' approaches to spreadsheet creation and spreadsheet usage, and suggests that spreadsheet error making is influenced by domain knowledge and domain perception.
Hitting the wall: errors in developing and debugging a "simple" spreadsheet model
  • R. Panko
  • Computer Science
    Proceedings of HICSS-29: 29th Hawaii International Conference on System Sciences
  • 1996
TLDR
Undergraduate MIS business students developed and debugged a spreadsheet model from a word problem that consisted of a bid to build a wall to address the concern that past spreadsheet experiments may have used problems that were too difficult or that required domain knowledge that subjects did not have.
Organization Designs for the Management of End-User Computing: Re-examining the Contingencies
TLDR
Testing of a previously published contingency model in which two different structural forms are modeled for four states of EUC implementation provides additional evidence for the effectiveness of a more controlled approach to EUC management under a low EUC growth objective at an early stage of implementation.
...
...