The College Hockey Championship Belt Part IV

[TalonsUpPuckDown]

I think automating it shouldn't be too terrible. The problem is going to be getting high quality, standardized format schedules and scores for all schools. I suspect I can run a simple scrape of one of the big sites (USCHO, chn, chs, etc) to pull that info.

after that it should be straightforward.

I use Google Sheet's IMPORTHTML to pull the CCHA composite (complete with scores) off of USCHO into my Pick 'Em analyzer. Here's the formula to pull the entire 2023-24 composite schedule:

=IMPORTHTML("https://www.uscho.com/scoreboard/division-i-men/2023-2024/composite-schedule/","table",1)

I bet if you tinker around a bit it'll give you what you want.

[Ralph Baer]

If anyone intends to continue this, this is what I compiled as the first defenses. Thee may be errors.

                   Current Holder         Next Defense
The Belt           Quinnipiac             next season
AHC Belt           Canisius               Holy Cross 11/03/2023
B1G Belt           Michigan               Ohio State 10/20/2023
CCHA Belt          Minnesota State        Ferris State 11/10/2023
ECAC Belt          Colgate                Brown 11/10/2023
HEA Belt           Boston University      New Hampshire 10/13/2023
NCHC Belt          St. Cloud              Miami 11/03/2023
Ivy Belt           Harvard                Dartmouth 10/27/2023
Eastern Belt       Boston University      Bentley 10/07/2023
Western Belt       Minnesota              St. Thomas 11/13/2023
Connecticut Belt   Quinnipiac             Yale 11/11/2023
Massachusetts Belt Northeastern           Stonehill 10/07/2023
Michigan Belt      Michigan               Michigan State 01/19/2024
Minnesota Belt     Minnesota              Minnesota Duluth 11/23/2023
New York Belt      Cornell                Colgate 12/01/2023
New York Belt SO   Colgate                Niagara 11/24/2023
D II Play Up Belt  St. Cloud              Bemidji State 11/29/2023
D III Play up Belt St. Lawrence           Union 11/10/2023
Play up Belt       St. Cloud              Bemidji State 11/29/2023

[Ralph Baer]

Thanks to everyone who appreciated my work.

dxmnkd316, if you are still interested, I can send you my history file.

[Caustic Undertow]

I have decided after several years of thinking about it to stop being the compiler of the Belts. It's become more of a chore for me than fun.

If anyone else is interested in doing this, I will gladly send the history file to them.

I'm sorry to hear this, but I understand. As a looooongtime mostly lingering occupant here I've always worked to locate this thread and I've always enjoyed it.

Thanks for keeping at it for so long. A gem of a record of college hockey.

An internet tip of the cap to you, Ralph.

[dxmnkd316]

I think automating it shouldn't be too terrible. The problem is going to be getting high quality, standardized format schedules and scores for all schools. I suspect I can run a simple scrape of one of the big sites (USCHO, chn, chs, etc) to pull that info.

after that it should be straightforward.

[Ralph Baer]

Thanks for all the work you have put into this project over the years! I assume this is a manual, time consuming project. I wonder if there is a way to automate some of it now, with a program or macro? (Not volunteering your or me for that, just thinking out loud)

Thanks.

There undoubtedly are ways to automate it. Whether someone wants to do that is a question.

[AMC]

Thank you for your service to this project.

[dxmnkd316]

Thanks for all the work you have put into this project over the years! I assume this is a manual, time consuming project. I wonder if there is a way to automate some of it now, with a program or macro? (Not volunteering your or me for that, just thinking out loud)

this is precisely what I was thinking.

[mar7967]

I have decided after several years of thinking about it to stop being the compiler of the Belts. It's become more of a chore for me than fun.

If anyone else is interested in doing this, I will gladly send the history file to them.

Thanks for all the work you have put into this project over the years! I assume this is a manual, time consuming project. I wonder if there is a way to automate some of it now, with a program or macro? (Not volunteering your or me for that, just thinking out loud)

[Ralph Baer]

If there's no passionate takers, I'd give it a go. Always been interested.

Good to see there is some interest.

[dxmnkd316]

I have decided after several years of thinking about it to stop being the compiler of the Belts. It's become more of a chore for me than fun.

If anyone else is interested in doing this, I will gladly send the history file to them.

If there's no passionate takers, I'd give it a go. Always been interested.

[Sean Pickett]

I have decided after several years of thinking about it to stop being the compiler of the Belts. It's become more of a chore for me than fun.

I really enjoyed helping create the belts' histories, but I was never interested in maintaining them. Thanks for all the years you have done so.

Sean

[Ralph Baer]

I have decided after several years of thinking about it to stop being the compiler of the Belts. It's become more of a chore for me than fun.

If anyone else is interested in doing this, I will gladly send the history file to them.

[Ralph Baer]

Congrats to Quinnipiac on winning the Belt

                   Current Holder         Next Defense
The Belt           Quinnipiac             next season
AHC Belt           Canisius               next season
B1G Belt           Michigan               next season
CCHA Belt          Minnesota State        next season
ECAC Belt          Colgate                next season
HEA Belt           Boston University      next season
NCHC Belt          St. Cloud              next season
Ivy Belt           Harvard                next season
Eastern Belt       Boston University      next season
Western Belt       Minnesota              next season
Connecticut Belt   Quinnipiac             next season
Massachusetts Belt Northeastern           next season
Michigan Belt      Michigan               next season
Minnesota Belt     Minnesota              next season
New York Belt      Cornell                next season
New York Belt SO   Colgate                next season
D II Play Up Belt  St. Cloud              next season
D III Play up Belt St. Lawrence           next season
Play up Belt       St. Cloud              next season

Corrections are always appreciated.

[Ralph Baer]

Congrats to Minnesota on winning the Belt

                   Current Holder         Next Defense
The Belt           Minnesota              Quinnipiac 04/08/2023
AHC Belt           Canisius               next season
B1G Belt           Michigan               next season
CCHA Belt          Minnesota State        next season
ECAC Belt          Colgate                next season
HEA Belt           Boston University      next season
NCHC Belt          St. Cloud              next season
Ivy Belt           Harvard                next season
Eastern Belt       Boston University      next season
Western Belt       Minnesota              next season
Connecticut Belt   Quinnipiac             next season
Massachusetts Belt Northeastern           next season
Michigan Belt      Michigan               next season
Minnesota Belt     Minnesota              next season
New York Belt      Cornell                next season
New York Belt SO   Colgate                next season
D II Play Up Belt  St. Cloud              next season
D III Play up Belt St. Lawrence           next season
Play up Belt       St. Cloud              next season

Corrections are always appreciated.