collapse


Armchair Cyclist

  • Classics Winner
  • *
  • *
  • Country: 00
  • Posts: 3443
  • Liked: 3660
  • Awards: 2020 Tour de France Prediction Champ2020 Worlds Prediction Champ2019 Spring Classics Prediction Champ2018 Tour de France CQ game winner
Re: 2021 Vuelta CQ Game
« on: September 04, 2021, 12:20 »
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 points
Other 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.

  • ReplyReply

  •  



    Top
    Back to top