Excel Solver Guidelines

Excel ships with a powerful add-in for multi-parameter optimization called Solver. Although Solver is a very robust optimizer, there are some tips and pitfalls in its usage that are not documented in Excel. A report written by the authors of the Solver algorithm provides insight into the inner workings of the optimizer. From the report introduction:
"In designing the spreadsheet optimizer that is bundled with
Microsoft Excel, we and Microsoft made certain choices in designing
its user interface, model processing, and solution algorithms
for linear, nonlinear, and integer programs. We describe
some of the common pitfalls users encounter and remedies
available in the latest version of Microsoft Excel. The Solver
has many applications and great impact in industry and
education."
The full report can be accessed at: Isotherm Technologies: Resources

Isotherm Technologies LLC