MapMyRide or Strava

[huwsparky]

@Drago I liked endo, I just upload for fun, I keep my own database which gives stats much better than many a site, though not so much about the ride details as totals and averages for example it does rolling 7, 30 ,90 ,180 and 360 day tables, also by month quarter ect, and weather which gives max min temps winds rain and said totals for the previous mentioned tables.

What do you do with/need the data for?

I only really use average speed and elevation.

 

[Nigelnaturist]

I was just developing a database, and looked for different ways to analyse the data, one interesting one is how the gearing is set up.

In blue is my current setup, though there have been many short rides these last 6 weeks or so, however it does show that using a closer grouped cassette the 12-23 I am spinning slower and using a higher gear, but I haven't had it on that long as the mileage shows, however you can see that per mile the riding is more difficult, though overall per day much easier, so this along with the higher gear contributes to a lower cad.
It also gives me some idea how to gear the bike as my average gear is about 61" or a 38x17 or there abouts giving me a pretty straight chain line on my triple.
A separate table shows the mileage each component has done.
Edit some of the avg cad on the current set up is from a zero average rather than a non zero in my case about 3-4rpm difference.