Hockey Thread! (NHL etc.)

[VictorViper]

Sounds great, KW! Thanks for putting in all the effort.

[SkyPikachu]

Buffalo, Calgary and Florida didn't get picked at all...

I nearly picked up Moulson.

[Kong Wen]

Buffalo, Calgary and Florida didn't get picked at all...

I nearly picked up Moulson.

Han picked Stajan! I think he plays for Calgary.

Kit, the points that show up in the chart right now are just temporary for testing purposes. I want it to be able to automatically update our "ranks" based on how many points we have.

[SkyPikachu]

Buffalo, Calgary and Florida didn't get picked at all...

I nearly picked up Moulson.

Han picked Stajan! I think he plays for Calgary.

Kit, the points that show up in the chart right now are just temporary for testing purposes. I want it to be able to automatically update our "ranks" based on how many points we have.

Oh right yeah he does so 2 teams.

[SkyPikachu]

I changed my mind again and want my team name to be "Drouin it to win it"

[Kong Wen]

Alright, I think I finished the hockey pool sheet. It's pretty damn slick! I added a way for the sheet to dynamically update our ranks (seen under our total points) without anyone having to manually sort them. This'll make it easier to tell at a glance what position you're in without having to compare everyone's point totals, which could be annoying when they start getting higher, especially if they're close. It'll also automatically take ties into account.

Now I just need to learn how to protect the main sheets from being edited, and then give you guys access to the data sheet so you can update the scores (if that's still something you're interested in doing?—if not, I'm happy to stay on top of keeping the scores up to date).

EDIT: Now I'm adding official team colours to the little team cell/tags!!!

[kitroplious]

"The Underground Kings" is what my slogan should be...!

[Kong Wen]

I just updated the playoff pool sheet with last year's stats for testing and interest purposes. Slurm and I are only 8 points apart with some strong low picks. Of note, Kreegs and Kit respectively had 3 and 4 players who missed more than 20 games, so their overall scores would have been better if we take into account their substitutions.

EDIT: Also of note, Han picked some pretty damn durable players! No one in his top 10 missed more than five games last season, and four of them played the full 82!

EDIT: Durability aside, Vic picked the most reliable team! His lowest-scoring top-10 pick had 53 points last season. Everyone else's lowest-scoring top-10 pick was lower than that, if only slightly.

Overall, everyone made some pretty solid choices except for Clay, whose Nashville fandom eclipsed his reason.

[VictorViper]

It looks great, Jog! Nice to have a little frame of reference to put at ease my worry that picking two defenders in my main grouping was a bad idea.

Can I get you to name my team Seguin Genesis as Slurm suggested last night? I haven't been able to top that one. Just love it!

[Kreegs]

This whole thing looks awesome! Way to go Kong! I can't wait to see this sheet in action!