Satya's blog

Wednesday, August 19, 2009

Calculating days required for an ongoing task

Eg: For a 4 day task, 50% should be completed on day2. if it takes 3 days to complete 50%, then it takes 3 days to complete the remaining work assuming the pace of work is same.
Then apply the following formula for projection calculation:
Projection (Days Required) = IIf([Physical % Complete]>0 And [Physical % Complete]<100,((100-[physical>

Labels:

Planned percent complete calculation in MPP

Create a Text field. Apply the following formula to calculate Planned % Complete:
str(IIf([Status Date]<[Start],"0",IIf([Status Date]>[Finish],"1",ProjDateDiff([Start],[Status Date])/[Duration]))*100)+"%"
Note: Above formula may not work properly at summary task level.

Labels:

Tuesday, August 18, 2009

Planned percent complete vs percent complete in MS Project