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.
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…