Easy way of applying Activity relationships

Dear All,

             I am preparing aschedule of about 10,000 activities. Giviing relationship to those activities will take time and I dont have much time. Please tell me the simplest, easiest & fastest way to add relationships so that I can finish the scheduule in time. 

Thanks in advance..

 

Regards...

M
Mujahid Chauhdry 👤 Member for 11 years 11 months

Thanx Dieter..

I just tried. Its working. I can modify the relationship type. 

But why it is showing only activities which already have relationships/pred & Succ in p6? There are no activities for which Pred & Succ are not assigned in p6. So if I want to assign pred & succ in excel, I have to add those activities manually in excel sheet? 

 

Mujahid

D
Dieter Wambach 👤 Member for 19 years 5 months

Mujahid

You'll export to Excel (XLS) --> mark activities and Activity relationships --> within the map "Taskpred" you'll see the relationships.

Never modify any formatting! But you may modify the contents and add new records.

Then import this file again. Pay attention for the import configuration.

 

Good luck!

Dieter

M
Mujahid Chauhdry 👤 Member for 11 years 11 months

Dear Dieter,

Thanx for suggestions. You understood my question very rightly. Grouping is what I am aleady trying. 

Can you please alloborate the process how can I change relationships in excel? I know how to edit Activity names, duration etc in excel. But could not succeed in giving relationships in excel. 

 

I will be thankfull to you. 

 

Regards..

Mujahid

D
Dieter Wambach 👤 Member for 19 years 5 months

Mujahid

This depends on the structure of your project.

- If you'll group it it will be easier to work group by group

- You can export into Excel, then add the links within Excel

- You'll have groups of activities which will be in a sequence. Select group by group then right mouse button then "Link activities" which wil sequence those activities.

These are only techniques. Reserve your time to create the proper logical links. This will help the project.

 

Hope I understood your question correctly. Good luck!

Dieter

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