2024 EISA Course Setter Rotation 2.13.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	V	W
1	EISA Alpine Course Setter and Referee assignments 2022									Reworked		Random
2
3		2024	Course Setters							Referees				Connection Coach			Slalom Warm Up
4		HOST	GS 1	GS 2	SL M1	SL W1	SL M2	SL W2		Ref GS	Ref SL M	Ref SL W		Ref GS alt	Ref SL alt		Course 1	Course 2
5		UVM	BC	UVM	UVM	CBC	SMC	PSU		HAR	UNH	PSU		CBC	BC		WIL	CSC
6		CBC	UNH	CBC	PSU	CBC	DAR	CSC		CSC	HAR	MID		PSU	UNH		HAR	BC
7		HAR	HAR	MID	HAR	BC	BAT	WIL		WIL	MID	BC		BAT	DAR		UVM	UNH
8		DAR	BAT	DAR	CSC	DAR	SMC	UNH		CBC	BAT	UNH		CSC	UVM		CBC	MID
9		WIL	SMC	WIL	WIL	PSC	HAR	UVM		PSU	SLU	SMC		HAR	MID		BAT	SMC
10		MID	DART	MID	UNH	MID	BAT	CBC		DAR	UVM	BAT		WIL	PSC		CSC	DAR
11
12			Course Setters											Alternate Referees			Warm Up				BC	1
13		Rotation	GS 1	GS 2	SL M1	SL W1	SL M2	SL W2	TOTAL	Ref GS	Ref SL M	Ref SL W	TOTAL	Ref GS alt	Ref SL alt	TOTAL	Warm up 1	Warm Up 2	TOTAL		BAT	2
14	Hosts	UVM	1	1	1				3	1			UVM		1	1	1		1	2	DART	3
15		CBC		1		1	1		3			1	CBC	1		1	1		1	2	COL	4
16		HAR		1	1		1		3		1		HAR	1		1	1		1	2	CSC	5
17		DAR		1		1	1		3	1			DAR	1		1		1	1	2	HAR	6
18		WIL		1	1			1	3		1	1	WIL			0	1		1	1	SMC	7
19		MID	1	1		1			3		1	1	MID		1	1		1	1	2	UVM	8
20																					UNH	9
21	A/N	SLU	1			1	1		3		1		SLU		1	1	1		1	2	PSU	10
22		BAT				1	1	1	3	1			BAT			0	1		1	1	MID	11
23		SMC	1				1	1	3		1	1	SMC		1	1			0	1	WIL	12
24		UNH	1		1			1	3	1	1		UNH		1	1		1	1	2
25
26	A only	CSC			1			1	2	1			CSC	1		1		1	1	2
27		BC	1			1			2			1	BC	1		1		1	1	2
28		PSU			1			1	2	1		1	PSU	1	1	2			0	2
29			6	6	6	6	6	6	36	6	6	6	0	6	6	12	6	5	11
30
31		Procedure:														Year to Year Adjustments:
32	1	Schools with Alpine and Nordic will get 3 sets (1 gs, 1 M SL, 1 W SL). Alpine only schools get 2 sets (GS/SL or 2 SL)													1	Enter host schools in order of hosting in the green box
33	2	Host shall set 2nd run GS and will alternate setting 1st run Men or Women SL													2	Enter non-hosting Alpine/Nordic schools in yellow box
34	3	Assign sets then assign Ref, Alt Ref and warm-up course sets avoiding duplicates													3	Enter Alpine only schools in blue box and rotate them from previous year
35	4	There are 13 assignments per carnival. Host sets twice. Previous weekends host is not assigned.													4	Swap M + W first columns
36	5	All schools have 6 assignments													5	Swap M + W second run columns
37	6	A school will not be assigned the same postion more than 1 time.
38	8	Women shall start first in GS and men first in SL
39	9	The assigned school is responsible to finding a substitute if they cannot fulfill the assignment.
40	10	Referees shall be participating coaches
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100