Nokia Sportstracker Total Metres Gained tutorial

WolfCreekPsycho

Likes Dirt
Hey guys,

A quick tut' for those who use Nokia Sportstracker for their rides. I quite like this product for a real cheap GPS training/ride tool but one of the things missing is your total verticle metres gained during a ride.
It seems like a lot of steps, but the whole process is very quick and can be done in around 1 - 2 mins when you know what your doing.

If you already know how to do this skip straight to step 11:


Step 1:
Upload your ride to Sportstracker

Step 2: When reveiwing your ride, click "Other Options" button and "Download as KML file" and save it

Step 3: http://www.gpsvisualizer.com/elevation Go here, and Browse to your file for upload. Click on "Convert and Add Elevation" Select Output = Plain Text
** Clicking the Draw Elevation Profile will also give a much better looking graph than Sportstracker

Step 4: When presented with all the text, ignore the first 6 lines and select/Copy all the data below the second Type Latitude Longitude heading..

Step 5: Open and Excel spreadsheet and paste all the data into Cell A1

Step 6: Select Data / Text to Columns and select "Delimited" then on the next screen click "Space" then select Finish

Step 7: Highlight everything from Row E to Row IV and delete it.. you really only care about the Altitude column

Step 8: In row E, next to the SECOND altitude value... enter this formula "=IF(D3>D2,(D3-D2),0)" this checks if there is a positive elevation change from the previous GPS point.

Step 9: Copy this formula all the way down till there are no more alititude values beside it.

Step 10: Add up (sum) all these values and you now have total metres gained for your ride.

Step 11: ????

Step 12: Profit.
 

Big Chuck

Likes Dirt
Thanks, worked well. Did 1542.2 metres on the Oaks up and back.

Notes for the Nokia E51, E71 and 6120 Navigator with Sports Tracker version 2.06.
Step 2: When reviewing your ride, click "Options" button, then "Export" then "Export as Google Earth" and save it.

Formula for Open Office Calc
Step 8: In row E, next to the SECOND altitude value... enter this formula "=IF(D3>D2;(D3-D2);0)" this checks if there is a positive elevation change from the previous GPS point.
 
Top