calculated stats based on FINAL results
|
TankNL |
Posted on 10-05-2015 22:14
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
bob7 wrote:
Majka 82 MO, Scarponi 79 MO Chavanel 80 TT, Bouhanni 82 SP, Van Avermaet 82 COB ? I'm Polish but WTF, I won't give Majka that great stat not to mention the other examples.
This prove that this calculated stats doesn't work perfectly. It's very helpful but need to be improved.
It is stats based on Final results. So in Majka's case this performance last year in the TdF where he had stage wins and the polkadot jersey. This was doen by him trough attacking, but the calculation can't filter that. As for the other examples many good results lead to a high stat in that area. |
|
|
|
Ad Bot |
Posted on 22-11-2024 07:09
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
IP: None |
|
|
udoi |
Posted on 11-05-2015 10:53
|
Protected Rider
Posts: 1165
Joined: 16-05-2013
PCM$: 200.00
|
Wonderful project ... congratulations |
|
|
|
TankNL |
Posted on 12-05-2015 16:57
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
hoping to add 610 results from 2014 later today.
All .2 or .2U or .NE results.
Lots of work catorigizing every result, but slowly getting there.
Will give more indepth stats to the upcomming / unknown / new cyslist I hope. |
|
|
|
DiCyc |
Posted on 12-05-2015 16:59
|
Sprinter
Posts: 1636
Joined: 09-03-2015
PCM$: 200.00
|
How does the calculation happens? |
|
|
|
TankNL |
Posted on 12-05-2015 18:10
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
Download the excel en see for yourself. It is all "open source" |
|
|
|
TankNL |
Posted on 12-05-2015 18:10
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
Download the excel en see for yourself. It is all "open source" |
|
|
|
asero |
Posted on 12-05-2015 23:55
|
Amateur
Posts: 9
Joined: 25-11-2014
PCM$: 200.00
|
How can I use the updated Stats in my PCM?
I want to play with a more realistic/updated skillset of riders.
Thanks |
|
|
|
TankNL |
Posted on 13-05-2015 09:55
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
Like it states here, it is based of JesGD2015 so I've used his DB and filled it with my stats. I did this though mapping the rider_id's with the id's of the cyclist in my Excel.
This process can ofcourse be done by you in a db of your own preference.
Edited by TankNL on 13-05-2015 10:11
|
|
|
|
TankNL |
Posted on 13-05-2015 10:39
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
new Excel file uploaded;
- 3146 results captured and categorized
- all World Tour results of 2011
- all WT, .HC and .1 results of 2012 and 2013
- all WT, .HC, .1, .2, .2U and .NE results of 2014 until now
- created stats for 5575 cyclist based on those results
link; https://dl.dropboxusercontent.com/u/4...%20v2.xlsx
- personal note; only 9 cyclist changed according to personal preference when uploaded into a database, rest is calculated by the algorithm's
Edited by TankNL on 16-05-2015 10:32
|
|
|
|
DiCyc |
Posted on 13-05-2015 11:22
|
Sprinter
Posts: 1636
Joined: 09-03-2015
PCM$: 200.00
|
TankNL wrote:
Download the excel en see for yourself. It is all "open source"
I should maybe turn my computer on... |
|
|
|
TankNL |
Posted on 13-05-2015 12:26
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
DiCyc wrote:
TankNL wrote:
Download the excel en see for yourself. It is all "open source"
I should maybe turn my computer on...
I you have questions or better yet tips on how the calculations could work better, feel free to discuss here. |
|
|
|
Captain CoinCoin |
Posted on 19-05-2015 11:44
|
Amateur
Posts: 13
Joined: 26-07-2008
PCM$: 200.00
|
I see that Alaphilippe stats does not truly represent its current skills. A solution may be to create a degressive discount for older results of young cyclists (the effect disappearing at 25). And conversely a progressive discount for older results of older cyclists (the effect kicking in at 30). |
|
|
|
TankNL |
Posted on 31-05-2015 22:39
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
I did the Giro update (and all the other races for that matter) and here is the new stats based on FINAL results (of last 4 years);
Top GC contenders overall; (sorted on Mountains and TT)
nr | CyclistName | FLA | MOU | HIL | TT | PRO | COB | SPR | ACC | DWN | FTR | STA | RES | REC | POP | 1 | FROOME | 78 | 83 | 78 | 80 | 78 | 61 | 66 | 75 | 78 | 69 | 78 | 74 | 82 | 87 | 2 | CONTADOR | 77 | 83 | 79 | 79 | 76 | 61 | 68 | 77 | 77 | 69 | 79 | 77 | 82 | 90 | 3 | NIBALI | 76 | 83 | 79 | 77 | 68 | 73 | 68 | 76 | 78 | 69 | 79 | 77 | 82 | 87 | 4 | QUINTANA | 74 | 83 | 78 | 75 | 63 | 60 | 63 | 74 | 75 | 69 | 78 | 75 | 81 | 86 | 5 | RODRIGUEZ | 76 | 82 | 82 | 75 | 67 | 60 | 70 | 78 | 79 | 70 | 81 | 79 | 81 | 90 | 6 | ARU | 71 | 82 | 77 | 68 | 62 | 59 | 66 | 75 | 73 | 77 | 78 | 75 | 80 | 83 | 7 | VALVERDE | 78 | 81 | 82 | 75 | 75 | 62 | 74 | 80 | 80 | 71 | 82 | 80 | 82 | 90 | 8 | PINOT | 74 | 81 | 78 | 74 | 74 | 61 | 67 | 74 | 75 | 69 | 78 | 74 | 80 | 84 | 9 | URAN | 75 | 80 | 79 | 78 | 70 | 61 | 68 | 74 | 75 | 78 | 78 | 77 | 79 | 84 | 10 | VAN GARDEREN | 75 | 80 | 76 | 78 | 74 | 60 | 65 | 73 | 74 | 69 | 76 | 74 | 79 | 84 | 11 | PORTE | 75 | 80 | 78 | 77 | 74 | 63 | 67 | 75 | 75 | 69 | 77 | 74 | 79 | 85 | 12 | PERAUD | 74 | 80 | 75 | 75 | 74 | 59 | 66 | 73 | 74 | 69 | 75 | 74 | 79 | 83 | 13 | MOLLEMA | 75 | 80 | 79 | 74 | 70 | 61 | 70 | 75 | 78 | 70 | 79 | 78 | 79 | 85 | 14 | KÖNIG | 71 | 80 | 74 | 74 | 62 | 59 | 64 | 73 | 67 | 68 | 75 | 73 | 79 | 81 | 15 | NIEVE | 73 | 80 | 75 | 70 | 67 | 59 | 68 | 74 | 74 | 77 | 76 | 74 | 79 | 82 | 16 | MORENO | 74 | 80 | 80 | 69 | 67 | 52 | 66 | 78 | 75 | 78 | 79 | 78 | 79 | 85 | 17 | HESJEDAL | 73 | 80 | 78 | 68 | 65 | 59 | 68 | 75 | 74 | 77 | 78 | 75 | 80 | 82 | 18 | LANDA | 68 | 80 | 74 | 65 | 60 | 51 | 64 | 74 | 71 | 76 | 77 | 73 | 80 | 81 | 19 | COSTA | 77 | 79 | 81 | 75 | 67 | 62 | 74 | 75 | 79 | 71 | 80 | 79 | 79 | 88 | 20 | EVANS | 74 | 79 | 78 | 75 | 73 | 60 | 67 | 73 | 75 | 69 | 76 | 75 | 78 | 83 |
Spoiler nr | CyclistName | FLA | MOU | HIL | TT | PRO | COB | SPR | ACC | DWN | FTR | STA | RES | REC | POP | 21 | KANGERT | 73 | 79 | 74 | 75 | 63 | 60 | 66 | 73 | 73 | 75 | 75 | 73 | 78 | 81 | 22 | POZZOVIVO | 73 | 79 | 78 | 74 | 70 | 61 | 63 | 74 | 73 | 68 | 77 | 76 | 79 | 83 | 23 | KREUZIGER | 73 | 79 | 78 | 74 | 66 | 59 | 65 | 75 | 71 | 76 | 78 | 77 | 78 | 82 | 24 | MONFORT | 73 | 79 | 74 | 74 | 70 | 59 | 69 | 73 | 69 | 75 | 74 | 71 | 79 | 76 | 25 | MAJKA | 73 | 79 | 78 | 73 | 63 | 62 | 65 | 75 | 75 | 69 | 78 | 75 | 78 | 84 | 26 | VAN DEN BROECK | 71 | 79 | 75 | 73 | 65 | 60 | 69 | 74 | 68 | 75 | 74 | 73 | 79 | 81 | 27 | TROFIMOV | 73 | 79 | 76 | 69 | 66 | 60 | 73 | 74 | 74 | 77 | 76 | 74 | 78 | 81 | 28 | TEN DAM | 69 | 79 | 74 | 69 | 67 | 60 | 67 | 73 | 67 | 75 | 74 | 70 | 78 | 69 | 29 | ROLLAND | 69 | 79 | 74 | 68 | 62 | 59 | 67 | 74 | 73 | 68 | 75 | 73 | 78 | 81 | 30 | BARDET | 74 | 79 | 79 | 66 | 61 | 61 | 69 | 75 | 75 | 78 | 78 | 77 | 79 | 84 | 31 | HORNER | 66 | 79 | 74 | 64 | 61 | 59 | 63 | 70 | 69 | 68 | 74 | 69 | 79 | 74 | 32 | KWIATKOWSKI | 78 | 78 | 81 | 77 | 79 | 73 | 73 | 77 | 79 | 69 | 79 | 79 | 78 | 86 | 33 | TALANSKY | 73 | 78 | 75 | 75 | 73 | 60 | 65 | 67 | 74 | 68 | 74 | 73 | 78 | 81 | 34 | KELDERMAN | 74 | 78 | 77 | 74 | 75 | 61 | 68 | 73 | 74 | 68 | 75 | 75 | 78 | 82 | 35 | ROCHE | 74 | 78 | 75 | 74 | 65 | 59 | 69 | 74 | 74 | 76 | 76 | 74 | 77 | 81 | 36 | FUGLSANG | 74 | 78 | 78 | 73 | 64 | 74 | 65 | 74 | 75 | 77 | 76 | 76 | 78 | 82 | 37 | KRUIJSWIJK | 73 | 78 | 75 | 73 | 64 | 60 | 68 | 73 | 74 | 77 | 75 | 74 | 82 | 81 | 38 | INTXAUSTI | 73 | 78 | 78 | 70 | 66 | 62 | 66 | 74 | 74 | 76 | 76 | 75 | 76 | 82 | 39 | ROGERS | 73 | 78 | 75 | 70 | 64 | 60 | 69 | 73 | 73 | 76 | 75 | 74 | 78 | 81 | 40 | AMADOR | 73 | 78 | 74 | 70 | 69 | 66 | 67 | 73 | 73 | 75 | 74 | 73 | 76 | 62 | 41 | CARUSO | 73 | 78 | 75 | 68 | 69 | 52 | 69 | 74 | 74 | 77 | 75 | 74 | 78 | 81 | 42 | SCARPONI | 70 | 78 | 76 | 68 | 65 | 60 | 67 | 74 | 73 | 76 | 76 | 74 | 77 | 81 | 43 | NIEMIEC | 71 | 78 | 76 | 68 | 64 | 60 | 69 | 74 | 73 | 76 | 75 | 74 | 75 | 76 | 44 | ZUBELDIA | 68 | 78 | 74 | 67 | 61 | 59 | 65 | 69 | 69 | 75 | 74 | 73 | 78 | 60 | 45 | MARTIN | 75 | 78 | 80 | 66 | 67 | 62 | 69 | 75 | 78 | 70 | 79 | 78 | 78 | 85 | 46 | CARDOSO | 67 | 78 | 74 | 66 | 62 | 53 | 65 | 73 | 68 | 75 | 74 | 73 | 76 | 59 | 47 | GENIEZ | 66 | 78 | 74 | 66 | 61 | 53 | 67 | 74 | 65 | 67 | 74 | 71 | 76 | 55 | 48 | KISERLOVSKI | 65 | 78 | 75 | 65 | 63 | 59 | 64 | 73 | 64 | 74 | 74 | 73 | 76 | 60 | 49 | NAVARRO | 67 | 78 | 74 | 64 | 63 | 59 | 63 | 66 | 73 | 68 | 74 | 70 | 78 | 60 | 50 | SANCHEZ | 73 | 77 | 78 | 73 | 62 | 59 | 66 | 74 | 74 | 77 | 77 | 76 | 78 | 82 |
|
|
|
|
TankNL |
Posted on 31-05-2015 23:52
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
new Excel file uploaded;
- 3959 results captured and categorized
- all World Tour results of 2011
- all WT, .HC and .1 results of 2012
- all WT, .HC, .1, .2, .2U and .NE results of 2013 until now
- created stats for 6119 cyclist based on those results
link; https://dl.dropboxusercontent.com/u/4...%20v3.xlsx
- personal note; only 15 cyclist changed according to personal preference (and Giro fever but will tune that down, in next update) when uploaded into a database, rest is calculated by the algorithm's |
|
|
|
DwayneWade1982 |
Posted on 19-06-2015 17:20
|
Amateur
Posts: 1
Joined: 15-06-2015
PCM$: 200.00
|
Hey TankNL,
i read all 12 Pages of this Thread. My English is not the best.
Great Compliment for the idea and the Excel you made.
Now i have a Question. How can i transfer your last file to an database. I want to begin a new Career with your last uodate and the JESGD v2.0 . You only had uploaded a JESGS 1.75v Database |
|
|
|
Jesper_DBLL |
Posted on 21-06-2015 14:57
|
Amateur
Posts: 9
Joined: 17-03-2009
PCM$: 600.00
|
Hey TankNL,
I use the JESGS db as well. Would you like to upload a new .cdb file with the current stats (or your "personal note" cdb ) |
|
|
|
TankNL |
Posted on 25-06-2015 08:45
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
Hi DwayneWade1982 and Jesper_DBLL,
Thanks for the compliments and the interest!
I will try to create a new .cdb based on the 2.0 version of JesGD
Hope to have it done by monday, but will have to see how much time I have this weekend.
Will then also post an update with the results up to now "pre- Tour de France".
Tank |
|
|
|
Jesper_DBLL |
Posted on 26-06-2015 07:40
|
Amateur
Posts: 9
Joined: 17-03-2009
PCM$: 600.00
|
I'm looking forward to it Thanx |
|
|
|
TankNL |
Posted on 26-06-2015 21:49
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
new Excel file uploaded;
- 4105 results captured and categorized
- all World Tour results of 2011
- all WT, .HC and .1 results of 2012
- all WT, .HC, .1, .2, .2U and .NE results of 2013 until now
- created stats for 6223 cyclist based on those results
link; https://dl.dropboxusercontent.com/u/4...%20v3.xlsx
- personal note; only 16 cyclist changed according to personal preference when uploaded into a database, rest is calculated by the algorithm's
- thought about editing Kittel, but left him as-is from the algorithm... so now he's 81 in sprint
- also created a new .cdb with v2 of JesGD database as a master... so all credits go to him for the database; https://dl.dropboxusercontent.com/u/4...erion3.cdb |
|
|
|
Jesper_DBLL |
Posted on 27-06-2015 01:44
|
Amateur
Posts: 9
Joined: 17-03-2009
PCM$: 600.00
|
Nice thanx. I've downloaded it and I'm going to give it a try. Looking forward to it ;-) |
|
|