|
calculated stats based on FINAL results
|
| ContadorVelasco |
Posted on 12-08-2014 04:16
|
Under 23
Posts: 53
Joined: 27-07-2014
PCM$: 200.00
|
stage 10 |
| |
|
|
| zachbastian |
Posted on 12-08-2014 07:34
|
Free Agent
Posts: 125
Joined: 26-07-2010
PCM$: 200.00
|
must say that the test race by OlegTinkov looks promising! Good work TankNL |
| |
|
|
| TankNL |
Posted on 17-08-2014 22:15
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
I created a new matrix for the stats, file is attached here;
https://dl.dropbo...%20v4.xlsx
I also put the matrix in a database again;
https://dl.dropbo...lStats.cdb
Like last time i did a couple of adjustments on individual's;
Mountains;
Valverde 83 -> 81
Rodriguez 82 -> 81
Nibali 83 -> 82
Contador 81 -> 82
Froome 81 -> 82
Peraud 80 -> 81
ten Dam 78 -> 79 (I'm dutch  )
Hills;
Valverde 83 -> 81
Sagan 81 -> 79
Timetrail;
Tom Dumoulin 80 -> 82
Cancellara 80 -> 81
Cobbles
Cancellara 83 -> 82
Terpstra 83 -> 82
Sagan 81 -> 80
Sprints
Cavendish 82 -> 83
Sagan 83 -> 81
Fighter
Voigt 72 -> 80
Voeckler 76 -> 81
So only adjusted the stats on 14 riders, rest is all calculated based on actual results, from 1-1-2012 to 10-8-2014
I will do a update of the stats next week, just before the Vuelta.
Edited by TankNL on 17-08-2014 22:52
|
| |
|
|
| TankNL |
Posted on 18-08-2014 23:15
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
Adjusted the files including the .cdb with the races up until last weekend.
file in the links are updated;
Excel; https://dl.dropbo...%20v4.xlsx
Database; https://dl.dropbo...lStats.cdb
|
| |
|
|
| OlegTinkov |
Posted on 18-08-2014 23:47
|
Classics Specialist
Posts: 2873
Joined: 31-12-2007
PCM$: 450.00
|
Thanks!
|
| |
|
|
| TankNL |
Posted on 19-08-2014 00:14
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
I will create a new update on the 25th including;
| 18/08/2014 | | 24/08/2014 | | 2.HC | | Usa | | USA Pro Challenge - Tour of Colorado | | 19/08/2014 | | | | 1.1 | | Bel | | GP Stad Zottegem | | 19/08/2014 | | 22/08/2014 | | 2.1 | | Fra | | Tour du Limousin | | 22/08/2014 | | | | 1.1 | | Ned | | Arnhem - Veenendaal Classic | | 24/08/2014 | | | | 1.WT2 | | Ger | | Vattenfall Cyclassics - Hamburg | | 24/08/2014 | | | | 1.1 | | Fra | | Châteauroux Classic de l'Indre - Trophée Fenioux |
Edited by TankNL on 19-08-2014 00:15
|
| |
|
|
| TankNL |
Posted on 03-09-2014 19:28
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
For those who are interested, created a update with races up until this weekend and a special worksheet to see how the riders will evolve during the Vuelta; so stat changes due to the Vuelta.
https://dl.dropbo...%20v4.xlsx
If somebody is interested, I could put this in a database again.
Edited by TankNL on 03-09-2014 19:28
|
| |
|
|
| Macimate |
Posted on 03-09-2014 19:55
|
Free Agent
Posts: 124
Joined: 15-07-2008
PCM$: 200.00
|
Hey Tank, I remember you from the PPBD-forums. Nice to see veterans still having a crack at it.
Great concept by the way, I'm very interested in this. Would be cool if PCMdaily incorporated you into the next big release |
| |
|
|
| Ad Bot |
Posted on 13-09-2026 16:49
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| TankNL |
Posted on 03-09-2014 22:45
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
Macimate wrote:
Hey Tank, I remember you from the PPBD-forums. Nice to see veterans still having a crack at it.
Great concept by the way, I'm very interested in this. Would be cool if PCMdaily incorporated you into the next big release
Yup, have been in the "PCM world" from cycling manager 2 or 3
And joined the PPDB a long time ago... had some great discussion back then with Pimmen, who's the one and only stats-master 
But started with this project 3 years ago and every summer I add more code in order to make it better... still not entirely satisfied, but get the feeling that it is becoming better and better. Especially below the top 10/ top 20. I play a carreer with it and it play's really well. |
| |
|
|
| TankNL |
Posted on 04-09-2014 18:44
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
After heated discussions about the cobble stats of a number of riders, but especially Tim Wellens, I altered the point allocation for the GC in a WT2 stage race.
Now Tim Wellens has the following stats;
| CyclistName | FLA | MOU | HIL | TT | PRO | COB | SPR | ACC | DWN | FTR | STA | RES | REC | POP | | WELLENS Tim | 72 | 71 | 76 | 69 | 69 | 69 | 69 | 70 | 78 | 75 | 74 | 76 | 71 | 79 | | previous; | | WELLENS Tim | 72 | 71 | 76 | 69 | 69 | 56 | 69 | 70 | 78 | 75 | 74 | 76 | 71 | 79 |
Edited by TankNL on 04-09-2014 18:46
|
| |
|
|
| admirschleck |
Posted on 04-09-2014 18:48
|
Team Leader
Posts: 6566
Joined: 11-10-2010
PCM$: 200.00
|
That should be perfectly accurate. I agree that COB stats shouldn't be higher for the guys that just "survived" cobbles at certain races and won them afterwards, while of course, they should be for some guys that are specialists in some other aspects of cycling, but do good on them. Nibali is a great example.
Anyhow, I really like this system. Just keep it up!
|
| |
|
|
| matt17br |
Posted on 04-09-2014 18:52
|
Directeur Sportif
Posts: 10519
Joined: 28-09-2013
PCM$: 200.00
|
TankNL wrote:
After heated discussions about the cobble stats of a number of riders, but especially Tim Wellens, I altered the point allocation for the GC in a WT2 stage race.
Now Tim Wellens has the following stats;
| CyclistName | FLA | MOU | HIL | TT | PRO | COB | SPR | ACC | DWN | FTR | STA | RES | REC | POP | | WELLENS Tim | 72 | 71 | 76 | 69 | 69 | 69 | 69 | 70 | 78 | 75 | 74 | 76 | 71 | 79 | | previous; | | WELLENS Tim | 72 | 71 | 76 | 69 | 69 | 56 | 69 | 70 | 78 | 75 | 74 | 76 | 71 | 79 |
You are amazing. |
| |
|
|
| TankNL |
Posted on 04-09-2014 18:52
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
admirschleck wrote:
That should be perfectly accurate. I agree that COB stats shouldn't be higher for the guys that just "survived" cobbles at certain races and won them afterwards, while of course, they should be for some guys that are specialists in some other aspects of cycling, but do good on them. Nibali is a great example.
Anyhow, I really like this system. Just keep it up!
Thanks for the support. Due to the second place in the cobble stage of the TdF, Nibali does have a 73 in Cobbles, as does Fuglsang. Nothing manipulated there, just the points the gathered in a stage. Also Wiggins has a 73, due to his top10 place in Paris-Roubaix |
| |
|
|
| depeche92 |
Posted on 04-09-2014 19:20
|
Domestique
Posts: 451
Joined: 24-08-2009
PCM$: 200.00
|
TankNL wrote:
After heated discussions about the cobble stats of a number of riders, but especially Tim Wellens, I altered the point allocation for the GC in a WT2 stage race.
Now Tim Wellens has the following stats;
| CyclistName | FLA | MOU | HIL | TT | PRO | COB | SPR | ACC | DWN | FTR | STA | RES | REC | POP | | WELLENS Tim | 72 | 71 | 76 | 69 | 69 | 69 | 69 | 70 | 78 | 75 | 74 | 76 | 71 | 79 | | previous; | | WELLENS Tim | 72 | 71 | 76 | 69 | 69 | 56 | 69 | 70 | 78 | 75 | 74 | 76 | 71 | 79 |
His mountain stat is still wrong though. He should be 74 or 75
And also better Acc
Edited by depeche92 on 04-09-2014 19:22
|
| |
|
|
| TankNL |
Posted on 04-09-2014 19:28
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
have created 2 .cdb's, both based on PCMDailyEP 1.2
- 1 with the raw stats, no edit's; https://dl.dropbo...atsRaw.cdb
- 1 with a couple of changes for my own private liking; https://dl.dropbo...dStats.cdb |
| |
|
|
| TankNL |
Posted on 04-09-2014 19:46
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
depeche92 wrote:
TankNL wrote:
After heated discussions about the cobble stats of a number of riders, but especially Tim Wellens, I altered the point allocation for the GC in a WT2 stage race.
Now Tim Wellens has the following stats;
| CyclistName | FLA | MOU | HIL | TT | PRO | COB | SPR | ACC | DWN | FTR | STA | RES | REC | POP | | WELLENS Tim | 72 | 71 | 76 | 69 | 69 | 69 | 69 | 70 | 78 | 75 | 74 | 76 | 71 | 79 | | previous; | | WELLENS Tim | 72 | 71 | 76 | 69 | 69 | 56 | 69 | 70 | 78 | 75 | 74 | 76 | 71 | 79 |
His mountain stat is still wrong though. He should be 74 or 75
And also better Acc
kinda curious why you think that. Can't seem to find the results to support that. He did some breakaway's in the Giro and got nice results with them, but other than that? Personally I would give him high potential atleast 7, in order for him to grow to that level. |
| |
|
|
| depeche92 |
Posted on 04-09-2014 19:54
|
Domestique
Posts: 451
Joined: 24-08-2009
PCM$: 200.00
|
TankNL wrote:
depeche92 wrote:
TankNL wrote:
After heated discussions about the cobble stats of a number of riders, but especially Tim Wellens, I altered the point allocation for the GC in a WT2 stage race.
Now Tim Wellens has the following stats;
| CyclistName | FLA | MOU | HIL | TT | PRO | COB | SPR | ACC | DWN | FTR | STA | RES | REC | POP | | WELLENS Tim | 72 | 71 | 76 | 69 | 69 | 69 | 69 | 70 | 78 | 75 | 74 | 76 | 71 | 79 | | previous; | | WELLENS Tim | 72 | 71 | 76 | 69 | 69 | 56 | 69 | 70 | 78 | 75 | 74 | 76 | 71 | 79 |
His mountain stat is still wrong though. He should be 74 or 75
And also better Acc
kinda curious why you think that. Can't seem to find the results to support that. He did some breakaway's in the Giro and got nice results with them, but other than that? Personally I would give him high potential atleast 7, in order for him to grow to that level.
He was 9th at Grappa MTT that is enough |
| |
|
|
| TankNL |
Posted on 04-09-2014 21:20
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
sorry, made error when editing....
here are the 1.2 files...
Raw stats; https://dl.dropbo...atsRaw.cdb
private edit; https://dl.dropbo...dStats.cdb |
| |
|
|
| Ulrich Ulriksen |
Posted on 06-09-2014 16:34
|
Directeur Sportif
Posts: 4339
Joined: 02-11-2010
PCM$: 300.00
|
Interesting work as always. Don't have '14 so I can't test for you. But will get it at some point.
Two ideas:
1. Not sure if/how you resolved the issue of young improving or old declining riders getting earlier periods over-weighted. But the thought I had was that you could look at their base results and then use a different weighting of the years based on the trend. If the rider had improved from 2012 to 2013 to 2014 by more than X%each year you flag them as improving and overweight 2014, same if they got consistently worse. But if they bounced around you use more of a straight average of the years. This would also avoid penalizing a rider who was injured in the current year too much or rewarding a rider who had one great year too much.
2. Would be cool to combine this with my fictionalized database. Instead of me generating randomized PCM stats I would create 3 years of race results based on general rider types. Then run them through your algorithm to generate game ratings. This would have two advantages over my current process (1) would benefit from the great stat stability in your system and (2) it would create history so that when you start a game you have 3 years of history built in. A lot of challenges to this in creating good results history but something for me to think about. Does your system rely only on stage results or does it also factor in the overall Tour results for stage races? |
| |
|
|
| TankNL |
Posted on 14-09-2014 23:17
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
Created an updated based on all the results up until the 15th September.
link to the Excel file; https://dl.dropbo...%20v6.xlsm
The top 10 GC Vuelta and their changes;
Spoiler | nr | CyclistName | FLA | MOU | HIL | TT | PRO | COB | SPR | ACC | DWN | FTR | STA | RES | REC | POP | | 1 | CONTADOR | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 0 | | 1 | CONTADOR | 79 | 82 | 79 | 79 | 73 | 69 | 73 | 79 | 80 | 71 | 79 | 81 | 82 | 86 | | 2 | FROOME | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | | 2 | FROOME | 79 | 82 | 79 | 81 | 78 | 71 | 73 | 79 | 80 | 71 | 79 | 80 | 82 | 85 | | 3 | VALVERDE | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | | 3 | VALVERDE | 79 | 82 | 82 | 78 | 79 | 71 | 74 | 81 | 82 | 72 | 82 | 82 | 82 | 87 | | 4 | RODRIGUEZ | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 1 | 2 | 0 | 0 | | 4 | RODRIGUEZ | 79 | 82 | 82 | 76 | 73 | 68 | 72 | 80 | 82 | 73 | 82 | 82 | 81 | 87 | | 5 | ARU | 1 | 1 | 2 | 0 | 5 | 0 | 4 | 3 | 1 | 6 | 3 | 2 | 0 | 0 | | 5 | ARU | 72 | 80 | 75 | 73 | 55 | 54 | 71 | 77 | 77 | 75 | 78 | 78 | 79 | 80 | | 6 | SANCHEZ | 1 | 0 | 0 | 3 | 0 | 0 | 1 | 2 | 1 | 0 | 0 | 1 | 0 | 0 | | 6 | SANCHEZ | 76 | 79 | 79 | 77 | 71 | 56 | 72 | 78 | 78 | 76 | 78 | 79 | 79 | 81 | | 7 | MARTIN | 1 | 2 | 0 | 0 | 16 | 0 | 2 | 1 | 0 | 7 | 1 | 1 | 1 | 1 | | 7 | MARTIN | 76 | 79 | 80 | 71 | 71 | 71 | 71 | 78 | 79 | 77 | 79 | 79 | 78 | 82 | | 8 | BARGUIL | 0 | 2 | 1 | 5 | 1 | 0 | 1 | 2 | 1 | 0 | 1 | 2 | 2 | 5 | | 8 | BARGUIL | 73 | 76 | 75 | 71 | 53 | 59 | 72 | 75 | 75 | 74 | 73 | 76 | 74 | 69 | | 9 | CARUSO | 1 | 2 | 1 | 0 | 16 | 0 | 1 | 3 | 0 | 1 | 1 | 2 | 2 | 0 | | 9 | CARUSO | 75 | 76 | 76 | 72 | 71 | 51 | 73 | 77 | 78 | 76 | 74 | 78 | 77 | 80 | | 10 | NAVARRO | 1 | 2 | 1 | 1 | 0 | 0 | 4 | 2 | 0 | 0 | 2 | 3 | 1 | 1 | | 10 | NAVARRO | 73 | 78 | 74 | 72 | 72 | 54 | 67 | 74 | 78 | 70 | 75 | 78 | 77 | 79 | |
Top25 of all categories will follow, but can be seen in the Excel file already
Edited by TankNL on 14-09-2014 23:19
|
| |
|
