show planned % complete

[yadsters]

How I show the planned % compete of the overall project? Not the actual %
complete, but the planned % complete.

 

[Jim Aksel]

It appears your question is: "If my task is on schedule, what should be my
%Complete on a specific status date?"

A formula can be applied to calculate the %Complete where you should be as
of the status date. The formula must address times when [Status] is (1) Prior
to [Start], (2)during the duration of a task, and, (3) after [Finish]. The
following formula can be applied to a spare column such as [Text1]:

str(IIf([Status Date]<[Start],"0",IIf([Status
Date]>[Finish],"1",ProjDateDiff([Start],[Status Date])/[Duration]))*100)+"%"

The formula can be used to compare with the %Complete field which is also a
duration based calculation.

************
There has been talk in this news group about this same topic. See the post
from Huazhou earlier today January 7, 2008 titled: How Microsoft Project
calculate weightage of the items. There is more detail there.




--
If this post was helpful, please consider rating it.

Jim

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

 

[Hisham]

Hi,

This is one of the topics that I have raised before to Microsoft as a
suggestion for enhancement on MS Project. Also I have discussed this matter
in more details at my blog with a sample project file that includes some
custom fields with the formulas needed to calculate the (Planned % Complete)
to be included in the project Gantt.

Please visit my blog and request your copy of the project sample file at:
http://epmforum.wordpress.com/2008/05/28/planned-pct-complete

Regards,
Hisham Aqtash