Hockey Thread! (NHL etc.)

[Kong Wen]

Can only pick one.

You can count my Crosbo picks as the official ones. Just throwing the extra picks in there for additional glory.

[SkyPikachu]

Kreeg?

[Kreegs]

1. Pick a 5 player team. Alex Ovechkin, Parick Kane, Vladimir Tarasenko, Jamie Benn, Tyler Seguin

2. Who will will win the Art Ross (Who will score the most points?) Benn

3. Who will win the Vezina (Best Goalie voted on) Bishop

4. Who will win the Calder (Rookie of the year voted on) Auston Matthews

5. Who will win the Stanley Cup? Tampa Bay

6. Which playoff team wont make the playoffs this year? (pick one) Minnesota (hate it, but it looks to be true at this point.)

7. Will Detroit continue their playoff streak? No

8. Which teams will win their divisions? (4 teams) Washington, Tampa Bay, St. Louis, San Jose

[SkyPikachu]

Alright I've set up a google doc.

It's nothing fancy.

https://docs.google.com/spreadsheets/d/ ... sp=sharing

If anyone knows a way to code the scores so it takes the highest 3 scoring players scores and adds them together (but not the bottom 2) please tell me how. It's not a huge deal either way.

[SkyPikachu]

So currently for every point scored your team gets 1 point (minus your worst 2 players scores). I want to add points for the other questions. What I was thinking was 10 points for a correct Division Champion, 20 points for Stanley Cup, 5 points for the others. Which means you can get a possible extra 85 points. Does that seem too much not enough what do you 2 think? Also the 3 of us do have very similar teams (Kong and I have 1 different player and Kreeg has 2 different from me and 3 from kong) so I'm guessing our teams at the end of the year could be very very close.

Thoughts?

[Kong Wen]

I think it's fine if our teams are quite close. It'll make us cheer for those one or two different guys. I'll take a look at the sheet when I get back in from vacation.

[Kreegs]

Looks good to me Slurm!

[Kong Wen]

If anyone knows a way to code the scores so it takes the highest 3 scoring players scores and adds them together (but not the bottom 2) please tell me how. It's not a huge deal either way.

OK Slurm, try this:

Code: Select all

=arrayFormula(sum(large(B3:F3,row(indirect("Z1:Z" & 3)))))

B3:F3 are the cells where the scores are located (so tweak this for each row). This formula will take the top 3, and only 3, so even if you have 5-5-5-5-5 in there, it'll total up 3x5.

[SkyPikachu]

If anyone knows a way to code the scores so it takes the highest 3 scoring players scores and adds them together (but not the bottom 2) please tell me how. It's not a huge deal either way.

OK Slurm, try this:

Code: Select all

=arrayFormula(sum(large(B3:F3,row(indirect("Z1:Z" & 3)))))

B3:F3 are the cells where the scores are located (so tweak this for each row). This formula will take the top 3, and only 3, so even if you have 5-5-5-5-5 in there, it'll total up 3x5.

Works a charm and I updated the pool.

In case you don't bookmark the link my signature has the link in it.

It's still very close.

Edit: Also Avs 3-1 against Pittsburgh, Washington, Dallas and Tampa Bay (Tampa Bay being a 4-0 Shutout) I'm guessing that'd got to be one of the hardest schedule in the league to start with and they seem to be doing well.

[Kong Wen]

Since the rest of our rosters are the same, the running between me & Slurm will be entirely decided by Tavares and Seguin, and that's only if they rank within the top 3 scorers on our teams. If they're both 4th or 5th, we tie. If one is in the top 3, that person wins. If they're both in the top 3, whoever scores the most out of Tavares and Seguin wins.