Importing Cost Worksheet data
You populate the Cost Worksheet by importing two sets of data. Firstly, use the WBS and Control Accounts to create the worksheet structure, then import the Control Elements with budget and forecast data.
Importing WBS and Control Accounts
You can build an import file by exporting the current Cost Worksheet or downloading the template from the Import screen. There are a number of mandatory columns which you have to include.
The import file requires each row be classified as wbs or controlAccount in the Type column. You must also specify the Parent Code, which is used by the system to build the Cost Worksheet hierarchy. This code must exist in the file or in the Cost worksheet.
- Open the Cost Worksheet in Cost.
- Click Import in the toolbar and select Import from CSV.
For level 1 WBS or Control Account rows, you can use the special code <ROOT>.
- Click Download Template.
- Complete the template and save it.
- Click Browse to find your saved CSV file.
- Click Delete all existing records and replace if you want to use this data to replace any existing data.
- Click Import.
Example Import file
| Parent Code | Name | Code | Description | Type |
|---|---|---|---|---|
| [parent.code] | [name] | [code] | [description] | [_type] |
| Area A | A-000 | wbs | ||
| Area B | B-000 | wbs | ||
| A-000 | Area A-Sub Area 1 | A-000 | controlAccount | |
| A-000 | Area A-Sub Area 2 | A-000 | controlAccount | |
| A-000 | Area A-Sub Area 3 | A-000 | controlAccount |
For information about the Cost Worksheet calculation options such as percent complete method and forecast method, see Cost Worksheet Calculations.
Importing Control Elements
- Each Control Account can have one or more Control Elements assigned to it. See Cost Worksheet Calculations for information on how Control Accounts are added.
- Each Control Element stores budget and forecast information which can be imported. See Cost - minimum data requirements for importing data via CSV files for information on mandatory columns.
Note: Control Element Categories must be created in either Organization or Project Settings before they can be used.
Control Element types are defined when you create Control Element Categories and must be Cost, Hours, or Quantity.
- Go to the Control Element screen in Cost.
- Click Import in the toolbar.
- If required, download and complete the template
- Click Browse and select the import file.
- Click Delete all existing records and replace, if you want to use this data to replace all the data that may already have been entered.
- Click Import.
Note: Budget and Forecast information can be imported but is not mandatory.
Example Import file
| Control Account Code | Name | Type |
|---|---|---|
| [controlAccountCode] | [controlElementCategory.name] | [controlElementCategory.type] |
| A-001 | Concrete | Cost |
| A-001 | Demolition | Cost |
| A-001 | Disposal | Cost |
| A-001 | Fencing | Cost |
| A-002 | Concrete | Cost |
| A-003 | Concrete | Cost |
| A-003 | Demolition | Cost |
- You can import budget and forecast data unless change management has been required.
- Remember contracts which are added after the forecasts will reduce the Estimate to Complete. This means if you haven’t imported or created contracts yet, the Estimate to Complete should not be reduced yet.