• Corpus ID: 34103840

A Typical Model Audit Approach: Spreadsheet Audit Methodologies in the City of London

@article{Croll2007ATM,
  title={A Typical Model Audit Approach: Spreadsheet Audit Methodologies in the City of London},
  author={G. J. Croll},
  journal={ArXiv},
  year={2007},
  volume={abs/0712.2591}
}
Spreadsheet audit and review procedures are an essential part of almost all City of London financial transactions. Structured processes are used to discover errors in large financial spreadsheets underpinning major transactions of all types. Serious errors are routinely found and are fed back to model development teams generally under conditions of extreme time urgency. Corrected models form the essence of the completed transaction and firms undertaking model audit and review expose themselves… 

Managing Critical Spreadsheets in a Compliant Environment

TLDR
This paper summarises the key issues regarding the establishment and maintenance of control of Business Critical spreadsheets.

Error Estimation in Large Spreadsheets using Bayesian Statistics

TLDR
Early research that has been carried out into the use of Bayesian Statistical methods to estimate the level of error in large spreadsheets during cell be cell examination based on expert knowledge and partial spreadsheet test data are outlined.

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

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.

Embedded Spreadsheet Modelling

TLDR
In larger accounting firms, specialist modellers typically sit in separate teams, but the advantages of embedding a specialist modeller within a Corporate Finance Team are examined.

The Detection of Human Spreadsheet Errors by Humans versus Inspection (Auditing) Software

TLDR
This study attempted to find errors in human-developed spreadsheets to avoid the potential artifacts created by error seeding, and found Excel Error Check and Spreadsheet Professional were almost useless for correctly flagging natural (human) errors.

End User Computing: The Dark Matter (and Dark Energy) of Corporate IT

  • R. PankoD. Port
  • Computer Science
    2012 45th Hawaii International Conference on System Sciences
  • 2012
TLDR
It is time to stop ignoring end user computing in general and spreadsheets in particular and only talk about development, regardless of whether the developer user a 3GL or 4GL.

Excel 2013 Spreadsheet Inquire

TLDR
A free helper add-in is offered that corrects one major short coming of Inquire and is compared in detail with similar products and makes suggestions for how it can be enhanced.

The Cognitive Science of Spreadsheet Errors: Why Thinking is Bad

  • R. Panko
  • Biology
    2013 46th Hawaii International Conference on System Sciences
  • 2013
TLDR
Cognitive science aspects of spreadsheet error commission are looked at, including how the brain hides its inaccuracy from us, leaving us to believe strongly in the correctness of the authors' work despite the presence of errors.

References

SHOWING 1-4 OF 4 REFERENCES

Spreadsheet Engineering: A Research Framework

TLDR
Spreadsheet engineering adapts the lessons of software engineering to spreadsheets, providing eight principles as a framework for organizing spreadsheet programming recommendations to overcome the heterogeneity of spreadsheet users.

Spreadsheet Errors: What We Know. What We Think We Can Do

TLDR
To date, only one technique, cell-by-cell code inspection, has been demonstrated to be effective, and the degree to which other techniques can reduce spreadsheet errors needs to be determined.

Spreadsheet Auditing Software, Proceedings of the Second Symposium of the European Spreadsheet Risks Interest

  • 2001

Proceedings of the Second Symposium of the European Spreadsheet Risks Interest Group

  • Proceedings of the Second Symposium of the European Spreadsheet Risks Interest Group
  • 2001