How the System Works
The production of the fixture list goes through a number of stages. The process centres round a number of spreadsheets in a Google workbook.
The first stage is the preparation of the Base Fixture List based on the fixtures in the previous year with dates updated.
The next stage, that is repeated, is of submissions to confirm, amend fixtures or to notify additional fixtures. Submissions are best made using the two forms accessed by the adjacent buttons. These entries are automatically transferred to spreadsheets in the workbook providing a record that may be viewed by clicking the appropriate spreadsheet button. Notifications may also be made by email or other means.
In the next stage the preparatory final fixture list is updated manually with the submitted information. As the list is updated, another spreadsheet is automatically generated to provide a list of only those fixtures that have been confirmed, amended or added. This list of confirmed fixtures is shown below the Base Fixture list.
Eventually, the confirmed list is downloaded in a format where it can be used to produce the final fixture list on the website. These stages are repeated periodically as new submissions are made.
There is another spreadsheet in the workbook where the fixtures for a particular venue (club) may be generated. A copy of a clubs fixtures can be sent to clubs.