Spreadsheet Add-in for Heat Exchanger Logarithmic Mean Temperature Difference Correction Factors

C. O.C.Oko, E.O. Diemuodeke, M. B. Katsina
2012 International Journal of Computer Applications  
This paper presents an MS Excel spreadsheet add-in for heat exchanger logarithmic mean temperature difference (LMTD) correction factors for ten heat exchanger configurations. It is a computer tool for determining the LMTD correction factors for complex heat exchanger flow arrangements. The charted correction factors for various flow arrangements were curvefitted using the MS Excel Solver tool. Lagrange interpolation scheme was used to formulate the relevant interpolation formulas for the
more » ... flow arrangements considered. The interpolation scheme was programmed in MS Excel Visual Basic for Application as an add-in. Results obtained agree with the values from the correction-factor charts presented in the literature. The add-in is a veritable tool for spreadsheet heat exchanger design and performance analysis for design engineers as well as for educational purposes. General Terms Spreadsheet add-in
doi:10.5120/6260-8406 fatcat:w3z7xvgxrfgc3oi6v7dm4xzrge