b.xlsx

	A	B	D	E	F	I	J	L	M	N	S
1	F =	(TargetHeading - Heading)
2	O =	(TargetElevation + 90)

3	R =	(TargetDistance)
4
5	A =	(RollAngle + 0)	PLEASE MAKE A COPY BEFORE EDITING THIS!!!!!
6	B =	-PitchAngle	divide code by rotator angle
7
8	X cockpit	0.0000
9	Y cockpit	5,1095		Leading?							EE
10	Z cockpit	5,0742		Cannon?
11				Velocity	1000	Elevation =	clamp(acos((cos((RollAngle + 0)) * (-sin(-PitchAngle)) * (((TargetDistance) * sin((TargetElevation + 90)) * cos((TargetHeading - Heading)))+0.0000) + sin((RollAngle + 0)) * (((TargetDistance) * sin((TargetElevation + 90)) * sin((TargetHeading - Heading)))+0.0000) + cos((RollAngle + 0)) * cos(-PitchAngle) * (((TargetDistance) * cos((TargetElevation + 90)))+0.0000)) / (TargetDistance)) - 90, -5,)
12	X Turret	0.0000		Left Angle	-120	Heading =	clamp(deltaangle(0,atan((sin((RollAngle + 0)) * sin(-PitchAngle) * (((TargetDistance) * sin((TargetElevation + 90)) * cos((TargetHeading - Heading)))+0.0000) + cos((RollAngle + 0)) * (((TargetDistance) * sin((TargetElevation + 90)) * sin((TargetHeading - Heading)))+0.0000) + cos(-PitchAngle) * (-sin((RollAngle + 0))) * (((TargetDistance) * cos((TargetElevation + 90)))+0.0000)) / (cos(-PitchAngle) * (((TargetDistance) * sin((TargetElevation + 90)) * cos((TargetHeading - Heading)))+0.0000) + sin(-PitchAngle) * (((TargetDistance) * cos((TargetElevation + 90)))+0.0000))) + (((cos(-PitchAngle) * (((TargetDistance) * sin((TargetElevation + 90)) * cos((TargetHeading - Heading)))+0.0000) + sin(-PitchAngle) * (((TargetDistance) * cos((TargetElevation + 90)))+0.0000)) < 0) ? (((sin((RollAngle + 0)) * sin(-PitchAngle) * (((TargetDistance) * sin((TargetElevation + 90)) * cos((TargetHeading - Heading)))+0.0000) + cos((RollAngle + 0)) * (((TargetDistance) * sin((TargetElevation + 90)) * sin((TargetHeading - Heading)))+0.0000) + cos(-PitchAngle) * (-sin((RollAngle + 0))) * (((TargetDistance) * cos((TargetElevation + 90)))+0.0000))>0) ? 180 : -180) : 0)),-120,120)
13	Y Turret	5,1037		Right Angle	120
14	Z Turret	4,7875		Up Angle	145
15				Down Angle	-5
16	∆Z	0,0000		Start heading	0
17	∆X	0,0000		Roll position	0
18	∆Y	0,0000
19
20	∆Z	0.0000							-0.0077
21	∆X	0.0000						3,3762	2,5526	0,8236
22	∆Y	0.0000						-0.0960	5.9415	#VALUE!
23
24	Zsp =	((TargetDistance) * sin((TargetElevation + 90)) * cos((TargetHeading - Heading)))
25	Xsp =	((TargetDistance) * sin((TargetElevation + 90)) * sin((TargetHeading - Heading)))
26	Ysp =	((TargetDistance) * cos((TargetElevation + 90)))
27
28
29
30	Zsp + p =	(((TargetDistance) * sin((TargetElevation + 90)) * cos((TargetHeading - Heading)))+0.0000)
31	Xsp + p =	(((TargetDistance) * sin((TargetElevation + 90)) * sin((TargetHeading - Heading)))+0.0000)
32	Ysp + p =	(((TargetDistance) * cos((TargetElevation + 90)))+0.0000)
33
34
35
36	Zspc + p =	(cos(-PitchAngle) * (((TargetDistance) * sin((TargetElevation + 90)) * cos((TargetHeading - Heading)))+0.0000) + sin(-PitchAngle) * (((TargetDistance) * cos((TargetElevation + 90)))+0.0000))
37	Xspc + p =	(sin((RollAngle + 0)) * sin(-PitchAngle) * (((TargetDistance) * sin((TargetElevation + 90)) * cos((TargetHeading - Heading)))+0.0000) + cos((RollAngle + 0)) * (((TargetDistance) * sin((TargetElevation + 90)) * sin((TargetHeading - Heading)))+0.0000) + cos(-PitchAngle) * (-sin((RollAngle + 0))) * (((TargetDistance) * cos((TargetElevation + 90)))+0.0000))
38	Yspc + p =	(cos((RollAngle + 0)) * (-sin(-PitchAngle)) * (((TargetDistance) * sin((TargetElevation + 90)) * cos((TargetHeading - Heading)))+0.0000) + sin((RollAngle + 0)) * (((TargetDistance) * sin((TargetElevation + 90)) * sin((TargetHeading - Heading)))+0.0000) + cos((RollAngle + 0)) * cos(-PitchAngle) * (((TargetDistance) * cos((TargetElevation + 90)))+0.0000))
39
40
41
42
43
44
45
46
47
48
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