Reviewing progressed activities

Member for

16 years 3 months

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

Member for

11 years 3 months

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

Member for

16 years 3 months

I do what I can 

Member for

11 years 3 months

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.

Member for

16 years 3 months

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