概念：Excel Interface for Planning
Excel Interface for Planning
集功能与强大功能于一身 Adaptive Planning
使用 Excel。安装后
Excel Interface for Planning
，您可以打开任意 Excel 电子表格，然后单击 “Planning”
选项卡以连接到 Adaptive Planning
，以便您可以查看、输入和更新其中存储的数据。 Adaptive Planning
。
Excel Interface for Planning 功能
Excel Interface for Planning
功能具有
Excel Interface for Planning
您可以执行以下操作：- 连接到Adaptive Planning访问Adaptive Planning以在线显示的形式编辑 Excel 中的工作表，并加载所有数据、公式和格式。
- 刷新工作表 ，将即时更新加载到由其他用户更新的单元格中。
- 将更新提交至Adaptive Planning以便其他用户可以查看。
- 连接到OfficeConnect同时 从 Excel 工作簿在 Word 和 PowerPoint 中创建报告。
关键概念 Adaptive Planning
Adaptive Planning
这些基本概念可帮助您了解规划的工作原理。
实例和模型
“实例”是结构性组件的集合，定义了功能齐全的规划实体。实例有时称为“安装”，由一组账户、组织结构、维度、属性、工作表、版本、权限、会计年度和集成组成。Workday 允许使用多个 Planning 实例。
Think of your
instance
as how your business exists within Adaptive Planning
. It includes all your company's actuals and planning versions and all the related data, levels, and so on. The model
of your instance refers to the building blocks, (the accounts, levels, assumptions and formulas). Versions
There are 2 types of versions: actuals and plan versions. Actuals display real
numbers of sales and costs that have already happened. Most instances have 1 root
actuals. Your actuals can have more than 1 sub-version. Sub-versions roll up to the
root actuals.
Plan versions contain forecasted or budgeted data. You can have more than 1 plan
version.
假设
“假设”是所有用户在自己的计划中编写公式时都可以访问的全局值。假设可能会随时间而变化，并且在不同版本中具有不同的值，但在所有级别和每个账户中都具有相同的值。
Assumptions are often associated with user-assigned sheets. These sheets let you see and update data to which you normally do not have access. For example, expenses from the IT department are allocated to all other departments based on the number of computers in each department. The IT manager does not have access to enter data in departments outside of IT. With a user-assigned sheet, the IT manager can enter the number of computers for each departments. The data can be used to calculate the IT allocation.
层级
“层级”指的是您企业的组织结构。例如，层级可表示部门、利润中心、成本中心或地理区域。
Level access is the primary way your admin controls which users can see which data. The levels a user has permission to see dictates the data they can view and update. Levels also help you filter data displayed on sheets.
工作表
- Data Interface
- Adaptive Planningstores information, such as general ledger actuals, forecasts, personnel information and budgets.Sheetsprovide the interface for you to view, enter and update that data. WithExcel Interface for Planning, you access the online sheets through Excel.
- Values and Calculations
- Values you see in a sheet may be calculated with data that is not displayed on the sheet. Likewise, data you enter or calculate in a sheet can affect values displayed in other sheets.Adaptive Planningformulas can only be entered online. They are either embedded in the sheet's cell by an admin or you can enter the formulas yourself. You can also just enter data without calculations. InExcel Interface for Planning, you can tell that a value is calculated with anAdaptive Planningformula when the text is italicized and you can drill down to see how it was calculated.You can't enterAdaptive Planningformulas withExcel Interface for Planningfor your sheet, but you can use Excel formulas to calculate data. Although the end value is saved the online sheets, the formula you used will not be saved. You can add them to a cell note instead.
- Sheet Access
- Sheets or portions of sheets can be restricted, so you may not have access to all sheets within your organization. Or, you may see a sheet, but you may not see the rows or columns that other users can see on the same sheet. Or you may see the columns and rows and their data, but you cannot edit the cells. For example, a sales-related user may have access to the sheet's expenses, travel, and other sales-related data, but not the data used by the marketing department.If you think you should be able to enter or edit data that appears locked, be sure you are accessing the correct version and the correct level of the sheet. If the problem persists, get clarification with your admin on your user permissions.
启用 Excel Interface for Planning 您的实例
Excel Interface for Planning
您的实例 安装后
Excel Interface for Planning
，请在 Workday Customer Center 中提交支持工单，为您的实例启用加载项。之后，您可以登录并开始使用该加载项。如果 Excel Interface for Planning
已为您的实例启用“Planning”，则您可以登录并从 Excel 功能区的 “Planning”
选项卡中访问它。