BOLTGRP.xls
 

Description:

Calculation Description:
"BOLTGRP" is a spreadsheet program written in MS-Excel for the purpose of analysis of bolt groups usingeither the ultimate strength method (also known as "instantaneous center of rotation" method) or the "elastic" (vector) method ("Alternate Method 1" in AISC Manual). There is also a worksheet for bolt stress analysis, and a separate worksheet that contains data tables for bolts.

This program is a workbook consisting of thirteen (13) worksheets, described as follows:

• Doc - Documentation sheet
• Table XI - Bolt group instantaneous center analysis for one row of bolts
• Table XII - Bolt group instantaneous center analysis for two rows spaced at 3"
• Table XIII - Bolt group instantaneous center analysis for two rows spaced at 5-1/2"
• Table XIV - Bolt group instantaneous center analysis for two rows spaced at 8"
• Table XV - Bolt group instantaneous center analysis for three rows spaced at 3"
• Table XVI - Bolt group instantaneous center analysis for three rows spaced at 6"
• Table XVII - Bolt group instantaneous center analysis for four rows spaced at 3"
• Table XVIII - Bolt group instantaneous center analysis for four rows spaced at 4"
• Bolt Group (<=25) - Bolt group elastic analysis for up to 25 total bolts and 4 load points
• Bolt Group (<=75) - Bolt group elastic analysis for up to 75 total bolts and 8 load points
• Bolt Stress - Bolt Stress Analysis for H.S. Bolts subject to tension and/or shear
• Bolt Data - Bolt Data Tables

Program Assumptions and Limitations:

1.The AISC eccentric loads on bolt groups worksheets (Tables XI through XVIII, pages 4-62 through 4-69) are applicable for only in-plane shear loads and torques (moments) on the bolt group.

2.The elastic method worksheets, "Bolt Group(<=25)" and "Bolt Group(<=75)", can be used for all cases of in-plane and out-of-plane loads on the bolt group, or where geometry limitations of the AISC Tables XI through XVIII are ecceeded.The "elastic" method (AISC "Alternate" Method 1) will always give conservative results when compared to using the AISC Tables.

3.The elastic method worksheets, "Bolt Group(<=25)" and "Bolt Group(<=75)", assume a minimum of 2 bolts and a maximum of either 25 or 75 bolts for a bolt group.

4.The elastic method worksheets, "Bolt Group(<=25)" and "Bolt Group(<=75)", assume that all the bolts contribute to the moment of inertia of the group, and the applied loads are linearly distributed among the bolts based on the location of the bolts from the centroidal axes.

5.The elastic method worksheets, "Bolt Group(<=25)" and "Bolt Group(<=75)", assume an orthogonal X-Y-Z coordinate system.All bolts and loads points MUST BE located in the "positive" (1st) quadrant."Negative" bolt or load point location coordinates are NOT permitted."Right-Hand-Rule" sign convention is used for all applied forces and moments at load point locations.

6.In the elastic method worksheets, "Bolt Group(<=25)" and "Bolt Group(<=75)", the bolts and load points can be numbered in any desired order.However, the user should make sure to either clear the contents of all spreadsheet cells that are not used for input or those cell values should be input = 0.All bolts and load points MUST BE input in proper numerical sequence with no "breaks" in the numerical order of input data.

7.The "Bolt Stress" analysis worksheet checks allowable bolt tension and bolt shear against the applied values. High strength bolts from 3/4" up through 1-1/2" diameter are assumed.Effects of fatigue are considered if required.Bolts can be in either single or double shear.AISC 9th Edition Manual (ASD) is used.

8.This program contains numerous “comment boxes” which contain a wide variety of information including explanations of input or output items, equations used, data tables, etc.(Note:presence of a “comment box” is denoted by a “red triangle” in the upper right-hand corner of a cell.Merely move the mouse pointer to the desired cell to view the contents of that particular "comment box".)

9.The Bolt Data worksheet contains 2 pages of data tables for bolt allowable tension and shear forces, bolt length determination, bolt hole dimensions, and minimum edge distances.All data is per AISC 9th Edition Manual (ASD).

Calculation Reference
AISC 9th
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Strength of Bolted Joints
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Structural Steel Designer's Handbook
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |

Version History
Check the version history to see how this calculation has changed over time. Use the Subscribe button to receive an automatic email should this calculation be updated to a higher version. Use the Favourite button so you can easily find this calculation in the future.

Submitted On:

26 Apr 2011

Submitted By:

ATomanovich

File Date:

26 Apr 2011

File Version:

2.8

File Size:

824.00 Kb

File Type:

xls

Downloads:

796

Rating:

Total Votes:13

Like this?:

More submitted by this user.

HTML Link:

Copy code below to your web page to create link to this page:

<a href="http://www.excelcalcs.com/index.php?option=com_remository&func=fileinfo&id=261">ExcelCalcs.com calculation BOLTGRP.xls</a>

HTML Window:

Copy code below to your web page to create a dynamic window to this download:

<span style="font-size: 8pt">Taken from the <a href="http://www.excelcalcs.com/index.php?option=com_remository&func=fileinfo&id=261">ExcelCalcs.com</a> website.<br /></span><iframe id="ExcelCalcsSample261" name="ExcelCalcsSample261" src="http://www.excelcalcs.com/index2.php?option=com_remository&func=fileinfo&id=261" align="top" scrolling="auto" height="650" width="100%">This option will not work correctly. Unfortunately, your browser does not support Inline Frames</iframe>

Comments  

 

#2 thiyaga 2009-02-22 03:57

nice

 

 

#1 MSH 2008-09-09 16:12

After I used, benefited, and enjoyed your spreadsheets, finally I found the time to say, "Thank you".

 

Refresh comments list
RSS feed for comments to this post

Please sign in or register to add a comment.

JComments