Excel as an optimization tool applied to multicomponent distillation column sizing
Autor(a) principal: | |
---|---|
Data de Publicação: | 2024 |
Outros Autores: | , , , , |
Tipo de documento: | Artigo |
Idioma: | eng |
Título da fonte: | Revista de Engenharia Química e Química |
Texto Completo: | https://periodicos.ufv.br/jcec/article/view/18680 |
Resumo: | The unit operation of distillation is a method of significant importance for industrial separation processes, as it enables the fractionation of a mixture based on the differences in volatility among its components. Considering that a typical initial mixture generally contains three or more products of interest, studies aimed at optimizing multicomponent distillation, although scarce in the literature, are increasingly imperative to ensure efficiency and reduce operational and energy costs associated with the process. Since sizing multicomponent distillation columns using the Fenske-Underwood and Gilliland (FUG) and Kirkbride methods involves extensive and complex calculations to obtain operational parameters, the objective of this study was to develop a computational method using Microsoft Excel® software to make them more practical and enhance the accuracy of the results obtained. The functionality of the developed spreadsheet was verified through the resolution of an example of application, both manually and electronically. In both cases, the results obtained were identical, but with significantly lower time consumption and probability of error by the electronic method, demonstrating its potential for use in academic and industrial settings. |
id |
UFV-4_5dc27c41956773d00c8a29f5ef7e900d |
---|---|
oai_identifier_str |
oai:ojs.periodicos.ufv.br:article/18680 |
network_acronym_str |
UFV-4 |
network_name_str |
Revista de Engenharia Química e Química |
repository_id_str |
|
spelling |
Excel as an optimization tool applied to multicomponent distillation column sizingExcel como uma ferramenta de otimização aplicada ao dimensionamento de colunas de destilação multicomponenteSeparationMulticomponentFenske-Underwood methodGilliland methodExcelSeparaçãoMulticomponenteMétodo de Fenske-UnderwoodMétodo de GillilandExcelThe unit operation of distillation is a method of significant importance for industrial separation processes, as it enables the fractionation of a mixture based on the differences in volatility among its components. Considering that a typical initial mixture generally contains three or more products of interest, studies aimed at optimizing multicomponent distillation, although scarce in the literature, are increasingly imperative to ensure efficiency and reduce operational and energy costs associated with the process. Since sizing multicomponent distillation columns using the Fenske-Underwood and Gilliland (FUG) and Kirkbride methods involves extensive and complex calculations to obtain operational parameters, the objective of this study was to develop a computational method using Microsoft Excel® software to make them more practical and enhance the accuracy of the results obtained. The functionality of the developed spreadsheet was verified through the resolution of an example of application, both manually and electronically. In both cases, the results obtained were identical, but with significantly lower time consumption and probability of error by the electronic method, demonstrating its potential for use in academic and industrial settings.A operação unitária de destilação é um método de grande importância para os processos de separação industrial, pois permite o fracionamento de uma mistura com base nas diferenças de volatilidade entre seus componentes. Considerando que uma mistura inicial típica geralmente contém três ou mais produtos de interesse, estudos que visam a otimização da destilação multicomponente, embora escassos na literatura, são cada vez mais imperativos para garantir a eficiência e reduzir os custos operacionais e energéticos associados ao processo. Como o dimensionamento de colunas de destilação multicomponentes usando os métodos Fenske-Underwood e Gilliland (FUG) e Kirkbride envolve cálculos extensos e complexos para obtenção de parâmetros operacionais, o objetivo deste trabalho foi desenvolver um método computacional usando o software Microsoft Excel® para torná-los mais práticos e aumentar a precisão dos resultados obtidos. A funcionalidade da planilha desenvolvida foi verificada através da resolução de um exemplo de aplicação, tanto manualmente quanto eletronicamente. Em ambos os casos, os resultados obtidos foram idênticos, porém com consumo de tempo e probabilidade de erro significativamente menores pelo método eletrônico, demonstrando seu potencial de uso em ambientes acadêmicos e industriais.Universidade Federal de Viçosa - UFV2024-05-10info:eu-repo/semantics/articleinfo:eu-repo/semantics/publishedVersionapplication/pdfapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheethttps://periodicos.ufv.br/jcec/article/view/1868010.18540/jcecvl10iss3pp18680The Journal of Engineering and Exact Sciences; Vol. 10 No. 3 (2024); 18680The Journal of Engineering and Exact Sciences; Vol. 10 Núm. 3 (2024); 18680The Journal of Engineering and Exact Sciences; v. 10 n. 3 (2024); 186802527-1075reponame:Revista de Engenharia Química e Químicainstname:Universidade Federal de Viçosa (UFV)instacron:UFVenghttps://periodicos.ufv.br/jcec/article/view/18680/9674https://periodicos.ufv.br/jcec/article/view/18680/9605Copyright (c) 2024 The Journal of Engineering and Exact Scienceshttps://creativecommons.org/licenses/by/4.0info:eu-repo/semantics/openAccessRibeiro, Luan Jonas de SouzaCarneiro, Camila RodriguesBosmediano, Sara GallegosNeves , Mateus TomazDias, Manoela Maciel dos SantosCarvalho, Fernanda Raquel2024-05-15T20:25:07Zoai:ojs.periodicos.ufv.br:article/18680Revistahttp://www.seer.ufv.br/seer/rbeq2/index.php/req2/indexONGhttps://periodicos.ufv.br/jcec/oaijcec.journal@ufv.br||req2@ufv.br2446-94162446-9416opendoar:2024-05-15T20:25:07Revista de Engenharia Química e Química - Universidade Federal de Viçosa (UFV)false |
dc.title.none.fl_str_mv |
Excel as an optimization tool applied to multicomponent distillation column sizing Excel como uma ferramenta de otimização aplicada ao dimensionamento de colunas de destilação multicomponente |
title |
Excel as an optimization tool applied to multicomponent distillation column sizing |
spellingShingle |
Excel as an optimization tool applied to multicomponent distillation column sizing Ribeiro, Luan Jonas de Souza Separation Multicomponent Fenske-Underwood method Gilliland method Excel Separação Multicomponente Método de Fenske-Underwood Método de Gilliland Excel |
title_short |
Excel as an optimization tool applied to multicomponent distillation column sizing |
title_full |
Excel as an optimization tool applied to multicomponent distillation column sizing |
title_fullStr |
Excel as an optimization tool applied to multicomponent distillation column sizing |
title_full_unstemmed |
Excel as an optimization tool applied to multicomponent distillation column sizing |
title_sort |
Excel as an optimization tool applied to multicomponent distillation column sizing |
author |
Ribeiro, Luan Jonas de Souza |
author_facet |
Ribeiro, Luan Jonas de Souza Carneiro, Camila Rodrigues Bosmediano, Sara Gallegos Neves , Mateus Tomaz Dias, Manoela Maciel dos Santos Carvalho, Fernanda Raquel |
author_role |
author |
author2 |
Carneiro, Camila Rodrigues Bosmediano, Sara Gallegos Neves , Mateus Tomaz Dias, Manoela Maciel dos Santos Carvalho, Fernanda Raquel |
author2_role |
author author author author author |
dc.contributor.author.fl_str_mv |
Ribeiro, Luan Jonas de Souza Carneiro, Camila Rodrigues Bosmediano, Sara Gallegos Neves , Mateus Tomaz Dias, Manoela Maciel dos Santos Carvalho, Fernanda Raquel |
dc.subject.por.fl_str_mv |
Separation Multicomponent Fenske-Underwood method Gilliland method Excel Separação Multicomponente Método de Fenske-Underwood Método de Gilliland Excel |
topic |
Separation Multicomponent Fenske-Underwood method Gilliland method Excel Separação Multicomponente Método de Fenske-Underwood Método de Gilliland Excel |
description |
The unit operation of distillation is a method of significant importance for industrial separation processes, as it enables the fractionation of a mixture based on the differences in volatility among its components. Considering that a typical initial mixture generally contains three or more products of interest, studies aimed at optimizing multicomponent distillation, although scarce in the literature, are increasingly imperative to ensure efficiency and reduce operational and energy costs associated with the process. Since sizing multicomponent distillation columns using the Fenske-Underwood and Gilliland (FUG) and Kirkbride methods involves extensive and complex calculations to obtain operational parameters, the objective of this study was to develop a computational method using Microsoft Excel® software to make them more practical and enhance the accuracy of the results obtained. The functionality of the developed spreadsheet was verified through the resolution of an example of application, both manually and electronically. In both cases, the results obtained were identical, but with significantly lower time consumption and probability of error by the electronic method, demonstrating its potential for use in academic and industrial settings. |
publishDate |
2024 |
dc.date.none.fl_str_mv |
2024-05-10 |
dc.type.driver.fl_str_mv |
info:eu-repo/semantics/article info:eu-repo/semantics/publishedVersion |
format |
article |
status_str |
publishedVersion |
dc.identifier.uri.fl_str_mv |
https://periodicos.ufv.br/jcec/article/view/18680 10.18540/jcecvl10iss3pp18680 |
url |
https://periodicos.ufv.br/jcec/article/view/18680 |
identifier_str_mv |
10.18540/jcecvl10iss3pp18680 |
dc.language.iso.fl_str_mv |
eng |
language |
eng |
dc.relation.none.fl_str_mv |
https://periodicos.ufv.br/jcec/article/view/18680/9674 https://periodicos.ufv.br/jcec/article/view/18680/9605 |
dc.rights.driver.fl_str_mv |
Copyright (c) 2024 The Journal of Engineering and Exact Sciences https://creativecommons.org/licenses/by/4.0 info:eu-repo/semantics/openAccess |
rights_invalid_str_mv |
Copyright (c) 2024 The Journal of Engineering and Exact Sciences https://creativecommons.org/licenses/by/4.0 |
eu_rights_str_mv |
openAccess |
dc.format.none.fl_str_mv |
application/pdf application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
dc.publisher.none.fl_str_mv |
Universidade Federal de Viçosa - UFV |
publisher.none.fl_str_mv |
Universidade Federal de Viçosa - UFV |
dc.source.none.fl_str_mv |
The Journal of Engineering and Exact Sciences; Vol. 10 No. 3 (2024); 18680 The Journal of Engineering and Exact Sciences; Vol. 10 Núm. 3 (2024); 18680 The Journal of Engineering and Exact Sciences; v. 10 n. 3 (2024); 18680 2527-1075 reponame:Revista de Engenharia Química e Química instname:Universidade Federal de Viçosa (UFV) instacron:UFV |
instname_str |
Universidade Federal de Viçosa (UFV) |
instacron_str |
UFV |
institution |
UFV |
reponame_str |
Revista de Engenharia Química e Química |
collection |
Revista de Engenharia Química e Química |
repository.name.fl_str_mv |
Revista de Engenharia Química e Química - Universidade Federal de Viçosa (UFV) |
repository.mail.fl_str_mv |
jcec.journal@ufv.br||req2@ufv.br |
_version_ |
1800211186186190848 |