Menu:

Timber Frame Wall Design Spreadsheet to BS 5268-2 and BS 5268-6.1
 

Description:
An easy to use spreadsheet for designing timber frame walls. Includes calculations of racking resistance based on selected sheathing material, fixings and masonry cladding (if present). Timber studs can be designed for vertical load and/or wind perpendicular to wall. Includes stud deflection check. Excellent spreadsheet for timber frame designers. Due to its form, easy input and clear output it reduces time spent on designing.

This spreadsheet was specially developed for Windows and Mac users.
Features:
- Clear and easy to read output (all on a single page);
- Quick summary of utilization factors;
- Softwoods covered: C14, C16, C18, C20, C22, C24, C27, C30, C35, C40;
- Hardwoods covered: D30, D35, D40, D50, D60, D70;
- Oak grades covered: TH1, TH2, THA, THB;
- Loading: uniformly distributed line load, wind load perpendicular to wall;
- Considers load sharing automatically if studs are at centres no greater than 610mm;
- Includes timber stud design and racking resistance calculations;
- Checks stud deflection (uses equation for simply supported beams);
- For calculating racking resistance of wall panel the following sheathing can be specified: Bitumen board, Medium board, OSB, Particleboard, Plasterboard, Separating walls, Plywood, Tempered hardboard;
- Option to specify sheathing thickness, nail/screw spacing and diameter;
- Option to add masonry cladding to enhance racking resistance of wall panel;
- In-spreadsheet help;
- Diagram changes automatically when user changes key information like adds an opening, second sheathing or masonry cladding;
- Design is based on British Standard (BS 5268-2: 2002 and BS 5268-6.1: 1996).

(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 have specialised in timber engineering since the 1970's so have a good deal of experience in the field. This is a truly excellent tool with (importantly) various really useful safety features to prevent the operator straying beyond the numerous boundaries which the British Standard sets and which can catch the unwary.

Richard Davis
wrdstructural.co.uk

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

  • 1
  • 2
  • 3
  • 4
  • 5

/

  • 1
  • 2
  • 3
  • 4
  • 5
Be one of the first to provide testimonial for this spreadsheet. Click the link below.

You

/

  • 1
  • 2
  • 3
  • 4
  • 5
  • 0
  • 1
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.
Download Section:
FREE Lite version: Timber Frame Wall Spreadsheet to BS (1.0).

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. Also you cannot change post height, axial load etc.
​ 

 
​​PLEASE NOTE: The file is in XLSM format. ​If after downloading you get an error message about invalid file format (XLSX) then please update your web browser or use a different one and re-download the file. Some versions of Microsoft Edge, Microsoft IE are known to corrupt XLSM files upon download by changing these to XLSX format, making these unreadable in Excel.


FULL version: Timber Frame Wall Spreadsheet to BS (1.0).

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

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

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.


 
 


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