Register to reply

Heat loss/gain within a home

by eddiej90
Tags: heat, home, loss or gain
Share this thread:
Nov20-12, 09:49 AM
P: 11
I am planning on calculating the heat loss and heat gain of a terraced house.

The data I have collected so far are the footprints of the house, with the size of windows and walls, roof and floors and the materials of which these are made. I know the rear of the house faces S-SE and its approximate location in Sheffield.

I would like to represent the heat loss and heat gain of the house in a spreadsheet however I am quite a novice when it comes to Excel.

I would also like to collect some data of outside temperature, wind direction and speed, and sun intensity over a year long period. I would ideally like this data over hourly intervals as the houses heating is controlled by a varying thermostat throughout the day and night.

Any suggestions as to where I can find this data (preferrably at no cost) and any hints and tips you can offer me? Anything will be much appreciated.

Thanks in advance
Phys.Org News Partner Science news on
'Smart material' chin strap harvests energy from chewing
King Richard III died painfully on battlefield
Capturing ancient Maya sites from both a rat's and a 'bat's eye view'
Nov20-12, 08:58 PM
P: 22,314
The data is the easy part. The government publishes typical hourly weather data including solar insolation information for lots of locations. The data is available for download here:

Calculating the heat gain/loss of a house is pretty difficult with a spreadsheet. Typically, a specially designed piece of software is used. One example with a partially functional demo:
jim mcnamara
Nov20-12, 10:30 PM
Sci Advisor
PF Gold
P: 1,386
An alternative:

Electric utilities in many US states offer energy audits. An audit can help you determine where heat loss/gain occurs. In New Mexico PNM offers these audits. The data provided gives you estimated R values for your windows, doors, etc. of your house. And looks for "leaky" places and points them out.

There is a consumer hit list generated -- things to do to improve problem areas, based on data from the audit. Generally most audits turn up the same sorts of problems. One tech told me he found a wall in a newer home that had no insulation, no Tyvek, nothing but sheathing and some paneling -- it kind of glowed in infared on a cold day. I do not know if PNM still uses the infared camera or not.

This audit feature may be available for you to use.

Nov22-12, 08:20 AM
P: 11
Heat loss/gain within a home

Thanks for your help but I should probably have mentioned i'm in the UK. Would help if we didnt both have a city named Sheffield. Any ideas on where to get the data for the UK?
Nov22-12, 08:58 AM
P: 22,314
Oops, no sorry -- I can try some googling for you, but that's about all I can do.
Nov22-12, 09:35 AM
P: 11
The best website iv found is
Its the best one iv found so far and even shows most of the data i need over a daily period for a year :) although to see the hourly data i need to click on each individual day. It will take me forever to collect the data for all 365 days, copying and pasting into excel. Is there a way I can import all the data without having to click on every single link?
Nov22-12, 10:40 AM
P: 2,055
Quote Quote by eddiej90 View Post
I am planning on calculating the heat loss and heat gain of a terraced house.
its approximate location in Sheffield.
Typical Yorkshireman. Just put another quid in the meter.

Register to reply

Related Discussions
Pool heat gain by solar radiation versus heat loss by evaporation General Physics 2
Gain/Loss of Electrons Chemistry 9
Measuring home heat loss General Physics 11
Temperature Fusion (heat gain = heat loss) Introductory Physics Homework 8
Heat gain or loss by s conductor and an insulator. Advanced Physics Homework 1