Hi Jono,
If I understand correctly you are asking for both court balance and home-away balance. This is possible, but it is beyond what you will get from the Excel generator, as essentially this does one or the other.
Below is a 14 round example where I have rearranged rounds 1 to 7 slightly, to form rounds 8 to 14. If a game is (A B), then I intend that team A is the home team and B is the away team. I have simply reversed all the games (A B) in rounds 1 to 7 to become (B A) in rounds 8 to 14 and have rotated the courts/columns along one. The result is that if the first game between any 2 teams is played in round 1, 3, 5 or 7, then the rematch between the same 2 teams will be played in either rounds 8, 10, 12 or 14, so balancing home/away and week-day/Saturday. If you want 21 rounds, then I think you could just take rounds 1 to 7 and rotate the columns twice.
Hope that helps,
Ian.
C1 C2 C3 C4
r1 (3 2) (6 7) (8 1) (5 4)
r2 (2 5) (1 3) (4 6) (7 8)
r3 (4 7) (5 3) (8 2) (6 1)
r4 (3 8) (1 4) (7 5) (2 6)
r5 (7 1) (5 8) (6 3) (4 2)
r6 (8 6) (2 7) (3 4) (1 5)
r7 (6 5) (4 8) (2 1) (7 3)
r8 (4 5) (2 3) (7 6) (1 8)
r9 (8 7) (5 2) (3 1) (6 4)
r10 (1 6) (7 4) (3 5) (2 8)
r11 (6 2) (8 3) (4 1) (5 7)
r12 (2 4) (1 7) (8 5) (3 6)
r13 (5 1) (6 8) (7 2) (4 3)
r14 (3 7) (5 6) (8 4) (1 2)