You can export the details of a budget or forecast version to a Microsoft Excel spreadsheet by selecting the Edit In Excel option. When you choose this option, Oracle Projects automatically populates an Excel spreadsheet with the planning elements (tasks and planning resources) and plan amounts (quantities, costs, and revenues) for the selected version.

You can perform the following activities in Microsoft Excel:

• Edit and enter budget or forecast lines

  You can edit existing budget or forecast lines and add new lines together with all necessary information including descriptions, change reasons, and conversion attributes.

  Note: If a field is disabled for amount entry in the Amount Entry planning options, you can still enter an amount for the field in a Microsoft Excel spreadsheet. However, Oracle Projects will ignore the amount when you upload the spreadsheet back to Oracle Projects.

• Enter amounts in multiple currencies

  To enter amounts in a different transaction currency, first insert a new row into the spreadsheet. Next, copy the appropriate planning elements and attributes from an existing budget or forecast line to the new row. After you copy the planning elements and attributes, select a currency for the new line and enter the budget or forecast amounts.

  Note: Before you can add a line in another transaction currency, you must define the new currency in the Add Transaction Currencies table on the Currency Settings page for the plan version.

• Delete budget or forecast lines

You can edit the following budget and forecast information in a Microsoft Excel spreadsheet:

• Budget/forecast quantity and amounts

• ETC quantity and amounts

• Cost and bill rates

• Dates for new budget or forecast lines for non-periodic plan versions

• Currency conversion attributes for project currency and project functional currency

• Change reason codes and descriptions for non-periodic plan versions

When you download a budget or forecast version to a Microsoft Excel spreadsheet, Oracle Projects includes the following planning resource attributes for information purposes only:

• UOM

• Spread Curve

• Cost Type

• ETC Method

You cannot modify planning resource attributes within a spreadsheet. When you upload new budget or forecast lines from a Microsoft Excel spreadsheet to Oracle Projects, Oracle Projects derives attribute values for the new plan lines based on the default values associated with each planning resource.

You cannot modify the start or end date for existing planning element in Microsoft Excel spreadsheet

You can edit a Microsoft Excel spreadsheet in either online or offline mode.

• In online mode, you are connected to Oracle Projects and can make use of lists of values to populate certain key fields such as Task, Planning Resource, and Currency.

• In offline mode, you must enter values for all required fields.

Downloading Plan Versions to Microsoft Excel Spreadsheets

You can download budget and forecast versions to a Microsoft Excel spreadsheet at either the plan version or project level. You can download a budget or forecast version for a project from the Project Home page. When you choose to download a budget or forecast from the Project Home page, Oracle Projects selects either the current working version of an Approved Budget plan type, or the current working version of a Primary Forecast plan type, as appropriate.

Oracle Projects enables you to download periodic budget and forecast lines to a non-periodic spreadsheet layout. When you download periodic lines to a non-periodic layout, Oracle Projects sums all periodic lines into a single, non-periodic plan line for each task, planning resource, and currency combination. When you upload non-periodic lines from Microsoft Excel back to an Oracle Projects plan version that is time-phased by period, Oracle Projects automatically distributes the amounts for each line across periods based on the spread curve associated with each planning resource.

Uploading Microsoft Excel Spreadsheets to Oracle Projects

When you complete your updates to a plan version in Microsoft Excel, upload the spreadsheet to Oracle Projects by choosing the Oracle > Upload menu option from the Microsoft Excel menu. Oracle Projects validates all attributes and amounts during the upload process.

When you choose to upload a spreadsheet, Oracle Projects performs the upload either as an online step, or by submitting the concurrent program PRC: Upload Financial Plan Data from Microsoft Excel. Oracle Projects determines whether to perform the upload online or as a concurrent program based on the settings of the following two profile options:

• PA: Process MS Excel Data

• PA: Process MS Excel Data Threshold

Other Sources

• Budget Change Reasons, Oracle Projects Implementation Guide

• Implementing Integration with Microsoft Excel, Oracle Projects Implementation Guide

• PA: Process MS Excel Data, Oracle Projects Implementation Guide

• PA: Process MS Excel Data Threshold, Oracle Projects Implementation Guide