Upload Results
You need to be logged in with an email-based account to use this feature.
|
As a promoter or enthusiastic racer, how can I upload my results directly to crossresults.com?
|
|
Step 0: Did you just upload these results to USAC?
You're done! We can use that format too, just upload that file and and let the magic happen! If not, proceed to step 1....
Step 1: All results on one sheet!
When you save an excel file as a csv, it only takes the data from the "active sheet."
So if you're one of those people who has every category on a different sheet, it's time for some cut-and-paste.
Make a new sheet and put all your results on it, keeping categories together.
Step 2: Label Categories
We're going to read the sheet from top to bottom. We need to know where one category begins
and another ends, so put the name of each category at top of it. It should look like this:
Any row that has exactly one cell filled on it will be treated as a new category. If you don't get the categories split where you thought they should be split, check for extra data on the category-separating rows. Step 3: Label Columns
We need to know what columns have what data. The only columns that are required are "First Name" and "Last Name"
or "Full Name" or "Name." We can also use (but don't require): "Team","Time","Place","License" The first row in the excel sheet should contain your column labels. You only have to put these in the sheet once, although if you have them listed for each category that's not a problem. You first row should look like this, with the columns in any order: Step 4: Save as CSV
That's all there is to massaging your data. Go to File -> Save As... and pick the csv format
to save as. Excel will warn you that it's only going to save the active sheet. Click OK. Upload file. |