Menu:

U-value Calculator Spreadsheet to BS EN ISO 6946 (and BS EN ISO 13370, 13789, BRE 443, 497)
For walls, roofs and slabs. Available for Microsoft Windows and Apple Mac users.
 
How This Spreadsheet Works:
slideshow not visible? check blocked content

Windows version:
Mac Version:
Description:
U-value calculator for calculating heat loss through construction elements like basement walls, external walls, slab-on-ground floors, suspended floors and roofs. The spreadsheet is automated as much as possible, providing easy to use tool for effortless calculations that normally would be complex and long. Includes an extensive database of materials selectable through drop-down menus to minimise design time. As a result it really makes U-value calculations a quick and simple task and it can be easily used by architects, builders and even regular home owners who just want to check a potential benefit of the extra insulation they always thought of adding.

This spreadsheet was specially developed for Windows and Mac users.
Features:
- User friendly and very easy to use;
- A clear and easy to read output;
- All input and output is on a single page making it very easy to follow and make adjustments;
- Any changes are immediately reflected in the calculated U-value and can be readily assessed;
- Covers the following Element Types: basement wall, external wall, slab-on-ground floor, suspended slab, typical floor, roof (including warm roof);
- Automatically selects the correct calculation method and shows relevant input options;
- Calculates elements of up to 10 layers;
- Allows for up to 4 bridged layers (up to 2 bridged layers for warm roofs);
- Includes resistance calculations for high and low emissivity airspaces;
- Includes allowance for corrections for airgaps and penetrating fasteners;
- Includes allowance for edge insulation for slab-on-ground floor calculations;
- Includes under-floor resistance calculations for suspended and slab-on-ground floors (in accordance with BS EN ISO 13370);
- Calculates mass of wall (as required by Part E: Resistance to the passage of sound);
- Covers warm roof calculations (in accordance with BS EN ISO 13789) where two parts have to be calculated separately;
- Extensive, editable Material Database (based on Standards, manufacturers' specifications and resources available on-line);
- Two versions are available: one for Microsoft Windows users and one for Apple Mac users;
- Design is based on BS EN ISO 6946:1997, 13370:1998, 13789:2007, BRE 443 and 497.

(Note: macros must be enabled for proper working of the spreadsheet. Follow instructions in this video)
Material Database:
This spreadsheet is independent of the industry of building materials. As a result it was possible to include an extensive database of building materials from various manufacturers. Data of these products is gathered from Standards, manufacturers' specifications and on-line resources. If you want your products to appear in this spreadsheet (free of charge) then please contact me.
On-screen Interface versus Printout:
There is a subtle difference in appearance of user interface and printout. This is because drop-down menus are used for easy and quick selection of layer materials. These have drop-buttons which are not visible on printouts. Have a look at these print screens:
Interface on Windows:
Interface on Mac:
Printout:
What People Say:

Title
/
Company

  • 1
  • 2
  • 3
  • 4
  • 5
If you need to calculate U-value in a fast way, this is your spreadsheet! I like the organization of all the values. I recommend the use for architects and engineers.

Carlos Rodriguez
​Freelancer

Director
/
Capita (www.capita.co.uk)

  • 1
  • 2
  • 3
  • 4
  • 5

/

  • 1
  • 2
  • 3
  • 4
  • 5
To calculate U-Values for my loft conversion could not have been easier. Found this website by shear coincidence. Would recommend this to anyone looking for a fast way to meet the latest regulations without spending to much by over specifying their insulation requirements."

John Denis
​Retired Project Engineer/Manager doing a loft conversion

/

  • 1
  • 2
  • 3
  • 4
  • 5

/

  • 1
  • 2
  • 3
  • 4
  • 5
Saves me a lot of time every day.

Robert G.

/

  • 1
  • 2
  • 3
  • 4
  • 5

/

  • 1
  • 2
  • 3
  • 4
  • 5
I'm impressed with the spreadsheet, very useful, thanks.

Chris T.

/

  • 1
  • 2
  • 3
  • 4
  • 5

/

  • 1
  • 2
  • 3
  • 4
  • 5
​Very easy to use, gives accurate results and the drop down menus are great - excel magic!

Patrick

/

  • 1
  • 2
  • 3
  • 4
  • 5
  • 0
  • 1
  • 2
  • 3
  • 4
Provide testimonial or feedback
System Requirements:
To run the Single-User Licensed version you require:
- Microsoft Windows Excel version 2007 and above;
(Note: the Single-User spreadsheet will not run on Mac due to unsupported activation procedure)

To run the Company Licensed version you require either:
- Microsoft Windows Excel version 2007 and above;
- Microsoft Mac Excel version 2004, 2011 and above. If unsure then see whether the FREE version works.

Technical Advice: If you have enabled macros and still cannot use the drop-down menu to change materials then it is probably because of a faulty Windows Update. Solution HERE.
Download Section:
FREE Lite version: U-value Calculator Spreadsheet to
BS EN ISO 6946, 13370, 13789, BRE 443, 497 (1.3).

The restriction in this free lite version is that you can not change the company name nor the logo (shown in top left corner) - currently set to a made up company. Furthermore, you are limited to four layers only and the first two are locked for editing. There are other minor limitations, for a full list see the spreadsheet.
Windows version:
Mac version:


FULL version: U-value Calculator Spreadsheet to
BS EN ISO 6946, 13370, 13789, BRE 443, 497 (1.3).

Single-User or Company License, which one is the best for me?

Fully working version where you can change the company information and logo in the top left corner.

Furthermore, you are not limited to four layers only; you can edit existing and add new materials to Material Database; you can edit Element Type specific information like widths, depths etc.

By purchasing this spreadsheet you agree to the disclaimer and terms & conditions. Two types of licenses are available for this spreadsheet. The single-user license is offered for a nominal price of £20 - a great product that you can have for a great value.

After purchase fill in this Activation Key Request Form.

 Windows version only:
 
Windows & Mac version:

For other currencies click here: € (EUR), £ (GBP) or $ (USD).