{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["系统功能模块","原型设计","项目计划"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":2,"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":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,3],[27,0,27,1]]}
["          高校实验室标准化管理平台功能模块"]
["序号","模块名称","功能说明","备注","后台开发","前端开发","测试"]
["一","设备资产管理"]
[1.1000000000000001,"设备管理","设备基本台账管理","计算机1000台左右",1,1,1]
[1.2,"设备质量管理","设备采购、维修、维护、保养、报废等操作管理",null,1,1,1]
[1.3,"设备运行记录","根据课程安排，自动记录设备使用情况",null,1,1,1]
["二","实验课程安排"]
[2.1,"课程查询","课程安排查询","学年、发布",1,1,1]
[2.2000000000000002,"课程安排","课程安排","机房、班级",1,1,1]
[2.2999999999999998,"排课规则设置","评课规则设置","每天12节"]
[2.4,"班级管理","班级管理","年级、名称",1,1,1]
["三","人员管理"]
[3.1,"员工管理","员工管理",null,1,1,1]
["四","值日表管理"]
[4.0999999999999996,"值日表查询","值日表查询",null,1,1,1]
[4.2,"值日表设置","值日表设置","设置人员",1,2,1]
[4.3,"值日报规则设置","值日报规则设置","上午、下午、晚上"]
["五","实验室基础设置"]
[5.0999999999999996,"实验室设计","实验室设计","20个机房",1,1,1]
[5.2,"计算机设置","计算机设置",null,1,1,1]
["六","系统设置","系统参数设置",null,1,1,1]
["七","账号管理","平台账户管理",null,1,1,1]
["八","用户管理"]
[8.1,"用户管理",null,null,1,1,1]
[8.1999999999999993,"角色管理","角色、菜单权限、操作权限管理",null,1,1,1]
[8.3000000000000007,"组织结构管理","组织结构管理",null,1,1,1]
["九","信息发布","信息发布，在首页展示，无分类",null,1,1,1]
[null,null,null,{"$f":"SUM(E28:G28)","v":52},{"$f":"SUM(E4:E27)","v":17},18,17]

{"sheet":"原型设计","index":1,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,0,24,0],[25,0,38,0],[1,1,8,1],[9,1,16,1],[17,1,19,1],[20,1,24,1],[25,1,30,1],[31,1,38,1]]}
["模块","页面","说明","备注"]
["二、实验课程安排","2.1.课程查询页面","学年自动生成","生成规则（三年？）"]
[null,null,"学期为字典表设置","春季、夏季、秋季"]
[null,null,"班级筛选项（下拉选择班级基础表维护的班级），方便学生自行查看课程安排","班级信息：年级（自动生成下拉）+名称"]
[null,null,"授课教师筛选项，方便教师查看自己的课程安排"]
[null,null,"实验地点筛选项，方便课程安排时，实验室的统筹规划"]
[null,null,"新增按钮：新增时根据所选学年及学期带入详情页新建数据","详情页学期学年可修改？"]
[null,null,"查询按钮：按照筛选项筛出数据"]
[null,null,"发布按钮：按照选择的学年、学期发布课程安排"]
[null,"2.2.课程新增页面","课程名称为字典维护"]
[null,null,"授课老师下拉选择"]
[null,null,"实验地点下拉选择"]
[null,null,"周次手工填写"]
[null,null,"节次多选"]
[null,null,"授课班级下拉选择"]
[null,null,"人数手工录入"]
[null,null,"学分手工录入"]
[null,"2.4.班级列表页面","新增按钮：点击新增跳转至新增班级页面"]
[null,null,"修改按钮：跳转至对应班级，可对其进行修改"]
[null,null,"删除按钮：删除对应的班级"]
[null,"2.4.班级详情页面\n（可将此页与班级列表页合并）","年级根据年份生成下拉菜单","生成规则（前后几年？）"]
[null,null,"班级名称，手工录入"]
[null,null,"返回按钮：返回至班级列表页面"]
[null,null,"保存按钮：保存当前班级信息，并返回班级列表页面"]
[null,null,"删除：删除当前班级，并返回班级列表页"]
["四、值日表管理","4.1.值班人员查询页面","学年自动生成"]
[null,null,"学期为字典表设置"]
[null,null,"地点为字典表设置"]
[null,null,"新增按钮：根据所选学年、学期跳转至新增值班表页面"]
[null,null,"修改按钮：跳转至对应值班表修改页面"]
[null,null,"删除按钮：删除对应排班表"]
[null,"4.2.值班人员设置","学年：下拉选择"]
[null,null,"学期：下拉选择"]
[null,null,"标题：手工录入"]
[null,null,"地点：多选"]
[null,null,"直接点击表格选择人员，可多选多个表格，整行整列"]
[null,null,"返回按钮：返回值班表查询页面"]
[null,null,"保存按钮：保存当前值班表"]
[null,null,"删除按钮：删除当前值班表"]

{"sheet":"项目计划","index":2,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[8,0,21,0],[22,0,39,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[4,1,4,4],[4,6,4,10],[5,0,5,10],[6,6,6,7],[6,8,6,9],[6,0,7,0],[6,4,7,4],[6,5,7,5],[6,10,7,10],[0,0,0,10],[1,0,1,10],[2,1,2,4],[2,6,2,10],[3,1,3,4],[3,6,3,10]]}
["高校实验室标准化管理平台项目管理进度表"]
[" 一、项目基本情况  I. Project Basic Info"]
[" 项目名称 project name：","高校实验室标准化管理平台",null,null,null,"项目编号 project code："]
[" 制作人 prepared by：","臧锴",null,null,null," 审核人 reviewed by："]
[" 项目经理 project manager：王忠元","臧锴",null,null,null," 制作日期 data：","2020-11-23"]
[" 二、项目进度表  II. Project Schedule"]
["阶段","序号","类型","内容","责任人","输出","计划开始时间",null,"实际开始时间",null,"状态"]
[{"$nulls":6},"开始日期","结束日期","开始日期","结束日期"]
["产品设计阶段",1,"数据库设计","设备资产管理-设备基本信息","郑英伟","数据库模型","2020-11-24","2020-11-24","2020-11-24","2020-11-24","已完成"]
[null,2,"数据库设计","实验课程安排-课程信息","臧锴","数据库模型","2020-11-17","2020-11-17","2020-11-17","2020-11-17","已完成"]
[null,3,"数据库设计","班级管理-班级信息","臧锴","数据库模型","2020-11-19","2020-11-19","2020-11-19","2020-11-19","已完成"]
[null,4,"数据库设计","员工管理-人员信息","郑英伟","数据库模型","2020-11-25","2020-11-26","2020-11-30","2020-11-30","已完成"]
[null,5,"数据库设计","值班表管理-值班表信息","臧锴","数据库模型","2020-11-20","2020-11-20","2020-11-20","2020-11-20","已完成"]
[null,6,"数据库设计","实验室基础设置-实验室基本信息","郑英伟","数据库模型","2020-11-25","2020-11-25","2020-11-27","2020-11-27","已完成"]
[null,7,"数据库设计","系统设置-字典表","郑英伟","数据库模型","2020-11-26","2020-11-27","2020-11-30","2020-11-30","已完成"]
[null,8,"数据库设计","账号管理-账号信息表","郑英伟","数据库模型","2020-11-27","2020-11-27","2020-11-30","2020-11-30","已完成"]
[null,9,"数据库设计","账号管理-角色信息表","郑英伟","数据库模型","2020-11-26","2020-11-27","2020-11-30","2020-11-30","已完成"]
[null,10,"数据库设计","账号管理-权限信息表","郑英伟","数据库模型","2020-11-28","2020-11-30","2020-11-30","2020-11-30","已完成"]
[null,11,"数据库设计","组织结构管理-组织机构信息表","郑英伟","数据库模型","2020-11-27","2020-11-30","2020-11-30","2020-11-30","已完成"]
[null,12,"数据库设计","信息发布-信息表","臧锴","数据库模型","2020-11-23","2020-11-23","2020-11-23","2020-11-23","已完成"]
[null,13,"原型设计","课程安排原型设计","臧锴","原型图","2020-11-18","2020-11-18","2020-11-18","2020-11-18","已完成"]
[null,14,"原型设计","值班表原型图设计","臧锴","原型图","2020-11-23","2020-11-23","2020-11-23","2020-11-23","已完成"]
["开发阶段",15,"后端开发","设备资产管理","郑英伟","可用的程序","2020-11-25","2020-11-26","2020-11-25","2020-11-30","已完成"]
[null,16,"前端开发","设备资产管理","郑英伟","可用的程序","2020-11-27","2020-11-28","2020-11-25","2020-11-30","已完成"]
[null,17,"后端开发","实验课程安排","杜勃成、臧锴","可用的程序","2020-11-24","2020-11-25",null,null,"开发中"]
[null,18,"前端开发","实验课程安排","杜勃成、臧锴","可用的程序","2020-11-25","2020-11-27",null,null,"开发中"]
[null,19,"后端开发","班级管理","杜勃成、臧锴","可用的程序","2020-11-25","2020-11-27","2020-11-27","2020-12-01","已完成"]
[null,20,"前端开发","班级管理","杜勃成、臧锴","可用的程序","2020-11-28","2020-11-30","2020-11-27","2020-12-01","已完成"]
[null,21,"后端开发","人员管理","郑英伟","可用的程序","2020-11-27","2020-11-30","2020-12-03","2020-12-03","已完成"]
[null,22,"前端开发","人员管理","郑英伟","可用的程序","2020-11-27","2020-11-30","2020-12-03","2020-12-03","已完成"]
[null,23,"后端开发","值班表管理","杜勃成、臧锴","可用的程序","2020-11-26","2020-11-26",null,null,"开发中"]
[null,24,"前端开发","值班表管理","杜勃成、臧锴","可用的程序","2020-11-26","2020-11-26",null,null,"开发中"]
[null,25,"后端开发","实验室基础设置","郑英伟","可用的程序","2020-12-01","2020-12-03","2020-11-27","2020-12-03","开发中"]
[null,26,"前端开发","实验室基础设置","郑英伟","可用的程序","2020-12-01","2020-12-03","2020-11-27","2020-12-03","开发中"]
[null,27,"后端开发","系统设置","郑英伟","可用的程序","2020-12-03","2020-12-04","2020-11-27","2020-11-27","已完成"]
[null,28,"前端开发","系统设置","郑英伟","可用的程序","2020-12-03","2020-12-04","2020-11-27","2020-11-27","已完成"]
[null,29,"后端开发","组织机构管理","郑英伟","可用的程序","2020-12-07","2020-12-08","2020-11-27","2020-11-27","已完成"]
[null,30,"前端开发","组织机构管理","郑英伟","可用的程序","2020-12-08","2020-12-09","2020-11-27","2020-11-27","已完成"]
[null,31,"后端开发","信息发布","杜勃成、臧锴","可用的程序","2020-12-01","2020-12-02","2020-11-27","2020-12-01","已完成"]
[null,32,"前端开发","信息发布","杜勃成、臧锴","可用的程序","2020-12-03","2020-12-04","2020-11-27","2020-12-01","已完成"]
[]
[null,"       "]