User must select the right csv files with the right formats.
Flight Schedule Format
Column A: Flight (Text)
Column B: C/S (Text)
Column C: DES (Text)
Column D: VIA (Text)
Column E: nVIA (Number)
Column F: A
Column G: Na (Text)
Column H: STD (h:mm)
Column I: ETD (h:mm)
Column J: COB
Column K: OFB (h:mm)
Column L: CTOT
Column M: RWY
Column N: ATD (h:mm)
Column O: POS (Text)
Column P: Gate 1 (Text)
Column Q: Gate 2 (Text)
Column R: CTR (Text)
Column S: REG (Text)
Column T: A/C (Text)
Column U: Date ATD (Text)
Column V: STATE
Column W REM
Column X: Rem. DEP
Column Y: Rem. DEP Daily
Staff Record Format
Column A: Group(Text)
Column B: Function (Text)
Column C: STF NO. (Text)
Column D: NA
Column E: NA
Column F: DOJ (d-mmm-yy)
Column G: Year of Service (as of 2011) (number)
Column H: DCS Trained (number)
Column I: Sabre 9W (Text)
Column J: Sabre IT (Text)
Column K: Sabre BI (Text)
Column L: Sabre VN (Text)
Column M: BABS- BA (Text)
Column O: Travelsky - CA/CZ/HX/MF/MU/NX/ZH (Text)
Column K: Babel - EY (Text)
Column L: Babel - GE (Text)
Column M: Jalpas - JL (Text)
Column N: Topas - KE (Text)
Column O: Pictures - LH (Text)
Column P: Liason - MH (Text)
Column Q: Able- NH (Text)
Column R: Artis II - OZ (Text)
Column S: Smile - PR (Text)
Column T: Jalpas - JL (Text)
Column U: Altea - QF (Text)
Column V: Royal - TG (Text)
Column W: Troya- TK (Text)
Column X: Fastair - UA (Text)
Column Y: Shares - CO (Text)
Column Z: Smile - PR (Text)
Column AA: SITA - AI (Text)
Column AB: Kriscom - SQ (Text)
Staff Roster Format
TBC by client
Flight Requirements Format
Airline_Name
No_of_Narrowed_Flights
No_of_Wide_Flights
Required_CSA
Required_CSO
|