Tagged: Cross Country
April 13, 2012 at 2:34 pm #506283
Does anyone here use a GPS tracker on their phone (or another device) to track their rides?
I have been doing this for a while on my Android phone using a free GPS tracker application. I use one called ‘GPS Essentials’, which not only tracks where you go but also gives you various stats about the ride.
So, the other day while I was bored I thought it would be useful (or useless maybe…) to make a spreadsheet that will track all of my daily rides and calculate some information based on those facts.
This is a link to an example of the spreadsheet. Please note that this is just an imported version of an Excel file. Google documents has a few limitations that alters how the sheet looks and works. For example, the first 14 rows should be frozen, not the first 10. There is also conditional formatting for every column, by month, to highlight important figures.
What you see is also incomplete. I’m still finishing it up.
But if you’re interested in this, I can email anyone a copy of the actual Excel file to use when it is done. Or in its current state if you’d like that.April 13, 2012 at 4:52 pm #649326
I’ve been using a spreadsheet for tracking component changes, tire wear and chain stretch for the past few years to get an idea of how quickly I go through things, as well as to see how far I’m riding in a year.
Recently I downloaded the Strava app. It makes maps, gives you stats, but I think the coolest part about it is that it lets you define segments of your ride as time trials. My default these segments become public, and anyone who rides over them gets put into the leader board. Example: http://app.strava.com/rides/6351708 I scored right up near the top on the three big climbs, WOO! 8)
Also interesting… I see that since I did that ride someone has added a segment on Altona Rd Southbound. It took my ride data from before the segment was defined and put me at the top of the list. I credit the awesome tailwind I had. I suffered through every part of that ride except for the few parts I was pointing South.
It’s crazy when you see how fast some people go through parts of the Don, especially Ghettocruiser on his everyday afternoon commute home. Dude is FAST.April 13, 2012 at 5:14 pm #649327
I use http://www.sports-tracker.com/ and their app to record my rides sometimes. Simple to use and nice diary of rides.April 13, 2012 at 5:18 pm #649328
So Strava does what I was doing basically?
Definitely going to check that out tonight!April 13, 2012 at 5:38 pm #649329
Just registered to Strava and uploaded one of my .gpx files.
I think its safe to say that I’m just going to delete that spreadsheet now haha
That is an amazing service, thanks for pointing that out! Do you use the Strava app, or a different GPS app?April 13, 2012 at 6:12 pm #649330
I’m using the Strava Android app.
A couple of guys on here upload data from Garmin devicesApril 14, 2012 at 1:54 am #649331
@nick Boers wrote:
It’s crazy when you see how fast some people go through parts of the Don, especially Ghettocruiser on his everyday afternoon commute home.
Sounds like he’s a hack, and a danger to himself and others. 😀
***EDITED TO PRESERVE THE ANONYMITY OF ANOTHER STRAVA AND RFG MEMBER***April 14, 2012 at 6:33 pm #649332
Here is my account if anyone wants to follow or link accounts or whatever. This is so much easier than trying to use my stupid spreadsheetApril 18, 2012 at 2:49 pm #649333
You must be logged in to reply to this topic.