Sorry about the delay: the spreadsheet suddenly started reporting untenable scores, which eventually traced back to mishandling capital letters with diacritics, and was also being very inconsistent with the =INDIRECT formula, which is pretty key to bringing everything together on the results page.
If anybody with proper knowledge of Excel, rather than my self-taught hit and miss and lifting code from other sheets approach, would be able to cast any light on the matter, that would be much appreciated.
It was beyond my Friday night head, but I have repopulated all the results tabs and refreshed other bits: I think I can now process yesterday's results and get something meaningful. At least I am starting from a proper position of Thursday's standings.
Stage 19 How did they not catch that breakaway?
Green points | | |
|---|
| CORT NIELSEN Magnus | 70 | 1 |
| OLIVEIRA Rui Filipe Alves | 40 | 0 |
| SIMMONS Quinn | 25 | 0 |
| BAGIOLI Andrea | 15 | 3 |
| ROUX Anthony | 10 | 0 |
| KRON Andreas Lorentz | 7 | 1 |
| CRADDOCK Lawson | 5 | 0 |
| DAINESE Alberto | 3 | 6 |
| TRENTIN Matteo | 2 | 1 |
| KRIEGER Alexander | 1 | 1 |
That was an inspired unique pick, that might yet be enough for TRiley to hold on to the overall lead.
| | |
|---|
| 1 | Triley36 | 70 |
| 2 | Berflamand | 15 |
| 2 | Bminchow | 15 |
| 2 | DJSprtsch | 15 |
| 5 | Comodoro | 10 |
| 6 | Mellow_Velo | 3 |
| 6 | Otoxiep87 | 3 |
| 6 | RedheadDane | 3 |
| 6 | Rufs | 3 |
| 6 | Salvarani | 3 |
| 6 | Titan31 | 3 |
And gives him back the lead in this category
| | | |
|---|
| 1 | Triley36 | 858 | 1 |
| 2 | Mellow_Velo | 795 | -1 |
| 3 | Comodoro | 668 | 1 |
| 4 | Search | 664 | -1 |
| 5 | Bminchow | 646 | 1 |
| 6 | Rote_Laterne | 639 | -1 |
| 7 | Otoxiep87 | 613 | 0 |
| 8 | SafeBet | 596 | 0 |
| 9 | Northerner | 576 | 0 |
| 10 | Leadbelly | 575 | 0 |
Red pointsOther than the stage points and red jersey bonus, the main relevant detail is riders that were below Meintjes moving up
GC a bit (I only watched the last 15km or so: Carlton must have been unconsolable). Modolo had been a fairly popular pick for those with not much budget left for their minor riders, but will not be giving an infinite percentage return.
| | |
|---|
| CORT NIELSEN Magnus | 80 | 1 |
| BAGIOLI Andrea | 20 | 3 |
| ROGLIC Primoz | 18 | 5 |
| DE LA CRUZ MELGAREJO David | 15 | 3 |
| GROSSSCHARTNER Felix | 8 | 1 |
| KRUIJSWIJK Steven | 8 | 3 |
| KRON Andreas Lorentz | 7 | 1 |
| DAINESE Alberto | 6 | 6 |
| LOPEZ PEREZ Juan Pedro | 6 | 2 |
| | |
| TRENTIN Matteo | -8 | 1 |
| MODOLO Sacha | -15 | 8 |
| VLASOV Aleksandr | -18 | 1 |
| MEINTJES Louis | -135 | 1 |
A tale of two unique picks: Cort does it again for Triley, but Meintjes has dented any thoughts Rote Laterne had on a late podium charge.
| | |
|---|
| 1 | Triley36 | 77 |
| 2 | Otoxiep87 | 27 |
| 3 | Bminchow | 26 |
| 4 | Berflamand | 24 |
| 5 | Mellow_Velo | 17 |
| 6 | Northerner | 16 |
| 6 | Yellow_Knight | 16 |
| 8 | BluesInTheBottle | 15 |
| 9 | Comodoro | 14 |
| 10 | ChrisDK | 12 |
| 11 | Del1962 | 11 |
| 11 | Vladimir | 11 |
| 13 | DJSprtsch | 7 |
| 13 | Search | 7 |
| 15 | BicycleBoy | 6 |
| 15 | Rufs | 6 |
| 17 | Koronin | 5 |
| 17 | Titan31 | 5 |
| 19 | Bonimenier | 1 |
| 20 | ArchieBoy | 0 |
| 20 | Earns1985 | 0 |
| 22 | SafeBet | -1 |
| 23 | AmisVelo | -2 |
| 23 | Leadbelly | -2 |
| 25 | RedheadDane | -9 |
| 26 | Armchair_Cyclist | -14 |
| 27 | Salvarani | -28 |
| 28 | Rote_Laterne | -129 |
| | Collective_Wisdom | -13 |
Standings | | | |
|---|
| 1 | Triley36 | 1895 | 0 |
| 2 | BluesInTheBottle | 1772 | 0 |
| 3 | Mellow_Velo | 1751 | 0 |
| 4 | Bminchow | 1628 | 1 |
| 5 | Otoxiep87 | 1550 | 2 |
| 6 | Search | 1533 | -1 |
| 7 | Rote_Laterne | 1485 | -3 |
| 8 | Northerner | 1451 | 1 |
| 9 | SafeBet | 1443 | -1 |
| 10 | ChrisDK | 1326 | 0 |
| 11 | Yellow_Knight | 1320 | 1 |
| 12 | Leadbelly | 1308 | -1 |
| 13 | Comodoro | 1218 | 0 |
| 14 | Berflamand | 1207 | 2 |
| 15 | Rufs | 1202 | -1 |
| 16 | Earns1985 | 1185 | -1 |
| 17 | AmisVelo | 1171 | 0 |
| 18 | BicycleBoy | 1153 | 0 |
| 19 | ArchieBoy | 1142 | 0 |
| 20 | Del1962 | 1123 | 0 |
| 21 | Vladimir | 1113 | 0 |
| 22 | Bonimenier | 1064 | 0 |
| 23 | DJSprtsch | 1016 | 0 |
| 24 | Salvarani | 889 | 0 |
| 25 | Titan31 | 881 | 0 |
| 26 | RedheadDane | 821 | 1 |
| 27 | Armchair_Cyclist | 818 | -1 |
| 28 | Koronin | 568 | 0 |
| | Collective_Wisdom | 1298 | |
Looking at the remaining riders for the top teams, as I posted them yesterday, I would suggest that the outcome depends on whether today's break stays clear. If Padun stays in it and scores well, the Roglic teams have definitely had it. But if all or most of the breakaway riders are caught, such that Roglic claws back most of what Cort gained yesterday, than TRiley will have to pray that some of the other time trialists have held back enough energy to limit the race leader's stage points tomorrow.
