Page 17 of 29

Re: Free Spirits CTC Participation and Leaderboard

Posted: Thu Jan 03, 2019 10:28 am
by Ian Bee
A quick round up of praiseworthy milestones achieved by the end of 2018:

Liefcat has reached the heights of 80 lifetime CTCs ^O^ =D>

Steve Smith is joined by Peter Tullet in reaching 70 lifetime CTCs ^O^ =D>

Very well done to them!

I've added a column for lifetime CTC tracking to the googlesheet in case anyone (hopefully not just me!) is motivated/interested. Please let me know if there's any errors.

Edit - all very wrong. sorry!
Image

Re: Free Spirits CTC Participation and Leaderboard

Posted: Thu Jan 03, 2019 10:56 am
by Grobi
Ian, thanks for adding the number of lifetime ctcs which is very helpful/motivational as far as I‘m concerned.

However, I think the numbers aren‘t correct. The highest score for lifetime ctcs in your table is 80 for Erik/Liefcat, but I know for sure that there is a number of Free Spirits that have rowed more than 100 ctcs. Maybe that column is missing a season or two?

Re: Free Spirits CTC Participation and Leaderboard

Posted: Thu Jan 03, 2019 10:59 am
by Ian Bee
Hmmmm - that column selects for those who rowed last year (and I will update if anyone else returns to the ctc).

The full list is in the running totals tab, but that doesn't show any 100+.

Back to the drawing board. Drat: pre 2013 results.....

Sent from my VTR-L09 using Tapatalk





Re: Free Spirits CTC Participation and Leaderboard

Posted: Thu Jan 03, 2019 2:23 pm
by plummy
From May last year....
ScreenHunter_193 Jan. 03 14.22.jpg
ScreenHunter_193 Jan. 03 14.22.jpg (77.38 KiB) Viewed 3390 times

Re: Free Spirits CTC Participation and Leaderboard

Posted: Thu Jan 03, 2019 2:26 pm
by Rodger
Here is an updated version of that list:

Image

Re: Free Spirits CTC Participation and Leaderboard

Posted: Thu Jan 03, 2019 5:02 pm
by Ian Bee
Thank you both - I'll add all the figures in.

Re: Free Spirits CTC Participation and Leaderboard

Posted: Fri Jan 04, 2019 6:31 am
by CamiCrew
Thanks Ian for the tracking work.

Re: Free Spirits CTC Participation and Leaderboard

Posted: Fri Jan 04, 2019 11:03 am
by Liefcat
Thanks for the updates, and the seemingly very demanding task of keeping track of lifetime ctc´s :!: ^O^ (For me I started as Erik Pedersen, then at a point changed it to Liefcat. And on one occasion I couldn´t scroll down to L on my Smartphone, so had to make a new "A Liefcat" to be able to make an entry - Well the list from May last year that Plummy referred to seems to have grasped those "changes")...

Re: Free Spirits CTC Participation and Leaderboard

Posted: Fri Jan 04, 2019 12:11 pm
by Ian Bee
All the figures are now in, and I've spotted a couple of duplications on the running totals tab to deal with.

I can see that previous years had other statistics presented (average points, % CTCs completed). If any of these are of interest I can easily automate this.

Sent from my VTR-L09 using Tapatalk


Re: Free Spirits CTC Participation and Leaderboard

Posted: Fri Jan 04, 2019 5:27 pm
by Grobi
Thanks for all the work you‘re putting into this Ian!

Knowing I‘m making myself unpopular here, but could you have a look at the following points:

- Steve Smith/Wolfmiester managed to row 246 ctcs, which is amazing given that there have been only 169 ctcs so far :lol: I think somehow you added 100 to his correct total of 146 (sorry Steve to be a spoilsport here :D )

- WiganLad and Hewitt are the same person (Jason Hewitt). According to Roger‘s list he rowed a total of 58 ctcs, not two.

- Joe Lohman‘s total is 68, not 62

- I‘m missing Bill Wright with a total of 73

Re: Free Spirits CTC Participation and Leaderboard

Posted: Fri Jan 04, 2019 5:29 pm
by Ian Bee
Grobi wrote:Thanks for all the work you‘re putting into this Ian!

Knowing I‘m making myself unpopular here, but could you have a look at the following points:

- Steve Smith/Wolfmiester managed to row 246 ctcs, which is amazing given that there have been only 169 ctcs so far Image I think somehow you added 100 to his correct total of 146 (sorry Steve to be a spoilsport here :D )

- WiganLad and Hewitt are the same person (Jason Hewitt). According to Roger‘s list he rowed a total of 58 ctcs, not two.

- Joe Lohman‘s total is 68, not 62
Genuinely pleased to have the extra eyes on the sheet - I was aware of some of the above issues, but not all.


Steve Smith/Wolfie - that was a fat fingered 113 rather than 13 for a previous year :oops:
WiganLad/Hewitt - now reintegrated as a single person (though currently 56 : 32 pre 2012, and the remainder as listed in the googlesheet. I'll look further).
Joe Lohman - updated to 68

I'm aware of Jon P Taylor, Hayley Plumb and a number of others appearing twice too which will have effects on the lifetime totals. I'll correct these this evening.his

Roger Burrell is missing an entry in 2013 (hence currently his total differs).
Sent from my VTR-L09 using Tapatalk

Re: Free Spirits CTC Participation and Leaderboard

Posted: Fri Feb 01, 2019 12:45 pm
by Ian Bee
The first leaderboard for 2019 is available here: https://docs.google.com/spreadsheets/d/ ... sp=sharing

Freespirits had 31 entrants this month. I believe - fingers crossed - I can congratulate:

Jon Taylor - 50th CTC ^O^
Philip Price - 90th CTC ^O^ ^O^
Sharky Jacaway - Warm welcome to a new entrant :fsbgrin:

Re: Free Spirits CTC Participation and Leaderboard

Posted: Fri Feb 01, 2019 2:46 pm
by Caratacus
Thanks for doing this Ian

I have a small question regarding the totals: on April fool's day 2017 the fish game was posted as a joke and some of us posted scores for this but it has subsequently been deleted from the CTC website. In the past I believe this challenge has been added to the totals of those that completed it. I don't think you are including it so perhaps we could all come to some collective agreement as to whether or not this should be included? Personally I feel that as it was just a joke and that it's been deleted we should just ignore it

Re: Free Spirits CTC Participation and Leaderboard

Posted: Fri Feb 01, 2019 3:04 pm
by Ian Bee
Caratacus wrote: Fri Feb 01, 2019 2:46 pm Thanks for doing this Ian Image

I have a small question regarding the totals: on April fool's day 2017 the fish game was posted as a joke and some of us posted scores for this but it has subsequently been deleted from the CTC website. In the past I believe this challenge has been added to the totals of those that completed it. I don't think you are including it so perhaps we could all come to some collective agreement as to whether or not this should be included? Personally I feel that as it was just a joke and that it's been deleted we should just ignore it
Thanks Felton.

The 2017 fish game is currently included in the google sheets running totals, but it's easy to remove that column of records (or indeed fiddle with the formulas to discount the fish game figures from the running CTC total, points total etc).

As such, I'm minded to agree with you that the scores should be cut (but we can preserve the record).

Re: Free Spirits CTC Participation and Leaderboard

Posted: Fri Feb 01, 2019 3:14 pm
by Caratacus
Ok, I see it now, had miscalculated my own running total
It would be interesting to know everyone's view on this. I kind of wish they had just owned the joke a bit more and kept the record on the CTC website.

Re: Free Spirits CTC Participation and Leaderboard

Posted: Fri Feb 01, 2019 3:57 pm
by Wolfmiester
Obviously I'm slightly bias, as I didn't get to do it. However that's sort of the point, there will be the majority of people who didn't even see it as an 'event', therefore I feel its unfair to 'penalise' for not doing it.
The CTC is a monthly challenge (with the addition of the 14/2 memorial row. At least that one is announced beforehand).

Re: Free Spirits CTC Participation and Leaderboard

Posted: Fri Feb 01, 2019 4:03 pm
by Caratacus
So that seems to be 3 against so far; anyone want to weigh in on the 'for' side?

Re: Free Spirits CTC Participation and Leaderboard

Posted: Fri Feb 01, 2019 4:18 pm
by Ian Bee
If it assists anyone's decision, in the event that the scores are adjusted:
  • No rowers loose a milestone of completed CTCs
  • Four rowers swap places: e-Clair and Joe Lohman; RGelissen and Paul Gould

Re: Free Spirits CTC Participation and Leaderboard

Posted: Fri Feb 01, 2019 5:19 pm
by plummy
I'm ok with losing it. It was probably too much of an oddball one off.

Re: Free Spirits CTC Participation and Leaderboard

Posted: Fri Feb 01, 2019 6:52 pm
by Tako
plummy wrote:I'm ok with losing it. It was probably too much of an oddball one off.
Me too

Re: Free Spirits CTC Participation and Leaderboard

Posted: Sat Feb 02, 2019 8:42 am
by JonT
I didn’t do it, so could be biased, but I would lose it. I agree with keeping 14/2 though.

Re: Free Spirits CTC Participation and Leaderboard

Posted: Fri Feb 15, 2019 6:41 am
by Ian Bee
Deleted.

Re: Free Spirits CTC Participation and Leaderboard

Posted: Fri Feb 15, 2019 7:01 am
by Tako
Ian Bee wrote:Update to the leaderboard following the 2019 Carole McNally Memorial

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

Tako now has assumed the summit of the table, and Guy completed his 20th CTC.
Good morning Ian!
As much as I love seeing my name at the top, you have a minor hickup in the table!
The next in the list all have equal number of points; hence, all up to Guy share the first spot.
As Felton was faster in both I think he should go first, unless you take age into account, but then one should look at putting the female and LWT ahead .....

Anyway, thanks for the short moment of glory!!

Re: Free Spirits CTC Participation and Leaderboard

Posted: Fri Feb 15, 2019 7:51 am
by Ian Bee
Tako wrote:
Ian Bee wrote:Update to the leaderboard following the 2019 Carole McNally Memorial

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

Tako now has assumed the summit of the table, and Guy completed his 20th CTC.
Good morning Ian!
As much as I love seeing my name at the top, you have a minor hickup in the table!
The next in the list all have equal number of points; hence, all up to Guy share the first spot.
As Felton was faster in both I think he should go first, unless you take age into account, but then one should look at putting the female and LWT ahead .....

Anyway, thanks for the short moment of glory!!
Gah! Damn my blurry morning eyes....

Or a bug in the sheet - I'll see what's gone wrong later today.

Sent from my VTR-L09 using Tapatalk

Re: Free Spirits CTC Participation and Leaderboard

Posted: Fri Feb 15, 2019 11:13 am
by Ian Bee
Hopefully, and apologies for this becoming a theme, the google sheet is now corrected.

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


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).