Re: Hockey Thread! (NHL etc.)
Posted: 13 Oct 2016 15:12
You can count my Crosbo picks as the official ones. Just throwing the extra picks in there for additional glory.Slurmee wrote:Can only pick one.
This Old Neon Forum
A retro gaming & game culture community on a retro platform.
https://thisoldneon.com/forum/
Hockey Thread! (NHL etc.)
Page 100 of 132
Re: Hockey Thread! (NHL etc.)
Posted: 15 Oct 2016 15:52
Kreeg?
Re: Hockey Thread! (NHL etc.)
Posted: 15 Oct 2016 18:04
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
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
Re: Hockey Thread! (NHL etc.)
Posted: 16 Oct 2016 10:32
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.
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.
Re: Hockey Thread! (NHL etc.)
Posted: 16 Oct 2016 11:15
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?
Thoughts?
Re: Hockey Thread! (NHL etc.)
Posted: 16 Oct 2016 16:48
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.
I'll take a look at the sheet when I get back in from vacation.Re: Hockey Thread! (NHL etc.)
Posted: 18 Oct 2016 02:33
Looks good to me Slurm!
Re: Hockey Thread! (NHL etc.)
Posted: 19 Oct 2016 14:57
OK Slurm, try this:Slurmee wrote: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.
Code: Select all
=arrayFormula(sum(large(B3:F3,row(indirect("Z1:Z" & 3)))))Re: Hockey Thread! (NHL etc.)
Posted: 21 Oct 2016 14:47
Works a charm and I updated the pool.Kong Wen wrote:OK Slurm, try this:Slurmee wrote: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.
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.Code: Select all
=arrayFormula(sum(large(B3:F3,row(indirect("Z1:Z" & 3)))))
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.
Re: Hockey Thread! (NHL etc.)
Posted: 21 Oct 2016 15:05
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.