MS Project Planned % vs Actual % completion- The MS Project file is inside the zip file, unzip the file and use the MS Project file that already has the custom fields built in which calculates the planned % completion.
Download the Microsoft Project File with the custom fields and formulas already updated for ready to use for your project plan. Why do we need Planned % completion in MS Project? Well, in MS Project we have a default column % completion which is manually updated by the PM. However if we want to know what should be the planned % complete for that task and how it track against the actual % complete then we need to calculate the Planned % complete value.
Ex. If you have a task that starts on Monday and ends on Friday. So the total task duration is 5 days, that means ideally each day 20% of the work should be completed to reach 100% by end of Friday. So the custom field “Planned % Complete” will calculate that for each task with the formula I included in the file, so that when you receive the actual % completion value from your team you would be able to compare and it against the calculated planned % complete to identify whether the task is running late or ahead. For any assistance or questions regarding the MS Project downloadable template contact via the contact page or reach out via email: email@example.com and I will be happy to assist.
Updated formula to calculate Planned % complete for Summary tasks & Milestones.