There seems to be a growing trend of meet directors and timers not utilizing the HyTek meet manager or RaceTab meet manager, along with other timing companies (primarily Road Race timers) putting their cross country results into a spreadsheet format. This is okay, but the data can be simplified in the spreadsheets, eliminating multiple columns that are not necessary for parsing meet results that can cause results to be unparsable on the state level, possibly resulting in a delay of your meet's results making it into the database.
For starters, if you are utilizing the HyTek meet manager or RaceTab, you must generate a flat HTML results file, as the PDF format will not work.
We can work with other programs that generate HTML files, though we often have to go into the RAW results posted and add some text (like the race distance competed at, and specifically rename column headers to what our database recognizes.
Excel spreadsheets are acceptable, but one needs to follow the specific protocols below. After following the protocols, please e-mail the file to firstname.lastname@example.org. Please follow the protocols below to ensure your meet's results are promptly entered into the MileSplit database.
Each race needs to be in a separate file or 'sheet'. Also, MileSplit Georgia only needs the following columns of data (and nothing more)
Here are the essential columns needed from left to right. And please name each column exactly as below:
Place, Name (no commas) Team, Time
All the other data is not needed and should be deleted out of the spreadsheet you submit, including bib numbers, pace, etc, etc, etc. Delete all those columns before e-mailing us the files. Sorry to be so specific, but when using an excel spreadsheet, this is required for us to process results into the database. Also, please make sure the time is recorded in minutes and seconds, and if needed tenths or hundredths of seconds.
For example: 23:01.02 is the correct format.
Compiling results in word or doc X and self-posting will not work in the database. Follow the spreadsheet protocols above and submit the file to email@example.com
Do this correctly, and the MileSplit 'Formatted Results' will tabulate Team Scores for each race.
Below is an example of an acceptable spreadsheet.
|HS Girls 5000 Meter Run|
|3||East Coweta||Leah Pfaff||0:22:00|
|5||East Coweta||Shannon Ferry||0:22:28|
|8||Wheeler High School||Haden Drake||0:23:41|
|11||Wheeler High School||Pooja Kanyadan||0:24:24|
|12||East Coweta||Mary Ellen Goltermann||0:24:27|
|14||St. Anne Pacelli Catholic School||ShaRae Williams||0:24:33|
|15||East Coweta||Maddie Stanley||0:24:34|
|16||East Coweta||Melissa Antrim||0:24:34|
|19||East Coweta||Skyler Carder||0:25:34|
|20||East Coweta||Dillen Bertelsen||0:25:43|
|22||Wheeler High School||Jada Dixon||0:25:58|
|24||St. Anne Pacelli Catholic School||Sammi Gomez||0:26:13|
|25||Wheeler High School||Alix Foy||0:26:21|
|27||East Coweta||Madison Grace Anderson||0:26:59|
|29||Wheeler High School||Cate McCoy||0:27:10|
|31||East Coweta||Lorelie Houde||0:27:18|
|35||St. Anne Pacelli Catholic School||Karina Reeves||0:28:21|
|38||Wheeler High School||Manya Chugh||0:28:40|
|39||Wheeler High School||Michelle Namgoong||0:28:45|
|41||Wheeler High School||Abigail Duffy||0:29:15|
|42||Northgate||Mary Ellis Hulsey||0:30:13|
|43||St. Anne Pacelli Catholic School||Gabby Gurrola||0:32:06|
|44||St. Anne Pacelli Catholic School||Faye Green||0:34:05|
|45||Wheeler High School||Annah Priyadi||0:47:24|