http://www.mediafire.com/download/kd...Builder(2).exe
File size: 63 MB
-------------------------------------------------------------------------------------------------------------
* Fixed a problem where fielding ability was calculating incorrectly when using career ratings.
Update (4/11)
------------------------------------------------------------------------------------------------
Update (2/21) version 1.0
*Changed the file path to the root C: drive
*Corrected pitcher overall calculation
*Minor reference error corrections.
-------------------------------------------------------------------------------------------------------
Update (2/14). The following fixes and features were added:
* Reordered attributes to match those found in game edit screen.
* Corrected a problem with career ratings scaling
* Added a "Reset all settings to default" command button.
* Fixed a problem that was causing overall ratings for pitchers to be calculated incorrectly.
* Added a Stamina adjustment for pitchers on the Ratings page (scroll right for the option which will be on by default). This ensures that stamina ratings will be adjusted based on whether a player is a SP, RP, or CP. This has more effect as the roster year goes further back in history. Since higher stamina ratings adversely affect batting averages, this will help correct a potential problem caused by much higher stamina ratings for time periods where pitchers threw far more innings.
------------------------------------------------------------------------------------------------------
Greetings, friends.
I'm posting a link for a free Historical Roster Building Utility that I've just finished and calling a beta version as of right now. The .rar file will install to a default location, but be sure to read the message prior to extraction.
This utility was a year in the making and I put a lot of hard work into it. It uses pre-calculated ratings completed for all years from 1902 to present. I'll discuss the calculator issue after listing the general features.
The utility requires Microsoft Excel version 2007 (I'm assuming it will work with later versions, but this is untested). You need Visual Basic installed and will need to adjust some settings in Excel which are described in the instructions.
Features:
* Complete vital statistics and ratings for all MLB players dating back to 1902. All data is contained in .xlsx files serving as a database. No web querying necessary.
* Automated roster-building which builds rosters, adds free agents, and minor leaguers. There are a number of options which allow you to set yearly weights and different rating types.
* Player search and edit features which allow easy searching of all MLB players in a given year.
* A Player generator will complete rosters to 90+ players using vital statistic and ratings averages for the selected year, and will fill rosters for all major league franchises which were not in existence for the particular year.
* Roster file creation which sets up all data in easy-to-access excel file, giving you the option to create separate team roster pages.
* The rating system used was designed based on careful study which compared stock ratings to numerous statistics (ranging from simple to more advanced), in order to determine which ones yielded the highest correlation.
* Ratings have been mathematically scaled based on actual fluctuations in major league statistics in conjunction with observations made concerning the sim engine. (Initial testing has been quite good in this regard.)
* Career rating options which allow any rating of your choosing to reflect a player's lifetime performance.
* and more...
More details found in the accompanying instructions.
On that note, please read the instructions. While I provided on-screen instructional guides, they are not exhaustive. There is a lot to do with this, so you'll have to be patient in order to get comfortable with it.
Unfortunately, it does not calculate specific pitch information. Though the functionality to add it yourself is there and needs some reworking. Future versions may expand on this feature.
Since this is a beta version, there could possibly be some bugs here and there, so you can use this thread for reporting and questions.
On the calculator I used:
I began this project over a year ago and intended to release the calculator, but after careful consideration, I opted to refrain from uploading it, at least for the time being. There is a fuller explanation contained in the instructional .pdf file. For now, understand that I put a tremendous amount of time and effort into this, and at this juncture I'm just not ready to share that portion of my work. I hope you'll understand this.
Some questions concerning ratings calculations are answered in the instructions. However, if the need arises, I can elaborate further.
For now, I'm interested in any bugs or errors that might pop up for people as they play around with this a bit.
Cheers,
JTommy67
File size: 63 MB
-------------------------------------------------------------------------------------------------------------
* Fixed a problem where fielding ability was calculating incorrectly when using career ratings.
Update (4/11)
------------------------------------------------------------------------------------------------
Update (2/21) version 1.0
*Changed the file path to the root C: drive
*Corrected pitcher overall calculation
*Minor reference error corrections.
-------------------------------------------------------------------------------------------------------
Update (2/14). The following fixes and features were added:
* Reordered attributes to match those found in game edit screen.
* Corrected a problem with career ratings scaling
* Added a "Reset all settings to default" command button.
* Fixed a problem that was causing overall ratings for pitchers to be calculated incorrectly.
* Added a Stamina adjustment for pitchers on the Ratings page (scroll right for the option which will be on by default). This ensures that stamina ratings will be adjusted based on whether a player is a SP, RP, or CP. This has more effect as the roster year goes further back in history. Since higher stamina ratings adversely affect batting averages, this will help correct a potential problem caused by much higher stamina ratings for time periods where pitchers threw far more innings.
------------------------------------------------------------------------------------------------------
Greetings, friends.
I'm posting a link for a free Historical Roster Building Utility that I've just finished and calling a beta version as of right now. The .rar file will install to a default location, but be sure to read the message prior to extraction.
This utility was a year in the making and I put a lot of hard work into it. It uses pre-calculated ratings completed for all years from 1902 to present. I'll discuss the calculator issue after listing the general features.
The utility requires Microsoft Excel version 2007 (I'm assuming it will work with later versions, but this is untested). You need Visual Basic installed and will need to adjust some settings in Excel which are described in the instructions.
Features:
* Complete vital statistics and ratings for all MLB players dating back to 1902. All data is contained in .xlsx files serving as a database. No web querying necessary.
* Automated roster-building which builds rosters, adds free agents, and minor leaguers. There are a number of options which allow you to set yearly weights and different rating types.
* Player search and edit features which allow easy searching of all MLB players in a given year.
* A Player generator will complete rosters to 90+ players using vital statistic and ratings averages for the selected year, and will fill rosters for all major league franchises which were not in existence for the particular year.
* Roster file creation which sets up all data in easy-to-access excel file, giving you the option to create separate team roster pages.
* The rating system used was designed based on careful study which compared stock ratings to numerous statistics (ranging from simple to more advanced), in order to determine which ones yielded the highest correlation.
* Ratings have been mathematically scaled based on actual fluctuations in major league statistics in conjunction with observations made concerning the sim engine. (Initial testing has been quite good in this regard.)
* Career rating options which allow any rating of your choosing to reflect a player's lifetime performance.
* and more...
More details found in the accompanying instructions.
On that note, please read the instructions. While I provided on-screen instructional guides, they are not exhaustive. There is a lot to do with this, so you'll have to be patient in order to get comfortable with it.
Unfortunately, it does not calculate specific pitch information. Though the functionality to add it yourself is there and needs some reworking. Future versions may expand on this feature.
Since this is a beta version, there could possibly be some bugs here and there, so you can use this thread for reporting and questions.
On the calculator I used:
I began this project over a year ago and intended to release the calculator, but after careful consideration, I opted to refrain from uploading it, at least for the time being. There is a fuller explanation contained in the instructional .pdf file. For now, understand that I put a tremendous amount of time and effort into this, and at this juncture I'm just not ready to share that portion of my work. I hope you'll understand this.
Some questions concerning ratings calculations are answered in the instructions. However, if the need arises, I can elaborate further.
For now, I'm interested in any bugs or errors that might pop up for people as they play around with this a bit.
Cheers,
JTommy67
Comment