Design and Use of the Microsoft Excel Solver
Daniel H. FylstraLeon S. LasdonDepartment of Management Science and Information Systems, College of Business Administration, University of Texas, Austin, Texas 78712John WatsonAllan D. WarenComputer and Information Science Department, Cleveland State University, Cleveland, Ohio 44115
1998en
ABI
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.
Identifiers
Citations and references
Cited by 20 references