{"text_format":"2","workbook":"xlsx","n_sheets":13,"sheets":["目录","结算汇总表","巡检人员费用","巡检车辆燃油费用","巡检车辆折旧费用","消耗备件费用","维修人员费用表","维修车辆燃油费用","维修车辆折旧费用","应急保障费用","勤务费用","优化配时费用","供电费用"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"目录","index":0,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,1,1,7],[2,1,2,7],[3,1,3,7],[4,1,4,7],[5,1,5,7],[6,1,6,7],[7,1,7,7],[8,1,8,7],[9,1,9,7],[10,1,10,7]]}
["目   录"]
[]
[null,"一、结算汇总表"]
[null,"二、交通设施巡检费用"]
[null,"三、交通设施维修费用"]
[null,"四、应急保障与勤务费用"]
[null,"五、信号灯优化配时费用"]
[null,"六、供电费用"]

{"sheet":"结算汇总表","index":1,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[20,0,20,1]]}
["结算资金汇总表"]
["2022-01-10"]
["序号","名称","金额（元）","备注"]
["一","交通设施巡检费用",{"$f":"SUM(C5:C7)","v":2405740.55833333}]
[1.1,"巡检人员费用",{"$f":"巡检人员费用!Q25","v":1607466.66666667}]
[1.2,"巡检车辆燃油费用",{"$f":"巡检车辆燃油费用!P14","v":474541.6}]
[1.3,"巡检车辆折旧费用",{"$f":"巡检车辆折旧费用!F13","v":323732.291666667}]
["二","交通设施维修费用",{"$f":"SUM(C9:C12)","v":5249978.68122299}]
[2.1,"消耗备件费用",{"$f":"消耗备件费用!H38","v":3644844.4272}]
[2.2,"维修人员费用",{"$f":"维修人员费用表!Q23","v":1266758.62068966}]
[2.3,"维修车辆燃油费用",{"$f":"维修车辆燃油费用!P8","v":149404.8}]
[2.4,"维修车辆折旧费用",{"$f":"维修车辆折旧费用!F7","v":188970.833333333}]
["三","应急保障与勤务费用",{"$f":"SUM(C14:C15)","v":182880}]
[3.1,"应急保障费用",{"$f":"应急保障费用!P6","v":51840}]
[3.2,"勤务费用",{"$f":"勤务费用!B16","v":131040}]
["四","信号灯优化配时费用",{"$f":"SUM(C17:C18)","v":440000}]
[4.1,"优化配时费用",{"$f":"优化配时费用!C3","v":350000}]
[4.2,"主干道绿波方案设计费用",90000]
["五","供电费用",{"$f":"C20","v":646400.76}]
[5.1,"供电费用",{"$f":"供电费用!F7","v":646400.76}]
["共计",null,{"$f":"C4+C8+C13+C16+C19","v":8924999.99955632}]

{"sheet":"巡检人员费用","index":2,"n_rows":25,"n_cols":17,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,16],[24,0,24,12]]}
["交通设施巡检人员出勤统计明细表"]
["序号","人员名单","2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月","合计","人月","月费用","金额"]
[1,"王洪涛（组长）",21,27,26,23,26,26,27,24,21,26,27,{"$f":"SUM(C3:M3)","v":274},{"$f":"N3/21.75","v":12.5977011494253},7000,{"$f":"O3*P3","v":88183.908045977}]
[2,"苏鹏",21,27,26,23,26,26,27,24,21,null,null,{"$f":"SUM(C4:M4)","v":221},{"$f":"N4/21.75","v":10.1609195402299},6700,{"$f":"O4*P4","v":68078.1609195402}]
[3,"刘文博",21,27,26,23,26,26,27,24,21,26,27,274,12.5977011494253,6700,84404.5977011494]
[4,"王文静",21,27,26,23,26,26,27,24,21,26,27,274,12.5977011494253,6700,84404.5977011494]
[5,"李乔伟",21,27,26,23,26,26,27,24,21,26,27,274,12.5977011494253,6700,84404.5977011494]
[6,"柳宇峰",21,27,26,23,26,26,27,24,21,26,27,274,12.5977011494253,6700,84404.5977011494]
[7,"申建",21,27,26,23,26,26,27,24,21,null,null,221,10.1609195402299,6700,68078.1609195402]
[8,"晁月腾",21,27,26,23,26,26,27,24,21,null,null,221,10.1609195402299,6700,68078.1609195402]
[9,"陈雷",21,27,26,23,26,26,27,24,21,26,27,274,12.5977011494253,6700,84404.5977011494]
[10,"段用兵",21,27,26,23,26,26,27,24,21,26,27,274,12.5977011494253,6700,84404.5977011494]
[11,"高跃",21,27,26,23,26,26,27,24,21,26,27,274,12.5977011494253,6700,84404.5977011494]
[12,"刘达",21,27,26,23,26,26,27,24,21,26,27,274,12.5977011494253,6700,84404.5977011494]
[13,"王宝成",21,27,26,23,26,26,27,24,21,26,27,274,12.5977011494253,6700,84404.5977011494]
[14,"周立杰",21,27,26,23,26,26,27,24,21,26,27,274,12.5977011494253,6700,84404.5977011494]
[15,"孔详超",21,27,26,23,26,26,27,24,21,26,27,274,12.5977011494253,6700,84404.5977011494]
[16,"葛建军",21,27,26,23,26,26,27,24,21,26,27,274,12.5977011494253,6700,84404.5977011494]
[17,"周凤杰",21,27,26,23,26,26,27,24,21,26,27,274,12.5977011494253,6700,84404.5977011494]
[18,"崔海峰",21,27,26,23,26,26,27,24,21,26,27,274,12.5977011494253,6700,84404.5977011494]
[19,"邹楠楠",21,27,26,23,26,26,27,24,21,26,27,274,12.5977011494253,6700,84404.5977011494]
[20,"刘洋",{"$nulls":9},26,27,53,2.4367816091954,6700,16326.4367816092]
[21,"贾金豹",{"$nulls":9},26,27,53,2.4367816091954,6700,16326.4367816092]
[22,"杨岩",{"$nulls":9},26,27,53,2.4367816091954,6700,16326.4367816092]
["合计",{"$nulls":12},{"$f":"SUM(N3:N24)","v":5206},{"$f":"SUM(O3:O24)","v":239.356321839081},null,1607466.66666667]

{"sheet":"巡检车辆燃油费用","index":3,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,15],[1,2,1,12],[13,0,13,1],[1,13,2,13],[1,14,2,14],[1,15,2,15]]}
["交通设施巡检车辆燃油费用结算明细表"]
["序号","车辆信息","燃油使用量（升）",{"$nulls":10},"合计\n(升)","平均油价\n（元/升）","燃油费（元）"]
[null,null,"2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月"]
[1,"京A0JF88",584,645,626,621,624,672,664,642,684,662,684,{"$f":"SUM(C4:M4)","v":7108},6.6,{"$f":"N4*O4","v":46912.8}]
[2,"京HHL105",564,647,611,634,608,648,640,608,660,639,661,{"$f":"SUM(C5:M5)","v":6920},6.6,{"$f":"N5*O5","v":45672}]
[3,"京MED179",585,664,664,668,661,680,678,653,704,682,705,7344,6.6,48470.4]
[4,"京KLX018",600,682,662,680,663,692,683,660,703,680,704,7409,6.6,48899.4]
[5,"京FGM022",612,622,608,630,628,664,652,637,695,672,684,7104,6.6,46886.4]
[6,"京EGP583",622,712,688,703,692,714,710,700,702,680,688,7611,6.6,50232.6]
[7,"京KMP870",602,614,608,611,629,659,648,641,672,650,686,7020,6.6,46332]
[8,"京JLZ337",611,676,672,669,679,695,690,680,676,654,685,7387,6.6,48754.2]
[9,"京N5N911",616,682,660,680,664,693,681,676,679,661,695,7387,6.6,48754.2]
[10,"京EGA773（柴油）",616,704,683,700,677,705,696,685,693,671,692,7522,5.8,43627.6]
["合计",null,{"$f":"SUM(C4:C13)","v":6012},{"$f":"SUM(D4:D13)","v":6648},6482,6596,6525,6822,6742,6582,6868,6651,6884,72812,null,{"$f":"SUM(P4:P13)","v":474541.6}]

{"sheet":"巡检车辆折旧费用","index":4,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,5],[12,0,12,4]]}
["交通设施巡检车辆折旧费用结算明细表"]
["序号","车辆","型号规格","购置价（元）","残值(5%)","折旧额\n（2021年02-12月共计11个月）"]
[1,"京A0JF88","五菱",110000,{"$f":"D3*0.05","v":5500},{"$f":"(D3-E3)/48*11","v":23947.9166666667}]
[2,"京HHL105","长安",125000,{"$f":"D4*0.05","v":6250},{"$f":"(D4-E4)/48*11","v":27213.5416666667}]
[3,"京MED179","长安",125000,6250,27213.5416666667]
[4,"京KLX018","福田牌",120000,6000,26125]
[5,"京FGM022","福田牌",120000,6000,26125]
[6,"京EGP583","福田牌",120000,6000,26125]
[7,"京KMP870","福田牌",146000,7300,31785.4166666667]
[8,"京JLZ337","福田牌",146000,7300,31785.4166666667]
[9,"京N5N911","大众",158000,7900,34397.9166666667]
[10,"京EGA773（柴油）","福田牌",317000,15850,69013.5416666667]
["折旧合计（元）",{"$nulls":4},{"$f":"SUM(F3:F12)","v":323732.291666667}]
["注：根据国家最新企业所得税法实施条例，飞机、火车、轮船以外的运输工具最低折旧年限4年。"]

{"sheet":"消耗备件费用","index":5,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,7],[37,0,37,5]]}
["交通信号灯设备维修结算资金明细表"]
["序号","名称","单位","品牌","规格/参数","单价（元）","数量","总价（元）"]
[1,"一般路灯","套",null,"1.名称:信号灯\n2.规格:φ400",2353.05,161,{"$f":"F3*G3","v":378841.05}]
[2,"一般路灯","套",null,"1.名称:步道灯\n2.规格:φ300",1550.05,61,{"$f":"F4*G4","v":94553.05}]
[3,"伸臂杆","根",null,"1.名称:八棱镀锌钢制伸臂杆\n2.规格:10m",5332.57,16,85321.12]
[4,"单柱型灯杆","根",null,"1.名称:钢制镀锌步道单柱杆\n2.规格:Ø133/4.5m",1226.64,21,25759.44]
[5,"信号灯板","块",null,"1.名称:信号灯板\n2.规格:Ø400mm",360.57,487,175597.59]
[6,"蓄电池","个",null,"1.名称:蓄电池（太阳能信号灯）\n2.容量（A·h):12V200AH",1042.18,185,192803.3]
[7,"电力电缆","米",null,"1.名称:电力电缆\n2.规格:YJV-3*4\n3.敷设方式、部位:管内敷设\n4.电压等级(kV):1kV",9.14,11986,109552.04]
[8,"电力电缆","米",null,"1.名称:电力控制电缆\n2.规格:YJV-5*1.5\n3.敷设方式、部位:管内敷设\n4.电压等级(kV):1kV",8.86,30406,269397.16]
[9,"信号机","架",null,"1.名称:老式单点信号机\n2.规格:提供8相位×4块/板=32（96路输出）相位数，用户可根据实际需要选择所需的信号控制相位，可以实现“一带二”、“一带三”或更多的控制模式)",6009.62,65,390625.3]
[10,"控制箱","台",null,"1.名称:高端联网智能交通信号机箱\n2.规格:16相位以上\n3.类型:联网\n⑴.铝制前后双开门；\n⑵.壁厚：3.0mm；\n⑶.高度：1600mm；宽度：1200mm 深度：550mm ；\n⑷.风扇2个，灯管1个，手控小门1个，应急电源小门及插座1套。\n⑸.信号机支架。\n⑹.信号机基础保护罩(香槟金)，不锈钢包边,表面氟碳喷涂。含信号机控制箱7.(室外机箱符合IP55，具有通风、隔热、防水、防火、耐盐雾、防尘等性能。适应室外恶劣条件下不间断工作，箱体中使用的端子、避雷装置、熔断装置、保护装置等均符合国家有关电气安全标准要求。箱体内具有自动温度调节控制模块和排风模块，可自动调节机柜内部温度，可自动排风或加热，使机柜内温度恒定在一定温度范围内，保证系统稳定的工作,底部配备了220V接线端子、红灯输入接线端子、I/O输出接线端子、接地端子及调试专用插座（2个两相插座、2个三相插座）",3821.43,3,11464.29]
[11,"路灯及庭院灯拆除","套",null,"1.名称:信号灯拆除\n2.规格:φ400",44.85,161,7220.85]
[12,"路灯及庭院灯拆除","套",null,"1.名称:步道灯拆除\n2.规格:φ300",44.85,61,2735.85]
[13,"路灯及庭院灯拆除","套",null,"1.名称:伸臂杆拆除\n2.规格:10m",395.82,16,6333.12]
[14,"路灯及庭院灯拆除","套",null,"1.名称:单柱型灯杆拆除\n2.规格:Ø133/4.5m",226.16,21,4749.36]
[15,"路灯及庭院灯拆除","套",null,"1.名称:信号灯板拆除\n2.规格:Ø400mm",131.05,487,63821.35]
[16,"蓄电池拆除","个",null,"1.名称:蓄电池（太阳能信号灯）拆除\n2.容量（A·h):12V200AH",259.33,185,47976.05]
[17,"电力电缆拆除","米",null,"1.名称:电力电缆拆除\n2.规格:YJV-3*4\n3.敷设方式、部位:管内敷设\n4.电压等级(kV):1kV",2.53,11986,30324.58]
[18,"电力电缆拆除","米",null,"1.名称:电力控制电缆拆除\n2.规格:YJV-5*1.5\n3.敷设方式、部位:管内敷设\n4.电压等级(kV):1kV",2.19,30406,66589.14]
[19,"信号机拆除","架",null,"1.名称:老式单点信号机拆除\n2.规格:提供8相位×4块/板=32（96路输出）相位数，用户可根据实际需要选择所需的信号控制相位，可以实现“一带二”、“一带三”或更多的控制模式)",120.93,65,7860.45]
[20,"控制箱拆除","台",null,"1.名称:信号箱拆除\n⑴.铝制前后双开门；\n⑵.壁厚：3.0mm；\n⑶.高度：1600mm；宽度：1200mm 深度：550mm ；\n⑷.风扇2个，灯管1个，手控小门1个，应急电源小门及插座1套。\n⑸.信号机支架。\n⑹.信号机基础保护罩(香槟金)，不锈钢包边,表面氟碳喷涂。含信号机控制箱7.(室外机箱符合IP55，具有通风、隔热、防水、防火、耐盐雾、防尘等性能。适应室外恶劣条件下不间断工作，箱体中使用的端子、避雷装置、熔断装置、保护装置等均符合国家有关电气安全标准要求。箱体内具有自动温度调节控制模块和排风模块，可自动调节机柜内部温度，可自动排风或加热，使机柜内温度恒定在一定温度范围内，保证系统稳定的工作,底部配备了220V接线端子、红灯输入接线端子、I/O输出接线端子、接地端子及调试专用插座（2个两相插座、2个三相插座）",202.66,65,13172.9]
[21,"拆除人行道","平方米",null,"1.材质:混凝土步道砖\n2.厚度:5cm\n3.材质:混凝土基层\n4.基层厚度:15cm",33.75,943,31826.25]
[22,"人行道块料铺设","平方米",null,"1.块料品种、规格:混合混凝土步道砖200*100*60（利旧）\n2.基础、垫层、材料品种、厚度:15cm厚C25混凝土",285.58,943,269301.94]
[23,"铺种草皮","平方米",null,"1.草皮种类:冷草\n2.铺种方式:铺草卷\n3.养护期:一年",13.05,1765,23033.25]
[24,"挖沟槽土方","米3",null,"1.名称:电缆沟挖填土\n2.土壤类别:三类土\n3.挖土深度:2m 内",141.38,1403.04,198361.7952]
[25,"电缆保护管","米",null,"1.名称:地埋电缆保护管\n2.规格:Φ90\n3.材质:PE\n4.敷设方式:地埋",39.29,2923,114844.67]
[26,"人（手)孔井","座",null,"1.材料品种:标准砖\n2.规格尺寸:收口型 井深1.5m  Φ1000mm\n3.盖板材质、规格:铸铁五防井盖\n4.混凝土标号：C25",2429.43,27,65594.61]
[27,"挖基坑土方","米3",null,"1.土壤类别:三类土\n2.挖土深度:2m 内",16.71,258.82,4324.8822]
[28,"独立基础","米3",null,"1.混凝土种类:现浇\n2.混凝土强度等级:C30",550.75,227.02,125031.265]
[29,"余方弃置","米3",null,"1.废弃料品种:土方\n2.运距:按运距18km考虑\n3.渣土消纳及运输",80.96,1888.88,152923.7248]
[31,"路灯及庭院灯拆除","套",null,"1.名称:自行车道灯拆除\n2.规格:φ400mm",44.85,65,2915.25]
[32,"自行车道灯","套",null,"1.类型:自行车道灯\n2.信号灯规格、型号、组数:φ400超高亮度LED信号灯、由三个分离的发光单元组成，每个发光单元都采用无色透明透光面、透过透光面可见LED排列成图形，壳体为金属制品",1410.07,65,91654.55]
[33,"智能控制箱拆除","台",null,"1.名称:老式单点信号机拆除",124.83,65,8113.95]
[34,"信号机","架",null,"1.名称:高端联网智能交通信号机\n2.规格:16相位以上\n3.类型:联网\n⑴. 32路处理器，嵌入式Linux操作系统，18相位、48路输出、64路RS-485通信输入或32位IO开关量输入(选配IO板)；\n⑵. LCD显示屏及键盘：可以在不带电脑的情况下，方便设置和查看信号机参数；\n⑶. 提供信号灯组红绿同亮、绿冲突、机动车灯组红灯熄灭、AC220V工作电压故障、通讯故障、配时异常、检测器异常检测；\n⑷. 提供3路RS-232接口、1路RS-485接口和2路RJ-45 10M/100M自适应网口；\n⑸. 支持1路SD存储卡；\n⑹. 提供8个行人请求接口，4路紧急优先输入接口，4路公交优先输入接口，1个铁路优先输入接口；\n⑺. 支持感应控制检测器、排队检测器、反溢检测器、路段数据采集检测器；\n⑻. 提供48套日时方案，36套节假日方案，255套相序方案，每套日时方案提供48个时段；\n⑼. 具有感应控制、单点自适应控制、流量密度感应控制、全红感应控制、排队控\n制、反溢控制、可变车道控制、调拨车道控制、搭接相位控制、特勤车队优先控制、铁道、紧急救险车优先控制、BRT快速公交优先控制、临界路口控制、下匝道排队控制、二次行人过街、邻近路口有线连锁控制、无线缆协调、多时段定时控制、节假日控制、周时方案控制等多种交通信号控制功能；\n⑽. 信号控制方式:   中心控制(配时、定相控制、特勤控制、BRT信号优先策略控制)、日时/周时方案控制、本地手动控制(步进或相位控制)、本地自适应感应控制；\n⑾. 支持GPS对时(选配GPS模块)；\n⑿. 数据采集与存储；\n⒀. 一体化PDU，具备电压显示、双路电源切换等功能；\n⒁. 主机尺寸：长：486mm；高：486mm；深：290mm\n⒂.符合GB25280-2016标准；",35209.62,3,105628.86]
[36,"控制箱","台",null,"1.名称:信号机箱及混凝土基础\n⑴.铝制前后双开门；\n⑵.壁厚：3.0mm；\n⑶.高度：1600mm；宽度：1200mm 深度：550mm ；\n⑷.风扇2个，灯管1个，手控小门1个，应急电源小门及插座1套。\n⑸.信号机支架。\n⑹.信号机基础保护罩(香槟金)，不锈钢包边,表面氟碳喷涂。含信号机控制箱7.(室外机箱符合IP55，具有通风、隔热、防水、防火、耐盐雾、防尘等性能。适应室外恶劣条件下不间断工作，箱体中使用的端子、避雷装置、熔断装置、保护装置等均符合国家有关电气安全标准要求。箱体内具有自动温度调节控制模块和排风模块，可自动调节机柜内部温度，可自动排风或加热，使机柜内温度恒定在一定温度范围内，保证系统稳定的工作,底部配备了220V接线端子、红灯输入接线端子、I/O输出接线端子、接地端子及调试专用插座（2个两相插座、2个三相插座）\n3.现浇混凝土C30独立基础（120CM*60CM*100CM)",6742.38,68,458481.84]
[37,"拉管","米",null,"1.MPP拉管\n2.DN80",202.74,40,8109.6]
["合计",{"$nulls":5},{"$f":"SUM(G3:G37)","v":97528.76},{"$f":"SUM(H3:H37)","v":3644844.4272}]

{"sheet":"维修人员费用表","index":6,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,16],[22,0,22,12]]}
["交通设施维修人员费用统计明细表"]
[null,null,"2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月","合计","人月","月费用","金额"]
[1,"彭效友",20,23,22,23,22,23,23,22,23,22,23,{"$f":"SUM(C3:M3)","v":246},{"$f":"N3/21.75","v":11.3103448275862},5600,{"$f":"O3*P3","v":63337.9310344828}]
[2,"杜绍彬",20,23,22,23,22,23,23,22,23,22,23,{"$f":"SUM(C4:M4)","v":246},{"$f":"N4/21.75","v":11.3103448275862},5600,{"$f":"O4*P4","v":63337.9310344828}]
[3,"梁军",20,23,22,23,22,23,23,22,23,22,23,246,11.3103448275862,5600,63337.9310344828]
[4,"李乾成",20,23,22,23,22,23,23,22,23,22,23,246,11.3103448275862,5600,63337.9310344828]
[5,"刁云斗",20,23,22,23,22,23,23,22,23,22,23,246,11.3103448275862,5600,63337.9310344828]
[6,"韩红言",20,23,22,23,22,23,23,22,23,22,23,246,11.3103448275862,5600,63337.9310344828]
[7,"逯长辉",20,23,22,23,22,23,23,22,23,22,23,246,11.3103448275862,5600,63337.9310344828]
[8,"迈书杰",20,23,22,23,22,23,23,22,23,22,23,246,11.3103448275862,5600,63337.9310344828]
[9,"郝新春",20,23,22,23,22,23,23,22,23,22,23,246,11.3103448275862,5600,63337.9310344828]
[10,"王凯",20,23,22,23,22,23,23,22,23,22,23,246,11.3103448275862,5600,63337.9310344828]
[11,"王宝成",20,23,22,23,22,23,23,22,23,22,23,246,11.3103448275862,5600,63337.9310344828]
[12,"崔海峰",20,23,22,23,22,23,23,22,23,22,23,246,11.3103448275862,5600,63337.9310344828]
[13,"胡海山",20,23,22,23,22,23,23,22,23,22,23,246,11.3103448275862,5600,63337.9310344828]
[14,"高春旺",20,23,22,23,22,23,23,22,23,22,23,246,11.3103448275862,5600,63337.9310344828]
[15,"杨新波",20,23,22,23,22,23,23,22,23,22,23,246,11.3103448275862,5600,63337.9310344828]
[16,"齐金旺",20,23,22,23,22,23,23,22,23,22,23,246,11.3103448275862,5600,63337.9310344828]
[17,"李付国",20,23,22,23,22,23,23,22,23,22,23,246,11.3103448275862,5600,63337.9310344828]
[18,"李东明",20,23,22,23,22,23,23,22,23,22,23,246,11.3103448275862,5600,63337.9310344828]
[19,"吴景田",20,23,22,23,22,23,23,22,23,22,23,246,11.3103448275862,5600,63337.9310344828]
[20,"季长城",20,23,22,23,22,23,23,22,23,22,23,246,11.3103448275862,5600,63337.9310344828]
["合计",{"$nulls":12},{"$f":"SUM(N3:N22)","v":4920},226.206896551724,null,{"$f":"SUM(Q3:Q22)","v":1266758.62068966}]

{"sheet":"维修车辆燃油费用","index":7,"n_rows":8,"n_cols":16,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,15],[1,2,1,12],[7,0,7,1],[1,0,2,0],[1,1,2,1],[1,13,2,13],[1,14,2,14],[1,15,2,15]]}
["交通设施维修车辆燃油费用结算明细表"]
["序号","车辆信息","燃油使用量（升）",{"$nulls":10},"合计\n(升)","油价\n（元/升）","燃油费（元）"]
[null,null,"2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月"]
[1,"京Q7Z7Y3（柴油）",485,537,519,536,522,534,530,520,506,549,528,{"$f":"SUM(C4:M4)","v":5766},5.8,{"$f":"N4*O4","v":33442.8}]
[2,"京HPB822",512,519,536,563,543,519,534,541,527,521,522,{"$f":"SUM(C5:M5)","v":5837},6.6,{"$f":"N5*O5","v":38524.2}]
[3,"京CVL720",540,560,528,499,534,555,527,506,547,519,498,{"$f":"SUM(C6:M6)","v":5813},6.6,{"$f":"N6*O6","v":38365.8}]
[4,"京AM0850",501,554,537,553,540,564,554,549,534,504,530,{"$f":"SUM(C7:M7)","v":5920},6.6,{"$f":"N7*O7","v":39072}]
["合计",null,{"$f":"SUM(C4:C7)","v":2038},2170,2120,2151,2139,2172,2145,2116,2114,2093,2078,23336,null,{"$f":"SUM(P4:P7)","v":149404.8}]

{"sheet":"维修车辆折旧费用","index":8,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,5],[6,0,6,4]]}
["交通设施维修车辆折旧费用结算明细表"]
["序号","车辆","型号规格","购置价（元）","残值(5%)","11个月折旧额\n（2021年02-12月）"]
[1,"京Q7Z7Y3（柴油）","江铃",199000,{"$f":"D3*0.05","v":9950},{"$f":"(D3-E3)/48*11","v":43323.9583333333}]
[2,"京HPB822","江铃",145000,{"$f":"D4*0.05","v":7250},{"$f":"(D4-E4)/48*11","v":31567.7083333333}]
[3,"京CVL720","江铃",189000,9450,41146.875]
[4,"京AM0850","江铃",335000,16750,72932.2916666667]
["折旧合计（元）",{"$nulls":4},{"$f":"SUM(F3:F6)","v":188970.833333333}]
["注：根据国家最新企业所得税法实施条例，飞机、火车、轮船以外的运输工具最低折旧年限4年。"]

{"sheet":"应急保障费用","index":9,"n_rows":6,"n_cols":16,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,15],[1,2,1,12],[5,0,5,14],[1,0,2,0],[1,1,2,1],[1,13,2,13],[1,14,2,14],[1,15,2,15]]}
["应急保障费用结算明细表"]
["序号","应急服务内容","各月份应急保障(台班)",{"$nulls":10},"合计\n(台班)","单价\n（元/台班）","金额（元）"]
[null,null,"2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月"]
[1,"发电机使用",10,9,14,16,21,17,15,11,9,7,12,{"$f":"SUM(C4:M4)","v":141},280,{"$f":"N4*O4","v":39480}]
[2,"太阳能临时信号灯使用",12,7,9,8,14,11,9,8,6,11,8,{"$f":"SUM(C5:M5)","v":103},120,{"$f":"N5*O5","v":12360}]
["合计",{"$nulls":14},{"$f":"SUM(P4:P5)","v":51840}]

{"sheet":"勤务费用","index":10,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,1,1,3],[1,4,1,6],[1,7,1,9],[12,1,12,3],[12,4,12,6],[12,7,12,9],[13,1,13,3],[13,4,13,6],[13,7,13,9],[14,1,14,3],[14,4,14,6],[14,7,14,9],[15,1,15,9],[1,0,2,0]]}
["勤务费用结算明细表"]
["勤务保障任务","勤务人员",null,null,"勤务保障车辆",null,null,"笔记本电脑"]
[null,"勤务量","数量","小计","勤务量","数量","小计","勤务量","数量","小计"]
["百年大庆保障",24,2,{"$f":"B4*C4","v":48},24,1,{"$f":"E4*F4","v":24},24,1,{"$f":"H4*I4","v":24}]
["高考保障",27,2,{"$f":"B5*C5","v":54},27,1,{"$f":"E5*F5","v":27},27,1,{"$f":"H5*I5","v":27}]
["中考保障",24,2,48,24,1,24,24,1,24]
["成人高考保障",2,2,4,2,1,2,2,1,2]
["公务员考试保障",3,2,6,3,1,3,3,1,3]
["英语美术考试保障",2,2,4,2,1,2,2,1,2]
["外宾迎接勤务保障",13,2,{"$f":"B10*C10","v":26},13,1,{"$f":"E10*F10","v":13},13,1,{"$f":"H10*I10","v":13}]
["过境车辆勤务保障",4,2,8,4,1,4,4,1,4]
["国展保障",5,2,{"$f":"B12*C12","v":10},5,1,{"$f":"E12*F12","v":5},5,1,{"$f":"H12*I12","v":5}]
["合计",{"$f":"SUM(D4:D12)","v":208},null,null,{"$f":"SUM(G4:G12)","v":104},null,null,{"$f":"SUM(J4:J12)","v":104}]
["单价（元/台班）",320,null,null,500,null,null,120]
["金额（元）",{"$f":"B13*B14","v":66560},null,null,{"$f":"E13*E14","v":52000},null,null,{"$f":"H13*H14","v":12480}]
["总金额（元）",{"$f":"B15+E15+H15","v":131040}]

{"sheet":"优化配时费用","index":11,"n_rows":182,"n_cols":13,"rows_kept":182,"cut":false,"hidden":false,"merged":[[4,0,4,12]]}
[]
["配时路\n口数量","年服务费用\n（元）","金额\n（元）"]
[{"$f":"COUNT(A7:A181)","v":175},2000,{"$f":"A3*B3","v":350000}]
[]
["优化配时路口清单表"]
["序号","路口名称","2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月"]
[1,"安宁大街裕安路",1,null,null,null,1,null,null,1]
[2,"安庆大街与裕庆路",{"$nulls":6},1]
[3,"白马路良白路",null,1,{"$nulls":6},1]
[4,"白马路水上公园儿",null,null,null,1,{"$nulls":5},1]
[5,"白马路右堤路",{"$nulls":9},1]
[6,"白马路与后郝家疃路",{"$nulls":4},1,{"$nulls":4},1]
[7,"白马路与火寺路",null,null,1,{"$nulls":6},1]
[8,"白马路与坤安路",{"$nulls":7},1]
[9,"白马路与木北路配",null,1,{"$nulls":6},1]
[10,"白马路与木燕路",{"$nulls":4},1,null,null,null,1]
[11,"白马路与南陈路",null,null,null,1,{"$nulls":5},1]
[12,"白马路与与恒兴路",{"$nulls":8},1]
[13,"白马路与左堤路",{"$nulls":10},1]
[14,"北木路火寺路",null,null,1,{"$nulls":5},1]
[15,"昌金路火寺路",{"$nulls":8},1]
[16,"昌金路与水色时光花园路",null,null,null,2,{"$nulls":5},1]
[17,"陈马路木北路",{"$nulls":9},1]
[18,"陈庄与左堤路",{"$nulls":5},1]
[19,"府前街大东路",{"$nulls":9},1]
[20,"港馨西区调",{"$nulls":9},1]
[21,"港馨西区西门",{"$nulls":6},1,3]
[22,"恒兴路与开元街",null,null,null,1,{"$nulls":4},1]
[23,"胡各庄小学",{"$nulls":9},1]
[24,"汇海南路与富元大街",{"$nulls":9},1]
[25,"汇海南路与四纬路",null,null,null,1,{"$nulls":5},2]
[26,"火沙路高白路",{"$nulls":10},1]
[27,"火沙路古城村中心街路",null,null,null,1,{"$nulls":4},1]
[28,"火沙路与高白路",{"$nulls":9},1]
[29,"火沙路与美术学院 ",{"$nulls":7},1]
[30,"火沙路与裕庆路",{"$nulls":4},1,null,1,2]
[31,"火沙路与裕庆路 ",{"$nulls":7},1]
[32,"火沙路裕丰路",{"$nulls":9},1]
[33,"火沙路中央美术学院",{"$nulls":8},1]
[34,"火寺路与机场北线南路",{"$nulls":10},1]
[35,"机场北街与顺畅大道",{"$nulls":9},1]
[36,"机场北线顺航路",1,{"$nulls":5},1]
[37,"机场北线与顺航路",{"$nulls":6},1]
[38,"机场东路三四营路",{"$nulls":5},1]
[39,"机场东路四维路",{"$nulls":10},1]
[40,"机场东路四纬路",{"$nulls":7},2]
[41,"机场东路与李天路",null,null,1,null,null,1]
[42,"机场东路与龙塘路",{"$nulls":7},2]
[43,"机场东路与三四营村路",{"$nulls":7},1]
[44,"机场东路与苏活路",{"$nulls":7},1]
[45,"金航西路与顺平路",null,1,{"$nulls":8},1]
[46,"京沈安详",{"$nulls":4},1,{"$nulls":4},1]
[47,"京沈火沙辅路",{"$nulls":9},1]
[48,"京沈路安宁大街",{"$nulls":9},1]
[49,"京沈路火沙路",{"$nulls":9},1]
[50,"京沈路顺于路",{"$nulls":10},1]
[51,"京沈路与安宁大街",null,null,1,null,1,null,null,null,1]
[52,"京沈路与安宁大街路",{"$nulls":7},1]
[53,"京沈路与安祥大街路",{"$nulls":7},1]
[54,"京沈路与国展地铁站路",null,null,null,1,null,null,null,1]
[55,"京沈路与后沙峪地铁站路",{"$nulls":7},1]
[56,"京沈路与火沙辅线",{"$nulls":7},1]
[57,"京沈路与火沙辅线路",null,null,1,{"$nulls":4},1]
[58,"京沈路与火沙路路",{"$nulls":7},1]
[59,"京沈路与良白路",1,{"$nulls":8},1]
[60,"京沈路与天北路",{"$nulls":7},1,1]
[61,"京沈路与天纬二街路",1,{"$nulls":6},3,1]
[62,"经纬中路与富元南街",{"$nulls":5},1]
[63,"经纬中路与正元南街",1,{"$nulls":4},1]
[64,"坤安路与顺恒大街",null,null,1,{"$nulls":5},1]
[65,"李木路与崇国庄路",null,null,1,{"$nulls":4},1]
[66,"李天路机场二高桥下",null,null,1,{"$nulls":4},1]
[67,"李天路樱花园路",null,null,1,null,null,null,1]
[68,"李天路与丰荣酒店门口",null,null,1,null,null,null,1]
[69,"李天路与南半壁店小区路",null,1,{"$nulls":4},1]
[70,"林荫路与杨林大道路",null,null,1,{"$nulls":4},1]
[71,"柳各庄与顺平南线",null,null,1,{"$nulls":6},1]
[72,"龙塘路崇各庄路",null,null,1,{"$nulls":5},1]
[73,"龙塘路平沿路",null,1,{"$nulls":5},1]
[74,"龙塘路与平沿路",null,null,1,{"$nulls":5},1]
[75,"龙塘路与通顺路",null,null,1,null,null,1]
[76,"龙塘路与左堤路",null,1,null,null,null,1]
[77,"龙塘路庄子营路",null,null,1,{"$nulls":6},1]
[78,"木北路小店路",null,null,1,{"$nulls":4},2,null,null,1]
[79,"木北路与顺平路",1,{"$nulls":8},1]
[80,"木邵路木林小学",{"$nulls":7},1]
[81,"木燕路南辛庄村口",{"$nulls":7},1]
[82,"木燕路与左堤路",1,{"$nulls":4},1]
[83,"南陈路毛家营",null,null,null,1,{"$nulls":4},1]
[84,"南陈路与顺于路",null,null,null,1,{"$nulls":5},1]
[85,"乾安路顺祥街",null,null,1,null,null,1]
[86,"三家店村口",null,null,null,1,{"$nulls":5},1,1]
[87,"山丁支线龙林路",null,null,null,1,{"$nulls":5},1]
[88,"石园大街顺泰路",null,1,null,1,{"$nulls":5},1]
[89,"顺白路西辛小区",{"$nulls":7},1]
[90,"顺白路与良白路",null,null,1,null,null,1]
[91,"顺白路与外环路",1,{"$nulls":7},1]
[92,"顺白路中晟馨苑",null,null,null,1,null,null,null,2,1]
[93,"顺驰路物流园六街",null,null,1,1,null,null,1]
[94,"顺和路和外环路",{"$nulls":8},1]
[95,"顺和路与和平街",{"$nulls":10},1]
[96,"顺密路与后鲁各庄路路",null,1,{"$nulls":5},1]
[97,"顺密路与木燕路",{"$nulls":7},1]
[98,"顺密路与前鲁各庄路",{"$nulls":7},1]
[99,"顺平辅线与李魏路",{"$nulls":7},1]
[100,"顺平辅线与顺密路",{"$nulls":10},1]
[101,"顺平辅线与拥军路",{"$nulls":8},1]
[102,"顺平路安乐庄村口",{"$nulls":8},1]
[103,"顺平路滨河南口",{"$nulls":5},1]
[104,"顺平路南焦路",{"$nulls":7},1]
[105,"顺平路南线与左堤路",{"$nulls":6},1]
[106,"顺平路顺畅大道",null,null,null,1,{"$nulls":5},1]
[107,"顺平路与杜庄村",{"$nulls":8},1]
[108,"顺平路与环镇东路",null,null,null,1,{"$nulls":4},1]
[109,"顺平路与机场东路",{"$nulls":7},1]
[110,"顺平路与李木路",{"$nulls":6},1,null,1]
[111,"顺平路与木北路",null,null,null,1,{"$nulls":4},1]
[112,"顺平路与木燕路",{"$nulls":8},2]
[113,"顺平路与南焦路",{"$nulls":8},1]
[114,"顺平路与顺畅大道",{"$nulls":7},1,null,1]
[115,"顺平路与顺康路",{"$nulls":7},1]
[116,"顺平路与顺密路",{"$nulls":5},1]
[117,"顺平路与顺泰路",{"$nulls":5},1,1,null,null,1]
[118,"顺平路与万福烤鸭店",null,1,{"$nulls":6},1]
[119,"顺平路与新顺南大街",null,1,{"$nulls":5},1]
[120,"顺平路与中干渠",{"$nulls":4},1,null,null,null,1]
[121,"顺平南线与柴家村路",null,null,null,1,null,1]
[122,"顺平南线与东华山",null,1,null,null,null,1]
[123,"顺平南线与李木路",{"$nulls":5},1]
[124,"顺平南线与李魏路",{"$nulls":5},1,null,1]
[125,"顺平南线与龙土南路",{"$nulls":5},1]
[126,"顺平南线与龙尹路",{"$nulls":5},1]
[127,"顺平南线与木北路",{"$nulls":5},2]
[128,"顺平南线与木燕路",{"$nulls":5},1]
[129,"顺平南线与七大路",{"$nulls":5},1]
[130,"顺平南线与赵湘路",{"$nulls":5},1]
[131,"顺平南线与中干渠路",{"$nulls":5},1]
[132,"顺平南线与左堤路",1,{"$nulls":4},1]
[133,"顺沙路 白良路",1,{"$nulls":7},1]
[134,"顺沙路高白路",{"$nulls":10},1]
[135,"顺沙路与火寺路",1,{"$nulls":4},1]
[136,"顺沙路与万万树",{"$nulls":8},1]
[137,"顺沙路与右堤路",1,{"$nulls":7},1]
[138,"顺沙路张喜庄路",{"$nulls":9},1]
[139,"顺于路南焦路",{"$nulls":7},1]
[140,"顺于路顺达路",1,{"$nulls":7},1]
[141,"顺于路外环路",{"$nulls":4},1,{"$nulls":4},1]
[142,"顺于路与高白路",{"$nulls":4},1,null,null,null,1]
[143,"顺于路与南焦路",{"$nulls":4},1,null,null,null,1]
[144,"顺于路与前景路",null,1,null,null,1,{"$nulls":5},1]
[145,"四纬路与北斗路",null,null,1,null,null,1]
[146,"四纬路与金桥路",null,1,null,null,null,1]
[147,"四纬路与经纬中路",null,1,null,1,null,1]
[148,"苏活小区的临时红绿灯",{"$nulls":7},1]
[149,"天北路花园西街路",null,1,{"$nulls":5},1]
[150,"天北路天柱东路",{"$nulls":7},1]
[151,"天北路与安宁大街",1,null,null,null,1,null,null,null,1]
[152,"天北路与花园西街",1,1,null,null,1,null,null,1]
[153,"天北路与兆丰二街",null,null,null,1,null,1]
[154,"天北路与兆丰一街",null,1,null,null,null,1]
[155,"天柱东路与丽苑街",{"$nulls":7},1]
[156,"天柱路 天纬二街",null,1,null,1,{"$nulls":4},1]
[157,"天柱路与天纬二街",{"$nulls":8},1]
[158,"通顺路石园南大街",null,1,{"$nulls":5},1]
[159,"通顺路与滨河北路",null,1,null,null,null,1]
[160,"通顺路与金牛街",{"$nulls":7},1]
[161,"通顺路与龙塘路现场",null,null,null,1,{"$nulls":5},1]
[162,"通顺路与石园大街",{"$nulls":8},1]
[163,"通顺路与石园大街路",1,null,null,null,1,null,null,null,1]
[164,"通顺路与顺丰大街",{"$nulls":7},1]
[165,"通顺路与西丰乐村",null,null,1,{"$nulls":7},1]
[166,"通顺路与幸福西区",{"$nulls":10},1]
[167,"杨镇小学",{"$nulls":4},1,{"$nulls":4},1]
[168,"赵陈路与顺密路",{"$nulls":7},1]
[169,"正元大街与汇海南路",1,{"$nulls":8},2]
[170,"正元大街与经纬中路",{"$nulls":5},1]
[171,"正元大街与鑫桥中路",{"$nulls":4},2,{"$nulls":5},2]
[172,"正元南街与汇海南路",{"$nulls":9},2]
[173,"中干渠杨镇东大街",null,1,null,null,1,null,null,null,1]
[174,"中干渠与顺密路",{"$nulls":8},1]
[175,"左堤路与太平路",{"$nulls":5},1]
["合计",null,{"$f":"SUM(C7:C181)","v":17},21,22,23,18,35,12,57,43,39,16]

{"sheet":"供电费用","index":12,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[[6,0,6,1],[0,0,1,6]]}
["供电费用估算表"]
[]
["序号","项目名称","计量单位","数量","综合单价","合价","备注"]
[1,"电卡充值费用","项",1,308837.33,{"$f":"D4*E4","v":308837.33},"详见实施方案"]
[2,"抄表支付费用","项",1,261154.39,261154.39]
[3,"协议用电费用（待支付）","项",1,76409.04,76409.04]
["小计",{"$nulls":4},{"$f":"SUM(F4:F6)","v":646400.76}]