Sample Format for Loading Activity and Resource Assignment Data

The table below provides a sample format for loading activities and resource assignments.

Table 1. Sample Format for Loading Activity and Resource Assignment Data
WBS WP OBS Baseline Start Date Baseline Finish Date Progress Technique Resource Hours Direct
1.1 1.1.1 MGT 8/15/2016 8/15/2018 % Complete DRAFT 456 0
1.1 1.1.1 MGT 8/15/2016 8/15/2018 % Complete MANAGER 320 0
1.1 1.1.1 MGT 8/15/2016 8/15/2018 % Complete SENG 124 0
1.1 1.1.1 MGT 8/15/2016 8/15/2018 % Complete TECH 459 0
1.2 1.2.1 ENG 8/20/2016 8/20/2018 Milestones MANAGER 251 0
1.2 1.2.1 ENG 8/20/2016 8/20/2018 Milestones TECH 321 0
1.2 1.2.1 ENG 8/20/2016 8/20/2018 Milestones DRAFT 546 0

The import file must contain a new row for each resource assignment in a work package. Rows 2-5 of the sample will create Control Account 1.1 and Work Package 1.1.1 with four resources assigned to them and the required hours listed in the Hours column. All results used by the resource calculations are available as columns, which can be loaded from the import file.