Jimbo's Ratings Calculator inc. Historic Calculator (with downloads)

[saintjimbo1885]

Due to the fact I am unable to modify the opening post of my original thread (banned!!), this is where all my downloads and updates will now be located.

As well as my original basic MLB calculator, I now have a new version that is linked to Brooks Baseball and downloads pitch f/x data into the calculator.

We all love a bit of nostalgia, so I have created a historic ratings calculator that allows you to produce ratings from 1950 onwards.

There is also a nifty wee Excel file that lets you access rosters and basic player info and stats for every team, from 1883 onwards!!

The Brooks Baseball version of the calculator, the historic ratings calculator and the historic rosters program all pull information from the web, so an internet connection is needed for them to work.

Not sure how my ratings will compare to those in MLB The Show 2014 but as usual all the formulas can be modified in the "Calcs" tab and there are alternative formulas listed here as well.


26/03/14 --- New thread started to replace the old one!!
02/04/14 --- Brooks Baseball version of the calculator available to download
14/04/14 --- Fixed issue with pitcher year drop down menu (Historic)
16/04/14 --- Fixed problem with wrong baserunning formula being used (Historic)
17/04/14 --- Fixed issue with the 1969 vsLHP data (Historic)
18/04/14 --- A trial V2 of the Historic Calculator now features personal info
30/04/14 --- A couple of pitcher clutch rating formulas added to historic calc
05/05/14 --- Fixed issue with K/9 rating for 2013
08/05/14 --- Updated calculator query so it can still access Brooks Baseball
15/05/14 --- Additions and minor changes to Historic Calculator formulas
29/05/14 --- Historic Rosters download available
29/05/14 --- Alternative Break Rating calculation added (see page 9)
29/05/14 --- New H/9 formula now being used across all calculators
10/06/14 --- The regular vision formula is now the default in the historic calculator


** My ISP has now stopped providing webspace, so if you require any of the programs below then just leave a message and I will give you a link to them!! **

MLB Calculator with Brooks Baseball data (results up to 12/07/16)

* Note: the Brooks Baseball part of the calculator does not work with Open Office or old versions of Excel

Historic Ratings Calculator (Create ratings from 1950 onwards)


Version 2:

(See note on Page 5 for one issue with the historic calculators!!)

Historic Rosters (Rosters and basic player info/stats for every MLB team from 1883 onwards!!)



If you have any questions or problems then feel free to get in touch!!

[dodgerblue]

re: Jimbo's Ratings Calculator inc. Historic Calculator (with downloads)

Wow Jim, just downloaded the original. I'm not much of a roster guy but I sure appreciate your work here. What kind of results are you getting with these?

[saintjimbo1885]

re: Jimbo's Ratings Calculator inc. Historic Calculator (with downloads)

Wow Jim, just downloaded the original. I'm not much of a roster guy but I sure appreciate your work here. What kind of results are you getting with these?

Found the game played well with the modified OSFM rosters that I used but when it came to simming, I found that the results were pretty mixed - some years worked out ok and then others were well wide of the mark.


I have made a few tweeks for this year and along with the changes they have made to this years game, especially the CPU plate discipline, I don't know how things will work out but I will have fun finding out!!

[Ghost Of The Year]

re: Jimbo's Ratings Calculator inc. Historic Calculator (with downloads)

What's a good stat to determine the "Clutch" attribute rating?
RISP? RISP with 2 out?
Baseball Reference also has a category broken down into what they call
"Late and Close". Wonder if that's clutch enough.

[saintjimbo1885]

re: Jimbo's Ratings Calculator inc. Historic Calculator (with downloads)

What's a good stat to determine the "Clutch" attribute rating?
RISP? RISP with 2 out?
Baseball Reference also has a category broken down into what they call
"Late and Close". Wonder if that's clutch enough.

There are quite a few methods you can use for clutch and it is the one rating where I think the default figures are possibly too high.


The most obvious one is Avg with RISP or OBP with RISP. Fangraphs actually do a +/- clutch rating for each player listed in the yearly batting stats, so working from a mid-point of 50 you could use this to create a rating. Another option might be to use Runs Created.

I suppose like you say, what is a clutch situation and/or does clutch even exist!!??

[Phil Parent]

re: Jimbo's Ratings Calculator inc. Historic Calculator (with downloads)

Awesome work!

I have a question on this.

Say I want to do historical data, would it work if I were to replace all the modern players with old ones?

And do I need to go five years back as in your file or can I just go three years back and the calculator will average things out ok?

[saintjimbo1885]

re: Jimbo's Ratings Calculator inc. Historic Calculator (with downloads)

Awesome work!

I have a question on this.

Say I want to do historical data, would it work if I were to replace all the modern players with old ones?

And do I need to go five years back as in your file or can I just go three years back and the calculator will average things out ok?

Unfortunately due to the way the calculator works, it isn't really possible to just swap modern players with old ones.


I did build a calculator for creating custom years via Fangraphs that you can download.

The only problem is Fangraphs only does Left and Right splits going back to 2002, so if you wanted to go further back you would only be able to produce the same contact/power ratings for either side - you would just put the appropriate batting stats into the left and/or right tab.


You can download it from the link below and there is an instructions tab that walks you through it.

http://www.jamesagrant.webspace.virginmedia.com/jimbos_mlb_ratings_calculator_custom_year.xlsx

[MauerMorneau09]

re: Jimbo's Ratings Calculator inc. Historic Calculator (with downloads)

Hey Jim, this isn't really a 100% accurate way to measure control and pitch break, but I've done some research and this is somewhat of a close method to figuring those ratings out. Normally I'll click on "Pitch Outcomes" on a player's card on Brooks Baseball and add up the "Strike" and "Swing" percentages for control. Obviously when a guy throws less pitches, say under 100, you might get some lopsided numbers when you add em up. Either too high or too low, but it's worth the try. As for break, normally using the "HMov" for fastballs is the way to go. "VMov" for changeups, but those seem like the only accurate break ratings. Once again, not 100%, but worth a shot.

[saintjimbo1885]

re: Jimbo's Ratings Calculator inc. Historic Calculator (with downloads)

Hey Jim, this isn't really a 100% accurate way to measure control and pitch break, but I've done some research and this is somewhat of a close method to figuring those ratings out. Normally I'll click on "Pitch Outcomes" on a player's card on Brooks Baseball and add up the "Strike" and "Swing" percentages for control. Obviously when a guy throws less pitches, say under 100, you might get some lopsided numbers when you add em up. Either too high or too low, but it's worth the try. As for break, normally using the "HMov" for fastballs is the way to go. "VMov" for changeups, but those seem like the only accurate break ratings. Once again, not 100%, but worth a shot.

Thanks a lot for the suggestions, I am modifying the calculator so that it includes the pitch outcomes as well but my only concern is that having looked at a few players, the control rating seems that it is going to be quite high?? How have you found it??

[MauerMorneau09]

re: Jimbo's Ratings Calculator inc. Historic Calculator (with downloads)

Thanks a lot for the suggestions, I am modifying the calculator so that it includes the pitch outcomes as well but my only concern is that having looked at a few players, the control rating seems that it is going to be quite high?? How have you found it??

Yeah it is going to be high with some guys, I putzed around with it on MLB 13, I looked at some guys ratings for control and break and were somewhat close to the Pitch FX data. I forgot to mention that they'll be off for some players by 10 haha, but I'll double check again later. Sometimes it has been spot on for guys, other times completely off. Basically the only thing I can measure control and break from atm.

[saintjimbo1885]

re: Jimbo's Ratings Calculator inc. Historic Calculator (with downloads)

The Brooks Baseball version of the calculator has been updated to also include pitch outcomes which has finally enabled me to produce a control rating for each pitcher/pitch type.


Thanks to MauerMorneau09 for influencing/inspiring the formula... although I have used a variation on his suggestion.


Hope to come up with a suitable fomula for break ratings soon!!


Again, you need an internet link for this version of the calculator to work properly, as it pulls data from the Brooks Baseball website.

[saintjimbo1885]

re: Jimbo's Ratings Calculator inc. Historic Calculator (with downloads)

I have been unable to come up with a good method for calculating pitch break using the Brooks Baseball website and that along with the different pitch classifactions they give (compared to Fangraphs) means that I have done a compromise and included both in my calculator!!

I would suggest looking at both sets of pitching figures and deciding yourself what pitch classifactions to use etc.

In most cases it will be pretty obvious but please remember that Brooks Baseball class 2 seamers as sinkers.

Download here or at the opening post:

http://www.jamesagrant.webspace.virginmedia.com/jimbos_calculator_2014_v2.xlsx

[saintjimbo1885]

re: Jimbo's Ratings Calculator inc. Historic Calculator (with downloads)

One of the most common questions I get asked is about making ratings for older players and whether my calculator can be used to do this.

So, after a wee bit of work, here's my beta historic ratings calculator!!
(Works from 1950 onwards, as this is the earliest I can get splits data from.)

The calclulator pulls its data from the internet, so obviously you need an internet connection for it to work!! Also, due to the amount of data it is pulling in, it can be quite slow to begin with.

If you decide to change years and you are working on batting ratings then you will know when it has collected all the new data as the the boxes Totals, vsLHP and vsRHP will be displaying the new year you have selected. For pitching the box pitching will be displaying the appropriate new year.

Note: The batting and pitching are totally separate entities but on the same page.

Unfortunately, I can't generate ratings for all the attributes and the clutch ratings are a bit.. meh... but you can see all the formulas on the 'Calcs' tab and feel free to modify, change or suggest alternatives.

It should be pretty obvious how to work it but if anybody has any problems etc then feel free to get in touch. Oh and likewise if you notice any errors or mistakes!!

Download here:

http://www.jamesagrant.webspace.virginmedia.com/jimbos_historic_calculator_v1.xlsx

[KCRoyals]

re: Jimbo's Ratings Calculator inc. Historic Calculator (with downloads)

I can not seem to get the historical calculatort to work. I have an older version of excel. Would you be able to talk me through the process, please?

KCRoyals

[saintjimbo1885]

re: Jimbo's Ratings Calculator inc. Historic Calculator (with downloads)

I can not seem to get the historical calculatort to work. I have an older version of excel. Would you be able to talk me through the process, please?

KCRoyals

I'm not actually sure if the historic calculator will work with older versions of excel, as I am unable to test it, as I use the 2010 version.


Basically, when you load the calculator you should get a security warning that data connections have been disabled, so you want to click on the Enable Content button - this allows excel to contact the web for the data it requires.


Having done that it should just be a case of selecting a year from either the batting or pitching drop down box. Once you have selected a year, you need to wait until all the data has finished loading (bottom left of excel window) before you select a batter or pitcher. Sometimes an error comes up that it is unable to connect, due to it timing out (taking too long to gather all the data). If this happens just select another year and then go back to the one you want.


If you could let me know what is happening when you try to run it then I might be able to help and/or fix the problem??