minirogaine.csv

The file minirogaine.csv holds all information related to mini-rogaine events for the year. This file must be copied to the web server about the beginning of each year; it can be updated as more events are added to the schedule. There are 3 steps: 1) Download the minirogaine.csv file; 2) Edit the file using Excel or Open Office and save it; 3) Upload the edited minirogaine.csv file. The information in the file is in the form of a spreadsheet that has been saved in .csv (comma separated value) form.  Each row of the spreadsheet has 17 values (columns).  Each row represents one minirogaine. The rows must list the minirogaines in chronological order; however, the first row is for column labels.  The following describes the contents of each column - the titles used are the labels to be used in row #1.  It is VERY important that all cells used in the spreadsheet have a Text format and that NO commas are used in any cell. If you think you need a comma, use a semicolon. The descriptions below are for what should be entered in the cells of a spreadsheet. After editing, be sure to save the spreadsheet in a file named minirogaine.csv

Col 1:   Name
This must consist of a single word: Raccoon for Raccoongaine or Babcock for the Babcock Bog & Boulder Challenge

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 follows an asterisk and contains one letter for each sponsor; for example, the code ZD indicates both Zanfel (Z) and Dick's Sporting Goods (D) are sponsors and would look like this *ZD. 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; for example, 250426 for April 26, 2025.

Col 14:  Swag
The swag item to be given away. * indicates no swag.

Col 15:  Image
The name of the file which is an image of the swag item. For no swag or undecided, use swagdefault.htm or leave blank.

Col 16:  Maximum
The maximum number of points possible for the courses.

Col 17:  !
Column 17 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.

Return to WPOC Welcome Page    or   Exclusive Member Pages    or   General Management Actions