My Ratings Calculator (with download)

[Number1SensFan]

Re: My Ratings Calculator (with download)

Thanks to Fangraphs it would pretty much just be a copy and paste job of all the stats.


It would then be a case of you choosing which formulas you thought were best to use out of those listed in the 'CALCS' tab and if any need averages or maximums etc working them out.


You would also need to add the new (old)players into the drop down list.


Would probably take about an hour to do tops!!


I might actually look at a way for doing a custom year as it could be a good/popular option.


(Right it's past 2am over here in Scotland, so I'm off to bed!!)

Okay, thanks for the help!

[Rwings832]

Re: My Ratings Calculator (with download)

[QUOTE=jimbo_1884;2045406718]Thanks to Fangraphs it would pretty much just be a copy and paste job of all the stats.


It would then be a case of you choosing which formulas you thought were best to use out of those listed in the 'CALCS' tab and if any need averages or maximums etc working them out.


You would also need to add the new (old)players into the drop down list.


Would probably take about an hour to do tops!!


I might actually look at a way for doing a custom year as it could be a good/popular option.


(Right it's past 2am over here in Scotland, so I'm off to bed!!)[/QUOTE
Would definately be interested in that

[jimbo_1884]

Re: My Ratings Calculator (with download)

Just noticed that the 2012 power rating vs RHP was not being calculated using the comparative formula (like all the other years and the vsLHP) and was using the basic figure instead, so have updated the calculator with this formula change.


Have also had a bash at a custom year calculator and you can download it here (1.5mb long):

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

Instructions are included but I should point out that I haven't properly tested it yet but I don't foresee any problems as long as you stick to the instructions.


As usual, if you have any problems or if you spot any errors, feel free to get in touch.


Oh and please note the custom year calculator will only work on Excel 2010 and later.

[Joey]

Re: My Ratings Calculator (with download)

I'm much more familiar with B-R over Fangraphs so I have a question. Where the heck do you view the Splits? I swear I've looked everywhere and I'm sure it's right under my nose, but I just don't see it! I'm trying to look up the '61 Yankees, for example, and I pulled the Full Season stats but can't for the life of me figure out where the splits are. Any help would be greatly appreciated!

[jimbo_1884]

Re: My Ratings Calculator (with download)

Don't worry, you aren't going mad!!


Unfortunately, Fangraphs only have splits available for 2002 onwards.


You could of course use Baseball Reference, as it doesn't actually matter where you get the data from, only that when you copy and paste it into the calculator it is laid out the correct way.

[jimbo_1884]

Re: My Ratings Calculator (with download)

Just done a quick test using the 2004 Fangraphs data (it's the data in the version you download) and everything seems to be working ok. So here are all the downloads.

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

Calculator:

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

Create a year calculator:

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

For those with older versions of Excel or Open Office etc
===================================

Calculator:

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

Create a year calculator:

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

[Joey]

Re: My Ratings Calculator (with download)

You know, I didn't even try another more recent year to see if the info provided was different. Thanks and yes, I'll definitely get on Baseball Reference at lunch and try it out. Thanks for your efforts on this!

[JaFFiTh]

Re: My Ratings Calculator v6 (with download)

Thanks to you. I finally got my calculator the way i wanted it! Tried to get it to have weighted 3 years average but wasn't sure how so i just did the normal average. Now I finally got to see how u did it.. All set in my spreadsheet and ready to play... Or should i say work? Lol

[jimbo_1884]

Re: My Ratings Calculator v6 (with download)

Have updated the calculator with stats up to the end of the 2013 regular season and added all the new players from this year to the drop down player list.


I do have still to input all their weights, heights etc. however.


Download here:

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

The default formulas I have used are mainly the comparative ones (ie. Chris Davis gets a power 99 and every one else works back from that) but as usual, all the other formulas are listed in the Calcs tab and they can easily be swapped/changed to your own preference.


Oh and this is only for Excel 2010 and later.

[BretttheJet11]

Re: My Ratings Calculator (with download)

This is great news. Thanks for the update, fine work!

[JaFFiTh]

Re: My Ratings Calculator v6 (with download)

Didn't your spreadsheet used to have the minor league converter from AAA to MLB? I'm sure I saw that somewhere. Would come in handy for my spreadsheet as I do every player including minors and it's pain in the arse using the minorsplit and Minor Central thing (where I get the splits from). Would be nice being able to just type down the numbers and having the spreadsheet doing everything at once.

[jimbo_1884]

Re: My Ratings Calculator v6 (with download)

Have updated the calculator so that it now has all the info for the 2013 regular season... stats, players, bios etc.

Also added my old Milb worksheet to the calculator but please be aware that the way I calculate figures now is different to the way they are done in the MiLB sheet, so it isn't really relative any more, although it still differentiates between the levels ok etc. I suppose the formulas could be changed/altered though.

The compatability version that works with OpenOffice etc. has also been completed but for some bizarre reason I can only get the new durability formula to work with pitchers... which I don't understand at all!!

Download all my stuff here:


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 Open Office etc
===================

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

Create a year calculator:

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

Oh and it all comes with the usual caveat... done to the best of my ability etc.

If you do spot any errors, feel free to let me know!!

[AC]

Re: My Ratings Calculator (with download)

Do you link your data with an online web base in excel? It'd probably make life easier.

[jimbo_1884]

Re: My Ratings Calculator (with download)

Do you link your data with an online web base in excel? It'd probably make life easier.

Unfortunately, I don't have it linked.


I have tried, even bought the book 'Baseball Hacks' to help me, but I have never been able to get it to work properly.

Now that I use fangraphs for all my stats, instead of mlb.com, it is a lot easier and quicker to update though.

[AC]

Re: My Ratings Calculator (with download)

You can link databases in fangraphs, have you tried creating a custom report that contains all your wanted data and linking it?

(You link by going Alt + A + FW and then inputting the address and clicking on the table.)