OOTP Developments Forums - View Single Post - New OOTP6 utility: Rating Translator/Expected Performance Scout is now available!

Jayzone · 10-18-2004, 08:37 PM

Note: Darn. Where is the 's' in the word 'translator' in my thread title?

Sorry about the typo.

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

Note: The "contact=0" issue is officially acknowledged and it's also found that some part of codes has something to do with this besides potential corruption of the CSV files. I have currently planned a new update for Rating Translator and planned to fix or prevent the bug. Hopefully, the new version will be rid of this problem permanently.

For the partial fix on the issue, please refer to the following link (post#7):
http://www.ootpdevelopments.com/boar...ad.php?t=86648

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

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: 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.

Version: 0.81b

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

Changes/Fixes in v0.81b

- Some expected performance stats for pitching were not calculated correctly. These stats categories include H/9, K/9, BB/9, HR/9, and WHIP. The issue is now fixed.

The original calculation formula calculated those number to be higher than what it should be. This was most evident with the-then inflated H/9 and WHIP. With the correction to the formula, the expected performance stats should now be accurate.

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

Hi,

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

And this is also my first attempt to 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 translation depends on league toal setting, rating itself and also the opposition rating. In short, pretty much every league will have its unique rating translation formulas. This program is designed to attempt rating translation by constructing a rating/actual stats loop-up table and then calculating the linear 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.

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 linear regression method. After that, the expected stats performance of the user desinated player is calculated. A sample output of the program is demostrated below:

Code:

Sample output of the program:

Player ID: 1
Name: #80 Robert  Ranger 
Nick name:  
Bat: R Throw: R
Age: 32 Position: RF

Batting:
Ability Rating:
  Contact Gap Power     Power       Eye   Avoid K
       40        69        55        26        57

Expected Performance:
      PA   AB     H 2B+3B  2B  3B  HR   BB    K    AVG   OBP   SLG   OPS
High  550  516  121  34    30   4  22   34   77  0.234 0.281 0.438 0.718
Mid   550  517  120  34    30   4  22   33   78  0.232 0.279 0.434 0.713
Low   550  517  119  34    30   4  22   33   79  0.231 0.277 0.430 0.707

Talent Rating:
  Contact Gap Power     Power       Eye   Avoid K
       37        64        47        30        52

Projected ML Performance:
      PA   AB     H 2B+3B  2B  3B  HR   BB    K    AVG   OBP   SLG   OPS
High  550  514  115  32    28   3  18   36   87  0.224 0.276 0.399 0.675
Mid   550  514  115  31    28   3  18   36   88  0.223 0.274 0.396 0.670
Low   550  514  114  31    28   3  18   36   89  0.221 0.272 0.392 0.664

Pitching:
Ability Rating:
   Stuff  Control Movement
       6        1       20

Expected Performance:
     K/AB  BB/BF HR/AB  K/BB  AVG   OBP     H/9   K/9  BB/9 HR/9  WHIP
High 0.070 0.148 0.043  0.40  0.295 0.399  12.05  2.85 7.06 1.76  2.12
Mid  0.069 0.148 0.043  0.39  0.296 0.400  12.08  2.80 7.10 1.76  2.13
Low  0.067 0.149 0.043  0.38  0.296 0.401  12.11  2.75 7.14 1.77  2.14

Talent Rating:
   Stuff  Control Movement
       6        1       20

Projected ML Performance:
     K/AB  BB/BF HR/AB  K/BB  AVG   OBP     H/9   K/9  BB/9 HR/9  WHIP
High 0.070 0.148 0.043  0.40  0.295 0.399  12.05  2.85 7.06 1.76  2.12
Mid  0.069 0.148 0.043  0.39  0.296 0.400  12.08  2.80 7.10 1.76  2.13
Low  0.067 0.149 0.043  0.38  0.296 0.401  12.11  2.75 7.14 1.77  2.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 Readme.txt in the mod package.

This is the first 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.

I only have basic programming skills, so I don't think this mod is pleased to the eyes and such. However, I do believe this mod is quite functional and serves its purpose well.

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

Special thanks to Markus for creating such a wonderful game!

Special thanks to every other mod makers in the OOTP community!
I have now come to the real understanding that it's really takes a lot efforts to create mods.

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

Get it here!!!

Rating Translator v0.81b

Special thanks to Joe for hosting the file on OOTP Downald Center.

Dicussion threads:
http://www.ootpdevelopments.com/boar...d.php?p=897453 (General discussion thread)
http://www.ootpdevelopments.com/boar...d.php?p=897441 (OOTP6 Mod thread; this thread)

Thanks everyone,

Jayzone

10-18-2004, 08:37 PM	#1
Jayzone All Star Reserve Join Date: Apr 2004 Posts: 706	New OOTP6 utility: Rating Translator/Expected Performance Scout is now available! Note: Darn. Where is the 's' in the word 'translator' in my thread title? Sorry about the typo. ************************************************ * Note: The "contact=0" issue is officially acknowledged and it's also found that some part of codes has something to do with this besides potential corruption of the CSV files. I have currently planned a new update for Rating Translator and planned to fix or prevent the bug. Hopefully, the new version will be rid of this problem permanently. For the partial fix on the issue, please refer to the following link (post#7): http://www.ootpdevelopments.com/boar...ad.php?t=86648 ************************************************ * 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: 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. Version: 0.81b -------------------------------------------------------------------------- Changes/Fixes in v0.81b - Some expected performance stats for pitching were not calculated correctly. These stats categories include H/9, K/9, BB/9, HR/9, and WHIP. The issue is now fixed. The original calculation formula calculated those number to be higher than what it should be. This was most evident with the-then inflated H/9 and WHIP. With the correction to the formula, the expected performance stats should now be accurate. -------------------------------------------------------------------------- Hi, This is a add-on utility mod specifically created for OOTP6. And this is also my first attempt to 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 translation depends on league toal setting, rating itself and also the opposition rating. In short, pretty much every league will have its unique rating translation formulas. This program is designed to attempt rating translation by constructing a rating/actual stats loop-up table and then calculating the linear 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. 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 linear regression method. After that, the expected stats performance of the user desinated player is calculated. A sample output of the program is demostrated below: Code: Sample output of the program: Player ID: 1 Name: #80 Robert Ranger Nick name: Bat: R Throw: R Age: 32 Position: RF Batting: Ability Rating: Contact Gap Power Power Eye Avoid K 40 69 55 26 57 Expected Performance: PA AB H 2B+3B 2B 3B HR BB K AVG OBP SLG OPS High 550 516 121 34 30 4 22 34 77 0.234 0.281 0.438 0.718 Mid 550 517 120 34 30 4 22 33 78 0.232 0.279 0.434 0.713 Low 550 517 119 34 30 4 22 33 79 0.231 0.277 0.430 0.707 Talent Rating: Contact Gap Power Power Eye Avoid K 37 64 47 30 52 Projected ML Performance: PA AB H 2B+3B 2B 3B HR BB K AVG OBP SLG OPS High 550 514 115 32 28 3 18 36 87 0.224 0.276 0.399 0.675 Mid 550 514 115 31 28 3 18 36 88 0.223 0.274 0.396 0.670 Low 550 514 114 31 28 3 18 36 89 0.221 0.272 0.392 0.664 Pitching: Ability Rating: Stuff Control Movement 6 1 20 Expected Performance: K/AB BB/BF HR/AB K/BB AVG OBP H/9 K/9 BB/9 HR/9 WHIP High 0.070 0.148 0.043 0.40 0.295 0.399 12.05 2.85 7.06 1.76 2.12 Mid 0.069 0.148 0.043 0.39 0.296 0.400 12.08 2.80 7.10 1.76 2.13 Low 0.067 0.149 0.043 0.38 0.296 0.401 12.11 2.75 7.14 1.77 2.14 Talent Rating: Stuff Control Movement 6 1 20 Projected ML Performance: K/AB BB/BF HR/AB K/BB AVG OBP H/9 K/9 BB/9 HR/9 WHIP High 0.070 0.148 0.043 0.40 0.295 0.399 12.05 2.85 7.06 1.76 2.12 Mid 0.069 0.148 0.043 0.39 0.296 0.400 12.08 2.80 7.10 1.76 2.13 Low 0.067 0.149 0.043 0.38 0.296 0.401 12.11 2.75 7.14 1.77 2.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 Readme.txt in the mod package. This is the first 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. I only have basic programming skills, so I don't think this mod is pleased to the eyes and such. However, I do believe this mod is quite functional and serves its purpose well. Anyhow, please enjoy this add-on mod for OOTP. Special thanks to Markus for creating such a wonderful game! Special thanks to every other mod makers in the OOTP community! I have now come to the real understanding that it's really takes a lot efforts to create mods. Special thanks to YOU for choosing to use this add-on mod! Get it here!!! Rating Translator v0.81b Special thanks to Joe for hosting the file on OOTP Downald Center. Dicussion threads: http://www.ootpdevelopments.com/boar...d.php?p=897453 (General discussion thread) http://www.ootpdevelopments.com/boar...d.php?p=897441 (OOTP6 Mod thread; this thread) Thanks everyone, Jayzone Last edited by Jayzone; 01-19-2005 at 10:56 PM.