Originally Posted by
ESBKLife
Hello all. I'm Derrick and new to the forum. I've had RaceRender for a while now but need help converting GPS coordinates. My data logger (i2M Chrome Pro2) or I should say, the data analysis tool (Danas) exports Longitude and Latitude "expressed in decimal mins" according to the manufacturer. RaceRender wants decimal degrees. Can anyone help with the conversion formula? Attached is a sample of the values in my data file.
screenshot.JPG
If RaceRender isn't able to automatically detect the LAT/LON columns, then you may need to edit the data in Excel or Google Sheets in order to get it into a format that it recognizes.
To do that, I'd recommend changing the LAT column name to "LAT DMS", and LON column name to "LON DMS". Then you can create a new LAT column with the following formula (assuming the first LAT DMS value is in cell G3):
Code:
=LEFT(G3,2) + MID(G3, 3, 2) / 60 + RIGHT(G3,4) / 100 / 60 / 60
And use this formula for the LON column (assuming the first LON DMS value is in I3):
Code:
=LEFT(I3,3) - MID(I3, 3, 2) / 60 - RIGHT(I3,4) / 100 / 60 / 60
You should then be able to select that cell, and click and drag the little square on the bottom right all the way down the entire spreadsheet and have Excel/Google Sheets automatically apply the formula to the corresponding cell in the LAT DMS/LON DMS column.