CityCyclingEdinburgh was launched on the 27th of October 2009 as "an experiment".
IT’S TRUE!
CCE is 15years old!
Well done to ALL posters
It soon became useful and entertaining. There are regular posters, people who add useful info occasionally and plenty more who drop by to watch. That's fine. If you want to add news/comments it's easy to register and become a member.
RULES No personal insults. No swearing.
You need a GPS / phone type device with a cadence sensor for this to work.
I just posted a step-by-step guide to graphing gear inches by time or distance on my blog. It comes out with stuff like this (for a 200km brevet):
For instance, it shows I shouldn't worry much about gearing over 90" on a future brevet bike (but want to get the range from 60-85" on a single chainring if possible). :thumbsup:
Quite interesting that, although I confess to skim reading most of the Excel stuff. I've sometimes wondered how much I use each gear.
Could you regraph it showing distance by gear? That would presumably push the peak towards the right?
I've followed the guide for wee blue floofy, but it keeps coming out as a single vertical line.
Is that because it has one gear? ;-)
Does this mean you have a couple of gears under 20" one of which is almost 0?
Would join the dots be better than smooth curve?
There's a lot of fuzz because, for instance, if you soft pedal or half turn the cranks to corner going downhill (so the cadence sensor registers a cadence but you didn't engage the cassette) that will create a false reading. I didn't try to manicure it too much - although maybe that's a whole follow-up article?
Bar chart would probably be best, possibly with the points forceably fitted to known gearing.
For instance, one sample 2x10 drivetrain I just generated figures for gives:
28,32,36,39,41,42.5,47,52.6,57,59.5,62.5,69,77,81,87.5,119
Would join the dots be better than smooth curve?
Is there ever a case when it's not?
Yes, in physics where there is a mathematical function behind the results a smooth curve is justified.
In biology we would join the dots because we rarely have the same kind of data, it's a bit more subject to random forces.
Should it not be a bar chart displaying time spent in each gear?
You must log in to post.
Cycling in Edinburgh Flickr group
Video embedded using Easy Video Embed plugin
posts