Referencing Variables From Linked Models

Instead of a single model with all of your variables and formulas, you can structure your work into separate, smaller models. Once linked, you can reference variables between them as described in this chapter.

For an instruction on how to link models, see Linking Models.

Once you have linked models, you can easily refer to any of the variables in that linked model when you are writing a formula, just by typing its name. The only difference is that it will show up as a green variable within a formula (see variable types), and if you hover over the variable you will see which model it is coming from (and Cmd/Ctrl+Click will open the model).

If you want to bring in the entire variable from a linked model, within your current model, you can import the variable. This will allow you to visually see (but not edit!) the values of the imported variable across time, alongside the rest of the variables in the current model.

To do this - Click New Variable and then select Import variable. You can type in the name of the variable or the model that its in (even if it is not linked yet).

It will now show up in the spreadsheet as a variable, and will be differentiated by its green name.

Once you have imported a variable, you can broadly use it like any other variable in your model. You can use it in formulas, and you can add it to visuals. The main restriction is that you cannot directly modify an imported variable's attributes, except for its name and description. This variable gets the rest of its attributes from the model in which it "lives".

If you want to make changes to an imported variable, double-click the variable's link icon in the spreadsheet to "zoom in" to its model, and make the changes in the original model.