🎓
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
  • Setup
  • Name
  • Value Source
  • Dimensions
  • Number Format
  • Scenarios
  • Data Type
  • Unit
  1. Assumptions

Assumptions Wizard

How to use the Assumptions wizard for adding and editing assumptions

PreviousCreating/Referencing AssumptionsNextAssumption Dates Step

Last updated 10 months ago

Setup

Name

Enter a name for your Assumption. There are no restrictions to how you name your Assumptions, as long as the name isn't blank.

Bear in mind that if you will be generating Excel from your Model, Assumption 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.

Value Source

Assumptions can take their value from 3 sources:

Value source
Description

Local Input

Manually entered values which are stored within the Model, and cannot be shared between Models

External Data

Link to Plug-In

Values stored in an Excel spreadsheet, which are added to the Model when generating Excel

The Assumptions wizard will update with the relevant steps according to the option chosen here. Instructions for entering data for each type of source can be found at the following locations:

  • Local Input

  • External Data

  • Link to Plug-In

An Assumption can use different sources for each Scenario in the Model. e.g. you might link to External Data for the Base Scenario, and then enter Local Input values for alternative Scenarios

Dimensions

Choose any Dimensions that you want to apply to your Assumptions.

When editing multiple existing Assumptions, any Dimensions will be automatically detected and cannot be changed

Number Format

Choose the Number Format to apply to your Assumptions.

Scenarios

You can enter values for Assumptions for multiple Scenarios simultaneously. By default, the wizard will prompt you to enter values for the Base Scenario only, but you can select multiple Scenarios here, in which case you will need to enter values for all selected Scenarios.

For External Data, you can only select values for one Scenario at a time. If you want to use External Data for multiple Scenarios for the same Assumption, you will need to select Data for each Scenario separately.

Data Type

Choose the Data Type for your Assumptions.

Unit

You will need to enter a Unit for your Assumptions.

See here for more details on how to use the Unit step of the wizard.

Values which are stored in a separate application; These values can be used by multiple Models

Data
Setup page of the Assumptions wizard