creates a Cohort Category
e.g. if your model runs over 12 months then your Cohort Category has 12 cohorts
returns the total number of days in the calendar month
e.g. useful for calculating exact rates for per-day variables
daily rate x daysinmonth
Fiscal month of the current time step. Integer between 1 and 12.
Fiscal year of the current time step.
indexes the calendar months from 1-12. Jan = 1, Feb = 2 etc.
Useful for seasonality, or any variables that occur on a particular month each year.
if month = 4 then X else Y
e.g. if an employee has no end date
if End Date = blank then X else Y
returns the total number of time steps in the model
e.g. useful for dividing a value equally over the length of the model
X / numtimesteps
indexes the quarter from 1-4
Can be used for calculating variables that reoccur in a particular quarter, e.g.
if quarter = 2 then X else Y
e.g. creating a different formula for the first time step of the model
if timestep = 0 then X else Y
e.g. if you want to set a particular value for today, or months beyond today
if timestep >= today then X else Y
indexes the calendar year
Useful for setting different values/formulas for different years, e.g.
if year = 2022 then X else Y