I get asked a lot about how to display variance in OnePager. This post will hopefully get your creative juices flowing about how to meet your specific needs. You might be interested in a project summary chart that looks something like this:
If so, here’s how to get it. As it turns out, Microsoft Project has two canned fields called Finish Variance and Start Variance. Both calculate the difference in days between the Baseline Finish and Baseline Start dates, and their current actuals.
In this exercise, I’m going to create a formula in a custom Number column in my Project file (Number1) that will allow me to produce a Finish Variance %, measured against the Duration of the task. To add the formula in MS Project, right click on any column header and select Custom Fields. Choose an unused Number column and plug in the following formula (per the screenshot below).
Prior to creating your new OnePager Project View, you’ll have to update the Template Properties to pull in that new Number column to be use for Conditional Formatting. To do this, click on the Templates button in your Add-Ins tab. Once the Template Properties form pops, select the Number column in the appropriate dropdown in the Other Columns tab (per the image below). Then click Save and Use.
Now click your OnePager button, and create your New Project View using the updated Template.
Next, create conditional formatting rules for color (or another format attribute) based on your Number column that will represent the Finish Variance %. See screenshot below:
The ordering of the rules is important in this case, so we’ve included a separate shot of that, as well.
At this point your project view should look something like mine does above.
Do you have a better idea on how to accomplish this visually using your data along with OnePager? We’d love to hear it! Please comment or send me a note at email@example.com.