I've been working the last few weeks on a new program that converts stats from CM4 -> WE7. I liked the Grinster one, but there were some problems. First, it didn't convert GKs. Secondly, really bad players were too high. For example, a striker with all 6's in CM4 has ratings in or near the 60s in lots of stats. Which is waaaay too high.
I wanted to write formulas that did a good job with Premiership-level players, but also does a good job of rating lower division players as well. So the new formula works like this:
First, I had to compare the stats of a selection of players in both CM4 and WE7. For that group of CM4 players, I took their attributes and "converted them" into a raw score in the form of WE7 attributes. For instance, Aggression in WE7 consists of 75% Aggression and 25% Bravery in CM4. This score can range from 1-20, depending on the player.
This has to be converted to a 0-99 scale. For each attribute, I found the average and standard deviation in WE7 and CM4. From this, we got a raw minimum (usually between 20-35) and a raw maximum (usually about 100), and a unit to decide how much increases in CM4 should translate into increases in WE7.
Since there aren't a lot of 20s in CM4 (which would be 99 in WE7), I noticed that some of the star player ratings were a little worse than they should be, and poor players (think Conference) were a little too good. So we converted this raw WE7 score based on the Current Ability stat in CM4 (which ranges from 1-190). The formula is as follows:
Raw WE7 + (current ability - 140) * (.x(99-Raw WE7)/50)
Basically, any player with a current ability over 140 gets a boost in stats, and this boost increases as the current ability gets higher (max being 190 in CM4). This boost (modulated by .x) is greater for more technical attributes (e.g. technique) and smaller for more physical attributes (e.g. speed, acceleration).
If a player already has a raw 99 WE7 rating, the boost doesn't go into effect. But as the raw rating decreases, the effect of the boost increases. We then threw in another formula such that the highest rating seen in CM4 translates to the best rating for existing players in WE7. So if the highest rating for Dribbling is a 98, this remains.
This also works the other way. Players with a low current ability lose points depending on how bad they are. The worse a player is on their raw WE7 rating, the more current ability affects their rating.
Here are links to the excel files. You need to have either CM4 or CM03/04 AND Search CM4 or Search CM03/04 (links to this program are in the instructions tab of the excel file). Both already have a selection of players in the input tab to show what the output stats look like. MAKE SURE TO READ THE INSTRUCTIONS, especially if you're outputting your own stats. Let me know if you have any questions regarding the excel file.
The small version can convert 100 field players at once, the large one can convert 550 players at once.
DSP CM4-WE7 GK converter version 0.20
DSP CM4-WE7 field player converter version 0.25 (small, 1.6MB)
DSP CM4-WE7 field player converter version 0.25 (large, 8MB)
Also, some people are starting work on an MLS patch. Here are links to converted MLS ratings from CM4, to give you an idea regarding the ratings output. I suggest saving these files. Even though they are .html, they tend to mess up a little when you load them from the web. That, and the field player page is large (about 1.6MB).
WE7 Ratings - MLS Field Players
WE7 Ratings - MLS Goalkeepers
Let me know if you have any questions, comments, advice, etc. More than happy to hear it.
Oh, one more thing. If anyone knows database programming (I don't), then I can put the output stats into one big searchable database on the web. If someone knows how to do this, PM me.
I wanted to write formulas that did a good job with Premiership-level players, but also does a good job of rating lower division players as well. So the new formula works like this:
First, I had to compare the stats of a selection of players in both CM4 and WE7. For that group of CM4 players, I took their attributes and "converted them" into a raw score in the form of WE7 attributes. For instance, Aggression in WE7 consists of 75% Aggression and 25% Bravery in CM4. This score can range from 1-20, depending on the player.
This has to be converted to a 0-99 scale. For each attribute, I found the average and standard deviation in WE7 and CM4. From this, we got a raw minimum (usually between 20-35) and a raw maximum (usually about 100), and a unit to decide how much increases in CM4 should translate into increases in WE7.
Since there aren't a lot of 20s in CM4 (which would be 99 in WE7), I noticed that some of the star player ratings were a little worse than they should be, and poor players (think Conference) were a little too good. So we converted this raw WE7 score based on the Current Ability stat in CM4 (which ranges from 1-190). The formula is as follows:
Raw WE7 + (current ability - 140) * (.x(99-Raw WE7)/50)
Basically, any player with a current ability over 140 gets a boost in stats, and this boost increases as the current ability gets higher (max being 190 in CM4). This boost (modulated by .x) is greater for more technical attributes (e.g. technique) and smaller for more physical attributes (e.g. speed, acceleration).
If a player already has a raw 99 WE7 rating, the boost doesn't go into effect. But as the raw rating decreases, the effect of the boost increases. We then threw in another formula such that the highest rating seen in CM4 translates to the best rating for existing players in WE7. So if the highest rating for Dribbling is a 98, this remains.
This also works the other way. Players with a low current ability lose points depending on how bad they are. The worse a player is on their raw WE7 rating, the more current ability affects their rating.
Here are links to the excel files. You need to have either CM4 or CM03/04 AND Search CM4 or Search CM03/04 (links to this program are in the instructions tab of the excel file). Both already have a selection of players in the input tab to show what the output stats look like. MAKE SURE TO READ THE INSTRUCTIONS, especially if you're outputting your own stats. Let me know if you have any questions regarding the excel file.
The small version can convert 100 field players at once, the large one can convert 550 players at once.
DSP CM4-WE7 GK converter version 0.20
DSP CM4-WE7 field player converter version 0.25 (small, 1.6MB)
DSP CM4-WE7 field player converter version 0.25 (large, 8MB)
Also, some people are starting work on an MLS patch. Here are links to converted MLS ratings from CM4, to give you an idea regarding the ratings output. I suggest saving these files. Even though they are .html, they tend to mess up a little when you load them from the web. That, and the field player page is large (about 1.6MB).
WE7 Ratings - MLS Field Players
WE7 Ratings - MLS Goalkeepers
Let me know if you have any questions, comments, advice, etc. More than happy to hear it.
Oh, one more thing. If anyone knows database programming (I don't), then I can put the output stats into one big searchable database on the web. If someone knows how to do this, PM me.
