A planning workbook consists of a header and a hot area. The header consists of the following elements:
Title of the workbook
Data source information such as system, user and client
Selected values of selection options
Buttons to execute functions on the planning data
The hot area shows the selected data.
You can add new plan data records at the lower end of the hot area, and you can add lines and columns around the hot area, that is, not within the hot area.
In the plan data cells, you can refer to other parts of the workbook by using the classic Microsoft Excel
tools.
You can also combine multiple queries within a single workbook.
After you have entered the planning data, press the Save
button. This recalculates and saves the data to the backend system.
If you want to start planning from scratch, press the Clear Plan
button. This empties all the input cells.
If you want to go back to the latest saved state in the back end, press the Back to Saved State
button. This overwrites all entries in the input cells for the plan data with the saved plan data from the back end.
In general, you do not start planning from scratch but with the actual data from the previous fiscal year. To do so, press the Copy Actual to Plan
button to populate the input cells for the plan data with the actual data from last year.
If you enter a value and want to aggregate and/or disaggregate across the dimensions, press the Recalculate
button.
You can also access the functions that are available in the header section from the Analysis
ribbon at the head of the Microsoft Excel
screen.
To do this, do the following:
In the File
menu, select Options
and then Customize Ribbon
.
In the right-hand pane, press New Tab
and enter a name. Optionally, you can add a new group to the tab.
In the left-hand pane, select Macros
from the list box and navigate to the macros that are provided by Analysis Office
. The following macros are available:
onClickPrompt
onClickSetVariables
onExecuteFYCopy
onExecuteFYInit
onExecuteFYRecalculate
onExecuteFYSave
Mark the corresponding macros and then press Add
. This adds the selected macros to the tab you just created. You can overwrite the name of the macros.