Video
Optimization using Excel
Lecture 9
Soumitra Chakraborty
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.