Excel Outputs
How to link outputs from your generated sheets to an Excel Insert
Last updated
How to link outputs from your generated sheets to an Excel Insert
Last updated
Models allows you to link sheets from Excel Inserts to your generated Model through Excel Outputs.
Excel Outputs work by generating Named Ranges which can be referenced by your custom Excel Inserts. (Read more about Named Ranges in the ).
There are several types of Output that Models allows you to create:
Variable values
The values of a Variable across all periods of the Model (including Row Summary)
Variable headings
The descriptions of dimensions of a Variable (including Row Summary)
Assumption
The used value of an Assumption
Timings
The periods of the Model
Examples of Variable values
, Variable headings
, and Timings
are shown in the screenshot below.
In the Excel Output wizard, shown below, you must enter a name for your output that conforms to Excel Named Range . Choose the type of output, and the or to link to.
When your , Models will add a Named Range for each of your Outputs, with the name given. You can set up your Excel Inserts to reference these Named Ranges, which will ensure that these references are correct regardless of where your Variables or Assumptions end up in your .