Create Complex Sports Schedule For Basketball League

Hi

I run a NYC Basketball League and we've grown to a point where we need a more complex schedule than we've had before. Here are the details:

a) 8 team league
b) 10 weeks of games
c) there are two divisions within the league (North & South)
d) In the North Division, you'll play the other 3 teams in the North Division twice (6 games)
e) In the North Division, you'll play the other 4 teams in the South Division once (4 games)
f) We play at 6pm, 7pm, 8pm and 9pm; we want to create a balanced schedule so people get [mostly] equal games at each of the time slots. This is less important, though the more even the games are split, the better.

I've put together the attached template.

In the tab: "Key", we have the team name and the division that each team is in.

In the tab: "Schedule", I've listed out the time slots, weeks and match ups. Ideally, we can insert each team in the cells that are marked yellow. For the two teams that play against each other in Week1 at 6pm, one team would be inserted into D3 and one into E3. For the two teams that play against each other in Week1 at 7pm, one team would be put into G3 and one into H3. And so on...

If anyone can help with this, it would be GREAT