{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["订票单"],"read":"whole","date_system":"1900"}

{"sheet":"订票单","index":0,"n_rows":36,"n_cols":6,"rows_kept":36,"merged":[[0,0,0,5],[1,0,12,0],[13,0,22,0],[23,0,23,1]]}
["订票单"]
["个人信息","乘机人序号","例子",1,2,3]
[null,"姓名（中文）","张三"]
[null,"姓（大写拼音） 注：与护照的拼音一致","ZHANG"]
[null,"名（大写拼音） 注：与护照的拼音一致","SAN"]
[null,"类型 格式必须为成人、儿童（2~12周岁）、婴儿（不满2周岁）","成人"]
[null,"护照签发国代码 ","CHN"]
[null,"护照号 ","E12345678"]
[null,"出生日期 ","1990-01-01"]
[null,"性别 格式必须为M(男)/F（女）","F"]
[null,"护照有效期至 ","2020-01-01"]
[null,"手机 ",12345678910]
[null,"邮箱 ","12456@163.COM"]
["航线信息","出发城市 ","北京"]
[null,"出发机场三字代码  查询方法见须知","PEK"]
[null,"目的城市 ","伦敦"]
[null,"目的机场三字代码  查询方法见须知","LHR"]
[null,"去程出发日期 ","2019-11-01"]
[null,"去程意向航班 ","CA937"]
[null,"回程出发日期 若无，可不填写"]
[null,"回程意向航班 若无，可不填写"]
[null,"国外英文详细地址（仅限美国填写）须填写*美国地址/市/州/邮编（英文）例如：U.S.Street Address/City/State/Zip Code"]
[null,"备注 Remark"]
["信息生成列(此列内容请勿修改)",null,{"$f":"IF(C6=\"婴儿\",\"NM:1\"&C4&\"/\"&C5&CHAR(10)&\"R BO/KH3246\"&CHAR(10)&\"RMK EZW-I-C104-T1017597\"&CHAR(10)&\"C JW-JIASHU\"&CHAR(10)&CONCATENATE(\"SSR DOCS \"&IF(C19=\"\",\"CA\",LEFT(C19,2))&\" HK1 P/\",C7,\"/\",C8,\"/\",C7,\"/\",TEXT(C9,\"ddmmmyy\"),\"/\",C10,\"I\",\"/\",TEXT(C11,\"ddmmmyy\"),\"/\",C4&\"/\"&C5,\"/P1\")&CHAR(10)&\"XN:IN/\"&C4&C5&\" INF(\"&TEXT(C9,\"mmmyy\")&\")/P1\"&CHAR(10)&\"SSR INFT CA NN1 城市对等等\"&CHAR(10)&\"SSR CTCE \"&IF(C19=\"\",\"CA\",LEFT(C19,2))&\" HK1 \"&SUBSTITUTE(SUBSTITUTE(C13,\"_\",\"..\"),\"@\",\"//\")&\"/P1\"&CHAR(10)&\"OSI \"&IF(C19=\"\",\"CA\",LEFT(C19,2))&\" CTCM\"&C12&\"/P1\"&CHAR(10)&\"OSI \"&IF(C19=\"\",\"CA\",LEFT(C19,2))&\" CTCT15801003517\"&CHAR(10)&\"\\KI\"&CHAR(10)&\" \",IF(C6=\"儿童\",\"NM:1\"&C4&\"/\"&C5&CHAR(10)&\"R BO/KH3246\"&CHAR(10)&\"RMK EZW-I-C104-T1017597\"&CHAR(10)&\"C JW-JIASHU\"&CHAR(10)&CONCATENATE(\"SSR DOCS \"&IF(C19=\"\",\"CA\",LEFT(C19,2))&\" HK1 P/\",C7,\"/\",C8,\"/\",C7,\"/\",TEXT(C9,\"ddmmmyy\"),\"/\",C10,\"/\",TEXT(C11,\"ddmmmyy\"),\"/\",C4&\"/\"&C5,\"/P1\")&CHAR(10)&\"SSR CHLD \"&IF(C19=\"\",\"CA\",LEFT(C19,2))&\" HK1 \"&TEXT(C9,\"ddmmmyy\")&\"/P1\"&CHAR(10)&\"SSR CTCE \"&IF(C19=\"\",\"CA\",LEFT(C19,2))&\" HK1 \"&SUBSTITUTE(SUBSTITUTE(C13,\"_\",\"..\"),\"@\",\"//\")&\"/P1\"&CHAR(10)&\"OSI \"&IF(C19=\"\",\"CA\",LEFT(C19,2))&\" CTCM\"&C12&\"/P1\"&CHAR(10)&\"OSI \"&IF(C19=\"\",\"CA\",LEFT(C19,2))&\" CTCT15801003517\"&CHAR(10)&\"\\KI\"&CHAR(10)&\" \",\"NM:1\"&C4&\"/\"&C5&CHAR(10)&\"R BO/KH3246\"&CHAR(10)&\"RMK EZW-I-C104-T1017597\"&CHAR(10)&\"C JW-JIASHU\"&CHAR(10)&CONCATENATE(\"SSR DOCS \"&IF(C19=\"\",\"CA\",LEFT(C19,2))&\" HK1 P/\",C7,\"/\",C8,\"/\",C7,\"/\",TEXT(C9,\"ddmmmyy\"),\"/\",C10,\"/\",TEXT(C11,\"ddmmmyy\"),\"/\",C4&\"/\"&C5,\"/P1\")&CHAR(10)&\"SSR CTCE \"&IF(C19=\"\",\"CA\",LEFT(C19,2))&\" HK1 \"&SUBSTITUTE(SUBSTITUTE(C13,\"_\",\"..\"),\"@\",\"//\")&\"/P1\"&CHAR(10)&\"OSI \"&IF(C19=\"\",\"CA\",LEFT(C19,2))&\" CTCM\"&C12&\"/P1\"&CHAR(10)&\"OSI \"&IF(C19=\"\",\"CA\",LEFT(C19,2))&\" CTCT15801003517\"&CHAR(10)&\"\\KI\"&CHAR(10)&\" \"))","v":"NM:1ZHANG/SAN\nR BO/KH3246\nRMK EZW-I-C104-T1017597\nC JW-JIASHU\nSSR DOCS CA HK1 P/CHN/E12345678/CHN/01Jan90/F/01Jan20/ZHANG/SAN/P1\nSSR CTCE CA HK1 12456//163.COM/P1\nOSI CA CTCM12345678910/P1\nOSI CA CTCT15801003517\n\\KI\n "},{"$f":"IF(D6=\"婴儿\",\"NM:1\"&D4&\"/\"&D5&CHAR(10)&\"R BO/KH3246\"&CHAR(10)&\"RMK EZW-I-C104-T1017597\"&CHAR(10)&\"C JW-JIASHU\"&CHAR(10)&CONCATENATE(\"SSR DOCS \"&IF(D19=\"\",\"CA\",LEFT(D19,2))&\" HK1 P/\",D7,\"/\",D8,\"/\",D7,\"/\",TEXT(D9,\"ddmmmyy\"),\"/\",D10,\"I\",\"/\",TEXT(D11,\"ddmmmyy\"),\"/\",D4&\"/\"&D5,\"/P1\")&CHAR(10)&\"XN:IN/\"&D4&D5&\" INF(\"&TEXT(D9,\"mmmyy\")&\")/P1\"&CHAR(10)&\"SSR INFT CA NN1 城市对等等\"&CHAR(10)&\"SSR CTCE \"&IF(D19=\"\",\"CA\",LEFT(D19,2))&\" HK1 \"&SUBSTITUTE(SUBSTITUTE(D13,\"_\",\"..\"),\"@\",\"//\")&\"/P1\"&CHAR(10)&\"OSI \"&IF(D19=\"\",\"CA\",LEFT(D19,2))&\" CTCM\"&D12&\"/P1\"&CHAR(10)&\"OSI \"&IF(D19=\"\",\"CA\",LEFT(D19,2))&\" CTCT15801003517\"&CHAR(10)&\"\\KI\"&CHAR(10)&\" \",IF(D6=\"儿童\",\"NM:1\"&D4&\"/\"&D5&CHAR(10)&\"R BO/KH3246\"&CHAR(10)&\"RMK EZW-I-C104-T1017597\"&CHAR(10)&\"C JW-JIASHU\"&CHAR(10)&CONCATENATE(\"SSR DOCS \"&IF(D19=\"\",\"CA\",LEFT(D19,2))&\" HK1 P/\",D7,\"/\",D8,\"/\",D7,\"/\",TEXT(D9,\"ddmmmyy\"),\"/\",D10,\"/\",TEXT(D11,\"ddmmmyy\"),\"/\",D4&\"/\"&D5,\"/P1\")&CHAR(10)&\"SSR CHLD \"&IF(D19=\"\",\"CA\",LEFT(D19,2))&\" HK1 \"&TEXT(D9,\"ddmmmyy\")&\"/P1\"&CHAR(10)&\"SSR CTCE \"&IF(D19=\"\",\"CA\",LEFT(D19,2))&\" HK1 \"&SUBSTITUTE(SUBSTITUTE(D13,\"_\",\"..\"),\"@\",\"//\")&\"/P1\"&CHAR(10)&\"OSI \"&IF(D19=\"\",\"CA\",LEFT(D19,2))&\" CTCM\"&D12&\"/P1\"&CHAR(10)&\"OSI \"&IF(D19=\"\",\"CA\",LEFT(D19,2))&\" CTCT15801003517\"&CHAR(10)&\"\\KI\"&CHAR(10)&\" \",\"NM:1\"&D4&\"/\"&D5&CHAR(10)&\"R BO/KH3246\"&CHAR(10)&\"RMK EZW-I-C104-T1017597\"&CHAR(10)&\"C JW-JIASHU\"&CHAR(10)&CONCATENATE(\"SSR DOCS \"&IF(D19=\"\",\"CA\",LEFT(D19,2))&\" HK1 P/\",D7,\"/\",D8,\"/\",D7,\"/\",TEXT(D9,\"ddmmmyy\"),\"/\",D10,\"/\",TEXT(D11,\"ddmmmyy\"),\"/\",D4&\"/\"&D5,\"/P1\")&CHAR(10)&\"SSR CTCE \"&IF(D19=\"\",\"CA\",LEFT(D19,2))&\" HK1 \"&SUBSTITUTE(SUBSTITUTE(D13,\"_\",\"..\"),\"@\",\"//\")&\"/P1\"&CHAR(10)&\"OSI \"&IF(D19=\"\",\"CA\",LEFT(D19,2))&\" CTCM\"&D12&\"/P1\"&CHAR(10)&\"OSI \"&IF(D19=\"\",\"CA\",LEFT(D19,2))&\" CTCT15801003517\"&CHAR(10)&\"\\KI\"&CHAR(10)&\" \"))","v":"NM:1/\nR BO/KH3246\nRMK EZW-I-C104-T1017597\nC JW-JIASHU\nSSR DOCS CA HK1 P////00Jan00//00Jan00///P1\nSSR CTCE CA HK1 /P1\nOSI CA CTCM/P1\nOSI CA CTCT15801003517\n\\KI\n "},"NM:1/\nR BO/KH3246\nRMK EZW-I-C104-T1017597\nC JW-JIASHU\nSSR DOCS CA HK1 P////00Jan00//00Jan00///P1\nSSR CTCE CA HK1 /P1\nOSI CA CTCM/P1\nOSI CA CTCT15801003517\n\\KI\n ","NM:1/\nR BO/KH3246\nRMK EZW-I-C104-T1017597\nC JW-JIASHU\nSSR DOCS CA HK1 P////00Jan00//00Jan00///P1\nSSR CTCE CA HK1 /P1\nOSI CA CTCM/P1\nOSI CA CTCT15801003517\n\\KI\n "]
[]
["填表须知："]
["1.发邮件时，请保持订票单的EXCEL格式，不要删除任何列或行，作为附件发送至家属订票邮箱。"]
["2.建议您预定完公派机票后，参照公派机票的航线去预订随行家属机票；确保同时预订成功后再确认出票。"]
["3.发邮件时，邮件正文中请附上公派的航线信息，确保家属和公派行程一致。"]
["4.因使用自动导入系统，请确认填写信息的准确性，发送至家属邮箱代表以上信息无误。如因提供信息错误而造成的一切损失，旅客须自行承担。"]
["5.公派留学人员需优先订购国内民航，您所要求的其他航空公司特价机票是否符合规定需向留学服务中心进行确认。"]
["6.乘机人需持有效期内的护照及签证。（请确认护照剩余有效期大于6个月，否则有可能无法登记或入境）"]
["7.手机号、邮箱为必填项，用于接收航空公司发送的航班变更通知。"]
["8.机场三字代码查询参考网站:"]
[null,"www.airportcodes.org"]
[null,"www.world-airport-codes.com"]