Silly Commuter Stats

1…5681011…246

Comments

  • shoulder_of_orion
    shoulder_of_orion Posts: 529
    I've added mine in. Somehow I am even closer to the bottom of this list than I was on the previous one and I've done 100+ miles in the past week. Grrr.
  • shoulder_of_orion
    shoulder_of_orion Posts: 529
    oops, I've just credited myself with an extra 80 miles, which is roughly what I've done this week, but my total should read 780 not 860. How do I undo that?
  • R_T_A
    R_T_A Posts: 488
    lost_in_thought wrote:
    OK, so...

    I think (correct me if I'm wrong, I'm not an IT guru like the rest of you) that this is a good system, but we can't include backdated monthly mileage splits - eg April miles - without it adding on to the YTD total we already entered. Is that right?

    Correct.

    But you can ask CinB to change your backdated amount (like he did for me :oops:).

    It could mean admin effort on CinB for the future though...
    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.
  • lost_in_thought
    lost_in_thought Posts: 10,563
    R_T_A wrote:
    lost_in_thought wrote:
    OK, so...

    I think (correct me if I'm wrong, I'm not an IT guru like the rest of you) that this is a good system, but we can't include backdated monthly mileage splits - eg April miles - without it adding on to the YTD total we already entered. Is that right?

    Correct.

    But you can ask CinB to change your backdated amount (like he did for me :oops:).

    It could mean admin effort on CinB for the future though...

    Or maybe we just start the monthly splits from mid-may... I like this one because my work net nanny doesn't block it...
    FCN 7/1
    Viner Maxima, Tifosi CK7, Giant Bowery, Old commuter.
  • cjcp
    cjcp Posts: 13,345
    Can we have an extra option for the PF column so we can just insert an "x"? Inserting a number risks incurring the wrath of the PF, which means I will have to burn some pencil sharpenings/shavings as a sacrific.

    Does this mean we're done with the list? What happens if we lose the figures or the host site is closed? (I speak as someone who hasn't the first idea what you IT chaps have done.)
    FCN 2-4.

    "What happens when the hammer goes down, kids?"
    "It stays down, Daddy."
    "Exactly."
  • tailwindhome
    tailwindhome Posts: 19,458
    @ CinB

    No offence meant, but your site seems to be a completely over engineered solution to a problem that never existed

    I thought the spreadsheet was working pretty

    Just needed the link pasted into the original post to make it easier to find.

    And as an accountant I would have liked to see more columns for analysis, but we're all geeks in our own wee ways


    (but if I'm the only one who thinks this I'll shut up and go with the flow.
    “New York has the haircuts, London has the trousers, but Belfast has the reason!
  • lost_in_thought
    lost_in_thought Posts: 10,563
    I'm updating both, mainly because only early adopters have added themselves to CinB's site!

    Oh yeah, and I have time...

    Link for g-docs sheet:


    http://spreadsheets.google.com/ccc?key= ... ypaw&hl=en
    FCN 7/1
    Viner Maxima, Tifosi CK7, Giant Bowery, Old commuter.
  • Christophe3967
    Christophe3967 Posts: 1,200
    Confused... Rich's stats are lower on the new version than the old. I'll wait and see what everyone decides to do and update mine on Sunday.
    Bike1
    http://www.flickr.com/photos/35118936@N07/3258551288/
    Bike 2
    http://www.flickr.com/photos/35118936@N ... otostream/
    New Bike
    http://www.flickr.com/photos/35118936@N07/3479300346/
  • Rich158
    Rich158 Posts: 2,348
    Doh, that's because I lost track of where I was and used the wrong stats :roll:
    pain is temporary, the glory of beating your mates to the top of the hill lasts forever.....................

    Revised FCN - 2
  • itboffin
    itboffin Posts: 20,072
    I have shamed myself 0 miles still this week but never fear brake SCRers & co i've laid out my cycling kit (Castelli) for tomorrow and I will be riding in regardless of weather, my London leg might be a little slower than normal as it'll be my first time Waterloo to Kings Cross and i'm seriously out of practice stop/starting at lights.

    Plus I'll be hugely under geared tomorrow, spin city for me :lol: gutted my new bike is all here but needs putting together and I don't have time tonight, my CX bike rear wheel is in the LBS

    :cry:
    Rule #5 // Harden The Feck Up.
    Rule #9 // If you are out riding in bad weather, it means you are a badass. Period.
    Rule #12 // The correct number of bikes to own is n+1.
    Rule #42 // A bike race shall never be preceded with a swim and/or followed by a run.
  • CiB
    CiB Posts: 6,098
    lost_in_thought wrote:
    OK, so...

    I think (correct me if I'm wrong, I'm not an IT guru like the rest of you) that this is a good system, but we can't include backdated monthly mileage splits - eg April miles - without it adding on to the YTD total we already entered. Is that right? or have I just not found how to do that?

    You're right LiT. You tell it how many miles you started with, then just add trips. That was the plan, but I had an idea that it would need a correction option, so...
    Shoulder of Orion wrote:
    oops, I've just credited myself with an extra 80 miles, which is roughly what I've done this week, but my total should read 780 not 860. How do I undo that?

    Revisit it. There's now an update link next to your YTD figure that allows you to change the running YTD value to a value that you want it to be. Yes - you can promote yourself to be top of the leaderboard. :)
    WheezyMcChubby wrote:
    @ CinB

    No offence meant, but your site seems to be a completely over engineered solution to a problem that never existed

    I thought the spreadsheet was working pretty

    Just needed the link pasted into the original post to make it easier to find.

    And as an accountant I would have liked to see more columns for analysis, but we're all geeks in our own wee ways


    (but if I'm the only one who thinks this I'll shut up and go with the flow.

    I work in IT, so I'll take that as a compliment 8) - over-engineered, unnecessary, utterly pointless ulitmately and yes - a solution to a non-existent problem, other than me having a couple of evenings on my hands and no-one in the house except for a sleeping 7 year old. But an interesting exercise - I've never used PHP before.

    Seems to be a broadly positive reaction to it so far - thanks for that. TBH I didn't fancy spending a week knocking up a fully functioning professional web site and then finding out that there was only me on the leaderboard, so I didn't. I'll look at tidying it up and adding more added value to the core data as times goes on, when time allows.

    Boy is out of hospital now though so it's back to normal.

    Cheers all. Keep using it.
    :)
  • biondino
    biondino Posts: 5,990
    SO WE'RE ALL USING CHRIS'S PROGRAM NOW RIGHT?

    If so, can everyone update it? And can Chris correct my May total back to 181 cos I buggered it up :(
    My Focus / My Bob Jackson
    Blog (incl. bikes)
  • Porgy
    Porgy Posts: 4,525
    Just added myself onto the list. I've had to do an educated guess for Jan and Feb stats, but it can;t be too far out. I was only cycling in one day a week in January, then in February I got up to two days a week. I was pretty unfit - used to a 5 mile commute I was suddenly doing a 30 miles round trip.

    In March and April I'm pretty much up to 5 days a week solid now - only occasionally jumping ont he train, and the odd ride at the weekend.

    I've surprised myself at the total though (1360). No wonder I'm knackered all the time.
  • King Donut
    King Donut Posts: 498
    My name's down.
    No data until late April due to lack of computer and sporadic commuting mixed with uncounted off road miles.

    So, does off road mileage count double? :)
  • Christophe3967
    Christophe3967 Posts: 1,200
    biondino wrote:
    SO WE'RE ALL USING CHRIS'S PROGRAM NOW RIGHT?

    If so, can everyone update it? And can Chris correct my May total back to 181 cos I buggered it up :(

    Looks like the Google spreadsheet's been taken down so I guess we are. I've loaded my figures on the new site but don't know my month stats without going through my records again. :(

    Failed miserably to hit my expected 250 this week. ITB's rain dance and the fact that I stupidly failed to dress appropriately meant that I called it a day after 50 miles today, so only 189 miles this week. But hit 3000 for the year. :) Trying to organise a ride down to Dorset next weekend... :) That would be 100 at least :wink:
    Bike1
    http://www.flickr.com/photos/35118936@N07/3258551288/
    Bike 2
    http://www.flickr.com/photos/35118936@N ... otostream/
    New Bike
    http://www.flickr.com/photos/35118936@N07/3479300346/
  • lost_in_thought
    lost_in_thought Posts: 10,563
    Huh, exactly 100 miles! Well that was unplanned... but yeah, need to amp up the mileage. Long weekend coming up, what's everyone planning?
    FCN 7/1
    Viner Maxima, Tifosi CK7, Giant Bowery, Old commuter.
  • itboffin
    itboffin Posts: 20,072
    Christophe3967 wrote:
    biondino wrote:
    SO WE'RE ALL USING CHRIS'S PROGRAM NOW RIGHT?

    If so, can everyone update it? And can Chris correct my May total back to 181 cos I buggered it up :(

    Looks like the Google spreadsheet's been taken down so I guess we are. I've loaded my figures on the new site but don't know my month stats without going through my records again. :(

    Failed miserably to hit my expected 250 this week. ITB's rain dance and the fact that I stupidly failed to dress appropriately meant that I called it a day after 50 miles today, so only 189 miles this week. But hit 3000 for the year. :) Trying to organise a ride down to Dorset next weekend... :) That would be 100 at least :wink:

    The spreadsheet is still there, I on the other hand couldn't be arsed to battle the gale force winds this weekend and choose beer & boating on the Thames very nice it was too :D

    http://spreadsheets.google.com/ccc?key= ... ypaw&hl=en

    The forecast for early to all of next week is the same heavy rain & gale force winds here i'm now FCUKED OFF :twisted: with this CRAP, just over two years i've lived here and the weather has been pants the whole time, I had no idea 50mph wind was such a regular occurrence in the south.
    Rule #5 // Harden The Feck Up.
    Rule #9 // If you are out riding in bad weather, it means you are a badass. Period.
    Rule #12 // The correct number of bikes to own is n+1.
    Rule #42 // A bike race shall never be preceded with a swim and/or followed by a run.
  • tailwindhome
    tailwindhome Posts: 19,458
    20 Shoulder of Orion 659
    21 Eau Rouge 617
    22 prawny 520
    23 WheezyMcChubby 401
    24 Redvee 347
    25 Fireblade96 291
    26 Agent57 280
    27 nielsamd 250
    28 kyoukoku 187
    29 Jonny Fortnight 176


    I've updated the google spreadsheet, and entered my current YTD on the SCstats thingy

    Haven't a clue how to update April, May and WTD


    Is it something to do with Blueteeth?

    Any way my aim for a first 100mile week was scuppered by family commitments and adverse weather

    On the plus side I'm back in the commuting game clocking 62 commuter miles and 23 civilian

    Aim to beat the 100 mile mark each of the next 2 weeks
    “New York has the haircuts, London has the trousers, but Belfast has the reason!
  • CiB
    CiB Posts: 6,098
    For you delectation...

    X option for those who don't want to upset the PF. Subtract down to below 0 to get to X.
    Some mileages adjusted as requested, but you can do this yourself anyway.
    Barebones page to give this...

    1 Rich 158 - 3279 mls.
    2 Christophe3967 - 3008 mls.
    3 CJCP - 2941 mls.
    4 R_T_A - 2180 mls.
    5 Feltup - 1982 mls.
    6 jimmypippa - 1949 mls.
    7 Porgy - 1360 mls.
    8 ChrisInBicester - 1350 mls.
    9 joew4ll - 1349 mls.
    10 bracketed - 1286 mls.
    11 SiHughes - 1263 mls.
    12 lost_in_thought - 1131 mls.
    13 TopSpin - 1122 mls.
    14 biondino - 943 mls.
    15 spursn17 - 936 mls.
    16 King Donut - 784 mls.
    17 Shoulder of Orion - 760 mls.
    18 WheezyMcChubby - 401 mls.
    19 ris - 387 mls.

    Nice little mid-table battle developing there in 7-11th place, on 1300 miles. I went out for a thrash earlier tonight and got absolutely drenched in the 6pm monsoon. Invigorating is the term.
  • itboffin
    itboffin Posts: 20,072
    ChrisInBicester wrote:
    For you delectation...

    X option for those who don't want to upset the PF. Subtract down to below 0 to get to X.
    Some mileages adjusted as requested, but you can do this yourself anyway.
    Barebones page to give this...

    1 Rich 158 - 3279 mls.
    2 Christophe3967 - 3008 mls.
    3 CJCP - 2941 mls.
    4 R_T_A - 2180 mls.
    5 Feltup - 1982 mls.
    6 jimmypippa - 1949 mls.
    7 Porgy - 1360 mls.
    8 ChrisInBicester - 1350 mls.
    9 joew4ll - 1349 mls.
    10 bracketed - 1286 mls.
    11 SiHughes - 1263 mls.
    12 lost_in_thought - 1131 mls.
    13 TopSpin - 1122 mls.
    14 biondino - 943 mls.
    15 spursn17 - 936 mls.
    16 King Donut - 784 mls.
    17 Shoulder of Orion - 760 mls.
    18 WheezyMcChubby - 401 mls.
    19 ris - 387 mls.

    Nice little mid-table battle developing there in 7-11th place, on 1300 miles. I went out for a thrash earlier tonight and got absolutely drenched in the 6pm monsoon. Invigorating is the term.

    Doesn't include me in what would now seem to be 3rd place :evil:
    Rule #5 // Harden The Feck Up.
    Rule #9 // If you are out riding in bad weather, it means you are a badass. Period.
    Rule #12 // The correct number of bikes to own is n+1.
    Rule #42 // A bike race shall never be preceded with a swim and/or followed by a run.
  • CiB
    CiB Posts: 6,098
    WheezyMcChubby wrote:
    I've updated the google spreadsheet, and entered my current YTD on the SCstats thingy

    Haven't a clue how to update April, May and WTD

    Welcome WmcC. Update your stats via your name -it's a link to the add stats page; just select the relevant w/c from the drop down. Anything that's a link just follow it. It's pretty easy to get on with.
  • CiB
    CiB Posts: 6,098
    itboffin wrote:
    Doesn't include me in what would now seem to be 3rd place :evil:

    Oh. Will have a stare and resolve that one....
  • CiB
    CiB Posts: 6,098
    ChrisInBicester wrote:
    itboffin wrote:
    Doesn't include me in what would now seem to be 3rd place :evil:

    Oh. Will have a stare and resolve that one....

    The raw data would suggest that you haven't yet added yourself to the db. 19 names in the db so far, 19 showing on the leaderboard.
  • tailwindhome
    tailwindhome Posts: 19,458
    ChrisInBicester wrote:
    WheezyMcChubby wrote:
    I've updated the google spreadsheet, and entered my current YTD on the SCstats thingy

    Haven't a clue how to update April, May and WTD

    Welcome WmcC. Update your stats via your name -it's a link to the add stats page; just select the relevant w/c from the drop down. Anything that's a link just follow it. It's pretty easy to get on with.


    Are we not working in calender months anymore?
    “New York has the haircuts, London has the trousers, but Belfast has the reason!
  • tailwindhome
    tailwindhome Posts: 19,458
    Also these people need added to the list

    Redvee
    Fireblade96
    Agent57
    nielsamd
    kyoukoku
    Jonny Fortnight


    Can you guess what they have in common?
    “New York has the haircuts, London has the trousers, but Belfast has the reason!
  • CiB
    CiB Posts: 6,098
    WheezyMcChubby wrote:
    ChrisInBicester wrote:
    WheezyMcChubby wrote:
    I've updated the google spreadsheet, and entered my current YTD on the SCstats thingy

    Haven't a clue how to update April, May and WTD

    Welcome WmcC. Update your stats via your name -it's a link to the add stats page; just select the relevant w/c from the drop down. Anything that's a link just follow it. It's pretty easy to get on with.


    Are we not working in calender months anymore?
    There was some discussion about where the week started and Monday was the consensus. Where a week runs into the next month the miles go into the new month's bucket.

    Can't see a link between those in your other post, but it's late on a Sunday... :)

    New users need to add themselves otherwise we end up with people on the list who don't realise it so never update their figures.
  • biondino
    biondino Posts: 5,990
    Chris, I think you overcorrected me! As a result, of course, I have gone to the site and corrected myself wrongly, so the YTD number is now correct but the month is wrong - should be 217...
    My Focus / My Bob Jackson
    Blog (incl. bikes)
  • CiB
    CiB Posts: 6,098
    OK. Later...
  • redvee
    redvee Posts: 11,922
    WheezyMcChubby wrote:
    Also these people need added to the list

    Redvee
    Fireblade96
    Agent57
    nielsamd
    kyoukoku
    Jonny Fortnight


    Can you guess what they have in common?

    We're too busy riding to add our huuuge mileage to the database? Anyhow my name can be take off the mia list, how do I correct the previous/current months totals?
    I've added a signature to prove it is still possible.
  • CiB
    CiB Posts: 6,098
    redvee wrote:
    ...how do I correct the previous/current months totals?

    To add miles click your name, which is a link to the add stats page. Select the relevant w/c from the drop down and enter the miles you want to log. Whatever miles you log are added to the YTD mileage.

    If the YTD figure is wrong follow the link to the correction page to change it.

    I haven't added a page to remove specific entries, but it looks as though I'll need to. In the meantime, leave a request on here for updates and I'll correct it as & when.

Categories