I have put together an Excel spreadsheet that calculates the temperature profile through a wall that is heated by the sun.
It use the matrix [K]{T} + [C]{dT/dt} = {S}, where [K] is the heat transfer, {T} is the temperature at the various nodes, [C] is the thermal capacitance of the node, and {S} is the thermal heat gain of the outer node. A copy of the spreadsheet and matrix math is attached.
The math equations have not been verified for accuracy or errors, but it is kind of fun to play around with the variables to see how the temperature profile in the wall changes throughout the day.
(Note that an earlier version of this post had the attached Excel file as a *.zip file. It has been replaced with an Excel version.)
Tags: difference, element, finite, heat, transfer, transient
 Attachments:
