What is the recommended way to structure a model that others will use?
- A Separate inputs, calculations and outputs, with hard-coded inputs clearly marked
- B Put everything on one sheet
- C Hide all formulas
- D Use merged cells for headings
Answer
Separate inputs, calculations and outputs, with hard-coded inputs clearly marked
A consistent convention, such as blue for inputs and black for formulas, lets any reviewer see immediately where a number comes from.





