When, why and how to test spreadsheets

Abstract

Testing is a vital part of software development, and spreadsheets are like any other software in this respect. This paper discusses the testing of spreadsheets in the light of one practitioner's experience. It considers the concept of software testing and how it differs from reviewing, and describes when it might take place. Different types of testing are described, and some techniques for performing them presented. Some of the commonly encountered problems are discussed.

7 pages, 5 colour figures

Cited by in corpus (8)

• Investigating the Potential of Test-Driven Development for Spreadsheet Engineering
• What's the point of documentation?
• Towards a Spreadsheet Engineering
• A Practical Approach to Managing Spreadsheet Risk in a Global Business
• End User Computing in AIB Capital Markets: A Management Summary
• The Reification of an Incorrect and Inappropriate Spreadsheet Model
• Embedded Spreadsheet Modelling
• Defending the future: An MSc module in End User Computing Risk Management