| 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 | "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 Name | Description | ||||||||||||||||||||||||
14 | Doc | This documentation sheet | ||||||||||||||||||||||||
15 | Complete Analysis | Beam 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 Control | Crack control - distribution of flexural reinforcing | ||||||||||||||||||||||||
19 | Shear | Beam or one-way type shear | ||||||||||||||||||||||||
20 | Torsion | Beam torsion and shear | ||||||||||||||||||||||||
21 | Inertia | Moments of inertia of singly or doubly reinforced beams/sections | ||||||||||||||||||||||||
22 | Uniaxial | Combined uniaxial flexure and axial load | ||||||||||||||||||||||||
23 | Biaxial | Combined biaxial flexure and axial load | ||||||||||||||||||||||||
24 | Rebar Data | Reinforcing 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 | ||||||||||||||||||||||||||