header ad

Track your rides with GPS and chart your stats.

HOME FORUM RIDING FEELS GOOD FORUM TALKING ABOUT BIKES Track your rides with GPS and chart your stats.


This topic contains 8 replies, has 5 voices, and was last updated by  secret agent 8 years, 7 months ago.

Viewing 9 posts - 1 through 9 (of 9 total)

  • Author
  • #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.


    Nick Boers

    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.



    I use http://www.sports-tracker.com/ and their app to record my rides sometimes. Simple to use and nice diary of rides.



    So Strava does what I was doing basically?

    Definitely going to check that out tonight!



    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?


    Nick Boers

    I’m using the Strava Android app.

    A couple of guys on here upload data from Garmin devices



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





    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 spreadsheet


    secret agent

    I have been using Sportstracker suggested by someone on this forum a while back. It looks like it does the same thing as Strava. At any rate, it works great.


Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic.

People Who Like Thisx


People Who viewed ThisX