Need Help Creating a Filter between Schedule Updates for Delayed Critical Path Activities

Hello,

I am struggling to create a filter required by my owner between updates- below are the requirements:

"Activities within 14 calendar days of the critical path that were planned to occur during the updated period, but which did not occur or occurred later than the scheduled late start or late finish date, shall be identified and accompanied with an explanation for those delays."

Oracle Primavera - PM6
D
Daniel Limson 👤 Member for 24 years 7 months
· Permalink

 

Hi Chris,

First, you need to define your critical activities in >Scheduling Options and second, you can use range or multiple filters to achieved the output you want in P6. If you are referring to the baseline, you can use the baseline start and finish dates and range of 2 weeks from data date.

Regards,

Daniel

 

J
Jerome Odeh 👤 Member for 22 years 4 months
· Permalink

Hi Chris,

You'd need to do this in Excel. Try the following steps.

  1. Export your baseline schedule to Excel with the following fields: Activity ID, Activity Name, Start, Finish, Late Start, Late Finish & Total Float
  2. Also export your live schedule to Excel with the following fields: Activity ID, Activity Name, Actual Start, Actual Finish, % Complete
  3. Combine these 2 exports into one workbook with 2 worksheets (tabs): Baseline & Live
  4. Add a third worksheet, lets call this Delays and in this third spreadsheet, using a combination of the following functions: IF, VLOOKUP and INDEX & MATCH, display activities from Live worksheet that meet either of the following 3 conditions:
    1. Baseline dates are within 14 days of critical path (i.e less than or equal to Total Float of 14) AND within reporting Period AND % Complete equal to 0
    2. Baseline dates are within 14 days of critical path (i.e less than or equal to Total Float of 14) AND within reporting Period AND % Complete not equal to 0 and Actual Start greater than Baseline Start
    3. Baseline dates are within 14 days of critical path (i.e less than or equal to Total Float of 14) AND within reporting Period AND % Complete not equal to 0 and Actual Finish greater than Baseline Finish

You will need to present your results in Excel.

=jerome

G
Gary Whitehead 👤 Member for 17 years 2 months
· Permalink

I don't think it's doable just with filters -I don't think the baseline late dates are a field you can filter on.

 

You could probably manage it by exporting your baseline to excel & re-importing BL late dates as user date fields (which are filterable)

 

 

Forum Sponsor

Top Posters

Josephus Enot
1 posts
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts