Eastern Suburbs Junior Cricket Club - Grade Convenors 2022/23
Grade |
Convenor |
Email / Phone |
Year 2 |
Terry Hills |
terry.hills@xtra.co.nz / 0274303654 |
Year 3 |
Terry Hills |
terry.hills@xtra.co.nz / 0274303654 |
Year 4 |
Claire Cairns |
claireanncairns@gmail.com / 02102266566 |
Year 5 |
Nelish Morar |
nelish.morar@gmail.com / 0212218952 |
Year 6 |
Gregor Fountain |
gjfountain@gmail.com / 0212010446 |
Year 7 |
Emily Walsh |
emzadude@hotmail.com / 021540156 |
Year 8 |
Dave Dornan |
davewgtn@gmail.com / 0211186271 |
Creating Year group and team spreadsheets from PlayHQ data
Click on ‘Reports’ in left-hand column. Scroll down to the ‘Participation Report’ section. Select the following:
Organisation: Cricket Wellington Competition: HVAC Junior Cricket Season: Summer 2022/23
Click ‘Generate’. Click on the ‘Generated Reports’ menu heading and keep clicking F5 (Refresh screen) until the STATUS column value changes to ‘Generated’. Click the ‘Download’ button.
Open the downloaded csv file (format participant_ccyymmddnnnnn.csv). It is important to save this file as an Excel spreadsheet (e.g.. .xlsx suffix).
Double click the header lines between each column to maximise the column size to see all data. Click Data / Sort and sort by column ‘team name’.
Hide the columns not required e.g. registration date, profile id, source, permit from etc.
Delete all rows not required.