Split Primavera P6 Schedule into 2 Schedules – Problem and solution

  • Date November 6, 2019

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) :
blank
3- Select the following columns:
A: Activities:
blank
B: Activities Relationships:
blank
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”)
blank
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.
blank
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:
blank
Both Excel Sheets With Formulas and clean for import are attached below for your reference.

Tag:, ,

author avatar
Hany Ismail, MSC, PMP

Hany Ismael is the founder and CEO of Planning Engineer Est. in Egypt. He has started his career back in 2003 as a site engineer, technical office engineer, planning engineer, planning manager, and finally planning department manager where he has been involved in several mega construction projects in Egypt and Saudi Arabia. In 2016, he established his own company in Egypt “Planning Engineer Est.” Hany gained his MSc degree in project management from Liverpool University-UK 2013-2016, PMP certified from PMI-USA 2010, and BSc Civil Engineer Tanta University-Egypt 2003. Hany provided more than 3,500 hours of planning and project management training on his website planningengineer.net, YouTube channel, and offline courses since 2011. He enjoys teaching project management in simple and practical way, and he developed several planning tools, techniques and courses.

You may also like

Planned VS Actual Excel Sheet
Mini Schedule Planned VS Actual Excel Sheet
18 August, 2021
3 weeks look ahead schedule
3 weeks look ahead schedule excel sheet
24 July, 2021
img_0265.jpg
10 Mistakes will prevent you from getting a planning job
23 December, 2020

Leave A Reply