i-nth logo

Authors

Nick Read & Jonathan Batson

Abstract

Spreadsheet Modelling Best Practice is a guide to developing high quality spreadsheets. This guide is of interest to anyone who relies on decisions from spreadsheet models.

The techniques described include areas such as ensuring that the objectives of the model are clear, defining the calculations, good design practice, testing and understanding and presenting the results from spreadsheet models.

Sample

Model logic
Model logic

Logically, all spreadsheet models should flow from inputs through calculations to the model results.

The process of model specification should run the other way around, because it is model results that are most important and should determine the structure of the model.

Publication

1999, EuSpRIG, April

Full article

Spreadsheet modelling best practice