Skip to content

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

Kashif KhanMember for 14 years 11 months
Created
6
2
0

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

6 replies

Oldest first
  1. 0
    Raymund de Laza ·

    Hi, Baseline = Planned...

    Hi,

    Baseline = Planned... what you will compare?

  2. 0
    Kashif Khan ·

    the %age progress, manhour,

    the %age progress, manhour, cost

  3. 0
    Mudasir Dijoo ·

    Hi Kashif Planned and

    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

  4. 0
    Kashif Khan ·

    Thanx i will try to do this

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

    best regards,

    kk

  5. 0
    Zahid Shaikh ·

    Hope this

    Hope this helps

     

     

    https://youtu.be/cocNGNW9nOY

  6. 0
    Zoltan Palffy ·

    1st you wil need to assign

    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

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?