Solve Linear Program problem in Excel (Solver)

No video

Solve Linear Program problem in Excel (Solver)

Рет қаралды 112,450

Күн бұрын

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

@felixokwaraoha2893 6 ай бұрын

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.

@kurtisternet2676 2 жыл бұрын

Joshua, you just saved my ass on my analytics test. Thank you sir! Keep up the great work!

@ontherangegal4296 2 жыл бұрын

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

@joshemman 2 жыл бұрын

Glad to hear and thanks for sharing the goodness.

@vanusadepaula7328 3 ай бұрын

Thank you so much!!! You made my day! I was able to do my school assignment thanks to this video. Many thanks!!!!

@VARSYUS 2 жыл бұрын

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!

@socketyellow3 6 ай бұрын

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

@fatimamanzumaabdurahman3400 4 ай бұрын

Thankyou very much for this, it made it so much clearer. Please do you have a video for linking and binary constraints?

@fatimamanzumaabdurahman3400 4 ай бұрын

Not to bother. I found all i wanted on your page. Thank you very much

@aditi5112 8 ай бұрын

Thnku so much...this video is really very helpful... I have solved questions after watching this video very easily 😊 support and love from India

@joshemman 8 ай бұрын

Most welcome 😊

@Umjion Жыл бұрын

Thank you SO MUCH, sir, it helped A LOT!!!🙏

@shifamansuri3190 3 ай бұрын

Can you make it for RSA, your explanation is very nice!!

@hsd287 Жыл бұрын

Tx man great work ❤👍🏻

@jbbin6718 Жыл бұрын

Thank you, it helped out a lot!

@amandakaren6379 9 ай бұрын

omg. thank you so much

@reynoldhutagalung2647 Жыл бұрын

YOU ARE PERFECT

@ziruiwang7293 4 ай бұрын

Bro you literally saved my ass, thank you!

@forkanfahimfhf6563 3 ай бұрын

Thank you sooo much sir.

@guilhermegonzalez5501 2 жыл бұрын

Thank you bro, I love you

@chadrwilson1231 2 жыл бұрын

Superb video! Thank you!

@andrewzhauoo4664 Жыл бұрын

Great boss. continue

@Chippin-luv 5 ай бұрын

thank you, you save me from uni

@tewzoful 2 жыл бұрын

Great video!

@user-jq1oj3cr9u 5 ай бұрын

Thanku soo much 😊

@whyjamesisacommonname 3 ай бұрын

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

@habeebomotunde3487 3 ай бұрын

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.

@ALPHAK249 8 ай бұрын

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💜

@artanzulali9489 10 ай бұрын

absolute goat

@rhe7187 Жыл бұрын

Thanks much

@joshemman Жыл бұрын

My pleasure, RHE

@lesliemenjivar 10 ай бұрын

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.

@nandinigupta1251 8 ай бұрын

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?

@joshemman 8 ай бұрын

One issue might be with selecting the Min radio button in Solver instead of Max. You should also check that your formulas are correct.

@brianng3989 7 ай бұрын

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

@joshemman 7 ай бұрын

What does the 750 represent?

@brianng3989 7 ай бұрын

@@joshemman just a constant

@joshemman 7 ай бұрын

@@brianng3989 If it is just a constant, then it is fine as you wrote it.

@adeobaadeteniola9232 6 ай бұрын

I can’t access the “About” function for your email. Kindly reach out pls

@joshemman 6 ай бұрын

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.

@Firstorder66 5 ай бұрын

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

@joshemman 5 ай бұрын

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.

@Firstorder66 3 ай бұрын

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