(16 intermediate revisions by 13 users not shown)
Line 4: Line 4:
=Procedures at entries close=
=Procedures at entries close=
==De-duplicate or approve Incomplete or Unconfirmed Entries==
==De-duplicate or approve Incomplete or Unconfirmed Entries==
 
- Take screengrabs of entries summary list by club and any incomplete and unresolved boats<br>
<br>
- Accept incomplete entries and unresolved entries<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
https://canoesprint.paddleuk.org.uk/competition/events/checkup/42<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>
- Take screengrabs of entries summary list by club again<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>
Take screengrabs of entries summary list by club and any incomplete and unresolved boats<br>
Accept incomplete entries and unresolved entries<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
https://canoesprint.britishcanoeing.org.uk/competition/events/checkup/11


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.
==Identify event merges and request seeding lists==
 
Review the events list and proposed numbers of heats and finals<br>
Take screengrabs of entries summary list by club again<br>
Identify those events that won't run and for which refunds are required<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>
Identify those events that have limited entries<br>
<br>
Identify where events with limited entry numbers can be merged<br>
For seeded events, prepare lists and send these to the individuals who will prepare those lists<br>
- Seniors<br>
- Juniors<br>
- Canoes<br>
- Paracanoe<br>
- Paddle-Ability<br>
Identify where events with small entry numbers, could potentially be run concurrently with separate results, i.e. not merged<br>


==Apply event merges and prepare coloured-up file for timetabling==
==Apply event merges and prepare coloured-up file for timetabling==
Note - Applying Merges and generating the Coloured-up file for the timetabling process takes about 2 hours<br>  
Note - Applying Merges and generating the Coloured-up file for the timetabling process takes about 2 hours<br>  
Merges take approx 30-50 mins<br>
- Merges take approx 30-50 mins<br>
Adding in days takes approx 30-40 mins (use Excel filters to help)<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>
Colouring up takes approx 40-50 mins<br>  
- Adding in days takes approx 20-40 mins (using Excel filters really speeds up the process)<br>  
- Colouring up takes approx 20-50 mins (sort by Event type only to prepare file)<br>  
<br>
<br>
- Regenerate event list<br>
- Regenerate event list<br>
- Paste it into Excel<br>
- Paste it into Excel<br>
- Delete system-generated Progression information. This will be corrected and added back in later in the process<br>
- Delete system-generated Progression information. This will be corrected and added back in later in the process<br>
- Add days (not dates) for each event based on the event schedule. These will be corrected to dates later in the process, but its easier to work with these as Days for Timetabling<br>
- Add in a Correct Distance column to supplement the system workaround distances to help with timetabling<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>
- Colour up the events in Excel, ideally showing all relevant colours for Mixed events<br>
- Colour up the events in Excel, ideally showing all relevant colours for Mixed events<br>
- Sort the file by Day, then by Event, then by Boat Type, then by Distance<br>
- Sort the file by Day, then by Event, then by Boat Type, then by Correct Distance<br>
<br>
 
<br>
Generate timetable<br>
Review timetable for time conflicts<br>
 
 
Checking draft Timetable - first review<br>
- Check that events are ideally 45+ mins apart using colouring as the principle guide<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>
- 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>
- Check Para runs are in correct sequence, i.e. R1, R2, R3<br>
- Identify and correct event title discrepancies against event naming convention<br>
 
Second review<br>
- Check corrections<br>
- Check time gaps again<br>
- Add Progressions info from master spreadsheet<br>
- Add dates in place of FRI/SAT/SUN in correct format<br>
 
<br>
Rework timetable<br>
Review timetable again for conflicts<br>
Add event times, progression info, event numbers, remove extra lines, delete Sunday row entry and renumber, and send to Cathy for checking of Progressions<br>
<br>
Upload Timetable to Online Entry System<br>
Check online view<br>
<br>
Ask Matej to generate start lists<br>
Import Start List data into Excel<br>
Add spaces between events, and add correct lane order, e.g. 5, 6, 4, 7 etc<br>
Take in lane draws, seedings, and paddler specific issues. This takes about 3 hours.<br>
Send to Cathy for review<br>
<br>
<br>
Upload start lists<br>
Generate PDF of start lists<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>
Generate data file for HPP system and send to Jon<br>
Compile programme and other materials for John<br>
Compile Timetable, Start Lists, Regatta Guide and Programme for the website and upload to the website<br>
Produce news item on website<br>
Send cover photo to Trevor for use in Official Results along with PDF of cover for reference<br>
Produce news item on BC Sprint Racing Committee Facebook page<br>
Share Facebook news item with Racing Canoe Clubs Facebook page<br>
Send final regatta bulletin to Team Leaders, including the Regatta Guide, and request payment<br>

Latest revision as of 22:08, 11 December 2025

Procedures before entries close

Chase Team Leaders to resolve Unresolved and Incomplete Boats

Procedures at entries close

De-duplicate or approve Incomplete or Unconfirmed Entries

- Take screengrabs of entries summary list by club and any incomplete and unresolved boats
- Accept incomplete entries and unresolved entries
- 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 https://canoesprint.paddleuk.org.uk/competition/events/checkup/42
- 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.
- Take screengrabs of entries summary list by club again
- 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

Identify event merges and request seeding lists

Review the events list and proposed numbers of heats and finals
Identify those events that won't run and for which refunds are required
Identify those events that have limited entries
Identify where events with limited entry numbers can be merged
For seeded events, prepare lists and send these to the individuals who will prepare those lists
- Seniors
- Juniors
- Canoes
- Paracanoe
- Paddle-Ability
Identify where events with small entry numbers, could potentially be run concurrently with separate results, i.e. not merged

Apply event merges and prepare coloured-up file for timetabling

Note - Applying Merges and generating the Coloured-up file for the timetabling process takes about 2 hours
- Merges take approx 30-50 mins
-- 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
- Adding in days takes approx 20-40 mins (using Excel filters really speeds up the process)
- Colouring up takes approx 20-50 mins (sort by Event type only to prepare file)

- Regenerate event list
- Paste it into Excel
- Delete system-generated Progression information. This will be corrected and added back in later in the process
- Add in a Correct Distance column to supplement the system workaround distances to help with timetabling
- 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
- Colour up the events in Excel, ideally showing all relevant colours for Mixed events
- Sort the file by Day, then by Event, then by Boat Type, then by Correct Distance