Where do you get your stats from? I am finding it difficult to find good stats for hockey. NHL.com is in some weird format that won't paste correctly to excel. Hockey reference has good stats, but not everything I am looking for. At the moment, I am trying to find Penalty kill shots allowed.
The problem has been a lot of the stats guys have been hired by teams so it has been up in the air. I use Naturalstattrick.com for most of my shot metrics. puckon.net also has filters for PK and can filter over years, months or games.
Corsica was the go to site for any analytics but the author shut it down. He has promised to relaunch with a new and improved site so keep an eye out for that.
***edit*** I see puckon.net no longer has PP and PK filters just even strength and full strength, so that's probably not the best plus it is only team based not player so you can ignore that one.
I just went with hockey reference. I can get 90% of what I need, it copies and pastes easily. Rather than try to figure out some formula for PP goals, I just averaged the GF and GA of the offense and defense. I have to test it, but on a few games, I get decently close enough to the line to make it worthwhile to continue.
For those that are interested corsica.hockey just relaunched. It has tons of advanced stats for skaters/teams/ whatever. NaturalStatTrick.com is also a great resource for stats.
i know people look at powerplay and short-handed play alot........ but do some teams create more powerplay and give more shorthanded opportunities than others? or do the refs - for whatever reason - assign penalties fairly equally to teams?