2024 Edition - Dobber WJC Pool

[doulos]

Very Unofficial Results after today's games (not sure who the official scorekeeper is!)

1 InForAPenny 59
2 watchingthegame 55
3 VintageVibe 52
4 stacjam 50
5 CrimsonYann 49
6 pmorrow 48
7 Doulos 48
8 Driedger18 48
9 PenguinHunter 47
10 metaldude26 46
11 Gotenks 45
12 Forsbergfan 44
13 Kingchev 44
14 Rocky71 44
15 Dennis 43
16 Axeman33 43
17 newfcollins 41
18 finnys_fanatsy 38
19 StuntMan12 37
20 Letterkeny Shamrocks 36
21 stevegamer 36

[Eskimo Brother]

Hey PH, any reason my entry didn't make it in?

[doulos]

After Dec 30 Games

1 watchingthegame 74
2 InForAPenny 70
3 Driedger18 66
4 Doulos 65
5 stacjam 62
6 CrimsonYann 61
7 Forsbergfan 61
8 stevegamer 61
9 newfcollins 60
10 Rocky71 59
11 VintageVibe 59
12 metaldude26 58
13 Dennis 58
14 pmorrow 57
15 PenguinHunter 57
16 Kingchev 57
17 Axeman33 55
18 finnys_fanatsy 54
19 Gotenks 54
20 Letterkeny Shamrocks 51
21 StuntMan12 48

[dodospice]

My entry is under the entries tab but not in the standings tab as well, if I could be added to the next standings update!

[Nights]

My entry is under the entries tab but not in the standings tab as well, if I could be added to the next standings update!

For whoever has edit rights...

The formula in row 30 is always a bugger and has to be updated for the current amount of teams.

The "$D$31:$BL$31" bit just has to be changed to "$D$31:$BR$31", since BR is where the last team entered in is... Then the formula copy-pasted over to all the other teams too.

Otherwise, it's ignoring the last 2 teams on the list (the ones after "BL") for ranking purposes, which is why dodo and markyj don't show up in the standings page (since their rank is "N/A" because the formula for those 2 teams goes past the 23 entries, while the first 21 use the first 21 teams).

Just checked in out of boredom, I'm doing better than last year but cut out my last fantasy hockey team this past summer so I haven't really been active anywhere hockey related. Glad to see this is still running regardless.

[doulos]

1 dodospice 95
2 InForAPenny 94
3 watchingthegame 91
4 Driedger18 91
5 Doulos 88
6 Forsbergfan 85
7 Marky J 85
8 PenguinHunter 84
9 VintageVibe 83
10 metaldude26 82
11 stacjam 81
12 Dennis 81
13 CrimsonYann 80
14 newfcollins 79
15 Gotenks 79
16 Rocky71 79
17 stevegamer 79
18 Axeman33 79
19 Kingchev 78
20 finnys_fanatsy 75
21 pmorrow 74
22 Letterkeny Shamrocks 73
23 StuntMan12 64

I actually didn't even notice two of the teams were not showing up because I was definitely just updating the stats quickly! These are the numbers I have now and hopefully correct. I have been using the Statistics from individual games for this so not sure if there is a better way. Maybe it will need an official run through at the very end from somewhere. The https://www.iihf.com/en/events/2024/...scoringleaders source doesn't have all of the players but maybe there is a different source that is used?

[stevegamer]

For whoever has edit rights...

The formula in row 30 is always a bugger and has to be updated for the current amount of teams.

The "$D$31:$BL$31" bit just has to be changed to "$D$31:$BR$31", since BR is where the last team entered in is... Then the formula copy-pasted over to all the other teams too.



Otherwise, it's ignoring the last 2 teams on the list (the ones after "BL") for ranking purposes, which is why dodo and markyj don't show up in the standings page (since their rank is "N/A" because the formula for those 2 teams goes past the 23 entries, while the first 21 use the first 21 teams).

I recommend making those sorts of ranges huge in formulas where you need to calculate for spreadsheets that are single-purpose but constantly add data. With modern computing power ( late 90's and on) it's been fine as long as you're not linking sheets or stuff.

I'd change that "D$31:$BR$31" to D$31:$HH$31 or something like that to cover yourself so you never need to manually re-edit again. I can't tell you how many times I had to fix this sort of thing professionally over the decades.

It's the same sort of reason I sum columns at the top, the sum range can run down as far as I need.

[Nights]

I recommend making those sorts of ranges huge in formulas where you need to calculate for spreadsheets that are single-purpose but constantly add data. With modern computing power ( late 90's and on) it's been fine as long as you're not linking sheets or stuff.

I'd change that "D$31:$BR$31" to D$31:$HH$31 or something like that to cover yourself so you never need to manually re-edit again. I can't tell you how many times I had to fix this sort of thing professionally over the decades.

It's the same sort of reason I sum columns at the top, the sum range can run down as far as I need.

That would be ideal but with Rank in particular, at least the way the sheet was built, including teams that don't have a legitimate entry introduces "N/A's" into the system, thus breaking the formula and spitting out NA instead of a number.

These days I'd build it completely differently but I guess that's the difference between a teenager taking on a file that already existed and just following how it worked back in 2008 or whenever I took over, and an accountant in his 30's who's now had plenty of experience with Excel lol

REoulos - what I used to do was use this URL (you can change the year in the URL to get whichever year you want) - https://www.iihf.com/en/events/2024/...icialdocuments

Every day I would go through each game's "Game Summary" from the Game Reports section, and they you'd get the PDF that has full rosters for each player and what they got.

The "Player Statistics By Team" is what I'd use once the group stage was done (as an audit of sorts) and then once at the end, ignoring the teams who were not playing in the medal rounds (since relegation game stats don't count).

They used to make those documents easier to find but they kind of gated them a few years back, so I had it bookmarked (from 2022, changed to 2024 for above and it just worked!).

[doulos]

Great thanks! That's almost exactly my plan!

I have no idea who was originally going to update the stats so if the mystery person wants to take it over then by all means...

I just was curious and it didn't take too long so did it myself and now here we are!

[doulos]

After the QF games. Top 2 teams are both going to lose their SVK players, so this could be pretty close at the end.

1 dodospice 115
2 watchingthegame 112
3 Driedger18 109
4 InForAPenny 108
5 Marky J 107
6 Forsbergfan 106
7 CrimsonYann 103
8 Doulos 103
9 PenguinHunter 101
10 stacjam 100
11 Dennis 100
12 metaldude26 99
13 Rocky71 99
14 VintageVibe 98
15 newfcollins 97
16 Kingchev 95
17 Axeman33 95
18 pmorrow 94
19 Gotenks 93
20 finnys_fanatsy 92
21 Letterkeny Shamrocks 92
22 stevegamer 92
23 StuntMan12 80

[watchingthegame]

I lost both my goalies today so I think I'm toast unfortunately. Driedger18 has both his still remaining so he could make a charge here.

[forsbergfan]

I had a little fun with the rosters of the top 6 teams (meaning everyone until my entry). There's actually some nice parity among the top 6. 18 players are only on one roster. 7 on 2 rosters, 6 on 3 and 6 on 4. Ryan Leonard on 5 rosters and Noah Ostlund on the top 6 rosters.
My entry has the most remaining players left, but I think I'm in too big a hold to come back.
watchingthegame is probably right, without his goalies and Slovaks it'll be hard for him to catch dodospice. But both of them only have 12 players left, although dodospice has goalie Havelid who in the medal round games could be a big factor (doubtful we see more blowouts so getting 2 points from a goalie is key). Marky J has only 13 players left, and one is goalie Fowler who looks like he's USA's backup. InForaPenny has 15 players left and Driedger18 has 16 left. I have 17 but I'm behind all those entries.
My best chance is Finland and Sweden winning and getting wins from Kokko and Havelid, and then a guaranteed win in the finals. So I'll be pulling for those teams in the semis!

[InForAPenny]

I'm pretty much all in for Czechia at this point. Figure I'll go as far as they take me. It's exciting to still be involved in the chace though, not sure I've been this close to the top before.

[doulos]

After the two semi-final games.

1 dodospice 125
2 watchingthegame 122
3 Driedger18 121
4 InForAPenny 117
5 Forsbergfan 115
6 Dennis 114
7 Doulos 113
8 Marky J 113
9 CrimsonYann 112
10 stacjam 112
11 PenguinHunter 111
12 metaldude26 110
13 VintageVibe 109
14 Rocky71 107
15 Axeman33 107
16 newfcollins 106
17 Kingchev 105
18 finnys_fanatsy 104
19 pmorrow 102
20 Letterkeny Shamrocks 101
21 Gotenks 99
22 stevegamer 99
23 StuntMan12 87

[doulos]

Preliminary results after the Bronze medal game have the top 4 within 2 points of each other. I wasn't watching the game but it looked liked Hrabal did not get the win, which might be huge. Wow!