Trevors solution is actually not so time consuming. Have the "as planned" programme in a seperate programme. Adjust the Status Date, get the hours as Trevor suggest and then copy/paste the whole column over in one go (requires the same order of ID, but that is easily done).
Anyway, formula for a customized field could be something along the lines of:
Just get the "as planned" version of your plan, before any updates were made to it, set the status date, select the tasks that should (ie were planned to) have started by the status date, and click the "Update as scheduled" button on the tracking toolbar. Then see Actual Work in the Tracking Table.
Also, in MSP2003 you can use the Analysis Toolbar to export the Cumulative Work, same thing.
Member for
15 years 9 monthsRE: Hours
I changed the formula a bit,
IIf([Status Date]>[Baseline Start];IIf([Status Date]>=[Baseline Finish];[Duration]/60;ProjDateDiff([Baseline Start];[Status Date])/60);0)
Now I can see the planned value up to status date
Thanks
Bo and Trevor
Regards
Dan
Member for
15 years 9 monthsRE: Hours
Hi Bo,
This is exactly what I am looking for! Thank you!
When I am working with a lot activities I think this is a nice way of getting a good look for each activity.
I am not saying that the other way is bad; I just think this is easier.
Regards
Dan
Member for
19 years 8 monthsRE: Hours
Trevors solution is actually not so time consuming. Have the "as planned" programme in a seperate programme. Adjust the Status Date, get the hours as Trevor suggest and then copy/paste the whole column over in one go (requires the same order of ID, but that is easily done).
Anyway, formula for a customized field could be something along the lines of:
IIf([Status Date]>[Start];IIf([Status Date]>=[Finish];[Duration]/60;ProjDateDiff([Start];[Status Date])/60);0)
Regards,
Bo
Member for
15 years 9 monthsRE: Hours
Hi Trevor,
This is a good way of doing it, but when the plan contains 2000 activities this way is very time-consuming.
What I wish for is that have a column that can show me this all the time for each task and summery.
Any more ides?
Member for
19 years 11 monthsRE: Hours
Just get the "as planned" version of your plan, before any updates were made to it, set the status date, select the tasks that should (ie were planned to) have started by the status date, and click the "Update as scheduled" button on the tracking toolbar. Then see Actual Work in the Tracking Table.
Also, in MSP2003 you can use the Analysis Toolbar to export the Cumulative Work, same thing.