HFVan Hockey League 2018-19

Weylspin · Aug 14, 2018

sign M. Salomaki 2 years, 750K AAV

Dabeast · Aug 14, 2018

Weylspin said:
sign M. Salomaki 2 years, 750K AAV

what

Maticus · Aug 14, 2018

Dabeast said:
what

Yikes, bad signing db.

Dabeast · Aug 14, 2018

TylerBigDBertuzzi said:
Yikes, bad signing db.

sad

Weylspin · Aug 15, 2018

signs J. Kotkaniemi to a 3 year ELC at 3.425M AAV

FOurteenS inCisOr · Aug 16, 2018

Vancouver terminates the contract of Thomas J. Wingels, and wishes him the most neutral of luck with Genève-Servette.

https://www.tsn.ca/postma-wingels-bouma-sign-in-europe-1.1157991

Intoewsables · Aug 19, 2018

Arizona terminates the contract of F Kris Versteeg.

Veteran winger Kris Versteeg leaves Flames, signs with KHL

Intoewsables · Aug 19, 2018

SIGNING: The Calgary Flames have signed prospect F Kristian Vesalainen to a 3 year ELC worth $5.4 million ($1.8M per season).

donut · Aug 20, 2018

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.

Intoewsables · Aug 21, 2018

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:

Code:

https://www.nhl.com/player/madison-bowey-8477474

Madison Bowey's ID is 8477474, and so on.

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.

StrictlyCommercial · Aug 22, 2018

Intoewsables said:
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:

Code:

https://www.nhl.com/player/madison-bowey-8477474

Madison Bowey's ID is 8477474, and so on.

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.

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.

[TBODY]

Maticus · Aug 22, 2018

StrictlyCommercial said:
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]

https://www.nhl.com/player/Aleksander-Barkov-8477493[/TD][/TR]
https://www.nhl.com/player/Alexander-Radulov-8471228[/TD][/TR]
https://www.nhl.com/player/Alex-Ovechkin-8471214[/TD][/TR]
https://www.nhl.com/player/Alex-Pietrangelo-8474565[/TD][/TR]
https://www.nhl.com/player/Anders-Lee-8475314[/TD][/TR]
https://www.nhl.com/player/Anze-Kopitar-8471685[/TD][/TR]
https://www.nhl.com/player/Artemi-Panarin-8478550[/TD][/TR]
https://www.nhl.com/player/Auston-Matthews-8479318[/TD][/TR]
[TBODY] [/TBODY]

Are you okay?

StrictlyCommercial · Aug 22, 2018

Hf limits the number of links you can post I guess.

I did not notice the bottom of that when I copy-pasta'ed lol.

Goon42 · Aug 22, 2018

sc pls calm down

Weylspin · Aug 22, 2018

Goon42 said:
sc pls calm down

Goon are you ok

donut · Aug 23, 2018

donut said:
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.

Hoping to get a few more votes in before tallying up the results. Please vote if you haven't already!

donut · Aug 27, 2018

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

Weylspin · Aug 28, 2018

sign B. Kiselevich to a 1 year 925K contract

donut · Aug 29, 2018

donut said:
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

Last call on votes before I close out round 4!

Tryamkin · Aug 29, 2018

are proud to name D Erik Gudbranson captain of the squad for the upcoming 2018-2019 HFVHL season. Joe Thornton and Tyler Bozak will serve as assistant captains.

donut · Aug 29, 2018

Thank you very much to those who have continued to vote.

Congratulations to the Pittsburgh Penguins (@TylerBigDBertuzzi), the Anaheim Ducks (@VanillaCoke), and the Buffalo Sabres (@Scholarships) on being voted into the top 12 of the first HFVHL Power Ranking!

Please click here to vote on the next round: https://goo.gl/forms/Qzefox9WnPRVqMRP2

VanillaCoke · Aug 29, 2018

Rigged!

Canucks LB · Aug 30, 2018

Please terminate Matt Stajan's contract.

Signed in Germany
https://hfboards.mandatory.com/threads/matt-stajan-signs-with-munich-in-del.2534185/

Weylspin · Aug 30, 2018

sign D. Turgeon 1 year 1.25M

Intoewsables · Aug 31, 2018

Lucbourdon said:
Please terminate Matt Stajan's contract.

Signed in Germany
https://hfboards.mandatory.com/threads/matt-stajan-signs-with-munich-in-del.2534185/

How do you only have 8 forwards? Lmao.

HFVan Hockey League 2018-19

The Swede

Registered User

Registered User

Registered User

The Swede

FOS COrp CEO

Registered User

Registered User

Moderator

Registered User

Registered User

Registered User

Registered User

Registered User

The Swede

Moderator

Moderator

The Swede

Moderator

Registered User

Moderator

Registered User

My Favourite, Gone too soon, RIP Luc, We miss you

The Swede

Registered User

Ad

Ad

Ad