A User-Friendly Dynamic Reactor Simulator Built in Microsoft Excel


  • M. L. Chew Hernandez Industrial Engineering Department, Technological Institute of Superior Studies of Coacalco, Mexico https://orcid.org/0000-0001-5240-147X
  • L. Viveros Rosas Industrial Engineering Department, Technological Institute of Superior Studies of Coacalco, Mexico
  • I. Hernandez-Arrieta Industrial Engineering Department, Technological Institute of Superior Studies of Coacalco, Mexico
Volume: 12 | Issue: 6 | Pages: 9414-9419 | December 2022 | https://doi.org/10.48084/etasr.5152


Computer plant simulation is being used in all aspects of engineering, through many simulation software packages. However, almost all of them require licenses that must be purchased by engineering colleges intending to use simulation in their teaching. As public educational institutions everywhere are facing a scarcity of economic resources, they can resort to a freeware steady-state plant simulator, however, there is no availability of reliable, free dynamic plant simulators. In addition, published experiences on developing dynamic simulators use programming languages requiring paid licenses (e.g. Matlab) and thus have limited relevancy to schools struggling to cut expenses. This article first uses a set of typical college objectives to discuss the advantages of building their own dynamic simulators, and then shows the development of a user-friendly dynamic simulator of a batch reactor constructed entirely within Microsoft Excel, which, in contrast to the programming languages used in related reports, is already widely used by universities around the world.


batch reactor, dynamic simulation, visual basic


Download data is not yet available.


"Licenciaturas," Tecnológico Nacional de México. https://www.tecnm.mx/?vista=Licenciaturas.

"COCO - the CAPE-OPEN to CAPE-OPEN simulator." https://www.cocosimulator.org/.

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. DOI: https://doi.org/10.48084/etasr.2106

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. DOI: https://doi.org/10.48084/etasr.1039

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. DOI: https://doi.org/10.48084/etasr.139

C. Renotte, A. Vande Wouwer, Ph. Bogaerts, and M. Remy, "Neural Network Applications in Non-Linear Modelling of (Bio)Chemical Processes," Measurement and Control, vol. 34, no. 7, pp. 197–201, Sep. 2001. DOI: https://doi.org/10.1177/002029400103400702

Adams II T. A., Ed., Modeling and Simulation of Energy Systems - Processes, Special Issue. MDPI, Basel, 2019. DOI: https://doi.org/10.3390/pr7080523

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. DOI: https://doi.org/10.1590/S0104-66322004000300005

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. DOI: https://doi.org/10.3390/app6100292

I. M Ariff and M. Bakir, "Dynamic Simulation of Petrochemical Wastewater Treatment Using Wastewater Plant Simulation Software," MATEC Web of Conferences, vol. 203, no. 1, Jan. 2018, Art. no. 03005. DOI: https://doi.org/10.1051/matecconf/201820303005

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. DOI: https://doi.org/10.3390/jmse6040132

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. DOI: https://doi.org/10.3390/en12173376

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. DOI: https://doi.org/10.1051/e3sconf/202020210003

A. Lemita, S. Boulahbel, and S. Kahla, "Gradient Descent Optimization Control of an Activated Sludge Process based on Radial Basis Function Neural Network," Engineering, Technology & Applied Science Research, vol. 10, no. 4, pp. 6080–6086, Aug. 2020. DOI: https://doi.org/10.48084/etasr.3714

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, Dec. 2011.

I. Šoljić Jerbić, S. Kuzmić, and A. Jukić, "Dynamic Simulation of Batch Polymerization Reactor and Sensitivity Analysis of Styrene Homopolymerization," Kemija u industriji : Časopis kemičara i kemijskih inženjera Hrvatske, vol. 64, no. 3–4, pp. 151–167, Mar. 2015. DOI: https://doi.org/10.15255/KUI.2013.039

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. DOI: https://doi.org/10.1051/matecconf/201815603003

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, Dec. 2018. DOI: https://doi.org/10.9767/bcrec.13.3.2098.420-428

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. DOI: https://doi.org/10.1016/j.egyr.2019.11.038

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. DOI: https://doi.org/10.3390/en13153925

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. DOI: https://doi.org/10.3390/pr9010183

I. M. Joao and J. M. 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 (iJEP), vol. 7, no. 3, pp. 4–18, Sep. 2017. DOI: https://doi.org/10.3991/ijep.v7i3.6795

J. Puskás, A. Egedy, and S. Németh, "Development of operator training simulator for isopropyl alcohol producing plant," Education for Chemical Engineers, vol. 22, pp. 35–43, Jan. 2018. DOI: https://doi.org/10.1016/j.ece.2017.11.003

S. M. Riachi, M. Duarte, and J. A. Scortechini, "Diseño De Un Simulador De Procesos Químicos Para Uso Colaborativo Y Didáctico," REFCalE: Revista Electrónica Formación 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. DOI: https://doi.org/10.1016/S0098-1354(00)00324-0

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. DOI: https://doi.org/10.1016/j.ece.2014.05.001

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. DOI: https://doi.org/10.1007/s12182-017-0170-5

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. DOI: https://doi.org/10.1016/j.ece.2020.03.002

R. Molina, G. Orcajo, Y. Segura, J. Moreno, and F. Martínez, "KMS platform: A complete tool for modeling chemical and biochemical reactors," Education for Chemical Engineers, vol. 34, pp. 127–137, Jan. 2021. DOI: https://doi.org/10.1016/j.ece.2020.09.003

M. L. C. Hernández, T. R. G. Gómez, G. B. Brugada, and D. E. R. Vargas, "Desarrollo Del Simulador Dinámico De Un Reactor Batch Con Fines Didácticos (building a Dynamic Simulator of a Batch Reactor for Educational Purposes)," Pistas Educativas, vol. 43, no. 139, pp. 34–49, Dec. 2021.

R. L. Keeney, Value-Focused Thinking: A Path to Creative Decisionmaking. Cambridge, MA, USA: Harvard University Press, 1996. DOI: https://doi.org/10.2307/j.ctv322v4g7

A. K. Jana, Chemical Process Modelling and Computer Simulation, 2nd ed. New Delhi, India: Phi Learning pvt Ltd., 2011.


How to Cite

M. L. Chew Hernandez, L. Viveros Rosas, and I. Hernandez-Arrieta, “A User-Friendly Dynamic Reactor Simulator Built in Microsoft Excel”, Eng. Technol. Appl. Sci. Res., vol. 12, no. 6, pp. 9414–9419, Dec. 2022.


Abstract Views: 697
PDF Downloads: 624

Metrics Information

Most read articles by the same author(s)