what do you mean by the rotation numbers? where is that and why is not good ?
Well every team on the sportsbook has a number next to it. That's the rotation number for that team at every book. That's fine, but the formula I'm trying to write references an entire cell on excel, and when the rotation number is next to the team, it messes everything up.
You needn't worry about this though, as it has nothing to do with the system itself. It's just me personally making a spreadsheet (which is a trainwreck by the way).
Also, for your other question, you get defensive stats the same way as you get offense. Just use the original formula, substituting defense numbers for offense. I recommend reading the ENTIRE thread. All 20-something pages. I know it will take time, but there is a lot of good info in there.
Good luck!