Utilizing VBA in MS Excel for Simplified Solutions in Chemical Engineering: Single-Effect Evaporator Study

Abstract

Solutions for an evaporator system involve equations that incorporate both mass and energy balances. Solving equations for a single-effect evaporator is simpler compared to those for multi-effect evaporator systems. However, due to the need for extensive analysis of diverse data from various sources, many prefer using simulation programs for convenience. These programs conduct calculations using their own data libraries, which contain thermodynamic and LLE-VLE data. To emulate the functionality of expensive simulation programs, an alternative interface was designed using Visual Basic for Applications (VBA) in MS Excel. In this study, we chose a single-effect evaporator system used for concentrating NaOH solution and solved its equations using a program created in VBA within MS Excel. Moreover, databases for saturated water and superheated steam data were developed within the MS Excel environment to facilitate the program. Ultimately, the program was employed to scrutinize the influence of selected parameters on other parameters, and the results were analyzed. This study serves as an illustration of how VBA in MS Excel can efficiently handle calculations pertaining to chemical engineering processes. By focusing on the single-effect evaporator, this study demonstrates how VBA in Excel can simplify and effectively conduct investigations into chemical engineering process calculations.

Keywords

• Separation
• Evaporation
• Single-effect evaporator
• Excel
• Visual Basic for applications
• VBA

References

1. Argo BD, Angky Putranto W, Lestari A, Ramadhan F, Okatavian R. 2020. Multi effect evaporator design calculation for brown sugar production using computational fluid dynamics. Int J Innov Technol Explor Eng, 9(3S): 87-90. https://doi.org/10.35940/ijitee.C1019.0193S20.
2. Boles MA, Cengel YA. 2014. Thermodynamics: An engineering approach. McGraw-Hill Education, New York, US, pp: 1024.
3. Çataltas I. 1963. Tek tesirli evaporatörlerde kütle ve energi bağıntıları. Kimya Müh Derg, 1(5): 31.
4. dos Santos MT, Vianna AS, Le Roux GAC. 2018. Programming skills in the industry 4.0: Are chemical engineering students able to face new problems? Educ Chem Eng, 22: 69-76. https://doi.org/10.1016/j.ece.2018.01.002.
5. Elmas ET. 2017. Evaporation plant for recycling of caustic soda. Int J Eng Technol, 3(3): 176-185.
6. Fricke A, Schöneberger J. 2015. Industrie 4.0 with MS-Excel? Chem Eng Transact, 43: 1303-1308. https://doi.org/10.3303/CET1543218.
7. Geankoplis CJ. 1978. Transport processes and unit operations. Allyn and Bacon Publishing, New York, USA, pp: 650.
8. Geankoplis CJ. 2003. Transport processes and separation process principles: (Includes Unit Operations). Upper Saddle River, NJ: Prentice Hall Professional Technical Reference, New York, USA, pp: 1026.

9. Kapuno RR. 2008. Programming for chemical engineers using C, C++, and MATLAB? Jones & Bartlett Learning., New York, US,
10. Karic E, Alic R. 2020. Simulation of a single-stage evaporator system integrated with a mechanical vapor compressor for concentrating the electrolytic system KNO3 – H2O. J Eng Proces Manag, 12(2): 50-56. https://doi.org/10.7251/JEPM2002050K.
11. Microsoft Inc. 2021. VBA Programming in Office. Microsoft Inc. URL: https://learn.microsoft.com/en-us/office/vba/api/overview/ (accessed date: August 2, 2022).
12. Said A, Louhi-Kultanen M. 2019. Simulation and empirical studies of solvent evaporation rates in vacuum evaporation crystallization. Chem Eng Technol, 42(7): 1452-1457. https://doi.org/10.1002/ceat.201800708.
13. Simpson R, Almonacid S, López D, Abakarov A. 2008. Optimum design and operating conditions of multiple effect evaporators: tomato paste. J Food Eng, 89(4): 488-497. https://doi.org/10.1016/j.jfoodeng.2008.05.033.
14. Teppaitoon W. 2016. Solving L-L extraction problems with excel spreadsheet. Chem Eng Educ, 50(3): 169-175.
15. Wong KWW, Barford JP. 2010. Teaching Excel VBA as a problem solving tool for chemical engineering core courses. Educ Chem Eng, 5(4): e72-77. https://doi.org/10.1016/j.ece.2010.07.002.