On 2002-03-26 15:10, Aladin Akyurek wrote:
On 2002-03-26 13:57, Brian from Maui wrote:
Here's an example:
A 7:00
B 7:45
C 7:20
D 7:51
Count as 1, because although it's alloted 45(b-a) mins, it exceed 30 mins (d-c) and because it's a 717 aircraft count as 1.
table:
717 31
767 46
D10 75
I have another column between both, hence 3 on the syntax. and a cell to reference what type of aircraft.
I'm trying to get you to formulate the rules when a flight event counts as a hit (that's, 1) for a given aircraft. I'll harass you until a consistent set of rules is settled/negotiated
.
Here the list we have so far:
[1] The central object is the elapsed time: that's the time spent between departure and grounding.
YES
[2] We have for each flight event an allotted (scheduled) duration: b-a [that is, the value in B minus the value in A].
YES, however, if the flight is late, the allotted time is then deferred to the type of aircraft.
[3] We have for each flight event an actual duration: d-c [that is, the value in D minus the value in C].
YES, again the duration if the flight is late (c>a) the allotted time is then deferred to the type of aircraft.
[4] We have for each flight event the type of the aircraft involved: e [that is, the value in E].
YES
[5] We have a norm table that, for each type of aircraft, shows the allowed duration (the norm) that it needs to take for a flight (apparently for a fixed, single type of traject).
A lookup table when a certain aircraft is entered in a cell
The data area in the relevant worksheet consists of columns A:E where A houses the scheduled departure time, B scheduled arrival/grounding time, C the actual departure time, D the actual arrival/grounding time, and E the type of aircraft.
In F, we want to see a 1 for the aircraft in E, when:
ActualDuration<=AllowedDuration OR
ActualDuration<=AllotedDuration
Actual Duration<=AllowedDuration by aircraft type (717 31 mins, 767, 45 mins) and b-a
Actual duration<=Allotted duration IF C<=A
otherwise 0.
Please read this carefully. Make suggestions/corrections using the terms deined here. If needed, add new terms along with their definitions.
Am I getting close?
YES!
Aladin