Sounds like fun, but I dont think it's a good idea to do the competition in this thread as it will get too crowded and complicated.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 ....
The spreadsheet is now updated and can be found here: https://docs.google.com/leaf?id=0B7YnE-FpIwSiMTA2NjhkMWEtZDZhMy00MWEzLTg2YzEtZmY2MjYzODg5NWEz&hl=en&authkey=CJTW2ckFTuarts 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.
Yes that's fine.Sasquatch said:Do we PM you the teams?
What is Di Luca's value?
Yep 25- 33 ridersArmchair 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?
Yes, the spreadsheet was created before the last update came out. I'll look into it now, though.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.
search all?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?
You can use the countif function.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?
Depends a bit on how the Excel sheet has been build. There sure are ways. Like the countif function or the use of macros.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?
Welcome!Benjamin Hall said:Finally signed up to the forum for this, gonna finish my team off later.
Is entrance still open?
My initiial instinct is NO!.ingsve said:Any chance of allowing substitutions because of the collapse of Pegasus?
WOW!! This has exploded since I was on here last. As far as the CountIf function goes, if you have multiple sheets you could always string CountIf functions (Countif(TEam 1) + Countif(Team 2)) Or you could use a Pivot Table with a Count function on as too many Countif()s can really bog down a file. Let me know if you need more Excel help as I'm an accountant and work in Excel all day. It would be fun to do something enjoyable in it for once. Best of luck to everyone. Here's hoping I break even with my PCM team!!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.
Thread starter | Similar threads | Forum | Replies | Date |
---|---|---|---|---|
S | The 2023 CQ Ranking Manager Thread | Games and Fantasy Cycling | 918 |
Similar threads |
---|
The 2023 CQ Ranking Manager Thread |