Utilize este identificador para referenciar este registo:
https://hdl.handle.net/1822/136
Título: | Can spreadsheet solvers solve demanding optimization problems? |
Autor(es): | Ferreira, Eugénio C. Salcedo, Romualdo |
Palavras-chave: | Optimization Process synthesis Spreadsheets |
Data: | 2001 |
Editora: | John Wiley and Sons |
Revista: | Computer Applications in Engineering Education |
Citação: | “Computer Applications in Engineering Education”. 9:1 (2001) 49-56. |
Resumo(s): | Practicing engineers resort to modular simulators or to algebraic tools such as GAMS or AMPL for performing complex process optimizations. These tools, however, have a significant learning curve unless they have been introduced at the undergraduate level beforehand. In this work we show how the Solver feature of the Excel spreadsheet can be used for the optimization of a fairly complex system, i.e., a classic solvent extraction/pollution prevention with heat integration process. The specific goal was the design optimization for continuous recovery of organic solvents (VOCs) using a gas absorption tower with solvent recovery in a stripper. It is shown that the Solver feature of the Excel spreadsheet can be used to converge on local optima for these complex systems, provided proper care is taken in the solution procedure. The complexities of optimization can also be demonstrated with this tool, as can several common pitfalls encountered during optimization. |
Tipo: | Artigo |
URI: | https://hdl.handle.net/1822/136 |
DOI: | 10.1002/cae.1005 |
ISSN: | 1061-3773 |
Arbitragem científica: | yes |
Acesso: | Acesso aberto |
Aparece nas coleções: | CEB - Publicações em Revistas/Séries Internacionais / Publications in International Journals/Series |
Ficheiros deste registo:
Ficheiro | Descrição | Tamanho | Formato | |
---|---|---|---|---|
CAEE-2001.pdf | 185,17 kB | Adobe PDF | Ver/Abrir |