Audit and Change Analysis of Spreadsheets

@article{Nash2008AuditAC,
  title={Audit and Change Analysis of Spreadsheets},
  author={John C. Nash and N. Smith and Andy Adler},
  journal={ArXiv},
  year={2008},
  volume={abs/0807.3168}
}
Because spreadsheets have a large and growing importance in real-world work, their contents need to be controlled and validated. Generally spreadsheets have been difficult to verify, since data and executable information are stored together. Spreadsheet applications with multiple authors are especially difficult to verify, since controls over access are difficult to enforce. Facing similar problems, traditional software engineering has developed numerous tools and methodologies to control… 

Figures from this paper

TellTable Spreadsheet Audit: from Technical Possibility to Operating Prototype
TLDR
The results of a pilot implementation of software to generate and analyse an audit trail for a spreadsheet file are described, along with developments in the server infrastructure and availability, extensions to other "Office Suite" files, integration of the audit tool into the server interface, and related developments, licensing and reports.
Evaluating and implementing a collaborative office document system
Beyond Regulatory Compliance for Spreadsheet Controls: A Tutorial to Assist Practitioners and a Call for Research
TLDR
An analysis of the prior work on error prevention and detection in spreadsheets as it relates to SOX and IT governance frameworks, more generally and suggestions to help IT practitioners in organizations look beyond SOX regulations at governance of end-user developed content are provided.
Forensic and Anomaly Detection Using Generalized Audit Software
TLDR
The research result shows that auditors can implement CAATs in GAS (Generalized Audit Software) which is software created specifically for audit purposes, which has features that can easily test management assertions.
Spreadsheets in Statistical Practice—Another Look
TLDR
Improvements in some spreadsheet processors and the possibility of audit trail facilities suggest that the use of a spreadsheet for some statistical data entry and simple analysis tasks may now be acceptable.
Governance of Spreadsheets through Spreadsheet Change Reviews
EuSpRiG 2012 : European Spreadsheet Risk Interest Group (EuSpRIG) annual conference, July 2012

References

SHOWING 1-9 OF 9 REFERENCES
An improved inspection technique
Software reviews are not a new idea. They have been around almost as long as software has. One ofthe most natural ways to check if something is correct is to look at it. Babbage and von Neumann
Systematic object-oriented inspection - an empirical study
TLDR
The analysis shows that using the systematic technique does not significantly improve an inspector's overall defect detection performance, but it does seem to have potential to help address delocalisation through the creation of abstract specifications, encourage a deeper understanding of the code being inspected, and may also help discover different defects from an ad-hoc approach.
An encompassing life cycle centric survey of software inspection
Applying RCS and SCCS - from source control to project control
TLDR
This book will not become a unity of the way for you to get amazing benefits at all, but, it will serve something that will let you get the best time and moment to spend for reading the book.
Software Inspection
TLDR
The Inspection techniques illustrated in this book have brought clear benefits in terms of lower (or even zero) defects, higher productivity, better project tracking and improved documentation.
Software Inspection Process
Introduction process management the inspection process implementing inspections managing inspections inspection data training in inspections the role of inspections in software the role of
Software inspections
Spreadsheet Auditing Software, EUSPRIG Conference
  • Spreadsheet Auditing Software, EUSPRIG Conference
  • 2001
Software Inspection Process, New York: McGraw-Hill
  • IBM System Journal,
  • 1994