Spreadsheets are the ideal means by which to submit tournament results for the national ranking system. However, if you are not familiar with such program all is not lost. Merely submit all the required data to Dan Hazelwood and it will be organized for you. Using a spreadsheet format just makes the data entry easier.
| If using a spreadsheet the first and last name should
be in separate cells. | Second, the organizer should give a number to each
player and then use this number to indicate who played whom. | Third, the organizer should
indicate the 'place' a player finished (1st, 2nd, 3rd,
etc.) - this should be ordered according to ANY
scoring system the organizer was using. | Finally, the name, date, location
AP level and scoring system of the tournament are
required. | |
Click here to download an Excel spreadsheet already properly formatted.
Data Requirements
If using a spread sheet program set up your columns according to the following entries. If not using a spreadsheet just submit all the required data.
Underlined entries are required information.
* = Optional but useful data
A Position: The order a player finished in the tournament,
1 = first, 2 = second, etc.
B Surname: Player's last name.
C 1st Name: Player's first name.
D Player no.: This is a number the organizer assigns each
play to track them, used to record opponents in lines L-O.
E Army Name The name of the army the player used. This
need not be exact.
F* Date: The date used by the player.
G* Book No.: The DBM army list book in which the player's
army is found
H* List No.: The list number that corresponds to the
players army.
I* Comp Score: This is the number of VP a player
scored. (Sum of P, Q, R & S) This should be noted in
whatever system (10-0, 15-0, 32-0, or +100) the tournament
organizer used to score his tournament. (Unfortunately WDL
score can NOT be reported here; if using WDL either leave
blank or convert to 10-0.)
J* DBM No Byes: This is the number of VPs a player scored excluding any he earned from byes.
K State: The state or province of residence
L Opp 1: The "Player no." of the first round opponent
M Opp 2: The "Player no." of the second round opponent
N Opp 3: The "Player no." of the third round opponent
O Opp 4: The "Player no." of the fourth round opponent
P Score 1: The VP score the player earned in his first game. This should be reported in whatever format (32-0, 15-0, 10-0, +100) the organizer used for his tournament. (Unfortunately WDL score can NOT be reported here; if using WDL please convert VPs to the 10-0 system.)
Q Score 2: The VP score the player earned in his second game.
R Score 3: The VP score the player earned in his third game.
S Score 4: The VP score the player earned in his fourth game.