# Sheets

## Overview

Just like in Excel, Layouts in Models are divided into Sheets. Each Sheet in Models represents a sheet that will be generated in Excel.

There are 5 types of Sheet that you can create:

<table><thead><tr><th width="235">Sheet type</th><th>Details</th></tr></thead><tbody><tr><td><code>Assumptions</code></td><td>Contains <a href="../assumptions"><strong>Assumptions</strong></a>. All inputs to the Model will be editable from an Assumptions sheet, unless they are linked to a <a href="../dashboards"><strong>Dashboard</strong></a> or <a href="../excel-inserts-and-outputs"><strong>Excel Insert</strong></a>.</td></tr><tr><td><code>Calculations</code></td><td>Contains <a href="../variables"><strong>Variables</strong></a>. </td></tr><tr><td><code>Metrics</code></td><td>Contains <a href="../metrics"><strong>Metrics</strong></a>.</td></tr><tr><td><code>Dashboard</code></td><td>Contains a <a href="../dashboards"><strong>Dashboard</strong></a>. Each Dashboard sheet can only display one Dashboard.</td></tr><tr><td><code>Excel Insert</code></td><td>Copy of a pre-built sheet from another spreadsheet (e.g. a cover sheet). Read more about Excel Inserts <a href="../excel-inserts-and-outputs"><strong>here</strong></a>.</td></tr></tbody></table>

{% hint style="info" %}
You can only have one type of item (Assumptions, Variables, Metrics or Dashboards) on each Sheet in the Layout.
{% endhint %}

### Auto-generated Sheets

Depending on your Model, some auto-generated Sheets may be added to your Layout. For instance, if any of your Variables use Dimensions, a `Dimensions` Sheet will be added.&#x20;

These Sheets:

* **Can** be moved
* **Can** be [**hidden**](#hide-sheet-in-excel), or have their [**tab color**](#tab-color) changed
* **Cannot** be deleted

## Sheet Setup page

Sheets can be created directly in the **Sheets tab** of the [**Model Editor**](https://help.taglo.io/models/model-editor), or from within any Sheet selector (e.g. in an **Add Item wizard**).

{% hint style="info" %}
Depending on the type of sheet you are creating, and which part of the UI you are creating it from, you will see different pages in the Sheet wizard. For `Dashboard` and `Excel Insert` sheets, for instance, you will see pages allowing you to choose the items to show on the sheet.
{% endhint %}

All sheet dialogs contain the **Setup page**, which will look similar to the below:

<figure><img src="https://2847533834-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVy65sax6FVoNo2UTlJ0x%2Fuploads%2F1gxGDX99GQjqIg3TXKK9%2Fimage.png?alt=media&#x26;token=e942dada-8255-4d34-b0b3-3b9c64ce47b1" alt="Screenshot of the new Sheet setup step" width="563"><figcaption><p>Sheet <strong>Setup page</strong></p></figcaption></figure>

### Sheet name

Each sheet must have a name that meets Excel [**sheet name rules**](https://support.microsoft.com/en-us/office/rename-a-worksheet-3f1f7148-ee83-404d-8ef0-9ff99fbad1f9). If you enter a name that has already been used elsewhere in your Layout, Models will automatically change it.

### Sheet description (Optional)

Adds a description to the Sheet when generated, shown in the top left of the sheet, as below.

<figure><img src="https://2847533834-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVy65sax6FVoNo2UTlJ0x%2Fuploads%2FOTv0dMMDbiwuNciwoxL9%2Fimage.png?alt=media&#x26;token=723ee08d-aaf5-4fc6-8c7e-42c2e23bd0d7" alt=""><figcaption><p>Sheet description</p></figcaption></figure>

### Time period (Calculation sheets only)

Specifies whether the Sheet's time period is the default period of the Model (as defined in [**Timings**](https://help.taglo.io/models/home-tab/creating-a-model/timings)) or an aggregated time period.&#x20;

If you have [**Variables**](https://help.taglo.io/variables) that are [**aggregated**](https://help.taglo.io/variables/variable-basics/variable-setup#time-period) over several time periods (e.g. in a quarterly Model, you may have a Variable that sums up totals for each year), these must be placed on a dedicated Sheet with the appropriate time period.

{% hint style="warning" %}
Each sheet can only show one type of time period e.g. you cannot have a Sheet that shows both quarterly and annual periods
{% endhint %}

### Control sheet

One Sheet in the Model must display the dropdown controls for selecting the active Scenario and Sensitivity, as shown below.

<figure><img src="https://2847533834-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVy65sax6FVoNo2UTlJ0x%2Fuploads%2FmmocxOZ3ruKzhwpaXa13%2Fimage.png?alt=media&#x26;token=855619bd-db4e-499c-8e59-ac3ffcef853b" alt=""><figcaption><p>Sheet with dropdown controls for Scenario and Sensitivity</p></figcaption></figure>

Use the toggle to specify whether this Sheet will display these controls. If you select this option on one Sheet, it will be deselected on all other Sheets.

### Group levels

You can specify a number of levels to group your [**Line Groups**](https://help.taglo.io/layout/sheet-content#line-groups-and-lines) by in your generated spreadsheet. By default, the value is `0`, meaning no Excel grouping is performed.

{% hint style="info" %}
Use grouping on large or complex Sheets to help speed up navigation of the Excel.
{% endhint %}

<figure><img src="https://2847533834-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVy65sax6FVoNo2UTlJ0x%2Fuploads%2FQY1C38WgF1uk7Eh19tHv%2Fimage.png?alt=media&#x26;token=567578a6-5076-4904-88ba-56b1ea0f4e13" alt=""><figcaption><p>Generated spreadsheet with 2 levels of grouping</p></figcaption></figure>

### Hide sheet in Excel

If this item is selected, the Sheet will be [**hidden**](https://support.microsoft.com/en-us/office/hide-or-unhide-worksheets-69f2701a-21f5-4186-87d7-341a8cf53344) in Excel.

### Tags

You can apply [**Tags**](https://help.taglo.io/tags) to your Sheet to help search Sheets in large Layouts.

### Tab color

You can select a color for your Sheet, which will be used to change the color of its tab in Excel, as shown below.

<figure><img src="https://2847533834-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVy65sax6FVoNo2UTlJ0x%2Fuploads%2FVv50wM4gMIdd8eqNWTtK%2Fimage.png?alt=media&#x26;token=eb84be95-3552-47c4-85f0-797beaa878a5" alt=""><figcaption><p>Sheets with edited tab colors</p></figcaption></figure>