Offline Planning

Planful Excel Planning Workbook (also referred to as Excel Client or Offline Planning) for budgeting is a Microsoft Excel Add-In that provides functionality to open templates in Excel for budgeting purposes.
Offline Planning provides functionality so that you can:

• Open and download templates (GTSC) to work with when offline.

• Refresh data from the online application.

• Synchronize changes or save data back to the Planful application.

• Open multiple templates of a selected budget entity and scenario in Excel.

Prerequisites for Offline Planning Workbook

To use Offline Planning, you must have the following components:

• Office 2010 or above

• VSTO 4.5.2 Runtime SP1 (Visual Studio Tools for the Office)

1. Enable Planful URL in Trusted Sites ... or...

2. Unblock in Excel Properties

In Practice: Enable Planful URL in Trusted Sites

1. Open Internet Explorer.

2. Click the gear icon and select Internet Options.

3. Click the Security tab.

4. Click Trusted sites.

5. Click Sites.

   

6. Add the following website https://*.planful.com as shown below.

   

In Practice: Unblock in Excel Properties

1. Select the Excel file and right-click.

2. Select Properties . The Properties dialog page appears with the General tab selected by default.

3. Click Unblock and then click Apply.

   

Providing User Access to Offline Planning 

Users must be given access within Planful. To do so, complete the steps below:

1. Navigate to Maintenance > Admin > User & Role Management.

2. Select the user.

3. Click directly on the security options icon within the user's Security column, or click the security options icon in the header.

4. Select Add-In Security.

5. Select the Planful Offline Planning Add-In.

6. Find the user in the Unmapped User's pane.

7. Select the user.

8. Click the forward arrow to map the user to the Mapped Users pane.

9. Click Save.

Downloading the Excel Planning Tools and Workbook

Navigate to Maintenance > My Settings > Components.

You must have Add In Security access to see the downloads for the Excel Planning Tools and Workbook located here in Maintenance, My Settings, Components. to obtain access, navigate to Maintenance, User Management, More, Add In Security.

Downloading Planning Tools

Click the Download link and follow the instructions on the dialog page. You will receive a series of informative installation dialog pages.

Downloading the Planning Workbook

Click the Download link and follow the instructions on the dialog page. The Application URL and User Name information is pre-populated.

Save the file to a selected folder on your computer and then open the workbook for input.

Managing Access to Offline Planning and Templates

To access Offline Planning, login using the Login dialog page, which is opened when you access templates or save the templates in Excel.

On the login page, complete the following information:

1. Enter your User Name.

2. Enter your Password.

3. Enter the Application URL (example, https://epm.planful.com).

4. The Application drop-down list displays a list of applications that you have access to. Select an application.

5. Click OK to login.

Budget Templates are available for budget users based on the User Access Role Security Setup performed in the online Planful Budget application by the Application Administrator. Administrators can edit user access to approval roles using the Approval Role page.

Selecting a Budget Plan and Downloading a Workbook

On the Select Budget Plan page, complete the following:

1. Application Area - Defaulted to Planning.

2. Scenario - Select the scenario in which your Admin user has provided you with access.

3. Budget Entity - Select the entity as you would in the Hierarchy in the Planning Control Panel.

4. Template - All templates mapped to the entity are displayed. Select the template you want to download.

5. Click Download to download the template.

6. Continue to download templates as needed from the same budget entity to the same workbook.

You can open multiple templates at a time in a single session. Templates open in view/read-only mode by default.

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 remain 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 budget template.

Freeze - Enable or disable freeze panes for the active budget 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 allows 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 same as in the online application.
Budget 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 budget template.

  • Template lines can be optionally locked by the administrative user designing the template so that calculations specified against line items is 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 budget 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 budget templates and to pull the numbers from other budget 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 that 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, Admin, 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.