Excel Outputs

How to link outputs from your generated sheets to an Excel Insert

Overview

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 Microsoft documentation here).

There are several types of Output that Models allows you to create:

Output type
Details

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.

Excel Output examples

Creating and using Excel Outputs

In the Excel Output wizard, shown below, you must enter a name for your output that conforms to Excel Named Range naming rules. Choose the type of output, and the Variable or Assumption to link to.

Excel Output wizard

When your Excel is generated, 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 Layout.

To reference Excel Outputs in an Insert, we recommend creating your Outputs first and generating Excel. Then create your custom sheet, referencing the Named Ranges that have been created. Once you have created your custom sheets, delete all other sheets, save the custom sheets into a separate file, and turn this file into an Excel Insert.

Last updated