Hey man, I love this spreadsheet a lot, I appreciate it. I am a big goalie nerd, and the way the stats are averaged are inaccurate because it does not account for games played. With the current formula, if a goalie plays 3 games with a 0.970 sv% in season 1 and then 40 games with a 0.910 sv% in season 2, it would generate an avg sv% of 0.945 instead of the expected/correct 0.914. This especially effects goalies that play 1 or 2 games as a rookie to fill for injuries or what have you, and play either really bad or really good, this calculation method would result in a skew in his stats for the remainder of his career. To correct this, I added an additional column to each goalie's stats that includes GP. I then created two rows of invisible text underneath the table that simply stores the weighted score of sv% * GP (also GAA * GP). Instead of the averageif command, you can instead fill the total stats by summing these invisible values (in the way I have formatted it, they will occupy cells d28:d52 for GAA and e28:e52 for sv%) and then dividing that summed value by total GP. This calculation method allows you to approximate GA and saves/shots against indirectly, so you don't have to include those stats directly in the table, which would make it like 7 columns wide lol. Doing it this way, Demko's career stats, for example, go from totaling 3.09 GAA; 0.902 SV% to 2.90 GAA; 0.910 SV% which is a more accurate depiction of his career stats. Just to circle back to the first paragraph, the stats are skewed so low almost solely because in his rookie season he played 1 game with a 3.91 and 0.866 which would forever pull down his career average. I hope that my description makes sense. I would be happy to send you my version of your spreadsheet if needed (this is the only thing I changed beyond changing all team codes to 3 characters and ANA & ARI to be coloured orange and burgundy respectively. Again, I love the spreadsheet so much, I'm a huge stats nerd and had made my own version of this type of thing a few years ago but it never reached the complexity/completeness that this one does, so I really appreciate having access to it!
I just saw this! Absolutely fabulous comment, I love hearing the goalie perspective since I am a player and tend to not consider the goalie stats as much as I really should! I will definitely make that change to the spreadsheet! Great insight!
![เป็นไปได้ไหม - WanMai [Performance Video]](http://i.ytimg.com/vi/Eh5hItD4Mr0/mqdefault.jpg)
Thanks!
Hey man, I love this spreadsheet a lot, I appreciate it.
I am a big goalie nerd, and the way the stats are averaged are inaccurate because it does not account for games played. With the current formula, if a goalie plays 3 games with a 0.970 sv% in season 1 and then 40 games with a 0.910 sv% in season 2, it would generate an avg sv% of 0.945 instead of the expected/correct 0.914. This especially effects goalies that play 1 or 2 games as a rookie to fill for injuries or what have you, and play either really bad or really good, this calculation method would result in a skew in his stats for the remainder of his career.
To correct this, I added an additional column to each goalie's stats that includes GP. I then created two rows of invisible text underneath the table that simply stores the weighted score of sv% * GP (also GAA * GP). Instead of the averageif command, you can instead fill the total stats by summing these invisible values (in the way I have formatted it, they will occupy cells d28:d52 for GAA and e28:e52 for sv%) and then dividing that summed value by total GP. This calculation method allows you to approximate GA and saves/shots against indirectly, so you don't have to include those stats directly in the table, which would make it like 7 columns wide lol.
Doing it this way, Demko's career stats, for example, go from totaling 3.09 GAA; 0.902 SV% to 2.90 GAA; 0.910 SV% which is a more accurate depiction of his career stats. Just to circle back to the first paragraph, the stats are skewed so low almost solely because in his rookie season he played 1 game with a 3.91 and 0.866 which would forever pull down his career average.
I hope that my description makes sense. I would be happy to send you my version of your spreadsheet if needed (this is the only thing I changed beyond changing all team codes to 3 characters and ANA & ARI to be coloured orange and burgundy respectively.
Again, I love the spreadsheet so much, I'm a huge stats nerd and had made my own version of this type of thing a few years ago but it never reached the complexity/completeness that this one does, so I really appreciate having access to it!
I just saw this! Absolutely fabulous comment, I love hearing the goalie perspective since I am a player and tend to not consider the goalie stats as much as I really should! I will definitely make that change to the spreadsheet! Great insight!
I just implemented your changes to the goalie tracker! Thanks for all the input, it works like a charm!
This is awesome Man! Thank you for sharing! Love all the detail and hard work you’ve put in to this. Much appreciated brother!
This is the type of detail I love
FYI ECHL only plays 72 games. Thanks for sharing though ;-)
1st.