Excelnoob123
New member
- Joined
- Jan 17, 2019
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Mac Microsoft Excel
Hi,
I am trying to create something called network units.
To do that I have two separate airport schedules. One for all landings, and one for all departures. I have been trying to figure out how to write a code to identify to generate the possible combinations within a 2 to 6 hour connection. I would be grateful for help if anyone knows how to write such a code. A snapshot of the data is provided below.
If there is data on the left side of hub timing, it means an arriving flight.
If there is data on the left side of hub timing, it means a departing flight.
I am trying to create something called network units.
To do that I have two separate airport schedules. One for all landings, and one for all departures. I have been trying to figure out how to write a code to identify to generate the possible combinations within a 2 to 6 hour connection. I would be grateful for help if anyone knows how to write such a code. A snapshot of the data is provided below.
If there is data on the left side of hub timing, it means an arriving flight.
If there is data on the left side of hub timing, it means a departing flight.
Equip | Op Days | Mkt Al | Flight | Stops | Orig | Dep Time | Hub timing | Arr Time | Dest | Stops | Mkt Al | Flight | Op Days | Equip | Seats | Ops/Week |
789 | 1234567 | EY | 487 | 0 | PER | 1705 | 0035 | 7 | ||||||||
32B | 1234567 | TK | 868 | 0 | IST | 1915 | 0055 | 7 | ||||||||
388 | 1234567 | EY | 20 | 0 | LHR | 1405 | 0120 | 7 | ||||||||
0150 | 0615 | IST | 0 | TK | 869 | 1234567 | 32B | 178 | 7 | |||||||
0205 | 0645 | DUB | 0 | EY | 45 | 123456. | 77W | 412 | 6 | |||||||
0205 | 0645 | DUB | 0 | EY | 45 | ......7 | 77W | 380 | 1 | |||||||
0210 | 0625 | LHR | 0 | BA | 72 | 1234567 | 789 | 216 | 7 |