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.

Checking predecessor

2 replies [Last post]
Mon, 2005-06-27 16:49
Nozar Naghani
User offline. Last seen 5 weeks 1 day ago. Offline
Joined: 11 Jul 2004
Posts: 22
Groups: None
Hello planners,
Lets see who knows how to:

Create a filter to find completed activities, which their predecessor/s is not yet complete.


Probably we need to do something more than a filter.


Have fun

Nozar Naghani
Top

Replies

Wed, 2005-06-29 08:34
#1
Alex Wong
User offline. Last seen 11 years 5 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
The best way I can think of is export the complete activity list in a excel table and run a VLookup in the activity list that look up the predecessor actual finish date. Run a auto filter to filter your specified conditions.

Export the activity id list

Create a Activity Code

Import the activity ID + A Special Code

Filter the code

I think it is a 5 min job

Cheers

Alex
Top
Wed, 2005-06-29 05:21
#2
Jihad Daniel
User offline. Last seen 8 years 7 weeks ago. Offline
Joined: 7 May 2005
Posts: 99
Groups: None
Simply check scheduling report which will list the activities completed or started and their predecessors did not start yet...It is not complicated at all...

Regards,
J. Daniel
Top