|
2015 Database v4: New OVL rating
|
| SportingNonsense |
Posted on 24-04-2015 16:08
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
Kami wrote:
@SN
Fair point about the hilly stats and when looking at the OVL of the hilly riders, it looks pretty on point.
About the climbers/GC riders, i used 50 to show the extreme just for the general idea. Like you said earlier, when you order riders by OVL, Schleck's higher RES/REC shouldn't outweigh Spilak's TT/HI adventage when looking at the riders OVL.
Some other examples: Intxausti & Henao Montoya have almost the same overall (0.05 difference), while Henao has -6 in TT and the same MO/HI.
Dekker & Taaramae: Dekker has the higher OVL while Taaramae has the higher HI/TT.
There are more examples but it comes down that the OVL stat doesn't represent the GC riders strength very well. Wouldn't adding statweight to HI/TT when MO is the highest stat help with this even when the supporting stats are higher then HI/TT.
Yes, that's a very reasonable point. But it gets complicated. What do you do with Gesink 81/81, Trofimov 78/73, Roche 78/80, Kwiatkowski 77/78, and those types of M/H riders. Or Phinney with a M/T of 82/83.
|
| |
|
|
| Smowz |
Posted on 24-04-2015 16:44
|
Team Leader
Posts: 6479
Joined: 09-04-2009
PCM$: 200.00
|
Thanks roturn and SN (well obviously mainly SN) for the database.
Thrilled to see many of my suggestions make it in with some nice stats too.
Took a quick scroll through the OVL list, I think the formula is pretty decent - the mountain 85 ites are at the top, though becuase there is a few of them it is probably a bit distorted.
Phinney, Bewley and Trofimov should possibly be a bit higher but they are in the right ballpark.
I was musing that possibly the third weighting should be just based on the key stats.
Spoiler 6 * Max(Mo, Hl, TT {TT - 2 if MO < 75} , Cb - 1, Sp - 5 {Sp - 7 if Hl < 61})
+
2 * Next Best (Mo, Hl, TT, Cb - 1, Sp - 5, Ac)
+
1.3 * Next Best (Mo, Hl, TT, Cb - 2, Sp - 9, Ac)
+
0.75 * Next Best (Fl, Mo, Hl, TT, St, Rs, Rc, Cb - 2, Sp - 9, Ac)
+
0.5 * Next Best (Fl, Mo, Hl, TT, St, Rs, Rc, Cb - 2, Sp - 9, Ac)
Divided by 10.55.
Not really convinced by those results either. I guess Phinfreak, Trofitruffle and BewBastard are good because they dominate their field whereas the stage racing 85 doom patrol are there in numbers.
|
| |
|
|
| dev4ever |
Posted on 24-04-2015 16:56
|
Small Tour Specialist
Posts: 2282
Joined: 13-03-2011
PCM$: 200.00
|
DB-time!  
|
| |
|
|
| FroomeDog99 |
Posted on 24-04-2015 17:04
|
Grand Tour Specialist
Posts: 4573
Joined: 07-10-2012
PCM$: 200.00
|
Not sure about the new average. Looking at Samwel, who got less than 200 points for us last season, it seems strange he's higher that someone like Kiserlovski or LLS. I know his recovery and stamina are high, but things like his downhill, hill and TT stats really hamper him and make him a lot worse than those around him with a similar overall. Maybe it's a case of the top main stat being too overweighted, but not sure.
More all-round riders seem to a bit better off in these rankings as well. For example have a look at Sella and Martin:
| FL | MO | HI | TT | STA | RES | REC | COB | SP | ACC | FTR | DH | PRL | | Sella | 69 | 81 | 74 | 66 | 75 | 81 | 74 | 50 | 52 | 76 | 79 | 68 | 66 | | Martin | 70 | 81 | 77 | 73 | 77 | 78 | 78 | 55 | 65 | 76 | 72 | 63 | 71 |
Looking at these stats, I'd much rather have Martin due to higher TT, Hill, Rec and Sta. However, Sella's average is larger which I don't understand.
Don't know what to suggest though, I'm by no means an expert with excel. Otherwise it looks like a great job, and I can't wait for renewals and transfers now.
Edited by FroomeDog99 on 24-04-2015 18:49
|
| |
|
|
| Roman |
Posted on 24-04-2015 18:02
|
Grand Tour Specialist
Posts: 4386
Joined: 29-05-2007
PCM$: 200.00
|
I believe rider ID 159 Paulius Siskevicius from my team did not get 20 XPs he would deserve to get thankfully to his participation in Avenir.
- Also, rider ID 5585 is Troels Vinther, not Vinter.
Rider ID 6286 is Klaas Lodewyck, not Lodewijck.
- There are two free agents named Aleksei Usov, the younger of them ID 164 even don't exist in reality. 
- Rider ID 7589 Magnus Cort Nielsen should IMO has Cort Nielsen as his last name, same goes with a few other Danish riders (for example Valgren id 7584)
- Free agent with ID 5771 Domingos Gonçalves is already in DB as a rider ID 847 - under contract in Prio.
|
| |
|
|
| Shonak |
Posted on 24-04-2015 19:46
|
Tour de France Champion
Posts: 15615
Joined: 16-07-2013
PCM$: 350.00
|
Cool stuff!
Uh, what's about the level that CT teams should aim for in the planning? I take it that most top free agents will be (money-wise) reserved for the PT and financial strong PCT teams?
"It’s a little bit scary when Contador attacks." - Tommy V
|
| |
|
|
| FroomeDog99 |
Posted on 24-04-2015 19:52
|
Grand Tour Specialist
Posts: 4573
Joined: 07-10-2012
PCM$: 200.00
|
Shonak wrote:
Cool stuff!
Uh, what's about the level that CT teams should aim for in the planning? I take it that most top free agents will be (money-wise) reserved for the PT and financial strong PCT teams?
Top leaders in CT are usually around 76/77 level in terms of one of the main stats. Sprint is probably a bit above that, and cobbles a bit below, but generally that would be a good level of rider to aim for. |
| |
|
|
| SportingNonsense |
Posted on 24-04-2015 19:57
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
Shonak wrote:
Cool stuff!
Uh, what's about the level that CT teams should aim for in the planning? I take it that most top free agents will be (money-wise) reserved for the PT and financial strong PCT teams?
Last year's DB is: https://www.dropbox.com/s/9siw6x0drgo...s.xls?dl=0
You can take a look at which riders were in the CT division then, which may help as a guide.
|
| |
|
|
| Shonak |
Posted on 24-04-2015 20:03
|
Tour de France Champion
Posts: 15615
Joined: 16-07-2013
PCM$: 350.00
|
Thanks! 76/77 seems good but maybe I can some even better riders hehe *dream big* That sprinter level last year was quite impressive in CT last season. Good that no Van der Poel is in the DB, so no rider I throw my money aimlessly at.
Edited by Shonak on 24-04-2015 20:04
"It’s a little bit scary when Contador attacks." - Tommy V
|
| |
|
|
| jsh312mufc |
Posted on 24-04-2015 20:08
|
Breakaway Specialist
Posts: 794
Joined: 05-02-2012
PCM$: 300.00
|
Will there be any extra riders in the final db? I was hoping to sign some members of what is Novo Nordisk in real life, but I can't find any members of the squad in there |
| |
|
|
| Ad Bot |
Posted on 22-11-2024 15:25
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| beagle |
Posted on 24-04-2015 20:17
|
Grand Tour Specialist
Posts: 4200
Joined: 06-10-2007
PCM$: 200.00
|
Great job with new formula. Maybe it´s not perfect yet, still I´m very very satisfied to see one-way riders with cutting down of their RD!
Manager of Polar in Man-Game
|
| |
|
|
| SportingNonsense |
Posted on 24-04-2015 20:25
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
jsh312mufc wrote:
Will there be any extra riders in the final db? I was hoping to sign some members of what is Novo Nordisk in real life, but I can't find any members of the squad in there
First Post. 2nd line.
SportingNonsense wrote:
First thing to note is that the rider addition process is by no means finished.
|
| |
|
|
| OlegTinkov |
Posted on 24-04-2015 20:34
|
Small Tour Specialist
Posts: 2666
Joined: 31-12-2007
PCM$: 450.00
|
Tom Last (6319) born on 00-12-1988
Alex Kirsch (7422) born on 117-09-1993
Peter Erdin (395) born on 32-01-1990
Willian Araujo (3337) born on 39-03-1986
Piter Campero (7054) has EU as continent should be SA
Double 1212/5711 Mark Dzamastagic
Double 847/5771 Domingos Gonçalves
Double 5952/5844 Anders Lund
Double 5791/164 Aleksei Usov
1085 Grippo Chiaffredo 86 Fighter Stat
1313 Portela Marcio 89 Fighter Stat
Riders with old loan detail in DB:
| 7494 | Warren | Barguil | | 5108 | Chris | Barton | | 6142 | Dries | Beatse | | 1108 | Michael | Boroš | | 3229 | Alexander | Edmondson | | 3103 | Joshua | Edmondson | | 936 | Alexander | Foliforov | | 7670 | Arnaud | Grand | | 7861 | Jan | Hirt | | 1106 | Tormod | Jacobsen | | 3114 | Stefan | Kung | | 3284 | Eliot | Lietaer | | 3046 | Adrien | Petit | | 5024 | Youcef | Reguigui | | 1112 | Mirco | Saggiorato | | 7925 | Daniel | Schorn | | 7833 | Toms | Skujins | | 8103 | Tesfar | Teklit | | 7858 | Daniel | Turek | | 7882 | Johan Fredrik | Ziesler |
Edited by OlegTinkov on 24-04-2015 20:35
|
| |
|
|
| aidanvn13 |
Posted on 24-04-2015 21:15
|
Classics Specialist
Posts: 2797
Joined: 06-11-2010
PCM$: 200.00
|
Thanks so much for this SN! I've been really busy the past while and this just makes my planning so much easier. Should have my goals done in no time! 
|
| |
|
|
| SportingNonsense |
Posted on 24-04-2015 22:10
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
OlegTinkov wrote:
Double 1212/5711 Mark Dzamastagic
Double 847/5771 Domingos Gonçalves
Double 5952/5844 Anders Lund
Double 5791/164 Aleksei Usov
Not a double
|
| |
|
|
| SportingNonsense |
Posted on 24-04-2015 23:30
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
Here is an updated version of the database, version 2. https://www.dropbox.com/s/1w3xc0n3u3r...2.xls?dl=0
I think I've fixed all errors mentioned here - all XP gains are now in place, amongst other things.
ggDonovan is working on a different system to calculate the Overall/Average, which is looking promising so far - but for now the system is unchanged on yesterday.
Oh, and there's been quite a few new riders added / stats revised since yesterday too.
Edited by SportingNonsense on 24-04-2015 23:32
|
| |
|
|
| knockout |
Posted on 24-04-2015 23:51
|
Grand Tour Champion
Posts: 7735
Joined: 21-12-2010
PCM$: 400.00
|
Do Sauber and Rothaus fusioned together to create a new combined team Aegon? There seems to be something mixed up with those two teams
A Big Thank You To All MG Reporters! |
| |
|
|
| SportingNonsense |
Posted on 25-04-2015 00:01
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
knockout wrote:
Do Sauber and Rothaus fusioned together to create a new combined team Aegon? There seems to be something mixed up with those two teams
And you seem to be using the old DB
|
| |
|
|
| knockout |
Posted on 25-04-2015 00:05
|
Grand Tour Champion
Posts: 7735
Joined: 21-12-2010
PCM$: 400.00
|
SportingNonsense wrote:
knockout wrote:
Do Sauber and Rothaus fusioned together to create a new combined team Aegon? There seems to be something mixed up with those two teams
And you seem to be using the old DB
Damn. It is never intelligent to have two different versions opened at the same time 
A Big Thank You To All MG Reporters! |
| |
|
|
| cio93 |
Posted on 25-04-2015 00:07
|
World Champion
Posts: 10845
Joined: 29-10-2007
PCM$: 500.00
|
jsh312mufc wrote:
Will there be any extra riders in the final db? I was hoping to sign some members of what is Novo Nordisk in real life, but I can't find any members of the squad in there
I feel like SN read this post... 
|
| |
|
