Menu:

Building Near Trees - Foundation Design Spreadsheet to NHBC standards
(Section 4.2 of National House Building Council)    Available for Microsoft Windows and Apple Mac users.
 
Description:
- If you are planning to build a new extensions, or a new building, and there are trees nearby...
- or if you are planning to plant a new tree near existing building and are not sure whether it will affect the existing foundations and cause wall cracking...
...then this spreadsheet is what you need.

Building near existing trees (or planting a new tree near existing building) is a very delicate matter and should be carefully dealt with. It is very easy to underestimate reach (influence zone) of trees and if new foundations are not deep enough then this may cause wall cracking etc. Claims due to defects caused by trees are one of the most common in the building industry.

This spreadsheet is a very handy tool that provides answers to these issues. Use it to calculate required foundation depth when building in cohesive ground, e.g. clay, and near existing or proposed trees (or planting trees near existing structure). It includes diagrams and site layout for easier understanding. This makes the spreadsheet very easy to use and follow. Based on Section 4.2 of NHBC standard. A great tool for engineers, contractors and regular house owners.

This spreadsheet was specially developed for Windows and Mac users.
Features:
- A clear and easy to read output (all on a single page);
- For broad leafed and coniferous trees;
- Up to two trees can be calculated per page;
- Calculates required foundation depth up to 2.5m. In some circumstances deeper foundations are required and these should be designed by a structural engineer (as required by NHBC);
- Diagrams and site location layout for easier understanding;
- Includes an extensive list of tree species and UK locations;
- Search for tree by English name or Latin equivalent;
- Option to include heave precautions;
- Quick summary of utilization factors;
- Results are updated automatically as input is changed;
- Two versions are available: one for Microsoft Windows users and one for Apple Mac users;
- Design is based on NHBC standards: 2020.

(Note: macros must be enabled for proper working of the spreadsheet. Follow instructions in this video)
What People Say:

Title
/
Company

  • 1
  • 2
  • 3
  • 4
  • 5
We purchased the 'Building Near Trees Foundation Design' spreadsheet for our company and I can honestly say it was worth every penny. Designing foundations around trees is now a simple matter of entering the tree details into the spreadsheet and using the results. The spreadsheet includes every tree we have encountered and takes into account the area of the country where the trees are located to provide an accurate design. We couldn't ask for more.

Darren Heighington
DH Drawings
www.dhdrawings.com

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

  • 1
  • 2
  • 3
  • 4
  • 5

/

  • 1
  • 2
  • 3
  • 4
  • 5
Two days ago I was ploughing through the NHBC tables, now I can use this superb tool in about a tenth of the time to present a professional and accurate output to clients. Another excellent offering from YourSpreadsheets​.

Richard Davis
wrdstructural.co.uk

/

  • 1
  • 2
  • 3
  • 4
  • 5

/

  • 1
  • 2
  • 3
  • 4
  • 5
Such a simple spreadsheet and such a time saver! Have been using it for the last few months and together with the other eight spreadsheets that I bought from this website I am prepared for anything. Your spreadsheets are fantastic!

​Lynn

/

  • 1
  • 2
  • 3
  • 4
  • 5
  • 0
  • 1
  • 2
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 and above. If unsure then see whether the FREE version works.
Alternatives:
There are two main on-line alternatives to this spreadsheets:
- Standalone program by NHBC which is a good alternative;
- On-line calculator provided by a 'warranty provider'. This calculator is not recommended as most of the tree data is incorrect and so gives wrong results.
Download Section:
FREE Lite version: Building Near Trees Design to NHBC (1.1).

The restriction in this free lite version is that you cannot change the company name nor the logo (shown in top left corner) - currently set to a made up company. Also you cannot change indicated cells.

 


FULL version: Building Near Trees Design to NHBC (1.4).

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

Fully working version where you change the company information and company logo.

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).