Changing a variable over time
By default, every variable has one single period (i.e. one consistent value/formula). However, variables can be split into multiple periods which makes it possible to define different formulas or values for different time steps. There are different ways to create periods:

Single-click vs. double-click

  • If you want to change the value of a single time step, just single-click on the cell and type a new value or formula. This will create a new period for this time step.
  • If you want to change the value or formula of a period, double-click (or hit enter) on a timestep anywhere within the period.

Split variables into Month, Quarter, Year

  • You can also create a period for every month, quarter or year of the model: right-click on a variable and select "Recipes"→ "Split by Month/Quarter/Year". Double-click (or hit enter) on a time step within each period to change the value/formula for that period.
Tip: You can see the different periods more clearly if you hit Show Formulas

Changing period endpoints

To change the span of a particular period, hover over the endpoint and drag it to the desired time step, or if you want the period to end at the end of the model, you can click "fill right" or Cmd/Ctrl+Shift+-> on your keyboard.
Copy link
On this page
Single-click vs. double-click
Split variables into Month, Quarter, Year
Changing period endpoints