This video shows how to solve a linear programming problem using Excel’s Solver add-in. 00:00 Installing Solver 00:41 Setting up the layout 03:16 Using Solver 04:28 Solver Results
Пікірлер: 72
@felixokwaraoha28936 ай бұрын
hey... you made someone happy tonight.
@agarwalarti Жыл бұрын
So brief and to the point and clear. You were SO helpful. Thank you.
@hannahbice9076 Жыл бұрын
WOW!!!! This helped me so so much you really will be the reason I pass this class! I felt at a loss with my current professor, but when you explained it - IT CLICKED! Great video, I'm sure it'll continue to help people through the years.
@kurtisternet26762 жыл бұрын
Joshua, you just saved my ass on my analytics test. Thank you sir! Keep up the great work!
@ontherangegal42962 жыл бұрын
Thank you, Joshua! I had to watch your video for this, as my professor did not explain this well at all. I am new to using Excel for my class. I am watching all of your videos, and referring to my colleagues. You're a proficient professor. Also, for anchoring the variables, it's function + F4 on the newer PC's. Thank you, again !!!
@joshemman2 жыл бұрын
Glad to hear and thanks for sharing the goodness.
@vanusadepaula73283 ай бұрын
Thank you so much!!! You made my day! I was able to do my school assignment thanks to this video. Many thanks!!!!
@VARSYUS2 жыл бұрын
Thanks a lot, it was very clear and helpful illustration
@HieuNguyen-mz7oy Жыл бұрын
Joshua, you are a life-saver. I appreciate all the content that you've uploaded. Thank you!
@socketyellow36 ай бұрын
My online teacher’s video and audio quality is so back in having to look for these. Now I know what the heck he meant well partly
@fatimamanzumaabdurahman34004 ай бұрын
Thankyou very much for this, it made it so much clearer. Please do you have a video for linking and binary constraints?
@fatimamanzumaabdurahman34004 ай бұрын
Not to bother. I found all i wanted on your page. Thank you very much
@aditi51128 ай бұрын
Thnku so much...this video is really very helpful... I have solved questions after watching this video very easily 😊 support and love from India
@joshemman8 ай бұрын
Most welcome 😊
@Umjion Жыл бұрын
Thank you SO MUCH, sir, it helped A LOT!!!🙏
@shifamansuri31903 ай бұрын
Can you make it for RSA, your explanation is very nice!!
@hsd287 Жыл бұрын
Tx man great work ❤👍🏻
@jbbin6718 Жыл бұрын
Thank you, it helped out a lot!
@amandakaren63799 ай бұрын
omg. thank you so much
@reynoldhutagalung2647 Жыл бұрын
YOU ARE PERFECT
@ziruiwang72934 ай бұрын
Bro you literally saved my ass, thank you!
@forkanfahimfhf65633 ай бұрын
Thank you sooo much sir.
@guilhermegonzalez55012 жыл бұрын
Thank you bro, I love you
@chadrwilson12312 жыл бұрын
Superb video! Thank you!
@andrewzhauoo4664 Жыл бұрын
Great boss. continue
@Chippin-luv5 ай бұрын
thank you, you save me from uni
@tewzoful2 жыл бұрын
Great video!
@user-jq1oj3cr9u5 ай бұрын
Thanku soo much 😊
@whyjamesisacommonname3 ай бұрын
THANKS YOU ! EZ PZ !
@superflash7398 Жыл бұрын
VERY HELPFULL
@vicentediaz8106 Жыл бұрын
Life-saver
@advaitmandlik3901 Жыл бұрын
Really amazing explanation! Thank you! I have one question which is, do we have to add another constraint specifying x1, x2, x3 >= 0. I did not see that in the constraints box. Or it is covered when we ticked the below box for non-negativity? Thanks in advance
@joshemman Жыл бұрын
Yes, nonnegativity is applied when you check the non-negativity box.
@advaitmandlik3901 Жыл бұрын
@@joshemman Got it. Thanks for the video and the quick reply . Keep going prof!!
@habeebomotunde34873 ай бұрын
Awesome
@runatayjohnerrola.2127 Жыл бұрын
Do you have a video of how to make a graph about this? Thank you so much.
@joshemman Жыл бұрын
Search for Joshua LP Graph. Note that Graphical solutions are limited to 2 decision variables.
@ALPHAK2498 ай бұрын
It really helped
@EmEpsilonАй бұрын
the formula in cell e2 gives error message on my excel. There is no mistake in what we do but it just does not work
@joshemmanАй бұрын
Make the cells are either empty or contain only numbers, then try this pasting this: =SUMPRODUCT(B3:D3,B2:D2)
@sanjaykonapur463 Жыл бұрын
can I get the question for this solution, as in statement of the problem
@vasanthashettyilanthila9955Ай бұрын
I have -1000 in my objective function formula what to do?
@ishadyaabesinghe1216 Жыл бұрын
Thanks💜
@artanzulali948910 ай бұрын
absolute goat
@rhe7187 Жыл бұрын
Thanks much
@joshemman Жыл бұрын
My pleasure, RHE
@lesliemenjivar10 ай бұрын
you're awesome
@ravenhawk6327 Жыл бұрын
Can you help me with these.I am confused with the last 3x1 >= 50,x2 >= 30, x3
@joshemman Жыл бұрын
For 3x1 >= 50, enter 3 under x1 and 50 on RHS. For x2 >= 30, enter 1 under x2 and 30 on RHS. For x3
@peterzhao3684 Жыл бұрын
Hello, Joshua Im just wondering how you would adjust this process if there was an requirement for X3 = 0?
@joshemman Жыл бұрын
For X3 = 0, input "1" under the X3 variable, and "0" on the right side. Otherwise, you can omit X3 altogether. from the model.
@nandinigupta12518 ай бұрын
Hi! I followed the exact same process but i dont know why all my values are coming out to be zero...if you know can you help why?
@joshemman8 ай бұрын
One issue might be with selecting the Min radio button in Solver instead of Max. You should also check that your formulas are correct.
@brianng39897 ай бұрын
i am some questions, Max: 500X1+3.75X2+70Y1+60Y2+40Y3−750 i am not sure where i should put the 750 as it is not a variable can you please explain, thank you
@joshemman7 ай бұрын
What does the 750 represent?
@brianng39897 ай бұрын
@@joshemman just a constant
@joshemman7 ай бұрын
@@brianng3989 If it is just a constant, then it is fine as you wrote it.
@adeobaadeteniola92326 ай бұрын
I can’t access the “About” function for your email. Kindly reach out pls
@joshemman6 ай бұрын
I can't post it here for obvious reasons but you can find it through a quick Google search.
@Wa1rrior Жыл бұрын
Legend
@elladominiquetrece8865 Жыл бұрын
hello! how do you add the X subscript 1?
@joshemman Жыл бұрын
Here you go: kzfaq.info/get/bejne/f6qbdNllrr2smKM.html
@nuttapronp3185 Жыл бұрын
Why my LHS doesn’t equal RHS after solver.
@joshemman Жыл бұрын
When LHS does not equal RHS, there is a slack or surplus.
@nuttapronp3185 Жыл бұрын
@@joshemman okkkk. Thank u so muchhh
@princeemma-ejikeme2622 Жыл бұрын
my sumproduct is bringing up an error
@joshemman Жыл бұрын
What exactly did you type and what error are you getting?
@manishanembang9396 Жыл бұрын
can anyone help me solve below question? flour A contains 20% fiber, 15% protein and 1.09% Acid insoluble ash : cost Rs 6/kg flour B contains 0.5% fiber, 10% protein and 0.06% acid insoluble ash ; cost Rs 90/kg constraints; fiber greater than equals to 10%, protein greater than equals to 13%, acid insoluble ash less than equals to 0.15 total flour to be made is 1 kg with minimum cost.
@joshemman Жыл бұрын
There is no feasible solution to this problem. Some values are probably incorrect.
@Firstorder665 ай бұрын
Why is excel even considered for linear programming? its so obsolete and garbage, you can solve the same problem in matlab with less effort. Excel is so dogshit and outdated
@joshemman5 ай бұрын
Most people don't have access to matlab but they have Excel. Besides, many will not be solving LPs in their professions but they might be using Excel.
@Firstorder663 ай бұрын
@@joshemman Youre make a good point. However, I am interested in this field and not using newer, industry used programs puts me at a disadvantage. Anyways thanks for the videos, you are really good at excel and made it easy to learn.