Solving Linear Programming Problem using Excel's Solver

Поділитися
Вставка
  • Опубліковано 27 чер 2017

КОМЕНТАРІ • 110

  • @NoTimeLikeThePRESENCE
    @NoTimeLikeThePRESENCE 4 роки тому +43

    Out of all the videos on UA-cam... this one helped me the most with my studies. Thank you for making this.

  • @stephenip3259
    @stephenip3259 4 роки тому +30

    Straight forward and simple. The best tutorial.

  • @EngineeringHooksets
    @EngineeringHooksets 3 роки тому +16

    Thank you so much. Our prof has been teaching us these in python but this is 100x easier. Saved my life

  • @YoutuberOutOfContext
    @YoutuberOutOfContext Рік тому +9

    Thank you so much 🥹 Even in 2023 ur lecture still help me survive Business Decision, meanwhile my teacher failed to make me understand this

  • @b0nniebr0wn
    @b0nniebr0wn 8 місяців тому +1

    It has taken me 3 years to finally find a video that actually help me learn how to do this correctly! Thank you!!!

  • @damianrico2433
    @damianrico2433 2 роки тому +1

    Tim, Great Video!! I have been looking for someone to break it down the way you did, completely appreciate the video!

  • @user-gz8ep1fp4n
    @user-gz8ep1fp4n Рік тому

    This has been life saver for me, I did my assignment in 5mins after learning from this video. Thank you!

  • @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!!

  • @linky6452
    @linky6452 Рік тому +2

    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.

  • @Strawberryknight
    @Strawberryknight 4 роки тому

    Thank you. It is much clearer than any instructions on youtube.

  • @odie7479
    @odie7479 3 роки тому

    Best explanation..... I got my work right after just following step by step .
    Thanks a lot

  • @xinziwei9760
    @xinziwei9760 29 днів тому

    The best video I've ever found to explain how to use solver:) Thanks!!!

  • @berhanumekonen5191
    @berhanumekonen5191 6 років тому +1

    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

  • @bagelsmmmm789
    @bagelsmmmm789 5 років тому +6

    Thanks, man, really helped me out here.

  • @homeromendoza6574
    @homeromendoza6574 4 роки тому +1

    awesome. this is the vid that made it crystal clear.

  • @shanna-kayswazey204
    @shanna-kayswazey204 4 місяці тому

    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!

  • @mayshadid
    @mayshadid 3 роки тому

    Thank you. Straight forward and simple.

  • @kevinmutahi5417
    @kevinmutahi5417 Рік тому

    This is the best tutorial so far!

  • @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

  • @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

  • @pimschakel7840
    @pimschakel7840 29 днів тому

    Great and clear tutorial!! Super helpfull!!!

  • @ClassofCABE
    @ClassofCABE 2 роки тому

    You are a life and grade saver!!!!!

  • @duyvo5315
    @duyvo5315 Рік тому

    Thanks a lot sir, your tutorial is very clear and easy to understand

  • @towfiqrahman4016
    @towfiqrahman4016 Рік тому

    Great work, very nice presentation and very helpful 👌

  • @ev1836
    @ev1836 4 роки тому +1

    Omg this was incredibly helpful tysm

  • @yufankoh5624
    @yufankoh5624 3 роки тому

    you saved my life 😭 thanks!!!

  • @tommy2598
    @tommy2598 4 роки тому

    thanks, now i can solve me task.. you really helped.

  • @Dhoomie
    @Dhoomie 2 роки тому +1

    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

  • @ThinboxStudios
    @ThinboxStudios 3 роки тому

    Thanks a lot! this video helped me with my class!!!!

  • @cabinoasis7565
    @cabinoasis7565 Рік тому

    Extremely helpful! Thanks!!!

  • @amjeenzoo4019
    @amjeenzoo4019 Рік тому

    thank you so much , finally a clear explanation

  • @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

  • @learnwithash12345
    @learnwithash12345 7 місяців тому

    Very informative and time saving!

  • @ganganaltangerel6293
    @ganganaltangerel6293 3 роки тому

    Thank you! It helped a lot!

  • @tausif3239
    @tausif3239 5 років тому

    Really helpful..thanks man.

  • @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 .

  • @joannalagden6457
    @joannalagden6457 5 років тому

    Fantastic video thank you!

  • @amohtontoh47
    @amohtontoh47 2 роки тому

    Hello Tim, if you have constraint with bracket, how do you go about it ? Do you open up the bracket ?

  • @gauravmakkar9803
    @gauravmakkar9803 4 роки тому

    I think it will be enough to save my butt, Thanks man

  • @hrishikeshmoghe5305
    @hrishikeshmoghe5305 5 років тому

    Awesomeee thanks you soo much sir!

  • @lusandamtembu7383
    @lusandamtembu7383 Рік тому

    MY MAN TIM, GOAT

  • @user-ve8vc7rp3d
    @user-ve8vc7rp3d 8 місяців тому

    Thank u for sharing this, well explained

  • @bballmstr
    @bballmstr 4 роки тому

    thank you so much bro saved me!

  • @dansheks6509
    @dansheks6509 4 роки тому

    Very clear and easy to understand

  • @ahmadcooper40
    @ahmadcooper40 Рік тому

    Amazing, thank you!

  • @justinparis9287
    @justinparis9287 3 роки тому

    You saved my grade thank you

  • @ishain7564
    @ishain7564 2 роки тому

    You're a life saver! Thank you ❤️

  • @majidachettiyamveettil1377
    @majidachettiyamveettil1377 3 роки тому

    THank u soo much..it helped

  • @cadenceforte8571
    @cadenceforte8571 3 роки тому

    You are a life saver...LOL

  • @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?

  • @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.

  • @Menakinjin
    @Menakinjin 9 місяців тому

    THANK YOU!!

  • @OFFSETPRINTMK
    @OFFSETPRINTMK Рік тому

    Thanks a lot!

  • @jagcsekaran5639
    @jagcsekaran5639 4 роки тому

    Thanx Tim!!!

  • @yomnaemad2213
    @yomnaemad2213 3 роки тому

    THANK YOU THANK YOU THANK YOU!

  • @dragoacimovic5001
    @dragoacimovic5001 6 років тому +2

    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.

  • @TheFoxHound626
    @TheFoxHound626 Рік тому

    Tim you saved our lives, we will build statues in your honor.

  • @lakshaychhabra9972
    @lakshaychhabra9972 8 місяців тому

    thank you paaaji !!!!

  • @tuli1954
    @tuli1954 Рік тому

    can you have the goal function being evaluated by a macro?

  • @ebenezerkaunda8879
    @ebenezerkaunda8879 2 роки тому

    Thank you so much🙌

  • @shashankksaraf8390
    @shashankksaraf8390 3 роки тому

    very helpful!

  • @Nerpy-D-Derp
    @Nerpy-D-Derp 4 роки тому

    Thank you!

  • @amantiwari1916
    @amantiwari1916 10 місяців тому

    Thanks man 🙏

  • @GB001TV
    @GB001TV 4 роки тому

    I have a linear programming question I have having difficulty in solving . Would you mind to help ?

  • @WESAFYGE5
    @WESAFYGE5 Рік тому

    Thank u so much.

  • @paulalangadan8375
    @paulalangadan8375 3 роки тому

    what do you do with the coefficients??

  • @lamiamouli8243
    @lamiamouli8243 5 років тому

    Very helpful

  • @eddyalonso7661
    @eddyalonso7661 Рік тому

    Thanks!!

  • @amjadmahmood5904
    @amjadmahmood5904 9 місяців тому

    Thank you so much

  • @anandanarayanang187
    @anandanarayanang187 8 місяців тому

    Thank you.

  • @bafanamhlahlo1717
    @bafanamhlahlo1717 Рік тому

    thanks my friend

  • @bharatwasi6392
    @bharatwasi6392 Рік тому +1

    thank you guruji

  • @pushtishah1495
    @pushtishah1495 7 місяців тому

    thank you sm

  • @luci1474
    @luci1474 2 роки тому

    how do you get the values first tho?

  • @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

  • @syafiqahshukor
    @syafiqahshukor Рік тому

    terima kasih bang

  • @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"

  • @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

  • @jackcurtiscanada
    @jackcurtiscanada 6 років тому +1

    How come you don't have to add the actual objective function? 3x1+2x2-x3?

    • @melvinmath
      @melvinmath  6 років тому +3

      The objective function is entered in cell B8 in the video.

    • @ELearninghub
      @ELearninghub 6 років тому +1

      you can try this ua-cam.com/video/1I2_QPGebbg/v-deo.html
      here you can learn how to define objective function along with Solver tutorial

    • @jackcurtiscanada
      @jackcurtiscanada 6 років тому

      Thanks Tim!

  • @user-wn9pr1wg3f
    @user-wn9pr1wg3f Рік тому

    if I use the mmult function i get different answer Why??

  • @sridharans5165
    @sridharans5165 5 років тому

    you have done a great job out there nigga.!

  • @chengheo9276
    @chengheo9276 3 роки тому

    why all my value go to 0, after click solver

  • @zishanhossain1451
    @zishanhossain1451 9 місяців тому

    how to add a not equal to

  • @sriharikrish518
    @sriharikrish518 4 роки тому

    Can you post this problem in excel file

  • @funtimes7305
    @funtimes7305 3 роки тому +1

    Thanksssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss!

  • @davidsanchez8360
    @davidsanchez8360 4 роки тому +1

    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.

  • @samilab1097
    @samilab1097 5 років тому +1

    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

  • @jnkvngz2965
    @jnkvngz2965 Рік тому

    gather here UG students

  • @obertylibuku4350
    @obertylibuku4350 11 місяців тому

    Improve on the video quality

  • @Raj-wj2zv
    @Raj-wj2zv 2 роки тому

    ,k

  • @fintancolaco7398
    @fintancolaco7398 5 років тому

    Have my fucking babies.