Walls_analytical_model.xlsx

	B	C	D	E	F	G	H	I
1
2	INPUT
3	Symbol	Value	Units	Description
4	w	2936	mm	Length of the wall
5	h	2100	mm	Height of the wall
6	T	5.7	kN	Tensile capacity of 1 bow tie
7	S	3.5	kN	Shear capacity of 1 bow tie
8	k_t	1.5	kN/mm	Hold down stiffness for 1 bow tie
9	k_s	3	kN/mm	Shear stiffness of 1 bow tie
10	n_h	14	-	Number of horizontal bow ties per face
11	n_v	6	-	Number of vertical bow ties between columns
12	E	8000	MPa	Elastic modulus
13	G	350	MPa	Shear modulus
14	t	18	mm	Panel thickness
15	F_sls	40	kN	SLS Force
16	F_uls	60	kN	ULS Force
17	q	0.5	kN/m	Vertical load
18
19	SLS CALCS
20	Symbol	Value	Units	Description
21	Delta_T	0.4762	mm	Transaltional displacement
22	Delta_S	2.2707	mm	Shear displacement
23	Delta_R	1.45	mm	Rotational displacement
24	Delta_tot	4.2	mm	Total displacement
25
26	ULS CALCS
27	Symbol	Value	Units	Description
28	F_S	98	kN	Shear capacity
29	F_R	77.4929	kN	Rotation capacity
30	F_V	793.8095695
31	C	77.49	kN
32
33	i [-]	d_i [mm]	d_i/d_n	d_i^2 (mm2)	T [kN]	T_i*d_i (kNm)	M_q (kNm)	0
34	1	134	0.05	17956	0.5	0.07305438972	2.155024	-134
35	2	374	0.13	139876	1.5	0.569088651		-374
36	3	569	0.20	323761	2.3	1.317228908		-569
37	4	764	0.27	583696	3.1	2.3747803		-764
38	5	974	0.35	948676	4.0	3.859709636		-974
39	6	1169	0.42	1366561	4.8	5.559884154		-1169
40	7	1364	0.49	1860496	5.5	7.569469807		-1364
41	8	1574	0.56	2477476	6.4	10.07966681		-1574
42	9	1769	0.63	3129361	7.2	12.73187559		-1769
43	10	1964	0.70	3857296	8.0	15.6934955		-1964
44	11	2174	0.78	4726276	8.8	19.22896017		-2174
45	12	2369	0.85	5612161	9.6	22.83320321		-2369
46	13	2564	0.92	6574096	10.4	26.74685739		-2564
47	14	2802	1.00	7851204	11.4	31.9428		-2802
48		20564		39468892				-20564
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100