Concrete Design Excel Sheet2
Concrete Design Excel Sheet2
Concrete Design Excel Sheet2
Exposure 3
2.Layout 1 for B,2 for C,3 for D
Kd 0.85
Wind directionality factor table 26.6-1
heff(feet) 22.965879 Effective Height of the structure
α 11.5 Table 26.9-1 of ASCE 7-10
I 1 Table6-1 ASCE7-10
zg(feet) 700 Table 26.9-1 of ASCE 7-10
6000.0mm (19.69)ft G 0.85 ASCE 7-02 Sect.6.5.8
2.1 Section Kz 1.16 Table 27.3-1 of ASCE 7-10
0.840 1.315
0.5 40 0.109 0.85 0.13 0.98
1.900
2.875 3.500
2 40 0.154 3.65 1.45 5.1
4.000 4.500
12.750 14.000
16.000
7.92m
Area 1 30.63115 m²
Area 2 11.256025 m²
Area 3 15.315575 m²
UBC AND ACI PROVISION
PARAMETER DESIGN
B 250 mm A's
d'
H 400 mm
f'c 21 MPa
fy 400 MPa d dt
Stirrup ø10 mm H
Cover 40 mm
Es 200000 MPa As
DB ø20 mm
N 4
B
As 12.57 cm²
A's
DB ø20 mm
N 2 Note: Pls always check the manual calculation
of d,dt and d' reason of number of layer of
A's 6.28 cm² bars
1.RESULT 2.RESULT
d 294 mm Check Strenght f's
dt 324 mm f's 223.209 MPa
d' 60 mm Mn1 32.818 kN.m
1. Check Steel Ratio Mn2 91.832 kN.m
b 0.85 εt 0.007
εc 0.003 f 0.90
ρmax 0.014 fMn 112.185 kN.m
ρmin 0.003
2. Check Singly Reinforced beam
ρ 0.0171
The beam is Doubly Reinforced
ρ' 0.0085
ρt.max 0.0228
Concrete is enough
ρ 0.0171
As 12.566 cm²
3. DETERMINATION OF
COMPRESSION PARAMETERS
f1 600 MPa
εy 0.002
ρcy 0.0318
Check Compression Steel
Steel: will not yield
a 81.212 mm
c 95.544 mm
PARAMETER DESIGN
Mu 1350 kN.m A's
d'
B 400 mm
H 800 mm
f'c 25 MPa d dt
fy 390 MPa H
Stirrup ø12 mm
Cover 30 mm As
Es 200000 MPa
1.RESULT 2.RESULT
d 688 mm Concrete is enough
dt 720.5 mm Compression Steel
d' 54.5 mm DB ø28 mm
1. Check Steel Ratio N 5
b 0.85 A's 30.23 cm²
εc 0.003 Tensile Steel
ρmax 0.0174 DB ø28 mm
ρmin 0.0035 N 10
Assume As 61.57 cm²
εt 0.0092
ρ 0.011
f 0.90 Note: Pls always check the manual calculation
of d,dt and d' reason of number of layer of
2. Check Singly Reinforced beam bars
As 31.341740227 cm²
a 143.803278689 mm
c 169.180327869 mm
Mn2 753.074196184 kN.m
The beam is Doubly Reinforced
3. CASE OF DOUBLY REINFORCED
BEAM
Mn1 746.9258 kN.m
f's 390 MPa
A's 30.232 cm²
ρ' 0.011
ρt.max 0.0284
As 61.574 cm²
ρrovide 0.022
SHEAR DESIGN
d=560
Vu=390.1kN
Wu 230.8 kN/m
V0 519.3 kN øVs øVc/2=55.1kN
B 300 mm
H 620 mm øVc
f'c 27.58 MPa x=2.02m
fy 413.7 MPa
Stirrup ø10 mm
DB ø20 mm
Cover 40 mm
Es 200000 MPa 50mm
2.02m
2.25m
1.RESULT 2.RESULT
1. Concrete Shear Strength 3. Distribution of Spacing of Stirrup
d 560 mm x1 1 m
Vc 147.04666 kN Vu 288500 N
f 0.75 Vs 237620.007 N
Location of no stirrup zone S 150 mm
x 2.0200 m x2 1.5 m
Minimum Stirrup Vu 173100 N
Av 1.5707963 cm² Vs 83753.3407 N
Smax 627.86323 mm S 280 mm
Smax 600 mm No. of stirrups and spacing
Vs.min 60.651588 kN 1 @50 50mm
Location of minimum stirrup zone 6 @90 540mm
x 1.5750707 m 4 @150 600mm
2. Required Spacing of Stirrup 3 @280 840mm
Vu 390.052 kN Ok 2.03m
Vs 373.02267 kN Check Minimum Area Requirement
Concrete is enough Av 67.6818951 Ok
Spacing,s 97.556945 mm
Smax.1 600 mm
Smax.2 140 mm
S 90 mm