Related Resources: Design Engineering
Bolt Group Shear and Torsion Excel Spreadsheet Calculator
NOTE: Refunds are not awarded after excel files have been downloaded - review your membership agreement for details.
Engineering Excel Spreadsheet Downloads
Structural Design Engineering Resources
Bolt Group Shear and Torsion in Fastened Members Excel Spreadsheet Calculator
Note: Accessing this resource requires an active Premium Membership with Engineers Edge
Download: Bolt Group Shear and Torsion in Fastened Members Excel Spreadsheet Calculator
Preview: Bolt Group Shear and Torsion in Fastened Members Excel Spreadsheet Calculator
Note, fasteners can be either pins or bolts. Up to 8 fasteners can be used.
You must enter zero for coordinates not used!
Shear Strength:
Note: This value is found from table 14-11 for pins.
For bolts, Sys=0.577Sy. See tables 14-6 and 14-7 for Sy.
Note: This is in case of no axial force, just a moment
acting alone. Enter Zero for no applied moment.
Related:
- Bolt Pattern Group Pullout Excel Spreadsheet Calculator
- Fastener, Bolt and Screw Design Torque and Force Calculation
- Design Bolted and Riveted Joints
- Eccentric Loading On Bolt Group One Vertical Row Calculator
- Structural Eccentric Loading on Bolt Group For Two Vertical Rows Calculator
- Fastener Size Thread Table
- ANSI Engineering Design Hardware Data
- ISO Metric Hardware Design Data