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.

[@aundrianal]

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

[@28ronji]

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

[@86puneet]

This was really well explained...thanks Joshua!

[@that_is_my_real_name]

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

[@joshemman]

My pleasure, Ines.

[@alexz1105]

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

[@herztard]

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

[@shabrishshankar9934]

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

[@jm-wo4or]

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

[@sourabhch3044]

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

[@mustafameydanc384]

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

[@RosemaryMuwani]

So easy to understand. Thanks Joshua

[@jayaniniroshima9136]

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

[@outsidelife5411]

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

[@dayvienk7114]

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

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

[@kopolwalizah887]

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

[@marutisciencetutorial6392]

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

[@eoinpow]

Thanks

[@joshemman]

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

[@abdofeduconsult]

Hi Emma. It really helps. God bless you

[@TeganUkomadu-dr1hy]

thanks a lot NOW I understand

[@spirosntemiris2022]

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

[@joshemman]

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

[@shaktishivanand624]

Thank you for making it. Learned a new thing.

[@israelrpo]

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

[@amrounesalah8706]

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

[@yomnaelmasry2000]

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

[@trina5514]

Thank you so much!! You explained it well.

[@lissiemackintosh]

this was explained brilliantly!

[@vivianigwe4856]

Best tutor ever. Thanks Josh

[@MarcosFMedeirosF]

Thank you Sir. Very well done.

[@nands7288]

My dood u r a life saver

[@amandakaren6379]

THANKS A BUNCH

[@joshemman]

You're welcome, Amanda.

[@latanyahaynes808]

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

[@vilochanadilshan9903]

Thank you, sir

[@joshemman]

You're welcome, Vilochana.

[@kavehiskaveh]

Really helpful ! Thanks for your clear and simple instructions

[@nethukarunasinghe7313]

Worth 🤩 Found at the perfect time … Thanks a lot

[@chaevie257]

THIS IS SO HELPFUL THANK YOU 😭

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

[@jassiemrobinson6038]

woah this was perfect thanks so much

[@MlleLauraKa]

Many thanks! You really helped me

[@omarfaruque8814]

Helpful 🌺 Thank you 💗

[@eyakhamassi8748]

Thank u sooo much it was so helpful

[@AbA-bi5dz]

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

[@jawad8846]

Thanks, made easy and simple

[@joshemman]

Most welcome 😊

[@eugenembn8672]

Helped a lot!! Cheers

[@mnjrupp]

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

[@onlyakshat]

Excellent one

[@HalimatonSaadiah]

Thanks,very helpful video!

[@yaolin9198]

the best one! more videos please!!

[@maximus380]

great explanation indeed. thanks Joshua.

[@N8Kracken]

Such a clear and accurate video. Thanks a lot.

[@killiankapalazanyeleti9481]

Very helpful

[@joshemman]

Glad it helped

[@mudhaferhasan1743]

Brilliant and smart presentation,keep it up please.

[@kabirumaitamakura6388]

Interesting! Thank you so much.

[@athirak388]

Well explained and very useful. Thank you.

[@bittu587]

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

[@samihakhan1717]

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

[@sharadamishra3307]

Thank you for the explanation.

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

[@yashjhawar2232]

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

[@kiragabosco1210]

Super helpful, Thanks

[@tcareycares]

Top notch video! Thank you very much!

[@mohamedrismy3060]

Thank You

[@jeansagi]

Excellent !, Very well explained.

[@quickconceptsbybakhtawar]

Great work love it !!

[@jaymarbabor4992]

Thank you very very much...

[@joymccracken1939]

Awesome job! Thank you so much!!

[@zengardenvibes2403]

Great video. Can you share the excel file?

[@joshemman]

Here you go: bit.ly/3PuzAV1

[@codingwithalfred]

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

[@gavinng7096]

very useful video

[@mikeRT1200]

absolutely useful

[@flora8781]

really helpful video!

[@MsSuman9]

Very well explained !!

[@europe1122]

This is very helpful. Thanks Joshua (y)

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

[@anjaojasmined.6058]

The best I learned something new

[@solomonsackey7775]

Excellent job done

[@loriconrad6031]

Thank you so much! YOU ARE MY HERO!

[@sureshamallikarjunappa4301]

Thank you, good work

[@duncanwil]

That is excellent.

[@forestsunrise26]

Thank you so much Joshua!

[@iHermany]

Great tutorial, thank you!

[@Eric-mn5ek]

Thanks for this , indeed very helpful

[@vetiscon1276]

Good communication.

[@usamaaltaish9390]

Thank you

[@joshemman]

You're welcome

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

[@mahmoudbadi3602]

Great explanation. Thank you.

[@danyyilgiba]

Thanks. Very helpful!

[@ramanathanr6]

How to change the range of graph? How to change the scale of the axes?

[@joshemman]

Righ-click a the numbers on the axis and click Format Axis.

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

[@amandawilson47]

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

[@XinboYu]

Thanks JC. God bless!

[@FlashNeptune]

Made me love maths already

[@godifalene3125]

smart continue....

[@totahazem85]

. Very helpful thanks