Assumption Values Step
How to enter values for Assumptions
Last updated
How to enter values for Assumptions
Last updated
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.
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.
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.
The value entry interface includes some functions to make it easier to copy and paste values to and from Excel, or other spreadsheets.
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.
You can sort each dimension by pressing the sort button and selecting a sort direction.