![Tallys Yunes](/img/default-banner.jpg)
- Видео 49
- Просмотров 882 321
Tallys Yunes
США
Добавлен 3 ноя 2009
Welcome to my channel!
I post videos on a variety of topics related to optimization, data analytics, and mathematical literacy (a.k.a. the opposite of "innumeracy"). These videos and tutorials serve both as a source of supplementary material for my students and as reference material for anyone else (student or not) who is interested in learning the topics I cover. If you'd like to see a video on a specific topic not yet covered by an existing video, just let me know!
If you like any of the content, please hit the thumbs-up button and consider subscribing (and activating the "bell") to be notified when I upload new videos. If you would like to help support the channel, you can buy me a coffee: www.buymeacoffee.com/tallysyunes. Enjoy and thank you for visiting!
I post videos on a variety of topics related to optimization, data analytics, and mathematical literacy (a.k.a. the opposite of "innumeracy"). These videos and tutorials serve both as a source of supplementary material for my students and as reference material for anyone else (student or not) who is interested in learning the topics I cover. If you'd like to see a video on a specific topic not yet covered by an existing video, just let me know!
If you like any of the content, please hit the thumbs-up button and consider subscribing (and activating the "bell") to be notified when I upload new videos. If you would like to help support the channel, you can buy me a coffee: www.buymeacoffee.com/tallysyunes. Enjoy and thank you for visiting!
Catch a Thief with Optimization: "Suits" Series, Episode 8, Season 1
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/tallysyunes/e/58123
Buy me an item from my wishlist: www.buymeacoffee.com/tallysyunes/wishlist
I recently started watching the hit series "Suits" on Netflix. In episode 8 of season 1, Harvey, Mike, and Louis are faced with a problem that can be cast as an optimization problem. The episode doesn't show how they solved it, but in this video I show you one way they could have done it.
Buy me a coffee: www.buymeacoffee.com/tallysyunes
Buy complete spreadsheet: www.buymeacoffee.com/tallysyunes/e/58123
Buy me an item from my wishlist: www.buymeacoffee.com/tallysyunes/wishlist
I recently started watching the hit series "Suits" on Netflix. In episode 8 of season 1, Harvey, Mike, and Louis are faced with a problem that can be cast as an optimization problem. The episode doesn't show how they solved it, but in this video I show you one way they could have done it.
Просмотров: 374
Видео
Installing and Using OpenSolver for Excel (Mac and Windows)
Просмотров 4,7 тыс.Год назад
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/tallysyunes/e/58123 Buy me an item from my wishlist: www.buymeacoffee.com/tallysyunes/wishlist Instructions on how to install and use another free optimization solver ...
Plant Maintenance Scheduling
Просмотров 657Год назад
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/tallysyunes/e/58123 Buy me an item from my wishlist: www.buymeacoffee.com/tallysyunes/wishlist Consider a plant whose output capacity depends on the amount of input as...
An Easy Way to Visualize Conditional Probabilities and Bayes Rule
Просмотров 7912 года назад
Enjoyed this content & want to support my channel? You can buy me a coffee here: www.buymeacoffee.com/tallysyunes or an item from my wishlist here: www.buymeacoffee.com/tallysyunes/wishlist If you want to jump straight to the Bayes Rules examples, they're here: Quality control in manufacturing: 12:27 Testing for allergy to cat hair: 22:45 In this video, I use a visual representation of darts on...
Mr. Lovr's Adventure: A Valentine's Day Optimization Story
Просмотров 4463 года назад
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/tallysyunes/e/58123 Buy me an item from my wishlist: www.buymeacoffee.com/tallysyunes/wishlist Learn how Mr. Lovr, a lonely gentleman, decided on the best way to ship ...
Excel Solver on the Mac: Be Careful with How You Input Constraints
Просмотров 20 тыс.3 года назад
Enjoyed this content & want to support my channel? You can buy me a coffee here: www.buymeacoffee.com/tallysyunes or an item from my wishlist here: www.buymeacoffee.com/tallysyunes/wishlist If you have a Mac with a Microsoft Office version that is newer than 2011, your constraints need to be implemented so that all variables are on one side of the symbol. In this video, I explain the issue and ...
How to Install TreePlan and SimVoi Excel Add-Ins on a Mac
Просмотров 6 тыс.3 года назад
Enjoyed this content? Want to help support my channel? You can buy me a coffee: www.buymeacoffee.com/tallysyunes For installation instructions on Windows, click here: ruclips.net/video/ysg0XCrT06Y/видео.html
How to Install TreePlan and SimVoi Excel Add-Ins on Windows
Просмотров 3,5 тыс.3 года назад
Enjoyed this content? Want to help support my channel? You can buy me a coffee: www.buymeacoffee.com/tallysyunes For installation instructions on a Mac, click here: ruclips.net/video/6Aqy0gp9NYo/видео.html
Word Problem Generator for Young Kids (Addition and Subtraction)
Просмотров 3524 года назад
Enjoyed this content? Want to help support my channel? You can buy me a coffee: www.buymeacoffee.com/tallysyunes I put together an Excel spreadsheet that can be used to entice young children to do addition and subtraction while having fun. See video for complete explanation. The spreadsheet can be downloaded from here: moya.bus.miami.edu/~tallys/docs/word-problem-generator.xlsx
Linear Programming Sensitivity Analysis with Excel Solver: An Employee Scheduling Example
Просмотров 8 тыс.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.buymeacoffee.com/tallysyunes Buy complete spreadsheet: www.buymeacoffee.com/tallysyunes/e/58123 Buy me an item from my wishlist: www.buymeacoffee.com/tallysyunes/wishlist If you're not familiar with Excel Solver's sensitivity report and basic ...
Linear Programming Sensitivity Analysis with Excel Solver: An Amusement Park Example
Просмотров 27 тыс.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.buymeacoffee.com/tallysyunes Buy complete spreadsheet: www.buymeacoffee.com/tallysyunes/e/58123 Buy me an item from my wishlist: www.buymeacoffee.com/tallysyunes/wishlist If you're not familiar with Excel Solver's sensitivity report and basic ...
Linear Programming: Equipment Replacement as Shortest Path with Excel Solver (Network Flows Part 5)
Просмотров 5 тыс.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.buymeacoffee.com/tallysyunes Buy complete spreadsheet: www.buymeacoffee.com/tallysyunes/e/58123 Buy me an item from my wishlist: www.buymeacoffee.com/tallysyunes/wishlist If you haven't watched my explanation of the transshipment problem, it m...
A First Monte Carlo Simulation Example in Excel: Planning Production with Uncertain Demand
Просмотров 31 тыс.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.buymeacoffee.com/tallysyunes Buy complete spreadsheet (must buy simulation add-in first; see below): www.buymeacoffee.com/tallysyunes/e/58123 Buy me an item from my wishlist: www.buymeacoffee.com/tallysyunes/wishlist If you're not already fami...
Using Data Tables for Sensitivity Analysis of Decision Trees in Excel: A Strategy Example
Просмотров 14 тыс.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.buymeacoffee.com/tallysyunes Buy complete spreadsheet (must purchase the tree add-in first; see below): www.buymeacoffee.com/tallysyunes/e/58123 Buy me an item from my wishlist: www.buymeacoffee.com/tallysyunes/wishlist Decision Tree add-in I ...
Risk Profiles with Decision Trees in Excel: A Strategy Example
Просмотров 9 тыс.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.buymeacoffee.com/tallysyunes Buy complete spreadsheet (must purchase the tree add-in first; see below): www.buymeacoffee.com/tallysyunes/e/58123 Buy me an item from my wishlist: www.buymeacoffee.com/tallysyunes/wishlist Decision Tree add-in I ...
Value of Information (EVSI and EVPI) with Decision Trees in Excel: A Strategy Example
Просмотров 9 тыс.4 года назад
Value of Information (EVSI and EVPI) with Decision Trees in Excel: A Strategy Example
A Business Strategy Example with Decision Trees in Excel
Просмотров 28 тыс.4 года назад
A Business Strategy Example with Decision Trees in Excel
Two-Stage Stochastic Optimization in Excel: An Airline Yield Management Example
Просмотров 8 тыс.4 года назад
Two-Stage Stochastic Optimization in Excel: An Airline Yield Management Example
Two-Stage Stochastic Optimization in Excel: A Hotel Booking Example
Просмотров 10 тыс.4 года назад
Two-Stage Stochastic Optimization in Excel: A Hotel Booking Example
Introduction to Two-Stage Stochastic Optimization (Conceptual)
Просмотров 16 тыс.4 года назад
Introduction to Two-Stage Stochastic Optimization (Conceptual)
Goal Programming: Soft Constraints with Excel Solver
Просмотров 10 тыс.4 года назад
Goal Programming: Soft Constraints with Excel Solver
Integer Programming: Solving a Puzzle with Excel Solver
Просмотров 2,1 тыс.4 года назад
Integer Programming: Solving a Puzzle with Excel Solver
Integer Programming: Fixed Costs and Linking of Variables (Facility Location) with Excel Solver
Просмотров 16 тыс.4 года назад
Integer Programming: Fixed Costs and Linking of Variables (Facility Location) with Excel Solver
Integer Programming: Set Covering with Excel Solver
Просмотров 12 тыс.4 года назад
Integer Programming: Set Covering with Excel Solver
Integer Programming: Logical Conditions with Binary Variables in Excel Solver
Просмотров 29 тыс.4 года назад
Integer Programming: Logical Conditions with Binary Variables in Excel Solver
Integer Programming: Budget Allocation with Excel Solver (Knapsack Problem)
Просмотров 16 тыс.4 года назад
Integer Programming: Budget Allocation with Excel Solver (Knapsack Problem)
Linear Programming: Shortest Path with Excel Solver (Network Flows Part 4)
Просмотров 13 тыс.4 года назад
Linear Programming: Shortest Path with Excel Solver (Network Flows Part 4)
Linear Programming: Transshipment with Excel Solver (Network Flows Part 3)
Просмотров 23 тыс.4 года назад
Linear Programming: Transshipment with Excel Solver (Network Flows Part 3)
Linear Programming: Assignment with Excel Solver (Network Flows Part 2)
Просмотров 6 тыс.4 года назад
Linear Programming: Assignment with Excel Solver (Network Flows Part 2)
Linear Programming: Transportation with Excel Solver (Network Flows Part 1)
Просмотров 10 тыс.4 года назад
Linear Programming: Transportation with Excel Solver (Network Flows Part 1)
Thanks a lot
Happy to help!
Hi Tallys, I was wondering if you could tell me why when you increase the initial amount to say, $100,000, the solver then says that the problem is no longer linear?
Assuming it was solving before (with 50,000) as the initial amount and not complaining of non-linearity, simply changing the initial 50K to 100K should not be generating this issue. Therefore, it's some sort of bug. I've seen these before with Solver. Sometimes, clicking (or un-clicking) the box that says "Automatic scaling" in the Solver options takes care of this.
@@TallysYunes Thanks! I suppose another way around it would be to convert the initial amount to thousands of dollars, so 100 in my case. This solves fine.
Yes, indeed. Sometimes if you scale the numbers yourself so that the difference between the smallest and the largest number in the data is reduced, this kind of bug goes away. Good thinking!
How do you formulate this with two plants?
If by "two plants" you mean two different products whose inventories have to be tracked, you can simply duplicate the variables and repeat the same set of constraints for each product individually.
@@TallysYunes It's more transshipment in my case. Solver cannot find a solution.
Check out the transshipment example on my playlist (if you haven't yet) and double check that all your constraint formulas are correct. If it can't find a solution, there's at least one constraint that is being too strict.
Anyone who got 6.333333 for X1 instead of 1.333333?
This problem has alternative optimal solutions. As long as you still get 22.333 in cell H16 and all the constraints are satisfied, you're fine.
@@TallysYunes thank you!
if my solver could not find a feasible solution, where and how can i find my own mistake?
This is caused by the problem being over constrained and the issue is with one of the (or a group of the) constraints. What I usually do is this: go to the grey area (i.e. the variables), start with it empty, and then assign some simple values to the grey cells (for example 1 or 2) and check that the resulting calculations that use those cells are returning the values you'd expect to see. Or try inputting a solution that you know should be feasible and then see if some calculated number looks weird. For instance, in this problem, type in the gray area a solution that only makes one type of gasoline. Try this with all gasolines (one at a time). You'll eventually find out where the issue is. In the worst case, go back to the beginning of the video and double check that all the formulas you are typing match mine exactly. Good luck!
🎯 Key Takeaways for quick navigation: 00:00 *📚 Introduction to Integer Programming in Excel* - Overview of transitioning from linear to integer programming, focusing on integral or whole number variables and binary variables for decision-making. - Introduction to binary variables for yes/no decisions and their common applications. - Preview of utilizing binary and whole number variables in Excel models. 02:08 *🎯 Budget Allocation Problem: The Knapsack Problem* - Explanation of the budget allocation problem as a practical application of integer programming, referring to the historical knapsack problem. - Setting the scenario for applying a budget allocation strategy using binary variables in advertising channel selections. - Detailing the process of mapping out the problem's constraints and objectives using a hypothetical business case. 06:05 *💻 Setting up the Excel Model for Integer Programming* - Instructions on creating the Excel model for the problem, including data input, defining binary variables, and formulating the objective and constraints. - Demonstrating the setup of formulas for total exposure and total expense based on binary decisions. - Guidance on using Excel Solver for maximizing exposure within the budget constraint by adjusting Solver parameters for binary variables. 11:07 *🔄 Different Applications of the Knapsack Problem* - Describing the versatility of the knapsack problem by illustrating various real-life applications beyond budget allocation, such as camping gear selection and space mission preparation. - Highlighting the adaptability of the problem structure to different contexts, including time management, space utilization, and auditing projects. - Introduction to extending the binary variable model to accommodate logical conditions in subsequent scenarios. Made with HARPA AI
This is fantastic, Professor! I'd like your thoughts and advice on how to do an MCSim with triangular distribution where the lower bound is negative? Thanks in advance!
What are the 3 parameters of this triangular distribution?
Essentially I’m trying to model future growth in an industrial company that has historically (15 years data) varied from -2% to +8% with median at 3%.
If the triangular function doesn't allow you to enter a negative for the low end, you can shift everything up 2% points and subtract afterward. For example: Cell A = randtriangular(0, 0.05, 0.1), and B = A - 0.02. This will make cell B behave as if it were a randtriangular(-0.02, 0.03, 0.08).
@@TallysYunes Thanks, Prof! Will try this.🙏
So good ! Thank you so much
You're welcome!
dude! I just enrolled in a mba and they have me doing linear optimization. The initial problems weren't bad, but it just seriously kicked up a notch. Would really appreciate if I could send you this one problem in particular and see how you would approach it.
I can't do homework for you, but it's likely that the one you need to tackle is similar to one of the examples in my videos. Look through my Excel Models playlist.
@@TallysYunes of course not! I'll be sure to check out the videos. I'm struggling with determining if it's blending or allocation, and determining the inequalities for blending. Especially when there's multiple rates and units of measurement. Do you offer tutoring?
At the moment I don't have time for one-on-one tutoring, but this is something your teacher would be able to clarify for you (it's their job). Have you tried reaching out to them? Do they offer office hours?
Professor Yunes, Not sure if you still read these but I am loving these videos which help me in my job. My question is, could you force the variable cells to be integers?
Thank you! I'm glad the videos are helping. Yes, you can add an "int" constraint on the gray cells. I don't do it in this video because I use this example to illustrate the ideas I go over at the end of the video to my students.
@@TallysYunes Can I ask what book you recommend? I see a few popular recommendations online. What would you choose?
Here's one that I like: www.amazon.com/Spreadsheet-Modeling-Decision-Analysis-Introduction/dp/130594741X
Hi sir, Can you tell me which video to watch to know how to model this problem in excel so I can solve it and follow through this video? Thanks in advance!
I don't have a detailed video on that, but at the beginning of this video I show you the mathematical formulation and the setup of the Solver window (you can pause the video at that moment and look at what I did). The formulas in column F and in cell B12 are all the same: a SUMPRODUCT. If you watch and understand the Farmer Problem example I have on this channel, you should be able to do this one.
Good video, Thank you!
Recorded four years ago and still relevant and so helpful. I wonder how this will change with new developments in Excel and the use of AI.
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.
wasted hours yesterday checking whether my input variables were correct... Thank you so much for the help!
You're welcome!
You are a very excellent teacher, thank you very much
Thank you!
Subscribed! I hope there's also a version using purely excel formulas, without using 3rd party paid programs such as 'Simvoi'
Thank you! There may be, but I'm not aware of any native Monte Carlo facilities for Excel other than the brute force way that can become very time consuming.
This was a huge help completing my homework assignment in time. Thank you!
You're welcome!
I undoubtably enjoyed your video. I subscribed right away.
Awesome! Thank you!
🙌🏻🤌🏻
such a great man, you saved our life
You're welcome.
Very well explained to be able to interpret these tables !
Thank you! I'm happy to hear it helped!
Note that the you will get 74,908.9 as initial amount for target 100K if the inflows/outflows are baked in. Without inflows/outflows, you should get 71,179.44 as the initial amount needed.
Great Video, you deserve more subs. Keep it up!!
I meant great playlist, not just this video. Doing a marathon of the playlist now :)
You are great man thanks a lot
Thank you! And you're welcome. I'm happy to hear the video was helpful.
Thank you for the clear tutorial. Manage to understand this clearly now.
Great to hear!
Amazing! Really helpful
Thank you!
Great explanation. Thank you!
You're welcome!
Thank you Prof. for given us all these great knowledge for free.
My pleasure!
thank you , really helped out
You're welcome! Glad it helped!
Professor, your passion for the subject is amazing. Would love to learn more things from you
Thank you so much!
Terimakasih banyak bapak
You're welcome!
Brilliant
Where do we add Long-term debt on DCF Analysis ?
I'm not a finance person, so I'm going to need you to give me a thorough explanation of what you're trying to do exactly. Beginning with the definitions of "long-term debt" and "DCF Analysis." Haha!
thanks prof
Thank you so much for explaining, based on your previous video in the playlist i was thinking if we have an additional constraint that if i select the neighbourhood (x) then the adjacent neighbours to x cannot be selected, so then I'll have to place fire stations in neighbourhood such the neighbourhoods that are adjacent to it are not selected, so how can i add this constraint here as a mathematical formulation ?
If I understand your question correctly, you replace the symbol >= with = so that exactly 1 neighborhood is chosen and all the other adjacent ones can't be chosen.
@@TallysYunes oh Thank you, if change the equality sign from>= to = it is not providing any solution to me :(
for example, one of the solutions can be neighbourhoods 1,8,6 as these are not adjacent neighbourhoods and at the same tile 1,8,6 cover all their adjacent neighbourhoods too, that is basically what my question is to choose neighbourhoods to place fire station that are not adjacent to each other but at the same time cover all neighbourhoods too, i hope you understand my question
Ah, OK. NOW I understand what you were asking. Then bring all the original constraints back to >= 1 and, for every pair of neighborhoods that are adjacent, add a new constraint saying at most one of them can be = 1. So for example, because 1 and 2 are adjacent, you add the constraint x1 + x2 <= 1. Repeat for every pair of adjacent neighborhoods. There will be lots of these.
Yunes would you have any problem solution related to quantity production, maximizing profit, with constrains of machine hours and man hours, but simultaneously with information about the manufacture operation a specific hours per week. I got confuse, when for instance, I'm given: man hours, numbers of machine, machine hours, number of hours available for all machines, but at the same time the problem a number of operation hours per week of the plant. Help please.
Think about each kind of resource separately. A product can consume a certain amount of man hours and a certain amount of machine hours. So your constraints could be: (man hours consumed) <= (man hours available) (machine hours consumed) <= (machine hours available) The latter constraint could be one per week (if your variables are products produced per week) or a single one for the entire operation. Without seeing more details of the problem, it's hard to tell. At the moment, I don't have a specific video of an example that's similar to what you describe. But this is a good idea for a future video.
This is amazing wow!!!!!!!! not me going back and watching the episode again to view with an optimization eye angle :))). keep posting such amazing creative content. THANK YOU
Haha! Thank you! I'm happy to hear you enjoyed it! I'm on season 6 now but haven't found another case yet where optimization could help. But this was a fun video to make.
Yes ofcourse! also i wanted to ask if you do not mind all the questions that you cover in the playlist are covered by my optimization professor so was wondering what textbook or reference do you use to get these questions so that i can practice more with similar questions?@@TallysYunes
The videos in my "Excel Models" playlist go over the examples I cover in my intro to optimization class that I teach at the Undergrad/Masters/MBA level. I followed the book by Cliff Ragsdale entitled "Spreadsheet Modeling and Decision Analysis" until 2019 (been using my own notes since then). If you're looking for additional practice problems on these topics, this book is a great source of examples. You can get a used 7th edition of this book on Amazon for very little money.
would be nice if you could get to the point of the video!
🤣 The point of the video is explained within the first 2 minutes. 🤣
definitely the best explanation i have found.
Thank you! I'm happy to hear the video has been helpful.
best explanation of the sensi report.
Thank you!
lovely, my brain blew off yesterday while doing the assignment...thank you.
You're welcome!
same
This is a cool problem! Perfect for showing binary integer programming models.
I agree! Glad you liked it!
Thanks man it helped a lot :D
You're welcome!
Thank you so much for this Video Not even in your class but really helped me
You're very welcome!
Really cool. I'm trying to solve a problem with multiple constraints... I'm spinning my wheels!
Take a look at my "Excel Models" playlist. There's a good chance the one you're trying to solve is similar to a problem I address in there.
very nice videos
Thank you!
@@TallysYunes Can you videos about: MILP to solve Job Shoo scheduling problem using excel. Like this one: www.ijmer.com/papers/Vol7_issue3/Version-2/D7322329.pdf I really hope you can do 👌🙏
if a problem include production cost in plant how to include those in to the cost equation
If these are costs per unit produced (rather than fixed costs), they can be added to the costs of the arcs that depart from the plant.
Hello Sir, please make a video about this: drive.google.com/file/d/1QLdiRT3rzqgYntI6sJy5SOmhFCqUaTWf/view?usp=sharing but using Excel not Lingo! @@TallysYunes
I hope you can do that sir🙏