A fantasy football power rankings formula that is actually fair

Weekly power rankings are a commissioner tradition, mostly because they start arguments. The usual method, sorting by record and adding jokes, mostly ranks luck. A formula built from points does better, and it is not hard to set up in a spreadsheet.

What a good formula should measure

• Quality: how often you outscore the league. All-play win rate is the best ingredient because it removes your schedule.
• Magnitude: how much you outscore it by. Average points for, or points relative to the league average.
• Form: recent weeks, because injuries, trades and bye weeks change teams during a season.
• Not luck: your head-to-head record should carry little weight. It is the thing power rankings are supposed to see past.

An example formula

There is no official formula. Here is a simple one that behaves well and that any league can copy:

Power score = 50% season all-play rate + 30% last-three-weeks all-play rate + 20% points-for index

The points-for index is your average weekly score divided by the league's average weekly score, times 50 so it sits on a similar scale to a percentage (a league-average team gets 50).

Example (illustrative numbers): Team A: 70% season all-play, 55% over the last three weeks, 118 average points in a league averaging 110 (index 53.6). Power score = 0.5 × 70 + 0.3 × 55 + 0.2 × 53.6 = 35 + 16.5 + 10.7 = 62.2. Team B: 58% season, 82% recent, 112 average (index 50.9). Power score = 29 + 24.6 + 10.2 = 63.8. Team B edges ahead on form even with the weaker season.

Tweak the weights to taste. More weight on recent form makes the rankings jumpier; more weight on the season makes them steadier.

Doing it in a spreadsheet

1. Paste each week's scores into one row per team, one column per week.
2. For each week, count how many teams each score beats (a COUNTIF against that week's column does it), add half for each tie, and divide by the number of opponents. That is weekly all-play.
3. Average all weeks for the season rate and the last three columns for the recent rate.
4. Divide each team's average score by the league average and multiply by 50 for the points index.
5. Apply the weights, sort, and write the jokes.

Ten minutes the first week, two minutes every week after that. The rankings will still start arguments, but at least they will be arguments about the right things.

Where formula rankings go wrong

• Small samples. Three weeks of "form" can be one player's two-touchdown game. Do not overreact in September.
• Roster changes. A formula built on past scores cannot see that a team just traded for a top receiver. Commissioners are allowed to adjust and add jokes.
• Lineup mistakes. A team with a great roster and terrible start/sit decisions looks weak on points. Lineup efficiency catches that.
• Only one league. Your number one ranked team is the best of twelve. Whether it would be top ten in a bigger pool is a different question.

Power rankings beyond your league

FantasyMatrix runs the cross-league version. Instead of weighting all-play, each week compares your starters' actual points with a reference built for that NFL week and your league's exact scoring, size and starting slots. That produces Matrix Score, where 100 is a typical team in an equivalent league and 15 points is one standard step. The Leaderboard ranks every eligible team on that one scale, across leagues. Inside your league, My League ranks schedule strength, efficiency, point differential and all-play.

Want the ingredients without the spreadsheet? Create a free account and connect your league: all-play, expected wins and luck for every team in about a minute.