{"text_format":"2","workbook":"xlsx","n_sheets":7,"sheets":["管理端-移网质量类","客户端-战略考核","管理端-重复投诉率","投诉处理时长、超时工单概况","客户端-投诉问题解决满意度","客户端-投诉问题解决率","客户端-投诉问题响应率"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":15,"n_cols":24,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,23]]}
["2023年客服投诉清单各地市投诉率情况（管理端-移网质量类）"]
["地市","1日","2日","3日","4日","5日","6日","7日","8日","9日","10日","11日","12日","13日","14日","15日","16日","投诉总量","用户数","目前万投率","本月预测","目标值","与目标差距","地市"]
["保定",33,24,25,36,24,33,60,50,30,37,31,30,27,22,18,16,496,254.4,1.949685534591195,3.7775157232704402,3,0.77751572327044016,"保定"]
["沧州",24,27,18,13,11,12,22,28,27,28,28,27,22,12,16,45,360,234.9,1.5325670498084292,2.9693486590038316,3,-3.0651340996168397E-2,"沧州"]
["承德",3,6,5,6,9,12,7,7,5,9,16,10,8,2,9,9,123,103.8,1.1849710982658961,2.2958815028901736,2.9,-0.60411849710982635,"承德"]
["邯郸",20,33,20,16,12,11,29,28,43,50,18,11,20,16,8,15,350,275.7,1.2694958287994198,2.4596481682988758,2.9,-0.44035183170112413,"邯郸"]
["衡水",21,17,12,9,5,8,12,16,10,23,10,8,9,6,2,13,181,154.9,1.1684958037443511,2.2639606197546804,2.5,-0.23603938024531956,"衡水"]
["廊坊",18,13,5,5,16,19,14,13,15,12,15,20,23,6,14,24,232,166.2,1.3959085439229844,2.7045728038507821,3,-0.29542719614921786,"廊坊"]
["秦皇岛",4,6,2,11,5,11,5,12,14,7,3,4,3,10,10,11,118,103.1,1.1445198836081476,2.217507274490786,3,-0.782492725509214,"秦皇岛"]
["石家庄",42,44,21,25,35,25,29,46,57,55,47,65,55,35,39,34,654,376.8,1.7356687898089171,3.3628582802547768,3,0.36285828025477684,"石家庄"]
["唐山",13,11,19,22,13,26,25,28,12,9,26,11,14,22,11,34,296,248.5,1.1911468812877264,2.3078470824949697,3,-0.69215291750503027,"唐山"]
["邢台",16,10,11,15,10,15,26,22,16,11,12,17,13,12,11,19,236,181.1,1.3031474323578134,2.5248481501932636,2.9,-0.37515184980673633,"邢台"]
["雄安",1,7,6,5,1,6,1,5,2,4,4,2,4,1,3,3,55,27.4,2.007299270072993,3.8891423357664241,3.7,0.18914233576642392,"雄安"]
["张家口",3,7,11,11,13,9,4,13,11,6,9,5,13,6,8,9,138,98.6,1.3995943204868155,2.7117139959432053,2.9,-0.18828600405679463,"张家口"]
["全省",198,205,155,174,154,187,234,268,242,251,219,210,211,150,149,232,3239,2225.3000000000002,1.4555340852918706,2.820097290252999,3,-0.17990270974700096,"全省"]

{"sheet":"客户端-战略考核","index":1,"n_rows":15,"n_cols":24,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,23]]}
["2023年客服投诉清单各地市投诉率情况（客户端-战略考核）"]
["地市","1日","2日","3日","4日","5日","6日","7日","8日","9日","10日","11日","12日","13日","14日","15日","16日","投诉总量","用户数","目前万投率","本月预测","目标值","与目标差距","地市"]
["保定",36,16,20,26,26,32,29,32,28,34,21,24,20,13,17,16,390,253.73134328358199,1.5370588235294123,2.9780514705882362,2.93,4.8051470588236E-2,"保定"]
["沧州",10,19,14,13,9,16,21,19,24,18,20,17,24,17,13,34,288,234.209313047487,1.2296692913385843,2.3824842519685072,2.76,-0.37751574803149257,"沧州"]
["承德",8,11,6,7,5,11,5,16,8,4,14,9,11,10,11,5,141,102.49453613686001,1.3756830882352988,2.6653859834558915,3.35,-0.68461401654410858,"承德"]
["邯郸",5,24,13,13,9,12,15,14,34,27,15,12,20,15,17,12,257,275.00280615108301,0.93453591836734751,1.8106633418367357,2.37,-0.55933665816326439,"邯郸"]
["衡水",12,13,6,10,8,12,6,10,6,11,8,10,5,5,5,10,137,154.99145716377799,0.88391968503937224,1.7125943897637836,1.79,-7.7405610236216393E-2,"衡水"]
["廊坊",13,9,4,6,14,15,14,8,13,8,11,19,21,8,7,13,183,165.04854368932001,1.1087647058823555,2.1482316176470637,3.51,-1.3617683823529361,"廊坊"]
["秦皇岛",3,6,2,7,11,5,13,6,6,5,5,5,1,9,9,11,104,102.389078498294,1.0157333333333285,1.9679833333333239,2.9,-0.93201666666667604,"秦皇岛"]
["石家庄",21,38,17,24,24,18,16,41,38,42,40,32,57,41,19,38,506,370.60500475134597,1.3653350427350437,2.6453366452991474,3.64,-0.99466335470085276,"石家庄"]
["唐山",18,10,18,16,11,29,27,25,14,21,21,12,23,10,9,32,296,247.39949395558099,1.1964454545454524,2.3181130681818138,3.56,-1.2418869318181862,"唐山"]
["邢台",10,7,13,9,14,10,18,12,8,15,9,13,15,6,7,16,182,179.65367965368,1.0130602409638534,1.962804216867466,2.39,-0.42719578313253415,"邢台"]
["雄安",1,4,2,3,1,2,0,4,0,3,2,0,1,1,3,1,28,27.377813830866,1.022725925925924,1.9815314814814777,3.25,-1.2684685185185223,"雄安"]
["张家口",6,6,7,9,8,8,7,7,8,6,6,6,5,3,4,8,104,98.380815740930501,1.0571166666666669,2.0481635416666673,2.4,-0.35183645833333266,"张家口"]
["全省",143,163,122,143,140,170,171,194,187,194,172,159,203,138,2541,-2224,2616,2211.2573099415199,1.1830373553719011,2.2921348760330584,2.95,-0.65786512396694174,"全省"]

{"sheet":"管理端-重复投诉率","index":2,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,1,1,2],[1,3,1,4],[1,5,1,6]]}
["重复投诉率（1-16）"]
["","工单数",null,"重复投诉率",null,"增量"]
["地市","10月截止15日","10月截止16日","10月截止15日","10月截止16日","工单数","重复投诉率"]
["衡水",1,4,5.9523809523809521E-3,2.2099447513812154E-2,3,1.6147066561431202E-2]
["唐山",11,14,4.1984732824427481E-2,4.72972972972973E-2,3,5.3125644728698185E-3]
["沧州",9,12,2.8571428571428571E-2,3.3333333333333333E-2,3,4.7619047619047623E-3]
["石家庄",20,22,3.2206119162640899E-2,3.3639143730886847E-2,2,1.4330245682459483E-3]
["保定",17,18,3.5416666666666666E-2,3.6290322580645164E-2,1,8.7365591397849801E-4]
["雄安",0,0,0,0,0,0]
["邯郸",14,14,4.1791044776119404E-2,0.04,0,-1.7910447761194034E-3]
["廊坊",4,4,1.9230769230769232E-2,1.7241379310344827E-2,0,-1.9893899204244045E-3]
["邢台",6,6,2.7649769585253458E-2,2.5423728813559324E-2,0,-2.2260407716941343E-3]
["秦皇岛",3,3,2.8037383177570093E-2,2.5423728813559324E-2,0,-2.6136543640107694E-3]
["承德",5,5,4.3859649122807015E-2,4.065040650406504E-2,0,-3.2092426187419754E-3]
["张家口",7,7,5.4263565891472867E-2,5.0724637681159424E-2,0,-3.538928210313444E-3]
["全省",97,109,3.2247340425531915E-2,3.3652361840074099E-2,12,1.4050214145421847E-3]

{"sheet":"投诉处理时长、超时工单概况","index":3,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,6,0,9]]}
["超时工单情况（1-16）",{"$nulls":5},"平均处理时长（1-16）"]
["地市","工单数","超时工单数","超时工单占比",null,null,"地市","9月","10月","涨幅"]
["石家庄",654,423,0.64678899082568808,null,null,"唐山",55.010597699321465,70.025507695195174,15.014909995873708]
["保定",496,307,0.61895161290322576,null,null,"石家庄",60.129757690471259,73.539033724091041,13.409276033619783]
["廊坊",232,136,0.58620689655172409,null,null,"保定",76.455193288697515,81.556951164874576,5.1017578761770608]
["唐山",296,162,0.54729729729729726,null,null,"秦皇岛",39.066768966547208,42.814336158192091,3.7475671916448832]
["沧州",360,196,0.5444444444444444,null,null,"沧州",69.249264852899131,70.652649691358036,1.4033848384589049]
["张家口",138,67,0.48550724637681159,null,null,"雄安",49.030036892361089,47.673328282828265,-1.3567086095328236]
["邯郸",350,157,0.44857142857142857,null,null,"衡水",44.28749999999998,42.809108348680148,-1.4783916513198321]
["雄安",55,23,0.41818181818181815,null,null,"邯郸",66.36693408662903,64.105925396825398,-2.2610086898036315]
["衡水",181,75,0.4143646408839779,null,null,"承德",47.731195965417854,38.541655374887085,-9.1895405905307683]
["邢台",236,94,0.39830508474576271,null,null,"邢台",62.45638938669854,47.837530602636498,-14.618858784062041]
["秦皇岛",118,34,0.28813559322033899,null,null,"廊坊",86.531504802119528,67.91287116858237,-18.618633633537158]
["承德",123,34,0.27642276422764228,null,null,"张家口",84.981190112130463,63.538113929146583,-21.44307618298388]
["全省",3239,1708,0.52732324791602347]

{"sheet":"客户端-投诉问题解决满意度","index":4,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["投诉问题解决满意率（1-16）"]
["地市","满意率","达标值","与达标值差距"]
["邯郸",0.96,0.92,3.9999999999999925E-2]
["邢台",0.95402298850574707,0.92,3.4022988505747032E-2]
["石家庄",0.95057034220532322,0.92,3.0570342205323175E-2]
["沧州",0.93959731543624159,0.92,1.9597315436241547E-2]
["廊坊",0.92592592592592593,0.92,5.9259259259258901E-3]
["秦皇岛",0.92592592592592593,0.92,5.9259259259258901E-3]
["张家口",0.90909090909090906,0.92,-1.0909090909090979E-2]
["保定",0.90797546012269936,0.92,-1.2024539877300677E-2]
["承德",0.89090909090909087,0.92,-2.9090909090909167E-2]
["唐山",0.88571428571428568,0.92,-3.4285714285714364E-2]
["衡水",0.88135593220338981,0.92,-3.8644067796610226E-2]
["雄安",0.8571428571428571,0.92,-6.2857142857142945E-2]
["全省",0.92743953294412007,0.92,7.4395329441200309E-3]

{"sheet":"客户端-投诉问题解决率","index":5,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["投诉问题解决率（1-16）"]
["地市","解决率","达标值","与达标值差距"]
["秦皇岛",0.92982456140350878,0.85,7.9824561403508798E-2]
["石家庄",0.91851851851851851,0.85,6.8518518518518534E-2]
["沧州",0.90789473684210531,0.85,5.7894736842105332E-2]
["衡水",0.90322580645161288,0.85,5.32258064516129E-2]
["邢台",0.90109890109890112,0.85,5.1098901098901139E-2]
["邯郸",0.89922480620155043,0.85,4.9224806201550453E-2]
["保定",0.89534883720930236,0.85,4.5348837209302384E-2]
["廊坊",0.85882352941176465,0.85,8.8235294117646745E-3]
["承德",0.8571428571428571,0.85,7.1428571428571175E-3]
["张家口",0.84090909090909094,0.85,-9.0909090909090384E-3]
["唐山",0.83185840707964598,0.85,-1.8141592920353999E-2]
["雄安",0.8125,0.85,-3.7499999999999978E-2]
["全省",0.89174017642341619,0.85,4.1740176423416209E-2]

{"sheet":"客户端-投诉问题响应率","index":6,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["投诉问题响应率（1-16）"]
["地市","响应率","达标值","与达标值差距"]
["雄安",1,0.99,1.0000000000000009E-2]
["邢台",0.97701149425287359,0.99,-1.29885057471264E-2]
["廊坊",0.97402597402597402,0.99,-1.5974025974025974E-2]
["石家庄",0.96862745098039216,0.99,-2.1372549019607834E-2]
["邯郸",0.96610169491525422,0.99,-2.3898305084745775E-2]
["沧州",0.96598639455782309,0.99,-2.40136054421769E-2]
["承德",0.96153846153846156,0.99,-2.8461538461538427E-2]
["秦皇岛",0.96153846153846156,0.99,-2.8461538461538427E-2]
["保定",0.95569620253164556,0.99,-3.4303797468354436E-2]
["衡水",0.94545454545454544,0.99,-4.4545454545454555E-2]
["唐山",0.92,0.99,-6.9999999999999951E-2]
["张家口",0.90697674418604646,0.99,-8.3023255813953534E-2]
["全省",0.95934256055363321,0.99,-3.0657439446366785E-2]