The 2015 CQ Ranking Manager Thread

[LaFlorecita]

228 points in Trentino, most of them from Porte

 

[shalgo]

Meintjes into profit!

 

[HelgeBlendet]

Porte, Mentjes, Vilela, Kudus, Dombo, Seb Henao and Moser scoring points in Trentino which is nice.

 

[LaFlorecita]

15 points for Ewan and 10 for Ruffoni Ratto quite good too but 7th so no points

 

[LaFlorecita]

About 50 points in addition the points Henao and Porte scored this week, I think And oh ghod, where are my riders next week everyone is on holiday or what?

 

[rote_laterne]

Giro del Trentino-Melinda (2.HC)
DOMBROWSKI Joseph Lloyd 9
HENAO GOMEZ Sebastian 8
KANGERT Tanel 21
KÖNIG Leopold 108

La Flèche Wallonne (1.UWT)
BETANCUR GOMEZ Carlos Alberto 5
HENAO MONTOYA Sergio Luis 66
SEPULVEDA Eduardo 5
TEUNS Dylan 30
YATES Simon 5
ZURLO Federico 5

Presidential Cycling Tour of Turkey (2.HC)
CAVENDISH Mark 33
EWAN Caleb 15

Liège - Bastogne - Liège (1.UWT)
BETANCUR GOMEZ Carlos Alberto 5
HENAO MONTOYA Sergio Luis 90
KANGERT Tanel 5
TEUNS Dylan 5
YATES Simon 5

420 points. Great week for Teuns, good week for König and Sergio Henao. Betancur gets points for not DNF.

Presidential Cycling Tour of Turkey (2.HC)
BELTRAN SUAREZ Edward Alexander
CAVENDISH Mark
EWAN Caleb
LOPEZ MORENO Miguel Angel
SEPULVEDA Eduardo
ZURLO Federico

Le Tour de Bretagne Cycliste trophée harmonie Mutuelle (2.2)
http://www.tourdebretagne.fr/la-course/les-24-equipes/
BOUHANNI Rayane
KASPERKIEWICZ Przemyslaw

Tour de Romandie (2.UWT)
BETANCUR GOMEZ Carlos Alberto
KüNG Stefan
STANNARD Ian
YATES Simon

Rund um den Finanzplatz Eschborn-Frankfurt (1.HC)
KÄMNA Lennard

Tour de Yorkshire (2.1)
HENAO GOMEZ Sebastian
LUDVIGSSON Fredrik
TEUNS Dylan

Grand Prix de la Somme (1.1)
TURGIS Anthony

 

[skidmark]

Some good stuff from JRod this week, up to over 700 points after the Ardennes; two good grand tour performances and some results in whichever Tour prep race he rides will make him as good a pick as I had hoped. I regret not picking Alaphilippe, as he was definitely a long look, but I honestly didn't expect him to develop that kind of staying power yet. Impressive.

Sidenote - I'm relatively off-grid doing my annual summer work, so shalgo is going to take over this week and through May. I haven't yet set anyone up for June or July, but will work on this sometime soon.

 

[Netserk]

I'd like to do July if I can have the privilege of picking a month, but I will definitely need some guidance as for how to do it regarding excel. Once I'm up and running I doubt I would mind doing more than just 4/5 updates, but I guess there's some of those from last year who will do some later as well?

 

[GP Blanco]

Tour de Romandie
BETANCUR GOMEZ Carlos Alberto
ATAPUMA HURTADO Jhon Darwin
FLAKEMORE Campbell
SENNI Manuel
GRMAY Tsgabu Gebremaryam
DE CLERCQ Bart
YATES Simon
GESINK Robert
FROOME Christopher
STANNARD Ian

Quantity but also some quality

Rund um den Finanzplatz Eschborn-Frankfurt
LATOUR Pierre-Roger
HOOGERLAND Johnny

Not much

Yorkshire 3 Day
HENAO GOMEZ Sebastian

 

[shalgo]

As skidmark mentioned, I am filling in on the updates this month. I am sure that I will not do them in nearly as stylish and amusing a fashion, but I hope to convey the basic information, at least.

One thing I should mention is that I am encountering some problems with the Excel workbook. In particular, whenever I open it, I get the error message: "PivotTable Field Name Is Not Valid." Perhaps as a result of this error, I am not at all sure if the monthly update numbers below are actually correct. As far as I can tell, this error might be an Excel 2003/Excel 2010 compatibility issue, but I have not been able to fix it. If anyone else encounters the same issue and figures out a fix, please let me know.

Update #16: Alaphilippe and Manzin

Two of the riders made the biggest difference this week were Julian Alaphilippe, who exceeded the expectations of even those who picked him in the three Ardennes Classics this week, and Lorrenzo Manzin, who not only scored 80 points in winning La Roue Tourangelle but also added 25 points from previous weeks, thanks to CQ Ranking's adding a "r" to his name during the off-season--as pointed out by Popchu. The biggest winner this week was Londonpat, who had big weeks from Alaphilippe, Manzin, Porte, Seb Henao. Konig, and many others, on the way to a whopping 1334 points and a jump from 30th into a tie for 6th.

This week's top scorers

1 Londonpat 1334
2 merengues 1131
3 Cykeltyven 1055
4 shalgo 993
5 Jakob747 972

Londonpat, however, was not the top mover this week; that honor goes to Jakob747, who climbed a remarkable 28 places--showing that there is still everything to play for at this stage of the game.

This week's high movers

1 Jakob747 +28
2 Londonpat +24
3 Roubaix +21
4 Hugo Koblet +20
5 Ferminal +19
5 Nyssinator +19

Londonpat and merengues were first and second this week--the order was flipped in the list of the monthly top scorers.

Monthly top scorers

1 merengues 2625
2 Londonpat 2467
3 Kjellus 2459
4 Cykeltyven 2432
5 snccdcno 2413
6 MADRAZO 2374
7 derrudi 2319
8 Geraint Too Fast 2288
9 LightBing 2281
10 18-Valve. (pithy) 2256

The monthly high movers list was topped by the_sceptic, who climbed nearly half the list of teams, moving from 84th to 26th.

This month's high movers

1 the_sceptic +58
2 Hugo Koblet +51
3 MADRAZO +49
4 Londonpat +45
5 Hugo87 +43
6 Froome19 +43
7 martybart +42
8 tomazo +42
9 Ruvu75 +39
10 karaev +38

Kjellus remains on top in the green jersey competition. derrudi, merengues, and Londonpat are new entrants in the top ten.

Green jersey competition

1 Kjellus 108
2 afpm90 97
3 LaFlorecita 85
4 derrudi 77
5 merengues 76
6 vladimir 75
7 Londonpat 74
7 PeterB 74
9 Ruvu75 73
10 The Hitch 72

Geraint Too Fast and PeterB remain in first and second, but there are changes in the rest of the top ten--most notably the entries of Londonpat, Cykeltyven, and merengues.

Top 10 overall

1 Geraint Too Fast 6542
2 PeterB 6403
3 snccdcno 6229
4 Kjellus 6183
5 derrudi 6063
6 Londonpat 6031
6 greenedge 6031
8 skidmark 6023
9 Cykeltyven 6017
10 merengues 5915

Spreadsheet at Dropbox: https://www.dropbox.com/s/b8aycj2dgdfebr8/CQ%202015%20update%2016.xls?dl=0

 

[LaFlorecita]

Thx for the update shalgo!

oh dear, -19 The Giro can't start soon enough

 

[martyfulu]

Thanks for update I done quite well. Hence im happy about it. Looks like im pretty reliant on Rodriguez over the next while.

 

[Panda Claws]

Tour de Romandie
BAKELANTS Jan
ULISSI Diego
GESINK Robert
MORENO Javier
WESTRA Lieuwe
VAN DER SANDE Tosh
ATAPUMA Darwin

 

[LondonPat]

Thanks for the update, shalgo. Appreciate all the work you guys do to run such a great game.

Classics done now though so time for some big swings back to the GT teams....

 

[LaFlorecita]

Ruffoni in the autobus today, so Ratto sprinted to 3rd place for me instead

 

[LaFlorecita]

My team for the Giro

CONTADOR VELASCO Alberto
GATTO Oscar
JUUL JENSEN Christopher
STORTONI Simone
RUFFONI Nicola
ATAPUMA HURTADO Darwin
KÜNG Stefan
ELISSONDE Kenny
PAOLINI Luca
PORTE Richie

 

[Jancouver]

Oh boy, let the slide begin. -22 positions this week and first time out of the Top 50.

... and there no hope as there is no GC giant on my team.

 

[Netserk]

Sepulveda into profit (GC is pretty much locked down, but yeah, it's the day after tomorrow that it will happen)

If Froome wins Romandie, I reckon that I will move up quite some spots and do well in the weekly ranking.

 

[LaFlorecita]

Ratto down from 7th to 14th overall in Turkey but 14th is still worth 26 points which is quite good for a 55 point pick, but still, 62 is so much better... Ruffoni abandoned, so can't hope for another 3rd place for him on the final stage.
& in Romandie I need Küng to win the ITT and Atapuma to finish top 10 overall

 

[LaFlorecita]

Re:

& in Romandie I need Küng to win the ITT and Atapuma to finish top 10 overall

Ok. Never mind

 

[NairoQ]

Giro
Betancur (4%)
Kangert (13%)
Haussler (103%)
Acevedo (26%)
Rosa (76%)
Elissonde (9%)
Atapuma (123%)
Henao (138%)
Paolini (264%)
Some riders doing really well, some riders disappointing really hard.
Can't expect too much, although some of them have proven in the past that the Giro suits them. We'll see.

 

[skidmark]

Re:

I'd like to do July if I can have the privilege of picking a month, but I will definitely need some guidance as for how to do it regarding excel. Once I'm up and running I doubt I would mind doing more than just 4/5 updates, but I guess there's some of those from last year who will do some later as well?

Hey netserk, I appreciate your willingness to do updates. And thanks shalgo for filling in. I believe shalgo has all the materials on updating the spreadsheet and could possibly forward them to you... another thing I was thinking was that if no one else steps up to do updates (as far as I have seen - unless I've overlooked some other comments - you two were the only ones to respond definitively to my request), perhaps shalgo could do them until the Dauphine starts (which would be about 6 weeks), and then you could do them until the start of August when I'm back in action (which would be about 6 weeks as well). Let me know if that would be possible, or anyone else who wants to do it speak up!

 

[LaFlorecita]

I would not mind to do the updates in June but I'm not really good at writing a story around the update

 

[Panda Claws]

Re:

Giro
Betancur (4%)
Kangert (13%)
Haussler (103%)
Acevedo (26%)
Rosa (76%)
Elissonde (9%)
Atapuma (123%)
Henao (138%)
Paolini (264%)
Some riders doing really well, some riders disappointing really hard.
Can't expect too much, although some of them have proven in the past that the Giro suits them. We'll see.

Cool idea to post the %'s with your start list.

ZABEL Rick
PORTE Richie
ULISSI Diego
ELISSONDE Kenny
BATTAGLIN Enrico
VISCONTI Giovanni
CHAVES RUBIO Johan Esteban
GRETSCH Patrik
ATAPUMA HURTADO Jhon Darwin

I am actually quite happy with this team, might be the start of a small comeback.

 

[Netserk]

Re: Re:

I'd like to do July if I can have the privilege of picking a month, but I will definitely need some guidance as for how to do it regarding excel. Once I'm up and running I doubt I would mind doing more than just 4/5 updates, but I guess there's some of those from last year who will do some later as well?

Hey netserk, I appreciate your willingness to do updates. And thanks shalgo for filling in. I believe shalgo has all the materials on updating the spreadsheet and could possibly forward them to you... another thing I was thinking was that if no one else steps up to do updates (as far as I have seen - unless I've overlooked some other comments - you two were the only ones to respond definitively to my request), perhaps shalgo could do them until the Dauphine starts (which would be about 6 weeks), and then you could do them until the start of August when I'm back in action (which would be about 6 weeks as well). Let me know if that would be possible, or anyone else who wants to do it speak up!

As long as someone will teach me how to do it before it's my turn to do an update, no problem! Will I have to install dropbox? iirc Hugo uploaded it to mediafire, right?