Spreadsheets in chemical engineering education: a tool in process design and process integration
Autor(a) principal: | |
---|---|
Data de Publicação: | 2004 |
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/1457 |
Resumo: | Recent developments in embedding numerical optimization procedures with linear and nonlinear solvers within a spreadsheet environment have greatly enhanced the use of these tools for teaching chemical process design and process integration. Student skills with respect to these topics are usually gained by complex and expensive modular simulators, e.g. ASPEN Plus® or algebraic tools such as GAMS® or AMPL®. However, modular simulators have a significant learning curve, and algebraic modeling languages are usually ignored once students commence careers. This paper demonstrates how the Solver feature of the Excel® spreadsheet is used for the optimization of several chemical engineering systems, including pollution prevention problems and mass-exchange networks. Three nonlinear problems are examined: the (a) recovery of benzene from a gaseous emission; (b) design of a chemical reactor network; and (c) solution of material balances in the production of vinyl chloride from ethylene. Dephenolization of aqueous wastes is presented as a linear case. The ease with which these and similar process problems can be formulated and solved within the Excel® environment constitutes a major step towards teaching practical optimization and design concepts for university students. |
id |
RCAP_c0b1adc6ac6e5728aa57cba0165bde6c |
---|---|
oai_identifier_str |
oai:repositorium.sdum.uminho.pt:1822/1457 |
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 |
Spreadsheets in chemical engineering education: a tool in process design and process integrationSocial SciencesScience & TechnologyRecent developments in embedding numerical optimization procedures with linear and nonlinear solvers within a spreadsheet environment have greatly enhanced the use of these tools for teaching chemical process design and process integration. Student skills with respect to these topics are usually gained by complex and expensive modular simulators, e.g. ASPEN Plus® or algebraic tools such as GAMS® or AMPL®. However, modular simulators have a significant learning curve, and algebraic modeling languages are usually ignored once students commence careers. This paper demonstrates how the Solver feature of the Excel® spreadsheet is used for the optimization of several chemical engineering systems, including pollution prevention problems and mass-exchange networks. Three nonlinear problems are examined: the (a) recovery of benzene from a gaseous emission; (b) design of a chemical reactor network; and (c) solution of material balances in the production of vinyl chloride from ethylene. Dephenolization of aqueous wastes is presented as a linear case. The ease with which these and similar process problems can be formulated and solved within the Excel® environment constitutes a major step towards teaching practical optimization and design concepts for university students.Fundação para a Ciência e a Tecnologia (FCT) – PRAXIS XXI BD/21481/99.Dublin Institute of Technology Tempus PublicationsUniversidade do MinhoFerreira, Eugénio C.Lima, RicardoSalcedo, Romualdo20042004-01-01T00:00:00Zinfo:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/articleapplication/pdfhttps://hdl.handle.net/1822/1457eng"International journal of engineering education". ISSN 0949-149X. 20:6 (2004) 928-938.0949-149Xinfo: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:42:29Zoai:repositorium.sdum.uminho.pt:1822/1457Portal AgregadorONGhttps://www.rcaap.pt/oai/openaireopendoar:71602024-03-19T19:39:44.793176Repositó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 |
Spreadsheets in chemical engineering education: a tool in process design and process integration |
title |
Spreadsheets in chemical engineering education: a tool in process design and process integration |
spellingShingle |
Spreadsheets in chemical engineering education: a tool in process design and process integration Ferreira, Eugénio C. Social Sciences Science & Technology |
title_short |
Spreadsheets in chemical engineering education: a tool in process design and process integration |
title_full |
Spreadsheets in chemical engineering education: a tool in process design and process integration |
title_fullStr |
Spreadsheets in chemical engineering education: a tool in process design and process integration |
title_full_unstemmed |
Spreadsheets in chemical engineering education: a tool in process design and process integration |
title_sort |
Spreadsheets in chemical engineering education: a tool in process design and process integration |
author |
Ferreira, Eugénio C. |
author_facet |
Ferreira, Eugénio C. Lima, Ricardo Salcedo, Romualdo |
author_role |
author |
author2 |
Lima, Ricardo Salcedo, Romualdo |
author2_role |
author author |
dc.contributor.none.fl_str_mv |
Universidade do Minho |
dc.contributor.author.fl_str_mv |
Ferreira, Eugénio C. Lima, Ricardo Salcedo, Romualdo |
dc.subject.por.fl_str_mv |
Social Sciences Science & Technology |
topic |
Social Sciences Science & Technology |
description |
Recent developments in embedding numerical optimization procedures with linear and nonlinear solvers within a spreadsheet environment have greatly enhanced the use of these tools for teaching chemical process design and process integration. Student skills with respect to these topics are usually gained by complex and expensive modular simulators, e.g. ASPEN Plus® or algebraic tools such as GAMS® or AMPL®. However, modular simulators have a significant learning curve, and algebraic modeling languages are usually ignored once students commence careers. This paper demonstrates how the Solver feature of the Excel® spreadsheet is used for the optimization of several chemical engineering systems, including pollution prevention problems and mass-exchange networks. Three nonlinear problems are examined: the (a) recovery of benzene from a gaseous emission; (b) design of a chemical reactor network; and (c) solution of material balances in the production of vinyl chloride from ethylene. Dephenolization of aqueous wastes is presented as a linear case. The ease with which these and similar process problems can be formulated and solved within the Excel® environment constitutes a major step towards teaching practical optimization and design concepts for university students. |
publishDate |
2004 |
dc.date.none.fl_str_mv |
2004 2004-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/1457 |
url |
https://hdl.handle.net/1822/1457 |
dc.language.iso.fl_str_mv |
eng |
language |
eng |
dc.relation.none.fl_str_mv |
"International journal of engineering education". ISSN 0949-149X. 20:6 (2004) 928-938. 0949-149X |
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 |
Dublin Institute of Technology Tempus Publications |
publisher.none.fl_str_mv |
Dublin Institute of Technology Tempus Publications |
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_ |
1799132940581470208 |