Avoid back to back Match ups

[Jerk24]

Good morning

I am running a dart league here are the details

12 teams (Team1, Team2, Team3...etc)
2 Division (odd teams and Even Teams)
16 weeks
6 Boards (all teams play at the same time)

I would like the teams to play in the same division 2 times, while playing the opposite division 1 time.

I also, do not want any team to play the same team two weeks in a row. T
I do not want the same team to play on the same board two weeks in a row.
and evenly distribute the times played on each board.


is this possible??

 

[Jerk24]

I have the current formulas to count the Team vs Team and times played on each board. - I can email the file if that helps. my main concern is to avoid teams playing on the same board two weeks in a row.

=COUNTIFS($O$45:$O$207,X$2,$L$45:$L$207,$W3)+COUNTIFS($O$45:$O$207,X$2,$N$45:$N$207,$W3) this is under the cell under board 1

			TOTAL Times played on each board
		BOARD 1	BOARD 2	BOARD 3	BOARD 4	BOARD 5	BOARD 6		inside	outside
Team	1	3	2	3	2	3	3	16	8	8	11
Team	2	3	3	2	2	3	3	16	8	8
Team	3	3	3	2	3	2	3	16	8	8
Team	4	3	3	3	3	2	2	16	9	7
Team	5	3	2	3	3	3	2	16	8	8
Team	6	3	2	2	3	3	3	16	7	9
Team	7	2	3	3	3	2	3	16	8	8
Team	8	2	2	4	3	3	2	16	8	8
Team	9	3	3	3	2	2	3	16	9	7
Team	10	2	3	3	2	3	3	16	8	8
Team	11	2	3	2	3	4	2	16	7	9
Team	12	3	3	2	3	2	3	16	8	8
			TOTAL Times played on each Team
Team>>		1	2	3	4	5	6	7	8	9	10	11	12
Team	1		1	2	1	2	1	2	1	2	1	2	1
Team	2	1		1	2	1	2	1	2	1	2	1	2
Team	3	2	1		1	2	1	2	1	2	1	2	1
Team	4	1	2	1		1	2	1	2	1	2	1	2
Team	5	2	1	2	1		1	2	1	2	1	2	1
Team	6	1	2	1	2	1		1	2	1	2	1	2
Team	7	2	1	2	1	2	1		1	2	1	2	1
Team	8	1	2	1	2	1	2	1		1	2	1	2
Team	9	2	1	2	1	2	1	2	1		1	2	1
Team	10	1	2	1	2	1	2	1	2	1		1	2
Team	11	2	1	2	1	2	1	2	1	2	1		1
Team	12	1	2	1	2	1	2	1	2	1	2	1
		16	16	16	16	16	16	16	16	16	16	16	16

<tbody>
</tbody>