ABOUT THE SPREADSHEET

Advanced player analytics for competitive hockey

What We Do

The Spreadsheet transforms raw game data into comprehensive player ratings that reveal true performance. Every shot, pass, hit, and defensive play is analyzed to measure how players impact winning.

Our ratings answer a simple question: How much does this player help their team win?

How Ratings Work

1

Gather Game Data

Every game generates detailed stats: goals, assists, shots, passes, defensive plays, and more.

2

Expected Performance

Machine learning predicts how many goals and assists a player should get based on their opportunities and opponent quality.

3

Above/Below Expected

Compare actual results to predictions. Positive = outperforming expectations. Negative = underperforming.

4

Offensive Value

Combine goals and assists above expected, with goals weighted more heavily than assists.

5

Defensive Value

Measure opponent suppression through blocks, takeaways, and preventing scoring chances.

6

Position Weighting

Forwards rated 60% offense / 40% defense. Defensemen rated 40% offense / 60% defense.

7

Competition Quality

Adjust for teammate strength and opponent difficulty. Playing better competition increases your rating.

8

Final Percentile

Rank against all players at your position. Your OVR rating (0-100) shows where you stand.

Reading Your Player Card

OVR Rating

Your overall rating is your percentile rank. OVR 85 means you're better than 85% of players at your position in your league.

Tier System

GAME 7LINE 1LINE 2LINE 3DEPTH

GAME 7: Top 5% (95+)
LINE 1: Top 25% (75-94)
LINE 2: Top 33% (67-74)
LINE 3: Top 60% (40-66)
DEPTH: Bottom 40% (<40)

The Four Ratings

  • OFFENSE: Scoring and playmaking percentile
  • DEFENSE: Opponent suppression percentile
  • TEAM: Teammate quality percentile
  • OPPONENTS: Competition difficulty percentile

Traditional Stats

Your card also shows goals, assists, points, shooting percentage, passing percentage, and key defensive stats like blocks and takeaways.

Why Advanced Stats Matter

Traditional stats don't tell the full story:

  • Context Matters: A player on a stacked team facing weak opponents will rack up points. Our system accounts for teammate quality and opponent strength.
  • Defense Counts: Goals and assists ignore defensive contributions. Our ratings measure complete two-way play.
  • Opportunity vs. Results: A player with great shot quality who isn't finishing will show as underperforming. A player burying low-percentage shots shows as elite.
  • Position Fairness: Comparing forwards to defensemen is apples to oranges. Our system ranks you against players at your position with position-appropriate weights.

The Technical Details

For those interested in the methodology:

  • Machine Learning Models: XGBoost algorithms trained on historical game data predict expected goals and assists with 43% and 53% accuracy respectively.
  • Goals Above Expected (GaX): The difference between actual goals scored and expected goals based on shot quality and positioning.
  • Assists Above Expected (AaX): The difference between actual assists and expected assists based on passing patterns and teammate positioning.
  • Offensive Rating Formula: OFF = GaX + (AaX / 2) — goals weighted double assists.
  • Defensive Rating: Measures opponent performance suppression, adjusted for defensive actions like blocks, takeaways, and interceptions.
  • Z-Score Normalization: Standardizes ratings within position groups so forwards and defensemen are compared fairly.
  • Strength of Schedule: Iterative algorithm converges over 10 iterations, weighting teammate quality 67% and opponent quality 33%.

See Your Rating

Find your player card and see how you stack up against the competition.

View Player Rankings