Design and use of the Microsoft Excel Solver

被引：390

作者：

Fylstra, D

Lasdon, L

Watson, J

Waren, A

机构：

[1] Frontline Syst Inc, Incline Village, NV 89450 USA

[2] Univ Texas, Coll Business Adm, Dept Management Sci & Informat Syst, Austin, TX 78712 USA

[3] Software Engines, Menlo Park, CA 94025 USA

[4] Cleveland State Univ, Dept Informat & Comp Sci, Cleveland, OH 44115 USA

来源：

INTERFACES | 1998年 / 28卷 / 05期

关键词：

computers; computer science; software;

D O I：

10.1287/inte.28.5.29

中图分类号：

C93 [管理学];

学科分类号：

12 ; 1201 ; 1202 ; 120202 ;

摘要：

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.

引用

页码：29 / 55

页数：27

共 26 条

[1] [Anonymous], 1997, PRACTICAL MANAGEMENT
[2] Teachers' forum: Teaching MBA quantitative business analysis with cases
Bodily, SE
[J]. INTERFACES, 1996, 26 (06) : 132 - 138
[3] Brooke A, 1992, GAMS: a user's guide
[4] Chinneck J. W., 1997, INFORMS Journal on Computing, V9, P164, DOI 10.1287/ijoc.9.2.164
[5] CONWAY D, 1987, OMEGA, V25, P313
[6] *ENF SOFTW CORP, 1988, OPT SOL US MAN
[7] EPPEN GD, 1998, INTRO MANAGEMENT SCI
[8] Fourer R, 1993, AMPL MODELING LANGUA
[9] *FRONTL SYST INC, 1990, WHAT IF SOLV US GUID
[10] Frontline Systems Inc, 1994, SOLV US GUID PREM QU

← 1 2 3 →