Excel as an Educational Platform for Design Analyses of Fluid-Thermal Systems

摘要

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.