Ratings Calculator

Mike R · 11-12-2008, 06:42 PM

Hey Everyone,

I don't know if anyone would be interested in this or if it's already been done but I'm working on a ratings calculator. It allows you to enter stats and gives you the ratings that correspond to those stats. I'm doing this for a project I'm working on and thought I would share it. It's still in the early stages and it only does the batters ratings (BABIP, Avoid K's, Gap, Powe, Eye/Patience & Running Speed).

You can download it here Ratings Calculator

I haven't really tested it too much but it appears to be fairly accurate.

Known issues:
I think mainly due to converting the stats to 550AB and numbers being rounded off a few times Hits, Doubles and Triples may sometimes be off by one.

I didn't figure HBP into the OBP so its off a little though this doesn't affect the ratings.

The SLG is also off sometimes. I think it has something to do with the way I rounded it off. This also has no affect on the ratings.

TO Do List:

Add Pitchers Ratings

Being able to add players and ratings to a list so it can be saved, exported and printed

Import comma delimited files for batch calculations

Again I haven't really tested it much but I am continuing to work on it so let me know if you find any bugs or have any suggestions.

Enjoy,
Mike

MB.Pelicans · 11-12-2008, 09:42 PM

This is very cool!!

[WWBL]Batboy · 11-14-2008, 12:33 PM

thank you

EWRBOSDENORD · 12-07-2008, 06:21 PM

Cool!

kurtalb1 · 02-05-2009, 09:25 AM

Mike R, thanks a bunch for this. It helps me out tremendously creating and editing minor leaguers. Are you still working on one for pitchers?

Mike R · 02-05-2009, 10:32 PM

I'm glad you find the program useful. It got put on the back burner for a little bit but I hope to have the pitchers finished soon.

Mike

kurtalb1 · 02-06-2009, 10:46 AM

That would be great. Thanks again!

kurtalb1 · 02-06-2009, 11:10 AM

Mike R,

Actually, when I ran a few more stats through your calculator, there seems to be a problem with the power rating. It jumps from 1 (16 homers in 550 AB) to 103 (17 homers in 550 AB). Just thought you may want to know (if you didn't already).

rasnell · 02-06-2009, 06:39 PM

I'm curious as to how it calculates running speed based on these stats?

Really would have been nice to have this built into the game. Maybe OOTP 10.

I never understood why you have to figure out ratings when everything else is stat based.

Very nice contribution.

Mike R · 02-06-2009, 09:50 PM

kurtalb1, Thanks for catching that bug. I fixed the problem and uploaded the fixed version to the same link as in the first post. If you find anything else that doesn't look right let me know.

rasnell, the gap rating determines the total number of doubles + triples. The running speed rating determines the ratio of doubles and triples. (the higher the rating the more triples and less doubles.)

I agree this should be built into the game.

darkcloud4579 · 02-08-2009, 07:38 PM

This looks great, wow. Thanks for this.

kurtalb1 · 02-09-2009, 10:47 AM

Mike R, it seems to work fine now. Thanks for fixing it so quickly. Also, I figured you used triples for the running speed calculation. Have you thought about using runs scored (minus homeruns) in addition to triples for this? I'm just curious because guys who score a lot of runs are generally fast baserunners.

injury log · 02-09-2009, 08:25 PM

I actually made a spreadsheet in Excel that does ratings-stats conversions for pitchers (and hitters) about a year ago, though there is one tricky bit (Control influences HR rate, and Control and Movement influence K rate) that I never bothered to make perfect. I could dig it off a backup drive and post it at some point if it's of any interest. If you can find them, there are a few threads from a year or two ago where we hashed out all of the relevant formulas, if I recall correctly.

The Design Team actually proposed that this kind of ratings calculator be integrated in OOTP-9, and we wrote up a spec for it, but I think other features took priority. Wouldn't be surprised to see it built into v10, though I have no inside knowledge there.

kurtalb1 · 02-10-2009, 08:34 AM

injury log, I wouldn't mind taking a look at your spreadsheet. It would be VERY cool if they included these "calculators" in OOTP 10!

Mike R · 02-10-2009, 06:24 PM

injury log, most of the formulas came from your posts on the forums. The just had to be reversed (from ratings=stats to stats=ratings) and the running rating to figure D/T ratio was trial and error and still isn't 100% correct but it's close.

I got the formulas from these threads:

Batting Formulas

Pitching Formulas

If your spreadheets include more details I'd like to see them.

Thanks
Mike

EMSoccerCoach · 02-10-2009, 11:47 PM

Very cool stuff, Mike. Small suggestion: Add a reset button at the bottom. Otherwise you have to manually delete all the boxes to run a new batch through. That button would just clear the whole setup to scratch again.

Nice work.

Mike R · 02-11-2009, 06:18 PM

EMSoccerCoach, Good idea. I added a button to clear the stats.

You can get the updated version here

EMSoccerCoach · 02-11-2009, 11:23 PM

Glad to be of help. A very cool utility you have here, and it should be quite useful for what I'm planning roster-wise. Would be cool to work R/L splits in somehow, but I don't want to keep piling crap onto what you're trying to do

Your work is appreciated.

kurtalb1 · 02-19-2009, 11:12 AM

Mike R, not to sound pushy, but I was just curious if you had an idea when you might finish the pitching calculator? Thanks again for all of your hard work!

Mike R · 02-24-2009, 11:38 PM

I have updated the Ratings Calculator to include pitcher ratings. I was having trouble until I read the post about the ratings editor included in OOTP10. It only required BFP, HRA, BB, K and HBP to be entered. Then it all fell into place.

Control primarily affects BB. Movement Affects HRA with a slight adjustment from the Control Rating. Stuff affects K with a slight adjustment from both Control and Movement.

I haven't tested it extensively but it seems to work ok.

I didn't include GB%. This will affect HA. In a previous post 'injury log' stated that the ML average for this is 54. You can adjust this in OOTP however you like.

You can get the updated version of the Ratings Calculator here.

Enjoy,
Mike

11-12-2008, 06:42 PM	#1
Mike R Minors (Rookie Ball) Join Date: Sep 2008 Posts: 30	Ratings Calculator Hey Everyone, I don't know if anyone would be interested in this or if it's already been done but I'm working on a ratings calculator. It allows you to enter stats and gives you the ratings that correspond to those stats. I'm doing this for a project I'm working on and thought I would share it. It's still in the early stages and it only does the batters ratings (BABIP, Avoid K's, Gap, Powe, Eye/Patience & Running Speed). You can download it here Ratings Calculator I haven't really tested it too much but it appears to be fairly accurate. Known issues: I think mainly due to converting the stats to 550AB and numbers being rounded off a few times Hits, Doubles and Triples may sometimes be off by one. I didn't figure HBP into the OBP so its off a little though this doesn't affect the ratings. The SLG is also off sometimes. I think it has something to do with the way I rounded it off. This also has no affect on the ratings. TO Do List: Add Pitchers Ratings Being able to add players and ratings to a list so it can be saved, exported and printed Import comma delimited files for batch calculations Again I haven't really tested it much but I am continuing to work on it so let me know if you find any bugs or have any suggestions. Enjoy, Mike

02-06-2009, 06:39 PM	#9
rasnell Hall Of Famer Join Date: Jan 2003 Location: Frankfort, Kentucky Posts: 3,746	I'm curious as to how it calculates running speed based on these stats? Really would have been nice to have this built into the game. Maybe OOTP 10. I never understood why you have to figure out ratings when everything else is stat based. Very nice contribution. __________________ Charlie Root won more games for the Cubs than any pitcher (201), yet was remembered for one pitch to Babe Ruth. Find out more about the 1929 World Series in my book, "Root for the Cubs: Charlie Root and the 1929 Chicago Cubs." See the web site at www.rootforthecubs.com. The book is at http://www.amazon.com/Root-Cubs-Char...t+for+the+cubs. Beta tester, OOTP 2007-2023 and iOOTP 2011-2014.

02-08-2009, 07:38 PM	#11
darkcloud4579 Hall Of Famer Join Date: Jun 2003 Posts: 8,660	This looks great, wow. Thanks for this. __________________ ------ My Mods Managerial Strategy Pack Competitive Balance Tax Calculator Major League Women's Baseball (OOTP24) quickstart Indian Premier League \| 300+ years of baseball quickstart \| Expatriate League quickstart \| Off-Field Injuries Update \| Women's Name File for OOTP \| ---- Dynasty classics: Centurion comes to OOTP5 \| DC Moneyball Dynasty (2004)

02-10-2009, 11:47 PM	#16
EMSoccerCoach Hall Of Famer Join Date: Apr 2008 Posts: 2,464	Very cool stuff, Mike. Small suggestion: Add a reset button at the bottom. Otherwise you have to manually delete all the boxes to run a new batch through. That button would just clear the whole setup to scratch again. Nice work. __________________ The Pastime Baseball League The Pastime Baseball League - 10-Year Recap The Pastime Boxing Association

02-11-2009, 11:23 PM	#18
EMSoccerCoach Hall Of Famer Join Date: Apr 2008 Posts: 2,464	Glad to be of help. A very cool utility you have here, and it should be quite useful for what I'm planning roster-wise. Would be cool to work R/L splits in somehow, but I don't want to keep piling crap onto what you're trying to do Your work is appreciated. __________________ The Pastime Baseball League The Pastime Baseball League - 10-Year Recap The Pastime Boxing Association

11-12-2008, 09:42 PM	#2
MB.Pelicans Minors (Triple A) Join Date: Aug 2008 Posts: 228	This is very cool!!

11-14-2008, 12:33 PM	#3
[WWBL]Batboy Major Leagues Join Date: Jan 2002 Location: Atlanta, Ga Posts: 485	thank you

12-07-2008, 06:21 PM	#4
EWRBOSDENORD Bat Boy Join Date: Nov 2008 Location: Chicago Posts: 6	Cool!

02-05-2009, 09:25 AM	#5
kurtalb1 Bat Boy Join Date: Apr 2002 Posts: 14	Mike R, thanks a bunch for this. It helps me out tremendously creating and editing minor leaguers. Are you still working on one for pitchers?

02-05-2009, 10:32 PM	#6
Mike R Minors (Rookie Ball) Join Date: Sep 2008 Posts: 30	I'm glad you find the program useful. It got put on the back burner for a little bit but I hope to have the pitchers finished soon. Mike

02-06-2009, 10:46 AM	#7
kurtalb1 Bat Boy Join Date: Apr 2002 Posts: 14	That would be great. Thanks again!

02-06-2009, 11:10 AM	#8
kurtalb1 Bat Boy Join Date: Apr 2002 Posts: 14	Mike R, Actually, when I ran a few more stats through your calculator, there seems to be a problem with the power rating. It jumps from 1 (16 homers in 550 AB) to 103 (17 homers in 550 AB). Just thought you may want to know (if you didn't already).

02-06-2009, 09:50 PM	#10
Mike R Minors (Rookie Ball) Join Date: Sep 2008 Posts: 30	kurtalb1, Thanks for catching that bug. I fixed the problem and uploaded the fixed version to the same link as in the first post. If you find anything else that doesn't look right let me know. rasnell, the gap rating determines the total number of doubles + triples. The running speed rating determines the ratio of doubles and triples. (the higher the rating the more triples and less doubles.) I agree this should be built into the game.

02-09-2009, 10:47 AM	#12
kurtalb1 Bat Boy Join Date: Apr 2002 Posts: 14	Mike R, it seems to work fine now. Thanks for fixing it so quickly. Also, I figured you used triples for the running speed calculation. Have you thought about using runs scored (minus homeruns) in addition to triples for this? I'm just curious because guys who score a lot of runs are generally fast baserunners.

02-09-2009, 08:25 PM	#13
injury log Hall Of Famer Join Date: Apr 2007 Location: Toronto Posts: 9,162	I actually made a spreadsheet in Excel that does ratings-stats conversions for pitchers (and hitters) about a year ago, though there is one tricky bit (Control influences HR rate, and Control and Movement influence K rate) that I never bothered to make perfect. I could dig it off a backup drive and post it at some point if it's of any interest. If you can find them, there are a few threads from a year or two ago where we hashed out all of the relevant formulas, if I recall correctly. The Design Team actually proposed that this kind of ratings calculator be integrated in OOTP-9, and we wrote up a spec for it, but I think other features took priority. Wouldn't be surprised to see it built into v10, though I have no inside knowledge there.

02-10-2009, 08:34 AM	#14
kurtalb1 Bat Boy Join Date: Apr 2002 Posts: 14	injury log, I wouldn't mind taking a look at your spreadsheet. It would be VERY cool if they included these "calculators" in OOTP 10!

02-10-2009, 06:24 PM	#15
Mike R Minors (Rookie Ball) Join Date: Sep 2008 Posts: 30	injury log, most of the formulas came from your posts on the forums. The just had to be reversed (from ratings=stats to stats=ratings) and the running rating to figure D/T ratio was trial and error and still isn't 100% correct but it's close. I got the formulas from these threads: Batting Formulas Pitching Formulas If your spreadheets include more details I'd like to see them. Thanks Mike

02-11-2009, 06:18 PM	#17
Mike R Minors (Rookie Ball) Join Date: Sep 2008 Posts: 30	EMSoccerCoach, Good idea. I added a button to clear the stats. You can get the updated version here

02-19-2009, 11:12 AM	#19
kurtalb1 Bat Boy Join Date: Apr 2002 Posts: 14	Mike R, not to sound pushy, but I was just curious if you had an idea when you might finish the pitching calculator? Thanks again for all of your hard work!

02-24-2009, 11:38 PM	#20
Mike R Minors (Rookie Ball) Join Date: Sep 2008 Posts: 30	I have updated the Ratings Calculator to include pitcher ratings. I was having trouble until I read the post about the ratings editor included in OOTP10. It only required BFP, HRA, BB, K and HBP to be entered. Then it all fell into place. Control primarily affects BB. Movement Affects HRA with a slight adjustment from the Control Rating. Stuff affects K with a slight adjustment from both Control and Movement. I haven't tested it extensively but it seems to work ok. I didn't include GB%. This will affect HA. In a previous post 'injury log' stated that the ML average for this is 54. You can adjust this in OOTP however you like. You can get the updated version of the Ratings Calculator here. Enjoy, Mike Last edited by Mike R; 07-18-2009 at 09:27 PM.