跳至主要內容
文件
文件
Adaptive Planning
上次更新時間 ：2023-06-23
概念︰Excel Excel Interface for Planning

概念︰Excel 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

這些基本概念可幫助您了解規劃的作業方式。

實例和模型

「實例」是結構性組成元素的集合，用於定義一個功能齊全的規劃實體。
實例又稱「安裝」，是由單一的一組科目、組織結構、版本、維度、屬性內容、工作表、權限、會計年度、整合等所構成。
Workday 允許有多個規劃實例。
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 Planning
 stores information, such as general ledger actuals, forecasts, personnel information and budgets.
Sheets
provide the interface for you to view, enter and update that data. With
Excel 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 Planning
 formulas 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. In
Excel Interface for Planning
, you can tell that a value is calculated with an
Adaptive Planning
 formula when the text is italicized and you can drill down to see how it was calculated.
You can't enter
Adaptive Planning
 formulas with
Excel Interface for Planning
 for 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
，在Workday Customer Center 建立支援個案，為您的實例啟用外接程序。之後，您即可登入並開始使用外接程式。如果
Excel Interface for Planning
已為您的實例啟用，您可以登入並從 Excel功能區的
Planning
分頁存取該實例。