20th Winter signup spreadsheet.xlsx

	A	B	E	F	H	I	J	M
1		XX Olympic Winter Games detailed sign-up spreadsheet
2		XX Olympic Winter Games detailed sign-up spreadsheet
3
4		Key inputs
5		Delegation name (normally your nation name)
6		Trigram (three letter code, e.g. Liventia is LEN)
7
8		Read me user guide
9		Insert names in the green cells where signing up an athlete. NOTE: Make sure there are no line breaks when copy and pasting names on Google Sheets.
10		Insert your delegation (country) name in the pink cells where signing up a team.
11		Insert skill levels (whole numbers between 0 and 100) in column F.
12		"Check" under Check entry means that one of the above boxes may not be filled.
13		"Check" under Check name means that the name of the team does not match the country name.
14		Copy column N onto the thread. NOTE: Please make sure to get rid of apostrophe marks (") which may appear when pasting from Google Sheets.
15
16		Key statistics						Output (copy column N to thread)
17		Total number of entries:		0				COPY THIS COLUMN AND PASTE IN THREAD
18		Total skill average:		0
19		Standard deviation:		0				Delegation:
20		Target standard deviation:		50				Trigram:
21		Min-Max Avoidance Bonus:		1	-0.2335
22								Total number of entries: 0
23								Total skill average: 0
24								Standard deviation: 0
25								Target standard deviation: 50
26								Min-Max Avoidance Bonus: 1
27
28	BIATHLON		Trigram	Skill	Check entry	Check name
29	Men's 10km Sprint (4)
30							TRUE
31							TRUE
32							TRUE
33							TRUE
34	Men's 15km Mass Start (4)
35							TRUE
36							TRUE
37							TRUE
38							TRUE
39	Men's 20km Individual (4)
40							TRUE
41							TRUE
42							TRUE
43							TRUE
44	Men's 4x7.5km Relay (1 team of 4)
45							TRUE
46	Women's 7.5km Sprint (4)
47							TRUE
48							TRUE
49							TRUE
50							TRUE
51	Women's 12.5km Mass Start (4)
52							TRUE
53							TRUE
54							TRUE
55							TRUE
56	Women's 15km Individual (4)
57							TRUE
58							TRUE
59							TRUE
60							TRUE
61	Women's 4x6km Relay (1 team of 4)
62							TRUE
63	Mixed 4x6km Relay (1 team of 4)
64							TRUE
65
66	BOBSLEIGH – BOBSLEIGH		Trigram	Skill	Check entry	Check name
67	Two-Man (3 teams of 2)
68							TRUE
69							TRUE
70							TRUE
71	Four-Man (3 teams of 4)
72							TRUE
73							TRUE
74							TRUE
75	Women's Monobob (3)
76							TRUE
77							TRUE
78							TRUE
79	Two-Woman (3 teams of 2)
80							TRUE
81							TRUE
82							TRUE
83	BOBSLEIGH – SKELETON		Trigram	Skill	Check entry	Check name
84	Men's (3)
85							TRUE
86							TRUE
87							TRUE
88	Women's (3)
89							TRUE
90							TRUE
91							TRUE
92	Mixed Team (2 teams of 2)
93							TRUE
94							TRUE
95
96	CURLING		Trigram	Skill	Check entry	Check name
97	Men's Team (1 team)
98							TRUE
99	Women's Team (1 team)
100							TRUE