Solving Linear Programming Problem using Excel's Solver

Sdílet
Vložit
  • čas přidán 27. 06. 2017

Komentáře • 110

  • @NoTimeLikeThePRESENCE
    @NoTimeLikeThePRESENCE Před 4 lety +43

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

  • @b0nniebr0wn
    @b0nniebr0wn Před 8 měsíci +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 Před 4 lety +30

    Straight forward and simple. The best tutorial.

  • @damianrico2433
    @damianrico2433 Před 2 lety +1

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

  • @EngineeringHooksets
    @EngineeringHooksets Před 3 lety +16

    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 Před rokem

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

  • @nagyakos4802
    @nagyakos4802 Před 2 lety

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

  • @YoutuberOutOfContext
    @YoutuberOutOfContext Před rokem +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

  • @h.s.3883
    @h.s.3883 Před 6 měsíci

    I appreciate videos like this! I spent too long stressing about it and now it makes sense. Thank you for sharing!

  • @linky6452
    @linky6452 Před rokem +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 Před 4 lety

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

  • @quangleuc2682
    @quangleuc2682 Před 4 měsíci

    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

  • @solo-cg2oo
    @solo-cg2oo Před rokem

    this video helped me the most out of all the others , thanks man

  • @xinziwei9760
    @xinziwei9760 Před měsícem

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

  • @berhanumekonen5191
    @berhanumekonen5191 Před 6 lety +1

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

  • @bagelsmmmm789
    @bagelsmmmm789 Před 5 lety +6

    Thanks, man, really helped me out here.

  • @odie7479
    @odie7479 Před 3 lety

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

  • @homeromendoza6574
    @homeromendoza6574 Před 4 lety +1

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

  • @mayshadid
    @mayshadid Před 3 lety

    Thank you. Straight forward and simple.

  • @towfiqrahman4016
    @towfiqrahman4016 Před rokem

    Great work, very nice presentation and very helpful 👌

  • @kevinmutahi5417
    @kevinmutahi5417 Před rokem

    This is the best tutorial so far!

  • @shanna-kayswazey204
    @shanna-kayswazey204 Před 4 měsíci

    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 Před 2 lety

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

  • @SanjitSinghSall
    @SanjitSinghSall Před 3 lety

    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

  • @ev1836
    @ev1836 Před 4 lety +1

    Omg this was incredibly helpful tysm

  • @Dhoomie
    @Dhoomie Před 2 lety +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.

  • @pimschakel7840
    @pimschakel7840 Před měsícem

    Great and clear tutorial!! Super helpfull!!!

  • @yufankoh5624
    @yufankoh5624 Před 3 lety

    you saved my life 😭 thanks!!!

  • @tommy2598
    @tommy2598 Před 4 lety

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

  • @lusandamtembu7383
    @lusandamtembu7383 Před rokem

    MY MAN TIM, GOAT

  • @cabinoasis7565
    @cabinoasis7565 Před rokem

    Extremely helpful! Thanks!!!

  • @ThinboxStudios
    @ThinboxStudios Před 3 lety

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

  • @tausif3239
    @tausif3239 Před 5 lety

    Really helpful..thanks man.

  • @TheRealStructurer
    @TheRealStructurer Před 9 měsíci

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

  • @learnwithash12345
    @learnwithash12345 Před 8 měsíci

    Very informative and time saving!

  • @amjeenzoo4019
    @amjeenzoo4019 Před rokem

    thank you so much , finally a clear explanation

  • @anandimerchant5180
    @anandimerchant5180 Před 8 měsíci

    Yay! Wonderfully explained...5 stars

  • @joannalagden6457
    @joannalagden6457 Před 5 lety

    Fantastic video thank you!

  • @duyvo5315
    @duyvo5315 Před rokem

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

  • @user-ve8vc7rp3d
    @user-ve8vc7rp3d Před 8 měsíci

    Thank u for sharing this, well explained

  • @hrishikeshmoghe5305
    @hrishikeshmoghe5305 Před 5 lety

    Awesomeee thanks you soo much sir!

  • @dansheks6509
    @dansheks6509 Před 4 lety

    Very clear and easy to understand

  • @gauravmakkar9803
    @gauravmakkar9803 Před 4 lety

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

  • @gurunathreddy9270
    @gurunathreddy9270 Před 2 lety

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

  • @ganganaltangerel6293
    @ganganaltangerel6293 Před 3 lety

    Thank you! It helped a lot!

  • @bjj7309
    @bjj7309 Před rokem

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

  • @TheFoxHound626
    @TheFoxHound626 Před rokem

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

  • @justinparis9287
    @justinparis9287 Před 3 lety

    You saved my grade thank you

  • @bballmstr
    @bballmstr Před 4 lety

    thank you so much bro saved me!

  • @ahmadcooper40
    @ahmadcooper40 Před rokem

    Amazing, thank you!

  • @amohtontoh47
    @amohtontoh47 Před 2 lety

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

  • @cadenceforte8571
    @cadenceforte8571 Před 3 lety

    You are a life saver...LOL

  • @ishain7564
    @ishain7564 Před 3 lety

    You're a life saver! Thank you ❤️

  • @majidachettiyamveettil1377

    THank u soo much..it helped

  • @theapexpredator157
    @theapexpredator157 Před 3 lety

    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?

  • @lakshaychhabra9972
    @lakshaychhabra9972 Před 8 měsíci

    thank you paaaji !!!!

  • @lamiamouli8243
    @lamiamouli8243 Před 5 lety

    Very helpful

  • @dragoacimovic5001
    @dragoacimovic5001 Před 6 lety +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.

  • @jagcsekaran5639
    @jagcsekaran5639 Před 4 lety

    Thanx Tim!!!

  • @bafanamhlahlo1717
    @bafanamhlahlo1717 Před rokem

    thanks my friend

  • @tuli1954
    @tuli1954 Před rokem

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

  • @MadelineHatch
    @MadelineHatch Před rokem

    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.

  • @OFFSETPRINTMK
    @OFFSETPRINTMK Před rokem

    Thanks a lot!

  • @shashankksaraf8390
    @shashankksaraf8390 Před 3 lety

    very helpful!

  • @Menakinjin
    @Menakinjin Před 9 měsíci

    THANK YOU!!

  • @amantiwari1916
    @amantiwari1916 Před 11 měsíci

    Thanks man 🙏

  • @ebenezerkaunda8879
    @ebenezerkaunda8879 Před 2 lety

    Thank you so much🙌

  • @Nerpy-D-Derp
    @Nerpy-D-Derp Před 4 lety

    Thank you!

  • @paulalangadan8375
    @paulalangadan8375 Před 3 lety

    what do you do with the coefficients??

  • @GBTVnetwork
    @GBTVnetwork Před 4 lety

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

  • @yomnaemad2213
    @yomnaemad2213 Před 3 lety

    THANK YOU THANK YOU THANK YOU!

  • @WESAFYGE5
    @WESAFYGE5 Před rokem

    Thank u so much.

  • @amjadmahmood5904
    @amjadmahmood5904 Před 10 měsíci

    Thank you so much

  • @bharatwasi6392
    @bharatwasi6392 Před rokem +1

    thank you guruji

  • @princeemma-ejikeme2622

    what happened to the coefficients of the objective function variables

  • @anandanarayanang187
    @anandanarayanang187 Před 8 měsíci

    Thank you.

  • @luci1474
    @luci1474 Před 2 lety

    how do you get the values first tho?

  • @eddyalonso7661
    @eddyalonso7661 Před rokem

    Thanks!!

  • @pushtishah1495
    @pushtishah1495 Před 7 měsíci

    thank you sm

  • @safiaatou7
    @safiaatou7 Před 5 měsíci

    Thanks ❤️

  • @afiahayat2644
    @afiahayat2644 Před 3 lety

    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 Před 4 lety

    Can i Use sumproduct function ?

  • @yashsgupta17
    @yashsgupta17 Před rokem

    Thanks❤

  • @bastienclarke1810
    @bastienclarke1810 Před 5 lety

    Cool

  • @sugoiiibeats
    @sugoiiibeats Před 5 měsíci

    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 Před rokem

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

  • @jackcurtiscanada
    @jackcurtiscanada Před 6 lety +1

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

    • @melvinmath
      @melvinmath  Před 6 lety +3

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

    • @ELearninghub
      @ELearninghub Před 6 lety +1

      you can try this czcams.com/video/1I2_QPGebbg/video.html
      here you can learn how to define objective function along with Solver tutorial

    • @jackcurtiscanada
      @jackcurtiscanada Před 6 lety

      Thanks Tim!

  • @syafiqahshukor
    @syafiqahshukor Před rokem

    terima kasih bang

  • @chengheo9276
    @chengheo9276 Před 3 lety

    why all my value go to 0, after click solver

  • @zishanhossain1451
    @zishanhossain1451 Před 10 měsíci

    how to add a not equal to

  • @sriharikrish518
    @sriharikrish518 Před 4 lety

    Can you post this problem in excel file

  • @davidsanchez8360
    @davidsanchez8360 Před 4 lety +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 Před 4 lety

      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 Před 5 lety

    you have done a great job out there nigga.!

  • @samilab1097
    @samilab1097 Před 5 lety +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 Před 2 lety

    Very good bro

  • @funtimes7305
    @funtimes7305 Před 3 lety +1

    Thanksssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss!

  • @jnkvngz2965
    @jnkvngz2965 Před rokem

    gather here UG students

  • @obertylibuku4350
    @obertylibuku4350 Před rokem

    Improve on the video quality

  • @Raj-wj2zv
    @Raj-wj2zv Před 2 lety

    ,k

  • @fintancolaco7398
    @fintancolaco7398 Před 5 lety

    Have my fucking babies.