|
Export Results in HY-TEK's Semicolon Delimited Format |
Top Previous Next |
|
Results Formats Results for the meet can be exported in a semi-colon delimited file format as described below. To export results, click on Main Menu / File / Import / Semi-Colon Delimited Rosters/Entries File / Export Results. The export results file will have up to 3 types of detailed records within the file.
E = Individual Event Result Record - one for each round R = Relay Event Result Record - one for each round
Note: If an athlete runs the 100 in prelims, semis, and finals, there will be 3 E records for that result.
Results Export Record - Header Record
Data Max Notes for H Record 1 H 1 Header Record 2 Meet Name 45 3 Meet Start Date 10 MM/DD/YYYY 4 Meet End Date 10 MM/DD/YYYY 5 File Created By 50 HY-TEK version 6 Date File Created 10 7 Comment 100 Optional
Results Export Record - Individual Event
Data Max Notes for E Record 1 E 1 Individual Event Result Record 2 T, F, M, TM, or FM 2 T=Running event; F=Field Event; M=overall combined-event; TM=Multi Running Event; FM=Multi Field Event 3 Event Number 4 4 Alternate Event # 4 5 Event Code 10 Examples: 100, 5000S, 10000W, SP, HJ, DEC 6 Event Gender 1 M = Male, F = Female, X = Mixed 7 Event Age Range 5 blank if Open; 11-12; 30-34; 30&over; 19&under 8 Event Division 2 blank or 1 to 99 9 Division Name 15 blank or JV; Varsity; Bantam 10 Round 1 P=Prelims, Q=Quarter-Finals S = Semi-Finals, F = Finals 11 Result Mark 10 Time: hh:mm:ss.tt (1:23.44.55, 1:19.14, 58.83, 13.4h) Field: Metric: 12.33; English: 12'10.25, 14'10, 11' Combined-event: 5586 (points) 12 Event meas. 1 M for Metric, E for English 13 Wind Reading 4 0.3, -1.2 if applicable 14 overall Place 3 15 Heat Place 3 16 Heat Number 2 17 Exhibition 1 X = exhibition; blank if not exhibition 18 Team Points 3 19 Pts if Multi-Evt 5 Points scored for this one individual combined-event 20 Sub-Event # 2 1 thru 10 if combined-event; if zero, then this record is overall total ranking for combined-event and Result Mark will be total pts 21 Age Graded 10 Age Graded Mark for Veterans 22 Age Graded % 6 23 Last Name 20 24 First Name 20 25 Initial 1 26 Athlete Gender 1 M = Male, F = Female 27 Birth Date 10 MM/DD/YYYY 28 Team Code 4 limited to 4 characters 29 Team Name 25 30 Age 3 31 School Year 2 32 Competitor # 5 33 Registration # 12
Results Export Record - Relay Event
Data Max Notes for R Record 1 R 1 Relay Event Results Record 2 Team Name 25 example: Hurricanes A, Strikers B 3 Event Number 4 4 Alternate Event # 4 5 Event Code 10 Examples: 400, 1600S, 3200D (see page S-8) 6 Event Gender 1 M = Male, F = Female, X = Mixed 7 Event Age Range 5 blank if Open; 11-12; 30-34; 30&over; 19&under 8 Event Division 2 blank or 1 to 99 9 Division Name 15 blank or JV; Varsity; Bantam 10 Round 1 P = Prelims, Q = Quarter-Finals S = Semi-Finals, F = Finals 11 Result Mark 10 Time: hh:mm:ss.tt (1:19.14, 58.83) 12 Event meas. 1 M for Metric, E for English 13 Team Abbrev. 4 14 Overall Place 3 15 Heat Place 3 16 Heat Number 2 17 Exhibition 1 X = exhibition; blank if not exhibition 18 Team Points 3 19 R1 Last Name 20 20 R1 First Name 20 21 R1 Initial 1 22 Athlete Gender 1 M = Male, F = Female 23 Birth Date 10 MM/DD/YYYY 24 Age 3 25 School Year 2 26 Competitor # 5 27 Registration # 12
== Same pattern for runners 2 through 8 (Fields 28-90) ==
Results Export Team Score
Data Notes for T Record 1 T Team Score Record 2 Event Type Examples: C = Cross-country, R = Road-race, Blank = Combined team score record 3 Event Number and Event Letter 0 = Combined team score record 4 Team Number 5 Team Name 6 Team Score 7 ; Semicolon
Examples: T;C;6;729;Aurora;1395; T; ;0;583;Pittsburg State;10;591;Rogers State;8;596;Southern Arkansas;5;598;Bacone College;8;738;Columbus;10;757;Frontenac;6;
Note: The export of results in semi-colon delimited format includes JD places.
|