"Deckslab" - Slab On Metal Deck Analysis / Design: Program Description
"Deckslab" - Slab On Metal Deck Analysis / Design: Program Description
"Deckslab" - Slab On Metal Deck Analysis / Design: Program Description
Program Description:
"DECKSLAB" is a spreadsheet program written in MS-Excel for the purpose of analysis and design of slabs on
metal deck. Both composite deck slabs and form deck slabs can be analyzed and designed for 3 different
loading conditions. Specifically, the flexural moment capacity for both positive and negative strong axis
moments, one-way beam shear, punching shear, and deflection are all evaluated and checked. Also, for
concentrated loads, the effective slab strip widths for both moment and beam shear are determined. There is
information on the metal deck properties, as well as reinforcing bar and welded wire fabric data tables.
3 of 22 04/03/2020 14:02:25
"DECKSLAB.xls" Program
Version 1.4
fVnt =
Beam Shear in Deck as a Form Only for Construction Loads: Vu =
fVd = 4.16 kips fVd = beam shear capacity of deck alone (LRFD value from SDI Table)
Vu = 0.496 kips Vu = (1.6*Wc+1.2*Wd+1.4*W2)/1000*0.625*L S.R. =
Vu <= Allow., O.K. Deflection for
Shear and Negative Moment Interaction in Deck as a Form Only for Construction Loads: wa(LL) =
S.R. = 0.472 S.R. = (Vu/fVd)^2+(Mu/(Fb(allow)*Sn/12))^2 S.R. <= 1.0, O.K.
Web Crippling (End Bearing) in Deck as a Form Only for Construction Loads: D(LL) =
fRd = 4.220 kips fRd = beam shear capacity of deck alone (LRFD value from SDI Table)D(ratio) =
Rui = 0.745 kips Rui = ((1.6*Wc+1.2*Wd+1.4*W2)/1000*1.25*L)*0.75 (allowing 1/3 increase)
Ri <= Rd, O.K.
be(max) =
Deflection in Deck as a Form Only for Construction Loads:
D(DL) = 0.089 in. D(DL) = 0.0054*(Wc+Wd)/12000*L^4/(Es*Id) (Es=29000 ksi) x=
D(ratio) = L/807 D(ratio) = L*12/D(DL) bm =
be =
Strong Axis Positive Moment for Uniform Live Load: n=
+fMno = 6.59 ft-kips/ft. +fMno = (0.85*Fyd*Scr)/12 a=
+Mu = 1.38 ft-kips/ft. +Mu = 1.2*(0.096*w(DL)/1000*L^2)+1.6*(0.096*w(LL)/1000*L^2) Z=
+Mu <= Allow., O.K. Icr =
Strong Axis Negative Moment for Uniform Live Load: Scr =
-fMno = 3.25 ft-kips/ft. -fMno = (0.90*Asn*Fy*((h-d1)-a/2))/12 +fMno =
-Mu = 1.95 ft-kips/ft. -Mu = 1.4*(0.125*w(DL)/1000*L^2)+1.7*(0.125*w(LL)/1000*L^2) +Mu =
-Mu <= Allow., O.K. Strong Axis N
Beam Shear for Uniform Live Load: x=
fVd = 4.16 kips fVd = beam shear capacity of deck alone (from SDI Table) bm =
Ac = 36.00 in.^2 Ac = 2*h*((rw+2*h*(rwt-rw)/2/hd)+rw)/2 be =
fVc = 3.87 kips fVc = 2*0.85*SQRT(f'c*1000)*Ac/1000 b=
fVnt = 7.74 kips fVnt = fVd+fVc <= 4*0.85*SQRT(f'c*1000)*Ac/1000 (without studs) a=
Vu = 1.50 kips Vu = 1.2*(0.625*w(DL)/1000*L)+1.6*(0.625*w(LL)/1000*L) -fMno =
Vu <= Allow., O.K.-Mu =
Shear and Negative Moment Interaction for Uniform Live Load:
S.R. = 0.396 S.R. = (Vu/fVnt)^2+(Mu/(+fMno))^2 S.R. <= 1.0, O.K. x =
bm =
Deflection for Uniform Live Load: be =
wa(LL) = 1585.32 psf wa(LL) = allow. live load = (fMno *(1/0.070)/L^2-1.2*w(DL))/1.6 fVd =
D(LL) = 0.005 in. D(LL) = 0.0054*w(LL)/12000*L^4/(Es*Iav) (Es=29000 ksi) Top Width =
D(ratio) = L/15068 D(ratio) = L*12/D(LL) Ac =
fVc =
Maximum Effective Slab Strip Width for Concentrated Load: fVnt =
be(max) = 80.10 in. be(max) = 8.9*(tc/h)*12 Vu =
(continued)
4 of 22 04/03/2020 14:02:25
"DECKSLAB.xls" Program
Version 1.4
D(P) =
Strong Axis Negative Moment for Concentrated Load: D(ratio) =
x= 36.00 in. x = (L*12)/2 (assumed for bending)
bm = 13.50 in. bm = b2+2*t(top)+2*tc A'c =
be = 37.50 in. be = bm+4/3*(1-x/(L*12))*x <= be(max) Ast(min) =
b= 4.50 in. b = 12/p*rw(avg) = width for negative bending x=
a= 0.784 in. a = Asn*Fy/(0.85*f'c*b)
-fMno = 3.25 ft-kips/ft. -fMno = (0.90*Asn*Fy*((h-d1)-a/2))/12
-Mu = 1.95 ft-kips/ft. -Mu = 1.4*(0.125*w(DL)/1000*L^2)+1.7*(0.094*P*L)*(12/be)
-Mu <= Allow., O.K.
Beam Shear for Concentrated Load: bm =
x= 6.00 in. x = h (assumed for beam shear) be =
bm = 13.50 in. bm = b2+2*t(top)+2*tc w=
be = 19.00 in. be = bm+(1-x/(L*12))*x <= be(max) a=
fVd = 4.16 kips fVd = beam shear capacity of deck alone (from SDI Table) fMnw =
Ac = 36.00 in.^2 Ac = 2*h*((rw+2*h*(rwt-rw)/2/hd)+rw)/2 Muw =
fVc = 3.87 kips fVc = 2*0.85*SQRT(f'c*1000)*Ac/1000
fVnt = 7.74 kips fVnt = fVd+fVc <= 4*0.85*SQRT(f'c*1000)*Ac/1000 (without studs)
Vu = 5.35 kips Vu = 1.2*(0.625*w(DL)/1000*L)+1.6*(P*12/be) Vu <= Allow., O.K.
(continued)
5 of 22 04/03/2020 14:02:25
"DECKSLAB.xls" Program
Version 1.4
6 of 22 04/03/2020 14:02:25
"DECKSLAB.xls" Program
Version 1.4
7 of 22 04/03/2020 14:02:25
"DECKSLAB.xls" Program
Version 1.4
(continued)
8 of 22 04/03/2020 14:02:25
"DECKSLAB.xls" Program
Version 1.4
Vu =
Beam Shear in Deck as a Form Only for Construction Loads:
fVd = 4.160 kips fVd = beam shear capacity of deck alone (LRFD value from SDI Table) S.R. =
Vu = 0.521 kips Vu = (1.6*Wc+1.2*Wd+1.4*W2)/1000*0.617*L
Vu <= Allow., wa(LL)
O.K. =
Shear and Negative Moment Interaction in Deck as a Form Only for Construction Loads: +Ma =
S.R. = 0.524 S.R. = (Vu/fVd)^2+(Mu/(Fb(allow)*Sn/12))^2 S.R. <= 1.0, O.K. Ie =
D(LL) =
Web Crippling (End Bearing) in Deck as a Form Only for Construction Loads: D(ratio) =
fRd = 4.220 kips fRd = beam shear capacity of deck alone (LRFD value from SDI Table)
Rui = 0.759 kips Rui = ((1.6*Wc+1.2*Wd+1.4*W2)/1000*1.20*L)*0.75 (allowing 1/3 increase)
be(max) =
Ri <= Rd, O.K. Strong Axis P
Deflection in Deck as a Form Only for Construction Loads: x=
D(DL) = 0.128 in. D(DL) = 0.0069*(Wc+Wd)/12000*L^4/(Es*Id) (Es=29000 ksi) bm =
D(ratio) = L/561 D(ratio) = L*12/D(DL) be =
Icr =
Ie =
9 of 22 04/03/2020 14:02:25
"DECKSLAB.xls" Program
Version 1.4
(continued)
10 of 22 04/03/2020 14:02:25
"DECKSLAB.xls" Program
Version 1.4
D(P) =
Strong Axis Negative Moment for Concentrated Load: D(ratio) =
x= 36.00 in. x = (L*12)/2 (assumed for bending)
bm = 13.50 in. bm = b2+2*t(top)+2*tc A'c =
be = 37.50 in. be = bm+4/3*(1-x/(L*12))*x <= be(max) Ast(min) =
b= 7.75 in. b = 12/p*rw(avg) = width for negative bending x=
a= 0.455 in. a = As*Fy/(0.85*f'c*b)
-fMno = 1.82 ft-kips/ft. -fMno = (0.90*As*Fy*((h-d1-hd/2)-a/2))/12
-Mu = 1.40 ft-kips/ft. -Mu = 1.4*(0.117*w(DL)/1000*L^2)+1.7*(0.100*P*L)*(12/be)
-Mu <= Allow., O.K.
Beam Shear for Concentrated Load: bm =
x= 6.00 in. x = h (assumed for beam shear) be =
bm = 13.50 in. bm = b2+2*t(top)+2*tc w=
be = 19.00 in. be = bm+(1-x/(L*12))*x <= be(max) a=
fVd = 4.16 kips fVd = fMnw =
Beam shear capacity of form deck is included (from SDI Catalog)
Ac = 57.75 in.^2 Ac = 2*hd*((2*rw(avg)-rw)+rw)/2+(h-hd)*(Pitch+(2*rw(avg)-rw))/2 Muw =
fVc = 6.21 kips fVc = 2*0.85*SQRT(f'c*1000)*Ac/1000
fVnt = 10.37 kips fVnt = fVd + fVc <= 4*0.85*SQRT(f'c*1000)*Ac/1000 -Ma =
Vu = 3.58 kips Vu = 1.4*(0.60*w(DL)/1000*L)+1.7*(P*12/be) Vu <= Allow., O.K. d =
fs =
Shear and Negative Moment Interaction for Concentrated Load: fs(used) =
S.R. = 0.709 S.R. = (Vu/fVnt)^2+(Mu/(-fMno))^2 S.R. <= 1.0, O.K.
s(max) =
Crack Control (Top Face Tension Reinf. Spacing Limitations) per ACI 318-99 Code:
-Ma = 0.30 ft-kips/ft. -Ma = (0.117*w(DL)/1000*L^2)+(0.117*w(LL)/1000*L^2)
fs = 9.03 ksi fs=12*Ma/(As2*d*(1-((2*As2/(b*d)*n+(As2/(b*d)*n)^2)^(1/2)-As2/(b*d)*n)/3))
fs(used) = 9.03 ksi fs(used) = minimum of: 'fs' and 0.6*fy
s(max) = 47.86 in. s(max) = minimum of: (540/fs(used))-2.5*(d1-0.25) and 12*36/fs(used)
11 of 22 04/03/2020 14:02:25
"DECKSLAB.xls" Program
Version 1.4
(continued)
12 of 22 04/03/2020 14:02:25
"DECKSLAB.xls" Program
Version 1.4
13 of 22 04/03/2020 14:02:25
"DECKSLAB.xls" Program
Version 1.4
14 of 22 04/03/2020 14:02:25
"DECKSLAB.xls" Program
Version 1.4
Results:
Properties and Data:
hd = 2.000 in. hd = deck rib height fVd =
p = 12.000 in. p = deck rib pitch (center to center distance between flutes) Vu =
rw = 5.000 in. rw = deck rib bearing width (from Vulcraft Table)
rw(avg) = 6.000 in. rw(avg) = average deck rib width (from Vulcraft Table) S.R. =
td = 0.0474 in. td = deck thickness (inch equivalent of gage)
Idp = 0.557 in.^4 Idp = inertia of steel deck/ft. width (from Vulcraft Table)
Idn = 0.557 in. Idn = inertia of steel deck/ft. width (from Vulcraft Table)
Sp = 0.520 in.^3 Sp = positive section modulus of steel deck/ft. width (from Vulcraft Table) fRd =
Sn = 0.520 in.^3 Sn = negative section modulus of steel deck/ft. width (from Vulcraft Table) Rui =
tc = 6.000 in. tc = h-hd = thickness of slab above top of deck ribs
Wd = 2.61 psf Wd = weight of deck/ft. (from Vulcraft Table)
Wc = 87.50 psf D(DL) =
Wc = ((t(top)+$h-hd)*12+(hd*(rwt+rw)/2))/144*wc (wt. of conc. for 12'' width)
w(DL) = 90.11 psf w(DL) = Wd+Wc = total dead weight of deck plus concrete D(ratio) =
15 of 22 04/03/2020 14:02:25
"DECKSLAB.xls" Program
Version 1.4
(continued)
16 of 22 04/03/2020 14:02:25
"DECKSLAB.xls" Program
Version 1.4
Vu =
Beam Shear in Deck as a Form Only for Construction Loads:
fVd = 3.180 kips fVd = beam shear capacity of deck alone (LRFD value from SDI Table) S.R. =
Vu = 0.634 kips Vu = (1.6*Wc+1.2*Wd+1.4*W2)/1000*0.617*L
Vu <= Allow., wa(LL)
O.K. =
Shear and Negative Moment Interaction in Deck as a Form Only for Construction Loads: +Ma =
S.R. = 0.321 S.R. = (Vu/fVd)^2+(Mu/(Fb(allow)*Sn/12))^2 S.R. <= 1.0, O.K. Ie =
D(LL) =
Web Crippling (End Bearing) in Deck as a Form Only for Construction Loads: D(ratio) =
fRd = 2.010 kips fRd = beam shear capacity of deck alone (LRFD value from SDI Table)
Rui = 0.924 kips Rui = ((1.6*Wc+1.2*Wd+1.4*W2)/1000*1.20*L)*0.75 (allowing 1/3 increase)
be(max) =
Ri <= Rd, O.K. Strong Axis P
Deflection in Deck as a Form Only for Construction Loads: x=
D(DL) = 0.086 in. D(DL) = 0.0069*(Wc+Wd)/12000*L^4/(Es*Id) (Es=29000 ksi) bm =
D(ratio) = L/835 D(ratio) = L*12/D(DL) be =
Icr =
Ie =
17 of 22 04/03/2020 14:02:25
"DECKSLAB.xls" Program
Version 1.4
(continued)
18 of 22 04/03/2020 14:02:25
"DECKSLAB.xls" Program
Version 1.4
D(P) =
Strong Axis Negative Moment for Concentrated Load: D(ratio) =
x= 36.00 in. x = (L*12)/2 (assumed for bending)
bm = 16.25 in. bm = b2+2*t(top)+2*tc A'c =
be = 40.25 in. be = bm+4/3*(1-x/(L*12))*x <= be(max) Ast(min) =
b= 6.00 in. b = 12/p*rw(avg) = width for negative bending x=
a= 0.588 in. a = As2*Fy/(0.85*f'c*b)
-fMno = 4.46 ft-kips/ft. -fMno = (0.90*As2*Fy*((h-d2-hd/2)-a/2))/12
-Mu = 2.05 ft-kips/ft. -Mu = 1.4*(0.117*w(DL)/1000*L^2)+1.7*(0.100*P*L)*(12/be)
-Mu <= Allow., O.K.
Beam Shear for Concentrated Load: bm =
x= 8.00 in. x = h (assumed for beam shear) be =
bm = 16.25 in. bm = b2+2*t(top)+2*tc w=
be = 23.36 in. be = bm+(1-x/(L*12))*x <= be(max) a=
fVd = 3.18 kips fVd = 0, as beam shear capacity of form deck alone is neglected fMnw =
Ac = 69.00 in.^2 Ac = hd*((2*rw(avg)-rw)+rw)/2+(h-hd)*(Pitch+(2*rw(avg)-rw))/2 Muw =
fVc = 7.42 kips fVc = 2*0.85*SQRT(f'c*1000)*Ac/1000
fVnt = 10.60 kips fVnt = fVd + fVc <= 4*0.85*SQRT(f'c*1000)*Ac/1000 -Ma =
Vu = 4.82 kips Vu = 1.4*(0.60*w(DL)/1000*L)+1.7*(P*12/be) Vu <= Allow., O.K. d =
fs =
Shear and Negative Moment Interaction for Concentrated Load: fs(used) =
S.R. = 0.418 S.R. = (Vu/fVnt)^2+(Mu/(-fMno))^2 S.R. <= 1.0, O.K.
s2(max) =
Crack Control (Top Face Tension Reinf. Spacing Limitations) per ACI 318-99 Code:
-Ma = 1.22 ft-kips/ft. -Ma = (0.117*w(DL)/1000*L^2)+(0.117*w(LL)/1000*L^2)
fs = 15.36 ksi fs=12*Ma/(As2*d*(1-((2*As2/(b*d)*n+(As2/(b*d)*n)^2)^(1/2)-As2/(b*d)*n)/3))
fs(used) = 15.36 ksi fs(used) = minimum of: 'fs' and 0.6*fy
s2(max) = 28.13 in. s2(max) = minimum of: (540/fs(used))-2.5*(d2-0.25) and 12*36/fs(used)
19 of 22 04/03/2020 14:02:25
"DECKSLAB.xls" Program
Version 1.4
(continued)
20 of 22 04/03/2020 14:02:25
"DECKSLAB.xls" Program
Version 1.4
21 of 22 04/03/2020 14:02:25
"DECKSLAB.xls" Program
Version 1.4
22 of 22 04/03/2020 14:02:25