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.
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.