calculated stats based on FINAL results
|
Faillu |
Posted on 01-08-2014 22:17
|
Domestique
Posts: 418
Joined: 14-02-2011
PCM$: 200.00
|
I've been searching the Internet for the profiles too, but haven't been able to find them.
But I found them for 2013, so when you reach that point, please use these links to see them,
Tour of China I,
https://www.procyc...s_Overview
Tour of China II,
https://www.procyc...s_Overview
Tour of Hainan,
https://www.procyc...s_Overview
Tour of Tahiu Lake,
https://www.procyc...s_Overview |
|
|
|
Anderis |
Posted on 01-08-2014 23:03
|
Domestique
Posts: 471
Joined: 13-09-2010
PCM$: 200.00
|
TankNL wrote:
Flat = ? could be a percentage of the sprint stages?
I think you should include the results of sprints, cobbles and flat time trials to determine the flat skill. Success in one of these three kind of races would be enough to deserve a high flat. You would give a Tony Martin very high flat skill despite the fact he is neither sprinter nor cobble rider, wouldn't you? The same goes with Vanmarcke, who is neither exceptional sprinter nor time-trialist. And the same goes with Cavendish who doesn't have much success in TT and cobbles. |
|
|
|
TankNL |
Posted on 02-08-2014 14:29
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
@Faillu; thanks, found those as well. 2013 is finished, but can't seem to get the results for 2012. Thanks for the effort though.
@Anderis; was playing with that idea. Will finish the results of 2014 so far and then will test some rankings. Will definitely also try your idea. |
|
|
|
TankNL |
Posted on 03-08-2014 13:39
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
So, I've managed to collect all the data on the races from 2012 up until yesterday.
Here is the excel (19Mb's) with all the results.
https://dl.dropbo...llNow.xlsx
Now the toying around with the stats will begin.
I've build in a pivot table to order the give a start tot the stats, but will have to fine tune it further.
Again this is open source, so feel free to use it, only to also post your results here.
Tank |
|
|
|
TankNL |
Posted on 03-08-2014 23:34
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
OK, I've created a new Excel, this time with the calculated STATS inside them.
The formula's are obviously free to change, in order to get more appropriate results, but the first STATS are a fact... I am very eager to hear your thoughts on them.
https://dl.dropbo...%20v2.xlsx
Mind you, its already 25Mb.
again, love to get some feedback.
Edited by TankNL on 03-08-2014 23:39
|
|
|
|
TankNL |
Posted on 03-08-2014 23:36
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
updated 4-8-2014; sorted on the stat MOUNTAIN, this is the top 50;
Maximum stat | 80 | 84 | 83 | 83 | 82 | 83 | 83 | 80 | 82 | | | | | | | | | | | | FLAT | MOUNTAIN | HILL | TIMETRAIL | PROLOGUE | COBBLE | SPRINT | ACCELERATION | DOWNHILL | NIBALI Vincenzo | 76 | 84 | 78 | 77 | 67 | 74 | 74 | 80 | 82 | VALVERDE BELMONTE Alejandro | 78 | 84 | 83 | 75 | 79 | 55 | 75 | 80 | 82 | MAJKA Rafal | 72 | 83 | 76 | 75 | 50 | 50 | 58 | 76 | 80 | RODRIGUEZ OLIVER Joaquim | 75 | 83 | 79 | 70 | 50 | 50 | 71 | 76 | 82 | QUINTANA ROJAS Nairo Alexander | 73 | 82 | 75 | 76 | 50 | 50 | 56 | 74 | 78 | PINOT Thibaut | 72 | 82 | 75 | 74 | 50 | 52 | 58 | 75 | 79 | FROOME Chris | 75 | 82 | 75 | 79 | 75 | 50 | 74 | 74 | 78 | VAN GARDEREN Tejay | 73 | 81 | 75 | 76 | 77 | 50 | 60 | 74 | 78 | POZZOVIVO Domenico | 73 | 80 | 77 | 75 | 50 | 50 | 54 | 75 | 77 | PERAUD Jean-Christophe | 73 | 80 | 75 | 75 | 76 | 50 | 57 | 74 | 77 | CONTADOR VELASCO Alberto | 74 | 80 | 77 | 76 | 50 | 50 | 74 | 74 | 78 | MOLLEMA Bauke | 74 | 80 | 79 | 74 | 73 | 50 | 75 | 77 | 79 | BARDET Romain | 73 | 79 | 77 | 53 | 50 | 52 | 75 | 75 | 79 | HORNER Chris | 72 | 79 | 75 | 53 | 50 | 50 | 61 | 74 | 76 | URAN URAN Rigoberto | 72 | 79 | 75 | 76 | 50 | 50 | 59 | 73 | 76 | ROCHE Nicolas | 72 | 79 | 75 | 69 | 50 | 50 | 69 | 74 | 77 | KÖNIG Leopold | 71 | 79 | 74 | 75 | 50 | 50 | 53 | 73 | 76 | COSTA Rui Alberto Faria | 74 | 79 | 77 | 75 | 59 | 52 | 74 | 72 | 80 | PORTE Richie | 72 | 79 | 75 | 75 | 76 | 53 | 61 | 74 | 76 | MORENO FERNANDEZ Daniel | 73 | 78 | 79 | 51 | 50 | 50 | 61 | 76 | 77 | ROLLAND Pierre | 71 | 78 | 74 | 67 | 50 | 50 | 54 | 73 | 76 | EVANS Cadel | 74 | 78 | 77 | 75 | 75 | 50 | 74 | 74 | 77 | NIEVE ITURRALDE Mikel | 72 | 78 | 75 | 50 | 50 | 50 | 56 | 72 | 77 | ULISSI Diego | 74 | 78 | 81 | 75 | 50 | 50 | 66 | 76 | 78 | SCARPONI Michele | 72 | 78 | 76 | 65 | 50 | 50 | 58 | 73 | 76 | ARU Fabio | 75 | 77 | 74 | 75 | 50 | 51 | 50 | 72 | 74 | KREUZIGER Roman | 72 | 77 | 77 | 74 | 50 | 50 | 60 | 74 | 75 | FRANK Mathias | 72 | 77 | 75 | 74 | 75 | 50 | 57 | 72 | 75 | KELDERMAN Wilco | 73 | 77 | 75 | 75 | 74 | 54 | 60 | 72 | 75 | PELLIZOTTI Franco | 72 | 77 | 76 | 68 | 50 | 50 | 58 | 73 | 76 | FUGLSANG Jakob | 72 | 77 | 75 | 60 | 50 | 75 | 68 | 72 | 75 | MARTIN Daniel | 72 | 77 | 78 | 52 | 50 | 50 | 58 | 74 | 76 | TALANSKY Andrew | 72 | 77 | 74 | 75 | 73 | 52 | 62 | 71 | 75 | BASSO Ivan | 71 | 77 | 74 | 53 | 50 | 50 | 53 | 72 | 75 | TEN DAM Laurens | 74 | 77 | 68 | 54 | 50 | 50 | 53 | 72 | 74 | SANCHEZ GONZALEZ Samuel | 71 | 76 | 75 | 68 | 50 | 50 | 58 | 72 | 74 | ROGERS Michael | 72 | 76 | 75 | 65 | 50 | 50 | 70 | 72 | 76 | VAN DEN BROECK Jurgen | 71 | 76 | 74 | 55 | 73 | 55 | 56 | 71 | 74 | DUARTE AREVALO Fabio Andres | 64 | 76 | 65 | 52 | 50 | 50 | 51 | 72 | 74 | ARREDONDO MORENO Julian David | 71 | 76 | 75 | 50 | 50 | 50 | 55 | 72 | 75 | NAVARRO GARCIA Daniel | 71 | 76 | 63 | 52 | 50 | 50 | 52 | 71 | 75 | HESJEDAL Ryder | 72 | 76 | 76 | 63 | 73 | 50 | 59 | 72 | 76 | SCHLECK Fränk | 68 | 76 | 75 | 50 | 50 | 50 | 53 | 72 | 74 | KISERLOVSKI Robert | 71 | 76 | 69 | 54 | 50 | 50 | 53 | 71 | 74 | ZUBELDIA AGIRRE Haimar | 71 | 76 | 74 | 55 | 61 | 50 | 53 | 71 | 74 | KWIATKOWSKI Michal | 75 | 76 | 81 | 76 | 80 | 72 | 75 | 77 | 77 | BETANCUR GOMEZ Carlos Alberto | 72 | 76 | 76 | 60 | 50 | 50 | 67 | 72 | 75 | GADRET John | 71 | 76 | 71 | 50 | 50 | 50 | 51 | 71 | 74 | ANTON HERNANDEZ Igor | 71 | 76 | 74 | 51 | 50 | 50 | 51 | 72 | 74 | CATALDO Dario | 66 | 76 | 73 | 75 | 57 | 50 | 53 | 71 | 74 |
Edited by TankNL on 04-08-2014 14:24
|
|
|
|
Ad Bot |
Posted on 22-11-2024 01:45
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
IP: None |
|
|
TankNL |
Posted on 03-08-2014 23:37
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
updated 4-8-2014; sorted on the stat SPRINTING, this is the top 50;
Maximum stat | 80 | 84 | 83 | 83 | 82 | 83 | 82 | 80 | 82 | | | | | | | | | | | | FLAT | MOUNTAIN | HILL | TIMETRAIL | PROLOGUE | COBBLE | SPRINT | ACCELERATION | DOWNHILL | SAGAN Peter | 80 | 67 | 81 | 68 | 77 | 83 | 82 | 80 | 78 | GREIPEL André | 77 | 54 | 74 | 50 | 56 | 58 | 82 | 73 | 62 | KRISTOFF Alexander | 77 | 58 | 76 | 52 | 56 | 77 | 82 | 80 | 55 | KITTEL Marcel | 76 | 55 | 58 | 55 | 79 | 52 | 82 | 70 | 50 | BOUHANNI Nacer | 76 | 51 | 62 | 50 | 50 | 59 | 82 | 71 | 57 | CAVENDISH Mark | 75 | 55 | 74 | 54 | 61 | 52 | 82 | 73 | 52 | DEGENKOLB John | 78 | 54 | 75 | 53 | 50 | 80 | 82 | 75 | 74 | DEMARE Arnaud | 77 | 60 | 72 | 54 | 50 | 76 | 80 | 72 | 55 | COQUARD Bryan | 74 | 54 | 74 | 53 | 50 | 60 | 80 | 73 | 64 | VIVIANI Elia | 73 | 53 | 65 | 50 | 73 | 54 | 79 | 71 | 58 | DUMOULIN Samuel | 74 | 62 | 75 | 50 | 50 | 50 | 79 | 73 | 74 | MODOLO Sacha | 73 | 51 | 64 | 50 | 50 | 59 | 78 | 71 | 61 | NIZZOLO Giacomo | 72 | 51 | 70 | 50 | 76 | 50 | 78 | 72 | 62 | FARRAR Tyler | 73 | 53 | 69 | 50 | 73 | 75 | 78 | 73 | 50 | VAN STAEYEN Michael | 72 | 51 | 60 | 50 | 50 | 53 | 77 | 71 | 56 | BOS Theo | 72 | 52 | 53 | 50 | 50 | 50 | 77 | 55 | 50 | RENSHAW Mark | 72 | 51 | 53 | 50 | 50 | 55 | 77 | 57 | 50 | ROJAS GIL Jose Joaquin | 74 | 71 | 76 | 50 | 50 | 57 | 77 | 72 | 75 | MEZGEC Luka | 72 | 51 | 68 | 50 | 50 | 55 | 77 | 71 | 63 | FERRARI Roberto | 72 | 51 | 58 | 50 | 50 | 50 | 76 | 66 | 55 | MATTHEWS Michael | 72 | 56 | 76 | 61 | 50 | 50 | 76 | 75 | 73 | PETACCHI Alessandro | 72 | 51 | 53 | 50 | 50 | 50 | 76 | 62 | 50 | NAVARDAUSKAS Ramunas | 72 | 59 | 75 | 52 | 80 | 50 | 76 | 73 | 73 | VAN HUMMEL Kenny | 72 | 53 | 55 | 50 | 50 | 57 | 76 | 61 | 52 | HUTAROVICH Yauheni | 73 | 50 | 67 | 50 | 50 | 74 | 76 | 72 | 69 | CIOLEK Gerald | 72 | 53 | 74 | 50 | 50 | 60 | 76 | 74 | 61 | SWIFT Ben | 72 | 60 | 74 | 50 | 50 | 55 | 75 | 72 | 74 | CHICCHI Francesco | 71 | 50 | 50 | 50 | 50 | 50 | 75 | 52 | 50 | VAN ASBROECK Tom | 74 | 55 | 74 | 50 | 50 | 75 | 75 | 71 | 73 | VAN POPPEL Danny | 73 | 52 | 64 | 50 | 81 | 69 | 75 | 71 | 64 | MARTINEZ Yannick | 72 | 54 | 74 | 50 | 50 | 61 | 75 | 64 | 69 | MEERSMAN Gianni | 74 | 60 | 76 | 52 | 78 | 50 | 75 | 72 | 76 | HUSHOVD Thor | 72 | 53 | 67 | 50 | 50 | 74 | 75 | 72 | 54 | FEILLU Romain | 71 | 51 | 56 | 50 | 50 | 50 | 75 | 65 | 52 | BENNETT Sam | 72 | 50 | 67 | 50 | 50 | 61 | 75 | 54 | 73 | DEBUSSCHERE Jens | 72 | 53 | 62 | 50 | 50 | 75 | 75 | 71 | 58 | GUARDINI Andrea | 71 | 50 | 52 | 50 | 50 | 52 | 75 | 55 | 51 | GOSS Matthew | 71 | 51 | 59 | 50 | 50 | 50 | 75 | 64 | 55 | LOBATO DEL VALLE Juan Jose | 72 | 54 | 74 | 50 | 50 | 54 | 75 | 73 | 65 | BOASSON HAGEN Edvald | 73 | 53 | 75 | 54 | 75 | 76 | 75 | 75 | 74 | HAUSSLER Heinrich | 73 | 52 | 56 | 57 | 50 | 75 | 75 | 71 | 53 | BENNATI Daniele | 72 | 51 | 74 | 63 | 50 | 54 | 75 | 73 | 69 | VAN AVERMAET Greg | 77 | 55 | 79 | 50 | 50 | 81 | 75 | 76 | 78 | HOFLAND Moreno | 72 | 54 | 69 | 50 | 50 | 61 | 75 | 72 | 55 | VENTOSO ALBERDI Francisco Jose | 71 | 51 | 74 | 50 | 50 | 67 | 75 | 73 | 72 | GIRAUD Benjamin | 71 | 52 | 63 | 50 | 50 | 51 | 75 | 73 | 62 | GILBERT Philippe | 73 | 75 | 82 | 60 | 78 | 52 | 75 | 80 | 75 | PETIT Adrien | 72 | 51 | 65 | 50 | 75 | 74 | 75 | 71 | 64 | SIMON Julien | 73 | 59 | 76 | 50 | 74 | 50 | 75 | 72 | 75 | NAPOLITANO Danilo | 71 | 50 | 53 | 50 | 50 | 58 | 74 | 64 | 50 |
Edited by TankNL on 04-08-2014 14:28
|
|
|
|
TankNL |
Posted on 03-08-2014 23:40
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
updated 4-8-2014; sorted on the stat COBBLES, this is the top 50;
Maximum stat | 80 | 84 | 83 | 83 | 82 | 83 | 82 | 80 | 82 | | | | | | | | | | | | FLAT | MOUNTAIN | HILL | TIMETRAIL | PROLOGUE | COBBLE | SPRINT | ACCELERATION | DOWNHILL | CANCELLARA Fabian | 76 | 53 | 76 | 78 | 80 | 83 | 74 | 80 | 73 | TERPSTRA Niki | 76 | 63 | 74 | 69 | 73 | 83 | 74 | 75 | 74 | SAGAN Peter | 80 | 67 | 81 | 68 | 77 | 83 | 82 | 80 | 78 | VANMARCKE Sep | 76 | 53 | 75 | 50 | 50 | 82 | 74 | 73 | 73 | VAN AVERMAET Greg | 77 | 55 | 79 | 50 | 50 | 81 | 75 | 76 | 78 | DEGENKOLB John | 78 | 54 | 75 | 53 | 50 | 80 | 82 | 75 | 74 | VANDENBERGH Stijn | 73 | 52 | 59 | 50 | 50 | 79 | 59 | 72 | 52 | THOMAS Geraint | 74 | 72 | 74 | 74 | 76 | 78 | 71 | 73 | 73 | BOONEN Tom | 74 | 53 | 62 | 55 | 50 | 78 | 74 | 72 | 54 | LANGEVELD Sebastian | 71 | 51 | 62 | 58 | 73 | 78 | 60 | 72 | 52 | STYBAR Zdenek | 73 | 58 | 75 | 50 | 50 | 77 | 74 | 73 | 73 | KRISTOFF Alexander | 77 | 58 | 76 | 52 | 56 | 77 | 82 | 80 | 55 | BOOM Lars | 72 | 55 | 71 | 74 | 73 | 77 | 74 | 72 | 63 | DEMARE Arnaud | 77 | 60 | 72 | 54 | 50 | 76 | 80 | 72 | 55 | BOZIC Borut | 73 | 53 | 63 | 50 | 73 | 76 | 74 | 72 | 57 | STANNARD Ian | 72 | 55 | 65 | 60 | 50 | 76 | 62 | 72 | 51 | BOASSON HAGEN Edvald | 73 | 53 | 75 | 54 | 75 | 76 | 75 | 75 | 74 | CHAVANEL Sylvain | 74 | 75 | 76 | 77 | 79 | 76 | 74 | 75 | 74 | TURGOT Sébastien | 71 | 51 | 61 | 50 | 73 | 76 | 60 | 71 | 59 | ROELANDTS Jürgen | 73 | 58 | 74 | 51 | 50 | 76 | 74 | 73 | 64 | DRUCKER Jempy | 72 | 56 | 66 | 50 | 77 | 75 | 74 | 72 | 53 | LEUKEMANS Björn | 72 | 57 | 76 | 50 | 50 | 75 | 62 | 73 | 74 | GATTO Oscar | 72 | 51 | 64 | 50 | 50 | 75 | 68 | 71 | 61 | PAOLINI Luca | 72 | 52 | 71 | 50 | 50 | 75 | 73 | 73 | 63 | HAUSSLER Heinrich | 73 | 52 | 56 | 57 | 50 | 75 | 75 | 71 | 53 | KEUKELEIRE Jens | 71 | 52 | 72 | 50 | 50 | 75 | 73 | 72 | 70 | FARRAR Tyler | 73 | 53 | 69 | 50 | 73 | 75 | 78 | 73 | 50 | VAN ASBROECK Tom | 74 | 55 | 74 | 50 | 50 | 75 | 75 | 71 | 73 | DEHAES Kenny | 73 | 51 | 59 | 50 | 50 | 75 | 74 | 58 | 57 | EISEL Bernhard | 72 | 52 | 56 | 50 | 50 | 75 | 73 | 68 | 54 | FUGLSANG Jakob | 72 | 77 | 75 | 60 | 50 | 75 | 68 | 72 | 75 | LADAGNOUS Matthieu | 71 | 53 | 70 | 50 | 66 | 75 | 62 | 72 | 55 | WYNANTS Maarten | 71 | 51 | 59 | 50 | 50 | 75 | 55 | 63 | 59 | HUTAROVICH Yauheni | 73 | 50 | 67 | 50 | 50 | 74 | 76 | 72 | 69 | WIGGINS Bradley | 73 | 76 | 73 | 77 | 78 | 74 | 56 | 72 | 74 | FLECHA GIANNONI Juan Antonio | 71 | 55 | 70 | 50 | 50 | 74 | 69 | 71 | 72 | NIBALI Vincenzo | 76 | 84 | 78 | 77 | 67 | 74 | 73 | 80 | 82 | JEROME Vincent | 74 | 53 | 57 | 50 | 50 | 74 | 53 | 67 | 51 | DEVENYNS Dries | 71 | 61 | 66 | 51 | 75 | 74 | 58 | 71 | 64 | GAUDIN Damien | 67 | 51 | 57 | 52 | 78 | 74 | 52 | 67 | 59 | PETIT Adrien | 72 | 51 | 65 | 50 | 75 | 74 | 75 | 71 | 64 | BURGHARDT Marcus | 71 | 55 | 66 | 50 | 50 | 74 | 58 | 71 | 65 | DE BACKER Bert | 73 | 51 | 63 | 50 | 50 | 74 | 61 | 57 | 68 | OSS Daniel | 71 | 53 | 74 | 66 | 50 | 74 | 73 | 72 | 57 | HUSHOVD Thor | 72 | 53 | 67 | 50 | 50 | 74 | 75 | 72 | 54 | GALLOPIN Tony | 74 | 70 | 78 | 55 | 74 | 74 | 74 | 73 | 77 | PHINNEY Taylor | 71 | 54 | 65 | 75 | 77 | 74 | 73 | 72 | 51 | HAYMAN Mathew | 65 | 51 | 56 | 50 | 50 | 74 | 61 | 66 | 53 | OFFREDO Yoann | 69 | 51 | 60 | 50 | 50 | 74 | 64 | 71 | 54 | TRENTIN Matteo | 72 | 51 | 75 | 50 | 50 | 74 | 74 | 72 | 74 |
Edited by TankNL on 04-08-2014 14:29
|
|
|
|
Adamb |
Posted on 04-08-2014 00:03
|
Domestique
Posts: 642
Joined: 22-08-2013
PCM$: 200.00
|
Majka has done very well to earn the same as Froome and Quintana. But this is a great guide for DB makers. |
|
|
|
Adamb |
Posted on 04-08-2014 00:04
|
Domestique
Posts: 642
Joined: 22-08-2013
PCM$: 200.00
|
Also Contador is very poor for some reason but has don't quite well this season. |
|
|
|
TankNL |
Posted on 04-08-2014 10:52
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
Will try to link the results of my testing to a existing db...
probably the ITA database that has just come out. Will have something to show then. |
|
|
|
zachbastian |
Posted on 04-08-2014 11:05
|
Free Agent
Posts: 131
Joined: 26-07-2010
PCM$: 200.00
|
Hmm, Basso better than JVB and Kelderman! Contador 80 and 15 riders better than him in mo?
Edited by zachbastian on 04-08-2014 11:06
|
|
|
|
MartijnVDD |
Posted on 04-08-2014 11:07
|
Breakaway Specialist
Posts: 801
Joined: 26-06-2012
PCM$: 200.00
|
These stats only take in account results that actually happened, but no results that could have happened. There are always crashes, injuries, illnesses, punctures etc.. |
|
|
|
TankNL |
Posted on 04-08-2014 11:09
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
zachbastian wrote:
Hmm, Basso better than JVB and Kelderman! Contador 80 and 30 riders better than him in mo?
I think you are misreading it.
Contador has 80 MO ... yes I know that is lower than what he normally gets, but his results of the past year have been slim. ( or atleast less then the guys above him).
And Basso has 77, just like Kelderman and JvdB
but I'm still fine-tuning the algorithms to calculate the stats... so any suggestions or even proposed Excel formula's (you can find them in the link a couple posts previous to this 1), are very welcome. |
|
|
|
TankNL |
Posted on 04-08-2014 14:31
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
Updated the stats with new algorithm.
Doubting about the max sprinting... could be set to 82.
Here is also the top 50 of the stat HILL
Maximum stat | 80 | 84 | 83 | 83 | 82 | 83 | 82 | 80 | 82 | | | | | | | | | | | | FLAT | MOUNTAIN | HILL | TIMETRAIL | PROLOGUE | COBBLE | SPRINT | ACCELERATION | DOWNHILL | VALVERDE BELMONTE Alejandro | 78 | 84 | 83 | 75 | 79 | 55 | 74 | 80 | 82 | GILBERT Philippe | 73 | 75 | 82 | 60 | 78 | 52 | 75 | 80 | 75 | KWIATKOWSKI Michal | 75 | 76 | 81 | 76 | 80 | 72 | 74 | 77 | 77 | SAGAN Peter | 80 | 67 | 81 | 68 | 77 | 83 | 82 | 80 | 78 | ULISSI Diego | 74 | 78 | 81 | 75 | 50 | 50 | 66 | 76 | 78 | GERRANS Simon | 73 | 75 | 80 | 50 | 50 | 50 | 73 | 76 | 74 | RODRIGUEZ OLIVER Joaquim | 75 | 83 | 79 | 70 | 50 | 50 | 71 | 76 | 82 | MOLLEMA Bauke | 74 | 80 | 79 | 74 | 73 | 50 | 74 | 77 | 79 | MORENO FERNANDEZ Daniel | 73 | 78 | 79 | 51 | 50 | 50 | 61 | 76 | 77 | VAN AVERMAET Greg | 77 | 55 | 79 | 50 | 50 | 81 | 75 | 76 | 78 | SLAGTER Tom-Jelte | 73 | 64 | 78 | 57 | 74 | 51 | 69 | 73 | 74 | NIBALI Vincenzo | 76 | 84 | 78 | 77 | 67 | 74 | 73 | 80 | 82 | MARTIN Daniel | 72 | 77 | 78 | 52 | 50 | 50 | 58 | 74 | 76 | GALLOPIN Tony | 74 | 70 | 78 | 55 | 74 | 74 | 74 | 73 | 77 | KREUZIGER Roman | 72 | 77 | 77 | 74 | 50 | 50 | 60 | 74 | 75 | GESCHKE Simon | 72 | 70 | 77 | 52 | 67 | 50 | 66 | 72 | 76 | EVANS Cadel | 74 | 78 | 77 | 75 | 75 | 50 | 73 | 74 | 77 | POZZOVIVO Domenico | 73 | 80 | 77 | 75 | 50 | 50 | 54 | 75 | 77 | COSTA Rui Alberto Faria | 74 | 79 | 77 | 75 | 59 | 52 | 73 | 72 | 80 | BARDET Romain | 73 | 79 | 77 | 53 | 50 | 52 | 75 | 75 | 79 | CONTADOR VELASCO Alberto | 74 | 80 | 77 | 76 | 50 | 50 | 73 | 74 | 78 | MARTIN Tony | 75 | 73 | 77 | 83 | 75 | 54 | 73 | 73 | 74 | ALBASINI Michael | 72 | 55 | 77 | 50 | 57 | 50 | 74 | 72 | 75 | MATTHEWS Michael | 72 | 56 | 76 | 61 | 50 | 50 | 76 | 75 | 73 | BAKELANTS Jan | 73 | 75 | 76 | 51 | 50 | 57 | 72 | 73 | 77 | PONZI Simone | 72 | 53 | 76 | 50 | 50 | 53 | 74 | 73 | 76 | MAJKA Rafal | 72 | 83 | 76 | 75 | 50 | 50 | 58 | 76 | 80 | VANENDERT Jelle | 71 | 59 | 76 | 50 | 50 | 50 | 52 | 72 | 73 | GASPAROTTO Enrico | 72 | 58 | 76 | 50 | 59 | 50 | 62 | 72 | 74 | PELLIZOTTI Franco | 72 | 77 | 76 | 68 | 50 | 50 | 58 | 73 | 76 | CANCELLARA Fabian | 76 | 53 | 76 | 78 | 80 | 83 | 74 | 80 | 73 | LEUKEMANS Björn | 72 | 57 | 76 | 50 | 50 | 75 | 62 | 73 | 74 | BETANCUR GOMEZ Carlos Alberto | 72 | 76 | 76 | 60 | 50 | 50 | 67 | 72 | 75 | FINETTO Mauro | 72 | 59 | 76 | 50 | 50 | 52 | 71 | 72 | 74 | GESINK Robert | 73 | 75 | 76 | 53 | 53 | 50 | 64 | 68 | 77 | VOECKLER Thomas | 73 | 75 | 76 | 61 | 50 | 61 | 64 | 72 | 77 | GAUTIER Cyril | 72 | 66 | 76 | 52 | 50 | 50 | 68 | 72 | 75 | CUNEGO Damiano | 72 | 67 | 76 | 53 | 50 | 51 | 59 | 71 | 74 | MEERSMAN Gianni | 74 | 60 | 76 | 52 | 78 | 50 | 75 | 72 | 76 | DUMOULIN Tom | 72 | 75 | 76 | 78 | 81 | 56 | 73 | 73 | 74 | SCARPONI Michele | 72 | 78 | 76 | 65 | 50 | 50 | 58 | 73 | 76 | CARUSO Giampaolo | 71 | 72 | 76 | 50 | 50 | 54 | 52 | 72 | 73 | COLBRELLI Sonny | 72 | 54 | 76 | 56 | 50 | 53 | 74 | 73 | 75 | ROJAS GIL Jose Joaquin | 74 | 71 | 76 | 50 | 50 | 57 | 77 | 72 | 75 | HENAO MONTOYA Sergio Luis | 71 | 76 | 76 | 58 | 50 | 50 | 59 | 72 | 74 | HESJEDAL Ryder | 72 | 76 | 76 | 63 | 73 | 50 | 59 | 72 | 76 | KRISTOFF Alexander | 77 | 58 | 76 | 52 | 56 | 77 | 82 | 80 | 55 | SIMON Julien | 73 | 59 | 76 | 50 | 74 | 50 | 75 | 72 | 75 | CHAVANEL Sylvain | 74 | 75 | 76 | 77 | 79 | 76 | 74 | 75 | 74 | REBELLIN Davide | 71 | 76 | 76 | 52 | 73 | 50 | 58 | 73 | 74 |
|
|
|
|
TankNL |
Posted on 04-08-2014 18:14
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
MartijnVDD wrote:
These stats only take in account results that actually happened, but no results that could have happened. There are always crashes, injuries, illnesses, punctures etc..
@MartijnVDD; you are absolutely right. This is only the scorecard afterwards, not who was the strongest in the race. I always see a lot of subjectivity in the DB's and I wanted to create an extra dimension.
For example, you can argue who's stronger in the mountains; Froome, Contador or Nibali. Fact of the matter is that Nibali has produced more ( better? ) results than the other.
I also said I wasn't creating a new DB, only creating a tool or a platform to give DB creators, more insights.
Tank |
|
|
|
TankNL |
Posted on 04-08-2014 23:19
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
I created a mapping with the PackITA to see how the stats would be altered if I used the created stats from actual results. Every stat column is followed by my stat (in orange) and the followed by the difference (in green).
https://dl.dropbo...20map.xlsx
I haven't created a .cdb, but that can easily done.
I did also 1 other thing (something I also did previously for the PCMDaily database); the popularity of a cyclist. I calculated the popularity based on the CQ points collected over the last years. This can easily be altered in the database so that the sponsor reacts correctly to the riders in the team.
I will do the A.S.O. DB 2014 of OlegTinkov next.
Tank |
|
|
|
Paul23 |
Posted on 04-08-2014 23:58
|
Grand Tour Specialist
Posts: 4411
Joined: 10-08-2011
PCM$: 400.00
|
Valverde 84 MO? Sagan Best Sprinter? Tony Martin just 75 Flat? Sagan 83 Cobble?
did i miss that much this year?
|
|
|
|
dacolik |
Posted on 05-08-2014 00:03
|
Junior Rider
Posts: 43
Joined: 21-06-2013
PCM$: 200.00
|
because of this year's results Contador should get the best MO... This is really bad database... |
|
|
|
TankNL |
Posted on 05-08-2014 00:29
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
first off, it is not a database.
second... it only the number of points scored in races of a certain kind by a rider.
And yes the races younger the 365 are counted times 4, the races older the 720 are counted once and between get 2 points.
Then when you look at the results in this year... these are the figures... not saying that this should also be the stats, but... those are the results.
as for SAGAN;
category | date | race_name | race_type | result | COBBLE | GT1s | 9-7-2014 | Tour de France, Stage 5 : Ieper (Bel) - Arenberg (156 km) | Cobbles | 4 | 173,6 | 1.WT1 | 13-4-2014 | Paris - Roubaix (257 km) | Cobbles | 6 | 280 | 1.WT1 | 6-4-2014 | Ronde van Vlaanderen (259 km) | CobbleHills | 16 | 70,4 | 2.HCs | 2-4-2014 | Driedaagse De Panne-Koksijde, Stage 2 : Zottegem - Koksijde (206 km) | CobbleSprint | DNF | 0 | 2.HCs | 1-4-2014 | Driedaagse De Panne-Koksijde, Stage 1 : De Panne - Zottegem (201 km) | CobbleSprint | 1 | 39,2 | 1.WT2 | 30-3-2014 | Gent - Wevelgem (233 km) | CobbleSprint | 3 | 156,8 | 1.WT2 | 28-3-2014 | E3 Prijs Vlaanderen - Harelbeke (211 km) | CobbleSprint | 1 | 308 | 1.WT1 | 31-3-2013 | Ronde van Vlaanderen (256,2 km) | CobbleHills | 2 | 187 | 1.WT2 | 24-3-2013 | Gent - Wevelgem (185 km) | CobbleSprint | 1 | 154 | 1.WT2 | 22-3-2013 | E3 Prijs Vlaanderen - Harelbeke (211 km) | CobbleHills | 2 | 145,2 | 2.HCs | 26-3-2013 | Driedaagse De Panne-Koksijde, Stage 1 : Middelkerke - Zottegem (199,8 km) | CobbleHills | 1 | 30,8 | 1.1 | 2-3-2013 | Strade Bianche (188 km) | CobbleHills | 2 | 52,8 |
|
|
|