Producing the fixtures for a league can be one of the secretary’s most difficult tasks. David Sanderson produced a useful guide to the problem which used to be available on the BCGBA site. His notes are incorporated in the guide below.
His method (like others) is based on using a “pattern” to assign fixtures to each team in the league. It helps to avoid greens being double-booked, and to avoid long runs of consecutive home or away matches.
I have automated the method in an Excel spreadsheet, which is available for download below (it requires Excel 2007 or later). You will probably also need to study the user guide.
To download these files, right-click on the links and select “Save link as...” or “Save target as...” (depending on your browser).
Note that this application is aimed at users who are reasonably comfortable with using Excel (version 2007 required).