SavedAdd your journal

Journals / Black Sea Journal of Engineering and Science / 2026 / Cilt: 7 Sayı: 2

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

Muhammed Bora Akın(ÇANKIRI KARATEKİN ÜNİVERSİTESİ)0000-0003-3841-1633
Pages
261–270
Publication Date
2024-03-15
🏛️Bibliographic metadata and full text access for this article are provided via DergiPark.
DergiPark Record ↗
✨

AI Summary & Key Takeaways

AI Insight
⚡ TL;DR(Too Long; Didn't Read)

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.

📌 3 Key Takeaways

🎯
Objective & Hypothesis:Solutions for an evaporator system involve equations that incorporate both mass and energy balances.
📊
Key Findings & Data:Moreover, databases for saturated water and superheated steam data were developed within the MS Excel environment to facilitate the program.
💡
Conclusion & Impact: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.
🔬Design:Araştırma Makalesi
📍Scope:Comprehensive Sample
⚙️Variables:Separation · Evaporation · Single-effect evaporator

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.

Özet

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.

🔖

Cite This Article

Akın, M. B. (2024). Utilizing VBA in MS Excel for Simplified Solutions in Chemical Engineering: Single-Effect Evaporator Study. Black Sea Journal of Engineering and Science, Cilt: 7 Sayı: 2, 261–270. https://doi.org/10.34248/bsengineering.1402065

📄 Full Text PDF Viewer

📄

PDF görüntüleyici hazırlanıyor...

References (15)

  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.