Friends, around a year ago I wrote an article and made a YouTube video about using a ‘Rule of Thumb’ for estimating the size of heat pump required to replace a gas boiler in a dwelling.
The ‘Rule of Thumb’ is splendidly simple: one just divides the previous year’s gas consumption by 2,900 to give the heat pump size in kilowatts. So if a dwelling used 10,000 kWh of gas the previous year, then one would estimate that it needed a 3.4 kW heat pump. The YouTube video explaining why the rule works has been watched an astonishing 37,000 times, and many people have left comments telling me they found the rule helpful and accurate.
The basic reason the rule works is because (a) most gas consumption is spent heating homes (rather than heating hot water or food) and (b) the climate of the southern half of the UK does not vary that much. The rule of thumb uses gas consumption as an indicator of the amount heat which enters a dwelling and uses climate data – in the form of heating degree days – to estimate how cold it gets in a particular locale. You can find a detailed description here, here, here and here!
But one or two people have told me that it gave them answers they thought were quite wrong. It turned out that these people often only put their gas boilers on for an hour or two per day, and so most of the time their dwellings were unheated. Alternatively, some people – particularly with families – used a lot of hot water every day – and so this formed an unusually large fraction of their gas consumption.
So I thought it would be nice to develop something just a little more sophisticated than the ‘Rule of Thumb’ that would take account of some of these factors. I did this last summer and sent it to an academic expert for feedback. The feedback was devastating: they basically told me that everything was wrong. And despite trying to modify the spreadsheet to meet their criticism, they seemed unmollified. So, shaken, I abandoned the idea for a while.
But recently I have been thinking about the idea again and decided that in fact I thought the spreadsheet was useful after all, and that it could also help with one other problem: sizing of radiators.
The reason I think this endeavour is important is that people who are thinking about installing heat pumps have faced a campaign by the fossil fuel industry and their knowing (and unknowing) shills, a campaign designed to instil fear, uncertainty and doubt (FUD). Every year of delay in installing heat pumps keeps the profits of fossil fuel companies healthy, and impoverishes the world in which our children will have to live.
This is not to say that there are not legitimate questions and uncertainties about installing a heat pump. So this spreadsheet is a transparent tool that can help people make rational choices and – I hope – help them to overcome the FUD.
- You can download the spreadsheet here:Link
- Spreadsheet updated to version 6.01 on 3/3/23
I have tried to make the spreadsheet Good For Nothing™ 🙂 . But mistakes will have slipped through: if you find one, please accept my apology in advance and let me know in the comments.
Spreadsheets Galore
The ‘spreadsheet’ is actually six spreadsheets linked together in an Excel™ Workbook. Each Spreadsheet has its own ‘tab’. Six spreadsheets may sound daunting, but really this could all be on one spreadsheet. Using several sheets actually makes things simpler.

Click on image for a larger version. The introductory ‘tab’ of the Excel™ Workbook showing the other 6 tabs. Users are recommended to save the downloaded copy and experiment with a ‘working copy’.
- The first spreadsheet helps people estimate the average temperature in their dwelling, and also the maximum temperature they like.
- The second spreadsheet helps people estimate the amount of hot water they use.
- The third spreadsheet uses the ideas behind the Rule of Thumb, but modified to take account of the estimates on the first two spreadsheets. It suggests a likely required size of heat pump and a few other building parameters that specialists might find interesting.
- The fourth spreadsheet allows people to see how the area of radiators and the type of radiators affects how hot the water flowing through the radiators needs to be in order to keep their home at the maximum temperature they desire.
- The fifth spreadsheet allows people to make more detailed calculations based on the number, size and type of radiators in their own dwelling.
- Finally, the sixth spreadsheet summarises the results from the previous spreadsheets and estimates the likely savings in cost and carbon dioxide emissions.
Let me show you each spreadsheet works in a little more detail.
Sheet 1: Household Temperature

Click on image for a larger version. Spreadsheet designed to allow a user to indicate the temperature changes in their home throughout a typical winter day.

Click on image for a larger version. As above, but showing a different temperature profile.
On this tab of the workbook, one can specify how the temperature varies inside a dwelling on a typical winter day. There are four times periods and each one can be set to one of three user-chosen temperatures.
The spreadsheet then calculates:
- The average temperature in the dwelling which is useful for calculating the average heat loss and hence energy consumption.
- The maximum temperature required which determines the required power of a heat pump able to heat the dwelling.
Sheet 2: Domestic Hot Water

Click on image for a larger version. Do you know how much hot water your dwelling uses each day.
I have been told that – in the absence of any other information – a good guess for the amount of gas used to heat hot water in a household is 3 kWh per person per day. This tab uses this figure to estimate how much of the annual gas usage is for domestic hot water.
If a user somehow has a better estimate, they can use their own estimate instead.
Sheet 3: Main Calculation

Click on image for a larger version. This ‘tab’ carries out the main heat pump size calculation.
This tab carries out the same calculation as the Rule of Thumb but now with a little more information about a particular user’s dwelling. It incorporates the data from the first two tabs on average and maximum temperatures and domestic hot water usage. It asks the user for the annual gas consumption and their approximate location (within around 100 miles). The location is used to estimate how cold the weather is likely to have been based on analysis of the heating degree-day records from 21 locations in the UK and Ireland.

Click on image for a larger version. This tab carries out the main heat pump size calculation.
The spreadsheet then estimates several parameters that characterise the level of thermal insulation of the dwelling and – most importantly from the perspective of this article – the heat pump size required for the dwelling.
Sheet 4: Radiators

Click on image for a larger version. This tab allows users to see how the area of radiators, and the type of radiators affect the performance of the heating system.
This tab allows users to see how – in general – the area of radiators, and the type of radiators affects the performance of the heating system. First one sets a maximum flow temperature for the system – this is the temperature of the hot water as it enters the radiators.
Heat pumps typically use weather compensation, which means that when the weather is cold, the heat pump increases the temperature of the water flowing in the radiators. For a heat pump the maximum flow temperature required in the coldest weather should ideally be below 50 °C.

Click on image for a larger version. This tab allows users to see how the area of radiators, and the type of radiators affect the performance of the heating system.
The table above shows – for the heat pump size calculated on the previous tab – what combinations of total radiator area and types of radiator will be able to heat the dwelling adequately.
For heat pumps to work at their very best, the temperature of the water flowing in the radiators should be as low as possible while still allowing the dwelling to be adequately heated.
In the example above the heat pump needs to transfer 5,296 watts of heating power to the dwelling.
- The table shows that this would require 9 square metres of single-panel/single-fin (Type 11) radiators, but the same heating could be done with just 5 square metres of double-panel/double-fin (Type 22) radiators.
- Alternatively one might use 9 square metres of double-panel/double-fin (Type 22) radiators because this would require a flow temperature in the radiators 39. 8°C rather than 49.2 °C – and this reduced flow temperature would result in increased heat pump efficiency, and lower running costs.
Sheet 5: More Radiators

Click on image for a larger version. This tab allows users to see how the number, size and type of radiators in their dwelling affect the performance of the heating system.
The previous tab allowed users to see in general terms how the area of radiators, and the type of radiators affect the performance of the heating system. On this tab a user can input the size (width and height) and type of their existing radiators and see whether – for the flow temperature set on the previous tab – they can release enough heat into their dwelling.

Click on image for a larger version. This TAB allows users to see how the area of radiators, and the type of radiators affect the performance of the heating system.
By putting in data on their existing radiators – the radiator type is input via a drop-down menu – the heating power of each radiator is calculated at the maximum allowed flow temperature. The heating power of each radiator is then summed up to see if the assemblage of radiators in the dwelling is capable of providing enough heating power to keep the dwelling warm on a cold day. This is shown as a percentage on a bar chart.
If a figure of 100% cannot be reached with existing radiators, then users can see whether 100% can be achieved by either adding radiators, or replacing radiators with larger ones, or radiators with more panels and fins.
Sheet 6: Summary

Click on image for a larger version. This tab summarises the results from the previous tabs and compares the cost and carbon dioxide emissions of systems using a gas boiler or alternatively, a heat pump.
Nearly finished! This summary tab collects together the conclusions from the previous spreadsheets. If a user enters the cost of their electricity and gas, the spreadsheet will then estimate the likely running costs of a gas boiler and a comparable heat pump.
The annual costs of the gas installation are estimated based on the users estimate of their own gas consumption. The running costs of the heat pump installation are based on an estimated seasonal coefficient of performance (SCOP).
The coefficient of performance (COP) of a heat pump is a measure of the efficiency of a heat pump measured over a period of typically an hour, a day or a week. In mild weather, the COP will be high (perhaps 4) and in cold weather the COP will be low (perhaps 2.5). SCOP measures the efficiency of a heat pump averaged over a whole year.
If a user experiments with different flow temperatures they will find that the lower the maximum flow temperature they plan for, the higher the achievable SCOP and the lower will be their running costs. Typically users will find that with the relative costs of electricity and gas as they are now (April 2023) at a ratio of roughly 3 to 1, a heat pump installation will commonly be a little bit cheaper to run than a gas boiler, but the difference is not very large compared with the capital cost of the installation.

Click on image for a larger version. This tab summarises the results from the previous tabs and compares the cost and carbon dioxide emissions of systems using a gas boiler or alternatively, a heat pump.
And finally – and this is the point of the entire endeavour – the spreadsheet makes a comparison of the carbon dioxide emissions from a dwelling heated either with a heat pump or a gas boiler. It is here that the entire point of running a heat pump becomes clear: carbon dioxide emissions from a heat pump installation are generally around 75% lower than an equivalent gas boiler. And that’s why this matters.

Click on image for a larger version. Graph showing the annual emissions of carbon dioxide from a gas boiler and an equivalent heat pump installations.
Like this:
Like Loading...