{"text_format":"2","workbook":"xlsx","n_sheets":1,"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":"Sheet1","index":0,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[33,1,38,1],[33,2,35,2],[33,3,35,3],[12,2,14,2],[12,3,14,3],[30,2,32,2],[30,3,32,3],[27,2,29,2],[27,3,29,3],[18,2,20,2],[18,3,20,3],[36,3,38,3],[36,2,38,2],[15,2,17,2],[21,2,23,2],[15,3,17,3],[21,3,23,3],[24,2,26,2],[24,3,26,3],[1,3,4,3],[1,2,4,2],[1,0,38,0],[5,3,8,3],[5,2,8,2],[1,1,8,1],[9,3,11,3],[9,2,11,2],[9,1,32,1]]}
["功能需求","一级模块","二级模块","功能详述","功能类型","工作类型","难度级别","基准工时","难度系数","工时预估（人/天）","备注"]
["投诉工单日报表增加县区三率","数据订阅","河北客户体验管理高品质日明细数据订阅","河北客户体验管理高品质日明细数据是通过能力商店发布的投诉工单客户端通报数据\n1. 打通能力商店网络，完成文件订阅流程\n2. 测试文件订阅任务，检查文件推送的稳定性，在任务异常时推送运维消息\n3. 完成文件MD5验证、字段确认、数据入库","接口服务类","需求方案","较高",1,1,{"$f":"H2*I2","v":1}]
[{"$nulls":4},"接口服务类","程序开发","较低",3,0.6,1.7999999999999998]
[{"$nulls":4},"接口服务类","数据开发","较低",3,0.6,1.7999999999999998]
[{"$nulls":4},"接口服务类","测试验证","较高",1,1,1]
[null,null,"河北_用户常驻基站数据订阅","河北_用户常驻基站数据是能力商店上发布的用户常驻小区（含2/3/4/5G）数据的文件能力，通过匹配常驻小区和工参可以帮助确定用户归属的地市和区县","接口服务类","需求方案","较高",1,1,{"$f":"H6*I6","v":1}]
[{"$nulls":4},"接口服务类","程序开发","较低",3,0.6,1.7999999999999998]
[{"$nulls":4},"接口服务类","数据开发","较低",3,0.6,1.7999999999999998]
[{"$nulls":4},"接口服务类","测试验证","较高",1,1,1]
[null,"新增报表","客户端-战略考核报表数据计算","1. 从河北客户体验管理高品质日明细数据表读取从当月1日起的地市统计数据，并汇总全省数据\n2. 在用户数表增加客户端各地市用户数据，每月更新，从中读取用户数数据\n3. 在目标万投比数据表增加客户端目标万头比字段，按需更新，从中读取目标万投比数据\n4. 通过各地市和全省从当月1日到当前日期的统计数据和用户数计算万投比、全月万投比预测、与目标差距等数据","数据加工类","需求方案","较高",1,1,1]
[{"$nulls":4},"数据加工类","数据开发","较低",22,0.6,13.2]
[{"$nulls":4},"数据加工类","测试验证","较低",10,0.6,6]
[null,null,"建立字典表","建立对应字典表，包含以下内容：\n1. 工单流转数据中的地市、区县字段与报表中的地市、区县字段的对应关系\n2. CEM客户端考核数据中地市、区县字段与日报表中的地市、区县字段的对应关系\n3. CEM客户端考核数据中归属于移网考核的新客服工单类型名称","数据加工类","需求方案","较高",1,1,{"$f":"H13*I13","v":1}]
[{"$nulls":4},"数据加工类","数据开发","较高",4,1,4]
[{"$nulls":4},"数据加工类","测试验证","较高",1,1,1]
[null,null,"获取和更新工作流转数据","通过定时任务，从工单流转系统同步工单数据，主要包括工单的归属地市和区县信息\n1. 获取和插入从上次任务开始时间到当前新增的工单\n2. 获取并更新从上次任务开始时间到当前有更新的工单数据","数据加工类","需求方案","较高",1,1,1]
[{"$nulls":4},"数据加工类","数据开发","较高",4,1,4]
[{"$nulls":4},"数据加工类","测试验证","较高",1,1,1]
[null,null,"按照规则匹配客户端工单数据的区县字段","按照以下原则筛选客户端通报工单数据并填充地市和区县信息\n1. 从字典表读取以往考核的工单类型名称，筛选符合类型的工单数据\n2. 按照未回访标识进行筛选，仅保留已回访和未回访的工单数据\n3. 按照工单流转>客户端工单数据>默认配置的原则使用字典表对应关系匹配日报表地市和区县字段","数据加工类","需求方案","较高",1,1,{"$f":"H19*I19","v":1}]
[{"$nulls":4},"数据加工类","数据开发","较低",22,0.8,17.600000000000001]
[{"$nulls":4},"数据加工类","测试验证","较低",10,0.8,8]
[null,null,"区县级别投诉问题解决满意度计算","按照区县匹配的结果进行统计，投诉问题解决满意度分母为测评-满意度不为空的工单数量+未回访的工单，分子为测评-满意度为满意的\n1. 按照各区县满意度与目标的差距进行排序","数据加工类","需求方案","较高",1,1,{"$f":"H22*I22","v":1}]
[{"$nulls":4},"数据加工类","数据开发","较低",6,0.6,3.5999999999999996]
[{"$nulls":4},"数据加工类","测试验证","较低",2,0.6,1.2]
[null,null,"区县级别投诉问题解决率计算","按照区县匹配的结果进行统计，投诉问题解决满意度分母为测评-解决情况不为空的工单数量+未回访的工单，分子为测评-解决情况为满意的\n1. 按照各区县解决率与目标的差距进行排序","数据加工类","需求方案","较高",1,1,{"$f":"H25*I25","v":1}]
[{"$nulls":4},"数据加工类","数据开发","较低",6,0.6,3.5999999999999996]
[{"$nulls":4},"数据加工类","测试验证","较低",2,0.6,1.2]
[null,null,"区县级别投诉问题响应率计算","按照区县匹配的结果进行统计，投诉问题解决满意度分母为测评-响应情况不为空的工单数量+未回访的工单，分子为测评-响应情况为满意的\n1. 按照各区县响应率与目标的差距进行排序","数据加工类","需求方案","较高",1,1,1]
[{"$nulls":4},"数据加工类","数据开发","较低",6,0.6,3.5999999999999996]
[{"$nulls":4},"数据加工类","测试验证","较低",2,0.6,1.2]
[null,null,"报表输出及截图","将新增的客户端-战略考核报表数据、区县级别投诉问题解决满意度、区县级别投诉问题解决率、区县级别投诉问题响应率报表按照格式要求输出到报表，并按要求完成截图输出","数据加工类","需求方案","较高",1,1,1]
[{"$nulls":4},"数据加工类","数据开发","较高",4,1,4]
[{"$nulls":4},"数据加工类","测试验证","较高",1,1,1]
[null,"钉钉推送演进","钉钉推送定时任务调整","调整钉钉推送的定时任务，增加新增的截图","数据加工类","需求方案","较高",1,1,1]
[{"$nulls":4},"数据加工类","数据开发","较低",4,0.6,2.4]
[{"$nulls":4},"数据加工类","测试验证","较低",1,0.6,0.6]
[null,null,"通过@机器人进行互动，手动发送或撤回消息","为了方便运维处理表格异常等情况，增加钉钉互动功能，支持通过与机器人互动完成消息撤回、重新生成报表、重新发送等功能","数据加工类","需求方案","较高",1,1,{"$f":"H37*I37","v":1}]
[{"$nulls":4},"数据加工类","数据开发","较高",4,1,4]
[{"$nulls":4},"数据加工类","测试验证","较高",1,1,1]
["合计","合计",{"$nulls":7},{"$f":"SUM(J2:J39)","v":103.39999999999999}]