{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Scheduling Instructions","Codeshare Instructions","Flight Details ","Code Share details "],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Scheduling Instructions","index":0,"n_rows":40,"n_cols":4,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null,"                                  OAG SCHEDULES INFORMATION REQUEST FORM - INSTRUCTIONS"]
["Please note that the hHighlighted fields are Mandatory (Conditional fields need to  be applied as applicable) "]
["Please load all flights in one sheet, do not separate each flight onto a new sheet ",null,null,"Macro's MUST be enabled to use print options"]
[]
[]
["Column Heading","Description","M = Mandatory, C = Conditional, O = Optional"]
["Carrier Code ","Airline Designator ","M","Can be an IATA or ICAO designator "]
["Flight No.","Flight Number, lead zeros to be omitted or will be published","M"]
["Effective From / To","Effective/Discontinue Dates","O","If supplied the date must b e in the format DDMMMYY, eg 21APR09 "]
["Days of Operation","Frequency of flight operation - 1234567 ","M"]
["Dep Apt","Departure Airport","M"]
["Dept Tmnl","Departure Terminal","M","If Departure Airport has terminals, they must be supplied "]
["Dep Time","Departure Time, using 24 hour clock","M"]
["Arr Apt","Arrival Airport","M"]
["Arr Tmnl","Arrival Terminal","M","If Arrival Airport has terminals, they must be supplied "]
["Arr Time","Arrival Time, using 24 hour clock","M"]
["Acft","Aircraft - 3 character IATA equipment code, may be general or sub-type code","M","The eqipment on the 1st leg will appply to all legs unless otherwise noted "]
["Passenger Classes","Up to 26 classes per leg allowed","M","The class at the departure airport will apply to all legs - unless otherwise noted"]
["Cargo Class","2 character cargo class","C"]
["Meals","See Below","O"]
["Service Type ","See Below","M"]
["DEI's (comments)","Data Element Identifiers, e.g. non-smoking or free text. Contact Schedules Supvr for details.","O"]
["Restrictions ","Code of Traffic Restriction applicable to the leg","C","If applicable"]
["Codeshare (Yes/No)","To indicate if the flight is operating in an agreement with another airline - for a more details see Codshare Instructions","C","If applicable"]
[]
["SERVICE TYPE",null,"Meals"]
["Pasenger ","J    Scheduled passenger normal service","M   Meal (no specific meal is intended)"]
[null,"S   Scheduled passenger shuttle mode","O   Cold meal"]
[null,"G   Additional flights passenger normal service","H   Hot meal"]
[null,"C   Charter passenger only","B   Breakfast"]
[null,"B   Additional flights passenger shuttle mode","K   Continental breakfast"]
[null,"U   Scheduled passenger service op by surface vehicle","L    Lunch"]
[" ","Q   Passenger/cargo in cabin","D   Dinner"]
[null,"R   Additional flights passenger/cargo in cabin","S   Snack or brunch"]
[null,null,"F   Food for purchase"]
["Cargo /mail ","F   Loose loaded cargo and/or preloaded devices","R   Refreshments"]
[null,"A   Additional flights cargo/mail","P   Alcoholic beverages for purchase"]
[null,"V   Cargo/mail service op by surface vehicle","C   Alcoholic beverages - complimentary"]
[null,"M   Mail only   "]

{"sheet":"Codeshare Instructions","index":1,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[[13,0,13,1],[2,0,2,1],[11,0,12,1],[1,0,1,1]]}
[]
["OAG CODESHARE SCHEDULE INFORMATION - INSTRUCTIONS"]
["If you are in a codesharing agreement OAG needs to determine what type of codeshare agreement you are participating in.\n\nThe IATA Standard has allocated 'code share indicators' (referred to as SAD Indicators - 'Shared Airlines Designation') to describe each type of codeshare.\nThese SAD Indicators need to be loaded on each code share flight in order to identify the type of codeshare agreement to the public."]
["Column Heading","Description"]
["Operational Carrier Flight No","Airline responsible for operating and scheduling the flights  "]
["Marketing Carrier Flight No","Airline in agreement with another airline. The marketing carrier is not responsible for the scheduling of this flight."]
["Aircraft Owner ","The owner of the aircraft on a flight"]
["Cockpit Crew","The airline who is responsible for the cockpit crew "]
["Cabin Crew ","The airline who is responsible for the cabin crew "]
["SAD Indicator","Indicators to be used S,X,L,Z - depending on agreement - see Codeshare descriptions below."]
["Any other comments","Any additional information relating to the agreement"]
["N.B. Highlighted fields are Mandatory"]
[]
["CODESHARE TYPES AND SAD INDICATORS"]
["Codesharing - Commercial Duplicate ","This agreement is applied when the operational carrier allows seats/space to be sold by one or more different airline airlines designators. This is known as either a 'free sale' agreement or a leased block space. SAD Indicators to be used are L or Z.  (L is to be used if the codeshare partner wishes to be identified by IATA designator.  Z is to be used if the codeshare partner wishes to be identified by name only.)"]
[]
["Codesharing  - Airline Designation ","This agreement is applied when an airline operates a flight, under another carriers designator and flight number.  This flight only displays under the marketing carriers designator. SAD Indicators to be used are S or X. (S is to be used if the codeshare partner wishes to be identified by IATA designator.  X is to be used if the codeshare partner wishes to be identified by name only.)"]
[]
["Joint Operation","This agreement is between 2 airlines with the flight displayed under one airlines designator, displaying both airline designators in a Multiple Carrier Designator field. No SAD indicator is required."]
[null," "]
["Wet Lease","This is where you use another airlines aircraft/cockpit/cabin crew.  SAD Indicators used are be 'S' if the partner wishes to be identified by designator or 'X' if the partner wishes to be identified by name."]
[]
["Damp Lease","This is where you use another airlines Aircraft/cockpit or cabin crew.  SAD Indicators used are 'S' if the partner wishes to be identified by designator or 'X' if the partner wishes to be identified by name."]
[]
["Dry Lease","This is where you use another airlines Aircraft. SAD Indicators used are 'S' if the partner wishes to be identified by designator or 'X' if the partner wishes to be identified by name."]

{"sheet":"Flight Details ","index":2,"n_rows":22,"n_cols":19,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,18]]}
[]
[]
["IATA Designator:",null,null,null,null,null,null,null,null,null,null,null,"UTC / Local:",null,"Local / UTC",null,"   (delete as applicable)"]
[]
["Airline Name:",null,null,null,null,null,null,null,null,null,null,null,"Is this schedule complete? ",null,"* Yes  /  No ",null,"   (delete as applicable)"]
[]
["Submitted By:",null,null,null,null,null,null,null,null,null,null,null,"Are all flights Non-Smoking?",null,"  Yes  /  No ",null,"   (delete as applicable)"]
[]
["Date:",null,null,null,null,null,null,null,null,null,null,null,"*If Yes all flights not resubmitted will be terminated/deleted"]
[]
["Carrier  code ","Flight number ","Effective From DDMMMYY","Effective To DDMMMYY","Days of Operation numeric values ","Dep Apt","Dep Tmnl","Dep Time","Arr Apt","Arr Tmnl","Arr Time","Acft code ","Passenger Classes","Cargo Class","Meals","Service Type","DEI's (comments)","Restns","UTC"]
["N.B.  Highlighted fields in yellow are Mandatory (Conditional fields need to to be applied as applicable) ",null,null,null,null,null,null,null,null,null,null,null,"Please do not load each flight on a separate sheet "]
["EXAMPLES:"]
["AB",10,"2014-10-26","2015-03-28",4,"LHR",null,1430,"CDG",null,1530,"77X",null,"LL",null,"F",null,null," "]
[]
["AB",6123,"2015-03-29","2015-10-24",1234567,"MEX",null,1245,"ATL",null,1700,"74Y",null,"LP",null,"F",null,null," "]
["AB",6123,"2015-03-29","2015-10-24",1234567,"ATL",null,1900,"CDG",null,845,"74Y",null,"LP",null,"F"]
[]
["AB",8000,"2015-01-09","00XXX00",15,"OPO",null,2000,"FRA",null,800,"75F",null,"PP",null,"F",null,null," "]
[" "," "," "," "," "," "," "," "," "," "," "," ",null,null,null," ",null,null," "]
["AB",8465,"2015-01-01","2015-03-27",5,"HEL",null,2245,"LEJ",null,2359,"ABF",null,"PP",null,"F",null,null," "]
["AB",8465,"2015-01-01","2015-03-27",5,"LEJ",null,215,"FRA",null,830,"RFS",null,"PP",null,"V",null,null," "]

{"sheet":"Code Share details ","index":3,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[7,0,7,7],[1,0,1,7]]}
[]
["OAG CODESHARE SCHEDULES INFORMATION REQUEST FORM"]
["Operational Carrier Flight No","Marketing Carrier Flight No","Aircraft Owner ","Cockpit Crew","Cabin Crew ","SAD Indicator","Carrier Name","Any other comments"]
["EXAMPLE"]
["AB 123","BC 123","AB","AB","AB"]
[]
["AB 1234"," ",null,null,null,"X","Example Airlines","New Codeshare"]
["N.B. Highlighted fields are Mandatory"]