I have 40 milestones to complete a task within my project (all task have same number of milestones). Each milestone take different time to be completed. Some just take one day to finish, and some take up to 3 weeks to get done.
I want to calculate the % completion of each task and put them in my report.
Could you please advice if there are any formula to calculate this?
Your guidance will be very my appreciated.
Best Regards,
sanlen Saving Changes...
Sort By:
Rakesh TrivediSenior Project Manager| IT CompanyIndore, Mp, India
There are two answers for this -
- Generally, global rule is that someone has to put % completion of task manually or if put no of hours spent on the task and you get % completion of the task. Microsoft project plan provides this facility.
- Another is that you can link timesheet with your document ( may be excel) where task are defined and allow developer to put effort spent on task then insert macros in original sheet
Anyway the formulae for
% completion till date=(No. of hours spent on task till date / total no of hours estimated for task )*100.
I hope this would answer you question.
Saving Changes...
Bruce LoflandSoftware Developer| SprintLenexa, Ks, United States
Do you want to show % complete of schedule or % complete of milestones? If you are trying to show % of effort, then it appears that measuring schedule would work best as an approximation of effort.
Plan the duration for each milestone for each task. Track the actual duration for each milestone. The mile stone is either complete or it isn't. A three week milestone that is in progress but not complete could be set to 50% complete.
Add up the duration for all complete milestones and divide by total duration (complate and incomplete) for all milestones to get the percent complete.
This is fairly easy to do in MS Project. There your "milestones" would be called tasks and your "tasks" would be called summary tasks. Link the milestones finish to start and adjust the duration as needed. Mark the percent complete for each one to be 0/50/100%. The aggregate % complete for all tasks will appear in the proejct summary task.
Thanks all for comment and advice. They are very useful for me.
One more thing that i am still having doubt about is do i have to count the gape of time between one milstone and another milestone?
i.e: milesone1 take up to 3 days to be completed (8h/day). and before milestone2 can be started, teams need to come back to the office and prepare reports submit for signature. This will take at least another 3 days to get the approval. Travelling from site to the office it take another 1 day.
How i am going to count the duration to complete milestone1? is it 3 day? or 3 days + 1 day (travelling)? or 3 days + 1 day + 3 days (approval)?
Thanks,
Saving Changes...
Rakesh TrivediSenior Project Manager| IT CompanyIndore, Mp, India
Valid point Sanlen, See duration of any milestone is summary of all task under that Milestone as suggested by Bruce thus all the subtask under that Milestone Task will count for effort.
Now in your peculiar case in picture if you have planned to include 1 day traveling + 3 day approval for said Milestone then it has to taken into consideration otherwise will fall into some other task/milestone.
Btw, I think both these task should come under mentioned Milestone , hope Bruce will be inline with that .
Saving Changes...
