- #1
dansphere
- 3
- 0
Hello,
I'm looking for some feedback on and an analysis of a spreadsheet calculator I've made.
It looks at temperature changes over time, given starting volumes of a building shell and thermal mass. The calc takes into account building fabric and ventilation heat losses.
First I've derived the available heat energy at a given starting temperature and used the specific heat capacities of the air and thermal mass to calculate the total available heat energy at 20 degrees Centigrade relative to absolute zero. Does this make sense?
Then I've calculated the losses over one hour and deducted that from the total energy, and done this recursively for several hours.
The change in internal temperature I'm deriving from a simple ratio.. ((heat energy lost/total heat energy) * original temperature in Kelvin). Although what I've realized is that the energy lost is only translatable to a temperature change via the specific heat capacities of the air and thermal mass, is this correct? Or can it be done via a ratio?
Attached is the spreadsheet I've made.
I'm looking for some feedback on and an analysis of a spreadsheet calculator I've made.
It looks at temperature changes over time, given starting volumes of a building shell and thermal mass. The calc takes into account building fabric and ventilation heat losses.
First I've derived the available heat energy at a given starting temperature and used the specific heat capacities of the air and thermal mass to calculate the total available heat energy at 20 degrees Centigrade relative to absolute zero. Does this make sense?
Then I've calculated the losses over one hour and deducted that from the total energy, and done this recursively for several hours.
The change in internal temperature I'm deriving from a simple ratio.. ((heat energy lost/total heat energy) * original temperature in Kelvin). Although what I've realized is that the energy lost is only translatable to a temperature change via the specific heat capacities of the air and thermal mass, is this correct? Or can it be done via a ratio?
Attached is the spreadsheet I've made.