Hopefully someone can help
I have exported from the resource and resource assignments from p6 into excel
and i have changed a number of the quanitites (ensuring the numbers remain as labels)
however, when i import the excel file back in,it only seems to populate 1 resource against each activity, ignoring the others
can anyone advise
thanks
Simon Hegarty
not sure what you mean by resource type but if you are saying that you have two DIFFERENT resource names with the same type or resource such as LABOR I do not see how this is possible.
However if you are saying that you have 2 of the SAME resource names with the same type of resource such as labor then go to Projects directory
make sure that your project is highlighted
click on Resources and at the bottom right make under Resource Assignments sure that Resources can be assigned to the same activity more than once is NOT checked.
Zolton
Many thanks for your response, having gone through your check list it appears to have worked!
I can now import multiple resources against individual back in from excel now as long as the resource types are different.
The only issue now is it still doesnt work if the resource type is the same.
However, your solution has provided me with a possible alternative way, so many thanks Zoltan.
make sure that you have the rights to import resources
make sure that the duration is not zero
make sure that calcualte costs from units is NOT checked
when importing ONLY import resorce ASSIGNMNETS becasue the resource is already there
Sometimes I have also faced this trouble especially with new assignments. So I used to ensure all of the resources are assigned to all activities and keep budget labour unit as zero.
Later we can update the budgeted labor units based on the weight factor and this we can import. Sometime this will also not work properly; then just re-import the same few times.
The activities with zero budgeted labor can be removed at later stage.