• Home
  • Blog
  • Courses
  • Tools
  • Jobs
  • Forums
Have any question?
(00) 201277767728
[email protected]
RegisterLogin

Login with your site account

Lost your password?

Not a member yet? Register now

Register a new account

Are you a member? Login now

Planning Engineer Est.
  • Home
  • Blog
  • Courses
  • Tools
  • Jobs
  • Forums
      • Cart

        0

    Excel in Planning

    • Home
    • Blog
    • Excel in Planning
    • Split Primavera P6 Schedule into 2 Schedules – Problem and solution

    Split Primavera P6 Schedule into 2 Schedules – Problem and solution

    • Posted by Hany Ismail, MSC, PMP
    • Categories Excel in Planning, Planning Discussions, Planning Using Primavera
    • Date November 6, 2019
    • Comments 0 comment

    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.
    NEWPROJ-11
    NEWPROJ-11-for import

    Tag:P6 Schedule, Problem and solution, Split Primavera

    • Share:
    Hany Ismail, MSC, PMP
    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.

    Previous post

    When you can use Constraints in Primavera P6 Time Schedule
    November 6, 2019

    Next post

    How to create Early curve and Late curve from Primavera P6
    November 26, 2019

    You may also like

    How to become a planning engineer
    How to be prepared to work as a junior planning engineer?
    22 May, 2022
    Materials Procurement Scheduling in a Baseline Programme
    Materials Procurement Scheduling in a Baseline Programme
    7 May, 2022
    Hany Live 15-Mar-2022
    Construction Projects Planning Q&A 15-March-2022
    15 March, 2022

    Leave A Reply Cancel reply

    You must be logged in to post a comment.

    Cart

    0

    Planning Courses

    Cost Control for Construction Projects

    Cost Control for Construction Projects

    $299.00
    Power Bi Monitoring and Controlling with P6

    Power Bi Monitoring and Controlling with P6

    $299.00
    Advanced Planning 3 Courses Package

    Advanced Planning 3 Courses Package

    $499.00
    Data Management and Reporting

    Data Management and Reporting

    $199.00
    Primavera Online Basic Course -Arabic

    Primavera Online Basic Course -Arabic

    $99.00
    Professional Planning Engineer (PPE)

    Professional Planning Engineer (PPE)

    $335.00
    Claims Management and (EOT)

    Claims Management and (EOT)

    $175.00
    Primavera Online Basic Course -English

    Primavera Online Basic Course -English

    $99.00

    Follow Us:

    About Us | Contact Us | Terms of Service | Privacy Policy | Refund Policy

    Copyright ©2012- 2018 planningengineer.net | All materials, unless otherwise noted, were developed originally for Planning Engineer Website. In the event that there is still a problem or error with copyrighted material, the break of the copyright is unintentional and noncommercial and the material will be removed immediately upon presented proof.

    • Planning Courses
    • Planning Jobs
    • Planning Blog
    Posting....