CQ ranking

[kurtinsc]

You need to drop MATTHEWS to 258 as he has had a result from 2009 dropped which hasn't been included in the latest release, that will bring Moondance and Joy in under budget.

New list after Matthews point reduction:

Player 2010 Points
1. Hugo Koblet 7495
2. Moondance 7483
3. who dat 7231
4. Vonn Brinkman 7758
5. The Cobra 7471
6. hrotha 7500
7. auto de fé 7500
8. Parrulo 7473
9. pabryan 7441
10. kurtinsc 7495
11. Rocksteady 7499
12. togo95 7450
13. Barrus 7254
14. Libertine Seguros 7492
15. auscyclefan94 7207
16. Jukebox 7493
17. Contre la montre 7500
18. Bumeington 7492
19. Kvinto 7479
20. ingsve 7500
21. Moncoutie 7499
22. Ferminal 7473
23. deValtos 7491
24. nvpacchi 7470
25. roundabout 6980
26. jens_attacks 7500
27. Mellow Velo 7499
28. The Hitch 7435
29. Team Sky Fans 7485
30. Joy118118 7500
31. Jaiying 7475
32. Bicing 7498


That just leaves Von Brinkman as being WAY over budget.

 

[Hugo Koblet]

A lot of people seem to be willing to help out with the whole Excel thing so thanks a lot bicing, Ferminal and kurtinsc.

There is one major issue, though, which Ferminal noted:

During the 2011 season, the sheets that CQ Ranking makes available for download shows the riders current CQ Ranking, which means that if you download the sheet in say, april 2011, the sheet will show each riders value based on his April 2010 - April 2011 results.

In some way we need to only get the points earned in the 2011 season to be able to make updates during the season.

 

[kurtinsc]

Please include Bos in my list. I think something went wrong along the way, as he is in my team. Theo Bos 182 points

That would put you over. Your current team is:

32. Bicing 2010 Results
ANTON HERNANDEZ Igor 952
ARVESEN Kurt Asle 24
BALLAN Alessandro 474
BRUSEGHIN Marzio 123
CUNEGO Damiano 659
DI LUCA Danilo 113
GADRET John 322
GASPAROTTO Enrico 284
GOSS Matthew 634
HAUSSLER Heinrich 251
HENAO MONTOYA Sergio Luis 61
KROON Karsten 130
MEYER Cameron 175
NAVARRO GARCIA Daniel 90
PELLIZOTTI Franco 60
PHINNEY Taylor 217
RASMUSSEN Alex 267
RENSHAW Mark 106
ROCHE Nicolas 847
RUJANO GUILLEN Jose Humberto 261
SAGAN Juraj 34
SASTRE CANDIL Carlos 574
SELLA Emanuele 354
SERBAN Albert Filon 3
STYBAR Zdenek 9
TAARAMÄE Rein 383
VANDE VELDE Christian 90
WOLSKI Marcin 1
7498

 

[Barrus]

That is Bicing list Kurtinsc, my list, without Bos would be at 7254, and with him 7436

 

[kurtinsc]

A lot of people seem to be willing to help out with the whole Excel thing so thanks a lot bicing, Ferminal and kurtinsc.

There is one major issue, though, which Ferminal noted:

During the 2011 season, the sheets that CQ Ranking makes available for download shows the riders current CQ Ranking, which means that if you download the sheet in say, april 2011, the sheet will show each riders value based on his April 2010 - April 2011 results.

In some way we need to only get the points earned in the 2011 season to be able to make updates during the season.

If we need to, we can cut and paste 100 rows at a time from what displays when you search for a year. We might have to modify the lookup formulas a little if we do that, but the format for the names is the same.

That will take a bit longer as we get to the end of the season... we're looking at about 34 pages... but that should still take less then 20 minutes. Not ideal but workable.

 

[kurtinsc]

That is Bicing list Kurtinsc, my list, without Bos would be at 7254, and with him 7436

Oops... my eyes played a trick on me.

Here you go:

13. Barrus 2010 results
BOIVIN Guillaume 151
BOL Jetse 115
CAVENDISH Mark 1241
DEBUSSCHERE Jens 39
DOWSETT Alex 10
DUARTE AREVALO Fabio Andres 181
HAUSSLER Heinrich 251
KASHECHKIN Andrey 84
KEUKELEIRE Jens 479
KING Benjamin 149
KRUIJSWIJK Steven 216
MATTHEWS Michael 258
MODOLO Sacha 330
MOLLEMA Bauke 524
NIERMANN Grischa 86
PELLIZOTTI Franco 60
PHINNEY Taylor 217
ROE Timothy 43
RUJANO GUILLEN Jose Humberto 261
SICARD Romain 174
SLAGTER Tom Jelte 52
SOLER HERNANDEZ Juan Mauricio 47
SPILAK Simon 555
STEEGMANS Gert 255
STYBAR Zdenek 9
TAARAMÄE Rein 383
TALANSKY Andrew 76
TXURRUKA ANSOLA Amets 75
VAN GARDEREN Tejay 531
VANDE VELDE Christian 90
VIVIANI Elia 312
BOS Theo 182
7436

 

[kurtinsc]

A lot of people seem to be willing to help out with the whole Excel thing so thanks a lot bicing, Ferminal and kurtinsc.

There is one major issue, though, which Ferminal noted:

During the 2011 season, the sheets that CQ Ranking makes available for download shows the riders current CQ Ranking, which means that if you download the sheet in say, april 2011, the sheet will show each riders value based on his April 2010 - April 2011 results.

In some way we need to only get the points earned in the 2011 season to be able to make updates during the season.

There appears to be a "year ranking" sheet as well as the main one on the document. Wouldn't that contain the right data?

 

[roundabout]

My team is missing LE MEVEL Christophe 510

 

[joy118118]

Sorrt, I forgot the 2010 ranking and the current ranking are slightly different.

have the change.
MATTHEWS Michael 278---> LANGEVELD Sebastian 229

 

[Ferminal]

A lot of people seem to be willing to help out with the whole Excel thing so thanks a lot bicing, Ferminal and kurtinsc.

There is one major issue, though, which Ferminal noted:

During the 2011 season, the sheets that CQ Ranking makes available for download shows the riders current CQ Ranking, which means that if you download the sheet in say, april 2011, the sheet will show each riders value based on his April 2010 - April 2011 results.

In some way we need to only get the points earned in the 2011 season to be able to make updates during the season.

The only way I can think of is to set it up so...

[1/1/2011 -> 31/1/2011] = [01/02/2010 -> 31/1/2011] - [01/02/2010 -> 31/12/2010]

That would require recording certain dates from the 2010 calendar (the CQ files seem to be updated after Sunday races once a week during the season).

Basically it's:

2011 points up to the specific date = "rolling" 12 month CQ points (which we get from the 2011 files) - CQ points in 2010 for the equivalent date after the 2011 setting, until the end of the year (which we could do by taking or end year 2010 number from specific dates on the 2010 calendar which correspond with the days we want to update the 2011 ranks))

 

[Ferminal]

There appears to be a "year ranking" sheet as well as the main one on the document. Wouldn't that contain the right data?

Oh yeh, that's what we want... I forgot that sheet was there

 

[kurtinsc]

My team is missing LE MEVEL Christophe 510

25. roundabout 2010 results
ARVESEN Kurt Asle 24
BENNATI Daniele 615
BOOM Lars 463
BOONEN Tom 777
CASTROVIEJO NICOLAS Jonathan 100
CHAVANEL Sylvain 533
CLEMENT Stef 54
COBO ACEBO Juan Jose 0
CUNEGO Damiano 659
DE LA FUENTE RASILLA David 72
DESSEL Cyril 80
GUSEV Vladimir 443
HAUSSLER Heinrich 251
KESSIAKOFF Fredrik 34
LE LAY David 85
LÖFKVIST Thomas 319
MENCHOV Denis 882
MOLMY Arnaud 80
MORABITO Steve 282
NAVARRO GARCIA Daniel 90
POSTHUMA Joost 99
POUX Paul 42
POZZATO Filippo 771
SOLER HERNANDEZ Juan Mauricio 47
VAITKUS Tomas 45
VANDE VELDE Christian 90
WILLEMS Frederik 43
LE MEVEL Christophe 510
7490

 

[roundabout]

Thank you.

 

[ingsve]

A lot of people seem to be willing to help out with the whole Excel thing so thanks a lot bicing, Ferminal and kurtinsc.

There is one major issue, though, which Ferminal noted:

During the 2011 season, the sheets that CQ Ranking makes available for download shows the riders current CQ Ranking, which means that if you download the sheet in say, april 2011, the sheet will show each riders value based on his April 2010 - April 2011 results.

In some way we need to only get the points earned in the 2011 season to be able to make updates during the season.

No, that won't be a problem I think. The CQ xml file has a tab for the single year ranking as well. You just have to be careful to use the right list.

 

[kurtinsc]

Hugo, do you want to wait until the December 31st deadline and send me the final team list, or do you want me to go ahead and send the file now?

There's a bit of manual stuff when you add a team (excel doesn't like doing a lookup of a calculated field... so I have to hardcode the references to get the team totals onto the summary sheet). But once the teams are finalized, all that is required to update is to copy the correct sheet from the CQ download to the 2011 results sheet... and everything should just update after that.

Send me a PM with an e-mail when you want it.

 

[The Hitch]

28. The Hitch 7435

7435. I had 7495!!!1

 

[kurtinsc]

7435. I had 7495!!!1

28. The Hitch 2010 Results
BALLAN Alessandro 474
BLANCO RODRIGUEZ David 300
BOONEN Tom 777
BOS Theo 182
FEILLU Brice 70
COBO ACEBO Juan Jose 0
CUNEGO Damiano 659
DEIGNAN Philip 5
DUARTE AREVALO Fabio Andres 181
EFIMKIN Vladimir 20
GASPAROTTO Enrico 284
GOLAS Michal 141
GRIVKO Andriy 281
HAEDO Juan Jose 399
HAUSSLER Heinrich 251
HUTAROVICH Yauheni 370
KASHECHKIN Andrey 84
KWIATKOWSKI Michal 87
MADRAZO RUIZ Angel 20
MARYCZ Jaroslaw 88
NOCENTINI Rinaldo 227
PELLIZOTTI Franco 60
PETROV Evgeni 241
PHINNEY Taylor 217
RUJANO GUILLEN Jose Humberto 261
SELLA Emanuele 354
SICARD Romain 174
SOLER HERNANDEZ Juan Mauricio 47
STEEGMANS Gert 255
TXURRUKA ANSOLA Amets 75
URAN URAN Rigoberto 410
VALJAVEC Tadej 65
WIGGINS Bradley 376
7435

 

[bicing]

Okay, I've got the teams that Ferminal edited and posted in the thread loaded in the database, as well as those that posted their teams in a "CQ cut and paste friendly format".

I actually prefer not to have the point numbers... I have to go through and remove them first. But it's not a huge deal.

Here are a list of th teams I have and what I have their point totals at based on the file downloaded from CQ. THe only change I made to the CQ points was to add di luca at 113 points (he was showing at 0 before), everything else is straight from the CQ file. Give me a heads up if last year's points were agreed to be different for another rider.

Dude I already made the spreadsheet, and you don't need to go and remove any numbers. And you don't need to do any manual entry with the CQ rankings. Its easier to just use mine.

Cheers
bicing

 

[kurtinsc]

Dude I already made the spreadsheet, and you don't need to go and remove any numbers. And you don't need to do any manual entry with the CQ rankings. Its easier to just use mine.

https://spreadsheets.google.com/ccc...5c2RVQ3VobFNxUUE&hl=en&authkey=COTP_54D#gid=1

Cheers
bicing

Very similar to mine.

The "manual" part I referred to was when adding a new team, you have to add the reference to the team total in column C of the results sheet and copy the formulas when creating a new team.

I didn't think about using string functions to chop the points off though... that probably would have been faster then manually chopping off the number. I do like having clean data though.

You've got to add di luca to the bottom of the results list as well.

Very little difference between the two.

 

[Bumeington]

Dude I already made the spreadsheet, and you don't need to go and remove any numbers. And you don't need to do any manual entry with the CQ rankings. Its easier to just use mine.

https://spreadsheets.google.com/ccc...5c2RVQ3VobFNxUUE&hl=en&authkey=COTP_54D#gid=1

Cheers
bicing

Good work bicing. One thing however, Di Luca is valued at 0 in your sheet not 113. Should be easy to change though.

 

[The Hitch]

Good work bicing. One thing however, Di Luca is valued at 0 in your sheet not 113. Should be easy to change though.

We were told Di luca was worth a lot more than that

 

[bicing]

Very similar to mine.

The "manual" part I referred to was when adding a new team, you have to add the reference to the team total in column C of the results sheet and copy the formulas when creating a new team.

I didn't think about using string functions to chop the points off though... that probably would have been faster then manually chopping off the number. I do like having clean data though.

You've got to add di luca to the bottom of the results list as well.

Very little difference between the two.

OK so you already did it?? Must have missed that in the forum.

Adding diluca will happen automatically when he gets results, he is zero because the actual points he scored in 2010 was zero. i was trying to make it easy as possible to update teams and update results as time goes on

 

[kurtinsc]

We were told Di luca was worth a lot more than that

The last I heard was in post #86 on page 9 of the thread:

Franco Pellizotti: 60 CQ Dollars
Michael Rasmussen: 38
Davide Rebellin: 775
Danilo di Luca: 113

I didn't add Rebellin as nobody has selected him I think... and the numbers for Rasmussen and Pellizotti are in the table correct anyway.

 

[Barrus]

Dude I already made the spreadsheet, and you don't need to go and remove any numbers. And you don't need to do any manual entry with the CQ rankings. Its easier to just use mine.

https://spreadsheets.google.com/ccc...5c2RVQ3VobFNxUUE&hl=en&authkey=COTP_54D#gid=1

Cheers
bicing

If he uses yours, please add BOS Theo 182 to mine

 

[kurtinsc]

OK so you already did it?? Must have missed that in the forum.

Adding diluca will happen automatically when he gets results, he is zero because the actual points he scored in 2010 was zero. i was trying to make it easy as possible to update teams and update results as time goes on

Yeah... I have a seperate 2010 and 2011 sheet for looking up... thought it would be fun to track the change in points for riders from last year to this year. Was also using 2010 to verify people were under the point limit.