Alright, not sure if there's an easy solution to this one... I've really been struggling with it. What I want is a semi-easy way to calculate a team's average opponent points for and against. So for the 2008 spreadsheet I've attached I'd like a way to calculate how good the teams were on average that each team faced (a strength of schedule factor). I have included on the spreadsheet all of the relevant information... I just don't know how to go about grabbing the up to date opponent's information for every team a team has faced and then average it out.
I'm struggling to even put this into words so let me know if you need clarification on anything. Any help is greatly appreciated... thanks!
Bookmarks