Thu May 25, 2023 2:40 pm
I do something similar with the DD dump. I download the data pool from DD but using the zero parks setting. I developed an excel spreadsheet that includes all the ballpark singles and homer chances so that I can just input the ballpark ratings on one page and it automatically updates all the NERP values. By doing this, I can tinker with the NERP formula to increase the weighting of on base vs slugging for example, depending on the park. By using filters and the expected at bats vs righties and lefties, I can (hopefully) find the best values for positions.
I then have a second excel spreadsheet that allows me to combine the contributions of hitter and pitcher when I want to make a lineup, and I have one more spreadsheet that allows me to look at the other team's lineups against my pitchers, including the defensive contributions, when determining the pitching rotation, as well as what settings to use for my pitchers. I find that many times, the best (and, in my opinion, most fun) way to approach pitching is to identify the other team's weakness and exploit that with a >5 man rotation with a mix of lefties, righties and reverse pitchers.
I also like the math aspect of it, so I enjoy tweaking the formulas to see how to get the most out of players. It makes me feel like I am doing something other than just watching HAL screw me over.