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 :)...
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.
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!
@@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?
@@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.
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).
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.
Thanks for taking the time to drop a note, Lira.
Much appreciated.
This is the most helpful tutorial I've ever seen. Thank you very much for making this!
I love the "to the point" approach.
You made this so simple and easy to follow. Thank you !
My pleasure, Ines.
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 :)...
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
This was really well explained...thanks Joshua!
Excellent video!! Thank you for breaking this down and showing tip on Excel.
SUPER helpful! I just did my whole project with the help of this video!!
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.
My pleasure, Liz. Thanks for dropping a note.
Fantastic video, thank you so much for breaking this down so easily. You are a life saver.
May God bless you this guy helped me finish most of my project by this video
Joshua you are amazing dude! So glad i found your channel.
Thank you , It is nice how you mention every single detail
Excellent very useful for my exam...thank u so much
Holy god about expertise of excel... im speechles..
I usually never comment on videos but this one was very well done. Good job.
This is exactly what I was looking for! Thank you so much.
You`re the God of Exel. Thanks a lot!!
Thanks man. Wish I saw this when I was doing operations research back in school.
Really helpful ! Thanks for your clear and simple instructions
Thank you very much for this video. It's really helpful
awesome! this is what I needed to do a quick linear programming graph. thanks so much!
Hi Emma. It really helps. God bless you
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!
this was explained brilliantly!
Thank you for making it. Learned a new thing.
Thank you so much!! You explained it well.
thanks a lot NOW I understand
Thank you Because I was very lost reading this in the book
Best tutor ever. Thanks Josh
Excellent.... Just Brilliant.... I want more....
Worth 🤩 Found at the perfect time … Thanks a lot
GREAT JOB..... Thank you very much for your help......Greetings from Greece!!!!!
Thanks for dropping a note my Greek friend. -Ἰησοῦς
Merci beaucoup pour le partage de la video thanks from Algeria.
Thank you Sir. Very well done.
THIS IS SO HELPFUL THANK YOU 😭
Well explained and very useful. Thank you.
Thank you, sir
You're welcome, Vilochana.
THANKS A BUNCH
You're welcome, Amanda.
Thanks for the video. I was able to replicate but with using the Solver Add-in.
Great tutorial! Thanks!
Glad it was helpful!
My dood u r a life saver
Brilliant and smart presentation,keep it up please.
you are awesome bro. it was a very good explanation of excel.
hi thank you for your video i was wondering do you have one for mac users
You can do it in Excel on a mac.
Thanks, made easy and simple
Most welcome 😊
great explanation indeed. thanks Joshua.
Many thanks! You really helped me
Wow! I am redoing my homework! Thank you sir.
Such a clear and accurate video. Thanks a lot.
Excellent one
Helpful 🌺
Thank you 💗
Thank u sooo much it was so helpful
Very helpful
Glad it helped
woah this was perfect thanks so much
Excellent !, Very well explained.
Thank you for the explanation.
Thank you so much.. I LEARN HOW TO DO IT.
the best one! more videos please!!
very useful video
How A point automatically show (1,8)???I don't understand it...
this vedio was very helpful for me
select AC3:AC3 and put formula press ctl+shift+enter
Helped a lot!! Cheers
Can you do a video on how to use this for the lottery. Powerball, and Mega Millions?
Top notch video! Thank you very much!
Excellent job done
Interesting! Thank you so much.
Super helpful, Thanks
Very well explained !!
Made me love maths already
Thank You
Good communication.
Great video. Can you share the excel file?
Here you go: bit.ly/3PuzAV1
Thank you! It was helpful
Great explanation. Thank you.
Thanks for this , indeed very helpful
Awesome job! Thank you so much!!
really helpful video!
Great work love it !!
absolutely useful
Thank you very very much...
The best I learned something new
Thank you, good work
This is very helpful. Thanks Joshua (y)
Thank you so much! YOU ARE MY HERO!
I am not able to get straight lines when we have to shade the feasible region. how to do it?
yup definitely what was i looking for. but sadly found this gem after i took my test, sigh.
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?
You will have to input some negative values for x and/or y to see beyond the first quadrant.
@@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?
@@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.
Thank you!!!!!!! this is awesome
That is excellent.
Thanks. Very helpful!
Thank you so much Joshua!
. Very helpful thanks
Thank you
You're welcome
smart continue....
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?
X values (1900, 1900) Y values (0, highest y value)
@@joshemman Thank you !
@3:32 why did you replace C1's series x and y values - wasn't it already 3,0 0,12?
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).
How to change the range of graph?
How to change the scale of the axes?
Righ-click a the numbers on the axis and click Format Axis.
Thanks JC. God bless!
Excellent