Timber Frame Wall Design Spreadsheet to BS 5268-2 and BS 5268-6.1
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.
- 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)
Be the first to leave a comment...