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:
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:
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:
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.
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:
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.