Trackmaster Forums
Categories » Trackmaster Questions or Issues » Editing GPS data
Combination View Flat View Tree View
Threads [ Previous | Next ]
Editing GPS data
toggle
Editing GPS data
6/3/10 11:44 AM
Hey,

I forgot to turn lapping on when I was at the track last weekend. So, my files only show one lap. Is there a good way to edit them to show multiple laps? I was thinking it would be possible with editing the data as a spread sheet, but have no experience with GPS data and would not be able to really tell where a start/stop point would be. And then would the data be imported back to the phone? And then back to google earth or can it be done in google earth?

Any tips or suggestions?
RE: Editing GPS data
6/3/10 12:07 PM as a reply to Matt Brost.
Sorry, there isn't a way to convert your non-lapping data to lapping.

Jeff
RE: Editing GPS data
6/3/10 1:00 PM as a reply to Jeff Trackaroo.
I was afraid of that...
RE: Editing GPS data
6/14/10 9:11 AM as a reply to Matt Brost.
If you're into analysis, this may work for you.

I did it in excel, by choosing a point (in Google Earth, then finding that sample in the data rows in excel), then adding a column for distance (and cumulative distance for a different reason). Then I added a column that tested for a sample point being within 40 feet (in 1s/sec native phone mode), and flagged the row as being a new lap start if it were within that distance. You could replace 40 with any other number...

=IF(40 > CONVERT(ACOS(COS(RADIANS(90-G$2)) *COS(RADIANS(90-G121)) +SIN(RADIANS(90-G$2)) *SIN(RADIANS(90-G121)) *COS(RADIANS(H$2-H121))) *(6371+(I121/1000)), "km", "ft"),1,0)

(column G is lat, H is long, I is alt)