Timber Post Design Spreadsheet to BS 5268-2: 2002
An easy to use spreadsheet for designing timber, glulam (glued laminated timber) and composite posts subject to axial load (compression or tension) and/or moments about major and minor axis. Essential spreadsheet for designing timber members. 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);
- Material types: timber, glued laminated timber (glulam) and composite;
- 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;
- Glued laminated timbers (Glulam) covered: vertically glued, horizontally glued;
- Composite member types: Parallam 2.0E PSL, Timberstrand 1.3E LSL, Timberstrand 1.5E LSL, Kerto S-LVL, Kerto Q-LVL, Versa Lam LVL;
- Loading: axial (tension, compression), moment about major axis, moment about minor axis;
- Option to consider load sharing;
- In-spreadsheet help;
- 'Live' section diagram;
- Design is based on British Standard (BS 5268-2: 2002).
(Note: macros must be enabled for proper working of the spreadsheet. Follow instructions in this video)
"Used this to calculate my timber post supports in my new loft conversion. Easy to use for sizing new posts for my roof supports when cutting out a purlin to increase head height. Recommend this to anyone wanting to do the same without long calculations." John Denis - Retired Project Engineer/Manager doing a loft conversion
"Simple yet effective and easy to input. As with all this series of design aids, a big time saver in being quickly able to alter modification factors such as restraints and end conditions etc. This is always useful when dealing with existing structures where construction details do not become clear until work on site commences." David Annakin