🎓
Models University
  • Alpha Testing
    • 👋Welcome to Alpha
    • Installation and Setup
    • Support and Help
    • Terms and Licence
  • Start Here
    • What is Models?
    • Quick start
    • Tutorials
  • Using Taglo Software
    • The Taglo Interface
      • Navigating in Models
      • List Views
      • Adding Items
      • Deleting Items
      • Searching and Filtering
      • Previewing and Editing
      • Using Wizards
      • Save/Undo/Redo
      • Keyboard Shortcuts
    • Data Storage
    • Namespaces
    • Inbuilt data
  • Tags
    • Introduction to Tags
    • Tag Basics
    • Tags Applet
    • Advanced Tags
  • Models
    • Home Tab
      • Creating a Model
        • Timings
      • Version History
      • Application Settings
    • Model Editor
  • Variables
    • Variable Basics
      • Variable Setup
      • Unit and Calculations
    • Time Segments
      • Time Segment Setup
    • Summaries
    • Default Assumptions
  • Units
    • Introduction to Units
    • Key Unit Concepts
    • Advanced Units
    • Defining a Unit
    • Unit Factors
  • Dimensions
    • Introduction to Dimensions
    • Dimension Setup
    • Defining Unit Variance by Dimension
  • Data Types
    • Data Types
  • Assumptions
    • Introduction to Assumptions
    • Creating/Referencing Assumptions
    • Assumptions Wizard
      • Assumption Dates Step
      • Assumption Values Step
      • Linking to external Data
      • Linking to Excel Inserts
      • Sensitivity Values
  • Calculations
    • Introduction to Calculations
    • The Calculation Page
      • The Formula Entry Bar
      • Unit Analysis
    • Calculation Parts
      • Variable References
        • Referencing Time
        • Referencing Dimensions
        • Lookups
        • Summarising Variables
      • Period References
      • Functions
        • Advanced Functions
  • Aggregation
    • Introduction to Aggregation
    • Creating Aggregations
  • Rearranging
    • Introduction to Rearranging
    • Rearranging Example
    • Rearranging Tips
  • Cases
    • Introduction to Cases
    • Managing Scenarios
    • Managing Sensitivities
  • Layout
    • Generating Excel
    • Auto Layout
    • Sheets
      • Sheet Content
      • Adding and Editing Content
    • Excel Formatting
      • Excel Themes and Styles
      • Line Formatting
    • Data Tables
    • Excel Generation Troubleshooting
  • Excel Inserts and Outputs
    • Excel Inserts
    • Excel Outputs
  • Number Formats
    • Number Formats
  • Dashboards
    • Dashboards Basics
    • Dashboard Layout
    • Dashboard Items
    • Excel Dashboards
  • Metrics
    • Metrics
  • Charts
    • Introduction to Charts
    • Chart Customisation
  • Importing Models
    • Importing Models
  • Data
    • Introduction to Data
    • Creating Data
    • Data Sources
Powered by GitBook
On this page
  • Overview
  • Creating and using Excel Outputs
  1. Excel Inserts and Outputs

Excel Outputs

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

PreviousExcel InsertsNextNumber Formats

Last updated 1 year ago

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 ).

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.

Creating and using Excel Outputs

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.

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 .

naming rules
Variable
Assumption
Excel is generated
Layout
Microsoft documentation here
Excel Output examples
Excel Output wizard