• English
    • Welsh
  • English 
    • English
    • Welsh
  • Login
Search DSpace:
  • Home
  • Research at Cardiff Met
  • Library Services
  • Contact Us
View item 
  • DSpace home
  • Cardiff School of Technologies
  • School of Technologies Research
  • View item
  • DSpace home
  • Cardiff School of Technologies
  • School of Technologies Research
  • View item
JavaScript is disabled for your browser. Some features of this site may not work without it.

Development and Experimentation of a Software Tool for Identifying High Risk Spreadsheets for Auditing

Thumbnail
View/open
Author's post-print (1002.Kb)
Author
Thorne, Simon
Shubbak, Mahmood
Date
2016-01-01
Acceptance date
2015-07-01
Type
Conference paper
Publisher
European Spreadsheets Risks Interest Group
Metadata
Show full item record
Abstract
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.
Journal/conference proceeding
European Spreadsheets Risks Interest Group;
Citation
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
URI
http://hdl.handle.net/10369/9478
Description
Conference paper published in Proceedings of the European Spreadsheets Risks Interest Group Conference on "Spreadsheet Risk Management"
Rights
http://www.rioxx.net/licenses/all-rights-reserved
Collections
  • School of Technologies Research [166]

Related items

Showing items related by title, author, subject and abstract.

  • Thumbnail

    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 ...
  • Thumbnail

    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 ...
  • Thumbnail

    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, ...

Browse

DSpace at Cardiff MetCommunities & CollectionsBy issue dateAuthorsTitlesSubjectsThis collectionBy issue dateAuthorsTitlesSubjects

My Account

Login

Statistics

Most Popular ItemsStatistics by CountryMost Popular Authors

DSpace software copyright © 2002-2015  DuraSpace
Contact us | Send feedback | Administrator