8 teams with sister teams using 4 tables for 8 ball

[hthomas22]

I am looking to have a schedule for 8 teams with each team having a sister team that only allows 1 team to be home at a time unless playing each other.  I would like this to be for 14 weeks or however the rotation works out. I.e.

A B Using Table 1 as home table
C D using Table 2  as home table
E F  using Table 3  as home table
G H Using Table 4  as home table

Is this possible with the scheduling spreadsheet?  Did I miss a step?

[Ian Wakeling]

I beleive my spreadsheet gives you what you want.  If you look at the background colours below, then the pairs A&G, B&H, C&D, E&F can all share the same venue.  Each row lists the order of opponents for the team given in the first column, green means the match is at home, yellow for away.  Hope that helps.

[hthomas22]

Thank you very much.  Yes it does