PCM.daily banner
22-11-2024 01:45
PCM.daily
Users Online
· Guests Online: 101

· Members Online: 0

· Total Members: 161,772
· Newest Member: KennethSal
View Thread
PCM.daily » Pro Cycling Manager 2006-2020 » Pro Cycling Manager 2014
 Print Thread
calculated stats based on FINAL results
Faillu
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, Smile

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
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
@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
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
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
updated 4-8-2014; sorted on the stat MOUNTAIN, this is the top 50;

Maximum stat808483838283838082
FLATMOUNTAINHILLTIMETRAILPROLOGUECOBBLESPRINTACCELERATIONDOWNHILL
NIBALI Vincenzo768478776774748082
VALVERDE BELMONTE Alejandro788483757955758082
MAJKA Rafal728376755050587680
RODRIGUEZ OLIVER Joaquim758379705050717682
QUINTANA ROJAS Nairo Alexander738275765050567478
PINOT Thibaut728275745052587579
FROOME Chris758275797550747478
VAN GARDEREN Tejay738175767750607478
POZZOVIVO Domenico738077755050547577
PERAUD Jean-Christophe738075757650577477
CONTADOR VELASCO Alberto748077765050747478
MOLLEMA Bauke748079747350757779
BARDET Romain737977535052757579
HORNER Chris727975535050617476
URAN URAN Rigoberto727975765050597376
ROCHE Nicolas727975695050697477
KÖNIG Leopold717974755050537376
COSTA Rui Alberto Faria747977755952747280
PORTE Richie727975757653617476
MORENO FERNANDEZ Daniel737879515050617677
ROLLAND Pierre717874675050547376
EVANS Cadel747877757550747477
NIEVE ITURRALDE Mikel727875505050567277
ULISSI Diego747881755050667678
SCARPONI Michele727876655050587376
ARU Fabio757774755051507274
KREUZIGER Roman727777745050607475
FRANK Mathias727775747550577275
KELDERMAN Wilco737775757454607275
PELLIZOTTI Franco727776685050587376
FUGLSANG Jakob727775605075687275
MARTIN Daniel727778525050587476
TALANSKY Andrew727774757352627175
BASSO Ivan717774535050537275
TEN DAM Laurens747768545050537274
SANCHEZ GONZALEZ Samuel717675685050587274
ROGERS Michael727675655050707276
VAN DEN BROECK Jurgen717674557355567174
DUARTE AREVALO Fabio Andres647665525050517274
ARREDONDO MORENO Julian David717675505050557275
NAVARRO GARCIA Daniel717663525050527175
HESJEDAL Ryder727676637350597276
SCHLECK Fränk687675505050537274
KISERLOVSKI Robert717669545050537174
ZUBELDIA AGIRRE Haimar717674556150537174
KWIATKOWSKI Michal757681768072757777
BETANCUR GOMEZ Carlos Alberto727676605050677275
GADRET John717671505050517174
ANTON HERNANDEZ Igor717674515050517274
CATALDO Dario667673755750537174

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
updated 4-8-2014; sorted on the stat SPRINTING, this is the top 50;

Maximum stat808483838283828082
FLATMOUNTAINHILLTIMETRAILPROLOGUECOBBLESPRINTACCELERATIONDOWNHILL
SAGAN Peter806781687783828078
GREIPEL André775474505658827362
KRISTOFF Alexander775876525677828055
KITTEL Marcel765558557952827050
BOUHANNI Nacer765162505059827157
CAVENDISH Mark755574546152827352
DEGENKOLB John785475535080827574
DEMARE Arnaud776072545076807255
COQUARD Bryan745474535060807364
VIVIANI Elia735365507354797158
DUMOULIN Samuel746275505050797374
MODOLO Sacha735164505059787161
NIZZOLO Giacomo725170507650787262
FARRAR Tyler735369507375787350
VAN STAEYEN Michael725160505053777156
BOS Theo725253505050775550
RENSHAW Mark725153505055775750
ROJAS GIL Jose Joaquin747176505057777275
MEZGEC Luka725168505055777163
FERRARI Roberto725158505050766655
MATTHEWS Michael725676615050767573
PETACCHI Alessandro725153505050766250
NAVARDAUSKAS Ramunas725975528050767373
VAN HUMMEL Kenny725355505057766152
HUTAROVICH Yauheni735067505074767269
CIOLEK Gerald725374505060767461
SWIFT Ben726074505055757274
CHICCHI Francesco715050505050755250
VAN ASBROECK Tom745574505075757173
VAN POPPEL Danny735264508169757164
MARTINEZ Yannick725474505061756469
MEERSMAN Gianni746076527850757276
HUSHOVD Thor725367505074757254
FEILLU Romain715156505050756552
BENNETT Sam725067505061755473
DEBUSSCHERE Jens725362505075757158
GUARDINI Andrea715052505052755551
GOSS Matthew715159505050756455
LOBATO DEL VALLE Juan Jose725474505054757365
BOASSON HAGEN Edvald735375547576757574
HAUSSLER Heinrich735256575075757153
BENNATI Daniele725174635054757369
VAN AVERMAET Greg775579505081757678
HOFLAND Moreno725469505061757255
VENTOSO ALBERDI Francisco Jose715174505067757372
GIRAUD Benjamin715263505051757362
GILBERT Philippe737582607852758075
PETIT Adrien725165507574757164
SIMON Julien735976507450757275
NAPOLITANO Danilo715053505058746450

Edited by TankNL on 04-08-2014 14:28
 
TankNL
updated 4-8-2014; sorted on the stat COBBLES, this is the top 50;

Maximum stat808483838283828082
FLATMOUNTAINHILLTIMETRAILPROLOGUECOBBLESPRINTACCELERATIONDOWNHILL
CANCELLARA Fabian765376788083748073
TERPSTRA Niki766374697383747574
SAGAN Peter806781687783828078
VANMARCKE Sep765375505082747373
VAN AVERMAET Greg775579505081757678
DEGENKOLB John785475535080827574
VANDENBERGH Stijn735259505079597252
THOMAS Geraint747274747678717373
BOONEN Tom745362555078747254
LANGEVELD Sebastian715162587378607252
STYBAR Zdenek735875505077747373
KRISTOFF Alexander775876525677828055
BOOM Lars725571747377747263
DEMARE Arnaud776072545076807255
BOZIC Borut735363507376747257
STANNARD Ian725565605076627251
BOASSON HAGEN Edvald735375547576757574
CHAVANEL Sylvain747576777976747574
TURGOT Sébastien715161507376607159
ROELANDTS Jürgen735874515076747364
DRUCKER Jempy725666507775747253
LEUKEMANS Björn725776505075627374
GATTO Oscar725164505075687161
PAOLINI Luca725271505075737363
HAUSSLER Heinrich735256575075757153
KEUKELEIRE Jens715272505075737270
FARRAR Tyler735369507375787350
VAN ASBROECK Tom745574505075757173
DEHAES Kenny735159505075745857
EISEL Bernhard725256505075736854
FUGLSANG Jakob727775605075687275
LADAGNOUS Matthieu715370506675627255
WYNANTS Maarten715159505075556359
HUTAROVICH Yauheni735067505074767269
WIGGINS Bradley737673777874567274
FLECHA GIANNONI Juan Antonio715570505074697172
NIBALI Vincenzo768478776774738082
JEROME Vincent745357505074536751
DEVENYNS Dries716166517574587164
GAUDIN Damien675157527874526759
PETIT Adrien725165507574757164
BURGHARDT Marcus715566505074587165
DE BACKER Bert735163505074615768
OSS Daniel715374665074737257
HUSHOVD Thor725367505074757254
GALLOPIN Tony747078557474747377
PHINNEY Taylor715465757774737251
HAYMAN Mathew655156505074616653
OFFREDO Yoann695160505074647154
TRENTIN Matteo725175505074747274

Edited by TankNL on 04-08-2014 14:29
 
Adamb
Majka has done very well to earn the same as Froome and Quintana. But this is a great guide for DB makers.
 
Adamb
Also Contador is very poor for some reason but has don't quite well this season.
 
TankNL
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
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
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
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
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 stat808483838283828082
FLATMOUNTAINHILLTIMETRAILPROLOGUECOBBLESPRINTACCELERATIONDOWNHILL
VALVERDE BELMONTE Alejandro788483757955748082
GILBERT Philippe737582607852758075
KWIATKOWSKI Michal757681768072747777
SAGAN Peter806781687783828078
ULISSI Diego747881755050667678
GERRANS Simon737580505050737674
RODRIGUEZ OLIVER Joaquim758379705050717682
MOLLEMA Bauke748079747350747779
MORENO FERNANDEZ Daniel737879515050617677
VAN AVERMAET Greg775579505081757678
SLAGTER Tom-Jelte736478577451697374
NIBALI Vincenzo768478776774738082
MARTIN Daniel727778525050587476
GALLOPIN Tony747078557474747377
KREUZIGER Roman727777745050607475
GESCHKE Simon727077526750667276
EVANS Cadel747877757550737477
POZZOVIVO Domenico738077755050547577
COSTA Rui Alberto Faria747977755952737280
BARDET Romain737977535052757579
CONTADOR VELASCO Alberto748077765050737478
MARTIN Tony757377837554737374
ALBASINI Michael725577505750747275
MATTHEWS Michael725676615050767573
BAKELANTS Jan737576515057727377
PONZI Simone725376505053747376
MAJKA Rafal728376755050587680
VANENDERT Jelle715976505050527273
GASPAROTTO Enrico725876505950627274
PELLIZOTTI Franco727776685050587376
CANCELLARA Fabian765376788083748073
LEUKEMANS Björn725776505075627374
BETANCUR GOMEZ Carlos Alberto727676605050677275
FINETTO Mauro725976505052717274
GESINK Robert737576535350646877
VOECKLER Thomas737576615061647277
GAUTIER Cyril726676525050687275
CUNEGO Damiano726776535051597174
MEERSMAN Gianni746076527850757276
DUMOULIN Tom727576788156737374
SCARPONI Michele727876655050587376
CARUSO Giampaolo717276505054527273
COLBRELLI Sonny725476565053747375
ROJAS GIL Jose Joaquin747176505057777275
HENAO MONTOYA Sergio Luis717676585050597274
HESJEDAL Ryder727676637350597276
KRISTOFF Alexander775876525677828055
SIMON Julien735976507450757275
CHAVANEL Sylvain747576777976747574
REBELLIN Davide717676527350587374
 
TankNL
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
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
Valverde 84 MO? Sagan Best Sprinter? Tony Martin just 75 Flat? Sagan 83 Cobble?

did i miss that much this year?
i.imgur.com/aJSlUNt.png
 
dacolik
because of this year's results Contador should get the best MO... This is really bad database...
 
TankNL
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;
categorydaterace_namerace_typeresultCOBBLE
GT1s9-7-2014Tour de France, Stage 5 : Ieper (Bel) - Arenberg (156 km)Cobbles4173,6
1.WT113-4-2014Paris - Roubaix (257 km)Cobbles6280
1.WT16-4-2014Ronde van Vlaanderen (259 km)CobbleHills1670,4
2.HCs2-4-2014Driedaagse De Panne-Koksijde, Stage 2 : Zottegem - Koksijde (206 km)CobbleSprintDNF0
2.HCs1-4-2014Driedaagse De Panne-Koksijde, Stage 1 : De Panne - Zottegem (201 km)CobbleSprint139,2
1.WT230-3-2014Gent - Wevelgem (233 km)CobbleSprint3156,8
1.WT228-3-2014E3 Prijs Vlaanderen - Harelbeke (211 km)CobbleSprint1308
1.WT131-3-2013Ronde van Vlaanderen (256,2 km)CobbleHills2187
1.WT224-3-2013Gent - Wevelgem (185 km)CobbleSprint1154
1.WT222-3-2013E3 Prijs Vlaanderen - Harelbeke (211 km)CobbleHills2145,2
2.HCs26-3-2013Driedaagse De Panne-Koksijde, Stage 1 : Middelkerke - Zottegem (199,8 km)CobbleHills130,8
1.12-3-2013Strade Bianche (188 km)CobbleHills252,8

 
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
So cute!
So cute!
PCM09: Funny Screenshots
Fantasy Betting
Current bets:
No bets available.
Best gamblers:
bullet fighti... 18,376 PCM$
bullet df_Trek 17,374 PCM$
bullet Marcovdw 15,345 PCM$
bullet jseadog1 13,552 PCM$
bullet baseba... 10,439 PCM$

bullet Main Fantasy Betting page
bullet Rankings: Top 100
ManGame Betting
Current bets:
No bets available.
Best gamblers:
bullet Ollfardh 21,890 PCM$
bullet df_Trek 15,520 PCM$
bullet Marcovdw 14,800 PCM$
bullet jseadog1 13,500 PCM$
bullet baseball... 7,332 PCM$

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