Login

FuzzSHL · 02-03-2024, 02:47 AM

Hi! Yesterday I posted my S74 SHL Awards Nominations Review, if you haven't already, go check it out! In that post I used my player cards as a visual representation of a player's season in many different facets. While the responses were positive, it did make me realize that not everyone has seen my player cards before. So, instead of just posting an explanation for my new goalie cards, I thought I would make a little longer of a post and provide an explanation on both the skater card and the goalie card. While there may be some minor additions or changes over time, the bulk of the thought process, theory, and implementation will not change moving forward. So, let's get into it, and if you have any questions, please don't hesitate to post a comment or send me a DM!

We'll start with the card that has been around for a few seasons and the one that most of the site would likely be interested in: the skater card.

So, we'll start with the easiest information at the top of the card, outlined in purple, and work our way down through the different sections. The database import that I have, courtesy of @Canadice , has included all skaters in the FHM file and their respective stats for the season. Using this sheet, I have a dropdown next to Player Name: that allows me to type in a player's name and select them. Because of this set up, players like Shoyo Hinata will not have the special characters included. So, my apologies for those players with special characters, but this is unfortunately what needs to happen to allow for this type of data import. Using the player name, the card is able to pull from a different database the Username, Team, and Position. While the Username is more for instances like the Awards review, both the Team and Position are important for later in the card.

Next, we move down the section highlighted in orange and blue, what I have labeled currently as Player. Using the player's name, the card is able to pull that player's stats for the season for everything that you see highlighted in orange. The stats that are calculated after the import are outlined in blue. The percentages that you see under each stat is that player's percentile rank compared to their position group. Forwards (C, LW, RW) are grouped together while Defensemen (LD, RD) are also grouped together. I would love to separate the forward group into wingers and centers, but that distinction will take a little while to implement. All of the per-minute rates (Shot Blocks/min, Hits/min, etc) are calculated by, you guessed it, dividing that stat by the player's total minutes played.

Moving on to the section outlined in yellow, this is where we take a little deeper look at how the player stacks up against their team, NOT other skaters. Here is likely where a bit more confusion will pop up for those looking at the player cards for the first time, so here's what each individual stat is and how it came to be.

% of TGoals: This takes the player's goals scored and divides it by the team's goals scored, showing the percentage of the team's goals actually scored by the player
Contribution%: This takes the player's points and divides it by the team's goals scored, showing the percentage of the team's goals that the player factored into. Since you can't have both a goal and an assist on a goal, there is no overlap or artificial inflation of a player's contribution
Shot Block%: This takes the player's shot blocks and divides it by the team's total shot blocks, showing the percentage of the team's shot blocks that the player attributed for
Hit%: This takes the player's hits and divides it by the team's total hits, showing the percentage of the team's hits that the player attributed for
GvA%: This takes the player's giveaways and divides it by the team's total giveaways, showing the percentage of the team's giveaways that the player attributed for
TkA%: This takes the player's takeaways and divides it by the team's total takeaways, showing the percentage of the team's takeaways that the player attributed for
Ratio v Team: This takes the player's TkA/GvA ratio and compares it to the team's TkA/GvA ratio, showing negative and red if the player's ratio was worse, or positive and green if the player's ratio was better
/60 v Team: For each of GF/60, GA/60, SF/60, and SA/60, this cell looks at the player's ratios compared to the team's ratios. If the player's ratio is better (+ for GF/SF, - for GA/SA), the cell will be highlighted in green. If the player's ratio is worse, the cell will be highlighted in red

The bottom section, outlined in pink, is the import of the team's stats.

If you feel there is anything missing from this (note: penalty minutes will hopefully be added for next season), please feel free to drop your suggestions in the comments or in my DMs!

Onto the newest addition to the cards, the goalie card!

Just like with the skater card, we are able to pull the Username, Team, and Position (G) upon name input. This information is pulled from the same database as the skater import, just from a separate tab, so the same issues are present with goalie names that have special characters.

The section outlined in orange is the goalie's typical stats for wins, losses, shots against, saves, etc. With the skater card, the skater's stats were compared to all skaters of the same position group. For goalies, however, I felt it was not fair to compare starting goalies with a ton of time to all goalies involved for specific stats. While games played, minutes played, wins, losses, overtime losses, shutouts, shots against, saves, goals against, and GAA are currently percent ranked to all goalies, save percentage (and the following section outlined in yellow) is compared only to starting goalies (min. 33 games played).

Speaking of the yellow outlined area, this is a conglomerate of calculations I've made myself, so I'll split the explanation into three separate sections: GSAR, GSAA, and GSA75.

We'll start a little out of order with GSAA, which stands for Goals Saved Above Average. The site index has this available, and those who look at both my cards and the site index will notice that the site's GSAA and mine don't line up. I am not entirely sure why these numbers don't line up, maybe my calculations are doing something incorrect, but here's how I got to the number that I did. First, I added together all of the shots faced by all goalies who appeared in a game. Taking shots by skaters would include shots on an empty net, which I did not want to do. Then, I added the goals allowed by all goalies who appeared in a game, and used those two numbers to determine the overall league save percentage. When a goalie is selected, the goalie card uses the league save percentage and applies it to the goalie's shots faced, which calculates how many goals "league average" would have allowed on that amount of shots. Comparing that number to the actual goals allowed by that goalie then gives us the GSAA of the given goalie. GSAA is a counting stat, meaning the goalies who face higher volumes and see more game time will likely see higher GSAA totals. To attempt to mitigate this, I use the goalie's games played to calculate GSAA-per-game (shown as GSAA/G). This voting cycle led me to realize that GSAA-per-shot faced would likely lead to a more accurate depiction of what we would want to see, and that will be a change I make before next season's voting cycle.

Moving on to GSAR and GSA75, these are both stats of my own making, more or less. GSAR was an idea I got while looking over baseball and certain IRL hockey statistics, which often reference "replacement level". So, I got to thinking and thought of a way that I could more or less introduce "replacement level" goaltending to SHL statistics. For both GSAR and GSA75, only starter save percentages were taken into account. On a separate tab, I made a table separating the league's starting goalie save percentages into the following categories: minimum, 25th percentile, 50th percentile, 75th percentile, and maximum. 50th percentile is ignored in favor of the overall league save percentages that we calculated for GSAA, while the 25th quartile save percentage is used as the Replacement Level Save Percentage while the 75th percentile save percentage is used for, you guessed it, GSA75 calculations. The method for determining GSAR and GSA75 are the same as determining GSAA except we use the replacement level save percentage and 75th percentile save percentage in the calculations instead of the overall league save percentage. The same is done for the per-game rates of these statistics.

SA/G is shots against per game. Shots faced divided by games played.

Now, one last thing about the yellow outlines section. Instead of percentages, as seen in the orange outlined section and in the skater card, these stats have simply numbers. These numbers are the ranks of the given goalie's stats among the league's starting goalies. I am still debating on whether to use ranks or percentages for the other goalie stats and the skater cards, but for the number of starting goalies in the league, I figured that using the actual rank instead of percentage rank would be a better visual to have.

That's it! Once again if anyone has any questions, concerns, suggestions, or requests, please don't hesitate to leave a comment or message me on the site or Discord. Thank you so much for reading!

Aleksi Kettu

**leafsftw1967** · 02-04-2024, 10:28 AM

I have been so impressed with the effort and analysis you have brought to the awards committee since joining. You have really been the mvp of the committee and helped improve the voting process significantly!

*Carpy48* · 02-04-2024, 11:14 AM

That was very detailed and is so useful. Also very well explained.

***Anthique*** · 02-05-2024, 11:34 AM

Thanks for adding the goalies!

Does one day we will be able to use it ourselves?

Navigation

Extra Menu

About us