Show TOC

Function documentationPlanning Workbook Structure

 

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.

Activities

The Buttons
Save

After you have entered the planning data, press the Save button. This recalculates and saves the data to the backend system.

Clear Plan

If you want to start planning from scratch, press the Clear Plan button. This empties all the input cells.

Back to Saved State

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.

Copy Actual to Plan

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.

Recalculate

If you enter a value and want to aggregate and/or disaggregate across the dimensions, press the Recalculate button.

The Ribbon

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:

  1. In the File menu, select Options and then Customize Ribbon.

  2. In the right-hand pane, press New Tab and enter a name. Optionally, you can add a new group to the tab.

  3. 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.