Simple Database Build

[Andyaf]

Hi,

I need some help building a simple database for a flight project I'm working on. The file is attached. Tab 1 (Updated Flight list) is pulling information for a website that lists all flight times (starts on row 92). The second tab, "Selection" is a filter I've created based on a drop down menu of all airlines.

I need help filtering the data. For example, when I select " American Airlines" from the dropdown, only American airlines information should show up on the selection tab.

Any ideas how this can be done?

Thanks very much for the help!

-Andrew

 

[Luke M]

You could use a formula based approach like this one:
http://chandoo.org/wp/2011/11/18/formula-forensics-003/
or you could setup a event macro to use Advanced Filter to copy the data over. Those would be my first two suggestions.

 

[SirJB7]

Crossposted at: http://chandoo.org/forum/threads/real-time-flights-database.13676/

 

[SirJB7]

Hi, Andyaf!

Give a look at the uploaded file. These are the main characteristics:
- It implements a web query on Airlines (I don't know why yet, since worksheet Selection became unnecessary), Arrivals and Departures.
- The refreshing time is set in worksheet Parameteres (most time goes in the web query 15-30" for 3-6Mbps connection, and 1-2" for processing).
- It schedules the update of worksheet Flights (main) and it's user controlled (Ok, Cancel), manually run or stoppable.
- It has filters on all data columns and sort on selected column.

The problems:
a) Date: How do you define the date regarding the time retrieved? The time is Boston time, or origin time (for arrivals? Why if the webpage says it display a 4 hour schedule, there're flights with times with more hours (10 or so) from the time being?
b) Persistence: How many time do you want to keep the older (i.e., not lastly retrieved) information? How do you unequivocally identify a flight? I assumed that it was by the flight number, but there're duplicates with the same time (orange shaded) and with different time (yellow shaded), despite of the same or different airline.
c) Actual time: How do you calculate this field?
d) Status: Which are the status that are irreversible, ergo not updated any more? I think of Landed for arrivals and In Flight for Departures. This's related to c).

Regards!