MS Project Template


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: and I will be happy to assist.

Download MSP File

Updated formula to calculate Planned % complete for Summary tasks & Milestones.

12 thoughts on “MS Project Template

  1. From the template , can i calculate the % baseline work simce the project started..1 year ago

    1. The link to download should have been in the email that’s shows the purchase receipt. If you haven’t seen the link or haven’t received the payment receipt email let me know. Either way let me send it you manually right away, give me few minutes to send it to your email.

Leave a Reply to Abu Yazid Abu Husin Cancel reply

Your email address will not be published. Required fields are marked *