{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":53,"n_cols":11,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,0,51,0],[1,3,4,3],[1,2,4,2],[9,3,12,3],[9,2,12,2],[1,1,12,1],[13,3,15,3],[13,2,15,2],[16,2,18,2],[19,2,21,2],[16,3,18,3],[19,3,21,3],[22,2,24,2],[25,2,27,2],[28,2,30,2],[22,3,24,3],[5,2,8,2],[5,3,8,3],[40,2,42,2],[40,3,42,3],[46,2,48,2],[25,3,27,3],[28,3,30,3],[31,2,33,2],[37,2,39,2],[34,2,36,2],[34,3,36,3],[46,3,48,3],[49,3,51,3],[43,2,45,2],[43,3,45,3],[13,1,39,1],[31,3,33,3],[37,3,39,3],[40,1,51,1],[49,2,51,2]]}
["功能需求","一级模块","二级模块","功能详述","功能类型","工作类型","难度级别","基准工时","难度系数","工时预估（人/天）","备注"]
["投诉工单日报表自动推送","数据订阅","河北_CEM高品质2日统计数据订阅","河北_CEM高品质2日统计为CEM通过能力商店发布的投诉工单客户端通报数据\n1. 打通能力商店网络，完成文件订阅流程\n2. 测试文件订阅任务，检查文件推送的稳定性\n3. 完成文件MD5验证、字段确认、数据入库","接口服务类","需求方案","较高",1,1,{"$f":"H2*I2","v":1}]
[{"$nulls":4},"接口服务类","程序开发","较高",3,1,{"$f":"H3*I3","v":3}]
[{"$nulls":4},"接口服务类","数据开发","较高",3,1,3]
[{"$nulls":4},"接口服务类","测试验证","较高",1,1,1]
[null,null,"河北_CEM移网质量投诉明细数据订阅","河北_CEM移网质量投诉明细是通过能力商店发布的投诉工单管理端通报数据\n1. 打通能力商店网络，完成文件订阅流程\n2. 测试文件订阅任务，检查文件推送的稳定性\n3. 完成文件MD5验证、字段确认、数据入库","接口服务类","需求方案","较高",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,null,"钉钉消息推送服务（钉钉群机器人推送）接口订阅","钉钉消息推送服务是能力商店提供的一个API接口，可用于向钉钉群推送文本消息，但无法推送文件，订阅后用于推送运维消息。\n1. 打通网络，完成能力商店的订阅流程\n2. 在接收运维消息的钉钉群添加机器人获取token\n3. 包装用于推送运维消息的服务","接口服务类","需求方案","较高",1,1,1]
[{"$nulls":4},"接口服务类","程序开发","较低",3,1,3]
[{"$nulls":4},"接口服务类","数据开发","较低",3,1,3]
[{"$nulls":4},"接口服务类","测试验证","较高",1,1,1]
[null,"报表生成","管理端-移网质量类报表建模","1. 从河北_CEM移网质量投诉明细数据获取当月1日起各地市统计数据\n2. 从各地市数据统计每天的全省汇总以及各地市截止到当日的统计数据\n3. 维护一个各地市用户数表，每月更新，从中读取用户数数据\n4. 维护一个目标万投比数据表，按需更新，从中读取目标万投比数据\n5. 通过各地市和全省从当月1日到当前日期的统计数据和用户数计算万投比、全月万投比预测、与目标差距等数据","数据加工类","需求方案","较高",1,1,1]
[{"$nulls":4},"数据加工类","数据开发","较高",22,1,22]
[{"$nulls":4},"数据加工类","测试验证","较高",10,1,10]
[null,null,"管理端-重复投诉率报表建模","重复工单是指同一个号码在当月重复进行投诉形成的工单。\n1. 按照重复工单逻辑获取当日各地市重复工单统计，并计算全省统计\n2. 获取前一天的重复工单统计，为了应对数据缺失情况，如果前一天无数据可再向前获取\n3. 计算重复投诉率(重复工单数/总工单数)和重复工单增量，按照增量排序","数据加工类","需求方案","较高",1,1,1]
[{"$nulls":4},"数据加工类","数据开发","较低",22,0.6,13.2]
[{"$nulls":4},"数据加工类","测试验证","较低",10,0.6,6]
[null,null,"投诉处理时长、超时工单情况建模","统计超时工单情况和工单平均处理时长\n1. 按照河北_CEM移网质量投诉明细统计的是否超时办结字段统计超时工单量\n2. 平均处理时长仅统计已归档工单，计算从受理时间到审核时间经历的小时数，如果审核时间为空，已办结的按0小时计算，未办结的计算归档时间减去受理时间的小时数","数据加工类","需求方案","较高",1,1,1]
[{"$nulls":4},"数据加工类","数据开发","较低",22,0.6,13.2]
[{"$nulls":4},"数据加工类","测试验证","较低",10,0.6,6]
[null,null,"客户端-投诉问题解决满意度报表生成","1. 从河北_CEM移网质量投诉明细数据按照日期和区县获取问题解决满意度数据，计算全省统计数据\n2. 从配置文件获取目标解决满意度，计算与达标值的差距\n3. 按照与达标值得差距进行排序","数据加工类","需求方案","较高",1,1,1]
[{"$nulls":4},"数据加工类","数据开发","较高",6,1,6]
[{"$nulls":4},"数据加工类","测试验证","较高",2,1,2]
[null,null,"客户端-投诉问题解决率","投诉问题解决率的处理方式与投诉问题解决满意度相似，获取各地市数据、计算全省统计值、按照与达标值得差距进行排序","数据加工类","需求方案","较高",1,1,1]
[{"$nulls":4},"数据加工类","数据开发","较低",6,0.6,3.5999999999999996]
[{"$nulls":4},"数据加工类","测试验证","较高",2,1,2]
[null,null,"客户端-投诉问题响应率","投诉问题响应率的处理方式与投诉问题解决满意度相似，获取各地市数据、计算全省统计值、按照与达标值得差距进行排序","数据加工类","需求方案","较高",1,1,1]
[{"$nulls":4},"数据加工类","数据开发","较低",6,0.6,3.5999999999999996]
[{"$nulls":4},"数据加工类","测试验证","较高",2,1,2]
[null,null,"报表输出","将报表数据按照指定的格式输出到excel文件，支持条件背景格式","数据加工类","需求方案","较高",1,1,1]
[{"$nulls":4},"数据加工类","数据开发","较高",4,1,4]
[{"$nulls":4},"数据加工类","测试验证","较高",1,1,1]
[null,null,"通用截图工具","为了方便报表查看，需要将excel报表进行截图输出png格式，要求截图无水印，需要自行开发截图工具，截图工具需要具备以下能力\n1. 支持对excel表格上指定的矩形区域进行截图\n2. 支持excel表格中不同的字体和字号，支持字体加粗、斜体等\n3. 支持excel三色渐进和两色渐进的条件背景颜色","数据加工类","需求方案","较高",1,1,1]
[{"$nulls":4},"数据加工类","数据开发","较低",22,0.6,13.2]
[{"$nulls":4},"数据加工类","测试验证","较低",10,0.6,6]
[null,null,"编排每日报表生成定时任务","1. 编排定时任务，完成数据源检查及入库、报表生成和截图\n2. 遇到异常时发送运维消息提醒运维人员处理\n3. 经过一定的时间间隔后重新尝试，继续完成任务。\n4. 提供API接口用于手动完成数据检查、入库、回退、报表生成。","数据加工类","需求方案","较高",1,1,{"$f":"H38*I38","v":1}]
[{"$nulls":4},"数据加工类","数据开发","较高",4,1,4]
[{"$nulls":4},"数据加工类","测试验证","较高",1,1,1]
[null,"钉钉推送","获取要推送的文件数据","报表在内网生成，钉钉推送需要连接到钉钉开放平台，因此需要分开部署，推送模块从报表生成模块获取要推送的文件数据","数据加工类","需求方案","较高",1,1,1]
[{"$nulls":4},"数据加工类","数据开发","较高",4,1,4]
[{"$nulls":4},"数据加工类","测试验证","较高",1,1,1]
[null,null,"封装钉钉推送工具","封装钉钉开放平台API，用于支持报表文件、图片以及markdown富文本的发送\n1. 钉钉开放平台创建应用，获取连接信息\n2. 封装钉钉开放平台用于上传文件、发送文件消息、图片消息及markdown、文本消息的API","数据加工类","需求方案","较高",1,1,1]
[{"$nulls":4},"数据加工类","数据开发","较高",6,1,6]
[{"$nulls":4},"数据加工类","测试验证","较高",2,1,2]
[null,null,"生成每日情况文本数据","读取每日报表数据，按照要求的文本格式填充数据，通过markdown完成字体颜色、粗体等富文本格式，生成每日推送的富文本消息。","数据加工类","需求方案","较高",1,1,1]
[{"$nulls":4},"数据加工类","数据开发","较高",4,1,4]
[{"$nulls":4},"数据加工类","测试验证","较高",1,1,1]
[null,null,"编排每日推送定时任务","1. 完成每日定时任务的调度\n2. 任务出现异常时，发送运维消息提醒运维人员，并等待错误恢复。\n3. 错误恢复后自动重新尝试发送\n4. 提供API接口用于手动完成发送，以及撤回消息。","数据加工类","需求方案","较高",1,1,1]
[{"$nulls":4},"数据加工类","数据开发","较高",4,1,4]
[{"$nulls":4},"数据加工类","测试验证","较高",1,1,1]
["合计",{"$nulls":8},{"$f":"SUM(J2:J52)","v":176.39999999999998}]