Originally Posted by Ruthian23
I am attempting to attach the spreadsheet I created, which is based on (and uses many aspects of) RchW's prior work.
It's designed for use with one league, but there's no reason you couldn't save a copy for each of your minor leagues, too.
There is a lot of stuff there. One of the worksheets included has instructions, but to simplify, all you need to do is the following:
1. Before beginning, go to the Desired Totals spreadsheet (one of the tabs on the bottom). Enter the numbers you want in all cells that are not shaded red. Leave the red shades cells alone. You need to enter the batting, fielding, and pitching totals you want, but you only need to do this once (unless you want to change the statistical environment of the league, of course.) I called it Desired Totals because your desired totals might not be based on a real life year, but if you're basing your numbers on a real MLB season, this is where all of those numbers go. All of the numbers are available at baseball-reference with the possible exception of total league passed balls (I couldn't find that one.)
2. After entering the Desired Totals, go back to the Main Worksheet. Like I said, there's a bunch of stuff all over the place on the sheet, and the setup of the spreadsheet is less than elegant to say the least, but as a general rule, you don't have to do anything (and shouldn't do anything) with any cell shaded red. The only places you need to input data are:
A. As instructed on the sheet, copy and paste your batting stats, pitching stats, and fielding stats into the relevant areas. You get these by doing a CSV Dump (go to the database tab, data base tools drop down (top right), and click export data to CSV files (fourth up from the bottom). This will put your files in (under normal installations) Documents/Out of the Park Developments/OOTP Baseball 16/saved_games/your saved game name/import_export//csv
The three files you need are league_history_batting_stats, league_history_pitching_stats, and league_history_fielding stats. Just copy and paste the two rows closest to the top that start with your most recent season (or one, if you only have one subleague) into the sheet.
B. Go to the second to last item of the sheet, where it asks you to input your current modifiers. Input the modifiers you are currently using from your Stats and AI tab.
3. Your suggested modifiers will automatically display in the box on the bottom of the main sheet. Ask OOTP to calculate its own modifiers. Compare to the suggested ones on the sheet. If there is a major divergence on any of them, compare your season results to the expected season results in the variation charts and see which you think is best, or split the difference. If they're close (and in my experience they generally tend to be as long as you run the autocalc right before the season), just go with what the game suggests.
|