You have downloaded this file 0 times in the last 24 hours, limit is 100.
Your file downloads total 0 in the last 24 hours, limit is 20.
RECTBEAM (31811).xls
This location is for Registered Users Only.
Perhaps you need to login or register.
 Description:

"RECTBEAM" is a spreadsheet program written in MSExcel for the purpose of analysis/design of rectangular beam or column sections. Specifically, the ultimate moment capacity, bar spacing for crack control, moments of inertia for deflection, beam shear and torsion requirements, and member capacity for flexure (uniaxial and biaxial) with axial load are calculated. There is also a worksheet which contains reinforcing bar data tables. This version is based on the ACI 31811 Code.
This program is a workbook consisting of twelve (12) worksheets, described as follows:
Worksheet NameDescriptionDoc  DescriptionComplete Analysis  Beam flexure, shear, crack control, and inertiaFlexure  Ultimate moment capacity of singly or doubly reinforced beams/sectionsCrack Control  Crack control  distribution of flexural reinforcingShear  Beam or oneway type shearTorsion  Beam torsion and shearInertia  Moments of inertia of singly or doubly reinforced beams/sectionsUniaxial  Combined uniaxial flexure and axial loadBiaxial  Combined biaxial flexure and axial loadSlenderness (Sidesway)  Estimate of slenderness effects for column with sideswayCRSI Column Formulas  CRSI Universal Column Formulas (reference)Rebar Data  Reinforcing bar data tables
Program Assumptions and Limitations:
1. This program follows the procedures and guidelines of the ACI 31811 Building Code.2. This program utilizes the following references:a. "Design of Reinforced Concrete" (Ninth Edition) (for ACI 31811), by Jack C. McCormac & Russell H. Brownb. "Notes of the ACI 31811 Building Code Requirements for Structural Concrete" (Twelfth Edition), by PCA3. The "Complete Analysis" worksheet combines the analyses performed by four (4) of the individual worksheets all into one. This includes member flexural moment capacity, as well as shear, crack control, and inertia calculations. Thus, any items below pertaining to any of the similar individual worksheets included in this one are also applicable here.4. In the "Flexure", "Uniaxial", and "Biaxial" worksheets, when the calculated distance to the neutral axis, 'c', is less than the distance to the reinforcement nearest the compression face, the program will ignore that reinforcing and calculate the ultimate moment capacity based on an assumed singlyreinforced section.5. In the "Uniaxial" and "Biaxial" worksheets, the CRSI "Universal Column Formulas" are used by this program to determine Points #1 through #7 of the 10 point interaction curve. For the most part, these formulas yield close, yet approximate results. However, these results should be accurate enough for most applications and situations.6. To account for the fact that the CRSI "Universal Column Formulas" originally utilized f =0.70 for compression, which was applicable up through the ACI 31899 Code, they have been factored by (0.65/0.70) to account for the reduction in the factor f = 0.65 for compression beginning with ACI 31802 Code and continuing through the ACI 31811 Code. This modification has been made to the equations applicable to Points #1 through #7.7. In the "Uniaxial" and "Biaxial" worksheets, the CRSI "Universal Column Formulas", which are used by this program, assume the use of the reinforcing yield strength, fy =60 ksi.8. In the "Uniaxial" and "Biaxial" worksheets, this program assumes a "short", nonslender rectangular column with symmetrically arranged and sized bars.9. In the "Uniaxial" and "Biaxial" worksheets, for cases with axial load only (compression or tension) and no moment(s) the program calculates total reinforcing area as follows:Ast = (Ntb*Abt) + (Nsb*Abs) , where: Abt and Abs = area of one top/bottom and side bar respectively.10. In the "Uniaxial" and "Biaxial" worksheets, for pure moment capacity with no axial load, the program assumes bars in 2 outside faces parallel to axis of bending plus 50% of the total area of the side bars divided equally by and added to the 2 outside faces, and program calculates reinforcing areas as follows:for Xaxis: As = A's = ((Ntb*Abt) + (0.50*Nsb*Abs))/2for Yaxis: As = A's = ((Nsb*Asb+4*Atb) + (0.50*(Ntb4)*Atb))/211. In the "Uniaxial" and "Biaxial" worksheets, for Point #8 (fPn = 0.1*f'c*Ag) on the interaction curve the corresponding value of fMn is determined from interpolation between the moment values at Point #7 (balanced condition, f = 0.65) and Point #9 (pure flexure, f <= 0.90).12. In the "Complete Analysis" and "Flexure" worksheets as well as the "Uniaxial" and "Biaxial" worksheets (for Point #9, pure flexure) the program first determines the strain in tension reinforcing (et), then the capacity reduction factor (f),and finally ultimate moment capacity (fMn) based on actual input reinforcing.a. For et >= 0.005 ("tensioncontrolled" section): f = 0.90.b. For fy/Es < et < 0.005 ("transition" section): f = 0.65+0.25*(etfy/Es)/(0.005fy/Es) < 0.90 (Es=29000 ksi)c. For et <= fy/Es ("compressioncontrolled" section): f = 0.65Note: Beginning with the ACI 31802 Code and continuing through the ACI 31811 Code, it is required that the strain in the tension reinforcing (et) >= 0.004 for both singly and doubly reinforced sections.13. In the "Uniaxial" and "Biaxial" worksheets, design capacities, fPn and fMn, at design eccentricity, e = Mu*12/Pu, are determined from interpolation within the interaction curve for the applicable axis.14. In the "Biaxial" worksheet, the biaxial capacity is determined by the following approximations:a. For Pu >= 0.1*f'c*Ag, use Bresler Reciprocal Load equation:1/fPn = 1/fPnx + 1/fPny  1/fPoBiaxial interaction stress ratio, S.R. = Pu/fPn <= 1b. For Pu < 0.1*f'c*Ag, use Bresler Load Contour interaction equation:Biaxial interaction stress ratio, S.R. = (Mux/fMnx)^1.15 + (Muy/fMny)^1.15 <= 115. The "Slenderness (Sidesway)" worksheet allows the user to perform a quick, conservative estimate of the slenderness effects for a column subject to sidesway. This worksheet is very well suited for analysis of a pier of a foundation, where there is either no supporting soil around the pier or where the soil is considered inadequate to provide continuous lateral support for the pier.The following is a list of assumptions used in the worksheet:a. Single column is not braced, and thus is subject to sidesway.b. All of moment is due to sway, thus entire moment gets magnified (conservative).c. Use I = 0.35*Ig/(1+bds), where bds varies between 0 and 1.0 (using 1.0 is conservative).d. Ultimate axial load, Pu, must be < 0.75*Pc, otherwise resize column.e. Use k = 2.1 for foundation pier with top free and bottom fixed.f. For foundation pier with no or inadequate soil support, use Lu = Pier height.g. For foundation pier with adequate soil support for full height, Lu = 0 (thus, "short" column).16. The "Rebar Data" worksheet contains tables of reinforcing bar data which include various bar properties, reinforcing bar areas based on spacing, and various plain welded wire fabric properties.17. 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 righthand corner of a cell. Merely move the mouse pointer to the desired cell to view the contents of that particular "comment box".)Calculation Reference
Reinforced Concrete
Structural Design
ACI 31811
 Submitted By:
 Alex Tomanovich (ATomanovich)
 Submitted On:
 19 Oct 2016
 File Size:
 1,048.00 Kb
 Downloads:
 205
 File Version:
 1.1
 File Author:
 Alex Tomanovich
 Rating:
Comments: 2
×
3 years ago
I just noticed yesterday that in the "DOC" worksheet of the updated "RECTBEAM (31811).xls" workbook that I sent out last week, I had a typo error. In describing the number of worksheets in the workbook, the text read "twelve (112)" when it should have obviously been "twelve (12)".
Since this was so minor I did not bother changing the version number, but I did want to make the correction.
Since this was so minor I did not bother changing the version number, but I did want to make the correction.
We have 194 guests and 5 members online