Column Design With Excel
Column Design With Excel
Column Design With Excel
IU
fy
3000
psi
60000
psi
10
in
2.5
Load (p)
200
kip
0.65
0.7
Steel ratio
8
0
WSD g
0.025
Amount of St. in WSD Method:
Clear Cover
CC
2.5
in
Capacity Finder
7
4.7
23
7.2
23
in2
2.5
in
1.86
in2
3000
=.40*fy
24000 psi
Let, g
0.025
Here, P
200 kip
200000 lb.
Ag:
174.29194 in2
175 in2
Breath:
13.201967 in
14 in
Dim. of Column:
14
Area of Column:
14
196 in2
0.01877 in2
So, g
0.019 in2
So, Ast
3.724
3
0.31
4.96 in
5.28 in
14 in
4.96 in
17.5 in
18 in
0.11
180 in2
18
180 in2
0.0232162
0.024
4.32 in2
Spiral Column:
P= Ag [0.25f'c + fsg
Ag
148.14815 in2
so, r is
6.8868035 in
Final Ag
g
Ast
153.9384 in2
0.0228626
3.542 in2
( WSD )
Civil Engineering
Result
10 in WSD
10 in USD
in
18 in WSD
10 in USD
2.5
Rectangular Column
No. of #
bar
0.31
No. of #
bar
0.11
2.48 in2
0 in
2.48
8
0
in2
USD Method:
in WSD
in USD
Use:
Use:
in
Tie Design
use:
use:
#
#
3
3
bar @
bar @
10 in C/C
10 in C/C
Calculations
200
Factored Load: P
Kip
3 ksi
fy
60 ksi
We Know,
Pu=.80[0.85f'c(Ag-Ast)+fyAst]
9.17
Ag
90.00009 in2
91 in2
Width:
9.539392 in
10 in
100 in2
2.2561425 in2
2.26 in2
(USD)
Breath:
9.1 in
So Dim. Of Column:
Area of Column A
10 in
10
10
100 in2
2.2561425 in2
100 in2
2.26 in2
mn:
Ag
66.85721 in2
67 in2
Area of Column = r2
Radius : r
4.6180854 in
Ag
69.397944 in2
4.7 in
70 in2
3.1095362 in2
( WSD )
78.54
149 in
7 in
154 in2
0.023
0.023
0.0228626
103545 lb
103.545 Kip
0.0236822
E-mail: humayoun6035@gmail.com
Last update: 27-08-2013
14 in WSD
10 in USD
14 in WSD
10 in USD
in
Square Column
No. of #
bar
0.31
2.48 in2
No. of #
bar
0.11
0 in2
2.48 in2
USD Method:
Circular Column
No. of #
bar
0.6
3.6 in2
No. of #
bar
0.11
0 in2
3.6 in2
USD Method:
e Design
Square. Col: WSD:
Square. Col: USD :
use:
use:
#
#
3
3
bar @
bar @
10 in C/C
10 in C/C
Capacity Finder:
Area of Steel:
7.2
in2
19.635
circu rat
6.75
484117.50
484.1175 kip
529
7.2
Tie Design
0.0136106
3
10 in
18 in
10 in
10
10
18
10
10
USD g
3
10 in
18 in
14 in
10 in
18 in
10 in
0.03
10 in
10 in
Check
f "Column Design" same as the given values of the pictures bellow then you will find all other content and va
that means " Column Design" = Check (1, 2) Then this sheet should work properly.
Check 01
Check 02
find all other content and values same as the main sheet.
Column: Columns are defined as members that carry loads chiefly in compression. Colum
member because compression force or stress dominates their behavior. Compression mem
Arch ribs
Rigid frame member
Compression member in trusses
Shells
Portion that carry axial compression
Fig: Arch
Type-3
Clear distance between longitudinal bars shall not be less than 1.5d
ACI 7.10.4: Spacing may not be less than 1 and may not be larger tha
Example 1
Design a square tied column to support an axial dead load of 400 K and a live
Solution:
1.
Column side =
11
Use fourteen no #8 bars (
Assignment:
Design a circular spiral column to support an axial dead load of 400 K and a liv
and a steel ratio of about 2.0%. Also, design the necessary spirals.
Columns loaded with axial load and uniaxial moment is designed based on fact
Mn Mu
Pn Pu
A column can be designed by solving the above two equations for a specific co
A better approach, providing the basis for practical design, is to construct a str
failure moment for a given column for the full range of eccentricities from zero
Pn
Figure: Interaction
diagram for nominal
column strength in
combined axial and
bending load.
e=
0
e small
e=
Design Aid: With a representative column design chart column can be designed
1.
a) Select trial cross section dimensions b and h
b) Calculate the ratio based on required cover distances to the bar centro
c) Calculate
and
d) From the graph, for the values found in (c), read the required reinforceme
e) Calculate the total steel area
2.
a. Select the reinforcement ratio
b. Choose a trial value of
and calculate
(a) Find the required column reinforcement for the condition that full live load a
(b) Check to ensure that the column is adequate for the condition of no live loa
Material strengths are
and
Solution:
(a) The column will be designed initially for full load, then checked for adequa
According to the ACI safety provisions, the column must be designed for a fact
a factored moment
the column perimeter will be used. Bar cover is estimated to be 2.5 in. from th
(assuming bending about the strong axis) are
and
as before. From Graph A.7 it is found that a reinforcement
less than that required in part (a), so no modification is required.
Selecting No. 3 (No. 10) ties for trial, the maximum tie spacing must not exceed,
20 in. Spacing is controlled by the diameter of the ties, and No. 3 (No. 10) ties
12 no # 9
Solution:
It is convenient to select a trial column dimension h, perpendicular to the axis
and assuming a concrete cover of 2.5 in. to the bar centers, the parameter
the stated loads the eccentricity is
and
from the trial dimension
A column
will be used, for which the required steel area is
Eight No. 11 (No. 36) bars will be used, providing
8 no # 11
Approximate method:
Where,
approximate value of nominal load in biaxial bending with eccentricities
nominal load when only eccentricity
nominal load when only eccentricity
nominal load for concentrically loaded column
Solution:
By the reciprocal load method, first considering bending about the Y axis,
With the reinforcement ratio
From which
[In general biaxial bending should be taken into account when the estim
Fig: Column
Steel contribution
Concrete contribution
of column)
ar is required when the bar s are enclosed by spaced rectangular or circular ties.
r is required when the bar s are enclosed by a continuous spiral.
mber = 1.5
bars shall not be less than 1.5db nor less than 1.5.
a local region, where as a column failure could result in the collapse of entire structure.
epends strongly on the concrete compressive strength whose quality control is very difficult in site.
dead load of 400 K and a live lode of 210 K using fc = 5 Ksi, and fy = 60 Ksi, and a steel ratio of about 5%. D
15
st of following
14 no # 8
al dead load of 400 K and a live load of 250 K using fc = 4 Ksi, fy = 60 Ksi,
necessary spirals.
ment is designed based on factored load, which must not exceed the design strength, i.e.
ty of column load
eb
e large
Mn
n chart column can be designed easily. And this can de done by two methods
ver distances to the bar centroid, and select the corresponding column design chart.
where
and
and calculate the required
load, then checked for adequacy when live load is partially removed.
mn must be designed for a factored load
A column
is specified, and reinforcement distributed arou
estimated to be 2.5 in. from the column face to the steel centerline for each bar. The column parameters
or
he ties, and No. 3 (No. 10) ties will be used at 18 in. spacing.
20
# 3 Tie @ 18 in c/c
22.5
2.5
, arranged in two layers of four bars each, similar to the sketch shown in Graph A.1
15
# 4 Tie @ 15 in c/c
22.5
loaded column
2.5
and
is present (
is present (
n
shown below is reinforced
he column perimeter, providing an area
.
ed with eccentricities
in. and ,
and
. Check Ihe adequacy of
, and
, using the average of Graphs A.6 (
, and
) and A.7 (
into account when the estimated eccentricity ratio approaches or exceeds 0.2]
ry difficult in site.
n Section
# 3 Tie @ 15 in c/c
12.5
2.5
mum live
kips and
reinforcement distributed around
The column parameters
),
E-mail: humayoun6035@gmail.c
Cell: +88 01771123050
Disclaimer
ad sheet will be able to Design rectangular, square and circular column both in USD and WSD method.
y loaded short column can be designed by this spread sheet. This sheet is following the ACI and BNBC code and
the owner. If any one wants to implement the result of this sheet in the practical field, it is their own liability.
mail: humayoun6035@gmail.com
ell: +88 01771123050