Spreadsheet use for strategic decision-making: An analysis of spreadsheet use and associated risk.

View/ open
Author
Madahar, Mukul
Date
2011Type
Thesis
Publisher
University of Wales
Metadata
Show full item recordAbstract
Spreadsheets are the most widely used End User Computing (EUC) tool. Errors in spreadsheets are significant and well documented. There is anecdotal evidence that spreadsheets are used at strategic level. The conjunction of the extent of errors and spreadsheet use at a strategic level in organisations raises the risk exposure to organisations.
There are two approaches towards this problem: 'spreadsheet engineering' or 'business problem'. There is extensive research in finding spreadsheet engineering solutions to reduce the errors. This research instead followed a 'business problem' approach. The literature reviewed concerned various subject areas: general Risk Management, EUC and IT Risk Management. The conceptual framework developed suggested an approach to mitigate risks associated with spreadsheet use.
The study followed a pragmatist research philosophy using a combination of qualitative and quantitative methods. This research investigated the significance and extent of spreadsheet problems using a Questionnaire survey conducted with Tuck Business School, USA, along with four secondary studies and a qualitative analysis of an e-discussion by an expert forum of EUSpRIG. This was followed by two qualitative case studies using semi-structured interviews. Resulting from the case studies, a model was developed for categorising spreadsheet use incorporating risk. The categories of use and approach to measure the risk were defined.
This study concludes that spreadsheets are an integral part of the organisations and their strategic decision-making processes. Spreadsheets are a powerful tool and have been a victim of their own success. The answer is not to avoid spreadsheets but to use them more sensibly and carefully as one would do with any other powerful tool. There needs to be formalised control governing their use and development, based on their type of use and extent of risks associated. The model developed helps prioritise spreadsheets based on categories of use incorporating risk associated and suggested strategy for each category.
Collections
Related items
Showing items related by title, author, subject and abstract.
-
A Pilot Study Exploring Spreadsheet Risk in Scientific Research
Thorne, Simon; ALtarawneh, Ghada (2017-01-12)This paper discusses the risks and potential impacts of spreadsheet errors in scientific research data in a Neuroscience research centre in the UK. Spreadsheets usage in neuroscience, or indeed any medical discipline, ... -
An alternative modelling technique for the reduction of error in decision support spreadsheets
Thorne, Simon (Cardiff Metropolitan University, 2008)Spreadsheet applications are currently the most prevalent end user tool in organisations across the world. Surveys on spreadsheet use show spreadsheets are used as decision making tools in a range of organisations from ... -
Development and Experimentation of a Software Tool for Identifying High Risk Spreadsheets for Auditing
Thorne, Simon; Shubbak, Mahmood (European Spreadsheets Risks Interest Group, 2016-01-01)Heavy use of spreadsheets by organisations bears many potential risks such as errors, ambiguity, data loss, duplication, and fraud. In this paper these risks are briefly outlined along with their available mitigation ...