What are Best Practices for Spreadsheet Models?

five Rules:

Irue or False

The model should be well organized and nicely formatted. An easy to follow

model helps minimize errors and makes it easy for others to follow.

Long or complex formulas should not be documented with an explanation. It

is easier to define functions again for repeat use rather than copy your own user$-$

defined functions for repeat use.

Variable inputs and calculations can be combined to facilitate good modeling

and tracking.

Enter numbers directly into a formula rather than as reference cells. This

makes calculations easier to track.

$5.$When finished, pressure test the model thoroughly. Input assumptions can

change.