i have one project with baseline & update with percent complete as Physical. I was showing the project progress as Schedule % complete VS performance % complete.Now i have changed the percent complete as duration.
please tell me how to show the project progress in terms of duration.
There is always more than one way to skin a cat
another tool thats wil do this for you is project tracker
Thanks ZOltan Plaffy.
I think this method will work out.
lets say your project started in January and it is now the end of March
you have baseline with no progress and u have an updated schedule with progress thru March
go to the baseline count the total number of activities lets say it is 100 to get the total number of activities
add a column for number of activities and when you group and sort select show grand totals
now in the baseline filter for activities where the finish date is less than whatever your data date is in your current schedule
in this example filter where finish is less than March 31, 2106 and lets say that the total activities in this filter is 10 so 10/100 is 10% so your planned number of activities to be completed is 10%
now go to your updated schedule (do not include any new activities such as change notices)
and filter where actual finish is less than DD or March 31, 2016 in our example. Now lets say that the total number of activities completed is 5 so 5/100 is 5%. That means that you are ACTUALLY 5% complete.
so the planned % complete is 10% and the actual is 5% this is totally based on the number of activities total, planned to be completed by a certain date and the number of activities actually completed by the data date
what you are not getting credit for are activities in progress meaning that they have started but are not yet complete.
so if you wanted to you could change your filters and add another parameter that includes actvities where % complete is within the range if 1 and 99. This wil pick up in progress activities
so your filter in the updated scheudle would be
filter for any
where actual finish is less than DD or March 31, 2016
or
where % complete is within the range if 1 and 99
It cant be evaluated as linear % because in the baseline, It wasnt planned to finish 30%(lets say) at the end of 3 months for a 10 month project.
In the beginning the palnned activities are less.
That is why i am facing this problem to show the Planned VS actual with duation % complete.
Provide any other solution please.
you need to have resources to measure something against
or you can have a summary bar that rolls up the entire schedule
or you can do it on a linear % complete over time
lets say you have a project that is 10 months long so based on time after the 3rd month you should be 30% complete.
that would be your planned progress
now your actual progress shows that you are behind schedule by 1 month so now the overall duration of the project is 11 months and you are actually 20% complete
planned 30%
actual 20%
straight linear based % complete as it relates to time.
or you can use project tracker to give your percentages
http://www.willmer.co.uk/projecttracker
i have already change all the physical % cmplete to duration % complete by a global change.
how can i show the project progress (plan vs actual) by duration % complete ?
i have already change all the physical % cmplete to duration % complete by a global change.
how can i show the project progress (plan vs actual) by duration % complete ?
run a global change
where
physical % complete is greather than 0
then
duration % complete = physical % complete