MLB Roster Tools - Pitching available now

[Bahnzo]

Get it HERE

This version will need Excel 2007 to work, I'm working on converting it for those with Excel 2000-2003, but that requires rewriting some code. Should be doable, just needs some time.

To use it, simply choose your team from the dropdown box, and the year, and click "Get Data". Give it some time...it has to retrieve info from Baseball-Reference.com and then lookup the stuff in the database. Depending on your computer, this should take only a few seconds to maybe a minute. I have an older computer and it takes me about 30 secs to update everything.

I'll keep an updated version of the database and upload it every week so you can add in new pitchers that are called up.

Please, let me know if you spot any errors, there are sure to be a few. Also, I'd love to hear what people think of the ratings. This tool is made for everyone, so I want to have a debate on what you think and what can be improved for future versions.

This is from the README file, please make sure you follow this or it will not work properly...

++++++++++++++++++++++++++++
How to Install
==============

Create a folder on your C:\ drive named "bball".
Copy both files to this folder.
Open RosterToolsPitchersV1.xlsm and enjoy!


Potential Problems
==================
You may have to allow Excel to run macros and access the database. By default these are sometimes off in Excel. If that's the case, after opening the spreadsheet, you should see a message in the upper right hand corner with a button you can click. Click this and allow the spreadsheet to do it's thing...there's no malicious code in here.

Also, Some pitchers will not update from the PitchFX database correctly. This is rare, but does happen due to a naming mis-match between MLB and Baseball-Reference.com. One example is Dan Haren. Baseball-Reference has him as "Danny" so he doesn't pull pitch data from the database. To solve this, simply goto the "Data" tab, find him, and change his name. If in doubt, check the spelling of his name in your MLB 09 The Show, those are usually correct.
++++++++++++++++++++++++++++++++++

Here's a screenshot that also has some info on the different functions on the main page and how to use them....

[franch1se]

do you know if its Mac compatible?

I guess I'll find out

[Bahnzo]

Quote: Originally Posted by franch1se

do you know if its Mac compatible? I guess I'll find out

Someone was able to get it to work with a Mac Pro I think it is. So it's possible I suppose depending on the type of Mac and the software you run.

Also, I corrected a minor bug, basically the program not recognizing a RunFB from Left handers. Fixed and the link is updated to reflect the newer file.

[JacobRaines]

Do I have to have Excel of can I use another program like that?

[Knight165]

Quote: Originally Posted by JacobRaines

Do I have to have Excel of can I use another program like that?

You can try an Excel "emulator"...but I don't think the tables will line up correctly in some cases.


M.K.
Knight165

[JacobRaines]

Ok, where can I find a free download of it?

[andrewdon]

i tried it on excel 03 and it works fine just there is way more clickin gto do

[JacobRaines]

Where can I find a download of Excel?