hello everybody,

I have a little problem allocating cost accounts on my project.
see, I have a complete P3 project, with activities, resources, budgeted quantities, and due to the number of resources (700), I’d rather track the progress (yes, we need to track the progress with MSExcel) with cost accounts. I only use them as resources groups, to export tabular reports to DBF files.

the thing is, some of the tasks have multiple resources (2 max), and I need to allocate one cost account to one resource and another cost account to the other resource.
doing this task by task is quite easy, but I happen to have 21.000 activities in my project, so I tried to use global change.
the problem with the global change is that it allocates the cost accounts with the "last to talk is right" principle. the first global change allocates the first cost account to both resources (I specified a filter to update only the good resource, but it selects both each time), and the second global change does the same, but with the second cost account...

I also tried exporting to DBF, updating in MSExcel and importing back into P3, but it adds to my tasks a new resource (duplicated from the original one) containing the good cost account, but I now have 3 resources in my task... the 2 original plus the new one.

does anybody have a solution to this problem ? because the multiple resources concern like 6000 tasks, and I cannot afford to bypass at least 18000 hours in my progress figures...


thanks to anyone who knows !


Johnny