View Single Post
Old 08-06-2024, 10:53 PM   #3
gmo
Hall Of Famer
 
Join Date: May 2002
Location: Longmont, CO
Posts: 3,437
Attached here the spreadsheet of what I gathered. The sheet in the file are explained here. The spreadsheet was made in LibreOffice Calc and saved in Excel 2007/365 format, so hopefully there are no issues with that.

Games sheet

Completed games with date, teams, scores, and results. These are from at least one of the scores mentioned. The dates may not be the originally scheduled date for the games. In fact, postponed games are mostly on the played date rather than the originally scheduled date. Some known exceptions are games that were started on the original date then suspended and later completed.

Records sheet

This includes in the first set of columns the records as determined from the games played. There are also records as compiled from the team websites. The non-D1 teams are not included in the second set. Between the sets is an indicator of if the sets do not match for teams. Beyond the sets are the differences when there are not record matches.

Not played sheet

These are games found from individual team websites (plus a handful from d1baseball.com) shown as scheduled but not played and thus not in the Games sheet. These were found by searching for instances of "cancel" or "postpone" on the team websites. Rows in bold indicate that both teams' websites showed that game. My impression is that many teams did not show any cancelled games. Considering how frequently games here were on only one team site, plus my impression that many team sites lacked cancelled games because they were cleaned away, it seems likely there are more games completely missed.

Believe otherwise covered

These are games found from individual team websites that were not played as scheduled but that I think are redundant. Mostly these are games known played at a later date and on the Games sheet. There are some other cases such as multiply postponed games.

The Games sheet plus the Not played sheet are my best guess at what to make into the schedule. Beyond issues already mentioned, particularly how to deal with games against non-D1 opponents, there is the big issue of making sure the teams as defined in the league align with the identifiers that get attributed to the teams in the schedule file.
Attached Files
File Type: xlsx ncaa_d1_2024.xlsx (296.8 KB, 46 views)
__________________
Making Baseball Schedules
gmo is offline   Reply With Quote