ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Output (copy column N to thread)
2
Games of the XVIII Olympiad sign-up spreadsheet
Delegation:
3
Trigram:
4
Key inputs
Number of medal entries: 0
5
Delegation name (e.g. Electrum)
Medal entries average: 0
6
Trigram (three letter code, e.g. Electrum - ETM)
Standard deviation: 0
7
Is this delegation a unified team? Yes or No
No
Target standard deviation: 50
8
Min-Max Avoidance Bonus: 1
9
User guide
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.
Automatic entries:
11
Insert skill levels (whole numbers between 0 and 100) in column F.
Archery - Men's Team
12
Check under Check entry means that one of the above boxes may not be filled.
None
13
Check under Check name means that the name of the team does not match the country name. Ignore if using unified teams.
Archery - Women's Team
14
For unified teams, put Yes in cell F7. Insert the appropriate 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.
Fencing - Men's Épée
16
None
17
Key statistics
Fencing - Men's Foil
18
Number of medal entries:
Cap of 600 per user0None
19
Medal entries average:
0
Fencing - Men's Sabre
20
Standard deviation:0None
21
Target standard deviation:
50
Fencing - Women's Épée
22
Min-Max Avoidance Bonus:
1-0.2335None
23
Fencing - Women's Foil
24
None
25
Fencing - Women's Sabre
26
None
27
28
29
30
Aquatics - artistic swimming
TrigramSkillCheck entryCheck name
Trigram (unified only)
31
Men’s Duet (1 team of 2)
32
TRUE
33
Women’s Duet (1 team of 2)
34
TRUE
35
Team (1 team)
36
TRUE
37
38
Aquatics - divingTrigramSkillCheck entry
Trigram (unified only)
39
Men’s 3 m Springboard (2)
40
TRUE
41
TRUE
42
Men’s 10 m Platform (2)
43
TRUE
44
TRUE
45
Men’s Synchronized 3 m Springboard (1 team of 2)
46
TRUE
47
Men’s Synchronized 10 m Platform (1 team of 2)
48
TRUE
49
Women’s 3 m Springboard (2)
50
TRUE
51
TRUE
52
Women’s 10 m Platform (2)
53
TRUE
54
TRUE
55
Women’s Synchronized 3 m Springboard (1 team of 2)
56
TRUE
57
Women’s Synchronized 10 m Platform (1 team of 2)
58
TRUE
59
60
Aquatics - marathon swimming
TrigramSkillCheck entry
Trigram (unified only)
61
Men’s 10 km Marathon (2)
62
TRUE
63
TRUE
64
Women’s 10 km Marathon (2)
65
TRUE
66
TRUE
67
68
Aquatics - swimmingSkillCheck entry
Trigram (unified only)
69
Men’s 50 m Freestyle (2)
70
TRUE
71
TRUE
72
Men’s 100 m Freestyle (2)
73
TRUE
74
TRUE
75
Men’s 200 m Freestyle (2)
76
TRUE
77
TRUE
78
Men’s 400 m Freestyle (2)
79
TRUE
80
TRUE
81
Men’s 800 m Freestyle (2)
82
TRUE
83
TRUE
84
Men’s 1500 m Freestyle (2)
85
TRUE
86
TRUE
87
Men’s 100 m Backstroke (2)
88
TRUE
89
TRUE
90
Men’s 200 m Backstroke (2)
91
TRUE
92
TRUE
93
Men’s 100 m Breaststroke (2)
94
TRUE
95
TRUE
96
Men’s 200 m Breaststroke (2)
97
TRUE
98
TRUE
99
Men’s 100 m Butterfly (2)
100
TRUE