|
calculated stats based on FINAL results
|
| Paul23 |
Posted on 20-04-2015 23:04
|
Grand Tour Specialist
Posts: 4411
Joined: 10-08-2011
PCM$: 400.00
|
Looks great overall. I like how Dege wins all cobbled classics, although there is no Omloop here. Tony stays ITT WC and switches to Giant.(although i would prefer him staying at etixx)
|
| |
|
|
| matt17br |
Posted on 21-04-2015 13:57
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
Looks pretty realistic 
Besides some obvious AI flaws as the cobbled stage screwing up the TDF, all the rest seems to be not too far from reality (except Valverde winning too much, Nibali and Degenkolb doing too well in the classics and Lutsenko somehow winning Pologne, but still, it can't be perfect and it's probably PCM's fault  ).
Keep it up, really, I'm quite confident that sooner or later some db makers may use it as base and only change the top stats to their liking 
|
| |
|
|
| TankNL |
Posted on 21-04-2015 15:58
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
matt17br wrote:
Looks pretty realistic
Besides some obvious AI flaws as the cobbled stage screwing up the TDF, all the rest seems to be not too far from reality (except Valverde winning too much, Nibali and Degenkolb doing too well in the classics and Lutsenko somehow winning Pologne, but still, it can't be perfect and it's probably PCM's fault ).
Keep it up, really, I'm quite confident that sooner or later some db makers may use it as base and only change the top stats to their liking
Thanks Matt, I'm using it that way. I only edit 7 riders to personal preference and have loads of fun with it.
Tank |
| |
|
|
| TankNL |
Posted on 22-04-2015 14:56
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
Paul23 wrote:
Looks great overall. I like how Dege wins all cobbled classics, although there is no Omloop here. Tony stays ITT WC and switches to Giant.(although i would prefer him staying at etixx)
Omloop is no WT race, that's why there's no result.
I did see that the startingfield of Omloop was far from impressive, not like in reallife. Will look into the races to see why the cobble leaders opt to skip this race. |
| |
|
|
| ppanther |
Posted on 04-05-2015 09:38
|
Domestique
Posts: 482
Joined: 25-12-2011
PCM$: 200.00
|
Super cool project. I am playing around with your excel by myself, but whats the best way including new races? |
| |
|
|
| TankNL |
Posted on 04-05-2015 10:05
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
ppanther wrote:
Super cool project. I am playing around with your excel by myself, but whats the best way including new races?
I use a build in VBA-macro to grab CQranking.com pages... but I did not include that macro in the public files, because I didn't wanted to DDOS them, with a couple of Excel’s that run simultaneously, that could very well be the case. |
| |
|
|
| TankNL |
Posted on 04-05-2015 10:05
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
ppanther wrote:
Super cool project. I am playing around with your excel by myself, but whats the best way including new races?
I use a build in VBA-macro to grab CQranking.com pages... but I did not include that macro in the public files, because I didn't wanted to DDOS them, with a couple of Excel’s that run simultaneously, that could very well be the case.
I could upload the lastest version with alle the races WT and .HC and .1 included, would that help?
Edited by TankNL on 04-05-2015 10:06
|
| |
|
|
| ppanther |
Posted on 04-05-2015 10:15
|
Domestique
Posts: 482
Joined: 25-12-2011
PCM$: 200.00
|
TankNL wrote:
ppanther wrote:
Super cool project. I am playing around with your excel by myself, but whats the best way including new races?
I use a build in VBA-macro to grab CQranking.com pages... but I did not include that macro in the public files, because I didn't wanted to DDOS them, with a couple of Excel’s that run simultaneously, that could very well be the case.
I could upload the lastest version with alle the races WT and .HC and .1 included, would that help?
Would be great and would help for sure. |
| |
|
|
| TankNL |
Posted on 04-05-2015 12:12
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
Here is the updated Excel file;
https://dl.dropboxusercontent.com/u/4...%20v1.xlsx
All races from 2011 until now on .WT, .HC and .1 level |
| |
|
|
| Ad Bot |
Posted on 22-11-2024 07:52
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| ppanther |
Posted on 04-05-2015 12:16
|
Domestique
Posts: 482
Joined: 25-12-2011
PCM$: 200.00
|
Thanks! |
| |
|
|
| ppanther |
Posted on 04-05-2015 12:17
|
Domestique
Posts: 482
Joined: 25-12-2011
PCM$: 200.00
|
How does it come this file is smaller than the previous one? Just curious. |
| |
|
|
| TankNL |
Posted on 04-05-2015 12:19
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
Don't know, might be that I've changed some formula's or deleted some hidden sheet... don't know exactly 
b.t.w. If you have any insights or tips regarding your playing around with the excel, please share them here.
Edited by TankNL on 04-05-2015 12:19
|
| |
|
|
| TankNL |
Posted on 04-05-2015 18:17
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
alright, past the 10.000 views... good to see that there is interest in the project still. |
| |
|
|
| themanxtrain1 |
Posted on 06-05-2015 12:16
|
Free Agent
Posts: 136
Joined: 05-07-2012
PCM$: 200.00
|
That's fantastic work. |
| |
|
|
| matt17br |
Posted on 08-05-2015 15:01
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
I noticed that you made a mistake while copying over FTR stats of the spreadsheet into the JESGD cdb file They are the same as the sprint stats! Just the same Looking a bit into the excel file again I noticed that the FTR formula could be made better. Not really sure how but we could discuss it!
Edited by matt17br on 08-05-2015 15:06
|
| |
|
|
| TankNL |
Posted on 08-05-2015 22:53
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
We could do it here in the forum. I've totally transparant, just for feedback like this. But you could also send me a pm, to discuss this in private. |
| |
|
|
| TankNL |
Posted on 08-05-2015 23:03
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
We could do it here in the forum. I've totally transparant, just for feedback like this. But you could also send me a pm, to discuss this in private. |
| |
|
|
| TankNL |
Posted on 09-05-2015 10:55
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
matt17br wrote:
I noticed that you made a mistake while copying over FTR stats of the spreadsheet into the JESGD cdb file They are the same as the sprint stats! Just the same L
I will look into that, thanks. |
| |
|
|
| TankNL |
Posted on 09-05-2015 13:42
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
I've done some extra work on the races and with the info from https://firstcycling.com/ I managed to also include all the .2 + .2U +.NE results from 2015, In order to get more info in the lesser known riders.
Will upload the new excel later this day.
Edited by TankNL on 09-05-2015 14:07
|
| |
|
|
| TankNL |
Posted on 09-05-2015 13:45
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
TankNL wrote:
matt17br wrote:
I noticed that you made a mistake while copying over FTR stats of the spreadsheet into the JESGD cdb file They are the same as the sprint stats! Just the same L
I will look into that, thanks.
You are right, wrong vLookup column selected ... corrected and will upload new .cdb later today. |
| |
|
