Predecessor status

S
Suchitra Goankar 👤 Member for 16 years 11 months

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

S
Suresh Sankarankutty PMP 👤 Member for 19 years 10 months

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....

K
Karim Mounir 👤 Member for 20 years 2 months

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

S
Suresh Sankarankutty PMP 👤 Member for 19 years 10 months

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.

S
Suresh Sankarankutty PMP 👤 Member for 19 years 10 months

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.

A
A D 👤 Member for 19 years 1 month

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



:-)

K
Karim Mounir 👤 Member for 20 years 2 months

In the report "activity relation" filter for the activites which haven’t started yet.

(ie. percent complete = 0%).

Forum Sponsor

Top Posters

Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts