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.
• This excel spreadsheet may contain macros which will need to be enabled in your excel application, see web page: Enable macros in Downloaded excel files
• Units utilized within calculators are either SI or Imperial (some enable both SI and Imperial) and member (you) are responsible for conversions. Ensure that you verify units utilized in excel application meet your requirements before downloading.

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