• Corpus ID: 7898940

Inclusion Analysis

@article{Colver2010InclusionA,
  title={Inclusion Analysis},
  author={David Colver},
  journal={ArXiv},
  year={2010},
  volume={abs/1001.4104}
}
Inclusion analysis is the name given by Operis to a black box testing technique that it has found to make the checking of key financial ratios calculated by spreadsheet models quicker, easier and more likely to find omission errors than code inspection. 1 CALCULATE MORE THAN ONCE One approach among many [Pryor, 2004] [Panko, 2006] for improving the chance that a spreadsheet delivers the results that it is intended to deliver is to calculate quantities two or more different ways [Ettema et al… 

Tables from this paper

Self-Checks In Spreadsheets: A Survey Of Current Practice

TLDR
A survey of 11 spreadsheets prepared by a range of organisations shows that the amount of self-testing included in such models ranges between one formula of testing for each three formulae of calculation, down to essentially no self- testing at all.

References

SHOWING 1-6 OF 6 REFERENCES

Spreadsheet Assurance by "Control Around" is a Viable Alternative to the Traditional Approach

TLDR
Not all distinct formulas are audited separately, but the relationship between input data and output data of a spreadsheet is audited through comparison with a shadow model developed in a modelling language.

When, why and how to test spreadsheets

TLDR
This paper discusses the testing of spreadsheets in the light of one practitioner’s experience, and considers the concept of software testing and how it differs from reviewing, and describes when it might take place.

What we know about spreadsheet errors

TLDR
Although spreadsheet programs are used for small "scratchpad" applications, they are also used to develop many large applications, and error rates are in line with those in programming and other human cognitive domains.

A typical model audit approach

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

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.

Operis Analysis Kit

  • Operis Analysis Kit
  • 2010