Hours
Featured Partner
Top Posters
Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Jeamiell Ostrovsky
2 posts
Our Partners
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
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
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
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?
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.