Excel Template Subtask

To upload your data into the Import Budget/EACs from Excel utility, you must startby entering your project budgets/EACs into an Excel template formatted by Deltek for this purpose. A link to the template is available from the Excel Template subtask on the Import Budget/EACs from Excel screen.

To download the Excel template:

1. Click Planning » Project Budgeting » Controls and Utilities » Import Budget/EACs from Excel to display the utility.

2. Click the Excel Template subtask link.

3. In the Excel Template subtask, copy the URL and paste it into a web browser.

4. Save the template to your specified location.

To finalize the template for use in the Import Budgets/EACs from Excel utility, you must do the following:

1. Enter the budget/EAC data in the spreadsheet.

2. In Excel, save the template as an .xml data type. If you are unfamiliar with this process, refer to the Excel online help.

To be uploaded within the Import Budget/EACs from Excel utility, the .xml data must be available in a pre-configured location within Costpoint, referred to as an Alternate File Location. When you save the template as an .xml data, you must either save it to the Alternate File Location, or copy it there using File Upload on the Process menu. If you do not know the Alternate File Location, check with your System Administrator.