Full Content is available to subscribers

Subscribe/Learn More  >

Inexpensive Numerical Method for Heat Transfer Computations Using Excel

[+] Author Affiliations
Amanie N. Abdelmessih

California Baptist University, Riverside, CA

Paper No. HT2017-4938, pp. V001T02A006; 12 pages
  • ASME 2017 Heat Transfer Summer Conference
  • Volume 1: Aerospace Heat Transfer; Computational Heat Transfer; Education; Environmental Heat Transfer; Fire and Combustion Systems; Gas Turbine Heat Transfer; Heat Transfer in Electronic Equipment; Heat Transfer in Energy Systems
  • Bellevue, Washington, USA, July 9–12, 2017
  • Conference Sponsors: Heat Transfer Division
  • ISBN: 978-0-7918-5788-5
  • Copyright © 2017 by ASME


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.

Copyright © 2017 by ASME



Interactive Graphics


Country-Specific Mortality and Growth Failure in Infancy and Yound Children and Association With Material Stature

Use interactive graphics and maps to view and sort country-specific infant and early dhildhood mortality and growth failure data and their association with maternal

Citing articles are presented as examples only. In non-demo SCM6 implementation, integration with CrossRef’s "Cited By" API will populate this tab (http://www.crossref.org/citedby.html).

Some tools below are only available to our subscribers or users with an online account.

Related Content

Customize your page view by dragging and repositioning the boxes below.

Related eBook Content
Topic Collections

Sorry! You do not have access to this content. For assistance or to subscribe, please contact us:

  • TELEPHONE: 1-800-843-2763 (Toll-free in the USA)
  • EMAIL: asmedigitalcollection@asme.org
Sign In