Planned % Complete vs. Actual % Complete

[Misty Hulbert]

Team,

I don’t agree with this concept since I believe it could give a false indication of health but I have a customer who is adamant despite my explanation.

I need help in creating a formula that will calculate the planned % complete daily so I may compare it to the actual % complete. I am challenged on how to accomplish this task so that it considers the current date. Any help is appreciated.

[Anonymous]

Hi Misty. I’m not sure if this helps but have you looked into using the Earned Value data? They compare actual to planned progress with a plus/minus dollar value. There’s a lot to using EV, but it conceptually provides the solution. If you’re interested I’d suggest reading up on it and the specific columns provided within Microsoft Project. Good luck…

[Author]

Posts