Here is a basic 2D heat transfer model. The first five worksheets model square plates of 30 x 30 elements. The last worksheet is the model of a 50 x 50 plate.
You can modify the initial temperature by hand within the range C21:AF240. It is also a diffusion model. It uses the storage and transport equations derived in the previous tutorials.
The temperature calculations are done all with a single repetitive spreadsheet formula. This is one the easiest models on this blog and a brief tutorial will follow.
On my computer I clocked it at 40 frames/second for the the 30 x 30 models (and 30 fps the 50 x 50 model with Excel 2003) and 1.7 frames/second with Excel 2007. Most of this delay in the 2007 version is due to real time charting.
The intrinsic calculation speed in Excel 2007 (measured with the chart out of view) it’s actually about half the speed of the 2003 version of Excel. I also have a model version using a custom VBA function and it has about half the speed of this one in 2003.