2024 Edition - Dobber WJC Pool

[PenguinHunter]

Any Vlookup or Spreadsheet masters that would be able to help me out with an issue.
This is something new that did not happen last year.

1) I created the entry form.
2) people fill out the entry form

3) I took the names from the entry form and copied them into the stats/standings spreadsheet
4) When I copy the entries over it is not picking up the names when using the vlookup.

[PenguinHunter]

Before submitting your entry, please make sure the Latvia players are on your entry form at the bottom.

If they are not, please make a new copy of the entry form with the link above, and use it.

Something funky is happening if the entries are submitted using the old version of the entry form without Latvia.

Thanks!

[InForAPenny]

Sent mine along. Fingers crossed it arrives. Was a hard one to fill in this year, goalies being the pain in the butt that they are. Somehow no Finns in the lineup, guess we'll see.

[PenguinHunter]

10 entries so far.

For all entries I have entered I have responded with an email saying that they have been entered.

If you did not receive a response please follow up

[forsbergfan]

In the end I went with 2 American captains. There were too many forwards I wanted to have on my roster, so I figured I could use up 2 US spots on captains and fill out my forwards from other countries.

5 USA
5 SWE
4 CAN
4 FIN
2 SVK
2 CZE

First time since I've been a part of this pool that I haven't taken 5 Canadians. I think there's a really good chance they lose in the quarterfinals, especially if they run into Slovakia. Dallbor Dvorsky is gonna put on a show in this tournament, and they have a goalie who could steal a medal round game by himself.
I think the US run away with their pool and make it to the finals only to get upset by the home team Sweden.
I think Finland wins the bronze. Konsta Helenius was the guy I didn't have room for on my roster that I would have liked to get in had there been one more spot.

[PenguinHunter]

Get those entries in!

the tourney starts really early tomorrow morning!

[PenguinHunter]

19 entries so far.

[StuntMan12]

Getting my entry in. Thanks for the reminder ��

[forsbergfan]

Slovakia is looking VERY strong against the Czechs.

[Daydream Nation]

I didn't realize these games would be played in the morning! This is glorious. And starting tomorrow, World Junior games in the morning and NHL games at night.

[InForAPenny]

Slovakia is looking VERY strong against the Czechs.

They can thank me for taking 5 Czechs...

[VintageVibe]

Not the greatest entry for us so far (Good night, Jiricek)!!

Can't for the life of me figure out how to see the updated points/standings results from Day 1 (is it just me or is google sheets really user unfriendly these days??).

I click the link in the first post in this thread and it just shows zeros across the board... any help is appreciated!

[VintageVibe]

Can't for the life of me figure out how to see the updated points/standings results from Day 1 (is it just me or is google sheets really user unfriendly these days??).

I click the link in the first post in this thread and it just shows zeros across the board... any help is appreciated!

Capture.JPG

[doulos]

I ran through the stats quickly. Not official at all as I just used the stats from each game. Not sure what the official source being used is.

1 InForAPenny 44
2 watchingthegame 43
3 VintageVibe 40
4 Driedger18 40
5 stacjam 38
6 pmorrow 36
7 Rocky71 36
8 newfcollins 35
9 Forsbergfan 35
10 Doulos 35
11 CrimsonYann 34
12 PenguinHunter 34
13 Gotenks 34
14 Dennis 34
15 metaldude26 33
16 Kingchev 33
17 Axeman33 30
18 finnys_fanatsy 29
19 Letterkeny Shamrocks 29
20 stevegamer 26
21 StuntMan12 25

[InForAPenny]

I realise its extremely early, but if those point totals are accurate, then hell is surely about to freeze over!