New OOTP6 utility: Rating Translator/Expected Performance Scout is now available!

[Jayzone]

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:

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

[Steve Kuffrey]

Sounds awesome, gonna try and check it out soon.

[HolyCow98]

Cool....as soon as I get my new solo league set up....I'm going to play around with this a bit. Maybe use it to help me decide on players in the dispersal draft. Just the thing to kinda spice it up a bit.

Thanks for the hard work.

[dougaiton]

Wow! That looks fantastic!

[Jayzone]

Steve Kuffrey, HolyCow98, and dougaiton,

Thanks for your kind words. If you find any problem in the program, please inform me about it. I have only tested on my machine, so I don't know how well it works on other machines. (It should be fine, since the program is just a simple EXE executable.) Thanks again.

*******

HolyCow98,

Word of caution. In order to get the expected performance scout (scout.bat) to work, you will need to use rating translator to generate the rating to stats look-up table first. What this means is that you will have to have the look-up table for the rating translation even for a newly generated league. This look-up table is generated (with translator.bat) by collecting and comparing the ratings and actual in-game stats. You are probably wondering if the new league doesn't have any stats yet, what should you do? The solution is to generate the look-up table using other league. As long as the 'substitute league' has the same league total setting and same rating distribution, this look-up table should still be able to give you a fairly accurate rating translation . Hope this helps. For more information on how to use the utility program, please read the Readme.txt file. Or you can just ask questions here. Thanks.

[gubaru]

Jayzone,

Very cool. So far, it looks quite accurate as well. Thanks for the new toy!

I modified your batch files a little bit to allow prompted values for the parameters you pass to the .exe files and allow the scout.bat file to be run for multiple players without restarting the batch file. The modifications include some very basic error testing. I'll include the code here.

Translator.bat:

@ECHO OFF
:CSV_path
set path=
set /p path=Enter directory containing csv files: 
if '%path%'=='' goto path_error
goto Scale
:path_error
ECHO You must enter a directory. Please enter a value.
ECHO.
goto CSV_path
:Scale
set scale=
set /p scale=Enter ratings scale:
if '%scale%'=='' goto scale_error
goto end
:scale_error
ECHO The rating scale cannot be blank. Please enter a value.
ECHO.
goto Scale
:end
rating_translator.exe %path% %scale%
pause

Scout.bat:

@ECHO OFF
:Player_ID
set pid=
set /p pid=Enter Player ID: 
if '%pid%'=='' goto pid_error
goto PA
:pid_error
ECHO Player ID cannot be blank. Please enter a value.
ECHO.
goto Player_ID
:PA
set pa=
set /p pa=Enter estimated PA:
if '%pa%'=='' goto pa_error
goto run
:pa_error
ECHO PA cannot be blank. Please enter a value.
ECHO.
goto PA
:run
EPScout.exe %pid% %pa%
set rerun=
set /p rerun=Run again? (Y/N): 
if not '%rerun%'=='' set rerun=%rerun:~0,1%
if '%rerun%'=='Y' goto Player_ID
if '%rerun%'=='y' goto Player_ID

[Jayzone]

gubaru,

Thanks for your kind words as well. Glad you like it. I am even more pleased when you said "it looks quite accurate as well".

The modified batch files are great. I was thinking about doing the similar stuff initially. However, I decided that I should just make the batch file as simple as possible so that people can understand it easily. Plus, I thought it's less of a hassle to just type a long folder path in a text file (batch file). You can just copy and paste. Also, I already designed my program to have safeguards against illegal inputs. The safegurad should work. Anyway, your modified batch is an excellent alternative to anyone who want to do things that way.

Hey, if you want, I can include your modified batch files in the possible future version in the file package (separate folder) and credit you in readme.

[gubaru]

I've been playing around with it using the backups from my solo league and the results are impressive. In many cases, the numbers are very close if not spot on.

Regarding the batch files, feel free to include them.

[HolyCow98]

Thanks for the heads up....I believe I just got my league setup the way I want.

I actually have a league of the same setup with 24 teams using the same league totals and other settings. The only settings that are slightly different are the park factors...but as a rule....I always make sure that the ball park ratings are as close to an average of 100 as a whole.

I'm assuming I could use that league to work with the scout.bat?

Can't wait to start my league and this really will add something to the dispersal draft. Good stuff.

[Another Mike D]

This is pretty cool, except I get nothing but 0s for everything. I followed the directions and use BOSI, so I have the exporter correct. It displays the correct ratings (talent and ability) in the report, but all the stats are 0s. We are in the offseason currently...could that be why?

Also, does this take into account park effects? I play at Minute Maid which apparently is very LHB friendly...

[gubaru]

Originally Posted by Another Mike D

This is pretty cool, except I get nothing but 0s for everything. I followed the directions and use BOSI, so I have the exporter correct. It displays the correct ratings (talent and ability) in the report, but all the stats are 0s. We are in the offseason currently...could that be why?

Yes. The translation file needs to be produced either while games are being played or after the season is over but before proceeding. If you have a backup from the end of last season, you can export from that and then produce the translation file.

Originally Posted by Another Mike D

Also, does this take into account park effects? I play at Minute Maid which apparently is very LHB friendly...

No. If my understanding of what Jayzone did is correct, the projected stats assume league average conditions.

[Jayzone]

I was going through the code today and I found a small error regarding to the calculation of H/9, K/9, BB/9, HR/9, and WHIP. The results the inflated number of those. It is especially evident with H/9 and WHIP. With the formula error fixed, these expected performance stats should reflect the ratings much more accurately.

The code-fixing only involes EPScout.exe. The update version of EPScout.exe is attached in this post. To update rating translator, simply replace the old EPScout.exe with the new version.

It is imperative to update your rating translator to v0.81b if you desire to have correct H/9, K/9, BB/9, HR/9, and WHIP.

An updated rating translator full mod package is now available on Joe's OOTP Download Ceter. (Special thanks to Joe for hosting.)

Full v0.81b: Get it here!!!

Rating Translator v0.81b

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

Thanks.

Jayzone

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

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.

[Jayzone]

Originally Posted by gubaru

I've been playing around with it using the backups from my solo league and the results are impressive. In many cases, the numbers are very close if not spot on.

Regarding the batch files, feel free to include them.

Again, good to hear the results are good. However, I have found a small coding error regrading to H/9, K/9, BB/9, HR/9 ,and WHIP calculation. I have since fixed the bug in v0.81b. So, v0.81b should give you a even more accurate result for expected pitching performance.

[Jayzone]

HolyCow98,

I think that you should still get a fairly accurate rating translation with the look-up table generated from the league that you described. Feel free to go ahead and use that.

However, you should use the updated Rating Translator v0.81b. In v0.81b, I have fixed a small coding error regrading to H/9, K/9, BB/9, HR/9 ,and WHIP calculation. Now v0.81b should give you more accurate results for expected pitching performance.

[Jayzone]

Another Mike D,

gubaru is right on both points. The symptom that you described suggests an inaccurate look-up table generation. You can either use the end-of-previous season backup or leagues with same league total setup for CSV data source files generation (CSV exporter).

The expected performance calculation is done under the assumption of league-neutral/league-average stituation. This includes both ballpark neutral and defense neutral. Hope this helps.

[JoeRockEHF]

Updated version up and running!