TRANSITRACE LOG FILE FORMAT, V2
1) 2) 3) 4) 5)
# TT F2A Thu Jul 20 2006 13:58:27 Round: 1 WORLD CHAMPS 06
6) 7) 8)
# Comp: 23 MAGNE, Jean Attempt: 2
9) 10) 11) 12) 13) 14) 15)
# ETime MTime1 MTime2 MTime3 ESpeed MSpeed EResult MResult Ruling
12.5060 0.00 0.00 0.00 287.861 0.000 287.8 0.0 $ Electronic
# Timed Flight Laps: 9 - 17 16)
# Individual laps:
17) 18) 19)
# Lap Speed(km/h) Time Stamp Course Speed(km/h)
0 31.0009376
1 131.238 34.0488290
2 175.587 36.3269046
3 234.383 38.0335143
4 271.704 39.5057041
5 288.070 40.8942559
6 288.358 42.2814215
7 288.755 43.6666794
8 288.224 45.0544878
9 288.306 46.4419023 233.146
10 288.171 47.8299672 261.227
11 288.296 49.2174286 279.275
12 288.065 50.6060023 286.340
13 288.322 51.9933380 288.285 20)
14 287.824 53.3830783 288.258 $ Missed lap inserted
15 287.326 54.7752241 288.143
16 287.136 56.1682901 287.963
17 287.306 57.5605331 287.861
18 288.695 58.9460761 287.904
19 289.108 60.3296435 288.007
20 236.688 62.0196304 281.202
21 141.376 64.8489610 252.756
21)
# Handle Events:
# Engaged 41.5719157
1) Category (Other than F2A are possible)
2) Weekday, month, day and year
3) Time of day in 24 hour format
4) Round number
5) Contest Name (optional)
6) Competitor number
7) Competitor Name (optional)
8) Attempt number
9) Electronic time (taken by the system)
10) Stopwatch times entered by the operator, 3x
11) Speed calculated from the electronic time
12) Speed calculated from the stopwatch times according to the detailed rules.
13) Electronically obtained speed after truncating/rounding according to the rules.
14) Manually obtained speed after truncating/rounding according to the rules.
15) Operator’s decision on the official result (Electronic, Manual, or Canceled)
16) Laps making up the official flight
17) Individual lap speed
18) Time in seconds from the attempt start for every sensor detection. The actual accuracy is
around three to four decimals, but the added decimals are given to be able to backtrack
the program calculations with full accuracy. Let us say you want the average speed over
laps 13-16. Take the time stamp for lap 16, subtract that of lap 12. As it it four laps,
take 4 x 400 = 1600 and divide this by the time difference.
19) Speed for the most recent official distance (For F2A one kilometre, nine laps)
20) The software found that the lap time was doubled, likely by a missed sensor detection.
A lap is inserted by interpolation after an OK by the operator.
For this case, a comparison to the secondary system, where the lap was not missed,
shows that the error of this interpolation is less than 0.001 sec.
21) Here the times for the operator signals for the pilot engaging or disengaging the handle
in the pylon are listed. All events until the official flight is completed get listed.
Each flight gets listed on a separate page if the file is printed.
To use the file for off-line analysis in an Excel spreadsheet or other application:
Copy the file to a Windows system. To import the data into Excel:
(a) Open the file using Notepad or other plain text editor.
(b) Select the text to import.
(c) Copy to the clipboard. (Ctrl-Insert)
(d) In Excel, locate the cursor in the upper left cell of the area where you want the data.
(e) Paste the data from the clipboard. (Shift-Insert) All fields of the log file are tab-separated,
so the numbers will be occupy one cell each.
It is possible to get a chart of the speed vs. lap using the Excel Chart Wizard: Select the group of cells
with the lap numbers and speed data. Click on the Chart Wizard. Select Chart Type: XY, and any of the sub-types.
Click Next a couple of times and then Finish. Done!