{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["C、N市场","H市场","B市场"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":2,"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":"C、N市场","index":0,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,1,1,7],[2,1,2,3],[3,1,3,7],[4,1,4,7],[5,1,5,7],[6,1,6,7],[7,1,7,7],[8,1,8,7],[9,1,9,7],[10,0,10,7],[11,1,11,7],[12,1,12,7],[13,1,13,7],[14,1,14,7],[15,0,15,7],[17,5,17,7],[18,0,18,7],[19,1,19,3],[19,5,19,7],[20,0,20,7],[22,0,22,7],[25,0,25,3],[25,4,25,7],[27,0,27,7],[28,2,28,3],[28,4,28,5],[28,6,28,7],[29,2,29,3],[29,4,29,5],[29,6,29,7],[30,2,30,3],[30,4,30,5],[30,6,30,7],[31,2,31,3],[31,4,31,5],[31,6,31,7],[32,2,32,3],[32,4,32,5],[32,6,32,7],[33,2,33,3],[33,4,33,5],[33,6,33,7],[34,2,34,3],[34,4,34,5],[34,6,34,7],[35,2,35,3],[35,4,35,5],[35,6,35,7],[36,2,36,3],[36,4,36,5],[36,6,36,7],[37,2,37,3],[37,4,37,5],[37,6,37,7],[38,0,38,7],[39,3,39,7],[40,1,40,7],[41,3,41,7],[42,1,42,7],[43,1,43,7],[44,1,44,7],[45,1,45,7],[46,1,46,7],[29,0,31,0],[32,0,34,0],[35,0,37,0]]}
["需求基本信息"]
["需求名称"]
["提出部门",null,null,null,"需求提出人",null,"期待完成时间"]
["系统使用对象"]
["业务开放范围"]
["涉及系统"]
["涉及渠道"]
["需求背景"]
["需求内容"]
["需求类型","（请勾选需求类型并根据需求类型选择以下一个或多个模板填写）"]
["【功能优化类】需求填写"]
["优化类型"]
["优化功能名称"]
["系统/业务现状"]
["优化点"]
["【新增办理渠道类】需求填写"]
["开展业务","需要开展的业务","支付方式",null,"二次确认","是否要做二次确认，二次确认的方式","业务权限说明","是否需要权限控制"]
["是否新增渠道、工号","是否新增渠道编码、新建工号还是复用现有渠道与工号","实收报表要求","        \n（如是，明确纳入哪个实收报表）","报表要求","如涉及，提供样张附件"]
["【新增业务类】需求填写"]
["需求目标","1.简要描述业务需求要实现的目标；\n2.为业务需求评审提供依据；",null,null,"预期业务量/预期效果","尽可能量化描述需求上线后的预期业务量，或者预期业务服务提升效果 "]
["业务规则"]
["互斥规则","资费间的互斥\n营销案间的互斥\n资费与营销案的互斥等","捆绑规则","业务办理时，相关捆绑产品或业务的描述","生失效规则","业务生效和失效的规则设定","其他特殊业务规则"]
["业务受理"]
["是否校验预存","如是，则预存需要大于多少","校验方式",null,"二次确认","是否要做二次确认","业务权限说明","是否需要权限控制"]
["业务冲正"," ","业务取消规则","是否可以取消\n是否可跨月取消\n取消是否要收违约金","实收报表要求","         \n（如是，明确纳入哪个实收报表）","报表要求","如涉及，提供样张附件"]
["客户服务",null,null,null,"计费账务"]
["业务短信\n（提供短信模板）",null,"免填单","需要打印哪些信息，如果需要有特殊的业务说明需要打印","账详单要求","如涉及，提供样张","计费方案","按天计费、按月计费、特殊计费"]
["【渠道费用类】需求填写"]
["需求维度分类","需求维度","需求维度描述",null,"需求维度备注",null,"示例"]
["业务场景","业务场景描述",null,null,"因酬金处于业务的后端，所以为保证准确结酬，需了解前端的业务场景。",null,"为提高volte活跃客户数，现要求地市公司为进厅客户打开终端的volte开关按钮。每打开一个开关，且在该终端在当月产生volte话单，则支付酬金2元/笔，或量酬1元/笔。一个号码12个月内仅结酬一次。但打开开关无法通过boss侧记录，从而导致酬金无法通过工号和渠道识别，造成无法支付酬金。现需开发volte打开开关登记界面，以便实现酬金支付操作"]
[null,"结算数据源描述",null,null,"对哪类数据进行结算"]
[null,"经分提供数据",null,null,"如酬金直接依据经分报表数据，请提供经分报表路径"]
["结算规则","结酬规则",null,null,"描述对符合什么情况的数据进行结酬"]
[null,"酬金科目",null,null,"落账的酬金科目详见备注"]
[null,"考核条件",null,null,"对参与结酬数据的过滤条件，比如判断用户状态、资费状态、商品状态等条件。"]
["结算标准","分段条件",null,null,"描述如需支持根据什么条件的分段，以支持不同比例的结算标准，如资费价格在10-20元，按资费价格20%结算，资费价格在21-40之间，按资费价格的30%结算。"]
[null,"单期/多期上限",null,null,"是否要求单期酬金封顶、多期酬金封顶"]
[null,"是否涉及补结",null,null,"如果业务已经开展需要补结，请描述涉及从哪个账期开始补结。"]
["【业务稽核类】需求填写"]
["稽核业务名称",null,"稽核需求类型"]
["稽核点类型"]
["是否需要AI稽核",null,"AI稽核规则描述","简要描述AI稽核的内容、比对的原则"]
["数据来源","如：BOSS系统某功能页面某字段；经分系统某报表某字段"]
["稽核规则描述","简要描述稽核的内容、比对的原则"]
["派单规则描述","简要描述工单流转角色、流转过程中限制的条件"]
["工单归档条件","描述是否超时自动归档，归档后是否可以再次打回"]
["其他说明","新增报表、优化报表、功能优化类需求请描述需求内容"]

{"sheet":"H市场","index":1,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,1,1,7],[2,1,2,3],[3,1,3,7],[4,1,4,7],[5,1,5,7],[6,1,6,7],[7,1,7,7],[8,1,8,7],[9,1,9,7],[10,0,10,7],[11,1,11,7],[12,1,12,7],[13,1,13,7],[14,1,14,7],[15,0,15,7],[17,5,17,7],[18,0,18,7],[19,1,19,3],[19,5,19,7],[20,0,20,7],[22,0,22,7],[26,0,26,3],[26,4,26,7],[28,0,28,7],[29,2,29,3],[29,4,29,5],[29,6,29,7],[30,2,30,3],[30,4,30,5],[30,6,30,7],[31,2,31,3],[31,4,31,5],[31,6,31,7],[32,2,32,3],[32,4,32,5],[32,6,32,7],[33,2,33,3],[33,4,33,5],[33,6,33,7],[34,2,34,3],[34,4,34,5],[34,6,34,7],[35,2,35,3],[35,4,35,5],[35,6,35,7],[36,2,36,3],[36,4,36,5],[36,6,36,7],[37,2,37,3],[37,4,37,5],[37,6,37,7],[38,2,38,3],[38,4,38,5],[38,6,38,7],[39,0,39,7],[40,3,40,7],[41,1,41,7],[42,3,42,7],[43,1,43,7],[44,1,44,7],[45,1,45,7],[46,1,46,7],[47,1,47,7],[30,0,32,0],[33,0,35,0],[36,0,38,0]]}
["需求基本信息"]
["需求名称"]
["提出部门",null,null,null,"需求提出人",null,"期待完成时间"]
["系统使用对象"]
["业务开放范围"]
["涉及系统"]
["涉及渠道"]
["需求背景"]
["需求内容"]
["需求类型","（请勾选需求类型并根据需求类型选择以下一个或多个模板填写）"]
["【功能优化类】需求填写"]
["优化类型"]
["优化功能名称"]
["系统/业务现状"]
["优化点"]
["【新增办理渠道类】需求填写"]
["开展业务","需要开展的业务","支付方式",null,"二次确认","是否要做二次确认，二次确认的方式","业务权限说明","是否需要权限控制"]
["是否新增渠道、工号","是否新增渠道编码、新建工号还是复用现有渠道与工号","实收报表要求","        \n（如是，明确纳入哪个实收报表）","报表要求","如涉及，提供样张附件"]
["【新增业务类】需求填写"]
["需求目标","1.简要描述业务需求要实现的目标；\n2.为业务需求评审提供依据；",null,null,"预期业务量/预期效果","尽可能量化描述需求上线后的预期业务量，或者预期业务服务提升效果 "]
["业务规则"]
["互斥规则","资费间的互斥\n营销案间的互斥\n资费与营销案的互斥等","捆绑规则","业务办理时，相关捆绑产品或业务的描述","生失效规则","业务生效和失效的规则设定","其他特殊业务规则"]
["业务受理"]
["支付方式",null,"校验方式",null,"二次确认","是否要做二次确认","业务权限说明","是否需要权限控制"]
["业务冲正",null,"业务取消规则","是否可以取消\n是否可跨月取消\n取消是否要收违约金","家庭解散","家庭解散调整与规则","成员管理","成员加入与退出规则"]
["是否允许跨地市","是否允许跨地市办理\n是否允许跨地市加成员","信控","宽带、主副卡、家庭信控规则","实收报表要求","         \n（如是，明确纳入哪个实收报表）","报表要求","如涉及，提供样张附件"]
["客户服务",null,null,null,"计费账务"]
["业务短信\n（提供短信模板）",null,"免填单","需要打印哪些信息，如果需要有特殊的业务说明需要打印","账详单要求","如涉及，提供样张","计费方案","按天计费、按月计费、特殊计费"]
["【渠道费用类】需求填写"]
["需求维度分类","需求维度","需求维度描述",null,"需求维度备注",null,"示例"]
["业务场景","业务场景描述",null,null,"因酬金处于业务的后端，所以为保证准确结酬，需了解前端的业务场景。",null,"为提高volte活跃客户数，现要求地市公司为进厅客户打开终端的volte开关按钮。每打开一个开关，且在该终端在当月产生volte话单，则支付酬金2元/笔，或量酬1元/笔。一个号码12个月内仅结酬一次。但打开开关无法通过boss侧记录，从而导致酬金无法通过工号和渠道识别，造成无法支付酬金。现需开发volte打开开关登记界面，以便实现酬金支付操作"]
[null,"结算数据源描述",null,null,"对哪类数据进行结算"]
[null,"经分提供数据",null,null,"如酬金直接依据经分报表数据，请提供经分报表路径"]
["结算规则","结酬规则",null,null,"描述对符合什么情况的数据进行结酬"]
[null,"酬金科目",null,null,"落账的酬金科目详见备注"]
[null,"考核条件",null,null,"对参与结酬数据的过滤条件，比如判断用户状态、资费状态、商品状态等条件。"]
["结算标准","分段条件",null,null,"描述如需支持根据什么条件的分段，以支持不同比例的结算标准，如资费价格在10-20元，按资费价格20%结算，资费价格在21-40之间，按资费价格的30%结算。"]
[null,"单期/多期上限",null,null,"是否要求单期酬金封顶、多期酬金封顶"]
[null,"是否涉及补结",null,null,"如果业务已经开展需要补结，请描述涉及从哪个账期开始补结。"]
["【业务稽核类】需求填写"]
["稽核业务名称",null,"稽核需求类型"]
["稽核点类型"]
["是否需要AI稽核",null,"AI稽核规则描述","简要描述AI稽核的内容、比对的原则"]
["数据来源","如：BOSS系统某功能页面某字段；经分系统某报表某字段"]
["稽核规则描述","简要描述稽核的内容、比对的原则"]
["派单规则描述","简要描述工单流转角色、流转过程中限制的条件"]
["工单归档条件","描述是否超时自动归档，归档后是否可以再次打回"]
["其他说明","新增报表、优化报表、功能优化类需求请描述需求内容"]

{"sheet":"B市场","index":2,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,1],[1,2,1,8],[2,0,2,1],[2,2,2,4],[3,0,3,1],[3,2,3,8],[4,0,4,1],[4,2,4,8],[5,0,5,1],[5,2,5,8],[6,0,6,1],[6,2,6,8],[7,0,7,1],[7,2,7,8],[8,0,8,1],[8,2,8,8],[9,0,9,1],[9,2,9,8],[10,0,10,1],[10,2,10,8],[11,0,11,1],[11,2,11,8],[12,2,12,8],[13,2,13,8],[14,2,14,8],[15,2,15,8],[16,2,16,8],[12,0,16,0]]}
["需求基本信息"]
["需求名称"]
["提出部门",{"$nulls":4},"需求提出人",null,"提出日期"]
["紧急程度"]
["需求性质"]
["涉及系统"]
["业务名称",null,"专线类：\n\n\n\n融合类：\n\n\n其他产品："]
["功能名称",null,"例：新V网成员删除，若为新增功能请填写新功能名称。"]
["需求涉及内容"]
["六个一标准"]
["支持终端"]
["使用角色"]
["需求详细说明","业务场景"]
[null,"业务规则"]
[null,"界面要素","例：列表信息包含：*服务号码、*成员角色、状态、生效时间、失效时间，其中*为必填项"]
[null,"审批流程及处理角色","注：若涉及审批则明确审批矩阵\n例：需求发起（客户经理） ->  合同签订（客户经理）  -> 业务开通 -> 开户计费（自动） -> 归档。"]
[null,"描述"]