Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Filter showing Activities with +/- lag !

5 replies [Last post]
Thu, 2006-10-26 18:11
Deepak Jain
User offline. Last seen 10 years 30 weeks ago. Offline
Joined: 14 Jan 2006
Posts: 31
Groups: Petro-Chem / Oil & Gas
Hi all,

Any method to filter activities having Lags (Positive/Negative) ?

Thanks
Deepak
Top

Replies

Thu, 2006-11-02 13:40
#1
Andrew Podolny
User offline. Last seen 1 year 12 weeks ago. Offline
Joined: 16 Nov 2004
Posts: 130
Groups: Petro-Chem / Oil & Gas
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
Top
Sun, 2006-10-29 19:29
#2
Alex Wong
User offline. Last seen 11 years 27 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
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
Top
Thu, 2006-10-26 23:38
#3
Deepak Jain
User offline. Last seen 10 years 30 weeks ago. Offline
Joined: 14 Jan 2006
Posts: 31
Groups: Petro-Chem / Oil & Gas
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
Top
Fri, 2006-10-27 09:02
#4
Ronald Winter
User offline. Last seen 3 years 29 weeks ago. Offline
Joined: 4 Jan 2003
Posts: 928
Groups: None
Step 2 is simply done in Excell. Select all and sort by lag column. Highlight the middle rows without a lag and delete.
Top
Thu, 2006-10-26 23:00
#5
Alex Wong
User offline. Last seen 11 years 27 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
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
Top