Jancouver said:Idea: Top 10 overall CQ game
So since we have this awesome CQ game going I was also thinking about having a game for the top 10/20/50 or whatever number of overall CQ ranked riders for 2011.
Very simple concept. You will guess the Top 10 riders CQ ranked at the end of the 2011 season.
You get 1 point for every rider you got in top 10 (20/50) and additional points for correct rankings. 10 points if you can guess the winner 9 points for second guy etc all the way to 1 point for rider who was tenth. (or 20 down to 1 if we have top 20 game)
Discuss ....
Tuarts said:Hugo, as the google doc isn't updates, can you please pm me my team and the riders scores, so I can know where I'm over and who to replace. Thanks.
Sasquatch said:Do we PM you the teams?
What is Di Luca's value?
Armchair cyclist said:Just coming back from a couple of weeks away from the forum, really don't want to wade through 51 pages to find out what's what.
I've downloaded the spreadsheet: what are the 2011 results?
How and where does one submit an entry?
I'm assuming that column I of the 2010 results page is the "price" of each rider.
Other than Di Luca, for whom I see that 113 is the price, where are prices for other riders returning from suspensions?
Is it still a case of team size 25-33?
Any rider age/nationality restrictions?
Closing date?
It would have been nice to have had my very similar World Rankings comp given the benefit of stickiness to gain higher profile, but thanks for setting up this one.
Read the opening post.Armchair cyclist said:I've downloaded the spreadsheet: what are the 2011 results?
Read the opening post.Armchair cyclist said:How and where does one submit an entry?
Read the opening post.Armchair cyclist said:Other than Di Luca, for whom I see that 113 is the price, where are prices for other riders returning from suspensions?
Read the opening post.Armchair cyclist said:Is it still a case of team size 25-33?
No.Armchair cyclist said:Any rider age/nationality restrictions?
Read the opening post.Armchair cyclist said:Closing date?
EvansIsTheBest said:Hugo, not that it really matters but Teklehaimanot has 116 points and not 76 as it is written in the spreadsheet. It is probably because you took the classification before they updated Tour of Rwanda.
Hugo Koblet said:A question:
Does anyone know if it's possible to do some data analysis in Excel? Like making the program list what riders have been chosen how many times etc?
Hugo Koblet said:A question:
Does anyone know if it's possible to do some data analysis in Excel? Like making the program list what riders have been chosen how many times etc?
Hugo Koblet said:A question:
Does anyone know if it's possible to do some data analysis in Excel? Like making the program list what riders have been chosen how many times etc?
Benjamin Hall said:Finally signed up to the forum for this, gonna finish my team off later.
Is entrance still open?
ingsve said:Any chance of allowing substitutions because of the collapse of Pegasus?
kurtinsc said:You can use the countif function.
For example, if you had all the teams on one sheet, you would use something like "=COUNTIF(Teams!$1:$65536,E2) in a cell next to the CQ data. This would essentially count all the occurrences of whatever is in E2 on the sheet named "Teams". If E2 is rider name, and you drag that cell down, you'd get a count of every team on that sheet with each name.
To be honest, I'm not sure how you'd do that over a series of sheets though.