#C parramon Comment entered by the
operator. That it appears twice is a bug!
#C parramon: Bob Fogg used this to
enter the name. Other comments also appear.
1) 2) 3) 4)
# TT FAI_F2A Round 3 10:16:14 Fri Jul 09 2004
5) 6) 7) 8) 9) 10) 11) 12) 13)
# Comp Attempt Etime Mtime1 Mtime2 Mtime3 ESpeed MSpeed EOff MOff Ruling
7 1 12.1652 12.03 12.15 12.07 295.926 297.931 295.9 297.9 $
Electronic
# Timed Flight Laps:
7 – 15 14)
# Individual laps:
15) 16) 17)
# Lap Speed(km/h)
Time Stamp Course Speed(km/h)
1 137.620 127.9822393
2 213.729 129.8537710
3 275.729 131.3044700
4 283.747 132.7141754
5 287.920 134.1034498
6 290.682 135.4795220
7 292.492 136.8470825
8 294.071 138.2072993
9 295.066 139.5629280 248.495
10 295.663 140.9158189 278.345
11 296.373 142.2654699 290.049
12 296.733 143.6134835 292.469
13 297.202 144.9593702 293.993
14 297.582 146.3035364 295.080
15 298.239 147.6447419 295.926
16 298.699 148.9838842 296.619
17 299.344 150.3201403 297.205
18 293.635 151.6823734 297.043
19 197.700 153.7056458 281.474
# Handle Events: 18)
# Engaged 132.045
1)
Category (Other than F2A are possible)
2)
Round number
3)
Time of day in 24 hour format
4)
Weekday, month, day and year
5)
Competitor number
6)
Attempt number
7)
Electronic time (taken by the system)
8)
Stopwatch times entered by the operator
9)
Speed calculated from the electronic time
10)
Speed calculated from the stopwatch times
according to the detailed rules.
11)
Electronically obtained speed after
truncating to one decimal.
12)
Manually obtained speed after truncating to
one decimal.
13)
Operator’s decision on which of the speeds
should be used as the official result (Always electronic by decision of the
organizers.)
14)
Laps making up the official flight
15)
Individual lap speed
16)
Time in seconds from the attempt start for
each sensor pass. 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. Le'ts 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.
17)
Speed for the most recent kilometre (nine
laps)
18)
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!
The format might change in future versions of the TT program!