ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
"RECTBEAM" --- RECTANGULAR CONCRETE BEAM ANALYSIS/DESIGN
2
3
Program Description:
4
5
"RECTBEAM" is a spreadsheet program written in MS-Excel for the purpose of analysis/design of rectangular
6
beam or column sections. Specifically, the required flexural reinforcing, ultimate moment capacity, bar spacing
7
for crack control, moments of inertia for deflection, beam shear and torsion requirements, and member capacity
8
for flexure (uniaxial and biaxial) with axial load are calculated. There is also a worksheet which contains
9
reinforcing bar data tables. This version is based on the ACI 318-05 Code.
10
11
This program is a workbook consisting of eleven (11) worksheets, described as follows:
12
13
Worksheet NameDescription
14
DocThis documentation sheet
15
Complete AnalysisBeam flexure, shear, crack control, and inertia
16
Flexure(As)Flexural reinforcing for singly or doubly reinforced beams/sections
17
Flexure(Mn)Ultimate moment capacity of singly or doubly reinforced beams/sections
18
Crack ControlCrack control - distribution of flexural reinforcing
19
ShearBeam or one-way type shear
20
TorsionBeam torsion and shear
21
InertiaMoments of inertia of singly or doubly reinforced beams/sections
22
UniaxialCombined uniaxial flexure and axial load
23
BiaxialCombined biaxial flexure and axial load
24
Rebar DataReinforcing bar data tables
25
26
Program Assumptions and Limitations:
27
28
1. This program follows the procedures and guidelines of the ACI 318-05 Building Code.
29
2. The "Complete Analysis" worksheet combines the analyses performed by four (4) of the individual
30
worksheets all into one. This includes member flexural moment capacity, as well as shear, crack control,
31
and inertia calculations. Thus, any items below pertaining to any of the similar individual worksheets
32
included in this one are also applicable here.
33
3. In the "Flexure(As)" worksheet, the program will display a message if compression reinforcing is required,
34
when the beam/section cannot handle the ultimate design moment with tension reinforcing only. Then a
35
doubly-reinforced design is performed.
36
4. In the "Flexure(As)" worksheet for a singly reinforced beam/section, when the required flexural reinforcing is
37
less than the Code minimum, then the program will use the lesser value of either 4/3 times the required value
38
or the minimum value as the amount to actually use for design.
39
5. In the "Flexure(Mn)", "Uniaxial", and "Biaxial" worksheets, when the calculated distance to the neutral axis, 'c',
40
is less than the distance to the reinforcement nearest the compression face, the program will ignore that
41
reinforcing and calculate the ultimate moment capacity based on an assumed singly-reinforced section.
42
6. In the "Uniaxial" and "Biaxial" worksheets, the CRSI "Universal Column Formulas" are used by this program
43
to determine Points #1 through #7 of the 10 point interaction curve. For the most part, these formulas yield
44
close, yet approximate results. However, these results should be accurate enough for most applications
45
and situations.
46
7. To account for the fact that the CRSI "Universal Column Formulas" originally utilized f =0.70 for compression,
47
which was applicable up through the ACI 318-99 Code, they have been factored by (0.65/0.70) to account for
48
the reduction in the factor f = 0.65 for compression beginning with ACI 318-02 Code and continuing with the
49
ACI 318-05 Code. This modification has been made to the equations applicable to Points #1 through #7.
50
8. In the "Uniaxial" and "Biaxial" worksheets, the CRSI "Universal Column Formulas", which are used by this
51
program, assume the use of the reinforcing yield strength, fy =60 ksi.
52
9. In the "Uniaxial" and "Biaxial" worksheets, this program assumes a "short", non-slender rectangular column
53
with symmetrically arranged and sized bars.
54
10. In the "Uniaxial" and "Biaxial" worksheets, for cases with axial load only (compression or tension) and no
55
moment(s) the program calculates total reinforcing area as follows:
56
Ast = (Ntb*Abt) + (Nsb*Abs) , where: Abt and Abs = area of one top/bottom and side bar respectively.
57
11. In the "Uniaxial" and "Biaxial" worksheets, for pure moment capacity with no axial load, the program assumes
58
bars in 2 outside faces parallel to axis of bending plus 50% of the total area of the side bars divided equally
59
by and added to the 2 outside faces, and program calculates reinforcing areas as follows:
60
for X-axis: As = A's = ((Ntb*Abt) + (0.50*Nsb*Abs))/2
61
for Y-axis: As = A's = ((Nsb*Asb+4*Atb) + (0.50*(Ntb-4)*Atb))/2
62
12. In the "Uniaxial" and "Biaxial" worksheets, for Point #8 (fPn = 0.1*f'c*Ag) on the interaction curve the
63
corresponding value of fMn is determined from interpolation between the moment values at Point #7
64
(balanced condition, f = 0.65) and Point #9 (pure flexure, f = 0.90).
65
13. In the "Uniaxial" and "Biaxial" worksheets, design capacities, fPn and fMn, at design eccentricity,
66
e = Mu*12/Pu, are determined from interpolation within the interaction curve for the applicable axis.
67
14. In the "Biaxial" worksheet, the biaxial capacity is determined by the following approximations:
68
a. For Pu >= 0.1*f'c*Ag, use Bresler Reciprocal Load equation:
69
1/fPn = 1/fPnx + 1/fPny - 1/fPo
70
Biaxial interaction stress ratio, S.R. = Pu/fPn <= 1
71
b. For Pu < 0.1*f'c*Ag, use Bresler Load Contour interaction equation:
72
Biaxial interaction stress ratio, S.R. = (Mux/fMnx)^1.15 + (Muy/fMny)^1.15 <= 1
73
15. The "Rebar Data" worksheet contains tables of reinforcing bar data which include various bar properties,
74
reinforcing bar areas based on spacing, and various plain welded wire fabric properties.
75
16. This program contains numerous “comment boxes” which contain a wide variety of information including
76
explanations of input or output items, equations used, data tables, etc. (Note: presence of a “comment box”
77
is denoted by a “red triangle” in the upper right-hand corner of a cell. Merely move the mouse pointer to the
78
desired cell to view the contents of that particular "comment box".)
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100