{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["需求"],"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":69,"n_cols":7,"rows_kept":69,"cut":false,"hidden":false,"merged":[[44,0,44,6],[42,0,42,4],[43,0,43,6],[14,1,15,1],[31,1,41,1],[16,1,20,1],[2,1,7,1],[27,2,30,2],[21,1,30,1],[8,1,13,1],[0,0,0,6],[60,1,67,1],[68,0,68,4],[51,1,59,1],[46,1,50,1],[54,4,55,4],[54,2,55,2]]}
["APP产品需求（一期 硬件+商城）"]
["ID","模块","标题","描述","说明","工期","报价"]
[1,"准备\n工作","APP图标","APP图标","需要乙方创意与设计"]
[2,null,"APP名称","APP名称","甲方内部确认"]
[3,null,"AppStore帐户申请与上架","以甲方公司名义申请开发者帐户并发布应用","乙方帮助申请，完成发布"]
[4,null,"Android主流市场上架","以甲方公司名义申请开发者帐户并发布应用","乙方帮助申请，完成发布"]
[5,null,"奶粉数据","奶粉数据，包括基本信息、条码、各种营养成份等","需甲方安排人收集整理，乙方初始化进系统配合功能实现"]
[6,null,"营养知识库","母婴营养知识库","需甲方安排专业人员收集整理，，乙方初始化进系统配合功能实现"]
[7,"非功能性\n需求","UI/UE设计","要求有设计理念，交互人性化。可参考APP：小鲤鱼育儿、孕育管家、育学园、小米智能家庭"]
[8,null,"驻点服务","项目需求分析阶段，需求相关人员可以安排驻点沟通与产品设计的讨论","乙方提供阶段性驻点与项目周报制"]
[9,null,"源文件交付","需交付需求文档、原型图源文件、设计稿源文件、系统设计文档、接口说明（软件内部）、数据库字段说明、测试用例与报告、可扩展开发的源代码"]
[10,null,"服务器独立部署","可独立部署于甲方阿里云服务器","请乙方提供服务器配制建议"]
[11,null,"版本迭代更新","提供方便可靠的版本迭代方式，特别是ios版的迭代发布。实现用户端更新提醒与引导"]
[12,null,"一年期免费服务","APP正式交付上线后，提供一年期免费的系统维护服务与技术指导服务"]
[13,"首页","APP启动页&引导页","启动页，后台可更新。引导页，仅首次安装时启用"]
[14,null,"首页","APP首页规划与设计"]
[15,"用户\n模块","注册、登录","手机号+短信验证码注册，实现注册、登录相关的业务流程","准备短信验证码通道与接口文档"]
[16,null,"会员基本信息","个人图像、姓名、电话号码、胎儿或婴儿相关信息，如预产期、体重、身高等。针对初始化信息随时间显示成长信息，如怀孕周期、婴儿年龄等","要求考虑预留并一个用户多个婴孩的情况"]
[17,null,"会员中心","设计用户中心，提供便捷服务与各种功能窗口的服务"]
[18,null,"用户安装信息收集","安装APP的用户信息收集，如装机数量、手机型号等"]
[19,null,"用户数据统计","对用户数据可进行统计展示，如装机信息、各区域用户数量、会员变化量的统计展示"]
[20,"硬件\n控制","添加绑定硬件","本次主要是添加冲奶机，预留其它硬件设备的绑定"]
[21,null,"硬件入网与连接","配合硬件模块完成设备入网与APP连接控制，要求有引导与诊断提示"]
[22,null,"奶粉数据、温度、充奶量设定","以扫描奶粉条形码的方式取得奶粉数据（从初始资料库或提供网络获取方式）、手动控制当次冲奶温度与充奶量"]
[23,null,"APP端定时设定冲奶计划","可以按计划任务形式，一次设置多个冲奶计划，但每次计划，需用户手动操作触发冲奶机","手动触发时的交互设计，需考虑误操作"]
[24,null,"冲奶记录","可形成可视的类似时间轴的图形展示"]
[25,null,"硬件连接与操作数据记录","本期只作开关机、硬件操控记录的数据存储，以备后期的数据分析"]
[26,null,"操控体验要求","数据连接与传输稳定、安全可靠"]
[27,null,null,"各种设定与展示要求有流畅友好的动画效果"]
[28,null,null,"操作交互简洁人性化"]
[29,null,null,"各种状态指示明晰"]
[30,"在线\n商城","商品类别","可管理商品类别"]
[31,null,"商品详情","包括名称、型号、原价、现价、商品详情、已售数量、上下架设置、点击量、上架时间、更新时间并提供分享（到微信、QQ）功能；预留积分、库存、所属频道 字段"]
[32,null,"邮费设置","设置支付多少元可包邮，以及未满时的邮费"]
[33,null,"购物车","提供加入购物车与立即购买的方式"]
[34,null,"发货地址","可添加管理多个发货地址，并可设置默认地址"]
[35,null,"订单","订单的形成、状态扭转（包括退换货）与订单管理与备注标记"]
[36,null,"支付","支持 微信、支付宝、银联支付方式"]
[37,null,"物流","配制发货物流信息，用户可在APP中查看到物流信息。"]
[38,null,"团购","提供专门的商品团购页面，可添加多个团购商品，标记原价、团购价、参团人数，开团起始时间"]
[39,null,"拼团","提供专门的商品拼购页面，可添加多个拼购商品，用户按拼购价支付，提供分享（微信、QQ）拉人拼团的方式，达到几人后，按拼购价发货。如在规定时间内未达到拼团人数，则不成团，退款处理，关闭订单。"]
[40,null,"订单统计与报表","针对销售能进行查询统计，并形成基本的可视报表"]
["合计："]
[]
["APP产品需求（二期 营养管理 初定）"]
["ID","模块","标题","描述","说明","工期","报价"]
[1,"营养\n数据","营养知识库的智能推荐与查询","按用户区域及婴儿（胎儿）年龄情况智能推介营养知识，以及用户主动查询的功能。后台可维护更新知识库"]
[2,null,"营养问题库的查询","用户可以进行常见营养问题库的查询。后台可维护更新问题库、并标记为每日营养问题栏目的推荐问题。"]
[3,null,"消息推送","针对不同的APP安装用户，可指定推送消息，并提供定时推送的功能"]
[4,null,"基准营养数据","各区域各阶段婴儿（胎儿）应补充营养的基准营养数据维护"]
[5,null,"系统营养对比结果提示","通过用户所用奶粉数据与基准营养数据的对比，主动展示营养数据对比结果，提醒营养补充"]
[6,"营养\n社区","帖子","后台可标记精华、置顶、所属话题"]
[7,null,"主题","用户或管理员可以发起主题，其它人可跟可回可点赞可收藏 "]
[8,null,"私信","针对用户帖子可发送私信，进行私聊。"]
[9,null,"圈子","同龄婴儿（胎儿）用户自动成一个圈子","后台可对圈子进行管理"]
[10,null,null,"用户可主动建圈子，系统提供可视化的周边用户地图，由用户主动申请拉圈子，用户同意后加入。用户可搜索圈子申请加入或关注"]
[11,null,"广告位","设计并提供广告位，并能统计点击量情况","前期可不放广告，放营养知识宣传"]
[12,null,"内容搜索","用户可以主动按话题或者用户名称进行帖搜索"]
[13,null,"积分","设计积分奖励模式，积分可用于营养问题咨询"]
[14,null,"数据管理","1、社区的总人数、帖子数量、圈子数量、帖子阅读量、点赞量以及跟帖量的记录。\n2、针对帖子非法内容可进行主动过滤，或人工处理。\n3、针对违规用户可进行拉黑处理"]
[15,"营养\n咨询","营养师","提供营养师注册、审核、管理"]
[16,null,"用户营养咨询","用户可进行营养问题咨询"]
[17,null,"营养师抢答","设计并提供营养师抢答营养问题模式与机制，可通过手机与PC进行参与"]
[18,null,"系统答案推荐与搜索","系统可为营养师提供类似问题的系统答案，并提供营养问题的关键字搜索"]
[19,null,"营养师方案评价","用户可针对营养师回复内容进行星级评价，参与评价奖积分。"]
[20,null,"积分","设计积分奖励与消耗规则"]
[21,null,"数据管理","1、营养师数量、参与问题数量、问题星级评价率等数据统计，为报酬提供数据依据\n2、用户营养咨询问题与营养师解决方案数据管理，并可收录进入营养问题库"]
[22,null,"其它要求","数据信息的及时性"]
["合计："]