{"text_format":"2","workbook":"xlsx","n_sheets":7,"sheets":["管理端-移网质量类","客户端-战略考核","管理端-重复投诉率","投诉处理时长、超时工单概况","客户端-投诉问题解决满意度","客户端-投诉问题解决率","客户端-投诉问题响应率"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":32,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,31]]}
["2023年客服投诉清单各地市投诉率情况（管理端-移网质量类）"]
["地市","1日","2日","3日","4日","5日","6日","7日","8日","9日","10日","11日","12日","13日","14日","15日","16日","17日","18日","19日","20日","21日","22日","23日","24日","投诉总量","用户数","目前万投率","本月预测","目标值","与目标差距","地市"]
["保定",26,26,19,22,36,29,25,30,28,34,24,26,36,34,27,38,36,28,31,30,25,34,37,26,707,250.2,2.8257394084732215,3.5321742605915269,4.5999999999999996,-1.0678257394084727,"保定"]
["沧州",27,29,25,18,27,20,13,28,25,20,20,24,40,28,24,28,16,23,34,25,28,27,30,13,592,232.9,2.5418634607127522,3.1773293258909399,4.4000000000000004,-1.2226706741090605,"沧州"]
["承德",17,24,18,13,24,20,12,7,16,7,9,12,2,6,4,16,12,9,9,7,5,9,15,19,292,102.4,2.8515625,3.564453125,4.4000000000000004,-0.83554687500000036,"承德"]
["邯郸",48,32,18,21,49,46,42,41,45,29,25,36,40,25,44,32,35,36,18,31,31,27,45,25,821,273,3.0073260073260073,3.7591575091575091,4.4000000000000004,-0.64084249084249123,"邯郸"]
["衡水",5,18,16,7,14,15,13,18,21,2,11,22,24,15,18,22,13,7,16,23,9,12,33,9,363,154.4,2.3510362694300517,2.9387953367875643,3.4,-0.46120466321243558,"衡水"]
["廊坊",16,31,10,13,17,16,19,16,29,17,23,33,34,22,17,36,23,15,22,16,15,10,11,14,475,164.2,2.8928136419001218,3.6160170523751525,4.7,-1.0839829476248477,"廊坊"]
["秦皇岛",9,18,11,7,16,15,10,11,14,6,9,18,14,10,12,4,11,8,17,8,13,14,13,12,280,102.9,2.7210884353741496,3.4013605442176869,4.3,-0.89863945578231297,"秦皇岛"]
["石家庄",40,65,39,45,52,53,42,41,66,36,38,61,47,50,60,37,58,27,68,54,43,42,52,49,1165,367.1,3.1735222010351403,3.9669027512939254,4.8,-0.83309724870607438,"石家庄"]
["唐山",37,26,15,19,48,44,33,26,43,23,15,35,40,36,30,36,25,24,43,35,55,28,19,16,751,245.3,3.0615572768039137,3.8269465960048925,4.5,-0.67305340399510749,"唐山"]
["邢台",25,18,7,9,20,24,23,24,29,22,13,25,33,23,16,27,13,14,25,23,35,16,20,16,500,177.7,2.8137310073157007,3.5171637591446259,4,-0.48283624085537413,"邢台"]
["雄安",6,5,5,5,6,4,4,6,4,4,6,3,3,5,6,3,5,3,3,2,7,7,9,5,116,26.5,4.3773584905660377,5.4716981132075473,6.1,-0.62830188679245236,"雄安"]
["张家口",15,9,9,10,12,9,9,7,5,10,15,19,12,4,13,14,20,12,12,15,9,8,7,11,266,97.4,2.731006160164271,3.413757700205339,4.4000000000000004,-0.98624229979466138,"张家口"]
["全省",271,301,192,189,321,295,245,255,325,210,208,314,325,258,271,293,267,206,298,269,275,234,291,215,6328,2193.8000000000002,2.8844926611359285,3.6056158264199105,4.4000000000000004,-0.79438417358008984,"全省"]

{"sheet":"客户端-战略考核","index":1,"n_rows":20,"n_cols":40,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,31],[19,5,23,25]]}
["2023年客服投诉清单各地市投诉率情况（客户端-战略考核）"]
["地市","1日","2日","3日","4日","5日","6日","7日","8日","9日","10日","11日","12日","13日","14日","15日","16日","17日","18日","19日","20日","21日","22日","23日","24日","投诉总量","用户数","目前万投率","本月预测","目标值","与目标差距","地市",{"$nulls":4},"从详单统计33类",null,"汇总表"]
["保定",26,26,19,22,36,29,25,30,28,34,24,26,36,34,27,38,36,28,31,30,25,34,37,26,707,250.0418480080348,2.8257394084732215,3.5321742605915269,2.9330400000000001,-1.0678257394084727,"保定",null,"保定",21173,"保定",929,"保定",929,{"$f":"AK3-AM3","v":0}]
["沧州",27,29,25,18,27,20,13,28,25,20,20,24,40,28,24,28,16,23,34,25,28,27,30,13,592,232.75253289521092,2.5418634607127522,3.1773293258909399,2.7561599999999999,-1.2226706741090605,"沧州",null,"沧州",17775,"沧州",916,"沧州",916,{"$f":"AK4-AM4","v":0}]
["承德",17,24,18,13,24,20,12,7,16,7,9,12,2,6,4,16,12,9,9,7,5,9,15,19,292,101.6159413105978,2.8515625,3.564453125,3.3451200000000001,-0.83554687500000036,"承德",null,"承德",8142,"承德",390,"承德",390,0]
["邯郸",48,32,18,21,49,46,42,41,45,29,25,36,40,25,44,32,35,36,18,31,31,27,45,25,821,272.61193798929355,3.0073260073260073,3.7591575091575091,2.3737066666666666,-0.64084249084249123,"邯郸",null,"邯郸",17665,"邯郸",700,"邯郸",702,-2]
["衡水",5,18,16,7,14,15,13,18,21,2,11,22,24,15,18,22,13,7,16,23,9,12,33,9,363,153.97384161872873,2.3510362694300517,2.9387953367875643,1.7851466666666664,-0.46120466321243558,"衡水",null,"衡水",8668,"衡水",352,"衡水",352,0]
["廊坊",16,31,10,13,17,16,19,16,29,17,23,33,34,22,17,36,23,15,22,16,15,10,11,14,475,163.80003468335673,2.8928136419001218,3.6160170523751525,3.5092533333333336,-1.0839829476248477,"廊坊",null,"廊坊",14191,"廊坊",705,"廊坊",705,0]
["秦皇岛",9,18,11,7,16,15,10,11,14,6,9,18,14,10,12,4,11,8,17,8,13,14,13,12,280,102.21137774020634,2.7210884353741496,3.4013605442176869,2.9028266666666669,-0.89863945578231297,"秦皇岛",null,"秦皇岛",9615,"秦皇岛",379,"秦皇岛",380,-1]
["石家庄",40,65,39,45,52,53,42,41,66,36,38,61,47,50,60,37,58,27,68,54,43,42,52,49,1165,366.86843694310664,3.1735222010351403,3.9669027512939254,3.6369333333333338,-0.83309724870607438,"石家庄",null,"石家庄",30594,"石家庄",1754,"石家庄",1755,-1]
["唐山",37,26,15,19,48,44,33,26,43,23,15,35,40,36,30,36,25,24,43,35,55,28,19,16,751,244.85910129474487,3.0615572768039137,3.8269465960048925,3.5564800000000001,-0.67305340399510749,"唐山",null,"唐山",22366,"唐山",990,"唐山",991,-1]
["邢台",25,18,7,9,20,24,23,24,29,22,13,25,33,23,16,27,13,14,25,23,35,16,20,16,500,177.30168990673192,2.8137310073157007,3.5171637591446259,2.38592,-0.48283624085537413,"邢台",null,"邢台",14150,"邢台",593,"邢台",593,0]
["雄安",6,5,5,5,6,4,4,6,4,4,6,3,3,5,6,3,5,3,3,2,7,7,9,5,116,26.458526260087314,4.3773584905660377,5.4716981132075473,3.2467466666666667,-0.62830188679245236,"雄安",null,"雄安新区",1831,"雄安新区",107,"雄安新区",107,0]
["张家口",15,9,9,10,12,9,9,7,5,10,15,19,12,4,13,14,20,12,12,15,9,8,7,11,266,97.331867692615177,2.731006160164271,3.413757700205339,2.404666666666667,-0.98624229979466138,"张家口",null,"张家口",8953,"张家口",347,"张家口",347,0]
["全省",271,301,192,189,321,295,245,255,325,210,208,314,325,258,271,293,267,206,298,269,275,234,291,215,6328,2189.8210269687979,2.8844926611359285,3.6056158264199105,2.9485866666666669,-0.79438417358008984,"全省"]
[]
[]
[]
[]
[{"$nulls":5},"说明：1.日投诉量按照客户端的日投诉量计算，投诉总量=日累计\n2.用户数=上月总报到量（办结量）/总投诉率（件/万户），或者找我提供\n3.目标值暂时不变，后期如有需要，再进行变更"]

{"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-24）"]
["","工单数",null,"重复投诉率",null,"增量"]
["地市","6月截止23日","6月截止24日","6月截止23日","6月截止24日","工单数","重复投诉率"]
["张家口",14,17,5.4901960784313725E-2,6.3909774436090222E-2,3,9.0078136517764973E-3]
["衡水",12,14,3.3898305084745763E-2,3.8567493112947659E-2,2,4.6691880282018969E-3]
["沧州",29,32,5.0086355785837651E-2,5.4054054054054057E-2,3,3.9676982682164061E-3]
["邢台",22,24,4.5454545454545456E-2,4.8000000000000001E-2,2,2.5454545454545452E-3]
["秦皇岛",8,9,2.9850746268656716E-2,3.214285714285714E-2,1,2.2921108742004238E-3]
["保定",20,22,2.9368575624082231E-2,3.1117397454031116E-2,2,1.748821829948885E-3]
["石家庄",85,90,7.6164874551971323E-2,7.7253218884120178E-2,5,1.0883443321488551E-3]
["廊坊",20,21,4.3383947939262472E-2,4.4210526315789471E-2,1,8.265783765269985E-4]
["邯郸",44,45,5.5276381909547742E-2,5.4811205846528627E-2,1,-4.651760630191154E-4]
["唐山",47,47,6.3945578231292516E-2,6.2583222370173108E-2,0,-1.3623558611194075E-3]
["雄安",4,4,3.6036036036036036E-2,3.4482758620689655E-2,0,-1.553277415346381E-3]
["承德",14,14,5.128205128205128E-2,4.7945205479452052E-2,0,-3.3368458025992281E-3]
["全省",319,339,5.2183870440045806E-2,5.3571428571428568E-2,20,1.3875581313827628E-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-24）",{"$nulls":5},"平均处理时长（1-24）"]
["地市","工单数","超时工单数","超时工单占比",null,null,"地市","5月","6月","涨幅"]
["唐山",751,343,0.45672436750998668,null,null,"秦皇岛",36.958350748867979,42.528742063492068,5.5703913146240893]
["廊坊",475,195,0.41052631578947368,null,null,"唐山",40.30454630547289,44.964502515164938,4.6599562096920479]
["雄安",116,47,0.40517241379310343,null,null,"承德",25.862091346153882,29.239756468797555,3.3776651226436734]
["张家口",266,106,0.39849624060150374,null,null,"保定",34.710614810960813,36.498644507307915,1.7880296963471025]
["石家庄",1165,464,0.39828326180257512,null,null,"雄安",39.714201646090508,40.670641762452121,0.95644011636161252]
["邢台",500,198,0.39600000000000002,null,null,"沧州",42.806604378326085,42.467359234234259,-0.33924514409182649]
["沧州",592,226,0.38175675675675674,null,null,"石家庄",39.508363875724044,39.126741297091051,-0.38162257863299232]
["邯郸",821,282,0.34348355663824603,null,null,"张家口",41.411148879142253,40.623974519632419,-0.78717435950983372]
["秦皇岛",280,89,0.31785714285714284,null,null,"衡水",34.152737835875072,30.944226354453651,-3.2085114814214215]
["保定",707,183,0.25884016973125884,null,null,"邯郸",48.296878150339673,44.811389227229682,-3.4854889231099904]
["承德",292,73,0.25,null,null,"廊坊",47.761217918061519,43.460716374269019,-4.3005015437924996]
["衡水",363,79,0.21763085399449036,null,null,"邢台",49.476087180930946,39.662031666666678,-9.8140555142642683]
["全省",6328,2285,0.36109355246523389]

{"sheet":"客户端-投诉问题解决满意度","index":4,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["投诉问题解决满意率（1-24）"]
["地市","满意率","达标值","与达标值差距"]
["雄安",0.94915254237288138,0.92,2.915254237288134E-2]
["承德",0.94318181818181823,0.92,2.3181818181818192E-2]
["保定",0.93283582089552242,0.92,1.2835820895522376E-2]
["邯郸",0.93131868131868134,0.92,1.1318681318681301E-2]
["石家庄",0.92614188532555874,0.92,6.1418853255587047E-3]
["衡水",0.92452830188679247,0.92,4.5283018867924296E-3]
["廊坊",0.92354740061162077,0.92,3.5474006116207324E-3]
["秦皇岛",0.92261904761904767,0.92,2.6190476190476319E-3]
["唐山",0.91343963553530749,0.92,-6.5603644646925474E-3]
["邢台",0.91233766233766234,0.92,-7.6623376623377037E-3]
["沧州",0.90137614678899081,0.92,-1.8623853211009234E-2]
["张家口",0.88709677419354838,0.92,-3.2903225806451664E-2]
["全省",0.92157354046604856,0.92,1.5735404660485175E-3]

{"sheet":"客户端-投诉问题解决率","index":5,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["投诉问题解决率（1-24）"]
["地市","解决率","达标值","与达标值差距"]
["雄安",0.91803278688524592,0.85,6.8032786885245944E-2]
["承德",0.88172043010752688,0.85,3.1720430107526898E-2]
["石家庄",0.87662337662337664,0.85,2.662337662337666E-2]
["保定",0.87558685446009388,0.85,2.55868544600939E-2]
["邯郸",0.87305699481865284,0.85,2.3056994818652865E-2]
["衡水",0.86904761904761907,0.85,1.9047619047619091E-2]
["沧州",0.8643326039387309,0.85,1.4332603938730926E-2]
["邢台",0.86068111455108354,0.85,1.0681114551083559E-2]
["秦皇岛",0.85869565217391308,0.85,8.6956521739131043E-3]
["唐山",0.85835095137420714,0.85,8.3509513742071606E-3]
["张家口",0.83458646616541354,0.85,-1.5413533834586435E-2]
["廊坊",0.81428571428571428,0.85,-3.5714285714285698E-2]
["全省",0.86485207100591721,0.85,1.4852071005917233E-2]

{"sheet":"客户端-投诉问题响应率","index":6,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["投诉问题响应率（1-24）"]
["地市","响应率","达标值","与达标值差距"]
["邯郸",0.98305084745762716,0.99,-6.9491525423728273E-3]
["雄安",0.98245614035087714,0.99,-7.5438596491228527E-3]
["保定",0.97435897435897434,0.99,-1.5641025641025652E-2]
["廊坊",0.97151898734177211,0.99,-1.848101265822788E-2]
["秦皇岛",0.97005988023952094,0.99,-1.9940119760479047E-2]
["石家庄",0.96990972918756269,0.99,-2.0090270812437305E-2]
["衡水",0.96644295302013428,0.99,-2.3557046979865714E-2]
["承德",0.9640718562874252,0.99,-2.5928143712574792E-2]
["邢台",0.96219931271477666,0.99,-2.7800687285223336E-2]
["沧州",0.96125907990314774,0.99,-2.8740920096852252E-2]
["唐山",0.95454545454545459,0.99,-3.5454545454545405E-2]
["张家口",0.93388429752066116,0.99,-5.6115702479338836E-2]
["全省",0.96718749999999998,0.99,-2.2812500000000013E-2]