Inexpensive Numerical Method for Heat Transfer Computations Using Excel

Author(s):  
Amanie N. Abdelmessih

Most thermal engineers will model and analyze thermal engineering cases, using any of the numerous thermal analysis software, available in the market. These commercial software need years of continuous use to be fully mastered. Large companies can afford to acquire expensive software available in the market and train their engineers; but small companies do not have the financial means to acquire such expensive software. Thus for modeling and analysis, small companies or private practice need a different alternative. Excel is one of the programs that come with Microsoft Office suite of software, which is installed on any purchased computer. Most users of Microsoft office are proficient in using Word, and can use Excel as a spread sheet to speed up calculations. Technical personnel can easily use the charting capability of Excel, but very few engineers can use Excel for intensive Numerical Analysis. Engineers should be able to use the available inexpensive Excel software to perform numerical analysis at their work place. In this article three Heat Transfer Numerical cases using Microsoft Excel are discussed in detail. the first case is two dimensional steady state heat transfer with different isothermal boundary conditions. The second shows other boundary conditions: uniform heat flux, adiabatic, and convection. The third case is transient conditions. The results from the three cases are compared with results from Patran Thermal software.

1997 ◽  
Vol 119 (1) ◽  
pp. 58-63 ◽  
Author(s):  
S. Sathe ◽  
K. M. Kelkar ◽  
K. C. Karki ◽  
C. Tai ◽  
C. Lamb ◽  
...  

Forced flow of air over extended surfaces offers a simple, reliable, and effective heat removal mechanism and is often employed in electronic equipment. The IBM 4381 heat sink, used in production IBM computers, utilizes this cooling technique. This heat sink consists of a ceramic substrate on which fins made of an aluminum-copper alloy are arranged in a regular array. Cooling air enters the fin array from a nozzle. Extensive experiments have been carried out to characterize the performance of this heat sink at the Advanced Thermal Engineering Laboratory at IBM Endicott. This paper presents computational analysis of the three-dimensional flow and heat transfer in this device for two different air flow rates through the nozzle. The heat dissipated by the electronic components is conducted into the fins through the ceramic base. In the present study the ceramic base is assumed to be subjected to a uniform heat flux at the bottom. The computational method incorporates a special block-correction procedure to enable iterative solution of conjugate heat transfer in the presence of large differences in thermal conductivities of the air and the fin material. The results of computations reproduce the flow pattern in the fin array that is observed experimentally. The part of the ceramic base directly below the nozzle is well cooled with the temperatures gradually increasing from the center towards the corner. The predicted pressure drop and most of the local temperatures at the base and the tip of the fins agree well with the experimental observations. This study illustrates the utility of computational flow analysis in the analysis and design of electronic cooling techniques.


Author(s):  
Oguz Kirez ◽  
Almila Yazicioglu ◽  
Sadik Kakac

In this study, a numerical analysis of heat transfer enhancement of Alumina/water nanofluid in a steady-state, single-phase, laminar flow in a circular duct is presented for the case of constant wall heat flux and constant wall temperature boundary conditions. The analysis is performed with a newly suggested model (Corcione) for effective thermal conductivity and viscosity, which show the effects of temperature and nanoparticle diameter. The results for Nusselt number and heat transfer enhancement are presented in graphical and tabular forms, for a given Peclet number, nanoparticle volumetric fraction, and particle diameter in the thermal entrance region. The results are compared with the experimental results available in the literature under the same conditions and a good agreement is found. The two boundary conditions are compared and slightly differing results are discussed. Finally, the effect of the axial conduction and viscous dissipation are investigated. The axial conduction effect is found to be negligible for practical cases while the viscous dissipation effect is found to be significantly important depending on the boundary conditions and the pipe diameter.


Author(s):  
Ruey Hwu ◽  
Weilin Qu

In this study, heat transfer to laminar hydrodynamically fully developed flow in the thermally developing region of rectangular micro-channels is analyzed for four-wall and three-wall circumferentially uniform temperature and axially uniform heat flux (H1) boundary conditions. The temperature and wall heat flux distributions are solved numerically and used to calculate the local average Nusselt number. Based on the numerical results, new correlations capable of predicting heat transfer in the thermally developing region continuously into the fully developed region are developed. The correlations are compared with other correlations and available experimental data, and show good agreement.


Author(s):  
Assunta Andreozzi ◽  
Nicola Bianco ◽  
Vincenzo Naso ◽  
Oronzio Manca

In this study a numerical investigation of mixed convection in air due to the interaction between a buoyancy flow and a moving plate induced flow in a vertical channel is carried out. The moving plate has a constant velocity and moves in the opposite direction with respect to the buoyancy force. The channel principal walls are heated at uniform heat flux. The numerical analysis is obtained by means of the commercial code Fluent. The effects of the channel spacing, heat transfer and moving plate velocity are investigated and results in terms of the channel wall and moving plate temperatures and Nusselt numbers are given. The wall temperature profiles allow to observe different behaviors of the flow motion inside the channel, a buoyancy flow, a forced flow and a transition flow related to the velocity of moving plate. The transition velocity increases as the heat flux and the channel gap increase. Dimensionless heat transfer results, Nu/Re0.68 as a function of Richardson number, Ri, present a good agreement with two correlations obtained for the buoyancy dominant flow, at Ri > 10, and forced dominant flow, at Ri < 10−3.


Sign in / Sign up

Export Citation Format

Share Document