Tom,
This is rarely asked for in my experience. Usually when HA format is used each team has their own home venue, so the assignment to courts or fields is no longer useful as this is something associated with a central location shared by all teams.
I think up to now you may have been lucky as it depends on the number of teams (n). For odd values of n, then I think there will always be the correspondence between the rounds of the two formats. Perhaps you have only had odd n up to now?
If n is of the form 6i + 4, where i >= 1, that is to say n = 10,16,22,... Then the court schedule will be read from the hidden 'library' worksheet, and will be a completely different schedule to the HA format.
Otherwise when n = 4,6,8,12,14,18, etc., then as you have found above there will be a correspondence, but the rounds will be in different orders. In these cases you need to reorder the rounds of the court schedule as follows. Round 1 remains the same, then play round 1 + d, where d = (n-2)/2, then play round 1 + 2d, then round 1 + 3d, etc.
For example if n = 6, then d = 2 and
1 = 1
1+d = 3
1+2d = 5
1+3d = 7
1+4d = 9
where this number exceeds the maximum number of rounds, (n-1) then keep subtracting (n-1) until it is back in range. So to un-shuffle the rounds of the court schedule above, rearrange them in the order R1,R3,R5,R2,R4. Similarly for n = 8, play the rounds in the order R1,R4,R7,R3,R6,R2,R5.
Ian.
