We apologize for a recent technical issue with our email system, which temporarily affected account activations. Accounts have now been activated. Authors may proceed with paper submissions. PhDFocusTM
CFP last date
20 November 2024
Reseach Article

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

by C.o.c. Oko, E.o. Diemuodeke, M. B. Katsina
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

@article{ 10.5120/6260-8406,
author = { C.o.c. Oko, E.o. Diemuodeke, M. B. Katsina },
title = { Spreadsheet Add-in for Heat Exchanger Logarithmic Mean Temperature Difference Correction Factors },
journal = { International Journal of Computer Applications },
issue_date = { April 2012 },
volume = { 44 },
number = { 5 },
month = { April },
year = { 2012 },
issn = { 0975-8887 },
pages = { 24-30 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume44/number5/6260-8406/ },
doi = { 10.5120/6260-8406 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T20:35:24.643394+05:30
%A C.o.c. Oko
%A E.o. Diemuodeke
%A M. B. Katsina
%T Spreadsheet Add-in for Heat Exchanger Logarithmic Mean Temperature Difference Correction Factors
%J International Journal of Computer Applications
%@ 0975-8887
%V 44
%N 5
%P 24-30
%D 2012
%I Foundation of Computer Science (FCS), NY, USA
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.

References
  1. Oko, C. O. C. 2005. Introductory Heat Transfer: An algorithmic approach, 2nd Edition, Pam Unique publishing company limited, Port Harcourt.
  2. Bell, J. K. and Mueller, C. A. 2001. Wolverine engineering data Book II, Wolverine tube Inc. , www. wlv. com/products/databook/ch2_2. pdf, Retrieved: 28/03/10.
  3. Liengme, B. V. (2000) A Guide to Microsoft Excel for scientist and engineers, Butterworth-Heinemann, London.
  4. Oko, C. O. C. , Diemuodeke, E. O. and Akinlade, I. S. 2010. Design of hoppers using spreadsheet, Journal of Research in Agricultural Engineering, Vol. 56(2), pp. 53-58.
  5. Lona, L. M. F. , Fernandes, F. A. N. , Roque, M. C. and Rodrigues, L. 2000. Developing an educational software for heat exchangers and heat exchanger networks projects, Journal of Computer and Chemical Engineering, Vol. 24(2-7), 1247-1251.
  6. Tan, F. L. and Fok, S. C. 2006. An educational computer-aided tool for heat exchanger design, Journal of Computer Application in Engineering education, Vol. 14(2), 77-89.
  7. Chapra S. C. , Canale R. P. (2002) Numerical methods for engineers, 4th Ed. , Tata McGraw-Hill, New Delhi,
  8. Oko, C. O. C. (2008) Engineering computational method: An algorithmic approach, 1st Edition, University of Port Harcourt Press, Port Harcourt.
  9. Mustafa, G. 2000. Correlations for some Thermophysical Properties of Air, International Drying Symposium, NL, Wageningen.
  10. Cengel, Y. A. (2007), Heat and mass transfer, 3rd Ed. , Tata McGram-Hill, New Delhi.
  11. Ebieto, C. E (2010) Finite element analysis of shell and tube heat exchangers, M. Eng Thesis, Department of Mechanical Engineering, University of Port Harcourt, Port Harcourt.
  12. Fakheri, A. (2003) Alternative approach for determining log mean temperature difference correction factor and number of shells of shell and tube heat exchangers, Journal of Enhanced Heat Transfer, Vol. 10(4), pp. 407-420.
  13. Leong, K. C. , Toh, K. C. and Leong, Y. C. 1998. Shell and tube heat exchanger design software for education application, Int. Journal of Engineering Education, Vol. 4(3), 217-224.
Index Terms

Computer Science
Information Sciences

Keywords

Heat Exchangers Lmtd Correction Factors Curve Fitting Spreadsheet Add-in