{"text_format":"3","workbook":"xls","n_sheets":5,"sheets":["2021-2022-2汇总","2021级课程教学津贴","2019级导师津贴","2020级导师津贴","2021级导师津贴"],"not_rendered":{"external_links":1,"defined_names":3},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"2021-2022-2汇总","index":0,"n_rows":6,"n_cols":8,"rows_kept":6,"merged":[[0,0,0,7],[5,3,5,6],[6,0,6,7]],"flags":["formulas_cached_only"]}
["2021-2022学年第2学期研究生教学津贴发放汇总表"]
["序号","学院","21级第1学期课酬/工作量","19级指导教师津贴/工作量","20级指导教师津贴/工作量","21级指导教师津贴/工作量","总计（元）","备注"]
["课酬汇总","XXX学院",14216.25,0,0,0,14216.25]
["工作量汇总","XXX学院",288,0,0,0,288]
[null,"总计"]
["制表"]

{"sheet":"2021级课程教学津贴","index":1,"n_rows":13,"n_cols":8,"rows_kept":13,"merged":[[0,0,0,7],[10,0,10,3],[11,0,11,3],[12,0,13,7]],"flags":["formulas_cached_only"]}
["      学院2021-2022学年度第2学期2021级研究生课程任课教师教学津贴申报表"]
["序号","课程名称","任课教师","职 称","总学时","选课学生人数","课酬（元）","备 注"]
[1,null,null,"教授",36,1,0]
[{"$nulls":3},"教授",36,2,0]
[{"$nulls":3},"教授",36,121,4496.25]
[{"$nulls":3},"副教授",36,4,1800]
[{"$nulls":3},"研究员",36,5,1980]
[{"$nulls":3},"教授",36,6,1980]
[{"$nulls":3},"教授",36,7,1980]
[{"$nulls":3},"教授",36,8,1980]
["课酬合计（元）",{"$nulls":5},14216.25]
["课酬工作量合计（小时）",{"$nulls":5},288]
["注：课酬计算公式：（设班级人数为R）\nR ≤ 40: 40或50或55（元）× 课时数；41 ≤ R≤ 60:40或50或55（元）×课时数×[6+(R-40)×0.125]÷6；\n61 ≤ R≤ 80:40或50或55（元）×课时数×8.5÷6；81≤R≤100:40或50或55（元）×课时数×[8.5+(R-80)×0.125]÷6；\n101≤R≤130：40或50或55（元）×课时数×[11+(R-100)×0.125]÷6；131≤R≤150：40或50或55（元）×课时数×[14.75+(R-130)×0.135]÷6；R≥150；40或50或55（元）×课时数×[17.5+(R-150)×0.135]÷6；\n按计财处规定扣税。                                                                                                        \n课酬标准：讲师40元/学时；副教授 50元/学时；教授  55元/学时。"]

{"sheet":"2019级导师津贴","index":2,"n_rows":19,"n_cols":7,"rows_kept":19,"merged":[[0,0,0,6],[16,0,16,3],[17,0,17,3],[18,0,18,6]],"flags":["formulas_cached_only"]}
["      学院2021-2022学年度第2学期2019级研究生导师津贴申报表"]
["序号","专业","导师姓名","学生姓名","金额(元)","休学、退学学生","备注"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
["津贴合计（元）",{"$nulls":3},0]
["津贴工作量合计（小时）",{"$nulls":3},0]
["备注：\n1、硕士研究生导师每指导1名硕士研究生每学期津贴为400元。\n2、博士研究生导师每指导1名博士研究生每学期津贴为800元。"]

{"sheet":"2020级导师津贴","index":3,"n_rows":19,"n_cols":7,"rows_kept":19,"merged":[[0,0,0,6],[16,0,16,3],[17,0,17,3],[18,0,18,6]],"flags":["formulas_cached_only"]}
["      学院2021-2022学年度第2学期2020级研究生导师津贴申报表"]
["序号","专业","导师姓名","学生姓名","金额(元)","休学、退学学生","备注"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
["津贴合计（元）",{"$nulls":3},0]
["津贴工作量合计（小时）",{"$nulls":3},0]
["备注：\n1、硕士研究生导师每指导1名硕士研究生每学期津贴为400元。\n2、博士研究生导师每指导1名博士研究生每学期津贴为800元。"]

{"sheet":"2021级导师津贴","index":4,"n_rows":19,"n_cols":7,"rows_kept":19,"merged":[[0,0,0,6],[16,0,16,3],[17,0,17,3],[18,0,18,6]],"flags":["formulas_cached_only"]}
["      学院2021-2022学年度第2学期2021级研究生导师津贴申报表"]
["序号","专业","导师姓名","学生姓名","金额(元)","休学、退学学生","备注"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
["津贴合计（元）",{"$nulls":3},0]
["津贴工作量合计（小时）",{"$nulls":3},0]
["备注：\n1、硕士研究生导师每指导1名硕士研究生每学期津贴为400元。\n2、博士研究生导师每指导1名博士研究生每学期津贴为800元。"]