Integer Programming: Logical Conditions with Binary Variables in Excel Solver

แชร์
ฝัง
  • เผยแพร่เมื่อ 5 ม.ค. 2025

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

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

    The ultimate teaching style. Period.
    Much appreciated all your videos. Thank you.

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

      You're welcome! And thank you!

  • @zheng-p2h
    @zheng-p2h 9 หลายเดือนก่อน

    You are a very excellent teacher, thank you very much

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

      Thank you!

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

    Excellent. How would we model an 'or'. i.e. if we advertise on channels 3 OR 4, then we must advertise on channel 10? what would the linear equation be?

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

      “3 or 4 imply 10” is equivalent to saying that 3 alone implies 10 and also 4 alone implies 10. So you need two constraints of the type “if this then that:” x3

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

    Your teaching skills are amazing. Thank you for this and keep going.

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

      Thank you so much! Glad you are enjoying the videos!

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

    Hi I would like to check, if the constraint is this instead, what would the equation be?
    If we advertise on channel 3, we must also advertise on channel 9 and 10,

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

      In this case, you can deal with it as if it were two separate statements and it will result in two constraints:
      a) If we advertise on 3, we must also advertise on 9.
      b) if we advertise on 3, we must also advertise on 10.
      You can do each of the above with the "if this then that" formula that the video teaches.

  • @olgahernandez8135
    @olgahernandez8135 3 ปีที่แล้ว

    What happened in both cases where constraints 2 and 3 weren’t satisfied at all? if the problem requires me that when x2 happens then x3 should do too. and the other one related x6 and x8 we didn’t get the answer we expected by adding those constraints, wha do we need to do in order to make it happen?

    • @TallysYunes
      @TallysYunes  3 ปีที่แล้ว

      At time 8:30, I implement the constraints in Solver: x2

  • @mrmoe5272
    @mrmoe5272 4 ปีที่แล้ว

    paused at 8:15