|
2015 Database v4: New OVL rating
|
| SportingNonsense |
Posted on 23-04-2015 23:45
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
28/04/2015: V4: https://www.dropbox.com/s/8ot0caifo3x...4.xls?dl=0
25/04/2015: V3: https://www.dropbox.com/s/8xjws51scnj...3.xls?dl=0
24/04/2015: V2 https://www.dropbox.com/s/1w3xc0n3u3r...2.xls?dl=0
-----
So it feels like it is time to release the first Excel version of the 2015 ManGame DB. Here it is: https://www.dropbox.com/s/1rdg9z2p1rz...1.xls?dl=0
First thing to note is that the rider addition process is by no means finished. While there are some new riders in there, the main purpose of this release is to provide an up to date version with updated stats from development increases and age decreases, new team names, national champions and the free agency list.
Also included is a new Average formula that roturn has come up with, with a bit of feedback from me. The purpose of this was to better reflect the importance of the main stat relative to secondary stats - it was clear last season that a number of the so-called 'one-dimensional' riders were underrated in terms of Average, and thus the amount of race days.
It is now calculated by:
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 (Fl, Mo, Hl, TT, St, Rs, Rc, 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.
I am now referring to this as the Overall stat, rather than the Average. This new formula is not final, and I really welcome feedback from all managers on this.
The exact Race Days formula will need to be updated once the Overall formula is finalised. I have made a couple of crude changes to last year's formula to offer an indication of what those Race Days might be. This reflects a reduction in the amount of race days all teams will have this season, as well as the new Overall stat. Note that any PT rider with less than 42 race days will still have the option to ride 2 Grand Tours, but these can be the only two races which they ride all season.
Edited by SportingNonsense on 28-04-2015 17:46
|
| |
|
|
| nacho63 |
Posted on 23-04-2015 23:50
|
Sprinter
Posts: 1944
Joined: 14-03-2013
PCM$: 200.00
|
Awesome! Will be relooking over targets for the coming season now I have submitted my goals. |
| |
|
|
| Ad Bot |
Posted on 25-11-2024 13:08
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| Scorchio |
Posted on 24-04-2015 00:08
|
Small Tour Specialist
Posts: 2073
Joined: 14-09-2013
PCM$: 4500.00
|
Christmas has arrived in April. Mucho Gracias!
Will think hard on the 'overall' rating and try and provide some feedback.
Manager of ISA - Hexacta in the MG |
| |
|
|
| cio93 |
Posted on 24-04-2015 00:14
|
World Champion
Posts: 10845
Joined: 29-10-2007
PCM$: 500.00
|
Thank you SN.
Disappointed about Arndt's training -.-
|
| |
|
|
| CountArach |
Posted on 24-04-2015 05:21
|
Grand Tour Champion
Posts: 8290
Joined: 14-07-2008
PCM$: 200.00
|
Oh man that new formula really hurts me, though it is totally fair.
Thanks for this SN, now the really exciting part of the planning can get under way.
|
| |
|
|
| Heine |
Posted on 24-04-2015 06:44
|
Grand Tour Specialist
Posts: 4116
Joined: 08-04-2007
PCM$: 200.00
|
Oh boy, oh boy, oh boy, oh boy, oh boy, oh boy, oh boy, oh boy, oh boy, oh boy, oh boy, oh boy, oh boy, oh boy, oh boy, oh boy, oh boy, oh boy, oh boy, oh boy, oh boy, oh boy, oh boy, oh boy, oh boy, oh boy, oh boy
Edit: looking at the new "overall", This will hurt during renewals... But it's not only me, so just fair
Edited by Heine on 24-04-2015 06:48
|
| |
|
|
| Avin Wargunnson |
Posted on 24-04-2015 07:03
|
World Champion
Posts: 14236
Joined: 20-06-2011
PCM$: 300.00
|
New DB, thanks SN 
Wow, those overall changes, which make Zmorka second best rider in the team. 
Ignatiev got more race days though, but i am not sure it is fair ibn some cases, because this makes alla arounders a bit overpowered in terms of race days and some one dimensional riders almost useless, will give it few more looks though...
Oh boy, how much i like certain added rider...hey Alex. 
Edited by Avin Wargunnson on 24-04-2015 07:04
|
| |
|
|
| Heine |
Posted on 24-04-2015 07:06
|
Grand Tour Specialist
Posts: 4116
Joined: 08-04-2007
PCM$: 200.00
|
Some nice riders added, without adding over the top talents. I like that, hope it stays that way in the last version. A couple of the new riders I might take a look at come transfers (atleast one)
I think I know the guy Alex and Avin will fight over, looks like a great domeqtique in the PT.
How will it be with training of added riders, is that allowed?
|
| |
|
|
| tsmoha |
Posted on 24-04-2015 07:30
|
Directeur Sportif
Posts: 11819
Joined: 19-07-2010
PCM$: 300.00
|
Thanks, SN!
But wtf, Michael Ford
|
| |
|
|
| TheManxMissile |
Posted on 24-04-2015 07:40
|
Tour de France Champion
Posts: 18187
Joined: 12-05-2012
PCM$: 0.00
|
Is it just me and LibreOffice, or is there no way to sort the columns? As in the past DB's have like drop down menus you can use to filter, but i don't have them this time around. And with something like 3500 riders it's quite an issue
|
| |
|
|
| Heine |
Posted on 24-04-2015 07:45
|
Grand Tour Specialist
Posts: 4116
Joined: 08-04-2007
PCM$: 200.00
|
That is Libreoffice
I remember from using open office before that I could find a sort option somewhere, today I'm using excel so much easier
|
| |
|
|
| TheManxMissile |
Posted on 24-04-2015 07:56
|
Tour de France Champion
Posts: 18187
Joined: 12-05-2012
PCM$: 0.00
|
Heine wrote:
That is Libreoffice
I remember from using open office before that I could find a sort option somewhere, today I'm using excel so much easier
Well i have the exact same drop downs in ICL DB's and they work fine. I accept it might be LibreOffice but i'm unwilling to download a whole new software just to open MG DB's.
Equally i can't 'sort' either because that crashes it every time i do.
Boy i'm in for a fun day with this! But still thanks for getting the DB out
|
| |
|
|
| Heine |
Posted on 24-04-2015 07:57
|
Grand Tour Specialist
Posts: 4116
Joined: 08-04-2007
PCM$: 200.00
|
Btw, I think something has gone wrong in the DB, Roturn has gotten quite a large team  43 Riders
|
| |
|
|
| TheManxMissile |
Posted on 24-04-2015 08:09
|
Tour de France Champion
Posts: 18187
Joined: 12-05-2012
PCM$: 0.00
|
Fixed it
Learnt how to add them myself, much easier than i thought it would be
|
| |
|
|
| Atlantius |
Posted on 24-04-2015 08:13
|
Team Leader
Posts: 6795
Joined: 21-07-2010
PCM$: 200.00
|
Great to get the DB out.
There's an issue with my stagiaire Manninen though. He hasn't gained a single XP-point in spite of racing both Azerbaijan and l'Avenir.
Edit: Looking a bit closer on the DB I suspect it's an issue with quite a lot of stagiaires actually...
Edited by Atlantius on 24-04-2015 08:26
|
| |
|
|
| cio93 |
Posted on 24-04-2015 08:14
|
World Champion
Posts: 10845
Joined: 29-10-2007
PCM$: 500.00
|
Yep, I realized TTers didn't come off lightly considering some of them are absolutely useless outside of maybe 6 or 7 stages all season long now...
And @Heine, I really hope the renewals formulas are adjusted to this.
|
| |
|
|
| CountArach |
Posted on 24-04-2015 08:58
|
Grand Tour Champion
Posts: 8290
Joined: 14-07-2008
PCM$: 200.00
|
cio93 wrote:
Yep, I realized TTers didn't come off lightly considering some of them are absolutely useless outside of maybe 6 or 7 stages all season long now...
And @Heine, I really hope the renewals formulas are adjusted to this.
It is just that those 6 or 7 stages can sometimes be crucial for GC, as shown by the huge number of riders at PCT and CT level who are only good at TTs and yet score huge points. At PT level I can see your point and agree, because there are fewer races for them, but below that I think they are immensely powerful.
|
| |
|
|
| Ollfardh |
Posted on 24-04-2015 09:03
|
World Champion
Posts: 14563
Joined: 08-08-2011
PCM$: 9100.00
|
Josef Cerny is not marked as national champion, while he did win the race iirc.
Changed my sig, this was getting absurd.
|
| |
|
|
| Avin Wargunnson |
Posted on 24-04-2015 09:23
|
World Champion
Posts: 14236
Joined: 20-06-2011
PCM$: 300.00
|
CountArach wrote:
cio93 wrote:
Yep, I realized TTers didn't come off lightly considering some of them are absolutely useless outside of maybe 6 or 7 stages all season long now...
And @Heine, I really hope the renewals formulas are adjusted to this.
It is just that those 6 or 7 stages can sometimes be crucial for GC, as shown by the huge number of riders at PCT and CT level who are only good at TTs and yet score huge points. At PT level I can see your point and agree, because there are fewer races for them, but below that I think they are immensely powerful.
What? Actually it was completely otherwise in PCT and only exception was Michael Ford
For example Zmorka wiill be close to useless as point scorer in PT and he has second biggest overall from the team and next year after his maxing out he will challenge the overall of Ignatiev beast with this overall formula, while having one great stat only...
This will for sure encourage everybody to buy mainly all arounders, because those guys with one high stat have minimal race days now compared to their point scoring potentials.
TTists will pay for success of Ford and hilly guys will pay for DiMaggio and Clayes, not sure that this is the good way to be honest. Give them hard time during renewals, instead of punishing whole group of riders...
Edit: Now i have seen that Zmorka or M.Ford have bigger overalls than Lars Boom, which i found pretty hillarious. 
Edited by Avin Wargunnson on 24-04-2015 09:29
|
| |
|
|
| The Rider |
Posted on 24-04-2015 09:29
|
Grand Tour Specialist
Posts: 4543
Joined: 29-02-2012
PCM$: 200.00
|
^ - I'm pretty sure Olman had multiple top 5 GC finishes for the OZ. (Faso off the top of my head)
Thanks a lot SN. Plenty of changes there: as if Nicacio didn't suffer enough last season!  |
| |
|
![imgur.com/KlJUqDx.jpg[/img[img]]https://imgur.com/yUygrQ.jpg](https://imgur.com/KlJUqDx.jpg[/img[img]]https://imgur.com/yUygrQ.jpg)
