Click here to get your copy now!
I also highly recommend using this in conjunction with WTNY's pitch edits spreadsheet. It's quality work and combined will give you ultimate editing functionality. You can find that in his thread here:
http://www.operationsports.com/forum...-read-faq.html
Things you need to know about the RosterTools program:
This is run on Microsoft Excel, guaranteed to work on 2010 and new versions.
You HAVE to enable Macros and Enable Data Connections (Excel might call it "Active Content"). Excel will prompt you to activate/allow these things under the formula bar.
There are buttons for sorting batter and pitcher names. You only need to click that 1 time after you have selected a new year.
Ratings are weighted by sabermetrics to the game. A full season sim should yield very realistic results.
Arm Strength, Arm Accuracy, and Reaction (as well as Catcher Blocking) are loosely based on FRAA. However, that stuff is incredibly hard to turn into a rating based off any stats, so they are ONLY an estimate. I would recommend adjusting accordingly for player you know have a good arm, or if the player is in the game, just stick with SCEA default ratings for those attributes.
In order to get Blocking ratings, be sure to click the "Catcher?" checkbox. It will populate numbers for you. BE SURE TO UNCHECK IT AFTER YOU SELECT A NEW PLAYER THAT ISN'T A CATCHER!
Do NOT edit or change ANYTHING that isn't on the Home tab. You don't need to click around and edit things, you WILL break it. Just stay on the Home tab.
Scroll down to the bottom and you will see PITCHf/x information. It will tell you what pitches the pitcher you have selected really throws. How often they throw it. What speed they throw it at on average (so you can duplicate that speed in the game by adjusting velocity accordingly) and it gives movement.
There is no formula I could really come up with to portray pitch movement. I recommend just sticking to SCEA default. If it is a created player, then use your judgement.
PITCHf/x data reads in a plus shape +
0 is in the middle, -15 is to the far left, 15 is on the far right, and same for the top and bottom.
So a pitch that has a -9 VMov and a 3 Hmov means that the pitch drops 9 inches, and cuts inside 3 inches. That's an example of how much movement is involved. Use your judgement is all I can say.
If anyone has a formula, I can update the file and reupload.
PLEASE REPORT ANY AND ALL BUGS ASAP SO I CAN FIX AND REUPLOAD!
I plan to keep this thing taken care of. Hope you all enjoy! A lot of work went into this.
Comment