Displaying the % of the Baseline

Yep , I would like to call myself an expert in this:
Here goes the formula :

Planned % =IF((100/(Baseline_Finish_date-Baseline_Start_date+1)*(Date_Now-Baseline_Start_date+1))<0,0,IF((100/(Baseline_Finish_date-Baseline_Start_date+1)*(Date_Now-Baseline_Start_date+1))>100,100,(100/(Baseline_Finish_date-Baseline_Start_date+1)*(Date_Now-Baseline_Start_date+1))))

I made this formula years back and still use deliberately in my trackers.(Excel based)

If you need more info , please gimme a shout.

Cheers ,

Sreejith Nair
Manager - Planning
MG WLL
Doha - Qatar

thanks Sreejith,
sorry to be thick but i keep getting an error on the code that reads Date_Now,, i have tried Status_Date,,
any ideas?

Use this formula in excel .. not in MSP
replace Baseline_start ..etc by the respective cell numbers (H45, E35 ..etc)

Read this post for more details:
http://www.planningplanet.com/forum/forum_post.asp?fid=1&Cat=4&Top=46747

Cheers!

Sreejith

Jon,

Just tried the formula in post #1 and it works fine for me. Have you checked your baseline and / or status date?

Regards,

Darren

Jon,

Had another thought… have any of the activities moved to the right?

Any delays in the schedule will not affect the planned % complete because that’s calculated from the Baseline Start / Finish Dates.

In effect according to the baseline you should have completed the tasks so the Planned % Complete shows as 100%, but the activity hasn’t started yet so the % Complete shows 0%.

Regards,

Darren

Hi!
My formula is useful when you have the following info :
Baseline start date
Baseline finish date
Current date/ Report date

From these 3 parameters , my formula calculates planned physical %.

If you have allocated a weighting / manhour to this activity you can get weighted progress / achieved manhour

This can be used for generating progress S-Curve, Productivity curve or EVM stuff

Cheers

Sreejith

here is what i’m trying to show, if line A is my activity bar, and is at 0%,, B is my base line bar (the verticle line is my date line,, so from that you can tell that the activity A has slipped to the right from the planned date,, so, i know how is show the % comp,, what i would like to show is the Planned % Complete,, in the example below the Planned % should read about 35%,, i have tried entering the formual (pasted at the bottom) in a new column (#12) in the formula section after i righ click on customise, however this does not tell me the % i’m looking for, i may be doing something obviolsy incorrect,, i would very much appreciate anyones help with this,, i know i shouldnt say this but P3 (once a Target has been created) details the baseline % quiet simply,, is there a method to check the data date of the baseline?

A -----------
B ----|-------

IIf([Baseline Start]>[Status Date],0,IIf([Baseline Finish]<[Status Date],100,projdatediff([Status Date],[Baseline Start],IIf([Task Calendar]="None",[Project Calendar],[Task Calendar]))*100/projdatediff([Baseline Finish],[Baseline Start],IIf([Task Calendar]="None",[Project Calendar],[Task Calendar]))))

ah rubbish,, in my example the line after A should be much further to the right,, well past B,, sorry HTML autoformats for us,,

Jon,

Still can’t replicate your problem. Both formulae work fine in my test schedule.

Sent you a PM to discuss.

Regards,

Darren