Starbuck1975
Lifer
Have a question on how to establish conditional predecessor relationships between tasks in Microsoft Project.
Let us assume for a moment that you have a series of sequential and discrete tasks, with the task culminating in the delivery of x number of an item.
Task A; Quantity Delivered = 2; Total Quantity Delivered = 0 + 2 = 2
Task B; Quantity Delivered = 4; Total Quantity Delivered = 2 + 4 = 6
Task C; Quantity Delivered = 2; Total Quantity Delivered = 6 + 2 = 8
Task D; Quantity Delivered = 6; Total Quanitity Delivered = 8 + 6 = 14
Now let's say you have another task M. You cannot start task M until you have a total quantity delivered of 10 items. In the case above, the predecessor for Task M would be Task D.
Now this is the challenge I am facing. If the quantites delivered during Tasks A thru D remained the same over time, all I would have to do is create all of these tasks in Project, determine during which task the total quantity delivered equals or exceeds 10, and then make that tasks the predecessor to Task M. Taking the above example, and changing the quantities delivered for each task:
Task A; Quantity Delivered = 8; Total Quantity Delivered = 0 + 8 = 8
Task B; Quantity Delivered = 4; Total Quantity Delivered = 8 + 4 = 12
Task C; Quantity Delivered = 2; Total Quantity Delivered = 12 + 2 = 14
Task D; Quantity Delivered = 6; Total Quanitity Delivered = 14 + 6 = 20
In this case, the predecessor to task M would now be Task B.
Unfortunately, the quantity delivered during Tasks A thru D do not remain constant over time. In fact, I want to have the capability to play what if on delivery quantities and see what happens to Task M. Similarly, this simulation models behavior that replicates itself thousands of times...which makes manual updates a bit tedious.
So this is what I want to do. I want to be able to load Tasks A thru D into MS Project, along with the quantities delivered at each task.
I want to set up a conditional relationship for task M such that its predecessor is established by when the total quantity delivered for tasks A thru D equals or exceeds 10.
The logic stream would work something like this
Total Quantity Delivered = 0
For i = A thru D
Total Quantitiy Delivered = Total Quantity Delivered + Quantity Delivered (i)
If Total Quantity Delivered >=10 then
Predecessor for Task M = i
I am not sure if you can establish logic flows like this for MS Project through Visual Basic or otherwise.
Any pointers? Thanks you in advanced.
Let us assume for a moment that you have a series of sequential and discrete tasks, with the task culminating in the delivery of x number of an item.
Task A; Quantity Delivered = 2; Total Quantity Delivered = 0 + 2 = 2
Task B; Quantity Delivered = 4; Total Quantity Delivered = 2 + 4 = 6
Task C; Quantity Delivered = 2; Total Quantity Delivered = 6 + 2 = 8
Task D; Quantity Delivered = 6; Total Quanitity Delivered = 8 + 6 = 14
Now let's say you have another task M. You cannot start task M until you have a total quantity delivered of 10 items. In the case above, the predecessor for Task M would be Task D.
Now this is the challenge I am facing. If the quantites delivered during Tasks A thru D remained the same over time, all I would have to do is create all of these tasks in Project, determine during which task the total quantity delivered equals or exceeds 10, and then make that tasks the predecessor to Task M. Taking the above example, and changing the quantities delivered for each task:
Task A; Quantity Delivered = 8; Total Quantity Delivered = 0 + 8 = 8
Task B; Quantity Delivered = 4; Total Quantity Delivered = 8 + 4 = 12
Task C; Quantity Delivered = 2; Total Quantity Delivered = 12 + 2 = 14
Task D; Quantity Delivered = 6; Total Quanitity Delivered = 14 + 6 = 20
In this case, the predecessor to task M would now be Task B.
Unfortunately, the quantity delivered during Tasks A thru D do not remain constant over time. In fact, I want to have the capability to play what if on delivery quantities and see what happens to Task M. Similarly, this simulation models behavior that replicates itself thousands of times...which makes manual updates a bit tedious.
So this is what I want to do. I want to be able to load Tasks A thru D into MS Project, along with the quantities delivered at each task.
I want to set up a conditional relationship for task M such that its predecessor is established by when the total quantity delivered for tasks A thru D equals or exceeds 10.
The logic stream would work something like this
Total Quantity Delivered = 0
For i = A thru D
Total Quantitiy Delivered = Total Quantity Delivered + Quantity Delivered (i)
If Total Quantity Delivered >=10 then
Predecessor for Task M = i
I am not sure if you can establish logic flows like this for MS Project through Visual Basic or otherwise.
Any pointers? Thanks you in advanced.
