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....
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....
Comment