Page 1 of 2

Player Distribution

PostedCOLON Thu Feb 02, 2017 9:45 am
by dave1959
Centres with 10 Pts or more
Anaheim-1
Arizona-1
Boston-3
Buffalo-3
Carolina-2
Calgary-5
Chicago-4
Columbus-1
Colorado-4
Dallas-4
Detroit-4
Edmonton-3
Florida-5
Los Angeles-4
Minnesota-4
Montreal-5
Nashville-5
New Jersey-2
NY Islanders-5
NY Rangers-2
Ottawa-4
Philadelphia-3
Pittsburgh-3
San Jose-3
St. Louis-5
Tampa Bay-4
Toronto-4
Vancouver-4
Washington-5
Winnipeg-5

Wingers with 10 points or more
Anaheim-4
Arizona-6
Boston-8
Buffalo-8
Carolina-8
Calgary-8
Chicago-6
Columbus-9
Colorado-3
Dallas-7
Detroit-5
Edmonton-7
Florida-8
Los Angeles-10
Minnesota-5
Montreal-6
Nashville-14
New Jersey-8
NY Islanders-6
NY Rangers-6
Ottawa-6
Philadelphia-8
Pittsburgh-5
San Jose-6
St. Louis-7
Tampa Bay-6
Toronto-6
Vancouver-5
Washington-7
Winnipeg-6

Defencemen with 7 Points or more
Anaheim-7
Arizona-5
Boston-5
Buffalo-5
Carolina-2
Calgary-6
Chicago-5
Columbus-4
Colorado-4
Dallas-4
Detroit-5
Edmonton-2
Florida-4
Los Angeles-8
Minnesota-6
Montreal-5
Nashville-8
New Jersey-5
NY Islanders-5
NY Rangers-2
Ottawa-4
Philadelphia-4
Pittsburgh-6
San Jose-5
St. Louis-6
Tampa Bay-5
Toronto-5
Vancouver-5
Washington-6
Winnipeg-6

Goalies with 1 or more Wins:
Anaheim-3
Arizona-2
Boston-2
Buffalo-2
Carolina-2
Calgary-3
Chicago-1
Columbus-1
Colorado-2
Dallas-2
Detroit-2
Edmonton-2
Florida-2
Los Angeles-2
Minnesota-2
Montreal-2
Nashville-2
New Jersey-4
NY Islanders-2
NY Rangers-2
Ottawa-3
Philadelphia-2
Pittsburgh-2
San Jose-4
St. Louis-3
Tampa Bay-2
Toronto-2
Vancouver-2
Washington-2
Winnipeg-3


Average Age (per Roster Submission Page)
Anaheim-24.73
Arizona-25.88
Boston-26.55
Buffalo-23.44
Carolina-26.14
Calgary-23.46
Chicago-29 oldest
Columbus-25.07
Colorado-23.43
Dallas-21.81 youngest
Detroit-25.38
Edmonton-22.9
Florida-25.50
Los Angeles-22.68
Minnesota-22.56
Montreal-23.37
Nashville-22.74
New Jersey-25.44
NY Islanders-25.63
NY Rangers-25.82
Ottawa-25.85
Philadelphia-22.51
Pittsburgh-25.50
San Jose-23.47
St. Louis-26.43
Tampa Bay-24.71
Toronto-23.45
Vancouver-25.84
Washington-25.26
Winnipeg-24.22

Re: Player Distribution

PostedCOLON Thu Feb 02, 2017 9:49 am
by The BBKL Insider
wow dave, tons of work....

did you toss this together that quickly after our conversation? incredible!

Re: Player Distribution

PostedCOLON Thu Feb 02, 2017 9:53 am
by dave1959
I did...excel makes it pretty easy

Re: Player Distribution

PostedCOLON Thu Feb 02, 2017 10:00 am
by Tony
For goalies, do you mean shutouts?

Re: Player Distribution

PostedCOLON Thu Feb 02, 2017 10:22 am
by dave1959
Tony wroteCOLONFor goalies, do you mean shutouts?
No Tony. Number of Goalies each team has with 1 or more Wins.

ie I have Jake Allen, that's it.

Re: Player Distribution

PostedCOLON Thu Feb 02, 2017 10:25 am
by Matthew
You should do age distribution next

Re: Player Distribution

PostedCOLON Thu Feb 02, 2017 10:41 am
by thom54
love this deep dive.

Re: Player Distribution

PostedCOLON Thu Feb 02, 2017 11:11 am
by dave1959
LordQuack wroteCOLONYou should do age distribution next

There are over 700 players born from 1990 to 1998 that have played at least 1 NHL game.

Might take a while...

Re: Player Distribution

PostedCOLON Thu Feb 02, 2017 11:16 am
by foofnik
Use the sheets, they have Age and Birthdates and are obviously separated by each BBKL team already. Average for each team should be quick, median would require some sorting and filtering.

Re: Player Distribution

PostedCOLON Thu Feb 02, 2017 12:10 pm
by dave1959
Average Age (per Roster Submission Page)

see player distribution -top of page

Re: Player Distribution

PostedCOLON Thu Feb 02, 2017 12:35 pm
by Matthew
dave1959 wroteCOLONAverage Age (per Roster Submission Page)


Anaheim-24.73
Arizona-25.88
Boston-
Buffalo-23.44
Carolina-
Calgary-
Chicago-
Columbus-
Colorado-
Dallas-21.81
Detroit-
Edmonton-
Florida-
Los Angeles-22.68
Minnesota-
Montreal-
Nashville-
New Jersey-
NY Islanders-
NY Rangers-
Ottawa-25.85
Philadelphia-
Pittsburgh-25.50
San Jose-
St. Louis-
Tampa Bay-
Toronto-23.45
Vancouver-
Washington-25.26
Winnipeg-

more to come
You're using everyone's prospects. Maybe I'll try and did what u did with points, but for age, later.

Re: Player Distribution

PostedCOLON Thu Feb 02, 2017 1:47 pm
by Tony
NY Islanders - 75

Re: Player Distribution

PostedCOLON Thu Feb 02, 2017 2:08 pm
by Arian The Insider
I have an average age calculation and their updated ages in my personal excel sheet so I can just send mine to anyone doing it, to at least save them from doing one team.

Re: Player Distribution

PostedCOLON Thu Feb 02, 2017 2:53 pm
by Loki
Awesome work Dave, really interesting to see :D

Re: Player Distribution

PostedCOLON Thu Feb 02, 2017 5:07 pm
by Nick
it's cool for sure.

Re: Player Distribution

PostedCOLON Thu Feb 02, 2017 8:47 pm
by hong57
dave1959 wroteCOLON Average Age (per Roster Submission Page)
Anaheim-24.73
Arizona-25.88
Boston-26.55
Buffalo-23.44
Carolina-26.14
Calgary-23.46
Chicago-29 oldest
Columbus-25.07
Colorado-23.43
Dallas-21.81 youngest
Detroit-25.38
Edmonton-22.9
Florida-25.50
Los Angeles-22.68
Minnesota-22.56
Montreal-23.37
Nashville-22.74
New Jersey-25.44
NY Islanders-25.63
NY Rangers-25.82
Ottawa-25.85
Philadelphia-22.51
Pittsburgh-25.50
San Jose-23.47
St. Louis-26.43
Tampa Bay-24.71
Toronto-23.45
Vancouver-25.84
Washington-25.26
Winnipeg-24.22
surprisingly.. i have the 3rd youngest team in the league

Re: Player Distribution

PostedCOLON Thu Feb 02, 2017 8:48 pm
by hong57
Thanks for all these work Dave the pig

Re: Player Distribution

PostedCOLON Thu Feb 02, 2017 8:54 pm
by Matthew
hong57 wroteCOLON
dave1959 wroteCOLON Average Age (per Roster Submission Page)
Anaheim-24.73
Arizona-25.88
Boston-26.55
Buffalo-23.44
Carolina-26.14
Calgary-23.46
Chicago-29 oldest
Columbus-25.07
Colorado-23.43
Dallas-21.81 youngest
Detroit-25.38
Edmonton-22.9
Florida-25.50
Los Angeles-22.68
Minnesota-22.56
Montreal-23.37
Nashville-22.74
New Jersey-25.44
NY Islanders-25.63
NY Rangers-25.82
Ottawa-25.85
Philadelphia-22.51
Pittsburgh-25.50
San Jose-23.47
St. Louis-26.43
Tampa Bay-24.71
Toronto-23.45
Vancouver-25.84
Washington-25.26
Winnipeg-24.22
surprisingly.. i have the 3rd youngest team in the league
I think he is including prospects. So if u have lots of players in your minors...like the full 90 available, then you'll likely come up looking young.

Re: Player Distribution

PostedCOLON Thu Feb 02, 2017 9:54 pm
by hong57
LordQuack wroteCOLON
hong57 wroteCOLON
dave1959 wroteCOLON Average Age (per Roster Submission Page)
Anaheim-24.73
Arizona-25.88
Boston-26.55
Buffalo-23.44
Carolina-26.14
Calgary-23.46
Chicago-29 oldest
Columbus-25.07
Colorado-23.43
Dallas-21.81 youngest
Detroit-25.38
Edmonton-22.9
Florida-25.50
Los Angeles-22.68
Minnesota-22.56
Montreal-23.37
Nashville-22.74
New Jersey-25.44
NY Islanders-25.63
NY Rangers-25.82
Ottawa-25.85
Philadelphia-22.51
Pittsburgh-25.50
San Jose-23.47
St. Louis-26.43
Tampa Bay-24.71
Toronto-23.45
Vancouver-25.84
Washington-25.26
Winnipeg-24.22
surprisingly.. i have the 3rd youngest team in the league
I think he is including prospects. So if u have lots of players in your minors...like the full 90 available, then you'll likely come up looking young.
ohhhh... i only have 7X... can still pick up a lot of players

Re: Player Distribution

PostedCOLON Thu Feb 02, 2017 10:36 pm
by lightupdadarkness
apparently my teams awesome.......thx Dave!