16Summer-signup-spreadsheet.xlsx

	A	B	D	E	F	H	I	J	L	M	N
1										Output (copy column N to thread)
2		Games of the XVI Olympiad sign-up spreadsheet									Delegation:
3											Trigram:
4		Key inputs									Number of medal entries: 0
5		Delegation name (e.g. Quebec and Shingoryeo)									Number of demonstration entries: 0
6		Trigram (three letter code, e.g. Electrum - ETM)									Medal entries average: 0
7		Is this delegation a unified team? Yes or No			No						Demonstration entries average: 0
8											Total entries average: 0
9		User guide									Standard deviation: 0
10		Insert names in the green cells where signing up an athlete/team. NOTE: Make sure there are no line breaks when copy and pasting names on Google Sheets.									Min-Max Avoidance Bonus: 0.2
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.									Automatic entries:
13		Check under Check name means that the name of the team does not match the country name. Ignore if using unified teams.									Archery - Men's Team
14		For unified teams, put Yes in cell F7. Insert the apprioriate trigram into column L. Default trigram used is F6 if column L is not specified.									None
15		Copy column N onto the thread. NOTE: Please make sure to get rid of apostrophe marks (") which may appear when pasting from Google Sheets.									Archery - Women's Team
16											None
17		Key statistics									Fencing - Men's Épée
18		Number of medal entries:	Cap of 600 per user		0						None
19		Number of demonstration entries:	Does not count towards cap		0						Fencing - Men's Foil
20		Total number of entries:			0						None
21		Medal entries average:			0						Fencing - Men's Sabre
22		Demonstration entries average:			0						None
23		Total entries average:			0						Fencing - Women's Épée
24		Standard deviation:			0						None
25		Target standard deviation:			50						Fencing - Women's Foil
26		Min-Max Avoidance Bonus:	Maximum of 0.2		0.2						None
27											Fencing - Women's Sabre
28											None
29
30	Aquatics - artistic swimming			Trigram	Skill	Check entry	Check name		Trigram (unified only)
31	Men’s Duet (1 team of 2)
32								TRUE
33	Men’s Team (1 team)
34								TRUE
35	Women’s Duet (1 team of 2)
36								TRUE
37	Women’s Team (1 team)
38								TRUE
39
40	Aquatics - diving			Trigram	Skill	Check entry			Trigram (unified only)
41	Men’s 3 m Springboard (2)
42								TRUE
43								TRUE
44	Men’s 10 m Platform (2)
45								TRUE
46								TRUE
47	Men’s Synchronized 3 m Springboard (1 team of 2)
48								TRUE
49	Men’s Synchronized 10 m Platform (1 team of 2)
50								TRUE
51	Women’s 3 m Springboard (2)
52								TRUE
53								TRUE
54	Women’s 10 m Platform (2)
55								TRUE
56								TRUE
57	Women’s Synchronized 3 m Springboard (1 team of 2)
58								TRUE
59	Women’s Synchronized 10 m Platform (1 team of 2)
60								TRUE
61
62	Aquatics - marathon swimming			Trigram	Skill	Check entry			Trigram (unified only)
63	Men’s 10 km Marathon (2)
64								TRUE
65								TRUE
66	Women’s 10 km Marathon (2)
67								TRUE
68								TRUE
69
70	Aquatics - swimming				Skill	Check entry			Trigram (unified only)
71	Men’s 50 m Freestyle (2)
72								TRUE
73								TRUE
74	Men’s 100 m Freestyle (2)
75								TRUE
76								TRUE
77	Men’s 200 m Freestyle (2)
78								TRUE
79								TRUE
80	Men’s 400 m Freestyle (2)
81								TRUE
82								TRUE
83	Men’s 800 m Freestyle (2)
84								TRUE
85								TRUE
86	Men’s 1500 m Freestyle (2)
87								TRUE
88								TRUE
89	Men’s 100 m Backstroke (2)
90								TRUE
91								TRUE
92	Men’s 200 m Backstroke (2)
93								TRUE
94								TRUE
95	Men’s 100 m Breaststroke (2)
96								TRUE
97								TRUE
98	Men’s 200 m Breaststroke (2)
99								TRUE
100								TRUE