Design and Use of the Microsoft Excel Solver

Authors:
Daniel Fylstra;Leon Lasdon;John Watson;Allan Waren
Affiliations:
-;-;-;-
Venue:
Interfaces
Year:
1998

Citing 0
Cited 10

The Effect of a Web-Based Tutorial on Problem Formulation Ability

Information Technology and Management
Representing space in a PDP network: Coarse allocentric coding can mediate metric and nonmetric spatial judgements

Spatial Cognition and Computation
Special Section: Linking Academia with Real-World Practice: Several Approaches

Interfaces
A decision support methodology for stochastic multi-criteria linear programming using spreadsheets

Decision Support Systems
A comparative study of the reliability of nine statistical software packages

Computational Statistics & Data Analysis
Nestlé Improves Its Financial Reporting with Management Science

Interfaces
Optimizing Investments in Security Countermeasures: A Practical Tool for Fixed Budgets

IEEE Security and Privacy
Model-based optimisation of Wastewater Treatment Plants design

Environmental Modelling & Software
A spreadsheet-based decision support tool for blending problems in brass casting industry

Computers and Industrial Engineering
Genetic algorithms: a fundamental component of an optimization toolkit for improved engineering designs

GECCO'03 Proceedings of the 2003 international conference on Genetic and evolutionary computation: PartII

Quantified Score

Hi-index	0.00

Visualization

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.