My Operations Research course (Click Here for the Syllabus) is all about optimization.
We discussed briefly different ways of modeling with spreadsheets. I have uploaded one of the resources[1] my professor, Dr. Mikhail Khenner, distributed to the class.
You may also be interested in the Excel Add-In that can be used with optimization problems. Please visit [2] for more about this.
An example of an Excel file that demonstrates a modeling problem can be seen in [3]. This file goes along with handout [1].
[1] http://www.tylerclark12.com/blog/wp-content/uploads/2010/11/SpreadsheetsForModeling.pdf
[2] http://peltiertech.com/WordPress/installing-an-add-in-in-excel-2007/
[3] http://www.tylerclark12.com/blog/wp-content/uploads/2010/11/Solver_Filexlsx.xlsx
Copyright secured by Digiprove © 2010 Tyler Clark
