***NOTE: You must have Microsoft Excel (desktop version) with Visual Basic and enable macros in the settings. The utility will NOT work with the online version.
This is a major update. I've been debugging for awhile but I'm going to upload it and ask some interested folks to play around with it and let me know if you see anything weird. If it looks good then I will upload it as an official version and tag some additional files with it (spreadsheets, custom player calculator, etc...) So post any problems or questions here and I'll answer.
New additions:
1) Pitch ratings...all players now have pitch repertoires and ratings of break and control. Velocity for individual pitches is not available, but a top velocity is. This is a first attempt at this and the data is reliable for some and off for others. Also, pitch ratings are not multi-year weighted according to the values you specify - all pitchers have single year ratings for each season.
2) Expanded minor league options. You have the option of adding full (or near full) minor leagues (from about 1915 on). These are all real players, most of which never played in the majors. This will result in each team having way more than the 90 or so slots available, so I doubt most will take advantage of it, but there you have it anyway.
You can also elect to forego minor leaguers or only include those that eventually made it to the majors.
3) The input helper screen has been redone...it now includes additional information such as salary, service time, hitting tendency and more. It also grabs a picture of each player as you cycle through them.
4) I eliminated the screen which had the drop-down menus and player searches. Seemed unnecessary since you can filter the player sheet and I got the impression most people didn't use it anyway.
5) This is a bigger download (178 MB) since there is so much more info, and the main file size is a little bigger and slower since it's doing more. Keep that in mind.
https://www.mediafire.com/file/0fyhj...1beta.exe/file
Enjoy,
JT
This is a major update. I've been debugging for awhile but I'm going to upload it and ask some interested folks to play around with it and let me know if you see anything weird. If it looks good then I will upload it as an official version and tag some additional files with it (spreadsheets, custom player calculator, etc...) So post any problems or questions here and I'll answer.
New additions:
1) Pitch ratings...all players now have pitch repertoires and ratings of break and control. Velocity for individual pitches is not available, but a top velocity is. This is a first attempt at this and the data is reliable for some and off for others. Also, pitch ratings are not multi-year weighted according to the values you specify - all pitchers have single year ratings for each season.
2) Expanded minor league options. You have the option of adding full (or near full) minor leagues (from about 1915 on). These are all real players, most of which never played in the majors. This will result in each team having way more than the 90 or so slots available, so I doubt most will take advantage of it, but there you have it anyway.
You can also elect to forego minor leaguers or only include those that eventually made it to the majors.3) The input helper screen has been redone...it now includes additional information such as salary, service time, hitting tendency and more. It also grabs a picture of each player as you cycle through them.
4) I eliminated the screen which had the drop-down menus and player searches. Seemed unnecessary since you can filter the player sheet and I got the impression most people didn't use it anyway.
5) This is a bigger download (178 MB) since there is so much more info, and the main file size is a little bigger and slower since it's doing more. Keep that in mind.
https://www.mediafire.com/file/0fyhj...1beta.exe/file
Enjoy,
JT
Comment