Page 18 of 29

Re: Free Spirits CTC Participation and Leaderboard

Posted: Mon Feb 18, 2019 10:20 am
by JonT
Ian Bee wrote: Fri Feb 15, 2019 11:13 am

I have been bold and added a fractional weighting to the scores to avoid ties but not distort the core value (at the moment this is derived from the lifetime CTC total, but I'm very happy to hear thoughts about the preferred way).
Fractional weighting is the future! My recommendation is you bias it towards male, light, older rowers. Just sayin’ :lol:

Re: Free Spirits CTC Participation and Leaderboard

Posted: Mon Feb 18, 2019 11:31 am
by Ian Bee
JonT wrote: Mon Feb 18, 2019 10:20 amMy recommendation is you bias it towards male, light, older rowers.
I suggest no one outside of that definition looks at any of the spreadsheet code :lol: Joke - promise!

Re: Free Spirits CTC Participation and Leaderboard

Posted: Mon Feb 18, 2019 2:52 pm
by RogerB
I like the idea of a bias but make it very old.

Re: Free Spirits CTC Participation and Leaderboard

Posted: Mon Feb 18, 2019 10:43 pm
by Pepe
Roger B. wrote: I like the idea of a bias but make it very old.
Hear, hear :!: :fsbgrin:

Re: Free Spirits CTC Participation and Leaderboard

Posted: Fri Mar 01, 2019 6:02 pm
by Ian Bee
https://docs.google.com/spreadsheets/d/ ... sp=sharing


The three way tie continues at the top of the leaderboard between Felton, Tako and Max (tie broken by a CTC count back). We successfully floated 6 boats, and had 31 entrants.

Major movers in the board include Amber Pierce in her first entry of the year, who finished 7th overall in the female rankings.

Congratulations are due to:
Felton – 60th CTC ^O^ ^O^
Plummy – 160th CTC ^O^ ^O^ ^O^ :shock:
Paul Gould – 100th CTC ^O^ ^O^ ^O^

Well done to everyone!

Re: Free Spirits CTC Participation and Leaderboard

Posted: Sat Mar 02, 2019 6:05 pm
by Sandbaggerone
Thanks Ian! For the lifetime stats I did do some CTCs way back in the depths of time: Jul, Aug, Oct of 06, and Jan and Feb of 07.

Cheers,
Colin Brinkman

Re: Free Spirits CTC Participation and Leaderboard

Posted: Sun Mar 03, 2019 8:13 am
by Ian Bee
Sorry for that Colin - the missing CTCs are now included.

Re: Free Spirits CTC Participation and Leaderboard

Posted: Sun Mar 03, 2019 5:04 pm
by Sandbaggerone
Thanks Ian, nothing like a 12 year gap to help make record-keeping easy ...

Re: Free Spirits CTC Participation and Leaderboard

Posted: Tue Apr 02, 2019 9:37 am
by Ian Bee
https://docs.google.com/spreadsheets/d/ ... sp=sharing

For your delight, please see above the updated CTC leaderboard.

Tako and Max are now topping the ranks, with Tako assuming the lead on the basis of number of CTCs completed =D>

Congratulations to Steve Smith for completing his 150th CTC :fsbgrin: ^O^

Re: Free Spirits CTC Participation and Leaderboard

Posted: Tue Apr 02, 2019 10:13 am
by MaxMacLaren1
Well done Steve, that is a very impressive total!

Re: Free Spirits CTC Participation and Leaderboard

Posted: Tue Apr 02, 2019 12:56 pm
by Tritorow
I must learn to look at ctc totals on last day of month for late entries so I can retry if knocked out of floating boat. Oh well...there is always another challenge :).

Re: Free Spirits CTC Participation and Leaderboard

Posted: Tue Apr 02, 2019 4:17 pm
by Jill
Tritorow wrote: Tue Apr 02, 2019 12:56 pm I must learn to look at ctc totals on last day of month for late entries so I can retry if knocked out of floating boat. Oh well...there is always another challenge .
Janet, being knocked out of a boat at the eleventh hour and finding yourself back in harbour, is an occupational hazard with the CTC fun and games. :fsbgrin: :fswink:

As a ‘ newbie ‘ that was a gutsy effort on your part, especially as it wasn’t the most popular of CTCs.

Well done. :) =D> 👍

Re: Free Spirits CTC Participation and Leaderboard

Posted: Tue Apr 02, 2019 4:57 pm
by Tritorow
Thanks for the kind words, Jill! I did the ctc early on in month but chose not to redo it later because a) I knew I couldn't catch the next faster female (at the time) and b) I have been trying to train at a lower heart rate. Even if I don't float my goal is to do every ctc at least once. This month should allow for easy repeat attempts.

Sent from my SM-G935V using Tapatalk


Re: Free Spirits CTC Participation and Leaderboard

Posted: Wed Apr 03, 2019 7:32 am
by Wolfmiester
Thanks Ian and Max, onward to the 200 then :-)

Re: Free Spirits CTC Participation and Leaderboard

Posted: Thu Apr 04, 2019 4:07 pm
by Ian Bee
I'll pop this over on the current CTC thread as well, but in the finest traditions of a little knowledge being a dangerous (or at least unwise) thing I've put together a basic automatically updating spreadsheet for the Free Spirits results for the current CTC month.

It needs a few eyes on it to test (and indeed to say whether this is helpful), so please feel free to view. I can't tell if its my PC being sluggish or not, but the update on open takes a few seconds to process.

https://docs.google.com/spreadsheets/d/ ... sp=sharing

Re: Free Spirits CTC Participation and Leaderboard

Posted: Thu Apr 04, 2019 5:00 pm
by JonT
Ian Bee wrote: Thu Apr 04, 2019 4:07 pm It needs a few eyes on it to test (and indeed to say whether this is helpful), so please feel free to view. I can't tell if its my PC being sluggish or not, but the update on open takes a few seconds to process.
When I look at this I see Forum Flyers and Free Spirits Ian.

Jon

Re: Free Spirits CTC Participation and Leaderboard

Posted: Thu Apr 04, 2019 5:17 pm
by Ian Bee
JonT wrote: Thu Apr 04, 2019 5:00 pm
Ian Bee wrote: Thu Apr 04, 2019 4:07 pm It needs a few eyes on it to test (and indeed to say whether this is helpful), so please feel free to view. I can't tell if its my PC being sluggish or not, but the update on open takes a few seconds to process.
When I look at this I see Forum Flyers and Free Spirits Ian.

Jon
Seems like when I open it in Sheets, it behaves. From the link, we get problems. I shall see what's going on....

Cheers Jon.

Re: Free Spirits CTC Participation and Leaderboard

Posted: Thu Apr 04, 2019 6:02 pm
by Tako
The link works fast for me with two tabs:

Free:
Image

Rank:
Image

Re: Free Spirits CTC Participation and Leaderboard

Posted: Thu Apr 04, 2019 6:03 pm
by Tako
The rank is not complete as some Free Spirits are missing that already had a go at it.

Re: Free Spirits CTC Participation and Leaderboard

Posted: Thu Apr 04, 2019 6:04 pm
by Ian Bee
Tako wrote: Thu Apr 04, 2019 6:03 pm The rank is not complete as some Free Spirits are missing that already had a go at it.
The auto update script is broken already!

Re: Free Spirits CTC Participation and Leaderboard

Posted: Sat Apr 06, 2019 9:26 am
by Ian Bee
Well, it was a an idea with shades of good. It seems that the scripts function when you open the spreadsheet in Chrome via the Sheets app, but otherwise things go south. It will however make updating the leaderboard a bit easier.

Re: Free Spirits CTC Participation and Leaderboard

Posted: Wed May 01, 2019 2:53 pm
by Ian Bee
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Updated leaderboard as above.

There are numerous movers this month thanks to some very competitive rowing ^O^ ^O^ and a respectable showing from the team of 31 =D> =D> =D> =D>

Tako is now in the lead ahead of Felton, but Guy is making progress in third. Well done gents.

No milestones this month, but we have a new entrant in the person of Ben Cutler. Welcome to the CTC leaderboard :fsbgrin:

Re: Free Spirits CTC Participation and Leaderboard

Posted: Thu May 02, 2019 3:04 pm
by Rodger
Ian, thanks for taking over this baton.

You have me on 65 lifetime CTCs. I think I'm on 72. It was 70 in the list I posted in January and I have done 2 since.

Also, you are bound to miss some challenges from Free Spirits who were not in the 'Club 50' if you are taking the lifetime numbers from the google doc only, because I only started that CTC leaderboard in 2013. I will see if I can update the 50+ list at a later date.

Re: Free Spirits CTC Participation and Leaderboard

Posted: Thu May 02, 2019 3:18 pm
by Ian Bee
Rodger wrote:Ian, thanks for taking over this baton.

You have me on 65 lifetime CTCs. I think I'm on 72. It was 70 in the list I posted in January and I have done 2 since.

Also, you are bound to miss some challenges from Free Spirits who were not in the 'Club 50' if you are taking the lifetime numbers from the google doc only, because I only started that CTC leaderboard in 2013. I will see if I can update the 50+ list at a later date.
Many apologies Rodger - I think this is a user name split problem which I'd not spotted. I'll amend once I'm back with my PC.

Sent from my VTR-L09 using Tapatalk


Re: Free Spirits CTC Participation and Leaderboard

Posted: Thu May 02, 2019 3:22 pm
by Rodger
Ian Bee wrote: Thu May 02, 2019 3:18 pmMany apologies Rodger - I think this is a user name split problem which I'd not spotted. I'll amend once I'm back with my PC.
No worries.