Audax 'stripes'

[jhob]

I had an idea this morning and knocked up a quick demo.

It's a little web tool where you enter your AUK membership number and year and it will generate your 'stripes' for that year.  A nice little visual representation of your audax year.

Try it out here: http://getyourstripes.co.uk

A couple of examples for what it looks like if you've done an awful lot of audaxing:
http://getyourstripes.co.uk/?membership_number=7565&year=2011
http://getyourstripes.co.uk/?membership_number=4183&year=2011

At the moment you can't export it or do anything with it, but if it looks like it may be of interest to some people I'm thinking that it could generate a jpg to use as facebook cover photo or in forum sigs (like veloviewer).

Note: You can probably break it very easily.  This was thrown together in an hour or so and is little more than a proof-of-concept!

[Ningishzidda]

Before AUK had a website, I entered details of my rides on a Lotus 1-2-3 spreadsheet.
That migrated to a MS Excel spreadsheet.
Each row represents a ride and columns contain details of the ride.

I create a PivotTable to group rides of each season, length or whatever.

One spreadsheet now cus Excel 10 has over 1,000,000 rows.

[Delph Cyclist]

I had an idea this morning and knocked up a quick demo.

My first thought was ... very pretty but what's the point?

My second thought was ... hang on a minute, I think I might have a little commission for someone with a bit of software wizardry and more time on his/her hands than is good for them.  If you could extend that to have a Randonneur Round the Year adjudicator I would be thoroughly impressed.  It would have to interrogate each year's results pages by MemNo, identify which rides qualify for the RRTY (non-zero in the points column) and spot 12 such occurrences in any consecutive months.  It gets more complicated when you take into consideration that multiple RRTY runs may occur simultaneously, not necesarrily starting in the same month.  No ride can be counted more than once.

Not only would I find such a webtool useful (as RRTY adjudicator), but I would imagine others could use it to check where they stand in the RRTY stakes before they make their claim.

And if you can pull that one off, I'm sure Steve Snook would be along with a similar request.

[Kim]

Very pretty.  Do we get a translation of what the stripes mean?

[jhob]

I had an idea this morning and knocked up a quick demo.

My first thought was ... very pretty but what's the point?

My second thought was ... hang on a minute, I think I might have a little commission for someone with a bit of software wizardry and more time on his/her hands than is good for them.  If you could extend that to have a Randonneur Round the Year adjudicator I would be thoroughly impressed.  It would have to interrogate each year's results pages by MemNo, identify which rides qualify for the RRTY (non-zero in the points column) and spot 12 such occurrences in any consecutive months.  It gets more complicated when you take into consideration that multiple RRTY runs may occur simultaneously, not necesarrily starting in the same month.  No ride can be counted more than once.

Not only would I find such a webtool useful (as RRTY adjudicator), but I would imagine others could use it to check where they stand in the RRTY stakes before they make their claim.

And if you can pull that one off, I'm sure Steve Snook would be along with a similar request.

The point was just for it to look pretty really!  A little visual summary of your audaxing year.

Regarding the RRTY tool, certainly the former part of that spec is do-able.  The concurrent RRTY checker would need more thought, but if there's an algorithm written down somewhere it could certainly be calculated programatically.  I shall give it some thought!

[jhob]

Very pretty.  Do we get a translation of what the stripes mean?

Light blue = BP
Red = 200
Yellow = 300
Green = 400
Dark blue = 600
Grey = 1200

Taken from the AUK Brand Guidelines.  I think I've got the colours right (correct me if not)!

[LittleWheelsandBig]

Grey is also 1000km?

The ACP used specific colours for enamelled medallions for each BRM distance.

[Ningishzidda]

Brun clair = 150
Bleu ciel = 100
Blanc = 50

[jhob]

Grey is also 1000km?

The ACP used specific colours for enamelled medallions for each BRM distance.

Corrected!

[jhob]

Brun clair = 150
Bleu ciel = 100
Blanc = 50

Corrected, although I had to make a guess at the correct colour for 150 as it doesn't appear in the brand guidelines.

Does pink represent a distance?

[Euan Uzami]

If you have done several consecutive rides of the same distance they appear as one contigious block. So wouldn't someone who's done 3 200s appear the same as someone who's only done 1?

[L CC]

Brun clair = 150
Bleu ciel = 100
Blanc = 50

Corrected, although I had to make a guess at the correct colour for 150 as it doesn't appear in the brand guidelines.

Does pink represent a distance?

Pink is for nifty 50s.

[jhob]

If you have done several consecutive rides of the same distance they appear as one contigious block. So wouldn't someone who's done 3 200s appear the same as someone who's only done 1?

Well, the red band would be three times as wide.  I could separate them with a small white band, but visually I don't think this looks so appealing.  You can see for yourself as that change is live on the site now.

[The Seldom Killer]

I did 17 rides in 2013 but only get 10 stripes as far as I can tell. All the same width.

Number is 8944

[Reg.T]

It seems to not always pick up all rides. For example 16 stripes for me last year out of 25 rides listed. And 27 stripes for last year's points champion out of 138 rides listed. Is it struggling with perms and/or ECEs maybe? 
(X-post with TSK)

[jhob]

It seems to not always pick up all rides. For example 16 stripes for me last year out of 25 rides listed. And 27 stripes for last year's points champion out of 138 rides listed. Is it struggling with perms and/or ECEs maybe? 
(X-post with TSK)

Fixed that bug now! 

[The Seldom Killer]

Any way to pick up on rides that were done on the same day to combine them as an ECE?

[jhob]

Yeah, should be able to do that. I'll take a look later.

It's all done by trying to make some semantic sense of the unstructured data on the site so there's quite a bit of trial and error involved.

[mattc]

If you want a challenge, how about working out AUK Edington(sp?) numbers?!

[see here if you don't know http://www.audax.co.uk/forum/index.php?topic=360.0 ]

[jochta]

If you want a challenge, how about working out AUK Edington(sp?) numbers?!

[see here if you don't know http://www.audax.co.uk/forum/index.php?topic=360.0 ]

I've asked if the Eddington Number could be added to VeloViewer. There's about a squillion percent more chance of that happening than Strava ever doing anything anyone actually wants (e.g. photo upload).

John

[Wobbly]

No prizes but guess whos 'stripes' these are...

http://damselflydevelopment.com/auk/?membership_number=6372&year=2014

[Revellinho]

Well I think it is great!

[Aunt Maud]

Nice.

But it has picked up a AAA added points as pink on mine, I'm not sure if that's how they add AAA points to overseas rides and then subtract the distance, but leave the points.

[rabbit]

I love this! 

[jhob]

Nice.

But it has picked up a AAA added points as pink on mine, I'm not sure if that's how they add AAA points to overseas rides and then subtract the distance, but leave the points.

Could you PM me your membership number and year you were looking at so I can take a look?  It should totally ignore AAA points.  Pink is used to designate 50k rides.