This paper deals with the use of Microsoft Excel as an educational tool for conducting basic engineering analyses related to thermal-fluid systems. The paper focuses on using Excel and its Goal-Seek command for solving thermal-fluid problems that require iterative solutions by presenting three related examples from the subjects of heat-transfer, fluid dynamics, and thermodynamics. The first example shows how Excel and Goal Seek can be used to solve heat-exchanger problems with unknown fluids exit temperatures with the log-mean temperature difference (LMTD) method. The second example deals with solving type-2 and type-3 flow problems, while the third example demonstrates the use of property add-ins for determining the adiabatic flame temperature with Excel and Goal-Seek.
El-Awad, Mohamed Musaddag Dr
Use of Excel's 'Goal Seek' feature for Thermal-Fluid Calculations,
Spreadsheets in Education (eJSiE):
1, Article 3.
Available at: http://epublications.bond.edu.au/ejsie/vol9/iss1/3