Spreadsheet: 816494d1675668431-pairing-people-with-no-repeats-over-multiple-weeks-events-8-person-example-ans
Sheet: 8 Person Matrix

 |  |  | Week
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
Number | 1 |  | 8 | 7 | 6 | 5 | 4 | 3 | 2 |  |  | 1 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8
8 | 2 |  | 7 | 6 | 5 | 8 | 3 | 4 | 1 |  |  | 2 |  | 3 | 4 | 5 | 6 | 7 | 8 | 1
 | 3 |  | 6 | 5 | 8 | 7 | 2 | 1 | 4 |  |  | 3 |  | 4 | 5 | 6 | 7 | 8 | 1 | 2
 | 4 |  | 5 | 8 | 7 | 6 | 1 | 2 | 3 |  |  | 4 |  | 5 | 6 | 7 | 8 | 1 | 2 | 3
 | 5 |  | 4 | 3 | 2 | 1 | 8 | 7 | 6 |  |  | 5 |  | 6 | 7 | 8 | 1 | 2 | 3 | 4
 | 6 |  | 3 | 2 | 1 | 4 | 7 | 6 | 5 |  |  | 6 |  | 7 | 8 | 1 | 2 | 3 | 4 | 5
 | 7 |  | 2 | 1 | 4 | 3 | 6 | 5 | 8 |  |  | 7 |  | 8 | 1 | 2 | 3 | 4 | 5 | 6
 | 8 |  | 1 | 4 | 3 | 2 | 5 | 8 | 7 |  |  | 8
 |  | Pair 1 |  |  | Pair 2 |  |  |  |  |  |  | WEEK | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  |  |  |  |  |  |  |  | Persons | 10 |  | PERSON
 |  | 1 | 8 |  | 1 | 7 |  |  | Weeks | 9 |  | 1
 |  | 2 | 7 |  | 2 | 6 |  |  |  |  |  | 2
 |  | 3 | 6 |  | 3 | 5 |  |  |  |  |  | 3
 |  | 4 | 5 |  | 4 | 8 |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 6
 |  | Pair 3 |  |  | Pair 4 |  |  |  |  |  |  | 7
 |  | 1 | 6 |  | 1 | 5 |  |  |  |  |  | 8
 |  | 2 | 5 |  | 2 | 8 |  |  |  |  |  | 9
 |  | 3 | 8 |  | 3 | 7
 |  | 4 | 7 |  | 4 | 6
 |  | Pair 5 |  |  | Pair 6
 |  | 1 | 4 |  | 1 | 3
 |  | 2 | 3 |  | 2 | 4
 |  | 5 | 8 |  | 5 | 7
 |  | 6 | 7 |  | 6 | 8
 |  | Pair 7
 |  | 1 | 2
 |  | 3 | 4
 |  | 5 | 6
 |  | 7 | 8
22 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | 1 |  | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2
 | 2 |  | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 12 | 22 | 1 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3
 | 3 |  | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 12 | 22 | 21 | 2 | 1 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4
 | 4 |  | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 12 | 22 | 21 | 20 | 3 | 2 | 1 | 11 | 10 | 9 | 8 | 7 | 6 | 5
 | 5 |  | 18 | 17 | 16 | 15 | 14 | 13 | 12 | 22 | 21 | 20 | 19 | 4 | 3 | 2 | 1 | 11 | 10 | 9 | 8 | 7 | 6
 | 6 |  | 17 | 16 | 15 | 14 | 13 | 12 | 22 | 21 | 20 | 19 | 18 | 5 | 4 | 3 | 2 | 1 | 11 | 10 | 9 | 8 | 7
 | 7 |  | 16 | 15 | 14 | 13 | 12 | 22 | 21 | 20 | 19 | 18 | 17 | 6 | 5 | 4 | 3 | 2 | 1 | 11 | 10 | 9 | 8
 | 8 |  | 15 | 14 | 13 | 12 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 11 | 10 | 9
 | 9 |  | 14 | 13 | 12 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 11 | 10
 | 10 |  | 13 | 12 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 11
 | 11 |  | 12 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1
24 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23
 | 1 |  | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2
 | 2 |  | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 24 | 1 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3
 | 3 |  | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 24 | 23 | 2 | 1 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4
 | 4 |  | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 24 | 23 | 22 | 3 | 2 | 1 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5
 | 5 |  | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 24 | 23 | 22 | 21 | 4 | 3 | 2 | 1 | 12 | 11 | 10 | 9 | 8 | 7 | 6
 | 6 |  | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 24 | 23 | 22 | 21 | 20 | 5 | 4 | 3 | 2 | 1 | 12 | 11 | 10 | 9 | 8 | 7
 | 7 |  | 18 | 17 | 16 | 15 | 14 | 13 | 24 | 23 | 22 | 21 | 20 | 19 | 6 | 5 | 4 | 3 | 2 | 1 | 12 | 11 | 10 | 9 | 8
 | 8 |  | 17 | 16 | 15 | 14 | 13 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 12 | 11 | 10 | 9
 | 9 |  | 16 | 15 | 14 | 13 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 12 | 11 | 10
 | 10 |  | 15 | 14 | 13 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 12 | 11
 | 11 |  | 14 | 13 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 12
 | 12 |  | 13 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1
26 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25
 | 1 |  | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2
 | 2 |  | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 26 | 1 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3
 | 3 |  | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 26 | 25 | 2 | 1 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4
 | 4 |  | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 26 | 25 | 24 | 3 | 2 | 1 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5
 | 5 |  | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 26 | 25 | 24 | 23 | 4 | 3 | 2 | 1 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6
 | 6 |  | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 26 | 25 | 24 | 23 | 22 | 5 | 4 | 3 | 2 | 1 | 13 | 12 | 11 | 10 | 9 | 8 | 7
 | 7 |  | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 26 | 25 | 24 | 23 | 22 | 21 | 6 | 5 | 4 | 3 | 2 | 1 | 13 | 12 | 11 | 10 | 9 | 8
 | 8 |  | 19 | 18 | 17 | 16 | 15 | 14 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 13 | 12 | 11 | 10 | 9
 | 9 |  | 18 | 17 | 16 | 15 | 14 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 13 | 12 | 11 | 10
 | 10 |  | 17 | 16 | 15 | 14 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 13 | 12 | 11
 | 11 |  | 16 | 15 | 14 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 13 | 12
 | 12 |  | 15 | 14 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 13
 | 13 |  | 14 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1
28 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 1 |  | 28 | 27 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2
 | 2 |  | 27 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 28 | 1 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3
 | 3 |  | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 28 | 27 | 2 | 1 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4
 | 4 |  | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 28 | 27 | 26 | 3 | 2 | 1 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5
 | 5 |  | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 28 | 27 | 26 | 25 | 4 | 3 | 2 | 1 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6
 | 6 |  | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 28 | 27 | 26 | 25 | 24 | 5 | 4 | 3 | 2 | 1 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7
 | 7 |  | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 28 | 27 | 26 | 25 | 24 | 23 | 6 | 5 | 4 | 3 | 2 | 1 | 14 | 13 | 12 | 11 | 10 | 9 | 8
 | 8 |  | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 28 | 27 | 26 | 25 | 24 | 23 | 22 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 14 | 13 | 12 | 11 | 10 | 9
 | 9 |  | 20 | 19 | 18 | 17 | 16 | 15 | 28 | 27 | 26 | 25 | 24 | 23 | 22 | 21 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 14 | 13 | 12 | 11 | 10
 | 10 |  | 19 | 18 | 17 | 16 | 15 | 28 | 27 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 14 | 13 | 12 | 11
 | 11 |  | 18 | 17 | 16 | 15 | 28 | 27 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 14 | 13 | 12
 | 12 |  | 17 | 16 | 15 | 28 | 27 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 14 | 13
 | 13 |  | 16 | 15 | 28 | 27 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 14
 | 14 |  | 15 | 28 | 27 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1
30 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29
 | 1 |  | 30 | 29 | 28 | 27 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2
 | 2 |  | 29 | 28 | 27 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 30 | 1 | 15 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3
 | 3 |  | 28 | 27 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 30 | 29 | 2 | 1 | 15 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4
 | 4 |  | 27 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 30 | 29 | 28 | 3 | 2 | 1 | 15 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5
 | 5 |  | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 30 | 29 | 28 | 27 | 4 | 3 | 2 | 1 | 15 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6
 | 6 |  | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 30 | 29 | 28 | 27 | 26 | 5 | 4 | 3 | 2 | 1 | 15 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7
 | 7 |  | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 30 | 29 | 28 | 27 | 26 | 25 | 6 | 5 | 4 | 3 | 2 | 1 | 15 | 14 | 13 | 12 | 11 | 10 | 9 | 8
 | 8 |  | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 30 | 29 | 28 | 27 | 26 | 25 | 24 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 15 | 14 | 13 | 12 | 11 | 10 | 9
 | 9 |  | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 30 | 29 | 28 | 27 | 26 | 25 | 24 | 23 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 15 | 14 | 13 | 12 | 11 | 10
 | 10 |  | 21 | 20 | 19 | 18 | 17 | 16 | 30 | 29 | 28 | 27 | 26 | 25 | 24 | 23 | 22 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 15 | 14 | 13 | 12 | 11
 | 11 |  | 20 | 19 | 18 | 17 | 16 | 30 | 29 | 28 | 27 | 26 | 25 | 24 | 23 | 22 | 21 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 15 | 14 | 13 | 12
 | 12 |  | 19 | 18 | 17 | 16 | 30 | 29 | 28 | 27 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 15 | 14 | 13
 | 13 |  | 18 | 17 | 16 | 30 | 29 | 28 | 27 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 15 | 14
 | 14 |  | 17 | 16 | 30 | 29 | 28 | 27 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 15
 | 15 |  | 16 | 30 | 29 | 28 | 27 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1