In the process of scheduling the games for a season, the person creating the schedule has on hand a list of available home dates for each arena. The list of 2000-01 Memphis home dates suggests that around 45-50 dates are submitted, of which 33-35 are selected.
Since I only have access to the final selection of dates, 10-15 possible dates are missing for the program to select from. In an effort to recreate these dates, I have gone back to the prior schedules for these teams and analysed their home date selections for patterns.
The date is collected in an Access database with tables for each team, and queries on those tables.
The queries are collected into one Excel worksheet for easier viewing.