Who found the talent on Opening NHL Rosters 2019-20?

By Chili · Oct 3, 2019 · Updated Oct 3, 2019
  1. Chili Registered User

    Joined:
    Jun 10, 2004
    Messages:
    6,504
    Likes Received:
    1,504
    Trophy Points:
    194
    SB Cash:
    $ 100,000
    Location:
    Sugar Mountain
    Opening 2019-2020 NHL rosters by Original Drafting/Signing team Comparison

    Team#(G+D+F)GoalsPointsDman GDman PtsFwd GoalsFwd Pts
    Anaheim29(2+13+14)20060850250150357
    Arizona19(0+7+12)18456133147151414
    Boston27(2+7+18)34994241165308777
    Buffalo27(2+11+14)21258641186171399
    Calgary22(3+8+11)23961838155201463
    Carolina21(0+7+14)22861335165193448
    Chicago33(3+10+20)34297626163316813
    Colorado15(1+6+8)23163923136208503
    Columbus29(2+13+14)26162839180222448
    Dallas28(2+9+17)20157954209147366
    Detroit24(2+5+17)2556272392232533
    Edmonton25(1+11+13)24267161223181446
    Florida23(2+7+14)24064231114209524
    Los Angeles35(3+11+21)21958629143190440
    Minnesota21(2+8+11)15045344175106276
    Montreal18(2+9+7)13538335170100208
    Nashville24(2+10+12)24268165303177378
    New Jersey20(2+6+12)18047724111156366
    NYIslanders25(2+9+14)30475050185254562
    NYRangers22(3+6+13)1694362179148351
    Ottawa22(2+5+15)27770329143248558
    Philadelphia21(2+5+14)22059330118190475
    Pittsburgh26(3+7+16)25770035166222532
    St. Louis26(4+7+15)23058247164183415
    San Jose32(3+9+20)24767414104233567
    Tampa Bay25(1+7+17)35189224114327775
    Toronto29(2+9+18)20861734138174477
    Vancouver14(2+5+7)1483641992129271
    Vegas6(0+3+3)010100
    Washington28(5+9+14)28674735182251562
    Winnipeg24(2+8+14)25962126143233475


    To explain the numbers, using Anaheim, there were 29 players originally drafted or signed by the Ducks (2 goaltenders, 13 dmen and 14 forwards). Those players combined last season for 200 NHL goals and 608 points. Th breakdown of those goals and points are 50/250 for dmen and 150/357 for forwards.

    Note: both drafted and originally signed undrafted players included, goaltender assists also included in team point totals
     
    Last edited: Jan 25, 2020
  2. Chili Registered User

    Joined:
    Jun 10, 2004
    Messages:
    6,504
    Likes Received:
    1,504
    Trophy Points:
    194
    SB Cash:
    $ 100,000
    Location:
    Sugar Mountain
    Added to chart above January 25, 2020 (this post can de deleted)

    Opening 2019-20 NHL rosters by Original Drafting/Signing team Comparison

    Team/Goals & Points by Dmen/Goals & Points by Forwards in 2018-19

    Ana 50/250 150/357
    Arz 33/147 151/414
    Bos 41/165 308/777
    Buf 41/186 171/399
    Cal 38/155 201/463
    Car 35/165 193/448
    Chi 26/163 316/813
    Col 23/136 208/503
    Clb 39/180 222/448
    Dal 54/209 147/366
    Det 23/92 232/533
    Edm 61/223 181/446
    Fla 31/114 209/524
    LAK 29/143 190/440
    Min 44/175 106/276
    Mtl 35/170 100/208
    Nas 65/303 177/378
    NJD 24/111 156/366
    NYI 50/185 254/562
    NYR 21/79 148/351
    Ott 29/143 248/558
    Phl 30/118 190/475
    Pit 35/166 222/532
    STL 47/164 183/415
    SJS 14/104 233/567
    TBL 24/114 327/775
    Tor 34/138 174/477
    Van 19/92 129/271
    Veg 0/1 0/0
    Was 35/182 251/562
    Win 26/143 233/475
     
    Last edited: Jan 25, 2020
    yianik, NHL WAR and Bear of Bad News like this.
  3. Busted Biscuits Registered User

    Joined:
    Feb 5, 2019
    Messages:
    3
    Likes Received:
    1
    Trophy Points:
    3
    SB Cash:
    $ 100,000
    Gender:
    Male
    Sorted to make it a bit easier to see how the teams stacked up. Thanks for sharing!

    Sorted by goals

    Veg 6 (0+3+3) 0/1
    Mtl 18 (2+9+7) 135/383
    Van 14 (2+5+7) 148/364
    Min 21 (2+8+11) 150/453
    NYR 22 (3+6+13) 169/436
    NJD 20 (2+6+12) 180/477
    Arz 19 (0+7+12) 184/561
    Ana 29 (2+13+14) 200/608
    Dal 28 (2+9+17) 201/579
    Tor 29 (2+9+18) 208/617
    Buf 27 (2+11+14) 212/586
    LAK 35 (3+11+21) 219/586
    Phl 21 (2+5+14) 220/593
    Car 21 (0+7+14) 228/613
    STL 26 (4+7+15) 230/582
    Col 15 (1+6+8) 231/639
    Cal 22 (3+8+11) 239/618
    Fla 23 (2+7+14) 240/642
    Edm 25 (1+11+13) 242/671
    Nas 24 (2+10+12) 242/681
    SJS 32 (3+9+20) 247/674
    Det 24 (2+5+17) 255/627
    Pit 26 (3+7+16) 257/700
    Win 24 (2+8+14) 259/621}
    Clb 29 (2+13+14) 261/628
    Ott 22 (2+5+15) 277/703
    Was 28 (5+9+14) 286/747
    NYI 25 (2+9+14) 304/750
    Chi 33 (3+10+20) 342/976
    Bos 27 (2+7+18) 349/942
    TBL 25 (1+7+17) 351/892

    Sorted by points

    Veg 6 (0+3+3) 0/1
    Van 14 (2+5+7) 148/364
    Mtl 18 (2+9+7) 135/383
    NYR 22 (3+6+13) 169/436
    Min 21 (2+8+11) 150/453
    NJD 20 (2+6+12) 180/477
    Arz 19 (0+7+12) 184/561
    Dal 28 (2+9+17) 201/579
    STL 26 (4+7+15) 230/582
    Buf 27 (2+11+14) 212/586
    LAK 35 (3+11+21) 219/586
    Phl 21 (2+5+14) 220/593
    Ana 29 (2+13+14) 200/608
    Car 21 (0+7+14) 228/613
    Tor 29 (2+9+18) 208/617
    Cal 22 (3+8+11) 239/618
    }Win 24 (2+8+14) 259/621
    Det 24 (2+5+17) 255/627
    Clb 29 (2+13+14) 261/628
    Col 15 (1+6+8) 231/639
    Fla 23 (2+7+14) 240/642
    Edm 25 (1+11+13) 242/671
    SJS 32 (3+9+20) 247/674
    Nas 24 (2+10+12) 242/681
    Pit 26 (3+7+16) 257/700
    Ott 22 (2+5+15) 277/703
    Was 28 (5+9+14) 286/747
    NYI 25 (2+9+14) 304/750
    TBL 25 (1+7+17) 351/892
    Bos 27 (2+7+18) 349/942
    Chi 33 (3+10+20) 342/976

     
    Chili likes this.
  4. Chili Registered User

    Joined:
    Jun 10, 2004
    Messages:
    6,504
    Likes Received:
    1,504
    Trophy Points:
    194
    SB Cash:
    $ 100,000
    Location:
    Sugar Mountain
    I'll add last season's numbers as well for a comparison...

    Opening 2018-2019 NHL rosters by Original Drafting/Signing team Comparison

    Team#(G+D+F)GoalsPointsDman GDman PtsFwd GoalsFwd Pts
    Anaheim24(2+10+12)26876660284208482
    Arizona20(2+6+12)18957532141157434
    Boston27(1+8+18)34893348196300737
    Buffalo28(2+10+16)22258232153190429
    Calgary18(2+5+11)19549425104170390
    Carolina20(0+7+13)22255137149185402
    Chicago31(4+8+19)28279138173244618
    Colorado14(1+4+9)20559830142175456
    Columbus27(2+11+14)24770540157207548
    Dallas24(1+10+13)19955449212150342
    Detroit24(2+4+18)2315691364218505
    Edmonton25(1+7+17)31379636138277658
    Florida20(1+8+11)22156637109184457
    Los Angeles26(3+7+16)27870937179241530
    Minnesota21(2+8+11)19357250227143345
    Montreal21(3+9+9)15144239183112259
    Nashville26(2+9+15)25667966269190410
    New Jersey19(1+7+11)1673982486143312
    NYIslanders24(1+9+14)28276840171242597
    NYRangers26(4+5+17)1805261887162439
    Ottawa26(2+8+16)20554331136174407
    Philadelphia22(1+5+16)27566442144233520
    Pittsburgh27(4+9+14)23365851226182432
    St. Louis27(2+8+17)22962049188180432
    San Jose29(4+7+18)27065827129243529
    Tampa Bay24(1+8+15)27975832130247628
    Toronto25(2+9+14)18753826136161402
    Vancouver17(1+7+9)1292952396106199
    Vegas0(0+0+0)000000
    Washington23(5+7+11)21760641182176424
    Winnipeg20(2+6+12)2215231482207441



    Note: stats based on 2017-18 regular season, undrafted players included
     
    Last edited: Jan 26, 2020
  5. Mrb1p PRICERSTOPDAPUCK

    Joined:
    Dec 10, 2011
    Messages:
    64,290
    Likes Received:
    20,782
    Trophy Points:
    166
    SB Cash:
    $ 100,000
    Location:
    Citizen of the world
    It would be interesting to see who has the best production per player. A team with McDavid and Draisaitl is obviously going to have insane point production but Im not sure its really representative as Mcdavid was a no-brainer and Draisaitl too.

    This doesn't give much weight to defenseman/goaltenders either. Games played would've been a great indicator
    maybe a save percentage average too ?

    Anyhow, great work for the rest.
     
  6. Chili Registered User

    Joined:
    Jun 10, 2004
    Messages:
    6,504
    Likes Received:
    1,504
    Trophy Points:
    194
    SB Cash:
    $ 100,000
    Location:
    Sugar Mountain
    @Mrb1p there are probably 1,001 ways to expand on or view the numbers, they would all have their plusses and minuses.

    This is a just a simple way of tracing the rosters back to the original signing team, with point totals added in. A comprehensive look would have a more complete breakdown. Could be done if someone had the time and inclination to set up the database and spreadsheets.

    I do the work by hand, without spreadsheets or databases, so I've probably taken this as far as I will. I start in the summer working with projected rosters and finalize the numbers when the opening rosters are set. Would be willing to give advice to anyone wanting to take it further.
     
    Mrb1p likes this.
  7. Mrb1p PRICERSTOPDAPUCK

    Joined:
    Dec 10, 2011
    Messages:
    64,290
    Likes Received:
    20,782
    Trophy Points:
    166
    SB Cash:
    $ 100,000
    Location:
    Citizen of the world
    I just laid it out there if someone ever wanted to work on it a bit. Its still good work.
     
  8. jumptheshark Rebooting myself Sponsor

    Joined:
    Oct 12, 2003
    Messages:
    88,942
    Likes Received:
    5,451
    Trophy Points:
    280
    SB Cash:
    $ 55,000
    Gender:
    Male
    Occupation:
    currently creating a new identity
    Location:
    Have Backpack Will Travel
    Even though he has done nothing.

    Does Sam gagner for the oilers count as home grown he was drafted by the Oilers
     
  9. Chili Registered User

    Joined:
    Jun 10, 2004
    Messages:
    6,504
    Likes Received:
    1,504
    Trophy Points:
    194
    SB Cash:
    $ 100,000
    Location:
    Sugar Mountain
    I would have counted him as an Oiler, yes. He`s not included above because he wasn`t on the opening roster, was sent to the AHL to start the season.
     
    Last edited: May 30, 2020
  10. Chili Registered User

    Joined:
    Jun 10, 2004
    Messages:
    6,504
    Likes Received:
    1,504
    Trophy Points:
    194
    SB Cash:
    $ 100,000
    Location:
    Sugar Mountain
    Was curious who finds players later in the draft and beyond (i.e. after the second round)

    This table is based on current NHLers, the team represents the original drafting team or signing team of undrafted free agents, detailed lists follow further down:

    TeamUndraftedRounds 3 to 7+Total
    Anaheim077
    Arizona145
    Boston5813
    Buffalo4913
    Calgary41014
    Carolina156
    Chicago8715
    Colorado235
    Columbus51318
    Dallas5712
    Detroit3811
    Edmonton7714
    Florida099
    Los Angeles71219
    Minnesota167
    Montreal145
    Nashville099
    New Jersey279
    NY Islanders2810
    NY Rangers4812
    Ottawa01111
    Philadelphia5611
    Pittsburgh51217
    St. Louis088
    San Jose101020
    Tampa Bay2810
    Toronto51419
    Vancouver336
    Vegas101
    Washington268
    Winnipeg178




    Who found the undrafted free agents around the league on current NHL rosters?

    Original signing team:

    Anaheim-(0)
    Arizona-(1) Ilya Lyubushkin
    Boston-(5) Torey Krug, Karson Kuhlman, Colby Cave, Noel Acciari, Frank Vatrano
    Buffalo-(4) Lawrence Pilut, Evan Rodriques, Chad Ruhwedel, Tim Schaller
    Calgary-(4) David Rittich, Marc Giordano, Alexander Yelesin, Garnet Hathaway
    Carolina-(1) Derek Ryan
    Chicago-(8) David Kampf, Matthew Highmore, Antti Raanta, Trevor Van Riemsdyk, Artemi Panarin, Dominik Kahun, Jan Rutta, Michal Kempny
    Colorado-(2) Pavel Francouz, Andrew Agozzino
    Columbus-(5) Matiss Kivlinieks, Dean Kukan, Eric Robinson, Nic Holden, Jonathan Marchessault
    Dallas-(5) Justin Dowling, Joel Kiviranta, Brendan Dillon, Jordie Benn, Antoine Rouessel
    Detroit-(3) Danny Dekeyser, Luke Glendening, Tomas Nosek
    Edmonton-(7) Gaetan Haas, Joakim Nygard, Patrick Russell, Jordan Oesterle, Brad Hunt, Taylor Fedun, Drake Caggiula
    Florida-(0)
    Los Angeles-(7) Kurtis MacDermid, Sean Walker, Alex Iafallo, Blake Lizotte, Scott Sabourin, Martin Jones, Oscar Fantenberg
    Minnesota-(1) Christian Folin
    Montreal-(1) Charlie Lindgren
    Nashville-(0)
    New Jersey-(2) Andy Greene, Kevin Rooney
    NYIslanders-(2) Ross Johnston, Michael Haley
    NYRangers-(4) Alex Georgiev, Cam Talbot, Mats Zuccarello, Neal Pionk
    Ottawa-(0)
    Philadelphia-(5) Philippe Myers, Michael Raffl, P.E. Bellemare, Sergei Bobrosky, Cole Bardeau
    Pittsburgh-(5) Juuso Riikola, Zach Aston-Reese, Carter Rowney, Conor Sheary, Mark Letestu
    St.Louis-(1) Carter Hutton (this was incorrect, should have read San Jose), table corrected 24 Apr 2020
    San Jose-(9) Aaron Dell, Radim Simek, Barclay Goodrow, Melker Karlsson, Joel Kellman, Antti Suomela, Alexander True, Ryan Carpenter, Matt Irwin
    Tampa Bay-(2) Yanni Gourde, Tyler Johnson
    Toronto-(5) Ilya Mikheyev, Trevor Moore, Par Lindholm, Nikita Zaitsev, Tyler Bozak
    Vancouver-(3) Troy Stecher, Chris Tanev, Zack MacEwen
    Vegas-(1) Zach Whitecloud
    Washington-(2) Jay Beagle, Nate Schmidt
    Winnipeg-(1) Brandon Tanev


    96 current undrafted NHLers by my count or the equivalent of 4 teams (just over 12% of the league). Some pretty good players on the list.

    This is a comparison of current NHLers drafted after the second round, listed by the team who drafted them:

    Anaheim-(7) Josh Manson 6th, Sami Vatanen 4th, Chris Wagner 5th, Tim Heed 5th, [Frederik Andersen 3rd], Ondrej Kase 7th, Troy Terry 5th
    Arizona-(4) Keith Yandle 4th, Michael Stone 3rd, Louis Domingue 5th, Adin Hill 3rd
    Boston-(8) Nate Thompson 6th, Vladimir Sobotka 4th, Brad Marchand 3rd, Matt Grzelcyk 3rd, Matt Benning 6th, Anton Blidh 6th, Danton Heinen 4th, Anders Bjork 5th
    Buffalo-(9) Ryan Miller 5th, Andrej Sekera 3rd, Nathan Gerbe 5th, Alex Biega 5th, Paul Byron 6th, Brayden McNabb 3rd, Marcus Foligno 4th, Linus Ulmark 6th, Victor Olofsson 7th
    Calgary-(10) Craig Anderson 3rd, Curtis McElhinney 6th, T.J. Brodie 4th, Michael Ferland 5th, Adam Fox 3rd, Laurent Brossoit 6th, Johnny Gaudreau 4th, Brett Kulak 4th, John Gilmour 7th, Andrew Mangiapane 6th
    Carolina-(5) Frederik Andersen 7th, Jaccob Slavin 4th, Brett Pesce 3rd, Lucas Wallmark 4th, Warren Foegele 3rd
    Chicago-(7) [Craig Anderson 3rd], Niklas Hjarmalsson 4th, Joakim Nordstrom 3rd, Andrew Shaw 5th, Vinny Hinostroza 6th, John Hayden 3rd, Tyler Motte 4th
    Colorado-(3) Brad Richardson 5th, Tyson Barrie 3rd, Will Butcher 5th
    Columbus-(13) Kris Russell 3rd, Matt Calvert 5th, Cam Atkinson 6th, David Savard 4th, Dalton Prout 6th, Mike Reilly 4th, Joonas Korpisalo 3rd, Josh Anderson 4th, Oliver Bjorkstrand 3rd, Elvis Merzlikins 3rd, Vladislav Gavrikov 6th, Markus Nutivaara 7th, Emil Bemstrom 4th
    Dallas-(7) Mike Smith 5th, Colton Sceviour 4th, Jamie Benn 5th, Reilly Smith 3rd, John Klingberg 5th, Esa Lindell 3rd, Nich Paul 4th
    Detroit-(8) Valteri Filppula 3rd, Darren Helm 5th, Gustav Nyquist 4th, Nick Jensen 5th, Petr Mzazek 5th, Andreas Atnanasiou 4th, Matthias Janmark-Nylen 3rd, Christopher Ehn 4th
    Edmonton-(7) Tobias Rieder 4th, Erik Gustafsson 4th, Jujhar Khaira 3rd, William Lagesson 4th, Caleb Jones 4th, Ethan Bear 5th, John Marino 6th
    Florida-(9) Evgeny Dadonov 3rd, Joonas Donskoi 4th, Zach Hymen 5th, Vincent Trochek 3rd, Josh Brown 6th, Mackenzie Weegar 7th, Dennis Malgin 4th, Samuel Montembeault 3rd, Riley Stillman 4th
    Los Angeles-(12) Jonathan Quick 3rd, Alec Martinez 4th, Nicolas Deslauriers 3rd, Jordan Weal 3rd, Nick Shore 3rd, Colin Miller 5th, Dominik Kubalik 7th, Nikolay Prokhorkin 4th, Mike Amadio 3rd, Jacob Middleton 7th, Austin Wagner 4th, Matt Roy 7th
    Minnesota-(6) Cal Clutterbuck 3rd, Darcy Kuemper 6th, Erik Haula 7th, Tyler Graovac 7th, Nick Seeler 5th, Carson Soucy 5th
    Montreal-(4) Jaroslav Halak 9th, Yannick Weber 3rd, Brendan Gallagher 5th, Victor Mete 4th
    Nashville-(9) Patrik Hornqvist 7th, Craig Smith 4th, Mattias Ekholm 4th, Gabriel Bourque 5th, Anthony Bitetto 6th, Jimmy Vesey 3rd, Brendan Leipsic 3rd, Juuse Saros 4th, Viktor Arvidsson 4th
    New Jersey-(7) Derek Engellund 6th, Adam Henrique 3rd, Blake Coleman 3rd, Alex Kerfoot 5th, Miles Wood 4th, Joey Anderson 3rd, Jesper Bratt 6th
    NY Islanders-(8) Frans Nielsen 3rd, Matt Martin 5th, Jared Spurgeon 6th, Anders Nilsson 3rd, Casey Cizikas 4th, Anders Lee 6th, Adam Pelech 3rd, Devon Toews 4th
    NY Rangers-(8) Henrik Lundqvist 7th, Carl Hagelin 6th, Dale Weise 4th, Jesper Fast 6th, Pavel Buchnevich 3rd, Anthony Duclair 3rd, Ryan Graves 4th, Igor Shesterkin 4th
    Ottawa-(11) Brian Elliott 9th, Zack Smith 3rd, Derek Grant 4th, Mark Borowiecki 5th, Mike Hoffman 5th, Mark Stone 6th, Jean Gabriel Pageau 4th, Ryan Dzingel 7th, Chris Driedger 3rd, Marcus Hogberg 3rd, Drake Batherson 4th
    Philadelphia-(6) Patrick Maroon 6th, Zac Rinaldo 6th, Nick Cousins 3rd, Shane Gostisbehere 3rd, Oskar Lindblom 5th, Connor Bunnaman 4th
    Pittsburgh-(10) Kris Letang 3rd, Robert Bortuzzo 3rd, Jake Muzzin 5th, Bryan Rust 3rd, Tom Kuhnhackl 4th, Josh Archibald 6th, Oskar Sundqvist 3rd, Matt Murray 3rd, Jake Guentzel 3rd, Sam Lafferty 4th, Dominik Simon 5th Anthony Angello 5th
    St. Louis-(8) Roman Polak 6th, Ryan Reaves 5th, Ben Bishop 3rd, Jordan Binnington 3rd, Mackenzie MacEachern 3rd, Colton Parayko 3rd, Sammy Blais 6th, Niko Mikkola 5th
    Sharks-(10) Joe Pavelski 7th, Thomas Greiss 3rd, Alex Stalock 4th, Nick Bonino 6th, Justin Braun 7th, Jason Demers 7th, Sean Kuraly 5th, Dylan DeMelo 6th, Joakim Ryan 7th, Kevin Labanc 6th,
    Tampa Bay-(8) Alex Killorn 3rd, Mark Barberio 6th, Radko Gudas 3rd, Ondrej Palat 7th, Cedric Paquette 4th, Nikita Gusev 7th, Brayden Point 3rd, Anthony Cirelli 3rd
    Toronto-(14) Anton Stralman 7th, James Reimer 4th, Korbinian Holzer 4th, Leo Komarov 6th, Carl Gunnarson 7th, Greg Pateryn 5th, Greg McKegg 3rd, Josh Leivo 3rd, Dominic Tontinato 5th, Andreas Johnsson 7th, Connor Brown 6th, Carter Verhaeghe 3rd, Pierre Engvall 7th, Dmtryo Timashov 5th
    Vancouver-(3) Alex Edler 3rd, Ben Hutton 5th, Adam Gaudette 5th
    Vegas-(0)
    Washington-(6) Mathieu Perreault 6th, Braden Holtby 4th, Cody Eakin 3rd, Philipp Grubauer 4th, Chandler Stephenson 3rd, Conner Carrick 5th
    Winnipeg-(7) Ben Chiarot 4th, Adam Lowry 3rd, Connor Hellebuyck 5th, Tucker Poolman 5th, Andrew Copp 4th, Sami Niku 7th, Mason Appleton 6th


    234 players current NHLers drafted after the second round or an average of about 8 per team
     
    Last edited: Apr 24, 2020
    Peat and uncleben like this.
  11. yianik Registered User

    Joined:
    Jun 30, 2009
    Messages:
    7,806
    Likes Received:
    2,669
    Trophy Points:
    156
    SB Cash:
    $ 100,000
    This is brilliant, great job thank you. Explains a lot.
     
    Chili likes this.
  12. voxel Go Condors!

    Joined:
    Feb 14, 2007
    Messages:
    16,858
    Likes Received:
    1,538
    Trophy Points:
    169
    SB Cash:
    $ 100,000
    Gender:
    Male
    Location:
    Florida
    Is there a reason Drake Caggiula isn't listed? Oilers tried to sign Stecher but only scored Caggiula that offseason.
     
    Chili likes this.
  13. mattihp Registered User

    Joined:
    Aug 2, 2004
    Messages:
    16,984
    Likes Received:
    506
    Trophy Points:
    230
    SB Cash:
    $ 100,000
    Location:
    Uppsala, Sweden
    Tried pasting it into excel to get some nice sorting options, but it will just paste it all into a single cell. Did you by any chance make the first list in excel and still have it? :)
     
  14. Doctor No Registered User

    Joined:
    Oct 26, 2005
    Messages:
    8,388
    Likes Received:
    2,199
    Trophy Points:
    166
    SB Cash:
    $ 100,000
    Home Page:
    Which version of Excel are you running?

    I just tried this (highlight the full table, CTRL-C copy, then highlight a cell in Excel and straight up CTRL-V paste with no other options) and it worked great.
     
  15. Chili Registered User

    Joined:
    Jun 10, 2004
    Messages:
    6,504
    Likes Received:
    1,504
    Trophy Points:
    194
    SB Cash:
    $ 100,000
    Location:
    Sugar Mountain
    Missed him, corrections made above. Thanks!

    Edit: I did have him correctly in the initial table (post 1)
     
    voxel likes this.
  16. Chili Registered User

    Joined:
    Jun 10, 2004
    Messages:
    6,504
    Likes Received:
    1,504
    Trophy Points:
    194
    SB Cash:
    $ 100,000
    Location:
    Sugar Mountain
    I don't have Excel, I did initially use a spreadsheet and tried to copy/paste here without success.

    If anyone is able to do that, by all means please add here if you can.
     
    Last edited: Apr 24, 2020
  17. Chili Registered User

    Joined:
    Jun 10, 2004
    Messages:
    6,504
    Likes Received:
    1,504
    Trophy Points:
    194
    SB Cash:
    $ 100,000
    Location:
    Sugar Mountain
    Same idea as the first post table, this table represents everyone who played in a game this season in the NHL, traced back to their original drafting/signing team...

    2019-2020 NHL stats by Original Drafting/Signing team Comparison (stats to end Mar 2020)

    Team#(G+D+F)GoalsPointsDman GDman PtsFwd GoalsFwd Pts
    Anaheim30(2+13+15)17155148227123324
    Arizona27(2+10+15)16747537139130336
    Boston37(2+10+25)30280139185263616
    Buffalo35(4+12+19)24161142172199438
    Calgary24(3+8+13)15243624128128307
    Carolina33(2+8+23)23456828125206443
    Chicago41(3+14+24)26979225125244666
    Colorado27(3+8+16)17052832160138368
    Columbus45(5+13+27)21958540137179447
    Dallas33(2+9+22)22154231170190370
    Detroit33(2+10+21)1965061465182441
    Edmonton32(1+14+17)24774656239191507
    Florida25(2+8+15)18851930120158398
    Los Angeles45(3+15+27)27771130135247571
    Minnesota26(3+10+13)14040335148105252
    Montreal27(4+11+12)1162942710689186
    Nashville29(2+11+16)18956970311118255
    New Jersey28(3+7+18)1744071464160342
    NYIslanders33(2+10+21)24362944157199472
    NYRangers27(4+6+17)20452227121177399
    Ottawa33(4+9+20)26064221113239528
    Philadelphia36(4+9+23)23255736114196443
    Pittsburgh34(3+8+23)21959033137186452
    St. Louis32(3+10+19)23059850171180424
    San Jose43(4+11+28)2005591593185464
    Tampa Bay29(1+6+22)29076129140261617
    Toronto40(5+11+24)2426041898224504
    Vancouver19(3+7+9)14642624139122286
    Vegas6(0+4+2)19701171853
    Washington34(4+11+19)25969036180223509
    Winnipeg29(2+8+19)23157228116203454

    I realize this is premature because no official announcement on how the rest of the regular season will be played (although there are rumours they would like to complete the season in some form). Have the numbers prepared so thought I would post them.
     
    Last edited: Apr 24, 2020
  18. CanadianSharks Registered User

    Joined:
    Dec 18, 2012
    Messages:
    31,360
    Likes Received:
    2,904
    Trophy Points:
    156
    SB Cash:
    $ 100,000
    Surprised to see SJ has the most forwards drafted. Kind of funny that our forward group kind of sucks.
     
  19. Chili Registered User

    Joined:
    Jun 10, 2004
    Messages:
    6,504
    Likes Received:
    1,504
    Trophy Points:
    194
    SB Cash:
    $ 100,000
    Location:
    Sugar Mountain
    Alot of those are undrafted free agents. I could have added a column for that, didn`t believe there was room.

    Undrafted free agents included in the Post 17 totals who played in 2019-20 by original signing team (i.e. Artemi Panarin was originally signed by the Hawks, Sergei Bobrosky by the Flyers, etc.):

    Ana 1
    Arz 3
    Bos 6
    Buf 4
    Cal 4
    Car 3
    Chi 9
    Col 4
    Clb 5
    Dal 6
    Det 6
    Edm 8
    Fla 1
    La 8
    Min 4
    Mtl 4
    Nas 1
    NJ 3
    NYI 2
    NYR 4
    Ott 2
    Phl 7
    Pit 9
    Stl 0
    SJ 16
    TB 3
    Tor 7
    Van 4
    Veg 2
    Was 2
    Win 3

    Undrafted players in 2019-20 who were originally signed by the Sharks:

    Ryan Carpenter
    Michael Sgarbossa
    Melker Karlsson
    Lukas Radil
    Lean Bergmann
    Joel Kellman
    Danil Yurtakin
    Barclay Goodrow
    Antti Suomela
    Alexander True
    Radim Simek
    Nikolai Knyzkov
    Matt Tennyson
    Matt Irwin
    Carter Hutton
    Aaron Dell
     
    Last edited: May 28, 2020
  20. CanadianSharks Registered User

    Joined:
    Dec 18, 2012
    Messages:
    31,360
    Likes Received:
    2,904
    Trophy Points:
    156
    SB Cash:
    $ 100,000
    Ah, that makes sense. The Sharks do sign a ton of undrafted players.
     
  21. morehockeystats Unusual hockey stats

    Joined:
    Dec 13, 2016
    Messages:
    439
    Likes Received:
    130
    Trophy Points:
    56
    SB Cash:
    $ 100,000
    Occupation:
    sysadmin
    Location:
    San Jose
    Home Page:

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
monitoring_string = "358c248ada348a047a4b9bb27a146148"