Integer Programming: Logical Conditions with Binary Variables in Excel Solver

Рет қаралды 28,726

4 жыл бұрын

Enjoyed this content & want to support my channel? You can get the spreadsheet I build in the video or buy me a coffee! Links below:
Buy me a coffee: www.buymeacoff...
Buy complete spreadsheet: www.buymeacoff...
Buy me an item from my wishlist: www.buymeacoff...
If you haven't yet, please watch the Budget Allocation video before this one: • Integer Programming: B... .
Besides allowing you to model yes/no decisions in optimization models, binary variables also allow you to enforce logical conditions such as: if this happens, then that also happens, or if this happens then that can't happen, etc. In this video we learn how to implement these kinds of constraints in an optimization model without resorting to Excel's IF function, which should not be used for this purpose.

Пікірлер: 13

@mutlugundiler4458 3 жыл бұрын

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

@TallysYunes 3 жыл бұрын

You're welcome! And thank you!

@user-eh6yl2ej5m 5 ай бұрын

You are a very excellent teacher, thank you very much

@TallysYunes 5 ай бұрын

Thank you!

@rg73140 4 ай бұрын

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 4 ай бұрын

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.

@vijaybisht3774 Жыл бұрын

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

@TallysYunes Жыл бұрын

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

@ShaunDePonte 2 жыл бұрын

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 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

@olgahernandez8135 2 жыл бұрын

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 2 жыл бұрын

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