The College Hockey Championship Belt Part IV

[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.

 

[AMC]

Thank you for your service to this project.

 

[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.

 

[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.

 

[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.

 

[Ralph Baer]

Thanks to everyone who appreciated my work.

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

 

[Ralph Baer]

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

                   [U]Current Holder[/U]         [U]Next Defense[/U]
[B]The Belt           Quinnipiac             next season[/B]
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

 

[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.