🎓
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
  • How to use the Auto Layout feature
  • The Auto Layout wizard
  1. Layout

Auto Layout

How to automatically add sections of your Model to the Layout

PreviousGenerating ExcelNextSheets

Last updated 10 months ago

How to use the Auto Layout feature

To automatically add Variables to your Layout, simply select one or more Variables. As shown below (1), you only need to select the top node of any logical tree of Variables - Models will ensure that any Variables that the selected Variable depends upon will also be added to the Layout.

With the Variable selected, simply press the "Auto layout" button (2). This brings up a wizard with one page

The Auto Layout wizard

There are several optional fields which can be used to change how the layout is created as follows:

Optional Field
Description

Calculations Line Group

If you want to add new content to an existing Line Group, select a Line Group here. If no Line Group is selected, new content will be added to the top level of the selected Sheet.

Assumptions Sheet

If you want to add Assumptions to a specific sheet, select one here. Otherwise Models will use the first Assumptions sheet it finds, or create one if none exists.

Assumptions Line Group

Select if you want to add new Assumptions content to an existing Line Group. If none selected, new content will be added to the top level of the selected Assumptions sheet.

Add Flags to separate sheet (toggle)

Flags Sheet

If the Add Flags to separate sheet toggle is selected, you will be prompted to choose a Sheet to add Flags to.

Flags Line Group

Select if you want to add new Flags content to an existing Line Group. If none selected, new content will be added to the top level of the selected Flags sheet.

Max levels

Sets the maximum level of nesting of groups within a Sheet. We recommend a maximum nesting of 3 for most Models - higher levels of nesting add more "structure", but make worksheets less readable.

Ideal min groups at level / Ideal max groups at level

Controls the way in which nested Line Groups are created. Models will try to ensure that Line Groups contain a number of child groups between the min and max values set here. Increasing the min groups at level setting will result in more Line Groups at higher levels, and fewer groups at lower levels.

The Auto Layout wizard has only one mandatory field, which is the choice of Calculations Sheet. This is the sheet which all within the selected node will be added to.

Flags are any Variable using the Boolean (i.e. with TRUE/FALSE values), often used for settings timings of Variables (e.g. start period, end period). It is often good practice to place Flags on a separate sheet from other calculations - select this option if you want to do so.

Variables
Data Type
Steps 1 and 2 of using the Auto Layout feature
The Auto Layout wizard
Screenshot of the Auto Layout wizard