Forum Discussion
Linking Tasks to aggregate % complete
Can something like this be done? Probably, but without some VBA you won't be able to use the built-in % Complete field for the aggregated value, it will need be be shown in a custom field.
The first question is, what exactly is your definition of "aggregated % complete" (i.e. what is the formula)?
Excel has a much more open format with respect to linking cells. Since Project has a very specific data structure, linking information between tasks is very limited.
If you can provide a sample of your file structure, I can help you get what you want.
John
- By % aggregated complete, I mean the rollup % complete. The way a summary task's % complete is a roll up value of sub tasks % Complete. Just that in my situation, the tasks which should contribute to the aggregated % complete of the higher task, are not the sub-tasks of this higher task. They are physically distributed within the file.
In a normal world, Summary Task A, will have rolled up % Complete values of it's child tasks.
In my case, Summary Task A, wants to have it's % complete values from tasks which are not it's own child task, but are located elsewhere in the file, and are other summary tasks child.
Is there a way to do it ?- NKumar2010,
Okay, thanks for the full explanation, it's what I assumed but it's always good to check. And yes, I can develop a way to do it but I need more details. Would you be able to send me your file?
JohnAllow me to explain the complete scenario
Scenario :
There is a Master.mpp and Vendor.mpp
Master.mpp contains high level task, which roll up as summary tasks. Vendor.mpp contains low level tasks, which roll up as summary tasks.
Unfortunately, the summary tasks in Vendor.mpp does not neatly align to tasks in Master.mpp. Tasks in vendor.mpp only align logically to tasks in Master.mpp.Hence the challenge is how to get % complete for tasks in Master.mpp.
Duration of tasks in Master.mpp is bulk duration, which vendor.mpp tasks & summary task must adhere to.
Solution I thought :
If I take the tasks from Master.mpp and place it in Vendor.mpp say, as a Group Task 1) and link the summary tasks & subtask which are native to Vendor.mpp to the Group Task 1 to which they logically correlate, the % complete can flow up. But then, linking tasks just moves the dates, not % complete. Moreover, tasks from Master.mpp has larger duration, say 4 months, but the tasks in Vendor.mpp has duraiton in days & weeks. If we link them in any ways, what's the impact on duraiton of Group 1 tasks (i.e. Master.mpp tasks) ?Is there a simple solution to the scenario ? Am i overcomplicating a solution ?
Attached is the sample file. Since .mpp attachment is not supported, please rename the attached file from Sample.xls to Sample.mpp