Top 10s (thru Week 2)

Discussion in 'Leaguegaming Hockey League (LGHL PSN)' started by DEATHS_SHADOW65, Jun 19, 2020.

?

Should I keep doing this weekly?

  1. yes

    92.7%
  2. no

    3.6%
  3. no preference

    3.6%
  1. DEATHS_SHADOW65

    DEATHS_SHADOW65 Well-Known Member

    Joined:
    Oct 3, 2016
    Messages:
    226
    Trophy Points:
    391
    Location:
    Dallas, Texas
    Ratings:
    +395 / 21 / -55
    We're two weeks through S14 and moving on into the mid-season grind time, with that I've decided to share a few things from some side work I've been doing. This season I decided to keep up to date with every game and to input it all into a database to calculate some advanced metrics based off a paper I read written by Alan Ryder on Player Contributions. It's a long ass paper with a lot of math involved but the short story would be he made a system that can essentially calculate how much an individual player contributes to their team's success, similar to baseball's WAR or VORP stats. I liked the idea so much I decided to make this season a test dummy to see how it works within the LG context. This means copy and pasting each game into Excel and then setting up a ton of formulas to calculate everything, literally everything, from those games to make this system work. Quite frankly, it's a pain in the ass but seeing the way it's shaping up already is making it worth it for me and now I want to share a few of the key stats and who the leaders are in each one. I also limited the pool for players to qualify for these stats by having it be that a player has to have played at least 2/3 of the possible 3 games per week so in this case 4 games and above.

    The first stat I have calculated in this database is simply a Strength of Schedule stat (SOS). The way I do this is that I take a player and add up the W-L-OTL for each of the 5 skaters they played in that game. The way my database is set up is that it automatically updates with each game that is inputted because it pulls the site user_id and keeps it up to date to where as soon as I get that game in a player's new opponents record will show up. The way I do this SOS stats is simply taking (Wins + (OTL/2))/Games Played. This calculates out a % of team standing points that this player gets. I do this with every skater for every game and add those up to get an individual players SOS to show how difficult their schedule has been. I exclude goalies from this because they can play double the amount of games in a week and their records skew things quite a bit. Anyway here is this season's leaders in toughest schedules played so far for both Fwd and Def.

    [​IMG]

    The next stat I have is one that anyone familiar with NCAA sports will recognize and that is a Ratings Percentage Index, or better known as RPI. It's a stat that's seen all the time when it comes to March Madness and the College World Series selection shows. This stat piggybacks off the SOS in that it is a weighted index. 25% of it is based off your record, 50% off your opponents record, and 25% off your opponents' opponents record (basically who your opponents played). This helps take into account skaters that played a potentially weaker SOS but their opponents constantly played top lines and helps balance out the final number more. So far, here are the top 10 for both Fwd and Def.

    [​IMG]

    On the flip side here are the bottom 10 players for Fwd and Def in RPI so far this season. Keep in mind that this doesn't mean they "scrub-hunted" because 25% of the number is based off their own record so players with weaker records will have slightly lower RPIs because of that.

    [​IMG]

    Now we start getting into Ryder's actual Player Contribution system. This system is broken down into Player Contribution Offense (PCO), Player Contribution Defense (PCD), and Total Player Contribution (PC). I took the final PC number and added in an RPI factor to adjust it based off a players schedule and who they've played as well. There's way too much math and formulas to show in here but basically Ryder's system boils down to what he calls Marginal Goals which roughly equate to goals above the league average. On Offense, its easy to calculate since there are plenty of offensive stats to use to find that out but Defense is a different story. What he does is takes into account positional weights based off the league that season and the stat totals for Fwd and Def. This basically comes down to two key numbers for the league which are Goal Creation Rate and Goal Allowance Rate which are done on a per/minute basis. These then allow for the final contribution totals to be calculated. Essentially higher numbers equals more contribution in these categories.

    Heres the top 10 for offense (PCO) so far this season:
    [​IMG]

    Heres the top 10 for defense (PCD) so far this season:
    [​IMG]

    And finally, here is the top 10 total contributions (TotAdjPC) that I added in an RPI weighting to as well:
    [​IMG]

    Anyway, I know its a long post but I felt like sharing all this shit with you guys. If you guys think I should keep sharing this weekly or if there is something else you'd want to see statistically let me know and I'll see what I can do.
     
    • Like Like x 24
    • Winner Winner x 9
    Offline
    memphisonfirex
  2. Jensen315

    Jensen315 Well-Known Member

    Joined:
    Nov 28, 2019
    Messages:
    6
    Trophy Points:
    221
    Location:
    California
    Ratings:
    +5 / 1 / -0
    Awesome!
     
    • Like Like x 3
    • Winner Winner x 1
    Offline
    Jensen315
  3. xBrickwall-_-

    xBrickwall-_- Brick "Carey Price" Wall

    Joined:
    Feb 13, 2016
    Messages:
    247
    Discord:
    brick wall#7119
    Trophy Points:
    1,866
    Location:
    Cup Check
    Ratings:
    +322 / 171 / -180
    Need a G ranking tho !
     
    • Like Like x 7
    Offline
    xbrickwall_
  4. Snoki69

    Snoki69 Well-Known Member

    Joined:
    Dec 5, 2018
    Messages:
    45
    Trophy Points:
    1,041
    Location:
    Montreal, Qc
    Ratings:
    +66 / 0 / -1
    I would be curious to know where my line is ranked in the strength of schedule, i'm surprised to not be top 10 tbh
     
    • Like Like x 2
    No Streaming Account
  5. bonwl

    bonwl Well-Known Member

    Joined:
    Oct 22, 2017
    Messages:
    542
    Discord:
    bonwl#9306
    Trophy Points:
    4,151
    Location:
    Ottawa
    Ratings:
    +653 / 34 / -46
    upload_2020-6-19_10-14-26.png
    (referring to the main post, not Snoki's reply.. lol)

    Good shit @DEATHS_SHADOW65 I'm glad to see you went through with this. I'll paypal you for 24/7 access to the database
     
    • Like Like x 1
    Offline
    Bonwl15
  6. DEATHS_SHADOW65

    DEATHS_SHADOW65 Well-Known Member

    Joined:
    Oct 3, 2016
    Messages:
    226
    Trophy Points:
    391
    Location:
    Dallas, Texas
    Ratings:
    +395 / 21 / -55
    I actually will have a G ranking later. I wanted to make sure the database was going to work first before actually spending time to add Gs to it only to find it's all broken.
     
    • Like Like x 5
    Offline
    memphisonfirex
  7. DEATHS_SHADOW65

    DEATHS_SHADOW65 Well-Known Member

    Joined:
    Oct 3, 2016
    Messages:
    226
    Trophy Points:
    391
    Location:
    Dallas, Texas
    Ratings:
    +395 / 21 / -55

    My price was 750k but you guys said nahhhhh :p I'll PM you though Bon cuz I could probably use a second set of eyes to help spot any huge errors and I know you know what to look for
     
    Offline
    memphisonfirex
  8. PLP Kenny

    PLP Kenny Well-Known Member

    Joined:
    Jul 31, 2018
    Messages:
    135
    Discord:
    PLP Kenny#5081
    Trophy Points:
    191
    Location:
    Long Island, NY
    Ratings:
    +43 / 10 / -15
    Love to see it
     
    • Like Like x 1
    Offline
    kennypoulin
  9. Levac27

    Levac27 Played all 6 positions in LGHL

    Joined:
    Dec 2, 2015
    Messages:
    350
    Discord:
    Levac27#5851
    Trophy Points:
    591
    Location:
    Montreal
    Ratings:
    +163 / 35 / -141
    Keep doing this !
     
    Offline
    Levac27
  10. natesous10

    natesous10 Well-Known Member

    Joined:
    Sep 8, 2018
    Messages:
    83
    Trophy Points:
    1,411
    Location:
    Canada
    Ratings:
    +136 / 1 / -6
    no goalie love:(
     
    • Get Good Get Good x 1
    • Informative Informative x 1
    • Dumb Dumb x 1
    No Streaming Account
  11. Snizzah

    Snizzah SnizLIVE

    Joined:
    Oct 25, 2014
    Messages:
    202
    Discord:
    Sniz#6305
    Trophy Points:
    4,591
    Location:
    Halifax, Canada
    Ratings:
    +490 / 88 / -43
    • Like Like x 1
    Offline
    Snizzahh
  12. eStokes

    eStokes I'm a product of my environment

    Joined:
    May 7, 2014
    Messages:
    49
    Trophy Points:
    1,191
    Location:
    Philly
    Ratings:
    +55 / 0 / -2
    Good Job Memphis!
     
    • Like Like x 1
    No Streaming Account
  13. iCallsoWhat55

    iCallsoWhat55 Well-Known Member

    Joined:
    Oct 30, 2016
    Messages:
    504
    Discord:
    icallsowhat55#1227
    Trophy Points:
    2,191
    Location:
    Wuhan, China
    Ratings:
    +744 / 48 / -138
    none of the pics work for me
     
    Offline
    icallsowhat55
  14. DEATHS_SHADOW65

    DEATHS_SHADOW65 Well-Known Member

    Joined:
    Oct 3, 2016
    Messages:
    226
    Trophy Points:
    391
    Location:
    Dallas, Texas
    Ratings:
    +395 / 21 / -55
    Weird does it show a link or anything to them? Cuz they pull up on my phone and PC. If not I could try to send them to you
     
    Offline
    memphisonfirex
  15. iCallsoWhat55

    iCallsoWhat55 Well-Known Member

    Joined:
    Oct 30, 2016
    Messages:
    504
    Discord:
    icallsowhat55#1227
    Trophy Points:
    2,191
    Location:
    Wuhan, China
    Ratings:
    +744 / 48 / -138
    nope just says [​IMG]
     
    Offline
    icallsowhat55
  16. Ebonynee

    Ebonynee Well-Known Member

    Joined:
    Dec 6, 2015
    Messages:
    98
    Trophy Points:
    5,651
    Location:
    China
    Ratings:
    +143 / 9 / -16
    Wow I’m cracked
     
    • Like Like x 1
    • Winner Winner x 1
    • Useful Useful x 1
    Offline
    ebonynee
  17. KROFTONITE

    KROFTONITE Credentialed media in AHL for CapitalsOutsider.com

    Joined:
    Nov 17, 2015
    Messages:
    231
    Discord:
    crofto40#8304
    Trophy Points:
    1,191
    Location:
    Pennsylvania
    Ratings:
    +644 / 3 / -25
    I am just happy I finally made a list!
     
    Offline
    kroftonite
  18. PattyLive

    PattyLive Well-Known Member

    Joined:
    Oct 5, 2016
    Messages:
    37
    Discord:
    Patty#9911
    Trophy Points:
    3,091
    Location:
    Boston
    Ratings:
    +41 / 0 / -5
    Offline
    PatJoyce
  19. CHARAx33

    CHARAx33 Well-Known Member

    Joined:
    Dec 22, 2015
    Messages:
    11
    Discord:
    CHARAx33#3454
    Trophy Points:
    1,261
    Location:
    Hamilton, ontario
    Ratings:
    +9 / 0 / -0
    Offline
    charax33z