Using the Offline Planning Interface

Exploring the Offline Planning Interface

The interface along with a downloaded template is displayed below.

Each of the fields and the functionality available in Offline Planning is described below.

Budget Plans - Click to launch a dialog page where you will select the scenario, entity, and template to download. Open multiple templates for a Budget Entity in the same Excel Workbook.

Sync - Saves budget data to the Planful application.

Sync and Read Only - Saves data back to the online application and prevents other users from editing the changes. For example, download content to your template, update the spreadsheet with data, and sync and retain the data so that the entity and page level parameter combination remains locked or in read-only mode for other users.

Refresh - Updates the template with the latest data from the online application.

• Refresh Compare Scenario and History – Updates the template with the latest data from the online application based on historical data and comparative scenarios added to the template.
• Refresh – Updates the template with the latest data from the online application based on reference measure, account, or reference account.

Disable Editing / Enable Editing - When the spreadsheet is in read-only mode, the Enable Editing button is displayed. When the template is in edit mode, the Disable Editing option is displayed.

• Enable Editing – Click to convert the template to edit mode. This action checks whether this combination is locked by any other user. If not locked the system converts the template to edit mode and locks the combination in the online application.
• Disable Editing – If the template is in edit mode, click to convert the template to read-only mode.

Global Field - Available when Global Fields are set up for the selected template. To apply a global field, select one or more cells and click the Global Field option or right-click from a cell and select Global Field.

Forecast Method - Available when Forecast Methods are set up for the selected template. To apply a forecast method, select one or more lines and click on Forecast Method or right-click from a cell and select Forecast.

Grid Lines - Enable or disable gridlines for the active template.

Freeze - Enable or disable freeze panes for the active template.

Save - Saves changes to the working spreadsheet. Changes are saved to the online application ONLY when synced.

Close - Closes the spreadsheet and unlocks the combination in the online server.

• Once closed, the template is no longer available in offline mode.
• Synchronization happens depending on the action you select.

Template Grid Explained Below

Last Checked Out - A timestamp of the date and time the template is downloaded is provided at the top of every template.

Spreads - Displayed in the template when spreads are set up during template configuration.

Compare Scenarios - Displayed in the template when compare scenarios are set up during template configuration.

Sublines - The L line shaded in green indicates there are sublines.

Attributes - Displayed in the template when set up.

Template Columns - Template columns typically include the following information:

• Attributes that allow you to enter drivers for the calculations in the template.
• Spread columns that allow you to enter an annual amount and to display the spread method used to distribute the annual amount to month columns. You can also choose manual spreads to input data by month.
• Compare scenarios that display data from other scenarios such as historical actuals, last forecast, and prior budget.

Input and Summary columns for the budget/forecast that allow you to enter budgets/forecasts.

Budget Input - Budget Input can be made against line type (L) rows. The yellow shaded cells represent data input cells as in the Planful application. You can add notes to template lines from both the online Planful Budget application and the Offline Planning Workbook. To add notes, click N in Column L.

Structuring an Offline Planning Template

The basic structure of the template in the Excel client and its usability is the same as in the online application.
Templates contain the following:

• Template Header, which displays the following information:
  • Scenario name (example: 2011 Budget final)
  • Entity name (example: 1000 - Administration)
  • Template name (example: Operating Expenses)
  • Currency (example: US Dollars)
• Template Lines, which are the line items that are included on the template.
  • Template lines can be optionally locked by the administrative user designing the template so that calculations specified against line items are protected preventing end users from modifying. These lines are called Calculated (C) lines.
  • Template lines can also be mapped to the chart of accounts so that the budget data entered by end users can be saved against the appropriate string that confirms with the organization’s chart of accounts. These account mappings are also used to display historical actuals within the template.
  • Template lines can optionally have the following types of account mappings:
    • Destination Account Mapping - Destination accounts are mapped for each line against which the budget data entered or calculated on the template and needs to be saved to the application against appropriate accounts in the chart of accounts. Full destination account mapping is derived through COA mapping (derived from the workflow) and Destination account mapping against template lines defined during template setup.
    • Reference Account Mapping - Referenced accounts are used for linking the templates and to pull the numbers from other template(s) to display a more complete picture of the budget and/or to drive the calculations based on the budget inputs in another template.
    • Reference Cube Mapping - Referenced cube is a variant of the Reference account functionality that opens complex referencing which requires calculations or aggregations from the OLAP cube.
• Template Columns, which typically include:
  • Attributes that allow users to enter drivers for the calculations in the template.
  • Spread columns allow users to enter an annual amount and to display the spread method used to distribute the annual amount to month columns; users can also choose manual spreads that allow them to input data by month.
  • Compare scenarios that display data from other scenarios such as historical actuals, last forecast, and prior budget pass, etc.
  • Input and Summary columns for budget/forecast that allow end users to enter budgets/forecasts.

Generating Offline Planning Audit Logs

An audit log is automatically created for Offline Template user actions. Access the audit log by navigating to Maintenance > Application Audit > View Audit Log.

Version Control in Offline Planning

Version control is handled in Offline Planning with a check-out time stamp. When you have multiple offline planning workbooks with the template opened in check-out mode, you can identify which template needs to be synchronized to the online application.

Whenever a template is checked out, a server-based time stamp is displayed on the spreadsheet.

If there are two versions of the template opened in check out mode, the system will display a message when a user is trying to synchronize a non-current version of the template.

Control may be lost for template sheets that appear to be in the check out mode in the offline application if a user initiated an Undo Check Out action. In this situation, the offline template may not be synchronized.

Cross Sheet Reference Account Data Update in Offline Planning

Indicate whether or not you want the system to automatically populate the updated reference account line data in dependent templates without connecting to the online template. For example, if you have two templates checked out for offline input with reference mapping (one template referencing data from another), you can automatically populate the reference account line data, or not, based on performance needs.

By default, this option is disabled when the Offline Planning feature is enabled for you. To enable this option, access the Security Administration page by navigating to Maintenance > Administration > Security Administration. When you enable this option, a message is displayed indicating possible performance implications.

When you have multiple templates downloaded to offline Excel for a budget entity with a time set mapping, references to and from the other templates will not honor the cross sheet reference setting. You must sync & refresh the template to update reference data.