| 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 | "BMREINF9" --- STEEL MEMBER REINFORCEMENT ANALYSIS | |||||||||||||||||||||||||
2 | ||||||||||||||||||||||||||
3 | Program Description: | |||||||||||||||||||||||||
4 | ||||||||||||||||||||||||||
5 | "BMREINF9" is a spreadsheet program written in MS-Excel for the purpose of analysis and code checking of | |||||||||||||||||||||||||
6 | steel members with various types of reinforcement configurations. Specifically, members are analyzed / code | |||||||||||||||||||||||||
7 | checked per the AISC 9th Edition Allowable Stress Design (ASD) Manual. Both actual and allowable stresses | |||||||||||||||||||||||||
8 | are computed, with the final result being a computed "stress ratio" of actual stress/allowable stress. Both the | |||||||||||||||||||||||||
9 | intermediate and end weld requirements for attaching the reinforcing to the existing member are determined. | |||||||||||||||||||||||||
10 | ||||||||||||||||||||||||||
11 | This program is a workbook consisting of nine (9) worksheets, described as follows: | |||||||||||||||||||||||||
12 | ||||||||||||||||||||||||||
13 | Worksheet Name | Description | ||||||||||||||||||||||||
14 | Doc | This documentation sheet | ||||||||||||||||||||||||
15 | Member+Plate | Analysis of Existing Member Reinforced with Plate at Bottom | ||||||||||||||||||||||||
16 | Member+WT | Analysis of Existing Member Reinforced with WT Section at Bottom | ||||||||||||||||||||||||
17 | Member+I-Beam | Analysis of Existing Member Reinforced with I-Beam at Bottom | ||||||||||||||||||||||||
18 | Member+4 Angles | Analysis of Existing Member Reinforced with 4 Symmetric Angles | ||||||||||||||||||||||||
19 | Member+4 Bars | Analysis of Existing Member Reinforced with 4 Symmetric Round Bars | ||||||||||||||||||||||||
20 | Member+2 Plates | Analysis of Existing Member Reinforced with Top & Bottom Plates | ||||||||||||||||||||||||
21 | Member+2 WT's(in) | Analysis of Existing Member Reinforced with 2 WT's (webs toed in) | ||||||||||||||||||||||||
22 | Member+2 WT's(out) | Analysis of Existing Member Reinforced with 2 WT's (webs toed out) | ||||||||||||||||||||||||
23 | ||||||||||||||||||||||||||
24 | Program Assumptions and Limitations: | |||||||||||||||||||||||||
25 | ||||||||||||||||||||||||||
26 | 1. This program follows the procedures and guidelines of the AISC 9th Edition Allowable Stress (ASD) Manual | |||||||||||||||||||||||||
27 | (1989). | |||||||||||||||||||||||||
28 | 2. This program uses the database of member dimensions and section properties from the "AISC Shapes | |||||||||||||||||||||||||
29 | Database", Version 3.0 (2001) as well as the AISC 9th Edition (ASD) Manual (1989). | |||||||||||||||||||||||||
30 | 3. This program assumes that existing member is overstressed primarily due to X-axis (strong axis) bending. | |||||||||||||||||||||||||
31 | However, the member may be also subjected to axial load (compression or tension) as well as Y-axis (minor | |||||||||||||||||||||||||
32 | axis) bending. Thus, the maximum resultant stress in the top flange of the composite section is assumed to | |||||||||||||||||||||||||
33 | be compression, while it is assumed to be tension at the bottom of the composite section. | |||||||||||||||||||||||||
34 | 4. This program addresses the concern of existing state of stress for original member by providing input of the | |||||||||||||||||||||||||
35 | "residual" X-axis (major axis) bending moment in the unreinforced member, and in some of the worksheets | |||||||||||||||||||||||||
36 | the "residual" axial load in the unreinforced member. These "residual" loads can be due to dead load alone | |||||||||||||||||||||||||
37 | or a combination of dead load and an assumed portion of the live load. | |||||||||||||||||||||||||
38 | The "residual", the added (new), and the maximum stresses for the beam are calculated as follows: | |||||||||||||||||||||||||
39 | fa(residual, mem) = P(residual, mem)/A | |||||||||||||||||||||||||
40 | fa(added) = (P(total)-P(residual, mem))/Ac | |||||||||||||||||||||||||
41 | fa(reinf) = fa(added) | |||||||||||||||||||||||||
42 | fa(mem) = fa(residual, mem) + fa(added) | |||||||||||||||||||||||||
43 | fbx(residual, mem) = Mx(residual, mem)*12/Sx | |||||||||||||||||||||||||
44 | fbx(added, reinf) = (Mx(total)-Mx(residual, mem))*12/Sxc(reinf) | |||||||||||||||||||||||||
45 | fbx(added, mem) = (Mx(total)-Mx(residual, mem))*12/Sxc(mem) | |||||||||||||||||||||||||
46 | fbx(reinf) = fbx(added, reinf) | |||||||||||||||||||||||||
47 | fbx(mem) = fbx(residual, mem) + fbx(added, mem) | |||||||||||||||||||||||||
48 | where: | A = cross sectional area of existing member alone | ||||||||||||||||||||||||
49 | Ac = cross sectional area of entire composite section | |||||||||||||||||||||||||
50 | Sx = section modulus for the existing member alone | |||||||||||||||||||||||||
51 | Sxc(reinf) = section modulus referenced to extremities of new reinforcing element(s) | |||||||||||||||||||||||||
52 | Sxc(mem) = section modulus referenced to extremities of existing member | |||||||||||||||||||||||||
53 | 5. This program prompts for the X-axis (strong axis) "cut-off" moment for the beam, which may be input as a | |||||||||||||||||||||||||
54 | value equal to the total design moment, but is more typically equal to the moment capacity of the existing | |||||||||||||||||||||||||
55 | unreinforced member. The "cut-off" moment is the moment used to determine the end weld requirements | |||||||||||||||||||||||||
56 | for the member reinforcing. | |||||||||||||||||||||||||
57 | 6. In this program for members subjected to known loadings consisting of axial load (compression or tension) | |||||||||||||||||||||||||
58 | and/or uniaxial or biaxial bending, both the actual and allowable stress are computed, with the final result | |||||||||||||||||||||||||
59 | being a computed "stress ratio" of actual stress/allowable stress. | |||||||||||||||||||||||||
60 | 7. For cases when the axial load is compression, then it is considered at the top flange of the section but it is | |||||||||||||||||||||||||
61 | not considered at the bottom of the section. When the axial load is tension, then it is not considered at the | |||||||||||||||||||||||||
62 | top flange of the section but it is considered for the bottom of the section. | |||||||||||||||||||||||||
63 | 8. In this program if beam reinforcing runs for full length, then the composite section properties will be used in | |||||||||||||||||||||||||
64 | computing both the actual and the allowable axial compressive stresses. Otherwise, only the properties of | |||||||||||||||||||||||||
65 | the original existing beam are used for reinforcing that does not run for full length of beam. (See Note #9.) | |||||||||||||||||||||||||
66 | 9. When a stiffened element (web) of a member subjected to axial compression is classified as a "slender" | |||||||||||||||||||||||||
67 | element (exceeding non-compact limits) based on local buckling criteria, then the program complies with | |||||||||||||||||||||||||
68 | AISC Appendix B. If the effective length of web for axial compression as determined by AISC Eqn. A-B5-8 is | |||||||||||||||||||||||||
69 | found to be less than the actual web length, then the area of the web to be deducted is assumed as one-half | |||||||||||||||||||||||||
70 | each side of the centroid of the existing beam for determining the effective section properties. | |||||||||||||||||||||||||
71 | 10. This program utilizes an "Allowable Stress Increase Factor" (ASIF) which is a multiplier of any of the | |||||||||||||||||||||||||
72 | calculated allowable stresses Fa, Fbx, and Fby and also the Euler column buckling stresses F'ex and F'ey. | |||||||||||||||||||||||||
73 | It is used and appears only in the stress ratio calculation. Typically a value of 1.0 may be used. However, a | |||||||||||||||||||||||||
74 | value of 1.333 may be used for load combinations which include wind or seismic loads. | |||||||||||||||||||||||||
75 | 11. If a member loaded with axial compression has a maximum slenderness ratio K*L*12/r >200, then a | |||||||||||||||||||||||||
76 | message will appear. However, this program does not consider or deem a particular member as | |||||||||||||||||||||||||
77 | "inadequate" based on the slenderness ratio of 200 being exceeded. | |||||||||||||||||||||||||
78 | 12. For the case of combined axial compression with bending, if the calculated value of fa >=F'e (which is not | |||||||||||||||||||||||||
79 | allowed) then a warning (error!) message will appear. | |||||||||||||||||||||||||
80 | 13. When the values of either 'Lx', 'Ly', or 'Lb' are input = 0' (or actually <= 1.0'), this program will use a value = 1.0'. | |||||||||||||||||||||||||
81 | 14. When the area of the top (assumed compression) flange is <= the area of the bottom (assumed tension) | |||||||||||||||||||||||||
82 | flange, then this program will not consider the use of AISC Eqn. F1-8 per Section F1.3 in determining | |||||||||||||||||||||||||
83 | the allowable X-axis bending stress, 'Fbx'. | |||||||||||||||||||||||||
84 | 15. The values of 'Cb', 'Cmx', 'Cmy', 'Kx, and 'Ky' may be calculated (if applicable) by accessing the additional | |||||||||||||||||||||||||
85 | input data to the right of the main page in each of the calculation worksheets. Then, these calculated values | |||||||||||||||||||||||||
86 | can be input under the member design parameters on the main page. (Note: there are equations which | |||||||||||||||||||||||||
87 | very closely approximate the solutions for 'Kx' and 'Ky' obtained using the AISC Code Alignment Charts.) | |||||||||||||||||||||||||
88 | 16. This program does not calculate or check shear or deflection in member. | |||||||||||||||||||||||||
89 | 17. This program does not consider torsion on member. | |||||||||||||||||||||||||
90 | 18. This program does not consider deduction for holes in members subjected to tension. | |||||||||||||||||||||||||
91 | 19. In weld design, this program determines the AISC Code minimum fillet weld as well as the maximum | |||||||||||||||||||||||||
92 | effective fillet weld size based on the shear strength of the base material. The weld size used will be the | |||||||||||||||||||||||||
93 | AISC minimum weld size, not to exceed the maximum assumed value for a single pass weld of 5/16". If the | |||||||||||||||||||||||||
94 | maximum effective fillet weld size is less than the actual size used, then the maximum effective fillet weld | |||||||||||||||||||||||||
95 | size is used to determine the actual required weld lengths. | |||||||||||||||||||||||||
96 | 20. This program contains numerous “comment boxes” which contain a wide variety of information including | |||||||||||||||||||||||||
97 | explanations of input or output items, equations used, data tables, etc. (Note: presence of a “comment box” | |||||||||||||||||||||||||
98 | is denoted by a “red triangle” in the upper right-hand corner of a cell. Merely move the mouse pointer to the | |||||||||||||||||||||||||
99 | desired cell to view the contents of that particular "comment box".) | |||||||||||||||||||||||||
100 | ||||||||||||||||||||||||||