How to Solve an LP Problem Graphically in Excel

This video provides a walk through on how to solve an LP problem in Excel using the graphical method.
Solving Linear Program in Excel (Solver): • Solve Linear Program p...
How to solve a system of linear equations in Excel 365: • Solve systems of linea...

[@christianlira1259]

Good day Joshua,
This is the best uses of LP within Excel I have ever seen in 30 years.
Great work and thank you for sharing.

[@joshemman]

Thanks for taking the time to drop a note, Lira.
Much appreciated.

[@nivenjulien4773]

This is the most helpful tutorial I've ever seen. Thank you very much for making this!

[@frankmasih5367]

My teacher taught us in the exact same way, even the yellow and green colour for the cell.
Now I know where he learnt from.
awesome video btw

[@KwameAkomeah]

Joshua you're the best. I am new to Linear Programming and you made me understand it so easily. Thank you so much. I feel am now ready for my Final Exams :)...

[@PumaCanIChange]

I love the "to the point" approach.

[@LizBarraclough]

Dear Joshua Thank you so much for this video. I'm teaching Linear Programming for the first time and wanted to show how to create it graphically. This is so helpful and easy to follow. Many thanks.

[@joshemman]

My pleasure, Liz. Thanks for dropping a note.

[@86puneet]

This was really well explained...thanks Joshua!

[@aundrianal]

SUPER helpful! I just did my whole project with the help of this video!!

[@that_is_my_real_name]

You made this so simple and easy to follow. Thank you !

[@joshemman]

My pleasure, Ines.

[@28ronji]

Excellent video!! Thank you for breaking this down and showing tip on Excel.

[@shabrishshankar9934]

May God bless you this guy helped me finish most of my project by this video

[@mustafameydanc384]

Holy god about expertise of excel... im speechles..

[@herztard]

You`re the God of Exel. Thanks a lot!!

[@alexz1105]

Fantastic video, thank you so much for breaking this down so easily. You are a life saver.

[@jayaniniroshima9136]

Excellent very useful for my exam...thank u so much

[@sourabhch3044]

Joshua you are amazing dude! So glad i found your channel.

[@RosemaryMuwani]

So easy to understand. Thanks Joshua

[@jm-wo4or]

I usually never comment on videos but this one was very well done. Good job.

[@bettys7298]

Thanks. So helpful! But, also, it seems there is a way to find the x and y value without manually solve the equation like what we do here? Forgot which is the name of the function in Excel... Solver? Can we also use Solver then plot the graph? Thank you very much!

[@yomnaelmasry2000]

Thank you , It is nice how you mention every single detail

[@israelrpo]

This is exactly what I was looking for! Thank you so much.

[@kopolwalizah887]

Thank you very much for this video. It's really helpful

[@lissiemackintosh]

this was explained brilliantly!

[@dayvienk7114]

Thanks man. Wish I saw this when I was doing operations research back in school.

[@shaktishivanand624]

Thank you for making it. Learned a new thing.

[@vivianigwe4856]

Best tutor ever. Thanks Josh

[@outsidelife5411]

awesome! this is what I needed to do a quick linear programming graph. thanks so much!

[@kavehiskaveh]

Really helpful ! Thanks for your clear and simple instructions

[@abdofeduconsult]

Hi Emma. It really helps. God bless you

[@trina5514]

Thank you so much!! You explained it well.

[@marutisciencetutorial6392]

Excellent.... Just Brilliant.... I want more....

[@latanyahaynes808]

Thank you Because I was very lost reading this in the book

[@MarcosFMedeirosF]

Thank you Sir. Very well done.

[@nands7288]

My dood u r a life saver

[@TeganUkomadu-dr1hy]

thanks a lot NOW I understand

[@chaevie257]

THIS IS SO HELPFUL THANK YOU 😭

[@spirosntemiris2022]

GREAT JOB..... Thank you very much for your help......Greetings from Greece!!!!!

[@joshemman]

Thanks for dropping a note my Greek friend. -Ἰησοῦς

[@HalimatonSaadiah]

Thanks,very helpful video!

[@jassiemrobinson6038]

woah this was perfect thanks so much

[@nethukarunasinghe7313]

Worth 🤩 Found at the perfect time … Thanks a lot

[@maximus380]

great explanation indeed. thanks Joshua.

[@AbA-bi5dz]

Wow! I am redoing my homework! Thank you sir.

[@N8Kracken]

Such a clear and accurate video. Thanks a lot.

[@MlleLauraKa]

Many thanks! You really helped me

[@amrounesalah8706]

Merci beaucoup pour le partage de la video thanks from Algeria.

[@athirak388]

Well explained and very useful. Thank you.

[@yaolin9198]

the best one! more videos please!!

[@mnjrupp]

Thanks for the video. I was able to replicate but with using the Solver Add-in.

[@eugenembn8672]

Helped a lot!! Cheers

[@jeansagi]

Excellent !, Very well explained.

[@ashleyprice9487]

hi thank you for your video i was wondering do you have one for mac users

[@joshemman]

You can do it in Excel on a mac.

[@eyakhamassi8748]

Thank u sooo much it was so helpful

[@samihakhan1717]

you are awesome bro. it was a very good explanation of excel.

[@mudhaferhasan1743]

Brilliant and smart presentation,keep it up please.

[@tcareycares]

Top notch video! Thank you very much!

[@omarfaruque8814]

Helpful 🌺
Thank you 💗

[@kabirumaitamakura6388]

Interesting! Thank you so much.

[@sharadamishra3307]

Thank you for the explanation.

[@jawad8846]

Thanks, made easy and simple

[@joshemman]

Most welcome 😊

[@joymccracken1939]

Awesome job! Thank you so much!!

[@bittu587]

Thank you so much.. I LEARN HOW TO DO IT.

[@MsSuman9]

Very well explained !!

[@anjaojasmined.6058]

The best I learned something new

[@iHermany]

Great tutorial, thank you!

[@quickconceptsbybakhtawar]

Great work love it !!

[@Eric-mn5ek]

Thanks for this , indeed very helpful

[@mahmoudbadi3602]

Great explanation. Thank you.

[@eoinpow]

Thanks

[@joshemman]

Thanks for the donation, Eoin ..means a lot.

[@AG-cx1ug]

@3:32 why did you replace C1's series x and y values - wasn't it already 3,0 0,12?

[@joshemman]

You’re right, I could leave C1 (at 3:15) as is and be correct (coincidentally), but viewers need to know the correct way of doing it: the Xs selected together, and the Ys selected together. Otherwise, there could be confusion in cases like C3 that is not in the form (X, 0), (0, Y).

[@loriconrad6031]

Thank you so much! YOU ARE MY HERO!

[@flora8781]

really helpful video!

[@europe1122]

This is very helpful. Thanks Joshua (y)

[@danyyilgiba]

Thanks. Very helpful!

[@codingwithalfred]

Thank you!!!!!!! this is awesome

[@forestsunrise26]

Thank you so much Joshua!

[@onlyakshat]

Excellent one

[@amandakaren6379]

THANKS A BUNCH

[@joshemman]

You're welcome, Amanda.

[@kiragabosco1210]

Super helpful, Thanks

[@dhanonjoypaul4491]

How A point automatically show (1,8)???I don't understand it...
this vedio was very helpful for me

[@RahulDas-ki7tg]

select AC3:AC3 and put formula press ctl+shift+enter

[@solomonsackey7775]

Excellent job done

[@killiankapalazanyeleti9481]

Very helpful

[@joshemman]

Glad it helped

[@yashjhawar2232]

I am not able to get straight lines when we have to shade the feasible region. how to do it?

[@amandawilson47]

Can you do a video on how to use this for the lottery. Powerball, and Mega Millions?

[@zuriquinn5574]

if there is a constraint like y

[@joshemman]

Just draw a horizontal line at y=225. Points like (0, 225) and (300, 225) should work. You can always replace "300" by whatever number works for your graph.

[@vilochanadilshan9903]

Thank you, sir

[@joshemman]

You're welcome, Vilochana.

[@zengardenvibes2403]

Great video. Can you share the excel file?

[@joshemman]

Here you go: bit.ly/3PuzAV1

[@sureshamallikarjunappa4301]

Thank you, good work

[@pranayd1402]

If a constraint is like this: X>=1900. How to get a vertical line on the excel scatter chart (x=1900). Could you please help?

[@joshemman]

X values (1900, 1900) Y values (0, highest y value)

[@pranayd1402]

@@joshemman Thank you !

[@mikeRT1200]

absolutely useful

[@sangmoklee3476]

Is there anyway that we can also include the non-negativity constraint (X,Y>=0) into the graphs, and find the point that meets x- or y-axis?

[@joshemman]

You will have to input some negative values for x and/or y to see beyond the first quadrant.

[@sangmoklee3476]

​@@joshemman Thank you for your reply. But in fact, what I meant is if it is possible to find the coordinate point of a line that crosses x-axis or y-axis by using the combination functions of MMULT and MINVERSE as you did in the clip.
Also, could you tell me how I should do if I want to draw a line that is vertical or horizontal such as x=1 or y=1?

[@joshemman]

@@sangmoklee3476 1) Yes, you can. I just think it's easier without MMULT. To find the x-intercept, use 1,0,0 for the x-coefficient, y-coefficient, and RHS respectively. For y-intercept, use 0, 1, 0.
2) You can construct a vertical line, say x = 1, by using (1, 1, y1, y2) where 1, 1 are the two x-values, and y1, y2 are any choices of y values you want. In the same vein, you can draw y = 2 using (x1, x2, 2, 2) where x1 and x2 are any 2 x-values.

[@XinboYu]

Thanks JC. God bless!

[@FlashNeptune]

Made me love maths already

[@aghelehtorabi1313]

ctr+shit+inter does not work in my mac. What should I do instead?

[@vetiscon1276]

Good communication.

[@ni9514]

yup definitely what was i looking for. but sadly found this gem after i took my test, sigh.

[@jaymarbabor4992]

Thank you very very much...

[@totahazem85]

. Very helpful thanks

[@mohamedrismy3060]

Thank You

[@gavinng7096]

very useful video

[@duncanwil]

That is excellent.