einsteinjpgjpg-4a389e85f92a0547

Fantasy Hockey: Cook Rating Explanation

After playing in three different hockey pools last season, I found it useful to determine the value of a trade by determining how valuable a player is to me. My measure of value in a player is how often the player would do things in a game that would contribute to my head-to-head match up statistics in my hockey pools. After downloading the latest player stats spreadsheet, I made a formula using the programming abilities in Excel. The people that I have shown this formula to have said it’s useful and that I should share it somehow. So with the assistance of my programming friend Shawn Hind, we created this tool for everyone to use for free. Click here to start using the Cook Rating, or continue reading for an explanation of the Cook Rating.

The Cook Rating is way to determine the value of a hockey player given a chosen number of statistics categories. Have you ever wanted to know who the best players are in goals, assists, and hits? How about hits, blocks, and penalty minutes? Any statistic combination that is desired, the Cook Rating would be able to give you the players who are the best players overall in those categories conveniently shown with one simple number. The following example guides you through an example of the Cook Rating calculation for goals and assists:

Example 1

Joe Smith needs better a player who is better in goals and assists for his Fantasy Hockey, “Average Joes”. He inputs into the “Cook Rating Calculator” that his desired categories are Goals (G) and Assists (A). The calculator performs this calculation for every player:

The formula for the Cook Rating for Goals and Assists that each player's stats are run through.
The formula for the Cook Rating for Goals and Assists that each player’s stats are run through.

This is a tedious formula, but it’s simple in plain English: the Cook Rating gives the highest valued players for selected categories. The Cook Rating is the desired statistic, divided by games played, divided by the league average for goals per game played, divided by games played, summed with all other stats calculated this way, divided by the amount of desired stats.

The calculator then outputs the players having the highest Cook Rating for goals and assists:

Rank Player Team Cook Rating POS GP G A
1 Sidney Crosby PIT 3.908 C 80 36 68
2 Steven Stamkos TBL 3.751 C 37 25 15
3 Evgeni Malkin PIT 3.554 C 60 23 49
4 Alex Ovechkin WSH 3.549 RW/LW 78 51 28
5 Ryan Getzlaf ANA 3.416 C 77 31 56
6 John Tavares NYI 3.395 C 59 24 42
7 Corey Perry ANA 3.344 RW 81 43 39
8 Tyler Seguin DAL 3.321 C 80 37 47
9 James Neal PIT 3.274 RW/LW 59 27 34
10 Taylor Hall EDM 3.191 LW 75 27 53

This was just a simple, but useful, example. This formula is expandable to however many statistics that are required and whatever new statistics are thrown at it. A minimum of one category must be used, but all 16 of the player categories may be used. This tool is intended to be useful for those who want assistance in making draft picks, free agent signings, and trades. Any feedback or questions about this is greatly appreciated!Figure 1: Output of the best players in goals and assists based on the Cook Rating.

Shorthanded Points

Some interesting results come from the calculator if any shorthanded category is selected. This is due to the rarity of shorthanded points causing the league average in shorthanded points to be very low. So when a player has a high amount of shorthanded points (like Patrik Elias or Victor Hedman in the 2013-14 season who had 6 Shorthanded Points). Follow this example for a breakdown of the calculation.

1) Determine League Averages for each stat category. Since I can’t present you the calculation of the league average since that would be impractical, you just have to trust me on these league averages. League average for stat = SUM(stat for each player/games played by player)/Number of Players, here is the results for each stat category:

  • League Average G: 0.122132989
  • League Average A: 0.205720518
  • League Average SOG: 1.437599241
  • League Average HITS: 1.289486206
  • League Average BLK: 0.719585984
  • League Average PIM: 0.585342476
  • League Average PPP: 0.069617845
  • League Average SHP: 0.007510141

2) For Patrik Elias, we are going to take each stat and divide stat individually by games played by Patrick Elias, then add all of those number together:

  • G: (18/65)/0.122132989 = 2.267389659
  • A: (35/65)/0.205720518 = 2.617442069
  • SOG: (116/65)/1.437599241 = 1.24138587
  • HITS: (26/65)/1.289486206 = 0.310201069
  • BLK: (19/65)/0.719585984 = 0.406216489
  • PIM: (30/65)/0.585342476 = 0.788493028
  • PPP: (17/65)/0.069617845 = 3.756773326
  • SHP: (6/65)/0.007510141 = 12.29107255 (You can already tell this is what really beefed Elias’ Cook Rating)

3) Now add all of these results, and divide by the number of stats calculated this way (in this case, 8). The number you will get is rounded to 2.960:

Conclusion

The reason Elias’ Cook Rating got so inflated is because of his Short Handed Points. Considering that short-handed points are fairly rare rare, and Elias had the most short-handed points last season, his 6 Short-Handed Points compared to the league average of 0.007510141 is much higher. A player like Victor Hedman will get ranked 1st when doing G, A, +/-, PIM, SHP, PPP, SOG, HIT, BLK as the chosen categories, but removing SHP and keeping the remaining 8 categories with the calculator will give Victor Hedman a 15th place ranking.

Comments

  1. Dennis Paulik

    Love this index but it looks like the data has not been updated this week. Is that correct? Thanks for doing this. Would love to see goalies added.

    Reply

Leave a Reply