User must select the right csv files with the right formats.
User must select the right csv files with the right formats.
Data format is ignored if irrelevant
Flight Schedule Format - Departure
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
Flight Schedule Format - Arrival
Column A: Flight (Text)
Column B: C/S (Text)
Column C: ORG (Text)
Column D: VIA (Text)
Column E: nVIA (Number)
Column F: A
Column G: Na (Text)
Column H: STA (h:mm)
Column I: ETA (h:mm)
Column J: TMO
Column K: ATA (h:mm)
Column L: RWY
Column M: EON (h:mm)
Column N: ONB (h:mm)
Column O: POS (Text)
Column P: Gate 1 (Text)
Column Q: Belt (Text)
Column R: REG (Text)
Column S: A/C (Text)
Column T: Date ATA (Text)
Column U: STATE
Column V: REM
Column W Rem. ARR
Column X: Rem. ARR Daily
Flight Requirements Format
Column A: Airline (Text)
Column B: No_of_Narrowed_Flights (Number)
Column C: No_of_Wide_Flights (Number)
Column D: Ctr_Required_CSO (Number)
Column E: Ctr_Required_CSA (Number)
Column F: Gate_Required_CSO (Number)
Column G: Ctr_Required_CSA (Number)
Staff Record Format
Column A: Group(Text)
Column B: Function (Text)
Column C: STF NO. (Text)
Column D:
Column E:
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
Column A: StaffNo (Text)
Column B: RosterID (Text)
Column C: RosterCycle (Text)
Column D: Mon (Normal shift - Row [2]: Start Time, Row [3]: End Time, Split Shift – Row[2]: 1st Start Time – End Time, Row[3] 2nd
Start Time – End Time) (Text)
Column E: Tue (Normal shift - Row [2]: Start Time, Row [3]: End Time, Split Shift – Row[2]: 1st Start Time – End Time, Row[3] 2nd
Start Time – End Time) (Text)
Column F: Wed (Normal shift - Row [2]: Start Time, Row [3]: End Time, Split Shift – Row[2]: 1st Start Time – End Time, Row[3] 2nd Start Time – End Time) (Text)
Column G: Thu (Normal shift - Row [2]: Start Time, Row [3]: End Time, Split Shift – Row[2]: 1st Start Time – End Time, Row[3] 2nd Start Time – End Time) (Text)
Column H: Fri (Normal shift - Row [2]: Start Time, Row [3]: End Time, Split Shift – Row[2]: 1st Start Time – End Time, Row[3] 2nd Start Time – End Time) (Text)
Column I: Sat (Normal shift - Row [2]: Start Time, Row [3]: End Time, Split Shift – Row[2]: 1st Start Time – End Time, Row[3] 2nd Start Time – End Time) (Text)
Column J: Sun (Normal shift - Row [2]: Start Time, Row [3]: End Time, Split Shift – Row[2]: 1st Start Time – End Time, Row[3] 2nd Start Time – End Time) (Text)
|