Interpreting the Results
The Model updates every time you press the ‘Run Scenario’ Button
With each run - any variable that is changed in value is coloured Yellow so it is easily identified
Each variable block shows:
The name of variable
Column 1: The years being used
Column 2: The base case - that is, the actual value for the start year and base case forecast value for the selected future year, the extent to which the variable changes in absolute value between those two years and the Compound Average Growth rate (CAGR) for that period
Column 3: The base case and then the revised value for the future year (in yellow if different from the base case), the absolute change from the start year and CAGR.
The ‘See Detail’ or ‘Change’ button takes you to the new window as shown below.
This gives the exact value for the selected variable for all years from 2007 to 2043
Select the ‘Return to Model’ button to quickly look at another variable.