Forums

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

Heat loss calculators and spread sheets

 
Page 1 / 3
Safety, Regulations, Tools & DIY Installations
Last Post by Abernyte 8 months ago
26 Posts
7 Users
9 Likes
6,067 Views
RSS
Mars
 Mars
(@editor)
Illustrious Member Admin
16502 kWhs
Veteran
Joined: 3 years ago
Posts: 2297
Topic starter 21/01/2023 9: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

Follow our sustainability journey at My Home Farm: https://myhomefarm.co.uk


   
Quote
 Kev M
(@kev-m)
Famed Member Moderator
5550 kWhs
Joined: 3 years ago
Posts: 1299
21/01/2023 10:25 pm  

I quite like the Stelrad one.    

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


   
Mars reacted
ReplyQuote
 HughF
(@hughf)
Noble Member Member
2848 kWhs
Joined: 2 years ago
Posts: 469
22/01/2023 6: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
16502 kWhs
Veteran
Joined: 3 years ago
Posts: 2297
Topic starter 22/01/2023 8:57 am  

@hughf, is the Freedom one free to download?

Buy Bodge Buster – Homeowner Air Source Heat Pump Installation Guide: https://amzn.to/3NVndlU

Follow our sustainability journey at My Home Farm: https://myhomefarm.co.uk


   
ReplyQuote
 HughF
(@hughf)
Noble Member Member
2848 kWhs
Joined: 2 years ago
Posts: 469
22/01/2023 9: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
6784 kWhs
Joined: 2 years ago
Posts: 1382
22/01/2023 9: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


   
Mars reacted
ReplyQuote
cathodeRay
 cathodeRay
(@cathoderay)
Famed Member Moderator
6784 kWhs
Joined: 2 years ago
Posts: 1382
22/01/2023 9: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
3655 kWhs
Joined: 3 years ago
Posts: 1091
22/01/2023 10: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


   
Mars reacted
ReplyQuote
Mars
 Mars
(@editor)
Illustrious Member Admin
16502 kWhs
Veteran
Joined: 3 years ago
Posts: 2297
Topic starter 22/01/2023 10: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

Follow our sustainability journey at My Home Farm: https://myhomefarm.co.uk


   
ReplyQuote



cathodeRay
 cathodeRay
(@cathoderay)
Famed Member Moderator
6784 kWhs
Joined: 2 years ago
Posts: 1382
22/01/2023 10: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


   
Derek M and Mars reacted
ReplyQuote
Abernyte
 Abernyte
(@abernyte)
Reputable Member Member
2618 kWhs
Joined: 1 year ago
Posts: 143
22/01/2023 11:06 am  

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
6784 kWhs
Joined: 2 years ago
Posts: 1382
22/01/2023 11:20 am  

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

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


   
ReplyQuote
Page 1 / 3
Forum Jump:
  Previous Topic
Next Topic  
Share:

Join Us!

Latest Posts

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