- Added full splits. Splits for every year can now be added. The lack of this feature was throwing contact ratings off a bit. Since the appropriate number of plate appearances and at-bats must be calculated for vsRHP and vsLHP, you have to break down walks, sacrifices, and HBP as well. You only need to enter information for vsRHP and it will automatically calculate the vs.LHP numbers.
- Added an adjusted overall rating calculation. Player can accrue overall points well over 99, but since the game truncates the total at that point, you can't tell the differences between players who have totals higher. The adjusted overall rating lets you see this value as a percentage of the maximum value possible for that position. This keeps the rating on a scale of 0-100, but allows you to see more of an absolute value and a better spread between players.
- Made some adjustments to the layout. Had to make everything fit, so made the font a tad smaller and moved some things around. The middle portion I plan to use for vitals when I can figure out how to export the fields properly. This will take some time, though.
---------------------------------------------------------------------------------
UPDATE: I've attached a new archive. Keep in mind the instructions/analysis do not reflect the following changes I've made:
The "Stat Input" section has been significantly changed for pitchers. Instead of reworking the statistics through the sim engine calculations, ratings are now assigned using scales that closely resemble what the devs are probably using. This allows pitcher ratings to be appropriately scaled.
The "Ratings Input" section for pitchers remains unchanged, and still reflects sim engine output. Other than one minor change (see below), calculations for position players is the same.
Some details on changes:
-Stamina Calculation:
You now have a column for IP(R) which denotes the number of innings pitched in relief. The calculator then differentiates between IP as a starter and IP as a reliever. If the position is set to "starter", it uses only starter innings in calculating stamina and ignores innings pitched as a reliever. When set to "long relief", it rates starter stamina using starter innings, reliever stamina using reliever innings, and then creates an average weighted according to the percentage of appearances as a starter vs. reliever. For all other relief pitchers, starter innings are ignored. This is in accordance with what it looks like they're doing.
-Because of the new rating calculation method, the "staff strength" option is removed from stat input.
-Fixed a few incorrect references that I saw.
-Durability calculation for position players now uses a scale close to what appears to be used by the devs.
-Fixed a number of /DIV 0 errors when certain divisor statistics are at zero. This eliminates a number of the ### when cells are not filled out.
Note: Remember that I crafted the tables for pitcher ratings based on correlations between weighted averages for pitchers and the rating assigned to them in the default roster. They are not a product of my own subjectivity, but are derived from the actual correlations observed from the game's own rating system to real-life statistics. If you disagree with the scales, you're not really disagreeing with me, but someone else!
Also, the tables reflect the general trendlines I observed, but I came across a number of instances where ratings for certain players were obviously boosted. All things considered, it's highly probable they're calculating ratings based on similar charts, but are then making minor adjustments to individual players based on their own subjective projections, taking into account recent trends in player performance, changes in teams and ballparks, aging, and any number of other factors.
----------------------------------------------------------------------------------
While I'm not calling this a beta version, I may still do additional work on this, especially after the 2014 version comes out. For now, I'm posting so people can have a look at it.
This is a sim-engine based calculator (requires Microsoft Excel) which attempts to reproduce ratings based on analysis of the simulation engine. It is not an attempt to pinpoint exactly how ratings are assigned by the devs.
There are two portions for both positional players and pitchers. The top half allows a number of season statistics to be input and weighted, returning ratings. The bottom portion allows for the input of ratings and returns a stat line of what would likely be seen in the game as an average over the course of many seasons. The formulas and tables contained in the file were derived from as many as 500 to 900 seasons.
There are some limitations. Initially I started this only for myself, but got drawn into it more and more as time went on. So it lacks the ability to grab statistics from the web, and doesn't contain a full split stats entry function (though there is still splits calculation). I'm hoping that either myself or others can work on this for the future. My knowledge of doing Visual Basic editing in Excel is about zero, and I'd like to add some command button functionality at some point, so if you're good with that, maybe we can join forces and make this a little more user-friendly.
Instructions are attached. There is a simple .txt version and a very detailed .pdf file which also contains my thoughts, analysis, and explanations of methods.
Please read through these before drawing too many conclusions. I have put months and months into this and while there are improvements to be made, I'm happy with how it is currently working.
If you have some quick questions, I'll respond in this thread. If you have some constructive feedback, this would be the place for it. I think it's pretty tight as it now stands but there may be some incorrect references in it in places.
Comment