Stage 2 Team Time Trial
(I had to re-jig the spreadsheet: suddenly realised why I had columns for the early stages before the totals columns, which I had previously "corrected", thinking it was a rationalisation.)
Stage points today were relatively unimportant, no rider got more than 20 of them (although Teunissen gets another 20 for the yellow jersey). Far more significant were the changes in projected position: Van Aert was 16th yesterday, with 94 points projected for that position, now he is 2nd, and if he stays there, will have 450 GC placing points. So he is the biggest improvement of the day.
However, none of us expect Van Aert to hang on to that podium spot, so he will at some time get negative points: that has already happened for some, most obviously Peter Sagan. He has dropped from 2nd to 48th, so his projected GC points are now 23, not 450.
I won't list every rider's point fluctuations every day: I'll choose a cut off depending on how dramatic the stage has been, and I will only show those who have been selected by at least one of our managers.
VAN AERT Wout 382 for Archieboy
KRUIJSWIJK Steven 380 for 5 teams
MARTIN Tony 320 for Otoxiep87
BERNAL GOMEZ Egan Arley 222 28 teams
THOMAS Geraint 192 for Ripley
MAS NICOLAU Enric 108 8
ZABEL Rick 70 7
KELDERMAN Wilco 65 3
KÄMNA Lennard 60 9
ZAKARIN Ilnur 53 1
...
PASQUALON Andrea -100 1
MATTHEWS Michael -157 1
TRENTIN Matteo -208 1
COLBRELLI Sonny -260 2
EWAN Caleb -360 16
SAGAN Peter -427 2
Daily Scores
Anyone who had a decent day yesterday courtesy of Ewan or Sagan saw most of those points evaporate today, even if many of us had that mitigated somewhat by the rise of a member of one of the higher placed teams (most commonly Bernal). That still left a lot of us in negative territory.
Very close for the honours on the day:
1 Laarsland 626 (Kruijswijk, Bernal and Zabel, but Debusschere and Garcia lost points) (80 Green points)
2 Search 624 (Kruijswijk, Bernal and Geschke) (50)
3 ArchieBoy 620 (Van Aert, Bernal and Van Garderen, but Boasson Hagen) (35)
4 Carlo_Algatrensig 434 (25)
5 Ripley 410 (15)
6 Tobydawq 386 (10)
7 Josedin 384 (5)
8 Vladimir 378 (3)
9 Mellow_Velo 362 (2)
10 Fauniera 340 (1)
11 Otoxiep87 290
12 Leadbelly 277
13 BluesInTheBottle 266
14 Del1962 261
14 JustSomeGuy 261
14 Salvarani 261
17 Triley36 240
18 Bminchow 218
19 Squire 207
20 Yellow_Knight 138
21 BlackBandit222 104
22 TotalPackage 90
23 Scrool07 20
24 Armchair_Cyclist -21
25 Comodoro -25
26 LosBrolin -39
26 Rote_Laterne -39
28 Shalgo -103
29 DJSprtsch -126
30 BicycleBoy -135
30 Googolplex -135
32 AmisVelo -138
33 RattaKuningas -240
34 Kazistuta -252
35 Tigerion -310
36 BikeRacer33 -316
37 LightBing -486
38 Koronin -506
Collective_Wisdom -99
Green points
You'll have noticed that the top ten each day have a bracketed number, these are their points towards our minor classification, the green points jersey. These get totalled every day. No-one who scored yesterday in this was in today's top ten (the Sagan/Colbrelli/Ewan correction factor), so when the scores for the two days are totalled, we have a lot of drawn placings.
1 Laarsland 80
2 Koronin, RattaKuningas 65
4 Search 50
5 ArchieBoy, LightBing 35
7 Carlo_Algatrensig, Googolplex 25
9 BicycleBoy, Ripley 15
11 DJSprtsch, Tobydawq 10
13 Josedin, Tigerion 5
15 Armchair_Cyclist, Vladimir 3
17 Mellow_Velo, TotalPackage 2
19 BikeRacer33, Fauniera 1
The rest have yet to score.
Standings
At least no-one's score is totally dependent on 20 per rider for being outside the top 50 any more. Don't expect these to be much more of a prediction of the final outcome than the current GC rankings are.
There again, Archie won the Giro game, and there he is again, on the back of a 20 place jump. Even that is outdone by Carlo and Search (24 and 28 places respectively)
1 ArchieBoy 873
2 Otoxiep87 850
3 Laarsland 842
4 Search 784
5 TotalPackage 660
6 Josedin 654
7 RattaKuningas 640
8 Carlo_Algatrensig 594
9 Scrool07 580
10 Ripley 574
11 Googolplex 565
12 BicycleBoy 555
13 Armchair_Cyclist 553
14 Tobydawq 550
15 Vladimir 538
16 Comodoro 535
17 Mellow_Velo 532
18 LosBrolin 521
18 Rote_Laterne 521
20 Fauniera 500
21 BlackBandit222 494
22 DJSprtsch 472
23 Shalgo 461
24 Triley36 447
25 Leadbelly 442
26 JustSomeGuy 432
27 BluesInTheBottle 431
28 AmisVelo 422
29 Del1962 421
29 Salvarani 421
31 Bminchow 382
32 Koronin 374
33 Squire 367
34 LightBing 360
35 Kazistuta 308
36 Yellow_Knight 307
37 Tigerion 280
38 BikeRacer33 253
Collective_Wisdom 461
I am out tomorrow evening: the update will be late.
PS I see there has been a late adjustment on the results, with Sunweb now being given 4th and Katusha 5th. It only makes a difference of 3 pts give or take for 9 riders, three of whom aren't selected and none of whom are very popular. I will hope that any differences it would have made to the Daily points would not be relevant to the final Green Jersey classification, rather than re-calculate everything. Similarly, I note that Julien Simon was 16th in the results table I used for the stage one calculations, but now he is shown as 29th in yesterday's results: that correction was incorporated in his drop of points today. These things will hopefully all be resolved by Paris.