Excel as an optimization tool applied to multicomponent distillation column sizing

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 product...

Full description

Saved in:
Bibliographic Details
Main Authors: Luan Jonas de Souza Ribeiro, Camila Rodrigues Carneiro, Sara Gallegos Bosmediano, Mateus Tomaz Neves, Manoela Maciel dos Santos Dias, Fernanda Raquel Carvalho
Format: Article
Language:English
Published: Universidade Federal de Viçosa (UFV) 2024-05-01
Series:The Journal of Engineering and Exact Sciences
Subjects:
Online Access:https://periodicos.ufv.br/jcec/article/view/18680
Tags: Add Tag
No Tags, Be the first to tag this record!
_version_ 1832569826937143296
author Luan Jonas de Souza Ribeiro
Camila Rodrigues Carneiro
Sara Gallegos Bosmediano
Mateus Tomaz Neves
Manoela Maciel dos Santos Dias
Fernanda Raquel Carvalho
author_facet Luan Jonas de Souza Ribeiro
Camila Rodrigues Carneiro
Sara Gallegos Bosmediano
Mateus Tomaz Neves
Manoela Maciel dos Santos Dias
Fernanda Raquel Carvalho
author_sort Luan Jonas de Souza Ribeiro
collection DOAJ
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.
format Article
id doaj-art-c001c2406c274e96a4585a087815b266
institution Kabale University
issn 2527-1075
language English
publishDate 2024-05-01
publisher Universidade Federal de Viçosa (UFV)
record_format Article
series The Journal of Engineering and Exact Sciences
spelling doaj-art-c001c2406c274e96a4585a087815b2662025-02-02T19:53:46ZengUniversidade Federal de Viçosa (UFV)The Journal of Engineering and Exact Sciences2527-10752024-05-0110310.18540/jcecvl10iss3pp18680Excel as an optimization tool applied to multicomponent distillation column sizingLuan Jonas de Souza Ribeiro0Camila Rodrigues Carneiro1Sara Gallegos Bosmediano2Mateus Tomaz Neves 3Manoela Maciel dos Santos Dias4Fernanda Raquel Carvalho5Viçosa University Center - UNIVIÇOSA, Brazil Federal University of Viçosa, BrazilFederal University of Viçosa, BrazilViçosa University Center - UNIVIÇOSA, Brazil Federal University of Viçosa, BrazilViçosa University Center - UNIVIÇOSA, Brazil 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. https://periodicos.ufv.br/jcec/article/view/18680SeparationMulticomponentFenske-Underwood methodGilliland methodExcel
spellingShingle Luan Jonas de Souza Ribeiro
Camila Rodrigues Carneiro
Sara Gallegos Bosmediano
Mateus Tomaz Neves
Manoela Maciel dos Santos Dias
Fernanda Raquel Carvalho
Excel as an optimization tool applied to multicomponent distillation column sizing
The Journal of Engineering and Exact Sciences
Separation
Multicomponent
Fenske-Underwood method
Gilliland method
Excel
title 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_short Excel as an optimization tool applied to multicomponent distillation column sizing
title_sort excel as an optimization tool applied to multicomponent distillation column sizing
topic Separation
Multicomponent
Fenske-Underwood method
Gilliland method
Excel
url https://periodicos.ufv.br/jcec/article/view/18680
work_keys_str_mv AT luanjonasdesouzaribeiro excelasanoptimizationtoolappliedtomulticomponentdistillationcolumnsizing
AT camilarodriguescarneiro excelasanoptimizationtoolappliedtomulticomponentdistillationcolumnsizing
AT saragallegosbosmediano excelasanoptimizationtoolappliedtomulticomponentdistillationcolumnsizing
AT mateustomazneves excelasanoptimizationtoolappliedtomulticomponentdistillationcolumnsizing
AT manoelamacieldossantosdias excelasanoptimizationtoolappliedtomulticomponentdistillationcolumnsizing
AT fernandaraquelcarvalho excelasanoptimizationtoolappliedtomulticomponentdistillationcolumnsizing