First, a big H/T to mm43 for setting up this thread.
One of the first posts on pprune on trying to replicate the earliest released INMARSAT data was by hamster3null on 28 Mar 2014 at 02:13:
http://www.pprune.org/rumours-news/5...ml#post8405984
He links to his own spreadsheet, very nicely organized, that calculates both aircraft and satellite Doppler at "ping" times along several hypothesized flight paths. He invites users to download spreadsheet and modify as desired.
At that time, hamster3null and many others of us were taking the INMARSAT graph to represent Doppler resulting purely from dividing line of sight rate by appropriate L-band wavelength (about 0.2 m). The trends were similar, but there was an obvious scaling problem.
Mike Exner has apparently explained and reconciled the burst frequency offset (BFO) data with the line of sight rates (see below).
An analysis by John Zweck, an Australian with a Ph.D. in mathematics, now teaching in the US:
https://www.siam.org/news/news.php?id=2151
Links to older Zweck material on MH370 on this page:
John Zweck
Zweck's updated spreadsheets and other analyses:
Aqqa on MH370
In the "Freq" worksheet in his latest 10 MB spreadsheet (
http://www.aqqa.org/MH370/models/Dop...84_v6-6-9.xlsx), Zweck says he is using INMARSAT position data provided by Shadoko, and Dopper data derived from BFO data by Mike Exner (airlandseaman):
Background Information on the Pinging of MH370 by Inmarsat-3F1 | Duncan Steel
Exner links to other MH370 material on his Twitter account:
https://twitter.com/Airlandseaman
Michael Exner | LinkedIn