Solving an old PMs dilemma

As a Project Manager, over the years, I have found very complex to have MS Project (MSP) calculate a Planned %Work for a given Status Date. This limitation has been discussed with many of my fellow PMs, and we were never able to find an easy way to solve it. I have witnessed PMs manually updating custom fields, or even parallel projects, to try to calculate a Planned %Work. And when you have thousands of tasks in your project, this activity can be daunting and time consuming.

So, to solve this old PMs issue, I decided to write a simple VB Macro that momentarily uses the earned-value logic of the %Work field to calculate a Planned %Work for Summary Tasks at a defined Status Date.

Feel free to download the paper here: