top of page
##### Heat Transfer Excel Tools

Here is a computational tool that computes the relative magnitudes of conduction, convection and radiation heat transfer from a system depending upon various input parameters. Click on the title to download.

This file on Fourier's law is a simple tool that explains the sign conventions in using the Fourier's law.

â€‹

The tool shows that irrespective of the selection of origin and the direction of x-axis chosen across a plane wall, the heat transfer as predicted by Fourier's law comes out to be from a hot to a cold body.

â€‹

â€‹

Here is a computerized version of the temperature profile for a composite wall. Click on the title to download.

Here is a computerized Python tool that specifically deals with steady state heat generation inside a wall. Just plug in values and choose any two of the 16 boundary conditions possible;  see the parametric variation, and visualize the changing nature of these curves. As you try to explain the underlying physics, you are sure to get deeper insights into the heat flow and the temperature.  Click on the title to download.

Here is a Python-based tool that demonstrates the concept of critical radius/thickness of insulation over an electric cable. Click on the title to download.

This small tool allows you to calculate insulation thickness, cost for doing it and temperatures at different locations.

Here is a computerized version of doing fin analysis using different boundary conditions. Click on the title to download.

Here is a computerized version of doing considerations in selection of fin material. Click on the title to download.

Here is a computerized version of the external convection over an isothermal plate. Click on the title to download.

Here is a computerized version of the external convection over an isoflux plate. Click on the title to download.

Here is a computerized version of the presentation of an hydrodynamic and thermal boundary layers in an internal convection. Click on the title to download.

Here is a computerized version of finding out the pressure drop and convection heat transfer in internal flows. Click on the title to download.

Here is a computerized version of understanding the natural convection for different geometries. Click on the title to download.

Here is a computerized version of the transient cooling of an initially hot sphere. Click on the title to download.

Here is a computerized version of the Heisler chart for a plane wall, which can prove very useful in the calculations of unsteady state problems. Click on the title to download.

Here is a computerized version of the Heisler chart for a cylinder, which can prove very useful in the calculations of unsteady state problems. Click on the title to download.

Here is a computerized version of the Heisler chart for a sphere, which can prove very useful in the calculations of unsteady state problems. Click on the title to download.

This small tool allows you to calculate different fluid properties, such as dynamic viscosity, density, kinematic viscosity, specific heat, thermal conductivity, thermal diffusivity of a variety of fluids at a given temperature. It also provides Prandtl number and Reynolds number (provided velocity and length scales are provided).

This small tool allows you to find out in which range blackbody radiation lies.

This small tool allows you to do performance analysis on multi pass shell and tube heat exchanger.

This small tool allows you to do performance analysis for counter flow heat exchanger.

This small tool allows you to find out viewfactors for different 2D geometries.

This small tool allows you to find out viewfactors for different 3D geometries.

bottom of page