International Journal of Computer Applications |
Foundation of Computer Science (FCS), NY, USA |
Volume 44 - Number 5 |
Year of Publication: 2012 |
Authors: C.o.c. Oko, E.o. Diemuodeke, M. B. Katsina |
10.5120/6260-8406 |
C.o.c. Oko, E.o. Diemuodeke, M. B. Katsina . Spreadsheet Add-in for Heat Exchanger Logarithmic Mean Temperature Difference Correction Factors. International Journal of Computer Applications. 44, 5 ( April 2012), 24-30. DOI=10.5120/6260-8406
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 curve-fitted using the MS Excel Solver tool. Lagrange interpolation scheme was used to formulate the relevant interpolation formulas for the various 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.