Solving Linear Programming Problem using Excel's Solver

Поделиться
HTML-код
  • Опубликовано: 27 июн 2017

Комментарии • 110

  • @NoTimeLikeThePRESENCE
    @NoTimeLikeThePRESENCE 4 года назад +42

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

  • @b0nniebr0wn
    @b0nniebr0wn 7 месяцев назад +1

    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 года назад +30

    Straight forward and simple. The best tutorial.

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

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

  • @EngineeringHooksets
    @EngineeringHooksets 3 года назад +15

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

  • @nagyakos4802
    @nagyakos4802 2 года назад

    Tim you just saved the day my man! I really do appreciate your effort!!

  • @YoutuberOutOfContext
    @YoutuberOutOfContext Год назад +8

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

  • @xinziwei9760
    @xinziwei9760 16 дней назад

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

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

  • @user-gz8ep1fp4n
    @user-gz8ep1fp4n 11 месяцев назад

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

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

  • @Strawberryknight
    @Strawberryknight 4 года назад

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

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

  • @odie7479
    @odie7479 3 года назад

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

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

  • @berhanumekonen5191
    @berhanumekonen5191 6 лет назад +1

    OH ! stil now I am doing with only simplex and graphical methods ,so it is very helpfull for me .THAXS !!!!

  • @mayshadid
    @mayshadid 3 года назад

    Thank you. Straight forward and simple.

  • @towfiqrahman4016
    @towfiqrahman4016 Год назад

    Great work, very nice presentation and very helpful 👌

  • @homeromendoza6574
    @homeromendoza6574 4 года назад +1

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

  • @kevinmutahi5417
    @kevinmutahi5417 Год назад

    This is the best tutorial so far!

  • @TheRealStructurer
    @TheRealStructurer 8 месяцев назад

    Good tutorial 👍
    To make the formulas easier to read I guess you can use named variables instead of cell references?

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

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

  • @ev1836
    @ev1836 4 года назад +1

    Omg this was incredibly helpful tysm

  • @pimschakel7840
    @pimschakel7840 16 дней назад

    Great and clear tutorial!! Super helpfull!!!

  • @ClassofCABE
    @ClassofCABE 2 года назад

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

  • @yufankoh5624
    @yufankoh5624 3 года назад

    you saved my life 😭 thanks!!!

  • @ThinboxStudios
    @ThinboxStudios 3 года назад

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

  • @cabinoasis7565
    @cabinoasis7565 Год назад

    Extremely helpful! Thanks!!!

  • @tommy2598
    @tommy2598 4 года назад

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

  • @tausif3239
    @tausif3239 5 лет назад

    Really helpful..thanks man.

  • @duyvo5315
    @duyvo5315 Год назад

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

  • @learnwithash12345
    @learnwithash12345 7 месяцев назад

    Very informative and time saving!

  • @lusandamtembu7383
    @lusandamtembu7383 Год назад

    MY MAN TIM, GOAT

  • @joannalagden6457
    @joannalagden6457 5 лет назад

    Fantastic video thank you!

  • @anandimerchant5180
    @anandimerchant5180 7 месяцев назад

    Yay! Wonderfully explained...5 stars

  • @amjeenzoo4019
    @amjeenzoo4019 Год назад

    thank you so much , finally a clear explanation

  • @user-ve8vc7rp3d
    @user-ve8vc7rp3d 7 месяцев назад

    Thank u for sharing this, well explained

  • @ganganaltangerel6293
    @ganganaltangerel6293 3 года назад

    Thank you! It helped a lot!

  • @bjj7309
    @bjj7309 Год назад

    graet video!!! Thank you so so so so so much tim .

  • @dansheks6509
    @dansheks6509 4 года назад

    Very clear and easy to understand

  • @hrishikeshmoghe5305
    @hrishikeshmoghe5305 5 лет назад

    Awesomeee thanks you soo much sir!

  • @gurunathreddy9270
    @gurunathreddy9270 2 года назад

    Tq so much for wonderful explain I do in exams perfectly 👍👍🙏🙏

  • @ahmadcooper40
    @ahmadcooper40 Год назад

    Amazing, thank you!

  • @gauravmakkar9803
    @gauravmakkar9803 4 года назад

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

  • @justinparis9287
    @justinparis9287 3 года назад

    You saved my grade thank you

  • @bballmstr
    @bballmstr 4 года назад

    thank you so much bro saved me!

  • @amohtontoh47
    @amohtontoh47 2 года назад

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

  • @lamiamouli8243
    @lamiamouli8243 5 лет назад

    Very helpful

  • @ishain7564
    @ishain7564 2 года назад

    You're a life saver! Thank you ❤️

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

  • @tuli1954
    @tuli1954 Год назад

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

  • @TheFoxHound626
    @TheFoxHound626 Год назад

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

  • @lakshaychhabra9972
    @lakshaychhabra9972 7 месяцев назад

    thank you paaaji !!!!

  • @jagcsekaran5639
    @jagcsekaran5639 4 года назад

    Thanx Tim!!!

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

  • @shashankksaraf8390
    @shashankksaraf8390 3 года назад

    very helpful!

  • @bafanamhlahlo1717
    @bafanamhlahlo1717 Год назад

    thanks my friend

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

  • @amantiwari1916
    @amantiwari1916 10 месяцев назад

    Thanks man 🙏

  • @majidachettiyamveettil1377
    @majidachettiyamveettil1377 3 года назад

    THank u soo much..it helped

  • @OFFSETPRINTMK
    @OFFSETPRINTMK Год назад

    Thanks a lot!

  • @Menakinjin
    @Menakinjin 8 месяцев назад

    THANK YOU!!

  • @ebenezerkaunda8879
    @ebenezerkaunda8879 2 года назад

    Thank you so much🙌

  • @cadenceforte8571
    @cadenceforte8571 3 года назад

    You are a life saver...LOL

  • @Nerpy-D-Derp
    @Nerpy-D-Derp 4 года назад

    Thank you!

  • @paulalangadan8375
    @paulalangadan8375 3 года назад

    what do you do with the coefficients??

  • @amjadmahmood5904
    @amjadmahmood5904 9 месяцев назад

    Thank you so much

  • @WESAFYGE5
    @WESAFYGE5 Год назад

    Thank u so much.

  • @yomnaemad2213
    @yomnaemad2213 3 года назад

    THANK YOU THANK YOU THANK YOU!

  • @bharatwasi6392
    @bharatwasi6392 Год назад +1

    thank you guruji

  • @elorm5948
    @elorm5948 4 года назад

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

  • @anandanarayanang187
    @anandanarayanang187 7 месяцев назад

    Thank you.

  • @luci1474
    @luci1474 2 года назад

    how do you get the values first tho?

  • @princeemma-ejikeme2622
    @princeemma-ejikeme2622 Год назад

    what happened to the coefficients of the objective function variables

  • @bastienclarke1810
    @bastienclarke1810 5 лет назад

    Cool

  • @safiaatou7
    @safiaatou7 4 месяца назад

    Thanks ❤️

  • @eddyalonso7661
    @eddyalonso7661 Год назад

    Thanks!!

  • @pushtishah1495
    @pushtishah1495 6 месяцев назад

    thank you sm

  • @yashsgupta17
    @yashsgupta17 Год назад

    Thanks❤

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

  • @4upranit
    @4upranit 4 года назад

    Can i Use sumproduct function ?

  • @sugoiiibeats
    @sugoiiibeats 4 месяца назад

    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

  • @zishanhossain1451
    @zishanhossain1451 9 месяцев назад

    how to add a not equal to

  • @user-wn9pr1wg3f
    @user-wn9pr1wg3f Год назад

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

  • @syafiqahshukor
    @syafiqahshukor Год назад

    terima kasih bang

  • @chengheo9276
    @chengheo9276 3 года назад

    why all my value go to 0, after click solver

  • @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 ruclips.net/video/1I2_QPGebbg/видео.html
      here you can learn how to define objective function along with Solver tutorial

    • @jackcurtiscanada
      @jackcurtiscanada 6 лет назад

      Thanks Tim!

  • @sriharikrish518
    @sriharikrish518 3 года назад

    Can you post this problem in excel file

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

  • @funtimes7305
    @funtimes7305 3 года назад +1

    Thanksssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss!

  • @sridharans5165
    @sridharans5165 5 лет назад

    you have done a great job out there nigga.!

  • @jnkvngz2965
    @jnkvngz2965 Год назад

    gather here UG students

  • @mohammedmisbah5796
    @mohammedmisbah5796 2 года назад

    Very good bro

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

  • @obertylibuku4350
    @obertylibuku4350 11 месяцев назад

    Improve on the video quality

  • @Raj-wj2zv
    @Raj-wj2zv 2 года назад

    ,k

  • @fintancolaco7398
    @fintancolaco7398 5 лет назад

    Have my fucking babies.