Recommended Practices for Spreadsheet Testing

Abstract

This paper presents the authors recommended practices for spreadsheet testing. Documented spreadsheet error rates are unacceptable in corporations today. Although improvements are needed throughout the systems development life cycle, credible improvement programs must include comprehensive testing. Several forms of testing are possible, but logic inspection is recommended for module testing. Logic inspection appears to be feasible for spreadsheet developers to do, and logic inspection appears to be safe and effective.

12 Pages, Extensive References

Cited by in corpus (7)

• Thinking is Bad: Implications of Human Error Research for Spreadsheet Research and Practice
• The Detection of Human Spreadsheet Errors by Humans versus Inspection (Auditing) Software
• In Pursuit of Spreadsheet Excellence
• Towards a Spreadsheet Engineering
• The Reification of an Incorrect and Inappropriate Spreadsheet Model
• Defending the future: An MSc module in End User Computing Risk Management
• Establishing and Measuring Standard Spreadsheet Practices for End-Users