i-nth logo

Authors

Robin Barker, Peter Harris, & Graeme Parkin

Abstract

This guide gives best practice on the use of applications implemented as spreadsheets, so that they may be properly validated.

It takes the approach that development and testing of spreadsheet applications should be founded on proper software engineering principles, bearing in mind that spreadsheets have aspects that are not found in normal software development and testing.

Sample

Typical software lifecycle
Typical software lifecycle

This is a typical software lifecycle: boxes represent the key stages, the lighter arrows show the main development path, and the darker arrows are the possible iteration loops.

Publication

2006, National Physical Laboratory, Software support for metrology best practice guide No. 7, December

Full article

Development and testing of spreadsheet applications