{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["原表"],"read":"whole","date_system":"1900"}

{"sheet":"原表","index":0,"n_rows":9,"n_cols":74,"rows_kept":9,"merged":[[0,0,0,73],[1,0,1,15],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,8,2,15],[2,16,2,25],[2,26,2,32],[2,33,2,40],[2,41,2,46],[2,47,2,50],[2,51,2,56],[2,57,2,59],[2,60,2,65],[2,66,2,67],[2,68,2,71],[2,72,3,72],[2,73,3,73],[4,0,7,0],[4,1,7,1],[4,2,7,2],[4,3,7,3],[4,4,7,4],[4,5,7,5],[4,6,7,6],[4,7,7,7],[4,15,7,15],[4,25,7,25],[4,32,7,32],[4,40,7,40],[4,46,7,46],[4,47,7,47],[4,48,7,48],[4,49,7,49],[4,50,7,50],[4,56,7,56],[4,59,7,59],[4,65,7,65],[4,66,7,66],[4,67,7,67],[4,68,7,68],[4,69,7,69],[4,70,7,70],[4,71,7,71],[4,72,7,72],[4,73,7,73],[8,0,8,2],[8,8,8,15],[8,16,8,25],[8,26,8,32],[8,33,8,40],[8,41,8,46],[8,47,8,50],[8,51,8,56],[8,57,8,59],[8,60,8,65],[8,66,8,67],[8,68,8,72]]}
["生科院20  -20  学年第    学期本科教学工作量登记表"]
["时间：20  年     月     日"]
["教师姓名","性别","工号","出生年月","参加工作时间","职称","岗位级别","任现职时间","通识教育必修课",{"$nulls":7},"专业必修课工作量",{"$nulls":9},"专业选修课工作量（不管学生数，只计算纯讲授工作量）",{"$nulls":6},"实验课工作量（每门课程基础实验、综合实验总数不得超过总实验组数*36）",{"$nulls":7},"野外实习、专业实习、教育实习",{"$nulls":5},"指导本科生毕业论文",{"$nulls":3},"其他教学任务（网络、函授课等）",{"$nulls":5},"本科生导师",null,null,"指导大学生创新实验项目（教务处批准立项项目）",{"$nulls":5},"减免工作量",null,"本学期合计",{"$nulls":3},"总计工作量","备注"]
[{"$nulls":8},"课程名称","校区及年级","修读学生数","周学时","教学周数","课程总学时","工作量","通识教育课总工作量","课程名称","上课班级","修读学生数","课程周学时","教学周数","讲授学时","新开课增计学时","包干（辅导答疑问、考试阅卷等）","工作量","专业必修课总工作量","课程名称","上课年级","修读学生数","课程周学时","教学周数","讲授学时","专业选修课总工作量","课程名称","上课班级","组数","每组人数","周学时","教学周数","工作量","实验课总工作量","实习班级","开始时间","结束时间","实习天数","实习工作量","实习总工作量","指导学生人数","指导学生班级","学生姓名等信息","指导论文工作量","课程名称","上课班级","教学周数","周学时","工作量","其他教学总工作量","指导学生人数","指导学生班级","本科生导师工作量","项目名称","指导项目个数","项目开始时间","项目结束时间","项目工作量","指导创新实验总工作量","减免项目","工作量","公共课工作量","专业课工作量","减免工作量","其它工作量"]
[{"$nulls":8},"课程1",{"$nulls":5},{"$f":"IF(K5>60,N5*(K5-60)/20*0.1+N5,N5)","v":{"v":0,"d":"0.0"}},{"$f":"O5+O6+O7+O8","v":{"v":0,"d":"0.0"}},"课程1",{"$nulls":6},{"$f":"T5*2+V5*0.15","v":{"v":0,"d":"0.0"}},null,{"$f":"Y5+Y6+Y7+Y8","v":{"v":0,"d":"0.0"}},"课程1",{"$nulls":4},{"$f":"AD5*AE5","v":{"v":0,"d":"0.0"}},{"$f":"AF5+AF6+AF7+AF8","v":{"v":0,"d":"0.0"}},"基础实验课程名",null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"$f":"AN5+AN6+AN7+AN8","v":{"v":0,"d":"0.0"}},{"$nulls":5},{"$f":"AT5+AT6+AT7+AT8","v":{"v":0,"d":"0.0"}},{"$nulls":3},{"$f":"AT5*9","v":{"v":0,"d":"0.0"}},{"$nulls":5},{"$f":"+BD5+BD6+BD7+BD8","v":{"v":0,"d":"0.0"}},null,null,{"$f":"BF5","v":{"v":0,"d":"0.0"}},"项目1",{"$nulls":3},{"$f":"BJ5*20","v":0},{"$f":"BM5+BM6+BM7+BM8","v":0},null,null,{"$f":"P5","v":{"v":0,"d":"0.0"}},{"$f":"Z5+AG5+AO5+AU5","v":{"v":0,"d":"0.0"}},{"$f":"BP5","v":0},{"$f":"AY5+BE5+BH5+BN5","v":{"v":0,"d":"0.0"}},{"$f":"BQ5+BR5+BS5+BT5","v":{"v":0,"d":"0.0"}}]
[{"$nulls":8},"课程2",{"$nulls":5},{"$f":"N6*(K6-60)/20*0.1+N6","v":{"v":0,"d":"0.0"}},null,"课程2",{"$nulls":6},{"$f":"T6*2+V6*0.15","v":{"v":0,"d":"0.0"}},null,null,"课程2",{"$nulls":4},{"$f":"AD6*AE6","v":{"v":0,"d":"0.0"}},null,"基础实验课程名称",{"$nulls":5},{"v":0,"d":"0.0"},{"$nulls":20},"项目2",{"$nulls":3},{"$f":"BJ6*20","v":0}]
[{"$nulls":8},"课程3",{"$nulls":5},{"$f":"N7*(K7-60)/20*0.1+N7","v":{"v":0,"d":"0.0"}},null,"课程3",{"$nulls":6},{"v":0,"d":"0.0"},null,null,"课程3",{"$nulls":4},{"v":0,"d":"0.0"},null,"综合性设计性实验1",{"$nulls":26},"项目3",{"$nulls":3},0]
[{"$nulls":8},"课程4",{"$nulls":5},{"$f":"N8*(K8-60)/20*0.1+N8","v":{"v":0,"d":"0.0"}},null,"课程4",{"$nulls":6},{"v":0,"d":"0.0"},null,null,"课程4",{"$nulls":4},{"v":0,"d":"0.0"},null,"综合性设计性实验2",{"$nulls":26},"项目4",{"$nulls":3},0]
["填表说明：红色部分为必填项，黄色部分不用填写会自动计算。任课教师填写完此表后，统一发给学科组组长，经学科组组长确认后，统一发院办。",null,null,"格式：六位，例如：199001","格式：六位，例如：199001",null,null,"六位，例如：199001","备注：班级人数基数以60人计算，每增加20人，工作量计算0.1个系数。",{"$nulls":7},"备注：1、班级名称：专业缩写+年级+班号，例如2015级生物科学专业3班，班级名称为：生科1603；专业缩写：基地班为生基、技术班为生技，生态学为生态、卓越师范班为生卓。2、新开课指第一次上一门课程，新开课增计学时计算办法：讲授学时*0.15。",{"$nulls":9},"备注：按照学院规定，选修课只按教学计划学时学时计算工作量，不管教学班级人数。例如：一门选修课的计划学时是36，无论选修该课程的人数是多少，工作量就只算36.",{"$nulls":6},"备注：每门课程基础实验、综合实验总数不得超过总实验组数*36，",{"$nulls":7},"备注：按照实习相关规定填写，春季学期不填写，秋季学期填写。",{"$nulls":5},"备注：春季学期填写，秋季学期不填写，指导一个学生计9个工作量。",{"$nulls":3},"备注：以实际教学情况填写",{"$nulls":5},"指导一个学生一学期1个工作量，只计算1，2年级指导学生",null,null,"备注：指导一个创新项目1年40个工作量，一学期20个工作量。",{"$nulls":5},"备注：只计算学院以及社会兼职项目，比如院长、学科组长等，只计算最高一项减免工作量，计算办法以教务处文件为准执行。"]