Silly Commuter Stats

lost_in_thought

Damn it! My cycling-free weekend has done me no favours whatsoever...

CiB

lost_in_thought wrote:

Damn it! My cycling-free weekend has done me no favours whatsoever...

It has. You've lost the beard & beer gut that your pic was showing towards the end of last week. A small but meaningful improvement.

Porgy

ChrisInBicester wrote:

Porgy wrote:

11 Feltup - 2169 mls.
12 ChrisInBicester - 1869 mls.
13 Porgy - 1842 mls.
14 bigease - 1832 mls.
15 DancesWithSheep - 1757 mls.

Weekend miles posted - up one space 8)

Expect to pass ChrisinBicester about Thursday

Surely the world's hardest game of squash in lieu of 20 miles on the bike should count for something? <sneaks off to tweak db without it showing up on SCStats...>


Maybe - like the SCR points - we need exactly that. Hard game of squash = 20 miles. Walking the dog = 0.5. An hour's worth of football on the back lawn with the kids = 124 miles. etc.

Finishing the Will Self novel = 80 miles
laying in bed watching DVD = 50 miles

yeah I'm up for that

in the meantime, however:
11 Feltup - 2169 mls.
12 Porgy - 1872 mls.
13 ChrisInBicester - 1869 mls.
14 bigease - 1832 mls.

CiB

Fixed an issue last night on SC Stats that could potentially have caused a problem further on in the summer, and did a wider tidy-up whilst I was at it. Any issues arising can be reported in the usual way, either by triplicate request through the SC Stats Support Hepdesk, or by sticking a post on here with the keywords 'WTF'.

jimmypippa

1 Rich 158 - 4104 mls.
2 itboffin - 3696 mls.
3 Christophe3967 - 3686 mls.
4 gtvlusso - 3650 mls.
5 mcmullej - 3614 mls.
6 CJCP - 3503 mls.
7 Gert_lush - 3247 mls.
8 R_T_A - 2703 mls.
9 Gazzaputt - 2687 mls.
10 jimmypippa - 2496 mls.
11 TheStone - 2326 mls.
12 bigease - 2253 mls.
13 Feltup - 2169 mls.
14 Porgy - 1977 mls.
15 ChrisInBicester - 1885 mls.
16 bracketed - 1785 mls.
17 DancesWithSheep - 1757 mls.
18 biondino - 1704 mls.
19 lost_in_thought - 1648 mls.
20 Dav1 - 1584 mls.
21 joew4ll - 1577 mls.
22 whyamihere - 1574 mls.
23 SiHughes - 1480 mls.
24 boy on bike - 1355 mls.
25 Shoulder of Orion - 1330 mls.
26 TopSpin - 1294 mls.
27 spursn17 - 1235 mls.
28 King Donut - 1229 mls.
29 Filippo Negroni - 1197 mls.
30 OldSkoolKona - 1079 mls.
31 m0scs - 1013 mls.
32 Prawny - 989 mls.
33 risi - 960 mls.
34 Eau Rouge - 925 mls.
35 Rolf F - 820 mls.
36 Ince - 802 mls.
37 ris - 744 mls.
38 WheezyMcChubby - 473 mls.
39 Redvee - 468 mls.
40 Jeff_otter - 310 mls.
41 Sailorchick - 283 mls.

R_T_A

41 users and 73,628 miles - we're getting quite a clan of stat junkies 8)

And all but 40 of my 2,703 are actual commuting miles. Plus I think I'm just breaking even after the initial capital of buying a bike/kit instead of driving to work.

**Reaches for credit card and logs into Wiggle**

redvee

Missed clocking up 50 miles this week by 1.65miles but my body told me to go home and tell everybody it's failings :oops: despite munching whilst out today

salsajake

1 Rich 158 - 4104 mls.
2 itboffin - 3696 mls.
3 Christophe3967 - 3686 mls.
4 gtvlusso - 3650 mls.
5 mcmullej - 3614 mls.
6 CJCP - 3503 mls.
7 Gert_lush - 3247 mls.
8 R_T_A - 2703 mls.
9 Gazzaputt - 2687 mls.
10 jimmypippa - 2496 mls.
11 TheStone - 2326 mls.
12 bigease - 2253 mls.
13 Feltup - 2169 mls.
14 Porgy - 1977 mls.
15 ChrisInBicester - 1885 mls.
16 bracketed - 1785 mls.
17 DancesWithSheep - 1757 mls.
18 biondino - 1704 mls.
19 lost_in_thought - 1648 mls.
20 Dav1 - 1584 mls.
21 joew4ll - 1577 mls.
22 whyamihere - 1574 mls.
23 SiHughes - 1480 mls.
24 boy on bike - 1355 mls.
25 Shoulder of Orion - 1330 mls.
26 TopSpin - 1294 mls.
27 spursn17 - 1235 mls.
28 King Donut - 1229 mls.
29 Filippo Negroni - 1197 mls.
30 OldSkoolKona - 1079 mls.
31 m0scs - 1013 mls.
32 Prawny - 989 mls.
33 risi - 960 mls.
34 Eau Rouge - 925 mls.
35 Rolf F - 820 mls.
36 Ince - 802 mls.
37 Salsajake - 750 mls
38 ris - 744 mls.
39 WheezyMcChubby - 473 mls.
40 Redvee - 468 mls.
41 Jeff_otter - 310 mls.
42 Sailorchick - 283 mls.

I'm assuming (having not read 20 pages of posts) that its miles since 1/1/09? Would prefer if it was a rolling 12 months, just for the numbers, but admittedly it would be almost impossible to keep track! I'm sure any places moved up the table will be cancelled out by others joining it higher up, but here's hoping ris isn't on their bike today!

Edited to add: didn't realise I had to do some weird coding thing, having looked earlier, so this won't actually cut the mustard I'm sure. Will see if I can work out what I am supposed to do and try again...

Edited again to say now I have seen a link to an excel page that seems to be out of date compared with the above and I am losing the will! Can anyone recap how to put the figures in these days?

R_T_A

salsajake wrote:

Edited again to say now I have seen a link to an excel page that seems to be out of date compared with the above and I am losing the will! Can anyone recap how to put the figures in these days?

If you check on the Stats webpage, CiB has kindly added a help page:
http://www.startfarm.co.uk/scstats/help.html

Shout if you need more help.

salsajake

ta, have added myself, but not appearing as yet

R_T_A

This has happened before. Not to worry - you're on the "barebones" page, so you're in the database so all miles are logged.

You'll have to wait until CiB gets his finger out and fixes the bug :roll:

CiB

R_T_A wrote:

This has happened before. Not to worry - you're on the "barebones" page, so you're in the database so all miles are logged.

You'll have to wait until CiB gets his finger out and fixes the bug :roll:

That's an odd one. People have been happily adding themselves for a while now since that bug was resolved 3 weeks ago - we went from around 32 users to 41, now 42. Salsa - I'll have a look later to see why you weren't added properly. Check again tomorrow and all should be well.

Like the idea of a rolling 12 / 6 / 3 / n months total. Might have a look at that; we've got a lot of cumulative data that could be manipulated in more creative ways than it is at present.

salsajake

there are 42 users, only 41 on the table, think I must be the missing 42nd as it did come up with a message saying I had been added in

CiB

It's a cycling forum not a database discussion but in short, you're in one table but not another and the query that joins the two is an inner join so you don't appear on the summary grid, which is where it's all driven from. Not a serious problem, not for me anyway. Have a look later tonight / tomorrow.

Can't remote into it from here otherwise it'd be done & dusted by now.

R_T_A

Don't worry Salsa - he's pretty good to us, and fixes things quickly. Your name will be in lights soon 8)

CiB

Fixed that. Tssk - a typo of all things.

Salsa, Hoppy & Fat Kid (?) all added themselves today. It's unusual to see two newbies arrive in a short space of time like that both on zero miles so welcome to the both of you, now get on with adding some miles . If they were added as a bit of testing by someone let me know and I'll clear those two entries out.

salsajake

Cheers CiB - what did I spell wrong?!

I don't mind people being on 0 miles (although technically they can't really be called cyclists), at least not until I surge up the leaderboard! Actually that's quite hard, because everyone else seems to be ever-surging too!

CiB

salsajake wrote:

Cheers CiB - what did I spell wrong?!

It's not you, it's me. Where have I heard that before...?

I did a bit of an overhaul last week to extend stats to the full year so that we can roll into next year if necessary, and to resolve a ticking time bomb that would have caused problems if we're still doing this in October, but missed a comma off on the new user code. Anyone who's done an SQL insert will be aware of the importance of commas - if you miss one off it doesn't work. That's what happened here.

45 users then. I reckon we might hit 50 soon at this rate.

redvee

Us males in postions 44 --> 48 are seriously going to get left behind by Sarajoy and the other burds in the 'competition' unless you do want the wooden spoon for the lowest mileage at the end of the year.

itboffin

I'm really pushing the boat out this week aiming for 315 miles :shock: I need to bag a shed load of miles as July will be spent on business trips

1 Rich 158 - 4196 mls.
2 itboffin - 3903 mls.
3 mcmullej - 3799 mls.
4 Christophe3967 - 3756 mls.
5 gtvlusso - 3650 mls.
6 CJCP - 3503 mls.
7 Gert_lush - 3366 mls.
8 R_T_A - 2703 mls.
9 Gazzaputt - 2687 mls.
10 jimmypippa - 2496 mls.
11 gb155 - 2445 mls.
12 TheStone - 2326 mls.
13 bigease - 2280 mls.
14 Feltup - 2219 mls.
15 Porgy - 2043 mls.
16 ChrisInBicester - 2007 mls.
17 bracketed - 1840 mls.
18 DancesWithSheep - 1757 mls.
19 whyamihere - 1736 mls.
20 biondino - 1725 mls.
21 lost_in_thought - 1715 mls.
22 Dav1 - 1647 mls.
23 SiHughes - 1590 mls.
24 joew4ll - 1577 mls.
25 boy on bike - 1355 mls.
26 spursn17 - 1353 mls.
27 Shoulder of Orion - 1330 mls.
28 TopSpin - 1294 mls.
29 King Donut - 1229 mls.
30 Filippo Negroni - 1197 mls.
31 Spoodzilla - 1175 mls.
32 OldSkoolKona - 1173 mls.
33 Prawny - 1060 mls.
34 Eau Rouge - 1029 mls.
35 m0scs - 1013 mls.
36 risi - 1012 mls.
37 Agent57 - 950 mls.
38 Ince - 838 mls.
39 Rolf F - 820 mls.
40 ris - 820 mls.
41 salsajake - 785 mls.
42 Hoppy - 568 mls.
43 sarajoy - 566 mls.
44 Redvee - 516 mls.
45 WheezyMcChubby - 473 mls.
46 Jeff_otter - 310 mls.
47 Sailorchick - 283 mls.
48 Fat Kid - 1 mls.

dav1

is there a place to recored general mechanicals in this list?

CiB

Dav1 wrote:

is there a place to recored general mechanicals in this list?

Sorry but no. It's a list of who's done most miles. I could add it I suppose, but not for a few days; I'll be washing my hair tonight and fancy some time observing our lawn growth and the decorating losing its moisture. Have a look next week.

dav1

rofl, I only ask because of the puncture section

CiB

14 Feltup - 2234 mls.
15 ChrisInBicester - 2111 mls.
16 Porgy - 2102 mls.

Might as well make the most of it before Porgy ambles in and sticks his 30 miles up.

Feltup

OOOH I'm famous!!!!!

Porgy

ChrisInBicester wrote:

14 Feltup - 2234 mls.
15 ChrisInBicester - 2111 mls.
16 Porgy - 2102 mls.

Might as well make the most of it before Porgy ambles in and sticks his 30 miles up.

15 Feltup - 2234 mls.
16 Porgy - 2131 mls.
17 ChrisInBicester - 2111 mls.

R_T_A

8 Peter,vj - 3304 mls.
9 R_T_A - 2811 mls.
10 Gazzaputt - 2687 mls.

Hey - no more people joining above me!

My "actual" commuting miles are barely keeping me in the top 10 :evil:


Grumble, grumble.....people who have time for weekend rides

CiB

Porgy wrote:

ChrisInBicester wrote:

14 Feltup - 2234 mls.
15 ChrisInBicester - 2111 mls.
16 Porgy - 2102 mls.

Might as well make the most of it before Porgy ambles in and sticks his 30 miles up.

15 Feltup - 2234 mls.
16 Porgy - 2131 mls.
17 ChrisInBicester - 2111 mls.

I haven't gone home yet but fully expect to in a while so...

15 Feltup - 2234 mls.
16 ChrisInBicester - 2132 mls.
17 Porgy - 2131 mls.

Porgy

ChrisInBicester wrote:

Porgy wrote:

ChrisInBicester wrote:

14 Feltup - 2234 mls.
15 ChrisInBicester - 2111 mls.
16 Porgy - 2102 mls.

Might as well make the most of it before Porgy ambles in and sticks his 30 miles up.

15 Feltup - 2234 mls.
16 Porgy - 2131 mls.
17 ChrisInBicester - 2111 mls.

I haven't gone home yet but fully expect to in a while so...

15 Feltup - 2234 mls.
16 ChrisInBicester - 2132 mls.
17 Porgy - 2131 mls.

Oi! :x

biondino

Jesus. Shall we just cut to the chase and have a penis size stat chart? (the girls can have a metaphorical penis)