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.

What is a quick/fast way for defining activity relationships in complex project???

3 replies [Last post]
Ali Murtaza
User offline. Last seen 7 years 17 weeks ago. Offline
Joined: 19 Aug 2015
Posts: 30
Groups: None

Dear Professionals, 

As we know, activity relationships can be easily defined in primavera. But, my question is that what is the fastest way of defining relationships for a complex project with 27,000 activities. 

Construction, Engineering & Procurement phase relations are already in place. Only the relations remaining are linking of Engineering & Procurement activities with construction phase.

1. Delivery of steel structure on site is to link with related construction activity.
2. Approval of footings shop drawings is to link with specific construction activity.

Engineering & Procurement activities are required to be linked with construction phase. If we link manually it will take a lot of time in primavera. Is there any other method to define relationships???

I am familiar with excel export/import method, but regarding relationship assignment in excel, can you guys explain a little in detail what specific steps to follow for a complex project in order to assign relationships in exported primavera xls file.


Johannes Vandenberg
User offline. Last seen 17 weeks 4 days ago. Offline
Joined: 21 Jan 2010
Posts: 234


Good solutions by Zoltan and  Raphel.

One other solution is to use is WBS structuring.  

Example: one item the PBS ( Product Breakdown Structure) is a Knock-out Drum. Transform this to an WBS item. Than list all the activity from procurement to mechanical Completion. This may look like this.

Make requisition  > issue, receive & analyze bids > Procure > Deliver> transport to location > Install & fix > test & inspect> mechanical completion.

Link all activities and drag & drop them in the correct WBS or work package.

Regards Johannes

Rafael Davila
User offline. Last seen 2 weeks 4 days ago. Offline
Joined: 1 Mar 2004
Posts: 5229

Maybe you can filter last procurement activities for each chain and all construction successors by creating a user defined field.  Mark these activities with an X and apply the filter, then you can link them with the cursor if the filtered activities are not that many.

Good Luck.

Zoltan Palffy
User offline. Last seen 12 weeks 3 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

there are several techniques to do what you want to do.

opting #1

One way is building intelligence into the activity id.

For example you could have the chain of activities for steel for the 2nd floor as 

sub2stl2000 which would be for the submittal of of the steel shop drawings

then app2stl2000 which would be for the approval of the steel shop drawings

then proc2stl2000 which would be for the procurement of the steel shop drawings

then you could have inst2stl2000 which would be the installation of the steel for the 2nd floor

then you could filter on where activity id contains 2stl this would give you the chain of the 4 activities

you could then select all then right click and then select link activities

or some variation of this it is up to you but you get the idea

option #2

another way to do it is to use an import spreadsheet that is available where you create the activity and list its predecessor id then import the activity with the relationships via excel.

here is a link to this spreadsheet see my posting the excel file is here #3

option #3

another way to do it is to create one activity on the schedule then export the activties and the relationships to excel then use this as a template for importing activities into p6. There will be 2 tabs one for activities and one for relationships the activity tab is labeled as TASK and the relationship tab is labeled as TASKPRED you can populate both of these tabs in the spreadsheet and then import the data into p6.

Remember that any column that has an asterisk in the top of the column can not be imported.

Also when you perform your import into P6 first import the activities then import the relationships 2 step process.