Good day experts,
I have several projects running which are all scheduled using Microsoft Project 2010 Professional.
I want to confirm the best way to track progress against the schedule. I currently have an Excel table listing each project with start date, end date and current date. I use Excel to calculate the percentage of project duration completed. For example, if the project lasts 20 days and we are 10 days passed the project start date, then 50% duration has passed. I then feed into the Excel sheet the amount of work percentage completed from the project schedule.
This is not the best way to do it because 50% of time passed doesn't necessarily mean that 50% of the work must be completed.
The ideal solution for me would be to get two measures from the project schedule iteself:
- Percentage work that should have been completed on current date
- Percentage work that is atually completed on current date
Please advise on best way to achieve this