A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | "BEAMCOL9" --- STEEL BEAM AND COLUMN ANALYSIS / CODE CHECK | |||||||||||||||||||||||||
2 | ||||||||||||||||||||||||||
3 | Program Description: | |||||||||||||||||||||||||
4 | ||||||||||||||||||||||||||
5 | "BEAMCOL9" is a spreadsheet program written in MS-Excel for the purpose of analysis and code checking of | |||||||||||||||||||||||||
6 | steel beams and columns. Specifically, beams and columns are analyzed / code checked per the AISC 9th | |||||||||||||||||||||||||
7 | Edition Allowable Stress Design (ASD) Manual. Both actual and allowable stresses are computed, with the | |||||||||||||||||||||||||
8 | final result being a computed "stress ratio" of actual stress/allowable stress. Also, a list of the lightest weight | |||||||||||||||||||||||||
9 | members which satisfy the code check is displayed for convenience. | |||||||||||||||||||||||||
10 | ||||||||||||||||||||||||||
11 | This program is a workbook consisting of six (6) worksheets, described as follows: | |||||||||||||||||||||||||
12 | ||||||||||||||||||||||||||
13 | Worksheet Name | Description | ||||||||||||||||||||||||
14 | Doc | This documentation sheet | ||||||||||||||||||||||||
15 | BeamCol(I) | Analysis / Code Check for W, S, M, and HP Shapes | ||||||||||||||||||||||||
16 | BeamCol(Built-Up) | Analysis / Code Check for Non-Database and Built-Up Shapes | ||||||||||||||||||||||||
17 | BeamCol(C) | Analysis / Code Check for Channel Shapes | ||||||||||||||||||||||||
18 | BeamCol(Tube) | Analysis / Code Check for Rectangular HSS (Tube) Shapes | ||||||||||||||||||||||||
19 | BeamCol(Pipe) | Analysis / Code Check for Round HSS and Pipe Shapes | ||||||||||||||||||||||||
20 | ||||||||||||||||||||||||||
21 | Program Assumptions and Limitations: | |||||||||||||||||||||||||
22 | ||||||||||||||||||||||||||
23 | 1. This program follows the procedures and guidelines of the AISC 9th Edition Allowable Stress (ASD) Manual | |||||||||||||||||||||||||
24 | (1989). | |||||||||||||||||||||||||
25 | 2. This program uses the database of member dimensions and section properties from the "AISC Shapes | |||||||||||||||||||||||||
26 | Database", Version 3.0 (2001) as well as the AISC 9th Edition (ASD) Manual (1989). | |||||||||||||||||||||||||
27 | 3. The "BeamCol(Built-Up)" worksheet is valid for AISC W, S, M, and HP shapes NOT contained in the AISC 9th | |||||||||||||||||||||||||
28 | Edition Manual, as well as for non-hybird and doubly-symmetrical ("I" shaped) built-up members which have | |||||||||||||||||||||||||
29 | their flanges continuously welded to the web and which DO NOT quailify as plate girders. | |||||||||||||||||||||||||
30 | (Note: the AISC Code limiting value on the web for built-up beams not to qualify as plate girders is as follows: | |||||||||||||||||||||||||
31 | (d-2*tf)/tw <= 760/SQRT(0.60*Fy) | |||||||||||||||||||||||||
32 | 4. This program is NOT valid for tees (WT shapes) and angles. | |||||||||||||||||||||||||
33 | 5. In this program for members subjected to known loadings consisting of axial load (compression or tension) | |||||||||||||||||||||||||
34 | and/or uniaxial or biaxial bending, both the actual and allowable stress are computed, with the final result | |||||||||||||||||||||||||
35 | being a computed "stress ratio" of actual stress/allowable stress. | |||||||||||||||||||||||||
36 | 6. The "BeamCol(Built-Up)" worksheet will require the input for the total depth, web thickness, flange width, and | |||||||||||||||||||||||||
37 | flange thickness. Then, all the remaining section properties are automatically calculated, assuming straight, | |||||||||||||||||||||||||
38 | non-sloping flanges. | |||||||||||||||||||||||||
39 | 7. This program utilizes an "Allowable Stress Increase Factor" (ASIF) which is a multiplier of any of the | |||||||||||||||||||||||||
40 | calculated allowable stresses Fa, Fbx, and Fby and also the Euler column buckling stresses F'ex and F'ey. | |||||||||||||||||||||||||
41 | It is used and appears ONLY in the stress ratio calculation. Typically a value of 1.0 may be used. However, a | |||||||||||||||||||||||||
42 | value of 1.333 may be used for load combinations which include wind or seismic loads. | |||||||||||||||||||||||||
43 | 8. If an axially loaded compression member has a value of the maximum slenderness ratio K*L*12/r >200, | |||||||||||||||||||||||||
44 | then a message will appear. However, this program DOES NOT consider or deem a particular member as | |||||||||||||||||||||||||
45 | "inadequate" based on the slenderness ratio of 200 being exceeded. | |||||||||||||||||||||||||
46 | 9. For the case of combined axial compression with bending, if the calculated value of fa >=F'e (which is not | |||||||||||||||||||||||||
47 | allowed) then a warning (error!) message will appear. | |||||||||||||||||||||||||
48 | 10. When the values of either 'Lx', 'Ly', or 'Lb' are input = 0' (or actually <= 1.0'), this program will use a value = 1.0'. | |||||||||||||||||||||||||
49 | 11. When a stiffened element (web) of a member subjected to axial compression is classified as a "slender" | |||||||||||||||||||||||||
50 | element (exceeding non-compact limits) based on local buckling criteria, then the program complies with | |||||||||||||||||||||||||
51 | AISC Appendix B. | |||||||||||||||||||||||||
52 | 12. In the "BeamCol(C)" worksheet for channels subjected to Y-axis bending, the properties database uses the | |||||||||||||||||||||||||
53 | minimum value of 'Sy'. However, it is desired to calculate the bending stress at the back of the channel | |||||||||||||||||||||||||
54 | instead of at the tips of the flanges, this may be done by computing a "reduced effective" Y-axis bending | |||||||||||||||||||||||||
55 | moment, Mye = My*Sy*(xbar)/Iy , for member loading input. | |||||||||||||||||||||||||
56 | 13. The values of 'Cb', 'Cmx', 'Cmy', 'Kx, and 'Ky' may be calculated (if applicable) by accessing the additional | |||||||||||||||||||||||||
57 | input data to the right of the main page in each of the calculation worksheets. Then, these calculated values | |||||||||||||||||||||||||
58 | can be input under the member design parameters on the main page. (Note: there are equations which | |||||||||||||||||||||||||
59 | very closely approximate the solutions for 'Kx' and 'Ky' obtained using the AISC Code Alignment Charts.) | |||||||||||||||||||||||||
60 | 14. This program does not calculate or check shear or deflection in member | |||||||||||||||||||||||||
61 | 15. This program does not consider torsion on member. | |||||||||||||||||||||||||
62 | 16. This program does not consider deduction for holes in members subjected to tension. | |||||||||||||||||||||||||
63 | 17. This program contains numerous “comment boxes” which contain a wide variety of information including | |||||||||||||||||||||||||
64 | explanations of input or output items, equations used, data tables, etc. (Note: presence of a “comment box” | |||||||||||||||||||||||||
65 | is denoted by a “red triangle” in the upper right-hand corner of a cell. Merely move the mouse pointer to the | |||||||||||||||||||||||||
66 | desired cell to view the contents of that particular "comment box".) | |||||||||||||||||||||||||
67 | ||||||||||||||||||||||||||
68 | ||||||||||||||||||||||||||
69 | ||||||||||||||||||||||||||
70 | ||||||||||||||||||||||||||
71 | ||||||||||||||||||||||||||
72 | ||||||||||||||||||||||||||
73 | ||||||||||||||||||||||||||
74 | ||||||||||||||||||||||||||
75 | ||||||||||||||||||||||||||
76 | ||||||||||||||||||||||||||
77 | ||||||||||||||||||||||||||
78 | ||||||||||||||||||||||||||
79 | ||||||||||||||||||||||||||
80 | ||||||||||||||||||||||||||
81 | ||||||||||||||||||||||||||
82 | ||||||||||||||||||||||||||
83 | ||||||||||||||||||||||||||
84 | ||||||||||||||||||||||||||
85 | ||||||||||||||||||||||||||
86 | ||||||||||||||||||||||||||
87 | ||||||||||||||||||||||||||
88 | ||||||||||||||||||||||||||
89 | ||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||
92 | ||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||
100 |