Design and Use of the Microsoft Excel Solver

Daniel Fylstra, Leon Lasdon, John Watson and Allan Waren
Additional contact information
Daniel Fylstra: Frontline Systems Inc., PO Box 4288, Incline Village, Nevada 89450
Leon Lasdon: Department of Management Science and Information Systems, College of Business Administration, University of Texas, Austin, Texas 78712
John Watson: Software Engines, 725 Magnolia Street, Menlo Park, California 94025
Allan Waren: Computer and Information Science Department, Cleveland State University, Cleveland, Ohio 44115

Interfaces, 1998, vol. 28, issue 5, 29-55

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.

Keywords: computers/computer science; software (search for similar items in EconPapers)
Date: 1998
References: View references in EconPapers View complete reference list from CitEc
Citations: View citations in EconPapers (42)

Downloads: (external link)
http://dx.doi.org/10.1287/inte.28.5.29 (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:inm:orinte:v:28:y:1998:i:5:p:29-55

Access Statistics for this article

More articles in Interfaces from INFORMS Contact information at EDIRC.
Bibliographic data for series maintained by Chris Asher ().