Article ID: | iaor19992747 |
Country: | United States |
Volume: | 28 |
Issue: | 5 |
Start Page Number: | 29 |
End Page Number: | 55 |
Publication Date: | Sep 1998 |
Journal: | Interfaces |
Authors: | Lasdon Leon S., Fylstra Daniel, Waren Allan, Watson John |
Keywords: | optimization, spreadsheets |
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.