No video

Solving Linear Programming Problem using Excel's Solver

  Рет қаралды 419,838

Tim Melvin

Tim Melvin

Күн бұрын

Пікірлер: 112
@JesusIsLordForever316
@JesusIsLordForever316 4 жыл бұрын
Out of all the videos on KZfaq... this one helped me the most with my studies. Thank you for making this.
@stephenip3259
@stephenip3259 4 жыл бұрын
Straight forward and simple. The best tutorial.
@b0nniebr0wn
@b0nniebr0wn 9 ай бұрын
It has taken me 3 years to finally find a video that actually help me learn how to do this correctly! Thank you!!!
@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.
@EngineeringHooksets
@EngineeringHooksets 3 жыл бұрын
Thank you so much. Our prof has been teaching us these in python but this is 100x easier. Saved my life
@quangleuc2682
@quangleuc2682 5 ай бұрын
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
@shanna-kayswazey204
@shanna-kayswazey204 5 ай бұрын
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!
@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
@Dhoomie
@Dhoomie 2 жыл бұрын
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 2 жыл бұрын
mba from where
@Dhoomie
@Dhoomie 2 жыл бұрын
@@sumitentertaiment7156 I meant my professor, not the youtuber xd
@xinziwei9760
@xinziwei9760 2 ай бұрын
The best video I've ever found to explain how to use solver:) Thanks!!!
@h.s.3883
@h.s.3883 6 ай бұрын
I appreciate videos like this! I spent too long stressing about it and now it makes sense. Thank you for sharing!
@user-gz8ep1fp4n
@user-gz8ep1fp4n Жыл бұрын
This has been life saver for me, I did my assignment in 5mins after learning from this video. Thank you!
@damianrico2433
@damianrico2433 2 жыл бұрын
Tim, Great Video!! I have been looking for someone to break it down the way you did, completely appreciate the video!
@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
@odie7479
@odie7479 3 жыл бұрын
Best explanation..... I got my work right after just following step by step . Thanks a lot
@pimschakel7840
@pimschakel7840 2 ай бұрын
Great and clear tutorial!! Super helpfull!!!
@berhanumekonen5191
@berhanumekonen5191 6 жыл бұрын
OH ! stil now I am doing with only simplex and graphical methods ,so it is very helpfull for me .THAXS !!!!
@solo-cg2oo
@solo-cg2oo Жыл бұрын
this video helped me the most out of all the others , thanks man
@nagyakos4802
@nagyakos4802 2 жыл бұрын
Tim you just saved the day my man! I really do appreciate your effort!!
@TheFoxHound626
@TheFoxHound626 Жыл бұрын
Tim you saved our lives, we will build statues in your honor.
@Strawberryknight
@Strawberryknight 4 жыл бұрын
Thank you. It is much clearer than any instructions on youtube.
@lusandamtembu7383
@lusandamtembu7383 Жыл бұрын
MY MAN TIM, GOAT
@TheRealStructurer
@TheRealStructurer 9 ай бұрын
Good tutorial 👍 To make the formulas easier to read I guess you can use named variables instead of cell references?
@user-ve8vc7rp3d
@user-ve8vc7rp3d 9 ай бұрын
Thank u for sharing this, well explained
@duyvo5315
@duyvo5315 Жыл бұрын
Thanks a lot sir, your tutorial is very clear and easy to understand
@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.
@bagelsmmmm789
@bagelsmmmm789 5 жыл бұрын
Thanks, man, really helped me out here.
@kevinmutahi5417
@kevinmutahi5417 Жыл бұрын
This is the best tutorial so far!
@anandimerchant5180
@anandimerchant5180 9 ай бұрын
Yay! Wonderfully explained...5 stars
@towfiqrahman4016
@towfiqrahman4016 Жыл бұрын
Great work, very nice presentation and very helpful 👌
@homeromendoza6574
@homeromendoza6574 4 жыл бұрын
awesome. this is the vid that made it crystal clear.
@gurunathreddy9270
@gurunathreddy9270 3 жыл бұрын
Tq so much for wonderful explain I do in exams perfectly 👍👍🙏🙏
@bjj7309
@bjj7309 Жыл бұрын
graet video!!! Thank you so so so so so much tim .
@soniadetert1733
@soniadetert1733 8 күн бұрын
Thank you! very helpfull.
@learnwithash12345
@learnwithash12345 8 ай бұрын
Very informative and time saving!
@mayshadid
@mayshadid 3 жыл бұрын
Thank you. Straight forward and simple.
@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"
@MadelineHatch
@MadelineHatch Жыл бұрын
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.
@cabinoasis7565
@cabinoasis7565 Жыл бұрын
Extremely helpful! Thanks!!!
@ChristyAjayi
@ChristyAjayi 10 күн бұрын
very helpful
@ThinboxStudios
@ThinboxStudios 3 жыл бұрын
Thanks a lot! this video helped me with my class!!!!
@sugoiiibeats
@sugoiiibeats 6 ай бұрын
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
@bharatwasi6392
@bharatwasi6392 Жыл бұрын
thank you guruji
@amjeenzoo4019
@amjeenzoo4019 2 жыл бұрын
thank you so much , finally a clear explanation
@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?
@bafanamhlahlo1717
@bafanamhlahlo1717 2 жыл бұрын
thanks my friend
@yufankoh5624
@yufankoh5624 3 жыл бұрын
you saved my life 😭 thanks!!!
@ev1836
@ev1836 4 жыл бұрын
Omg this was incredibly helpful tysm
@dansheks6509
@dansheks6509 4 жыл бұрын
Very clear and easy to understand
@justinparis9287
@justinparis9287 3 жыл бұрын
You saved my grade thank you
@tommy2598
@tommy2598 4 жыл бұрын
thanks, now i can solve me task.. you really helped.
@ClassofCABE
@ClassofCABE 2 жыл бұрын
You are a life and grade saver!!!!!
@tuli1954
@tuli1954 Жыл бұрын
can you have the goal function being evaluated by a macro?
@princeemma-ejikeme2622
@princeemma-ejikeme2622 Жыл бұрын
what happened to the coefficients of the objective function variables
@samilab1097
@samilab1097 5 жыл бұрын
1. Consider the 0-1 integer programming problem that follows: X1 X2 X3 RHS Maximize 50 45 48 Constraint 1 19 27 34
@amohtontoh47
@amohtontoh47 2 жыл бұрын
Hello Tim, if you have constraint with bracket, how do you go about it ? Do you open up the bracket ?
@ganganaltangerel6293
@ganganaltangerel6293 3 жыл бұрын
Thank you! It helped a lot!
@gauravmakkar9803
@gauravmakkar9803 4 жыл бұрын
I think it will be enough to save my butt, Thanks man
@ahmadcooper40
@ahmadcooper40 Жыл бұрын
Amazing, thank you!
@joannalagden6457
@joannalagden6457 5 жыл бұрын
Fantastic video thank you!
@tausif3239
@tausif3239 5 жыл бұрын
Really helpful..thanks man.
@jackcurtiscanada
@jackcurtiscanada 6 жыл бұрын
How come you don't have to add the actual objective function? 3x1+2x2-x3?
@melvinmath
@melvinmath 6 жыл бұрын
The objective function is entered in cell B8 in the video.
@ELearninghub
@ELearninghub 6 жыл бұрын
you can try this kzfaq.info/get/bejne/Z69ikrSBrMvGkps.html here you can learn how to define objective function along with Solver tutorial
@jackcurtiscanada
@jackcurtiscanada 6 жыл бұрын
Thanks Tim!
@amjadmahmood5904
@amjadmahmood5904 10 ай бұрын
Thank you so much
@shattastudiosuk
@shattastudiosuk 4 жыл бұрын
I have a linear programming question I have having difficulty in solving . Would you mind to help ?
@OFFSETPRINTMK
@OFFSETPRINTMK Жыл бұрын
Thanks a lot!
@user-wn9pr1wg3f
@user-wn9pr1wg3f Жыл бұрын
if I use the mmult function i get different answer Why??
@anandanarayanang187
@anandanarayanang187 9 ай бұрын
Thank you.
@WESAFYGE5
@WESAFYGE5 Жыл бұрын
Thank u so much.
@bballmstr
@bballmstr 4 жыл бұрын
thank you so much bro saved me!
@majidachettiyamveettil1377
@majidachettiyamveettil1377 3 жыл бұрын
THank u soo much..it helped
@hrishikeshmoghe5305
@hrishikeshmoghe5305 5 жыл бұрын
Awesomeee thanks you soo much sir!
@paulalangadan8375
@paulalangadan8375 3 жыл бұрын
what do you do with the coefficients??
@Menakinjin
@Menakinjin 10 ай бұрын
THANK YOU!!
@ishain7564
@ishain7564 3 жыл бұрын
You're a life saver! Thank you ❤️
@luci1474
@luci1474 2 жыл бұрын
how do you get the values first tho?
@darwin_ate_my_dcf
@darwin_ate_my_dcf 9 ай бұрын
thank you paaaji !!!!
@amantiwari1916
@amantiwari1916 11 ай бұрын
Thanks man 🙏
@ebenezerkaunda8879
@ebenezerkaunda8879 2 жыл бұрын
Thank you so much🙌
@lamiamouli8243
@lamiamouli8243 5 жыл бұрын
Very helpful
@safiaatou7
@safiaatou7 6 ай бұрын
Thanks ❤️
@davidsanchez8360
@davidsanchez8360 4 жыл бұрын
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 4 жыл бұрын
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.
@cadenceforte8571
@cadenceforte8571 3 жыл бұрын
You are a life saver...LOL
@shashankksaraf8390
@shashankksaraf8390 3 жыл бұрын
very helpful!
@4upranit
@4upranit 4 жыл бұрын
Can i Use sumproduct function ?
@chengheo9276
@chengheo9276 3 жыл бұрын
why all my value go to 0, after click solver
@eddyalonso7661
@eddyalonso7661 Жыл бұрын
Thanks!!
@zishanhossain1451
@zishanhossain1451 10 ай бұрын
how to add a not equal to
@yashsgupta17
@yashsgupta17 Жыл бұрын
Thanks❤
@Alluneedismosh
@Alluneedismosh 4 жыл бұрын
Thank you!
@sriharikrish518
@sriharikrish518 4 жыл бұрын
Can you post this problem in excel file
@yomnaemad2213
@yomnaemad2213 3 жыл бұрын
THANK YOU THANK YOU THANK YOU!
@pushtishah1495
@pushtishah1495 8 ай бұрын
thank you sm
@jagcsekaran5639
@jagcsekaran5639 4 жыл бұрын
Thanx Tim!!!
@bastienclarke1810
@bastienclarke1810 5 жыл бұрын
Cool
@syafiqahshukor
@syafiqahshukor Жыл бұрын
terima kasih bang
@sridharans5165
@sridharans5165 5 жыл бұрын
you have done a great job out there nigga.!
@mohammedmisbah5796
@mohammedmisbah5796 2 жыл бұрын
Very good bro
@mohammedmisbah5796
@mohammedmisbah5796 2 жыл бұрын
I love your Chanel content bro
@jnkvngz2965
@jnkvngz2965 Жыл бұрын
gather here UG students
@funtimes7305
@funtimes7305 3 жыл бұрын
Thanksssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss!
@obertylibuku4350
@obertylibuku4350 Жыл бұрын
Improve on the video quality
Solve Linear Program problem in Excel (Solver)
5:22
Joshua Emmanuel
Рет қаралды 112 М.
Linear Optimization in Excel with Solver Add-in | LPP in Excel
11:11
Sane's Academy of Artificial Intelligence
Рет қаралды 34 М.
Parenting hacks and gadgets against mosquitoes 🦟👶
00:21
Let's GLOW!
Рет қаралды 12 МЛН
Transport Cost Optimization Using Solver in Excel
14:36
PK: An Excel Expert
Рет қаралды 76 М.
Intro to Linear Programming
14:23
Dr. Trefor Bazett
Рет қаралды 183 М.
The Art of Linear Programming
18:56
Tom S
Рет қаралды 650 М.
Linear Programming (LP) Optimization with Excel  Solver
17:32
Matt Macarty
Рет қаралды 631 М.
Linear Programming 1: Maximization -Extreme/Corner Points (LP)
5:43
Joshua Emmanuel
Рет қаралды 961 М.
Maximize Profit by Optimizing Production Using Excel Solver
10:51
Linear Programming Solver Excel
23:28
Jason Bitmead
Рет қаралды 102 М.
Excel Solver - Example and Step-By-Step Explanation
9:57
Leila Gharani
Рет қаралды 997 М.
Parenting hacks and gadgets against mosquitoes 🦟👶
00:21
Let's GLOW!
Рет қаралды 12 МЛН