Quote:
Originally Posted by luckymann
So, what's the exact calculation you use here? I have a save that's just about to finish its first full season on 27 and will give you my results if you can clarify that formula for the mathematically challenged. Where does one even find the league-wide wOBA or xwOBA?
Thanks
G
|
Easiest way to do it on a default OOTP game:
1. Open the "Batting Stats 2" view on the "Sortable Stats" tab for MLB.
2. Customize the view to include xwOBA from "Batting Superstats".
3. Make sure all players are displayed (no filters, no "batting qualifiers").
4. Export the table to a CSV file.
5. Open the CSV file (you'll need to find your OOTP export folder)
6. Make a new column in the CSV file that is equal to the PA column multiplied by the wOBA column. This makes it so we are computing an average weighted by plate appearances, not by player count.
7. Make another new column that is equal to the PA column multiplied by the xwOBA column.
8. Compute the sum of the two new columns using the SUM function. Also compute the sum of the PA column.
9. Divide the sum of the two new columns by the sum of the PA column. This gives you the league-average wOBA and league-average xwOBA, respectively.