ENDPLMC9.xls
 

Description:

"ENDPLMC9" is a spreadsheet program written in MS-Excel for the purpose of analysis and design of end plate moment connections per the AISC 9th Edition (ASD) Manual.  Specifically the program can analyze both single 4-tension bolt and 8-tension bolt configurations, as well as the conditions of having moment connections on each side of the column attached to the column flanges.

This program is a workbook consisting of five (5) worksheets, described as follows:

• Doc - Documentation sheet
• 4-Tension Bolt MC - Single 4-tension bolt end plate moment connection
• (2) 4-Tension Bolt MC's - Double 4-tension bolt end plate moment connections
• 8-Tension Bolt MC - Single 8-tension bolt end plate moment connection
• (2) 8-Tension Bolt MC's - Double 8-tension bolt end plate moment connections

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.

Program Assumptions and Limitations:

1.   This program uses the database of member dimensions and section properties from the "AISC Shapes Database", Version 3.0 (2001) as well as the AISC 9th Edition (ASD) Manual (1989).

2.   This program is based on the non-seismic specific design procedures found in the following two references:
  a. "Moment Connections - End Plate (Static Loading Only)" on pages 4-116 through 4-125 (Static Loading Only)" on pages 4-116 through 4-125, AISC 9th Edition (ASD) Manual (1989).
  b. "Extended End-Plate Moment Connections" - AISC Steel Design Guide Series #4, by Thomas M. Murray, PhD, P.E., First Edition (AISC 1990).
  c. "Stiffening of Wide-Flange Columns at Moment Connections: Wind and Seismic Applications" - AISC Steel Design Guide Series #13, by Charles J. Carter, P.E., Second Edition (AISC 2003).

3.   The original theory used assumes that prying action is negligible and that the tension flange force is equally distributed among the tension bolts.  End plates sized according to this AISC procedure herein should result in negligible prying forces at working stress.  Thick end plates will result in reduced bolt prying action and are preferred to achieve desired connection rigidity.  As a "rule-of-thumb", for end plates with thicknesses greater than or equal to the bolt diameter, prying forces need not be checked.

4.  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".)

Calculation Reference
AISC Steel Construction Manual
| 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:

11 Dec 2008

Submitted By:

ATomanovich

File Date:

11 Dec 2008

File Author:

Alex Tomanovich

File Version:

1.3

File Size:

616.50 Kb

File Type:

xls

Downloads:

654

Rating:

Total Votes:6

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=294">ExcelCalcs.com calculation ENDPLMC9.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=294">ExcelCalcs.com</a> website.<br /></span><iframe id="ExcelCalcsSample294" name="ExcelCalcsSample294" src="http://www.excelcalcs.com/index2.php?option=com_remository&func=fileinfo&id=294" 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 MSH 2008-09-09 16:24

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

 

 

#1 mdmichiels 2008-05-13 17:58

Thanks.

 

Refresh comments list
RSS feed for comments to this post

Please sign in or register to add a comment.

JComments