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.
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
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
I do what I can
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.
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