Excel Solver & Goal Seek Kevin Stratvert
video description
Date: 2022-03-15
Related videos
Comments and reviews: 10
Geert
Hey Kevin,
Great simplex example for how to use Solver! ;-)
Please note that there-s (a lot) more to the underlying solvers algorithms than what you showed.
Especially the Simplex (LP - Linear Programming) method is more intricate than your straight line suggests.
BTW: it was invented by an American (USAF) back in 1947, so you should be a little proud about it. :-)
Also, only Simplex is guaranteed to find the global optimum solution. That-s one of the beautiful things about LP.
The requirements for it-s use: all equations (objective and constraints) need to be linear in the variables.
FYI: all your examples were linear.
Then again, truth be told: -Life is a Constrained Optimisation Problem-, but it-s non-linear and often not even smooth.
That-s why life chose the Evolutionary Solver.
...Just think about that one for a minute and let it sink in. :-)
See you on the next one! :-)
reply
Hey Kevin,
Great simplex example for how to use Solver! ;-)
Please note that there-s (a lot) more to the underlying solvers algorithms than what you showed.
Especially the Simplex (LP - Linear Programming) method is more intricate than your straight line suggests.
BTW: it was invented by an American (USAF) back in 1947, so you should be a little proud about it. :-)
Also, only Simplex is guaranteed to find the global optimum solution. That-s one of the beautiful things about LP.
The requirements for it-s use: all equations (objective and constraints) need to be linear in the variables.
FYI: all your examples were linear.
Then again, truth be told: -Life is a Constrained Optimisation Problem-, but it-s non-linear and often not even smooth.
That-s why life chose the Evolutionary Solver.
...Just think about that one for a minute and let it sink in. :-)
See you on the next one! :-)
reply
Jim
Awesome Video. Going to play with your sample file to see how to include Day Old Cookies (i.e. current -acceptable- inventory) to see how I can maintain a full Product selection for your company - including the Fortune Cookie customer desires. Suspect that if money is the only goal - will need to reduce the variety of Cookies offered.
I REALLY APPRECIATE your Video's. Not only the content but your voice and diction. I'm hearing impaired and your one of the very few presenters that I NEVER have any trouble understanding the audio or the content your presenting. The sample files and the hyperlinks to sections of the video are OUTSTANDING.
THANKS a Million (Cookies). ;-]
reply
Awesome Video. Going to play with your sample file to see how to include Day Old Cookies (i.e. current -acceptable- inventory) to see how I can maintain a full Product selection for your company - including the Fortune Cookie customer desires. Suspect that if money is the only goal - will need to reduce the variety of Cookies offered.
I REALLY APPRECIATE your Video's. Not only the content but your voice and diction. I'm hearing impaired and your one of the very few presenters that I NEVER have any trouble understanding the audio or the content your presenting. The sample files and the hyperlinks to sections of the video are OUTSTANDING.
THANKS a Million (Cookies). ;-]
reply
Anne
Hi Kevin, Thanks for loading such helpful videos.
Could you please solve one problem - How to reduce the time frame - this annoying windows 10 pop volume control panel stays on screen. That comes on the top left hand corner. It just stays on for soooooo long. This is a big nuisance. It want the pop up to come but only stay for short time. Can you plz help with this. Thanks
reply
Hi Kevin, Thanks for loading such helpful videos.
Could you please solve one problem - How to reduce the time frame - this annoying windows 10 pop volume control panel stays on screen. That comes on the top left hand corner. It just stays on for soooooo long. This is a big nuisance. It want the pop up to come but only stay for short time. Can you plz help with this. Thanks
reply
Loverboy84
Hi great video. How do you make solver update automatically when you change a value that is used in the equation, not an input value that you are asking to calculate but a constant that you set manually. How you can get all of the solutions visible that will fulfill the constraints?
reply
Hi great video. How do you make solver update automatically when you change a value that is used in the equation, not an input value that you are asking to calculate but a constant that you set manually. How you can get all of the solutions visible that will fulfill the constraints?
reply
The
I need Solver to accept formulas in the Variable Cells Line so that it can select only certain cells within a range. Is this possible? If not, is there an alternate method to achieve my goal?
reply
I need Solver to accept formulas in the Variable Cells Line so that it can select only certain cells within a range. Is this possible? If not, is there an alternate method to achieve my goal?
reply
Felix
Hi Kevin, great video first of all. Very clear explanation and concise. I'm just wondering though - what if there's multiple solution to the problem? Is there any way to display this?
reply
Hi Kevin, great video first of all. Very clear explanation and concise. I'm just wondering though - what if there's multiple solution to the problem? Is there any way to display this?
reply
Sage
Very useful video thank you
I have a question, what's the difference between evolutionary and GRG non-linear with multistart optiion? Form what I understood they do the same thing.
reply
Very useful video thank you
I have a question, what's the difference between evolutionary and GRG non-linear with multistart optiion? Form what I understood they do the same thing.
reply
Franz
Love it.
Will you do a -How to use- the -Szenario Manager- ?
it would be very interesting; if you can come up with a good use case :-)
BR from Switzerland
reply
Love it.
Will you do a -How to use- the -Szenario Manager- ?
it would be very interesting; if you can come up with a good use case :-)
BR from Switzerland
reply
Sarah
Very meticulous way of explaining my friend,Keep it up.i come back to your videos all the time whenever I have problems on EXcel.Thanks for helping me out!
reply
Very meticulous way of explaining my friend,Keep it up.i come back to your videos all the time whenever I have problems on EXcel.Thanks for helping me out!
reply
texasseastar
Say what??? I had no idea that Goal Seek or Solver even existed in Excel. Yet another Kevin video I need to bookmark for reference. Thanks Kevin!
reply
Say what??? I had no idea that Goal Seek or Solver even existed in Excel. Yet another Kevin video I need to bookmark for reference. Thanks Kevin!
reply
Add a review, comment
Other channel videos
17:8
