{"text_format":"2","workbook":"xlsx","n_sheets":2,"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":46,"n_cols":26,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,0,22,0],[24,0,41,0],[1,1,4,1],[5,1,12,1],[13,1,16,1],[17,1,22,1],[27,1,33,1],[35,1,36,1],[1,2,4,2],[6,2,11,2],[18,2,23,2],[24,2,26,2],[27,2,33,2],[35,2,36,2]]}
["系统","一级模块","二级模块","三级模块","描述","UI设计人员","设计天数","状态","计划开始时间","完成时间","分隔","前端开发人员","开发天数","计划开始时间","完成时间","状态","后端开发人员","开发天数","计划开始时间","完成时间","状态","测试人员","测试天数","计划开始时间","完成时间","状态"]
["南交校园报修小程序端","用户报修端","报修","/","需要有学生教职工年级字段","罗伟",1,"未开始","2023-07-05","2023-07-05","/","甘昱新",2,"2023-07-07","2023-07-10","未开始","夏文涛",3,"2023-07-26","2023-07-28","未开始","李荣",0.5,"2023-07-15","2023-07-16","未开始"]
[null,null,null,"/","4个小时内同一个人同一个区域和物品需要判断是否重复报修","罗伟",1,"未开始","2023-07-06","2023-07-06","/","甘昱新",1,"2023-07-11","2023-07-11","未开始","夏文涛",1,"2023-07-31","2023-07-31","未开始","李荣",0.5,"2023-07-16","2023-07-17","未开始"]
[{"$nulls":4},"评价评价语可不填写直接提交，可为空或用户没有评价"]
[null,null,null,"报修列表","报修列表每个状态都需要有（待审核、待接单、维修中、已完成已取消、已超时、已关单、已退款、申请退款、退款中、待确认、转线下）除待处理"]
[null,"郭班长端","首页","/","大量接单改为正常接单"]
[null,null,"工单管理","/","列表每个状态都需要有（待审核、待接单、维修中、已完成已取消、已超时、已关单、已退款、申请退款、退款中、待确认、待处理、转线下）","罗伟",1,"未开始","2023-07-07","2023-07-07","/","甘昱新",2,"2023-07-12","2023-07-13","未开始","夏文涛",2,"2023-08-16","2023-08-17","未开始","李荣",0.5,"2023-07-14","2023-07-14","未开始"]
[null,null,null,"工单列表","待接单前查看师傅的姓名和电话","罗伟",1,"未开始","2023-07-10","2023-07-10","/","甘昱新",1,"2023-07-13","2023-07-13","未开始","夏文涛",2,"2023-08-04","2023-08-07","未开始","李荣",1,"2023-07-14","2023-07-15","未开始"]
[null,null,null,"关单","可自定义编辑原因，可语言和文字"]
[null,null,null,"转单","转线下师傅可自动转线下"]
[null,null,null,"协作/转单","协作拒绝和转单拒绝有备注"]
[null,null,null,"退款","已支付订单可退款"]
[null,null,"待处理池","/","需要增加年级字段，值班时间待处理池可接单","罗伟",0.5,"未开始","2023-07-11","2023-07-11","/","甘昱新",1,"2023-07-14","2023-07-14","未开始","夏文涛",1,"2023-08-08","2023-08-08","未开始","李荣",0.5,"2023-07-15","2023-07-15","未开始"]
[null,"维修师傅端","首页","/","只看到自己的排班情况，大量接单改为正常接单","罗伟",0.5,"未开始","2023-07-12","2023-07-12","/","甘昱新",2,"2023-07-19","2023-07-20","未开始","夏文涛",2,"2023-08-16","2023-08-17","未开始","李荣",0.5,"2023-07-20","2023-07-20","未开始"]
[null,null,"工单管理","/","需要增加年级字段，待接单状态可看到分配师傅","罗伟",0.5,"未开始","2023-07-12","2023-07-12","/","甘昱新",1,"2023-07-21","2023-07-21","未开始","夏文涛",2,"2023-08-01","2023-08-02","未开始","李荣",0.5,"2023-07-22","2023-07-22","未开始"]
[null,null,"待处理池","/","师傅值班时接单池的单子都可以维修，第二天重新分","罗伟",0.5,"未开始","2023-07-13","2023-07-13","/","甘昱新",1,"2023-07-24","2023-07-24","未开始","夏文涛",1,"2023-08-02","2023-08-03","未开始","李荣",0.5,"2023-07-25","2023-07-25","未开始"]
[null,null,"改价","/","不可改价"]
[null,"后勤端","首页","/","大量接单改为正常接单","罗伟",0.5,"未开始","2023-07-13","2023-07-13","/","甘昱新",2,"2023-07-25","2023-07-26","未开始","夏文涛",2,"2023-08-16","2023-08-17","未开始","李荣",0.5,"2023-07-27","2023-07-27","未开始"]
[null,null,"工单管理","/","列表每个状态都需要有（待审核、待接单、维修中、已完成、已取消、已超时、已关单、已退款、申请退款、退款中、待确认、待处理、转线下）","罗伟",0,"未开始","2023-07-13","2023-07-13","/","甘昱新",2,"2023-07-27","2023-07-28","未开始","夏文涛",2,"2023-08-09","2023-08-10","未开始","李荣",1,"2023-07-29","2023-07-30","未开始"]
[null,null,null,"工单列表","待接单前查看师傅的姓名和电话"]
[null,null,null,"关单","可自定义编辑原因，可语言和文字"]
[null,null,null,"退款","已支付订单可退款"]
[null,null,null,"转单","转线下师傅可自动转线下"]
[null,null,null,"协作/转单","协作拒绝和转单拒绝有备注"]
["南交报修管理端","/","首页","/","需区分墨轩湖校区和黄家湖校区，师傅展示界面默认4个，可滑动查看更多，可点击名字查看师傅好评数和工单数等信息，有搜索导出功能，时间全部默认本月","罗伟",0.5,"未开始","2023-07-14","2023-07-14","/","华志杰",2,"2023-07-17","2023-07-18","未开始","夏文涛",1,"2023-07-24","2023-07-24","未开始","李荣",1,"2023-07-19","2023-07-20","未开始"]
[null,null,null,"/","待审核、待接单、维修中、已完成、已取消、已超时、已关单、已退款、申请退款、退款中、待确认、待处理、转线下都需要有"]
[null,"/",null,"/","耗材记录要有数量、品名、校区（区域）、有偿、无偿","罗伟",1,"未开始","2023-07-17","2023-07-17","/","华志杰",3,"2023-07-19","2023-07-21","未开始","夏文涛",3,"2023-08-16","2023-08-18","未开始","李荣",0.5,"2023-07-22","2023-07-22","未开始"]
[null,"/","工单管理","改价","可更改价格，可搜索耗材名称","罗伟",0.5,"未开始","2023-07-18","2023-07-18","/","华志杰",2,"2023-07-24","2023-07-25","未开始","夏文涛",1,"2023-07-21","2023-07-21","未开始","李荣",1,"2023-07-26","2023-07-27","未开始"]
[null,null,null,"关单","可自定义编辑原因"]
[null,null,null,"转单","转线下师傅可自动转线下"]
[null,null,null,"协作/转单","协作拒绝和转单拒绝有备注"]
[null,null,null,"退款","已支付订单可退款"]
[null,null,null,"工单详情/工单列表","待审核、待接单、维修中、已完成、转线下、已取消、已超时、已关单、已退款、申请退款、退款中、待确认、待处理都需要有"]
[null,null,null,"打印","任意状态可打印"]
[null,"/","报修区域","/","可任意拖拽排序","罗伟",0.5,"未开始","2023-07-18","2023-07-18","/","华志杰",2,"2023-07-24","2023-07-25","未开始","夏文涛",1,"2023-07-21","2023-07-21","未开始","李荣",1,"2023-07-26","2023-07-27","未开始"]
[null,"/","耗材管理","耗材管理","耗材名称改完品名，可筛选校区","罗伟",0.5,"未开始","2023-07-18","2023-07-18","/","华志杰",2,"2023-07-26","2023-07-27","未开始","夏文涛",2,"2023-07-19","2023-07-20","未开始","李荣",1,"2023-08-05","2023-08-06","未开始"]
[null,null,null,"耗材记录","耗材记录要有数量、品名、校区（区域）、有偿、无偿、改价人","罗伟",0.5,"未开始","2023-07-19","2023-07-19","/","华志杰",1,"2023-07-28","2023-07-28","未开始","夏文涛",2,"2023-08-04","2023-08-07","未开始","李荣",0.5,"2023-07-31","2023-07-31","未开始"]
[null,"/","员工管理","/","新增其他，其他为线下师傅","罗伟",0.5,"未开始","2023-07-19","2023-07-19","/","华志杰",2,"2023-07-31","2023-08-01","未开始","夏文涛",3,"2023-07-12","2023-07-14","未开始","李荣",0.5,"2023-08-02","2023-08-02","未开始"]
[null,"/","报修物品","/","可任意拖拽排序","罗伟",0.5,"未开始","2023-07-20","2023-07-20","/","华志杰",2,"2023-08-04","2023-08-07","未开始","夏文涛",1,"2023-07-25","2023-07-25","未开始","李荣",0.5,"2023-08-08","2023-08-08","未开始"]
[null,"/","支付成功订单","/","退款流程，拒绝状态为原状态，拒绝后可重新申请退款","罗伟",0.5,"未开始","2023-07-24","2023-07-24","/","华志杰",2,"2023-08-14","2023-08-15","未开始","夏文涛",3,"2023-08-21","2023-08-23","未开始","李荣",0.5,"2023-08-16","2023-08-16","未开始"]
[null,"/","评价管理","/","筛选星级","罗伟",0.5,"未开始","2023-07-24","2023-07-24","/","华志杰",2,"2023-08-16","2023-08-17","未开始","夏文涛",1,"2023-07-10","2023-07-10","未开始","李荣",1,"2023-08-18","2023-08-19","未开始"]
[null,"/","系统设置","/","将自动好评时间小时改为天数","罗伟",0.5,"未开始","2023-07-25","2023-07-25","/","华志杰",3,"2023-08-23","2023-08-25","未开始","夏文涛",0.5,"2023-07-11","2023-07-11","未开始","李荣",0.5,"2023-08-26","2023-08-26","未开始"]
[null,"部署","/","/","线上部署","/","/","/","/","/","/","/","/","/","/","/","夏文涛",0.5,"2023-08-23","2023-08-23","未开始","李荣",0.5,"2023-08-24","2023-08-24","未开始"]
[null,"测试小程序","/","/","测试环境测试，回归测试，生产环境测试","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","李荣",5," /","/","未开始"]
[null,"测试管理端","/","/","测试环境测试，回归测试，生产环境测试","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","李荣",4,"/","/","未开始"]
[null,"总计",null,"/","/","/",{"$f":"SUM(G2:G45)","v":12.5},"/","/","/","/","/",{"$f":"SUM(M2:M40)","v":33},"/","/","/","/",{"$f":"SUM(R2:R45)","v":37},"/","/","/","/",{"$f":"SUM(W2:W45)","v":23.5},"/","/","/"]

{"sheet":"项目实施进度甘特图","index":1,"n_rows":14,"n_cols":62,"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],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[1,10,2,10],[1,11,2,11],[1,12,2,12],[1,13,2,13],[1,14,2,14],[1,15,2,15],[1,16,2,16],[1,17,2,17],[1,18,2,18],[1,19,2,19],[1,20,2,20],[1,21,2,21],[1,22,2,22],[1,23,2,23],[1,24,2,24],[1,25,2,25],[1,26,2,26],[1,27,2,27],[1,28,2,28],[1,29,2,29],[1,30,2,30],[1,31,2,31],[1,32,2,32],[1,33,2,33],[1,34,2,34],[1,35,2,35],[1,36,2,36],[1,37,2,37],[1,38,2,38],[1,39,2,39],[1,40,2,40],[1,41,2,41],[1,42,2,42],[1,43,2,43],[1,44,2,44],[1,45,2,45],[1,46,2,46],[1,47,2,47],[1,48,2,48],[1,49,2,49],[1,50,2,50],[1,51,2,51],[1,52,2,52],[1,53,2,53],[1,54,2,54],[1,55,2,55],[1,56,2,56],[1,57,2,57],[1,58,2,58],[1,59,2,59],[1,60,2,60],[1,61,2,61]]}
["              时间                内容",null,null,"2023-07-05","2023-07-06","2023-07-07","2023-07-08","2023-07-09","2023-07-10","2023-07-11","2023-07-12","2023-07-13","2023-07-14","2023-07-15","2023-07-16","2023-07-17","2023-07-18","2023-07-19","2023-07-20","2023-07-21","2023-07-22","2023-07-23","2023-07-24","2023-07-25","2023-07-26","2023-07-27","2023-07-28","2023-07-29","2023-07-30","2023-07-31","2023-08-01","2023-08-02","2023-08-03","2023-08-04","2023-08-05","2023-08-06","2023-08-07","2023-08-08","2023-08-09","2023-08-10","2023-08-11","2023-08-12","2023-08-13","2023-08-14","2023-08-15","2023-08-16","2023-08-17","2023-08-18","2023-08-19","2023-08-20","2023-08-21","2023-08-22","2023-08-23","2023-08-24","2023-08-25","2023-08-26","2023-08-27","2023-08-28","2023-08-29","2023-08-30","2023-08-31","2023-09-01"]
["南交报修系统","产品","产品文档编写",null,null,null,"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末"]
[]
[null,"UI","ui设计",null,null,null,"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末"]
[null,"开发","管理端",null,null,null,"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末"]
[null,null,"小程序",null,null,null,"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末"]
[null,null,"后端",null,null,null,"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末"]
[null,"测试","小程序",null,null,null,"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末"]
[null,null,"管理端",null,null,null,"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末"]
[null,null,"测试环境测试",null,null,null,"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末"]
[null,null,"回归测试",null,null,null,"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末"]
[null,null,"生产环境测试",null,null,null,"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末"]
[null,"部署","线上部署",null,null,null,"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末",{"$nulls":5},"周末","周末"]
[null,null,"注："]