Col 2: Date
This is the date the minirogaine will be held.
Col 3: Open Date
This is the date that registration will open. This date is also used to determine
the date when entry fees increase, the date when registation will close, and the date when an entry must be in to
qualify for swag.
Col 4: Number
For Raccoongaine, this is a Roman numeral indicating which event this is, such as XIII indicating
the 13th Raccoongaine. For the 3BC, this is the ordinal number indicating which event this is, such as 3rd for the third 3BC.
Col 5: 3-hr Cost
This is the entry fee for the 3-hour race, provided registration is made before the fee increase.
Col 6: 6-hr Cost
This is the entry fee for the 6-hour race, provided registration is made before the fee increase.
Col 7: 3-hr Late
This
is the entry fee for the 3-hr race for people who register after the fee increase but before the registration deadline.
Col 8: 6-hr Late
This is the entry fee for the 6-hr race for people who register after the fee increase
but before the registration deadline.
Col 9: 3-hr limit
This is the maximum number of people allowed in the 3-hr race.
Col 10: 6-hr limit
This is the maximum number of people allowed in the 6-hr race.
Col 11: Sponsors
This is a code indicating which sponsors should be listed in the announcement
page. The code contains one letter for each sponsor; for example, the code ZD indicates both Zanfel (Z) and
Dick's Sproting Goods (D) are sponsors. If there are no sponsors, the column should contain an asterisk (*).
Col 12: Photos
This is the URL for photos of this event in the previous year.
Col 13: Previous
This is the date in the previous year when this event was held. The form must be yymmdd
that is, 2-digit year, 2-digit month, 2-digit day
Col 14: Swag Flag
A character indicating the nature of the swag to be given away. * indicates no swag.
Col 15: !
Column 14 must contain an exclamation point and nothing else.
A word of warning about putting certain HTML in any of the columns.
I have found that when Excel converts my spreadsheet to .csv
form, it handles anything in double quotes badly. For example,
if a cell contains a double qoute, when Excel makes the .csv file, it duplicates the double quote.
During uploading, these extra double quotes
are removed; however, in general
you should avoid using double quotes unless they are syntactically required.