Oxter Posted July 4, 2016 Share Geraldm24, Just out of interest, did any 2 Hubbers pick exactly the same team?active 9 riders or total 12? Will be interesting though. Subs will make the difference in my opinion Link to comment Share on other sites More sharing options...
Frosty Posted July 4, 2016 Share Here are some stats, more to come over the next few days... Link to comment Share on other sites More sharing options...
BDF Posted July 4, 2016 Share active 9 riders or total 12? Will be interesting though. Subs will make the difference in my opinionStarting 9 as a departure point. Subs a category. Link to comment Share on other sites More sharing options...
Frosty Posted July 4, 2016 Share Geraldm24, Just out of interest, did any 2 Hubbers pick exactly the same team?Chances are very good for a yes answer.I will check later and let you knowactive 9 riders or total 12? Will be interesting though. Subs will make the difference in my opinionOf the 648 entries, a duplicate only happens twice:3 people have picked the entire Team Sky team2 people have picked the entire Team DiData4 people didn't select any ridersThe rest of the entries (subs included) returns zero duplicates. Is that possible? Perhaps you would like to know the logic used to determine, and correct me if you think it's not accurate enough:data is in columns C1:N648;12 columns with the formula =small($C1:$N1;1), and repeat for 12 columns changing the 1 to 2, 3, 4... 12. This sorts each team from lowest bib number to highest bib number;Then use =concatenate("'";O1;P1,Q1;...;Z1) to create a "TEXT" value for the team;Then use =countif($AC$1:$AC$648;AC1) to count the number of duplicates in the "TEXT" column. edit: This is for the entire team of 12.edit: 4 hubbers didn't select any riders Link to comment Share on other sites More sharing options...
BDF Posted July 4, 2016 Share Of the 648 entries, a duplicate only happens twice:3 people have picked the entire Team Sky team2 people have picked the entire Team DiData4 people didn't select any ridersThe rest of the entries (subs included) returns zero duplicates. Is that possible? Perhaps you would like to know the logic used to determine, and correct me if you think it's not accurate enough:data is in columns C1:N648;12 columns with the formula =small($C1:$N1;1), and repeat for 12 columns changing the 1 to 2, 3, 4... 12. This sorts each team from lowest bib number to highest bib number;Then use =concatenate("'";O1;P1,Q1;...;Z1) to create a "TEXT" value for the team;Then use =countif($AC$1:$AC$648;AC1) to count the number of duplicates in the "TEXT" column. edit: This is for the entire team of 12.edit: 4 hubbers didn't select any ridersI would have just added the bib numbers together per hubber and sorted. Then match duplicates. If any duplicated then check the individuals. Link to comment Share on other sites More sharing options...
Frosty Posted July 4, 2016 Share I would have just added the bib numbers together per hubber and sorted. Then match duplicates. If any duplicated then check the individuals.Problem is that 1+11+101=11351+41+21 also equals 113 I tried that before (2013 or 2014, I think) Link to comment Share on other sites More sharing options...
Frosty Posted July 4, 2016 Share Okay, if I use just the 9 active riders (without the subs), there are 7 sets of duplicate riders. This means the use of their subs should help split the guys. Link to comment Share on other sites More sharing options...
BDF Posted July 4, 2016 Share Problem is that 1+11+101=11351+41+21 also equals 113 I tried that before (2013 or 2014, I think)Ja, I realise that but it will automatically exclude a huge sample. You way is very clever though. I'm not so smart! Link to comment Share on other sites More sharing options...
Frosty Posted July 4, 2016 Share Here's the duplicate values if you add the bib numbers: 1 - 2592 - 214 3 - 1234 - 365 - 56 - 6 Link to comment Share on other sites More sharing options...
BDF Posted July 4, 2016 Share Here's the duplicate values if you add the bib numbers: 1 - 2592 - 214 3 - 1234 - 365 - 56 - 6So much for my theory! Link to comment Share on other sites More sharing options...
Frosty Posted July 4, 2016 Share So much for my theory!Yip - tried that before. Link to comment Share on other sites More sharing options...
Slowbee Posted July 4, 2016 Share i cant believe i missed a team entry ! Link to comment Share on other sites More sharing options...
Oxter Posted July 4, 2016 Share Does today count as a Rest Day?? I want to make a few changes to my team Link to comment Share on other sites More sharing options...
whitewings Posted July 4, 2016 Share Where do I see current results for fantasy tour? Link to comment Share on other sites More sharing options...
'Dale Posted July 4, 2016 Share i cant believe i missed a team entry !You been too focused on Munga Mango ???? Link to comment Share on other sites More sharing options...
Matt Posted July 4, 2016 Share The leaderboard has been updated with Stage 3 points. Today's stage prize: Fabric Scoop Race SaddleThe Scoop saddle is designed to provide flexibility and great ergonomic feel for all genres of cycling. Starting with our unique flexible base, vacuum bonded upper and custom design rail, the Fabric Scoop is proven to be the perfect balance of comfort, performance and simplicity. Available in three profiles and four specifications. More info: fabric.cc This prize will be awarded to Fantasy team which scores the most White jersey (young rider) points on Stage 3 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.