Integer Programming: Logical Conditions with Binary Variables in Excel Solver
HTML-код
- Опубликовано: 13 июн 2020
- 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.buymeacoffee.com/tallysyunes
Buy complete spreadsheet: www.buymeacoffee.com/tallysyu...
Buy me an item from my wishlist: www.buymeacoffee.com/tallysyu...
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.
The ultimate teaching style. Period.
Much appreciated all your videos. Thank you.
You're welcome! And thank you!
You are a very excellent teacher, thank you very much
Thank you!
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?
“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
Your teaching skills are amazing. Thank you for this and keep going.
Thank you so much! Glad you are enjoying the videos!
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?
At time 8:30, I implement the constraints in Solver: x2
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,
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.
paused at 8:15