Historical Regular Season ZHL Skater and Goalie Stats (Updated 7/5/19)

Share your player tiers, draft analysis, or any thoughtful write-ups.
Eric
Posts: 44
Joined: Sat May 31, 2014 9:38 am
Battle.net Name: Eric
Battle.net Char Code: 2601
Battle.net Server: NA

Historical Regular Season ZHL Skater and Goalie Stats (Updated 7/5/19)

Post by Eric » Fri Sep 21, 2018 9:42 pm

I compiled a list of regular season stats for all ZHL skaters since season 2. I created a spreadsheet that displays this data in various ways:

- Career Records
- Career Per Game Records
- Single Season Records
- Single Season Per Game Records
- Statistics Based Ranking System (career, single season, and broken down by each season)
- Player Comparison/Progression Graphs
- Raw Career/Single Season data

The ranking system loosely represents how players have performed at each position over the years. The numbers used in this ranking system are somewhat arbitrary and are based solely on statistics, which isn’t always the best indicator of a player’s skill, so take the results with a grain of salt. If you have suggestions for a more accurate system, please let me know! The “overall” category is calculated by simply averaging the offense, support, and defense ratings together, so it is more of a “best all-around category”, rather than a true “best overall”.

The “Skater Progression” and “Skater Comparison” tabs offer interactive drop down boxes, which you can use to compare stats of players to one another.

As of now, there is no probe, goalie, or playoff data in the sheet, but those are some things I may add at some point in the future. If you have any suggestions for more features you’d like to see out of this sheet, let me know and I’ll take it into consideration. Performance is already starting to suffer due to the numerous formulas, so I won’t be able to add everything. Enjoy!

Update (9/24/18):

- updated stats through the end of s13
- added another way of determining career positional rankings (average of all season ratings, Watermelon's idea)
- changed positional rankings page to display actual season ratings, rather than scaling them to 1.
- changed weighting of defense stats
- fixed several bugs
- currently looking into figuring out a way to balance out ratings between positions so the Skater Progression graph can become more meaningful.

Update (9/28/18):

- added "Results Per Pickup" pie charts to the "Skater Comparison" page. They show a breakdown of how often a player scores a goal, gets an assist, passes (with no assist), and turns the puck over per pickup. Viewable either for their whole career or by season.
- added missing s13 stats for Lime, Bizarro, and adonis.
- reduced minimum game requirement to appear on "Skater Comparison" and "Skater Progression" pages from 7 to 6.

Update (10/28/18):

- created Team Records page - shows teams with best/worst win %, goals per game, goals allowed per game and goal differential per game
- created Team Lookup page - can easily look up team stats (and stats of players on that team) from any season
- added win %, home win %, away win %
- added career worsts for every stat to the career records page
- added worst career positional rankings
- added possession time per pickup, pickups-PR, and per pickup efficiency stats to career records and single season records pages
- changed the way overall rating is calculated to - 75% best position, 15% second best position, 10% worst position
- re-balanced positional rankings so they are slightly more comparable to each other
- stricter minimums to appear on some pages (to reduce the amount of goalies showing up)
- other minor changes and bug fixes

Update (11/17/18):

- Goalie stats spreadsheet is now out! https://docs.google.com/spreadsheets/d/ ... sp=sharing

On the Skater Stats spreadsheet, I made the following updates:
- created "Champions" page - list of teams that won each season as well as a list of players who have the most rings/finals appearances.
- added "Create a Team" page - can create a team of up to 8 players, assign them each a position and a number of GP. A rating will be generated for the team based on these factors. I may eventually add more features to this page.
- added value by draft position to rankings pages
- added "per possession time" stats and graphs as an alternative way of measuring efficiency
- added head to head win rate graphs to the"Skater Comparision" page
- added average draft position, attendance %, home attendance %, and away attendance % to "Career Records" page
- added more stats to "Team Records" page

Update (2/11/19):

- skater stats have been updated for season 14.
- new radar charts on "Skater Comparison" page
- goalie stats update is coming soon!

Update (2/14/19):

- goalie stats have been updated for season 14.
- tweaked expected overall formula for skaters (range changed from .50-.79 to .53-.83 and increased rate of decay, effectively raising the expectations of players picked early in the draft)

Update (3/11/19):
- created Win Rate By Stat page
- added career team records to Team Records page (team win rates, player with most GP for each team, number of finals wins/losses for each team)
- added teammate win rate graphs to Skater Comparison page
- added games played by team graph to Skater Comparison page
- discord bot coming "soon" to allow for quick stat checking

Update (7/05/19):
Skater stats have been added for season 15. Goalie stats will be added soon.

The ranking system for skaters has been completely revamped.

Ratings are now based off of the league average in each stat, rather than taking the percentage of the season leader's performance. The offense/support/defense/overall rating indicates how many standard deviations above or below the league average a player is. By measuring in standard deviations, the ratings for different positions are now much more comparable to one another. Using league averages also greatly diminishes the impact one player (iFound s15, LK S14, etc.) has on the ratings of other players.

Skater Stats: https://docs.google.com/spreadsheets/d/ ... sp=sharing
Goalie Stats: https://docs.google.com/spreadsheets/d/ ... sp=sharing
Last edited by Eric on Fri Jul 05, 2019 5:57 pm, edited 15 times in total.
User avatar
l)arkangel
Posts: 1106
Joined: Tue Apr 08, 2014 10:50 am
Battle.net Name: Darkangel
Battle.net Char Code: 1457
Battle.net Server: NA
Location: Troll City

Re: Historical Regular Season ZHL Skater Stats

Post by l)arkangel » Fri Sep 21, 2018 11:02 pm

well done
*S5 Champion*

Player Profile
User avatar
Coftea
Posts: 24
Joined: Sun Feb 14, 2016 10:25 am
Battle.net Name:
Battle.net Char Code: 0
Battle.net Server: EU

Re: Historical Regular Season ZHL Skater Stats

Post by Coftea » Sat Sep 22, 2018 7:00 am

Amazing work, this made me wish that I would have played a few seasons on NA! I especially like those interactive tables which are really well implemented and easy to use even if those displayed values and graphs might not represent the actual player's skill in the respective position as you have already written already. But it still gives a good general overview. Image
User avatar
krazymen
Posts: 1170
Joined: Wed Feb 26, 2014 6:10 pm
Battle.net Name: krazymen
Battle.net Char Code: 249
Battle.net Server: NA

Re: Historical Regular Season ZHL Skater Stats

Post by krazymen » Sat Sep 22, 2018 5:03 pm

that is pretty cool eric
Bowling trophy (birthday trophy)
Achieved level 105 in starcraft 2
Undefeated in 5v5
self proclaimed director of ironic trophies
User avatar
Sir
Posts: 138
Joined: Tue Jan 20, 2015 9:37 pm
Battle.net Name: Sir
Battle.net Char Code: 1206
Battle.net Server: NA

Re: Historical Regular Season ZHL Skater Stats

Post by Sir » Sun Sep 23, 2018 2:34 am

Just thought I'd take the opportunity to raise some ancient beef from the dead:
https://forum.zealothockey.net/viewtopi ... =10#p20065

Image

get fucked, blitzerg.
User avatar
forumusername
Posts: 721
Joined: Tue Dec 09, 2014 9:40 am
Battle.net Name: kwakster
Battle.net Char Code: 0
Battle.net Server: NA

Re: Historical Regular Season ZHL Skater Stats

Post by forumusername » Sun Sep 23, 2018 9:01 pm

get carried by eric noob
Image
Image
[+] ruckLUL
Image

LF mediation
User avatar
MrAlerteyes
Posts: 182
Joined: Sat May 31, 2014 9:53 pm
Battle.net Name: MrAlerteyes
Battle.net Char Code: 583
Battle.net Server: NA

Re: Historical Regular Season ZHL Skater Stats

Post by MrAlerteyes » Mon Sep 24, 2018 2:53 pm

Quality stuff Eric!
ZHL Season 8 Champion - Kaldir Yetis

http://www.youtube.com/HaterTotsGaming - For my top tier youtube channel!
Eric
Posts: 44
Joined: Sat May 31, 2014 9:38 am
Battle.net Name: Eric
Battle.net Char Code: 2601
Battle.net Server: NA

Re: Historical Regular Season ZHL Skater Stats (Updated 9/24/18)

Post by Eric » Mon Sep 24, 2018 8:53 pm

Updated the spreadsheet (new link). See original post to see what changed.
https://docs.google.com/spreadsheets/d/ ... sp=sharing
User avatar
Blitz
Posts: 1001
Joined: Tue Jul 22, 2014 8:34 pm
Battle.net Name: Blitzerg
Battle.net Char Code: 713
Battle.net Server: NA

Re: Historical Regular Season ZHL Skater Stats (Updated 9/24/18)

Post by Blitz » Thu Sep 27, 2018 5:48 pm

Top 3 player S8, still couldn't carry Bulb - kid is an anchor.
Image

The only two links you ever need to click:
https://puu.sh/zFTwQ/57cfb6dd4f.png
viewtopic.php?f=57&t=2556
User avatar
LittleDicky
Posts: 601
Joined: Thu Nov 27, 2014 7:22 pm
Battle.net Name: LittleDicky
Battle.net Char Code: 0
Battle.net Server: EU

Re: Historical Regular Season ZHL Skater Stats (Updated 9/28/18)

Post by LittleDicky » Fri Sep 28, 2018 1:20 pm

Once again, NA wins the design game. Pretty neat.
Image
Image
Image
Post Reply