Hi,
I have an array that consists of (A) airline id number, (B) origin airport, (C) destination airport, (D) number of departures in a year, and (E) number of passengers flown in a year. For example:
A B C D E
AIRLINE ID ORIGIN DESTINATION DEPARTURES PASSENGERS
1 200 ABQ ORD 250 10000
2 200 PHX LAX 1000 25000
3 200 LAX SAN 500 12000
4 300 TPA JFK 100 5000
...............
I am trying to find the number of possible INDIRECT connections through a hub, e.g. for airline id 200, if PHX is connected to LAX and LAX is connected say to SAN, then PHX - SAN is a possible indirect connection through a hub (the hub being LAX), BUT ONLY if there is no direct connection between PHX and SAN.
So, I want to find out how many connections of the type PHX - SAN exist in my spreadsheet (i.e. there is no direct connection and there is indirect connection through a hub) and then calculate the number of departures and the number of passngers.
Your help is greatly appreciated!
I have an array that consists of (A) airline id number, (B) origin airport, (C) destination airport, (D) number of departures in a year, and (E) number of passengers flown in a year. For example:
A B C D E
AIRLINE ID ORIGIN DESTINATION DEPARTURES PASSENGERS
1 200 ABQ ORD 250 10000
2 200 PHX LAX 1000 25000
3 200 LAX SAN 500 12000
4 300 TPA JFK 100 5000
...............
I am trying to find the number of possible INDIRECT connections through a hub, e.g. for airline id 200, if PHX is connected to LAX and LAX is connected say to SAN, then PHX - SAN is a possible indirect connection through a hub (the hub being LAX), BUT ONLY if there is no direct connection between PHX and SAN.
So, I want to find out how many connections of the type PHX - SAN exist in my spreadsheet (i.e. there is no direct connection and there is indirect connection through a hub) and then calculate the number of departures and the number of passngers.
Your help is greatly appreciated!