Assumption Values Step

How to enter values for Assumptions

Overview

Values step of the Assumptions wizard

When creating Assumptions, either through the Assumptions wizard or from a Variable, 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

Dimension editing interface

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.

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

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

Value entry with rearranged and sorted dimensions

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.

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