Been trying to catch up, seems I have missed so much on here some great inspiration from the newer members to those just joining, seems
@Mo1959 and myself will need to be catching a few up as it is.
Well since I can't get out until at least ( probably) the middle of next week I have been delving into access a little more
@Stonechat ( hope I have that right and it's not
@morrisman, morphine does weird things to your day ) I can now do some sort of pretty charts close to those I did in Excel, this is a rolling 30day showing avg cad, gear inch, distance covered, max avg speed in the 30 day period and the avg sp for the same period, thats the light blue and red lines at the bottom.
I have filtered it from Aug 2012 as i didn't have a cad sensor before that.
You can see that as of today working backwards the last 30 days are actually my quickest avg, but thats not the full story as anyone would know, however what is interesting is my avg cad whilst that had been going up my gear length had gone down my speed was picking up, gradually, toward the end my (reading right to left as the latest dates are on the left) my gear length was beginning to increase, this would have lead to a higher sustainable avg speed I hope.