My manual calculations for Q1_M1N1FKxe and Q2_M1N1FMze.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	AH
1		OpenFAST Output
2	1	Time	M1N1TDxss	M1N1TDyss	M1N1TDzss	M1N1RDxe	M1N1RDye	M1N1RDze	M1N2TDxss	M1N2TDyss	M1N2TDzss	M1N2RDxe	M1N2RDye	M1N2RDze	M1N1FKxe
3		(s)	(m)	(m)	(m)	(rad)	(rad)	(rad)	(m)	(m)	(m)	(rad)	(rad)	(rad)	(N)
4		0	7.69E-04	1.49E-03	-2.60E-03	-2.80E-04	-2.13E-05	-8.80E-06	1.02E-05	1.29E-03	-3.22E-03	2.85E-06	-4.45E-05	-2.32E-05	2.67E+01
5
6	2	MemberID	Star Joint ID	End Joint ID	Diameter /m		Coordinates				Coordinate Difference			Length
7		61	5	43	0.8		JointID	x	y	z	dx	dy	dz	Lexy	Le
8		Elements	Star node	End node	Thickness /m		5	5.333	5.333	-24.614	-5.333	-0.269	8.243	5.340	9.821
9		122	125	43	0.02		43	0	5.064	-16.371
10
11	3	Translational displacement transformation (from global to local coordinate system)；local=Dc*U								Ux1-Ux2(m)	θy1+θy2(rad)	Fxe(N)
12		Coordinates	Dc（direction cosine matrix）			Global-Node 1	Local-Node 1(Ux1)	Global-Node 2	Local-Node 2(Ux2)	1.63E-04	-6.58E-05	6.99E+01
13		Ux(m)	-5.04E-02	9.99E-01	0.00E+00	7.69E-04	1.45E-03	1.02E-05	1.28E-03	1.63E-04=1.45E-03-1.28E-03		≠26.66(M1N1FKxe)
14		Uy(m)	-8.38E-01	-4.23E-02	-5.44E-01	1.49E-03	7.06E-04	1.29E-03	1.69E-03	-6.58E-05=-2.13E-05-4.45E-05
15		Uz(m)	-5.43E-01	-2.74E-02	8.39E-01	-2.60E-03	-2.64E-03	-3.22E-03	-2.74E-03	6.99E01=6.63E+071.63E-04-6.58E-051.63E+08
16
17	4	Member Parameters			Element Stiffness Calculation
18		ShearG	(N/m2)	8.08E+10	k11=-k17
19		Area-Az	m^2	0.049	6.63E+07	=122.1E+113.73E-03/(4.911^3*(1+1.97E-01))
20		YoungE	(N/m2)	2.10E+11	K15=k1,11
21		Length-le	m	4.911	1.63E+08	k11Le0.5=6.63E+074.910.5
22		Jx/Jy	m^4	3.73E-03
23		Shear/kay	-	5.01E-01
24		Asy	m^2	2.45E-02
25		Ksy	-	1.97E-01
26		Ksy=122.1E+113.73E-03/(8.08E+102.45E-24.911^2); Asy=5.01E-01*0.049
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56		2.65	2.77E-03	7.83E-04	-3.20E-03	-9.99E-05	-2.29E-04	5.23E-05	2.50E-03	3.22E-04	-3.04E-03					2.51E+03
57		2.7	2.17E-03	1.48E-03	-3.32E-03	-1.29E-04	-1.88E-04	7.68E-05	2.55E-03	1.26E-03	-3.24E-03					5.91E+03
58		2.75	2.33E-03	2.23E-03	-3.46E-03	-1.45E-04	-1.29E-04	1.17E-04	3.14E-03	2.31E-03	-3.45E-03					6.49E+03
59		2.8	3.00E-03	2.99E-03	-3.56E-03	-1.57E-04	-6.96E-05	1.35E-04	3.67E-03	3.31E-03	-3.61E-03					3.97E+03
60		2.85	3.58E-03	3.72E-03	-3.63E-03	-1.70E-04	-3.18E-05	1.15E-04	3.69E-03	4.02E-03	-3.73E-03					2.62E+03
61		2.9	3.66E-03	4.26E-03	-3.66E-03	-1.88E-04	-9.63E-06	8.46E-05	3.20E-03	4.33E-03	-3.80E-03					4.91E+03
62		2.95	3.25E-03	4.47E-03	-3.63E-03	-2.07E-04	6.57E-06	7.26E-05	2.55E-03	4.24E-03	-3.82E-03					7.62E+03
63		3	2.69E-03	4.31E-03												7.21E+03
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