Abstract
ABSTRACT 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. General Terms Spreadsheet add-in Keywords heat exchangers, LMTD correction factors, curve fitting, spreadsheet add-in
Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
