🎓
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
  • Layouts
  • Layout Views
  • Spreadsheet view (default)
  • Logical view
  • Creating your Layout Automatically
  • Creating your Layout Manually
  1. Layout

Generating Excel

Introduction to generating Excel with Models

PreviousManaging SensitivitiesNextAuto Layout

Last updated 3 months ago

Overview

You can generate an Excel spreadsheet from your Model at the click of a button.

These spreadsheets are:

  • Free of copy/paste formula errors

  • Neatly and consistently formatted

  • Fully-working and dynamic, allowing your colleagues and clients to explore your model without needing access to the Models software

Layouts

To generate Excel, you first need to create a Layout. The Layout tells Models where you want the various parts of your Model (, , etc.) to appear in your spreadsheet.

Your Model's Layout is independent of the Calculation structure - so unlike in Excel, moving things around in the Layout can't affect any of the Calculations being performed. This means you can quickly edit the layout of your spreadsheet, without needing to worry about breaking a formula. Instead, you can focus on improving the readability of the spreadsheet, or whatever is important for your particular project.

That said, you do need to make sure that you have included all components of a Calculation in the Layout for the Calculation to be performed. If your Layout is missing a part of a Calculation tree (any Variables and Assumptions on which the Calculation is dependent), the spreadsheet will still be generated, but you will see warnings where components are missing.

You can add the same Variable to the Layout multiple times. A calculation formula will only be created in the first instance of the Variable; subsequent instances will reference the first instance.

Currently, you can only create one Layout per Model. We may add the ability to create multiple Layouts in future updates (e.g. so that you can include/exclude parts of the Model depending on audience) - let us know if you would be interested in this feature.

Layout Views

Models provides two views for examining your Excel layout, Spreadsheet view (left) and Logical view (right).

Spreadsheet view (default)

Values representing assumptions (with a green background) can be edited directly in this view.

Logical view

Creating your Layout Automatically

Creating your Layout Manually

Models provides two main methods of creating and editing your Layout manually:

The next sections provide more detail of how to build and edit your Layout.

This view shows a representation of how your generated Excel will look, including all calculated values, and borders, bold/italic text (note, it does not show how the selected will look).

This view shows simplified and Variables but does not show any calculated values. This view is helpful when reorganising a sheet and allows quick rearranging of items.

Models provides an easy way of adding multiple items to the Layout in a logical fashion with just a few button clicks. Details are on the .

From within the Sheets tab of the . Here you can easily see all of the items in each and edit them directly.

By adding items directly to the Layout from the , and tabs. Here you can add items to the Layout as you create them without needing to leave your workflow.

Variables
Assumptions
Dashboards
Model Theme
next page
Model Editor
Sheet
Variables
Assumptions
Metrics
Line Groups
Excel layout views
The Sheets tab
Add to sheet buttons in the Variables tab
Screenshot of the two views for Excel layouts
Screenshot of the Sheets tab with contents of the sheet displayed in a treeview
Screenshot of Variables list view, with "Add to sheet" buttons showing on Variable items that haven't been added to the layout.