BOLTGRP.xls
 
This Download is for Registered Users Only.
Please login or Register (free plans available).

Description:

"BOLTGRP.xls" is a MS-Excel spreadsheet workbook for analyzing bolt groups. There are 8 worksheets which replicate the AISC 9th Edition Manual Tables XI thru XVIII to be used for analysis. There are 2 worksheets for analysis by the elastic method, one for bolt groups of up to 25 bolts and another for bolt groups of up to 75 bolts. These 2 worksheets allow the user to input axial, shear, and moment loadings. Both of the elastic method worksheets have user input for bolt coordinates, and the bolt group is plotted to aid in verifying the group configuration. There is also built-in capability to facilitate the user input of circular bolt groups.

There is another worksheet for general bolts stress analysis, including combined tension and shear. Finally there is a worksheet containing data and tables replicated from the AISC 9th Edition Manual.

All the worksheets are independent and self contained, so that you can move them from one workbook to another. All the worksheets are protected, but not with a password.

Please read the "DOC" worksheet for program details as well as assumptions and limitations.

Calculation Reference
AISC
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |

Forum Link

Comment upon or discuss this document in the Forum

Submitted On:

02 Dec 2008

Submitted By:

ATomanovich

File Date:

02 Dec 2008

File Version:

v2.7

File Size:

810.00 Kb

File Type:

xls

Downloads:

707

Rating:

Total Votes:9

Comments:

MSH 2008-09-09 16:12:24 After I used, benefited, and enjoyed your spreadsheets, finally I found the time to say, "Thank you".

thiyaga 2009-02-22 03:57:07 nice