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!