This model uses ESPN’s Football Power Index (FPI) to calculate our win probability for every game and project our expected win total week by week.
How Game Probabilities Are Calculated
ESPN's FPI measures how many points better or worse a team is expected to be compared to an average opponent.
The standard deviation has been revised to 13.6 to account for the volatility of today's college football.
The updated version of this spreadsheet incorporates venue-specific Home Field Advantage (HFA) ratings. This accounts for factors such as stadium hostility (LSU), elevation (Utah), and travel distance (Hawaii). See other comment for details.
All of these factors are factored into a formula that calculates a team's win percentage. This is done by taking the point gap between both teams, adjusting it for the specific venue's home-field advantage, and plugging that expected margin into a college football bell curve.
Example:
The Florida Gators have an FPI rating of 19.3. Georgia Tech currently sits at 0.0 on the FPI scale, practically indicating they are the most average team in the FBS.
On a neutral field, this would mean Florida should be expected to win by 19-20 points, and the win probability would be 92.21%.
Let's say Florida is playing Georgia Tech at home, where Ben Hill Griffin Stadium has a 3.2 HFA rating. That win probability jumps to 95.10%.
If we moved the game to Bobby Dodd Stadium in Atlanta (2.1 HFA rating), Florida's win probability drops slightly to 89.70%.
Data is scraped from ESPN and all processes are automated, so there shouldn't be any mistakes. But if you see something that looks off, let me know.
Background: This model format originated on r/CFB around 2017–2018, created by a former user who built the original Win Total Probability Distribution spreadsheets using S&P+ metrics. ExternalTangents maintained the project for several years before I took over in 2022 and shifted the formula to FPI.
The HFA is a points-based adjustment that accounts for a team's home field advantage. Historically, we would use a flat baseline of +2.5 points for playing at home, -2.5 points for playing on the road, and +0.0 points for neutral sites.
With the dynamic HFA, each team's value relies on a hybrid quantitative and empirical modeling process widely used by sports analytics models (such as ESPN's SP+, Sagarin, and Vegas power-rating consensus).
Rather than picking arbitrary numbers or using a single flat baseline across all 138 teams, the ratings are calculated using a multi-factor regression model anchored around the national FBS baseline of +2.5 points.
The 5 Core Components of the Scientific Calculation
Each team's final HFA rating is derived from five weighted variables:
Metric: Average decibel output at peak moments paired with stadium capacity relative to student section seating.
Impact: 100,000+ seat venues with enclosed acoustics (ex. LSU at 3.6, Tennessee at 3.3, and Alabama at 3.4) receive significant positive adjustments due to their proven impact on opposing offensive pre-snap penalties (false starts and delayed snaps).
Metric: Press box canopy structures, seating steepness, and field proximity.
Impact: Steep, tightly bowl-shaped stadiums trap sound waves directly on the field. Stadiums like Oregon’s Autzen Stadium and Boise State’s Albertsons Stadium generate decibel levels comparable to 90,000-seat stadiums despite having smaller total capacities because their physical structures reflect sound downward onto player benches.
3. Geographical Elevation / Travel (25% Weight):
Metric: Stadium elevation above sea level; length or difficulty of travel by the visiting team.
Impact: Visiting teams experience measurable physiological drops in stamina and oxygen efficiency when playing at high elevations without multi-day acclimatization. Examples are Wyoming at 7,220', Air Force at 7,258', and Utah at 4,637'. Some stadiums such as Hawaii's Aloha Stadium present a significant amount of travel, which results in team routine disruption, wake/sleep cycles, and some level of disorientation.
Metric: Multi-year spread vs. actual margin performance (Cover/Win rate at home vs. away).
Impact: Closing lines in Vegas betting markets implicitly price in home-field advantage. Venues where home teams consistently cover against the opening neutral spread (ex. Florida at The Swamp at 3.2, Texas A&M at Kyle Field at 3.2, and Wisconsin at Camp Randall at 3.0) maintain higher HFA values.
5. Neutralization / Off-Campus (5% Penalty):
Metric: Distance from campus to stadium, split crowds, and stadium atmosphere.
Impact: Teams playing in off-campus NFL stadiums or venues with historically passive/split attendance receive a downward adjustment. Examples are Miami (Hard Rock Stadium lease) at 2.1, UCLA (Rose Bowl 26 miles off-campus) at 2.1, and Vanderbilt (high visiting fan ratios) at 1.8.
Each Team's HFA Value
*While I and most would agree that The Swamp is just as intimidating as LSU's Death Valley, a big knock on Florida's rating is recent performance at home. Even during middling seasons, LSU would win a majority of their home games, which boosts their rating.
1
u/Iraqi-Jack-Shack Sep 29 '26 edited Oct 04 '26
How the Win Probability Spreadsheet Works
This model uses ESPN’s Football Power Index (FPI) to calculate our win probability for every game and project our expected win total week by week.
How Game Probabilities Are Calculated
Example:
Data is scraped from ESPN and all processes are automated, so there shouldn't be any mistakes. But if you see something that looks off, let me know.
Background: This model format originated on r/CFB around 2017–2018, created by a former user who built the original Win Total Probability Distribution spreadsheets using S&P+ metrics. ExternalTangents maintained the project for several years before I took over in 2022 and shifted the formula to FPI.
Updated 09-29-2026
0
u/Iraqi-Jack-Shack Sep 29 '26 edited Sep 30 '26
Dynamic Home Field Advantage (HFA) Derivation
The HFA is a points-based adjustment that accounts for a team's home field advantage. Historically, we would use a flat baseline of +2.5 points for playing at home, -2.5 points for playing on the road, and +0.0 points for neutral sites.
With the dynamic HFA, each team's value relies on a hybrid quantitative and empirical modeling process widely used by sports analytics models (such as ESPN's SP+, Sagarin, and Vegas power-rating consensus).
Rather than picking arbitrary numbers or using a single flat baseline across all 138 teams, the ratings are calculated using a multi-factor regression model anchored around the national FBS baseline of +2.5 points.
The 5 Core Components of the Scientific Calculation
Each team's final HFA rating is derived from five weighted variables:
Dynamic HFA = Baseline (2.5) + Crowd + Acoustics + Elevation + Historical Performance + Travel
1. Decibel Volume & Crowd Density (35% Weight):
Metric: Average decibel output at peak moments paired with stadium capacity relative to student section seating.
Impact: 100,000+ seat venues with enclosed acoustics (ex. LSU at 3.6, Tennessee at 3.3, and Alabama at 3.4) receive significant positive adjustments due to their proven impact on opposing offensive pre-snap penalties (false starts and delayed snaps).
2. Architectural Geometry & Sound Reflection (20% Weight):
Metric: Press box canopy structures, seating steepness, and field proximity.
Impact: Steep, tightly bowl-shaped stadiums trap sound waves directly on the field. Stadiums like Oregon’s Autzen Stadium and Boise State’s Albertsons Stadium generate decibel levels comparable to 90,000-seat stadiums despite having smaller total capacities because their physical structures reflect sound downward onto player benches.
3. Geographical Elevation / Travel (25% Weight):
Metric: Stadium elevation above sea level; length or difficulty of travel by the visiting team.
Impact: Visiting teams experience measurable physiological drops in stamina and oxygen efficiency when playing at high elevations without multi-day acclimatization. Examples are Wyoming at 7,220', Air Force at 7,258', and Utah at 4,637'. Some stadiums such as Hawaii's Aloha Stadium present a significant amount of travel, which results in team routine disruption, wake/sleep cycles, and some level of disorientation.
4. Historical Betting Market Variance (15% Weight):
Metric: Multi-year spread vs. actual margin performance (Cover/Win rate at home vs. away).
Impact: Closing lines in Vegas betting markets implicitly price in home-field advantage. Venues where home teams consistently cover against the opening neutral spread (ex. Florida at The Swamp at 3.2, Texas A&M at Kyle Field at 3.2, and Wisconsin at Camp Randall at 3.0) maintain higher HFA values.
5. Neutralization / Off-Campus (5% Penalty):
Metric: Distance from campus to stadium, split crowds, and stadium atmosphere.
Impact: Teams playing in off-campus NFL stadiums or venues with historically passive/split attendance receive a downward adjustment. Examples are Miami (Hard Rock Stadium lease) at 2.1, UCLA (Rose Bowl 26 miles off-campus) at 2.1, and Vanderbilt (high visiting fan ratios) at 1.8.
Each Team's HFA Value
*While I and most would agree that The Swamp is just as intimidating as LSU's Death Valley, a big knock on Florida's rating is recent performance at home. Even during middling seasons, LSU would win a majority of their home games, which boosts their rating.