🎓
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
  • How Scenarios and Sensitivities work in Models
  • How to change active Scenario and Sensitivity
  1. Cases

Introduction to Cases

How to use Scenarios and Sensitivities to test your Model

PreviousRearranging TipsNextManaging Scenarios

Last updated 10 months ago

Overview

We often want to test how our outputs change for different values of inputs. What would be the impact of raising the price of a product? What would happen if our product launch was delayed by 6 months?

To do this, we can use Scenarios and Sensitivities:

Scenario

A Scenario usually reflects some kind of "alternative reality" for your Model, perhaps to reflect decisions that need to be made, and may involve significant changes.

e.g. turning a revenue item on or off, or switching between insourcing and outsourcing a cost activity

Sensitivity

A Sensitivity is usually used to test how the outputs of a Model are affected by changes to the inputs, reflecting uncertainty in our assumptions. e.g. testing the impact of a range of inflation rates

Models automatically calculates all combinations of Scenarios and Sensitivities and, unlike Excel, can easily display several Scenarios or Sensitivities simultaneously, as in the example screenshot below, enabling efficient analysis of your Model dynamics.

We call each combination of a Scenario and Sensitivity a Case.

How Scenarios and Sensitivities work in Models

Scenarios and Sensitivities both affect the values of Assumptions in your Model. For each Scenario/Sensitivity in the Model, you can apply a value for each Assumption.

In the below example, there are two Scenarios (Base and Lean), and three Sensitivities (Base, Low, and High).

In this case, the Lean Scenario is configured to take its value from the Base Scenario by default, unless a value is specified for Lean (1). This means that a value must be present in the Base Scenario for all Assumptions.

Sensitivities do not need to have a value specified, in which case the value for the Assumption will be the unchanged Scenario value. In the case that a value is specified (2), the Scenario value will be modified appropriately.

The next sections explain how to set up Scenarios and Sensitivities, and the various ways in which they can be used.

How to change active Scenario and Sensitivity

previews and items will by default display values for the currently active Scenario and Sensitivity. You can change this in the Model Settings bar at the top of the . Just click on one of the Scenario or Sensitivity buttons, as shown in the screenshot below, to activate it.

Variable
Dashboard
Model Editor
Model
Chart showing three Sensitivities
Scenario and Sensitivity values in Assumptions
Controls for changing active Scenario/Sensitivity