An Introduction to Spreadsheet Optimization Using Excel Solver

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
Back to Publications