|
2013 Database v1 - New Average System
|
| Deadpool |
Posted on 26-10-2012 19:01
|
Team Leader
Posts: 7357
Joined: 06-10-2007
PCM$: 200.00
|
Sorry, try this link: https://www.mediaf...6vp625myww |
| |
|
|
| Deadpool |
Posted on 26-10-2012 21:47
|
Team Leader
Posts: 7357
Joined: 06-10-2007
PCM$: 200.00
|
Should worth noting it is fully functional for the vast majority of riders, so hopefully it'll be good enough for you. |
| |
|
|
| SportingNonsense |
Posted on 26-10-2012 22:22
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
Obviously it is written correctly in the first post, and the original calculations were right, so it is of course an error from your calculations. Surprised that you only highly doubted c)...
With Damiano Cunego as an example, you are including his Mountain stat in your Average calculation 3 times. 2x for being the Max, and then you take it again under 'First'. You need to change your formulas so that 'First-Fourth' does not include the stat that was used as 'Max'
Pretty clear oversight imo
Edited by SportingNonsense on 26-10-2012 22:23
|
| |
|
|
| Deadpool |
Posted on 26-10-2012 22:29
|
Team Leader
Posts: 7357
Joined: 06-10-2007
PCM$: 200.00
|
Ah, I misread your post then.
I'll fix it here and re-upload it in a couple of minutes. |
| |
|
|
| DaBobScotts |
Posted on 27-10-2012 02:59
|
Domestique
Posts: 606
Joined: 15-01-2011
PCM$: 200.00
|
A couple of the Koreans have their continent listed as EU (Jeon and Soon). I was wondering why I couldn't find them in Asia 
|
| |
|
|
| DaBobScotts |
Posted on 27-10-2012 03:07
|
Domestique
Posts: 606
Joined: 15-01-2011
PCM$: 200.00
|
And that's Gyung Gu Jang (Jang is his last name) and Yung-Jae Jeon (Jeon last name).
|
| |
|
|
| Ste117 |
Posted on 28-10-2012 16:42
|
Classics Specialist
Posts: 3684
Joined: 21-02-2009
PCM$: 200.00
|
Just a quick question regarding using excel, hardly use it so I need help.
Is their a way I can sort the riders out by free agents and nationality?
MG Team manager Team Ticos Air Costa Rica
 |
| |
|
|
| felix_29 |
Posted on 28-10-2012 16:49
|
Classics Specialist
Posts: 3054
Joined: 08-08-2009
PCM$: 200.00
|
First sort by nationality and then by team. You can also sort by average, then by nationality and then by free agents to have the best ones on top.
|
| |
|
|
| Ad Bot |
Posted on 22-11-2024 02:01
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| Roman |
Posted on 28-10-2012 19:37
|
Grand Tour Specialist
Posts: 4386
Joined: 29-05-2007
PCM$: 200.00
|
Thanks you Deadpool, better something than nothing for sure. 
|
| |
|
|
| Heine |
Posted on 10-11-2012 11:57
|
Grand Tour Specialist
Posts: 4116
Joined: 08-04-2007
PCM$: 200.00
|
I've noticed a slight mistake in the db. Rohregger stands as Austrian RR champ (while he won the TT) and Schorn stand as TT (while he won the RR)
|
| |
|
|
| Roman |
Posted on 03-12-2012 19:11
|
Grand Tour Specialist
Posts: 4386
Joined: 29-05-2007
PCM$: 200.00
|
I found two small 'typo' mistakes in DB.
Okrouhlicky Tomas should be named Tomas Okrouhlicky - as Tomas is his first name. 
And Jiri Huducek should be named Jiri Hudecek.
|
| |
|
