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.