{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["表一  工作量总表","表二 理论课明细","表三 实验课时明细表","表四 实践课时明细表","表五 理论课时分配","表六 实验课时分配","表七 实践课标时分配表","其他说明"],"not_rendered":{"defined_names":7,"comments":4},"read":"whole","date_system":"1900"}

{"sheet":"表一  工作量总表","index":0,"n_rows":65,"n_cols":13,"rows_kept":65,"merged":[[0,0,0,12]]}
["表一    2023年下半年教师教学工作量统计总表"]
["序号","课时上报单位号","工作单位","教师姓名","一卡通号码","在职类别","职称","理论学时数","实验学时数","实践学时数\n（含专业见习/专业实习与实践等）","认知实习学时数","本年度下半年总课时数","备注"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]

{"sheet":"表二 理论课明细","index":1,"n_rows":58,"n_cols":25,"rows_kept":58,"merged":[[1,0,2,0],[1,1,2,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,1,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]]}
[null,"表二  2023-2024学年第1学期理论课时表"]
["序号","课程代码","课程名称","讲课教师","上课班级","总学分","总学时","理论课堂学时","理论课学分","指导学生自主学习学时","理论课总学时","理论课验算值","人数","合班系数","课程系数","过程考核次数","其中",null,"过程考核系数","质量调节系数Q","修正值1","修正值2","理论课程总标时","实际选课学生数","其他"]
[{"$nulls":16},"测验等","论文等"]
[1,{"$nulls":9},{"$f":"H4+J4","v":0},{"$f":"I4*16-K4","v":0},{"$nulls":6},{"$f":"Q4*0.03+R4*0.05+1","v":1},1,0,{"v":1,"d":"1.0"},{"$f":"K4*N4*O4*S4*T4*V4+U4","v":0}]
[2,{"$nulls":9},{"$f":"H5+J5","v":0},{"$f":"I5*16-K5","v":0},{"$nulls":6},{"$f":"Q5*0.03+R5*0.05+1","v":1},1,0,{"v":1,"d":"1.0"},{"$f":"K5*N5*O5*S5*T5*V5+U5","v":0}]
[3,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[4,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[5,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[6,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[7,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[8,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[9,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[10,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[11,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[12,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[13,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[14,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[15,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[16,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[17,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[18,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[19,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[20,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[21,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[22,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[23,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[24,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[25,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[26,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[27,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[28,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[29,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[30,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[31,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[32,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[33,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[34,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[35,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[36,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[37,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[38,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[39,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[40,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[41,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[42,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[43,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[44,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[45,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[46,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[47,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[48,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[49,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[50,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[51,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[52,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[53,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[54,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]
[55,{"$nulls":9},0,0,{"$nulls":6},1,1,0,{"v":1,"d":"1.0"},0]

{"sheet":"表三 实验课时明细表","index":2,"n_rows":64,"n_cols":20,"rows_kept":64,"merged":[[1,0,2,0],[1,1,2,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]]}
[null,"表三  2023-2024学年第1学期实验课时表"]
["序号","课程代码","课程名称","实验教师","上课班级","实验学时","本实验总学分","验算值","演示实验对应学时","验证性实验对应学时","综合实验对应学时","创新性实验对应学时","实验类型系数T","质量系数Q","学生人数","修正值1","修正值2","实验课标时","起止周","备注"]
[]
[1,{"$nulls":6},{"$f":"F4-I4-J4-K4-L4","v":0},{"$nulls":7},0,1,{"$f":"ROUND((I4*0.8+J4*1+K4*1.2+L4*1.3)*M4*Q4+P4,1)*N4","v":{"v":0,"d":"0.0"}}]
[2,{"$nulls":6},{"$f":"F5-I5-J5-K5-L5","v":0},{"$nulls":7},0,1,{"$f":"ROUND((I5*0.8+J5*1+K5*1.2+L5*1.3)*M5*Q5+P5,1)*N5","v":{"v":0,"d":"0.0"}}]
[3,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[4,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[5,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[6,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[7,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[8,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[9,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[10,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[11,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[12,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[13,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[14,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[15,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[16,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[17,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[18,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[19,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[20,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[21,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[22,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[23,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[24,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[25,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[26,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[27,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[28,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[29,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[30,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[31,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[32,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[33,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[34,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[35,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[36,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[37,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[38,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[39,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[40,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[41,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[42,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[43,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[44,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[45,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[46,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[47,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[48,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[49,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[50,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[51,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[52,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[53,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[54,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[55,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[56,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[57,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[58,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[59,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[60,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]
[61,{"$nulls":6},0,{"$nulls":7},0,1,{"v":0,"d":"0.0"}]

{"sheet":"表四 实践课时明细表","index":3,"n_rows":45,"n_cols":15,"rows_kept":45}
[null,"表四：实践课时明细"]
["序号","课程代码","课程名称","授课教师","上课班级","人数","计划周数","学生数1","学生数1对应系数K1","学生数2","学生数2对应系数K2","类型调节系数T","质量系数Q","实践标时","起止周"]
[1,{"$nulls":12},{"$f":"G3*(H3*I3+J3*K3)*L3*M3","v":0}]
[2,{"$nulls":12},{"$f":"G4*(H4*I4+J4*K4)*L4*M4","v":0}]
[3,{"$nulls":12},0]
[4,{"$nulls":12},0]
[5,{"$nulls":12},0]
[6,{"$nulls":12},0]
[7,{"$nulls":12},0]
[8,{"$nulls":12},0]
[9,{"$nulls":12},0]
[10,{"$nulls":12},0]
[11,{"$nulls":12},0]
[12,{"$nulls":12},0]
[13,{"$nulls":12},0]
[14,{"$nulls":12},0]
[15,{"$nulls":12},0]
[16,{"$nulls":12},0]
[17,{"$nulls":12},0]
[18,{"$nulls":12},0]
[19,{"$nulls":12},0]
[20,{"$nulls":12},0]
[21,{"$nulls":12},0]
[22,{"$nulls":12},0]
[23,{"$nulls":12},0]
[24,{"$nulls":12},0]
[25,{"$nulls":12},0]
[26,{"$nulls":12},0]
[27,{"$nulls":12},0]
[28,{"$nulls":12},0]
[29,{"$nulls":12},0]
[30,{"$nulls":12},0]
[31,{"$nulls":12},0]
[32,{"$nulls":12},0]
[33,{"$nulls":12},0]
[34,{"$nulls":12},0]
[35,{"$nulls":12},0]
[36,{"$nulls":12},0]
[37,{"$nulls":12},0]
[38,{"$nulls":12},0]
[39,{"$nulls":12},0]
[40,{"$nulls":12},0]
[41,{"$nulls":12},0]
[42,{"$nulls":12},{"$f":"G44*(H44*I44+J44*K44)*L44","v":0}]
[43,{"$nulls":12},0]

{"sheet":"表五 理论课时分配","index":4,"n_rows":2,"n_cols":6,"rows_kept":2,"merged":[[0,0,0,5],[2,0,3,0],[2,1,3,1],[2,2,3,2],[4,0,5,0],[4,1,5,1],[4,2,5,2],[6,0,7,0],[6,1,7,1],[6,2,7,2],[8,0,12,0],[8,1,12,1],[8,2,12,2]]}
["表五：理论课标时分配（非校内请备注）"]
["课程序号","课程名称","表二计算后总学时","教师姓名","一卡通号码","对应学时"]

{"sheet":"表六 实验课时分配","index":5,"n_rows":2,"n_cols":7,"rows_kept":2,"merged":[[0,0,0,6],[2,0,3,0],[2,1,3,1],[2,2,3,2],[4,0,5,0],[4,1,5,1],[4,2,5,2],[6,0,7,0],[6,1,7,1],[6,2,7,2],[48,0,48,3]]}
["表六：实验课标时分配（非校内请备注）"]
["课程序号","课程名称","表二计算后\n总学时","教师姓名","一卡通号码","对应学时","备注"]

{"sheet":"表七 实践课标时分配表","index":6,"n_rows":2,"n_cols":7,"rows_kept":2,"merged":[[0,0,0,6],[2,0,19,0],[2,1,19,1],[2,2,19,2],[20,0,39,0],[20,1,39,1],[20,2,39,2],[40,0,59,0],[40,1,59,1],[40,2,59,2]]}
["表七：实践课标时分配（非校内请备注）"]
["课程序号","课程名称","表四计算后总学时","教师姓名","一卡通号码","对应学时","备注"]

{"sheet":"其他说明","index":7,"n_rows":0,"n_cols":0,"rows_kept":0}