County Selectors (Selection Committee) : ideas, tools
Lincolnshire is looking to grow its selection from A to ABC teams as we grow our own tournaments, engage in friendlies with other counties and participate in established inter-county competitions. We have a Selection Committee of 6 experienced players, including a few committee members. I'm wondering how other counties approach selections: are all counties doing it the same? How do you keep the selection process in good standing with county and club players, for example?
Comments
Tools. This is a spreadsheet we're starting to use for a certain type of squad-building event of the strongest and/or most in-form players to produce a regular 5-10 table event, about 6-8 a year. It contains a code to autosync with NGS and to sort the names according to the updated NGS data, whilst retaining all the selectors choices.
This is how the spreadsheet looks with dropdown (data validation) for each Selector's choice.
This is a copy of the spreadsheet
[Sample] Lincolnshire CBA Selection Committee : selection for County Days
This is the main code calling two functions to sync from EBU and then to sort the Selector's choices to match the new EBU NGS ordering.