After you have checked the brevet cards, entered missing RUSA numbers, and calculated finish times, use the results submission form to submit your results. Detailed instructions are included in the form.

The form allows RBAs to enter rider information directly, or to tabulate the results into a CSV (comma-separated value) text file in a format which the results submissions form recognizes – details below. (CSV files can be created and edited in a spreadsheet program such as Microsoft Excel, or in a text editor.) It is recommended that you try these programs to determine which approach you will take. In general, RBAs with a small number of participants use the direct entry method while those RBAs with a large number of participants use CSV files.

1200km+ Events Only: Submit results in alphabetical order by last name. Contact the Brevet Coordinator for the current format RM requires, which currently includes the nationality and gender of the rider.  The form will show additional Nationality and Gender columns.  Note that “nationality” is not “country of residence” – A German national currently living in San Francisco has German nationality.  Therefore, for your RM events, it’s a good idea to capture Nationality on your rider registration form.

[11/2009]  [11/2013] [12/2017]

Selecting an Event

On the results submission page you (1) select the event for which you are submitting results, (2) verify that your selection is the one you intended, (3) enter the number of starters and provide or change the route. Route Selection – Step 3 is your chance to update your original route selection if you’ve used a different route from originally planned, or provide a route (required) if you had not done so earlier.

When you reach the results entry page, you can then enter the results directly, or select a CSV file by clicking:

Want to use a CSV file for input? click here

Submitting Results - Direct Entry Method

In this method, you enter the data directly into a table of fields on a webpage.  It is an optional method for submitting brevet and the required method flèche and other team event results.

For each brevet starter enter:

• rider RUSA membership number (if a member or former member), or name (if a non-member),
• finishing time in hours and minutes,
• whether the rider finished,
• whether the rider has foreign nationality
• whether the rider is a RUSA member.

The information collected for team events is similar. For each finisher on each team enter:

• rider RUSA number (if a member), or name (if a non-member)
• 22-hour and 24-hour distances
• bicycle type
• For each team, enter the start location, starting time and finish location.
• For the event, enter the location where all teams congregated.

Submitting Results – CSV File Method

The CSV file method is only available for submitting brevet and populaire results. Use the direct entry method for team events.

To use a CSV format file, after you have created it as per the format below, begin by clicking “click here” on the results entry page:

Want to use a CSV file for input? click here

This page also has a link to a sample of the CSV format:

Example CSV

Important Tip – For RUSA members, you may want to enter both the RUSA number and rider name. That way you can easily see, after the file has been imported on the results entry page, whether the RUSA number actually matches the intended rider. If you entered “24090, Fred, Bloggs” and the results submission page displays “24090, Jane, Doe” you know that “14090” is not Fred’s RUSA number. You can find Fred’s correct number by doing a member search. If you don’t make the correction, Jane will be credited with Fred’s ride.

If you cannot submit your results using this process, contact the Brevet Coordinator.

[12/2015]

Other Methods

RBAs with large numbers of participants sometimes use databases or other specialized applications to manage information about entrants. In these cases, it may be advantageous to write a script to extract information directly from a database and create the equivalent of the CSV file described in the previous section.