So I did a lot of (sims) work in the defense thread to try and figure out how defense works, so I went ahead and tried to figure out how offense works as well and how they work together.
This is what I came up with.
It's a spread sheet that attempts to use player ratings to measure their wins. I've played around with it and got some decent (not perfect) results and figured I'd share it.
It's pretty easy to use.
Select the appropriate columns in Sortable Stats. Copy. Paste.
Not quite that easy. Then you have to adjust formula in the row below the blue row that says 'Weighted Average' so that it includes ALL the players who appeared in a game the previous season. This will give you the average player from which the calculations are based.
Next you have to manually type those values into the blue 'Weighted Average' row. This allows you to sort the players and not F-up the calculations.
There's a sheet for each position since each position is affected differently by the defensive ratings. I've also put in a wOBA calc and a Runs/Game calc that I use.
Reply With Quote
Originally Posted by filihok
