Excel as an optimization tool applied to multicomponent distillation column sizing

Detalhes bibliográficos
Autor(a) principal: Ribeiro, Luan Jonas de Souza
Data de Publicação: 2024
Outros Autores: Carneiro, Camila Rodrigues, Bosmediano, Sara Gallegos, Neves , Mateus Tomaz, Dias, Manoela Maciel dos Santos, Carvalho, Fernanda Raquel
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