Yikes, bad signing db.what
sadYikes, bad signing db.
https://www.nhl.com/player/madison-bowey-8477474
I'm currently in the process of adding scripts that grab player ages to the roster sheets. If you want to help speed up the process for your team or others, you can send me a list of players along with their player IDs on NHL.com.
Example:
Madison Bowey's ID is 8477474, and so on.Code:https://www.nhl.com/player/madison-bowey-8477474
I figured it would be nice to compare the average age of each team on the Quick Info sheet, but I'm really hoping it won't slow the sheets down too much. Guess we'll see.
Are you okay?Can I use an excel formula to extract the link location of a hyperlink in a cell?
Can only do 100 rows at a time on NHL.com, but seems like one of the quickest ways to do it if you have excel.
https://www.nhl.com/player/Blake-Wheeler-8471218[/TD][/TR]
https://www.nhl.com/player/Brad-Marchand-8473419[/TD][/TR]
https://www.nhl.com/player/Brayden-Point-8478010[/TD][/TR]
https://www.nhl.com/player/Brayden-Schenn-8475170[/TD][/TR]
https://www.nhl.com/player/Brendan-Gallagher-8475848[/TD][/TR]
https://www.nhl.com/player/Brent-Burns-8470613[/TD][/TR]
https://www.nhl.com/player/Brock-Boeser-8478444[/TD][/TR]
https://www.nhl.com/player/Claude-Giroux-8473512[/TD][/TR]
https://www.nhl.com/player/Clayton-Keller-8479343[/TD][/TR]
https://www.nhl.com/player/Connor-McDavid-8478402[/TD][/TR]
https://www.nhl.com/player/Daniel-Sedin-8467875[/TD][/TR]
https://www.nhl.com/player/David-Pastrnak-8477956[/TD][/TR]
https://www.nhl.com/player/David-Perron-8474102[/TD][/TR]
https://www.nhl.com/player/Derek-Stepan-8474613[/TD][/TR]
https://www.nhl.com/player/Drew-Doughty-8474563[/TD][/TR]
https://www.nhl.com/player/Dustin-Brown-8470606[/TD][/TR]
https://www.nhl.com/player/Dylan-Larkin-8477946[/TD][/TR]
https://www.nhl.com/player/Eric-Staal-8470595[/TD][/TR]
https://www.nhl.com/player/Erik-Haula-8475287[/TD][/TR]
[TD]https://www.nhl.com/player/Erik-Karlsson-8474578[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Evander-Kane-8475169[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Evgenii-Dadonov-8474149[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Evgeni-Malkin-8471215[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Evgeny-Kuznetsov-8475744[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Filip-Forsberg-8476887[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Gabriel-Landeskog-8476455[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Henrik-Zetterberg-8468083[/TD][/TR]
[TR][TD]https://www.nhl.com/player/J.T.-Miller-8476468[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Jack-Eichel-8478403[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Jaden-Schwartz-8475768[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Jakub-Voracek-8474161[/TD][/TR]
[TR][TD]https://www.nhl.com/player/James-van Riemsdyk-8474037[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Jamie-Benn-8473994[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Jason-Zucker-8475722[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Joe-Pavelski-8470794[/TD][/TR]
[TR][TD]https://www.nhl.com/player/John-Carlson-8474590[/TD][/TR]
[TR][TD]https://www.nhl.com/player/John-Klingberg-8475906[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Johnny-Gaudreau-8476346[/TD][/TR]
[TR][TD]https://www.nhl.com/player/John-Tavares-8475166[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Jonathan-Huberdeau-8476456[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Jonathan-Marchessault-8476539[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Jordan-Eberle-8474586[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Josh-Bailey-8474573[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Keith-Yandle-8471735[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Kyle-Connor-8478398[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Leon-Draisaitl-8477934[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Logan-Couture-8474053[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Mark-Scheifele-8476460[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Mark-Stone-8475913[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Mathew-Barzal-8478445[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Mats-Zuccarello-8475692[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Matt-Duchene-8475168[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Mikael-Granlund-8475798[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Mike-Hoffman-8474884[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Mikko-Rantanen-8478420[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Mitchell-Marner-8478483[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Nathan-MacKinnon-8477492[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Nazem-Kadri-8475172[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Nicklas-Backstrom-8473563[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Nikita-Kucherov-8476453[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Nikolaj-Ehlers-8477940[/TD][/TR]
[TR][TD]https://www.nhl.com/player/P.K.-Subban-8474056[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Patrice-Bergeron-8470638[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Patrick-Kane-8474141[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Patrik-Laine-8479339[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Paul-Stastny-8471669[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Phil-Kessel-8473548[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Reilly-Smith-8475191[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Rickard-Rakell-8476483[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Ryan-Getzlaf-8470612[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Ryan-Johansen-8475793[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Ryan-O'Reilly-8475158[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Sean-Couturier-8476461[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Sean-Monahan-8477497[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Sebastian-Aho-8478427[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Seth-Jones-8477495[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Shayne-Gostisbehere-8476906[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Sidney-Crosby-8471675[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Steven-Stamkos-8474564[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Taylor-Hall-8475791[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Teuvo-Teravainen-8476882[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Thomas-Vanek-8470598[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Torey-Krug-8476792[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Tyler-Seguin-8475794[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Tyson-Barrie-8475197[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Victor-Hedman-8475167[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Viktor-Arvidsson-8478042[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Vincent-Trocheck-8476389[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Vladimir-Tarasenko-8475765[/TD][/TR]
[TR][TD]https://www.nhl.com/player/William-Karlsson-8476448[/TD][/TR]
[TR][TD]https://www.nhl.com/player/William-Nylander-8477939[/TD][/TR]
[TR][TD]https://www.nhl.com/player/Yanni-Gourde-8476826[/TD][/TR][/TBODY][/TABLE][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD][/TR][/TD]
Apologize for the delay, been busy with work.
In no particular order, congratulations to the Tampa Bay Lightning (@donut), the Carolina Hurricanes (@Goon42), and the New York Islanders (@ahmon) on being voted into the top 6 of the first ever HFVHL Power Rankings.
More importantly, a big thanks to everyone who has been voting. CLICK HERE FOR ROUND 3 OF VOTING.
Round 3 of the Power Ranking has concluded.
Congratulations to the Arizona Coyotes (@Intoewsables), the Los Angeles Kings (@CreativeUsername), and the Washington Capitals (@Elusive Derposaurus) on being voted into the top 10 of the off-season power rankings.
Next round of voting available here: https://goo.gl/forms/HPBQGsaE7kkLjfQL2
How do you only have 8 forwards? Lmao.Please terminate Matt Stajan's contract.
Signed in Germany
https://hfboards.mandatory.com/threads/matt-stajan-signs-with-munich-in-del.2534185/