Design and Use of the Microsoft Excel Solver
Published Online:1 Oct 1998https://doi.org/10.1287/inte.28.5.29
Abstract
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.
This article appears in INFORMS Analytics Collections Vol. 15: 25 Years of INFORMS.
Visit this collection for free access to more articles showcasing the evolution of INFORMS over the past 25 years.
