Development and Experimentation of a Software Tool for Identifying High Risk Spreadsheets for Auditing
European Spreadsheets Risks Interest Group
MetadataShow full item record
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 methods such as: documentation, centralisation, auditing, and user training. However, because of the large quantities of spreadsheets used in organisations, applying these methods on all spreadsheets is impossible. This fact is considered as a deficiency in these methods, a gap which is addressed in this paper. In this paper a new software tool for managing spreadsheets and identifying the risk levels they include is proposed, developed and tested. As an add-in for Microsoft Excel application, ‘Risk Calculator’ can automatically collect and record spreadsheets properties in an inventory database and assign risk scores based on its importance, use, and complexity. Consequently, auditing processes can be targeted to high risk spreadsheets. Such a method saves time, effort, and money.
European Spreadsheets Risks Interest Group;
Shubbak, M., Thorne, S., (2015), 'Development and Experimentation of a Software Tool for Identifying High Risk Spreadsheets for Auditing', Proceedings of the European Spreadsheets Risks Interest Group Conference on "Spreadsheet Risk Management", ICAEW, London, pp 31-53
Conference paper published in Proceedings of the European Spreadsheets Risks Interest Group Conference on "Spreadsheet Risk Management"
Showing items related by title, author, subject and abstract.
Spreadsheet use for strategic decision-making: An analysis of spreadsheet use and associated risk. Madahar, Mukul (University of Wales, 2011)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 ...
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 ...
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, ...