Copy of Roof Load Calculator

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Point Name	Load Weight	Point X	Point Y	Y Actual	Bridle Apex	Length 1	Length 2	Links	Tension1	Tension 2	Force Vertial 1	Force Vertical 2	Force Horz 1	Force Horz 2	Beam 1 X	Beam 1 Z	Beam 2 X	Beam 2 Z
2	B1	200	37	-53	-53	91	15.34	15.34	-0.6	#DIV/0!	9	#DIV/0!	9	#DIV/0!	2	33.8	106	33.8	106
3	L1	1760	32.7	-0.5	-0.5	91	19.53	15.04	12.8	143	334	110	333	-92	24	20.2	106	33.8	106
4	V5	3520	-14.8	0	0	91	15.94	17	2.6	0	0	0	0	0	0	-20.2	106	-6.8	106
5	V4	3080	-3	1	1	91	15.47	17.92	6.7	2651	107	2570	90	-651	59	-6.8	106	6.8	106
6	V3	3080	3	0	0	91	17.92	15.47	6.7	0	0	0	0	0	0	-6.8	106	6.8	106
7	V2	3520	14.8	0	0	91	17	15.94	2.6	0	0	0	0	0	0	6.8	106	20.2	106
8	V1	3080	24	0	0	91	15.47	17.92	6.7	0	0	0	0	0	0	20.2	106	33.8	106
9	K7	704	43.8	5.5	5.5	91	15	22.23	21.1	0	0	0	0	0	0	43.8	106	60.2	106
10	K5	1375	-14.8	5.5	5.5	91	15.94	17	2.6	930	63	875	56	-315	30	-20.2	106	-6.8	106
11	K4	1375	0	5.5	5.5	91	16.47	16.47	-0.6	755	91	688	83	-312	38	-6.8	106	6.8	106
12	K3	1375	14.8	5.5	5.5	91	17	15.94	2.6	589	126	520	119	-277	43	6.8	106	20.2	106
13	K2	1375	28.3	5.5	5.5	91	17.05	15.98	2.6	592	148	521	139	-281	51	20.2	106	33.8	106
14	K1	704	43.8	5.5	5.5	91	15	22.23	21.1	0	0	0	0	0	0	43.8	106	60.2	106
15	L3	1975	49.7	9.1	9.1	91	16.12	18.31	5.9	1544	201	1437	165	-565	115	43.8	106	60.2	106
16	C3	0	-13	11.5	11.5	91	16.64	16.23	0.6	0	0	0	0	0	0	-20.2	106	-6.8	106
17	C2	0	13	11.5	11.5	91	16.23	16.64	0.6	0	0	0	0	0	0	6.8	106	20.2	106
18	C1	0	37.8	11.5	11.5	91	15.52	16.16	1.3	0	0	0	0	0	0	33.8	106	43.8	106
19	PA1	770	48.9	16.7	16.7	91	15.84	18.78	8.2	664	67	629	54	-214	40	43.8	106	60.2	106
20	C7	300	-13	17.5	17.5	91	16.64	16.23	0.6	150	19	135	18	-65	7	-20.2	106	-6.8	106
21	C6	300	13	17.5	17.5	91	16.23	16.64	0.6	179	20	165	18	-68	9	6.8	106	20.2	106
22	C5	300	37.8	17.5	17.5	91	15.52	16.16	1.3	194	17	188	16	-50	6	33.8	106	43.8	106
23	L7	968	-7.9	20	20	91	19.4	15.04	12.5	80	122	62	122	-51	9	-20.2	106	-6.8	106
24	L6	968	7.9	20	20	91	15.04	19.4	12.5	1149	11	1146	9	-84	7	6.8	106	20.2	106
25	L5	1320	21.2	20	20	91	15.03	19.59	13.1	1597	15	1594	11	-106	10	20.2	106	33.8	106
26	L4	1309	40.5	20	20	91	16.43	15.36	2.6	442	133	404	130	-180	29	33.8	106	43.8	106
27					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
28					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
29					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
30					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
31					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
32					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
33					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
34					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
35					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
36					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
37					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
38					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
39					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
40					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
41					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
42					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
43					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
44					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
45					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
46					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
47					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
48					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
49					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
50					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
51					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
52					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
53					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
54					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
55					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
56					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
57					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
58					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
59					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
60					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
61					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
62					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
63					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
64					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
65					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
66					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
67					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
68					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
69					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
70					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
71					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
72					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
73					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
74					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
75					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
76					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
77					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
78					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
79					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
80					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
81					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
82					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
83					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
84					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
85					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
86					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
87					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
88					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
89					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
90					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
91					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
92					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
93					0	91	16.47	42.72	78.1	0	0	0	0	0	0	-6.8	106	40	106
94						91