Days of operation refer to the days of the week on which the flight departs or arrives. Day 1 is Monday and day 7 is Sunday.
ELAPSED TIME
This field represents the time in minutes between the departure time and the arrival time, ramp to ramp. This includes any stopover time if the flight involves one or more stops.
20011004-20011005-20011006
In the example (Table 7), the time period selected was from the 4th of October 2001 to 6th of October 2001. The flight selected was not in operation on 4/10/01 shown by a “0” but was the two other days “1”.
4.4. Downloading data
Due to the large amount of flights in the world, the data generation was split into files corresponding to Back Aviation world area classification (see Table 5). All files were saved as Excel files.
4.5. Back Aviation file importing procedure
The importing procedure developed at that stage for Back Aviation data was quite similar to AMOC and ETMS procedure. Flight characteristics type of data were converted and imported. Time of flight departure and arrival expressed in local time were converted to GMT (Phase1 Paragraph 5). Airline codes expressed with two letters were converted into 3-letters codes using an airline conversion table (Phase1 Paragraph 7). In absence of information on the trajectory, using the Great Circle trajectory generator (Phase1 Paragraph 10), eight points were created along the flight from the airport of departure to the airport of arrival. No altitude was assigned to the points. The time was calculated in a proportional manner.
5
.
T
h
e
g
l
o
b
a
l
t
i
m
e
z
o
n
e
c
o
n
v
e
r
t
e
r
Because schedule data listed in Back Aviation database are expressed in local time, a global time zone converter was developed. The converter was based on an ASCII CSV (American Standards Code for Information Interchange, Comma separated values) file and the Time Zone Guide published by iSBiSTER International, Inc and updated four times a year.
The global time zone converter tool (Figure 3) is used for converting the time from a chosen time-location to another time-location. The source location and the destination location are chosen using two combo-boxes.
Figure 3: Global time zone converter interface.
A destination time-location coordinate depends on:
.
Source location.
.
Source time; the user can choose for the source time, the machine time or other time, which is typed into a text box.
Converting a time-location coordinate to another implies two steps (Figure 4)
.
Convert source time-location coordinate to UTC/GMT time knowing the standard and daylight saving time (DST) offset to add or retrieve to GMT time and the date (pattern) when the DST starts or finishes.
.
Convert UTC/GMT time to destination time-location coordinate.
Figure 4: Illustration of the conversion from local time to GMT time.
The functions that allow the conversion of time are described below:
Private Function CPatternDate(PatternYear As Long, Pattern As String, Start As
Boolean) As Date PATTERN 1: HHNN DD/MM (eg. "0000 01/04") If the pattern length is 10 then | PatternDate = Format(DD-MM-PatternYear HH:NN:00, "dd-mm-yyyy hh:nn:ss") | CPatternDate = PatternDate | Exit []
中國(guó)航空網(wǎng) www.k6050.com
航空翻譯 www.aviation.cn
本文鏈接地址：AERO2K Flight Movement Inventory Project Report(14)
