Freeborn-Trammel-Kennard Labor Day 2017
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTU
1
Wind Speed-->0-4MPH
Wind Speed HC Column -->
1
2
RankSail NumberSkipperClassStart Time
(minutes)
Finish Time
(hh:mm:ss)
Elapsed Time
(hh:mm:ss)
HandicapHandicap Time
(hh:mm:ss)
3
181W. BlighCutter120:47:360:35:36501:11:12
4
224H. FinnLightning (3 person)121:31:131:19:13931:25:11
5
313I. M. ExampleOpti62:28:162:22:161381:43:06
6
#N/A#N/A#N/A
7
8
If this is the original template spreadsheet ("Scoresheet template free-for-all"), make a copy (File | Make a copy...) and work in the copy.
9
10
Determine individual race results:
11
Make the following entries on the appropriate "Race#" tab of this workbook:
12
Wind SpeedSelect wind speed range for race using pull down menu
13
Sail NumberEnter sail number
14
SkipperEnter Skipper Name
15
ClassSelect boat class using pull down menu in each cell. Alternatively, type a class name.
16
Start Time (minutes)Enter start time of each boat in minutes (e.g. 0 or 5 or 10)
17
Finish Time
(hh:mm:ss)
Enter finish time for each boat in hours:minutes:seconds format. If less than one hour, enter 0:minutes:seconds
18
19
To enter a boat that is not in the HC table, goto the Race# tab, type the class name in the class column and the handicap value in the Handicap column. Enter start and finish times as described above.
20
Delete unused rows below the last competitor
21
To put the results in order, select all of the rows with competitors (spreadsheet rows 3,4 & 5 in the example above), select Data|Sort range by column A, A->Z
22
23
Spreadsheet will calculate Elapsed Time from Start and Finish times.
24
Handicap is determined from the Wind Speed range, the boat class and the handicap values on the HC tab of this workbook or from the HC value entered on the Results tab by the user
25
Handicap Time is calculated from the Elapsed Time and the Handicap (HT=ET * 100/HC)
26
"Rank" is the rank of the Handicap Time
27
For series with more than 2 races, duplicate one of the Race# tabs (right click on tab, select "Duplicate")
28
29
Calculate overall results for a multi-race series (e.g. Rubenstien Memorial):
30
Fill in the regatta name and date in rows 2 and 3
31
Enter handicapped rankings from each race on the "Overall" tab in the "Finish" columns.
32
Enter the total number of competitors (i.e. skippers only, don't include crew) across all races. A skipper who competes in multiple races counts as one. Also fill in the number of races and the number of throwout races. The number of throwouts can be zero.
33
Feel free to delete the "Club" column for a WBYC only race
34
Select unused columns in the "Finish" area (columns D through M) and either delete or hide them. Hide all of the columns in the "Points" and "Ordered Scores" areas.
35
Delete unused rows
36
Sort the results by rank. Select all rows with results, then Data | Sort range by column A, A-> Z
37
If there are any competitors with the same rank (i.e. tied), determine the correct places manually using RRS Appendix A. Enter the correct places in the "Tie-Break" column for the tied racers only and then re-sort the results.
38
Review the results and confirm they make sense. In particular, review any ties to make sure they are sorted correctly according to the RRS.
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...
 
 
 
Instructions
Overall - Kennard
Freeborn
Trammel
HC