概念：工作表类型

通过工作表工具栏、行和列的内容可以确定工作表类型。工作表类型有 3 种，每种类型具有不同的功能：

标准

模型化

多维

通过工作表，您可以查看、输入和更新数据，包括实际分类账数据、预测和预算。

标准工作表

标准工作表包含由账户和时段组成的简单网格。

示例：

资产负债表

现金流量表

费用表

损益表

收入表

Option	Description
1	Accounts or levels populate down the rows.
2	Levels or accounts exist in the drop-down menu. Swap the rows with the drop-down menu.
3	Time populates across the columns. Change the time periods with Display Options .
4	Dimensions exist as columns with cells that have drop-down values. Not all standard sheets have dimensions. In order to select dimension, add a split.

Standard sheets also have the

Add Split

Delete Split

, and

Rename Split

buttons in the toolbar.

模型化工作表

模型化工作表可用来输入基于记录的数据。在这类工作表中，您可以在列中使用自定义字段名称，并将记录保存在行中。模型化工作表包含对财务事件进行建模时使用的基础业务逻辑。示例：

资本采购的折旧

人员的月薪

销售产生的收入

Option	Description
1	Add Row and Delete Row buttons display in addition to, or instead of, the add, delete, rename splits buttons.
2	Labeled columns exist across the top and records list down the rows. The column types determine how you enter data. You can type in fields, or select from drop-downs. There are no row headers, only column headers.

You can enter new information into existing rows or add new rows. Your admin can set a maximum number of rows a modeled sheet can display at once. If the sheet has a maximum, a message states how many rows of the total you can see. Use the filters to uncover different sets of data.

多维工作表

多维工作表让用户能够根据大量的各种维度，在一些账户中输入多维数据。

Option	Description
1	More display options exist in the toolbar. You can pivot the sheet to view data in multiple ways.
2	No level drop-down list exists in the toolbar. Levels are a dimension to use as filters, columns, or rows.
3	Alternative dimensions enable you to filter data, drag and drop into the columns and rows, and nest up to 5 dimensions in the rows.

Merged cube sheets are entirely read-only. These sheets combine the data presence of other sheets to display calculated data.

Although the use case for cube sheets is modeling complex, multidimensional sales forecasting, you can use them for planning almost any multidimensional model.