Office Tools - Competition Criteria Spreadsheet

Example Data Sheet


Note the Update Number Matching button.  This will update the Number of Matching Competitors column which displays how many competitors currently match the criteria.  This can be used to aid in adjusting the values in the criteria to obtain a balanced set of competitions.

The data in the cells can be edited to adjust the criteria values and the Sub-name.  The rows and also be copied and pasted to add more rows - just make sure that there are no blank rows in the list of criteria.

The colour of the Competition Name cell (green here) is used to change the colour of the tab for the generated competition running order sheet.  Use this for your convenience to quickly identify the sheets once they are generated.