View Single Post
Old 03-13-2005, 10:36 AM   #1
Jayzone
All Star Reserve
 
Jayzone's Avatar
 
Join Date: Apr 2004
Posts: 706
Arrow Update: Rating Translator/Expected Performance Scout v0.93b is now available!

Note: Note: This version of Rating Translator is not compatible with previous versions (eg. V0.8xb and v0.92b). This means that the old versions of rating_translation.csv can not and should not be used with the new version.

Note: If you are new to this utility, please read the manual (can be found in program file shortcuts) first. Even if you are already familiar with the old version of this utility, I still strongly recommend you to read the readme/manual file since there are quite a few changes from the old versions.

Note:If you have previous version installed, it is strongly recommended that you uninstall any previous version of Rating Translator.

**************************************************

Note: CommishJoe's CSV Exporter v1.01 is required to be used prior using this program. (The CSV files generated from the CommishJoe's CSV Exporter are used as the input data files here.) Also, special thanks to CommishJoe for making the CSV Exporter. This mod wouldn't have been a reality without his wonderful add-on mod.

Note: Alternatively, you can opt to use CSV Exporter with its own GUI wrapper. The GUI wrapper is written by the same person who wrote the terrific GUI for this utility, Eriq Jaffe. More info on CSV Exporter can be found on Eriq Jaffe’s personal website: http://www.geocities.com/eriqjaffe/ The GUI wrapper can also be found at JoeRockEHF’s wonderful OOTP Download Center: http://www.ootpdownloadcenter.com/

Edit: All OOTP Download Center files can now be found at CLB - OOTP Download.

Note: The {players.csv; bat_stats.csv; pitch_stats.csv} are used as the data source for translator.bat to generate the rating to stats look-up table. The {players.csv} is used as the data source for scout.bat. The above mentioned files are the CSV files needed from CommishJoe's CSV Exporter.

I already posted this in the Mod forum. This is just an announcement here.

Version: 0.93b

--------------------------------------------------------------------------

Change/Fixes in v0.93b

- SB/CS projection is now included.

Due to the fact the SB/CS projection needs to be based on other stats projections, the accuracy of SB/CS projection will be worse than most. The inaccuracy issue is more apparent for the best base stealers. This means that, for a very good base stealer, it’s not unusual to see a discrepancy between projected SB and actual SB. That being said, I still think the projection is at least satisfactory. As the result, I now offer the option of including SB/CS in the calculation of XR. This way, you can separate the SB/CS component in XR if you think SB/CS is not accurate enough.

- DIPS ERA projection is now included.

Finally, DIPS ERA has made it into Rating Translator. The calculation of DIPS ERA is based on Voros McCracken's DIPS 2.0 method. I offer two options in how to calculate DIPS ERA. The difference lies in how BABIP is calculated. The default option is my modified BABIP calculation method, which is dynamically adjusted to the real league environment. The second option is to use Voros’ original BABIP calculation method. This means that all factors in BABIP calculation will not be dynamically modified but rather follow original factors to the letter instead. My experience is that my modified BABIP method reflects the real DIPS ERA better. Anyhow, the choice is yours to make.

- Stats projections based on split ratings (VSR, VSL) are now included.

Rating Translator now has the option to perform stats projection based on split ratings. This split rating projection is not adjusted to opponent level, but rather based on the existing rating to stats formulas used by overall rating/talent projection. Basically, I just use the same formulas to calculate split performance. The plate appearance of split stats is based on the default 7 to 3 ratio. This means that a 600PA player will have 600*0.7 = 420 PA VSR and 600*0.3 = 180 PA VSL. If you feel the output screen is cluttered, then you just opt not to perform split stats projection.

- HBP number in config.txt is now changed to become HBP per 550 BF, which is in the same unit as HBP rating in OOTP. So, if you want to sub in real HBP rating, then you could just simply sub in the number instead of calculating HBP per single BF like before.

- Minor code improvements

--------------------------------------------------------------------------

Hi,

This is a add-on utility mod specifically created for OOTP6.

And this is also my first attempt (third public version) in add-on utility mod creation.

The purpose of this add-on is to translate the players' ratings into stats (expected performance).

The translation between ratings and the expected performance is a problem that has no easy answer. The rating to stats translation needs to be done within context, not depending on pre-determined translation formulas. The actual translation depends on league total setting, rating itself and also the opposition rating. In short, pretty much every league will have its own unique rating translation formulas. This program is designed to perform the translation dynamically. The utility program attempts the rating translation by constructing a rating/actual stats loop-up table and then calculating the regression formula (best-fit line) for each rating/stats relationship. By doing this, the rating/stats translation is guaranteed to be tailor-made to the individual league setup.

As metioned above, the tanslation formula is generated from the rating translation look-up table. The construction of the look-up table is done by list the x-y table between the weighted-average of ratings and weighted-average of stats. Then the rating to stats translation formulas are calculated by using regression method. After that, the expected stats performance of the user desinated player is calculated. A sample output of the program is demostrated below (with split stats projection option enabled):

Code:
Sample output of the program:

Expected Performance Scout v0.93b

Note: If the talent rating scale is different than the ability rating scale, then the talent translation will be incorrect.

Player ID: 1401
Name: #7 Luigi Crespo
Nick name: 
Bat: R Throw: R
Age: 40 Position: SS

Running Rating:
  Speed  Steal Run.I.
     24     13     60

Batting:
Ability Rating:
  Contact Gap Power     Power       Eye   Avoid K
       45        50        33        32        46

Expected Performance:
      PA   AB     H 2B+3B  2B  3B  HR   BB    K    AVG   OBP   SLG   OPS   SA%   SB%   SB   CS     XR *XR/27
High  600  559  130  26    24   2  11   41  124  0.232 0.285 0.343 0.628   0.8  49.8    1    1   74.9   4.71
Mid   600  559  129  26    24   2  11   41  125  0.231 0.283 0.340 0.623   0.4  49.6    0    0   74.0   4.65
Low   600  559  128  26    24   2  11   41  127  0.229 0.282 0.338 0.619   0.1  49.4    0    0   73.1   4.58

Ability Rating Split:
     Contact Gap Power     Power       Eye   Avoid K
VSL       46        51        33        34        49
VSR       44        49        33        31        45

Expected Performance Split:
      PA   AB     H 2B+3B  2B  3B  HR   BB    K    AVG   OBP   SLG   OPS
VSL   180  167   39   8     7   1   3   13   35  0.233 0.287 0.344 0.631
VSR   420  392   89  18    17   1   8   28   90  0.228 0.280 0.337 0.617

Talent Rating:
  Contact Gap Power     Power       Eye   Avoid K
       41        51        38        40        48

Projected ML Performance:
      PA   AB     H 2B+3B  2B  3B  HR   BB    K    AVG   OBP   SLG   OPS   SA%   SB%   SB   CS     XR *XR/27
High  600  554  123  26    24   2  13   46  117  0.222 0.282 0.345 0.627   0.8  49.8    1    1   76.1   4.77
Mid   600  554  122  26    24   2  13   46  118  0.221 0.281 0.342 0.623   0.4  49.6    0    0   75.2   4.71
Low   600  554  122  26    24   2  13   46  120  0.220 0.279 0.339 0.619   0.1  49.4    0    0   74.3   4.64

************************************************************************

Pitching:
Ability Rating:
   Stuff  Control Movement
      13       22       22

Expected Performance:
     K/AB  BB/BF HR/AB  K/BB  AVG   OBP     H/9   K/9  BB/9 HR/9  WHIP   FIP  FIP+  fERA  dERA   ERC
High 0.091 0.128 0.041  0.62  0.353 0.436  13.76  3.55 5.72 1.61  2.16  3.45  2.21  6.82  7.23  9.13
Mid  0.090 0.128 0.041  0.61  0.354 0.437  13.82  3.51 5.76 1.62  2.17  3.48  2.24  6.85  7.26  9.19
Low  0.089 0.129 0.042  0.60  0.355 0.438  13.87  3.47 5.80 1.62  2.19  3.51  2.28  6.88  7.30  9.26

Ability Rating Split:
      Stuff  Control Movement
VSL      12       21       22
VSR      13       23       22

Expected Performance Split:
     K/AB  BB/BF HR/AB  K/BB  AVG   OBP     H/9   K/9  BB/9 HR/9  WHIP
VSL  0.087 0.130 0.041  0.59  0.356 0.439  13.93  3.42 5.84 1.62  2.20
VSR  0.090 0.127 0.041  0.62  0.354 0.436  13.82  3.51 5.69 1.62  2.17

Talent Rating:
   Stuff  Control Movement
      42       68       62

Projected ML Performance:
     K/AB  BB/BF HR/AB  K/BB  AVG   OBP     H/9   K/9  BB/9 HR/9  WHIP   FIP  FIP+  fERA  dERA   ERC
High 0.159 0.069 0.029  2.15  0.300 0.348  10.88  5.78 2.69 1.04  1.51  1.12 -0.11  4.49  4.84  5.04
Mid  0.158 0.070 0.029  2.11  0.301 0.349  10.93  5.74 2.72 1.05  1.52  1.15 -0.08  4.52  4.88  5.09
Low  0.157 0.070 0.029  2.08  0.302 0.351  10.97  5.71 2.75 1.06  1.52  1.18 -0.05  4.55  4.91  5.14
Both expected pitching and batting performances are calculated. The rating scale of rating translation is designed to be flexible. This means the translation will be based on the rating scale set in the league setting. Also, the expected performance is given as a range value. "Mid" is the direct stats translation from exact rating. (eg. rating of 5) "High" is the translation for rating + half rating point (eg. rating of 5.5) and "Low" is the translation for rating - half rating point (eg. rating of 4.5). The range value is particularly useful for "vaguer" rating scale (eg. 1 to 5, etc.).

For more details of the mod, please read the Manual.rtf via the program startup menu shortcut.

This is the third major public build of the program. Bug fixing and further expanded functionality will be considered in the possible future version. All feedbacks and suggestions are extremely welcome. Please provide all feedbacks and suggestions in the official OOTP forum.

I only have basic programming skills, so I don't think the original mod was pleased to the eyes and such. However, with the addition of GUI wrapper written by Eriq Jaffe, I do believe this mod is not only quite functional and serves its purpose well but also quite easy to use.

Anyhow, please enjoy this add-on mod for OOTP.

Special thanks to Eriq Jaffe for making the terrific GUI wrapper for this utility program. With the addition of GUI, this utility has improved enormously regarding to user friendliness.

Special thanks to Markus for creating such a wonderful game!

Special thanks to every other mod maker in the OOTP community and the OOTP community in general! The knowledge that I learned through the OOTP community has helped me in continuing improving this utility program. I have now also come to the real understanding that it's really takes a lot of efforts to create mods.

Special thanks to YOU for choosing to use this add-on mod!

Get it here!!!

New link
Rating Translator v0.93b

Special thanks to jazzrack for hosting the file at CLB - OOTP Download.

Old link:
Rating Translator v0.93b

Special thanks to Joe for hosting the file at OOTP Download Center.

Thanks everyone,

Jayzone

Last edited by Jayzone; 12-03-2005 at 02:52 PM. Reason: correcting typo
Jayzone is offline   Reply With Quote