ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Surfcomp Member List Import Instructions
2
Before beginning, you need to make a copy of this Google Sheet: File > Make a Copy. Make sure to name it as follows: "Boardriders Club Name - Surfcomp Members Import Sheet"
3
1. Before entering any information, you need to organise your member list spreadsheet, first before copying and pasting into this online Google Sheet.
4
5
2. Name the Division tabs (bottom of page) with a Division name in the following format:
6
a.Long Description:Open
7
b.Short Description: (two CAP letters only)OP
8
c.Tab Name: (no spaces)Open,OP
9
10
3. Add as many divisions as your club runs competitions in. Make sure you have unique member numbers for all.
11
(see Column A - member number)
12
Just click the division tab menu (small triangle), and click "Duplicate", then copy in real members details and rankings. Make sure to remove/delete any sample sheets (Junior,JR - Division 2 etc) once you are done.
13
14
When you have completed all divisions, with all required details, simply share this file with the administrator email, gtgart@gmail.com
15
16
NB: email field is mandatory, so if there is no email address for user, then just leave dummy
17
email in place on sheet. See note on sheet - Email Address - header.
18
19
Leaderboard Importing: Please note that if you are onboarding your club mid season and need to bring in prior rounds results, make sure to fill in these additional columns with the members points for each round.
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