Steps: Build Standard 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.

Prerequisites

Create:

Accounts, dimensions, and levels to add to the sheet.

User profiles for user-assigned sheets.

Security: Model includes: sheets, accounts, dimensions, and formulas
permission.

Basic Steps

Start a New Sheet

Create account groups and add accounts.

Optional. Add custom dimensions.

Set the initial view.

Assign level-assigned sheets to levels or user-assigned sheets to users.

For user assigned sheets only, add levels to the sheet.

Optional. Customize each level's access to each account.

Create Account Groups and Add Accounts

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

The Account Details
or Group Details
section contains settings for the sheet, the account, or the group.

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

To add accounts, groups, and change settings:

Choose to show or hide initial balances on the sheet.

(Optional) Rename the default New Group.

(Optional) Add New Groups to the sheet and select group settings: display headings and subtotals.

Arrange the account groups in the sheets.

Add accounts to the groups.

(Optional) Choose to make accounts read-only for all levels.

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

From the Account for Sheet box, select New Group
.

In the Group Details section, enter a name for the group in the Heading field.

Add New Groups

Select the New Group
button.

Enter a name in the Heading field.

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.

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.

Select a group from the Accounts for Sheets box.

Select the Move Up
or Move Down
buttons at the bottom of the box.

Add Accounts to Group

From the Accounts for Sheet box, select a group.

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.

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.

From the Accounts for Sheet box, select an account.

In the Account Details section, select the Read Only
checkbox.

Select Save
.

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:

In Available Dimensions, select a dimension.

Select the right arrow >>
to add the dimension to Selected Dimensions for the sheet.

After adding all dimensions, use Move Up
, Move Down
to set the order of the dimensions in the sheet.

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 all zeroes or blank
: Hides any rows with zeros or blank values.

Select Next
.

Further Define the Initial View

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

Model Management Access > Model permission

Access Sheets permissions

Set the initial view so that anyone who first 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 with the Reset to Default View
button on the sheet toolbar.

From the nav menu, select Sheets
and choose the sheet.

From the toolbar, click Display Options
.

Modify the display options in the tabs: Time, Version Comparison, and Sparklines.

Select the
Set as default for all users
checkbox.

Select Apply
. Check the sheet to ensure that it looks the way you prefer.

Select Save
.

Assign to Levels or Users

With level-assigned sheets, you assign levels to the sheet.

With user-assigned sheets, you assign users to the sheet.

Users can find level-assigned sheets from nav menu > Sheets
. To open the list of user-assigned sheets, users can expand the left panel and click

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:

Expand the list of levels as much as you need.

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.

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.

From the Available Users box, select one user at a time.

Click the forward arrow to assign the user.

Optional. If your instance uses Workflow, select Excluded from Workflow
to remove the sheet from Workflow. See Steps: Use Workflow for more information.

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.

Expand the level list as needed.

Select levels to add to the sheet. When you select a child level, the ancestor levels are automatically added to the sheet.

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:

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.

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.

Select Save and Close
.

Next Steps

Regularly monitor the usage and performance of the sheet. See Check Sheet Metrics.