A Stochastic Simulator of a Multi-Component Distillation Tower Built as an Excel Macro
Received: 15 December 2022 | Revised: 30 December 2022 | Accepted: 5 January 2023 | Online: 2 April 2023
Corresponding author: Mario Luis Chew Hernandez
Abstract
Dynamic process simulation is widely used in teaching controller design, as it allows foreseeing the performance of different control configurations and controller tunings. Currently, most college-level controller design exercises that are based on simulation consider deterministic perturbations (i.e. steps or ramps). In real life however, processes are more likely to face fluctuating, random disturbances, so the use of stochastic simulation in controller tuning exercises would provide students with an experience closer to their future professional practice than that provided by deterministic simulation. However, public institutions attempting to use dynamic, stochastic simulators in teaching, are hindered by the need of buying licenses of simulation packages or specialized programming languages (such as Matlab), as there aren´t any dynamic, stochastic simulators available as downloadable freeware. This paper shows a dynamic, stochastic simulator with a friendly interface of a distillation tower, developed as an Excel macro. This simulator has the advantage that it can be used at no cost to educational institutions since Excel is almost universally known and used by college faculties.
Keywords:
simulation, stochastic, distillationDownloads
References
M. L. Luyben and W. L. Luyben, Essentials of Process Control. New York, NY, USA: McGraw-Hill College, 1996.
"COCO - the CAPE-OPEN to CAPE-OPEN simulator." https://www.cocosimulator.org.
T. A. Adams, "Special Issue: Modeling and Simulation of Energy Systems," Processes, vol. 7, no. 8, Aug. 2019, Art. no. 523.
B. O. Odedairo and N. Nwabuokei, "Framework for Operational Performance Measurements in Small and Medium Scale Industries Using Discrete Event Simulation Approach," Engineering, Technology & Applied Science Research, vol. 8, no. 4, pp. 3103–3107, Aug. 2018.
M. L. C. Hernandez, L. V. Rosas, R. F. R. Mantilla, G. J. E. Martínez, and V. V. Romero, "Supply Chain Cooperation by Agreed Reduction of Behavior Variability: A Simulation-based Study," Engineering, Technology & Applied Science Research, vol. 7, no. 2, pp. 1546–1551, Apr. 2017.
M. L. C. Hernandez, E. K. V. Hernandez, and S. L. Dominguez, "A Decision-Analytic Feasibility Study of Upgrading Machinery at a Tools Workshop," Engineering, Technology & Applied Science Research, vol. 2, no. 2, pp. 182–189, Apr. 2012.
P. E. Bauer and R. Maciel Filho, "Incorporation of environmental impact criteria in the design and operation of chemical processes," Brazilian Journal of Chemical Engineering, vol. 21, pp. 405–414, Sep. 2004.
D. Huang, H. Zhang, S. Weng, and M. Su, "Modeling and Simulation of IGCC Considering Pressure and Flow Distribution of Gasifier," Applied Sciences, vol. 6, no. 10, Oct. 2016, Art. no. 292.
I. F. M. Ariff and M. Bakir, "Dynamic Simulation of Petrochemical Wastewater Treatment Using Wastewater Plant Simulation Software," MATEC Web of Conferences, vol. 203, 2018, Art. no. 03005.
Y.-H. Yu and D. Jenne, "Numerical Modeling and Dynamic Analysis of a Wave-Powered Reverse-Osmosis System," Journal of Marine Science and Engineering, vol. 6, no. 4, Dec. 2018, Art. no. 132.
V. Meshalkin, V. Bobkov, M. Dli, and V. Dovì, "Optimization of Energy and Resource Efficiency in a Multistage Drying Process of Phosphate Pellets," Energies, vol. 12, no. 17, Jan. 2019, Art. no. 3376.
S. Silviana, F. Dalanta, D. Q. A’yuni, L. Khoiriyah, P. R. Nabila, and M. F. Alfaris, "Design simulation and economic optimization of a benzene-toluene-xylene system distillation process upon the energy cost," E3S Web of Conferences, vol. 202, 2020, Art. no. 10003.
M. Khodadoost and J. Sadeghi, "Dynamic Simulation of Distillation Sequences in Dew Pointing Unit of South Pars Gas Refinery," Journal of Chemical and Petroleum Engineering, vol. 45, no. 2, pp. 109–116, 2011.
I. Soljic Jerbic, S. Kuzmic, and A. Jukic, "Dynamic Simulation of Batch Polymerization Reactor and Sensitivity Analysis of Styrene Homopolymerization," Kemija u industriji : Casopis kemicara i kemijskih inzenjera Hrvatske, vol. 64, no. 3–4, pp. 151–167, Mar. 2015.
T. P. Adhi and M. I. Prasetyo, "Process Stability Identification Through Dynamic Study of Single-bed Ammonia Reactor with Feed-Effluent Heat Exchanger (FEHE)," MATEC Web of Conferences, vol. 156, 2018, Art. no. 03003.
A. K. Patan, M. Mekala, and S. K. Thamida, "Dynamic Simulation of Heterogeneous Catalysis at Particle Scale to Estimate the Kinetic Parameters for the Pore Diffusion Model," Bulletin of Chemical Reaction Engineering & Catalysis, vol. 13, no. 3, pp. 420–428, 2018.
T. Wanotayaroj, B. Chalermsinsuwan, and P. Piumsomboon, "Dynamic simulation and control system for chemical looping combustion," Energy Reports, vol. 6, pp. 32–39, Feb. 2020.
F. Calise, U. Eicker, J. Schumacher, and M. Vicidomini, "Wastewater Treatment Plant: Modelling and Validation of an Activated Sludge Process," Energies, vol. 13, no. 15, Jan. 2020, Art. no. 3925.
Q. Li, W. Zhang, Y. Qin, and A. An, "Model Predictive Control for the Process of MEA Absorption of CO2 Based on the Data Identification Model," Processes, vol. 9, no. 1, Jan. 2021, Art. no. 183.
I. Joao and J. Silva, "Designing Solutions by a Student Centred Approach: Integration of Chemical Process Simulation with Statistical Tools to Improve Distillation Systems," International Journal of Engineering Pedagogy, vol. 7, no. 3, pp. 4–18, 2017.
J. Puskas, A. Egedy, and S. Nemeth, "Development of operator training simulator for isopropyl alcohol producing plant," Education for Chemical Engineers, vol. 22, pp. 35–43, Jan. 2018.
S. M. Riachi, M. Duarte, and J. A. Scortechini, "Diseno de un simulador de procesos quimicos para uso colaborativo y didactico," Revista Electronica Formacion y Calidad Educativa, vol. 2, no. 1, pp. 71–82, Apr. 2014.
L. M. F. Lona, F. A. N. Fernandes, M. C. Roque, and S. Rodrigues, "Developing an educational software for heat exchangers and heat exchanger networks projects," Computers & Chemical Engineering, vol. 24, no. 2, pp. 1247–1251, Jul. 2000.
S. J. M. Cartaxo, P. F. G. Silvino, and F. A. N. Fernandes, "Transient analysis of shell-and-tube heat exchangers using an educational software," Education for Chemical Engineers, vol. 9, no. 3, pp. e77–e84, Jul. 2014.
Y. Lee, C. Ko, H. Lee, K. Jeon, S. Shin, and C. Han, "Interactive plant simulation modeling for developing an operator training system in a natural gas pressure-regulating station," Petroleum Science, vol. 14, no. 3, pp. 529–538, Aug. 2017.
J. F. O. Granjo and M. G. Rasteiro, "Enhancing the autonomy of students in chemical engineering education with LABVIRTUAL platform," Education for Chemical Engineers, vol. 31, pp. 21–28, Apr. 2020.
R. Molina, G. Orcajo, Y. Segura, J. Moreno, and F. Martinez, "KMS platform: A complete tool for modeling chemical and biochemical reactors," Education for Chemical Engineers, vol. 34, pp. 127–137, Jan. 2021.
S. Ross, Simulation, 5th Edition. Cambridge, MA, United States: Academic Press, 2012.
M. L. C. Hernandez, L. V. Rosas, and J. R. P. Torres, "Three component tower simulator.xlsm," Google Docs. https://drive.google.com/file/d/1ZeTAwIlV83LMynr2D5QzRSB2jHzvaYjX/view?usp=sharing.
Downloads
How to Cite
License
Copyright (c) 2023 Mario Luis Chew Hernandez, Leopoldo Viveros Rosas, Jose Roberto Perez Torres
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain the copyright and grant the journal the right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) after its publication in ETASR with an acknowledgement of its initial publication in this journal.
