Design and use of the Microsoft Excel Solver

Interfaces

Volumn 28, Issue 5, 1998, Pages 29-55

  Fylstra, Daniel ^a   Lasdon, Leon ^b   Watson, John ^c   Waren, Allan ^d  

^a Frontline Systems   (United States)

^b UNIVERSITY OF TEXAS AT AUSTIN   (United States)

^c Software Engines   (United States)

^d CLEVELAND STATE UNIVERSITY   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

EID: 0008621673     PISSN: 00922102     EISSN: None     Source Type: Journal    
DOI: 10.1287/inte.28.5.29     Document Type: Article

References (26)

1. Bodily, S. 1996, "Teaching MBA quantitative business analysis with cases," Interfaces, Vol. 26, No. 6, pp. 132-149.
2. Brooke, A.; Kendrick, D.; and Meeraus, A. 1992, GAMS, A User's Guide, Boyd and Fraser, Danvers, Massachusetts.
3. Chinneck, J. W. 1997, "Finding a useful subset of constraints for analysis in an infeasible linear program," INFORMS Journal on Computing, Vol. 9, No. 2, pp. 164-174.
4. Conway, D. and Ragsdale, C. 1987, "Modeling optimization problems in the unstructured world of spreadsheets," Omega, Vol. 25, No. 3, pp. 313-322.
5. Enfin Software Corporation 1988, Optimal Solutions User Manual, San Diego, California.
6. Eppen, G. D.; Gould, F.; Schmidt, C.; Moore, J.; and Weatherford, L. 1998, Introductory Management Science: Decision Modeling with Spreadsheets, fifth edition, Prentice Hall, Englewood Cliffs, New Jersey.
7. Fourer, R.; Gay, D. M.; and Kernighan, B. W. 1993, AMPL: A Modeling Language for Mathematical Programming, Duxbury Press, Pacific Grove, California.
8. Frontline Systems Inc. 1990, What-If Solver User Guide, Incline Village, Nevada.
9. Frontline Systems Inc. 1994, Solver User Guide: Premium, Quadratic, and Large-Scale LP Solvers, Incline Village, Nevada.
10. Fylstra, D. 1992, The Student Edition of What-If Solver, Addison-Wesley Longman, Reading, Massachusetts.
11. Geoffrion, A. M. 1991, "Forces, trends, and opportunities in management science and operations research," Operations Research, Vol. 4, No. 3, pp. 423-445.
12. Gill, P. E.; Murray, W.; and Wright, M. H. 1981, Practical Optimization, Academic Press, San Diego, California.
13. Griewank, A. and Corliss, G. F. 1991, Automatic Differentiation of Algorithms: Theory, Implementation, and Application, SIAM Press, Philadelphia, Pennsylvania.
14. Hesse, R. 1997, Managerial Spreadsheet Modeling and Analysis, Richard D. Irwin, Burr Ridge, Illinois.
15. Jordan, E.; Lasdon, L.; Lenard, M.; Moore, J.; Powell, S.; and Willemain, T. 1997, "OR/MS and MBA's - Mediating the mismatches," OR/MS Today, February, pp. 36-41.
16. Lasdon, L. S.; Waren, A. D.; Jain, A.; and Ratner, M. 1978, "Design and testing of a generalized reduced gradient code for nonlinear programming," ACM Transactions on Mathematical Software, Vol. 4, No. 1, pp. 34-49.
17. Lasdon, L. S. and Smith, S. 1992, "Solving large sparse nonlinear programs using GRG," ORSA Journal on Computing, Vol. 4, No. 1, pp. 2-15.
18. Lilien, G. and Rangaswamy, A. 1997, Marketing Engineering: Computer-Assisted Marketing Analysis and Planning, Addison-Wesley Longman, Reading, Massachusetts.
19. Lotus Development Corp. 1990, 1-2-3/G User Guide, Cambridge, Massachusetts.
20. Ng, E. and Char, B. W. 1979, "Gradient and Jacobian computation for numerical applications," Proceedings of the 1979 Macsyma User's Conference, Washington, DC, pp. 604-621.
21. Person, R. 1997, Using Microsoft Excel 97, Que Corp./Macmillian Computer Publishing, Indianapolis, Indiana.
22. Powell, S. G. 1995, "Teaching the art of modeling to MBA students," Interfaces, Vol. 25, No. 3, pp. 88-94.
23. Ragsdale, C. T. 1997, Spreadsheet Modeling and Decision Analysis, second edition, South-Western Publishing, Cambridge, Massachusetts.
24. Savage, S. L. 1985, What'sBest! User Manual, General Optimization Inc., Chicago, Illinois.
25. Savage, S. L. 1997, INSIGHT Business Analysis Tools for Excel, Duxbury Press, Pacific Grove, California.
26. Winston, W. L. and Albright, S. C. 1997, Practical Management Science: Spreadsheet Modeling and Applications, Duxbury Press, Pacific Grove, California.