Skip to main content

logoCorrectSize.png

Adaptive Insights LLC.

Build Standard Sheets

Explains how to build and edit standard level-assigned and user-assigned sheets.

Build standard sheets for basic input based on accounts and levels. Use splits to tag data by a dimension or to create subcategories by row.

Standard sheets use a wizard to help you build the sheet.

Before You Begin

Required permission: Model Management Access > Model

Before you build sheets, create:

To learn how to edit standard sheets, see Edit Standard Sheets.

How You Get There

Compass.png From the nav menu, select Modeling. In the Sheets menu, select User Assigned Sheets or Level Assigned Sheets to view the list of sheets in your model.

Basic Steps to Build Standard Sheets

  1. Name the sheet.
  2. Create account groups and add accounts.
  3. Optional. Add custom dimensions.
  4. Set the initial view.
  5. Assign level-assigned sheets to levels or user-assigned sheets to users.
  6. For user assigned sheets only, add levels to the sheet.
  7. Optional. Customize each level's access to each account. 
  8. Optional. Set a default view of the sheet.

Name the Sheet

  1. From the Sheets list, select New Sheet
  2. Enter a unique sheet name. 
  3. Select Create a new sheet > Standard.
  4. Select Next

You cannot clone standard sheets. If you select Clone existing sheet, the only options are for cube and modeled sheets.

Create Account Groups and Add Accounts

1 In the Accounts for Sheet box are the groups and accounts that appear on the sheet. When you first build a sheet, this box has one single account group. 

2 The Account Details or Group Details contain settings for the sheet, the account, or the group. 

3 The Select Account box contains all the accounts in your model. You can add these accounts to the group so they appear on the sheet. 

Standard Sheet Builder.png

In this step: 

  1. Choose to show or hide initial balances on the sheet. 
  2. (Optional) Rename the default New Group. 
  3. (Optional) Add New Groups to the sheet and select group settings: display headings and subtotals. 
  4. Arrange the account groups in the sheets. 
  5. Add accounts to the groups.
  6. (Optional) Choose to make accounts read-only for all levels. 
  7. Select Next

Show or Hide Initial Balances

Many accounts have initial balances. Above the Group or Account Details, select the Show the initial balance checkbox to display the initial balance as a column in the sheet. Leave the checkbox blank to hide this column. 

Rename the First Account Group

  1. From the Account for Sheet box, select New Group
  2. In the Group Details section, enter a name for the group in the Heading field. 

Add New Groups

  1. Select the New Group button. 
  2. Enter a name in the Heading field. 
  3. Select the optional checkboxes. 
    • Display heading: The account group heading appears on the sheet and groups the accounts you add to it.
    • Display subtotal: The sheet displays a subtotal of all the accounts in the group. 
  4. Select the Save button in the Group Details section. 

Arrange the Groups

You can reorder the account groups, not the accounts, to control how they display on the sheet. 

  1. Select a group from the Accounts for Sheets box. 
  2. Select the Move Up or Move Down buttons at the bottom of the box. 

Add Accounts to Group 

  1. From the Accounts for Sheet box, select a group.
  2. From the Select Accounts box on the right, select the accounts to add. For quick additions, add a parent account to automatically include all its descendants:
  • Use the Type dropdown to filter the list.
  • Use the Search field to enter keywords or account codes. 
  1. Select the Add to Group button. The account and its descendants appear in the Accounts for Sheet box on the left.

Make Accounts Read-Only

Once you add accounts to groups, you can make specific accounts read-only for any viewer of the sheet. No one can edit the account data on the sheet.  

Parent accounts are always read-only because they display the rollup value of all their descendant accounts. If you make a parent account read-only, you hide its descendants. 

  1. From the Accounts for Sheet box, select an account.
  2. In the Account Details section, select the Read Only checkbox.
  3. Select Save.
  4. When you're done adding accounts, select Next.

Add Dimensions

You can assign dimensions to the sheet. Dimensions provide custom filters to categorize and analyze plan data. Use dimensions to view data or include it in formulas. Dimensions you add display after the first column on the sheet. 

To add a dimension to the sheet:

  1. In Available Dimensions, select a dimension. 
  2. Select the right arrow >> to add the dimension to Selected Dimensions for the sheet.
  3. After adding all dimensions, use Move Up, Move Down to set the order of the dimensions in the sheet. 
  4. Select Next

Set the Initial  View

Choose the initial view of the sheet when it's first opened. Each user can change the display options when they open the sheet.

  • Start in view by level mode: Shows levels down the rows. If unselected, the sheet shows accounts down the rows.
  • Suppress rows if zero or blank: Hides any rows with zeros or blank values.

Select Next.

Assign to Levels or Users

  • With level-assigned sheets, you assign levels to the sheet. Users who own the levels assigned to these sheets find these sheets from nav menu > Sheets
  • With user-assigned sheets, you assign users to the sheet. Users assigned to a sheet find the sheet from nav menu > Assumptions

Assign to Levels

This step only appears for level-assigned sheets. Keep in mind: 

  • If you assign only a parent level, users can't edit the data in the accounts. 
  • You can assign parent levels without assigning its child levels. When your team views the sheet at the parent level, they can explore a cell to see the child level contributions. Users who have access only to the child levels can't open the sheet at all. 
  • When you assign a child level, you automatically assign its parent and all ancestors.
  • Customize each level's access to each account with the Customize Sub-Levels option. See below. 

To assign levels: 

  1. Expand the list of levels as much as you need.
  2. Select the levels that can access this sheet. If you select a parent level, but not its descendants, the sheet displays the (Only) level. This data isn't rollup data, but is specific to the (Only) level. 
  3. Select Create Sheet to finish or Customize Sub-Levels to further define level access to the sheet.

Assign to Users 

This step only appears for user-assigned sheets.

  1. From the Available Users box, select one user at a time. 
  2. Click the forward arrow to assign the user. 
  3. Optional. If your instance uses Workflow, select Excluded from Workflow to remove the sheet from Workflow. See Use Workflow for more information.
  4. Select Next

Add Levels to User-Assigned Sheets

This section applies to user-assigned sheets only.

Users assigned to the sheet can view all levels you add to the sheet. They can only edit leaf-levels or levels that don't have child levels. 

  1. Expand the level list as needed. 
  2. Select levels to add to the sheet. When you select a child level, the ancestor levels are automatically added to the sheet. 
  3. Select Create Sheet to finish or Customize Sub-Levels to further define level access to the sheet.

Customize Sub-Levels 

Customize each level's access to each account.

A few rules:

  • You can customize only the levels that you have already assigned or added to the sheet.
  • If an account is hidden from a parent level, then it's also hidden from the child levels.
  • If an account is marked Read Only on the Select Accounts page of the sheet builder, you cannot make it editable here, only Hidden or Read Only. 

To customize sub-levels:

  1. Select an account from the left box. The list includes all the accounts you added in the sheet. You can't select an account group. 
  2. Expand the level list and select the checkboxes until they display what you want: 
    • A blank box hides the selected account from the level.
    • A blue box locks the selected account. 
    • A checkmark allows the level to edit the selected account.  
  3. Select Save and Close

Set the Default View (Optional)

Once you've built the sheet, you can further manage the initial view if you have both:

  •  Model Management Access > Model permission
  • Access Sheets permissions

Set the default view so that anyone who opens the sheet sees it exactly as you defined. They can still change the sheet view, but they also have the option to reset the view to the default. 

  1. From the nav menu, select Sheets and choose the sheet. 
  2. Select Display Options displayOptions.png
  3. Modify the display options in the tabs: Time, Version comparison, and Sparklines. 
  4. Select the Set as default for all users checkbox.
  5. Select Apply. Check the sheet to ensure that it looks the way you prefer.
  6. Select Save
  • Was this article helpful?