Skip to content

Reviewing progressed activities

Folahan AdebayoMember for 12 years 3 months
Created
5
3
0

Hi all,

Can you suggest an easy way to review the progressed activities from contractor's updated program? I mean how can I simply filter all activities that was progressed within the week (reporting period) without having to scroll through thousands of activities to find the changes in Performance % btw this period and the last period. Preferably another approach besides the Claim Digger (To me...thats not so cool).

Thanks

Idris.

5 replies

Oldest first
  1. 0
    Zoltan Palffy ·

    if you are talk about just

    if you are talk about just the activites that have been progressed since last week you can easily get the activities that have started or finished getting the incremental % complete increase is a little more difficult. 

    filter    any                                                                low value                 high value

    where           atual start        is within the range              DD-1W                      DD

     or               actual finish      is wihtin the range              DD-1W                      DD

     or               activity status     equals                              in-progress  

     

    create a UDF (user defined filed) call it old % complete 

    take the previous update and export the new UDF filed and the duration % complete (or whatever type of % complete that you are using) to excel. 

    filter                                                                 low value          high value 

    where duration % complete    is in the range of         1                   99  

    now in excel copy the values in the duration % complete to the UDF column

    when you get the update create the udf field again in the updated schedule and import the excel file that you just created into the updated schedule

    now run a filter 

     filter    any                                                                                    low value                     high value

    where           atual start                              is within the range              DD-1W                        DD

     or               actual finish                           is wihtin the range              DD-1W                         DD

     or               duration % complete               is greater than                    (UDF) old % complete

    do this for each update

  2. 0
    Folahan Adebayo ·

    Hi Zoltan,You are always in

    Hi Zoltan,

    You are always in high spirit to offer a help. Let me give your suggestion a shot and I will revert.

    Thanks a lot.

  3. 0
    Zoltan Palffy ·

    I do what I can

    I do what I can 

  4. 0
    Folahan Adebayo ·

    Hi Zoltan, It all went

    Hi Zoltan,

     

    It all went smoothly until the last filter(as below). The low value does not accept the syntax  (UDF) old % complete- I tried all combination without luck. Please clarify.

    filter    any                                                                                    low value                     high value

    where           atual start                              is within the range              DD-1W                        DD

     or               actual finish                           is wihtin the range              DD-1W                         DD

     or               duration % complete               is greater than                    (UDF) old % complete

  5. 0
    Zoltan Palffy ·

    ok you are right then in this

    ok you are right then in this case you may have to export to excel and do the comparison there then tag each activity that increased with a code then import the code back into p6. Like I said the incremental percentages are a little harder to filter out.

    However if the schedule is manhour loaded or cost loaded and you are performing a store period performance then you can filter where actual this period labor units or actual this period labor costs is greater than 0

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?