{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["提示","差旅费报销封面","附件1、航空公司定点直销机构和代理人","附件2、住宿费标准"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"提示","index":0,"n_rows":15,"n_cols":1,"rows_kept":15}
["温馨提示"]
["\n1、差旅费属于《中央预算单位公务卡强制结算目录》范围内支出项目，出差人员必须使用公务卡支付结算。\n\n"]
["2、出差人员乘坐交通工具等级规定：\n    火车：硬席（硬座、硬卧）；\n    高铁/动车：二等座；\n    全列软席列车：二等软座；\n    轮船：三等舱；\n    飞机：经济舱；\n    公务机票左上角须有“GP”标识，无“GP”标识的机票一律不予报销（航空公司定点直销机构和代理人见后面附件1）。\n    其他交通工具（不含出租小汽车）：往返当天凭据报销；\n    乘坐交通工具超标准的，按照当天车次、可乘坐的标准报销；出发地、到达地非合肥和目的地的，不能报销；特殊情况须提交情况说明，报校长批准后方可报销；\n    因特殊情况需要中转的，中转站应在起始点之间，或按当天对应车次、座次限额报销。\n    自行驾车所发生的油费、过路过桥费、高速通行费均不能报销。"]
["3、住宿费不允许超限额（限额标准见附件2），无住宿费发票的，不得报销住宿费、交通补助、伙食补助费。\n   实际发生住宿而无住宿费发票的，如果住在自己家里，或到偏远地区出差，无法取得住宿费发票的，由出差人员说明情况并经单位领导批准，可以报销城市间交通费、伙食补助费和室内交通费，其中到偏远地区出差实际发生的住宿费用的可以在住宿费限额标准内据实报销住宿费，其他情况一般不予报销差旅费"]
["4、交通补助：参加会议、培训的按照2天核定补助天数，当天来回的按照1天核定补助天数。\n   其他类型的公务出差按照出差自然（日历）天数核定补助天数。\n   学校安排车辆接送的无交通补助；\n   无交通工具凭据的不能报销交通补助；\n   合肥市内（含庐江、巢湖、长丰、肥西、肥东）无交通补助。\n"]
["5、伙食补助标准：西藏、青海、新疆的补助标准为120元/天；\n   其他地方补助标准为100元/天（培训、会议安排伙食的无伙食补助）。\n"]
["6、市直单位工作人员到合肥市所属市县区参加会议、培训的，不报销住宿费、伙食补助和市内交通费；到合肥市所属市县区开展其他公务活动，原则上要求当天返回，因项目检查等特殊原因，不能当天往返而必须在市县区住宿或接待单位未安排伙食、交通工具而实际发生住宿、伙食、交通费用的，需说明情况并经所在单位领导批准，参照《合肥市市级审计外勤经费管理办法》，按照市（县）每天伙食费70元，交通费50元；城区每天伙食费20元，交通费20元的补助标准包干使用。\n统一安排伙食、交通工具的，不在报销伙食补助费和市内交通费。"]
["7、挂职干部生活补助等参见合组﹝2017﹞202号《关于全市挂职、异地任职干部待遇有关问题的通知》。"]
["\n8、公务卡实际支付金额与交通票、住宿费发票信息不一致的，按照实际支付金额填写报销单，并且需要本人提交情况说明，报校长批准后方可报销。\n"]
["9、差旅费报销单红色部分为打印出来手签，黄色部分为需据实填写，请勿更改表格格式（公式及表格打印设置已设定）。\n"]
["10、差旅费报销单据请勿双面打印。\n"]
["11、请出差人员认真填好本单，并将所有原始票据（包括但不限于车票、住宿费发票、与出差相关且符合报销规定的各类发票、消费记录截图、银行流水明细单等）整齐粘贴于打印好的“原始单据粘贴页”上。完成粘贴后，需依次经由部门负责人、财务科长、部门分管校长、分管财务的校长以及校长进行审核。审核无误后，请将粘贴好的单据提交至财务科办理报销手续。"]
["12、对于因出差产生的各类费用所取得的增值税专用发票、普通发票及非税票据等，其背面均需由经办人及证明人分别签字确认，以确保票据的真实性与有效性。"]
["13、若住宿费实际消费金额中包含优惠减免部分，致使按照标准单价与住宿天数计算得出的理论金额（单价×住宿天数）与实际消费金额存在差异时，请务必分行详细填列各项数据，避免表格内金额数据出现逻辑矛盾或错误。"]
["14、其他相关事项说明请参考《合肥市市直机关差旅费管理办法》（http://zwgk.hefei.gov.cn/public/4381/65278391.html）。"]

{"sheet":"差旅费报销封面","index":1,"n_rows":28,"n_cols":57,"rows_kept":28,"merged":[[0,0,0,57],[1,0,1,58],[2,34,2,36],[2,37,2,46],[2,52,2,55],[2,56,2,58],[3,0,3,4],[3,5,3,10],[3,11,3,15],[3,16,3,21],[3,22,3,28],[3,29,3,36],[3,37,3,41],[3,42,3,47],[3,48,3,52],[3,53,3,58],[4,0,4,4],[4,5,4,33],[4,34,4,38],[4,39,4,58],[5,0,5,33],[5,34,5,44],[5,45,5,58],[6,0,6,10],[6,11,6,21],[6,22,7,24],[6,25,7,27],[6,28,7,29],[6,30,7,33],[6,34,7,36],[6,37,7,38],[6,39,7,40],[6,41,7,44],[6,45,7,49],[6,50,7,52],[6,53,7,54],[6,55,7,58],[7,0,7,1],[7,2,7,3],[7,4,7,5],[7,6,7,10],[7,11,7,12],[7,13,7,14],[7,15,7,16],[7,17,7,21],[8,0,8,1],[8,2,8,3],[8,4,8,5],[8,6,8,10],[8,11,8,12],[8,13,8,14],[8,15,8,16],[8,17,8,21],[8,22,8,24],[8,25,8,27],[8,28,8,29],[8,30,8,33],[8,34,8,36],[8,37,8,38],[8,39,8,40],[8,41,8,44],[8,45,8,49],[8,50,8,52],[8,53,8,54],[8,55,8,58],[9,0,9,1],[9,2,9,3],[9,4,9,5],[9,6,9,10],[9,11,9,12],[9,13,9,14],[9,15,9,16],[9,17,9,21],[9,22,9,24],[9,25,9,27],[9,28,9,29],[9,30,9,33],[9,34,9,36],[9,37,9,38],[9,39,9,40],[9,41,9,44],[9,45,9,49],[9,50,9,52],[9,53,9,54],[9,55,9,58],[10,0,10,1],[10,2,10,3],[10,4,10,5],[10,6,10,10],[10,11,10,12],[10,13,10,14],[10,15,10,16],[10,17,10,21],[10,22,10,24],[10,25,10,27],[10,28,10,29],[10,30,10,33],[10,34,10,36],[10,37,10,38],[10,39,10,40],[10,41,10,44],[10,45,10,49],[10,50,10,52],[10,53,10,54],[10,55,10,58],[11,0,11,1],[11,2,11,3],[11,4,11,5],[11,6,11,10],[11,11,11,12],[11,13,11,14],[11,15,11,16],[11,17,11,21],[11,22,11,24],[11,25,11,27],[11,28,11,29],[11,30,11,33],[11,34,11,36],[11,37,11,38],[11,39,11,40],[11,41,11,44],[11,45,11,49],[11,50,11,52],[11,53,11,54],[11,55,11,58],[12,0,12,1],[12,2,12,3],[12,4,12,5],[12,6,12,10],[12,11,12,12],[12,13,12,14],[12,15,12,16],[12,17,12,21],[12,22,12,24],[12,25,12,27],[12,28,12,29],[12,30,12,33],[12,34,12,36],[12,37,12,38],[12,39,12,40],[12,41,12,44],[12,45,12,49],[12,50,12,52],[12,53,12,54],[12,55,12,58],[13,0,13,1],[13,2,13,3],[13,4,13,5],[13,6,13,10],[13,11,13,12],[13,13,13,14],[13,15,13,16],[13,17,13,21],[13,22,13,24],[13,25,13,27],[13,28,13,29],[13,30,13,33],[13,34,13,36],[13,37,13,38],[13,39,13,40],[13,41,13,44],[13,45,13,49],[13,50,13,52],[13,53,13,54],[13,55,13,58],[14,0,14,21],[14,22,14,33],[14,34,14,38],[14,39,14,44],[14,45,14,50],[14,51,14,58],[15,0,17,4],[15,5,15,7],[15,8,15,10],[15,11,15,13],[15,14,15,19],[15,20,17,24],[15,25,15,27],[15,28,15,30],[15,31,15,33],[15,34,15,39],[15,40,17,43],[15,44,15,46],[15,47,15,49],[15,50,15,52],[15,53,15,58],[16,5,16,7],[16,8,16,10],[16,11,16,13],[16,14,17,19],[16,25,16,27],[16,28,16,30],[16,31,16,33],[16,34,17,39],[16,44,16,46],[16,47,16,49],[16,50,16,52],[16,53,17,58],[17,5,17,7],[17,8,17,10],[17,11,17,13],[17,25,17,27],[17,28,17,30],[17,31,17,33],[17,44,17,46],[17,47,17,49],[17,50,17,52],[18,0,18,11],[18,12,18,28],[18,29,18,58],[23,0,23,4],[27,56,69,58]]}
["请先阅读、理解前一页签“提示”后，再填写本页报销单据\n\n"]
["合肥市第七中学差旅费报销单"]
[{"$nulls":34},"公务卡卡号：",{"$nulls":17},"所附单据张数："]
["经办人",{"$nulls":10},"申请部门",{"$nulls":10},"申请日期",{"$nulls":6},{"$f":"TODAY()","v":"2025-11-05"},{"$nulls":7},"出差天数",{"$nulls":10},"出差地"]
["出差事由",{"$nulls":33},"同行人姓名"]
["交通费",{"$nulls":33},"住宿费",{"$nulls":10},"其他费用"]
["起程时间地点",{"$nulls":10},"到达时间地点",{"$nulls":10},"交通\n工具",null,null,"票价",null,null,"人数",null,"金额",{"$nulls":3},"住宿费\n单价",null,null,"住宿\n天数",null,"房间\n间数",null,"金额",{"$nulls":3},"项目",{"$nulls":4},"单价",null,null,"人数",null,"金额"]
["月",null,"日",null,"时",null,"起点",{"$nulls":4},"月",null,"日",null,"时",null,"终点"]
[{"$nulls":22},"高铁",null,null,{"v":238,"d":"238.00"},null,null,1,null,{"$f":"AC9*Z9","v":{"v":238,"d":"238.00"}},{"$nulls":3},{"$f":"658.12/2","v":329.06},null,null,2,null,1,null,{"$f":"AI9*AL9*AN9","v":658.12},{"$nulls":13},{"$f":"BB9*AY9","v":0}]
[{"$nulls":22},"高铁",null,null,{"v":224,"d":"224.00"},null,null,1,null,{"$f":"AC10*Z10","v":{"v":224,"d":"224.00"}},{"$nulls":3},{"v":300,"d":"300.00"},null,null,2,null,1,null,{"$f":"AI10*AL10*AN10","v":{"v":600,"d":"600.00"}},{"$nulls":13},{"$f":"BB10*AY10","v":0}]
[{"$nulls":17}," ",{"$nulls":12},{"$f":"AC11*Z11","v":0},{"$nulls":10},0,{"$nulls":13},0]
[{"$nulls":30},0,{"$nulls":10},0,{"$nulls":13},0]
[{"$nulls":30},0,{"$nulls":10},0,{"$nulls":13},0]
[{"$nulls":30},0,{"$nulls":10},0,{"$nulls":13},0]
["交通费小计",{"$nulls":21},{"$f":"SUM(AE9:AH14)","v":{"v":462,"d":"¥462.00"}},{"$nulls":11},"住宿费小计",{"$nulls":4},{"$f":"SUM(AP9:AS14)","v":{"v":1258.12,"d":"¥1,258.12"}},{"$nulls":5},"其他费用小计：",{"$nulls":5},{"$f":"SUM(BD9:BG14)","v":{"v":0,"d":"¥0.00"}}]
["交通补助",{"$nulls":4},"标准",null,null,"天数",null,null,"人数",null,null,"交通补助小计",{"$nulls":5},"伙食补助",{"$nulls":4},"标准",null,null,"天数",null,null,"人数",null,null,"伙食补助小计",{"$nulls":5},"生活补助",{"$nulls":3},"标准",null,null,"月份/天数",null,null,"人数",null,null,"生活补助小计"]
[{"$nulls":5},80,null,null,2,null,null,1,null,null,{"$f":"F17*I17*L17+F18*I18*L18","v":{"v":160,"d":"¥160.00"}},{"$nulls":10},{"$f":"IF(COUNT(FIND({\"新疆\",\"西藏\",\"青海\"},差旅费报销封面!AM4)),120,100)","v":100},null,null,0,null,null,1,null,null,{"$f":"Z17*AC17*AF17+Z18*AC18*AF18","v":{"v":0,"d":"¥0.00"}},{"$nulls":9},1500,{"$nulls":8},{"$f":"AS17*AV17*AY17+AS18*AV18*AY18","v":{"v":0,"d":"¥0.00"}}]
[{"$nulls":5},80,{"$nulls":19},{"$f":"IF(COUNT(FIND({\"新疆\",\"西藏\",\"青海\"},差旅费报销封面!AM4)),120,100)","v":100},{"$nulls":18},50]
["报销费用合计（小写）",{"$nulls":11},{"$f":"W15+AN15+AZ15+O17+AI17+BB17","v":{"v":1880.12,"d":"¥1,880.12"}},{"$nulls":16},{"$f":"\"报销费用合计（大写）：人民币\"&SUBSTITUTE(SUBSTITUTE(TEXT(TRUNC(FIXED(M19)),\"[>0][dbnum2];[<0]负[dbnum2];;\")&TEXT(RIGHT(FIXED(M19),2),\"元[dbnum2]0角0分;;\"&IF(ABS(M19)>1%,\"元整\",)),\"零角\",IF(ABS(M19)<1,,\"零\")),\"零分\",\"整\")","v":"报销费用合计（大写）：人民币壹仟捌佰捌拾元壹角贰分"}]
["备注说明："]
[]
[]
[]
["部门负责人审核：",{"$nulls":10},"财务稽核：",{"$nulls":8},"部门分管校长审批：",{"$nulls":11},"财务分管校长审批：",{"$nulls":12},"校长审批："]
[]
[]
[]
[{"$nulls":56},"原 始 单 据 粘 贴 页"]

{"sheet":"附件1、航空公司定点直销机构和代理人","index":2,"n_rows":27,"n_cols":4,"rows_kept":27,"merged":[[1,0,1,3]]}
[]
["一、航空公司定点直销机构和代理人（24家）"]
["序号","机构名称","机构地址","联系电话"]
[1,"安徽中国青年旅行社有限责任公司","安徽省合肥市包河区屯溪路33号恒兴广场A区1701室",13866782291]
[2,"安徽汉尼航空票务代理有限公司","安徽省合肥市包河区绿地中心D座2010室",13721060774]
[3,"安徽环球航空服务有限公司","合肥市包河区马鞍山南路世纪阳光大厦9楼",18955177565]
[4,"安徽国联商务有限公司","安徽省合肥市长江中路158号","0551-66668888"]
[5,"合肥通达旅行服务有限公司","安徽省合肥市徽州大道27号银成大厦407室",18955175098]
[6,"安徽华夏航空代理服务有限公司","安徽省合肥市徽州大道30号","0551-66668888"]
[7,"安徽东科航空服务代理有限公司","安徽省合肥市金寨路高科技广场南二座九号","0551-63603333"]
[8,"合肥票盟商旅服务有限公司","安徽省合肥市庐阳区长江中路247号108室","0551-62625577"]
[9,"安徽海外旅游有限公司（安徽省中国国际旅行社）","安徽省合肥市梅山路153号","0551-62823100"]
[10,"安徽兰宇航空服务有限公司","安徽省合肥市美菱大道368号","0551-66668888"]
[11,"安徽省新视野商务旅游咨询有限公司","安徽省合肥市蜀山区潜山路绿地蓝海国际大厦C-701室","0551-62661188"]
[12,"安徽先锋航空服务有限公司","安徽省合肥市宿州路6号欣都大厦33楼",13865956073]
[13,"合肥联拓天下国际旅行社有限公司","合肥市蜀山区经济开发区湖光路自主创新产业基地三区（南区）D座19层",18867865833]
[14,"安徽航空物流有限公司","安徽省合肥市新桥国际机场","0551-63777691"]
[15,"中国东方航空股份有限公司安徽分公司合肥金寨路售票处","合肥市金寨路246号","0551-62817832"]
[16,"安徽天一航空服务有限公司","安徽省合肥市北一环濉溪路95号","0551-65603333"]
[17,"中国国际航空股份有限公司合肥营业部售票处","合肥市蜀山区长江西路297号万科金域国际写字楼1913室","0551-62853999"]
[18,"中国南方航空股份有限公司合肥营业部","蜀山区肥西路66号汇金大厦1505室","0551-64652633"]
[19,"厦门航空合肥营业部","合肥市蜀山区之心城环球中心2410室","0551-63440650"]
[20,"深圳航空合肥机场柜台","合肥新桥机场侯机楼出境大厅B岛售票柜台","0551-63775788"]
[21,"合肥浩龙物资有限公司","合肥市包河区滨湖世纪城福徽苑4栋4001","0551-66666006"]
[22,"合肥快达航空服务有限公司","安徽省合肥市蜀山区潜山路与皖河路交口望潜金融中心B座1301室",13955101340]
[23,"合肥懿飞商务有限公司","安徽省合肥市望江西路60号1村28栋203",18955175119]
[24,"安徽速仕航旅游发展有限责任公司","安徽省合肥市高新区大别山路与天龙路交口南岗科技园长河经济城E9555室",13655606267]

{"sheet":"附件2、住宿费标准","index":3,"n_rows":38,"n_cols":8,"rows_kept":38,"merged":[[0,0,0,7]]}
["市直机关国内差旅住宿标准"]
["省份",500,"其他浮动",350,"351-399","400-450","451-499",500]
["北京",{"v":500,"d":"500.00"},{"$nulls":5},{"v":500,"d":"500.00"}]
["上海市",{"v":500,"d":"500.00"},{"$nulls":5},{"v":500,"d":"500.00"}]
["广东省",{"v":450,"d":"450.00"},{"$nulls":4},{"v":450,"d":"450.00"}]
["广东省深圳",{"v":450,"d":"450.00"},{"$nulls":4},{"v":450,"d":"450.00"}]
["浙江省",{"v":400,"d":"400.00"},{"$nulls":3},{"v":400,"d":"400.00"}]
["福建厦门",{"v":400,"d":"400.00"},{"$nulls":3},{"v":400,"d":"400.00"}]
["山东青岛市",{"v":380,"d":"380.00"},"7-9月450",null,{"$f":"B9","v":{"v":380,"d":"380.00"}}]
["福建省",{"v":380,"d":"380.00"},null,null,{"v":380,"d":"380.00"}]
["天津",{"v":380,"d":"380.00"},null,null,{"v":380,"d":"380.00"}]
["江苏省",{"v":380,"d":"380.00"},null,null,{"v":380,"d":"380.00"}]
["山东省",{"v":380,"d":"380.00"},null,null,{"v":380,"d":"380.00"}]
["河南省",{"v":380,"d":"380.00"},null,null,{"v":380,"d":"380.00"}]
["云南省",{"v":380,"d":"380.00"},null,null,{"v":380,"d":"380.00"}]
["重庆市",{"v":370,"d":"370.00"},null,null,{"v":370,"d":"370.00"}]
["四川省",{"v":370,"d":"370.00"},null,null,{"v":370,"d":"370.00"}]
["贵州省",{"v":370,"d":"370.00"},null,null,{"v":370,"d":"370.00"}]
["西藏",{"v":350,"d":"350.00"},"6-9月530",{"$f":"B19","v":{"v":350,"d":"350.00"}}]
["青海省",{"v":350,"d":"350.00"},"6-9月530",{"v":350,"d":"350.00"}]
["海南省",{"v":350,"d":"350.00"},"11-2月450",{"v":350,"d":"350.00"}]
["辽宁大连市",{"v":350,"d":"350.00"},"7-9月420",{"v":350,"d":"350.00"}]
["黑龙江",{"v":350,"d":"350.00"},"7-9月420",{"v":350,"d":"350.00"}]
["河北省",{"v":350,"d":"350.00"},null,{"v":350,"d":"350.00"}]
["山西省",{"v":350,"d":"350.00"},null,{"v":350,"d":"350.00"}]
["内蒙古",{"v":350,"d":"350.00"},null,{"v":350,"d":"350.00"}]
["辽宁省",{"v":350,"d":"350.00"},null,{"v":350,"d":"350.00"}]
["吉林省",{"v":350,"d":"350.00"},null,{"v":350,"d":"350.00"}]
["浙江宁波市",{"v":350,"d":"350.00"},null,{"v":350,"d":"350.00"}]
["安徽省",{"v":350,"d":"350.00"},null,{"v":350,"d":"350.00"}]
["江西省",{"v":350,"d":"350.00"},null,{"v":350,"d":"350.00"}]
["湖北省",{"v":350,"d":"350.00"},null,{"v":350,"d":"350.00"}]
["湖南省",{"v":350,"d":"350.00"},null,{"v":350,"d":"350.00"}]
["广西",{"v":350,"d":"350.00"},null,{"v":350,"d":"350.00"}]
["陕西省",{"v":350,"d":"350.00"},null,{"v":350,"d":"350.00"}]
["甘肃省",{"v":350,"d":"350.00"},null,{"v":350,"d":"350.00"}]
["宁夏",{"v":350,"d":"350.00"},null,{"v":350,"d":"350.00"}]
["新疆",{"v":350,"d":"350.00"},null,{"v":350,"d":"350.00"}]