{"text_format":"2","workbook":"xlsx","n_sheets":16,"sheets":["B1","B2","B3","B4","B6","B7","B8","B9","B10","B11","B12","B13","B14","B15","C","G"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":15,"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":"B1","index":0,"n_rows":1,"n_cols":13,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["序号","查勘站名","站址类型","区域类型","经度","纬度","运营商+工程期别","日期","查勘人","员工归属单元","项目归属单元","受阻情况","说明"]

{"sheet":"B2","index":1,"n_rows":1,"n_cols":12,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["序号","新图站名","站址类型","区域类型","经度","纬度","运营商+工程期别","日期","新图人","员工归属单元","项目归属单元","说明"]

{"sheet":"B3","index":2,"n_rows":1,"n_cols":11,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["序号","查勘段名","段类型","区域类型","运营商+工程期别","测量公里","日期","查勘人","员工归属单元","项目归属单元","说明"]

{"sheet":"B4","index":3,"n_rows":1,"n_cols":12,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["序号","新图段名","段类型","区域类型","运营商+工程期别","测量公里","皮线公里","日期","新图人","员工归属单元","项目归属单元","说明"]

{"sheet":"B6","index":4,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["序号","起点-终点","日期","姓名","员工归属单元","项目归属单元","折算工日","说明"]

{"sheet":"B7","index":5,"n_rows":1,"n_cols":12,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["序号","查勘室分站名","室分类型","经度","纬度","运营商+工程期别","覆盖平米数","日期","查勘人","员工归属单元","项目归属单元","说明"]

{"sheet":"B8","index":6,"n_rows":1,"n_cols":14,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["序号","新图室分站名","室分类型","经度","纬度","运营商+工程期别","无源天线数","有源天线数","覆盖平米数","日期","新图人","员工归属单元","项目归属单元","说明"]

{"sheet":"B9","index":7,"n_rows":1,"n_cols":13,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["序号","新图室分站名","室分类型","经度","纬度","运营商+工程期别","当日远端数","覆盖平米数","日期","新图人","员工归属单元","项目归属单元","说明"]

{"sheet":"B10","index":8,"n_rows":1,"n_cols":12,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["序号","查勘信息化项目名","经度","纬度","运营商+设计院","当日室外点位数","当日室内点位数","日期","查勘人","员工归属单元","项目归属单元","说明"]

{"sheet":"B11","index":9,"n_rows":1,"n_cols":12,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["序号","新图信息化项目名","经度","纬度","运营商+设计院","当日室外点位数","当日室内点位数","日期","新图人","员工归属单元","项目归属单元","说明"]

{"sheet":"B12","index":10,"n_rows":1,"n_cols":11,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["序号","查勘传输设备节点或机房名","经度","纬度","运营商+工程期别","当日端数","日期","查勘人","员工归属单元","项目归属单元","说明"]

{"sheet":"B13","index":11,"n_rows":1,"n_cols":11,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["序号","新图传输设备节点或机房名","经度","纬度","运营商+工程期别","当日端数","日期","新图人","员工归属单元","项目归属单元","说明"]

{"sheet":"B14","index":12,"n_rows":10,"n_cols":29,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["序号","查勘出图日期","区县","查勘站段点机房等名","查勘人","查勘人归属单元","项目归属单元","用车方式","用车类型","日行公里数","车费","直接加油费","结算油价","停车费","过路桥费","用车费小计","早餐补","中餐补","晚餐补","餐补小计","他方出车餐费","出图公里数","出图单价","出图包干小计","合计","税率","含税合计","用餐人全名电话","说明"]
[{"$nulls":15},{"$f":"K2+L2+J2*M2+N2+O2","v":0},null,null,null,{"$f":"SUM(Q2:S2)","v":0},null,null,null,{"$f":"V2*W2","v":0},{"$f":"P2+T2+U2+X2","v":0},null,{"$f":"ROUNDUP(Y2/(1-Z2),2)","v":0}]
[{"$nulls":15},{"$f":"K3+L3+J3*M3+N3+O3","v":0},null,null,null,{"$f":"SUM(Q3:S3)","v":0},null,null,null,{"$f":"V3*W3","v":0},{"$f":"P3+T3+U3+X3","v":0},null,{"$f":"ROUNDUP(Y3/(1-Z3),2)","v":0}]
[{"$nulls":15},0,null,null,null,0,null,null,null,0,0,null,0]
[{"$nulls":15},0,null,null,null,0,null,null,null,0,0,null,0]
[{"$nulls":15},0,null,null,null,0,null,null,null,0,0,null,0]
[{"$nulls":15},0,null,null,null,0,null,null,null,0,0,null,0]
[{"$nulls":15},0,null,null,null,0,null,null,null,0,0,null,0]
[{"$nulls":15},0,null,null,null,0,null,null,null,0,0,null,0]
[{"$nulls":15},0,null,null,null,0,null,null,null,0,0,null,0]

{"sheet":"B15","index":13,"n_rows":3,"n_cols":25,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["序号","费用日期","报销人归属单元号","项目归属单元","报销人","行程起城市","行程止城市","交通补助","伙食补助","住宿补助","高原补助","线下其他","线下车船","线下宾馆","线下差旅小计","房租费","非查勘用车费","办公费","招待费","入职体检","水电物管费","外包成本","住县补贴","合计","说明"]
[null,"2022-06-07","U1999","U1055P2022","张强","-","-",0,0,0,0,0,0,0,0,0,0,0,100,0,0,0,0,100,"x"]
[null,"2022-06-07","U1999","U1065P2022","张强","-","-",0,0,0,0,0,0,0,0,0,0,0,100,0,0,0,0,100,"x"]

{"sheet":"C","index":14,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"表","行数"]
[null,"B1",{"$f":"COUNTA('B1'!B:B)-1","v":0}]
[null,"B2",{"$f":"COUNTA('B2'!B:B)-1","v":0}]
[null,"B3",{"$f":"COUNTA('B3'!B:B)-1","v":0}]
[null,"B4",{"$f":"COUNTA('B4'!B:B)-1","v":0}]
[null,"B6",{"$f":"COUNTA('B6'!B:B)-1","v":0}]
[null,"B7",{"$f":"COUNTA('B7'!B:B)-1","v":0}]
[null,"B8",{"$f":"COUNTA('B8'!B:B)-1","v":0}]
[null,"B9",{"$f":"COUNTA('B9'!B:B)-1","v":0}]
[null,"B10",{"$f":"COUNTA('B10'!B:B)-1","v":0}]
[null,"B11",{"$f":"COUNTA('B11'!B:B)-1","v":0}]
[null,"B12",{"$f":"COUNTA('B12'!B:B)-1","v":0}]
[null,"B13",{"$f":"COUNTA('B13'!B:B)-1","v":0}]
[null,"B14",{"$f":"COUNTA('B14'!B:B)-1","v":0}]
[null,"B15",{"$f":"COUNTA('B15'!B:B)-1","v":2}]
[null,"合计",{"$f":"SUM(C2:C15)","v":2}]

{"sheet":"G","index":15,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,1,0,13],[1,1,1,13],[2,1,2,13],[4,1,4,6],[32,0,32,7]]}
[]
["(1)","当天上报仅保留当天数据"]
["(2)","派出支援时：工作量，按项目号识别，便于项目负责人汇总，一天之内，同时存在多个项目号工作量的，需要1个项目号对应1个文件上传。"]
[]
["二","说明"]
[]
[null,"SHEET名简称","作用","收费项","传输专业填写","无线宏站填写","无线室分填写","信息化填写"]
[null,"B1","用于记录“站”类“查勘”结果","-","-","查勘","机房查勘","机房查勘"]
[null,"B2","用于记录“站”类“新图”结果","是","-","新图","机房新图","机房新图"]
[null,"B3","用于记录“公里”类“查勘”结果","-","长度查勘","-","长度查勘","长度查勘"]
[null,"B4","用于记录“公里”类“新图”结果","是","长度新图","-","长度新图","长度新图"]
[null,"B6","用于折算记录“工日”类，用于工作调遣的路上时间结果","-","交通工日","交通工日","交通工日","交通工日"]
[null,"B7","用于记录“覆盖平米”类“查勘”结果","-","-","-","覆盖面积查勘","-"]
[null,"B8","用于记录“天线”类“新图”结果","是","-","-","天线新图","-"]
[null,"B9","用于记录“远端”类“新图”结果","按站","-","-","远端新图","-"]
[null,"B10","用于记录“点位”类“查勘”结果","-","-","-","-","点位查勘"]
[null,"B11","用于记录“点位”类“新图”结果","-","-","-","-","点位新图"]
[null,"B12","用于记录“端”类“设备查勘”结果","-","设备查勘","-","-","-"]
[null,"B13","用于记录“端”类“设备新图”结果","是","设备新图","-","-","-"]
[null,"B14","用于记录“查勘相关费用”","-","是","是","是","是"]
[null,"B15","用于记录“差旅”和“查勘之外”，的相关费用","-","是","是","是","是"]
[null,"C","不填","-","不填","不填","不填","不填"]
[null,"G","不填，说明，请认真阅读，按要求填报","-","不填","不填","不填","不填"]
[null,"K","不填","-","不填","不填","不填","不填"]
[]
["(1)","局房电源、建筑专业，工作内容为点的性质，建议按站填写在B1、B2表中；"]
["(2)","光缆、皮线光缆,仅填第一路由长度；"]
["(3)","传输设备勘察、新图的端数为本次涉及新建、扩容的设备端数，而非机房内原有设备的总端数；凡是具备独立主控板件的机架式或盒式设备，均认定为一“端”设备，头柜或ODF等配套设备不计入端数计算；"]
["(4)","一线人员漏报和重复上报的问题，单元负责人负责；"]
["(5)","传输实际出图工作量填入B4直接作为结算的数据来源，但查勘工作量也要在B3予以体现，以便掌握人员的实际工作负荷情况；"]
[]
["三、","B6交通折算工日算法"]
["因公务原因交通时间折算工日计算表"]
["序号","起点","终点","辅助","正常路程时间小时","两头从办公点到车站路上及候车小时","整天工时小时","折算工日"]
[1,"蒙自","个旧",{"$f":"B35&\"-\"&C35","v":"蒙自-个旧"},1.5,1,8,{"$f":"SUM(E35,F35)/G35","v":0.3125}]
[2,"蒙自","开远",{"$f":"B36&\"-\"&C36","v":"蒙自-开远"},2,1,8,{"$f":"SUM(E36,F36)/G36","v":0.375}]
[3,"蒙自","建水","蒙自-建水",2,1,8,0.375]
[4,"蒙自","泸西","蒙自-泸西",4,1,8,0.625]
[5,"蒙自","绿春","蒙自-绿春",5,1,8,0.75]
[6,"蒙自","元阳","蒙自-元阳",3,1,8,0.5]
[7,"蒙自","石屏","蒙自-石屏",4,1,8,0.625]
[8,"元阳","绿春","元阳-绿春",2,1,8,0.375]
[9,"个旧","开远","个旧-开远",1,1,8,0.25]
[10,"绿春","个旧","绿春-个旧",4,1,8,0.625]
["1、因工作需要调动人员路途计算工日，因个人原因（休整、事假、报账、探亲等）不计算路途工日；"]
["2、为切实推进查勘人员池组，加快项目组之间相互支援流动，需要折算往返交通时间为工日，不然去外面支援的越多越吃亏；"]
["3、云南为山区落后地区，下县人员和驻地人员，路途上消耗的时间不同，是实情，需要考虑转为工作量；"]
["4、上表中没有的路段自己按现有规则补充，“B6”中的次数需与车船票对应。"]