Тёмный

Solving Linear Programming Problem using Excel's Solver 

Tim Melvin
Подписаться 1,3 тыс.
Просмотров 439 тыс.
50% 1

Опубликовано:

 

24 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 114   
@JesusIsLordForever316
@JesusIsLordForever316 4 года назад
Out of all the videos on RU-vid... 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 11 месяцев назад
It has taken me 3 years to finally find a video that actually help me learn how to do this correctly! Thank you!!!
@EngineeringHooksets
@EngineeringHooksets 4 года назад
Thank you so much. Our prof has been teaching us these in python but this is 100x easier. Saved my life
@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.
@quangleuc2682
@quangleuc2682 7 месяцев назад
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
@h.s.3883
@h.s.3883 9 месяцев назад
I appreciate videos like this! I spent too long stressing about it and now it makes sense. Thank you for sharing!
@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
@KanwaljitDhiman
@KanwaljitDhiman Год назад
This has been life saver for me, I did my assignment in 5mins after learning from this video. Thank you!
@xinziwei9760
@xinziwei9760 4 месяца назад
The best video I've ever found to explain how to use solver:) Thanks!!!
@shanna-kayswazey204
@shanna-kayswazey204 7 месяцев назад
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!
@musewhipser
@musewhipser 9 дней назад
Thanks, very helpful, and one question, what does RHS mean?
@Dhoomie
@Dhoomie 3 года назад
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 3 года назад
mba from where
@Dhoomie
@Dhoomie 3 года назад
@@sumitentertaiment7156 I meant my professor, not the youtuber xd
@solo-cg2oo
@solo-cg2oo Год назад
this video helped me the most out of all the others , thanks man
@odie7479
@odie7479 3 года назад
Best explanation..... I got my work right after just following step by step . Thanks a lot
@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
@damianrico2433
@damianrico2433 2 года назад
Tim, Great Video!! I have been looking for someone to break it down the way you did, completely appreciate the video!
@duyvo5315
@duyvo5315 Год назад
Thanks a lot sir, your tutorial is very clear and easy to understand
@nagyakos4802
@nagyakos4802 2 года назад
Tim you just saved the day my man! I really do appreciate your effort!!
@Shalimarsunrisers
@Shalimarsunrisers Месяц назад
Absolute stunning video❤
@Strawberryknight
@Strawberryknight 4 года назад
Thank you. It is much clearer than any instructions on youtube.
@EkramDardeer
@EkramDardeer 11 месяцев назад
Thank u for sharing this, well explained
@pimschakel7840
@pimschakel7840 4 месяца назад
Great and clear tutorial!! Super helpfull!!!
@TheRealStructurer
@TheRealStructurer 11 месяцев назад
Good tutorial 👍 To make the formulas easier to read I guess you can use named variables instead of cell references?
@berhanumekonen5191
@berhanumekonen5191 7 лет назад
OH ! stil now I am doing with only simplex and graphical methods ,so it is very helpfull for me .THAXS !!!!
@towfiqrahman4016
@towfiqrahman4016 Год назад
Great work, very nice presentation and very helpful 👌
@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.
@kevinmutahi5417
@kevinmutahi5417 2 года назад
This is the best tutorial so far!
@gurunathreddy9270
@gurunathreddy9270 3 года назад
Tq so much for wonderful explain I do in exams perfectly 👍👍🙏🙏
@bagelsmmmm789
@bagelsmmmm789 5 лет назад
Thanks, man, really helped me out here.
@homeromendoza6574
@homeromendoza6574 5 лет назад
awesome. this is the vid that made it crystal clear.
@learnwithash12345
@learnwithash12345 11 месяцев назад
Very informative and time saving!
@anandimerchant5180
@anandimerchant5180 11 месяцев назад
Yay! Wonderfully explained...5 stars
@soniadetert1733
@soniadetert1733 2 месяца назад
Thank you! very helpfull.
@TheFoxHound626
@TheFoxHound626 2 года назад
Tim you saved our lives, we will build statues in your honor.
@mayshadid
@mayshadid 3 года назад
Thank you. Straight forward and simple.
@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.
@bjj7309
@bjj7309 Год назад
graet video!!! Thank you so so so so so much tim .
@dansheks6509
@dansheks6509 4 года назад
Very clear and easy to understand
@tommy2598
@tommy2598 4 года назад
thanks, now i can solve me task.. you really helped.
@cabinoasis7565
@cabinoasis7565 Год назад
Extremely helpful! Thanks!!!
@amohtontoh47
@amohtontoh47 3 года назад
Hello Tim, if you have constraint with bracket, how do you go about it ? Do you open up the bracket ?
@lusandamtembu7383
@lusandamtembu7383 Год назад
MY MAN TIM, GOAT
@amjeenzoo4019
@amjeenzoo4019 2 года назад
thank you so much , finally a clear explanation
@ThinboxStudios
@ThinboxStudios 3 года назад
Thanks a lot! this video helped me with my class!!!!
@yufankoh5624
@yufankoh5624 3 года назад
you saved my life 😭 thanks!!!
@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?
@ChristyAjayi
@ChristyAjayi 2 месяца назад
very helpful
@justinparis9287
@justinparis9287 3 года назад
You saved my grade thank you
@ClassofCABE
@ClassofCABE 2 года назад
You are a life and grade saver!!!!!
@bafanamhlahlo1717
@bafanamhlahlo1717 2 года назад
thanks my friend
@ev1836
@ev1836 4 года назад
Omg this was incredibly helpful tysm
@bharatwasi6392
@bharatwasi6392 Год назад
thank you guruji
@shattastudiosuk
@shattastudiosuk 4 года назад
I have a linear programming question I have having difficulty in solving . Would you mind to help ?
@sugoiiibeats
@sugoiiibeats 8 месяцев назад
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
@ahmadcooper40
@ahmadcooper40 Год назад
Amazing, thank you!
@tuli1954
@tuli1954 Год назад
can you have the goal function being evaluated by a macro?
@ganganaltangerel6293
@ganganaltangerel6293 3 года назад
Thank you! It helped a lot!
@tausif3239
@tausif3239 5 лет назад
Really helpful..thanks man.
@darwin_ate_my_dcf
@darwin_ate_my_dcf 11 месяцев назад
thank you paaaji !!!!
@WESAFYGE5
@WESAFYGE5 2 года назад
Thank u so much.
@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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-1I2_QPGebbg.html here you can learn how to define objective function along with Solver tutorial
@jackcurtiscanada
@jackcurtiscanada 6 лет назад
Thanks Tim!
@joannalagden6457
@joannalagden6457 5 лет назад
Fantastic video thank you!
@gauravmakkar9803
@gauravmakkar9803 4 года назад
I think it will be enough to save my butt, Thanks man
@ebenezerkaunda8879
@ebenezerkaunda8879 2 года назад
Thank you so much🙌
@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.
@majidachettiyamveettil1377
@majidachettiyamveettil1377 3 года назад
THank u soo much..it helped
@amjadmahmood5904
@amjadmahmood5904 Год назад
Thank you so much
@OFFSETPRINTMK
@OFFSETPRINTMK 2 года назад
Thanks a lot!
@shashankksaraf8390
@shashankksaraf8390 3 года назад
very helpful!
@hrishikeshmoghe5305
@hrishikeshmoghe5305 5 лет назад
Awesomeee thanks you soo much sir!
@Menakinjin
@Menakinjin Год назад
THANK YOU!!
@anandanarayanang187
@anandanarayanang187 11 месяцев назад
Thank you.
@safiaatou7
@safiaatou7 8 месяцев назад
Thanks ❤️
@princeemma-ejikeme2622
@princeemma-ejikeme2622 Год назад
what happened to the coefficients of the objective function variables
@lamiamouli8243
@lamiamouli8243 5 лет назад
Very helpful
@bballmstr
@bballmstr 4 года назад
thank you so much bro saved me!
@amantiwari1916
@amantiwari1916 Год назад
Thanks man 🙏
@cadenceforte8571
@cadenceforte8571 4 года назад
You are a life saver...LOL
@pushtishah1495
@pushtishah1495 10 месяцев назад
thank you sm
@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"
@yashsgupta17
@yashsgupta17 2 года назад
Thanks❤
@eddyalonso7661
@eddyalonso7661 Год назад
Thanks!!
@4upranit
@4upranit 4 года назад
Can i Use sumproduct function ?
@paulalangadan8375
@paulalangadan8375 4 года назад
what do you do with the coefficients??
@luci1474
@luci1474 3 года назад
how do you get the values first tho?
@yomnaemad2213
@yomnaemad2213 4 года назад
THANK YOU THANK YOU THANK YOU!
@MarshallVinck
@MarshallVinck Год назад
if I use the mmult function i get different answer Why??
@Alluneedismosh
@Alluneedismosh 4 года назад
Thank you!
@jagcsekaran5639
@jagcsekaran5639 5 лет назад
Thanx Tim!!!
@ishain7564
@ishain7564 3 года назад
You're a life saver! Thank you ❤️
@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
@sriharikrish518
@sriharikrish518 4 года назад
Can you post this problem in excel file
@chengheo9276
@chengheo9276 3 года назад
why all my value go to 0, after click solver
@zishanhossain1451
@zishanhossain1451 Год назад
how to add a not equal to
@mohammedmisbah5796
@mohammedmisbah5796 3 года назад
Very good bro
@mohammedmisbah5796
@mohammedmisbah5796 3 года назад
I love your Chanel content bro
@syafiqahshukor
@syafiqahshukor Год назад
terima kasih bang
@bastienclarke1810
@bastienclarke1810 5 лет назад
Cool
@jnkvngz2965
@jnkvngz2965 Год назад
gather here UG students
@sridharans5165
@sridharans5165 5 лет назад
you have done a great job out there nigga.!
Далее
Intro to Linear Programming
14:23
Просмотров 195 тыс.
Linear Programming Solver Excel
23:28
Просмотров 106 тыс.
Каха понты
00:40
Просмотров 288 тыс.
He went ALL in 😭
00:12
Просмотров 1,8 млн
Excel Solver & Goal Seek Tutorial
23:34
Просмотров 172 тыс.
Solving optimization problems using Excel solver
20:55
Просмотров 1,1 тыс.
EASILY Make an Automated Data Entry Form in Excel
14:52
Solve Linear Program problem in Excel (Solver)
5:22
Просмотров 132 тыс.
How to Read Excel Solver's Sensitivity Report
35:53
Просмотров 55 тыс.
Каха понты
00:40
Просмотров 288 тыс.