{"text_format":"2","workbook":"xlsx","n_sheets":8,"sheets":["管理端-移网质量类","客户端-战略考核","管理端-重复投诉率","投诉处理时长、超时工单概况","客户端-投诉问题解决满意度","客户端-投诉问题解决率","客户端-投诉问题响应率","Sheet1"],"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":19,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,18]]}
["2023年客服投诉清单各地市投诉率情况（管理端-移网质量类）"]
["地市","1日","2日","3日","4日","5日","6日","7日","8日","9日","10日","11日","投诉总量","用户数","目前万投率","本月预测","目标值","与目标差距","地市"]
["保定",37,49,37,52,52,36,48,30,38,34,46,459,253.8,1.80851063829787,4.9323017408123802,4.3,0.632301740812379,"保定"]
["沧州",17,15,17,37,23,31,27,29,37,18,23,274,234.3,1.1694408877507501,3.1893842393202201,4.3,-1.11061576067978,"沧州"]
["承德",15,6,8,6,13,13,11,11,14,11,11,119,103.2,1.1531007751938001,3.1448202959830902,4.3,-1.1551797040169101,"承德"]
["邯郸",20,23,18,18,18,15,30,22,33,31,41,269,275.3,0.97711587359244501,2.6648614734339402,4.2,-1.53513852656606,"邯郸"]
["衡水",10,9,14,22,20,19,12,12,17,13,14,162,155.30000000000001,1.0431423052157101,2.8449335596792098,3.3,-0.45506644032078702,"衡水"]
["廊坊",26,15,11,18,32,27,21,23,25,16,29,243,165.4,1.4691656590084601,4.0068154336594501,4.4000000000000004,-0.39318456634055199,"廊坊"]
["秦皇岛",10,7,11,12,17,2,18,10,15,10,14,126,103.1,1.22211445198836,3.3330394145137099,4.2,-0.86696058548628896,"秦皇岛"]
["石家庄",54,53,19,98,61,83,66,64,67,34,92,691,370.8,1.86353829557713,5.0823771697558104,4.5,0.58237716975581,"石家庄"]
["唐山",36,20,24,50,55,48,50,31,36,27,39,416,247.7,1.6794509487283,4.580320769259,4.3,0.28032076925900101,"唐山"]
["邢台",5,16,11,15,18,14,15,26,19,17,20,176,180,0.97777777777777797,2.6666666666666701,3.9,-1.2333333333333301,"邢台"]
["雄安",7,1,2,3,3,3,6,4,4,3,4,40,27.4,1.4598540145985399,3.9814200398141999,5.7,-1.7185799601858001,"雄安"]
["张家口",15,14,11,9,22,11,19,10,17,9,14,151,98.4,1.5345528455284601,4.1851441241685103,4.2,-1.4855875831486299E-2,"张家口"]
["全省",252,228,183,340,334,302,323,272,322,223,347,3126,2214.8000000000002,1.4114141231713899,3.8493112450128901,4.2,-0.35068875498711199,"全省"]

{"sheet":"客户端-战略考核","index":1,"n_rows":15,"n_cols":19,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,18]]}
["2023年客服投诉清单各地市投诉率情况（客户端-战略考核）"]
["地市","1日","2日","3日","4日","5日","6日","7日","8日","9日","10日","11日","投诉总量","用户数","目前万投率","本月预测","目标值","与目标差距","地市"]
["保定",30,42,39,46,37,31,40,27,34,37,36,399,250.65545610704299,1.5918265103697,4.34134502828101,2.93,1.4113450282810101,"保定"]
["沧州",26,12,28,56,32,43,44,32,47,24,37,381,232.81490929165599,1.6364931316435001,4.4631630863004501,2.76,1.7031630863004501,"沧州"]
["承德",18,15,7,14,19,23,18,19,21,15,23,192,101.781691583043,1.88639034205231,5.1447009328699496,3.35,1.7947009328699499,"承德"]
["邯郸",15,28,29,36,31,36,27,33,36,36,54,361,273.076556695139,1.3219736046511601,3.6053825581395298,2.37,1.2353825581395299,"邯郸"]
["衡水",19,9,11,22,17,17,10,11,21,14,10,161,154.23523544917001,1.0438600461893801,2.8468910350619399,1.79,1.05689103506194,"衡水"]
["廊坊",32,28,22,18,25,33,30,26,26,21,35,296,164.00628264601701,1.80480890868597,4.9222061145981,3.51,1.4122061145981,"廊坊"]
["秦皇岛",13,9,11,11,16,9,13,12,10,11,14,129,102.21915135750299,1.2619944333996,3.4418030001807298,2.9,0.54180300018073302,"秦皇岛"]
["石家庄",53,52,18,76,60,68,76,77,75,33,113,701,367.43781177809802,1.9078058314350801,5.2031068130047604,3.64,1.5631068130047601,"石家庄"]
["唐山",40,22,20,62,57,43,49,44,41,31,39,448,244.89646056689699,1.82934452773613,4.9891214392803596,3.56,1.42912143928036,"唐山"]
["邢台",13,18,10,14,19,18,20,30,20,11,17,190,177.90216597712299,1.0680027359781099,2.9127347344857601,2.39,0.52273473448576002,"邢台"]
["雄安",5,2,2,1,3,3,6,3,4,3,3,35,26.749143191507098,1.308453125,3.5685085227272699,3.25,0.31850852272727298,"雄安"]
["张家口",13,8,12,7,18,15,23,14,15,5,16,146,97.500988185691099,1.49742072072072,4.0838746928746898,2.4,1.6838746928746899,"张家口"]
["全省",277,245,209,363,334,339,356,328,350,241,397,3439,2193.2983139879698,1.56795816513761,4.2762495412844004,2.95,1.3262495412844,"全省"]

{"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-11）"]
["","工单数",null,"重复投诉率",null,"增量"]
["地市","9月截止10日","9月截止11日","9月截止10日","9月截止11日","工单数","重复投诉率"]
["衡水",1,2,6.7567567567567597E-3,1.2345679012345699E-2,1,5.5889222555889203E-3]
["邢台",2,3,1.2820512820512799E-2,1.7045454545454499E-2,1,4.2249417249417198E-3]
["承德",5,6,4.6296296296296301E-2,5.0420168067226899E-2,1,4.1238717709306E-3]
["秦皇岛",4,5,3.5714285714285698E-2,3.9682539682539701E-2,1,3.9682539682539698E-3]
["保定",13,16,3.1476997578692503E-2,3.4858387799564301E-2,3,3.3813902208717798E-3]
["唐山",9,11,2.3872679045092798E-2,2.6442307692307699E-2,2,2.5696286472148598E-3]
["石家庄",17,20,2.83806343906511E-2,2.8943560057887101E-2,3,5.6292566723603295E-4]
["沧州",0,0,0,0,0,0]
["雄安",0,0,0,0,0,0]
["邯郸",3,3,1.3157894736842099E-2,1.11524163568773E-2,0,-2.0054783799647799E-3]
["张家口",3,3,2.18978102189781E-2,1.9867549668874201E-2,0,-2.0302605501039302E-3]
["廊坊",7,7,3.27102803738318E-2,2.8806584362139901E-2,0,-3.9036960116918501E-3]
["全省",64,76,2.3029866858582201E-2,2.4312220089571301E-2,12,1.2823532309891199E-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-11）",{"$nulls":5},"平均处理时长（1-11）"]
["地市","工单数","超时工单数","超时工单占比",null,null,"地市","8月","9月","涨幅"]
["张家口",151,88,0.58278145695364203,null,null,"邯郸",46.864013683886803,81.089609665427503,34.225595981540799]
["石家庄",691,368,0.53256150506512301,null,null,"沧州",56.827604613385397,58.603454987834503,1.77585037444918]
["廊坊",243,127,0.52263374485596703,null,null,"石家庄",49.7648563388626,50.3486613603474,0.58380502148475]
["唐山",416,210,0.50480769230769196,null,null,"张家口",71.8034200542006,70.299626563649795,-1.5037934905508199]
["承德",119,60,0.504201680672269,null,null,"邢台",50.994536438700401,47.7492771464646,-3.2452592922357701]
["邢台",176,86,0.48863636363636398,null,null,"廊坊",71.6376184032477,67.825582990397805,-3.8120354128498501]
["保定",459,220,0.47930283224400899,null,null,"衡水",46.745936890838202,42.159891975308703,-4.5860449155295804]
["沧州",274,122,0.44525547445255498,null,null,"雄安",43.298781094527399,36.053576388888899,-7.2452047056384803]
["衡水",162,72,0.44444444444444398,null,null,"秦皇岛",52.566658249158301,44.961693121693102,-7.6049651274651104]
["雄安",40,17,0.42499999999999999,null,null,"承德",61.943278957022997,49.313695144724598,-12.629583812298399]
["邯郸",269,113,0.42007434944237898,null,null,"唐山",58.924652665589598,43.273502270299097,-15.6511503952905]
["秦皇岛",126,51,0.40476190476190499,null,null,"保定",98.975776851851805,50.414342774146697,-48.561434077705201]
["全省",3126,1534,0.49072296865003201]

{"sheet":"客户端-投诉问题解决满意度","index":4,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["投诉问题解决满意率（1-11）"]
["地市","满意率","达标值","与达标值差距"]
["雄安",1,0.92,0.08]
["张家口",1,0.92,0.08]
["邢台",0.97247706422018398,0.92,5.24770642201835E-2]
["石家庄",0.92142857142857104,0.92,1.4285714285713299E-3]
["邯郸",0.91764705882352904,0.92,-2.35294117647067E-3]
["沧州",0.91709844559585496,0.92,-2.90155440414508E-3]
["秦皇岛",0.91379310344827602,0.92,-6.2068965517241299E-3]
["保定",0.91145833333333304,0.92,-8.5416666666666696E-3]
["衡水",0.90625,0.92,-1.375E-2]
["承德",0.88888888888888895,0.92,-3.11111111111112E-2]
["唐山",0.88819875776397506,0.92,-3.1801242236024901E-2]
["廊坊",0.88079470198675502,0.92,-3.9205298013245099E-2]
["全省",0.91731112433075501,0.92,-2.6888756692445802E-3]

{"sheet":"客户端-投诉问题解决率","index":5,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["投诉问题解决率（1-11）"]
["地市","解决率","达标值","与达标值差距"]
["秦皇岛",0.921875,0.85,7.1874999999999994E-2]
["张家口",0.91891891891891897,0.85,6.8918918918919006E-2]
["保定",0.89447236180904499,0.85,4.4472361809045201E-2]
["衡水",0.89041095890411004,0.85,4.0410958904109603E-2]
["沧州",0.87562189054726403,0.85,2.5621890547263701E-2]
["邢台",0.859649122807018,0.85,9.6491228070175704E-3]
["雄安",0.85714285714285698,0.85,7.1428571428571201E-3]
["石家庄",0.85300668151447701,0.85,3.00668151447658E-3]
["邯郸",0.85227272727272696,0.85,2.2727272727273199E-3]
["廊坊",0.84905660377358505,0.85,-9.4339622641503905E-4]
["唐山",0.84705882352941197,0.85,-2.9411764705882201E-3]
["承德",0.78571428571428603,0.85,-6.4285714285714293E-2]
["全省",0.86325267304445696,0.85,1.3252673044457E-2]

{"sheet":"客户端-投诉问题响应率","index":6,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["投诉问题响应率（1-11）"]
["地市","响应率","达标值","与达标值差距"]
["衡水",1,0.99,0.01]
["雄安",1,0.99,0.01]
["邯郸",0.98773006134969299,0.99,-2.2699386503067802E-3]
["秦皇岛",0.98113207547169801,0.99,-8.8679245283018703E-3]
["邢台",0.98113207547169801,0.99,-8.8679245283018703E-3]
["沧州",0.97894736842105301,0.99,-1.10526315789473E-2]
["保定",0.97826086956521696,0.99,-1.1739130434782599E-2]
["张家口",0.97058823529411797,0.99,-1.9411764705882399E-2]
["石家庄",0.96829268292682902,0.99,-2.17073170731708E-2]
["唐山",0.96732026143790895,0.99,-2.26797385620915E-2]
["廊坊",0.96527777777777801,0.99,-2.4722222222222201E-2]
["承德",0.96153846153846201,0.99,-2.8461538461538399E-2]
["全省",0.97475369458128103,0.99,-1.52463054187192E-2]

{"sheet":"Sheet1","index":7,"n_rows":21,"n_cols":19,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,6],[0,8,0,12],[0,14,0,18]]}
["投诉问题响应率（1-11）",{"$nulls":7},"投诉问题响应率（1-11）",{"$nulls":5},"投诉问题响应率（1-11）"]
["地市","区县","响应率","达标值","与达标值差距","昨日未响应工单量","本月累计未响应工单量",null,"地市","区县","满意率","达标值","与达标值差距",null,"地市","区县","解决率","达标值","与达标值差距"]
["衡水",null,1,0.99,0.01,null,null,null,"衡水",null,1,0.99,0.01,null,"衡水",null,1,0.99,0.01]
["雄安",null,1,0.99,0.01,null,null,null,"雄安",null,1,0.99,0.01,null,"雄安",null,1,0.99,0.01]
["邯郸",null,0.98773006134969299,0.99,-2.2699386503067802E-3,null,null,null,"邯郸",null,0.98773006134969299,0.99,-2.2699386503067802E-3,null,"邯郸",null,0.98773006134969299,0.99,-2.2699386503067802E-3]
["秦皇岛",null,0.98113207547169801,0.99,-8.8679245283018703E-3,null,null,null,"秦皇岛",null,0.98113207547169801,0.99,-8.8679245283018703E-3,null,"秦皇岛",null,0.98113207547169801,0.99,-8.8679245283018703E-3]
["邢台",null,0.98113207547169801,0.99,-8.8679245283018703E-3,null,null,null,"邢台",null,0.98113207547169801,0.99,-8.8679245283018703E-3,null,"邢台",null,0.98113207547169801,0.99,-8.8679245283018703E-3]
["沧州",null,0.97894736842105301,0.99,-1.10526315789473E-2,null,null,null,"沧州",null,0.97894736842105301,0.99,-1.10526315789473E-2,null,"沧州",null,0.97894736842105301,0.99,-1.10526315789473E-2]
["保定",null,0.97826086956521696,0.99,-1.1739130434782599E-2,null,null,null,"保定",null,0.97826086956521696,0.99,-1.1739130434782599E-2,null,"保定",null,0.97826086956521696,0.99,-1.1739130434782599E-2]
["张家口",null,0.97058823529411797,0.99,-1.9411764705882399E-2,null,null,null,"张家口",null,0.97058823529411797,0.99,-1.9411764705882399E-2,null,"张家口",null,0.97058823529411797,0.99,-1.9411764705882399E-2]
["石家庄",null,0.96829268292682902,0.99,-2.17073170731708E-2,null,null,null,"石家庄",null,0.96829268292682902,0.99,-2.17073170731708E-2,null,"石家庄",null,0.96829268292682902,0.99,-2.17073170731708E-2]
["唐山",null,0.96732026143790895,0.99,-2.26797385620915E-2,null,null,null,"唐山",null,0.96732026143790895,0.99,-2.26797385620915E-2,null,"唐山",null,0.96732026143790895,0.99,-2.26797385620915E-2]
["廊坊",null,0.96527777777777801,0.99,-2.4722222222222201E-2,null,null,null,"廊坊",null,0.96527777777777801,0.99,-2.4722222222222201E-2,null,"廊坊",null,0.96527777777777801,0.99,-2.4722222222222201E-2]
["承德",null,0.96153846153846201,0.99,-2.8461538461538399E-2,null,null,null,"承德",null,0.96153846153846201,0.99,-2.8461538461538399E-2,null,"承德",null,0.96153846153846201,0.99,-2.8461538461538399E-2]
["全省",null,0.97475369458128103,0.99,-1.52463054187192E-2,null,null,null,"全省",null,0.97475369458128103,0.99,-1.52463054187192E-2,null,"全省",null,0.97475369458128103,0.99,-1.52463054187192E-2]
[]
[]
[]
[]
[]
[null,null,null,"响应率由低到高排序，条件格式，越差越红"]