Steven Knoetze (sk27) Posted July 14, 2015 Posted July 14, 2015 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..........
Frosty Posted July 14, 2015 Author Posted July 14, 2015 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.
Slowbee Posted July 14, 2015 Posted July 14, 2015 ok, where is my prize .... I suppose like my rider choice...wishfull thinking.
Frosty Posted July 14, 2015 Author Posted July 14, 2015 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 team100 - Team Igknot101 - MarshTDF2015102 - Spirit of of Charlie Gaul103 - Scuzzies104 - Unseen to the normal eye105 - Xanthe's team106 - The Racing Turtles107 - zaheerpatel's team108 - Onassis's team109 - 818 Cycles's team110 - JCA12's team111 - Nimthor's team112 - Simonstel113 - worriesnot's team114 - Mrs Squier's team115 - antomeno's team116 - Speedy Team117 - Dan45's team118 - Nicholas F's team119 - doyle's team120 - Mietsie's team121 - Vonkpropkatalisator's team122 - Firozfx's team123 - High Cadence124 - Reece_Rower's team125 - Chainline Cycleworks126 - Ruba's team127 - TheCannibal's team128 - henrivdr's team129 - HannesBasson93's team130 - Flyer007's team131 - Slow_one's team132 - TeamButtons133 - CarlyS's team134 - tri-dreams's team135 - The Tourminator's team
Frosty Posted July 14, 2015 Author Posted July 14, 2015 And the winner is... Andy's Wheelers - well done.
Frosty Posted July 14, 2015 Author Posted July 14, 2015 The leaderboard has also been updated, as well as the points breakdown
Cav' Posted July 14, 2015 Posted July 14, 2015 The leaderboard has also been updated, as well as the points breakdownWho was all the riders that attacked today? Valverde?
CASSIE1975 Posted July 14, 2015 Posted July 14, 2015 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
Frosty Posted July 14, 2015 Author Posted July 14, 2015 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 Will check it out. Thanks for querying
Frosty Posted July 14, 2015 Author Posted July 14, 2015 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 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
Frosty Posted July 14, 2015 Author Posted July 14, 2015 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 Fixed - thanks for checking
Heppy Posted July 14, 2015 Posted July 14, 2015 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.
Ryinc Posted July 14, 2015 Posted July 14, 2015 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
Ryinc Posted July 14, 2015 Posted July 14, 2015 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).
Frosty Posted July 14, 2015 Author Posted July 14, 2015 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.