Quote:
Originally Posted by sgrondin98
Are you working on a tool to export csv files or something like this ... like rosters - stats standings ???
|
Something like that. I am putting together a spreadsheet that attempts to provide some advanced analytics based on the data we can pull from the game. For example, I currently have a formula to calculate a player's expected goals while on the ice: it takes all the NHL goals scored, multiplied by 4 (since there are usually 4 other players on the ice when a goal goes in), divided by the league-wide Fenwick-For, to provide a rough shooting percentage for the NHL. Apply that to a player's individual FF, and you get an expected-goals stat.
Comparing the output to my team's actual oi-GF (which has to be looked up manually, since it isn't exported), 3 players were dead-on accurate, 9 players were within 3 goals, and 14 players were within 4 goals of their oixGF.
I've also put together a goals-above-replacement metric, based on the numbers used by Evolving Hockey. This lets you see how much better a player is vs the bottom ~20% of NHL players. Also from Evolving Hockey, I used their numbers to add an "expected wins" contribution, though this one is a little harder to predict. I'll keep working on it though.
All of this is done from a single page on the spreadsheet, with dropdown menus to select the team, player, and stat view you want to use, and it can compare three players at a time. It's in its very rough stages right now, but you can see some screenshots on the Discord if you're interested!