# Assumptions Wizard

How to use the Assumptions wizard for adding and editing assumptions

Last updated

How to use the Assumptions wizard for adding and editing assumptions

Last updated

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:

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.

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.

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