Procedure at Entries Close - Revision history

Phil Caisley: /* Apply event merges and prepare coloured-up file for timetabling */

2025-12-11T22:08:07Z

Apply event merges and prepare coloured-up file for timetabling

← Older revision		Revision as of 22:08, 11 December 2025
Line 30:		Line 30:
	- Merges take approx 30-50 mins<br>		- Merges take approx 30-50 mins<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>		-- 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>
	- Adding in days takes approx 30-40 mins (~~use~~ Excel filters ~~to help~~)<br>		- Adding in days takes approx 20-40 mins (using Excel filters really speeds up the process)<br>
	- Colouring up takes approx 40-50 mins (sort by Event type only to prepare file)<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>

172.68.186.109 at 13:30, 18 May 2025

2025-05-18T13:30:30Z

← Older revision		Revision as of 13:30, 18 May 2025
Line 41:		Line 41:
	- Sort the file by Day, then by Event, then by Boat Type, then by Correct Distance<br>		- Sort the file by Day, then by Event, then by Boat Type, then by Correct Distance<br>
	<br>		<br>

	~~==Review timetable==~~
	~~===First review===~~
	~~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>~~
	~~- Add times~~
	~~- Add race numbers~~
	~~- Check that there is an hour between K4 usage. We have 10 skinny Plastex boats and 16 more stable Commanders~~

	~~<br>~~
	~~merged the Girls A/B and Girls C K4 500m events and updated the spreadsheet name and number of entries<br>~~
	~~checked that events are ideally 45+ mins apart<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>~~
	~~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>~~
	~~checked that there is an hour between K4 usage based on available boats<br>~~
	~~added event times<br>~~
	~~added race numbers and can confirm that we have 253 races<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>~~
	~~updated days to dates in yyyy-mm-dd format ready for upload<br>~~
	~~dropped a note to Matej to inform him to expect a Start Lists request later today<br>~~

	~~===Second review===~~
	~~Checking draft Timetable - second review<br>~~
	~~- Check corrections<br>~~
	~~- Check time gaps again<br>~~
	~~- Add Progressions info from the Progressions spreadsheet, if not already added<br>~~
	~~- Add dates in place of FRI/SAT/SUN in yyyy-mm-dd format<br>~~
	~~- Update race numbers~~
	~~- Add information lines, e.g. course opens, course closes, paralympic events etc<br>~~
	~~- Delete extraneous rows used for time separation, when no longer required<br>~~
	~~- Remove columns to the right of the data<br>~~
	~~- Remove rows below the data<br>~~

	~~==Upload Timetable to Online Entry System==~~
	~~Check online view<br>~~
	~~Once approved, ask Matej to generate start lists<br>~~

172.70.163.54: /* De-duplicate or approve Incomplete or Unconfirmed Entries */

2025-05-18T12:27:01Z

De-duplicate or approve Incomplete or Unconfirmed Entries

← Older revision		Revision as of 12:27, 18 May 2025
Line 7:		Line 7:
	- Accept incomplete entries and unresolved entries<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		- 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<br>		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>		- 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>		- Take screengrabs of entries summary list by club again<br>

172.70.85.72: /* Second review */

2024-08-25T17:18:12Z

Second review

← Older revision		Revision as of 17:18, 25 August 2024
Line 72:		Line 72:
	- Add Progressions info from the Progressions spreadsheet, if not already added<br>		- Add Progressions info from the Progressions spreadsheet, if not already added<br>
	- Add dates in place of FRI/SAT/SUN in yyyy-mm-dd format<br>		- Add dates in place of FRI/SAT/SUN in yyyy-mm-dd format<br>
	- Delete extraneous rows used for time separation, when no longer required		- Update race numbers
	- Remove columns to the right of the data		- Add information lines, e.g. course opens, course closes, paralympic events etc<br>
	- Remove rows below the data		- Delete extraneous rows used for time separation, when no longer required<br>
			- Remove columns to the right of the data<br>
			- Remove rows below the data<br>

	==Upload Timetable to Online Entry System==		==Upload Timetable to Online Entry System==
	Check online view<br>		Check online view<br>
	Once approved, ask Matej to generate start lists<br>		Once approved, ask Matej to generate start lists<br>

172.70.162.162: /* Apply event merges and prepare coloured-up file for timetabling */

2024-08-24T08:14:03Z

Apply event merges and prepare coloured-up file for timetabling

← Older revision		Revision as of 08:14, 24 August 2024
Line 31:		Line 31:
	-- 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>		-- 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>
	- Adding in days takes approx 30-40 mins (use Excel filters to help)<br>		- Adding in days takes approx 30-40 mins (use Excel filters to help)<br>
	- Colouring up takes approx 40-50 mins<br>		- Colouring up takes approx 40-50 mins (sort by Event type only to prepare file)<br>
	<br>		<br>
	- Regenerate event list<br>		- Regenerate event list<br>

172.70.91.167: /* Identify event merges and request seeding lists */

2024-06-22T07:13:37Z

Identify event merges and request seeding lists

← Older revision		Revision as of 07:13, 22 June 2024
Line 23:		Line 23:
	- Canoes<br>		- Canoes<br>
	- Paracanoe<br>		- Paracanoe<br>
	- Paddle-Ability<be>		- Paddle-Ability<br>
	Identify where events with small entry numbers, could potentially be run concurrently with separate results, i.e. not merged<be>		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==

172.70.86.7: /* First review */

2024-03-30T08:08:20Z

First review

← Older revision		Revision as of 08:08, 30 March 2024
Line 54:		Line 54:
	- Check that there is an hour between K4 usage. We have 10 skinny Plastex boats and 16 more stable Commanders		- Check that there is an hour between K4 usage. We have 10 skinny Plastex boats and 16 more stable Commanders

			<br>
	merged the Girls A/B and Girls C K4 500m events and updated the spreadsheet name and number of entries		merged the Girls A/B and Girls C K4 500m events and updated the spreadsheet name and number of entries<br>
	checked that events are ideally 45+ mins apart		checked that events are ideally 45+ mins apart<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		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>
	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		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>
	checked that there is an hour between K4 usage based on available boats		checked that there is an hour between K4 usage based on available boats<br>
	added event times		added event times<br>
	added race numbers and can confirm that we have 253 races		added race numbers and can confirm that we have 253 races<br>
	added progressions info. I have marked a few queries in column K, which are highlighted in yellow. Please update these progressions if correct		added progressions info. I have marked a few queries in column K, which are highlighted in yellow. Please update these progressions if correct<br>
	updated days to dates in yyyy-mm-dd format ready for upload		updated days to dates in yyyy-mm-dd format ready for upload<br>
	dropped a note to Matej to inform him to expect a Start Lists request later today		dropped a note to Matej to inform him to expect a Start Lists request later today<br>

	===Second review===		===Second review===

172.70.86.7: /* First review */

2024-03-30T08:07:51Z

First review

@@ Line 53: / Line 53: @@
 - Add race numbers
 - Check that there is an hour between K4 usage. We have 10 skinny Plastex boats and 16 more stable Commanders
 ===Second review===

172.70.86.7: /* Apply event merges and prepare coloured-up file for timetabling */

2024-03-30T08:07:38Z

Apply event merges and prepare coloured-up file for timetabling

← Older revision		Revision as of 08:07, 30 March 2024
Line 36:		Line 36:
	- 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>

172.69.195.156: /* Apply event merges and prepare coloured-up file for timetabling */

2024-03-30T07:58:25Z

Apply event merges and prepare coloured-up file for timetabling

← Older revision		Revision as of 07:58, 30 March 2024
Line 29:		Line 29:
	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>
			-- 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>
	- Adding in days takes approx 30-40 mins (use Excel filters to help)<br>		- Adding in days takes approx 30-40 mins (use Excel filters to help)<br>
	- Colouring up takes approx 40-50 mins<br>		- Colouring up takes approx 40-50 mins<br>