TY - JOUR
T1 - An Excel VBA-based educational module for simulation and energy optimization of spray drying process
AU - Golman, Boris
AU - Yermukhambetova, Assiya
PY - 2019/1/1
Y1 - 2019/1/1
N2 - The spray drying processes are widely used in chemical, ceramic, food, and pharmaceutical industries to produce both high-volume and high-value particulate products. Therefore, it is important to include a topic covering the spray drying process in the undergraduate curriculum of chemical and materials engineering students. In this article, we describe an Excel Visual Basic for Applications (VBA)-based educational module developed to assist students in learning the spray drying process. The module consists of two Excel files with VBA macro programs and teaching materials. The module focuses on the design of spray drying process conditions to produce the particulate product with desired moisture content at required production rate while satisfying the process restrictions on the inlet slurry concentration and the exhaust air temperature. Students are also asked to carry out the energy performance analysis of spray dryer equipped with an air-to-air heat exchanger that recovers the exhaust air heat to preheat the drying air. Using this module, students will enhance their theoretical and practical knowledge in drying processes, and gain analytical skills in drying process energy optimization.
AB - The spray drying processes are widely used in chemical, ceramic, food, and pharmaceutical industries to produce both high-volume and high-value particulate products. Therefore, it is important to include a topic covering the spray drying process in the undergraduate curriculum of chemical and materials engineering students. In this article, we describe an Excel Visual Basic for Applications (VBA)-based educational module developed to assist students in learning the spray drying process. The module consists of two Excel files with VBA macro programs and teaching materials. The module focuses on the design of spray drying process conditions to produce the particulate product with desired moisture content at required production rate while satisfying the process restrictions on the inlet slurry concentration and the exhaust air temperature. Students are also asked to carry out the energy performance analysis of spray dryer equipped with an air-to-air heat exchanger that recovers the exhaust air heat to preheat the drying air. Using this module, students will enhance their theoretical and practical knowledge in drying processes, and gain analytical skills in drying process energy optimization.
KW - energy recovery
KW - Excel VBA simulator
KW - mass and energy balances
KW - modeling
KW - spray drying
UR - http://www.scopus.com/inward/record.url?scp=85070666047&partnerID=8YFLogxK
UR - http://www.scopus.com/inward/citedby.url?scp=85070666047&partnerID=8YFLogxK
U2 - 10.1002/cae.22139
DO - 10.1002/cae.22139
M3 - Article
AN - SCOPUS:85070666047
SN - 1061-3773
JO - Computer Applications in Engineering Education
JF - Computer Applications in Engineering Education
ER -