{"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.93230174081238,4.3,0.632301740812379,"保定"]
["沧州",17,15,17,37,23,31,27,29,37,18,23,274,234.3,1.16944088775075,3.18938423932022,4.3,-1.11061576067978,"沧州"]
["承德",15,6,8,6,13,13,11,11,14,11,11,119,103.2,1.1531007751938,3.14482029598309,4.3,-1.15517970401691,"承德"]
["邯郸",20,23,18,18,18,15,30,22,33,31,41,269,275.3,0.977115873592445,2.66486147343394,4.2,-1.53513852656606,"邯郸"]
["衡水",10,9,14,22,20,19,12,12,17,13,14,162,155.3,1.04314230521571,2.84493355967921,3.3,-0.455066440320787,"衡水"]
["廊坊",26,15,11,18,32,27,21,23,25,16,29,243,165.4,1.46916565900846,4.00681543365945,4.4,-0.393184566340552,"廊坊"]
["秦皇岛",10,7,11,12,17,2,18,10,15,10,14,126,103.1,1.22211445198836,3.33303941451371,4.2,-0.866960585486289,"秦皇岛"]
["石家庄",54,53,19,98,61,83,66,64,67,34,92,691,370.8,1.86353829557713,5.08237716975581,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.280320769259001,"唐山"]
["邢台",5,16,11,15,18,14,15,26,19,17,20,176,180,0.977777777777778,2.66666666666667,3.9,-1.23333333333333,"邢台"]
["雄安",7,1,2,3,3,3,6,4,4,3,4,40,27.4,1.45985401459854,3.9814200398142,5.7,-1.7185799601858,"雄安"]
["张家口",15,14,11,9,22,11,19,10,17,9,14,151,98.4,1.53455284552846,4.18514412416851,4.2,-0.0148558758314863,"张家口"]
["全省",252,228,183,340,334,302,323,272,322,223,347,3126,2214.8,1.41141412317139,3.84931124501289,4.2,-0.350688754987112,"全省"]

{"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.655456107043,1.5918265103697,4.34134502828101,2.93,1.41134502828101,"保定"]
["沧州",26,12,28,56,32,43,44,32,47,24,37,381,232.814909291656,1.6364931316435,4.46316308630045,2.76,1.70316308630045,"沧州"]
["承德",18,15,7,14,19,23,18,19,21,15,23,192,101.781691583043,1.88639034205231,5.14470093286995,3.35,1.79470093286995,"承德"]
["邯郸",15,28,29,36,31,36,27,33,36,36,54,361,273.076556695139,1.32197360465116,3.60538255813953,2.37,1.23538255813953,"邯郸"]
["衡水",19,9,11,22,17,17,10,11,21,14,10,161,154.23523544917,1.04386004618938,2.84689103506194,1.79,1.05689103506194,"衡水"]
["廊坊",32,28,22,18,25,33,30,26,26,21,35,296,164.006282646017,1.80480890868597,4.9222061145981,3.51,1.4122061145981,"廊坊"]
["秦皇岛",13,9,11,11,16,9,13,12,10,11,14,129,102.219151357503,1.2619944333996,3.44180300018073,2.9,0.541803000180733,"秦皇岛"]
["石家庄",53,52,18,76,60,68,76,77,75,33,113,701,367.437811778098,1.90780583143508,5.20310681300476,3.64,1.56310681300476,"石家庄"]
["唐山",40,22,20,62,57,43,49,44,41,31,39,448,244.896460566897,1.82934452773613,4.98912143928036,3.56,1.42912143928036,"唐山"]
["邢台",13,18,10,14,19,18,20,30,20,11,17,190,177.902165977123,1.06800273597811,2.91273473448576,2.39,0.52273473448576,"邢台"]
["雄安",5,2,2,1,3,3,6,3,4,3,3,35,26.7491431915071,1.308453125,3.56850852272727,3.25,0.318508522727273,"雄安"]
["张家口",13,8,12,7,18,15,23,14,15,5,16,146,97.5009881856911,1.49742072072072,4.08387469287469,2.4,1.68387469287469,"张家口"]
["全省",277,245,209,363,334,339,356,328,350,241,397,3439,2193.29831398797,1.56795816513761,4.2762495412844,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,0.00675675675675676,0.0123456790123457,1,0.00558892225558892]
["邢台",2,3,0.0128205128205128,0.0170454545454545,1,0.00422494172494172]
["承德",5,6,0.0462962962962963,0.0504201680672269,1,0.0041238717709306]
["秦皇岛",4,5,0.0357142857142857,0.0396825396825397,1,0.00396825396825397]
["保定",13,16,0.0314769975786925,0.0348583877995643,3,0.00338139022087178]
["唐山",9,11,0.0238726790450928,0.0264423076923077,2,0.00256962864721486]
["石家庄",17,20,0.0283806343906511,0.0289435600578871,3,0.000562925667236033]
["沧州",0,0,0,0,0,0]
["雄安",0,0,0,0,0,0]
["邯郸",3,3,0.0131578947368421,0.0111524163568773,0,-0.00200547837996478]
["张家口",3,3,0.0218978102189781,0.0198675496688742,0,-0.00203026055010393]
["廊坊",7,7,0.0327102803738318,0.0288065843621399,0,-0.00390369601169185]
["全省",64,76,0.0230298668585822,0.0243122200895713,12,0.00128235323098912]

{"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.582781456953642,null,null,"邯郸",46.8640136838868,81.0896096654275,34.2255959815408]
["石家庄",691,368,0.532561505065123,null,null,"沧州",56.8276046133854,58.6034549878345,1.77585037444918]
["廊坊",243,127,0.522633744855967,null,null,"石家庄",49.7648563388626,50.3486613603474,0.58380502148475]
["唐山",416,210,0.504807692307692,null,null,"张家口",71.8034200542006,70.2996265636498,-1.50379349055082]
["承德",119,60,0.504201680672269,null,null,"邢台",50.9945364387004,47.7492771464646,-3.24525929223577]
["邢台",176,86,0.488636363636364,null,null,"廊坊",71.6376184032477,67.8255829903978,-3.81203541284985]
["保定",459,220,0.479302832244009,null,null,"衡水",46.7459368908382,42.1598919753087,-4.58604491552958]
["沧州",274,122,0.445255474452555,null,null,"雄安",43.2987810945274,36.0535763888889,-7.24520470563848]
["衡水",162,72,0.444444444444444,null,null,"秦皇岛",52.5666582491583,44.9616931216931,-7.60496512746511]
["雄安",40,17,0.425,null,null,"承德",61.943278957023,49.3136951447246,-12.6295838122984]
["邯郸",269,113,0.420074349442379,null,null,"唐山",58.9246526655896,43.2735022702991,-15.6511503952905]
["秦皇岛",126,51,0.404761904761905,null,null,"保定",98.9757768518518,50.4143427741467,-48.5614340777052]
["全省",3126,1534,0.490722968650032]

{"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.972477064220184,0.92,0.0524770642201835]
["石家庄",0.921428571428571,0.92,0.00142857142857133]
["邯郸",0.917647058823529,0.92,-0.00235294117647067]
["沧州",0.917098445595855,0.92,-0.00290155440414508]
["秦皇岛",0.913793103448276,0.92,-0.00620689655172413]
["保定",0.911458333333333,0.92,-0.00854166666666667]
["衡水",0.90625,0.92,-0.01375]
["承德",0.888888888888889,0.92,-0.0311111111111112]
["唐山",0.888198757763975,0.92,-0.0318012422360249]
["廊坊",0.880794701986755,0.92,-0.0392052980132451]
["全省",0.917311124330755,0.92,-0.00268887566924458]

{"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,0.071875]
["张家口",0.918918918918919,0.85,0.068918918918919]
["保定",0.894472361809045,0.85,0.0444723618090452]
["衡水",0.89041095890411,0.85,0.0404109589041096]
["沧州",0.875621890547264,0.85,0.0256218905472637]
["邢台",0.859649122807018,0.85,0.00964912280701757]
["雄安",0.857142857142857,0.85,0.00714285714285712]
["石家庄",0.853006681514477,0.85,0.00300668151447658]
["邯郸",0.852272727272727,0.85,0.00227272727272732]
["廊坊",0.849056603773585,0.85,-0.000943396226415039]
["唐山",0.847058823529412,0.85,-0.00294117647058822]
["承德",0.785714285714286,0.85,-0.0642857142857143]
["全省",0.863252673044457,0.85,0.013252673044457]

{"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.987730061349693,0.99,-0.00226993865030678]
["秦皇岛",0.981132075471698,0.99,-0.00886792452830187]
["邢台",0.981132075471698,0.99,-0.00886792452830187]
["沧州",0.978947368421053,0.99,-0.0110526315789473]
["保定",0.978260869565217,0.99,-0.0117391304347826]
["张家口",0.970588235294118,0.99,-0.0194117647058824]
["石家庄",0.968292682926829,0.99,-0.0217073170731708]
["唐山",0.967320261437909,0.99,-0.0226797385620915]
["廊坊",0.965277777777778,0.99,-0.0247222222222222]
["承德",0.961538461538462,0.99,-0.0284615384615384]
["全省",0.974753694581281,0.99,-0.0152463054187192]

{"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.987730061349693,0.99,-0.00226993865030678,null,null,null,"邯郸",null,0.987730061349693,0.99,-0.00226993865030678,null,"邯郸",null,0.987730061349693,0.99,-0.00226993865030678]
["秦皇岛",null,0.981132075471698,0.99,-0.00886792452830187,null,null,null,"秦皇岛",null,0.981132075471698,0.99,-0.00886792452830187,null,"秦皇岛",null,0.981132075471698,0.99,-0.00886792452830187]
["邢台",null,0.981132075471698,0.99,-0.00886792452830187,null,null,null,"邢台",null,0.981132075471698,0.99,-0.00886792452830187,null,"邢台",null,0.981132075471698,0.99,-0.00886792452830187]
["沧州",null,0.978947368421053,0.99,-0.0110526315789473,null,null,null,"沧州",null,0.978947368421053,0.99,-0.0110526315789473,null,"沧州",null,0.978947368421053,0.99,-0.0110526315789473]
["保定",null,0.978260869565217,0.99,-0.0117391304347826,null,null,null,"保定",null,0.978260869565217,0.99,-0.0117391304347826,null,"保定",null,0.978260869565217,0.99,-0.0117391304347826]
["张家口",null,0.970588235294118,0.99,-0.0194117647058824,null,null,null,"张家口",null,0.970588235294118,0.99,-0.0194117647058824,null,"张家口",null,0.970588235294118,0.99,-0.0194117647058824]
["石家庄",null,0.968292682926829,0.99,-0.0217073170731708,null,null,null,"石家庄",null,0.968292682926829,0.99,-0.0217073170731708,null,"石家庄",null,0.968292682926829,0.99,-0.0217073170731708]
["唐山",null,0.967320261437909,0.99,-0.0226797385620915,null,null,null,"唐山",null,0.967320261437909,0.99,-0.0226797385620915,null,"唐山",null,0.967320261437909,0.99,-0.0226797385620915]
["廊坊",null,0.965277777777778,0.99,-0.0247222222222222,null,null,null,"廊坊",null,0.965277777777778,0.99,-0.0247222222222222,null,"廊坊",null,0.965277777777778,0.99,-0.0247222222222222]
["承德",null,0.961538461538462,0.99,-0.0284615384615384,null,null,null,"承德",null,0.961538461538462,0.99,-0.0284615384615384,null,"承德",null,0.961538461538462,0.99,-0.0284615384615384]
["全省",null,0.974753694581281,0.99,-0.0152463054187192,null,null,null,"全省",null,0.974753694581281,0.99,-0.0152463054187192,null,"全省",null,0.974753694581281,0.99,-0.0152463054187192]
[]
[]
[]
[]
[]
[null,null,null,"响应率由低到高排序，条件格式，越差越红"]