CSA Temporary Shelter

PROJECT Civl 510 - Temporary Shelter SECTION
TITLE column design DATE

FILE steelspreadsheet.xls TIME
Revised Bracing Design
Description:This spreadsheet shows the design of axially loaded bracing (in compression)
Member Propeties
Section 2L203*152*11
Total Area Ag = 7630.0
Depth d = 203.0
Width b = 152.0
Flange Thickness t = 11.0
Web/Plate Thickness tw = 11.0
Radius of Gyration (x) rx = 65.3
Radius of Gyration (y) ry = 63.9
Member Length L = 11660.0
Member Design Input/ Calculations
Factored Compressive Load Cf = 93.6
Compressive Yield Strength Cy = Ag*Fy/1000 = 2670.50
Unbraced Length (x) Lx = L = 11660.00
Unbraced Length (y) Ly = L = 11660.00
Member Class
Specified Yield Strength Fy = 350
Flange Ratio Fr = (b/2)/t = 6.91
Web Ratio Wr = (d-(2*t))/tw = 16.45
IF(Fr<=(145/Fy^0.5),1,IF(Fr<=(170/Fy^0.5),2,IF(Fr<=(200/Fy^
Flange Classification FC = 0.5),3,4))) = 1
IF(Wr<=(1100/Fy^0.5)*(1-
Web Classification WC (0.39*(Cf/Cy))),1,IF(Wr<=(1700/Fy^0.5)*(1-
(0.61*(Cf/Cy))),2,IF(Wr<=(1900/Fy^0.5)*(1-
= (0.65*(Cf/Cy))),3,4))) = 1
IF(MAX(FC,WC)=1,"Class 1",IF(MAX(FC,WC)=2,"Class
Member Classification MC
2",IF(MAX(FC,WC)=3,"Class 3","Class 4")))
= = Class 1
Material Design Factor
Modulus of Elasticiy E = 200000
Performance Factor f = 0.9
Connection Type c_type = ("F-F" or "F-P" or "P-P" or "F-T" or "F-R") = P-P
IF(c_type="F-F",0.65,IF(c_type="F-P",0.8,IF(c_type="P-
Effective Length Factor K = P",1.0,IF(c_type="F-T",1.2,IF(c_type="F-R",2.0,"---"))))) = 1
Effective Length Factor(x) Kx = K = 1
Effective Length Factor(y) Ky = K = 1
Member Shape m_shape = ("W" or "HSS-C" or "WWF" or "HSS-H") = L
Coefficient n n = IF(m_shape="W",1.34,IF(m_shape="HSS-C",1.34,2.24)) = 2.24
Slenderness Ratio
Slenderness (x) slx = (Kx*Lx)/rx = 178.56
Slenderness (y) sly = (Ky*Ly)/ry = 182.47
Slenderness Ratio slr = MAX(slx,sly) = 182.47
Compressive Resistance
Yeild Limit Cr_yld = (f*Ag*Fy)/1000 = 2403.45
Code Fomular Cr_code = ((f*Ag*Fy)*(1+(slr*(Fy/((PI()^2)*E))^0.5)^(2*n))^(-1/n))/1000 = 403.74
Summary of Results
Check Comp. Resistance C_Cr = IF(Cf<=MIN(Cr_yld,Cr_code),"pass","fail") = pass
Check Slanderness C_slr = IF(MAX(slx,sly)<=200,"pass","fail") = pass
Design/ Efficiency Considerations
Required Radius of Gyration R_r = (Ky*Ly)/200 = 58.30
Required Area (min) R_a = (Cf*1000)/((f*Fy)*(1+(slr*((Fy/((3.14^2)*E)))^0.5)^(2*n))^(-1/n)) = 1770.64
X-section Efficiency Ratio Eff_1 = (R_a/Ag)*100 = 23.21
Slenderness Efficiency Ratio Eff_2 = (max(slx,sly)/200)*100 = 91.24
Weight per Meter of Material WMM = 30.9
1
6/7/2017
2:03 PM
mm2
mm
mm
mm
mm
mm
mm
mm
KN
KN
mm
mm
Mpa
MPa
KN
KN
mm
mm2
%
%
kg/m
TITLE column design DATE
FILE temporary_shelter.xls TIME
Revised Bracing Design
Description:This spreadsheet shows the design of axially loaded bracing (in compression)
Member Propeties
Section 2L127*89*9.5
Total Area Ag = 3930.0
Depth d = 127.0
Width b = 89.0
Flange Thickness t = 9.5
Radius of Gyration (x) rx = 40.6
Member Length L = 7810.0
Factored Compressive Load Cf = 93.6
Compressive Yield Strength Cy = Ag*Fy/1000 = 1375.50
Unbraced Length (x) Lx = L = 7810.00
Unbraced Length (y) Ly = L = 7810.00
Member Class
IF(Wr<=(1100/Fy^0.5)*(1-
(0.61*(Cf/Cy))),2,IF(Wr<=(1900/Fy^0.5)*(1-
= (0.65*(Cf/Cy))),3,4))) = 1
2",IF(MAX(FC,WC)=3,"Class 3","Class 4")))
= = Class 1
Modulus of Elasticiy E = 200000
Member Shape m_shape = ("W" or "HSS-C" or "WWF" or "HSS-H") = L
Slenderness Ratio
Yeild Limit Cr_yld = (f*Ag*Fy)/1000 = 1237.95
Code Fomular Cr_code = ((f*Ag*Fy)*(1+(slr*(Fy/((PI()^2)*E))^0.5)^(2*n))^(-1/n))/1000 = 178.45
Summary of Results
Required Radius of Gyration R_r = (Ky*Ly)/200 = 39.05
Required Area (min) R_a = (Cf*1000)/((f*Fy)*(1+(slr*((Fy/((3.14^2)*E)))^0.5)^(2*n))^(-1/n)) = 2063.47
X-section Efficiency Ratio Eff_1 = (R_a/Ag)*100 = 52.51
Slenderness Efficiency Ratio Eff_2 = (max(slx,sly)/200)*100 = 98.61
Weight per Meter of Material WMM = 30.9
1
6/7/2017
2:03 PM
mm2
mm
mm
mm
mm
mm
mm
mm
KN
KN
mm
mm
Mpa
MPa
KN
KN
mm
mm2
%
%
kg/m
PROJECT Civl 510 - Temporary Shelter SECTION 1
TITLE Bracing Design DATE ###
FILE temporary_shelter.xls TIME ###
Bracing Design in Tension--at End Wall
DESCRIPTION
This page is a tension member design.
Input
section selected 2L127*89*9.5
effective length factor(x) Kx = = 1
effective length factor(y) Ky = = 1
effective length factor(z) Kz = = 1
unbraced member length(x) Lx = = 11660 mm
unbraced member length(y) Ly = = 11660 mm
# of equally spaced stitch fasteners nsf = = 1
radius of gyration(x) rx = = 40.6 mm
radius of gyration(y) ry = = 39.6 mm
radius of gyration(z) rz = = 20.1 mm
web/plate thickness w = = 9.53 mm
angle leg (vertical) d = = 127 mm
angle leg (horiz.) b = = 89 mm
gross area Ag = = 3930 mm2
resistance factor f = = 0.9
yield strength Fy = = 350 Mpa
ultimate strength Fu = = 450 Mpa
nominal hole diameter dh = = 16 mm
Calculations
slenderness limit = 300.0
factored load fL = = 200.0 kN
slenderness about x-axis slx = (Kx*Lx)/rx = 287.2
slenderness about y-axis sly = (Ky*Ly)/ry = 294.4
unbraced member length(z) Lz = Lx/(nsf+1) = 5830.0 mm
slenderness about z-axis slz = (Kz*Lz)/rz = 290.0
check slenderness ratios chk_sl = IF(MAX(slx,sly,slz)<=limit,"o.k.","too slender") = o.k.
Tensile Resistance
yield in gross cross section Tri = f*Ag*Fy/1000 = 1238.0 kN
Case 1- rupture in net cross section perpendicular to load

effective net area Ane1 = Ag-(w*dh)*2 = 3625.0 mm
rupture in net cross section Trii = 0.85*f*Ane1*Fu/1000 = 1247.9 kN
reduction net area A'ne1 = Ane1*0.6 = 2175.0 mm
shear lag effects Triii = 0.85*f*A'ne1*Fu/1000 = 748.8 kN
Case 2- block tear out with fracture lines parallel to applied load
number of bolts nb = 3.0
minimum end distance med = 40.0 mm
bolt spacing bs = 60.0 mm
net length nl = 2*(med-dh/2)+nb*bs-nb*dh = 196.0 mm
effective net area Ane2 = 0.6*nl*w*2 = 2241.5 mm2
rupture in net cross section Trii2 = 0.85*f*Ane2*Fu/1000 = 771.6 kN
reduction net area A'ne2 = Ane2*0.6 = 1344.9 mm2
shear lag effects Triii2 = 0.85*f*A'ne2*Fu/1000 = 463.0 kN
Summary
tensile resistence Tr = min(Tri,Trii,Triii,Trii2,Triii2) = 463.0 kN
check check = IF(fL<=Tr,"o.k.","section too small") = o.k.
Efficiency considerations
min. required net area A'ne = (FL*1000)/(0.85*f*Fu) = 581.0 mm2
min. chosen net area A'nec = min(A'ne1,A'ne2) = 1344.9 mm2
efficiency ratio / cross section eff1 = A'ne/A'nec = 43.2%
efficiency ratio / slenderness eff2 = max(slx,sly,slz)/limit = 98.1%
TITLE Bracing Design DATE ###
Bracing Design in Tension--at Side Wall
DESCRIPTION
This page is a tension member design.
Input
section selected 2L90*65
effective length factor(x) Kx = = 1
effective length factor(y) Ky = = 1
effective length factor(z) Kz = = 1
unbraced member length(x) Lx = = 7070 mm
unbraced member length(y) Ly = = 7070 mm
# of equally spaced stitch fasteners nsf = = 1
radius of gyration(x) rx = = 28.5 mm
radius of gyration(y) ry = = 28.7 mm
radius of gyration(z) rz = = 13.9 mm
web/plate thickness w = = 8 mm
angle leg (vertical) d = = 90 mm
angle leg (horiz.) b = = 65 mm
gross area Ag = = 2350 mm2
resistance factor f = = 0.9
yield strength Fy = = 350 Mpa
ultimate strength Fu = = 450 Mpa
nominal hole diameter dh = = 16 mm
Calculations
slenderness limit = 300.0
factored load fL = = 95.3 kN
slenderness about x-axis slx = (Kx*Lx)/rx = 248.1
slenderness about y-axis sly = (Ky*Ly)/ry = 246.3
unbraced member length(z) Lz = Lx/(nsf+1) = 3535.0 mm
slenderness about z-axis slz = (Kz*Lz)/rz = 254.3
check slenderness ratios chk_sl = IF(MAX(slx,sly,slz)<=limit,"o.k.","too slender") = o.k.
Tensile Resistance
yield in gross cross section Tri = f*Ag*Fy/1000 = 740.3 kN
Case 1- rupture in net cross section perpendicular to load

effective net area Ane1 = Ag-(w*dh)*2 = 2094.0 mm
rupture in net cross section Trii = 0.85*f*Ane1*Fu/1000 = 720.9 kN
reduction net area A'ne1 = Ane1*0.6 = 1256.4 mm
shear lag effects Triii = 0.85*f*A'ne1*Fu/1000 = 432.5 kN
Case 2- block tear out with fracture lines parallel to applied load
number of bolts nb = 2.0
minimum end distance med = 40.0 mm
bolt spacing bs = 60.0 mm
net length nl = 2*(med-dh/2)+nb*bs-nb*dh = 152.0 mm
effective net area Ane2 = 0.6*nl*w*2 = 1459.2 mm2
rupture in net cross section Trii2 = 0.85*f*Ane2*Fu/1000 = 502.3 kN
reduction net area A'ne2 = Ane2*0.6 = 875.5 mm2
shear lag effects Triii2 = 0.85*f*A'ne2*Fu/1000 = 301.4 kN
Summary
tensile resistence Tr = min(Tri,Trii,Triii,Trii2,Triii2) = 301.4 kN
check check = IF(fL<=Tr,"o.k.","section too small") = o.k.
Efficiency considerations
min. required net area A'ne = (FL*1000)/(0.85*f*Fu) = 276.8 mm2
min. chosen net area A'nec = min(A'ne1,A'ne2) = 875.5 mm2
efficiency ratio / cross section eff1 = A'ne/A'nec = 31.6%
efficiency ratio / slenderness eff2 = max(slx,sly,slz)/limit = 84.8%
PROJECT Temporary Shelter SECTION
TITLE beam-column design DATE
Column Design
Description:This spreadsheet shows the design of columns subjected to

bending and axial compression
member subjected to a concentrated or moment between supports, w 1=0.85
Member Properties
Section W410*149
Total Area Ag = 19000
Depth d = 431
Width b = 265
Flange Thickness t = 25
Radius of Gyration (x) rx = 180
Moment of inertia (x) ix = 619000000
Moment of inertia (y) iy = 77700000
Tortional Moment of inertia J = 3220000
Warping Constant Cw = 3.2E+12
Plastic Section Modulus(x) Zx = 3250000
Plastic Section Modulus(y) Zy = 900000
Member Length L = 10000
Modulus of Elasticity Es = 200000

Factored Compressive Load Cf = 373
Smaller Factored Moment(x) Mfx_s = 0
Larger Factored Moment(x) Mfx_l = 694
Smaller Factored Moment(y) Mfy_s = 0
Larger Factored Moment(y) Mfy_l = 0
Unbraced Length (x) Lx = 10000
Unbraced Length (y) Ly = 10000
Effective Length Factor(x) Kx = 2
Effective Length Factor(y) Ky = 1
Member Class
IF(Wr<=(1100/Fy^0.5)*(1-
(0.61*(Cf/Cy))),2,IF(Wr<=(1900/Fy^0.5)*(1-
= (0.65*(Cf/Cy))),3,4))) = 1
= 2",IF(MAX(FC,WC)=3,"Class 3","Class 4"))) = Class 1
Member Shape m_shape = ("W" or "HSS-C" or "WWF" or "HSS-H") = W
Slenderness Ratio
Check Cross Section
Plastic Moment Mpx Mpx = Zx*Fy/1000000 = 1137.50
Plastic Moment Mpy Mpy = Zy*Fy/1000000 = 315.00
Factored Moment resistant Mrx = f*Mpx = 1023.75
Factored Moment resistant Mry = f*Mpy = 283.50
Compressive Yield Strength Cy = (f*Ag*Fy)/1000 = 5985.00
Cross Section Check cross = Cf/Cy+(0.85*Mfx_l)/Mrx+(0.6*Mfy_l)/Mry = 0.64
Overall Member Check
Copmressive Resistance Cr = ((f*Ag*Fy)*(1+(slr*(Fy/((PI()^2)*Es))^0.5)^(2*n))^(-1/n))/1000 = 1250.04

Overall Check overall = Cf/Cr+(0.85*Mfx_l)/Mrx+(0.6*Mfy_l)/Mry = 0.87
Lateral Buckling Check
value of w1 w1 = 0.85
Euler Buckling Strength Cex = Es*ix*(PI()/(Kx*Lx))^2/1000 = 3054.64
Cey = Es*iy*(PI()/(Ky*Ly))^2/1000 = 1533.74
Second Order Effects U1x = w1/(1-Cf/Cex) = 0.97
U1y = w1/(1-Cf/Cey) = 1.12
Lateral Check lateral = Cf/Cr+(0.85*U1x*Mfx_l)/Mrx+(0.6*U1y*Mfy_l)/Mry = 0.86
Additional Check
additional Check add = Mfx_l/Mrx+Mfy_l/Mry = 0.68
Summary of thr Results
Check (o.k. if <1.0) check1 = slr/200 = 0.78
check2 = MAX(cross,overall,lateral,add) = 0.87
27.12.2007
mm2
mm
mm
mm
mm
mm
mm
mm4
mm4
mm4
mm6
mm3
mm3
mm
Mpa
Mpa
KN
KNm
KNm
KNm
KNm
mm
mm
KNm
KNm
KNm
KNm
KN
KN
KN
TITLE column design DATE ###
Column Design
Description:This spreadsheet shows the design of axially loaded columns
Member Propeties
Section W200*59
Total Area Ag = 7530.0 mm2
Depth d = 210.0 mm
Width b = 205.0 mm
Flange Thickness t = 14.2 mm
Web/Plate Thickness tw = 9.1 mm
Radius of Gyration (x) rx = 89.9 mm
Radius of Gyration (y) ry = 52.1 mm
Member Length L = 10000.0 mm
Factored Compressive Load Cf = 342.2 KN
Compressive Yield Strength Cy = Ag*Fy/1000 = 2635.50 KN
Unbraced Length (x) Lx = L = 10000.00 mm
Unbraced Length (y) Ly = L = 10000.00 mm
Member Class
Specified Yield Strength Fy = 350 Mpa
IF(Wr<=(1100/Fy^0.5)*(1-
(0.61*(Cf/Cy))),2,IF(Wr<=(1900/Fy^0.5)*(1-
= (0.65*(Cf/Cy))),3,4))) = 1
= 2",IF(MAX(FC,WC)=3,"Class 3","Class 4"))) = Class 1
Modulus of Elasticiy E = 200000 MPa
Member Shape m_shape = ("W" or "HSS-C" or "WWF" or "HSS-H") = W
Slenderness Ratio
Yeild Limit Cr_yld = (f*Ag*Fy)/1000 = 2371.95 KN
Code Fomular Cr_code = ((f*Ag*Fy)*(1+(slr*(Fy/((PI()^2)*E))^0.5)^(2*n))^(-1/n))/1000 = 342.64 KN
Summary of Results
Required Radius of Gyration R_r = (Ky*Ly)/200 = 50.00 mm
Required Area (min) R_a = (Cf*1000)/((f*Fy)*(1+(slr*((Fy/((3.14^2)*E)))^0.5)^(2*n))^(-1/n)) = 7527.41 mm2
X-section Efficiency Ratio Eff_1 = (R_a/Ag)*100 = 99.97 %
Slenderness Efficiency Ratio Eff_2 = (max(slx,sly)/200)*100 = 95.97 %
Weight per Meter of Material WMM = 59 kg/m
PROJECT civl511-simple design SECTION 1
TITLE Civl 510 - Temporary Shelter DATE ###
Connection Design for Bracing to Column--End Plate to Column
Description:This spreadsheet shows the design of bolted connections subjected to tension and shear
Data Input
Bolt Selected A325M-M16
Factored Shear Vf = 171.50 KN
Factored Tension Tf = 103.00 KN
Connection Type type = b
Performance Factor for Connection Type fb = IF(type="b",0.67,1.0) = 0.67
Plate Thickness t = 10.00 mm
Bolt Diameter d = 16.00 mm
Nominal Area of Bolt Ab = PI()*d^2/4 = 201.06 mm2
Number of Bolts n = 3.00
Number of Shear Plane ns = 1.00
Ultimate Strength of Bolt Fub = 830.00 Mpa
Ultimate Strength of Plate Fup = 450.00 Mpa
Calculation
Load Bearing of Plate Br = 3*fb*t*d*n*Fup/1000 = 434.16
Shear Resistance of Bolt Shaft Vr_sh = 0.6*fb*n*ns*Ab*Fub/1000 = 201.26
Shear Resistance of Theaded Part of Bolt Vr_th = 0.7*Vr_sh/1000 = 0.14
Shear Resistance Vr = Vr_sh = 201.26
Tensil Resistance Tr = 0.75*fb*n*Ab*Fub/1000 = 251.57
Check
Shear shear = Vf/MIN(Br,Vr) = 0.85
Tension tension = Tf/Tr = 0.41
Combined comb = shear^2+tension^2 = 0.89
Check check = IF(comb<=1.0,"pass","fail") = pass
TITLE Connection Design DATE ###
Connection Design for Beam to Column Connection
Description:This spreadsheet shows the design of connections subjected to tension and shear,
bolts carry the shear, groove welds carry the tension.
Data Input
Bolt Seleted A325M-M20
Factored Shear Vf = 269.2 KN
Performance Factor for Connection Type fb = IF(type="b",0.67,1.0) = 0.67
Plate Thickness t = 10 mm
Bolt Diameter d = 20 mm
Nominal Area of Bolt Ab = PI()*d^2/4 = 314.15926536 mm2
Number of Bolts n = 4
Number of Shear Plane ns = 1
Ultimate Strength of Bolt Fub = 830 MPa
Ultimate Strength of Plate Fup = 450 MPa
Calculation
Load Beearing of Plate Br = 3*fb*t*d*n*Fup/1000 = 723.6 KN
Shear Resistance of Bolt Shaft Vr_sh = 0.6*fb*n*ns*Ab*Fub/1000 = 419.28952192 KN
Shear Resistance of Theaded Part of Bolt Vr_th = 0.7*Vr_sh = 293.50266534 KN
Breaking Path path = shaft
Shear Resistance Vr = IF(path="shaft",Vr_sh,Vr_th) = 293.50266534 KN
Check
check = IF(shear<=1.0,"pass", "fail") = pass
TITLE Connection Design DATE
Connection Design for Bracing to Column Connection--Bracing to Gusset Plate
Description:This spreadsheet shows the design of connections subjected to shear,

Data Input
Bolt Seleted A325M-M16
Factored Shear Vf = 200
Performance Factor for Connectfb = IF(type="b",0.67,1.0) = 0.67
Plate Thickness t = 9.53
Bolt Diameter d = 16
Nominal Area of Bolt Ab = PI()*d^2/4 = 201.06192983
Number of Bolts n = 3
Number of Shear Plane ns = 2
Ultimate Strength of Bolt Fub = 830
Ultimate Strength of Plate Fup = 450
Calculation
Load Beearing of Plate Br = 3*fb*t*d*n*Fup/1000 = 413.75448
Shear Resistance of Bolt Shaft Vr_sh = 0.6*fb*n*ns*Ab*Fub/1000 = 402.51794104
Shear Resistance of Theaded PaVr_th = 0.7*Vr_sh = 281.76255873
Breaking Path path = shaft
Shear Resistance Vr = IF(path="shaft",Vr_sh,Vr_th) = 281.76255873
Check
check = IF(shear<=1.0,"pass", "fail") = pass
1
6/7/2017
2:03 PM
KN
mm
mm
mm2
MPa
MPa
KN
KN
KN
KN
TITLE connection design DATE
Connection Design for Base Connection
Description:This spreadsheet shows the design of anchor bolts subjected to tension and shear
Data Input
Anchor Bolt Selected use 300W 2M24
Factored Shear Vf = 103.50
Factored Tension Tf = 163.30
Performance Factor for Connectfb = IF(type="b",0.67,1.0) = 0.67
Bolt Diameter d = 24.00
Nominal Area of Bolt Ab = PI()*d^2/4 = 452.39
Tensil Area of Bolts An = PI()*(d-0.938*2)^2/4 = 384.43
Number of Bolts n = 2.00
Ultimate Strength of Bolt Fub = 450.00
Ultimate Strength of Plate Fup = 450.00
Calculation
Shear Resistance of Bolt Shaft Vr_sh = 0.6*fb*n*Ab*Fub/1000 = 163.67
Shear Resistance of Theaded PaVr_th = 0.7*Vr_sh/1000 = 0.11
Shear Resistance Vr = Vr_sh = 163.67
Tensil Resistance Tr = fb*n*An*Fub/1000 = 231.81
Check
Shear shear = Vf/Vr = 0.63
Tension tension = Tf/Tr = 0.70
Combined comb = shear^2+tension^2 = 0.90
Check check = IF(comb<=1.0,"pass","fail") = pass
1
6/7/2017
2:03 PM
KN
KN
mm
mm2
mm2
Mpa
Mpa
Engineering Calculation Template
Manual
INTRODUCTION
1. This template provides necessary macros to build up engineering calculations for quick re-calc
2. and
Key clear presentation.
functions:
- set up formulae
- page setup
HOW TO USE
[0] Save this file first with another appropriate name. Ensure this file is put in the same directory as
your newly saved file.
[1] Use the styles as in sheet 'sample' to fill in title, logo, etc.
[2] Define variables, equations, units. Make sure not to use cell locations as variable names!
[3] Use macro 'formatted' to calculate the defined formulae. Bring up a list of macro by ALT-F8.
[4] Set your default font to Arial Size 8 (Tools/Options/General/Fonts)
SHEET STRUCTURE
Ranges:
Column A: section descriptions
Column B: variable/formula description
Column C: variable name, to be referenced in formulae
Column D, F: equal sign
Column E: formulae
Column G: variable values or formula results
Column H: units
calculation contents: from row 8
MACRO DESCRIPTIONS
formatted
validates and calculates all the variables and formulae. All variable referenced in the formulae
have to be defined in the same sheet.
setWidth
adjusts column widths.
CREDITS
This template is first created by Mr. Michael Gedig using the ideas from Dr. S. F. Stiemer's and Mr.
David S.K. "auto123.wks". Mr. Ye Zhou got his hands on it and further improved it a bit.

CSA Temporary Shelter

Uploaded by

Copyright:

Available Formats

CSA Temporary Shelter

Uploaded by

Document Information

Original Description:

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

CSA Temporary Shelter

Uploaded by

Copyright:

Available Formats

What is the purpose of the spreadsheet?

What is the purpose of the spreadsheet?

How is the compressive resistance of the member calculated?

How is the compressive resistance of the member calculated?

PROJECT Civl 510 - Temporary Shelter SECTION

TITLE column design DATE

Revised Bracing Design

Revised Bracing Design

Bracing Design in Tension--at End Wall

Case 1- rupture in net cross section perpendicular to load

Bracing Design in Tension--at Side Wall

Case 1- rupture in net cross section perpendicular to load

Description:This spreadsheet shows the design of columns subjected to

Member Design Input/ Calculations

Copmressive Resistance Cr = ((f*Ag*Fy)*(1+(slr*(Fy/((PI()^2)*Es))^0.5)^(2*n))^(-1/n))/1000 = 1250.04

Description:This spreadsheet shows the design of axially loaded columns

Connection Design for Bracing to Column--End Plate to Column

Connection Design for Beam to Column Connection

Connection Design for Bracing to Column Connection--Bracing to Gusset Plate

Description:This spreadsheet shows the design of connections subjected to shear,

Connection Design for Base Connection

You might also like

Copmressive Resistance Cr = ((fAgFy)(1+(slr(Fy/((PI()^2)Es))^0.5)^(2n))^(-1/n))/1000 = 1250.04