Calculate Manager'S Ratings

[rbfoster]

I'm trying to calculate the team manager's ratings (batting, pitching, fielding, base runnung) for the mvpedit. I have used Dylan's calculators for the players, but am now looking for a way to create the ratings for the managers. Which stats do any of you use, and how are they converted into a percentage for mvpedit? Any help?

I am working on a 1957 mod, by the way.

[Yankee4Life]

I'm trying to calculate the team manager's ratings (batting, pitching, fielding, base runnung) for the mvpedit. I have used Dylan's calculators for the players, but am now looking for a way to create the ratings for the managers. Which stats do any of you use, and how are they converted into a percentage for mvpedit? Any help?

I am working on a 1957 mod, by the way.

That's a hell of a good question. If anyone would know it would be Dylan and I hope he does see this thread.

Good luck on your 1957 mod by the way.

[DylanBradbury]

I'm trying to calculate the team manager's ratings (batting, pitching, fielding, base runnung) for the mvpedit. I have used Dylan's calculators for the players, but am now looking for a way to create the ratings for the managers. Which stats do any of you use, and how are they converted into a percentage for mvpedit? Any help?

I am working on a 1957 mod, by the way.

rbfoster, just to let you know I have seen this thread. I've been feeling a little under the weather lately. When I'm back to 100%, I'll start working on a Manager Rating Calculator.

[rbfoster]

rbfoster, just to let you know I have seen this thread. I've been feeling a little under the weather lately. When I'm back to 100%, I'll start working on a Manager Rating Calculator.

That would be great, Dylan. I'm sure others would be interested also. Thanks.

[Jim825]

I actually created some formulas that I use to create the manager ratings in my Total Classics mods. I will dig out my notes a little later and then post an explanation of how I create the ratings.

[rbfoster]

I actually created some formulas that I use to create the manager ratings in my Total Classics mods. I will dig out my notes a little later and then post an explanation of how I create the ratings.

Thanks Jim825. I'll be watching for it.

[Jim825]

Here's the process I use. The data is specific to the TC1978 mod, however, the basic principles are the same and the only thing that changes from one mod to the next are some of the specific numbers used to calculate the formulas. I ran this procedure by stecropper, since he consulted with RGlass when MVPEdit was created and also developed the Global Roster Tweaks that I use when developing my classic rosters. He thought that the process I was using made sense.

Here's what I do (using TC1978 as an example)

First, I went to http://www.retrosheet.org, went to the year 1978, scrolled down and clicked on the ML Team Totals link. This provided the following stats:

NL Team Batting

AL Team Batting

NL Team Pitching

AL Team Pitching

NL Team Defense by Position

AL Team Defense by Position

For each of the 4 ratings on the manager tab, I used the following data:

hitting -- Team batting average

pitching -- Team ERA

baserunning -- Runs scored

Fielding -- Fielding average

For each rating, I looked at the settings that came with the game, so that I could determine the range of values used by the default rosters. Here are the ranges:

hitting: 75 - 96

pitching: 70 - 99

baserunning: 70 - 98

fielding: 70 - 95

Once I had the range of data, it was just a matter of mapping the data to a specific value in the range.

Here are the details for each rating:

1. Hitting (75 - 96)

In 1978, the team batting averages ranged from .244 (Atlanta Braves) to .276 (Milwaukee Brewers). This meant that the Braves were assigned a

hitting rating of 75 (lowest value)and the Brewers were assigned a rating of 96 (highest value).

The formula to map these values properly is:

75 + (X * (Batting Avg. - .244)) = Hitting Rating

What I had to do here was to come up with a value for 'X'. Since I knew that Milwaukee's .276 batting average equated to a hitting rating of 96, it was just a matter of plugging in those numbers and solving for 'X' as follows:

75 + (X * (.276 - .244)) = 96

75 + (X * .032) = 96

(X * .032) = 21

X = 21 / .032

X = 656.25

Therefore, the hitting rating formula is:

75 + (656.25 * (Batting Avg. - .244)) = Hitting rating

2. Pitching (70 - 99)

In 1978, the team ERA's ranged from 4.67 (Seattle Mariners) to 3.12 (Los Angeles Dodgers) This meant that the Mariners were assigned a pitching rating of 70 (lowest value) and the Dodgers were assigned a rating of 99 (highest value).

The formula to map these values properly is:

99 - (X * (Team ERA - 3.12)) = Pitching Rating

Again, it was a matter of solving for 'X' and in this case, I plugged in values for Seattle (rating of 70, ERA of 4.67):

99 - (X * (4.67 - 3.12)) = 70

99 - (X * 1.55) = 70

29 = (X * 1.55)

29 / 1.55 = X

X = 18.709677

Therefore, the pitching rating formula is:

99 - (18.709677 * (Team ERA - 3.12)) = Pitching rating

3. Baserunning (70 - 98)

In 1978, the runs scored ranged from 534 (Oakland A's) to 804 (Milwaukee Brewers). This meant that the A's were assigned a baserunning rating of 70 (lowest value)and the Brewers were assigned a rating of 98 (highest value).

The formula to map these values properly is:

70 + (X * (Runs Scored - 532)) = Baserunning Rating

Plugging in Milwaukee's Runs scored (804) and Rating (98), we solve for

'X' as follows:

70 + (X * (804 - 532)) = 98

70 + (X * 272) = 98

(X * 272) = 28

X = 28 / 272

X = 0.102941176

Therefore, the baserunning rating formula is:

70 + (0.102941176 * (Runs Scored - 532)) = Baserunning rating

4. Fielding (70 - 95)

In 1978, the fielding average (for all positions) .971 (Oakland A's) to .983 (Philadelphia Phillies). This meant that the A's were assigned a baserunning rating of 70 (lowest value)and the Phillies were assigned a rating of 98 (highest value).

The formula to map these values properly is:

70 + (X * (Fielding Avg. - .971)) = Fielding Rating

Plugging in Philadelphia's Fielding Avg. (.983) and Rating (95), we solve for 'X' as follows:

70 + (X * (.983 - .971)) = 95

70 + (X * .012) = 95

(X * .012) = 25

X = 25 / .012

X = 2083.3333

Therefore, the fielding rating formula is:

70 + (2083.3333 * (Fielding Avg. - .971)) = Fielding Rating

When I calculated an individual rating, I rounded up, if necessary.

Attached you will also find a spreadsheet that contains these formulas. I basically just enter the team information and it calculates the 4 manager rating values for me. For a different TC mod, I simply follow the same process, taking this spreadsheet as a base and tweaking the formulas above based upon the data for the particular season I am modding.

Let me know if you have any questions.

1978_Manager_Ratings.rar

[DylanBradbury]

That's one useful spreadsheet Jim.

rbfoster, if you still want me to make a separate calculator with different formulae, let me know. I think Jim's spreadsheet does the trick though.

[MarkB]

Someone remind me never to get into an algebra argument with Jim.

[Jim825]

Someone remind me never to get into an algebra argument with Jim.

Didn't Trues have you solve equations like this on your Admin application? What almost tripped me up on my application were the questions on quantum physics and string theory, but I just put down "infinity" for most of the answers and was able to squeak by and get my MVPMods Admin certification. :)

[MarkB]

Didn't Trues have you solve equations like this on your Admin application? What almost tripped me up on my application were the questions on quantum physics and string theory, but I just put down "infinity" for most of the answers and was able to squeak by and get my MVPMods Admin certification.

Yeah, well...suffice it to say that social engineering has a wide range of applications. ;)

[Maestro23]

Someone remind me never to get into an algebra argument with Jim.

Well said.

Mark, Jim just made me have that "deer in the headlights" look with that spreadsheet & his post. Must be how people feel when we tell them to SEARCH. :popcorn:

[rbfoster]

Thanks for the formula, Jim. I was close on some of the fields to use, but was way off on the formulas. I'll try these on my 57 mod, and see how everything tests out.

Thanks again.

....Dick

[rbfoster]

Jim, the formula works great. Many thanks for the help. I have acouple of other questions about the manger's ratings. Could I PM a message to you? Thanks. ...Dick

[Jim825]

Jim, the formula works great. Many thanks for the help. I have acouple of other questions about the manger's ratings. Could I PM a message to you? Thanks. ...Dick

Yes you can.