{"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":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,8,1],[9,1,26,1],[1,2,4,2],[5,2,8,2],[9,2,11,2],[12,2,14,2],[15,2,17,2],[18,2,20,2],[21,2,23,2],[24,2,26,2],[1,3,4,3],[5,3,8,3],[9,3,11,3],[12,3,14,3],[15,3,17,3],[18,3,20,3],[21,3,23,3],[24,3,26,3]]}
["功能需求","一级模块","二级模块","功能详述","功能类型","工作类型","难度级别","基准工时","难度系数","工时预估（人/天）","备注"]
[null,"数据订阅","从能力商店订阅河北客户体验管理智能定责投诉明细月累计接口日数据","通过能力商店订阅CEM发布的河北客户体验管理智能定责投诉明细月累计接口日数据\n1. 打通网络，完成能力商店文件订阅流程\n2. 测试文件订阅任务，检查文件是否符合要求，确人文件推送任务稳定\n3. 验证文件MD5、数据入库，在任务异常时推送运维消息","接口服务类","需求方案","较低",1,0.6,{"$f":"H2*I2","v":0.6}]
[{"$nulls":4},"接口服务类","程序开发","较低",3,0.6,{"$f":"H3*I3","v":1.8}]
[{"$nulls":4},"接口服务类","数据开发","较低",3,0.6,1.8]
[{"$nulls":4},"接口服务类","测试验证","较低",1,0.6,0.6]
[null,null,"从能力商店订阅河北客户体验管理系统移网网络体验明细日信息数据","通过能力商店订阅CEM发布的河北客户体验管理系统移网网络体验明细日信息_HE_D_CEM_MOBILE_EXPERIENCE_LIST数据\n1. 打通网络，完成能力商店文件订阅流程\n2. 测试文件订阅任务，检查文件是否符合要求，确人文件推送任务稳定\n3. 编写定时任务，每天完成文件MD5验证、数据入库，在任务异常时推送运维消息","接口服务类","需求方案","较低",1,0.6,0.6]
[{"$nulls":4},"接口服务类","程序开发","较低",3,0.6,1.8]
[{"$nulls":4},"接口服务类","数据开发","较低",3,0.6,1.8]
[{"$nulls":4},"接口服务类","测试验证","较低",1,0.6,0.6]
[null,"日报生成与推送","管理端-移网感知类数据计算","按照新的考核表准调整数据计算方式：\n1. sheet命名从管理端-移网质量类重新命名韦管理端-移网感知类\n2. 新增统计数据表，将愿意王质量类工单详表以及新订阅的河北客户体验管理智能定责投诉明细月累计接口日进行清洗去重然后入库到新的汇总表\n3. 按照规则完成数据统计，输出日报","数据加工类","需求方案","较低",1,0.6,0.6]
[{"$nulls":4},"数据加工类","数据开发","较低",22,0.8,17.6]
[{"$nulls":4},"数据加工类","测试验证","较低",10,0.8,8]
[null,null,"移网感知服务请求计算","从河北客户体验管理系统移网网络体验明细日信息数据统计计算服务请求日报数据","数据加工类","需求方案","较高",1,1,1]
[{"$nulls":4},"数据加工类","数据开发","较高",6,1,6]
[{"$nulls":4},"数据加工类","测试验证","较高",2,1,2]
[null,null,"投诉处理时长、超时工计算调整","1. 数据源修改为进入工单流程系统（TOP）的工单。\n    - 排除已退单（re_is_status）状态的工单\n    - 统计范围为所有存在归档时间的工单\n2. 处理时长 = 客服归档时间 - 客服受理时间，处理时长超过36小时为超时。\n3. 月底未回单的工单要计入下月工单--所以应该按归档时间计算工单范围","数据加工类","需求方案","较高",1,1,1]
[{"$nulls":4},"数据加工类","数据开发","较高",6,1,6]
[{"$nulls":4},"数据加工类","测试验证","较高",2,1,2]
[null,null,"三率计算调整","按照新的三率计算要求计算移网综合评价\n三率数据来源不变，移网综合投诉评价“三率”=响应率*0.1+解决率*0.4+满意率*0.5","数据加工类","需求方案","较低",1,1,1]
[{"$nulls":4},"数据加工类","数据开发","较低",4,0.8,3.2]
[{"$nulls":4},"数据加工类","测试验证","较低",1,1,1]
[null,null,"日报和截图生成","按照适配后的规则重新写入excel文件并修改截图程序完成截图","数据加工类","需求方案","较低",1,0.6,0.6]
[{"$nulls":4},"数据加工类","数据开发","较低",4,0.6,2.4]
[{"$nulls":4},"数据加工类","测试验证","较低",1,0.6,0.6]
[null,null,"钉钉推送任务调整适配","修改推送任务，适配新需求中的报表名称和截图文件名称。","数据加工类","需求方案","较低",1,0.6,0.6]
[{"$nulls":4},"数据加工类","数据开发","较低",4,0.6,2.4]
[{"$nulls":4},"数据加工类","测试验证","较低",1,0.6,0.6]
[{"$nulls":9},{"$f":"SUM(J2:J27)","v":66.2}]