How to fix out of sequence activities in P6 is finally revealed using an excel filter

แชร์
ฝัง
  • เผยแพร่เมื่อ 1 ธ.ค. 2024

ความคิดเห็น • 70

  • @servandoserrano5674
    @servandoserrano5674 10 หลายเดือนก่อน

    Thanks for sharing...its been a long time I'm doing manual ways in changing the activity links to remove out of sequence activities until I watch this video. This will now make my life easy fixing out of sequence activities

    • @SoftEdemy
      @SoftEdemy  10 หลายเดือนก่อน

      Welcome

  • @shakeeln2020
    @shakeeln2020 ปีที่แล้ว +1

    Thanks Buddy
    Keep updating such video
    Valuable information

    • @SoftEdemy
      @SoftEdemy  ปีที่แล้ว

      Thanks Mr. Shakeel Ahmed ,your feedback is valuable for us.

  • @Nithishkumar-wl2mp
    @Nithishkumar-wl2mp 2 ปีที่แล้ว +1

    after long time good to see you back with some valuable content thanks buddy

    • @SoftEdemy
      @SoftEdemy  2 ปีที่แล้ว

      Thanks, Nithish Kumar.I was just busy with some other projects. As professional Commitment. This time I will sure some pure professional and useful content. With a new interface. Stay connected with Softedemy. Also, Suggest to us the content you required.

  • @mahansor8295
    @mahansor8295 ปีที่แล้ว +3

    Very informative, thanks for sharing.
    Would you have any plan to resolve the rest of out of sequences activities (75 activities)?
    Thank you

    • @SoftEdemy
      @SoftEdemy  ปีที่แล้ว +1

      Resolved all. These are remaining 4th case

  • @aalamgeer2059
    @aalamgeer2059 2 ปีที่แล้ว +1

    Mashallah Sir thank you so much for creating this video.Regaring I asked number of planning manager but no one has the this short cuts .jaza kum Allah Khair sir

    • @SoftEdemy
      @SoftEdemy  2 ปีที่แล้ว

      Thanks, @Alam Geer for your valuable and inspirational comment on our hard work. We are coming up with more valuable content. Keep watching @Softedemy

    • @mohammadalamgir6347
      @mohammadalamgir6347 2 ปีที่แล้ว

      @@SoftEdemy Thank you very much Sir

  • @adnanjunaidsyed9725
    @adnanjunaidsyed9725 ปีที่แล้ว +1

    very well explained thank you but i have one question can we delete the relationships in excel itself after that we can export rather than putting "d"

    • @SoftEdemy
      @SoftEdemy  ปีที่แล้ว +1

      You have to delete in P6 in Excel. If you just remove than in P6 relationship will be remain their. The d commands the P6 to delete the relationship.so it's necessary.P6 will only do what you instruct to do. Also watch below video it's fixer tool .Its very easy nothing much to do in it.

    • @SoftEdemy
      @SoftEdemy  ปีที่แล้ว

      th-cam.com/video/488ipg6351k/w-d-xo.html
      Watch this video

  • @محمدالامينمحمدالمأمون
    @محمدالامينمحمدالمأمون ปีที่แล้ว

    Thanks a lot

  • @rupeshns03
    @rupeshns03 10 หลายเดือนก่อน

    Thanks for the wondeful video. I have a query. When you apply FF relationship to Out of sequence activities why don't you consider the lag. If you do not maintain lag (equal to remaining duation of the activity), FF relationship mayl pull ahead the overall schedule end dates?

    • @SoftEdemy
      @SoftEdemy  10 หลายเดือนก่อน

      By adding lag your finish dates will be changed in that case. No lag should be applied.out of sequence will be only detected when predecessor activity get started or completed. So in this senerio their is no sense to assign lag.
      Please first understand why out of sequence appears in monitoring phase of schedule.
      Thanks

  • @RHSkills
    @RHSkills 2 ปีที่แล้ว

    MA SHA ALLAH THANKS SIR

    • @SoftEdemy
      @SoftEdemy  2 ปีที่แล้ว +1

      Welcome you are also doing great work. Keep it up RH Skills

    • @RHSkills
      @RHSkills 2 ปีที่แล้ว

      @@SoftEdemy 💖

  • @UnofficialFaizan
    @UnofficialFaizan ปีที่แล้ว

    Have you uploaded the video for activities with no predecessor.

    • @SoftEdemy
      @SoftEdemy  ปีที่แล้ว

      No.

    • @SoftEdemy
      @SoftEdemy  ปีที่แล้ว +1

      Just apply a filter in which predecessors = empty

  • @skghomedesignideas5086
    @skghomedesignideas5086 ปีที่แล้ว +1

    Sir can you please add video for window analysis and time impact analysis step by step with example schedule.

    • @SoftEdemy
      @SoftEdemy  ปีที่แล้ว +1

      Sure, thanks for your comment

  • @mdzubairahmed6819
    @mdzubairahmed6819 ปีที่แล้ว

    please come with an example for window analysis method..

    • @SoftEdemy
      @SoftEdemy  ปีที่แล้ว +1

      We haven't started for any delay analysis content yet.
      In future our best content will be uploaded.
      All methods of delay with their case of work and different senerios .
      The video's will be practical.
      Meanwhile you can contact to our influencer as per above contact details for any urgent help.
      This may take sometime

  • @BedarBukhat
    @BedarBukhat 5 หลายเดือนก่อน

    Hi sir ,
    We use all these Cases to resolve out of sequence activities in one time?

    • @SoftEdemy
      @SoftEdemy  5 หลายเดือนก่อน

      Yes

    • @BedarBukhat
      @BedarBukhat 5 หลายเดือนก่อน

      Ok sir thankyou so much 😊

    • @SoftEdemy
      @SoftEdemy  5 หลายเดือนก่อน

      @@BedarBukhat welcome

  • @mohammedalmaky9637
    @mohammedalmaky9637 ปีที่แล้ว

    What if completed activity on predesser?

    • @SoftEdemy
      @SoftEdemy  ปีที่แล้ว

      Than their is no of sequence.
      For last case 4 you need to delete relationship

  • @AhmedAli-dj9jo
    @AhmedAli-dj9jo 2 ปีที่แล้ว

    Thank you for your time
    What you meant activity deviation +/- 5%
    What minus -5% mean?

    • @SoftEdemy
      @SoftEdemy  2 ปีที่แล้ว

      @Ahmed Ali, You have followed my words that true learners' spirits lead to professionalism. you have maybe read some in the contract or other procedures. In most general conditions of the contract and in the programme section you read this.
      "In the event that progress of an element of the Works deviates by plus or minus five percent (± 5%) from that shown in the associated Activity Programme the Contractor shall submit a revision of such Activity Programme for the Engineer’s information"
      If you revise your programme on 5% deviation then out of sequence will not occur in this bulk that was 1162 activities. There will be some out of sequence but not in huge nos.
      I hope you understand (± 5%) meaning that's not a division word i used deviation may be my pronunciations lead you wrong.
      Also maybe a question comes into your mind how can we find out (± 5%) deviation in activities.
      To find out (± 5%) deviation in activities. you just need to see the variance = (planned % (Which is Schedule %) - Earned % (which is Performance %).If the variance of an event is more than or equal to± 5% then you need to revise the activity program . The revision of activity according to the site should be done monthly basis and the consultant /Engineer should be informed about the changes by a summarized narrative report. That Programme will be not considered a revision it will be considered a monthly update.
      That's the best Practice >I would recommend to all planners to stay away from unrealistic forecasting results in EVM and Completion dates. Further, the choice depends on how your client is well known in Planning and Scheduling Practices.
      Thanks Again Ahmed Ali for Asking to keep asking these types of questions also let us know what you more want to hear from us.

    • @AhmedAli-dj9jo
      @AhmedAli-dj9jo 2 ปีที่แล้ว

      @@SoftEdemy thank you, I appreciate your work

    • @SoftEdemy
      @SoftEdemy  2 ปีที่แล้ว

      @@AhmedAli-dj9jo Welcome

  • @a.m2764
    @a.m2764 8 หลายเดือนก่อน

    hello sir ... i have two questions needing help
    1- After fixing in execel , i found this message(The User Preferences used to create this Excel file are not the same as your current preferences. Importing this file could corrupt your data. Please refer to Help for more information about importing data from Excel. Are you sure that you want to continue?) Is there a problem or continue ? 2- After updating : why budgeded units or costs before D.D disappear and the distribution of them is reassigned on next months differently compared to baseline?

    • @SoftEdemy
      @SoftEdemy  8 หลายเดือนก่อน

      The excel export file and then imported files are different. Like while exporting you setting if users preferences was different and in import was different. This cause the issue

    • @a.m2764
      @a.m2764 8 หลายเดือนก่อน

      thanks ... and what about the second enquiry pls???@@SoftEdemy

    • @SoftEdemy
      @SoftEdemy  8 หลายเดือนก่อน +1

      @a.m2764 when you remove out of sequence your relationship changes. So changes in relationship means changes in dates . And changes in dates means change in resources assignments.

    • @a.m2764
      @a.m2764 8 หลายเดือนก่อน

      @@SoftEdemyhow to solve (failed to find a matching object for activity relationship) whenever I import from excel to p6?..pls tell me

    • @SoftEdemy
      @SoftEdemy  8 หลายเดือนก่อน

      @a.m2764 predecessor I'd nort matching or type of relationship not matching. Or your deleting any relationship which doesn't exist. Any possibility from above

  • @rahulnagarwal4990
    @rahulnagarwal4990 9 หลายเดือนก่อน

    can i level resource of my project without fix "out of sequence activities"?

    • @SoftEdemy
      @SoftEdemy  9 หลายเดือนก่อน

      Yes but P6 resource level is resource constraint.

    • @rahulnagarwal4990
      @rahulnagarwal4990 9 หลายเดือนก่อน

      @@SoftEdemy what’s the mean of resource constraint?

    • @rahulnagarwal4990
      @rahulnagarwal4990 9 หลายเดือนก่อน

      Any issue or error occurred after resources leveling without fixing out of sequence activity?

    • @SoftEdemy
      @SoftEdemy  9 หลายเดือนก่อน

      @rahulnagarwal4990 inprogress activities have always issue in resources. Because you need to consider remaining units not budgeted

  • @muhammadusmanjanjua6235
    @muhammadusmanjanjua6235 ปีที่แล้ว

    Due to 4th case relationships of many activities removed. How to solve it??

    • @SoftEdemy
      @SoftEdemy  ปีที่แล้ว

      After resolving out of sequence, Assign new relationships

    • @SoftEdemy
      @SoftEdemy  ปีที่แล้ว

      th-cam.com/video/iwiMyK_9_eo/w-d-xo.html

  • @rahulnagarwal4990
    @rahulnagarwal4990 9 หลายเดือนก่อน

    sir is it for running project or completed project?

    • @SoftEdemy
      @SoftEdemy  9 หลายเดือนก่อน

      In progress project

  • @vino1817
    @vino1817 2 ปีที่แล้ว

    Sir,
    Thanks
    Having small doubt in this video.
    Before import why don't you deleted the activities.
    You clear the four rules first with the copy paste method. After that u did not delete existing activities
    Pls clarify sir

    • @SoftEdemy
      @SoftEdemy  2 ปีที่แล้ว +1

      if you delete all of them, your activities relationship will be broken. The previous relationship should be known. This is not a copy-paste method. This is a trick found after a lot of research. The second one is that there are more than 10 K activities or more than 35K relationships are there. By mistake, if you removed necessary relationships and forget to replace a new one. It will take days to know where your relationships are creating problems. If your project is in the monitoring stage. Now come to your question answer. you said I haven't deleted old relationships. The answer is that I deleted the relationship before importing. I put d in the delete column which instructs P6 to delete the relationship. If you just delete the row and import it back the relationship will be there. You have to put d in front of the delete row column. To instruct the p6 delete it. Watch again you will see it. thanks for your appreciation.

    • @vino1817
      @vino1817 2 ปีที่แล้ว

      First I say special thanks to you sir.
      For me u have spent this much time to type mes it is really thanks for your response.
      I got the answer from your reply sir.

    • @SoftEdemy
      @SoftEdemy  2 ปีที่แล้ว

      @@vino1817 you understood right, Before importing into p6, I have added d in the delete row column. Welcome me, my team, always work for free and we are focusing to deliver the best to the people. Although there is no earning from these services. In the market, the trainers and consultants charge 100s of dollars. But our services and response are free. Although our skills are not hidden from anyone. We have recently launched our website www.Softedemy.com.Now we are expanding ourselves and believe to be the best service providers. Stay with us. and keep sharing your feedback, What should be published next.

  • @electricalengineer2950
    @electricalengineer2950 ปีที่แล้ว

    Hi Sir Thank you so much for sharing valuable Knowledge 😊🤗😊
    I have a Doubt here in you Excel sheet there is no lag but in our sheet there is Some lags for activities how should we do for those activities to fix out of sequence please help sir thanks in Advance

    • @electricalengineer2950
      @electricalengineer2950 ปีที่แล้ว

      I tried this proceess as usual but I didn't get its showing "Process did not complete successfully.see log file for details" please help if you can give any idea sir please help

    • @SoftEdemy
      @SoftEdemy  ปีที่แล้ว

      Remove the lag to zero

    • @SoftEdemy
      @SoftEdemy  ปีที่แล้ว

      Avoid using lag or lead in scheduling

    • @SoftEdemy
      @SoftEdemy  ปีที่แล้ว

      th-cam.com/video/488ipg6351k/w-d-xo.html
      Follow the above video
      This is the same video with automated sheet

  • @siddiqkhan914
    @siddiqkhan914 2 ปีที่แล้ว

    Sir,
    For last 75 activities remaining out of sequence how to fix it? Do we need to repeat the same steps?

    • @SoftEdemy
      @SoftEdemy  2 ปีที่แล้ว +1

      Thanks for asking, I was expecting this question. That events are due 4th Case as I have explained that it does not impact Schedule strength. These 75 activities are completed but their predecessor and successor are not completed. So this is a totally different case. Normally when a scheduler uses fewer relationships during scheduling this does appear. IN this schedule he has used a lot of irrelevant relationships. this was falling in the 4th case Predecessor not started and Successor Completed. This can be resolved by deleting all activities in this case.
      One line answer is that you have to delete just the 4th Case Predecessor Not started and Successor Completed relationship to resolve 75 activities. In my case, not every Schedule. I hope you got the point. Also @Saddiq Khan thanks for asking.

    • @siddiqkhan914
      @siddiqkhan914 2 ปีที่แล้ว

      @@SoftEdemy Thanks for quick reply.

    • @SoftEdemy
      @SoftEdemy  2 ปีที่แล้ว

      @@siddiqkhan914 Welcome my pleasure.

  • @mohammedrauf5869
    @mohammedrauf5869 ปีที่แล้ว

    Could you share source file for a practice please

    • @SoftEdemy
      @SoftEdemy  ปีที่แล้ว

      Contact at whatsapp wa.me/+923155537580

  • @SoftEdemy
    @SoftEdemy  2 ปีที่แล้ว

    To see all below questions answers visit at www.softedemy.com/out-of-sequence-activities-in-p6/
    What are out of sequence activities in Primavera P6
    Why are they called out of sequence activities
    What is the impact of an out of sequence activity on a project schedule
    What are some best practices for avoiding out of sequence activities in Primavera P6
    How can out of sequence activities be identified?
    Step by Step Guide to resolve of Fix out of Sequence Activities in Primavera P6