• Corpus ID: 28573513

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

@article{Shubbak2016DevelopmentAE,
  title={Development and Experimentation of a Software Tool for Identifying High Risk Spreadsheets for Auditing},
  author={Mahmood H. Shubbak and Simon Thorne},
  journal={ArXiv},
  year={2016},
  volume={abs/1602.05231}
}
Conference paper published in Proceedings of the European Spreadsheets Risks Interest Group Conference on "Spreadsheet Risk Management" 
4 Citations
Mitigating Spreadsheet Model Risk with Python Open Source Infrastructure
TLDR
This paper lays ground work for spreadsheet modelling professionals to develop reproducible audit tools using freely available, open source packages built with the Python programming language, enabling stakeholders to develop clearly defined model "oracles" with which to test and audit spreadsheet calculations against.
A Conceptual Model for Measuring the Complexity of Spreadsheets
TLDR
A conceptual model integrating all aspects which are identified by related literature as potential drivers to spreadsheet complexity is proposed, which forms the foundation for a structured definition of complexity metrics, and thus enhances the reproducibility of their results.
Exploring Spreadsheet Use and Practices in a Technologically Constrained Setting
TLDR
Findings indicate that the proliferation of spreadsheets in the organization has provided an enabling environment for business automation and there is ample room for improvement in many areas such as implementation of comprehensive policies and regulations governing spreadsheet development processes and adoption.

References

SHOWING 1-10 OF 75 REFERENCES
Recommended Practices for Spreadsheet Testing
TLDR
This paper presents the authors recommended practices for spreadsheet testing, and logic inspection appears to be feasible for spreadsheet developers to do and safe and effective for module testing.
Controlling End User Computing Applications - a case study
TLDR
Several workstreams were employed in order to bring about a cultural change within the bank towards the use of spreadsheets and other end-user tools, covering policy development, awareness and skills training, inventory monitoring, user licensing, key risk metrics and mitigation approaches.
A Paradigm for Spreadsheet Engineering Methodologies
TLDR
This paradigm provides a framework for evaluation, comparison, and selection of methodologies, and a list of essential elements for developers or codifiers of new methodologies.
Spreadsheet good practice: is there any such thing?
TLDR
The author urges that EuSpRIG does not succumb to internal or external pressures to champion a particular set of "best practices", because no such set is optimal in all spreadsheet applications.
Documenting Spreadsheets
TLDR
This paper discusses spreadsheets documentation and new means to achieve this end by using Excel’s built-in “Comment” function, which will greatly facilitate spreadsheet change control, risk management and auditing.
The Misuse of Spreadsheets in the Nuclear Fuel Industry: The Falsification of Safety Critical Data Using Spreadsheets at British Nuclear Fuels Limited (BNFL)
  • Simon Thorne
  • Environmental Science
    J. Organ. End User Comput.
  • 2013
TLDR
The production of MOX pellets at the Sellafield site, the falsification of data and the report commissioned by HM Nuclear Inspectorate are examined.
Research Methods for Business Students (5th edn)
TLDR
" " I've got my data; what do I write first?" ΠK then, open this book to read: * Regular checklists and ...
The Misuse of Spreadsheets in the Nuclear Fuel Industry: The Falsification of Safety Critical Nuclear Fuel Data Using Spreadsheets at British Nuclear Fuels Limited (BNFL)
  • Simon Thorne
  • Environmental Science
    2012 45th Hawaii International Conference on System Sciences
  • 2012
TLDR
The production of MOX pellets at the Sellafield site, the falsification of data and the report commissioned by HM Nuclear Inspectorate are examined.
A Survey of MBA Spreadsheet Users by
TLDR
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.
Ensuring Spreadsheet Integrity with Model Master
TLDR
The Model Master (MM) language for describing spreadsheets, and tools for converting MM programs to and from spreadsheet, which makes possible a new style of development, in which spreadsheets are generated from textual specifications.
...
...