Split Primavera P6 Schedule into 2 Schedules - Problem and solution

I have received a question from one of my trainees as follow “I have schedule of work around 50,000 activities and the schedule contains the scope of work of two contractors. Now one contractor will not be working under us and i need to maintain the dependencies between the 2 scope of works and in the same time remove other contractor activities from my schedule. Or maybe split the schedule into 2 activities”

My answer to this challenging question was as follow:

1- Following is a screenshot of the test schedule where there is project A (the one you want to delete) and project B where there are relationships from Project A

2- I will export excel spread sheet (Activities and Activities Relationships) :

3- Select the following columns:

A: Activities:

B: Activities Relationships:

4: Now we want to find out which activities in Project A that have relationships with project B to keep it and delete other activities Following screenshot showing the technique used to find this using excel also the excel sheet attached:

You need to identify the project A and project B using the activity ID; so we need to know if there is a Successor in project A that has Project B.

A: Column H Formula will find if the Successor column has the word “Project B”: =ISNUMBER(SEARCH(“ProjectB”,B3))

B: Column I Formula will find if the Activity belongs to Project A: =ISNUMBER(SEARCH(“ProjectA”,A3))

C: Column J will find if the both columns (H & I) are true to tell us this is required activity: =IF(AND(H3=TRUE,I3=TRUE),”Required”,”Not Required”)

5: Now we will go to the activity sheet to make Vlockup to find the required and not required activities in Project A. Not required activities will be deleted by add letter “d” as per below screenshot and required activities will add a constrain must finish by = early finish date.

6: Now clean your sheet by deleting the relationships sheet and paste value your data in activities sheet and import to your schedule and here is the result:

Only the activities that affect project B remains with constrain to finish by its planned date:

Both Excel Sheets With Formulas and clean for import are attached below for your reference.

NEWPROJ-11

NEWPROJ-11-for import

Keep growing with Planning Engineer

Learn with a clear path

From Primavera P6 basics to claims, cost control and Power BI. Start with our free courses.

Ready to take your skills to the next level? 🚀 Check out our Special Online Courses! 🚀
Gain valuable insights, boost your career, and learn from industry experts.

Planning Courses

Browse courses

Get help on WhatsApp

Every course comes with a private WhatsApp support group where our team answers your questions.

Join a course

Find planning jobs

25 open planning and project control jobs. Post your resume so employers can find you.

See jobs

Get tips by email

Free planning tips, templates and course offers. Unsubscribe any time.

Do you want to know how to download this attachments?

Check this article to know how to download our website contents

In this guide, we’ll show you step by step how to access the articles’ resources, where to find them, and which part is free, which part is premium. We will introduce our freemium approach.

Tell Me How To Download

Excel in Planning

Split Primavera P6 Schedule into 2 Schedules – Problem and solution

Keep in Touch