Dr. Ashish Karn
Heat Transfer Excel Tools
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.
​
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.
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).