![](http://www.meiss.com/images/abstract/pix-black.gif) |
|
![](http://www.meiss.com/images/abstract/pix.gif) |
Joern Meissner, Thanh-Ha Nguyen
|
![](http://www.meiss.com/images/abstract/pix.gif) |
Abstract |
![](http://www.meiss.com/images/abstract/pix.gif) |
The major PC-based spreadsheet, Microsoft Excel, has a built-in optimizer called Solver. This optimizer allows for linear, non-linear, and integer programs to be solved within the spreadsheet. This tutorial provides a brief introduction to using the optimizer Solver, which is available in the Analysis group on the Data tab in Excel.
|
![](http://www.meiss.com/images/abstract/pix.gif) |
Keywords |
![](http://www.meiss.com/images/abstract/pix.gif) |
Optimization, Excel, Solver, Linear Program, Integer Program
|
![](http://www.meiss.com/images/abstract/pix.gif) |
Status |
![](http://www.meiss.com/images/abstract/pix.gif) |
Tutorial |
![](http://www.meiss.com/images/abstract/pix.gif) |
Download |
![](http://www.meiss.com/images/abstract/pix.gif) |
www.meiss.com/download/Spreadsheet-Optimization-Solver.pdf (1412 kb) |
![](http://www.meiss.com/images/abstract/pix.gif) |
Example |
![](http://www.meiss.com/images/abstract/pix.gif) |
www.meiss.com/download/LancasterBrewery.xlsx (14 kb) |
![](http://www.meiss.com/images/abstract/pix.gif) |
Reference |
![](http://www.meiss.com/images/abstract/pix.gif) |
BibTeX,
Plain Text |
|
|
![](http://www.meiss.com/images/abstract/pix-black.gif) |
![](http://www.meiss.com/images/abstract/shadow-top.gif) |