Made my own ratings calculator

[DeathMetal]

I made this with Excel 2003. It's something I've been working on on and off for months now.

It has an automatic ratings calculator with a pull down list of players, just select the player you want and it will bring up his stats for 09, 10, and 11 and calculate his in game ratings. There is also a manual calculator where you can input the stats yourself, and you can enter up to three years if you want.

This will show ratings for individual years, 3 years avg., and 3 years weighted to the latest year.

This is only for position players and only covers contact (L, R), power (L,R), vision, discipline, and clutch.

*Updated 4/9/2012

[spboden]

Nice, seems pretty accurate, have you tried putting these in yet?

[DeathMetal]

No, I haven't really tested these out for a significant amount of time in game yet. I have played like one game with two edited teams and it seemed to play well, but I haven't played through and entire season or anything like that. I did notice though that a lot of players are underrated in power and contact in Sony's roster.

[spboden]

I use knights OSFM full minor roster....i think i will start to update players based off this and let you know. thanks

[Scott]

Plan on adding anything for Durability and Fielding Ability?

[Scott]

Inputed some those ratings for Texas as well as the Top 15 Players on each team....
Starters
Kinsler - .256, 29 HR, 148 H, 88 RBI
Andrus - .238, 4 HR, 136 H, 40 RBI
Beltre - .269, 25 HR, 141 H, 77 RBI
Hamilton - .309, 19 HR, 123 H, 65 RBI (missed a lot of time)
Young - .258, 23 HR, 153 H, 91 RBI
Cruz - .271, 41 HR, 140 H, 100 RBI
Napoli - .268, 36 HR, 140 H, 104 RBI
Murphy - .275, 20 HR, 130 H, 69 RBI
Moreland - .258, 14 HR, 99 H, 47 RBI
Bench
Torrealba - .249, 5 HR, 57 H, 23 RBI
Gonzalez - .200, 1 HR, 53 H, 14 RBI
Borbon - .316, 3 HR, 95 H, 31 RBI
Martin - .257, 2 HR, 58 H, 14 RBI

BA Leader - Mauer - .330
H Leader - Mauer - 209
2B Leader - Ichiro - 55
3B Leader - Crisp - 10
HR Leader - Konerko - 43 (Gomes had 42, Cruz 41, Cabrera 39, Pena 39, Martinez 37, Longoria 36, Fielder 36
RBI Leader - V-Mart - 120 (13 players had 100+, not bad)

Playoff Stats
Kinsler - .242, 5 HR, 16 H, 12 RBI
Andrus - .127, 0 HR, 9 H, 2 RBI
Beltre - .290, 4 HR, 20 H, 9 RBI
Hamilton - .354, 6 HR, 23 H, 13 RBI
Young - .109, 1 HR, 7 H, 1 RBI
Cruz - .179, 2 HR, 10 H, 6 RBI
Napoli - .262, 5 HR, 16 H, 10 RBI
Murphy - .220, 1 HR, 13 H, 4 RBI
Moreland - .292, 2 HR, 14 H, 8 RBI

Rangers lost to Phillies in the WS, 4 games to 2.

[DeathMetal]

Quote: Originally Posted by Scott

Plan on adding anything for Durability and Fielding Ability?

I wasn't really planning on it but I might look into it. I would need to try to figure out what stats to use for each and how to calculate the ratings from them. It would just take a lot of work inputting the extra stats into the databases. There are a lot of players in there.

Quote: Originally Posted by Scott

Inputed some those ratings for Texas as well as the Top 15 Players on each team.... Starters Kinsler - .256, 29 HR, 148 H, 88 RBI Andrus - .238, 4 HR, 136 H, 40 RBI Beltre - .269, 25 HR, 141 H, 77 RBI Hamilton - .309, 19 HR, 123 H, 65 RBI (missed a lot of time) Young - .258, 23 HR, 153 H, 91 RBI Cruz - .271, 41 HR, 140 H, 100 RBI Napoli - .268, 36 HR, 140 H, 104 RBI Murphy - .275, 20 HR, 130 H, 69 RBI Moreland - .258, 14 HR, 99 H, 47 RBI Bench Torrealba - .249, 5 HR, 57 H, 23 RBI Gonzalez - .200, 1 HR, 53 H, 14 RBI Borbon - .316, 3 HR, 95 H, 31 RBI Martin - .257, 2 HR, 58 H, 14 RBI BA Leader - Mauer - .330 H Leader - Mauer - 209 2B Leader - Ichiro - 55 3B Leader - Crisp - 10 HR Leader - Konerko - 43 (Gomes had 42, Cruz 41, Cabrera 39, Pena 39, Martinez 37, Longoria 36, Fielder 36 RBI Leader - V-Mart - 120 (13 players had 100+, not bad) Playoff Stats Kinsler - .242, 5 HR, 16 H, 12 RBI Andrus - .127, 0 HR, 9 H, 2 RBI Beltre - .290, 4 HR, 20 H, 9 RBI Hamilton - .354, 6 HR, 23 H, 13 RBI Young - .109, 1 HR, 7 H, 1 RBI Cruz - .179, 2 HR, 10 H, 6 RBI Napoli - .262, 5 HR, 16 H, 10 RBI Murphy - .220, 1 HR, 13 H, 4 RBI Moreland - .292, 2 HR, 14 H, 8 RBI Rangers lost to Phillies in the WS, 4 games to 2.

What do you think about the results, do HR's seem too high? Also which ratings did you use, 3 year average or weighted or?

[thevaliantx]

Why won't SCEA release to the gaming community its formulas for ratings so that folks like you can create software to allow for easy rostering creation and editing?