{"text_format":"2","workbook":"xlsx","n_sheets":3,"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":"报修程序系统","index":0,"n_rows":32,"n_cols":26,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,0,13,0],[14,0,27,0],[1,1,2,1],[3,1,6,1],[7,1,9,1],[10,1,13,1],[17,1,18,1],[22,1,23,1],[17,2,18,2],[22,2,23,2]]}
["系统","一级模块","二级模块","三级模块","描述","UI设计人员","设计天数","状态","计划开始时间","完成时间","分隔","前端开发人员1","开发天数","计划开始时间","完成时间","状态","后端开发人员","开发天数","计划开始时间","完成时间","状态","测试人员","测试天数","计划开始时间","完成时间","状态"]
["南交校园报修小程序端","用户报修端","报修","/","发布报修工单（涵盖选择校区、报修区域、报修分类、上传图片等）和消息通知","罗伟",1,"未开始","2023-07-05","2023-07-05","/","甘昱新",null,"2023-07-07",null,"未开始","夏文涛",3,"2023-07-26","2023-07-28","初步完成","李荣","/","/",null,"未开始"]
[null,null,"报修记录","/","报修列表（实时查看工单状态信息）","罗伟",1,"未开始","2023-07-06","2023-07-06","/","甘昱新",null,null,null,"未开始","夏文涛",1,"2023-07-31","2023-07-31","初步完成","李荣","/","/",null,"未开始"]
[null,"郭班长端","首页","/","团队及个人数据统计、排班、工单完成排行榜、消息通知和身份切换","罗伟",1,"未开始","2023-07-07","2023-07-07","/","甘昱新",null,null,null,"未开始","夏文涛",2,"2023-08-16","2023-08-17","未开始","李荣","/","/",null,"未开始"]
[null,null,"工单管理","/","工单信息列表（涵盖待审核、待接单、维修中、已完成、已超时、已关单）","罗伟",1,"未开始","2023-07-10","2023-07-10","/","甘昱新",null,null,null,"未开始","夏文涛",2,"2023-08-04","2023-08-07","未开始","李荣","/","/",null,"未开始"]
[null,null,"待处理池","/","工单信息列表（涵盖延时、接单、派单和关闭工单）","罗伟",0.5,"未开始","2023-07-11","2023-07-11","/","甘昱新",null,null,null,"未开始","夏文涛",1,"2023-08-08","2023-08-08","未开始","李荣","/","/",null,"未开始"]
[null,null,"通讯录","/","查看外部维修人员与内部维修人员信息，进行派单和更改状态","罗伟",0.5,"未开始","2023-07-11","2023-07-11","/","甘昱新",null,null,null,"未开始","夏文涛",2,"2023-08-14","2023-08-15","未开始","李荣",null,null,null,"未开始"]
[null,"维修师傅端","首页","/","个人数据统计、排班、工单完成排行榜、消息通知和身份切换","罗伟",0.5,"未开始","2023-07-12","2023-07-12","/","甘昱新",null,null,null,"未开始","夏文涛",2,"2023-08-16","2023-08-17","未开始","李荣","/","/",null,"未开始"]
[null,null,"工单管理","/","工单信息列表（涵盖待接单、维修中、已超时、待审核）","罗伟",0.5,"未开始","2023-07-12","2023-07-12","/","甘昱新",null,null,null,"未开始","夏文涛",2,"2023-08-01","2023-08-02","初步完成","李荣","/","/",null,"未开始"]
[null,null,"待处理池","/","工单信息列表（涵盖接单、关闭工单）","罗伟",0.5,"未开始","2023-07-13","2023-07-13","/","甘昱新",null,null,null,"未开始","夏文涛",1,"2023-08-02","2023-08-03","初步完成","李荣",null,null,null,"未开始"]
[null,"后勤端","首页","/","工单状态数据统计、排班、工单完成情况、消息通知","罗伟",0.5,"未开始","2023-07-13","2023-07-13","/","甘昱新",null,null,null,"未开始","夏文涛",2,"2023-08-16","2023-08-17","未开始","李荣",null,null,null,"未开始"]
[null,null,"工单管理","/","工单数据列表（涵盖延时、派单、协作审核、关闭工单）","罗伟",0,"未开始","2023-07-13","2023-07-13","/","甘昱新",null,null,null,"未开始","夏文涛",2,"2023-08-09","2023-08-10","未开始","李荣",null,null,null,"未开始"]
[null,null,"待处理池","/","工单信息列表（涵盖延时、派单和关闭工单）","罗伟",0,"未开始","2023-07-13","2023-07-13","/","甘昱新",null,null,null,"未开始","夏文涛",1,"2023-08-11","2023-08-11","未开始","李荣",null,null,null,"未开始"]
[null,null,"通讯录","/","查看外部维修人员与内部维修人员信息，进行派单和更改状态","罗伟",0,"未开始","2023-07-13","2023-07-13","/","甘昱新",null,null,null,"未开始","夏文涛",2,"2023-08-14","2023-08-15","未开始","李荣",null,null,null,"未开始"]
["南交报修管理端","/","登录","/","管理员登录页面","罗伟",0.5,"未开始","2023-07-14","2023-07-14","/","华志杰",null,null,null,"未开始","夏文涛",1,"2023-07-24","2023-07-24","初步完成","李荣","/","/",null,"未开始"]
[null,"/","首页","/","报修分析统计、报修去死分析、总数据汇总分析、报修校区统计、报修区域统计、维修物品统计、维修师傅效率统计","罗伟",1,"未开始","2023-07-17","2023-07-17","/","华志杰",null,null,null,"未开始","夏文涛",3,"2023-08-16","2023-08-18","未开始","李荣","/","/",null,"未开始"]
[null,"/","报修区域","/","编辑两校区所有报修区域","罗伟",0.5,"未开始","2023-07-18","2023-07-18","/","华志杰",null,null,null,"未开始","夏文涛",1,"2023-07-21","2023-07-21","初步完成","李荣","/","/",null,"未开始"]
[null,"/","耗材管理","耗材管理","新增、编辑/删除/批量导入耗材，涵盖序号、耗材名称、单价、关联故障类型、录入人、创建时间、操作","罗伟",0.5,"未开始","2023-07-18","2023-07-18","/","华志杰",null,null,null,"未开始","夏文涛",2,"2023-07-19","2023-07-20","初步完成","李荣","/","/",null,"未开始"]
[null,null,null,"耗材记录","序号、耗材名称、单价、数量、金额、关联故障类型、工单、报修时间、维修时间","罗伟",0.5,"未开始","2023-07-19","2023-07-19","/","华志杰",null,null,null,"未开始","夏文涛",2,"2023-08-04","2023-08-07","初步完成","李荣",null,null,null,"未开始"]
[null,"/","员工管理","/","管理校方人员和第三方人员","罗伟",0.5,"未开始","2023-07-19","2023-07-19","/","华志杰",null,null,null,"未开始","夏文涛",3,"2023-07-12","2023-07-14","初步完成","李荣","/","/",null,"未开始"]
[null,"/","账号管理","/","新增、编辑、删除账号","罗伟",0.5,"未开始","2023-07-20","2023-07-20","/","华志杰",null,null,null,"未开始","夏文涛",2,"2023-07-06","2023-07-07","初步完成","李荣","/","/",null,"未开始"]
[null,"/","报修物品","/","关联工种维修分类","罗伟",0.5,"未开始","2023-07-20","2023-07-20","/","华志杰",null,null,null,"未开始","夏文涛",1,"2023-07-25","2023-07-25","初步完成","李荣","/","/",null,"未开始"]
[null,"/","时段设置","班次设置","管理班次，可添加、编辑和删除","罗伟",0.5,"未开始","2023-07-21","2023-07-21","/","华志杰",null,null,null,"未开始","夏文涛",1,"2023-07-17","2023-07-17","初步完成","李荣","/","/",null,"未开始"]
[null,null,null,"排班设置","对人员进行排班设置管理","罗伟",0.5,"未开始","2023-07-21","2023-07-21","/","华志杰",null,null,null,"未开始","夏文涛",1,"2023-07-18","2023-07-18","初步完成","李荣",null,null,null,"未开始"]
[null,"/","支付成功订单","/","支付成功记录，可查看详情、导出表单和退款","罗伟",0.5,"未开始","2023-07-24","2023-07-24","/","华志杰",null,null,null,"未开始","夏文涛",3,"2023-08-21","2023-08-23","未开始","李荣","/","/",null,"未开始"]
[null,"/","评价管理","/","记录用户对维修评价数据，可查看详情、删除和导出表单","罗伟",0.5,"未开始","2023-07-24","2023-07-24","/","华志杰",null,null,null,"未开始","夏文涛",1,"2023-07-10","2023-07-10","初步完成","李荣",null,null,null,"未开始"]
[null,"/","公告管理","/","发布报修工作运行各个方面的内容","罗伟",0.5,"未开始","2023-07-25","2023-07-25","/","华志杰",null,null,null,"未开始","夏文涛",0.5,"2023-07-11","2023-07-11","初步完成","李荣",null,null,null,"未开始"]
[null,"/","系统设置","/","时间设定、响应时间设置、维修时间设置、电话设置等","罗伟",0.5,"未开始","2023-07-25","2023-07-25","/","华志杰",null,null,null,"未开始","夏文涛",0.5,"2023-07-11","2023-07-11","初步完成","李荣",null,null,null,"未开始"]
[null,"部署","/","/","线上部署","/","/","/","/","/","/","/","/","/",null,"/","/",1,"2023-05-04",null,"/","李荣",null,null,null,"未开始"]
[null,"测试小程序","/","/","测试环境测试，回归测试，生产环境测试","/","/","/","/","/","/","/","/","/",null,"/","/","/","/",null,"/","李荣",null,null,null,"未开始"]
[null,"测试管理端","/","/","测试环境测试，回归测试，生产环境测试","/","/","/","/","/","/","/","/","/",null,"/","/","/","/",null,"/","李荣",null,null,null,"未开始"]
[null,"总计",null,"/","/","/",{"$f":"SUM(G2:G31)","v":14.5},null,null,null,"/",null,{"$f":"SUM(M2:M25)","v":0},{"$nulls":4},{"$f":"SUM(R2:R31)","v":46},{"$nulls":4},{"$f":"SUM(W30:W31)","v":0}]

{"sheet":"项目实施进度甘特图","index":1,"n_rows":14,"n_cols":40,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,12,0],[1,1,2,1],[4,1,6,1],[7,1,11,1]]}
["              时间                内容",null,null,"2023-03-29","2023-03-30","2023-03-31","2023-04-01","2023-04-02","2023-04-03","2023-04-04","2023-04-05","2023-04-06","2023-04-07","2023-04-08","2023-04-09","2023-04-10","2023-04-11","2023-04-12","2023-04-13","2023-04-14","2023-04-15","2023-04-16","2023-04-17","2023-04-18","2023-04-19","2023-04-20","2023-04-21","2023-04-22","2023-04-23","2023-04-24","2023-04-25","2023-04-26","2023-04-27","2023-04-28","2023-04-29","2023-04-30","2023-05-01","2023-05-02","2023-05-03","2023-05-04"]
["南交报修系统","产品","产品设计",null,null,null,"周末","周末","放假",{"$nulls":4},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"放假","放假","放假","放假","放假"]
[null,null,"产品文档编写",null,null,null,"周末","周末","放假",{"$nulls":4},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"放假","放假","放假","放假","放假"]
[null,"UI","ui设计",null,null,null,"周末","周末","放假",{"$nulls":4},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"放假","放假","放假","放假","放假"]
[null,"开发","管理端",null,null,null,"周末","周末","放假",{"$nulls":4},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"放假","放假","放假","放假","放假"]
[null,null,"小程序",null,null,null,"周末","周末","放假",{"$nulls":4},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"放假","放假","放假","放假","放假"]
[null,null,"后端",null,null,null,"周末","周末","放假",{"$nulls":4},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"放假","放假","放假","放假","放假"]
[null,"测试","小程序",null,null,null,"周末","周末","放假",{"$nulls":4},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"放假","放假","放假","放假","放假"]
[null,null,"管理端",null,null,null,"周末","周末","放假",{"$nulls":4},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"放假","放假","放假","放假","放假"]
[null,null,"测试环境测试",null,null,null,"周末","周末","放假",{"$nulls":4},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"放假","放假","放假","放假","放假"]
[null,null,"回归测试",null,null,null,"周末","周末","放假",{"$nulls":4},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"放假","放假","放假","放假","放假"]
[null,null,"生产环境测试",null,null,null,"周末","周末","放假",{"$nulls":4},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"放假","放假","放假","放假","放假"]
[null,"部署","线上部署",null,null,null,"周末","周末","放假",{"$nulls":4},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"放假","放假","放假","放假","放假"]
[null,null,"注："]

{"sheet":"Sheet1","index":2,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["管理端：","状态","说明",null,"移动端用户：","状态","说明",null,"移动端维修师傅：","状态","说明"]
["系统首页      ","未开发",null,null,"我的报修-点击金额查看详情","已完成",null,null,"消息中心","未开发"]
["工单管理     ","已完成",null,null,"我的报修-转后勤","已完成",null,null,"待分配单","已完成"]
["报修区域     ","已完成",null,null,"我的报修-已完成","已完成",null,null,"选择协作人","已完成"]
["耗材管理     ","已完成",null,null,"我的报修-待确认","目前加了假的支付接口，不影响主流程\n支付目前改为使用微信支付绑定招行",null,null,"协作审核 申请","已完成"]
["员工管理     ","已完成",null,null,"报修详情","还缺报修跟踪",null,null,"转单申请","已完成"]
["账号管理      ","已完成",null,null,"我的报修","已完成",null,null,"维修完成","已完成"]
["报修物品    ","已完成",null,null,"报修端-去评价","已完成",null,null,"添加耗材","已完成"]
["排班管理       ","已完成",null,null,"消息中心","未开发",null,null,"报价","已完成"]
["支付成功订单","未开发",null,null,"报修端-首页-选择区域-物品选择","已完成",null,null,"工单管理-关单","已完成"]
["评价管理   ","已完成",null,null,"报修端-首页-选择区域-其他","已完成",null,null,"工单管理","已完成"]
["公告管理      ","已完成",null,null,"报修端-首页-选择区域","已完成",null,null,"首页","已完成"]
["系统设置","已完成",null,null,"报修端-首页","已完成"]
[]
[]
[{"$nulls":4},"移动端郭师傅：","状态","说明",null,"移动端后勤：","状态","说明"]
[{"$nulls":4},"消息中心\n","未开发",null,null,"消息中心1","未开发"]
[{"$nulls":4},"通讯录-编辑","已完成",null,null,"通讯录-编辑1","已完成"]
[{"$nulls":4},"通讯录-弹窗","已完成",null,null,"通讯录-弹窗","已完成"]
[{"$nulls":4},"通讯录","已完成",null,null,"通讯录","已完成"]
[{"$nulls":4},"协作审核","已完成",null,null,"待分配单1","已完成"]
[{"$nulls":4},"转单审核","已完成",null,null,"协作审核","已完成"]
[{"$nulls":4},"维修完成","已完成",null,null,"转单审核","已完成"]
[{"$nulls":4},"报价","已完成",null,null,"派1","已完成"]
[{"$nulls":4},"延时","已完成",null,null,"工单管理-延时","已完成"]
[{"$nulls":4},"派单","已完成",null,null,"待确认-改价","已完成"]
[{"$nulls":4},"关联耗材","已完成",null,null,"待确认-留言","已完成"]
[{"$nulls":4},"留言","不做",null,null,"工单管理1","已完成"]
[{"$nulls":4},"关单","已完成",null,null,"首页1","已完成"]
[{"$nulls":4},"待分配单","已完成"]
[{"$nulls":4},"工单管理","已完成"]
[{"$nulls":4},"首页","已完成"]