Show us your.......newbie progress! [4 Sep 2012 - 4 Oct 2014]

Status
Not open for further replies.
Page may contain affiliate links. Please see terms for details.
I did do a spread sheet with that info, didn't do one on the database another routine to work out.
I have an excel spreadsheet that calculates it for me... just uses the
=COUNTIF(B:B,">="&D3)
command and where your route mileage is in column B and your reference (in this case the number 1) is in cell D3... make d4 to be number 2, d5 = 3 and so on. Put the command above into E3 and then copy the command down. Just add new data to the bottom of the data in column B and it auto-updates. you then just have to compare one column of numbers with another column
 
Location
Pontefract
I have an excel spreadsheet that calculates it for me... just uses the command and where your route mileage is in column B and your reference (in this case the number 1) is in cell D3... make d4 to be number 2, d5 = 3 and so on. Put the command above into E3 and then copy the command down. Just add new data to the bottom of the data in column B and it auto-updates. you then just have to compare one column of numbers with another column
I did something similar for rides between say 0-10 miles 10-20 miles ect, but I do all my stuff in Access now (miss the pretty charts excel did) I will have to have a think about it for Access.
 
mine is only 51 (in miles that is) but I have only recorded rides since we set out rtw on the 28th February 2011 (and I have ridden most of my life).
need another 7 ride of +52 miles to up it one more so think I might have to extend that commute of mine :whistle: (when I am feeling a touch better - been off colour for the last few days and having to take it easy, i.e. no riding
Well I did a lot of rides over 50 miles in my birdwatching days, no record of them now
 

Biggler

Veteran
Location
Teesside
Mo time is the best time.. http://www.strava.com/activities/145700195
33.1 miles, the longest I've done and my Garmin goes and corrupts the data, the distance is correct though. Should I just go make a manual entry or is there a way to recover the data?
I think I'll create a GPX of the route and upload that then give my ride commentary... so much faffing! silly Garmin
 
Last edited:
Location
Pontefract
Mo time is the best time.. http://www.strava.com/activities/145700195
33.1 miles, the longest I've done and my Garmin goes and corrupts the data, the distance is correct though. Should I just go make a manual entry or is there a way to recover the data?
I think I'll create a GPX of the route and upload that then give my ride commentary... so much faffing! silly Garmin.
How do you mean corrupted. Try copying the file from the unit to your computer and upload that.

Edit, long shot, but has the gps track option been turned off some how, not the thing you do but the 510 being new something may have changed it.
 
Location
Pontefract
I had a look, have a look hoe big the file is compared with the last ride, this will give you an indication of how much data was recorded. Should be approx 3 time, though not quite as the header is only produced once, opposed to the gps plots.
 
Status
Not open for further replies.
Top Bottom