🎓
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
  • Name
  • Variable type
  • Assumption Variables
  • Calculation Variables
  • Aggregation Variables
  • Dimensions
  • Number Format
  • Data Type
  • Validation Dimension
  • Time Period
  • Tags
  1. Variables
  2. Variable Basics

Variable Setup

How to create and configure a Variable

PreviousVariable BasicsNextUnit and Calculations

Last updated 7 months ago

The items on this page can all be configured on the Name and Setup step of the Variable dialog.

Name

There are no restrictions to how you name your Variables, as long as the name isn't blank. Make them as readable and self-explanatory as possible and thank yourself later!

Bear in mind that if you will be generating Excel from your Model, Variable names will be written in the spreadsheet, meaning you should avoid choosing a name that Excel will interpret as a formula, otherwise you will run into problems. But if you really want to start a name with an "=", we won't stop you.

Variable type

There are three types of variables in Models:

  1. Assumption

  2. Calculation

  3. Aggregation

Assumption Variables

Calculation Variables

Calculation Variables obtain their values by referencing other Variables and performing a calculation. e.g. Profits = Revenues - Costs.

Aggregation Variables

Aggregation allows you to bring values from several separate Variables together into a single Variable.

Dimensions

For example, a Dimension might be:

  • Widget Model | Model A, Model B, and Model C

or

  • Sales Region | North, East, West, and South

Number Format

A Number Format determines how the calculated values for your Variable will be displayed. You can choose from inbuilt Number Formats or create your own. Any Assumptions you create from within the Variable will use the same Number Format by default.

Data Type

Models works with several Data Types, which affect how values are treated in calculations.

These include Data Types for working with numerical values, text values, date-time values and others.

Validation Dimension

The Validation Dimension step will only appear if you select the Validation Data Type. Validation allows you to select inputs from a list of values.

For instance, a Variable called Include tax? may be an Assumptions Variable where you want to choose between Yes/No options. To achieve this, select the Validation Data Type, and then select the inbuilt Yes/No Option Dimension in the Validation Dimension step.

The Validation chosen here will be applied to any Assumptions created from this Variable. You can use any Dimension for Validation.

Time Period

For instance, for a Model built on a Monthly basis, you may want to see outputs in Quarters or Years

Tags

You can Tag Variables just like any other taggable item in Taglo software, which will allow you to filter the list of Variables by those Tags.

The Variable type you choose determines the default way that the Variable will calculate its value. Variables can calculate values from both Assumptions and Calculations in different periods of the model by using Time Segments. See the for more details. Aggregation Variables must calculate value via aggregation for the entire model period.

Assumption Variables are usually the starting point of your Model. They reference the basic inputs, called Assumptions, that underpin your Model's calculations. Read more on how Assumptions work , and how to reference them from your Variable .

Read more about Calculations .

You will only see the Aggregation option if you have already selected one or more for your Variable ().

Read more about Aggregation .

Select any that you want to apply to your Variable. Dimensions allow you to work with a collection of items without having to repeat calculations.

Dimensions are extremely powerful, time-saving, and improve the quality of your Models. Read more about how to use Dimensions .

Read more about Number Formats .

Read more about the different Data Types and how to work with them .

You may want to see outputs from your Model on a different timescale to that defined in the Model .

How Models calculates the value for each aggregated period depends on the Unit of the Variable. Balance Variables will calculate the value at the end of the period, and Flow Variables will sum the values of intervening periods. Read more about Balance and Flow concepts in the .

If you select a Time Period other than Default, your Variable will automatically be a Calculation Variable, and you will not be able to edit .

Read more about Tags and tagging .

dedicated help section on Time Segments
here
here
here
here
Dimensions
here
here
here
Timings
Units documentation
Time Segments
here
Dimensions
see below
Variable dialog | Name and Setup step
A screenshot of the Setup step of the new Variable dialog, containing several steps