Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

how to display Planned Vs Baseline curves w.r.t time?

6 replies [Last post]
Wed, 2012-01-25 08:09
Kashif Khan
User offline. Last seen 10 years 18 weeks ago. Offline
Joined: 17 Nov 2011
Posts: 46
Groups: None

Hi All,

Can anyone help me by telling how to create Planned Vs Baseline curves using P6 or in any excel sheet. I have been asked by my manager to develop the weekly progress report showing these curves w.r.t time.

thanks in anticipation,

Kashif

Top

Replies

Wed, 2018-01-03 13:39
#1
Zoltan Palffy
User offline. Last seen 4 weeks 4 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

1st you wil need to assign resources to the baseline schedule

next copy the baseline schedule and use the copy to do your updating 

then you can compare the baseline vs the current

Top
Mon, 2017-12-25 05:00
#2
zahid shaikh
User offline. Last seen 5 years 7 weeks ago. Offline
Joined: 24 Aug 2016
Posts: 35
Groups: Building Information Modelling, TILOS

Hope this helps

 

 

https://youtu.be/cocNGNW9nOY

Top
Thu, 2012-01-26 01:01
#3
Kashif Khan
User offline. Last seen 10 years 18 weeks ago. Offline
Joined: 17 Nov 2011
Posts: 46
Groups: None

Thanx i will try to do this and if i feel any difficulty then i will get back to you.

best regards,

kk

Top
Wed, 2012-01-25 11:20
#4
mudasir dijoo
User offline. Last seen 4 years 9 weeks ago. Offline
Joined: 26 Jan 2011
Posts: 8
Groups: None

Hi Kashif

Planned and Baseline is same, you might be trying to compare %progress timewise planned/baseline vs actual

you can do one thing,

1)     Define a resource nonlabor type (i.e. Dur ) keep price/unit as 0 and default unit/time and max unit/time as 1 

so for any activity budgeted units is same as duration (i.e. 1* duration = duration).
2)     Select all activity by pressing Ctrl+A (highlight all) Resource from the menu.
3)     Select the new created resource (i.e. Dur ) and double click. (These will assign resource to all highlighted activities)

4) now go to reports Activity Resource and Role Assignments  , see monthly/weekly and cummulative budgeted units for this resource (Dur), now u can plot these weekly/monthly values in excel to get the  S-curve for planned duration complete.

5) once u update the schedule same way u can get the actual budgeted units for resource (Dur), and plot this against the planned curve.

this is just to compare duration complete planned vs actual   
 

regards

Mudasir

Top
Wed, 2012-01-25 09:32
#5
Kashif Khan
User offline. Last seen 10 years 18 weeks ago. Offline
Joined: 17 Nov 2011
Posts: 46
Groups: None

the %age progress, manhour, cost

Top
Wed, 2012-01-25 08:35
#6
Raymund de Laza
User offline. Last seen 32 weeks 7 hours ago. Offline
Joined: 23 Nov 2009
Posts: 762
Groups: Civil Engineering, Pinoy Planning Planet Community

Hi,

Baseline = Planned... what you will compare?

Top