MH370 Doppler reconstruction

Still loading...

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC
1
2		Edit values in green cells to calculate Doppler data for possible projected routes.
3
4
5		Inmarsat 3-F1 orbit:
6
7		Earth radius	6371
8		Perigee	35769
9		Apogee	35816.2
10		Inclination	1.7
11		Eccentricity	0.000560
12		p	42,163.59
13		Time @ N point	18:17:00
14
15
16
17	Time (UTC)	Sat radial speed, km/h	Sat N/S pos, km	Sat N/S speed, km/h	Latitude, deg	Longitude, deg	Speed, kts	Heading	Climb rate, fpm	Latitude, rad	Longitude, rad	Plane x	Plane y	Plane z	Plane V_ns	Plane V_we	Plane vx, km/h	Plane vy, km/h	Plane vz, km/h	Sat vy, km/h	Sat vz, km/h	rx, km	ry, km	rz, km	r	delta v	Doppler shift	Doppler shift (abs)	Arc
18	16:30:00	0.5	1,117.12	-147.41	3	102	0	0	0	0.05	0.65	3,873.10	333.43	5,047.53	0.00	0.00	0.00	0.00	0.00	147.41	0.50	3,873.10	-783.68	-37,116.06	37,325.82	-3.59	-5.33	5.33	37.69
19	16:55:00	0	1,171.78	-114.70	4	102.19	468	25	3000	0.07	0.66	3,885.67	444.42	5,029.28	424.15	197.79	256.36	783.62	-212.45	114.70	0.00	3,885.67	-727.36	-37,134.30	37,344.13	-171.55	-254.33	254.33	37.93
20	17:07:00	-0.5	1,193.10	-98.48	5.29	102.8	480	25	0	0.09	0.67	3,931.79	587.39	4,978.52	435.03	202.86	248.80	802.24	-291.14	98.48	-0.50	3,931.79	-605.71	-37,185.07	37,397.27	-251.43	-372.75	372.75	38.61
21	17:30:00	-3	1,224.79	-66.69	7	103	480	230	0	0.12	0.67	3,936.48	776.43	4,948.83	-308.54	-367.70	-489.59	-567.15	478.42	66.69	-3.00	3,936.48	-448.36	-37,214.76	37,425.06	419.63	622.10	622.10	38.97
22	18:20:00	-3	1,250.89	4.29	7	96	480	285	0	0.12	0.55	3,304.03	776.43	5,391.68	124.23	-463.64	-746.79	228.36	424.75	-4.29	-3.00	3,304.03	-474.46	-36,771.91	36,923.09	362.16	536.90	536.90	32.11
23	18:30:00	-5	1,248.99	18.57	7	95	400	188	0	0.12	0.53	3,209.42	776.43	5,448.52	-396.11	-55.67	-43.46	-728.12	129.36	-18.57	-5.00	3,209.42	-472.56	-36,715.06	36,858.10	120.96	179.32	179.32	31.14
24	19:45:00	-6	1,159.91	122.69	-1.25	93.83	400	175	0	-0.02	0.51	3,120.17	-139.23	5,552.91	-398.48	34.86	48.39	-737.80	-45.69	-122.69	-6.00	3,120.17	-1,299.14	-36,610.68	36,766.35	-57.15	-84.72	84.72	29.72
25	20:40:00	-6	1,015.28	191.35	-7.34	94.36	400	178	0	-0.13	0.52	3,146.42	-813.95	5,479.70	-399.76	13.96	-24.68	-734.28	-94.90	-191.35	-6.00	3,146.42	-1,829.23	-36,683.88	36,863.98	-117.51	-174.21	174.21	31.23
26	21:40:00	-6	791.51	253.62	-14.00	94.60	400	182	0	-0.24	0.53	3,100.07	-1,541.58	5,348.15	-399.76	-13.96	-112.21	-718.35	-142.02	-253.62	-6.00	3,100.07	-2,333.09	-36,815.43	37,019.32	-173.96	-257.89	257.89	33.51
27	22:40:00	-5	513.81	298.61	-20.67	94.36	400	184	0	-0.36	0.52	2,967.83	-2,248.38	5,169.76	-399.03	-27.90	-174.66	-691.45	-200.45	-298.61	-5.00	2,967.83	-2,762.19	-36,993.83	37,215.33	-237.37	-351.91	351.91	36.23
28	24:10:00	-5	38.20	327.36	-30.64	93.61	400	186	0	-0.53	0.51	2,666.96	-3,247.02	4,788.93	-397.81	-41.81	-250.34	-633.88	-290.37	-327.36	-5.00	2,666.96	-3,285.22	-37,374.66	37,613.44	-328.08	-486.38	486.38	41.30
29
30
31
32
33
34
35
36
37
38			Measured	Predicted	Predicted north
39		16:30:00	80	5.33	80
40		16:55:00	165	254.33	165
41		17:07:00	130	372.75	130
42		17:30:00		622.10
43		18:25:00	270	536.90	270
44		18:29:00	145	179.32	170
45		19:45:00	110	84.72	195
46		20:40:00	140	174.21	220
47		21:40:00	170	257.89	210
48		22:40:00	205	351.91	200
49		23:59:00	250	486.38	190
50
51
52
53
54
55
56		Possible S route 1:
57		Time	Latitude	Longitude	Speed	Heading	Notes
58		16:30:00	3	102	0	0
59		16:55:00	4	102.19	468	25
60		17:07:00	5.29	102.8	480	25
61		17:30:00	7	103	480	230
62		18:25:00	7	96	480	285
63		18:29:00	7	95	450	185	W of Malaysia
64		19:45:00	-2.34	94.18	450	180
65		20:40:00	-9.21	94.18	450	186
66		21:40:00	-16.67	93.38	450	192
67		22:40:00	-24.01	91.75	450	197
68		24:10:00	-34.77	88.15	450	203	South Indian Ocean, west of Australia
69
70		Possible S route 2:
71		Time	Latitude, deg	Longitude, deg	Speed, kts	Heading
72		16:30:00	3	102	0	0
73		16:55:00	4	102.19	468	25
74		17:07:00	5.29	102.8	480	25
75		17:30:00	7	103	480	230
76		18:25:00	7	96	480	285
77		18:29:00	7	95	400	188
78		19:45:00	-1.25	93.83	400	175
79		20:40:00	-7.34	94.36	400	178
80		21:40:00	-14.00	94.60	400	182
81		22:40:00	-20.67	94.36	400	184
82		24:10:00	-30.64	93.61	400	186
83
84		Possible N route 1:
85		Time	Latitude	Longitude	Speed	Heading
86		16:30:00	3	102	0	0
87		16:55:00	4	102.19	468	25
88		17:07:00	5.29	102.8	480	14
89		17:30:00	7	103	480	230
90		18:25:00	7	96	480	285
91		18:29:00	7	95	450	328
92		19:45:00	14.95	89.99	450	335	Bay of Bengal
93		20:40:00	21.18	86.99	450	327	Eastern India
94		21:40:00	27.47	82.61	450	318	India/Nepal border
95		22:40:00	33.04	76.95	450	311	Kashmir
96		24:10:00	40.43	66.82	450	302	Eastern Uzbekistan
97		Possible N route 2:
98		Time	Latitude	Longitude	Speed	Heading
99		16:30:00	3	102	0	0
100		16:55:00	4	102.19	468	25