Girls Dual Middleton @ Memorial 4/16/19
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
USER GUIDE
2
3
1) Change team name on scoring tab from Team A and Team B, highlighed in yellow, to the team names. Cells in each event will automatically update based on Conference Regs from 01-Jun-2016
4
2) Enter the gender that the sheet is being used for on the scoring tab in cell A2. Use either "Girls" or "Boys" as only these will populate the sheet. All other tabs will be populated with the appropriate gender and the high hurdle distance
5
3) Places need to be entered into the cells as a number (ie, 1, 2, 3, 4) and not a place (ie, 1st, 2nd, 3rd, etc). The data will only pull into the scoring tab if the place numbers are correct. Only put places on varsity events
6
4) The 400m needs to be entered in 0:00.0 format. If the time is less than 1 minute, enter the leading 0. For example, 52.4 seconds would be 0:52.4
7
5) Field events need to have the "foot" symbol entered with the distance. Enter the fraction of an inch as a decimal. For example, a long jump of 15 feet, 5 and 1/2 inch would be entered as 15'5.5.
8
6) Any ties in field events will need to have the results hand entered into the scoring tab. The spreadsheet is not smart enough to do both
9
7) After all values are entered into a tab for a specific event, the scoring for that event will be automatically calculated. Scoring for events with a tie have to be calculated manually.
10
7a) For individual events, 5 points for 1st, 3 points for 2nd, 1 point for 3rd
11
7b) For relays, 5 points for 1st, 0 points for 2nd.
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
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
Loading...