Solving Linear Programming Problem using Excel's Solver

  Рет қаралды 460,583

Tim Melvin

Tim Melvin

Күн бұрын

Пікірлер: 117
@JesusIsLordForever316
@JesusIsLordForever316 4 жыл бұрын
Out of all the videos on KZbin... this one helped me the most with my studies. Thank you for making this.
@b0nniebr0wn
@b0nniebr0wn Жыл бұрын
It has taken me 3 years to finally find a video that actually help me learn how to do this correctly! Thank you!!!
@stephenip3259
@stephenip3259 5 жыл бұрын
Straight forward and simple. The best tutorial.
@EngineeringHooksets
@EngineeringHooksets 4 жыл бұрын
Thank you so much. Our prof has been teaching us these in python but this is 100x easier. Saved my life
@linky6452
@linky6452 Жыл бұрын
Tim Melvin, more like Tim Delving into the depths of academia to help me with a project that I have. Sorry Tim, your name didn't rhyme quite like I'd hope it would but the help you have provided me today is immeasurable. Thank you good sir.
@h.s.3883
@h.s.3883 11 ай бұрын
I appreciate videos like this! I spent too long stressing about it and now it makes sense. Thank you for sharing!
@KanwaljitDhiman
@KanwaljitDhiman Жыл бұрын
This has been life saver for me, I did my assignment in 5mins after learning from this video. Thank you!
@Dhoomie
@Dhoomie 3 жыл бұрын
I attended every class so far in this semester, i decided to not attend a class cause i had another midterm, and to my surprise the test will be mostly simplex method questions using the solver. Don't know why he went through the process of teaching us how to do all the iterations manually, but thank god your video exists.
@sumitentertaiment7156
@sumitentertaiment7156 3 жыл бұрын
mba from where
@Dhoomie
@Dhoomie 3 жыл бұрын
@@sumitentertaiment7156 I meant my professor, not the youtuber xd
@damianrico2433
@damianrico2433 2 жыл бұрын
Tim, Great Video!! I have been looking for someone to break it down the way you did, completely appreciate the video!
@azusazi0628
@azusazi0628 7 ай бұрын
The best video I've ever found to explain how to use solver:) Thanks!!!
@quangleuc2682
@quangleuc2682 10 ай бұрын
Thank you so much its 2024 and still helped me. I am a university students i couldnt get anything in class but watching this video has solved everything
@SanjitSinghSall
@SanjitSinghSall 3 жыл бұрын
You are the best. My exam is going on and I did not know a word about this solver.. boom u helped me solve all questions
@solo-cg2oo
@solo-cg2oo Жыл бұрын
this video helped me the most out of all the others , thanks man
@zubeirjamaa
@zubeirjamaa 2 ай бұрын
Thank you so much! Clear, concise, and straight right the point.
@nagyakos4802
@nagyakos4802 3 жыл бұрын
Tim you just saved the day my man! I really do appreciate your effort!!
@Strawberryknight
@Strawberryknight 5 жыл бұрын
Thank you. It is much clearer than any instructions on youtube.
@NolanPham20sThought
@NolanPham20sThought Жыл бұрын
Thank you so much 🥹 Even in 2023 ur lecture still help me survive Business Decision, meanwhile my teacher failed to make me understand this
@TheFoxHound626
@TheFoxHound626 2 жыл бұрын
Tim you saved our lives, we will build statues in your honor.
@shanna-kayswazey204
@shanna-kayswazey204 10 ай бұрын
Thank you very much!! This was by far the most detailed and helpful video! It really helped me to undersatnad the concept! You explained it so well!
@bagelsmmmm789
@bagelsmmmm789 5 жыл бұрын
Thanks, man, really helped me out here.
@kevinmutahi5417
@kevinmutahi5417 2 жыл бұрын
This is the best tutorial so far!
@odie7479
@odie7479 3 жыл бұрын
Best explanation..... I got my work right after just following step by step . Thanks a lot
@homeromendoza6574
@homeromendoza6574 5 жыл бұрын
awesome. this is the vid that made it crystal clear.
@Shalimarsunrisers
@Shalimarsunrisers 4 ай бұрын
Absolute stunning video❤
@dragoacimovic5001
@dragoacimovic5001 6 жыл бұрын
Dear Tim, I saw your post ~ Solving Linear Programming Problem using Excel's Solver ~ I would ask you to help me solve a single task with Solver, since I'm bad at Solver.
@towfiqrahman4016
@towfiqrahman4016 Жыл бұрын
Great work, very nice presentation and very helpful 👌
@EkramDardeer
@EkramDardeer Жыл бұрын
Thank u for sharing this, well explained
@pimschakel7840
@pimschakel7840 7 ай бұрын
Great and clear tutorial!! Super helpfull!!!
@berhanumekonen5191
@berhanumekonen5191 7 жыл бұрын
OH ! stil now I am doing with only simplex and graphical methods ,so it is very helpfull for me .THAXS !!!!
@ClassofCABE
@ClassofCABE 3 жыл бұрын
You are a life and grade saver!!!!!
@anandimerchant5180
@anandimerchant5180 Жыл бұрын
Yay! Wonderfully explained...5 stars
@musewhipser
@musewhipser 3 ай бұрын
Thanks, very helpful, and one question, what does RHS mean?
@learnwithash12345
@learnwithash12345 Жыл бұрын
Very informative and time saving!
@duyvo5315
@duyvo5315 2 жыл бұрын
Thanks a lot sir, your tutorial is very clear and easy to understand
@lusandamtembu7383
@lusandamtembu7383 Жыл бұрын
MY MAN TIM, GOAT
@cabinoasis7565
@cabinoasis7565 Жыл бұрын
Extremely helpful! Thanks!!!
@mayshadid
@mayshadid 3 жыл бұрын
Thank you. Straight forward and simple.
@TheRealStructurer
@TheRealStructurer Жыл бұрын
Good tutorial 👍 To make the formulas easier to read I guess you can use named variables instead of cell references?
@yufankoh5624
@yufankoh5624 3 жыл бұрын
you saved my life 😭 thanks!!!
@ev1836
@ev1836 5 жыл бұрын
Omg this was incredibly helpful tysm
@dansheks6509
@dansheks6509 4 жыл бұрын
Very clear and easy to understand
@ThinboxStudios
@ThinboxStudios 3 жыл бұрын
Thanks a lot! this video helped me with my class!!!!
@ChristyAjayi
@ChristyAjayi 5 ай бұрын
very helpful
@bjj7309
@bjj7309 Жыл бұрын
graet video!!! Thank you so so so so so much tim .
@amjeenzoo4019
@amjeenzoo4019 2 жыл бұрын
thank you so much , finally a clear explanation
@bafanamhlahlo1717
@bafanamhlahlo1717 2 жыл бұрын
thanks my friend
@MadelineHatch
@MadelineHatch 2 жыл бұрын
at the part where you calculated the maximum equation, why did you add the first two x's but subtracted the 3rd? In my class we just added all of them.
@justinparis9287
@justinparis9287 3 жыл бұрын
You saved my grade thank you
@ganganaltangerel6293
@ganganaltangerel6293 3 жыл бұрын
Thank you! It helped a lot!
@tommy2598
@tommy2598 4 жыл бұрын
thanks, now i can solve me task.. you really helped.
@tuli1954
@tuli1954 Жыл бұрын
can you have the goal function being evaluated by a macro?
@tausif3239
@tausif3239 5 жыл бұрын
Really helpful..thanks man.
@gurunathreddy9270
@gurunathreddy9270 3 жыл бұрын
Tq so much for wonderful explain I do in exams perfectly 👍👍🙏🙏
@soniadetert1733
@soniadetert1733 5 ай бұрын
Thank you! very helpfull.
@lamiamouli8243
@lamiamouli8243 5 жыл бұрын
Very helpful
@afiahayat2644
@afiahayat2644 3 жыл бұрын
Discuss the statement: "An operating system (OS) exploits the hardware resources of one or more processors to provide a set of service to system users"
@gauravmakkar9803
@gauravmakkar9803 4 жыл бұрын
I think it will be enough to save my butt, Thanks man
@sugoiiibeats
@sugoiiibeats 11 ай бұрын
where can I find a solver solution with a word problem from beginning to end?? I cannot find one anywhere for my life and I'm struggling
@princeemma-ejikeme2622
@princeemma-ejikeme2622 Жыл бұрын
what happened to the coefficients of the objective function variables
@bharatwasi6392
@bharatwasi6392 2 жыл бұрын
thank you guruji
@ahmadcooper40
@ahmadcooper40 2 жыл бұрын
Amazing, thank you!
@amohtontoh47
@amohtontoh47 3 жыл бұрын
Hello Tim, if you have constraint with bracket, how do you go about it ? Do you open up the bracket ?
@luci1474
@luci1474 3 жыл бұрын
how do you get the values first tho?
@paulalangadan8375
@paulalangadan8375 4 жыл бұрын
what do you do with the coefficients??
@hrishikeshmoghe5305
@hrishikeshmoghe5305 5 жыл бұрын
Awesomeee thanks you soo much sir!
@shattastudiosuk
@shattastudiosuk 5 жыл бұрын
I have a linear programming question I have having difficulty in solving . Would you mind to help ?
@majidachettiyamveettil1377
@majidachettiyamveettil1377 4 жыл бұрын
THank u soo much..it helped
@bballmstr
@bballmstr 5 жыл бұрын
thank you so much bro saved me!
@ebenezerkaunda8879
@ebenezerkaunda8879 2 жыл бұрын
Thank you so much🙌
@joannalagden6457
@joannalagden6457 6 жыл бұрын
Fantastic video thank you!
@theapexpredator157
@theapexpredator157 3 жыл бұрын
I need Solver to accept formulas in the Variable Cells Line so that it can select only certain cells within a range. Is this possible? If not, is there an alternate method to achieve my goal?
@cadenceforte8571
@cadenceforte8571 4 жыл бұрын
You are a life saver...LOL
@amantiwari1916
@amantiwari1916 Жыл бұрын
Thanks man 🙏
@4upranit
@4upranit 4 жыл бұрын
Can i Use sumproduct function ?
@amjadmahmood5904
@amjadmahmood5904 Жыл бұрын
Thank you so much
@OFFSETPRINTMK
@OFFSETPRINTMK 2 жыл бұрын
Thanks a lot!
@darwin_ate_my_dcf
@darwin_ate_my_dcf Жыл бұрын
thank you paaaji !!!!
@Menakinjin
@Menakinjin Жыл бұрын
THANK YOU!!
@yomnaemad2213
@yomnaemad2213 4 жыл бұрын
THANK YOU THANK YOU THANK YOU!
@safiaatou7
@safiaatou7 11 ай бұрын
Thanks ❤️
@WESAFYGE5
@WESAFYGE5 2 жыл бұрын
Thank u so much.
@MarshallVinck
@MarshallVinck Жыл бұрын
if I use the mmult function i get different answer Why??
@shashankksaraf8390
@shashankksaraf8390 3 жыл бұрын
very helpful!
@jackcurtiscanada
@jackcurtiscanada 7 жыл бұрын
How come you don't have to add the actual objective function? 3x1+2x2-x3?
@melvinmath
@melvinmath 7 жыл бұрын
The objective function is entered in cell B8 in the video.
@ELearninghub
@ELearninghub 7 жыл бұрын
you can try this kzbin.info/www/bejne/Z3qVkISGfMqVmMk here you can learn how to define objective function along with Solver tutorial
@jackcurtiscanada
@jackcurtiscanada 7 жыл бұрын
Thanks Tim!
@catsofMumbai
@catsofMumbai 3 жыл бұрын
You're a life saver! Thank you ❤️
@anandanarayanang187
@anandanarayanang187 Жыл бұрын
Thank you.
@sriharikrish518
@sriharikrish518 4 жыл бұрын
Can you post this problem in excel file
@yashsgupta17
@yashsgupta17 2 жыл бұрын
Thanks❤
@Nerpy-D-Derp
@Nerpy-D-Derp 4 жыл бұрын
Thank you!
@jagcsekaran5639
@jagcsekaran5639 5 жыл бұрын
Thanx Tim!!!
@mohammedmisbah5796
@mohammedmisbah5796 3 жыл бұрын
Very good bro
@mohammedmisbah5796
@mohammedmisbah5796 3 жыл бұрын
I love your Chanel content bro
@zishanhossain1451
@zishanhossain1451 Жыл бұрын
how to add a not equal to
@chengheo9276
@chengheo9276 4 жыл бұрын
why all my value go to 0, after click solver
@eddyalonso7661
@eddyalonso7661 Жыл бұрын
Thanks!!
@pushtishah1495
@pushtishah1495 Жыл бұрын
thank you sm
@bastienclarke1810
@bastienclarke1810 5 жыл бұрын
Cool
@sakinbuyukkayin
@sakinbuyukkayin 26 күн бұрын
hacettepe endüstri case study ödevinden selamlar
@yigit521
@yigit521 25 күн бұрын
selam
@jnkvngz2965
@jnkvngz2965 2 жыл бұрын
gather here UG students
@davidsanchez8360
@davidsanchez8360 5 жыл бұрын
Great video, thanks! But how would it be possible to restrict the optimal solution to whole numbers? I get decimals :facepalm: It's probably an easy fix, but I can't figure it out 🙁
@gouravnayak182
@gouravnayak182 5 жыл бұрын
You can try with changing formula for Z. Put INT(currentformula). Best way that I recommend is to add int in the constraint box for decision variables.
@sridharans5165
@sridharans5165 6 жыл бұрын
you have done a great job out there nigga.!
Solve Linear Program problem in Excel (Solver)
5:22
Joshua Emmanuel
Рет қаралды 170 М.
Linear Programming (LP) Optimization with Excel  Solver
17:32
Matt Macarty
Рет қаралды 652 М.
It works #beatbox #tiktok
00:34
BeatboxJCOP
Рет қаралды 41 МЛН
Linear Programming Solver Excel
23:28
Jason Bitmead
Рет қаралды 110 М.
Excel Solver & Goal Seek Tutorial
23:34
Kevin Stratvert
Рет қаралды 183 М.
Maximize Profit by Optimizing Production Using Excel Solver
10:51
Intro to Linear Programming
14:23
Dr. Trefor Bazett
Рет қаралды 211 М.
Linear Programming (Optimization) 2 Examples Minimize & Maximize
15:08
Mario's Math Tutoring
Рет қаралды 615 М.
Excel Solver - Example and Step-By-Step Explanation
9:57
Leila Gharani
Рет қаралды 1 МЛН
Transport Cost Optimization Using Solver in Excel
14:36
PK: An Excel Expert
Рет қаралды 82 М.