Calculator for assessment of coldformed steel structures (www.theengineeringcommunity.org).xlsm

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	Q
1	METAMORPHS														C:\Documents and Settings\All Users\Documents\ExelCalcs\schTechLIB.xla'!
2	AS4600 CALCULATOR
3		MATERIAL PROPERTIES
4		Fy	#NAME?	MPa	Fu	#NAME?	MPa	E	200000	MPa	G	80000	MPa
5				#NAME?
6		Section		DHS30030

7
8		Section Properties for Analysis
9		swt	#NAME?	kg/m
10		A	#NAME?	mm²	Ix	#NAME?	mm^4	Iy	#NAME?	mm^4	J	#NAME?	mm^4
11
12		Full Section Properties for Member Design {from Tables}
13		SECTION GEOMETRY			SECTION PROPERTIES
14		D	#NAME?	mm	Zfx	#NAME?	mm^3	Zfy	#NAME?	mm³
15		Bf1=top	#NAME?	mm	rx	#NAME?	mm	ry	#NAME?	mm	Iw	#NAME?	mm^6
16		Bf2=btm		mm	Sx			Sy
17		dL	#NAME?	mm	x_bar	#NAME?	mm	y_bar	#NAME?	mm	Q	#NAME?
18		tf	#NAME?	mm	x_o	#NAME?	mm	y_o	#NAME?	mm	ro1	#NAME?
19		tw		mm
20		ri	#NAME?	mm
21
22		Areas	Ag	#NAME?	mm^2	An	#NAME?	mm^2	Ae	#NAME?	mm^2
23
24				Member Description:	Portal COLUMN
25
26		MEMBER PROPERTIES					M+C				M+T
27							XX	YY			XX	YY
28		Beam/Column Length				L	6807				mm
29		Length = Lx				LX	6807				6807		mm
30		Brace position = Ly				LY	1800				1800		mm
31		Torsion Brace = Lz				LZ	1800				1800		mm
32							-				-
33	BENDING
34							M+C				M+T
35							XX	YY			XX	YY
36		Axial				P_1	18						kN
37		End1 Moment				M_1							kNm
38		End2 Mom{Design}				M_2*	23,93				23,93		kNm
39					q1	M_3
40					q2	M_4
41					q3	M_5
42		cb=	#NAME?		1	Cb =	1,00				1,00		1	#NAME?
43						foy	#NAME?				#NAME?
44						foz	#NAME?				#NAME?
45						Mo	#NAME?				#NAME?
46						My	#NAME?				#NAME?
47						Lambda[b]	#NAME?				#NAME?
48						Mc	#NAME?				#NAME?
49						fc	#NAME?				#NAME?		MPa
50						Zcx	#NAME?				#NAME?		mm^3
51						Zex	#NAME?						mm^3
52						Ms	#NAME?						kNm
53						phi	0,95				0,95		§ 3.3.1
54						phi*Ms	#NAME?	#NAME?					kNm
55						M<=phiMs	#NAME?				#NAME?
56						phi*Mb	#NAME?				#NAME?		kNm
57						M<=phiMb	#NAME?				#NAME?
58						min(phi*Mb)	#NAME?				kNm
59
60						Zfx	#NAME?						mm^3
61						M[full] =Msxf	#NAME?						kNm
62						phi*Ms/M[full]	#NAME?				1
63
64							M+C				M+T
65	AXIAL				Axial Compression					Axial Tension
66						P=N*	18,00	kN	(+ve)	P=N*		kN	(+ve)
67						Lx	6807,00	mm		Ag	#NAME?
68						fox	#NAME?			An	#NAME?	Hole	0,00	mm
69						beta	#NAME?	E3.4.3(3)		kt	1,00
70					#NAME?	foc	#NAME?	E3.4.3(1)		Nt	#NAME?	kN
71						Lambda[c]	#NAME?			phi =	0,90	§ 3.2.1
72						fn	#NAME?			Nd = phi.Nt	#NAME?	kN
73						Ae1 (f*=fy)	#NAME?	mm²			#NAME?
74						Ae2 (f*=fn)	#NAME?	mm²
75				#NAME?	#NAME?	Ns = Ae1 fy	#NAME?	kN
76				#NAME?	#NAME?	Nc = Ae2 fn	#NAME?	kN
77						phi =	0,85	§ 3.4.3
78						Nd = phi.Nc =	#NAME?	kN	#NAME?
79
80	COMBINED
81	Combined Axial Compression & Bending								Combined Axial Tension & Bending
82	Cmx		1,00
83	Ne		#NAME?	kN
84	alpha[nx]		#NAME?
85	Stability	#NAME?	#NAME?	Strength	#NAME?	#NAME?			Stability	#NAME?	#NAME?	Strength	#NAME?	#NAME?
86
87	SIMPLE	{ignores flexural buckling and local effects}
88			Compression {ignoring buckling}							Tension
89		stress =	M/Z + P/A							M/Z + P/A
90			#NAME?	#NAME?						#NAME?	#NAME?
91			#NAME?		MPa					#NAME?		MPa
92		stress/Fy	#NAME?	#NAME?						#NAME?	#NAME?
93		Fy/stress	#NAME?	#NAME?						#NAME?	#NAME?
94
95
96
97
98
99	#NAME?
100					Combined Member type		BuiltUpType	0