🎓
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 a Data Table
  • Adding a Data Table to the Layout
  1. Layout

Data Tables

How to create Excel Data Tables

PreviousLine FormattingNextExcel Generation Troubleshooting

Last updated 1 year ago

Overview

Unlike Models, Excel will only calculate one of your Model at a time, and you will need to use the controls in your spreadsheet to change Case.

However, Excel allow you to calculate results from different sets of inputs simultaneously, and display all results in one place. While this will not show you all outputs, it can be useful for comparing specific metrics over several Scenarios and Sensitivities, as shown in the example below.

Due to the limitations of Excel Data Tables, which can only respond to a single input cell, when you add a Data Table to your Layout, Scenarios and Sensitivities are combined into a list of Cases that contains all combinations.

Creating a Data Table

If you add new Scenarios and Sensitivities to the Model, these will not automatically appear in the Data Table. You will need to edit the selected Cases if you want them to be shown.

Adding a Data Table to the Layout

To add a Data Table to the Layout, you must perform the following steps:

We also add a Cases sheet to the Layout, which contains the list of Cases. This sheet can be as desired.

To create a Data Table, simply go to the Tables tab of the and add a new item. You will need to enter a name and choose which combinations of Cases to show.

As shown in the screenshot below, once you have created the Data Table, you can edit it in the same way you . In a Data Table, all sheet items are .

Use and to change the appearance of your Table.

Add the Data Table to a . You must place the Data Table in the main of the Dashboard, and the Data Table should be the only item in the Dashboard.

Add a Dashboard containing the Dashboard to the Layout

Model Editor
Dashboard
Panel
Sheet
Case
Data Tables
Metrics
line formatting
edit a Sheet in the sheet preview
group spacing
Scenario and Sensitivity
moved and hidden
A Data Table in Excel, generated by Models
A Data Table in Models
Screenshot of a Data Table in models.