Jump to content

The Hub TdF Fantasy Comp 2015


Frosty

Recommended Posts

We move down the stage results until we find a picked rider. Then do a draw if more than one person picked that rider.

 

Perhaps you could pick somebody who is having an absolute shocker, take pity on them and then "donate" the prize to them.

The guy in 634th spot at the moment is having a torrid fantasy tour, as an unbiased example..........

Link to comment
Share on other sites

  • Replies 1.4k
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

The Points Breakdown sheet will be updated tonight, after stage 10 results are complete.

The new format will show all the riders and teams that have scored points for you from stage 01 until the current stage.

 

Below is an example of what you will see:

 

Your original 9 riders picked to start the Tour are in the first 9 columns.

  • The PEACH coloured columns are riders that you've axed/dropped/thrown out, or they did that themselves by retiring/withdrawing from the Tour;
  • The PINK coloured columns are the substitutions you've brought into the team;
  • Any un-used substitutes will not show on this spreadsheet until you bring them into the team (next week Monday is the last chance to make a change).

     
  • Top right, in orange are hyperlinks to other data (Points Summary, Rider Scores and the Dream Team). Click on the orange cell to open the other tables of info or graphs. Warning - It opens in another tab in your browser.

 

Please check you teams to make sure it corresponds with the leaderboard, and let me know if there are any riders that belong/don't belong on the list.

 

post-1372-0-75071700-1436882248_thumb.png

Link to comment
Share on other sites

135 Hubbers selected Chris Froome as the winner of today's stage.

So they go into the draw for the daily prize.

 

As usual, the draw will be done using www.random.org

 

    1 - Admin's Allstars
    2 - Julian Goldmann's team
    3 - Wil6's team
    4 - Wez-O's Warriors
    5 - iceman_'s team
    6 - Spinnekop's team
    7 - ChrisCyclesZA
    8 - Sidekick Racer's team
    9 - Like A Boss
  10 - Irshaadmayet's team
  11 - Kylie's Carbon Crusaders
  12 - BigT4's team
  13 - StaalPaal
  14 - Fadhl's team
  15 - bunkermonkey's team
  16 - jjb's team
  17 - alexwc46's team
  18 - Thats_BH's team
  19 - Team Lucien
  20 - pauloc's team
  21 - tikki's team
  22 - TheDoc's Team
  23 - Team Jamaica
  24 - j.r.whitehead's team
  25 - Djangove Unchained's team
  26 - simo's team
  27 - Eight Ball in Paris
  28 - Team TAZ
  29 - _Pat_'s team
  30 - Funky Pro Cycling
  31 - bernard14's team
  32 - Martin Smit's team
  33 - Lurch's team
  34 - FlyingScot's team
  35 - @jamie_loots's team
  36 - Chainworx Team
  37 - Team Damz
  38 - VVC's team
  39 - Franco22's team
  40 - Andy's Wheelers
  41 - insomnia's team
  42 - Stevester's team
  43 - Team Léon Pro Cycling Team
  44 - sdp's team
  45 - 1 Racing
  46 - Peter Parker
  47 - ryan15harris's team
  48 - Cybercrow's team
  49 - mtbgirl's team
  50 - meez55's team
  51 - Tour de Svan
  52 - naTE-AM
  53 - Prince's team
  54 - MaplotterWJM's team
  55 - RaymondC's Team
  56 - David's team
  57 - sakkiebomskok's team
  58 - SlowSlow's team
  59 - flandriacycles
  60 - Google's team
  61 - Rattler's renegades
  62 - Team Stages
  63 - Shelbourne FCCC
  64 - Blackthorne's team
  65 - @TeamMTNFans
  66 - TOUR de Heidelberg
  67 - Quickie's team
  68 - BR87's team
  69 - BernardG's team
  70 - WBO's team
  71 - SurferChild's team
  72 - Heppy's team
  73 - Team Cervelo-Stephenson
  74 - BDF's team
  75 - Big J's team
  76 - Zatopek's team
  77 - MegC's team
  78 - LDValere's team
  79 - billabong69's team
  80 - orbeaorca's team
  81 - The Pro
  82 - besso's team
  83 - ForzaSky
  84 - Dagher's Team
  85 - JohanC's team
  86 - Team JSTN
  87 - Kaboom's team
  88 - jamex's team
  89 - El Pisteleros
  90 - TEAM POOPATROOPER
  91 - flash98's team
  92 - incredible9
  93 - Team Bobby Dazzler
  94 - Charsky's team
  95 - juair10's team
  96 - HABA's team
  97 - Urban Ninja
  98 - Speedy's team
  99 - dalem44's team
100 - Team Igknot
101 - MarshTDF2015
102 - Spirit of of Charlie Gaul
103 - Scuzzies
104 - Unseen to the normal eye
105 - Xanthe's team
106 - The Racing Turtles
107 - zaheerpatel's team
108 - Onassis's team
109 - 818 Cycles's team
110 - JCA12's team
111 - Nimthor's team
112 - Simonstel
113 - worriesnot's team
114 - Mrs Squier's team
115 - antomeno's team
116 - Speedy Team
117 - Dan45's team
118 - Nicholas F's team
119 - doyle's team
120 - Mietsie's team
121 - Vonkpropkatalisator's team
122 - Firozfx's team
123 - High Cadence
124 - Reece_Rower's team
125 - Chainline Cycleworks
126 - Ruba's team
127 - TheCannibal's team
128 - henrivdr's team
129 - HannesBasson93's team
130 - Flyer007's team
131 - Slow_one's team
132 - TeamButtons
133 - CarlyS's team
134 - tri-dreams's team
135 - The Tourminator's team
Link to comment
Share on other sites

The leaderboard has also been updated, as well as the points breakdown

Who was all the riders that attacked today? Valverde?

Link to comment
Share on other sites

The leaderboard has also been updated, as well as the points breakdown

 

Hi Gerald, just a note...my team position is different on the points breakdown (148) and on the Fantasy Tour page (115)...not sure, maybe there is a Gremlin in the pipes :w00t:

Link to comment
Share on other sites

Hi Gerald, just a note...my team position is different on the points breakdown (148) and on the Fantasy Tour page (115)...not sure, maybe there is a Gremlin in the pipes :w00t:

Will check it out. Thanks for querying
Link to comment
Share on other sites

Hi Gerald, just a note...my team position is different on the points breakdown (148) and on the Fantasy Tour page (115)...not sure, maybe there is a Gremlin in the pipes :w00t:

I didn't copy the data to the Points Summary tab... it still shows 9 stages.

 

Give me a few minutes to update it... sorry

Link to comment
Share on other sites

Hi Gerald, just a note...my team position is different on the points breakdown (148) and on the Fantasy Tour page (115)...not sure, maybe there is a Gremlin in the pipes :w00t:

Fixed - thanks for checking

Edited by geraldm24
Link to comment
Share on other sites

Hi Gerald - My points for stage 10 amounts to 386 on the points breakdown but I have only been given 288 on the points summary. It looks like the summary is taking the scores of the riders pre-substitution.

Link to comment
Share on other sites

The Points Breakdown sheet will be updated tonight, after stage 10 results are complete.

The new format will show all the riders and teams that have scored points for you from stage 01 until the current stage.

 

Below is an example of what you will see:

 

Your original 9 riders picked to start the Tour are in the first 9 columns.

  • The PEACH coloured columns are riders that you've axed/dropped/thrown out, or they did that themselves by retiring/withdrawing from the Tour;
  • The PINK coloured columns are the substitutions you've brought into the team;
  • Any un-used substitutes will not show on this spreadsheet until you bring them into the team (next week Monday is the last chance to make a change).

     

     

  • Top right, in orange are hyperlinks to other data (Points Summary, Rider Scores and the Dream Team). Click on the orange cell to open the other tables of info or graphs. Warning - It opens in another tab in your browser.

 

Please check you teams to make sure it corresponds with the leaderboard, and let me know if there are any riders that belong/don't belong on the list.

 

  Points Breakdown v1.PNG

 

Thanks for all your effort Gerald - really amazing

Link to comment
Share on other sites

Hi Gerald - My points for stage 10 amounts to 386 on the points breakdown but I have only been given 288 on the points summary. It looks like the summary is taking the scores of the riders pre-substitution.

 

Hi Gerald similar problems for me. My points on the Leaderboard, the points summary and points breakdown sheet don't seem to match. Also seems to be looking up riders that were dropped? (E.g. Cavendish in my instance).

Link to comment
Share on other sites

The leaderboard has been updated and is correct - the OFFICIAL scoreboard for the competition.

 

I will correct the points breakdown tomorrow - during the day. The more I work with Google Sheets, the more I dislike it. It has half the functionality that MS Office has, so more times than not I have to enter everything manually.

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
Settings My Forum Content My Followed Content Forum Settings Ad Messages My Ads My Favourites My Saved Alerts My Pay Deals Help Logout