Forums

Forums
Sustainable Sidetra...
Safety, Regulations...
Heat loss calculato...
 
Notifications
Clear all

Heat loss calculators and spread sheets

 
Page 1 / 9
Safety, Regulations, Tools, Plumbing & DIY Installations
Last Post by Transparent 2 months ago
99 Posts
15 Users
24 Reactions
17.3 K Views
RSS
Mars
 Mars
(@editor)
Illustrious Member Admin
Joined: 4 years ago
Posts: 3136
Topic starter 21/01/2023 10:04 pm  

Please can you post your favoured heat loss calculators and spreadsheets in this thread so that we can build up a repository for those homeowners that want to undertake their own calculations?

Buy Bodge Buster – Homeowner Air Source Heat Pump Installation Guide: https://amzn.to/3NVndlU
From Zero to Heat Pump Hero: https://amzn.to/4bWkPFb

Subscribe and follow our Homeowners’ Q&A heat pump podcast


   
Quote
 Kev M
(@kev-m)
Famed Member Member
Joined: 4 years ago
Posts: 1276
21/01/2023 11:25 pm  

I quite like the Stelrad one.    

https://www.stelrad.com/advice-hub/heat-loss-programmes/


   
👍
1
ReplyQuote
 HughF
(@hughf)
Noble Member Member
Joined: 3 years ago
Posts: 487
22/01/2023 7:59 am  

I’ve used the freedom spreadsheet for my own place and am halfway through doing the calcs for my builder friend on the same. 

I’ve also modelled my place in heatpunk, that’s quite nice, although not as fast as the freedom toolkit.

I have used the stelrad windows program for rad sizing but haven’t looked at their other offerings yet, will do so.

Off grid on the isle of purbeck
2.4kW solar, 15kWh Seplos Mason, Outback power systems 3kW inverter/charger, solid fuel heating with air/air for shoulder months, 10 acres of heathland/woods.

My wife’s house: 1946 3 bed end of terrace in Somerset, ASHP with rads + UFH, triple glazed, retrofit IWI in troublesome rooms, small rear extension.


   
ReplyQuote



Mars
 Mars
(@editor)
Illustrious Member Admin
Joined: 4 years ago
Posts: 3136
Topic starter 22/01/2023 9:57 am  

@hughf, is the Freedom one free to download?

Buy Bodge Buster – Homeowner Air Source Heat Pump Installation Guide: https://amzn.to/3NVndlU
From Zero to Heat Pump Hero: https://amzn.to/4bWkPFb

Subscribe and follow our Homeowners’ Q&A heat pump podcast


   
ReplyQuote
 HughF
(@hughf)
Noble Member Member
Joined: 3 years ago
Posts: 487
22/01/2023 10:44 am  

Posted by: @editor
↑

@hughf, is the Freedom one free to download?

They were sending copies out to anyone go asked for a while, not sure what the current situation is as they’ve taken down the video instructions from their YouTube channel. I’ve since stuffed it in my GitHub which is probably against various terms of use but I’ll deal with that issue if it ever arises.

 

 

Off grid on the isle of purbeck
2.4kW solar, 15kWh Seplos Mason, Outback power systems 3kW inverter/charger, solid fuel heating with air/air for shoulder months, 10 acres of heathland/woods.

My wife’s house: 1946 3 bed end of terrace in Somerset, ASHP with rads + UFH, triple glazed, retrofit IWI in troublesome rooms, small rear extension.


   
ReplyQuote
cathodeRay
 cathodeRay
(@cathoderay)
Famed Member Moderator
Joined: 3 years ago
Posts: 2040
22/01/2023 10:46 am  

Posted by: @editor
↑

is the Freedom one free to download?

It used to be (from the Freedom Heat Pump's website) but you now have to create an account (I wonder why) which I declined to do as it is not clear what that involves or what it gives you access to. The Wayback Machine does not appear to have the actual downloads, though it does have the folders. But all is not lost, a copy of v3.3 (early 2022) is available on this very forum!

https://renewableheatinghub.co.uk/forums/renewable-heating-air-source-heap-pumps-ashps/designing-ashp-system-using-the-freedom-toolkit-spreadsheet#post-8477

Midea 14kW (for now...) ASHP heating both building and DHW


   
👍
1
ReplyQuote
cathodeRay
 cathodeRay
(@cathoderay)
Famed Member Moderator
Joined: 3 years ago
Posts: 2040
22/01/2023 10:52 am  

Posted by: @hughf
↑

they’ve taken down the video instructions from their YouTube channel

Looks like the cancel culture has hit Headroom Heatpumps... 

Midea 14kW (for now...) ASHP heating both building and DHW


   
ReplyQuote
 batalto
(@batalto)
Famed Member Member
Joined: 4 years ago
Posts: 1091
22/01/2023 11:08 am  

@cathoderay freedoms 2.1V is the one in my signature (Google sheets version)

12kW Midea ASHP - 8.4kw solar - 29kWh batteries
262m2 house in Hampshire
Current weather compensation: 47@-2 and 31@17
My current performance can be found - HERE
Heat pump calculator spreadsheet - HERE


   
👍
1
ReplyQuote
Mars
 Mars
(@editor)
Illustrious Member Admin
Joined: 4 years ago
Posts: 3136
Topic starter 22/01/2023 11:14 am  

@cathoderay, brilliant, I've re-uploaded here for easy access and reference.

2021 Freedom Heat Pumps tool kit V3.3 for all installers - Copy.xlsx

 

Buy Bodge Buster – Homeowner Air Source Heat Pump Installation Guide: https://amzn.to/3NVndlU
From Zero to Heat Pump Hero: https://amzn.to/4bWkPFb

Subscribe and follow our Homeowners’ Q&A heat pump podcast


   
ReplyQuote



cathodeRay
 cathodeRay
(@cathoderay)
Famed Member Moderator
Joined: 3 years ago
Posts: 2040
22/01/2023 11:53 am  

@editor - it was just hiding in plain sight, as things so often are!

People do need to be aware that, while good, Freedom's calculator is not perfect:

(1) famously, it over-estimates Midea heat pump output at lower ambient temps

(2) not all building materials are available, sometimes you have to choose something that is not what you home has, but is 'near enough'

(3) it uses a relatively crude method of calculation radiator output (based on area) which doesn't take into account an actual radiator's output (but most of the time it is 'good enough'). It also lacks the option of using K3 rads (but you can hack it to make it do that, but make sure you get the numbers right)

(4) v3.3 uses/tests for the MCS heat pump must supply 100% or more of the heat demand requirement (if it doesn't you FAIL). I think MCS in their infinite wisdom may have changed that requirement. Perhaps someone more up to date on MCS requirements could comment

Lastly, it needs a LOT of data entry. Typos are easy, check and double check your entries, and do visual sanity checks on your results eg if a large room has a small heat loss, you probably made a typo in a measurement entry somewhere. 

Midea 14kW (for now...) ASHP heating both building and DHW


   
👍
2
ReplyQuote
Abernyte
 Abernyte
(@abernyte)
Honorable Member Member
Joined: 2 years ago
Posts: 224
22/01/2023 12:06 pm  

Does anyone else get a "Problem with content in this workbook" error when opening this file in Excel?  I am using Excel 2016


   
ReplyQuote
cathodeRay
 cathodeRay
(@cathoderay)
Famed Member Moderator
Joined: 3 years ago
Posts: 2040
22/01/2023 12:20 pm  

@abernyte - I use LibreOffice Calc. Maybe try that?

Midea 14kW (for now...) ASHP heating both building and DHW


   
ReplyQuote
Page 1 / 9
Forum Jump:
  Previous Topic
Next Topic  



Share:

Join Us!

Trusted Installers

Struggling to find a reliable heat pump installer? A poor installation can lead to inefficiencies and high running costs. We now connect homeowners with top-rated installers who deliver quality work and excellent service.

✅ Verified, trusted & experienced installers
✅ Nationwide coverage expanding
✅ Special offers available

👉 Find your installer now!

Latest Posts

x Powerful Protection for WordPress, from Shield Security
This Site Is Protected By
Shield Security →