Can Spreadsheet Solvers Solve Demanding Optimization Problems?

Computer Applications in Engineering Education

Volumn 9, Issue 1, 2001, Pages 49-56

  Ferreira, Eugénio C ^a,b   Salcedo, Romualdo ^b,c  

^a UNIVERSITY OF MINHO   (Portugal)

^b UNIVERSITY OF PORTO   (Portugal)

^c MCGILL UNIVERSITY   (Canada)

Author keywords

Optimization; Process synthesis; Spreadsheets

Indexed keywords

EID: 0442297383     PISSN: 10613773     EISSN: None     Source Type: Journal    
DOI: 10.1002/cae.1005     Document Type: Article

References (15)

1. T. Umeda, Optimal design of an absorber-stripper system, I&EC Process Design and Dev 8(3) (1969), 308-317.
2. T. Umeda and A. Ichikawa, A modified complex method for optimization, I&EC Process Design Dev 10(2) (1971), 229-236.
3. P. Silverberg, A scrubber system tackles 15 different VOCs, Chem Eng 103(10), (1996), 159.
4. J. M. Douglas, Conceptual design of chemical processes, McGraw-Hill, New York, 1988.
5. R. Salcedo and R. Lima, On the optimum choice of decision variables for equation-oriented global optimization, Ind Eng Chem Res 38(12), (1999), 4742-4758.
6. R. Salcedo, M. J. Gonçalves, and S. Feyo de Azevedo, An improved random search algorithm for non-linear optimization, Comput Chem Eng 14(19), (1990), 1111-1126.
7. R. Salcedo, Solving nonconvex nonlinear programming and mixed-integer nonlinear programming problems with adaptive random search Ind Eng Chem Res 31(1), (1992), 262-273.
8. F. M. Julian, Using spreadsheets in Chemical Engineering problems. In G. Filby (Editor), Spreadsheets in Science and Engineering, Springer, Berlin, 1998, Chap. 6, pp. 171-202.
9. M. A. Burns and J. C. Sung, Design of separation units using spreadsheets Chem Eng Educ (Winter 1996), 62-69.
10. B. S. Mitchell, Use of spreadsheets in introductory statistics and probability, Chem Eng Educ (Summer 1997), 194-200.
11. L. S. Lasdon, A. D. Waren, A. Jain, and M. Ratner, Design and testing of a generalized reduced gradient code for nonlinear programming, ACM Trans Math Software 1(4), (1978), 34-50.
12. D. Fylstra, L. S. Lasdon, A. D. Waren and J. Watson, Design and use of the Microsoft Excel solver Interfaces 28(5) (1998), 29-55.
13. Microsoft EXCEL - Visual Basic for Applications, Microsoft Press, Washington, 1995.
14. E. M. Rosen, Visual Basic for Applications, Add-Ins and Excel 7.0, CACHE News (45), (Fall 1997), 1-3.
15. M. F. Cardoso, R. L. Salcedo, S. Feyo de Azevedo, and D. Barbosa, A simulated annealing approach to the solution of MINLP problems, Comput Chem Eng 21(12) (1997), 1349-1364.