Filter showing Activities with +/- lag !

D
Deepak Jain 👤 Member for 20 years 4 months
Primavera Project Planner - P3
A
Andrew Podolny 👤 Member for 21 years 6 months
· Permalink

Hi all.

For those who are familiar with SQL - the most attractive solution for above mentioned routines is MSAccess or any other DB oriented program. The export should be therefore done in DBF.

Regards

Andrew

A
Alex Wong 👤 Member for 23 years 4 months
· Permalink

Deepak



I mean using the export function in P3, It export a wks file that you can either open in Lotus 123 or excel.



Like Ronald said, you can easily to achieve to filter the 2500 activity with lag. (Its a 2 second job - and no need to do it manually, use auto fileter. and with a custom condition Lag <> 0)



Once you produce this list you might have a duplicate activity id.



What you can do then is to use another excel funtion, to create the unique list.



If you have difficult in Excel, then I suggest you better learn in quickly, because we(planner) do require a lot of the excel skill to create reports.



Good Luck



Alex

D
Deepak Jain 👤 Member for 20 years 4 months
· Permalink

Thanks Alex.. My understanding of your solution in CAPS. Please correct me if i’m wrong



Regards

Deepak



...........................................................

The quick answer is no



but you can still do it with the following steps



1. export all relationship in P3 {U MEAN EXCEL ?????}

2. filter the activity have +/- Lag (HAVE TO DO MANUALLY..IT’S CLOSE TO 2500 ACTIVITIES..HUUH :-) )

3. Create a unique list using excel funtion

4. import this list with a special project code

5. use this code to filter these activity

6. remember to use this code to assign new relationship that have lags attached



HTH



Alex

R
Ronald Winter 👤 Member for 23 years 5 months
· Permalink

Step 2 is simply done in Excell. Select all and sort by lag column. Highlight the middle rows without a lag and delete.

A
Alex Wong 👤 Member for 23 years 4 months
· Permalink

Deepak



The quick answer is no



but you can still do it with the following steps



1. export all relationship in P3

2. filter the activity have +/- Lag

3. Create a unique list using excel funtion

4. import this list with a special project code

5. use this code to filter these activity

6. remember to use this code to assign new relationship that have lags attached



HTH



Alex

Forum Sponsor

Top Posters

Dimitrios Theocharidis
3 posts
MichaelFuelsC
0 posts
anwar zeb
1 posts
olva seselima
1 posts
Muhammd Muneer
0 posts
sairam
0 posts
MARAT BILYALOV
0 posts
RichTea66
0 posts
Muneer Muhammad
1 posts
Manny Onifade
5 posts