{"text_format":"3","workbook":"xls","n_sheets":7,"sheets":["汇总","马克思主义学院学院 ","外国语学院","数计学院","计通学院 ","交通学院","物电学院"],"not_rendered":{"external_links":1,"defined_names":4},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"汇总","index":0,"n_rows":17,"n_cols":9,"rows_kept":17,"merged":[[0,0,0,8]],"flags":["formulas_cached_only"]}
["2014年“外学院为本院”“本院为外院”开课人数统计"]
["序号","学院","马克思主义学院","外国语学院","数计学院","计通学院","交通运输学院","物电学院","外院为本院开课折合人数"]
[1,"交通运输工程学院",30.4375,39.9375,30.8125,null,null,0.2813,101.4688]
[2,"土木与建筑工程学院",{"v":26.015625,"d":"26.0156"},{"v":30.65625,"d":"30.6563"},{"v":54.203125,"d":"54.2031"},null,{"v":0.5,"d":"0.5000"},null,{"v":111.375,"d":"111.3750"}]
[3,"汽车与机械工程学院",7.8125,10.3125,{"v":15.5,"d":"15.5000"},2.0625,{"v":0.46875,"d":"0.4688"},{"v":1.21875,"d":"1.2188"},{"v":37.375,"d":"37.3750"}]
[4,"水利工程学院",{"v":11,"d":"11.0000"},{"v":13.125,"d":"13.1250"},{"v":25.125,"d":"25.1250"},{"v":2.53125,"d":"2.5313"},null,null,{"v":51.78125,"d":"51.7813"}]
[5,"电气与信息工程学院",{"v":19.5,"d":"19.5000"},{"v":24.84375,"d":"24.8438"},{"v":17.578125,"d":"17.5781"},null,0.1875,null,{"v":62.109375,"d":"62.1094"}]
[6,"能源与动力工程学院",{"v":5.203125,"d":"5.2031"},{"v":7.125,"d":"7.1250"},{"v":10.640625,"d":"10.6406"},{"$nulls":3},{"v":22.96875,"d":"22.9688"}]
[7,"经济与管理学院",32.5625,39.1875,{"v":0.28125,"d":"0.2813"},{"$nulls":3},{"v":72.03125,"d":"72.0313"}]
[8,"计算机与通信工程学院",{"v":7.5,"d":"7.5000"},9.9375,{"v":6.375,"d":"6.3750"},{"$nulls":3},23.8125]
[9,"化学与生物工程学院",{"v":7.546875,"d":"7.5469"},10.3125,{"v":3.46875,"d":"3.4688"},{"$nulls":3},{"v":21.328125,"d":"21.3281"}]
[10,"数学与计算科学学院",{"v":4.453125,"d":"4.4531"},{"v":6.09375,"d":"6.0938"},{"v":0,"d":"0.0000"},{"$nulls":3},{"v":10.546875,"d":"10.5469"}]
[11,"物理与电子科学学院",{"v":3.890625,"d":"3.8906"},{"v":5.625,"d":"5.6250"},{"v":4.359375,"d":"4.3594"},{"$nulls":3},{"v":13.875,"d":"13.8750"}]
[12,"马克思主义学院",{"v":0,"d":"0.0000"},8.4375,{"v":0,"d":"0.0000"},{"$nulls":3},8.4375]
[13,"外国语学院",{"v":7.03125,"d":"7.0313"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"$nulls":3},{"v":7.03125,"d":"7.0313"}]
[14,"文法学院",{"v":3.703125,"d":"3.7031"},{"v":4.78125,"d":"4.7813"},{"v":0,"d":"0.0000"},{"$nulls":3},{"v":8.484375,"d":"8.4844"}]
[14,"本院为外院开课折合人数",{"v":166.65625,"d":"166.6563"},{"v":210.375,"d":"210.3750"},{"v":168.34375,"d":"168.3438"},{"v":4.59375,"d":"4.5938"},{"v":1.15625,"d":"1.1563"},{"v":1.5000499999999999,"d":"1.5001"},{"v":552.62505,"d":"552.6251"}]

{"sheet":"马克思主义学院学院 ","index":1,"n_rows":18,"n_cols":9,"rows_kept":18,"merged":[[0,0,0,8],[17,0,17,8]],"flags":["formulas_cached_only"]}
["2014年马克思主义学院研究生公共课开课人数统计"]
["序号","学院","自然辩证法或马克思主义方法论（14级，1学分）","折算人数","中国特色社会主义（13级，2学分）","折算人数","中国马克思主义当代（博14级，2学分）","折算人数","折合人数"]
[1,"交通运输工程学院",200,{"v":9.375,"d":"9.3750"},190,17.8125,13,{"v":3.25,"d":"3.2500"},30.4375]
[2,"土木与建筑工程学院",167,{"v":7.828125,"d":"7.8281"},162,15.1875,12,{"v":3,"d":"3.0000"},{"v":26.015625,"d":"26.0156"}]
[3,"汽车与机械工程学院",52,2.4375,52,{"v":4.875,"d":"4.8750"},2,{"v":0.5,"d":"0.5000"},7.8125]
[4,"水利工程学院",74,{"v":3.46875,"d":"3.4688"},67,{"v":6.28125,"d":"6.2813"},5,{"v":1.25,"d":"1.2500"},{"v":11,"d":"11.0000"}]
[5,"电气与信息工程学院",128,{"v":6,"d":"6.0000"},144,{"v":13.5,"d":"13.5000"},0,{"v":0,"d":"0.0000"},{"v":19.5,"d":"19.5000"}]
[6,"能源与动力工程学院",41,{"v":1.921875,"d":"1.9219"},35,{"v":3.28125,"d":"3.2813"},0,{"v":0,"d":"0.0000"},{"v":5.203125,"d":"5.2031"}]
[7,"经济与管理学院",220,10.3125,216,{"v":20.25,"d":"20.2500"},8,{"v":2,"d":"2.0000"},32.5625]
[8,"计算机与通信工程学院",52,2.4375,54,5.0625,0,{"v":0,"d":"0.0000"},{"v":7.5,"d":"7.5000"}]
[9,"化学与生物工程学院",57,{"v":2.671875,"d":"2.6719"},52,{"v":4.875,"d":"4.8750"},0,{"v":0,"d":"0.0000"},{"v":7.546875,"d":"7.5469"}]
[10,"数学与计算科学学院",35,{"v":1.640625,"d":"1.6406"},30,2.8125,0,{"v":0,"d":"0.0000"},{"v":4.453125,"d":"4.4531"}]
[11,"物理与电子科学学院",37,{"v":1.734375,"d":"1.7344"},23,{"v":2.15625,"d":"2.1563"},0,{"v":0,"d":"0.0000"},{"v":3.890625,"d":"3.8906"}]
[12,"马克思主义学院",0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[13,"外国语学院",44,2.0625,53,{"v":4.96875,"d":"4.9688"},0,{"v":0,"d":"0.0000"},{"v":7.03125,"d":"7.0313"}]
[14,"文法学院",29,{"v":1.359375,"d":"1.3594"},25,{"v":2.34375,"d":"2.3438"},0,{"v":0,"d":"0.0000"},{"v":3.703125,"d":"3.7031"}]
[null,"共计",1136,{"v":53.25,"d":"53.2500"},1103,{"v":103.40625,"d":"103.4063"},40,{"v":10,"d":"10.0000"},{"v":166.65625,"d":"166.6563"}]
["注：根据研究生教学工作量计算办法。\n折算人数=选课人数*课程学分*系数，其中博士系数=2/16.硕士系数=1.5/32"]

{"sheet":"外国语学院","index":2,"n_rows":19,"n_cols":9,"rows_kept":19,"merged":[[0,0,0,6],[1,0,2,0],[1,1,2,1],[1,2,1,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[18,0,18,8]],"flags":["formulas_cached_only"]}
["2014年外国语学院研究生公共课开课人数统计"]
["序号","学院","硕士英语",{"$nulls":3},"14级博士英语\n（3学分）","折算人数","折合人数"]
[null,null,"14级研究生\n（2学分)","折算人数","13级研究生\n(2学分","折算人数"]
[1,"交通运输工程学院",200,{"v":18.75,"d":"18.7500"},190,17.8125,9,{"v":3.375,"d":"3.3750"},39.9375]
[2,"土木与建筑工程学院",165,{"v":15.46875,"d":"15.4688"},162,15.1875,0,{"v":0,"d":"0.0000"},{"v":30.65625,"d":"30.6563"}]
[3,"汽车与机械工程学院",50,4.6875,52,{"v":4.875,"d":"4.8750"},2,{"v":0.75,"d":"0.7500"},10.3125]
[4,"水利工程学院",74,6.9375,66,6.1875,0,{"v":0,"d":"0.0000"},{"v":13.125,"d":"13.1250"}]
[5,"电气与信息工程学院",124,{"v":11.625,"d":"11.6250"},141,{"v":13.21875,"d":"13.2188"},0,{"v":0,"d":"0.0000"},{"v":24.84375,"d":"24.8438"}]
[6,"能源与动力工程学院",41,{"v":3.84375,"d":"3.8438"},35,{"v":3.28125,"d":"3.2813"},0,{"v":0,"d":"0.0000"},{"v":7.125,"d":"7.1250"}]
[7,"经济与管理学院",214,20.0625,204,{"v":19.125,"d":"19.1250"},0,{"v":0,"d":"0.0000"},39.1875]
[8,"计算机与通信工程学院",53,{"v":4.96875,"d":"4.9688"},53,{"v":4.96875,"d":"4.9688"},0,{"v":0,"d":"0.0000"},9.9375]
[9,"化学与生物工程学院",58,5.4375,52,{"v":4.875,"d":"4.8750"},0,{"v":0,"d":"0.0000"},10.3125]
[10,"数学与计算科学学院",35,{"v":3.28125,"d":"3.2813"},30,2.8125,0,{"v":0,"d":"0.0000"},{"v":6.09375,"d":"6.0938"}]
[11,"物理与电子科学学院",37,{"v":3.46875,"d":"3.4688"},23,{"v":2.15625,"d":"2.1563"},0,{"v":0,"d":"0.0000"},{"v":5.625,"d":"5.6250"}]
[12,"马克思主义学院",46,4.3125,44,{"v":4.125,"d":"4.1250"},0,{"v":0,"d":"0.0000"},8.4375]
[13,"外国语学院",0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[14,"文法学院",29,{"v":2.71875,"d":"2.7188"},22,2.0625,0,{"v":0,"d":"0.0000"},{"v":4.78125,"d":"4.7813"}]
[null,"共计",1126,105.5625,1074,100.6875,11,{"v":4.125,"d":"4.1250"},{"v":210.375,"d":"210.3750"}]
["注：根据研究生教学工作量计算办法。\n折算人数=选课人数*课程学分*系数，其中博士系数=2/16.硕士系数=1.5/32"]

{"sheet":"数计学院","index":3,"n_rows":19,"n_cols":21,"rows_kept":19,"merged":[[0,0,0,20],[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],[1,20,2,20],[18,0,18,20]],"flags":["formulas_cached_only"]}
["2014年数计学院研究生公共课开课人数统计"]
["序号","学院","矩阵论\n（3学分）","折算人数","数理统计\n（2学分）","折算人数","数值分析\n（3学分）","折算人数","最优化方法\n（2学分）","折算人数","数理方程\n（2学分）","折算人数","随机过程\n（2学分）","折算人数","模糊数学\n（2学分）","折算人数","随机过程\n（博士2学分）","折算人数","非线性方程\n数值方法(12级，3学分） ","折算人数","折合人数"]
[]
[1,"交通运输工程学院",76,10.6875,54,5.0625,80,{"v":11.25,"d":"11.2500"},28,{"v":2.625,"d":"2.6250"},0,{"v":0,"d":"0.0000"},10,0.9375,0,{"v":0,"d":"0.0000"},1,{"v":0.25,"d":"0.2500"},0,{"v":0,"d":"0.0000"},30.8125]
[2,"土木与建筑工程学院",158,{"v":22.21875,"d":"22.2188"},35,{"v":3.28125,"d":"3.2813"},163,{"v":22.921875,"d":"22.9219"},0,{"v":0,"d":"0.0000"},59,{"v":5.53125,"d":"5.5313"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},1,{"v":0.25,"d":"0.2500"},0,{"v":0,"d":"0.0000"},{"v":54.203125,"d":"54.2031"}]
[3,"汽车与机械工程学院",46,{"v":6.46875,"d":"6.4688"},13,{"v":1.21875,"d":"1.2188"},44,6.1875,10,0.9375,2,0.1875,0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},2,{"v":0.5,"d":"0.5000"},0,{"v":0,"d":"0.0000"},{"v":15.5,"d":"15.5000"}]
[4,"水利工程学院",55,{"v":7.734375,"d":"7.7344"},49,{"v":4.59375,"d":"4.5938"},45,{"v":6.328125,"d":"6.3281"},10,0.9375,38,3.5625,0,{"v":0,"d":"0.0000"},13,{"v":1.21875,"d":"1.2188"},3,{"v":0.75,"d":"0.7500"},0,{"v":0,"d":"0.0000"},{"v":25.125,"d":"25.1250"}]
[5,"电气与信息工程学院",125,{"v":17.578125,"d":"17.5781"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},null,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},{"v":17.578125,"d":"17.5781"}]
[6,"能源与动力工程学院",25,{"v":3.515625,"d":"3.5156"},8,{"v":0.75,"d":"0.7500"},30,{"v":4.21875,"d":"4.2188"},11,{"v":1.03125,"d":"1.0313"},4,{"v":0.375,"d":"0.3750"},1,{"v":0.09375,"d":"0.0938"},7,{"v":0.65625,"d":"0.6563"},null,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},{"v":10.640625,"d":"10.6406"}]
[7,"经济与管理学院",0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},3,{"v":0.28125,"d":"0.2813"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},null,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},{"v":0.28125,"d":"0.2813"}]
[8,"计算机与通信工程学院",26,{"v":3.65625,"d":"3.6563"},13,{"v":1.21875,"d":"1.2188"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},16,{"v":1.5,"d":"1.5000"},0,{"v":0,"d":"0.0000"},null,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},{"v":6.375,"d":"6.3750"}]
[9,"化学与生物工程学院",2,{"v":0.28125,"d":"0.2813"},34,3.1875,0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},null,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},{"v":3.46875,"d":"3.4688"}]
[10,"数学与计算科学学院",0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},null,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[11,"物理与电子科学学院",28,3.9375,0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},null,{"v":0,"d":"0.0000"},3,{"v":0.421875,"d":"0.4219"},{"v":4.359375,"d":"4.3594"}]
[12,"马克思主义学院",0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},null,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[13,"外国语学院",0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},null,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[14,"文法学院",0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},null,{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"共计",{"v":541,"d":"541.0000"},{"v":76.078125,"d":"76.0781"},{"v":206,"d":"206.0000"},19.3125,{"v":362,"d":"362.0000"},{"v":50.90625,"d":"50.9063"},{"v":62,"d":"62.0000"},5.8125,{"v":103,"d":"103.0000"},{"v":9.65625,"d":"9.6563"},{"v":27,"d":"27.0000"},{"v":2.53125,"d":"2.5313"},{"v":20,"d":"20.0000"},{"v":1.875,"d":"1.8750"},{"v":7,"d":"7.0000"},{"v":1.75,"d":"1.7500"},{"v":3,"d":"3.0000"},{"v":0.421875,"d":"0.4219"},{"v":168.34375,"d":"168.3438"}]
["注：根据研究生教学工作量计算办法。\n折算人数=选课人数*课程学分*系数，其中博士系数=2/16.硕士系数=1.5/32"]

{"sheet":"计通学院 ","index":4,"n_rows":18,"n_cols":7,"rows_kept":18,"merged":[[0,0,0,6],[17,0,17,6]],"flags":["formulas_cached_only"]}
["2014年计通学院研究生公共课开课人数统计"]
["序号","学院","神经网络与软计算（13级，2学分）","折算人数","小波分析（13级，2学分）","折算人数","折合人数"]
[1,"交通运输工程学院"]
[2,"土木与建筑工程学院"]
[3,"汽车与机械工程学院",10,0.9375,12,{"v":1.125,"d":"1.1250"},2.0625]
[4,"水利工程学院",12,{"v":1.125,"d":"1.1250"},15,{"v":1.40625,"d":"1.4063"},{"v":2.53125,"d":"2.5313"}]
[5,"电气与信息工程学院"]
[6,"能源与动力工程学院"]
[7,"经济与管理学院"]
[8,"计算机与通信工程学院"]
[9,"化学与生物工程学院"]
[10,"数学与计算科学学院"]
[11,"物理与电子科学学院"]
[12,"马克思主义学院"]
[13,"外国语学院"]
[14,"文法学院"]
[null,"共计",22,2.0625,{"v":24.0625,"d":"24"},{"v":2.53125,"d":"2.5313"},{"v":4.59375,"d":"4.5938"}]
["注：根据研究生教学工作量计算办法,\n折算人数=选课人数*课程学分*系数，其中博士系数=2/16.硕士系数=1.5/32"]

{"sheet":"交通学院","index":5,"n_rows":18,"n_cols":9,"rows_kept":18,"merged":[[0,0,0,5],[17,0,17,8]],"flags":["formulas_cached_only"]}
["2014年交通学院研究生公共课开课人数统计"]
["序号","学院","交通运输\n工程学（14级，2学分）","折合人数","工程经济理论（14级博士,2学分 ）","折合人数","工程项目\n管理学（14级博士，2学分 ）","折合人数","折合人数"]
[1,"交通运输工程学院"]
[2,"土木与建筑工程学院",null,null,1,{"v":0.25,"d":"0.2500"},1,{"v":0.25,"d":"0.2500"},{"v":0.5,"d":"0.5000"}]
[3,"汽车与机械工程学院",5,{"v":0.46875,"d":"0.4688"},{"$nulls":4},{"v":0.46875,"d":"0.4688"}]
[4,"水利工程学院"]
[5,"电气与信息工程学院",2,0.1875,{"$nulls":4},0.1875]
[6,"能源与动力工程学院"]
[7,"经济与管理学院"]
[8,"计算机与通信工程学院"]
[9,"化学与生物工程学院"]
[10,"数学与计算科学学院"]
[11,"物理与电子科学学院"]
[12,"马克思主义学院"]
[13,"外国语学院"]
[14,"文法学院"]
[null,"共计",7,{"v":0.65625,"d":"0.6563"},1,{"v":0.25,"d":"0.2500"},1,{"v":0.25,"d":"0.2500"},{"v":1.15625,"d":"1.1563"}]
["注：根据研究生教学工作量计算办法,\n折算人数=选课人数*课程学分*系数，其中博士系数=2/16.硕士系数=1.5/32"]

{"sheet":"物电学院","index":6,"n_rows":18,"n_cols":11,"rows_kept":18,"merged":[[0,0,0,6],[17,0,17,10]],"flags":["formulas_cached_only"]}
["2014年物电学院研究生公共课开课人数统计"]
["序号","学院","材料制备与加工技术(13级，2学分）","折算人数","固体物理(13级，2学分）","折算人数","复合材料（13级，2学分）","折算人数","材料现代研究方法(14级，3学分）","折算人数","折合人数（合计）"]
[1,"交通运输工程学院",{"$nulls":4},3,{"v":0.28125,"d":"0.2813"},null,null,0.2813]
[2,"土木与建筑工程学院"]
[3,"汽车与机械工程学院",4,{"v":0.375,"d":"0.3750"},4,{"v":0.375,"d":"0.3750"},null,null,5,{"v":0.46875,"d":"0.4688"},{"v":1.21875,"d":"1.2188"}]
[4,"水利工程学院"]
[5,"电气与信息工程学院"]
[6,"能源与动力工程学院"]
[7,"经济与管理学院"]
[8,"计算机与通信工程学院"]
[9,"化学与生物工程学院"]
[10,"数学与计算科学学院"]
[11,"物理与电子科学学院"]
[12,"马克思主义学院"]
[13,"外国语学院"]
[14,"文法学院"]
[null,"共计",4,{"v":0.375,"d":"0.3750"},4,{"v":0.375,"d":"0.3750"},3,{"v":0.28125,"d":"0.2813"},5,{"v":0.46875,"d":"0.4688"},{"v":1.5000499999999999,"d":"1.5001"}]
["注：根据研究生教学工作量计算办法,\n折算人数=选课人数*课程学分*系数，其中博士系数=2/16.硕士系数=1.5/32"]