"Grdslab" - Concrete Slab On Grade Analysis: Program Description
"Grdslab" - Concrete Slab On Grade Analysis: Program Description
"Grdslab" - Concrete Slab On Grade Analysis: Program Description
Program Description:
"GRDSLAB" is a spreadsheet program written in MS-Excel for the purpose of analysis of concrete slabs on
grade. Specifically, a concrete slab on grade may be subjected to concentrated post or wheel loading. Then
for the given parameters, the slab flexural, bearing, and shear stresses are checked, the estimated crack width is
determined, the minimum required distribution reinforcing is determined, and the bearing stress on the dowels
at construction joints is checked. Also, design charts from the Portland Cement Association (PCA) are included
to provide an additional method for determining/checking required slab thickness for flexure. The ability to
analyze the capacity of a slab on grade subjected to continuous wall (line-type) load as well as stationary,
uniformly distributed live loads is also provided.
This program is a workbook consisting of eight (8) worksheets, described as follows:
Worksheet Name
Description
Doc
Slab on Grade
PCA Fig. 3-Wheel Load
PCA Fig. 7a-Post Load
PCA Fig. 7b-Post Load
PCA Fig. 7c-Post Load
Wall Load
Unif. Load
g. Load at interior and corner of slab distributed uniformly of a circular contact area.
h. Full contact (support) between the slab and foundation.
3. Other basic assumptions used in the flexural analysis of the "Slab on Grade" worksheet are as follows:
a. Slab viewed as a plate on a liquid foundation with full subgrade contact (subgrade modeled as a series
of independent springs - also known as "Winkler" foundation.)
b. Modulus of subgrade reaction ("k") is used to represent the subgrade.
c. Slab is considered as unreinforced concrete beam, so that any contribution made to flexural strength by
the inclusion of distribution reinforcement is neglected.
d. Combination of flexural and direct tensile stresses will result in transverse and longitudinal cracks.
e. Supporting subbase and/or subgrade act as elastic material, regaining position after application of load.
4. The "Slab on Grade" worksheet allows the user to account for the effect of an additional post or wheel load.
The increase in stress, 'i', due to a 2nd wheel (or post) load expressed as a percentage of stress for a single
wheel (or post) load generally varies between 15% to 30% as is to be input by the user.
5. All four (4) worksheets pertaining to the PCA Figures 3, 7a, 7b, and 7c from Reference (f) in item #1 above are
based on interior load condition and other similar assumptions used in the "Slab on Grade" worksheet.
Other assumed values used in the development of the Figures 3, 7a, 7b, and 7c are as follows:
a. Modulus of elasticity for concrete, Ec = 4,000,000 psi.
b. Poisson's Ratio for concrete, = 0.15.
6. In the four (4) worksheets pertaining to the PCA Figures 3, 7a, 7b, and 7c, the user must manually determine
(read) the required slab thickness from the design chart and must manually input that thickness in the
appropriate cell at the bottom of the page. An interation or two may be required, as when the slab thickness
is input, it may/may not change the effective contact area. Note: the user may unprotect the worksheet (no
password is required) and access the Drawing Toolbar (select: View, Toolbars, and Drawing) to manually
draw in (superimpose) the lines on the chart which are used to determine the required slab thickness.
7. 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 right-hand corner of a cell. Merely move the mouse pointer to the
desired cell to view the contents of that particular "comment box".)
"GRDSLAB.xls" Program
Version 1.4
###
###
###
###
###
###
###
Input Data:
Slab Thickness, t =
Concrete Strength, f 'c =
Conc. Unit Weight, wc =
Reinforcing Yield, fy =
Subgrade Modulus, k =
Concentrated Load, P =
Contact Area, Ac =
Factor of Safety, FS =
Dowel Bar Dia., db =
Dowel Bar Spacing, s =
Const. Joint Width, z =
Joint Spacing, L =
Temperature Range,T =
Increase for 2nd Wheel, i =
8.000
5000
150
60000
100
12500.00
114.00
2.00
0.750
12.000
0.2500
20.000
50.00
15
109.65
2672.86
Wheel
psi
pcf
Top/Slab
psi
pci
lbs.
Contact Area, Ac
in.^2
(Subgrade)
in.
in.
ft.
of all Dowels
deg.
%
in.
psi
psi
ft-k/ft.
in.
in.
psi
psi
psi
psi
psi
in.
psi
psi
psf
psi
in.^2/ft.
###
###
###
###
###
in.
Results:
Check Slab Flexural Stress:
Effective Load Radius, a =
6.024
Modulus of Elasticity, Ec = 4286826
Modulus of Rupture, MR =
636.40
Cracking Moment, Mr =
6.79
Poisson's Ratio, =
0.15
Radius of Stiffness, Lr =
36.985
Equivalent Radius, b =
5.648
1 Load: fb1(actual) =
267.58
2 Loads: fb2(actual) =
307.72
Fb(allow) =
318.20
Post
in.
Direction of pour
Stop slab reinf. (As) at joint
Min. of
1/8"-1/4" x t/4 formed joint
###
t/3 or 2"
t/2
fb1(actual) =
fb1(actual) =
3/4" Plain Dowels @ 12"
=
Typical Construction Joint for Load Transfer
=
(assuming unreinforced slab with interior load condition)
=
a = SQRT(Ac/)
Ec = 33*wc^1.5*SQRT(f 'c)
Check Sla
MR = 9*SQRT(f 'c)
fp(actual) =
Mr = MR*(12*t^2/6)/12000 (per 1' = 12" width)
Fp(allow) =
= 0.15 (assumed for concrete)
Lr = (Ec*t^3/(12*(1-^2)*k))^0.25
Check Sla
b = SQRT(1.6*a^2+t^2)-0.675*t , for a < 1.724*t
bo =
fb1(actual) = 3*P*(1+)/(2**t^2)*(LN(Lr/b)+0.6159) fv(actual)
(Ref. 1) =
fb2(actual) = fb1(actual)*(1+i/100)
Fv(allow) =
Fb(allow) = MR/FS
Fb(allow) >= fb(actual), O.K.
Shrinkage
(assuming working stress)
(Ref. 4)
fp(actual) = P/Ac
W=
Fp(allow) = 4.2*MR
Fp(allow) >= fp(actual), O.K. fs =
As =
(assuming working stress)
(Ref. 4)
bo = 4*SQRT(Ac) (assumed shear perimeter)
Slab Reinf
fv(actual) = P/(t*(bo+4*t))
fr =
Fv(allow) = 0.27*MR
Fv(allow) >= fv(actual), O.K. fs =
=
(assuming subgrade drag method)
(Ref. 3)
F = 1.5 (assumed friction factor between subgrade and slab)
As =
W = wc*(t/12)
fs = 0.75*fy
Slab Reinf
As = F*L*W/(2*fs)
fr =
5 of 20
01/19/2015 18:10:42
"GRDSLAB.xls" Program
Version 1.4
(continued)
6 of 20
01/19/2015 18:10:42
"GRDSLAB.xls" Program
Version 1.4
As =
(Ref. 2)
Pt
Le
Le
s
di
d4
d3
d2
d1
0*Pc
(1-(4-1)*s/Le)*Pc
(1-(3-1)*s/Le)*Pc
(1-(2-1)*s/Le)*Pc
d2
d3
d4
di
0*Pc
(1-(4-1)*s/Le)*Pc
(1-(3-1)*s/Le)*Pc
(1-(2-1)*s/Le)*Pc
1.0*Pc
=
A=
Ecm =
L=
As =
Determine
C=
=
=
L =
7 of 20
01/19/2015 18:10:42
"GRDSLAB.xls" Program
Version 1.4
#
8 of 20
01/19/2015 18:10:42
"GRDSLAB.xls" Program
Version 1.4
###
###
###
###
###
###
###
lbs.
in.^2
in.^2
psi
psi
psi
in.
9 of 20
01/19/2015 18:10:42
"GRDSLAB.xls" Program
Version 1.4
10 of 20
01/19/2015 18:10:43
"GRDSLAB.xls" Program
Version 1.4
###
###
###
###
###
###
###
76.34
636.40
212.13
16.32
10.800
in.^2
psi
psi
psi
in.
11 of 20
01/19/2015 18:10:43
"GRDSLAB.xls" Program
Version 1.4
12 of 20
01/19/2015 18:10:43
"GRDSLAB.xls" Program
Version 1.4
###
###
###
###
###
###
###
70.03
636.40
212.13
16.32
9.800
in.^2
psi
psi
psi
in.
13 of 20
01/19/2015 18:10:44
"GRDSLAB.xls" Program
Version 1.4
14 of 20
01/19/2015 18:10:44
"GRDSLAB.xls" Program
Version 1.4
###
###
###
###
###
###
###
68.02
492.95
164.32
12.64
9.200
in.^2
psi
psi
psi
in.
15 of 20
01/19/2015 18:10:44
"GRDSLAB.xls" Program
Version 1.4
16 of 20
01/19/2015 18:10:45
"GRDSLAB.xls" Program
Version 1.4
Subject:
Originator:
Slab Thickness, t =
Concrete Strength, f 'c =
Subgrade Modulus, k =
Wall Load, P =
Checker:
Wall
Input Data:
8.000
4000
100
800.00
Wall
P
in.
P
Dowel
(at Joint)
psi
###
###
###
###
###
###
###
Top/Slab
pci
=
Bx =
lb./ft.
Pc =
###
(Subgrade)
Wall
P
Top/Slab
Iteration #
##
t
##
##
##
(Subgrade)
Results:
##
MR = 9*SQRT(f 'c)
##
Fb = 1.6*SQRT(f 'c) (as recommended in reference below) ##
psi
FS = MR/Fb
##
S = b*t^2/6
#
in.^3/ft.
Ec = 57000*SQRT(f 'c)
#
psi
b = 12" (assumed)
#
in.
I = b*t^3/12
#
in.^4
= (k*b/(4*Ec*I))^(0.25)
#
Bx = coef. for beam on elastic foundation
#
#
Wall Load Near Center of Slab or Keyed/Doweled Joints:
#
Pc = 4*Fb*S*
Allowable Wall Load, Pc =
1040.30 lb./ft.
#
= 12.8*SQRT(f 'c)*t^2*(k/(19000*SQRT(f 'c)*t^3))^(0.25) #
Pc(allow) >= P, O.K. #
Wall Load Near Free Edge of Slab:
#
Pe = Fb*S*/Bx
Allowable Wall Load, Pe =
806.68
#
lb./ft.
= 9.9256*SQRT(f 'c)*t^2*(k/(19000*SQRT(f 'c)*t^3))^(0.25) #
Reference:
Pe(allow) >= P, O.K. #
"Concrete Floor Slabs on Grade Subjected to Heavy Loads"
#
Army Technical Manual TM 5-809-12, Air Force Manual AFM 88-3, Chapter 15 (1987)
#
#
Comments:
#
#
#
#
569.21
101.19
5.625
128.00
3604997
12.00
512.00
0.0201
0.3224
psi
17 of 20
01/19/2015 18:10:45
"GRDSLAB.xls" Program
Version 1.4
#
18 of 20
01/19/2015 18:10:45
"GRDSLAB.xls" Program
Version 1.4
###
###
###
###
wLL(allow) =
Input Data:
*Aisle Width
Slab Thickness, t =
Concrete Strength, f 'c =
Subgrade Modulus, k =
Factor of Safety, FS =
Uniform Live Load, wLL =
7.500
3000
800
2.000
2700.00
in.
###
###
wLL
wLL
psi
Top/Slab
pci
psf
(Subgrade)
Iteration
negative bending moment in slab may be up to twice as great
as
positive moment in slab beneath loaded area. Allowable uniform
load determined below is based on critical aisle width and as a
result, there are no restrictions on load layout configuration or
uniformity of loading.
Results:
Design Parameters:
Modulus of Rupture, MR =
Allow. Bending Stress, Fb =
Modulus of Elasticity, Ec =
Poisson's Ratio, =
Radius of Stiffness, Lr =
Critical Aisle Width, Wcr =
492.95
246.48
3122019
0.15
19.36
3.56
psi
psi
in.
ft.
MR = 9*SQRT(f 'c)
Fb = MR/FS
Ec = 57000*SQRT(f 'c)
= 0.15 (assumed for concrete)
Lr = (Ec*t^3/(12*(1-^2)*k))^0.25
Wcr = (2.209*Lr)/12
wLL(allow) = 257.876*Fb*SQRT(k*t/Ec)
wLL(allow) >= wLL, O.K.
Reference:
1. "Concrete Floor Slabs on Grade Subjected to Heavy Loads"
Army Technical Manual TM 5-809-12, Air Force Manual AFM 88-3, Chapter 15 (1987)
2. "Slab Thickness Design for Industrial Concrete Floors on Grade" (IS195.01D)
by Robert G. Packard (Portland Cement Association, 1976)
Comments:
19 of 20
#
##
##
##
##
##
##
##
##
##
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
01/19/2015 18:10:45
"GRDSLAB.xls" Program
Version 1.4
#
20 of 20
01/19/2015 18:10:45