|
calculated stats based on FINAL results
|
| matt17br |
Posted on 09-05-2015 14:59
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
Both your last 2 posts are great news Tank! Looking forward to play around with the excel spreadsheet later on!
About the FTR formula, looks like punchers have a higher score than the other riders. Would be nice if you could somehow bring back the old formula you had showed in here: https://pcmdaily.com/forum/viewthread....ost_962666
Although there were problems with Voigt (that is retired now anyway) it looked quite accurate imo!
|
| |
|
|
| themanxtrain1 |
Posted on 09-05-2015 15:20
|
Free Agent
Posts: 136
Joined: 05-07-2012
PCM$: 200.00
|
Can't seem to open this with open office its stuck when loading ?? |
| |
|
|
| TankNL |
Posted on 09-05-2015 17:36
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
themanxtrain1 wrote:
Can't seem to open this with open office its stuck when loading ??
well. it is almost 100Mb, so might be that open office can't handle that? |
| |
|
|
| themanxtrain1 |
Posted on 09-05-2015 17:47
|
Free Agent
Posts: 136
Joined: 05-07-2012
PCM$: 200.00
|
Ok could would it work using Google Fusion tables do you think ?? |
| |
|
|
| matt17br |
Posted on 09-05-2015 17:49
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
If I were you, if you don't want to edit the tables but just want to take a look at them, I'd download Excel Viewer.
|
| |
|
|
| Ad Bot |
Posted on 22-11-2024 08:06
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| lg98 |
Posted on 09-05-2015 19:36
|
Amateur
Posts: 2
Joined: 09-05-2015
PCM$: 200.00
|
Hi there, just wondering how I download his database for use? I think what you have done is fantastic! |
| |
|
|
| TankNL |
Posted on 09-05-2015 20:09
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
matt17br wrote:
Both your last 2 posts are great news Tank! Looking forward to play around with the excel spreadsheet later on!
About the FTR formula, looks like punchers have a higher score than the other riders. Would be nice if you could somehow bring back the old formula you had showed in here: https://pcmdaily.com/forum/viewthread....ost_962666
Although there were problems with Voigt (that is retired now anyway) it looked quite accurate imo!
The problem with the Fighter stat is that there is actually no way to calculate it, based on FINAL results... So I came up with a trick. I calculate the number of points collected as the best of the team and as domestic. If the percentage of domestic is higher than 6%, then I calculates the fighter stat, based on scored points. If the percentage of domestic is lower than 6% (he is seen as a leader) and therefor, the points score are deducted if his primary stats exceed a certain level.
I've done a tweek and I must say, it is looking better now... |
| |
|
|
| TankNL |
Posted on 09-05-2015 20:48
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
Here is the new excel file.
https://dl.dropboxusercontent.com/u/4...%20v2.xlsx
There are about a 1000 more cyclists with stats.
It really takes me a lot of work getting all the races in the right category (race type). And it would help a lot if people form the countries (especially those in the Africa continent) would look at the races in their country, because it is hard to find profiles of those races. |
| |
|
|
| themanxtrain1 |
Posted on 09-05-2015 21:53
|
Free Agent
Posts: 136
Joined: 05-07-2012
PCM$: 200.00
|
matt17br wrote:
If I were you, if you don't want to edit the tables but just want to take a look at them, I'd download Excel Viewer.
Excellent finally got it open can add some cyclist to my PCM 13 database now for this season. |
| |
|
|
| matt17br |
Posted on 09-05-2015 22:19
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
Fair enough on the fighter stat, I understand it and that's why I didn't really have ideas for a formula. By the way, thanks for the updated excel file, looking forward to play around with it tomorrow, those 1000 races are a real plus!
|
| |
|
|
| gundir |
Posted on 09-05-2015 22:21
|
Free Agent
Posts: 136
Joined: 17-09-2007
PCM$: 200.00
|
Isnt it an idea to use Pro Cycling Stats for the Fighter stat? They list which riders are in the early breakaway on their result page.
|
| |
|
|
| TankNL |
Posted on 10-05-2015 08:34
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
gundir wrote:
Isnt it an idea to use Pro Cycling Stats for the Fighter stat? They list which riders are in the early breakaway on their result page.
I looked at it, but i use cqranking.com as a base for the stats creation and writing a new macro on procyclingstats.com just for that purpose, seems a bit of a longshot. Beside, iT only had the breakaway recorded for big races. |
| |
|
|
| TankNL |
Posted on 10-05-2015 18:26
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
Progress so far;
Stats created based on 2.422 results resulting in calculated stats for 5.024 cyclist of which some have gone into retirement, but still a lot of useful stats..
Will see if I have the drive to also include the 2014 .2 races
Edited by TankNL on 10-05-2015 18:27
|
| |
|
|
| TankNL |
Posted on 10-05-2015 18:35
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
I could use some help from somebody with knowledge of the north African races. I have given the results a classification based on the website firstcycling.com and based on the time-gaps or the absence of them in the result. I could really use somebody to conform the stage profile.
Egypt;
Spoiler | date | race name | country | cat | race_type | | 14-1-2015 | Tour of Egypt, Prologue : Makadi Bay I.T.T. (8 km) | Egy | 2.2s | Prologue | | 15-1-2015 | Tour of Egypt, Stage 1 : Hurghada - Hurghada (185 km) | Egy | 2.2s | Mountains | | 16-1-2015 | Tour of Egypt, Stage 2 : Hurghada - Hurghada (150 km) | Egy | 2.2s | Hills | | 17-1-2015 | Tour of Egypt, Stage 3 : Makadi Bay - Makadi Bay (142 km) | Egy | 2.2s | Hills | | 18-1-2015 | Tour of Egypt, Stage 4 : Makadi - Makadi (121 km) | Egy | 2.2s | Hills |
Marocco
Spoiler | ]date | race name | country | cat | race_type | | 26-2-2015 | Challenges de la Marche Verte - GP Sakia El Hamra (162 km) | Mar | 1.2 | Unknown | | 28-2-2015 | Challenges de la Marche Verte - GP Oued Eddahab (103 km) | Mar | 1.2 | Unknown | | 1-3-2015 | Challenges de la Marche Verte - GP Al Massira (140 km) | Mar | 1.2 | Unknown | | 3-4-2015 | Tour du Maroc, Stage 1 : Settat - Marrakech (170 km) | Mar | 2.2s | Hills | | 4-4-2015 | Tour du Maroc, Stage 2 : Marrakech - Beni-Mellal (192 km) | Mar | 2.2s | Sprint | | 5-4-2015 | Tour du Maroc, Stage 3 : Khènifra - Fès (165 km) | Mar | 2.2s | Hills | | 6-4-2015 | Tour du Maroc, Stage 4 : Fès - Taza (118 km) | Mar | 2.2s | UphillSprint | | 7-4-2015 | Tour du Maroc, Stage 5 : Guercif - Oujda (159 km) | Mar | 2.2s | Sprint | | 8-4-2015 | Tour du Maroc, Stage 6 : Oujda - Nador (139 km) | Mar | 2.2s | Sprint | | 9-4-2015 | Tour du Maroc, Stage 7 : Nador - El Hoceima (155 km) | Mar | 2.2s | Mountains | | 10-4-2015 | Tour du Maroc, Stage 8 : Tétouan - Tanger (104 km) | Mar | 2.2s | Hills | | 11-4-2015 | Tour du Maroc, Stage 9 : Souk Elarbaa du Gharb - Kènitra (148 km) | Mar | 2.2s | Sprint | | 12-4-2015 | Tour du Maroc, Stage 10 : Rabat - Casablanca (120 km) | Mar | 2.2s | Sprint | | 7-5-2015 | Challenge du Prince - Trophée Princier (162 km) | Mar | 1.2 | Hills |
Algiers
Spoiler | ]date | race name | country | cat | race_type | | 6-3-2015 | Circuit d'Alger (105 km) | Alg | 1.2 | Unknown | | 7-3-2015 | Tour d'Oranie, Stage 1 : Alger - Ain Defla (128 km) | Alg | 2.2s | Sprint | | 8-3-2015 | Tour d'Oranie, Stage 2 : Mostaganem - Oran (143 km) | Alg | 2.2s | Hills | | 9-3-2015 | Tour d'Oranie, Stage 3 : Oran - Santa Cruz (128 km) | Alg | 2.2s | finishOnHill | | 10-3-2015 | GP d'Oran (132 km) | Alg | 1.2 | Sprint | | 12-3-2015 | Tour de Blida, Stage 1 : Blida - Djbabra (140,8 km) | Alg | 2.2s | Hills | | 13-3-2015 | Tour de Blida, Stage 2 : Tipiza - Blida (123,8 km) | Alg | 2.2s | Sprint | | 14-3-2015 | Tour de Blida, Stage 3 : Zeralda - Chrea | Alg | 2.2s | finishOnMountain | | 15-3-2015 | Critérium de Sétif (96 km) | Alg | 1.2 | Sprint | | 16-3-2015 | Tour de Sétif, Stage 1 : Sétif - Sétif (142 km) | Alg | 2.2s | Hills | | 17-3-2015 | Tour de Sétif, Stage 2 : Sétif - Sétif (112,5 km) | Alg | 2.2s | Sprint | | 18-3-2015 | Tour de Sétif, Stage 3 : Sétif - Sétif (162 km) | Alg | 2.2s | Sprint | | 19-3-2015 | Tour de Sétif, Stage 4 : Sétif - Sétif (100 km) | Alg | 2.2s | Hills | | 21-3-2015 | Tour d'Annaba, Stage 1 : Annaba - Annaba (130,5 km) | Alg | 2.2s | Sprint | | 22-3-2015 | Tour d'Annaba, Stage 2 : Annaba - Annaba (129 km) | Alg | 2.2s | Hills | | 23-3-2015 | Tour d'Annaba, Stage 3 : Annaba - Annaba (110 km) | Alg | 2.2s | Sprint | | 24-3-2015 | Tour d'Annaba, Stage 4 : Annaba - Constantine (117 km) | Alg | 2.2s | finishOnHill | | 25-3-2015 | Tour de Constantine, Stage 1 : Constantine - Constantine (115 km) | Alg | 2.2s | Hills | | 26-3-2015 | Tour de Constantine, Stage 2 : Constantine - Constantine (134 km) | Alg | 2.2s | Hills | | 27-3-2015 | Tour de Constantine, Stage 3 : Mila - Constantine (137 km) | Alg | 2.2s | Sprint | | 28-3-2015 | Circuit de Constantine (95 km) | Alg | 1.2 | Hills | | 30-3-2015 | Circuit de Blida (89 km) | Alg | 1.2 | Sprint |
Edited by TankNL on 10-05-2015 19:00
|
| |
|
|
| DiCyc |
Posted on 10-05-2015 18:39
|
Sprinter
Posts: 1636
Joined: 09-03-2015
PCM$: 200.00
|
Wow, that is very helpful and impressive on same time! |
| |
|
|
| TankNL |
Posted on 10-05-2015 19:02
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
DiCyc wrote:
Wow, that is very helpful and impressive on same time!
Thanks, been working on it for a year now. on and off adjusting the calculation matrix. And use it to create my own stats for a .cdb file. Have lots of fun playing with it. |
| |
|
|
| DiCyc |
Posted on 10-05-2015 19:04
|
Sprinter
Posts: 1636
Joined: 09-03-2015
PCM$: 200.00
|
Thanks, I had just downloaded it, so I am excited!
|
| |
|
|
| TankNL |
Posted on 10-05-2015 19:23
|
Domestique
Posts: 440
Joined: 19-03-2007
PCM$: 200.00
|
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 |
| |
|
|
| bob7 |
Posted on 10-05-2015 20:35
|
Stagiare
Posts: 220
Joined: 27-01-2009
PCM$: 200.00
|
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. |
| |
|
|
| lg98 |
Posted on 10-05-2015 22:12
|
Amateur
Posts: 2
Joined: 09-05-2015
PCM$: 200.00
|
Hi sorry to be a pain but I am rather new to using the databases and whenever I click this link it takes me to notepad? How do I get the database for use? Once again great work! |
| |
|
