# Assumption Values Step

## Overview

<figure><img src="https://2847533834-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVy65sax6FVoNo2UTlJ0x%2Fuploads%2FbDoCQ4bXRk16SPRhzrvr%2Fimage.png?alt=media&#x26;token=a4bb6eb5-2cb2-4fb6-a318-28e6cbe5df4e" alt="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." width="563"><figcaption><p>Values step of the Assumptions wizard</p></figcaption></figure>

When creating Assumptions, either through the Assumptions wizard or [**from a Variable**](https://help.taglo.io/creating-referencing-assumptions#creating-assumptions-from-variables), 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

<figure><img src="https://2847533834-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVy65sax6FVoNo2UTlJ0x%2Fuploads%2F0eI6P36QmnMMsZUfhY8f%2Fimage.png?alt=media&#x26;token=7f84fbd3-7fc4-4e77-9ee6-4d3f4d6de81d" alt=""><figcaption><p>Dimension editing interface</p></figcaption></figure>

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 <img src="https://2847533834-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVy65sax6FVoNo2UTlJ0x%2Fuploads%2FLkMlCOEtufW6DvQ80ai8%2Fimage.png?alt=media&#x26;token=26e2558e-3f9a-44af-af8b-97619a4d1eea" alt="" data-size="line">sort button and selecting a sort direction.

In the example below, the interface shown in the [**Overview**](#overview) section above is rearranged with the `Region` dimension horizontal, and the `Membership Tier` sorted alphabetically.

<figure><img src="https://2847533834-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVy65sax6FVoNo2UTlJ0x%2Fuploads%2FxT0DkQz4aBKZ6jf1Ggxu%2Fimage.png?alt=media&#x26;token=f7795e70-635b-4be4-82ac-64ece6aca511" alt="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." width="563"><figcaption><p>Value entry with rearranged and sorted dimensions</p></figcaption></figure>

{% hint style="info" %}
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
{% endhint %}

## 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.

<table><thead><tr><th width="218">Button</th><th>Details</th></tr></thead><tbody><tr><td><img src="https://2847533834-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVy65sax6FVoNo2UTlJ0x%2Fuploads%2F11WFgmO7w43CELZBobxr%2Fimage.png?alt=media&#x26;token=6e5f27a1-fd9a-4bc2-adff-46ac0a9335e7" alt="Paste Values button" data-size="line"></td><td>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.</td></tr><tr><td><img src="https://2847533834-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVy65sax6FVoNo2UTlJ0x%2Fuploads%2F24mnJVexqYj9KAxBIhy6%2Fimage.png?alt=media&#x26;token=fbecbbfe-5391-4fa3-81c0-038d62aa003b" alt="Copy values to clipboard button" data-size="line"></td><td>Copies just the value cells to the clipboard. If pasted to Excel, will paste in the same layout.</td></tr><tr><td><img src="https://2847533834-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVy65sax6FVoNo2UTlJ0x%2Fuploads%2FZYKodEsNHPJy1Dl50nwv%2Fimage.png?alt=media&#x26;token=dc8870e3-2122-4cc5-95dd-886af5112d25" alt="Copy all to clipboard button" data-size="line"></td><td>Copies value cells and row/column headers to the clipboard. If pasted to Excel, will paste in the same layout.</td></tr></tbody></table>

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.

{% hint style="info" %}
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`.**
{% endhint %}

{% hint style="info" %}
If pasting values from Excel, use [**Dimension editing**](#dimension-editing) to make the values entry layout match the layout of your data in Excel before pasting.
{% endhint %}