Home

My Ratings Calculator (with download)

This is a discussion on My Ratings Calculator (with download) within the MLB The Show Last Gen Rosters forums.

Go Back   Operation Sports Forums > Baseball > MLB The Show > MLB The Show Last Gen > MLB The Show Last Gen Rosters
Why Player Ratings Change When Starting Dynasty Mode in College Football 25
What Is Pro Yakyuu Spirits 2024/Professional Baseball Spirits 2024, and How Do You Get It?
The House Rules Hub for Recruiting in College Football 25 Dynasty Mode
Reply
 
Thread Tools
Old 10-12-2012, 08:05 AM   #1
Banned
 
jimbo_1884's Arena
 
OVR: 2
Join Date: Jul 2011
Location: Perth, Scotland
My Ratings Calculator v6 (with download)

This has been my first year playing MLB The Show and I have enjoyed it that much, I decided to have a bash at creating an Excel ratings calculator based on MLB regular season statistics.

I thought I would make it available for people to try and also because I am looking for any feedback or alternative formulas etc.

I am especially interested in any suggestions for formulas for Arm Strength and Accuracy, as I have been unable to think of any, based on the current set of stats that I use.

The calculator is worked by simply selecting the player from the drop down menu on the HOME tab.

If you want to see the formulas I have used, they are listed on the Calcs tab and down the right hand side, I have also listed alternative formulas that could be used instead.

As I am a total newbie to roster making, I can't promise it will be 100% accurate but it has been completed to the best of my abilities.

03/11/12 --- v3 fixes an error with the pitcher k/9 rating ---
05/11/12 --- changed drag bunt formula - doesn't affect rating, just inputs "-" when appropriate ---
17/11/12 --- v4 This fixes the 2012 Tampa Bay Rays pitcher stats with RISP omission ---
17/11/12 --- pitcher H/9 and HR/9 formula changes ---
23/11/12 --- v5 new fielding ability formula and changes to H/9 AND HR/9 ---
02/12/12 --- Have updated the file to include missing players and all players now have detailed personal information ---
21/02/13 --- New version of calculator that is compatible with older versions of Word and Open Office now available ---
03/03/13 --- Bahnzo's formulas added and a formula fix ---
06/03/13 --- v6 new formulas for Base Running Ability and Aggressiveness, Discipline, Bunting and modifications to Catcher Blocking and Reaction ---
17/03/13 --- "user input" tab added ---
06/08/13 --- New version of the calculator available for download but unfortunately, due to its size (14mb) I am unable to upload it.
30/08/13 --- Comapatabilty version for use with older versions of Excel and Open Office now available ---
03/09/13 --- create a year calculator available for download ---
08/10/13 --- Updated to include all the 2013 regular season stats, bios etc. ---


For those with Excel 2010 and later
======================

Calculator:
http://www.jamesagrant.webspace.virg...ator_2013.xlsx

Create a year calculator:
http://www.jamesagrant.webspace.virg...stom_year.xlsx


For those with OpenOffice or older versions of Excel etc
===================================

Calculator:
http://www.jamesagrant.webspace.virg...atability.xlsx

Create a year calculator:
http://www.jamesagrant.webspace.virg...atability.xlsx



The calculator is designed for use with Excel 2010 and later, so there may be some anomalies with the "compatability version" due to trying to work out averages for example, when there are errors etc.

Last edited by jimbo_1884; 10-08-2013 at 09:54 AM.
jimbo_1884 is offline  
Reply With Quote
Advertisements - Register to remove
Old 10-24-2012, 10:25 PM   #2
Banned
 
jimbo_1884's Arena
 
OVR: 2
Join Date: Jul 2011
Location: Perth, Scotland
Re: My Ratings Calculator (with download)

I have fixed an error in the calculator that meant some names (U-Z) were missing from the pitcher list in the drop down menu.

Also about to collate pitcher stats and try to incorporate basic pitcher ratings within the calculator.

So, if anybody has any formulas etc. they would like me to include for calculating the basic pitcher ratings, then let me know.

Last edited by jimbo_1884; 10-25-2012 at 07:24 PM.
jimbo_1884 is offline  
Reply With Quote
Old 10-24-2012, 11:34 PM   #3
Rookie
 
doominic77's Arena
 
OVR: 0
Join Date: Nov 2011
Location: Calgary, AB
Re: My Ratings Calculator (with download)

This calculator looks and works really nicely. Good job!
__________________
NHL: Calgary Flames
NFL: Baltimore Ravens
NBA: Los Angeles Clippers
MLB: Toronto Blue Jays
NCAAF: Miami Redhawks
NCAAF: LSU Tigers
NCAAB: LSU Tigers
doominic77 is offline  
Reply With Quote
Old 10-28-2012, 10:28 AM   #4
Pro
 
OVR: 10
Join Date: Jan 2006
Blog Entries: 1
Re: My Ratings Calculator (with download)

Yes this looks really good, a good calculator if you want to kind of do an overall 2013 roster. Good Job with these.
Rwings832 is offline  
Reply With Quote
Old 10-28-2012, 05:54 PM   #5
Banned
 
jimbo_1884's Arena
 
OVR: 2
Join Date: Jul 2011
Location: Perth, Scotland
Re: My Ratings Calculator (with download)

Quote:
Originally Posted by jimbo_1884
I have fixed an error in the calculator that meant some names (U-Z) were missing from the pitcher list in the drop down menu.

Also about to collate pitcher stats and try to incorporate basic pitcher ratings within the calculator.

So, if anybody has any formulas etc. they would like me to include for calculating the basic pitcher ratings, then let me know.

I've now added 3 years worth of pitching stats but unfortunately, I have ZERO ideas for formulas.... ok I have a couple but none I'm happy with!!

So, if anybody can help with formulas for:

Stamina
Pitching Clutch
H/9
HR/9
k/9
BB/9

I can/will upload an updated version of my calculator with pitcher ratings.
jimbo_1884 is offline  
Reply With Quote
Advertisements - Register to remove
Old 10-28-2012, 06:48 PM   #6
The Future
 
seanjeezy's Arena
 
OVR: 34
Join Date: Aug 2009
Location: The 206
Posts: 3,351
Re: My Ratings Calculator (with download)

Stamina: ((IP/G) / 7.34) * 100 for starters, (((IP/G) / 7.34) * 100) *2 for relievers

Clutch: use the clutch ratings on fangraphs and this scale (also from fangraphs) -

99 = 2
88 = 1.5
77 = 1
66 = 0.5
55 = 0
44 = -0.5
33 = -1
22 = -1.5
11 = -2

Position players: ((((C / (G/162)) - C1) / 0.5) *11) + R1
Starters: ((((C / (G/33)) - C1) / 0.5) *11) + R1
Relievers: ((((C / (G/61)) - C1) / 0.5) *11) + R1

* C1 = closest clutch rating on the scale rounded down (so 1.48 would be 1)
* R1 = the rating that corresponds with C1 on the chart (so 1 would be 77)

I came up with these by myself, I think at the time, 7.34 IP was the highest average in the league, and the clutch rating is simply the difference quotient set on the 0 - 99 scale. The other stuff I just use Bahnzo's calculator for, the formulas might be floating around somewhere in the forum.
seanjeezy is offline  
Reply With Quote
Old 10-29-2012, 03:09 PM   #7
Rookie
 
OVR: 0
Join Date: Dec 2011
Location: Boston
Quote:
Originally Posted by jimbo_1884
I've now added 3 years worth of pitching stats but unfortunately, I have ZERO ideas for formulas.... ok I have a couple but none I'm happy with!!

So, if anybody can help with formulas for:

Stamina
Pitching Clutch
H/9
HR/9
k/9
BB/9

I can/will upload an updated version of my calculator with pitcher ratings.
I think you're putting in place right now foundations for something great for roster makers.

Just curious, what tool and what data source do you use for mass import data?
Richie12 is offline  
Reply With Quote
Old 10-29-2012, 05:50 PM   #8
Banned
 
jimbo_1884's Arena
 
OVR: 2
Join Date: Jul 2011
Location: Perth, Scotland
Re: My Ratings Calculator (with download)

Quote:
Originally Posted by seanjeezy
Stamina: ((IP/G) / 7.34) * 100 for starters, (((IP/G) / 7.34) * 100) *2 for relievers

Clutch: use the clutch ratings on fangraphs and this scale (also from fangraphs) -

99 = 2
88 = 1.5
77 = 1
66 = 0.5
55 = 0
44 = -0.5
33 = -1
22 = -1.5
11 = -2

Position players: ((((C / (G/162)) - C1) / 0.5) *11) + R1
Starters: ((((C / (G/33)) - C1) / 0.5) *11) + R1
Relievers: ((((C / (G/61)) - C1) / 0.5) *11) + R1

* C1 = closest clutch rating on the scale rounded down (so 1.48 would be 1)
* R1 = the rating that corresponds with C1 on the chart (so 1 would be 77)

I came up with these by myself, I think at the time, 7.34 IP was the highest average in the league, and the clutch rating is simply the difference quotient set on the 0 - 99 scale. The other stuff I just use Bahnzo's calculator for, the formulas might be floating around somewhere in the forum.

Thanks for the formula suggestion.....

Initially I was going to go with 9 (total innings), then I changed it to 6 (mlb average) but they gave either too low or high ratings, so the idea of working from the highest average makes perfect sense!!

As for clutch, I was simply going to base my figure around the OBP with RISP.
jimbo_1884 is offline  
Reply With Quote
Reply


« Previous Thread | Next Thread »

« Operation Sports Forums > Baseball > MLB The Show > MLB The Show Last Gen > MLB The Show Last Gen Rosters »



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -4. The time now is 12:20 PM.
Top -