What are Models?
Models are used to Forecast your rows for a given date range. You can apply as many Models per Row as you want, as long as they are assigned to different periods.
Each Model will be automatically assigned a color, which will used to highlight the Forecast months the model is calculating. In the above example, 2 Models are assigned to a Row:
GROW 4% PM- assigned to dates
Apr 2020 - Jun 2020
GROW 8% PM- assigned to dates
Jul 2020 - Dec 2020
You can see in the Forecasts to the right that the
Mar 2020 value is being increased by 4% each month until
Jul 2020 where it starts increasing by 8% each month. The corresponding Forecast values are also color coded to attribute the model used to calculate the values.
Adding a Model
To add a Model to a Row, start by clicking in the Model Cell for the row, then clicking the
Next select the type of Model you wish to add from the menu that appears. See "Model Types" below for more a more detailed explanation of each model type.
Then enter the required information for the Model Type that was selected. Each model will have the following fields in common:
Name - Use the model name as a way to clearly identify your assumption. Good model names are descriptive and specific such as
"constant gross margin"
Start Date - The first Forecast month to apply the model. Defaults to the current
Project Start Dateif no models are assigned to the row, or the next unassigned month if there are already existing Models assigned to the row.
End Date - The last Forecast month to apply the model. Defaults to the current
Project End Date
Interval - The applicable months in the date range beginning with Start Month. Defaults to a value of 1
When completed, click the
Save button to assign the Model to a Row.
Updating a Model
To edit an existing Model, simply click on the Model pill in the required Row to see the settings for that particular Model. Once required changes are made, click the
Save button to update a Model. Its applicable Forecast values will then be immediately recalculated.
Removing a Model
To remove a Model from a row, click the Model pill as if you were going to update the Model. In the pop-up menu, click the
Delete icon and the Model will be removed from the Row and its Forecasts will be updated.
Two Models assigned to the same row are not able to have their date ranges overlap unless they have different interval values. If upon saving a models date ranges will overlap, you will be given an error similar to below which will inform you of the conflicting model and its dates.
Models can have the same date range if their intervals cause them to apply to different months. For example, in the image below both
GROW 4% PM and
GROW 8% PM have an overlapping range, but a different start month and interval to ensure they don't overlap.
GROW 4% PM- applies to
4/2020 - 12/2020with interval of
GROW 8% PM- applies to
5/2020 - 12/2020with an interval of
Models can be created with a variety of types, which are all based on the functions above, but can speed up the process of creating your models.
Uses the formula builder interface, so you can type functions as in formulas.
Returns a result based on a % growth of the previous period. If you select growth per year, the % is adjusted as
(1 + growth) ^ (1/12) - 1
Returns the value that maintains the ratio of the assigned row to another selected row, based on the average of a certain number of periods.
Repeats a value from the past, you can use it for all constant rows or for seasonal rows, which repeat every certain number of months or years.
Allows entry of manual values for a selected range of months.
Returns the moving average of a number of periods.