How to cost-load a schedule using Excel export and import
I want to export a schedule to Excel, cost-load the activities there, and then import it back into the schedule. How is this accomplished?
I know how to load non-labor costs in a schedule manually. I use a non-labor resource "Lump Sum." I also know how to export the schedule as an xls. But I can't get the costs to import back into the schedule after I've added them in Excel.
Thanks,
Rob
Hi Rob,
What fields are you exporting and updating inExcel? Are you exporting the cost fields from the "Resource Assignments" data?
For example, if you have a nonlabor resource called "Cost" assigned to an un-started activity, export out the "Budgeted Cost" field from the "Resource Assignments" data area. After editing the budgeted cost in Excel and importing back into P6, the nonlabor cost should be updated to whatever you entered in Excel.