SBR Challenge 2012 & training log links

Me and apologies if I have upset anyone's data I've put in a column for the overall rank of the challenge that I will update once a week as late in the week that I can. The status of that will then remain for the next week so you can actually see how you are moving on the challenge versus where you were on last calculation. Fazz is almost 50% to the first green and odds on to hit it first too so once the targets come in the overall SBR points start to become secondary for calculation. Therefore no need for the second tab. I will sort the table regularly by SBR points anyway and others are sorting it by other columns for whatever reason that I'm ok with. I've seen it sorted by turbo kms, name, points, run kms, bike kms, swim kms, treadmill kms so far... so there are plenty on the challenge who know how to sort the table!

So this pins the challenge to a weekly update and maybe a bit of a weekly chat about it in the thread.

If you are sorting the table for some reason, please resort back to SBR points as status quo, thanks.

Its the unique way the challenge is calculated that made this necessary. You may have seen me play with different options such as logging how many of each green and gold target you hit. I was searching for a way to take those into account first. I toyed with variations and without adding another metric or more columns to the spreadsheet I decided the simplest way was to have one sheet and sort the overall rank manually at the end of each week. If I can't I'll delegate that responsibility to anyone willing to do so

So, I'll rank the challenge either on a Sunday night or Monday morning.

BTW, the font in the cell will change to green once you input a figure that corresponds with a target. So it will be obvious without needing more columns to see who has hit what targets.

Bear with me folks. I'm open to clever ideas by the way...

End of week 4 rank now up. This is how it will stand for the week so please don't edit that column. If your last update for week 4 was not included PM me and I'll adjust tomorrow.

Overall it is proving to be a tight one this year and Its fantastic to see so many acticely participating so far. I have to hand it to the ladies, they are really putting the cat amongst the pigoens. Great stuff!

45% of the swim green - your truly
45% of the cycle green - Fazz, who also has 42% of the swim green
39% of the run green :eek: - RC I'm disappointed I missed the hot black number you were wearing last night :pac: all these miles gotta have you fit lookin'

Who's gonna get the first green mark?!

Everyone please put your hands together for D'pop who has paved a venture to a Tri debut at Valentia Island on 19th May. Lets see if he can do better than TFBubendorfer's one hit wonder

Shell to Run wrote: »

Just updated for week - hope that’s ok?
Another good week. Goal for week was to get an additional cycle in....went outta my way to get 20 miles in Tues and then this morning had a big decision to make. Club cycle or Australian Open tennis final. All round the tennis won with an epic game. Managed to get out later for short but extremely tough 16miles and was well tested with hill repeats – quality over quantity!
Did not miss any planned sessions this week. 5 Runs, 2 Turbo, 2 cycles, 3 swims, yoga and combat class.
Goal for this week is yet again - two cycles.

Thats a savage week's training Shell to Run! How do you find the combat class amidst all the otehr stuff?

hardCopy wrote: »

Are back-dated kms allowed? I haven't added anything since the 8th of Jan (I haven't done much training either)

yep everything from Jan1-Dec 31 is what its all about

RacoonQueen wrote: »

You're just going to have to throw that party you promised for Joey Hannon/Limerick Marathon. I don't take the frock out for just any oul party you know!

I'm actually not around for Joey Hannon but If the sun comes out I'll def throw a BBQ for the GLR

pgibbo wrote: »

Has something changed with the spreadsheet? I just updated and it's like a tab is missing.

Check out post #255

the guy who removed the tab wrote: »

Me and apologies if I have upset anyone's data I've put in a column for the overall rank of the challenge that I will update once a week as late in the week that I can. The status of that will then remain for the next week so you can actually see how you are moving on the challenge versus where you were on last calculation. Fazz is almost 50% to the first green and odds on to hit it first too so once the targets come in the overall SBR points start to become secondary for calculation. Therefore no need for the second tab. I will sort the table regularly by SBR points anyway and others are sorting it by other columns for whatever reason that I'm ok with. I've seen it sorted by turbo kms, name, points, run kms, bike kms, swim kms, treadmill kms so far... so there are plenty on the challenge who know how to sort the table!

So this pins the challenge to a weekly update and maybe a bit of a weekly chat about it in the thread.

If you are sorting the table for some reason, please resort back to SBR points as status quo, thanks.

Its the unique way the challenge is calculated that made this necessary. You may have seen me play with different options such as logging how many of each green and gold target you hit. I was searching for a way to take those into account first. I toyed with variations and without adding another metric or more columns to the spreadsheet I decided the simplest way was to have one sheet and sort the overall rank manually at the end of each week. If I can't I'll delegate that responsibility to anyone willing to do so

So, I'll rank the challenge either on a Sunday night or Monday morning.

BTW, the font in the cell will change to green once you input a figure that corresponds with a target. So it will be obvious without needing more columns to see who has hit what targets.

Bear with me folks. I'm open to clever ideas by the way... .

couerdelion wrote: »

Ok, now I'm back training, ready to mount a challenge to the top of the leaderboard again and I've been deleted! :mad:

I was wondering where you had gone. Feel free to add yourself back in

donothoponpop wrote: »

Ah yeah I understand that, my point is that the big gang of them who have made a sekrit pact together to not swim are being rewarded with a lower overall score (x+y+39), whereas my fully embracing all disciplines is penalized purely because biking is more popular than swimming.
.

No they have not been rewarded with the lower overall score. They collectively have the lowest score for the swim column. The challenge is open to adventure racers, duathletes and those who just do one or the other. I'll guarantee that anyone with a blank on any column at the end of the year will not win the challenge. They may fly high enough if they top the bike and run with 2 golds, but everyone with 3 greens will rank higher regadrless of how many or few SBR points they have.

The fact is, the challenge favoures those who SB and R!

In the first 2 installment of the SBR challeneg we had runaway leaders in each discipline but none of them challeneged at the business end.

So best strategy. Get the 3 greens first and push on from there

Also DeePop, nobody with a 39 swim rank is currently higher than you in rank or lower than you in SBR points... take a chill pill man!

Re: putting the bins out

My sister lives up a mountain and has 0.8km to walk to put her bins out :eek:

I have about 20 meters but it is uphill

Folks

The challenge is now ranked up to week 6.

68% to swim green
65% to bike green
44% to run green

Dory Dory is the lead SBR hoochie now unless RacoonQueen is sitting on a chunky update Shell to run is due her weekly update too which could change things.

Lots of bike miles being put down last week meaning spring must be here?!

Well done to Zico on the Bankok Marathon. Hey its not the result you wanted but you are out there exploring so to knock out a decent marathon off a few weeks traning and in that heat is not to be sniffed at. Fair play!

Bonus points for anyone who can predict the date the first green will land

@Izoard I agree, the ladies are best thing this challenge has seen!