EUDL Hall of Fame

Post Reply
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

EUDL Hall of Fame

Post by Coftea » Tue Apr 03, 2018 8:51 pm

I'm a big fan of stats and therefore I created a sheet in the style of the current EUDLS7 Hall of Fame that includes all EUDL seasons! The sheet displays the top 7 players/records for total, average and 'single game' stats. I also included a tab that shows the statistics for every player that has played atleast 1 EUDL game. I thought there might be someone else out there who also enjoys comparing such boring numbers like me :D

https://docs.google.com/spreadsheets/d/ ... sp=sharing

Some notes:
- EUDL season 1 is currently not included due to the suboptimal way the stats have been kept back then
- No goalie stats have been recorded for season 2, 3 and 4
- Season 5 and 6 recorded shots and saves for the goalies but no 'time tended'. This makes it hard to have a meaningful 'shutout' counter for those seasons
- There are no playoff stats for none of the seasons
User avatar
DerrocK
Posts: 1273
Joined: Tue Jul 29, 2014 11:46 am
Battle.net Name: Junky
Battle.net Char Code: 0
Battle.net Server: EU
Location: Top 1000 EU

Re: EUDL Hall of Fame

Post by DerrocK » Tue Apr 03, 2018 8:58 pm

this is awesome
COTEP W
EZHL S1 W
EU Open W
NA ZHPL S5 W
EUS2 Regular Season W, Commish, AllStar
EU Redline W
EUS6 Commish
Swedish Open 2v2 W
DaGOAT ZHCL Rings: 2
Best Support ZHPL S11
Nº1 EU Forum Poster
Immortals on ice Rings: 3
EUS8 W

Narcissism at its best
MoS
Posts: 306
Joined: Wed Jul 09, 2014 7:51 pm
Battle.net Name: MoS
Battle.net Char Code: 671
Battle.net Server: EU

Re: EUDL Hall of Fame

Post by MoS » Fri Apr 06, 2018 3:13 am

That's sick coftea!
A suggestion for your (and mine) stats-addicted brain -> maybe a stats/season part?
Even though seasons were of different size, so is everybody's career as well.
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: EUDL Hall of Fame

Post by Coftea » Thu Apr 12, 2018 3:14 pm

MoS wrote:
Fri Apr 06, 2018 3:13 am
A suggestion for your (and mine) stats-addicted brain -> maybe a stats/season part?
Even though seasons were of different size, so is everybody's career as well.
Mh... If you want to check the stats of some person from a specific season you can just check the sheet of the respective EUDL season. Or do you mean something like a comparison between the single seasons, or in other words, grouping the stats by seasons and not by a person. I could think about adding that.

I have added few more features on the sheet for all stats-addicted brains:
  • added 'season stats' on the 'Player Stats'-tab that shows the number of games for each season a person as played, seperated for probe and main league
  • stats from EUDL S1 have been added (Note: There are no single game stats for this season, which also was the reason why I didn't add those stats initially)
  • 'Game Stats'-Tab for main and probe league
    • shows the top 5 games for various categories like game with the most (or least) goals / assists / passes
    • general overview
      • total number of recorded games (Season 1 game excluded)
      • number of 4v4s, 3v4s etc
      • number of games with benches
    • total game stats
    • average game stats
  • 'Owner Stats'-tab
    • number of times being owner and in which seasons
    • main regular season results
    • main playoff results
  • 'Achievements'-Tab (does not include free agents)
    • average draft rank and round
    • best draft rank and round
    • season stats
      • sorted after average rank
      • shows in which season a person played
      • shows round and rank for each season
      • shows all owners for which the person played for
    • main playoff stats
https://docs.google.com/spreadsheets/d/ ... sp=sharing
User avatar
Slide
Posts: 183
Joined: Sat Aug 16, 2014 9:43 am
Battle.net Name: slide
Battle.net Char Code: 824
Battle.net Server: EU

Re: EUDL Hall of Fame

Post by Slide » Sat Apr 14, 2018 7:44 am

Crazy work, simply awesome
Draft league (EUDL s2) : finalist
Draft league (EUDL3) : winner
Draft league (EUDL4) : winner
Draft League (ZHL8) : finalist
Draft league (EUDL6) : finalist (LUL)
Draft league (EUDL8) : winner
44 000 gambling Marker bot
User avatar
LittleDicky
Posts: 602
Joined: Thu Nov 27, 2014 7:22 pm
Battle.net Name: LittleDicky
Battle.net Char Code: 0
Battle.net Server: EU

Re: EUDL Hall of Fame

Post by LittleDicky » Sat Apr 14, 2018 9:09 am

Thank you very much. How about adding attendance%, total or per season, or both.
Image
Image
Image
Sunny
Posts: 56
Joined: Mon May 16, 2016 3:55 pm
Battle.net Name: Ravarath
Battle.net Char Code: 2673
Battle.net Server: EU

Re: EUDL Hall of Fame

Post by Sunny » Sat May 19, 2018 5:58 pm

Good job! Since we both had this idea, I will tell you why I did my sheet of all seasons and what's missing from both, maybe you have time:

The most important thing is to quantify a player's skill based on certain inputs such as passes/game.
The player with most passes/game receive a perfect 10 in that category. The player with most goals/game also receive a perfect 10 on goals category.
Every other player will receive a % of how close they are to the first player.

When that is done and each player has a score on each category, then you can combine certain categories (average of some categories) to create a specialization.
A specialization might be offense ((goals + assists + pickups) / 3).
At this point all players will be ranked by these stats of all EUDL seasons so far.

And to make it perfect, do the same thing for each season at a time and with all of that you can create for each player:
hall of fame for each category/specialization, worst season, best season, player trend over seasons and overall stats.

That was my plan for the ultimate stats sheet, but as you know I didn't have enough time to do all of that...
And the 2nd most important reason why I didn't finish it is because players name-changed too often and it became a pain in the ass just to create a mechanism to solve that problem.

Great job so far! Also, you can do so much more with all that information. (best owner, best team so far, etc)
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: EUDL Hall of Fame

Post by Coftea » Thu Sep 13, 2018 5:55 pm

Considering the upcoming season 9 I have updated the sheet with some new stuff. These are the most important changes:
  • Added S8 statistics
  • Added "Goalie" stat which counts the number of games a player was goalie
  • Added multiple color scales to highlight important columns
  • Reconstructed the missing Saves/Shots/Shutout statistics from S2, S3, S4 based on goals allowed and the goalie save%
  • Added an attendance column (Can you find the player who has 123.1% attendance?)
Working with Google Sheet got really painful with a sheet that has this many formulas and data in the background. I tried to reduce the amount of formulas already by working with scripts that only get executed manually (so the sheet doesn't try to recalculate everything constantly), but the performance is still really terrible. So it's unlikely that I will add big suggestions like that from Sunshine to the sheet since that will just increase the recalculations time of the sheet just into infinity I would assume. :ugeek:

https://docs.google.com/spreadsheets/d/ ... 1879643211
User avatar
LoOgiK
Posts: 715
Joined: Thu Jul 07, 2016 5:49 pm
Battle.net Name: BlackPhilou
Battle.net Char Code: 2169
Battle.net Server: EU

Re: EUDL Hall of Fame

Post by LoOgiK » Fri Sep 14, 2018 3:18 am

thanks coftea
EUDL4 winner #10-0
1st best forum spammer
ZHCL 8 9 Winner
EUDL5 Manager
Redline tourney finalist

VOTE KURT FOR S10 COMMISION
Limee
Posts: 13
Joined: Thu Apr 05, 2018 4:59 pm
Battle.net Name: Lime
Battle.net Char Code: 0
Battle.net Server: EU

Re: EUDL Hall of Fame

Post by Limee » Sun Sep 16, 2018 7:07 am

Coftea best LM in eudl history
Post Reply