Global Time Vectors

These time vector variables are present in every projection node. They are included in every "Time Vectors" table in the output.

This is equivalent to creating a variable set named "global" from which all other variable sets inherit.

Unlike the global scalars, these variables are not available to functions that affect the structure of the model, like mapProjectionValues, etc..

t

Every projection node has one or more time steps. t is the ordinal of the current time step in the current projection node. It always starts at t=1. The last value depends on the configuration of the valuation type being used.

A Time Vector is any Variable that depends on t.

This variable cannot be modified.

Date

In most models, each time step corresponds to one month. The Date is the last day of the month at the current time step.

The default formula in the template is IF(t=1,ProjectionStartDate,EOMONTH(INDEX(Date,t-1),1)), but this may be modified for advanced use cases. Some parts of the documentation assume that this has not been changed.

Add your own

You may add your own global time vectors.

Using an Excel model

Add a row to the GlobalProjectionVariables table.

VarName	Formula
t	SequenceFrom1
Date	IF(t=1,ProjectionStartDate,EOMONTH(INDEX(Date,t-1),1))
MyGlobal	3+t*2

Using a JSON model

When using a JSON model, there is no implicit "global" variable set. You can create one manually, and let all other variable sets inherit from that one.

{
    "variable_sets": [
        {
            "name": "global"
        }
    ],
    "variables": [
        {
            "group": "global",
            "name": "MyGlobal",
            "dimensionality": "TimeVector",
            "weight": 1
        }
    ],
    "variables_in_sets": [
        {
            "variable_set": "global",
            "formula": "3+t*2",
            "variable": "MyGlobal"
        }
    ],
    "variable_set_inheritance": [
        {
            "parent": "global",
            "child": "AnotherVariableSet"
        }
    ]
}