Many of the cells provide 'pull down' lists of options, so it is easy to complete the forms consistently. When filling in the form, each club can just pick their name from the list of clubs - the details you have previously set up will be copied in automatically from the 'Clubs' worksheet. Similarly, the grades, gender and teams have picklists defined on the 'Lists' worksheet. Automatically evaluated cells are 'locked' so they cannot be inadvertently changed. Important! You must set the YEAR on the front worksheet for the age group calculations to be correct. The sheets assume that age groups are defined by the calendar year of the date of birth. If you need to use the academic year instead, please use the ‘Schools Competition’ template entry form provided with TScore version 9.5.17 and later. Set the Event Name, Venue and Date on the 'Entries' worksheet, and the return address on the 'Payment' worksheet. If you need to change the cost per competitor, simply alter cell E6 on the payments sheet. Note that Excel must be used to edit this form – ‘Open Office’ gets it wrong! |