Man thank you I wish I could give you my money instead of my professors. I’ll repay you one day
@MattMacarty5 жыл бұрын
Glad it helped. c
@matthewh43774 жыл бұрын
Thank you Matt! Ive spent hours trying to interpret my professor's videos and you taught this in 20 mins! My university needs to fire my professor and give me a refund as well! - Thanks dude! Im sending your link to the class
@belladonnagammidge85723 жыл бұрын
I got help from thechinahacks financially .They got me a transfer of $37,000 just yesterday .
@soulmanjerome073 жыл бұрын
@@MattMacarty This is a great review on how to use solver. Any other ones? I second Goon Head's comment. My professors focused on the results but not the Answer Report, Sensitivity Report, and Limits Report.
@yonathantadesse33853 жыл бұрын
lol 😂 for real
@CT-mc3sy4 жыл бұрын
Thank you!!! So much better than my prof at explaining, especially since you use much clearer terms.
@MattMacarty4 жыл бұрын
Thanks. Glad it helped.
@justinfay3011 Жыл бұрын
@@MattMacarty Do you help with homework at a reasonable $/hr rate? The model I have to create is very complicated!
@8sevenstudiosphotography4693 жыл бұрын
It baffles me that Matt made this problem so easy to understand. Why can’t my Professor break it down like this? Thanks Matt!
@MattMacarty3 жыл бұрын
Thanks. Glad it helped.
@CamilleEssick5 жыл бұрын
I think I watched about 5 videos before I found one that has the best example on what to do. Thanks!!! Short and Simple!!
@MattMacarty5 жыл бұрын
Thank you. Glad it helped.
@jimparsons68033 жыл бұрын
Interesting. ... going to school in the early 70s, we did all of this by hand... with the use of a slide rule to estimate the answer and then draw a couple of graphs by hand to zero in on the better answer. Them were the days!! Enjoyed the clip.
@MattMacarty3 жыл бұрын
They still teach that in school, but without the slide rule.
@jamesquaranto8606 Жыл бұрын
@@MattMacarty we would just use our Ti-84 and a pencil and paper to solve these in my operations management class.
@melo42462 жыл бұрын
Extremely good video. I was pulling my hair in class because my teacher was confusing everyone. Thank you!
@MattMacarty2 жыл бұрын
Thank you. Glad it helped
@88spaces4 жыл бұрын
Matt, thank you for taking the time to produce this video. It has helped me a lot.
@MattMacarty4 жыл бұрын
Thank you. Glad it helped.
@portaltaker2 жыл бұрын
Saved me for my Quantitative Analytics module! My lecturer explained this so badly, thank you!
@MattMacarty2 жыл бұрын
Glad it helped
@williamhylen3273 жыл бұрын
You are a god among men. This is the best explanation of this I have heard. Thank you.
@MattMacarty3 жыл бұрын
Thanks. Glad it helped.
@ASB-cf2ke6 жыл бұрын
easy way to learn ,good work to the developers of the video
@MattMacarty6 жыл бұрын
Thanks. Glad it helped.
@nirtheart4 жыл бұрын
Edit: I found it! I had to go to Data/Solver and then go through the set-up there and the "Limits Report" showed up! Thank you so much for the video again! Thank you for the insightful video! Only thing I was unable to do on my own when following your video was to find the "Limits Report" which didn't show up anywhere in my Excel document. I'm using the newest versions of things, so it probably is just somewhere I don't know where to look for it
@MattMacarty4 жыл бұрын
Glad it helped.
@meatbeater54254 жыл бұрын
You saved my ass. I have an assignment on this and I had no idea before I watched this video.
@MattMacarty4 жыл бұрын
Glad it helped
@ravneethanda82283 жыл бұрын
Thank you so much. I was struggling to solve LP with excel solver and your video helped me a lot.
@MattMacarty3 жыл бұрын
Glad it helped!
@RandlemanProductions10 ай бұрын
Thank you so much!!!! I had so much trouble with understanding this and you explained it perfectly. I now understand this. THANK YOU!!!
@MattMacarty10 ай бұрын
Glad it helped!
@jrels Жыл бұрын
Thorough and clear explanation. THANKS so much :)
@MattMacarty Жыл бұрын
Glad it helped
@zizo873710 ай бұрын
I don’t understand why professors make so difficult huhhh thanksss a lot man❤
@MattMacarty10 ай бұрын
Thanks. Glad it helped
@AbdoulayeDiallo-xu4hx4 жыл бұрын
Wow man, you are a LEGEND; the way you explain.... just wow. I wish I could trade you with my professor.
@MattMacarty4 жыл бұрын
hank you. Glad it helped.
@laurenwood27025 жыл бұрын
Easy to understand and so much easier than doing the simplex method by hand 🙏🙌 Thank you!
@MattMacarty5 жыл бұрын
Glad it helped
@Light-vu6ws2 жыл бұрын
You're awesome for replying to every comment. Good video!
@MattMacarty2 жыл бұрын
Thanks. Glad it helped
@user-ru2ry7rm3p6 жыл бұрын
Thank you for posting this! you explained it in a easy but clear way. Now, I know how to solve my assignment problem. Thank you!
@MattMacarty6 жыл бұрын
Glad it helped.
@nomnom914 Жыл бұрын
thanks, gonna use this to find probable missing amounts
@MattMacarty Жыл бұрын
Glad it helped
@oneandonlylfs84066 жыл бұрын
THANK YOU! This helped me finally understand Solver.
@MattMacarty6 жыл бұрын
Thanks. Glad it helped.
@Dret42885 жыл бұрын
Let me tell you. You definitely aleviated a headache and got me out of a tough spot. You explained and showed me this in a manner that was easy to pick up thanks a ton.
@MattMacarty5 жыл бұрын
Thanks very much. Glad it helped.
@soumyadeepchatterjee21892 жыл бұрын
Explained clearly. Thank You, Matt!
@MattMacarty2 жыл бұрын
Great it helped
@kushikachhabra80213 жыл бұрын
Great video. My professor took 2 hours to teach this method and i did not understand a thing. whereas you made me understand it in 10 mins. :)
@MattMacarty3 жыл бұрын
Glad it helped!
@powellnine14773 жыл бұрын
Thank you very much for your KZbin video. I’ve subscribed to your channel.
@MattMacarty3 жыл бұрын
Thanks! Glad it helped
@RamandeepSingh-kk4zt2 жыл бұрын
This is the best explanation I've seen so far💯 ,Thank you Sir☺️
@MattMacarty2 жыл бұрын
You are welcome. Glad it helped.
@zainabhashimi6 жыл бұрын
it was easy to learn and certainly very helpful to me. Thank you so much for making this video!
@MattMacarty6 жыл бұрын
Thanks. Glad it helped
@rozthepuffer10372 жыл бұрын
My professor literally gave us a link to this video instead of just teaching it himself, I wish I can just take back the money I gave to my professor and give it to you instead. Have my like and sub cuz idk how else to repay u back
@MattMacarty2 жыл бұрын
Glad it helped.
@reinssz3 жыл бұрын
Thank you so much for this video. It really helps a lot for my upcoming report with this kind of topic. Thanks a bunch!
@MattMacarty3 жыл бұрын
Glad it helped
@evridikson4 жыл бұрын
Saved me a lot of time and stress, can't thank you enough!!
@MattMacarty4 жыл бұрын
Glad it helped
@brandycurtisrichards69464 жыл бұрын
Great video! Thank you so much for the explanation.
@MattMacarty4 жыл бұрын
Thank you. Glad it helped
@nayaroni Жыл бұрын
So helpful, thank you so much Matt!
@MattMacarty Жыл бұрын
Glad it helped.
@erickodhiambo37833 жыл бұрын
Very clear and easily understood. Thank you
@MattMacarty3 жыл бұрын
Glad it helped
@satviksoni84993 жыл бұрын
so so so helpfull, gonna submit my semester project with t your spreadsheet. thank you so muchh
@MattMacarty3 жыл бұрын
Glad it helped.
@AniMax_cjs3 жыл бұрын
you're really a good tutor. thank you so much. this helped a lot.
@MattMacarty3 жыл бұрын
Thanks. Glad it helped.
@arwinderkaur44113 жыл бұрын
Hi Matt! Thanks for your video, this really helped me to find the LP for my problem.
@MattMacarty3 жыл бұрын
Glad it helped!
@ltrof Жыл бұрын
man you are literally a god thank you so much !!!!!
@MattMacarty Жыл бұрын
Thanks. Glad it helped
@jemimamagak5 жыл бұрын
You are incredible thank you for your help 🙏🤗
@MattMacarty5 жыл бұрын
Glad it helped
@mrmoe52723 жыл бұрын
Better than my professor explanation that took 6 classes and I did not understand a thing
@MattMacarty3 жыл бұрын
Glad it helped
@Faz527 Жыл бұрын
Wow! well explained. Thanks.
@MattMacarty Жыл бұрын
Thank you. Glad it helped.
@clmkc5393Ай бұрын
Using this in a business merger and acquisition deal in the Midwest. Its a maximization problem of how much capital to allocate to acquisition 1 vs acquisition 2. Its tricky in that the constraints are sensative to changes and are somewhat subjective. For example, we are using return on investment (ROI) as our maximization goal - similar to the "profits goal" in the video. However, the characteristics used as inputs on ROI have some nuances - i.e, capitalization rates, time horizon, standard deviation of cash flows, industry betas and overall risk profiles. Nevertheless, it does provide a methodology to analyze capital allocations to different investments. I saw the other comments about how Linear Programming is taught at the university level. I experienced the same issue at both the undergraduate and graduate level. It was the most time intensive class I took and most of the learning I received was from my own investigation as the Prof didn't seem to care much about what we absorbed or was so far advanced that he had a difficult time bringing down to an introductory level. Stay with it though - its good real world usage your getting.
@MattMacartyАй бұрын
Thanks for your comment
@laksyy5 жыл бұрын
Very clear and concise tutorial thank you!
@MattMacarty5 жыл бұрын
Thank you. Glad it helped.
@onyemaugoh48132 жыл бұрын
Thank you so much this was super helpful
@MattMacarty2 жыл бұрын
Glad it helped!
@jmac25005 жыл бұрын
Very helpful and straight forward - thank you!
@MattMacarty5 жыл бұрын
Glad it helped.
@stephenip32594 жыл бұрын
Back in the days, we used simplex method, and I wrote C program to solve the opimization... now there is an excel solver.... People have forgotten the importance of solving problems on their own.
@MattMacarty4 жыл бұрын
Agreed If I were in a classroom I would have started by solving with Simplex and then moved onto Solver. Most courses still cover with a graphical example so you can see what's going on but as soon as you move past a couple of variables pretty much everyone is using a solver. I was actually considering showing Simplex with a python program but I haven't gotten to it yet.
@mariamelendez86154 жыл бұрын
Thank you for making this video!
@MattMacarty4 жыл бұрын
Glad it helped
@s108t2 жыл бұрын
thanks Matt, you're awesome
@MattMacarty2 жыл бұрын
Thanks. Glad it helped.
@KCRcats2 жыл бұрын
Thank you! This helped a lot
@MattMacarty2 жыл бұрын
Glad it helped!
@Tsunade647 жыл бұрын
Thank you! Awesome job btw, and very clearly and thoroughly explained :)
@MattMacarty7 жыл бұрын
Thanks. Glad it helped.
@Philantrope3 жыл бұрын
Thank you - very well explained!
@MattMacarty3 жыл бұрын
Glad it helped.
@HungTran-fj8hg5 жыл бұрын
Saved my life homie. Much love.
@MattMacarty5 жыл бұрын
Glad it helped
@CaptainMoroni95 жыл бұрын
Very easy to understand, thank you!
@MattMacarty5 жыл бұрын
Glad it helped
@mariavelasco4422 Жыл бұрын
Thank you! Very helpful
@MattMacarty Жыл бұрын
Glad it helped
@mrfoxviiska4 жыл бұрын
Thanks. You teach better than my prof. who teach in the most famous university in my country.... #youtuisbetterteacherthanteacherinclass
@MattMacarty4 жыл бұрын
Thank you. Glad it helped.
@mohammadrezaghasemi67925 жыл бұрын
Thank you Matt. It was very helpful for me 🙏
@MattMacarty5 жыл бұрын
Glad it helped
@desipuspitasari70795 жыл бұрын
Thank you so much!! Now I understand a lot!
@MattMacarty5 жыл бұрын
Thanks. Glad it helped.
@VedikaKhandelwal3 жыл бұрын
LIFESAVER THANK YOU SO MUCH
@MattMacarty3 жыл бұрын
Glad it helped
@GSZ8186 жыл бұрын
Thank you so much, really helped a lot!! Awesome work
@MattMacarty6 жыл бұрын
Thanks. Glad it helped.
@alifikri98243 жыл бұрын
im student from indonesia, thank youu this video really helpful :)
@MattMacarty3 жыл бұрын
Glad it was helpful!
@surik.54813 жыл бұрын
sen türk değil misin şimdi? ali fikri türkçe ad değil mi?
@oussamadeziri48066 жыл бұрын
Thanks for the help! Definitely useful stuff
@MattMacarty6 жыл бұрын
Glad it helped
@kyle38185 жыл бұрын
Video really helped me! Thank you!
@MattMacarty5 жыл бұрын
Thanks. Glad it helped
@umarwaqas6496 жыл бұрын
Thank you. Well explained. Great Job (thumbs up).
@MattMacarty6 жыл бұрын
Glad it helped.
@aashishphatate70035 жыл бұрын
Thank you! Video was very helpful!! :)
@MattMacarty5 жыл бұрын
Glad it helped
@poorlydrawnstickman16603 жыл бұрын
Very helpful! Thank you.
@MattMacarty3 жыл бұрын
Glad it helped
@roardinoson76 жыл бұрын
Thanks Matt - it was help in college
@MattMacarty6 жыл бұрын
Glad it helped.
@iWillRun_5 жыл бұрын
My Professor shared this Video with in class :)
@MattMacarty5 жыл бұрын
Thanks, hop it helped.
@iWillRun_5 жыл бұрын
@@MattMacarty Thankyou too :)
@henrymsipa21914 жыл бұрын
very helpful, thank you very much for sharing
@MattMacarty4 жыл бұрын
Thanks. Glad it helped
@rishondanapier14452 жыл бұрын
Thank you so much.
@MattMacarty2 жыл бұрын
Glad it helped
@davidszabo93024 жыл бұрын
Thank you so much!!!
@MattMacarty2 жыл бұрын
Glad it helped
@SuperMegamalik6 жыл бұрын
Excellent Matt
@MattMacarty6 жыл бұрын
Thanks, glad it helped.
@adolfom90916 жыл бұрын
You are the man!
@MattMacarty6 жыл бұрын
Thanks. Glad it helped
@TerryBowl Жыл бұрын
perfect thanks!
@MattMacarty Жыл бұрын
Glad it helped
@1rasha2 жыл бұрын
This sensitivity report is not clear. Can you make a detailed video on its analysis please
@MattMacarty2 жыл бұрын
You mean you can't see the report? You can changethe settings to HD and that should clear it up.
@milesdeichler97004 жыл бұрын
Thank you so much
@MattMacarty4 жыл бұрын
Glad it helped
@CarlosOrtiz-ht6rn5 жыл бұрын
Thank you!
@MattMacarty5 жыл бұрын
Glad it helped.
@siddharthGupta6326 жыл бұрын
Thank you very much. :-)
@MattMacarty6 жыл бұрын
Glad it helped.
@minseokkim70976 жыл бұрын
Thank you so much. Can I share this youtube with my students?
@MattMacarty6 жыл бұрын
Thanks. Yes please feel free to share.
@kayodeolakunleoluwaseyi42733 жыл бұрын
Wonderful video... Can we use excel solver to solve goal programming?
@MattMacarty3 жыл бұрын
Yes, you may also be able to simply use goal seek
@shambhabchaki54082 жыл бұрын
thank you!!!!
@MattMacarty2 жыл бұрын
Glad it helped
@NinOo794 Жыл бұрын
Can you give me the same example (question, issue) Because I want to solve it on my own?
@MattMacarty Жыл бұрын
Hi. I am not sure what you mean. If you want to download the spreadsheet I used follow this link: alphabench.com/data/linear-programming-optimization.html
@LiLi-ul8jy5 жыл бұрын
Do you have an example on linear programming to minimize interest payment? Example whether to get bank loan at the beginning of the year or monthly loan or combination of both types of loan. I can’t seem to find any examples online. Hope you can show an example. Thank you.
@MattMacarty5 жыл бұрын
Glad it helped
@shikharsingh15403 жыл бұрын
Awesome
@MattMacarty3 жыл бұрын
Glad it helped
@RV225 жыл бұрын
Thank you!!!
@MattMacarty5 жыл бұрын
Glad it helped
@mansigupta927 Жыл бұрын
THANKYOUUUUUU
@MattMacarty Жыл бұрын
Glad it helped
@becajaja52173 жыл бұрын
Thank you #Matt Macarty
@MattMacarty3 жыл бұрын
Glad it helped.
@houssainchaer83353 жыл бұрын
Your channel it s very helpful 👏👏 I just want to ask How we can use linear programming for asset allocation
@MattMacarty3 жыл бұрын
HI. Take a look at this one: kzbin.info/www/bejne/qXqYiWWhf6aSas0
@houssainchaer83353 жыл бұрын
@@MattMacarty can we solve it with simpleLP ?
@MattMacarty3 жыл бұрын
@@houssainchaer8335 Well whatever we do is based on a forecasted return and volatility. There are many ways to formulate the problem, my video describes one of them where we maximize Sharpe ratio.
@hakankosebas2085 Жыл бұрын
can you do it with multiple objective? and can we pick one thing from list with multiple objective problem with excel solver?
@MattMacarty Жыл бұрын
You can only have one objective function.
@Icey_tata6 жыл бұрын
hi- to define if i exceeding daily usage what would be my constraints?
@MattMacarty6 жыл бұрын
I think you will just have to compare actual usage with "optimal" usage
@mookaclement22702 жыл бұрын
Hello Matt, what keys did you press for you to change (B4:C4) to ($B$4:$C$4)??
@MattMacarty2 жыл бұрын
It's F4 (function4) in Windows, command + T in MAC
@umargalaria69093 жыл бұрын
How to avoid decimal number. I want natural number but i keep getting decimal numbers
@MattMacarty3 жыл бұрын
Yes it happens. Probably the easiest thing is to hide the decimals. You could also force integer values by setting int as a constraint on the changing cells.
@merinasaha36696 жыл бұрын
Can you articulate the example in a paragraph or give the link of the example?
@MattMacarty6 жыл бұрын
Hi. I have posted in the video description: kzbin.info/www/bejne/bKnEYquVftadsMk
@nathaniellmolinaa51883 жыл бұрын
when i add subj to constraints it says unequal number of cell ref and constraints, however they are equal, how do i fix this? thanks great video btw, just encountered some technical difficulties
@MattMacarty3 жыл бұрын
Thanks. It's probably telling you that you have selected different dimensions for one of the ranges, so maybe three cells for one and two for the other or something similar. You can download the spreadsheet here: alphabench.com/data/linear-programming-optimization.html
@mdaroza9 ай бұрын
I'm wondering if you can help set up the following question in Solver: I'm travelling 15000km. Each tire has travel a max distance of 10000km (assume I start with a set of 4 tires). What is the min number of tires I need to use to complete the trip?
@MattMacarty8 ай бұрын
I may be missing something, but this sounds like a simple algebra problem
@mdaroza8 ай бұрын
@@MattMacarty I'd like to know if Solver is smart enough to calculate that I need 6 tires as opposed to 8.
@MattMacarty8 ай бұрын
It should if you set the objective to minimize instead of maximize.
@mdaroza8 ай бұрын
@@MattMacartyI think this is where I’m struggling with, is to set up the constraints.
@calliebless68944 жыл бұрын
How do you do a weight using your format? I have a problem that I set up just like you did, but one product cannot account for more than 50% of units produced and another has to account for at least 20%. Thanks for your help!
@MattMacarty4 жыл бұрын
So you need side constraints. This example has something like what you are talking about: kzbin.info/www/bejne/eZDZYaWipbl4o8U
@faadumomataan51046 жыл бұрын
thanks
@MattMacarty6 жыл бұрын
Glad it helped
@leecurcio61325 жыл бұрын
Hi. I have a question. I created a macro (VBA) that emulates the solver by clicking on a button. The problem is that sometime I have to click 3-4 times before getting the last results. Do you know how to avoid this and getting on solution with one click?
@MattMacarty5 жыл бұрын
Hi. This is really difficult to diagnose, but one thing to consider is that usually there are many feasible solutions, but only one optimal solution. it sounds like maybe your script is stopping once it finds a feasible solution and then on subsequent runs it gets closer and closer to the optimal. Another common problem is in the modeling step. It's pretty easy to design your model in such a way that it is no longer linear. When this happens you sometimes end up with "local" optima rather than global optima.
@jamieharvie98273 жыл бұрын
Hi! I am a little confused about 5:37 for the total profit function. Can you explain what you did? I tried sum product for the number to make * used numbers and got VALUE!.
@MattMacarty3 жыл бұрын
This may mean you have selected the wrong range for one of the arguments or ranges of different sizes. You can download my spreadsheet here: alphabench.com/data/linear-programming-optimization.html
@aliciadecou5 жыл бұрын
When you start doing the SUMPRODUCT part you lose me. It doesn't show how you copied it down and I do not get the $ as you do. I only get the B3:C3 part and there is no explanation on the video as to how you did that since the cell you had already formatted
@MattMacarty5 жыл бұрын
Hi to add absolute referencing ($), if in Windows press F4. If in MAC press command + T. To copy the formula down position your mouse over the lower right corner of a cell and then click and drag or double-click.
@nomnom914 Жыл бұрын
how can i add a constraint to disable the use of decimal?
@MattMacarty Жыл бұрын
You can solve as an integer problem, but it's likely better to just decrease decimals in Excel
@nomnom914 Жыл бұрын
@@MattMacarty found it, its in the constraints button, set the operator to int