The Importance and Criticality of Spreadsheets in the City of London
@article{Croll2007TheIA, title={The Importance and Criticality of Spreadsheets in the City of London}, author={G. J. Croll}, journal={ArXiv}, year={2007}, volume={abs/0709.4063} }
Spreadsheets have been with us in their present form for over a quarter of a century. We have become so used to them that we forget that we are using them at all. It may serve us well to stand back for a moment to review where, when and how we use spreadsheets in the financial markets and elsewhere in order to inform research that may guide their future development. In this article I bring together the experiences of a number of senior practitioners who have spent much of their careers working…
74 Citations
Spreadsheets and the Financial Collapse
- EconomicsArXiv
- 2009
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.
Spreadsheet Hell
- EconomicsArXiv
- 2008
This management paper looks at the real world issues faced by practitioners managing spreadsheets through the production phase of their life cycle. It draws on the commercial experience of several…
Error Estimation in Large Spreadsheets using Bayesian Statistics
- BusinessArXiv
- 2009
Early research that has been carried out into the use of Bayesian Statistical methods to estimate the level of error in large spreadsheets during cell be cell examination based on expert knowledge and partial spreadsheet test data are outlined.
Inappropriate Use of Spreadsheets in the Finance Industry
- Economics
- 2013
Spreadsheets are major tools in the finance industry. In order to find out how these tools are used, we examined recently published research papers and interviewed seven experienced bankers. This…
Comparison of Characteristics and Practices amongst Spreadsheet Users with Different Levels of Experience
- BusinessArXiv
- 2008
An internet-based questionnaire on spreadsheet use is administered to a large number of users in several companies and organizations to document how spreadsheets are currently being developed and used in business and indicates that gaps have multiple dimensions.
Towards Evaluating the Quality of a Spreadsheet: The Case of the Analytical Spreadsheet Model
- EconomicsArXiv
- 2011
This work proposes for discussion a framework and terminology for evaluating the quality of analytical spreadsheet models, which categorizes and generalizes the findings of previous work on the more narrow domain of financial spreadsheet models.
A Survey of MBA Spreadsheet Users by
- Computer Science
- 2015
The results of an internet-based questionnaire on spreadsheet use drawn from a large sample of MBA graduates describe current spreadsheet use in organizations, largely confirming the gap that exists between actual practice and best practice.
Spreadsheets and Long Term Corporate Survival
- BusinessArXiv
- 2012
There is a material and statistically significant increase in the long term survival rate of all of these groups of companies compared to the control.
References
SHOWING 1-10 OF 20 REFERENCES
A typical model audit approach
- Economics
- 2003
Spreadsheet audit and review procedures are an essential part of almost all City of London financial transactions. Structured processes are used to discover errors in large financial spreadsheets…
Spreadsheet Assurance by "Control Around" is a Viable Alternative to the Traditional Approach
- BusinessArXiv
- 2008
Not all distinct formulas are audited separately, but the relationship between input data and output data of a spreadsheet is audited through comparison with a shadow model developed in a modelling language.
Reducing Overconfidence in Spreadsheet Development
- EconomicsArXiv
- 2008
Two experiments in overconfidence in spreadsheet development are described, including a pilot study to determine the existence of overconfidence, and a manipulation to reduce overconfidence and errors.
Interpretation as a factor in understanding flawed spreadsheets
- EducationArXiv
- 2008
The problems of mechanical production and the problems of translation of problem to spreadsheet representation are considered.
Spreadsheet Errors: What We Know. What We Think We Can Do
- BusinessArXiv
- 2008
To date, only one technique, cell-by-cell code inspection, has been demonstrated to be effective, and the degree to which other techniques can reduce spreadsheet errors needs to be determined.
Spreadsheet Engineering: A Research Framework
- Computer ScienceArXiv
- 2007
Spreadsheet engineering adapts the lessons of software engineering to spreadsheets, providing eight principles as a framework for organizing spreadsheet programming recommendations to overcome the heterogeneity of spreadsheet users.
Risk, uncertainty and investment decision-making in the upstream oil and gas industry
- Geology, Economics
- 2000
iii
Spreadsheet Errors
- www.wilmott.com, General Forum
- 2005
The City's Importance to the EU economy
- Centre for Economics and Business Research
- 2005
Getting Spreadsheets Under Control – Practical Issues and Ideas
- European Spreadsheet Risks Interest Group, 4th Annual Symposium
- 2003