 |
|
|
 |
Joern Meissner, Thanh-Ha Nguyen
|
|
| Abstract |
|
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.
|
|
| Keywords |
|
Optimization, Excel, Solver, Linear Program, Integer Program
|
|
| Status |
|
Tutorial |
|
| Download |
|
www.meiss.com/download/Spreadsheet-Optimization-Solver.pdf
(1412 kb) |
|
| Example |
|
www.meiss.com/download/LancasterBrewery.xlsx
(14 kb) |
|
| Reference |
|
BibTeX,
Plain Text |
|
|
|
 |
