Solving Linear Programming Problem using Excel's Solver

  Рет қаралды 414,496

Tim Melvin

7 жыл бұрын

Пікірлер: 110
@NoTimeLikeThePRESENCE
@NoTimeLikeThePRESENCE 4 жыл бұрын
Out of all the videos on KZbin... this one helped me the most with my studies. Thank you for making this.
@b0nniebr0wn
@b0nniebr0wn 8 ай бұрын
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 4 жыл бұрын
Straight forward and simple. The best tutorial.
@YoutuberOutOfContext
@YoutuberOutOfContext Жыл бұрын
Thank you so much 🥹 Even in 2023 ur lecture still help me survive Business Decision, meanwhile my teacher failed to make me understand this
@EngineeringHooksets
@EngineeringHooksets 3 жыл бұрын
Thank you so much. Our prof has been teaching us these in python but this is 100x easier. Saved my life
@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!
@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 5 ай бұрын
I appreciate videos like this! I spent too long stressing about it and now it makes sense. Thank you for sharing!
@nagyakos4802
@nagyakos4802 2 жыл бұрын
Tim you just saved the day my man! I really do appreciate your effort!!
@Strawberryknight
@Strawberryknight 4 жыл бұрын
Thank you. It is much clearer than any instructions on youtube.
@quangleuc2682
@quangleuc2682 3 ай бұрын
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
@odie7479
@odie7479 3 жыл бұрын
Best explanation..... I got my work right after just following step by step . Thanks a lot
@xinziwei9760
@xinziwei9760 26 күн бұрын
The best video I've ever found to explain how to use solver:) Thanks!!!
@bagelsmmmm789
@bagelsmmmm789 5 жыл бұрын
Thanks, man, really helped me out here.
@solo-cg2oo
@solo-cg2oo Жыл бұрын
this video helped me the most out of all the others , thanks man
@berhanumekonen5191
@berhanumekonen5191 6 жыл бұрын
OH ! stil now I am doing with only simplex and graphical methods ,so it is very helpfull for me .THAXS !!!!
@homeromendoza6574
@homeromendoza6574 4 жыл бұрын
awesome. this is the vid that made it crystal clear.
@kevinmutahi5417
@kevinmutahi5417 Жыл бұрын
This is the best tutorial so far!
@mayshadid
@mayshadid 3 жыл бұрын
Thank you. Straight forward and simple.
@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
@shanna-kayswazey204
@shanna-kayswazey204 3 ай бұрын
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!
@ClassofCABE
@ClassofCABE 2 жыл бұрын
You are a life and grade saver!!!!!
@towfiqrahman4016
@towfiqrahman4016 Жыл бұрын
Great work, very nice presentation and very helpful 👌
@cabinoasis7565
@cabinoasis7565 Жыл бұрын
Extremely helpful! Thanks!!!
@yufankoh5624
@yufankoh5624 3 жыл бұрын
you saved my life 😭 thanks!!!
@ev1836
@ev1836 4 жыл бұрын
Omg this was incredibly helpful tysm
@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
@pimschakel7840
@pimschakel7840 25 күн бұрын
Great and clear tutorial!! Super helpfull!!!
@joannalagden6457
@joannalagden6457 5 жыл бұрын
Fantastic video thank you!
@learnwithash12345
@learnwithash12345 7 ай бұрын
Very informative and time saving!
@tommy2598
@tommy2598 4 жыл бұрын
thanks, now i can solve me task.. you really helped.
@ThinboxStudios
@ThinboxStudios 3 жыл бұрын
Thanks a lot! this video helped me with my class!!!!
@tausif3239
@tausif3239 5 жыл бұрын
Really helpful..thanks man.
@dansheks6509
@dansheks6509 4 жыл бұрын
Very clear and easy to understand
@amjeenzoo4019
@amjeenzoo4019 Жыл бұрын
thank you so much , finally a clear explanation
@ganganaltangerel6293
@ganganaltangerel6293 3 жыл бұрын
Thank you! It helped a lot!
@duyvo5315
@duyvo5315 Жыл бұрын
Thanks a lot sir, your tutorial is very clear and easy to understand
@TheRealStructurer
@TheRealStructurer 8 ай бұрын
Good tutorial 👍 To make the formulas easier to read I guess you can use named variables instead of cell references?
@anandimerchant5180
@anandimerchant5180 8 ай бұрын
Yay! Wonderfully explained...5 stars
@user-ve8vc7rp3d
@user-ve8vc7rp3d 8 ай бұрын
Thank u for sharing this, well explained
@lusandamtembu7383
@lusandamtembu7383 Жыл бұрын
MY MAN TIM, GOAT
@ahmadcooper40
@ahmadcooper40 Жыл бұрын
Amazing, thank you!
@gurunathreddy9270
@gurunathreddy9270 2 жыл бұрын
Tq so much for wonderful explain I do in exams perfectly 👍👍🙏🙏
@bjj7309
@bjj7309 Жыл бұрын
graet video!!! Thank you so so so so so much tim .
@hrishikeshmoghe5305
@hrishikeshmoghe5305 5 жыл бұрын
Awesomeee thanks you soo much sir!
@amohtontoh47
@amohtontoh47 2 жыл бұрын
Hello Tim, if you have constraint with bracket, how do you go about it ? Do you open up the bracket ?
@justinparis9287
@justinparis9287 3 жыл бұрын
You saved my grade thank you
@gauravmakkar9803
@gauravmakkar9803 4 жыл бұрын
I think it will be enough to save my butt, Thanks man
@bballmstr
@bballmstr 4 жыл бұрын
thank you so much bro saved me!
@ishain7564
@ishain7564 2 жыл бұрын
You're a life saver! Thank you ❤️
@majidachettiyamveettil1377
@majidachettiyamveettil1377 3 жыл бұрын
THank u soo much..it helped
@OFFSETPRINTMK
@OFFSETPRINTMK Жыл бұрын
Thanks a lot!
@Menakinjin
@Menakinjin 9 ай бұрын
THANK YOU!!
@Nerpy-D-Derp
@Nerpy-D-Derp 4 жыл бұрын
Thank you!
@jagcsekaran5639
@jagcsekaran5639 4 жыл бұрын
Thanx Tim!!!
@shashankksaraf8390
@shashankksaraf8390 3 жыл бұрын
very helpful!
@ebenezerkaunda8879
@ebenezerkaunda8879 2 жыл бұрын
Thank you so much🙌
@tuli1954
@tuli1954 Жыл бұрын
can you have the goal function being evaluated by a macro?
@lamiamouli8243
@lamiamouli8243 5 жыл бұрын
Very helpful
@paulalangadan8375
@paulalangadan8375 3 жыл бұрын
what do you do with the coefficients??
@yomnaemad2213
@yomnaemad2213 3 жыл бұрын
THANK YOU THANK YOU THANK YOU!
@cadenceforte8571
@cadenceforte8571 3 жыл бұрын
You are a life saver...LOL
@lakshaychhabra9972
@lakshaychhabra9972 8 ай бұрын
thank you paaaji !!!!
@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.
@WESAFYGE5
@WESAFYGE5 Жыл бұрын
Thank u so much.
@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?
@amjadmahmood5904
@amjadmahmood5904 9 ай бұрын
Thank you so much
@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.
@anandanarayanang187
@anandanarayanang187 7 ай бұрын
Thank you.
@TheFoxHound626
@TheFoxHound626 Жыл бұрын
Tim you saved our lives, we will build statues in your honor.
@amantiwari1916
@amantiwari1916 10 ай бұрын
Thanks man 🙏
@bafanamhlahlo1717
@bafanamhlahlo1717 Жыл бұрын
thanks my friend
@bharatwasi6392
@bharatwasi6392 Жыл бұрын
thank you guruji
@eddyalonso7661
@eddyalonso7661 Жыл бұрын
Thanks!!
@GB001TV
@GB001TV 4 жыл бұрын
I have a linear programming question I have having difficulty in solving . Would you mind to help ?
@luci1474
@luci1474 2 жыл бұрын
how do you get the values first tho?
@pushtishah1495
@pushtishah1495 7 ай бұрын
thank you sm
@safiaatou7
@safiaatou7 4 ай бұрын
Thanks ❤️
@princeemma-ejikeme2622
@princeemma-ejikeme2622 Жыл бұрын
what happened to the coefficients of the objective function variables
@4upranit
@4upranit 4 жыл бұрын
Can i Use sumproduct function ?
@yashsgupta17
@yashsgupta17 Жыл бұрын
Thanks❤
@bastienclarke1810
@bastienclarke1810 5 жыл бұрын
Cool
@afiahayat2644
@afiahayat2644 2 жыл бұрын
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"
@syafiqahshukor
@syafiqahshukor Жыл бұрын
terima kasih bang
@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 kzbin.info/www/bejne/Z3qVkISGfMqVmMk here you can learn how to define objective function along with Solver tutorial
@jackcurtiscanada
@jackcurtiscanada 6 жыл бұрын
Thanks Tim!
@sriharikrish518
@sriharikrish518 4 жыл бұрын
Can you post this problem in excel file
@chengheo9276
@chengheo9276 3 жыл бұрын
why all my value go to 0, after click solver
@sugoiiibeats
@sugoiiibeats 5 ай бұрын
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
@user-wn9pr1wg3f
@user-wn9pr1wg3f Жыл бұрын
if I use the mmult function i get different answer Why??
@zishanhossain1451
@zishanhossain1451 9 ай бұрын
how to add a not equal to
@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.
@sridharans5165
@sridharans5165 5 жыл бұрын
you have done a great job out there nigga.!
@funtimes7305
@funtimes7305 3 жыл бұрын
Thanksssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss!
@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
@mohammedmisbah5796
@mohammedmisbah5796 2 жыл бұрын
Very good bro
@mohammedmisbah5796
@mohammedmisbah5796 2 жыл бұрын
I love your Chanel content bro
@obertylibuku4350
@obertylibuku4350 11 ай бұрын
Improve on the video quality
@jnkvngz2965
@jnkvngz2965 Жыл бұрын
gather here UG students
@Raj-wj2zv
@Raj-wj2zv 2 жыл бұрын
,k
@fintancolaco7398
@fintancolaco7398 5 жыл бұрын
Have my fucking babies.
NERF WAR HEAVY: Drone Battle!
00:30
MacDannyGun
Рет қаралды 50 МЛН
The child was abused by the clown#Short #Officer Rabbit #angel
00:55
兔子警官
Рет қаралды 24 МЛН
Sigma Girl Past #funny #sigma #viral
00:20
CRAZY GREAPA
Рет қаралды 34 МЛН
NERF WAR HEAVY: Drone Battle!
00:30
MacDannyGun
Рет қаралды 50 МЛН