Start Lists

2024-09-10T08:54:48Z

172.69.194.154:

When importing the Start Lists in csv format into Excel, remember to add the suffix to the first line of csv file with 12 semi-colons

;;;;;;;;;;;;

this allows all the C4 and K4 paddler records to be imported to Excel

Also set the import encoding to UTF-8 and update date format to yyyy-mm-dd

- Import Start List data into Excel, remembering to add enough ;;;; characters to reflect the K4 events 
- Add spaces between events, and add correct lane order, e.g. 5, 6, 4, 7 etc. This takes approx. 30 minutes 
- Take in lane draws, seedings, and paddler-specific issues. This can take between 45 minutes to 3 hours, depending on how many selection events there are. For MacGregor it took 45 mins. 
- Send to Cathy for review 
 
Upload start lists 
Generate PDF of start lists 
Once PDF has been approved, update 5000>500 and 2000>200 in the Online Entry System where required, e.g. for Paddle-Ability and Paracanoe races 
Generate data file for HPP system and send to Jon 
Compile programme and other materials for John 
Compile Timetable, Start Lists, Regatta Guide and Programme for the website and upload to the website 
Produce news item on website 
Send cover photo to Trevor for use in Official Results along with PDF of cover for reference 
Produce news item on BC Sprint Racing Committee Facebook page 
Share Facebook news item with Racing Canoe Clubs Facebook page 
Send final regatta bulletin to Team Leaders, including the Regatta Guide, and request payment 

When preparing the start list file for upload, remember to do the following:

Delete all columns to the right of the last populated column of the spreadsheet 
Delete all rows below the last populated column of the spreadsheet 
Replace long hyphens with short hyphens, but not in - R1, - R2, Paddle-Ability - Saturday, Paddle-Ability - Sunday, Canoe A-D - Mixed etc 
Replace , with ; in the CSV file 
Update date format to yyyy-mm-dd<be>

The uploaded file needs to be UTF-8 encoded.

After selecting 'Import timetable / startlist' remember to change event code to correct number in the URL 

Once the Start List has been completed, you can generate a print out using the following URL with the last number changed to the regatta number. Make sure that the PDF is output to A4 not US A4. 

https://canoesprint.britishcanoeing.org.uk/public/default/startlist-print/3 

Once signed off, check the following:
- races have correct categorization, e.g. National Championship, Selection, Paddle-Ability etc
- races have correct distances set, e.g. 5000 > 500 and 2000 > 200
- races have correct naming, e.g. V1 not C1 for Va'a events

=Paddlers with disabilities or special needs=
We occasionally receive requests for paddlers to race in specific lanes, e.g. for hearing or sight impairment, or anxiety. We endeavour to support these requests if they are known about prior to timetabling and the preparation of the Start Lists.

canoesprint-wiki - User contributions [en]

Start Lists