Roster Tools - Complete Suite now available

[Bahnzo]

Batting tools for 2003 seems ready. Link is in the first post. Thanks to gtm for relaying the bug messages to me.

You will probably get a message or two about macros and compatibility, and gtm also said he gets one about updating. Just ignore these, except make sure you have macros enabled for this sheet. The update thing? dunno, haven't seen it, sounds like M$ trying to get you to upgrade. If it's a true windows update, then that might not be a bad idea.

[bravesfan1984]

bahnzo you are still working on the pitching for excel 2003 correct?

[bravesfan1984]

another thing...when looking at the 2009 braves, when i get data for brian mccann i get the name brandon patrick mccarthy and when i look up chipper jones i get the name christopher dale jones....haven't checked anyone else but i dont know if this means it's also pulling in the wrong stats or not

[JaFFiTh]

Umm.. Is it possible to do the minors league players? When i try, i get nothing so i'm assuming it only reads the MLB stats. Awesome tool by the way!

[Bahnzo]

Quote: Originally Posted by bravesfan1984

another thing...when looking at the 2009 braves, when i get data for brian mccann i get the name brandon patrick mccarthy and when i look up chipper jones i get the name christopher dale jones....haven't checked anyone else but i dont know if this means it's also pulling in the wrong stats or not

Did you get the warning that comes up about the PA's not matching? If so, then you need to use the "Variation" option next to the players name. Try setting it to "2". The way the naming works on the website, players with similar names have 02 after them, both the names you mention look like that.


Also...I was told about a bug that I totally missed. Some teams don't get pulled up due to their franchise changing in history. I'll have a fix for it soon.

[JaFFiTh]

I'll have to say it's a damn decent tool. Like you said you need to work on the fielding.. I'll have to agree. Just popped up Scott Rolen from last year as I'm sure everyone knows he's one of the best 3B fielder of all time. His fielding showed up as a 55! LOL should be way up there

[Bahnzo]

Quote: Originally Posted by JaFFiTh

I'll have to say it's a damn decent tool. Like you said you need to work on the fielding.. I'll have to agree. Just popped up Scott Rolen from last year as I'm sure everyone knows he's one of the best 3B fielder of all time. His fielding showed up as a 55! LOL should be way up there

Actually, in 2008 Rolen had the most errors on the team and a .964 fielding percentage...far from the "best of all time"

MAJOR UPDATE. Fixed the bug with the teams, make sure you select the correct year for the historical team you are looking up. All version are updated and link are in the first post. Everyone should get and use this update.

Also a PitchFX database has been done, current to 08/02. Link in the first post, just overwrite your old one.

As always, PM me with any bugs you find. I can't check everything, so you get to be the testers!

[JaFFiTh]

Guess those who use excel 03 gotta wait for the pitchers eh. Also you didn't answer my question earlier about minors. Is it possible for me to type in some minor league players in and get the attributes or I'll have to find another way for them?

EDIT: The 2003 file seems to be under 2007 file as it seem to be a xlsm file and not accessible for me.