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.

Predecessor status

12 replies [Last post]
Mon, 2007-10-08 03:39
Suresh Sankaranku...
User offline. Last seen 4 years 36 weeks ago. Offline
Joined: 30 Jul 2006
Posts: 77
Groups: Petro-Chem / Oil & Gas
Hi
A good question for all..
I dont know whether you might got this scenario earlier.

Q: How can i make a report / layout showing the current activity and the predecessor activity status.

Infact, if we run the activity relation report you will get all activities relationship for the entire project. I am interested to see only the activities which is not started and the predecessor activity status. Becasue, if the predecessor activity status shows as completed, then due activiy can carryout straight.

I have no idea, if any one got any idea pls share.


Regards
Suresh
Top

Replies

Sat, 2009-07-04 10:41
#1
Rafael Davila
User offline. Last seen 12 hours 19 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Groups: Spider Project Team
Using Primavera SureTrak I can get the reports and filters with ease. Being Suretrak a low end and outdated Primavera product this should be a walk in the park under P6.

http://rapidshare.com/files/251857683/Organize_by_Successor_or_Predecess...

Hope this give you the clue.

Rafael

Top
Fri, 2009-07-03 05:44
#2
Suresh Sankaranku...
User offline. Last seen 4 years 36 weeks ago. Offline
Joined: 30 Jul 2006
Posts: 77
Groups: Petro-Chem / Oil & Gas
Hi Suchitra
sagasuresh@yahoo.com
Regards
Top
Fri, 2009-07-03 05:15
#3
Suchitra Goankar
User offline. Last seen 14 years 38 weeks ago. Offline
Joined: 26 Jun 2009
Posts: 3
Groups: Civil Engineering
Hi Suresh Gurubhavan,

I tried to get in touch with you through planning planet but currently private messaging is restricted on planning planet,can you please share me your email id,i would like to discuss regarding P6 with you

Regards

Suchi
Top
Tue, 2007-10-09 06:55
#4
Karim Mounir
User offline. Last seen 9 years 36 weeks ago. Offline
Joined: 5 Apr 2006
Posts: 314
Groups: None
badddddddd
Top
Tue, 2007-10-09 04:51
#5
Suresh Sankaranku...
User offline. Last seen 4 years 36 weeks ago. Offline
Joined: 30 Jul 2006
Posts: 77
Groups: Petro-Chem / Oil & Gas
Ooops... Karim
I got kicked off from there... because i am using 3.5.1 version.. I cant export relationship... also i cant export to xls....
Top
Tue, 2007-10-09 04:49
#6
Suresh Sankaranku...
User offline. Last seen 4 years 36 weeks ago. Offline
Joined: 30 Jul 2006
Posts: 77
Groups: Petro-Chem / Oil & Gas
Hi Karim
I think its having the logic. I think i will try your method.. Thanks...
Top
Tue, 2007-10-09 00:00
#7
Karim Mounir
User offline. Last seen 9 years 36 weeks ago. Offline
Joined: 5 Apr 2006
Posts: 314
Groups: None
Hi Suresh,

OK I now get it but sorry as far as I know there is no automatic way to do it (neither a report nor layout export will do it at one shot).

What I manged to do is:

1- Export the schedule relationships (File - Export - Spreadsheet XLS - Activity Relationships), set a template in which u’ll be showing the predecessors data only (eg. Start / Finish / ID / Status) - sheet #1.
2- Back to your schedule, remove all the columns except Act. ID / Activity Name and add the column named Predecessors.
3- Select the schedule data (press ctrl+A) and then paste it in another excel sheet - sheet #2.
4- Now u have 2 excel files, one contains activities data and the other containing predecessors data, u can use vlookup formula in linkage between the 2 sheets (ie. search for predecessors ID from sheet #2 and gets its info from sheet #1).

Regards,
Karim
Top
Mon, 2007-10-08 11:53
#8
Suresh Sankaranku...
User offline. Last seen 4 years 36 weeks ago. Offline
Joined: 30 Jul 2006
Posts: 77
Groups: Petro-Chem / Oil & Gas
Hey
Pls try to understand what i really mean.

I want to show a schedule plan / report which shows the main activity and the predecessor activity status.

Eg:

Act.id Act.name Start Finish Predcessor Predecessor status

00100 Relagging 10/10 12/10
Box-up line In-prgss

This is what i want. I want to see the predecessor activity’s status and not the main activity status.
Top
Mon, 2007-10-08 11:52
#9
Suresh Sankaranku...
User offline. Last seen 4 years 36 weeks ago. Offline
Joined: 30 Jul 2006
Posts: 77
Groups: Petro-Chem / Oil & Gas
Hey
Pls try to understand what i really mean.

I want to show a schedule plan / report which shows the main activity and the predecessor activity status.

Eg:

Act.id Act.name Start Finish Predcessor pred.status

00100 Relagging 10/10 12/10 Box-up line In-prgss

This is what i want. I want to see the predecessor activity’s status and not the main activity status.
Top
Mon, 2007-10-08 05:31
#10
A D
User offline. Last seen 3 years 23 weeks ago. Offline
Joined: 20 May 2007
Posts: 1027
Groups: Accreditation Editors
Good Question Suresh...

To show the activities which haven’t started, you can give filter of

Select if Is Low Value High Value

early start WR DD DD + 2W

If u want to know the predecessaor’s status, then that you have to do it manually

:-)
Top
Mon, 2007-10-08 05:11
#11
Hesham Arafa
User offline. Last seen 1 year 8 weeks ago. Offline
Joined: 14 Jan 2006
Posts: 10
Groups: None
I think you can only show up the predecessor manually.
Top
Mon, 2007-10-08 03:48
#12
Karim Mounir
User offline. Last seen 9 years 36 weeks ago. Offline
Joined: 5 Apr 2006
Posts: 314
Groups: None
In the report "activity relation" filter for the activites which haven’t started yet.
(ie. percent complete = 0%).
Top