PCM.daily banner
29-09-2024 16:23
PCM.daily
Users Online
· Guests Online: 37

· Members Online: 2
Ollfardh, Caspi

· Total Members: 161,118
· Newest Member: emeric7444
View Thread
PCM.daily » Pro Cycling Manager 2006-2020 » Pro Cycling Manager 2014
 Print Thread
calculated stats based on FINAL results
TankNL
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 Grin 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.
 
udoi
Wonderful project ... congratulations
 
https://www.youtube.com/watch?v=8km8B7A0L9Y
TankNL
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
How does the calculation happens?
 
TankNL
Download the excel en see for yourself. It is all "open source" Cool
 
Ad Bot
Posted on 29-09-2024 16:23
Bot Agent

Posts: Countless
Joined: 23.11.09

IP: None  
TankNL
Download the excel en see for yourself. It is all "open source" Cool
 
asero
How can I use the updated Stats in my PCM?
I want to play with a more realistic/updated skillset of riders.

Thanks
 
TankNL
TankNL wrote:
for those who are interested; my .cdb file based of JesGD2015 version 1.75 db (all credits to him) and filled with my calculated stats; https://dl.dropboxusercontent.com/u/4...erion2.cdb


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
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
TankNL wrote:
Download the excel en see for yourself. It is all "open source" Cool

I should maybe turn my computer on...Smile
 
TankNL
DiCyc wrote:
TankNL wrote:
Download the excel en see for yourself. It is all "open source" Cool

I should maybe turn my computer on...Smile


I you have questions or better yet tips on how the calculations could work better, feel free to discuss here.
 
Captain CoinCoin
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
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)
nrCyclistNameFLAMOUHILTTPROCOBSPRACCDWNFTRSTARESRECPOP
1FROOME 7883788078616675786978748287
2CONTADOR 7783797976616877776979778290
3NIBALI 7683797768736876786979778287
4QUINTANA 7483787563606374756978758186
5RODRIGUEZ 7682827567607078797081798190
6ARU 7182776862596675737778758083
7VALVERDE 7881827575627480807182808290
8PINOT 7481787474616774756978748084
9URAN 7580797870616874757878777984
10VAN GARDEREN 7580767874606573746976747984
11PORTE 7580787774636775756977747985
12PERAUD 7480757574596673746975747983
13MOLLEMA 7580797470617075787079787985
14KÖNIG 7180747462596473676875737981
15NIEVE 7380757067596874747776747982
16MORENO 7480806967526678757879787985
17HESJEDAL 7380786865596875747778758082
18LANDA 6880746560516474717677738081
19COSTA 7779817567627475797180797988
20EVANS 7479787573606773756976757883

Spoiler
nrCyclistNameFLAMOUHILTTPROCOBSPRACCDWNFTRSTARESRECPOP
21KANGERT 7379747563606673737575737881
22POZZOVIVO 7379787470616374736877767983
23KREUZIGER 7379787466596575717678777882
24MONFORT 7379747470596973697574717976
25MAJKA 7379787363626575756978757884
26VAN DEN BROECK7179757365606974687574737981
27TROFIMOV 7379766966607374747776747881
28TEN DAM 6979746967606773677574707869
29ROLLAND 6979746862596774736875737881
30BARDET 7479796661616975757878777984
31HORNER 6679746461596370696874697974
32KWIATKOWSKI 7878817779737377796979797886
33TALANSKY 7378757573606567746874737881
34KELDERMAN 7478777475616873746875757882
35ROCHE 7478757465596974747676747781
36FUGLSANG 7478787364746574757776767882
37KRUIJSWIJK 7378757364606873747775748281
38INTXAUSTI 7378787066626674747676757682
39ROGERS 7378757064606973737675747881
40AMADOR 7378747069666773737574737662
41CARUSO 7378756869526974747775747881
42SCARPONI 7078766865606774737676747781
43NIEMIEC 7178766864606974737675747576
44ZUBELDIA 6878746761596569697574737860
45MARTIN 7578806667626975787079787885
46CARDOSO 6778746662536573687574737659
47GENIEZ 6678746661536774656774717655
48KISERLOVSKI 6578756563596473647474737660
49NAVARRO 6778746463596366736874707860
50SANCHEZ 7377787362596674747777767882
 
TankNL
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 Smile but will tune that down, in next update) when uploaded into a database, rest is calculated by the algorithm's
 
DwayneWade1982
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
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 Wink )
 
TankNL
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
I'm looking forward to it Smile Thanx
 
TankNL
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
Nice thanx. I've downloaded it and I'm going to give it a try. Looking forward to it ;-)
 
Jump to Forum:
Login
Username

Password



Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
Latest content
Screenshots
And the Giro...
And the Giro...
PCM 08: General PCM-screenshots
Fantasy Betting
Current bets:
No bets available.
Best gamblers:
bullet fighti... 17,576 PCM$
bullet df_Trek 16,674 PCM$
bullet Marcovdw 14,545 PCM$
bullet jseadog1 12,852 PCM$
bullet baseba... 10,039 PCM$

bullet Main Fantasy Betting page
bullet Rankings: Top 100
ManGame Betting
Current bets:
No bets available.
Best gamblers:
bullet Ollfardh 21,290 PCM$
bullet df_Trek 14,820 PCM$
bullet Marcovdw 14,000 PCM$
bullet jseadog1 12,800 PCM$
bullet baseball... 6,932 PCM$

bullet Main MG Betting page
bullet Get weekly MG PCM$
bullet Rankings: Top 100
Render time: 0.24 seconds