https://canoesprint-wiki.paddleuk.org.uk/w/api.php?action=feedcontributions&feedformat=atom&user=Phil+Caisleycanoesprint-wiki - User contributions [en]2026-06-06T01:24:15ZUser contributionsMediaWiki 1.43.1https://canoesprint-wiki.paddleuk.org.uk/w/index.php?title=Start_Lists&diff=198Start Lists2026-05-19T07:19:10Z<p>Phil Caisley: /* Long distance numbers missing from sequence */</p>
<hr />
<div>=Long distance numbers=<br />
We have sets of 1 up to 199 in both White and Yellow colours. The 3-digit numbers are long and can be an issue in the wind, so it's best to go with the 2-digit boards if we can.<br><br />
=Long distance numbers missing from sequence=<br />
<br />
For the Yellow number boards, we have Y1-Y10, then Y100-Y199, except for the following:<br><br />
<br />
The following numbers have been lost, so should not be used<br><br><br />
Y146<br><br />
Y154<br><br />
Y168<br><br />
W46<br><br />
<br />
=Paddlers with disabilities or special needs=<br />
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.<br />
<br />
=Importing Start List csv files into Excel=<br />
<br />
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<br />
<br />
;;;;;;;;;;;;<br />
<br />
this allows all the C4 and K4 paddler records to be imported to Excel<br />
<br />
Also set the import encoding to UTF-8 and update date format to yyyy-mm-dd<br />
<br />
<br />
- Import Start List data into Excel, remembering to add enough ;;;; characters to reflect the K4 events<br><br />
- Add spaces between events, and add correct lane order, e.g. 5, 6, 4, 7 etc. This takes approx. 30 minutes<br> <br />
- 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.<br><br />
- Send to Cathy for review<br><br />
<br><br />
Upload start lists<br><br />
Generate PDF of start lists<br><br />
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<br><br />
Generate data file for HPP system and send to Jon<br><br />
Compile programme and other materials for John<br><br />
Compile Timetable, Start Lists, Regatta Guide and Programme for the website and upload to the website<br><br />
Produce news item on website<br><br />
Send cover photo to Trevor for use in Official Results along with PDF of cover for reference<br><br />
Produce news item on BC Sprint Racing Committee Facebook page<br><br />
Share Facebook news item with Racing Canoe Clubs Facebook page<br><br />
Send final regatta bulletin to Team Leaders, including the Regatta Guide, and request payment<br><br />
<br />
=Preparing the Start List file for import back into the Online Entry System=<br />
<br />
When preparing the start list file for upload, remember to do the following:<br />
<br />
Delete all columns to the right of the last populated column of the spreadsheet<br><br />
Delete all rows below the last populated column of the spreadsheet<br><br />
Replace long hyphens with short hyphens, but not in - R1, - R2, Paddle-Ability - Saturday, Paddle-Ability - Sunday, Canoe A-D - Mixed etc<br><br />
Replace , with ; in the CSV file<br><br />
Update date format to yyyy-mm-dd<br><br />
<br />
The uploaded file needs to be UTF-8 encoded. After creating the csv file for upload, open it in an application like Notepad++ and check again that the coding is UTF-8, as it won't upload otherwise.<br><br />
<br />
After selecting 'Import timetable / startlist' remember to change event code to correct number in the URL<br><br />
<br />
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.<br><br />
<br />
https://canoesprint.paddleuk.org.uk/public/default/startlist-print/3<br><br />
<br />
=Actions to take after the Start List is signed off=<br />
<br />
Once signed off, check the following:<br />
- races have correct categorization, e.g. National Championship, Selection, Paddle-Ability etc<br />
- races have correct distances set, e.g. 5000 > 500 and 2000 > 200<br />
- races have correct naming, e.g. V1 not C1 for Va'a events<br />
<br />
=Start List to support promotions/demotions=<br />
<br />
There is a special version of the Start List to support promotions and demotions. This includes both the Age Class and any Ability Classes for each paddler.<br />
<br />
https://canoesprint.paddleuk.org.uk/public/default/startlist-wendy/43 <br />
<br />
The number at the end of the link increments by +1 for each regatta.</div>Phil Caisleyhttps://canoesprint-wiki.paddleuk.org.uk/w/index.php?title=Competitions_and_Events&diff=197Competitions and Events2026-04-14T17:18:02Z<p>Phil Caisley: /* Creating Events */</p>
<hr />
<div>=Competitions=<br />
When creating a competition, ensure that the 'Entries close' date is initially entered before today's date. This means that the competition won't be visible to Team Leaders until we're ready to open it up after internal review.<br />
<br />
=Events=<br />
<br />
We aim to provide 6 events for each paddler class at each Regatta. Generally, there's not enough time during the weekend to support more than 6 events, particularly when there are potentially heats and finals for each of these events and allowing for an hour's gap between races for paddlers. <br />
<br />
=Event naming convention=<br />
<br />
When setting events up in the Online Entry System, please, adopt the following naming conventions<br><br />
<br><br />
Reduce the number of characters by shortening the overall length as much as possible:<br><br />
* Men is plural so there is no need for Mens, similarly Women<br><br />
* If you use Mens or Womens, don't add a single quote, not Men's or Women's<br><br />
* Combine adjoining classes with an oblique, not space-plus-space or space-ampersand-space<br><br />
* Combine wider classes with hyphen, not space-to-space<br><br />
* Men Masters can be shortened to Masters<br><br />
* Women Masters can be shortened to WMasters<br><br />
* Reduce Over to O, so Over 44 (7 chars) becomes O44 (3 chars)<br><br />
* Reduce Under to U, so Under 14 (8 chars) becomes U14 (3 chars)<br><br />
* Remove single quote from Va'a, make it Vaa (or Va-a?)<br />
* Consider removing Va'a altogether as Va'a is indicated by boat type V1<br><br />
* Reduce Saturday to Sat<br><br />
* Reduce Sunday to Sun<br><br />
<br><br />
Do not use the following characters:<br><br />
* ampersand (&)<br><br />
* single quote (')<br><br />
* double quote (")<br><br />
* colon (:)<br><br />
* semi-colon (;)<br><br />
* equals (=)<br><br />
* asterix (*)<br><br />
* hash (#)<br><br />
<br><br />
Examples<br><br />
<br><br />
From<br><br />
To<br><br />
<br><br />
Mens A + B<br><br />
Men A/B<br><br />
<br><br />
Womens A + Womens B<br><br />
Women A/B<br><br />
<br><br />
Boys C & D<br><br />
Boys C/D<br><br />
<br><br />
Womens A & B + Girls A & B<br><br />
Women A/B + Girls A/B<br><br />
<br><br />
Womens A & B + Girls A + Girls B<br><br />
Women A/B + Girls A/B<br><br />
<br><br />
Canoe A to D - mixed<br><br />
Canoe A-D - mixed<br><br />
<br><br />
Men Masters Over 44<br><br />
Masters O44<br><br />
<br><br />
Women Masters Over 44<br><br />
WMasters O44<br><br />
<br><br />
Women Masters Over 34 & Over 44<br><br />
WMasters O34/44<br><br />
<br><br />
Girls Under 14<br><br />
Girls U14<br><br />
<br><br />
Boys Under 18 + Boys Under 16<br><br />
Boys U18/16<br><br />
<br><br />
Para Men Va'a VL1-3<br><br />
Para Men Vaa VL1-3<br><br />
<br><br />
Para Men Va'a VL1-3<br><br />
Para Men Vaa VL1-3<br><br />
<br><br />
Para Men Va'a VL1-3<br><br />
Para Men VL1-3<br><br />
<br><br />
Paddle-Ability - Saturday<br><br />
Paddle-Ability - Sat<br><br />
<br />
==Creating Events==<br />
When setting up events, remember to include the event category, e.g. Mini-sprint series, Paddle-ability, National Championship, Selection etc. These categories appear on the Start Lists next to each event.<br />
<br />
==Racing-up Categories==<br />
Different racing-up categories apply for Selection events compared to National Championship events, e.g. in an U18/16 event, U14s are not eligible for selection and so should not be included as a valid racing-up class.<br />
<br />
==Mixed Crew Events==<br />
<br />
The system allows us to control what percentage of the correct class needs to be in each crew boat for the entry to be valid.<br />
<br />
This can be set up using the 'Ratio' value.<br />
<br />
0% or NULL means not applicable.<br />
<br />
25% means at least one paddler has to be from the higher class, i.e. not racing-up class.<br />
<br />
50% means at least two paddlers have to be from the higher class, i.e. not racing-up class.<br />
<br />
The Ratio can also be used for mixed crew boats. In this instance, all the gender classes should be split between the higher class and the racing-up classes, i.e. men or boys classes in one column, women or girls classes in the other. It doens't match which way round these are. You can then apply a 50% ratio value.<br />
<br />
During entries, the system enforces the ratio and throws up an error message.<br />
<br />
==Merging Events==<br />
1. The timetable has to be truncated. You can truncate the timetable from import menu.<br />
2. In events setting you just select the event to merge and system automatically rename the event and merge the entries from selected events.<br />
3. Older events are automatically deleted.<br />
4. Edit the event name to be more prettier<br />
<br />
<br><br />
<br><br />
<br />
=Combined National Championship events and medals=<br />
<br />
Do you know if the Seniors and U23 will race together with results separated, or will they have separate races? Similarly, will the Senior / U23 Mixed K2 follow the same format?<br><br />
<br />
For the events shown on the event schedule as being across both Senior & U23, such as the K1 200m, they will be run as one combined event. With one result, however, as these events are National Championship events, the x3 medals will be awarded for each age group. That is the first three fastest seniors, and the first three fastest U23 athletes.<br><br />
<br />
For crew boats, the age group will be the oldest age group in the boat, i.e. in a K2 or K4, if all are U23, they will be considered as U23; if, however, one athlete is a Senior and others U23, they will be considered for medals as a senior boat.<br><br />
<br />
The Mixed Men/Women K2 500m is a different format as they are shown on the event schedule as separate events, each age group will be run separately.<br></div>Phil Caisleyhttps://canoesprint-wiki.paddleuk.org.uk/w/index.php?title=Start_Lists&diff=196Start Lists2026-03-31T21:16:01Z<p>Phil Caisley: /* Long distance numbers and numbers missing from the sequence */</p>
<hr />
<div>=Long distance numbers=<br />
We have sets of 1 up to 199 in both White and Yellow colours. The 3-digit numbers are long and can be an issue in the wind, so it's best to go with the 2-digit boards if we can.<br><br />
=Long distance numbers missing from sequence=<br />
The following numbers have been lost, so should not be used<br><br><br />
Y146<br><br />
Y154<br><br />
Y168<br><br />
W46<br><br />
<br />
=Paddlers with disabilities or special needs=<br />
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.<br />
<br />
=Importing Start List csv files into Excel=<br />
<br />
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<br />
<br />
;;;;;;;;;;;;<br />
<br />
this allows all the C4 and K4 paddler records to be imported to Excel<br />
<br />
Also set the import encoding to UTF-8 and update date format to yyyy-mm-dd<br />
<br />
<br />
- Import Start List data into Excel, remembering to add enough ;;;; characters to reflect the K4 events<br><br />
- Add spaces between events, and add correct lane order, e.g. 5, 6, 4, 7 etc. This takes approx. 30 minutes<br> <br />
- 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.<br><br />
- Send to Cathy for review<br><br />
<br><br />
Upload start lists<br><br />
Generate PDF of start lists<br><br />
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<br><br />
Generate data file for HPP system and send to Jon<br><br />
Compile programme and other materials for John<br><br />
Compile Timetable, Start Lists, Regatta Guide and Programme for the website and upload to the website<br><br />
Produce news item on website<br><br />
Send cover photo to Trevor for use in Official Results along with PDF of cover for reference<br><br />
Produce news item on BC Sprint Racing Committee Facebook page<br><br />
Share Facebook news item with Racing Canoe Clubs Facebook page<br><br />
Send final regatta bulletin to Team Leaders, including the Regatta Guide, and request payment<br><br />
<br />
=Preparing the Start List file for import back into the Online Entry System=<br />
<br />
When preparing the start list file for upload, remember to do the following:<br />
<br />
Delete all columns to the right of the last populated column of the spreadsheet<br><br />
Delete all rows below the last populated column of the spreadsheet<br><br />
Replace long hyphens with short hyphens, but not in - R1, - R2, Paddle-Ability - Saturday, Paddle-Ability - Sunday, Canoe A-D - Mixed etc<br><br />
Replace , with ; in the CSV file<br><br />
Update date format to yyyy-mm-dd<br><br />
<br />
The uploaded file needs to be UTF-8 encoded. After creating the csv file for upload, open it in an application like Notepad++ and check again that the coding is UTF-8, as it won't upload otherwise.<br><br />
<br />
After selecting 'Import timetable / startlist' remember to change event code to correct number in the URL<br><br />
<br />
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.<br><br />
<br />
https://canoesprint.paddleuk.org.uk/public/default/startlist-print/3<br><br />
<br />
=Actions to take after the Start List is signed off=<br />
<br />
Once signed off, check the following:<br />
- races have correct categorization, e.g. National Championship, Selection, Paddle-Ability etc<br />
- races have correct distances set, e.g. 5000 > 500 and 2000 > 200<br />
- races have correct naming, e.g. V1 not C1 for Va'a events<br />
<br />
=Start List to support promotions/demotions=<br />
<br />
There is a special version of the Start List to support promotions and demotions. This includes both the Age Class and any Ability Classes for each paddler.<br />
<br />
https://canoesprint.paddleuk.org.uk/public/default/startlist-wendy/43 <br />
<br />
The number at the end of the link increments by +1 for each regatta.</div>Phil Caisleyhttps://canoesprint-wiki.paddleuk.org.uk/w/index.php?title=Procedure_at_Entries_Close&diff=195Procedure at Entries Close2025-12-11T22:08:07Z<p>Phil Caisley: /* Apply event merges and prepare coloured-up file for timetabling */</p>
<hr />
<div>=Procedures before entries close=<br />
Chase Team Leaders to resolve Unresolved and Incomplete Boats<br><br />
<br />
=Procedures at entries close=<br />
==De-duplicate or approve Incomplete or Unconfirmed Entries==<br />
- Take screengrabs of entries summary list by club and any incomplete and unresolved boats<br><br />
- Accept incomplete entries and unresolved entries<br><br />
- If there are duplicate entries or if you need to accept Unconfirmed or Incomplete entries, use the following link syntax substituting the number at the end of the link with the number for the specific event<br />
https://canoesprint.paddleuk.org.uk/competition/events/checkup/42<br><br />
- At present, the entry costs associated with Incomplete or Unconfirmed entries, which are subsequently accepted using this Admin feature, aren't currently being charged back to the respective clubs or squads.<br> <br />
- Take screengrabs of entries summary list by club again<br><br />
- Generate the event list (heats and finals) from Online Entry System, remembering to select the correct event number in the URL, paste it into Excel, and send it to Cathy<br><br />
<br><br />
<br />
==Identify event merges and request seeding lists==<br />
Review the events list and proposed numbers of heats and finals<br><br />
Identify those events that won't run and for which refunds are required<br><br />
Identify those events that have limited entries<br><br />
Identify where events with limited entry numbers can be merged<br><br />
For seeded events, prepare lists and send these to the individuals who will prepare those lists<br><br />
- Seniors<br><br />
- Juniors<br><br />
- Canoes<br><br />
- Paracanoe<br><br />
- Paddle-Ability<br><br />
Identify where events with small entry numbers, could potentially be run concurrently with separate results, i.e. not merged<br><br />
<br />
==Apply event merges and prepare coloured-up file for timetabling==<br />
Note - Applying Merges and generating the Coloured-up file for the timetabling process takes about 2 hours<br> <br />
- Merges take approx 30-50 mins<br><br />
-- When merging, remember to copy the Classes, Racing-up Classes, and Event names to a separate file, as the merge function doesn't merge these correctly, so prepare these outside of the system<br><br />
- Adding in days takes approx 20-40 mins (using Excel filters really speeds up the process)<br> <br />
- Colouring up takes approx 20-50 mins (sort by Event type only to prepare file)<br> <br />
<br><br />
- Regenerate event list<br><br />
- Paste it into Excel<br><br />
- Delete system-generated Progression information. This will be corrected and added back in later in the process<br><br />
- Add in a Correct Distance column to supplement the system workaround distances to help with timetabling<br><br />
- Add days (not dates) for each event based on the event schedule, e.g. SAT, SUN, MON. These will be corrected to dates later in the process, but it's easier to work with these as Days for Timetabling<br><br />
- Colour up the events in Excel, ideally showing all relevant colours for Mixed events<br><br />
- Sort the file by Day, then by Event, then by Boat Type, then by Correct Distance<br><br />
<br></div>Phil Caisleyhttps://canoesprint-wiki.paddleuk.org.uk/w/index.php?title=Start_Lists&diff=194Start Lists2025-12-11T22:06:29Z<p>Phil Caisley: /* Preparing the Start List file for import back into the Online Entry System */</p>
<hr />
<div>=Long distance numbers missing from sequence=<br />
The following numbers have been lost, so should not be used<br><br><br />
Y146<br><br />
Y154<br><br />
Y168<br><br />
W46<br><br />
<br />
=Paddlers with disabilities or special needs=<br />
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.<br />
<br />
=Importing Start List csv files into Excel=<br />
<br />
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<br />
<br />
;;;;;;;;;;;;<br />
<br />
this allows all the C4 and K4 paddler records to be imported to Excel<br />
<br />
Also set the import encoding to UTF-8 and update date format to yyyy-mm-dd<br />
<br />
<br />
- Import Start List data into Excel, remembering to add enough ;;;; characters to reflect the K4 events<br><br />
- Add spaces between events, and add correct lane order, e.g. 5, 6, 4, 7 etc. This takes approx. 30 minutes<br> <br />
- 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.<br><br />
- Send to Cathy for review<br><br />
<br><br />
Upload start lists<br><br />
Generate PDF of start lists<br><br />
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<br><br />
Generate data file for HPP system and send to Jon<br><br />
Compile programme and other materials for John<br><br />
Compile Timetable, Start Lists, Regatta Guide and Programme for the website and upload to the website<br><br />
Produce news item on website<br><br />
Send cover photo to Trevor for use in Official Results along with PDF of cover for reference<br><br />
Produce news item on BC Sprint Racing Committee Facebook page<br><br />
Share Facebook news item with Racing Canoe Clubs Facebook page<br><br />
Send final regatta bulletin to Team Leaders, including the Regatta Guide, and request payment<br><br />
<br />
=Preparing the Start List file for import back into the Online Entry System=<br />
<br />
When preparing the start list file for upload, remember to do the following:<br />
<br />
Delete all columns to the right of the last populated column of the spreadsheet<br><br />
Delete all rows below the last populated column of the spreadsheet<br><br />
Replace long hyphens with short hyphens, but not in - R1, - R2, Paddle-Ability - Saturday, Paddle-Ability - Sunday, Canoe A-D - Mixed etc<br><br />
Replace , with ; in the CSV file<br><br />
Update date format to yyyy-mm-dd<br><br />
<br />
The uploaded file needs to be UTF-8 encoded. After creating the csv file for upload, open it in an application like Notepad++ and check again that the coding is UTF-8, as it won't upload otherwise.<br><br />
<br />
After selecting 'Import timetable / startlist' remember to change event code to correct number in the URL<br><br />
<br />
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.<br><br />
<br />
https://canoesprint.paddleuk.org.uk/public/default/startlist-print/3<br><br />
<br />
=Actions to take after the Start List is signed off=<br />
<br />
Once signed off, check the following:<br />
- races have correct categorization, e.g. National Championship, Selection, Paddle-Ability etc<br />
- races have correct distances set, e.g. 5000 > 500 and 2000 > 200<br />
- races have correct naming, e.g. V1 not C1 for Va'a events<br />
<br />
=Start List to support promotions/demotions=<br />
<br />
There is a special version of the Start List to support promotions and demotions. This includes both the Age Class and any Ability Classes for each paddler.<br />
<br />
https://canoesprint.paddleuk.org.uk/public/default/startlist-wendy/43 <br />
<br />
The number at the end of the link increments by +1 for each regatta.</div>Phil Caisleyhttps://canoesprint-wiki.paddleuk.org.uk/w/index.php?title=Timetable&diff=193Timetable2025-12-11T22:05:16Z<p>Phil Caisley: /* Preparing timetable for sign-off before upload */</p>
<hr />
<div>= Review timetable for issues/clashes =<br />
<br />
<br />
Look for the following issues when reviewing the timetable<br><br />
- sufficient K4s available - *see Crew Boats section for the number of available boats. Boats are blocked out for 1 hour*<br><br />
- event spacing between Heats, Finals, next Heats - *ensure min 45 mins, ideally 60 mins between Ability Class/Age Class events, and 90 mins between Selection events*<br><br />
- sufficient time between distance stepdowns - *when stepping down a distance (1000 > 500, 1000 > 200, 500 > 200) keep at least 8 mins between events, particularly for 1000 > 200*<br><br />
- that single finals are marked F, not F1/F2<br><br />
- possible cross-class clashes, where avoidable, e.g. U18/16 vs A/B<br><br />
<br />
=Review timetable=<br />
===First review===<br />
Checking draft Timetable - first review<br><br />
- Check that events are ideally 45+ mins apart using colouring as the principle guide<br><br />
- Check enough time space between reducing distance, i.e. 1000 > 500, 1000 > 200, 500 > 200 to allowance course to be clear of other events<br><br />
- Check that if we don't have Final 2 (F2) or Final 3 (F3) races, then the event description shows F not F1, F2, or F3<br><br />
- Check Para runs are in correct sequence, i.e. R1, R2, R3<br><br />
- Identify and correct event title discrepancies against event naming convention<br><br />
- Add times<br />
- Add race numbers<br />
- Check that there is an hour between K4 usage. We have 10 skinny Plastex boats and 16 more stable Commanders<br />
<br />
<br><br />
- Merged the Girls A/B and Girls C K4 500m events and updated the spreadsheet name and number of entries<br><br />
- Checked that events are ideally 45+ mins apart<br><br />
- Checked enough time space between reducing distance, i.e. 1000 > 500, 1000 > 200, 500 > 200 to allowance course to be clear of other events<br><br />
- Checked that if we don't have Final 2 (F2) or Final 3 (F3) races, then the event description shows F not F1, F2, or F3<br><br />
- Checked that there is an hour between K4 usage based on available boats<br><br />
- Added event times<br><br />
- Added race numbers and can confirm that we have 253 races<br><br />
- Added progressions info. I have marked a few queries in column K, which are highlighted in yellow. Please update these progressions if correct<br><br />
- Updated days to dates in yyyy-mm-dd format ready for upload<br><br />
- Dropped a note to Matej to inform him to expect a Start Lists request later today<br><br />
<br />
===Second review===<br />
Checking draft Timetable - second review<br><br />
- Check corrections<br><br />
- Check time gaps again<br><br />
- Add Progressions info from the Progressions spreadsheet, if not already added<br><br />
- Add dates in place of FRI/SAT/SUN in yyyy-mm-dd format<br><br />
- Update race numbers<br />
- Add information lines, e.g. course opens, course closes, paralympic events etc<br><br />
- Delete extraneous rows used for time separation, when no longer required<br><br />
- Remove columns to the right of the data<br><br />
- Remove rows below the data<br><br />
<br />
==Upload Timetable to Online Entry System==<br />
Check online view<br><br />
Once approved, ask Matej to generate start lists<br><br />
<br />
<br />
= Preparing timetable for sign-off before upload =<br />
<br />
When preparing the timetable for upload, remember to do the following:<br><br />
- Delete all columns to the right of the last populated column of the spreadsheet<br><br />
- Delete all rows below the last populated column of the spreadsheet<br><br />
- Replace long hyphens with short hyphens, but not in - R1, - R2, Paddle-Ability - Saturday, Paddle-Ability - Sunday, Canoe A-D - Mixed etc<br><br />
- Replace , with ; in the CSV file<br><br />
- Update date format to yyyy-mm-dd<br />
- The uploaded file needs to be UTF-8 encoded. After creating the csv file, open it in an application like Notepad++ and check again that the coding is UTF-8, as it won't upload otherwise<br />
<br />
After selecting 'Import timetable / startlist' remember to change event code to correct number in URL, e.g. change from 10 to whatever the competition number is<br><br />
https://canoesprint.paddleuk.org.uk/import/offline/default/10<br><br />
<br><br />
Work through each error one by one, generally they relate to a difference between the Event name [Discipline] stated on the upload file compared to the Event name in the system. Correcting the latter allows you to progress. The error codes state the line number on the .csv file.<br />
<br />
For non-event entries in the timetable, use the following syntax<br><br><br />
<code>;;;;V;2021-09-04;08:00;;;Course Open</code><br><br />
<code>;;;;V;2021-09-04;08:15;;;Start Gate Practice at 200m Start</code><br><br />
<code>;;;;V;2021-09-04;08:45;;;Course Cleared</code><br />
<br />
Each row needs to be preceded by a 0, i.e. Event number = 0<br />
<br />
= Post-upload review = <br />
<br />
Check that the correct progression descriptions are applied. Note: when it states U18/U16, that's referring to U16 only when they are combined with U18s.<br> <br />
Check that the numbers progressing do add up and that the number of finals matches what we have allowed.<br> <br />
Do a final check on the time between heats/final and next events.<br></div>Phil Caisleyhttps://canoesprint-wiki.paddleuk.org.uk/w/index.php?title=Start_Lists&diff=192Start Lists2025-08-19T19:37:09Z<p>Phil Caisley: /* Long distance numbers missing from sequence */</p>
<hr />
<div>=Long distance numbers missing from sequence=<br />
The following numbers have been lost, so should not be used<br><br><br />
Y146<br><br />
Y154<br><br />
Y168<br><br />
W46<br><br />
<br />
=Paddlers with disabilities or special needs=<br />
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.<br />
<br />
=Importing Start List csv files into Excel=<br />
<br />
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<br />
<br />
;;;;;;;;;;;;<br />
<br />
this allows all the C4 and K4 paddler records to be imported to Excel<br />
<br />
Also set the import encoding to UTF-8 and update date format to yyyy-mm-dd<br />
<br />
<br />
- Import Start List data into Excel, remembering to add enough ;;;; characters to reflect the K4 events<br><br />
- Add spaces between events, and add correct lane order, e.g. 5, 6, 4, 7 etc. This takes approx. 30 minutes<br> <br />
- 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.<br><br />
- Send to Cathy for review<br><br />
<br><br />
Upload start lists<br><br />
Generate PDF of start lists<br><br />
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<br><br />
Generate data file for HPP system and send to Jon<br><br />
Compile programme and other materials for John<br><br />
Compile Timetable, Start Lists, Regatta Guide and Programme for the website and upload to the website<br><br />
Produce news item on website<br><br />
Send cover photo to Trevor for use in Official Results along with PDF of cover for reference<br><br />
Produce news item on BC Sprint Racing Committee Facebook page<br><br />
Share Facebook news item with Racing Canoe Clubs Facebook page<br><br />
Send final regatta bulletin to Team Leaders, including the Regatta Guide, and request payment<br><br />
<br />
=Preparing the Start List file for import back into the Online Entry System=<br />
<br />
When preparing the start list file for upload, remember to do the following:<br />
<br />
Delete all columns to the right of the last populated column of the spreadsheet<br><br />
Delete all rows below the last populated column of the spreadsheet<br><br />
Replace long hyphens with short hyphens, but not in - R1, - R2, Paddle-Ability - Saturday, Paddle-Ability - Sunday, Canoe A-D - Mixed etc<br><br />
Replace , with ; in the CSV file<br><br />
Update date format to yyyy-mm-dd<be><br />
<br />
The uploaded file needs to be UTF-8 encoded.<br />
<br />
After selecting 'Import timetable / startlist' remember to change event code to correct number in the URL<br><br />
<br />
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.<br><br />
<br />
https://canoesprint.paddleuk.org.uk/public/default/startlist-print/3<br><br />
<br />
=Actions to take after the Start List is signed off=<br />
<br />
Once signed off, check the following:<br />
- races have correct categorization, e.g. National Championship, Selection, Paddle-Ability etc<br />
- races have correct distances set, e.g. 5000 > 500 and 2000 > 200<br />
- races have correct naming, e.g. V1 not C1 for Va'a events<br />
<br />
=Start List to support promotions/demotions=<br />
<br />
There is a special version of the Start List to support promotions and demotions. This includes both the Age Class and any Ability Classes for each paddler.<br />
<br />
https://canoesprint.paddleuk.org.uk/public/default/startlist-wendy/43 <br />
<br />
The number at the end of the link increments by +1 for each regatta.</div>Phil Caisleyhttps://canoesprint-wiki.paddleuk.org.uk/w/index.php?title=Start_Lists&diff=191Start Lists2025-08-18T20:44:00Z<p>Phil Caisley: </p>
<hr />
<div>=Long distance numbers missing from sequence=<br />
The following numbers have been lost, so should not be used<br><br><br />
Y146<br><br />
Y168<br><br />
W46<br><br />
<br />
=Paddlers with disabilities or special needs=<br />
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.<br />
<br />
=Importing Start List csv files into Excel=<br />
<br />
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<br />
<br />
;;;;;;;;;;;;<br />
<br />
this allows all the C4 and K4 paddler records to be imported to Excel<br />
<br />
Also set the import encoding to UTF-8 and update date format to yyyy-mm-dd<br />
<br />
<br />
- Import Start List data into Excel, remembering to add enough ;;;; characters to reflect the K4 events<br><br />
- Add spaces between events, and add correct lane order, e.g. 5, 6, 4, 7 etc. This takes approx. 30 minutes<br> <br />
- 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.<br><br />
- Send to Cathy for review<br><br />
<br><br />
Upload start lists<br><br />
Generate PDF of start lists<br><br />
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<br><br />
Generate data file for HPP system and send to Jon<br><br />
Compile programme and other materials for John<br><br />
Compile Timetable, Start Lists, Regatta Guide and Programme for the website and upload to the website<br><br />
Produce news item on website<br><br />
Send cover photo to Trevor for use in Official Results along with PDF of cover for reference<br><br />
Produce news item on BC Sprint Racing Committee Facebook page<br><br />
Share Facebook news item with Racing Canoe Clubs Facebook page<br><br />
Send final regatta bulletin to Team Leaders, including the Regatta Guide, and request payment<br><br />
<br />
=Preparing the Start List file for import back into the Online Entry System=<br />
<br />
When preparing the start list file for upload, remember to do the following:<br />
<br />
Delete all columns to the right of the last populated column of the spreadsheet<br><br />
Delete all rows below the last populated column of the spreadsheet<br><br />
Replace long hyphens with short hyphens, but not in - R1, - R2, Paddle-Ability - Saturday, Paddle-Ability - Sunday, Canoe A-D - Mixed etc<br><br />
Replace , with ; in the CSV file<br><br />
Update date format to yyyy-mm-dd<be><br />
<br />
The uploaded file needs to be UTF-8 encoded.<br />
<br />
After selecting 'Import timetable / startlist' remember to change event code to correct number in the URL<br><br />
<br />
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.<br><br />
<br />
https://canoesprint.paddleuk.org.uk/public/default/startlist-print/3<br><br />
<br />
=Actions to take after the Start List is signed off=<br />
<br />
Once signed off, check the following:<br />
- races have correct categorization, e.g. National Championship, Selection, Paddle-Ability etc<br />
- races have correct distances set, e.g. 5000 > 500 and 2000 > 200<br />
- races have correct naming, e.g. V1 not C1 for Va'a events<br />
<br />
=Start List to support promotions/demotions=<br />
<br />
There is a special version of the Start List to support promotions and demotions. This includes both the Age Class and any Ability Classes for each paddler.<br />
<br />
https://canoesprint.paddleuk.org.uk/public/default/startlist-wendy/43 <br />
<br />
The number at the end of the link increments by +1 for each regatta.</div>Phil Caisleyhttps://canoesprint-wiki.paddleuk.org.uk/w/index.php?title=Timetable&diff=190Timetable2025-07-01T19:41:47Z<p>Phil Caisley: </p>
<hr />
<div>= Review timetable for issues/clashes =<br />
<br />
<br />
Look for the following issues when reviewing the timetable<br><br />
- sufficient K4s available - *see Crew Boats section for the number of available boats. Boats are blocked out for 1 hour*<br><br />
- event spacing between Heats, Finals, next Heats - *ensure min 45 mins, ideally 60 mins between Ability Class/Age Class events, and 90 mins between Selection events*<br><br />
- sufficient time between distance stepdowns - *when stepping down a distance (1000 > 500, 1000 > 200, 500 > 200) keep at least 8 mins between events, particularly for 1000 > 200*<br><br />
- that single finals are marked F, not F1/F2<br><br />
- possible cross-class clashes, where avoidable, e.g. U18/16 vs A/B<br><br />
<br />
=Review timetable=<br />
===First review===<br />
Checking draft Timetable - first review<br><br />
- Check that events are ideally 45+ mins apart using colouring as the principle guide<br><br />
- Check enough time space between reducing distance, i.e. 1000 > 500, 1000 > 200, 500 > 200 to allowance course to be clear of other events<br><br />
- Check that if we don't have Final 2 (F2) or Final 3 (F3) races, then the event description shows F not F1, F2, or F3<br><br />
- Check Para runs are in correct sequence, i.e. R1, R2, R3<br><br />
- Identify and correct event title discrepancies against event naming convention<br><br />
- Add times<br />
- Add race numbers<br />
- Check that there is an hour between K4 usage. We have 10 skinny Plastex boats and 16 more stable Commanders<br />
<br />
<br><br />
- Merged the Girls A/B and Girls C K4 500m events and updated the spreadsheet name and number of entries<br><br />
- Checked that events are ideally 45+ mins apart<br><br />
- Checked enough time space between reducing distance, i.e. 1000 > 500, 1000 > 200, 500 > 200 to allowance course to be clear of other events<br><br />
- Checked that if we don't have Final 2 (F2) or Final 3 (F3) races, then the event description shows F not F1, F2, or F3<br><br />
- Checked that there is an hour between K4 usage based on available boats<br><br />
- Added event times<br><br />
- Added race numbers and can confirm that we have 253 races<br><br />
- Added progressions info. I have marked a few queries in column K, which are highlighted in yellow. Please update these progressions if correct<br><br />
- Updated days to dates in yyyy-mm-dd format ready for upload<br><br />
- Dropped a note to Matej to inform him to expect a Start Lists request later today<br><br />
<br />
===Second review===<br />
Checking draft Timetable - second review<br><br />
- Check corrections<br><br />
- Check time gaps again<br><br />
- Add Progressions info from the Progressions spreadsheet, if not already added<br><br />
- Add dates in place of FRI/SAT/SUN in yyyy-mm-dd format<br><br />
- Update race numbers<br />
- Add information lines, e.g. course opens, course closes, paralympic events etc<br><br />
- Delete extraneous rows used for time separation, when no longer required<br><br />
- Remove columns to the right of the data<br><br />
- Remove rows below the data<br><br />
<br />
==Upload Timetable to Online Entry System==<br />
Check online view<br><br />
Once approved, ask Matej to generate start lists<br><br />
<br />
<br />
= Preparing timetable for sign-off before upload =<br />
<br />
When preparing the timetable for upload, remember to do the following:<br><br />
- Delete all columns to the right of the last populated column of the spreadsheet<br><br />
- Delete all rows below the last populated column of the spreadsheet<br><br />
- Replace long hyphens with short hyphens, but not in - R1, - R2, Paddle-Ability - Saturday, Paddle-Ability - Sunday, Canoe A-D - Mixed etc<br><br />
- Replace , with ; in the CSV file<br><br />
- Update date format to yyyy-mm-dd<br />
- The uploaded file needs to be UTF-8 encoded.<br />
<br />
After selecting 'Import timetable / startlist' remember to change event code to correct number in URL, e.g. change from 10 to whatever the competition number is<br><br />
https://canoesprint.paddleuk.org.uk/import/offline/default/10<br><br />
<br><br />
Work through each error one by one, generally they relate to a difference between the Event name [Discipline] stated on the upload file compared to the Event name in the system. Correcting the latter allows you to progress. The error codes state the line number on the .csv file.<br />
<br />
For non-event entries in the timetable, use the following syntax<br><br><br />
<code>;;;;V;2021-09-04;08:00;;;Course Open</code><br><br />
<code>;;;;V;2021-09-04;08:15;;;Start Gate Practice at 200m Start</code><br><br />
<code>;;;;V;2021-09-04;08:45;;;Course Cleared</code><br />
<br />
Each row needs to be preceded by a 0, i.e. Event number = 0<br />
<br />
= Post-upload review = <br />
<br />
Check that the correct progression descriptions are applied. Note: when it states U18/U16, that's referring to U16 only when they are combined with U18s.<br> <br />
Check that the numbers progressing do add up and that the number of finals matches what we have allowed.<br> <br />
Do a final check on the time between heats/final and next events.<br></div>Phil Caisleyhttps://canoesprint-wiki.paddleuk.org.uk/w/index.php?title=Competitions_and_Events&diff=189Competitions and Events2025-06-19T13:01:33Z<p>Phil Caisley: /* Event naming convention */</p>
<hr />
<div>=Competitions=<br />
When creating a competition, ensure that the 'Entries close' date is initially entered before today's date. This means that the competition won't be visible to Team Leaders until we're ready to open it up after internal review.<br />
<br />
=Events=<br />
<br />
We aim to provide 6 events for each paddler class at each Regatta. Generally, there's not enough time during the weekend to support more than 6 events, particularly when there are potentially heats and finals for each of these events and allowing for an hour's gap between races for paddlers. <br />
<br />
=Event naming convention=<br />
<br />
When setting events up in the Online Entry System, please, adopt the following naming conventions<br><br />
<br><br />
Reduce the number of characters by shortening the overall length as much as possible:<br><br />
* Men is plural so there is no need for Mens, similarly Women<br><br />
* If you use Mens or Womens, don't add a single quote, not Men's or Women's<br><br />
* Combine adjoining classes with an oblique, not space-plus-space or space-ampersand-space<br><br />
* Combine wider classes with hyphen, not space-to-space<br><br />
* Men Masters can be shortened to Masters<br><br />
* Women Masters can be shortened to WMasters<br><br />
* Reduce Over to O, so Over 44 (7 chars) becomes O44 (3 chars)<br><br />
* Reduce Under to U, so Under 14 (8 chars) becomes U14 (3 chars)<br><br />
* Remove single quote from Va'a, make it Vaa (or Va-a?)<br />
* Consider removing Va'a altogether as Va'a is indicated by boat type V1<br><br />
* Reduce Saturday to Sat<br><br />
* Reduce Sunday to Sun<br><br />
<br><br />
Do not use the following characters:<br><br />
* ampersand (&)<br><br />
* single quote (')<br><br />
* double quote (")<br><br />
* colon (:)<br><br />
* semi-colon (;)<br><br />
* equals (=)<br><br />
* asterix (*)<br><br />
* hash (#)<br><br />
<br><br />
Examples<br><br />
<br><br />
From<br><br />
To<br><br />
<br><br />
Mens A + B<br><br />
Men A/B<br><br />
<br><br />
Womens A + Womens B<br><br />
Women A/B<br><br />
<br><br />
Boys C & D<br><br />
Boys C/D<br><br />
<br><br />
Womens A & B + Girls A & B<br><br />
Women A/B + Girls A/B<br><br />
<br><br />
Womens A & B + Girls A + Girls B<br><br />
Women A/B + Girls A/B<br><br />
<br><br />
Canoe A to D - mixed<br><br />
Canoe A-D - mixed<br><br />
<br><br />
Men Masters Over 44<br><br />
Masters O44<br><br />
<br><br />
Women Masters Over 44<br><br />
WMasters O44<br><br />
<br><br />
Women Masters Over 34 & Over 44<br><br />
WMasters O34/44<br><br />
<br><br />
Girls Under 14<br><br />
Girls U14<br><br />
<br><br />
Boys Under 18 + Boys Under 16<br><br />
Boys U18/16<br><br />
<br><br />
Para Men Va'a VL1-3<br><br />
Para Men Vaa VL1-3<br><br />
<br><br />
Para Men Va'a VL1-3<br><br />
Para Men Vaa VL1-3<br><br />
<br><br />
Para Men Va'a VL1-3<br><br />
Para Men VL1-3<br><br />
<br><br />
Paddle-Ability - Saturday<br><br />
Paddle-Ability - Sat<br><br />
<br />
==Creating Events==<br />
When setting up events, remember to include the event category, e.g. Mini-sprint series, Paddle-ability, National Championship, Selection etc. These categories appear on the Start Lists next to each event.<br />
<br />
==Mixed Crew Events==<br />
<br />
The system allows us to control what percentage of the correct class needs to be in each crew boat for the entry to be valid.<br />
<br />
This can be set up using the 'Ratio' value.<br />
<br />
0% or NULL means not applicable.<br />
<br />
25% means at least one paddler has to be from the higher class, i.e. not racing-up class.<br />
<br />
50% means at least two paddlers have to be from the higher class, i.e. not racing-up class.<br />
<br />
The Ratio can also be used for mixed crew boats. In this instance, all the gender classes should be split between the higher class and the racing-up classes, i.e. men or boys classes in one column, women or girls classes in the other. It doens't match which way round these are. You can then apply a 50% ratio value.<br />
<br />
During entries, the system enforces the ratio and throws up an error message.<br />
<br />
==Merging Events==<br />
1. The timetable has to be truncated. You can truncate the timetable from import menu.<br />
2. In events setting you just select the event to merge and system automatically rename the event and merge the entries from selected events.<br />
3. Older events are automatically deleted.<br />
4. Edit the event name to be more prettier<br />
<br />
<br><br />
<br><br />
<br />
=Combined National Championship events and medals=<br />
<br />
Do you know if the Seniors and U23 will race together with results separated, or will they have separate races? Similarly, will the Senior / U23 Mixed K2 follow the same format?<br><br />
<br />
For the events shown on the event schedule as being across both Senior & U23, such as the K1 200m, they will be run as one combined event. With one result, however, as these events are National Championship events, the x3 medals will be awarded for each age group. That is the first three fastest seniors, and the first three fastest U23 athletes.<br><br />
<br />
For crew boats, the age group will be the oldest age group in the boat, i.e. in a K2 or K4, if all are U23, they will be considered as U23; if, however, one athlete is a Senior and others U23, they will be considered for medals as a senior boat.<br><br />
<br />
The Mixed Men/Women K2 500m is a different format as they are shown on the event schedule as separate events, each age group will be run separately.<br></div>Phil Caisleyhttps://canoesprint-wiki.paddleuk.org.uk/w/index.php?title=Competitions_and_Events&diff=188Competitions and Events2025-06-19T12:59:30Z<p>Phil Caisley: </p>
<hr />
<div>=Competitions=<br />
When creating a competition, ensure that the 'Entries close' date is initially entered before today's date. This means that the competition won't be visible to Team Leaders until we're ready to open it up after internal review.<br />
<br />
=Events=<br />
<br />
We aim to provide 6 events for each paddler class at each Regatta. Generally, there's not enough time during the weekend to support more than 6 events, particularly when there are potentially heats and finals for each of these events and allowing for an hour's gap between races for paddlers. <br />
<br />
=Event naming convention=<br />
<br />
When setting events up in the Online Entry System, please, adopt the following naming conventions<br><br />
<br><br />
Reduce the number of characters by shortening the overall length as much as possible:<br><br />
• Men is plural so there is no need for Mens, similarly Women<br><br />
• If you use Mens or Womens, don't add a single quote, not Men's or Women's<br><br />
• Combine adjoining classes with an oblique, not space-plus-space or space-ampersand-space<br><br />
• Combine wider classes with hyphen, not space-to-space<br><br />
• Men Masters can be shortened to Masters<br><br />
• Women Masters can be shortened to WMasters<br><br />
• Reduce Over to O, so Over 44 (7 chars) becomes O44 (3 chars)<br><br />
• Reduce Under to U, so Under 14 (8 chars) becomes U14 (3 chars)<br><br />
• Remove single quote from Va'a, make it Vaa (or Va-a?)<br />
• Consider removing Va'a altogether as Va'a is indicated by boat type V1<br><br />
• Reduce Saturday to Sat<br><br />
• Reduce Sunday to Sun<br><br />
<br><br />
Do not use the following characters:<br><br />
• ampersand (&)<br><br />
• single quote (')<br><br />
• double quote (")<br><br />
• colon (:)<br><br />
• semi-colon (;)<br><br />
• equals (=)<br><br />
• asterix (*)<br><br />
• hash (#)<br><br />
<br><br />
Examples<br><br />
<br><br />
From<br><br />
To<br><br />
<br><br />
Mens A + B<br><br />
Men A/B<br><br />
<br><br />
Womens A + Womens B<br><br />
Women A/B<br><br />
<br><br />
Boys C & D<br><br />
Boys C/D<br><br />
<br><br />
Womens A & B + Girls A & B<br><br />
Women A/B + Girls A/B<br><br />
<br><br />
Womens A & B + Girls A + Girls B<br><br />
Women A/B + Girls A/B<br><br />
<br><br />
Canoe A to D - mixed<br><br />
Canoe A-D - mixed<br><br />
<br><br />
Men Masters Over 44<br><br />
Masters O44<br><br />
<br><br />
Women Masters Over 44<br><br />
WMasters O44<br><br />
<br><br />
Women Masters Over 34 & Over 44<br><br />
WMasters O34/44<br><br />
<br><br />
Girls Under 14<br><br />
Girls U14<br><br />
<br><br />
Boys Under 18 + Boys Under 16<br><br />
Boys U18/16<br><br />
<br><br />
Para Men Va'a VL1-3<br><br />
Para Men Vaa VL1-3<br><br />
<br><br />
Para Men Va'a VL1-3<br><br />
Para Men Vaa VL1-3<br><br />
<br><br />
Para Men Va'a VL1-3<br><br />
Para Men VL1-3<br><br />
<br><br />
Paddle-Ability - Saturday<br><br />
Paddle-Ability - Sat<br><br />
<br />
==Creating Events==<br />
When setting up events, remember to include the event category, e.g. Mini-sprint series, Paddle-ability, National Championship, Selection etc. These categories appear on the Start Lists next to each event.<br />
<br />
==Mixed Crew Events==<br />
<br />
The system allows us to control what percentage of the correct class needs to be in each crew boat for the entry to be valid.<br />
<br />
This can be set up using the 'Ratio' value.<br />
<br />
0% or NULL means not applicable.<br />
<br />
25% means at least one paddler has to be from the higher class, i.e. not racing-up class.<br />
<br />
50% means at least two paddlers have to be from the higher class, i.e. not racing-up class.<br />
<br />
The Ratio can also be used for mixed crew boats. In this instance, all the gender classes should be split between the higher class and the racing-up classes, i.e. men or boys classes in one column, women or girls classes in the other. It doens't match which way round these are. You can then apply a 50% ratio value.<br />
<br />
During entries, the system enforces the ratio and throws up an error message.<br />
<br />
==Merging Events==<br />
1. The timetable has to be truncated. You can truncate the timetable from import menu.<br />
2. In events setting you just select the event to merge and system automatically rename the event and merge the entries from selected events.<br />
3. Older events are automatically deleted.<br />
4. Edit the event name to be more prettier<br />
<br />
<br><br />
<br><br />
<br />
=Combined National Championship events and medals=<br />
<br />
Do you know if the Seniors and U23 will race together with results separated, or will they have separate races? Similarly, will the Senior / U23 Mixed K2 follow the same format?<br><br />
<br />
For the events shown on the event schedule as being across both Senior & U23, such as the K1 200m, they will be run as one combined event. With one result, however, as these events are National Championship events, the x3 medals will be awarded for each age group. That is the first three fastest seniors, and the first three fastest U23 athletes.<br><br />
<br />
For crew boats, the age group will be the oldest age group in the boat, i.e. in a K2 or K4, if all are U23, they will be considered as U23; if, however, one athlete is a Senior and others U23, they will be considered for medals as a senior boat.<br><br />
<br />
The Mixed Men/Women K2 500m is a different format as they are shown on the event schedule as separate events, each age group will be run separately.<br></div>Phil Caisleyhttps://canoesprint-wiki.paddleuk.org.uk/w/index.php?title=Ability_Classes_and_Age_Classes&diff=187Ability Classes and Age Classes2025-06-19T12:48:45Z<p>Phil Caisley: /* SUP Ability Classes */</p>
<hr />
<div>=Ability Classes=<br />
<br />
Ben Gallacher was promoted from BAK to MAK when he was under 18 in June 2017. This hadn't been documented on his paddler record.<br />
<br />
His original entry was in MAK but then we saw that he was U18 and checked his paddler details, as there was no promotion noted there, I switched him to BAK. For the May he will need to race in his ability class which is MAK.<br />
<br />
Unfortunately, we will have to reinstate him as MAK moving his entries from BAK to MAK.<br />
<br />
Please, note Item 7 about the Classification of Paddlers on page A8 of the Racing Handbook.<br />
<br />
==SUP Ability Classes==<br />
<br />
The following SUP Ability Classes are available in the system:<br><br><br />
SUPEM = SUP Elite Men<br><br />
SUPEW = SUP Elite Women<br><br />
SUPOM = SUP Open Men<br><br />
SUMOW = SUP Open Women<br><br />
SUPB = SUP Junior Boys<br><br />
SUPG = SUP Junior Girls<br><br><br />
<br />
=Age Classes=<br />
<br />
The system calculates age classes based on the combination of the following data from each paddler record<br><br><br />
Date of birth<br><br />
Gender<br><br />
Kayak and/or Canoe<br><br><br />
<br />
=Multiple classes=<br />
<br />
If a paddler has more than one Ability Class and is selected as a member of a crew boat, is the matching Ability Class to the selected Event picked up?<br />
<br />
=Paddle-Ability and Paracanoe=<br />
<br />
Before registration to a Para class the athlete's personal classification is assessed in a formal classification process for this, they need to be in contact with the Paracanoe programme. If they have already gone through that process, then we need to contact Steve Train for confirmation of their classification.<br />
<br />
If they wish to use a Va'a boat but are not fast enough for the Paracanoe they can race in the Paddle-Ability without any formal classification of their impairment. In that case they can be registered as PAD. The Va times for a Paddle-Ability are on this link Paddle-Ability – Canoe Sprint Racing UK, https://canoesprint.org.uk/regatta-info/paddle-ability/</div>Phil Caisleyhttps://canoesprint-wiki.paddleuk.org.uk/w/index.php?title=Ability_Classes_and_Age_Classes&diff=186Ability Classes and Age Classes2025-06-19T12:48:35Z<p>Phil Caisley: /* Age Classes */</p>
<hr />
<div>=Ability Classes=<br />
<br />
Ben Gallacher was promoted from BAK to MAK when he was under 18 in June 2017. This hadn't been documented on his paddler record.<br />
<br />
His original entry was in MAK but then we saw that he was U18 and checked his paddler details, as there was no promotion noted there, I switched him to BAK. For the May he will need to race in his ability class which is MAK.<br />
<br />
Unfortunately, we will have to reinstate him as MAK moving his entries from BAK to MAK.<br />
<br />
Please, note Item 7 about the Classification of Paddlers on page A8 of the Racing Handbook.<br />
<br />
==SUP Ability Classes==<br />
<br />
The following SUP Ability Classes are available in the system:<br><br><br />
SUPEM = SUP Elite Men<br><br />
SUPEW = SUP Elite Women<br><br />
SUPOM = SUP Open Men<br><br />
SUMOW = SUP Open Women<br><br />
SUPB = SUP Junior Boys<br><br />
SUPG = SUP Junior Girls<br><br />
<br />
=Age Classes=<br />
<br />
The system calculates age classes based on the combination of the following data from each paddler record<br><br><br />
Date of birth<br><br />
Gender<br><br />
Kayak and/or Canoe<br><br><br />
<br />
=Multiple classes=<br />
<br />
If a paddler has more than one Ability Class and is selected as a member of a crew boat, is the matching Ability Class to the selected Event picked up?<br />
<br />
=Paddle-Ability and Paracanoe=<br />
<br />
Before registration to a Para class the athlete's personal classification is assessed in a formal classification process for this, they need to be in contact with the Paracanoe programme. If they have already gone through that process, then we need to contact Steve Train for confirmation of their classification.<br />
<br />
If they wish to use a Va'a boat but are not fast enough for the Paracanoe they can race in the Paddle-Ability without any formal classification of their impairment. In that case they can be registered as PAD. The Va times for a Paddle-Ability are on this link Paddle-Ability – Canoe Sprint Racing UK, https://canoesprint.org.uk/regatta-info/paddle-ability/</div>Phil Caisleyhttps://canoesprint-wiki.paddleuk.org.uk/w/index.php?title=Ability_Classes_and_Age_Classes&diff=185Ability Classes and Age Classes2025-06-19T12:48:08Z<p>Phil Caisley: </p>
<hr />
<div>=Ability Classes=<br />
<br />
Ben Gallacher was promoted from BAK to MAK when he was under 18 in June 2017. This hadn't been documented on his paddler record.<br />
<br />
His original entry was in MAK but then we saw that he was U18 and checked his paddler details, as there was no promotion noted there, I switched him to BAK. For the May he will need to race in his ability class which is MAK.<br />
<br />
Unfortunately, we will have to reinstate him as MAK moving his entries from BAK to MAK.<br />
<br />
Please, note Item 7 about the Classification of Paddlers on page A8 of the Racing Handbook.<br />
<br />
==SUP Ability Classes==<br />
<br />
The following SUP Ability Classes are available in the system:<br><br><br />
SUPEM = SUP Elite Men<br><br />
SUPEW = SUP Elite Women<br><br />
SUPOM = SUP Open Men<br><br />
SUMOW = SUP Open Women<br><br />
SUPB = SUP Junior Boys<br><br />
SUPG = SUP Junior Girls<br><br />
<br />
=Age Classes=<br />
<br />
The system calculates age classes based on the combination of the following data from each paddler record<br><br><br />
Date of birth<br><br />
Gender<br><br />
Kayak and/or Canoe<br><br />
<br />
=Multiple classes=<br />
<br />
If a paddler has more than one Ability Class and is selected as a member of a crew boat, is the matching Ability Class to the selected Event picked up?<br />
<br />
=Paddle-Ability and Paracanoe=<br />
<br />
Before registration to a Para class the athlete's personal classification is assessed in a formal classification process for this, they need to be in contact with the Paracanoe programme. If they have already gone through that process, then we need to contact Steve Train for confirmation of their classification.<br />
<br />
If they wish to use a Va'a boat but are not fast enough for the Paracanoe they can race in the Paddle-Ability without any formal classification of their impairment. In that case they can be registered as PAD. The Va times for a Paddle-Ability are on this link Paddle-Ability – Canoe Sprint Racing UK, https://canoesprint.org.uk/regatta-info/paddle-ability/</div>Phil Caisleyhttps://canoesprint-wiki.paddleuk.org.uk/w/index.php?title=Ability_Classes_and_Age_Classes&diff=184Ability Classes and Age Classes2025-06-19T12:43:53Z<p>Phil Caisley: </p>
<hr />
<div>Ability Classes<br />
<br />
Ben Gallacher was promoted from BAK to MAK when he was under 18 in June 2017. This hadn't been documented on his paddler record.<br />
<br />
His original entry was in MAK but then we saw that he was U18 and checked his paddler details, as there was no promotion noted there, I switched him to BAK. For the May he will need to race in his ability class which is MAK.<br />
<br />
Unfortunately, we will have to reinstate him as MAK moving his entries from BAK to MAK.<br />
<br />
Please, note Item 7 about the Classification of Paddlers on page A8 of the Racing Handbook.<br />
<br />
<br />
SUP Ability Classes<br />
<br />
The following SUP Ability Classes are available in the system.<br />
<br />
SUPEM = SUP Elite Men<br />
SUPEW = SUP Elite Women<br />
SUPOM = SUP Open Men<br />
SUMOW = SUP Open Women<br />
SUPB = SUP Junior Boys<br />
SUPG = SUP Junior Girls<br />
<br />
<br />
Age Classes<br />
<br />
Multiple classes<br />
<br />
If a paddler has more than one Ability Class and is selected as a member of a crew boat, is the matching Ability Class to the selected Event picked up?<br />
<br />
<br />
Paddle-Ability and Paracanoe<br />
<br />
Before registration to a Para class the athlete's personal classification is assessed in a formal classification process for this, they need to be in contact with the Paracanoe programme. If they have already gone through that process, then we need to contact Steve Train for confirmation of their classification.<br />
<br />
If they wish to use a Va'a boat but are not fast enough for the Paracanoe they can race in the Paddle-Ability without any formal classification of their impairment. In that case they can be registered as PAD. The Va times for a Paddle-Ability are on this link Paddle-Ability – Canoe Sprint Racing UK, https://canoesprint.org.uk/regatta-info/paddle-ability/</div>Phil Caisleyhttps://canoesprint-wiki.paddleuk.org.uk/w/index.php?title=Ability_Classes_and_Age_Classes&diff=183Ability Classes and Age Classes2025-06-19T12:42:47Z<p>Phil Caisley: </p>
<hr />
<div># Ability Classes #<br />
<br />
Ben Gallacher was promoted from BAK to MAK when he was under 18 in June 2017. This hadn't been documented on his paddler record.<br />
<br />
His original entry was in MAK but then we saw that he was U18 and checked his paddler details, as there was no promotion noted there, I switched him to BAK. For the May he will need to race in his ability class which is MAK.<br />
<br />
Unfortunately, we will have to reinstate him as MAK moving his entries from BAK to MAK.<br />
<br />
Please, note Item 7 about the Classification of Paddlers on page A8 of the Racing Handbook.<br />
<br />
<br />
Age Classes<br />
<br />
Multiple classes<br />
<br />
If a paddler has more than one Ability Class and is selected as a member of a crew boat, is the matching Ability Class to the selected Event picked up?<br />
<br />
<br />
Paddle-Ability and Paracanoe<br />
<br />
Before registration to a Para class the athlete's personal classification is assessed in a formal classification process for this, they need to be in contact with the Paracanoe programme. If they have already gone through that process, then we need to contact Steve Train for confirmation of their classification.<br />
<br />
If they wish to use a Va'a boat but are not fast enough for the Paracanoe they can race in the Paddle-Ability without any formal classification of their impairment. In that case they can be registered as PAD. The Va times for a Paddle-Ability are on this link Paddle-Ability – Canoe Sprint Racing UK, https://canoesprint.org.uk/regatta-info/paddle-ability/</div>Phil Caisleyhttps://canoesprint-wiki.paddleuk.org.uk/w/index.php?title=Ability_Classes_and_Age_Classes&diff=182Ability Classes and Age Classes2025-06-19T12:42:24Z<p>Phil Caisley: </p>
<hr />
<div>##Ability Classes##<br />
<br />
Ben Gallacher was promoted from BAK to MAK when he was under 18 in June 2017. This hadn't been documented on his paddler record.<br />
<br />
His original entry was in MAK but then we saw that he was U18 and checked his paddler details, as there was no promotion noted there, I switched him to BAK. For the May he will need to race in his ability class which is MAK.<br />
<br />
Unfortunately, we will have to reinstate him as MAK moving his entries from BAK to MAK.<br />
<br />
Please, note Item 7 about the Classification of Paddlers on page A8 of the Racing Handbook.<br />
<br />
<br />
Age Classes<br />
<br />
Multiple classes<br />
<br />
If a paddler has more than one Ability Class and is selected as a member of a crew boat, is the matching Ability Class to the selected Event picked up?<br />
<br />
<br />
Paddle-Ability and Paracanoe<br />
<br />
Before registration to a Para class the athlete's personal classification is assessed in a formal classification process for this, they need to be in contact with the Paracanoe programme. If they have already gone through that process, then we need to contact Steve Train for confirmation of their classification.<br />
<br />
If they wish to use a Va'a boat but are not fast enough for the Paracanoe they can race in the Paddle-Ability without any formal classification of their impairment. In that case they can be registered as PAD. The Va times for a Paddle-Ability are on this link Paddle-Ability – Canoe Sprint Racing UK, https://canoesprint.org.uk/regatta-info/paddle-ability/</div>Phil Caisleyhttps://canoesprint-wiki.paddleuk.org.uk/w/index.php?title=Ability_Classes_and_Age_Classes&diff=181Ability Classes and Age Classes2025-06-19T12:42:10Z<p>Phil Caisley: </p>
<hr />
<div>--Ability Classes--<br />
<br />
Ben Gallacher was promoted from BAK to MAK when he was under 18 in June 2017. This hadn't been documented on his paddler record.<br />
<br />
His original entry was in MAK but then we saw that he was U18 and checked his paddler details, as there was no promotion noted there, I switched him to BAK. For the May he will need to race in his ability class which is MAK.<br />
<br />
Unfortunately, we will have to reinstate him as MAK moving his entries from BAK to MAK.<br />
<br />
Please, note Item 7 about the Classification of Paddlers on page A8 of the Racing Handbook.<br />
<br />
<br />
Age Classes<br />
<br />
Multiple classes<br />
<br />
If a paddler has more than one Ability Class and is selected as a member of a crew boat, is the matching Ability Class to the selected Event picked up?<br />
<br />
<br />
Paddle-Ability and Paracanoe<br />
<br />
Before registration to a Para class the athlete's personal classification is assessed in a formal classification process for this, they need to be in contact with the Paracanoe programme. If they have already gone through that process, then we need to contact Steve Train for confirmation of their classification.<br />
<br />
If they wish to use a Va'a boat but are not fast enough for the Paracanoe they can race in the Paddle-Ability without any formal classification of their impairment. In that case they can be registered as PAD. The Va times for a Paddle-Ability are on this link Paddle-Ability – Canoe Sprint Racing UK, https://canoesprint.org.uk/regatta-info/paddle-ability/</div>Phil Caisleyhttps://canoesprint-wiki.paddleuk.org.uk/w/index.php?title=Ability_Classes_and_Age_Classes&diff=180Ability Classes and Age Classes2025-06-19T12:41:54Z<p>Phil Caisley: </p>
<hr />
<div>- Ability Classes -<br />
<br />
Ben Gallacher was promoted from BAK to MAK when he was under 18 in June 2017. This hadn't been documented on his paddler record.<br />
<br />
His original entry was in MAK but then we saw that he was U18 and checked his paddler details, as there was no promotion noted there, I switched him to BAK. For the May he will need to race in his ability class which is MAK.<br />
<br />
Unfortunately, we will have to reinstate him as MAK moving his entries from BAK to MAK.<br />
<br />
Please, note Item 7 about the Classification of Paddlers on page A8 of the Racing Handbook.<br />
<br />
<br />
Age Classes<br />
<br />
Multiple classes<br />
<br />
If a paddler has more than one Ability Class and is selected as a member of a crew boat, is the matching Ability Class to the selected Event picked up?<br />
<br />
<br />
Paddle-Ability and Paracanoe<br />
<br />
Before registration to a Para class the athlete's personal classification is assessed in a formal classification process for this, they need to be in contact with the Paracanoe programme. If they have already gone through that process, then we need to contact Steve Train for confirmation of their classification.<br />
<br />
If they wish to use a Va'a boat but are not fast enough for the Paracanoe they can race in the Paddle-Ability without any formal classification of their impairment. In that case they can be registered as PAD. The Va times for a Paddle-Ability are on this link Paddle-Ability – Canoe Sprint Racing UK, https://canoesprint.org.uk/regatta-info/paddle-ability/</div>Phil Caisleyhttps://canoesprint-wiki.paddleuk.org.uk/w/index.php?title=Start_Lists&diff=179Start Lists2025-06-04T21:57:25Z<p>Phil Caisley: </p>
<hr />
<div>=Long distance numbers missing from sequence=<br />
The following numbers have been lost, so should not be used<br><br><br />
Y146<br><br />
Y168<br><br />
W46<br><br />
<br />
=Paddlers with disabilities or special needs=<br />
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.<br />
<br />
=Importing Start List csv files into Excel=<br />
<br />
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<br />
<br />
;;;;;;;;;;;;<br />
<br />
this allows all the C4 and K4 paddler records to be imported to Excel<br />
<br />
Also set the import encoding to UTF-8 and update date format to yyyy-mm-dd<br />
<br />
<br />
- Import Start List data into Excel, remembering to add enough ;;;; characters to reflect the K4 events<br><br />
- Add spaces between events, and add correct lane order, e.g. 5, 6, 4, 7 etc. This takes approx. 30 minutes<br> <br />
- 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.<br><br />
- Send to Cathy for review<br><br />
<br><br />
Upload start lists<br><br />
Generate PDF of start lists<br><br />
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<br><br />
Generate data file for HPP system and send to Jon<br><br />
Compile programme and other materials for John<br><br />
Compile Timetable, Start Lists, Regatta Guide and Programme for the website and upload to the website<br><br />
Produce news item on website<br><br />
Send cover photo to Trevor for use in Official Results along with PDF of cover for reference<br><br />
Produce news item on BC Sprint Racing Committee Facebook page<br><br />
Share Facebook news item with Racing Canoe Clubs Facebook page<br><br />
Send final regatta bulletin to Team Leaders, including the Regatta Guide, and request payment<br><br />
<br />
=Preparing the Start List file for import back into the Online Entry System=<br />
<br />
When preparing the start list file for upload, remember to do the following:<br />
<br />
Delete all columns to the right of the last populated column of the spreadsheet<br><br />
Delete all rows below the last populated column of the spreadsheet<br><br />
Replace long hyphens with short hyphens, but not in - R1, - R2, Paddle-Ability - Saturday, Paddle-Ability - Sunday, Canoe A-D - Mixed etc<br><br />
Replace , with ; in the CSV file<br><br />
Update date format to yyyy-mm-dd<be><br />
<br />
The uploaded file needs to be UTF-8 encoded.<br />
<br />
After selecting 'Import timetable / startlist' remember to change event code to correct number in the URL<br><br />
<br />
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.<br><br />
<br />
https://canoesprint.paddleuk.org.uk/public/default/startlist-print/3<br><br />
<br />
=Actions to take after the Start List is signed off=<br />
<br />
Once signed off, check the following:<br />
- races have correct categorization, e.g. National Championship, Selection, Paddle-Ability etc<br />
- races have correct distances set, e.g. 5000 > 500 and 2000 > 200<br />
- races have correct naming, e.g. V1 not C1 for Va'a events</div>Phil Caisleyhttps://canoesprint-wiki.paddleuk.org.uk/w/index.php?title=Start_Lists&diff=178Start Lists2025-06-04T21:56:56Z<p>Phil Caisley: </p>
<hr />
<div>=Long distance numbers missing from sequence=<br />
The following numbers have been lost, so should not be used<br><br><br />
Y146<br><br />
Y168<br><br />
W46<br><br />
<br />
=Importing Start List csv files into Excel=<br />
<br />
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<br />
<br />
;;;;;;;;;;;;<br />
<br />
this allows all the C4 and K4 paddler records to be imported to Excel<br />
<br />
Also set the import encoding to UTF-8 and update date format to yyyy-mm-dd<br />
<br />
<br />
- Import Start List data into Excel, remembering to add enough ;;;; characters to reflect the K4 events<br><br />
- Add spaces between events, and add correct lane order, e.g. 5, 6, 4, 7 etc. This takes approx. 30 minutes<br> <br />
- 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.<br><br />
- Send to Cathy for review<br><br />
<br><br />
Upload start lists<br><br />
Generate PDF of start lists<br><br />
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<br><br />
Generate data file for HPP system and send to Jon<br><br />
Compile programme and other materials for John<br><br />
Compile Timetable, Start Lists, Regatta Guide and Programme for the website and upload to the website<br><br />
Produce news item on website<br><br />
Send cover photo to Trevor for use in Official Results along with PDF of cover for reference<br><br />
Produce news item on BC Sprint Racing Committee Facebook page<br><br />
Share Facebook news item with Racing Canoe Clubs Facebook page<br><br />
Send final regatta bulletin to Team Leaders, including the Regatta Guide, and request payment<br><br />
<br />
=Preparing the Start List file for import back into the Online Entry System=<br />
<br />
When preparing the start list file for upload, remember to do the following:<br />
<br />
Delete all columns to the right of the last populated column of the spreadsheet<br><br />
Delete all rows below the last populated column of the spreadsheet<br><br />
Replace long hyphens with short hyphens, but not in - R1, - R2, Paddle-Ability - Saturday, Paddle-Ability - Sunday, Canoe A-D - Mixed etc<br><br />
Replace , with ; in the CSV file<br><br />
Update date format to yyyy-mm-dd<be><br />
<br />
The uploaded file needs to be UTF-8 encoded.<br />
<br />
After selecting 'Import timetable / startlist' remember to change event code to correct number in the URL<br><br />
<br />
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.<br><br />
<br />
https://canoesprint.paddleuk.org.uk/public/default/startlist-print/3<br><br />
<br />
=Actions to take after the Start List is signed off=<br />
<br />
Once signed off, check the following:<br />
- races have correct categorization, e.g. National Championship, Selection, Paddle-Ability etc<br />
- races have correct distances set, e.g. 5000 > 500 and 2000 > 200<br />
- races have correct naming, e.g. V1 not C1 for Va'a events<br />
<br />
=Paddlers with disabilities or special needs=<br />
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.</div>Phil Caisleyhttps://canoesprint-wiki.paddleuk.org.uk/w/index.php?title=Start_Lists&diff=177Start Lists2025-06-04T21:55:27Z<p>Phil Caisley: /* Long distance numbers missing from sequence */</p>
<hr />
<div>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<br />
<br />
;;;;;;;;;;;;<br />
<br />
this allows all the C4 and K4 paddler records to be imported to Excel<br />
<br />
Also set the import encoding to UTF-8 and update date format to yyyy-mm-dd<br />
<br />
<br />
- Import Start List data into Excel, remembering to add enough ;;;; characters to reflect the K4 events<br><br />
- Add spaces between events, and add correct lane order, e.g. 5, 6, 4, 7 etc. This takes approx. 30 minutes<br> <br />
- 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.<br><br />
- Send to Cathy for review<br><br />
<br><br />
Upload start lists<br><br />
Generate PDF of start lists<br><br />
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<br><br />
Generate data file for HPP system and send to Jon<br><br />
Compile programme and other materials for John<br><br />
Compile Timetable, Start Lists, Regatta Guide and Programme for the website and upload to the website<br><br />
Produce news item on website<br><br />
Send cover photo to Trevor for use in Official Results along with PDF of cover for reference<br><br />
Produce news item on BC Sprint Racing Committee Facebook page<br><br />
Share Facebook news item with Racing Canoe Clubs Facebook page<br><br />
Send final regatta bulletin to Team Leaders, including the Regatta Guide, and request payment<br><br />
<br />
<br />
<br />
<br />
<br />
When preparing the start list file for upload, remember to do the following:<br />
<br />
Delete all columns to the right of the last populated column of the spreadsheet<br><br />
Delete all rows below the last populated column of the spreadsheet<br><br />
Replace long hyphens with short hyphens, but not in - R1, - R2, Paddle-Ability - Saturday, Paddle-Ability - Sunday, Canoe A-D - Mixed etc<br><br />
Replace , with ; in the CSV file<br><br />
Update date format to yyyy-mm-dd<be><br />
<br />
The uploaded file needs to be UTF-8 encoded.<br />
<br />
After selecting 'Import timetable / startlist' remember to change event code to correct number in the URL<br><br />
<br />
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.<br><br />
<br />
https://canoesprint.paddleuk.org.uk/public/default/startlist-print/3<br><br />
<br />
Once signed off, check the following:<br />
- races have correct categorization, e.g. National Championship, Selection, Paddle-Ability etc<br />
- races have correct distances set, e.g. 5000 > 500 and 2000 > 200<br />
- races have correct naming, e.g. V1 not C1 for Va'a events<br />
<br />
=Paddlers with disabilities or special needs=<br />
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.</div>Phil Caisleyhttps://canoesprint-wiki.paddleuk.org.uk/w/index.php?title=Start_Lists&diff=176Start Lists2025-06-04T21:55:00Z<p>Phil Caisley: /* Long distance numbers missing from sequence */</p>
<hr />
<div>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<br />
<br />
;;;;;;;;;;;;<br />
<br />
this allows all the C4 and K4 paddler records to be imported to Excel<br />
<br />
Also set the import encoding to UTF-8 and update date format to yyyy-mm-dd<br />
<br />
<br />
- Import Start List data into Excel, remembering to add enough ;;;; characters to reflect the K4 events<br><br />
- Add spaces between events, and add correct lane order, e.g. 5, 6, 4, 7 etc. This takes approx. 30 minutes<br> <br />
- 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.<br><br />
- Send to Cathy for review<br><br />
<br><br />
Upload start lists<br><br />
Generate PDF of start lists<br><br />
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<br><br />
Generate data file for HPP system and send to Jon<br><br />
Compile programme and other materials for John<br><br />
Compile Timetable, Start Lists, Regatta Guide and Programme for the website and upload to the website<br><br />
Produce news item on website<br><br />
Send cover photo to Trevor for use in Official Results along with PDF of cover for reference<br><br />
Produce news item on BC Sprint Racing Committee Facebook page<br><br />
Share Facebook news item with Racing Canoe Clubs Facebook page<br><br />
Send final regatta bulletin to Team Leaders, including the Regatta Guide, and request payment<br><br />
<br />
<br />
<br />
<br />
<br />
When preparing the start list file for upload, remember to do the following:<br />
<br />
Delete all columns to the right of the last populated column of the spreadsheet<br><br />
Delete all rows below the last populated column of the spreadsheet<br><br />
Replace long hyphens with short hyphens, but not in - R1, - R2, Paddle-Ability - Saturday, Paddle-Ability - Sunday, Canoe A-D - Mixed etc<br><br />
Replace , with ; in the CSV file<br><br />
Update date format to yyyy-mm-dd<be><br />
<br />
The uploaded file needs to be UTF-8 encoded.<br />
<br />
After selecting 'Import timetable / startlist' remember to change event code to correct number in the URL<br><br />
<br />
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.<br><br />
<br />
https://canoesprint.paddleuk.org.uk/public/default/startlist-print/3<br><br />
<br />
Once signed off, check the following:<br />
- races have correct categorization, e.g. National Championship, Selection, Paddle-Ability etc<br />
- races have correct distances set, e.g. 5000 > 500 and 2000 > 200<br />
- races have correct naming, e.g. V1 not C1 for Va'a events<br />
<br />
=Long distance numbers missing from sequence=<br />
The following numbers have been lost, so should not be used<br><br><br />
Y146<br><br />
Y168<br><br />
W46<br><br />
<br />
=Paddlers with disabilities or special needs=<br />
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.</div>Phil Caisley