• Corpus ID: 35421378

The Role of Spreadsheets in the Allied Irish Bank / Allfirst Currency Trading Fraud

@article{Butler2009TheRO,
  title={The Role of Spreadsheets in the Allied Irish Bank / Allfirst Currency Trading Fraud},
  author={Raymond J. Butler},
  journal={ArXiv},
  year={2009},
  volume={abs/0910.2048}
}
This brief paper outlines how spreadsheets were used as one of the vehicles for John Rusnak's fraud and the revenue control lessons this case gives us. 
Qtier-Rapor: Managing Spreadsheet Systems & Improving Corporate Performance, Compliance and Governance
TLDR
This paper is an anatomy of the real-life issues of the commercial use of spreadsheets in business, and demonstrates how Qtier-Rapor has been used to instil best practice in the use of integrated commercial spreadsheet systems.
Spreadsheet Risk Management in Organisations
TLDR
Findings support previous findings of Panko (1998), that errors occur frequently in spreadsheets and that there is little or unenforced controls employed, however this research finds that attitudes are changing with regard to spreadsheet risk.
THE GOVERNANCE OF RISK ARISING FROM THE USE OF SPREADSHEETS IN ORGANISATIONS
The key to maximising the effectiveness of spreadsheet models for critical decision making is appropriate risk governance. Those responsible for governance need, at a macro level, to identify the
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.
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.
Mitigating Spreadsheet Risk in Complex Multi-Dimensional Models in Excel
TLDR
The following solution is designed to mitigate spreadsheet risk for a set of problems commonly addressed in a spreadsheet defined as "complex multi-dimensional models".
A Comparison of Low-Code and Spreadsheet based Calculation Tools within Accountancy
Low-Code Development Platforms (LDCPs, sometimes also called PaaS for Platforms as a Service) are cloud services or products that are used for application development. They avoid programming and
Introducing Morphit, a new type of spreadsheet technology
TLDR
A new type of spreadsheet which mitigates the errors caused by incorrect range referencing in formulae, composed of structured worksheets called tables which contain a hierarchical organization of fields.
Asheetoxy: A Taxonomy for Classifying Negative Spreadsheet-related Phenomena
TLDR
Asheetoxy, a simple and phenomenon-oriented taxonomy that avoids the problematic term error altogether is proposed, and an initial study indicates that even non-spreadsheet researchers similarly classify real-world spreadsheet phenomena using Asheetoxy.
How do you know your spreadsheet is right?
TLDR
This is the most fundamental level of your work, and the most creative moment in the entire existence of your spreadsheet, so think before you write.
...
...

References

SHOWING 1-7 OF 7 REFERENCES
Stop that Subversive Spreadsheet!
This paper documents the formation of the European Spreadsheet Risks Interest Group (EuSpRIG www.eusprig.org) and outlines some of the research undertaken and reported upon by interested parties in
A Typical Model Audit Approach: Spreadsheet Audit Methodologies in the City of London
TLDR
It is noteworthy that in the United Kingdom, the management of spreadsheet error is almost unheard of outside of the City of London despite the commercial ubiquity of the spreadsheet.
Risk Assessment For Spreadsheet Developments: Choosing Which Models to Audit
TLDR
Risk assessment based on the "SpACE" audit methodology used by H M Customs & Excise's tax inspectors is described, which allows the auditor to target resources on the spreadsheets posing the highest risk of error, and justify the deployment of those resources to managers and clients.
Detecting Errors in Spreadsheets
TLDR
The paper presents two complementary strategies for identifying errors in spreadsheet programs, grounded on the assumption that spreadsheets are software, albeit of a different nature than conventional procedural software.
Spreadsheet Auditing
  • Proc. European Spreadsheet Risks Int. Grp
  • 2001
Report to the Boards of Allied Irish Banks Allfirst Financial Inc. and Allfirst Bank Concerning Currency Trading Losses, Promontory Financial Group And Wachtell
  • Allied Irish Banks plc http://www.aibgroup.com (Follow the links to Investor Relations
  • 2002
EuSpRIG) 2000 51-63 ISBN:1 86166 158 4
  • European Spreadsheet Risks Int. Grp