sparksnmagic
New member
- Joined
- Dec 4, 2004
- Messages
- 1
One thing I find cumbersome is entering route data. Ideally you could break theDEPARTURE and DESTINATION points into two fields. This has multiple beneifts:
1) It is (usually) a safe assumption that an airplane is where you left it. Therefore, the departure field could be auto-filled with the last destination for the specifiedaircraft.
2) By breaking out these two fields, you then have the opportunity to do a database lookup of the field coordinates from publicly-available data. This would allow you to fill an as-yet unavailableDISTANCE field, which could then be used to automatically determine if the flight is cross-country.
I do all this in an Excel spreadsheet I wrote. The logic and formulae are pretty straight-forward.
1) It is (usually) a safe assumption that an airplane is where you left it. Therefore, the departure field could be auto-filled with the last destination for the specifiedaircraft.
2) By breaking out these two fields, you then have the opportunity to do a database lookup of the field coordinates from publicly-available data. This would allow you to fill an as-yet unavailableDISTANCE field, which could then be used to automatically determine if the flight is cross-country.
I do all this in an Excel spreadsheet I wrote. The logic and formulae are pretty straight-forward.