tiger beetle
06-29-2021, 11:44 AM
I've assembled a spreadsheet that accepts position reports (boat, date/time, lat, lon) and produces distance/speed run/made good. Given that the trackers are not sending data at convenient 24 hour intervals, the run distances are normalized to 24 hours; this introduces errors and estimation into the resulting values but does allow direct boat-to-boat comparisons. As a skipper on the course I would not be interested in these numbers, but the folks on shore might.
Here are the numbers from 6/28-29 time period, as a .JPG graphic. If anybody would like the spreadsheet to play with, let me know. The same position was received at my end for Northern Star for both 6/28 and 6/29 - that's why the zeros.
There's a chance there are errors in my spreadsheet, I'm continuing to look at it in between time spent changing out the raw water pump on the engine.
- rob/beetle
6576
Here are the numbers from 6/28-29 time period, as a .JPG graphic. If anybody would like the spreadsheet to play with, let me know. The same position was received at my end for Northern Star for both 6/28 and 6/29 - that's why the zeros.
There's a chance there are errors in my spreadsheet, I'm continuing to look at it in between time spent changing out the raw water pump on the engine.
- rob/beetle
6576