Assumptions Wizard

How to use the Assumptions wizard for adding and editing assumptions

Setup

Setup page of the Assumptions wizard

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

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

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:

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.

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.

Last updated