An Excel VBA-based educational module for simulation and energy optimization of spray drying process

Boris Golman, Assiya Yermukhambetova

Research output: Contribution to journalArticle

Abstract

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.

Original languageEnglish
JournalComputer Applications in Engineering Education
DOIs
Publication statusAccepted/In press - Jan 1 2019

Fingerprint

Spray drying
energy
simulation
Students
air
Air
Drying
heat
Driers (materials)
ceramics industry
student
Drug products
Curricula
Heat exchangers
chemical industry
Macros
food and luxury products industry
pharmaceutical industry
Teaching
teaching materials

Keywords

  • energy recovery
  • Excel VBA simulator
  • mass and energy balances
  • modeling
  • spray drying

ASJC Scopus subject areas

  • Computer Science(all)
  • Education
  • Engineering(all)

Cite this

@article{c7a80d60eda94c0ca283f290fdc9b17c,
title = "An Excel VBA-based educational module for simulation and energy optimization of spray drying process",
abstract = "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.",
keywords = "energy recovery, Excel VBA simulator, mass and energy balances, modeling, spray drying",
author = "Boris Golman and Assiya Yermukhambetova",
year = "2019",
month = "1",
day = "1",
doi = "10.1002/cae.22139",
language = "English",
journal = "Computer Applications in Engineering Education",
issn = "1061-3773",
publisher = "John Wiley and Sons Inc.",

}

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

JO - Computer Applications in Engineering Education

JF - Computer Applications in Engineering Education

SN - 1061-3773

ER -