BMREINF9.xls
 

Description:

"BMREINF9" is a spreadsheet program written in MS-Excel for the purpose of analysis and code checking of steel members with various types of reinforcement configurations.  Specifically, members are analyzed / code checked per the AISC 9th Edition Allowable Stress Design (ASD) Manual.  Both actual and allowable stresses are computed, with the final result being a computed "stress ratio" of actual stress/allowable stress.  Both the
intermediate and end weld requirements for attaching the reinforcing to the existing member are determined.

This program is a workbook consisting of nine (9) worksheets, described as follows:

Worksheet NameDescription

• Doc - Documentation sheet
• Member+Plate - Analysis of Existing Member Reinforced with Plate at Bottom
• Member+WT - Analysis of Existing Member Reinforced with WT Section at Bottom
• Member+I-Beam - Analysis of Existing Member Reinforced with I-Beam at Bottom
• Member+4 Angles - Analysis of Existing Member Reinforced with 4 Symmetric Angles
• Member+4 Bars - Analysis of Existing Member Reinforced with 4 Symmetric Round Bars
• Member+2 Plates - Analysis of Existing Member Reinforced with Top & Bottom Plates
• Member+2 WT's(in) - Analysis of Existing Member Reinforced with 2 WT's (webs toed in)
• Member+2 WT's(out) - Analysis of Existing Member Reinforced with 2 WT's (webs toed out)

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 follows the procedures and guidelines of the AISC 9th Edition Allowable Stress (ASD) Manual (1989).

2.   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).

3.   This program assumes that existing member is overstressed primarily due to X-axis (strong axis) bending. However, the member may be also subjected to axial load (compression or tension) as well as Y-axis (minor axis) bending.  Thus, the maximum resultant stress in the top flange of the composite section is assumed to be compression, while it is assumed to be tension at the bottom of the composite section.

4.   This program addresses the concern of existing state of stress for original member by providing input of the "residual" X-axis (major axis) bending moment in the unreinforced member, and in some of the worksheets the "residual" axial load in the unreinforced member.  These "residual" loads can be due to dead load alone or a combination of dead load and an assumed portion of the live load. The "residual", the added (new), and the maximum stresses for the beam are calculated as follows:
      fa(residual, mem) = P(residual, mem)/A
      fa(added) = (P(total)-P(residual, mem))/Ac
      fa(reinf) = fa(added)
      fa(mem) = fa(residual, mem) + fa(added)
      fbx(residual, mem) = Mx(residual, mem)*12/Sx
      fbx(added, reinf) = (Mx(total)-Mx(residual, mem))*12/Sxc(reinf)
      fbx(added, mem) = (Mx(total)-Mx(residual, mem))*12/Sxc(mem)
      fbx(reinf) = fbx(added, reinf)
      fbx(mem) = fbx(residual, mem) + fbx(added, mem)
      where:A = cross sectional area of existing member alone
      Ac = cross sectional area of entire composite section
      Sx = section modulus for the existing member alone
      Sxc(reinf) = section modulus referenced to extremities of new reinforcing element(s)
      Sxc(mem) = section modulus referenced to extremities of existing member

5.   This program prompts for the X-axis (strong axis) "cut-off" moment for the beam, which may be input as a value equal to the total design moment, but is more typically equal to the moment capacity of the existing unreinforced member.  The "cut-off" moment is the moment used to determine the end weld requirements for the member reinforcing.

6.   In this program for members subjected to known loadings consisting of axial load (compression or tension) and/or uniaxial or biaxial bending, both the actual and allowable stress are computed, with the final result being a computed "stress ratio" of actual stress/allowable stress.

7.   For cases when the axial load is compression, then it is considered at the top flange of the section but it is not considered at the bottom of the section.  When the axial load is tension, then it is not considered at the top flange of the section but it is considered for the bottom of the section.

8.   In this program if beam reinforcing runs for full length, then the composite section properties will be used in computing both the actual and the allowable axial compressive stresses.  Otherwise, only the properties of the original existing beam are used for reinforcing that does not run for full length of beam.  (See Note #9.)

9.  When a stiffened element (web) of a member subjected to axial compression is classified as a "slender" element (exceeding non-compact limits) based on local buckling criteria, then the program complies with AISC Appendix B.  If the effective length of web for axial compression as determined by AISC Eqn. A-B5-8 is found to be less than the actual web length, then the area of the web to be deducted is assumed as one-half each side of the centroid of the existing beam for determining the effective section properties.

10. This program utilizes an "Allowable Stress Increase Factor" (ASIF) which is a multiplier of any of the calculated allowable stresses Fa, Fbx, and Fby and also the Euler column buckling stresses F'ex and F'ey. It is used and appears only in the stress ratio calculation.  Typically a value of 1.0 may be used.  However, a value of 1.333 may be used for load combinations which include wind or seismic loads.

11. If a member loaded with axial compression has a maximum slenderness ratio K*L*12/r >200, then a message will appear.  However, this program does not consider or deem a particular member as "inadequate" based on the slenderness ratio of 200 being exceeded.

12. For the case of combined axial compression with bending, if the calculated value of fa >=F'e (which is not allowed) then a warning (error!) message will appear.

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'.

14. When the area of the top (assumed compression) flange is <= the area of the bottom (assumed tension) flange, then this program will not consider the use of AISC Eqn. F1-8 per Section F1.3 in determining the allowable X-axis bending stress, 'Fbx'.

15. The values of 'Cb', 'Cmx', 'Cmy', 'Kx, and 'Ky' may be calculated (if applicable) by accessing the additional input data to the right of the main page in each of the calculation worksheets.  Then, these calculated values can be input under the member design parameters on the main page.  (Note: there are equations which very closely approximate the solutions for 'Kx' and 'Ky' obtained using the AISC Code Alignment Charts.)

16. This program does not calculate or check shear or deflection in member.

17. This program does not consider torsion on member.

18. This program does not consider deduction for holes in members subjected to tension.

19. In weld design, this program determines the AISC Code minimum fillet weld as well as the maximum effective fillet weld size based on the shear strength of the base material.  The weld size used will be the AISC minimum weld size, not to exceed the maximum assumed value for a single pass weld of 5/16".  If the maximum effective fillet weld size is less than the actual size used, then the maximum effective fillet weld  size is used to determine the actual required weld lengths.

20. 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
| 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:

04 Dec 2008

Submitted By:

ATomanovich

File Date:

04 Dec 2008

File Author:

Alex Tomanovich

File Version:

1.9

File Size:

1,753.50 Kb

File Type:

xls

Downloads:

717

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=259">ExcelCalcs.com calculation BMREINF9.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=259">ExcelCalcs.com</a> website.<br /></span><iframe id="ExcelCalcsSample259" name="ExcelCalcsSample259" src="http://www.excelcalcs.com/index2.php?option=com_remository&func=fileinfo&id=259" align="top" scrolling="auto" height="650" width="100%">This option will not work correctly. Unfortunately, your browser does not support Inline Frames</iframe>

Comments  

 

#3 mhmd10 2010-11-21 15:49

Thankssssssssss s....

 

 

#2 mjmce 2008-12-10 00:40

Great time saver.

 

 

#1 MSH 2008-09-09 16:11

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