Displaying the % of the Baseline
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
Dear friends,
I need to calculate the ""baseline"" and ""actual"" progress considering the weight factors of each activity.
I have used John Ward's formula (of course it does not include the weight farctor). But I also got 100% progress for each activity, even for those that have not been started yet.
can anyone help me with tis problem? and of course I need the formula to consider the weight factors as well...
Thank you so much in advance...
Dear friends,
I need to calculate the ""baseline"" and ""actual"" progress considering the weight factors of each activity.
I have used John Ward's formula (of course it does not include the weight farctor). But I also got 100% progress for each activity, even for those that have not been started yet.
can anyone help me with tis problem? and of course I need the formula to consider the weight factors as well... Please keep in mind that I am absolutely new in MSP, so please let me know exactly what I need to do step by step...
Thank you so much in advance...
Jon,
Still cant replicate your problem. Both formulae work fine in my test schedule.
Sent you a PM to discuss.
Regards,
Darren
ah rubbish,, in my example the line after A should be much further to the right,, well past B,, sorry HTML autoformats for us,,
here is what im 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 % im 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]))))
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
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
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
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
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?
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