Timber beam/joist design spreadsheet to Eurocode 5
(EN 1995-1-1:2004 + A2:2014 plus UK N.A. or Dutch N.A.)
(EN 1995-1-1:2004 + A2:2014 plus UK N.A. or Dutch N.A.)
Essential spreadsheet for designing timber members in accordance with the European Standard now in force throughout Europe. Due to its form, easy input and clear output the spreadsheet reduces time spend on designing.
- English version - calculations are based on Eurocode 5 and British National Annex (EN 1995-1-1:2004 + A2:2014);
- Nederlandse (Dutch) versie - houten balk / balklaag ontwerpen spreadsheet. Berekeningen gebaseerd op Eurocode 5 (NEN-EN 1995-1-1+C1+A1) en Nederlandse nationale bijlage (NEN-EN 1995-1-1/NB); If you are after an English version but based on a different National Annex then feel free to contact me. To get a FREE copy of the Company Licensed version of this spreadsheet: - Translate the spreadsheet to your language and send me an adeqaute National Annex so that I can adjust formulas if necessary. In return I will send you a Company Licensed version of the new spreadsheet, free of charge. Better contact me first to check if someone else is not already translating it to your language.
- A clear and easy to read output (all on a single page);
- Design timber beam or timber joists with given spacing; - Quick summary of utilization factors; - Softwoods covered: C14, C16, C18, C20, C22, C24, C27, C30, C35, C40, C45, C50; - Hardwoods covered: D30, D35, D40, D50, D60, D70; - Oak grades covered: TH1, TH2, THA, THB; - Glued laminated timbers (Glulam) covered: GL24h, GL28h, G32h, GL36h, GL24c, GL28c, GL32c, GL36c; - Laminated Veneer Lumbers (LVL) covered: LVL-S, LVL-Q; - Five load duration classes covered: Permanent, Long-term, Medium-term, Short-term, Instantaneous; - Three timber classes covered: 1, 2, 3; - Automatically calculates modification factors; - Deflection due to shear included in instantaneous deflection calculations; - Option to input notched ends; - Loading options: UDL, Partial UDL, 2x Point Load; - 'Live' Loading diagram; - Vibration checks NOT included; - Design is based on Eurocode 5 (EN 1995-1-1:2004 + A2:2014). (Note: macros must be enabled for proper working of the spreadsheet. Follow instructions in this video)
|
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: |
|
English Version
Dutch Version
|
|
|