TITLE:
Excel as an Educational Platform for Design Analyses of Fluid-Thermal Systems
AUTHORS:
Mohamed M. El-Awad, Mohammed S. Al-Saidi
KEYWORDS:
Fluid-Thermal Systems, Design Optimisation, Excel, Solver, VBA
JOURNAL NAME:
World Journal of Engineering and Technology,
Vol.10 No.2,
May
31,
2022
ABSTRACT: Equipped with its Solver and-in and VBA, Microsoft Excel makes an ideal educational platform for design analyses of fluid-thermal systems. This paper illustrates this capability by considering a common type of these systems; which is the double-pipe heat exchanger. While Solver is used for the optimisation analysis, VBA is used for the development of a user-defined function (UDF) that determines the optimum standard-pipe size for the system.