User must select the right csv/txt 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
Gate Departure
Column A: Airline (Text)
Column B: Aircraft Type (Text)
Column C: CSO at Gate (Number)
Column D: CSA at Gate (Number)
Column E: Gate Opening Hours (Number)
Counter Departure
Column G: Airline (Text)
Column H: No of Narrow Aircraft (Number)
Column I: No of Wide Aircraft (Number)
Column J: CSO at Counter (Number)
Column K: CSO at Counter (Number)
Column L: Counter Opening Hours(Number)
Gate Arrival
Column N: Airline (Text)
Column O: CSO at Gate (Number)
Column P: CSO at Gate (Number)
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
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)
|