I used this formula in USA BBB1 last season, more stat based, no opinion, but it came out pretty accurate, and it's all easily copy and paste into excel. Just takes 10-15 once you get used to it. And once you tag each team East or West, Lion or Elephant it's easily sortable for both Conferance and division. Just to chuck it out there.
Passing Rank = Pass Yards a game,+,AVG Pass Yards a Game,+,TD x 100,-,INT X 100 = OFF Rating, Sorted Teams Most to Least for Ranks 1-32.
Rush = Rush Yards a game,+,AVG Rush Yards a Game,+,TD x 100,-,FUM X 100 = DEF Rating, Sorted Teams Most to Least for Ranks 1-32.
Pass D Rank = Pass Yards Allowed, +, AVG Pass Yards Allowed, +, TD/All, X, 100 = Def Pass Ranking, Sorted teams least to most for Ranks 1-32
Rush Rank=Rush Yards Allowed, +, AVG Rush Yards Allowed, +, TD/All, X, 100 = Def Pass Ranking, Sorted teams least to most for Ranks 1-32
Pts Scored a Game = Most to Least for Ranks 1-32
Pts allowed a game = Least to most for Ranks 1-32
AVG Rank = AVG of all categories
Team Rank = Lowest to hightest AVG Rank for teams 1-32.
Passing Rank = Pass Yards a game,+,AVG Pass Yards a Game,+,TD x 100,-,INT X 100 = OFF Rating, Sorted Teams Most to Least for Ranks 1-32.
Rush = Rush Yards a game,+,AVG Rush Yards a Game,+,TD x 100,-,FUM X 100 = DEF Rating, Sorted Teams Most to Least for Ranks 1-32.
Pass D Rank = Pass Yards Allowed, +, AVG Pass Yards Allowed, +, TD/All, X, 100 = Def Pass Ranking, Sorted teams least to most for Ranks 1-32
Rush Rank=Rush Yards Allowed, +, AVG Rush Yards Allowed, +, TD/All, X, 100 = Def Pass Ranking, Sorted teams least to most for Ranks 1-32
Pts Scored a Game = Most to Least for Ranks 1-32
Pts allowed a game = Least to most for Ranks 1-32
AVG Rank = AVG of all categories
Team Rank = Lowest to hightest AVG Rank for teams 1-32.
Last edited Jun 15, 2008 19:59:06





.























