{"text_format":"2","workbook":"xlsx","n_sheets":7,"sheets":["管理端-移网质量类","管理端-重复投诉率","投诉处理时长、超时工单概况","客户端-投诉问题解决满意度","客户端-投诉问题解决率","客户端-投诉问题响应率","text"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":6,"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":31,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,30]]}
["2023年客服投诉清单各地市投诉率情况（管理端-移网质量类）"]
["地市","1日","2日","3日","4日","5日","6日","7日","8日","9日","10日","11日","12日","13日","14日","15日","16日","17日","18日","19日","20日","21日","22日","23日","投诉总量","用户数","目前万投率","本月预测","目标值","与目标差距","地市"]
["保定",32,35,34,25,31,22,34,29,24,37,39,34,36,39,23,26,22,23,30,31,23,30,26,685,248.76,{"$f":"Y3/Z3","v":2.7536581443962054},{"$f":"AA3*30/23","v":3.5917280144298331},4.5,{"$f":"AB3-AC3","v":-0.90827198557016686},"保定"]
["沧州",25,38,26,34,43,45,38,41,53,56,38,47,31,34,26,53,32,45,32,27,44,15,30,853,232.91,{"$f":"Y4/Z4","v":3.6623588510583489},{"$f":"AA4*30/23","v":4.7769898057282809},4.4000000000000004,{"$f":"AB4-AC4","v":0.37698980572828056},"沧州"]
["承德",11,18,8,14,17,11,21,16,20,20,30,13,23,27,13,15,25,87,31,21,19,13,17,490,101.93,4.8072206416167953,6.2702877934132113,4.4000000000000004,1.8702877934132109,"承德"]
["邯郸",14,19,36,49,43,28,26,24,25,51,55,38,39,49,23,33,32,36,37,36,26,30,18,767,272.58999999999997,2.8137495872922709,3.6701081573377445,4.4000000000000004,-0.72989184266225582,"邯郸"]
["衡水",15,11,20,34,14,13,25,8,15,17,40,15,17,20,15,13,33,25,20,11,26,11,10,428,154.13,2.7768766625575814,3.6220130381185842,3.4,0.2220130381185843,"衡水"]
["廊坊",19,13,34,22,25,45,24,22,16,28,35,18,24,9,14,18,18,26,13,16,13,28,20,500,163.68,3.0547409579667644,3.9844447277827362,4.7,-0.715555272217264,"廊坊"]
["秦皇岛",15,16,28,10,15,21,12,13,21,15,10,13,8,11,8,5,10,13,12,14,17,9,8,304,103.12,2.948021722265322,3.845245724693898,4.3,-0.4547542753061018,"秦皇岛"]
["石家庄",129,131,108,159,105,88,117,92,68,105,80,77,92,124,69,58,72,100,65,64,54,49,54,2060,366.35,5.6230380783403842,7.3343974934874572,4.8,2.5343974934874574,"石家庄"]
["唐山",26,14,59,39,44,39,49,30,25,40,34,41,37,49,32,23,60,53,32,36,40,12,29,843,244.01,3.4547764435883774,4.5062301438109271,4.5,6.2301438109271245E-3,"唐山"]
["邢台",17,12,24,25,8,34,32,27,13,34,27,20,38,31,9,12,31,29,25,26,26,22,17,539,176.5,3.0538243626062322,3.9832491686168243,4,-1.6750831383175679E-2,"邢台"]
["雄安",5,2,11,3,7,4,4,8,5,11,6,12,13,5,7,4,5,9,6,4,8,8,3,150,25.82,5.8094500387296666,7.5775435287778263,6,1.5775435287778263,"雄安"]
["张家口",11,17,22,17,14,14,11,17,16,14,19,21,24,9,18,18,17,13,16,10,22,15,8,363,96.83,3.7488381699886402,4.889788917376487,4.4000000000000004,0.48978891737648667,"张家口"]
["全省",319,326,410,431,366,364,393,327,301,428,413,349,382,407,257,278,357,459,319,296,318,242,240,7982,2186.63,3.6503660884557512,{"$f":"AA15*30/23","v":4.7613470718988058},4.4000000000000004,0.36134707189880544,"总计"]

{"sheet":"管理端-重复投诉率","index":1,"n_rows":16,"n_cols":21,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,15,1,16],[1,17,1,18],[1,19,1,20],[0,0,0,6],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,12,1,13]]}
["重复投诉率（1-23）"]
[null,"重复投诉工单数",null,"重复投诉率",null,"增量",{"$nulls":5},"地市","总工单数",null,null,"重复投诉工单数",null,"重复投诉率",null,"增量"]
["地市","4月截止20日","4月截止23日","4月截止20日","4月截止23日","重复投诉工单数","重复投诉率",{"$nulls":4},"地市","4月截止20日","4月截止23日","地市","4月截止20日","4月截止23日","4月截止20日","4月截止23日","重复投诉工单数","重复投诉率"]
["唐山",33,45,4.33070866141732E-2,5.3380782918149502E-2,12,1.00736963039762E-2,{"$nulls":4},"保定",606,685,"保定",26,31,{"$f":"P4/M4","v":4.2904290429042903E-2},{"$f":"Q4/N4","v":4.5255474452554748E-2},{"$f":"Q4-P4","v":5},{"$f":"S4-R4","v":2.3511840235118445E-3}]
["沧州",38,50,4.9738219895287997E-2,5.8616647127784298E-2,12,8.8784272324963394E-3,{"$nulls":4},"沧州",764,853,"沧州",38,50,{"$f":"P5/M5","v":4.9738219895287955E-2},{"$f":"Q5/N5","v":5.8616647127784291E-2},{"$f":"Q5-P5","v":12},{"$f":"S5-R5","v":8.8784272324963359E-3}]
["廊坊",36,43,8.2004555808655996E-2,8.5999999999999993E-2,7,3.9954441913439597E-3,{"$nulls":4},"承德",441,490,"承德",15,18,{"$f":"P6/M6","v":3.4013605442176874E-2},{"$f":"Q6/N6","v":3.6734693877551024E-2},{"$f":"Q6-P6","v":3},{"$f":"S6-R6","v":2.7210884353741499E-3}]
["张家口",13,16,4.08805031446541E-2,4.4077134986225897E-2,3,3.1966318415718102E-3,{"$nulls":4},"邯郸",693,767,"邯郸",40,43,{"$f":"P7/M7","v":5.772005772005772E-2},{"$f":"Q7/N7","v":5.6062581486310298E-2},{"$f":"Q7-P7","v":3},{"$f":"S7-R7","v":-1.6574762337474222E-3}]
["衡水",14,17,3.6745406824147002E-2,3.9719626168224297E-2,3,2.9742193440773202E-3,{"$nulls":4},"衡水",381,428,"衡水",14,17,{"$f":"P8/M8","v":3.6745406824146981E-2},{"$f":"Q8/N8","v":3.9719626168224297E-2},{"$f":"Q8-P8","v":3},{"$f":"S8-R8","v":2.9742193440773154E-3}]
["承德",15,18,3.4013605442176902E-2,3.6734693877551003E-2,3,2.7210884353741499E-3,{"$nulls":4},"廊坊",439,500,"廊坊",36,43,{"$f":"P9/M9","v":8.2004555808656038E-2},{"$f":"Q9/N9","v":8.5999999999999993E-2},{"$f":"Q9-P9","v":7},{"$f":"S9-R9","v":3.9954441913439553E-3}]
["保定",26,31,4.2904290429042903E-2,4.5255474452554699E-2,5,2.3511840235118401E-3,{"$nulls":4},"秦皇岛",270,304,"秦皇岛",4,4,{"$f":"P10/M10","v":1.4814814814814815E-2},{"$f":"Q10/N10","v":1.3157894736842105E-2},{"$f":"Q10-P10","v":0},{"$f":"S10-R10","v":-1.6569200779727108E-3}]
["石家庄",134,149,7.0415133998948998E-2,7.23300970873786E-2,15,1.91496308842962E-3,{"$nulls":4},"全省",7182,7982,"全省",379,445,{"$f":"P11/M11","v":5.2770815928710663E-2},{"$f":"Q11/N11","v":5.575043848659484E-2},{"$f":"Q11-P11","v":66},{"$f":"S11-R11","v":2.9796225578841776E-3}]
["雄安",7,8,5.34351145038168E-2,5.3333333333333302E-2,1,-1.01781170483456E-4,{"$nulls":4},"石家庄",1903,2060,"石家庄",134,149,{"$f":"P12/M12","v":7.0415133998949025E-2},{"$f":"Q12/N12","v":7.2330097087378642E-2},{"$f":"Q12-P12","v":15},{"$f":"S12-R12","v":1.9149630884296165E-3}]
["邢台",19,21,4.0084388185653998E-2,3.8961038961039002E-2,2,-1.1233492246150499E-3,{"$nulls":4},"唐山",762,843,"唐山",33,45,{"$f":"P13/M13","v":4.3307086614173228E-2},{"$f":"Q13/N13","v":5.3380782918149468E-2},{"$f":"Q13-P13","v":12},{"$f":"S13-R13","v":1.007369630397624E-2}]
["秦皇岛",4,4,1.48148148148148E-2,1.3157894736842099E-2,0,-1.65692007797271E-3,{"$nulls":4},"邢台",474,539,"邢台",19,21,{"$f":"P14/M14","v":4.0084388185654012E-2},{"$f":"Q14/N14","v":3.896103896103896E-2},{"$f":"Q14-P14","v":2},{"$f":"S14-R14","v":-1.1233492246150514E-3}]
["邯郸",40,43,5.7720057720057699E-2,5.6062581486310298E-2,3,-1.65747623374742E-3,{"$nulls":4},"雄安",131,150,"雄安",7,8,{"$f":"P15/M15","v":5.3435114503816793E-2},{"$f":"Q15/N15","v":5.3333333333333337E-2},{"$f":"Q15-P15","v":1},{"$f":"S15-R15","v":-1.0178117048345592E-4}]
["全省",379,445,5.2770815928710697E-2,5.5750438486594799E-2,66,2.9796225578841802E-3,{"$nulls":4},"张家口",318,363,"张家口",13,16,{"$f":"P16/M16","v":4.0880503144654086E-2},{"$f":"Q16/N16","v":4.4077134986225897E-2},{"$f":"Q16-P16","v":3},{"$f":"S16-R16","v":3.1966318415718106E-3}]

{"sheet":"投诉处理时长、超时工单概况","index":2,"n_rows":15,"n_cols":22,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,6,0,9],[0,13,0,16],[0,18,0,21]]}
["超时工单情况（1-23）",{"$nulls":5},"平均处理时长（1-23）",{"$nulls":6},"超时工单情况",{"$nulls":4},"平均处理时长"]
["地市","工单数","超时工单数","超时工单占比",null,null,"地市","3月","4月","涨幅",null,null,null,"地市","工单数","超时工单数","超时工单占比",null,"地市","3月","4月","涨幅"]
["雄安",150,71,0.473333333333333,null,null,"雄安",43.876446581194898,54.557116666678297,10.680670085483399,null,null,null,"保定",685,229,{"$f":"P3/O3","v":0.33430656934306602},null,"保定",41.177645519264203,40.674617599346298,{"$f":"U3-T3","v":-0.50302791991790496}]
["石家庄",2060,955,0.46359223300970898,null,null,"石家庄",44.493510629247197,45.916902373246401,1.4233917439992001,null,null,null,"沧州",853,233,{"$f":"P4/O4","v":0.27315357561547499},null,"沧州",30.275409830596999,33.5040543180938,{"$f":"U4-T4","v":3.2286444874967999}]
["张家口",363,161,0.443526170798898,null,null,"张家口",44.122748717950401,43.951815120911,-0.170933597039401,null,null,null,"承德",490,64,0.130612244897959,null,"承德",22.222533089512002,24.181930272110801,1.9593971825987999]
["唐山",843,366,0.43416370106761598,null,null,"邯郸",42.241879719532001,43.950620382438302,1.7087406629063,null,null,null,"邯郸",767,299,0.38983050847457601,null,"邯郸",42.241879719532001,43.950620382438302,1.7087406629063]
["邢台",539,216,0.40074211502782903,null,null,"邢台",47.811231396533302,43.357272727270299,-4.4539586692629998,null,null,null,"衡水",428,165,0.38551401869158902,null,"衡水",33.888232577665697,34.995144730010701,1.1069121523450001]
["廊坊",500,200,0.4,null,null,"秦皇岛",43.332846498845797,42.047447916671402,-1.2853985821743901,null,null,null,"廊坊",500,200,0.4,null,"廊坊",52.311633155688497,38.8626361111072,-13.448997044581301]
["邯郸",767,299,0.38983050847457601,null,null,"保定",41.177645519264203,40.674617599346298,-0.50302791991790496,null,null,null,"秦皇岛",304,100,0.32894736842105299,null,"秦皇岛",43.332846498845797,42.047447916671402,-1.2853985821743901]
["衡水",428,165,0.38551401869158902,null,null,"唐山",63.838571294210702,40.608637801504699,-23.229933492705999,null,null,null,"石家庄",2060,955,0.46359223300970898,null,"石家庄",44.493510629247197,45.916902373246401,1.4233917439992001]
["保定",685,229,0.33430656934306602,null,null,"廊坊",52.311633155688497,38.8626361111072,-13.448997044581301,null,null,null,"唐山",843,366,0.43416370106761598,null,"唐山",63.838571294210702,40.608637801504699,-23.229933492705999]
["秦皇岛",304,100,0.32894736842105299,null,null,"衡水",33.888232577665697,34.995144730010701,1.1069121523450001,null,null,null,"邢台",539,216,0.40074211502782903,null,"邢台",47.811231396533302,43.357272727270299,-4.4539586692629998]
["沧州",853,233,0.27315357561547499,null,null,"沧州",30.275409830596999,33.5040543180938,3.2286444874967999,null,null,null,"雄安",150,71,0.473333333333333,null,"雄安",43.876446581194898,54.557116666678297,10.680670085483399]
["承德",490,64,0.130612244897959,null,null,"承德",22.222533089512002,24.181930272110801,1.9593971825987999,null,null,null,"张家口",363,161,0.443526170798898,null,"张家口",44.122748717950401,43.951815120911,-0.170933597039401]
["全省",7982,3059,0.38323728388875,{"$nulls":9},"全省",7982,{"$f":"SUM(P3:P14)","v":3059},0.38323728388875]

{"sheet":"客户端-投诉问题解决满意度","index":3,"n_rows":19,"n_cols":18,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["投诉问题解决满意率（1-23）"]
["地市","投诉问题解决满意率","达标值","与达标值差距",{"$nulls":10},"地市","投诉满意率","达标值","与达标值差距"]
["衡水",0.9375,0.92,1.7500000000000002E-2,{"$nulls":10},"保定",0.92110000000000003,0.92,{"$f":"P3-Q3","v":1.0999999999999901E-3}]
["廊坊",0.93569999999999998,0.92,1.5699999999999902E-2,{"$nulls":10},"沧州",0.91190000000000004,0.92,{"$f":"P4-Q4","v":-8.1000000000001106E-3}]
["秦皇岛",0.93569999999999998,0.92,1.5699999999999902E-2,{"$nulls":10},"承德",0.93300000000000005,0.92,1.2999999999999901E-2]
["承德",0.93300000000000005,0.92,1.2999999999999901E-2,{"$nulls":10},"邯郸",0.92530000000000001,0.92,5.2999999999999697E-3]
["邢台",0.93030000000000002,0.92,1.03E-2,{"$nulls":10},"衡水",0.9375,0.92,1.7500000000000002E-2]
["邯郸",0.92530000000000001,0.92,5.2999999999999697E-3,{"$nulls":10},"廊坊",0.93569999999999998,0.92,1.5699999999999902E-2]
["保定",0.92110000000000003,0.92,1.0999999999999901E-3,{"$nulls":10},"秦皇岛",0.93569999999999998,0.92,1.5699999999999902E-2]
["石家庄",0.91539999999999999,0.92,-4.5999999999999401E-3,{"$nulls":10},"石家庄",0.91539999999999999,0.92,-4.5999999999999401E-3]
["沧州",0.91190000000000004,0.92,-8.1000000000001106E-3,{"$nulls":10},"唐山",0.90200000000000002,0.92,-1.7999999999999999E-2]
["唐山",0.90200000000000002,0.92,-1.7999999999999999E-2,{"$nulls":10},"邢台",0.93030000000000002,0.92,1.03E-2]
["张家口",0.875,0.92,-4.4999999999999998E-2,{"$nulls":10},"雄安",0.84850000000000003,0.92,-7.1500000000000105E-2]
["雄安",0.84850000000000003,0.92,-7.1500000000000105E-2,{"$nulls":10},"张家口",0.875,0.92,-4.4999999999999998E-2]
["全省",0.9173,0.92,-2.70000000000004E-3,{"$nulls":10},"全省",0.9173,0.92,-2.70000000000004E-3]
[]
[]
[]
[{"$nulls":14},"满意率=满意/（满意+不满意+一般）"]

{"sheet":"客户端-投诉问题解决率","index":4,"n_rows":15,"n_cols":19,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["投诉问题解决率（1-23）"]
["地市","投诉问题解决率","达标值","与达标值差距",{"$nulls":11},"地市","投诉问题解决率","达标值","与达标值差距"]
["承德",0.89690000000000003,0.85,4.6900000000000101E-2,{"$nulls":11},"保定",0.8931,0.85,{"$f":"Q3-R3","v":4.3099999999999999E-2}]
["保定",0.8931,0.85,4.3099999999999999E-2,{"$nulls":11},"沧州",0.86099999999999999,0.85,{"$f":"Q4-R4","v":1.0999999999999999E-2}]
["邯郸",0.8931,0.85,4.3099999999999999E-2,{"$nulls":11},"承德",0.89690000000000003,0.85,4.6900000000000101E-2]
["邢台",0.88260000000000005,0.85,3.2600000000000101E-2,{"$nulls":11},"邯郸",0.8931,0.85,4.3099999999999999E-2]
["衡水",0.88149999999999995,0.85,3.1500000000000097E-2,{"$nulls":11},"衡水",0.88149999999999995,0.85,3.1500000000000097E-2]
["秦皇岛",0.87329999999999997,0.85,2.3300000000000001E-2,{"$nulls":11},"廊坊",0.84370000000000001,0.85,-6.2999999999999697E-3]
["沧州",0.86099999999999999,0.85,1.0999999999999999E-2,{"$nulls":11},"秦皇岛",0.87329999999999997,0.85,2.3300000000000001E-2]
["石家庄",0.85060000000000002,0.85,6.0000000000004505E-4,{"$nulls":11},"石家庄",0.85060000000000002,0.85,6.0000000000004505E-4]
["廊坊",0.84370000000000001,0.85,-6.2999999999999697E-3,{"$nulls":11},"唐山",0.83040000000000003,0.85,-1.9599999999999999E-2]
["唐山",0.83040000000000003,0.85,-1.9599999999999999E-2,{"$nulls":11},"邢台",0.88260000000000005,0.85,3.2600000000000101E-2]
["张家口",0.80620000000000003,0.85,-4.3799999999999999E-2,{"$nulls":11},"雄安",0.79410000000000003,0.85,-5.5900000000000102E-2]
["雄安",0.79410000000000003,0.85,-5.5900000000000102E-2,{"$nulls":11},"张家口",0.80620000000000003,0.85,-4.3799999999999999E-2]
["全省",0.85970000000000002,0.85,9.7000000000000402E-3,{"$nulls":11},"全省",0.85970000000000002,0.85,9.7000000000000402E-3]

{"sheet":"客户端-投诉问题响应率","index":5,"n_rows":15,"n_cols":16,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["投诉问题响应率（1-23）"]
["地市","投诉问题响应率","达标值","与达标值差距",{"$nulls":8},"地市","投诉问题响应率","达标值","与达标值差距"]
["廊坊",0.98470000000000002,0.99,-5.2999999999999697E-3,{"$nulls":8},"保定",0.96409999999999996,0.99,{"$f":"N3-O3","v":-2.5899999999999999E-2}]
["衡水",0.98370000000000002,0.99,-6.2999999999999697E-3,{"$nulls":8},"沧州",0.96970000000000001,0.99,{"$f":"N4-O4","v":-2.0299999999999999E-2}]
["邯郸",0.98019999999999996,0.99,-9.8000000000000292E-3,{"$nulls":8},"承德",0.97889999999999999,0.99,-1.11E-2]
["承德",0.97889999999999999,0.99,-1.11E-2,{"$nulls":8},"邯郸",0.98019999999999996,0.99,-9.8000000000000292E-3]
["秦皇岛",0.97670000000000001,0.99,-1.3299999999999999E-2,{"$nulls":8},"衡水",0.98370000000000002,0.99,-6.2999999999999697E-3]
["邢台",0.97370000000000001,0.99,-1.6299999999999999E-2,{"$nulls":8},"廊坊",0.98470000000000002,0.99,-5.2999999999999697E-3]
["沧州",0.96970000000000001,0.99,-2.0299999999999999E-2,{"$nulls":8},"秦皇岛",0.97670000000000001,0.99,-1.3299999999999999E-2]
["唐山",0.9667,0.99,-2.3300000000000001E-2,{"$nulls":8},"石家庄",0.96409999999999996,0.99,-2.5899999999999999E-2]
["保定",0.96409999999999996,0.99,-2.5899999999999999E-2,{"$nulls":8},"唐山",0.9667,0.99,-2.3300000000000001E-2]
["石家庄",0.96409999999999996,0.99,-2.5899999999999999E-2,{"$nulls":8},"邢台",0.97370000000000001,0.99,-1.6299999999999999E-2]
["张家口",0.95689999999999997,0.99,-3.3099999999999997E-2,{"$nulls":8},"雄安",0.9032,0.99,-8.6800000000000099E-2]
["雄安",0.9032,0.99,-8.6800000000000099E-2,{"$nulls":8},"张家口",0.95689999999999997,0.99,-3.3099999999999997E-2]
["全省",0.96930000000000005,0.99,-2.0699999999999899E-2,{"$nulls":8},"全省",0.96930000000000005,0.99,-2.0699999999999899E-2]

{"sheet":"text","index":6,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["2023年4月截至23日移动网投诉情况统计：\n\n管理端-移网质量类：投诉率：石家庄、承德、雄安、张家口、沧州、衡水、唐山未达到目标值，石家庄、雄安、承德排名靠后；重复投诉率：唐山、沧州、廊坊增长较快。\n\n客户端-移网网络体验：投诉问题解决满意率：雄安、张家口、唐山较低，与达标值差距较大；投诉问题解决率：雄安、张家口、唐山较低，与达标值差距较大；投诉问题响应率：雄安、张家口、石家庄较低，与达标值差距较大。\n\n投诉处理时长、超时工单概况：超时工单：雄安、石家庄、张家口分公司超时工单占比较高，石家庄、唐山、邯郸超时工单数量较多。平均处理时长：本月相对较长的地市为雄安、石家庄、张家口；与3月比雄安时长增幅较大。"]