ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
• DELETE THIS TAB WHEN YOU ARE FINISHED CONVERTING
2
3
Changes from the 2013 WFTDA Game History
4
The new format of the Officiating History Document includes the following changes:
5
- Referee and NSO positions are now integrated into a single Game History sheet.
6
- WFTDA and MRDA games now are entered on the same Game History sheet and tallied on the same Summary sheet.
7
- Games for any other associations or rule sets are entered on the Other History sheet and tallied on the Other Summary sheet.
8
- Some changes have been made to add or better specify information on these sheets.
9
10
Converting to the 2015 Roller Derby Officiating Game History
11
In order to update your information from the 2013 version to the 2015 version, you will need to review and rearrange your game information in your current Game History.
12
Make a copy of your existing 2013 WFTDA Game History to use for this conversion. Be mindful of any event applications that include a link to your previous Game History.
13
The below instructions detail the required changes to your 2013 WFTDA Game History so that information may be transfered to this new document.
14
15
WFTDA Summary Tab
16
• The Personal Information fields do not change. You will need to manually enter this information into your new Game History.
17
• Officiating Clinic information is now specific to the association (WFTDA or MRDA) operating the clinic. You will enter the relevant information for any association clinics attended.
18
• All other data on this sheet are populated from the Game History sheet. You will not need to copy any additional information to your new Game History.
19
20
WFTDA Referee
21
• Format your game dates as YYYY-MM-DD, using the "123" button in the Google Docs menu bar. Select "More Formats" and then the first date option.
22
• Cut/paste the appropriate cells or retype to move the position codes from column G into column I. Add "WFTDA" to column G for each game. In column H, add "Champs" or "Playoff" as appropriate.
23
• Move the position code from column H into column I. Add "WFTDA" to column G. Add "Sanc" to column H.
24
• For those position codes already listed in column I, add "WFTDA" to column G and "Reg" to column H.
25
• Move the position codes from column J into column I. Add "WFTDA" to column G. Add "Other" to column H.
26
• For any games worked as Head Referee, add the secondary position code worked to column J. If you cannot remember what position that was, list it as IPR.
27
• Ensure all position codes follow the correct format as defined in the Instructions of the new Game History. This includes changing "ALT" to "ALTR" where you were an alternate referee.
28
• Add a column to the right of column J. Leave this column blank.
29
• If you have no NSO or Other History entries, skip directly to Move to the New Game History below.
30
31
WFTDA NSO
32
• Format your game dates as YYYY-MM-DD, using the "123" button in the Google Docs menu bar. Select "More Formats" and then the first date option.
33
• Cut/paste the appropriate cells or retype to move the position codes from column G into column I. Add "WFTDA" to column G for each game. In column H, add "Champs" or "Playoff" as appropriate.
34
• Move the position code from column H into column I. Add "WFTDA" to column G. Add "Sanc" to column H.
35
• For those position codes already listed in column I, add "WFTDA" to column G and "Reg" to column H.
36
• Move the position codes from column J into column I. Add "WFTDA" to column G. Add "Other" to column H.
37
• Move the the position code for any secondary role you served as HNSO from column L into Column J.
38
• Ensure all position codes follow the correct format as defined in the Instructions of the new Game History. This includes changing "ALT" to "ALTN" where you were an alternate NSO.
39
• Ensure that all cells in column K are either empty or include only a "Y" when Rinxter or a later association-approved electronic system (NOT league-coded apps) was used in your specific position during a game. Do not use terms like "Yes," "No," or "N."
40
• Delete column L.
41
• If you have no Other History entries, skip directly to Move to the New Game History below.
42
43
Other History
44
• Duplicate this sheet (using the arrow menu in the tab at the bottom of the document) if it includes any rulesets other than MRDA (such as Juniors [at any level]).
45
• In the first instance, delete all games that are not Men's derby.
46
• In the second instance, delete all Men's derby.
47
• In both instances, make the same changes as described in the WFTDA Referee and NSO tab directions above.
48
• In the first instance, column G should list MRDA where appropriate.
49
• In the second instance, column G should list Juniors or the alternate ruleset, according to the Other Associations Table of the Instructions sheet of this document.
50
51
Combine Tabs
52
• Copy and paste into empty cells the contents of the WFTDA Referee tab and the first instance of the Other History tab (MRDA) to the WFTDA NSO tab.
53
• Sort your game history by highlighting column A then choosing Data > Sort Sheet by Column A, Z→A in the Google Docs menu, so that the most recent games appear at the top.
54
55
Move to the New Game History
56
• Copy the combined game data, beginning at row 4 (exclude the headers) and Paste-Special-Values (Edit > Paste Special > Values only) to row 4 of the Game History sheet of the 2015 document.
57
• Copy and paste the second instance of the Other History tab (Juniors + different rules) to the Other History tab of the 2015 document in the same manner.
58
59
• You're done! Huzzah! *throws confetti*
60
61