🎓
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
  • Dimension editing
  • Copy/Paste
  1. Assumptions
  2. Assumptions Wizard

Assumption Values Step

How to enter values for Assumptions

PreviousAssumption Dates StepNextLinking to external Data

Last updated 1 year ago

Overview

When creating Assumptions, either through the Assumptions wizard or , you will usually enter values through the Values step interface.

This presents you with a table in which you can enter a value for each Assumption. Validity of the entered data is indicated by a green/red background.

Dimension editing

The Dimension editing section of the interface allows you to rearrange the order and positioning of items in the value entry table.

Drag and drop the table dimensions (Time, Scenarios, Dimensions) between the Horizontal and Vertical sections to change the way in which the table is displayed.

Much of the time you won't need to rearrange the value entry dimensions, but it can help enormously when you are working with a large number of Assumptions.

e.g., if you are entering data across a large number of periods, we recommend moving Time to Vertical

Copy/Paste

The value entry interface includes some functions to make it easier to copy and paste values to and from Excel, or other spreadsheets.

Button
Details

Pastes contents of clipboard to table if possible. If pasting several values from Excel, will paste from first cell in the table. Pasting will not work if the number and position of copied values do not match the cells in the table.

Copies just the value cells to the clipboard. If pasted to Excel, will paste in the same layout.

Copies value cells and row/column headers to the clipboard. If pasted to Excel, will paste in the same layout.

You can also paste in values using the Ctrl+V shortcut. If you have copied multiple values (e.g. from Excel), values will start to be pasted from the currently selected cell.

For a large number of assumptions, we sometimes find it easiest to use Copy all to clipboard to paste the entry table into Excel, edit values in Excel, and paste back to Models using Paste Values or Ctrl+V.

You can sort each dimension by pressing the sort button and selecting a sort direction.

In the example below, the interface shown in the section above is rearranged with the Region dimension horizontal, and the Membership Tier sorted alphabetically.

If pasting values from Excel, use to make the values entry layout match the layout of your data in Excel before pasting.

Overview
Dimension editing
from a Variable
Values step of the Assumptions wizard
Dimension editing interface
Value entry with rearranged and sorted dimensions
Screenshot showing the Assumptions Values step of the Assumptions dialog. The user is presented with a table in which they should enter values for the assumptions. 5 of the values have been entered correctly, indicated by cell formatting in the table. The last value is yet to be entered and its cell has a pink background indicating that it is not valid.
Screenshot of the Assumption Values entry interface. The dimensions of the assumptions have been rearranged so that the table is in a 3x2 format rather than a 6x1 format. The Membership Tier dimension has been sorted alphabetically.