How to Calculate Percent Duration Variance in Microsoft Project - Easy Trick!
Hey there! In this blog post, I’ll guide you through the process of creating a custom field in Microsoft Project that will help you calculate Percent Duration Variance for each task. This handy feature allows you to easily understand and visualize how your project tasks are progressing in relation to their Baseline Duration values.
If you would rather watch a YouTube video on this subject, click here or click the thumbnail below.
Percent Duration Variance Calculation: How Does it Work?
Before we dive into creating the custom field, let’s briefly talk about how Microsoft Project calculates Duration Variance. It’s quite simple. Duration Variance is calculated as the current Duration of each task minus the Baseline Duration. For example, if a task has a current Duration of 15 days and a Baseline Duration of 10 days, the Duration Variance would be 15 days minus 10 days, resulting in 5 days of Duration Variance.
To calculate the percent of Duration Variance, we use the following formula:
Percent of Duration Variance = 100 x (Duration Variance/Baseline Duration)
To create the preceding formula in a custom field in Microsoft Project, it is absolutely crucial to account for tasks with no Baseline saved and for tasks that are milestones to avoid division by zero errors. Now, let’s get started with creating the custom field.
Creating the Custom Field
To create the custom field, complete the following steps:
-
Click on the Project tab to display the Project ribbon.
-
Click the Custom Fields button in the Properties section of the ribbon.
-
In the Custom Fields dialog, select the Number type from the Type pick list.
-
Choose an available Number field, such as Number 1, and click the Rename button.
-
In the Rename Field dialog, name it something short like “Percent Dur Var” and then click the OK button.
Creating the Formula
To create the custom formula to calculate the percent of Duration Variance, complete the following steps:
-
Click the Formula button in the Custom Fields dialog.
-
Use the field names and operators to build the following formula. You can also copy and paste the formula, if needed.
IIf([Baseline Estimated Finish] = ProjDateValue(“NA”), -16000, IIf([Milestone], 0, 100*([Duration Variance]/[Baseline Estimated Duration])))
- Click the OK button to save the formula.
The preceding formula initially tests for tasks with no Baseline saved and then tests to determine if the task is a milestone. If both tests are false, then the formula calculates the percent of Duration Variance for the task.
Configuring Graphical Indicators
To add graphical indicators to the custom field, complete the following additional steps:
-
Click the Graphical Indicators button in the Custom Fields dialog.
-
In the Graphical Indicators dialog, set up graphical indicators based on your organization’s criteria. For example:
- If Duration Variance > 100%, display a red unhappy face.
- If 50% ≤ Duration Variance < 100%, show a red stoplight.
- And so on… Customize the criteria to match your project management processes.
-
Select the “Show data values in Tooltips” checkbox and then click the OK button to save the graphical indicators.
-
Click the OK button to close the Custom Fields dialog and to save the new custom field.
Saving the Custom Field for Future Projects
Complete the following steps to save this new custom field so that you can use it in all current and future projects:
-
Click the File tab, click the Info tab in the Backstage, and then click Organizer to display the Organizer dialog.
-
In the Organizer dialog, click the Fields tab.
-
In the list of custom fields on the right side of the dialog, select your custom field.
-
Click Copy to copy it into your Global .MPT file for use with all current and future projects.
-
Click the Close button to close the Organizer dialog and then press the Escape key on your computer keyboard to exit the Backstage.
And that’s it! You’ve successfully created a custom field for percent Duration Variance in Microsoft Project. Now, your project tasks will visually indicate their progress, helping you stay on top of your project timelines.
If you have questions, please add them in the “Leave a Reply” section below. Or if you watched the video, add your questions or comments there. Please subscribe to my YouTube channel and leave “Likes” if you like the videos.
If you would like to have a formal class on using Microsoft Project, here is a link for my classes.
Posted Feb 26, 2024, 4:15 PM UTC