🎓
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
  • Worked Example
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  1. Calculations
  2. The Calculation Page

Unit Analysis

How to keep track of Units when creating a Calculation

PreviousThe Formula Entry BarNextCalculation Parts

Last updated 10 months ago

Overview

The Calculation page analyses the Unit of your Calculation as you are creating it. This helps you check your Calculation for logical consistency, and provides clues to the Unit of Variables required to finish your Calculation.

The Calculation page shows two or three items:

Target Unit

The Unit of the Variable in which we are creating the Calculation. Note: If you haven't defined a Unit for the Variable, this will be guessed based on context

Current Unit

The Unit currently produced by the Calculation. This item will show warning messages if a Unit cannot be determined.

Remaining Unit

The Unit required to finish the Calculation with the Target Unit. The remaining Unit will only be shown if the entered formula is empty ends in an operator (+, -, /, *).

Worked Example

In this example, we are creating a Variable called Gym Revenues, which is equal to Gym members * Revenue per member.

Gym Revenues has a Unit of GBP.

Step 1

To begin with we have an empty formula. Target Unit shows our desired Unit (GBP). Current Unit shows that the Calculation is not currently valid. Remaining Unit shows that if we reference a Variable with Unit GBP we will have the correct Unit.

Step 2

We enter a reference to Gym Members. This updates the Current Unit to Member, and alerts us that Member does not match the Target Unit of GBP. We have not entered an operator, so Models cannot determine the Remaining Unit.

Step 3

We enter a * (multiply) operator. Models can now work out that we need to reference a Variable with Unit GBP / Member in order to arrive at the Target Unit, as Current Unit * Remaining Unit = Target Unit.

Step 4

We add a reference to the Revenue per member Variable, which has Unit GBP / Member.

The Current Unit now matches the Target Unit.

At this point, if we click on the Add Variable Reference button in the Calculation Part list, we will be shown only Variables that match the Remaining Unit of GBP / Member.

Step 1
Step 2
Step 3
Step 4