[Armchair Cyclist]

We are in that strange fortnight that have National Championships and almost nothing else, and a few teams have named their teams, so it must be time to get my spreadsheet dusted off.


Your Team
8 riders, who must all be on the final start list for the Tour, with a maximum total cost of 4000 CQ points. 

Rider cost
Their CQ points for the year to 30th June, as compiled in the download that was made available on the CQ site on Monday 1st.   Their prices, and team selections updated as often as I can, are in a spreadsheet available on Dropbox.

Scoring
Points are won by the top ten on the stage each day (80, 50, 35 down to 1 point for 10th), holding the yellow jersey (20 points a day, but not on the last day) and for the GC (600 for the winner, then 450, 380, 320, 290, down to 160 for 10th, 72 for 20th, 21 for 50th, and 20 for every finisher) and also for the Points and KoM classifications (same scale as the stage points).  I will apply the standings every day, so your projected points can change quite rapidly. 

There is a subsidiary ranking, with points given to teams (on the same 80, 50, 35... scale) each day according to their points gained on the stage.

(For the team time trial, points are divided by 4 and rounded down, and only given to riders who finish in their team's main group, so 20, 12, 8, down to 1 for 7th, and only the top 7 teams)

Entering the game
By PM to me at Velorooms or Cycling News (you can't send a PM at Cycling News if you are a new member, and I'm not sure that I would trust CN on the day of its switchover to a new format on Wednesday) anytime up to the start of the race which is, I believe, noon in Brussels on Saturday 6th July.

Please give riders' names in CQ format (surname, then forename, particular care needed with Spanish, South American, Portuguese and Danish riders); if you use the dropbox spreadsheet with prices, the names are already in the right format.

Please do not add info like team and points in submitting your team: I'll only have to delete those bits, so it is a waste of time for both of us.


If there are any rules that I have forgotten to include here, then precedent applies.

[just some guy]

Joel has this

[search]

Start List with cq values (EF still to be confirmed)

	TEAM INEOS			AG2R LA MONDIALE
	BERNAL GOMEZ Egan Arley	1155		BARDET Romain	1222
	CASTROVIEJO NICOLAS Jonathan	332		CHEREL Mikael	121
	KWIATKOWSKI Michal	1354		COSNEFROY Benoit	428
	MOSCON Gianni	777		FRANK Mathias	371
	POELS Wout	922		GALLOPIN Tony	419
	ROWE Luke	228		GOUGEARD Alexis	262
	THOMAS Geraint	1348		NAESEN Oliver	1237
	VAN BAARLE Dylan	568		VUILLERMOZ Alexis	357
		6684			4417
	ASTANA PRO TEAM			BAHRAIN - MERIDA
	BILBAO LOPEZ DE ARMENTIA Pello	632		CARUSO Damiano	447
	CORT NIELSEN Magnus	334		COLBRELLI Sonny	815
	FRAILE MATARRANZ Omar	242		DENNIS Rohan	1006
	FUGLSANG Jakob	1870		GARCIA CORTINA Ivan	288
	HOULE Hugo	263		MOHORIC Matej	898
	IZAGIRRE INSAUSTI Gorka	398		NIBALI Vincenzo	1114
	LUTSENKO Alexey	818		TEUNS Dylan	1051
	SANCHEZ GIL Luis Leon	880		TRATNIK Jan	264
		5437			5883
	BORA-HANSGROHE			CCC TEAM
	BUCHMANN Emanuel	984		BEVIN Patrick	521
	BURGHARDT Marcus	162		DE MARCHI Alessandro	562
	KONRAD Patrick	831		GESCHKE Simon	180
	MÜHLBERGER Gregor	300		PAUWELS Serge	73
	OSS Daniel	127		SCHÄR Michael	190
	PÖSTLBERGER Lukas	159		VAN AVERMAET Greg	1627
	SAGAN Peter	1710		ROSSKOPF Joey	181
	SCHACHMANN Maximilian	1446		WISNIOWSKI Lukasz	91
		5719			3425
	COFIDIS SOLUTIONS CRÉDITS			DECEUNINCK - QUICK-STEP
	HERRADA LOPEZ Jesus	921		ALAPHILIPPE Julian	2618
	LAPORTE Christophe	620		ASGREEN Kasper	666
	EDET Nicolas	319		DEVENYNS Dries	245
	SIMON Julien	591		LAMPAERT Yves	1064
	PERICHON Pierre-Luc	261		MAS NICOLAU Enric	812
	BERHANE Natnael Teweldemedhin	111		MØRKØV CHRISTENSEN Michael	336
	PEREZ Anthony	122		RICHEZE ARAQUISTAIN Maximiliano Ariel	138
	ROSSETTO Stéphane	122		VIVIANI Elia	1513
		3067			7392
	EF EDUCATION FIRST			GROUPAMA - FDJ
	URAN URAN Rigoberto	832		PINOT Thibaut	1879
	BETTIOL Alberto	709		BONNET William	15
	CLARKE Simon	586		GAUDU David	683
	LANGEVELD Sebastian	345		KÜNG Stefan	465
	VAN GARDEREN Tejay	567		LADAGNOUS Matthieu	80
	WOODS Michael	1067		MOLARD Rudy	509
	KANGERT Tanel	306		REICHENBACH Sébastien	305
	SCULLY Tom	125		ROUX Anthony	350
		4537			4286
	LOTTO SOUDAL			MITCHELTON - SCOTT
	BENOOT Tiesj	677		DURBRIDGE Luke	209
	DE BUYST Jasper	299		HAIG Jack	525
	DE GENDT Thomas	431		HEPBURN Michael	125
	EWAN Caleb	746		IMPEY Daryl	751
	KEUKELEIRE Jens	466		JUUL JENSEN Christopher	156
	KLUGE Roger	92		TRENTIN Matteo	958
	MONFORT Maxime	95		YATES Adam	1252
	WELLENS Tim	1419		YATES Simon	1565
		4225			5541
	MOVISTAR TEAM			TEAM ARKÉA - SAMSIC
	QUINTANA ROJAS Nairo Alexander	1030		BARGUIL Warren	555
	AMADOR BIKKAZAKOVA Andrey	116		BOUET Maxime	88
	ERVITI OLLO Imanol	90		DELAPLACE Anthony	198
	LANDA MEANA Mikel	871		GESBERT Elie	270
	OLIVEIRA Nelson Filipe Santos Simoes	295		GREIPEL André	496
	SOLER GIMENEZ Marc	214		LEDANOIS Kévin	81
	VALVERDE BELMONTE Alejandro	2292		MOINARD Amaël	48
	VERONA QUINTANILLA Carlos	241		VACHON Florian	43
		5149			1779
	TEAM DIMENSION DATA			TEAM JUMBO - VISMA
	BOASSON HAGEN Edvald	530		BENNETT George	623
	NIZZOLO Giacomo	526		DE PLUS Laurens	290
	KING Benjamin	300		GROENEWEGEN Dylan	1138
	KREUZIGER Roman	250		JANSEN Amund Grøndahl	505
	CUMMINGS Stephen	75		KRUIJSWIJK Steven	1075
	VALGREN ANDERSEN Michael	549		MARTIN Tony	196
	JANSE VAN RENSBURG Reinardt	300		TEUNISSEN Mike	669
	BAK Lars Ytting	70		VAN AERT Wout	1065
		2600			5561
	TEAM KATUSHA ALPECIN			TEAM SUNWEB
	DEBUSSCHERE Jens	333		ARNDT Nikias	142
	DOWSETT Alex	189		BOL Cees	532
	GONÇALVES Jose Isidro Maciel	142		HAGA Chad	207
	HALLER Marco	225		KELDERMAN Wilco	510
	POLITT Nils	807		ANDERSEN Søren Kragh	632
	WÜRTZ SCHMIDT Mads	114		KÄMNA Lennard	99
	ZABEL Rick	104		MATTHEWS Michael	1323
	ZAKARIN Ilnur	709		ROCHE Nicolas	270
		2623			3717
	TOTAL DIRECT ENERGIE			TREK-SEGAFREDO
	CALMEJANE Lilian	411		PORTE Richie	531
	TERPSTRA Niki	554		BERNARD Julien	149
	TURGIS Anthony	572		CICCONE Giulio	568
	SICARD Romain	76		DE KORT Koen	133
	TAARAMÄE Rein	471		FELLINE Fabio	190
	OURSELIN Paul	86		MOLLEMA Bauke	1185
	GRELLIER Fabien	63		SKUJINS Toms	525
	BONIFAZIO Niccolo	380		STUYVEN Jasper	852
		2613			4133
	UAE - TEAMEMIRATES			WANTY – GROUPE GOBERT
	ARU Fabio	295		BACKAERT Frederik	260
	BYSTRØM Sven Erik	147		DE GENDT Aimé	421
	COSTA Rui Alberto Faria	761		EIKING Odd Christian	274
	HENAO MONTOYA Sergio Luis	237		MARTIN Guillaume	767
	KRISTOFF Alexander	1579		MEURISSE Xandro	391
	LAENGEN Vegard Stake	70		OFFREDO Yoann	51
	MARTIN Daniel	960		PASQUALON Andrea	406
	PHILIPSEN Jasper	675		VAN MELSEN Kevin	34
		4724			2604

The download isn't available yet, so I copied the prices from the "current" ranking on the website - they should be correct, but better double check

[Mellow Velo]

Much appreciated S.
A big help for...................well me really.

[just some guy]

Yep huge help.

Still come bottom 1/3 mind

[Armchair Cyclist]

I've made a few changes: hope it is all accurate.

[Armchair Cyclist]

All the teams are now in, and on both the Dropbox spreadsheet and Search's list:  what's keeping you?

[Armchair Cyclist]

Entries so far:
Armchair_Cyclist
BluesInTheBottle
Bminchow
Comodoro
Googolplex
Kazistuta
Koronin
Salvarani
Scrool07
Search
Triley36
Vladimir


Among those teams, 42 of the 176 riders in the Tour are named, one of them 9 times and 3 others appear in at least half the teams.

A bit less than 2 1/2 days to go

[Blackbandit222]

No, Velogames TDF?!?  Anyone considering the TDF/Velon offering?
https://fantasy.letour.fr  I forgot to read the directions which I think were in the Release form.
But you can make a League for Velorooms. 

[Armchair Cyclist]

No, Velogames TDF?!?  Anyone considering the TDF/Velon offering?
https://fantasy.letour.fr  I forgot to read the directions which I think were in the Release form.
But you can make a League for Velorooms. 

The official TdF site legally threatened Velogames out of running its game this time last year too: I recall there were efforts to boycott their game in retaliation.


They haven't tracked me down yet, though:

Entries so far  (about 18 hours to go)
AmisVelo
ArchieBoy
Armchair_Cyclist
BicycleBoy
BluesInTheBottle
Bminchow
Carlo_Algatrensig
Comodoro
Del1962
DJSprtsch
Googolplex
Kazistuta
Koronin
Leadbelly
LosBrolin
Mellow_Velo
Otoxiep87
Ripley
Salvarani
Scrool07
Search
Shalgo
TotalPackage
Triley36
Vladimir
Yellow_Knight


The popularity rankings very from 36% to 87% of the max possible.


29 of the 59 selected riders are unique picks; one team (but not the bottom of the popularity table) has 4 of them, while 6 have none.

8 different riders costing 1000 pts + have been chosen.

[just some guy]

Team in see how many time AC gives me the over budget reply

[rote_laterne]

Thanks to ACs spreadsheet and search start list I had my team in less than 1 hour.

[just some guy]

4 min for me

[Armchair Cyclist]

Team in see how many time AC gives me the over budget reply

You even had 24 points unspent: keep trying more permutations until 12:00 (CET) to use them up if you want to.

[Armchair Cyclist]

The teams

38 of them in the end: two of the later entries had overbudget/non-competing rider issues, so I had to do some swapping-in for those managers.  And one team had its cheapestt rdier removed to make the standard eight.

As usual, teams listed with their riders sorted by price, and unique picks marked with an asterisk.

Amis Velo
   BERNAL GOMEZ Egan Arley   
   QUINTANA ROJAS Nairo Alexander   
   EWAN Caleb   
   PORTE Richie   
   ARU Fabio   
   CHEREL Mikael   *
   PAUWELS Serge   
   MOINARD Amaël   


Archieboy
   BERNAL GOMEZ Egan Arley   
   VAN AERT Wout   *
   VAN GARDEREN Tejay   
   BOASSON HAGEN Edvald   *
   HENAO MONTOYA Sergio Luis   
   SOLER GIMENEZ Marc   
   PEREZ Anthony   *
   WISNIOWSKI Lukasz   (9th rider removed)


Armchair Cyclist
   BERNAL GOMEZ Egan Arley   
   URAN URAN Rigoberto   
   EWAN Caleb   
   PORTE Richie   
   REICHENBACH Sébastien   
   KREUZIGER Roman   
   ZABEL Rick   
   SICARD Romain   *


Bicycle Boy
   SAGAN Peter   
   BERNAL GOMEZ Egan Arley   
   URAN URAN Rigoberto   
   GONÇALVES Jose Isidro Maciel   
   MOINARD Amaël   
   VACHON Florian   
   VAN MELSEN Kevin   
   BONNET William   


BikeRacer33
   YATES Adam   
   EWAN Caleb   
   VAN GARDEREN Tejay   
   CALMEJANE Lilian   
   REICHENBACH Sébastien   
   ARU Fabio   
   KREUZIGER Roman   
   BERNARD Julien   


BlackBandit222
   Bernal Gomez Egan Arley   
   Trentin Matteo   *
   Van Garderen Tejay   
   Porte Richie   
   Aru Fabio   
   De Plus Laurens   
   Dowsett Alex   
   Bonnet William   


Blues in the Bottle
   YATES Adam   
   BERNAL GOMEZ Egan Arley   
   PORTE Richie   
   ARU Fabio   
   DE PLUS Laurens   
   SOLER GIMENEZ Marc   
   DOWSETT Alex   
   PAUWELS Serge   

Bminchow
   BERNAL GOMEZ Egan Arley   
   QUINTANA ROJAS Nairo Alexander   
   BILBAO LOPEZ DE ARMENTIA Pello   *
   PORTE Richie   
   ARU Fabio   
   KREUZIGER Roman   
   PAUWELS Serge   
   BONNET William   


Carlo Algatrensig
   BERNAL GOMEZ Egan Arley   
   URAN URAN Rigoberto   
   MAS NICOLAU Enric   
   KELDERMAN Wilco   
   ARU Fabio   
   FELLINE Fabio   
   ROSSETTO Stéphane   *
   LEDANOIS Kévin   *


Comodoro
   BERNAL GOMEZ Egan Arley   
   EWAN Caleb   
   ZAKARIN Ilnur   *
   PORTE Richie   
   ARU Fabio   
   HENAO MONTOYA Sergio Luis   
   SOLER GIMENEZ Marc   
   KÄMNA Lennard   


Del1962
   BERNAL GOMEZ Egan Arley   
   QUINTANA ROJAS Nairo Alexander   
   URAN URAN Rigoberto   
   PORTE Richie   
   ARU Fabio   
   PAUWELS Serge   
   GRELLIER Fabien   *
   BONNET William   


DJSprtsch
   BERNAL GOMEZ Egan Arley   
   URAN URAN Rigoberto   
   EWAN Caleb   
   DEBUSSCHERE Jens   
   ARU Fabio   
   DE PLUS Laurens   
   ROCHE Nicolas   
   PAUWELS Serge   


Fauniera
   BERNAL GOMEZ Egan Arley   
   LANDA MEANA Mikel   
   URAN URAN Rigoberto   
   GAUDU David   *
   ARU Fabio   
   KÄMNA Lennard   
   MOINARD Amaël   
   BONNET William   


Googolplex
   SAGAN Peter   
   BERNAL GOMEZ Egan Arley   
   BARGUIL Warren   
   HENAO MONTOYA Sergio Luis   
   FELLINE Fabio   
   ZABEL Rick   
   VAN MELSEN Kevin   
   BONNET William   


Josedin
   BERNAL GOMEZ Egan Arley   
   BUCHMANN Emanuel   *
   MAS NICOLAU Enric   
   PASQUALON Andrea   *
   FRAILE MATARRANZ Omar   
   ROSSKOPF Joey   *
   ZABEL Rick   
   KÄMNA Lennard   


Just Some Guy
   BERNAL GOMEZ Egan Arley   
   QUINTANA ROJAS Nairo Alexander   
   URAN URAN Rigoberto   
   PORTE Richie   
   ROCHE Nicolas   
   PAUWELS Serge   
   LAENGEN Vegard Stake   *
   BONNET William   


Kazistuta
   QUINTANA ROJAS Nairo Alexander   
   MAS NICOLAU Enric   
   EWAN Caleb   
   PORTE Richie   
   ARU Fabio   
   GESBERT Elie   
   FELLINE Fabio   
   BERHANE Natnael Teweldemedhin   *


Koronin
   COLBRELLI Sonny   
   MAS NICOLAU Enric   
   EWAN Caleb   
   DE MARCHI Alessandro   *
   BARGUIL Warren   
   DE GENDT Thomas   *
   VACHON Florian   
   VAN MELSEN Kevin   


Laarsland
   BERNAL GOMEZ Egan Arley   
   KRUIJSWIJK Steven   
   BARGUIL Warren   
   DEBUSSCHERE Jens   
   ARU Fabio   
   GARCIA CORTINA Ivan   *
   FELLINE Fabio   
   ZABEL Rick   


Leadbelly
   YATES Adam   
   BERNAL GOMEZ Egan Arley   
   BARGUIL Warren   
   PORTE Richie   
   HENAO MONTOYA Sergio Luis   
   KÄMNA Lennard   
   CUMMINGS Stephen   
   PAUWELS Serge   


LightBing
   MATTHEWS Michael   *
   QUINTANA ROJAS Nairo Alexander   
   EWAN Caleb   
   ROCHE Nicolas   
   FRAILE MATARRANZ Omar   
   FELLINE Fabio   
   GONÇALVES Jose Isidro Maciel   
   BONNET William   (because chosen rider put team over budget)


Los Brolin
   BERNAL GOMEZ Egan Arley   
   URAN URAN Rigoberto   
   EWAN Caleb   
   PORTE Richie   
   ARU Fabio   
   HENAO MONTOYA Sergio Luis   
   KÄMNA Lennard   
   MONFORT Maxime   


Mellow Velo
   BERNAL GOMEZ Egan Arley   
   LANDA MEANA Mikel   
   URAN URAN Rigoberto   
   PORTE Richie   
   ARU Fabio   
   GONÇALVES Jose Isidro Maciel   
   ZABEL Rick   
   MOINARD Amaël   


Otoxiep87
   BERNAL GOMEZ Egan Arley   
   MAS NICOLAU Enric   
   EWAN Caleb   
   PORTE Richie   
   ARU Fabio   
   MARTIN Tony   *
   FELLINE Fabio   
   PAUWELS Serge   


RattaKuningas
   KRUIJSWIJK Steven   
   COLBRELLI Sonny   
   EWAN Caleb   
   PORTE Richie   
   ARU Fabio   
   SOLER GIMENEZ Marc   
   HAGA Chad   *
   CUMMINGS Stephen   


Ripley
   THOMAS Geraint   *
   BERNAL GOMEZ Egan Arley   
   BARGUIL Warren   
   PORTE Richie   
   KREUZIGER Roman   
   ERVITI OLLO Imanol   *
   VACHON Florian   
   BONNET William   


Rote Laterne
   BERNAL GOMEZ Egan Arley   
   URAN URAN Rigoberto   
   EWAN Caleb   
   BARGUIL Warren   
   ARU Fabio   
   FRAILE MATARRANZ Omar   
   KÄMNA Lennard   
   PAUWELS Serge   


Salvarani
   BERNAL GOMEZ Egan Arley   
   LANDA MEANA Mikel   
   URAN URAN Rigoberto   
   BARGUIL Warren   
   GESBERT Elie   
   GOUGEARD Alexis   *
   VAN MELSEN Kevin   
   BONNET William   


Scrool07
   KRUIJSWIJK Steven   
   QUINTANA ROJAS Nairo Alexander   
   EWAN Caleb   
   PORTE Richie   
   ARU Fabio   
   SOLER GIMENEZ Marc   
   PAUWELS Serge   
   BONNET William   


Search
   BERNAL GOMEZ Egan Arley   
   KRUIJSWIJK Steven   
   LANDA MEANA Mikel   
   BARGUIL Warren   
   GESCHKE Simon   *
   CUMMINGS Stephen   
   PAUWELS Serge   
   BONNET William   


Shalgo
   BERNAL GOMEZ Egan Arley   
   URAN URAN Rigoberto   
   EWAN Caleb   
   PORTE Richie   
   KREUZIGER Roman   
   HENAO MONTOYA Sergio Luis   
   BERNARD Julien   
   WISNIOWSKI Lukasz   


Squire
   QUINTANA ROJAS Nairo Alexander   
   URAN URAN Rigoberto   
   MAS NICOLAU Enric   
   PORTE Richie   
   ARU Fabio   
   HENAO MONTOYA Sergio Luis   
   KÄMNA Lennard   
   MONFORT Maxime   


Tigerion
   YATES Adam   
   LANDA MEANA Mikel   
   EWAN Caleb   
   PORTE Richie   
   BONIFAZIO Niccolo   *
   ZABEL Rick   
   VAN MELSEN Kevin   (because selected rider is not in the race)
   BONNET William   


Tobydawq
   BERNAL GOMEZ Egan Arley   
   MAS NICOLAU Enric   
   BARGUIL Warren   
   PORTE Richie   
   ARU Fabio   
   GESBERT Elie   
   KREUZIGER Roman   
   KÄMNA Lennard   


Total Package
   GROENEWEGEN Dylan   *
   KRUIJSWIJK Steven   
   EWAN Caleb   
   ARU Fabio   
   HENAO MONTOYA Sergio Luis   
   SOLER GIMENEZ Marc   
   FELLINE Fabio   
   ZABEL Rick   


Triley36
   BERNAL GOMEZ Egan Arley   
   LANDA MEANA Mikel   
   PORTE Richie   
   KELDERMAN Wilco   
   CORT NIELSEN Magnus   *
   ARU Fabio   
   KREUZIGER Roman   
   OFFREDO Yoann   *


Vladimir
   BERNAL GOMEZ Egan Arley   
   QUINTANA ROJAS Nairo Alexander   
   BARGUIL Warren   
   KELDERMAN Wilco   
   CALMEJANE Lilian   
   GONÇALVES Jose Isidro Maciel   
   KÄMNA Lennard   
   PAUWELS Serge   


Yellow Knight
   LANDA MEANA Mikel   
   URAN URAN Rigoberto   
   KONRAD Patrick   *
   MAS NICOLAU Enric   
   PORTE Richie   
   PAUWELS Serge   
   VAN MELSEN Kevin   
   BONNET William   

[just some guy]

Bonnet

[Armchair Cyclist]

Rider picks

71 riders picked, 105 neglected (including Teunissen)

32 of the 71 are unique picks (I hope the previous post has 32 asterisks on it)

The more popular selections are:

28 (out of 38): BERNAL GOMEZ Egan Arley
22:ARU Fabio, PORTE Richie
16: EWAN Caleb
14: BONNET William, URAN URAN Rigoberto
13: PAUWELS Serge
10: BARGUIL Warren
Although it comes in a bit over budget (4202 pts), I will count these as the Collective Wisdom squad.

9: KÄMNA Lennard, QUINTANA ROJAS Nairo Alexander
8: HENAO MONTOYA Sergio Luis, MAS NICOLAU Enric
7:  FELLINE Fabio, KREUZIGER Roman, LANDA MEANA Mikel, ZABEL Rick
6:  SOLER GIMENEZ Marc, VAN MELSEN Kevin
5:  KRUIJSWIJK Steven
4:  GONÇALVES Jose Isidro Maciel, MOINARD Amaël, YATES Adam
3:  CUMMINGS Stephen, DE PLUS Laurens, FRAILE MATARRANZ Omar, GESBERT Elie, KELDERMAN Wilco, ROCHE Nicolas, VACHON Florian, VAN GARDEREN Tejay
2:  BERNARD Julien, CALMEJANE Lilian, COLBRELLI Sonny, DEBUSSCHERE Jens, DOWSETT Alex, MONFORT Maxime, REICHENBACH Sébastien, SAGAN Peter, WISNIOWSKI Lukasz


Popularity rankings
1   Del1962   123
2   LosBrolin   121
3   Otoxiep87   117
4   Bminchow   116
5   AmisVelo   115
5   Rote_Laterne   115
7   Comodoro   112
8   Tobydawq   109
9   Mellow_Velo   108
10   Scrool07   107
11   JustSomeGuy   104
12   DJSprtsch   101
13   BluesInTheBottle   100
14   Fauniera   99
14   Shalgo   99
16   Armchair_Cyclist   97
16   Leadbelly   97
18   BlackBandit222   95
19   Squire   94
20   Triley36   91
21   Kazistuta   88
22   Ripley   86
23   Yellow_Knight   85
24   Carlo_Algatrensig   84
25   Salvarani   83
26   Googolplex   82
26   Laarsland   82
28   Search   81
29   Vladimir   78
30   RattaKuningas   77
30   Tigerion   77
32   BicycleBoy   75
33   TotalPackage   72
34   BikeRacer33   58
34   Josedin   58
36   LightBing   57
37   ArchieBoy   50
38   Koronin   47
   Collective_Wisdom   139


Unique picks

 3: ArchieBoy, Josedin
2:  Carlo_Algatrensig, Koronin, Ripley, Triley36


Major Picks
Those costing 700 points or more that were picked

SAGAN Peter   1710pts   2 teams
THOMAS Geraint   1348   1
MATTHEWS Michael   1323   1
YATES Adam   1252   4
BERNAL GOMEZ Egan Arley   1155   28
GROENEWEGEN Dylan   1138   1
KRUIJSWIJK Steven   1075   5
VAN AERT Wout   1065   1
QUINTANA ROJAS Nairo Alexander   1030   9
BUCHMANN Emanuel   984   1
TRENTIN Matteo   958   1
LANDA MEANA Mikel   871   7
URAN URAN Rigoberto   832   14
KONRAD Patrick   831   1
COLBRELLI Sonny   815   2
MAS NICOLAU Enric   812   8
EWAN Caleb   746   16
ZAKARIN Ilnur   709   1

and how we put them together:
Sagan   Bernal   Uran      Bicycle Boy
Sagan   Bernal         Googolplex
            
Thomas   Bernal         Ripley
            
Matthews   Quintana   Ewan      LightBing
            
Yates   Bernal         Blues in the Bottle, Leadbelly
Yates   Landa   Ewan      Tigerion
Yates   Ewan         BikeRacer33
            
Bernal   Kruijswijk   Landa      Search
Bernal   Kruijswijk         Laarsland
Bernal   Van Aert         Archieboy
Bernal   Quintana   Uran      Del1962, Just Some Guy
Bernal   Quintana   Ewan      Amis Velo
Bernal   Quintana         Bminchow, Vladimir
Bernal   Buchmann   Mas      Josedin
Bernal   Trentin         BlackBandit222
Bernal   Landa   Uran      Fauniera, Mellow Velo, Salvarani
Bernal   Landa         Triley36
Bernal   Uran   Mas      Carlo Algatrensig
Bernal   Uran   Ewan      Armchair Cyclist, DJSprtsch, Los Brolin, Rote Laterne, Shalgo
Bernal   Mas   Ewan      Otoxiep87
Bernal   Mas         Tobydawq
Bernal   Ewan   Zakarin      Comodoro
            
Groenewegen   Kruijswijk   Ewan      Total Package
            
Kruijswijk   Quintana   Ewan      Scrool07            
Kruijswijk   Colbrelli   Ewan      RattaKuningas
            
Quintana   Uran   Mas      Squire
Quintana   Mas   Ewan      Kazistuta
            
Landa   Uran   Konrad   Mas   Yellow Knight
            
Colbrelli   Mas   Ewan      Koronin

[Armchair Cyclist]

Stage 1 From one spelling of Brussels to another.

So, to remind you, these scores are a mixture of stage points, and projected points for the GC and the sprints and mountains classifications.   I'm only showing those who have been selected.  Sagan's score is made up of 50 stage points for coming second (which cannot be lost, even if he doesn't reach Paris), 450 points for being second in the GC, and 50 for his current second place in the sprints category.  Had anyone picked Teunissen, you would also see 20 points for being race leader.  Every rider has at least 20 points, as that is the reward for finishing.  Given that there were no DNFs today, every team must have at least 160 points: those who have noone in the GC top 50 have that score.

SAGAN Peter   550   2
EWAN Caleb   420   16
COLBRELLI Sonny   340   2
MATTHEWS Michael   295   1
TRENTIN Matteo   250   1
PASQUALON Andrea   120   1
VAN AERT Wout   88   1
OFFREDO Yoann   63   1
DEBUSSCHERE Jens   47   2
BOASSON HAGEN Edvald   45   1

Standings

1   RattaKuningas   880(Ewan and Colbrelli) (65 green points)
1   Koronin   880 (Ewan and Colbrelli)  (65 Green pts)
3   LightBing   846 (Ewan, Matthews and Roche)  (35)
4   Googolplex   700 (Sagan and Zabel)  (25)
5   BicycleBoy   690 (Sagan)  (15)
6   DJSprtsch   598 (10)
7   Tigerion   590 (5)
8   Armchair_Cyclist   574 (3)
9   TotalPackage   570  (2)
10   BikeRacer33   569  (1)
11   Shalgo   564
12   LosBrolin   560
12   Otoxiep87   560
12   AmisVelo   560
12   Rote_Laterne   560
12   Comodoro   560
12   Scrool07   560
12   Kazistuta   560
19   BlackBandit222   390
20   Josedin   270
21   ArchieBoy   253
22   Laarsland   216
23   Triley36   207
24   JustSomeGuy   171
25   Mellow_Velo   170
26   Yellow_Knight   169
27   BluesInTheBottle   165
27   Leadbelly   165
29   Bminchow   164
29   Tobydawq   164
29   Ripley   164
32   Del1962   160
32   Fauniera   160
32   Squire   160
32   Carlo_Algatrensig   160
32   Salvarani   160
32   Search   160
32   Vladimir   160
   Collective_Wisdom   560

The team time trial tomorrow will shake this about a bit, and will force me to explain the negative points that will occur and the green points.

I won't put up the link to Dropbox every day, but the spreadsheet will be in the same place regardless.

[Armchair Cyclist]

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.

[Armchair Cyclist]

However, given how close the top of the daily table was, it turns out that the three extra points given to Rick Zabel were quite significant.  Once those are taken away, Search pips Laarsland to the day's win (by just 1 point), and a 30 point switcharound in the Green points is significant.  Vladimir has 2 of the Sunweb riders (Kamna and Kelderman), and so catches up with Josedin, so they get 4 green points each.

New Green standings:
1 Search 80
2 Koronin, RattaKuningas 65
4 Laarsland 50
5 ArchieBoy, LightBing 35
7 Carlo_Algatrensig, Googolplex 25
9 BicycleBoy, Ripley 15
11 DJSprtsch, Tobydawq 10
13 Tigerion 5
14  Josedin, Vladimir  4
16 Armchair_Cyclist 3
17 Mellow_Velo, TotalPackage 2
19 BikeRacer33, Fauniera 1

[Armchair Cyclist]

Stage 3 Champagne version of the Ardennes

Those who can't cope with a series of short sharp hills fall away, and those who can move up the GC to replace them.  We need to wait until stage 6 removes those who can't deal with longer climbs before the table takes on a really meaningful shape.

MATTHEWS Michael   268pts for LightBing
SAGAN Peter   104   for Bicycle Boy and Googolplex
KELDERMAN Wilco   81   for Carlo Algatrensig, Triley36 and Vladimir
MAS NICOLAU Enric   80   8 teams
COLBRELLI Sonny   75   for Koronin and Ratta Kuningas
URAN URAN Rigoberto   63   14
TRENTIN Matteo   55   1
VAN GARDEREN Tejay   51   3
GAUDU David   49   1
ROCHE Nicolas   46   3
YATES Adam   45   4
...
DOWSETT Alex   -46   2
ZAKARIN Ilnur   -50   1
KÄMNA Lennard   -54   9
ZABEL Rick   -77   7
MARTIN Tony   -300   1

On the day
1   LightBing   305 (80 Green points)
2   Carlo_Algatrensig   256 (50)
3   Yellow_Knight   187 (35)
4   JustSomeGuy   167 (25)
5   BicycleBoy   166 (15)
6   Koronin   150 (10)
7   Triley36   137 (5)
8   DJSprtsch   134 (3)
9   BikeRacer33, Del1962   121 (1.5 each)
11   Squire   117
12   ArchieBoy   109
13   Bminchow   108
14   Shalgo   106
15   Kazistuta   105
16   Salvarani   101
17   Fauniera   96
18   BlackBandit222   93
19   RattaKuningas   80
20   Ripley   78
21   Tobydawq   74
22   Googolplex   59
23   AmisVelo   53
24   Vladimir   45
25   Armchair_Cyclist   44
26   BluesInTheBottle   39
27   LosBrolin   37
28   Rote_Laterne   34
29   Scrool07   30
30   Leadbelly   24
31   Search   17
32   Mellow_Velo   -4
33   Josedin   -19
34   Tigerion   -26
35   Laarsland   -42
36   Comodoro   -69
37   TotalPackage   -73
38   Otoxiep87   -190
   Collective_Wisdom   91


Green points

Yellow Knight and Just Some Guy come from no score to the top 10; LightBing has a 1st and a 3rd to secure top spot, and Koronin, Carlo and Bicycle Boy all have a second top ten placing in today's stage.

1   LightBing   115
2   Search   80
3   Carlo_Algatrensig, Koronin   75
5   RattaKuningas   65
6   Laarsland   50
7   ArchieBoy, Yellow_Knight   35
9   BicycleBoy   30
10   Googolplex, JustSomeGuy   25

Standings

Archie retains his lead, through unique pick Van Aert, but there are some teams with early momentum behind him: Carlo is up 6 places in 2nd, and BicycleBoy up 7 to 5th, but those are as nothing to LightBing's 27 place move to 7th.

1   ArchieBoy   982
2   Carlo_Algatrensig   850 
3   Search   801
4   Laarsland   797
5   BicycleBoy   721
6   RattaKuningas   720
7   LightBing   665
8   Otoxiep87   660
9   Ripley   652
10   Josedin   635
11   Googolplex   624
11   Tobydawq   624
13   Scrool07   610
14   DJSprtsch   606
15   JustSomeGuy   599
16   Armchair_Cyclist   597
17   Fauniera   596
18   Vladimir   589
19   BlackBandit222   587
19   TotalPackage   587
21   Triley36   584
22   Shalgo   567
23   LosBrolin   558
24   Rote_Laterne   555
25   Del1962   542
26   Mellow_Velo   528
27   Koronin   524
28   Salvarani   522
29   Yellow_Knight   494
30   Bminchow   490
31   Squire   484
32   AmisVelo   475
33   BluesInTheBottle   470
34   Comodoro   466
34   Leadbelly   466
36   Kazistuta   413
37   BikeRacer33   374
38   Tigerion   254
   Collective_Wisdom   552

Tomorrow should see far less change in the GC, and the sprinters we have chosen, or left unchosen, will probably affect the green points more than the main event.

Now I'm just hoping that ASO don't nullify that 5 second gap between Bernal and Thomas and render all my numbers incorrect.

[rote_laterne]

Thanks for the swift updates. Is there a chance you include the guaranteed points standing again as there's more fluctuation at the beginning of the tours?

[Armchair Cyclist]

Stage 4 One for the sprinters

Far fewer points changes, and the biggest ones, for 1st and 2nd on the day, don't affect our riders:

EWAN Caleb   38   16
SAGAN Peter   25   2
GROENEWEGEN Dylan   15   1
KREUZIGER Roman   8   7
GAUDU David   6   1
SOLER GIMENEZ Marc   5   6
PORTE Richie   5   22
...
KELDERMAN Wilco   -5   3
DE MARCHI Alessandro   -6   1
QUINTANA ROJAS Nairo Alexander   -7   9
COLBRELLI Sonny   -10   2
MATTHEWS Michael   -13   1
REICHENBACH Sébastien   -27   2


1   TotalPackage   62 (Ewan, Groenewegen, Felline, Soler) (80 green points)
2   Shalgo   51 (Ewan, Kreuziger, Porte) (50)
3   Comodoro   48 (Ewan, Porte, Soler) (35)
4   Otoxiep87   47 (25)
5   Tigerion   45 (15)
6   LosBrolin   43 (10)
7   Scrool07   41 (5)
8   Kazistuta   40 (3)
9   DJSprtsch, RattaKuningas, Rote_Laterne   38 (1 each)
12   AmisVelo   36
13   Googolplex   29
14   BicycleBoy   25
15   Armchair_Cyclist   24
16   Koronin, LightBing   22
18   BikeRacer33   19
19   Ripley, Tobydawq   13
21   BluesInTheBottle   10
21   Triley36   10
23   Fauniera   8
24   ArchieBoy, Mellow_Velo, Yellow_Knight   7
27   Bminchow   6
28   BlackBandit222, Leadbelly   5
30   Josedin, Laarsland   4
32   Salvarani, Search   2
34   Carlo_Algatrensig   -1
35   Del1962, JustSomeGuy, Squire   -2
38   Vladimir   -12
   Collective_Wisdom   43

Green points
Total Package already had a couple of points, so the day's win brings 2nd place.  Shalgo and Comodoro get the top ten with their forst points: 6 teams are still waiting for theirs.  At this stage it is odd to score, and yet drop in the table, but Ratta Kuningas manages it.

1   LightBing   115
2   TotalPackage   82
3   Search   80
4   Carlo_Algatrensig   75
4   Koronin   75
6   RattaKuningas   66
7   Laarsland   50
7   Shalgo   50
9   ArchieBoy   35
9   Comodoro   35
9   Yellow_Knight   35


Guaranteed points
I had envisaged the Green points replacing this as the secondary classification, and once the GC rankings take on something resembling its final shape, this should become fairly redundant, but I have been asked for it on both sites:
1   LightBing   138
2   Otoxiep87, RattaKuningas   110
4   TotalPackage   108
5   Googolplex   105
6   BicycleBoy   104
7   Koronin   98
8   Comodoro   91
9   LosBrolin, Rote_Laterne, Scrool07   90
12   Armchair_Cyclist   87
13   DJSprtsch, Shalgo   84
15   AmisVelo   82
16   Kazistuta   78
17   Tigerion   73
18   BikeRacer33   72
19   ArchieBoy   36
20   Laarsland   35
21   Search   33
22   BlackBandit222   32
23   Josedin   30
24   Carlo_Algatrensig   28
25   Tobydawq   26
26   Ripley, Vladimir   24
28   Fauniera   20
29   Leadbelly, Triley36   18
31   Mellow_Velo   17
32   Squire   16
33   BluesInTheBottle   15
34   Del1962, JustSomeGuy, Salvarani   14
37   Bminchow   12
38   Yellow_Knight   10
   Collective_Wisdom   84


Standings

Small scores mean fewer changes in the rankings: the top 4 are unchanged, Ratta Kuningas and Otoxiep make minor steps forward among the top ten, Googolplex shows up in the top 10, and Total Package gets a 7 position leap forward, the best of the day, even if undramatic compared to the last couple of days.

1   ArchieBoy   989
2   Carlo_Algatrensig   849
3   Search   803
4   Laarsland   801
5   RattaKuningas   758
6   BicycleBoy   746
7   Otoxiep87   707
8   LightBing   687
9   Ripley   665
10   Googolplex   653
11   Scrool07   651
12   TotalPackage   649
13   DJSprtsch   644
14   Josedin   639
15   Tobydawq   637
16   Armchair_Cyclist   621
17   Shalgo   618
18   Fauniera   604
19   LosBrolin   601
20   JustSomeGuy   597
21   Triley36   594
22   Rote_Laterne   593
23   BlackBandit222   592
24   Vladimir   577
25   Koronin   546
26   Del1962   540
27   Mellow_Velo   535
28   Salvarani   524
29   Comodoro   514
30   AmisVelo   511
31   Yellow_Knight   501
32   Bminchow   496
33   Squire   482
34   BluesInTheBottle   480
35   Leadbelly   471
36   Kazistuta   453
37   BikeRacer33   393
38   Tigerion   299
   Collective_Wisdom   595

[Armchair Cyclist]

Stage 5 Hilly ride through Alsace, main sprinters dropped

Sagan got a substantial (but probably very temporary) rise through the GC positions today, which was worth more points than the stage win.  Few other substantial changes, as those who dropped away today were, for the most part, already outside the top 50 anyway.

SAGAN Peter   178pts   2 teams
TRENTIN Matteo   56   1
VAN AERT Wout   50   1
MATTHEWS Michael   20   1
COLBRELLI Sonny   19   2
...
URAN URAN Rigoberto   -10   14
VAN GARDEREN Tejay   -10   3
GAUDU David   -12   1
KELDERMAN Wilco   -15   3

On the day
1   Googolplex   179 (Sagan and Felline (1)) (80 Green pts)
2   BicycleBoy   168 (Sagan but Uran) (50)
3   BlackBandit222   46 (Trentin but Van Garderen) (35)
4   ArchieBoy   43 (Van Aert and Boasson Hagen but Van Garderen and Soler) (25)
5   Koronin   18 (15)
6   RattaKuningas   17 (10)
7   LightBing   14 (5)
8   Josedin   3 (3)
9   Search   2 (2)
10   Laarsland, Tobydawq   1 (0.5 each)
12   Otoxiep87, Ripley   0
14   Bminchow, Comodoro, Kazistuta, Leadbelly, Tigerion, TotalPackage   -1
20   AmisVelo   -2
21   BluesInTheBottle, Scrool07   -3
23   Mellow_Velo, Salvarani, Yellow_Knight   -8
26   LosBrolin, Rote_Laterne, Squire   -10
29   Armchair_Cyclist, Del1962, Shalgo   -11
32   BikeRacer33, Triley36   -13
34   Vladimir   -15
35   DJSprtsch, JustSomeGuy   -16
37   Fauniera   -19
38   Carlo_Algatrensig   -24
   Collective_Wisdom   -11

Green points

Googolplex and Bicycle Boy are new in the top ten.

1   LightBing   120
2   Googolplex   105
3   Koronin   90
4   Search   82
4   TotalPackage   82
6   BicycleBoy   80
7   RattaKuningas   76
8   Carlo_Algatrensig   75
9   ArchieBoy   60
10   Laarsland   50.5


Guaranteed points

1   Googolplex   185
2   BicycleBoy   184
3   LightBing   143
4   RattaKuningas   135
5   Koronin   123
6   Otoxiep87   110
7   TotalPackage   108
8   Comodoro   91
9   LosBrolin, Rote_Laterne, Scrool07   90


Standings

Given the margin by which he was the biggest scorer of the day, it is no surprise that Sagan is behind the two most significant jumps in position: BicycleBoy and Googolplex getting onto the podium.  But not the biggest jump: BlackBandit has moved up 9.

1   ArchieBoy   1032 
2   BicycleBoy   914
3   Googolplex   832
4   Carlo_Algatrensig   825
5   Search   805
6   Laarsland   802
7   RattaKuningas   775
8   Otoxiep87   707
9   LightBing   701
10   Ripley   665
11   Scrool07   648
11   TotalPackage   648
13   Josedin   642
14   BlackBandit222   638
14   Tobydawq   638
16   DJSprtsch   628
17   Armchair_Cyclist   610
18   Shalgo   607
19   LosBrolin   591
20   Fauniera   585
21   Rote_Laterne   583
22   JustSomeGuy   581
22   Triley36   581
24   Koronin   564
25   Vladimir   562
26   Del1962   529
27   Mellow_Velo   527
28   Salvarani   516
29   Comodoro   513
30   AmisVelo   509
31   Bminchow   495
32   Yellow_Knight   493
33   BluesInTheBottle   477
34   Squire   472
35   Leadbelly   470
36   Kazistuta   452
37   BikeRacer33   380
38   Tigerion   298
   Collective_Wisdom   584

Puncheurs have a huge influence on the scores at the moment: I suspect that will not be the case after tomorrow.

[Blackbandit222]

Almost selected Ciccone,  he was so so impressive at Giro.  How he made all those breaks and beat everyone to the top of those climbs when I’d never heard of him before.  Then again I don’t follow Italian riders on Italian Pro Conti squads!  I didn’t think he could replicate it a month later.

Also just because team average is 500/ per rider doesn’t mean I can have all the high 500 riders TVG, Porte & Ciccone

Trentin really letting me down.  Sits up stage 4 and doesn’t bike throw on 5.

[Armchair Cyclist]

Stage 6 Planche des Belles Filles, and then a bit

A few stage points, but mainly GC gains by passing puncheurs as they, for the most part, drop dramatically.

THOMAS Geraint   88pts for Ripley
BUCHMANN Emanuel   82   for Josedin
QUINTANA ROJAS Nairo Alexander   62   9 teams
LANDA MEANA Mikel   57   7
URAN URAN Rigoberto   50   14
YATES Adam   47   4
PORTE Richie   39   22
BARGUIL Warren   35   10
ARU Fabio   31   22
REICHENBACH Sébastien   25   2
...
BOASSON HAGEN Edvald   -25   1
BILBAO LOPEZ DE ARMENTIA Pello   -35   1
ROCHE Nicolas   -52   3
VAN GARDEREN Tejay   -57   3
TRENTIN Matteo   -68   1
COLBRELLI Sonny   -74   2
MAS NICOLAU Enric   -80   8
KELDERMAN Wilco   -120   3
SAGAN Peter   -160   2
KRUIJSWIJK Steven   -180   5
MATTHEWS Michael   -270   1
VAN AERT Wout   -419   1

On the day
1   Del1962   182 (Quintana, Uran, Porte, Aru) (80 Green points)
2   Mellow_Velo   177  (Landa, Uran, Porte, Aru) (50)
3   Ripley   172 (Thomas, Barguil, Kreuziger, Porte) (35)
4   AmisVelo   152 (25)
5   Salvarani   142 (12.5)
5   Tigerion   142(12.5)
7   Fauniera   132 (5)
8   Armchair_Cyclist   123 (3)
9   Leadbelly   120 (2)
10   BluesInTheBottle   118 (0.5)
10   LosBrolin   118 (0.5)
12   Rote_Laterne   114
13   Shalgo   111
14   Bminchow   107
15   Squire   101
16   JustSomeGuy   99
17   Yellow_Knight   76
18   Comodoro   69
19   BikeRacer33   68
20   Kazistuta   64
21   Tobydawq   34
22   DJSprtsch   28
23   Triley36   17
24   Josedin   1
25   Otoxiep87   -13
26   Vladimir   -24
27   Scrool07   -48
28   BlackBandit222   -55
29   Search   -88
30   BicycleBoy   -110
31   Koronin   -115
32   Laarsland   -116
33   Carlo_Algatrensig   -121
34   Googolplex   -127
35   TotalPackage   -151
36   RattaKuningas   -184
37   LightBing   -263
38   ArchieBoy   -500
   Collective_Wisdom   154

Green points

Del is the only one of this group to have scored today.

1   LightBing   120
2   Googolplex   105
3   Koronin   90
4   Search   82
4   TotalPackage   82
6   Del1962   81.5
7   BicycleBoy   80
8   RattaKuningas   76
9   Carlo_Algatrensig   75
10   ArchieBoy   60

Guaranteed points

1   Googolplex   185
2   BicycleBoy   184
3   LightBing   148
4   RattaKuningas   135
5   Koronin   123
6   Otoxiep87   110
7   TotalPackage   108
8   Scrool07   95
9   Comodoro   91
10   LosBrolin   90
10   Rote_Laterne   90

Standings

Huge changes, including ne sall of more than 30 places.  5 of the top ten weren't in that group yesterday, and those new entries to the top ten have an average jump of more than 12 places.  Del's is the biggest (19 place) move, but the most significant move is of our first-time player from PCM Daily, and new leader, Ripley, who has Geraint Thomas as a unique pick and therefore might, on today's evidence, take some shifting. 

1   Ripley   837
2   BicycleBoy   804
3   Armchair_Cyclist   733
4   Shalgo   718
5   Fauniera   717
5   Search   717
7   Del1962   711
8   LosBrolin   709
9   Googolplex   705
10   Carlo_Algatrensig   704
10   Mellow_Velo   704
12   Rote_Laterne   697
13   Otoxiep87   694
14   Laarsland   686
15   JustSomeGuy   680
16   Tobydawq   672
17   AmisVelo   661
18   Salvarani   658
19   DJSprtsch   656
20   Josedin   643
21   Bminchow   602
22   Scrool07   600
23   Triley36   598
24   BluesInTheBottle   595
25   RattaKuningas   591
26   Leadbelly   590
27   BlackBandit222   583
28   Comodoro   582
29   Squire   573
30   Yellow_Knight   569
31   Vladimir   538
32   ArchieBoy   532
33   Kazistuta   516
34   TotalPackage   497
35   Koronin   449
36   BikeRacer33   448
37   Tigerion   440
38   LightBing   438
   Collective_Wisdom   738

[Armchair Cyclist]

Stage 7 Slow motion chase of a half hearted break

Stage points, and a few Point classification changes dominate, only very minor GC projection changes.

GROENEWEGEN Dylan   83   1
EWAN Caleb   64   16
COLBRELLI Sonny   50   2
SAGAN Peter   35   2
CHEREL Mikael   4   1
FELLINE Fabio   3   7
BOASSON HAGEN Edvald   3   1
BERNARD Julien   2   2
OFFREDO Yoann   1   1
...
VAN AERT Wout   -1   1
REICHENBACH Sébastien   -4   2
TRENTIN Matteo   -5   1
SOLER GIMENEZ Marc   -6   6
VAN GARDEREN Tejay   -6   3
MATTHEWS Michael   -23   1

Points are so low that I have included all the selected riders who have gained or lost today.

On the day
1   TotalPackage   144 (Groenewegen, Ewan, Felline but Soler) (80)
2   Koronin   114 (Ewan and Colbrelli)
3   RattaKuningas   108 (Ewan and Colbrelli, but Soler) (35)
4   AmisVelo   68 (25)
5   Kazistuta, Otoxiep87   67 (12.5 each)
7   Shalgo   66(5)
8   DJSprtsch, LosBrolin, Rote_Laterne, Tigerion   64 (1.5 each)
12   Armchair_Cyclist   60
13   Comodoro, Scrool07   58
15   BikeRacer33   56
16   LightBing   44
17   Googolplex   38
18   BicycleBoy   35
19   Carlo_Algatrensig, Laarsland   3
21   Triley36   1
22   Bminchow, Del1962, Fauniera, Josedin, JustSomeGuy, Leadbelly, Mellow_Velo, Ripley, Salvarani, Search, Squire, Tobydawq, Vladimir, Yellow_Knight   0
36   BluesInTheBottle   -6
37   ArchieBoy   -10
38   BlackBandit222   -11
   Collective_Wisdom   64

Green points

The population of the top ten is unchanged.  Other than the toppled leader, LightBing, the top four is made up of the day's top three.

1   TotalPackage   162
2   Koronin   140
3   LightBing   120
4   RattaKuningas   111
5   Googolplex   105
6   Search   82
7   Del1962   81.5
8   BicycleBoy   80
9   Carlo_Algatrensig   75
10   ArchieBoy   60


Guaranteed points

First and second on the day yields 130 guaranteed points, and brings TP from 7th to top.

1   TotalPackage   238
2   Googolplex   220
3   BicycleBoy   219
4   RattaKuningas   210
5   LightBing   200
6   Koronin   198
7   Otoxiep87   160
8   Scrool07   145
9   Comodoro   141
10   LosBrolin   140
10   Rote_Laterne   140


Standings

Peter Sagan's third place is enough to bring Bicycle Boy into the lead, while those in 3rd and 4th close the gap to the leaders.  Otoxiep, Rote Laterne, Amis Velo and DJSprtsch are new entries in the top ten, with jumps of 6 to 9 places, but Total Package has gone up by 11: more volatility than I would have expected on such a neutral stage, and testament to how closely bunched most of us still are.

1   BicycleBoy   839
2   Ripley   837
3   Armchair_Cyclist   793
4   Shalgo   784
5   LosBrolin   773
6   Otoxiep87   761
6   Rote_Laterne   761
8   Googolplex   743
9   AmisVelo   729
10   DJSprtsch   720
11   Fauniera   717
11   Search   717
13   Del1962   711
14   Carlo_Algatrensig   707
15   Mellow_Velo   704
16   RattaKuningas   699
17   Laarsland   689
18   JustSomeGuy   680
19   Tobydawq   672
20   Salvarani   658
20   Scrool07   658
22   Josedin   643
23   TotalPackage   641
24   Comodoro   640
25   Bminchow   602
26   Triley36   599
27   Leadbelly   590
28   BluesInTheBottle   589
29   Kazistuta   583
30   Squire   573
31   BlackBandit222   572
32   Yellow_Knight   569
33   Koronin   563
34   Vladimir   538
35   ArchieBoy   522
36   BikeRacer33   504
36   Tigerion   504
38   LightBing   482
   Collective_Wisdom   802

[Armchair Cyclist]

Because I have put it on CN, I should put it here too:

The top 15 scorers of projected (including guaranteed) points are:

CICCONE Giulio   740pts   0 teams
ALAPHILIPPE Julian   609   0
TEUNS Dylan   485   0
BENNETT George   340   0
THOMAS Geraint   330   1
SAGAN Peter   305   2
BERNAL GOMEZ Egan Arley   272   28
PINOT Thibaut   246   0
KRUIJSWIJK Steven   220   5
WOODS Michael   182   0
MEURISSE Xandro   173   0
TEUNISSEN Mike   172   0
URAN URAN Rigoberto   162   14
EWAN Caleb   155   16
VIVIANI Elia   155   0
and a few other decent scorers who were selected:
COLBRELLI Sonny   140   2
BUCHMANN Emanuel   133   1
MAS NICOLAU Enric   128   8
MATTHEWS Michael   120   1
GROENEWEGEN Dylan   118   1
YATES Adam   110   4
VAN AERT Wout   102   1
QUINTANA ROJAS Nairo Alexander   99   9
LANDA MEANA Mikel   89   7
TRENTIN Matteo   80   1


And among top teams, the big scorers are:
1   BicycleBoy   839 (Sagan, Bernal, Uran)
2   Ripley   837 (Thomas, Bernal)
3   Armchair_Cyclist   793 (Bernal, Uran, Ewan)
4   Shalgo   784 (Bernal, Uran, Ewan)
5   LosBrolin   773 (Bernal, Uran, Ewan)
6   Otoxiep87   761 (Bernal, Ewan, Mas)
6   Rote_Laterne   761 (Bernal, Uran, Ewan)
8   Googolplex   743 (Sagan, Bernal)
9   AmisVelo   729 (Bernal, Ewan, Quintana)
10   DJSprtsch   720 (Bernal, Uran, Quintana)

and everything is in the spreadsheet

[Armchair Cyclist]

Stage 8 Hilly transfer to St Etienne

Apart from stage and KoM rankings, there were quite a few points for moving up as Teuns and Woods slipped down.

DE GENDT Thomas   125 points for Koronin
MATTHEWS Michael   63 folr LightBing
URAN URAN Rigoberto   40   14 teams
BUCHMANN Emanuel   30 for Josedin
KRUIJSWIJK Steven   30   5
TRENTIN Matteo   27   1
SAGAN Peter   26   2
MAS NICOLAU Enric   20   8
YATES Adam   20   4
...
EWAN Caleb   -10   16
VAN AERT Wout   -10   1
COLBRELLI Sonny   -15   2
CHEREL Mikael   -16   1
VAN GARDEREN Tejay   -37   3

Three teams become the first to register a non-finisher (TJVG): they lose the 37 GC points he was in line for by virtue of the 36th place spot he held on GC, but retain the 2 points he got on stage 2.

On the day

Koronin not only had De Gendt as a unique pick, she also had De Marchi in back-up

1   Koronin   129 (De Gendt and Mas, but Ewan and Colbrelli) (80 green points)
2   Squire   112 (Uran and Mas, and 4 others with some gains today)  (50)
3   Yellow_Knight   96  (Uran and Mas, and 3 others with some gains today) (35)
4   JustSomeGuy   81 (25)
5   Del1962   79 (15)
6   Mellow_Velo   75 (10)
7   Fauniera   71 (5)
8   Shalgo   70 (3)
9   LightBing   69 (2)
10   BicycleBoy, LosBrolin   68 (0.5 each)
12   Armchair_Cyclist   63
13   Carlo_Algatrensig, Salvarani   60
15   Leadbelly   58
16   Tobydawq   55
17   Scrool07   54
18   Josedin   52
19   DJSprtsch   51
20   Search   50
21   BluesInTheBottle   45
21   Bminchow   45
23   Rote_Laterne   44
24   Googolplex   41
25   Triley36   40
26   Tigerion   37
27   Laarsland   36
28   Kazistuta   34
29   TotalPackage   28
30   Ripley   27
31   Comodoro, Otoxiep87   25
33   Vladimir   24
34   RattaKuningas   23
35   BlackBandit222   18
36   AmisVelo   13
37   BikeRacer33   -3
38   ArchieBoy   -36
   Collective_Wisdom   59

Green points

Koronin has stated that this classification is her goal for the game, and has now gained top spot.  Del1962 is moving in the right direction, and Yellow Knight has a 7 place jump to enter the top ten.

1   Koronin   220
2   TotalPackage   162
3   LightBing   122
4   RattaKuningas   111
5   Googolplex   105
6   Del1962   96.5
7   Search   82
8   BicycleBoy   80.5
9   Carlo_Algatrensig   75
10   Yellow_Knight   70

Guaranteed points

1   Koronin   278
2   TotalPackage   238
3   Googolplex   237
4   BicycleBoy   236
5   LightBing   225
6   RattaKuningas   210
7   Otoxiep87   162
8   Scrool07   145
9   Comodoro   143
10   LosBrolin   142
10   Rote_Laterne   142

Standings

You have to look down to 7th place before you will find any team that has made progress, and there Del, immediately followed by Fauniera, sit as new teams in the top ten.  Yellow Knight and Squire match Del's 6 place rise, but Koronin outdoes them, jumping 10 spots.

1   BicycleBoy   907
2   Ripley   864
3   Armchair_Cyclist   856
4   Shalgo   854
5   LosBrolin   841
6   Rote_Laterne   805
7   Del1962   790
8   Fauniera   788
9   Otoxiep87   786
10   Googolplex   784
11   Mellow_Velo   779
12   DJSprtsch   771
13   Carlo_Algatrensig   767
13   Search   767
15   JustSomeGuy   761
16   AmisVelo   742
17   Tobydawq   727
18   Laarsland   725
19   RattaKuningas   722
20   Salvarani   718
21   Scrool07   712
22   Josedin   695
23   Koronin   692
24   Squire   685
25   TotalPackage   669
26   Comodoro   665
26   Yellow_Knight   665
28   Leadbelly   648
29   Bminchow   647
30   Triley36   639
31   BluesInTheBottle   634
32   Kazistuta   617
33   BlackBandit222   590
34   Vladimir   562
35   LightBing   551
36   Tigerion   541
37   BikeRacer33   501
38   ArchieBoy   486
   Collective_Wisdom   861

[Armchair Cyclist]

Stage 9 Unchased breakaway through the Massif Central

A few of us had those who gained points in the break, a few of us had riders overtaken by those who were in the break, one of us had an unfortunate non-finisher, and a lot of us had nothing at all.

ROCHE Nicolas   35   DJSprtsch, JSG and LightBing
SOLER GIMENEZ Marc   33   6 teams
GARCIA CORTINA Ivan   3   Laarsland
...
DE PLUS Laurens   -1   3
CHEREL Mikael   -2   1
EWAN Caleb   -2   16
REICHENBACH Sébastien   -4   2
HENAO MONTOYA Sergio Luis   -5   8
BERNARD Julien   -6   2
SAGAN Peter   -9   2
TRENTIN Matteo   -9   1
MATTHEWS Michael   -10   1
DE MARCHI Alessandro   -23   1


On the day

1   JustSomeGuy   35 (80 green points)
2   BluesInTheBottle, DJSprtsch   32 (42.5 each)
4   RattaKuningas, Scrool07   31 (20 each)
6   ArchieBoy   28 (10)
7   Comodoro, TotalPackage   26 (4 each)
9   LightBing   23 (2)
10   Laarsland   3 (1)
11   The other 13 teams   0
24   Kazistuta, Otoxiep87, Rote_Laterne, Tigerion   -2
28   AmisVelo   -4
29   Leadbelly, Squire   -5
31   Armchair_Cyclist   -6
32   LosBrolin   -7
33   BicycleBoy   -9
34   BlackBandit222   -10
35   BikeRacer33   -12
36   Shalgo   -13
37   Googolplex   -14
38   Koronin   -25
   Collective_Wisdom   -2


Green points

Ratta (is that a forename?) moves onto the podium, but JSG, coming from way down the table, nearly prevented him from doing so.

1   Koronin   220
2   TotalPackage   166
3   RattaKuningas   131
4   JustSomeGuy   130
5   LightBing   124
6   Googolplex   105
7   Del1962   96.5
8   Search   82
9   BicycleBoy   80.5
10   Carlo_Algatrensig   75


Guaranteed points

The top 6 here have points from expensive sprinters/puncheurs (Sagan, Groenewegen, Colbrelli, Matthews), so although they have a good margin over the rest of the field here, they are missing out on GC points, and have an average position of about 19th in the main ranking. 

1   Koronin   278
2   TotalPackage   243
3   Googolplex   237
4   BicycleBoy   236
5   LightBing   235
6   RattaKuningas   215
7   Otoxiep87   162
8   Scrool07   150
9   Comodoro   148
10   DJSprtsch   146

Standings

The exception to the low ranking of the teams with high guaranteed scores is found at the top of the table.  Bicycle Boy retains his place, as do the rest of yesterday's top six.  On a day of low scores, DJSprtsch and Just Some Guy make Roche-powered jumps of 6 and 7 places respectively into the top ten.

1   BicycleBoy   898
2   Ripley   864
3   Armchair_Cyclist   850
4   Shalgo   841
5   LosBrolin   834
6   DJSprtsch   803
6   Rote_Laterne   803
8   JustSomeGuy   796
9   Del1962   790
10   Fauniera   788
11   Otoxiep87   784
12   Mellow_Velo   779
13   Googolplex   770
14   Carlo_Algatrensig   767
14   Search   767
16   RattaKuningas   753
17   Scrool07   743
18   AmisVelo   738
19   Laarsland   728
20   Tobydawq   727
21   Salvarani   718
22   Josedin   695
22   TotalPackage   695
24   Comodoro   691
25   Squire   680
26   Koronin   667
27   BluesInTheBottle   666
28   Yellow_Knight   665
29   Bminchow   647
30   Leadbelly   643
31   Triley36   639
32   Kazistuta   615
33   BlackBandit222   580
34   LightBing   574
35   Vladimir   562
36   Tigerion   539
37   ArchieBoy   514
38   BikeRacer33   489
   Collective_Wisdom   859