CQ ranking

[who dat]

You have who dat (Who Dat) twice in that list...

Nah, don't fix it then I can score double points all season

 

[Hugo Koblet]

With some inspiration from the spreadsheets I have recieved, I have made some changes to the one I recieved from kurtinsc. I will try uploading it later today to let people see what they think about the layout.

 

[Mellow Velo]

Good luck with that. You seriously think Dowsett will be doing spectacular rides and beating seasoned pros?

i see phinney and matthews getting as many chances as any neo pro at htc or saxo has been given. BMC are making a special bike specifically for phinney for the track. Quite of few of BMC's bikes won some big awards and they are known to be top bikes.

Let's not send this thread down a sidetrack with yet more of ACF's biased pearls of wisdom.
At least until we have all the teams in and the spreadsheet system sorted.

A number of guys are putting in a heck of a lot of work to get this up and running.
Chapeau sirs!

 

[who dat]

Great job to all people working on the spreadsheets would like to help out but I'm not exactlly that good at the finer details of spreadsheets and stuff like that.

Keep up the good work Guys

 

[Kazistuta]

Saw this thread a couple of days ago and decided to put in a team. Even though Hugo has decided to put a limit on the number of participants, I'll post my team to claim bragging rights, when it turns out this team is the most improved

CAVENDISH Mark 1241
ANTON HERNANDEZ Igor 952
BOONEN Tom 777
BALLAN Alessandro 474
TAARAMÄE Rein 383
WIGGINS Bradley 376
CHICCHI Francesco 287
HAUSSLER Heinrich 251
CATALDO Dario 230
NAPOLITANO Danilo 223
NUYENS Nick 220
GALIMZYANOV Denis 193
HAEDO Lucas Sebastian 189
BOS Theo 182
GODDAERT Kristof 171
VANSUMMEREN Johan 147
QUINZIATO Manuel 144
GERRANS Simon 140
KROON Karsten 130
VANDE VELDE Christian 90
MARYCZ Jaroslaw 88
PAUWELS Serge 87
KASHECHKIN Andrey 84
MASCIARELLI Francesco 66
PELLIZOTTI Franco 60
CLEMENT Stef 54
STEENSEN André 54
SOLER HERNANDEZ Juan Mauricio 47
GOMEZ MARCHANTE Jose Angel 44
SEELDRAEYERS Kevin 40
IMPEY Daryl 39
JEANNESSON Arnold 26
KRITSKIY Timofey 0

 

[Arnout]

Where can I see if my team is accepted (I sent it via PM)?

 

[auscyclefan94]



He and Cam will go to Berlin six-day and worlds track. This means not much point until May. From an article, i think i read it in cyclingnews, he said htc gave him a lot freedom to continue track. He has the talent. Hope he not waste it.

Take a look at this from a tweet from Mike Tomalaris

Just found the article which quotes him saying it.
http://www.sbs.com.au/cyclingcentral/news/18627/Howard-calling-time-on-track-career

He may do the Berlin 6 day event but that will be it.

 

[Hugo Koblet]

Saw this thread a couple of days ago and decided to put in a team. Even though Hugo has decided to put a limit on the number of participants, I'll post my team to claim bragging rights, when it turns out this team is the most improved

CAVENDISH Mark 1241
ANTON HERNANDEZ Igor 952
BOONEN Tom 777
BALLAN Alessandro 474
TAARAMÄE Rein 383
WIGGINS Bradley 376
CHICCHI Francesco 287
HAUSSLER Heinrich 251
CATALDO Dario 230
NAPOLITANO Danilo 223
NUYENS Nick 220
GALIMZYANOV Denis 193
HAEDO Lucas Sebastian 189
BOS Theo 182
GODDAERT Kristof 171
VANSUMMEREN Johan 147
QUINZIATO Manuel 144
GERRANS Simon 140
KROON Karsten 130
VANDE VELDE Christian 90
MARYCZ Jaroslaw 88
PAUWELS Serge 87
KASHECHKIN Andrey 84
MASCIARELLI Francesco 66
PELLIZOTTI Franco 60
CLEMENT Stef 54
STEENSEN André 54
SOLER HERNANDEZ Juan Mauricio 47
GOMEZ MARCHANTE Jose Angel 44
SEELDRAEYERS Kevin 40
IMPEY Daryl 39
JEANNESSON Arnold 26
KRITSKIY Timofey 0

I removed the restriction again, so welcome to the game

Where can I see if my team is accepted (I sent it via PM)?

I have recieved your PM so don't worry - at the moment I'm just working on the spreadsheet so I haven't updated the list of teams.

 

[Timmy-loves-Rabo]

KRITSKIY Timofey 0

nice one, wish i had got him.
i kinda wish i got boy van poppel also.. he might yet rack up some points this season.

 

[Kazistuta]

nice one, wish i had got him.

Well, I read about the potential bargain buys in Cobo and Stybar, decided I wouldn't pick either one of them, and then I had to find another one by myself Would be surprised if noone else "remembers" him.

Really hope that Kritskiy gets some succes next season, he deserves it after his lack of luck in 2010.

And I just realised that I totally forgot about Di Luca, who was the first name that came to mind when I read HK's initial post - absolute brain fart on my behalf, but I'll have to do without him...

 

[The Hitch]

Well, I read about the potential bargain buys in Cobo and Stybar, decided I wouldn't pick either one of them, and then I had to find another one by myself Would be surprised if noone else "remembers" him.

Really hope that Kritskiy gets some succes next season, he deserves it after his lack of luck in 2010.

Your team is good. Kritskiy Van Summeren and Taramei are all riders i wish i thought of.

And you went with the full 33 which i think is a wise choice.

 

[Hugo Koblet]

Alright.

I think we're ready for the 2011 season.

I have now uploaded the spreadsheet we will be using to keep track of the score board (unless something better comes up or something is very wrong with this).

Here's how it works:

The first sheet named "Rankings" shows a list of all the teams ranked in order. The leader is at the top and so on. The 2010 points shows the value of the team in the 2010 season, and the 2011 points shows the teams points this (next) season. Total point rank shows what place each team is in. Gain/loss shows how much profit the team has made (or lost!) in the 2011 season compared to the 2010 season.

The next sheets shows the individual teams. Each team has got their own sheet. This is because I thought it was a bit confusing and badly arranged if all teams were just thrown in one single sheet. Each sheet shows the same as the "Rankings" sheet: 2010 points, 2011 points and Gain/loss.

That's actually it. Don't mind the last 3 sheets named "Teams", "2010 Results" and "2011 Results".

Note: In the spreadsheet uploaded I have inserted the 2009 points in the 2011 points row. This was just to test if it works, but I thought I might as well keep it there - that way you can all see how it works

Now since I've been a bit busy the last days there will probably be a few minor mistakes in the various teams. I therefore request you all to go check your team to see if I've made any errors. Also please notice if your team value exceeds 7500.

If anyone notices anything in the spreadsheet that doesn't work please let me know. Also if I've made any minor spelling errors in your name, or the text size isn't the same in every sheet. Yes, I'm a bit perfectionist

Here's a list of team registered. If you aren't in the list but have already send your team, let me know.

Arnout
auscyclefan94
auto de fé
Barrus
bicing
Bumeington
Contre la montre
deValtos
Erik8-A
Ferminal
hrotha
Hugo Koblet
ingsve
jaiying
Jancouver
Jan the Man
jens_attacks
joy118118
Jpettersen
Jukebox
Kazistuta
kurtinsc
Kvinto
Libertine Seguros
LukeSchmid
mc_mountain
Mellow Velo
Moncoutie
Moondance
nvpacchi
pabryan
Parrulo
roundabout
Rocksteady
Spider1964
TeamSkyFans
The Cobra
The Hitch
Timmy-loves-Rabo
togo95
Vonn Brinkman
whittashau
who dat

And here's the spreadsheet:

https://docs.google.com/leaf?id=0B7...hlNjAtYmIxMmNmOTNlNTMz&hl=en&authkey=CMij_fYO

 

[tgsgirl]

Hi Hugo, can I still join?

1 Tom Boonen 777
2 Heinrich Haussler 251
3 Martijn Maaskant 118
4 Kevin Seeldraeyers 40
5 Laurens Ten Dam 97
6 Marco Bandiera 21
7 Brice Feillu 70
8 Amets Txurruka 75
9 Simon Gerrans 140
10 Phillip Deignan 5
11 Sylvain Chavanel 533
12 Jussi Veikkanen 127
13 Niki Terpstra 369
14 Michael van Staeyen 300
15 Damiano Cunego 659
16 Fabian Wegmann 475
17 Paul Martens 463
18 Przemyslaw Niemiec 426
19 Mark Cavendish 1241
20 Johnny Hoogerland 452
21 Yoann Offredo 304
22 Nelson Oliviera 150
23 Serge Pauwels 87
24 Francesco Chicci 287
25 Bruno Pires 28

SPENT 7495
LEFT 5
AVERAGE 299,8

 

[LukeSchmid]

Huge Effort Hugo, well done on getting this altogether. Should be fun

 

[Hugo Koblet]

Hi Hugo, can I still join?

1 Tom Boonen 777
2 Heinrich Haussler 251
3 Martijn Maaskant 118
4 Kevin Seeldraeyers 40
5 Laurens Ten Dam 97
6 Marco Bandiera 21
7 Brice Feillu 70
8 Amets Txurruka 75
9 Simon Gerrans 140
10 Phillip Deignan 5
11 Sylvain Chavanel 533
12 Jussi Veikkanen 127
13 Niki Terpstra 369
14 Michael van Staeyen 300
15 Damiano Cunego 659
16 Fabian Wegmann 475
17 Paul Martens 463
18 Przemyslaw Niemiec 426
19 Mark Cavendish 1241
20 Johnny Hoogerland 452
21 Yoann Offredo 304
22 Nelson Oliviera 150
23 Serge Pauwels 87
24 Francesco Chicci 287
25 Bruno Pires 28

SPENT 7495
LEFT 5
AVERAGE 299,8

Sure! Just send your team with the names according to CQ Ranking, like this:

BOONEN Tom
HAUSSLER Heinrich
etc.

That really eases the effort needed to be put into this by me

 

[Hugo Koblet]

Huge Effort Hugo, well done on getting this altogether. Should be fun

Thanks, but I really can't take all the credit for it myself. Without Ferminal, kurtinsc and bicing there was no way I would have been able to do this

 

[Barrus]

Huga, you need to add 182 points at mine, I think you missed Theo Bos in my list

 

[Hugo Koblet]

Huga, you need to add 182 points at mine, I think you missed Theo Bos in my list

Consider it done

It won't show in the uploaded spreadsheet but I've added him to your team on the one on my computer.

 

[tgsgirl]

Sure! Just send your team with the names according to CQ Ranking, like this:

BOONEN Tom
HAUSSLER Heinrich
etc.

That really eases the effort needed to be put into this by me

Done, by pm.

 

[Jiaying]

Alright.

I think we're ready for the 2011 season.

I have now uploaded the spreadsheet we will be using to keep track of the score board (unless something better comes up or something is very wrong with this).

Here's how it works:

The first sheet named "Rankings" shows a list of all the teams ranked in order. The leader is at the top and so on. The 2010 points shows the value of the team in the 2010 season, and the 2011 points shows the teams points this (next) season. Total point rank shows what place each team is in. Gain/loss shows how much profit the team has made (or lost!) in the 2011 season compared to the 2010 season.

The next sheets shows the individual teams. Each team has got their own sheet. This is because I thought it was a bit confusing and badly arranged if all teams were just thrown in one single sheet. Each sheet shows the same as the "Rankings" sheet: 2010 points, 2011 points and Gain/loss.

That's actually it. Don't mind the last 3 sheets named "Teams", "2010 Results" and "2011 Results".

Note: In the spreadsheet uploaded I have inserted the 2009 points in the 2011 points row. This was just to test if it works, but I thought I might as well keep it there - that way you can all see how it works

Now since I've been a bit busy the last days there will probably be a few minor mistakes in the various teams. I therefore request you all to go check your team to see if I've made any errors. Also please notice if your team value exceeds 7500.

If anyone notices anything in the spreadsheet that doesn't work please let me know. Also if I've made any minor spelling errors in your name, or the text size isn't the same in every sheet. Yes, I'm a bit perfectionist

Here's a list of team registered. If you aren't in the list but have already send your team, let me know.

Arnout
auscyclefan94
auto de fé
Barrus
bicing
Bumeington
Contre la montre
deValtos
Erik8-A
Ferminal
hrotha
Hugo Koblet
ingsve
jaiying
Jancouver
Jan the Man
jens_attacks
joy118118
Jpettersen
Jukebox
Kazistuta
kurtinsc
Kvinto
Libertine Seguros
LukeSchmid
mc_mountain
Mellow Velo
Moncoutie
Moondance
nvpacchi
pabryan
Parrulo
roundabout
Rocksteady
Spider1964
TeamSkyFans
The Cobra
The Hitch
Timmy-loves-Rabo
togo95
Vonn Brinkman
whittashau
who dat

And here's the spreadsheet:

https://docs.google.com/leaf?id=0B7...hlNjAtYmIxMmNmOTNlNTMz&hl=en&authkey=CMij_fYO

I find you made a mistake on my user name.It's Jiaying,not jaiying

 

[kurtinsc]

I find you made a mistake on my user name.It's Jiaying,not jaiying

I may get the credit for that mistake.

 

[kurtinsc]

It is interesting to see who seemed to focus on teams made up of riders who got better last season in the hopes that they'd continue improving (guys who are at the bottom of the rankings... thus showing an increase from 2009 to 2010) and those who focused more on guys who had off years last year in hopes of a rebound (guys at the front of the rankings who had a lot more points in 2009 then they did this past year).

 

[ingsve]

It is interesting to see who seemed to focus on teams made up of riders who got better last season in the hopes that they'd continue improving (guys who are at the bottom of the rankings... thus showing an increase from 2009 to 2010) and those who focused more on guys who had off years last year in hopes of a rebound (guys at the front of the rankings who had a lot more points in 2009 then they did this past year).

Ya, those are two very diffrent strategies and by looking where I end up in that spectrum I think it is quite clear which tactic I think is more likely to succeed.

 

[Hugo Koblet]

It is interesting to see who seemed to focus on teams made up of riders who got better last season in the hopes that they'd continue improving (guys who are at the bottom of the rankings... thus showing an increase from 2009 to 2010) and those who focused more on guys who had off years last year in hopes of a rebound (guys at the front of the rankings who had a lot more points in 2009 then they did this past year).

True. Although I'm not sure if that's a deliberate choice or not. I think points can be made for both approaches. Someone like Sagan would probably not be a good choice (no offence intended on anyone ) but there will be someone who is up and coming that scored more in 2010 than in 2009 and will score even higher in 2011. On the other hand, riders who's declining might not be the best choice while someone like Haussler probably is.

 

[auscyclefan94]

Can I ask why there is already is 2011 points and that the gain/loss is already filled for each of the riders? (probably a stupid question.)