Posted:
#126
Quote Originally Posted by si1ly:
Here's one type of calculation you can perform using the sheets to predict the score. Let's look at the Seattle at San Francisco game as an example.
Here's one type of calculation you can perform using the sheets to predict the score. Let's look at the Seattle at San Francisco game as an example.
Start with RPI Score offense: Seattle's offense scores -3.1 points less than their opponents allow on average. San Francisco's defense allows 15.7 points per game. Therefore Seattle's offense is projected to score 12.6 points.
Start with RPI Score offense: San Francisco's offense scores +1.4 points more than their opponents allow on average. Seattle's defense allows 15.5 points per game. Therefore San Francisco's offense is projected to score 16.9 points.
Start with RPI Score defense: San Francisco's defense allows -9.3 points less than their opponents average. Seattle's offense scores 18.3 points per game. Therefore Seattle's offense will score 9.0 points.
Start with RPI Score defense: Seattle's defense allows -6.3 points less than their opponents average. San Francisco's offense scores 25.3 points per game. Therefore San Francisco's offense will score 19 points.
SEA = (12.6 + 9.0) / 2 = 21.6 / 2 = 10.8
SF = (19 +16.9) / 2 = 35.9 / 2 = 18.0
Round to the nearest football score and you get something like 17-10 San Francisco. You can do this calculation for every game to get one perspective on a final score prediction for the game.
Great spreadsheets! Just wanted to know how you get the RPI numbers. I mean i can find out how many points per game each team scores but unless I go through every past game and calculate it how do you get that number (e.g. Seattle's -3.1 for offense)?
0
Awesome as usual
Hot Forum Topics
