overpass
Registered User
- Jun 7, 2007
- 5,274
- 2,819
A few years ago I put together a spreadsheet with situational and adjusted stats for NHL players. The stats begin in 1967-68 when plus-minus data was first officially published by the NHL. Some members of the ATD community have found it useful so I thought I might as well post it for general use and discussion.
Link is here. Stats are included for individual seasons and careers. If you use pivot tables, there's one included so you can easily filter and calculate the stats over a particular time frame.
Full file through 2020
Career numbers only
There's a glossary explaining the different terms included in the download. Here are a few of the commonly used ones.
$ESG Even strength goals, adjusted to a league scoring level of 180 ESG per team.
$ESA Even strength assists, adjusted to a league scoring level of 180 ESG per team.
$ESP Even strength points, adjusted to a league scoring level of 180 ESG per team.
$ESGF Even strength goals for (on-ice), adjusted to a scoring level of 180 ESG per team.
$ESGA Even strength goals against (on-ice), adjusted to a scoring level of 180 ESG per team.
R-ON Even strength GF/GA ratio for the player's team while the player was on the ice.
R-OFF Even strength GF/GA ratio for the player's team while the player was off the ice.
AEV+/- Adjusted even-strength plus-minus - plus minus adjusted for scoring level and strength of team. Calculated with (EV+/-) - (XEV+/-). Does not adjust for strength of linemates or opposition.
EV% Percentage of team's even strength goals, both for and against, for which the player was on the ice (per game). Calculation is (ESGF+ESGA)/(TmESGF+TmESGA)/SFrac. If you don't want it on a per-game basis, simply multiply by SFrac.
TmEV+ Strength of the player's team at even strength. 1 is average, higher is better. Calculated with TmESGF/TmESGA.
$PPG Power play goals, adjusted to a league scoring level of 60 PPG per team and a league-average number of power play opportunities.
$PPA Power play assists, adjusted to a league scoring level of 60 PPG per team and a league-average number of power play opportunities.
$PPP Power play points, adjusted to a league scoring level of 60 PPG per team and a league-average number of power play opportunities.
PP% Percentage of team's power play goals for which the player was on the ice (per game). Calculation is PGF/TmPPGF/SFrac. If you don't want it on a per-game basis, simply multiply by SFrac.
TmPP+ Strength of the player's team's power play. 1 is average, higher is better. Calculated with ((TmPPGF-TmSHGA)/TmPPO)/((LgPPGF-LgSHGA)/LgPPO).
$SHG Shorthanded goals, adjusted to a league scoring level of 6 SHG per team and a league-average number of times shorthanded.
$SHA Shorthanded assists, adjusted to a league scoring level of 6 SHG per team and a league-average number of times shorthanded.
$SHP Shorthanded points, adjusted to a league scoring level of 6 SHG per team and a league-average number of times shorthanded.
SH% Percentage of team's power play goals against which the player was on the ice (per game). Calculation is PGA/TmPPGA/SFrac. If you don't want it on a per-game basis, simply multiply by SFrac.
TmSH+ Strength of the player's team's penalty kill. 1 is average, lower is better. Calculated with ((TmPPGA-TmSHGF)/TmTSH)/((LgPPGF-LgSHGA)/LgPPO)
Link is here. Stats are included for individual seasons and careers. If you use pivot tables, there's one included so you can easily filter and calculate the stats over a particular time frame.
Full file through 2020
Career numbers only
There's a glossary explaining the different terms included in the download. Here are a few of the commonly used ones.
$ESG Even strength goals, adjusted to a league scoring level of 180 ESG per team.
$ESA Even strength assists, adjusted to a league scoring level of 180 ESG per team.
$ESP Even strength points, adjusted to a league scoring level of 180 ESG per team.
$ESGF Even strength goals for (on-ice), adjusted to a scoring level of 180 ESG per team.
$ESGA Even strength goals against (on-ice), adjusted to a scoring level of 180 ESG per team.
R-ON Even strength GF/GA ratio for the player's team while the player was on the ice.
R-OFF Even strength GF/GA ratio for the player's team while the player was off the ice.
AEV+/- Adjusted even-strength plus-minus - plus minus adjusted for scoring level and strength of team. Calculated with (EV+/-) - (XEV+/-). Does not adjust for strength of linemates or opposition.
EV% Percentage of team's even strength goals, both for and against, for which the player was on the ice (per game). Calculation is (ESGF+ESGA)/(TmESGF+TmESGA)/SFrac. If you don't want it on a per-game basis, simply multiply by SFrac.
TmEV+ Strength of the player's team at even strength. 1 is average, higher is better. Calculated with TmESGF/TmESGA.
$PPG Power play goals, adjusted to a league scoring level of 60 PPG per team and a league-average number of power play opportunities.
$PPA Power play assists, adjusted to a league scoring level of 60 PPG per team and a league-average number of power play opportunities.
$PPP Power play points, adjusted to a league scoring level of 60 PPG per team and a league-average number of power play opportunities.
PP% Percentage of team's power play goals for which the player was on the ice (per game). Calculation is PGF/TmPPGF/SFrac. If you don't want it on a per-game basis, simply multiply by SFrac.
TmPP+ Strength of the player's team's power play. 1 is average, higher is better. Calculated with ((TmPPGF-TmSHGA)/TmPPO)/((LgPPGF-LgSHGA)/LgPPO).
$SHG Shorthanded goals, adjusted to a league scoring level of 6 SHG per team and a league-average number of times shorthanded.
$SHA Shorthanded assists, adjusted to a league scoring level of 6 SHG per team and a league-average number of times shorthanded.
$SHP Shorthanded points, adjusted to a league scoring level of 6 SHG per team and a league-average number of times shorthanded.
SH% Percentage of team's power play goals against which the player was on the ice (per game). Calculation is PGA/TmPPGA/SFrac. If you don't want it on a per-game basis, simply multiply by SFrac.
TmSH+ Strength of the player's team's penalty kill. 1 is average, lower is better. Calculated with ((TmPPGA-TmSHGF)/TmTSH)/((LgPPGF-LgSHGA)/LgPPO)
Last edited: