Optimization using Excel – 20. Use of GRG solver

Video
Optimization using Excel
Lecture 20
Soumitra Chakraborty
Play Video

In this video, I have solved a smooth non-linear problem using the GRG solver in Excel. I have also explained how to choose the Convergence size and the Multi-start option in GRG. The multi-start option is like mimicking the genetic algorithm of the Evolutionary solver in that it chooses various starting points in anticipation of the fact that the objective value will eventually find its global optima.