Can spreadsheet solvers solve demanding optimization problems?
Autor(a) principal: | |
---|---|
Data de Publicação: | 2001 |
Outros Autores: | |
Tipo de documento: | Artigo |
Idioma: | eng |
Título da fonte: | Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) |
Texto Completo: | https://hdl.handle.net/1822/136 |
Resumo: | 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. |
id |
RCAP_4177ddb49de39209f9f608f74200d7b1 |
---|---|
oai_identifier_str |
oai:repositorium.sdum.uminho.pt:1822/136 |
network_acronym_str |
RCAP |
network_name_str |
Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) |
repository_id_str |
7160 |
spelling |
Can spreadsheet solvers solve demanding optimization problems?OptimizationProcess synthesisSpreadsheetsScience & TechnologySocial SciencesPracticing 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.John Wiley and SonsUniversidade do MinhoFerreira, Eugénio C.Salcedo, Romualdo20012001-01-01T00:00:00Zinfo:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/articleapplication/pdfhttps://hdl.handle.net/1822/136eng“Computer Applications in Engineering Education”. 9:1 (2001) 49-56.1061-377310.1002/cae.1005info:eu-repo/semantics/openAccessreponame:Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)instname:Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informaçãoinstacron:RCAAP2023-07-21T12:30:22Zoai:repositorium.sdum.uminho.pt:1822/136Portal AgregadorONGhttps://www.rcaap.pt/oai/openaireopendoar:71602024-03-19T19:25:31.544256Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) - Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informaçãofalse |
dc.title.none.fl_str_mv |
Can spreadsheet solvers solve demanding optimization problems? |
title |
Can spreadsheet solvers solve demanding optimization problems? |
spellingShingle |
Can spreadsheet solvers solve demanding optimization problems? Ferreira, Eugénio C. Optimization Process synthesis Spreadsheets Science & Technology Social Sciences |
title_short |
Can spreadsheet solvers solve demanding optimization problems? |
title_full |
Can spreadsheet solvers solve demanding optimization problems? |
title_fullStr |
Can spreadsheet solvers solve demanding optimization problems? |
title_full_unstemmed |
Can spreadsheet solvers solve demanding optimization problems? |
title_sort |
Can spreadsheet solvers solve demanding optimization problems? |
author |
Ferreira, Eugénio C. |
author_facet |
Ferreira, Eugénio C. Salcedo, Romualdo |
author_role |
author |
author2 |
Salcedo, Romualdo |
author2_role |
author |
dc.contributor.none.fl_str_mv |
Universidade do Minho |
dc.contributor.author.fl_str_mv |
Ferreira, Eugénio C. Salcedo, Romualdo |
dc.subject.por.fl_str_mv |
Optimization Process synthesis Spreadsheets Science & Technology Social Sciences |
topic |
Optimization Process synthesis Spreadsheets Science & Technology Social Sciences |
description |
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. |
publishDate |
2001 |
dc.date.none.fl_str_mv |
2001 2001-01-01T00:00:00Z |
dc.type.status.fl_str_mv |
info:eu-repo/semantics/publishedVersion |
dc.type.driver.fl_str_mv |
info:eu-repo/semantics/article |
format |
article |
status_str |
publishedVersion |
dc.identifier.uri.fl_str_mv |
https://hdl.handle.net/1822/136 |
url |
https://hdl.handle.net/1822/136 |
dc.language.iso.fl_str_mv |
eng |
language |
eng |
dc.relation.none.fl_str_mv |
“Computer Applications in Engineering Education”. 9:1 (2001) 49-56. 1061-3773 10.1002/cae.1005 |
dc.rights.driver.fl_str_mv |
info:eu-repo/semantics/openAccess |
eu_rights_str_mv |
openAccess |
dc.format.none.fl_str_mv |
application/pdf |
dc.publisher.none.fl_str_mv |
John Wiley and Sons |
publisher.none.fl_str_mv |
John Wiley and Sons |
dc.source.none.fl_str_mv |
reponame:Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) instname:Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação instacron:RCAAP |
instname_str |
Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação |
instacron_str |
RCAAP |
institution |
RCAAP |
reponame_str |
Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) |
collection |
Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) |
repository.name.fl_str_mv |
Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) - Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação |
repository.mail.fl_str_mv |
|
_version_ |
1799132739682697216 |