2023 Edition - Dobber WJC Pool

[PenguinHunter]

LINK TO THIS YEAR'S TRACKING SHEET - ENTRY SHEET IS AT THE BOTTOM OF THIS MESSAGE.
https://docs.google.com/spreadsheets...it?usp=sharing

We made it! Life gets busy, I spend time recovering, but eventually we make it here - ready to go for round 14 and hopefully find some solace among the wild stuff *still* happening!

Similar to last year, struggled to cut down from 8 and 6 to 6 and 5 captains, which is a bit of a trend based on last year, but post-pool analysis justified my choice so I'll leave it as it is and take another year of data.

I took the teams off eliteprospects, but normally I take them from here and couldn't double-check, so if you see a discrepancy let me know.

Deadline is approximately 3 days, 2 hours and 45 minutes hours from this posting.

HALL OF FAME:2007/08: miked (out of 9 entries)
2008/09: ultrawhiteness (out of 28 entries)
2009/10: watchingthegame (out of 28 entries)
2010/11: metaldude26 (out of 20 entries)
2011/12: vandalay (out of 29 entries)
2012/13: dodospice (out of 49 entries)
2013/14: CaptainCally (out of 21 entries)
2014/15: watchingthegame (out of 34 entries - two time champ)
2015/16: Crazy Joe Davola (out of 37 entries)
2016/17: vandalay (out of 34 entries) - 2 time champ)
2017/18: markyj (out of 31 entries)
2018/19: axeman33 (out of 38 entries)
2019/20: crimsonyann (out of 44 entries)
2020/21: PenguinHunter (out of 42 entries)
2021/22: Tournament Cancelled - no competition held for the summer tourney
2022/23: TBD

Credit to user 'reeveta' who started the pool and was running this for the first 9 years.
And credit to use 'Nights' who helped from 2010-2016 and then took over completely in 2017.

Changes to the rules copy-paste are in bold.
Same format as last year.

SCORING:
Points only for skaters
Goalies Wins = 2, OTL = 1, SO = +2
The only points that count are those in games that lead to a medal (round robin and playoffs). This does include the bronze medal game. Relegation round or 5th-6th seeding games are NOT included.

In case of a tie in points, the winner will be decided via shootout - which is to say, the highest amount of goals. Most points in the gold-medal game may be used as the second tie-breaker if necessary.

ROSTER
12 forwards, 6 d-men, 2 goalies + 2 captains (total 22 players)
Only 5 players from any one nation (including all positions and captain) so you can?t load up on one or two nations.
Captains are in to try and drive some variety. I used the forums' collective judgement in figuring out who some of the top picks will be. Does a good job to help diversify picks across different teams. It's always tough.

Captain options for this year's pool are:

Captain - F	Captain - D
Connor Bedard	Olen Zellweger
Shane Wright	Brandt Clarke
Fabian Lysell	Luke Hughes
Joakim Kemell	David Jiricek
Logan Cooley

PRIZE
Respect and bragging rights.

HOW TO ENTER
In the attached .zip file in which I have put a Microsoft Excel spreadsheet. From here you can use the pull-down menus to pick you team. The spreadsheet counts the number of players from each nation. Once you have selected your 22 players save the excel file with your username and email it to me. My email is [email protected]

Please put '2023 World Junior Pool' in the title so it will be easy to spot in case your email gets caught as spam.

You can also use the link provided at the bottom to the Google Sheets version of the file. You can make your changes, download the file as an Excel and send that over instead.

If you don't have Microsoft Excel your other option is to email me with the names (first name and last name) of you entry in a list. The names must be spelled exactly as found on the roster from the IIHF website (insert website). This makes it possible for me to cut and paste into excel. Be sure to count the number of players you have from each nation.
If you don't have email and want to PM me please also make sure the full name is spelled correctly. Names I don't understand may be mistaken for depth players on Team Denmark (Who haven't qualified this year!).

The deadline is before the drop of the puck for the first game (Which is 9:00 a.m. EST on December 26, 2022)

CHANGES
Every year a few people wanted to change their entries after they made them but before the deadline. This is not a big deal but it is something I would like to minimize because it opens it up for me to make a mistake. The best plan is to wait until closer to the start of the tournament to make your entry. However, if you want to change it I will accept it up until the deadline.

NOTES AND DISCLAIMER
I have done the best I can to get the up-to-date rosters but these rosters are pre-cuts for some teams and there may be errors. I take no responsibility for you picking players that don't play, or great players not being listed, although I will try to update when possible.

If player is not on the pull down list but should be, add him in the 'write in' section. There shouldn't be many but if there are I am sorry. Every year a few people put a write-in candidate that is one of the captain choices. Be sure to look there first.


SPREAD THE WORD
Please feel free to spread the word around the forums about this free challenge.

Here's the google sheets version - save a copy (*either make a copy on Google Drive, or Download it as a separate file type locally), complete it, then e-mail it to me (preferably as an .xlsx).
https://docs.google.com/spreadsheets...it?usp=sharing


New email - [email protected]

Good luck!

[forsbergfan]

I don't see the excel spreadsheet or google doc - am I missing something?

[Nights]

Just wanted to pop in and thank PenguinHunter for taking over this year.

It's been a hectic year and while it's quieting down now to give me a chance to breathe, and a lot of the stuff we're one-off's that shouldn't need to be dealt with again/for a while, I wanted to take the holidays to rest up so I'm taking the year off.

We'll see how next year goes, but in the meantime enjoy the PenguinHunter WJC pool!

[PenguinHunter]

I don't see the excel spreadsheet or google doc - am I missing something?

Yes - sorry - I was just making sure I got the Dobber thread set up while I was checking over things in the entry form and tracker.

They should be both included in the original post now.

Also - this is my first time using these spreadsheets - so if there is anything that you see that needs fixed/update or anything you have questions about - please reach out!

Good luck all!

[forsbergfan]

is there only a google doc option? i don't see the excel.

[PenguinHunter]

is there only a google doc option? i don't see the excel.

I think there should be an option to open it as an Excel spreadsheet - but this might only be an option on mobile?

[PenguinHunter]

I think there should be an option to open it as an Excel spreadsheet - but this might only be an option on mobile?

Does anyone know how to copy a google sheet document into Excel format?

Thanks,

[CrimsonYann]

Just wanted to pop in and thank PenguinHunter for taking over this year.

It's been a hectic year and while it's quieting down now to give me a chance to breathe, and a lot of the stuff we're one-off's that shouldn't need to be dealt with again/for a while, I wanted to take the holidays to rest up so I'm taking the year off.

We'll see how next year goes, but in the meantime enjoy the PenguinHunter WJC pool!

Cheers, Nights. I hope you can still participate.

[CrimsonYann]

Does anyone know how to copy a google sheet document into Excel format?

Thanks,

Once in the Google sheet, I click on File > Download > Microsoft Excel, then locally save the xlsx file found in my Downloads folder with my user tab in the tab and file title.

[Nights]

Does anyone know how to copy a google sheet document into Excel format?

Thanks,

Like CrimsonYann said, you can download the google sheet as an Excel through the "File > Download > Microsoft Excel (.xlsx)" option.

The boards are always a pain, since you have to open the attachment window, browse to select the doc, hit upload, and then hit attach or something equally as bothersome.

[PenguinHunter]

I am replying to emails as I received entries and get them entered into an entry sheet.

once the deadline passes - I will transfer them to the main tracker.

so if you have sent me an entry and have not received a response - please reach out to me and we will find it!

[pmorrow]

Bumping for visibility. Keep the submissions coming!

[InForAPenny]

Sent mine in. We'll see if I can dodge the bottom half of the standings this year.

[Axeman33]

I had to request permission to see it, request sent.

[forsbergfan]

I think I've changed my D captain 10 times in the last few hours. Same two guys, just can't decide who. Brain says one thing, heart says the other.