Beam And Connections Using Clip Angles Spreadsheet
“Clip Conn Table” is a spreadsheet program written in MS-Excel for the purpose of analysis of steel beam end connections using double clip angles either welded or bolted to the beam web, and bolted to either the column flange, column web, or girder web.
The connections may be subjected to end shear reaction and/or axial load. Specifically, all applicable “limit states” for the end connection analysis pertaining to the clip angles, bolts, beam web, column flange or web, and girder web are checked. The program is presented in a “tabular” format.
This program is a workbook consisting of four (4) worksheets, described as follows:
Doc – documentation sheet
Conn Table (Welded Clips) – Clip angles welded to beam web and bolted to support
Conn Table (Bolted Clips) – Clip angles bolted to beam web and bolted to support
Conn Table (Welded or Bolted) – Clip angles either welded or bolted to beam web and bolted to support
Program Assumptions and Limitations:
1. The most critical assumption used in this program is that all beam end connections are basically “full-depth”, utilzing as many vertical rows of bolts as permitted. See first page of each worksheet for outline of other assumptions used.
2. This program is fundamentally a "plain" design variant of the "CLIPCONN.xls" program, and is the most ideal to break down an enormous number of bar end associations in an extremely speedy, effective, and succinct way. (Note: The singular case worksheets in the "CLIPCONN.xls" program were utilized as "aces computations" in the improvement of this program, and might be alluded to for individual nitty gritty estimations.)
3. When the client has embedded the expected info information in cells beginning at A408 through F408 and down for every one of the associations with be examined, then, at that point, the client ought to duplicate the column of cells from G62 through the end cell of the specific calculation sheet (either CI408, CV408, or EG408) and "Glue Exceptional" the recipes on down the worksheet to match the absolute number of associations with be dissected.
4. This program observes the strategies and rules of the AISC ninth Release Permissible Pressure (ASD) Manual (1989) and the AISC ninth Version Manual Vol. II - Associations (1992).
5. This program utilizes the data set of part aspects and area properties from the "AISC Shapes Data set", Adaptation 3.0 (2001) as well as the AISC ninth Release (ASD) Manual (1989).
6. This program expects that the pressure limit with respect "as far as possible state" is decreased by the presence of shear. For admissible bolt pressure within the sight of shear, the "communication" (consolidated burdens) is taken care of straight by the AISC Code conditions. For other "limit states" in joined burdens like bolt bearing, gross and net shear and strain, and block shear and strain tearout, the impact of "communication" is dealt with by utilization of the equation, P/Ra+(R/Rv)^2=1, as recommended from the accompanying reference:
"Joined Shear and Strain Pressure" - by Subhash C. Goel, AISC Diary, third Qtr.- 1986.
Consequently, the decrease factor applied to "as far as possible state" limit is = (1-R/Rv)^2.
where:R = genuine shear end response; Rv = admissible shear limit with regards to "as far as possible state" considered
7. This program contains various "remark boxes" which contain a wide assortment of data including clarifications of information or result things, conditions utilized, information tables, and so forth. (Note: presence of a "remark box" is meant by a "red triangle" in the upper right-hand corner of a cell. Simply move the mouse pointer to the ideal cell to see the items in that specific "remark box".)
.png)
0 Comments