Jump to content
  • entries
    10
  • comments
    102
  • views
    28059

Exploring the ratios and losses between building elements

SteamyTea

Entry posted by SteamyTea in Compare U-Values and ACH

38 views

 Share

Been a bit bored as I have not been able to concentrate on anything much recently, but life is getting back to normal.

 

I read on here a lot about the advantages of insulation, airtightness, MVHR etc, but this misses a few points.

Form is one of them, a simple cube is a pretty good shape for thermal efficiency, and the bigger it is, the better it looks.

So I thought I would knock up a very basic spreadsheet that can be used to explore the differences between size, form, thermal properties (just U-Value), air changes an hour for a cuboid.

This is basically to just show the ratios and theoretical power transfers.

Cells B3 to B11 can be changed with the snapshot results shown in cells B13 to B17.

Below that are some data arrays that show ventilation and fabric losses, and ratios for surface area to volume and fabric to ventillation for different form factors for the cuboids.

Not sure how useful this will be to anyone, but it does put numbers to changes i.e. you can change the ACH and U-Value and see which will have the greater effect.

 

This is a very limited scope spreadsheet, so a lot of interpretation is needed.

It does produce some charts though.

 

 

Compare U-Values and ACH.ods

  • Like 2
 Share

4 Comments

Recommended Comments

Gus Potter

Gus Potter 1385

Posted

Hi Steamy.

 

Having a bit of trouble opening your spreadsheet. 

 

Have tried it in Excel 2024 using the "all files option" Says the file is corrupt. Tried it in Excel 2013 version using the all files option, says it's protected with a password so won't open. 

Gus Potter

Gus Potter 1385

Posted

Hiya. Can open it a bit in excel 2024, but it is stripping out a lot of info I think? Tried again with an earlier version of excel but most of the cells are not referencing. The charts are blank.

 

From what I can see you have put in a pile of effort into this. It's not a five minute job, it must have taken a huge effort to develop this. 

 

It looks like a good tool. 

 

It may be a "jock" problem at my end" but I doubt it. Ask around and see what others say.. you do know why the animal called the Haggis has it two left legs shorter.. it's so the can run round a hill and still stay level! 

 

 

 

 

SimonD

SimonD 912

Posted

15 minutes ago, Gus Potter said:

Can open it a bit in excel 2024

 

Both the ods and xlsx file work fine in LibreOffice calc.

 

Best thing to do is download and install a copy of libre office - https://www.libreoffice.org/

 

But beware, once you start using it instead of Excel, you may never go back 😁

 

Now need to do some interpretation.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...