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.

Three modes of heat transfer.JPG

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.

Click on the title to download.

18.JPG

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

composite wall.JPG

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.

steady_state_heat_gen_wall.JPG

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.

insulation_Design_electric cable.JPG

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

insulation design.JPG

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

fin analysis.JPG

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

considerations in fin.JPG

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

external isothermal.JPG

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

external isoflux.JPG

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.

boundary layers.JPG

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

pressure drop.JPG

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

natural convection.JPG

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

transient.JPG

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.

heisler chart_plane wall.jpg

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.

heisler chart_cylinder.jpg

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.

Heisler Chart_sphere.JPG

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).

fluid properties calculator.jpg

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

weins law.JPG

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

22.JPG

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

21.JPG

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

19.JPG

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

20.JPG
bottom of page