CQ ranking

[Tuarts]

Holy guacamole, how'd my team go so far over? I checked it twice against the CQ info.

I'll have to investigate further (compare the spreadsheet and mine) when I get home.

 

[Hugo Koblet]

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

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.

 

[Tuarts]

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.

 

[Hugo Koblet]

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.

The spreadsheet is now updated and can be found here: https://docs.google.com/leaf?id=0B7YnE-FpIwSiMTA2NjhkMWEtZDZhMy00MWEzLTg2YzEtZmY2MjYzODg5NWEz&hl=en&authkey=CJTW2ckF

One more thing: Sneekes' team consists of 35 riders. I don't know if he withdrew from the competition or not, but if he didn't, he needs to remove two riders from his team.

 

[Tuarts]

Ok Hugo, can you please omit Bos (182) + Ben King (5) and put in Timothy Roe? Btw, you have Ben King listed as 8 when it should be 5 (not that I think it matters now he's out of the team...).

 

[sublimit]

Nice, I'm in. I must admit to putting Stybar in after looking at a couple of teams, he probably would gone over my head but in the main i've gone for out of form riders that can do better, some obvious ones and youngsters with potential.

I still think 33 riders is a tad too much, i've gone for 30. Still its not my comp but nevertheless i like the format.

 

[Kwibus]

I send my list. Just 28 riders as I can't be bothered to look for good riders with 0-1 points except for the good riders are coming back from a DQ or something ofcourse

 

[Sasquatch]

Do we PM you the teams?

What is Di Luca's value?

 

[Hugo Koblet]

Do we PM you the teams?

What is Di Luca's value?

Yes that's fine.

113.

 

[Armchair cyclist]

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.

 

[The Hitch]

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.

Yep 25- 33 riders
Prices are their value on the cq website http://www.cqranking.com/men/asp/gen/cqRankingRider.asp?current=1
No restrictions
Closing Date is 31st December. But since you havent read the 51 pages you might be unaware that most people already submitted their lists and you are strongly urged to resist the temptation of looking at other people lists. Not that im saying you would, but just a notice.

 

[Hugo Koblet]

Q's and A's today!

I've downloaded the spreadsheet: what are the 2011 results?

Read the opening post.

How and where does one submit an entry?

Read the opening post.

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.

Is it still a case of team size 25-33?

Read the opening post.

Any rider age/nationality restrictions?

No.

Closing date?

Read the opening post.

 

[EvansIsTheBest]

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]

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.

Yes, the spreadsheet was created before the last update came out. I'll look into it now, though.

Thanks.

 

[Hugo Koblet]

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?

 

[joy118118]

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?

search all?

 

[kurtinsc]

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.

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.

 

[The Amateur]

Very nice initiative Hugo. I have been reading CN forums for quite a while but this was what made me register.

I hope I can keep up with the experts in here.

Anyway, I submitted my team in a PM to Hugo but I will post it as well:

ARVESEN Kurt Asle
BOONEN Tom
COBO ACEBO Juan Jose
DEIGNAN Philip
FEILLU Brice
GOSS Matthew
GUSEV Vladimir
HAUSSLER Heinrich
TEN DAM Laurens
KESSIAKOFF Fredrik
URAN URAN Rigoberto
KROON Karsten
BOS Theo
MOLLEMA Bauke
MAASKANT Martijn
NAVARRO GARCIA Daniel
NUYENS Nick
OSS Daniel
PELLIZOTTI Franco
PLAZA MOLINA Ruben
RICCO Riccardo
SANTAMBROGIO Mauro
SCHUMACHER Stefan
SICARD Romain
SOLER HERNANDEZ Juan Mauricio
IGNATIEV Mikhail
STYBAR Zdenek
SÖRENSEN Chris Anker
POSTHUMA Joost
VALVERDE BELMONTE Alejandro
VANDE VELDE Christian
VELITS Peter
ZANDIO ECHAIDE Xabier

I could not resist to include Valverde for 0 points even though he will not race in 2011

Cheers
The Amateur

 

[Dutchsmurf]

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.

 

[Sasquatch]

I've done my team but won't PM it till later and won't post it till after the deadline. Hope I don't have a lot of same selections as others.

 

[Benjamin Hall]

Finally signed up to the forum for this, gonna finish my team off later.

Is entrance still open?

 

[ingsve]

Any chance of allowing substitutions because of the collapse of Pegasus?

 

[skidmark]

Finally signed up to the forum for this, gonna finish my team off later.

Is entrance still open?

Welcome!

The contest is open until the 31st, as far as I know. If anyone knows different, please tell me because I'm holding off on submitting my team until right at the deadline...

 

[The Hitch]

Any chance of allowing substitutions because of the collapse of Pegasus?

My initiial instinct is NO!.

1 ingsve. You should have known better

2 It doesnt benefit me (the main consideration).

But on a more serious note considering people are leaving their submissions till the last possible minute, i think its only fair that you can change the riders you have who it turns out wont be riding.

Just my thought, ultimately its up to hugo of course. But hes been fair throughout, so i expect he will say yes.

 

[Rocksteady]

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.

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!!