The golden rules for model design

There are a few rules for model design that should be followed when designing the layout of a model. Most experienced modellers will follow these instinctively, as they are generally common sense:

• Separate inputs, calculations, and results, where possible.
• Use each column for the same purpose.
• Use one formula per row or column.
• Refer to the left and above.
• Use multiple worksheets.
• Include documentation sheets.
• Design issues: time series, data collection, model purpose, and model audience.