Silly Commuter Stats
Comments
-
salsajake wrote:He's only gone and gone top 10!
I honestly take no delight in that at all.
I am not doing my victory dance, I have not booked a celebratory kit kat in for my afternoon coffee.
I am not trying.Fixed gear for wet weather / hairy roadie for posing in the sun.
What would Thora Hurd do?0 -
Greg T wrote:salsajake wrote:He's only gone and gone top 10!
I honestly take no delight in that at all.
I am not doing my victory dance, I have not booked a celebratory kit kat in for my afternoon coffee.
I am not trying.
Have you taken holidays and sick days into account?
FCN 2-4.
"What happens when the hammer goes down, kids?"
"It stays down, Daddy."
"Exactly."0 -
prawny wrote:Argh bumped out of the top 20, it's on now, I've got my eye on you king donut :evil:
So I see... we were locked on 2,679 until I posted last week's miles. A week away in September might require the target to be lowered somewhat.0 -
King Donut wrote:prawny wrote:Argh bumped out of the top 20, it's on now, I've got my eye on you king donut :evil:
So I see... we were locked on 2,679 until I posted last week's miles. A week away in September might require the target to be lowered somewhat.
Yeah I'm off for a week aswell and a day off to take the wife for her 20 week scan and another to watch the TOB, neither of which I can go by bike to, boooo! I mentioned taking my bike on holiday, I got a stoney look.Saracen Tenet 3 - 2015 - Dead - Replaced with a Hack Frame
Voodoo Bizango - 2014 - Dead - Hit by a car
Vitus Sentier VRS - 20170 -
prawny wrote:King Donut wrote:prawny wrote:Argh bumped out of the top 20, it's on now, I've got my eye on you king donut :evil:
So I see... we were locked on 2,679 until I posted last week's miles. A week away in September might require the target to be lowered somewhat.
Yeah I'm off for a week aswell and a day off to take the wife for her 20 week scan and another to watch the TOB, neither of which I can go by bike to, boooo! I mentioned taking my bike on holiday, I got a stoney look.
I know that look well! 0 -
salsajake wrote:Porgy wrote:
He's only gone and gone top 10! I was 31st yesterday, now 33rd and a whopping 242 miles off 30th. Grrrrrrrr. Having the most miles in September so far has just lost its sheen somewhat.
What's annoying is that if I'd been doing my current average monthly mileage back in January and onwards, I'd be top 5 now.
However, I'm hoping that once we hit January it'll be a rolling total - in which case by about June next year, you'll see me leap into 5th postion, or therabouts.0 -
nah,
we should reset in January to give all the hard core commuters a head start before all the fair weather sportive riders dust off their bikes Just Keep Pedalling0 -
Definitely a reset on Jan 1st, otherwise the gap increases exponentially and we'll never catch ITB, Rich etc.
Jan 1st = 0 miles.
0 -
Fair enough - Should be in the top5 in January then 8)0
-
If I started putting in my climb now - how is the climb ration calculated? - do I have to work out my climb for the whole year to date - or just add it on a daily basis. If year - I don;t think I can do it - I've had two quite different commute routes this year - one over Shooters Hill and the other around.0
-
Agree it should be reset, but I'll be playing catch up again if its as cold as last winter as I won't venture out if temperatures have fallen below zero overnight (having come off twice last winter, both times in front of cars!) Advantage southeners!0
-
salsajake wrote:Agree it should be reset, but I'll be playing catch up again if its as cold as last winter as I won't venture out if temperatures have fallen below zero overnight (having come off twice last winter, both times in front of cars!) Advantage southeners!
Nah it gets just as cold in the souf - its just we're so hard we don't take much notice of it. :P0 -
Climb Ratio is miles divided by feet (or is it miles divided into feet?) Who knows? It's in the SQL query anyway. It's a function of miles travelled and feet climbed, nothing more.
Suss the climb for your commutes and multiply them by the approximate number of commutes you think you've done for each, then add a bit on for other rides that you'll have done through the year. That's your start point. Once loaded the ratio doesn't change much. I need to add the climb onto the same page as the new miles add page to keep it simple.
On changes - I now no longer like the split of regulars, lapsed and everyone, so fancy tidying it up a bit. The intention was to chivvy people into updating stats if they've lapsed but it hasn't happened to any great extent. I plan to leave the split as is but dump the Everyone and Div 2 lists into their own new pages linked to from the bottom of the main page. It'll still be easily accessible but not cluttering up the main page. I still feel that if someone hasn't updated himself since June he's not really part of it so can be quietly hived off. The average stats and total will then show figures relevant to the page being shown for each of the listings.
Thoughts appreciated before I dive in and hack the source code about later this week.0 -
Ah - done it anyway. Fiddling about with Stats, or Relocation Relocation Room 101 on Dave +4 Deja Vu. Tough one that.
Any complaints, direct them to the usual PO Box number.
:idea:0 -
Looks good, Chris. 8)0
-
who is the newbie #75 that has just made 30th place even further away!?0
-
FCN 2-4.
"What happens when the hammer goes down, kids?"
"It stays down, Daddy."
"Exactly."0 -
That'll be LeeHellCat. Can't say I recognise the name. The more the merrier though, as long as they keep at it.salsajake wrote:who is the newbie #75 that has just made 30th place even further away!?
(Tip - sort the list on an empty column and the underlying sort is by user ID, which gives users sorted first to last. Obviously I'm first, LiT next then all the way down to our newest members.)0 -
ChrisInBicester wrote:(Tip - sort the list on an empty column and the underlying sort is by user ID, which gives users sorted first to last. Obviously I'm first, LiT next then all the way down to our newest members.)
Well, me being in third place is the closest I'm going to get to the top Giant Escape R1
FCN 8
"Build a man a fire, and he'll be warm for a day. Set a man on fire, and he'll be warm for the rest of his life."
- Terry Pratchett.0 -
I prefer to sort by September at the moment0
-
What is the 'Gap' column for?0
-
Getting a vague idea for yet another column (sorry Chris!!). Quite a good one though - basically, overall SCS hardness stat.
Climb ratio only tells you how hilly your area is - a cyclist who does one trip up a 1 in 3 will probably top the table. Similarly, total mileage only says how far from work home is and how dedicated a cycle commuter you are - but if the route is flat, then your grannys great aunt could get the same total. SCS hardness is an indicator of how much effort you have put in - perhaps in units of SCSWatts
Basically, take climb ratio and factor in overall distance to produce a number that gives your SCSWattage. As an example, if you order the Stats table to overall climb, you see me in 7th place and girv73 in 8th. girv is ahead of me in mileage at about 1800 to my 1600 but my total climb is almost twice girvs. So I've worked far harder for my 1600 than girv has for their 1800 so I'd expect my SCSWattage to be at least 30% higher than girvs. Square root (distance x climb) might work.
I'd test it to see if it works myself but Excel has fallen over on my home computer (managed to lose some small file somewhere).Faster than a tent.......0 -
I think the Climb Ratio calculation just needs a tweak, nothing more. At present it shows (miles / height gain) * 10 [to make it a sensibly sized number]. What you're asking - I think - is to show an inverse of that, where higher climbs for shorter mileages result in a larger CR value than high climbs over longer mileages, and small climbs in moderate mileages float downwards rather than upwards. I'll have a think.
Regardless, I'm up for anything that has a scale measured in hardness, the preferred unit of hardness being the Nail obviously. Hard, or Ard?
We're running out of width though. Since the climb columns went in and July became September the width of the table exceeds all but one of the monitors that I view it on, so it looks errrr.... crap. Adding more will make it worse.0 -
Not sure Rolf F is talking about an adaptation of the climb ratio - the climb ratio is what it is, but I agree that someone who rides a 3 mile section of hardknott pass and then does nothing else for the rest of the year will have the highest climb ratio on the table.
I think he means something calculated by something akin to Naismith's rule - a walking rule which says to allow 1 hour for every 3 miles forwards and half hour for every 1000' of ascent. So in walking terms, 1 unit of effort is around 1.5 miles or 500'. So someone walking 15 miles on the flat would have put in half the effort of someone walking 15 miles and climbing 5,000' at the same time. (Granted time isn't quite equal to effort, but you see the principle).
I don't know what the cycling equivalent is but I am sure some boffin has worked out how many watts of power it takes to go a mile on the flat and how many watts it takes to climb 'x' feet, although of course, the steeper the climb, the more watts, but we can't get into that level of detail. A general rule may be available on the internet, or even somewhere on bike radar...
Surely the only way you could do a true hardness test though is to also add in average speed that all the above is completed at! And that would surely make the spreadsheet explode!
Lots of ideas to mull over the Christmas holidays and see what goodies we can have when the big reset happens on Jan 1st 2010!0 -
ChrisInBicester wrote:
That'll be LeeHellCat. Can't say I recognise the name. The more the merrier though, as long as they keep at it.salsajake wrote:who is the newbie #75 that has just made 30th place even further away!?
But... how can you feel any satisfaction by posting a YTD figure in September? It's just ain't right I tell ya :evil:0 -
He's discovered it late in life; as long as he's done the miles it's a fair cop, and if it's a one-off he'll drop out in a few weeks anyway, like a lot of others have.0
-
salsajake wrote:Not sure Rolf F is talking about an adaptation of the climb ratio - the climb ratio is what it is, but I agree that someone who rides a 3 mile section of hardknott pass and then does nothing else for the rest of the year will have the highest climb ratio on the table.
That's it. We currently don't have a unit of measure that takes into account both the horizontal hardness of the commute and the vertical one in overall terms. The climb ratio goes someway but, of course, if everyone only put their commute data in (ie not leisure runs as well) and didn't vary their route, the climb ratio would be a constant so a single commute over Hardknott would inevitably win. By dividing the horizontal by the vertical, whilst you get an indication of the hilliness of the commute, there is no accumulation. The SCSWattage or whatever it would be called gives an overall weighting to the total mileage in two dimensions.
Given that climb ratio will trend towards a constant, I suspect I think that it might be better to replace it with SCSWattage if space is too much of a problem. Mind you, I'm not that convinced of the relevance of PF..........
And Salsajake is clearly right that speed should be in there but I wouldn't dream of suggesting that one Faster than a tent.......0
