Holding Down Bolts Design Spreadsheet to BS5950, BS8110
for cast-in, post-drilled and with anchor plate holding down bolts
for cast-in, post-drilled and with anchor plate holding down bolts
|
Very useful and easy to use spreadsheet for designing all common types of holding down bolts. This includes cast-in bolts, post-drilled anchors (where resin or grout is used) and holding down bolts with anchor plate (typically used with positioning cones that are grouted in once columns are in position). The spreadsheet includes diagrams that clearly represents the bolt type being designed. The effective conical surface area is calculated for two bolts in accordance with Concrete Society Advise No 5. Very useful spreadsheet for engineers working with steel frame buildings.
- A clear and easy to read output (all on a single page);
- In-spreadsheet help notes; - Quick summary of results; - Covers all common types of holding down bolts: a) cast-in; b) post-drilled (i.e. post-installed or post-grouted), typically filled with grout or resin; c) with anchor plates, typically used with positioning cones; - Covers 4.6, 8.8, 10.9, general and higher grade HSFG bolts; - Option to change between bolt total length and bolt embedment depth for quick calculations; - Diagrams that clearly represent the design case; - Checks bolt tension capacity, pull-out resistance, bond stress at bolt-grout and/or bolt-concrete interface; - Automatically calculates effective conical surface area based on given spacing between two bolts; - Concrete pull-out resistance is calculated based on effective conical surface area for standard holding down bolts, and based on effective punching shear perimeter for bolts with anchor plates; - Minimum edge distance and other requirements/notes are included in the spreadsheet; - Design is in based on British Standard (BS 5950, BS 8110 and Concrete Society Advise No 5). (Note: macros must be enabled for proper working of the spreadsheet. Follow instructions in this video)
Be the first to leave a comment...
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.
|