Sheets
How to create Sheets in a Layout
Last updated
How to create Sheets in a Layout
Last updated
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:
Assumptions
Calculations
Metrics
Dashboard
Excel Insert
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.
These Sheets:
Can be moved
Can be , or have their changed
Cannot be deleted
All sheet dialogs contain the Setup page, which will look similar to the below:
Adds a description to the Sheet when generated, shown in the top left of the sheet, as below.
Each sheet can only show one type of time period e.g. you cannot have a Sheet that shows both quarterly and annual periods
One Sheet in the Model must display the dropdown controls for selecting the active Scenario and Sensitivity, as shown below.
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.
You can select a color for your Sheet, which will be used to change the color of its tab in Excel, as shown below.
Contains . All inputs to the Model will be editable from an Assumptions sheet, unless they are linked to a or .
Contains .
Contains .
Contains a . Each Dashboard sheet can only display one Dashboard.
Copy of a pre-built sheet from another spreadsheet (e.g. a cover sheet). Read more about Excel Inserts .
Sheets can be created directly in the Sheets tab of the , or from within any Sheet selector (e.g. in an Add Item wizard).
Each sheet must have a name that meets Excel . If you enter a name that has already been used elsewhere in your Layout, Models will automatically change it.
Specifies whether the Sheet's time period is the default period of the Model (as defined in ) or an aggregated time period.
If you have that are 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.
You can specify a number of levels to group your by in your generated spreadsheet. By default, the value is 0
, meaning no Excel grouping is performed.
If this item is selected, the Sheet will be in Excel.
You can apply to your Sheet to help search Sheets in large Layouts.