{"text_format":"3","workbook":"xls","n_sheets":7,"sheets":["生科必修课成绩汇总","生技必修课成绩汇总","必修课成绩排名","资格审查","Sheet1","Sheet2","Sheet3"],"not_rendered":{"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"生科必修课成绩汇总","index":0,"n_rows":26,"n_cols":144,"rows_kept":26,"flags":["formulas_cached_only"]}
["学号","姓名","体育（1） [2]","体育2 [2]","体育3[2]","体育4 [2]","大学英语（1） [4]","学分","绩点","军事理论课 [2]","学分","绩点","专业导论(生物科学) [1]","学分","绩点","人体解剖学 [3]","学分","绩点","中国近现代史纲要 [2]","学分","绩点","形势与政策 [.3]","学分","绩点","大学生心理健康教育 [2]","学分","绩点","无机化学 [3]","学分","绩点","高等数学 [3]","学分","绩点","大学生就业指导与创业教育 [1]","学分","绩点","大学英语（2） [4]","学分","绩点","植物学 [3]","学分","绩点","动物学 [2.5]","学分","绩点","生理学 [3]","学分","绩点","思想道德修养与法律基础 [3]","学分","绩点","形势与政策 [.3]","学分","绩点","有机化学 [3]","学分","绩点","大学生就业指导与创业教育 [1]","学分","绩点","大学英语（3） [4]","学分","绩点","生物化学 [5]","学分","绩点","普通生物学实践 [2]","学分","绩点","计算机文化基础 [4]","学分","绩点","形势与政策 [.3]","学分","绩点","毛泽东思想和中国特色社会主义理论体系 [6]","学分","绩点","分析化学 [3]","学分","绩点","大学英语（4） [4]","学分","绩点","微生物学 [3]","学分","绩点","生物化学大实验 [2]","学分","绩点","微生物学实验 [1]","学分","绩点","植物生理学 [3]","学分","绩点","马克思主义基本原理概论 [3]","学分","绩点","形势与政策 [.3]","学分","绩点","遗传学 [2]","学分","绩点","分子生物学 [3]","学分","绩点","免疫学 [2]","学分","绩点","免疫学实验 [1]","学分","绩点","遗传学实验 [1]","学分","绩点","科研设计与论文指导 [2]","学分","绩点","形势与政策 [.3]","学分","绩点","生物统计学 [3]","学分","绩点","细胞生物学 [3]","学分","绩点","生态学 [2.5]","学分","绩点","分子生物学大实验 [1.5]","学分","绩点","细胞生物学实验 [1]","学分","绩点","形势与政策 [.3]","学分","绩点","总学分","总学分绩点","加权平均绩点"]
["201312200501001","吴飞",60,81,70,87,60,4,{"v":1,"d":"1.0"},79,2,2.9,92,1,4.2,60,3,{"v":1,"d":"1.0"},63,2,1.3,83,0.3,3.3,76,2,2.6,87,3,3.7,61,3,1.1,92,1,4.2,65,4,1.5,60,3,{"v":1,"d":"1.0"},61,2.5,1.1,72,3,2.2,86,3,3.6,82,0.3,3.2,66,3,1.6,74,1,2.4,91,4,4.1,70,5,{"v":2,"d":"2.0"},70,2,{"v":2,"d":"2.0"},79,4,2.9,94,0.3,4.4,62,6,1.2,60,3,{"v":1,"d":"1.0"},69,4,1.9,80,3,{"v":3,"d":"3.0"},67,2,1.7,76,1,2.6,76,3,2.6,74,3,2.4,80,0.3,{"v":3,"d":"3.0"},92,2,4.2,94,3,4.4,94,2,4.4,87,1,3.7,86,1,3.6,81,2,3.1,92,0.3,4.2,67,3,1.7,90,3,{"v":4,"d":"4.0"},86,2.5,3.6,86,1.5,3.6,88,1,3.8,90,0.3,{"v":4,"d":"4.0"},104.29999999999998,255.37999999999994,{"v":2.4485139022051774,"d":"2.45"}]
["201312200501002","王蒙",82,74,82,85,67,4,1.7,86,2,3.6,90,1,{"v":4,"d":"4.0"},71,3,2.1,77,2,2.7,84,0.3,3.4,86,2,3.6,68,3,1.8,60,3,{"v":1,"d":"1.0"},92,1,4.2,60,4,{"v":1,"d":"1.0"},60,3,{"v":1,"d":"1.0"},60,2.5,{"v":1,"d":"1.0"},72,3,2.2,86,3,3.6,90,0.3,{"v":4,"d":"4.0"},82,3,3.2,79,1,2.9,60,4,{"v":1,"d":"1.0"},77,5,2.7,72,2,2.2,71,4,2.1,97,0.3,4.7,65,6,1.5,67,3,1.7,70,4,{"v":2,"d":"2.0"},78,3,2.8,77,2,2.7,74,1,2.4,88,3,3.8,70,3,{"v":2,"d":"2.0"},79,0.3,2.9,89,2,3.9,77,3,2.7,86,2,3.6,86,1,3.6,82,1,3.2,84,2,3.4,94,0.3,4.4,88,3,3.8,86,3,3.6,93,2.5,4.3,82,1.5,3.2,92,1,4.2,94,0.3,4.4,104.29999999999998,260.69000000000005,{"v":2.499424736337489,"d":"2.50"}]
["201312200501003","方来",75,77,62,96,66,4,1.6,74,2,2.4,88,1,3.8,69,3,1.9,73,2,2.3,85,0.3,3.5,82,2,3.2,62,3,1.2,60,3,{"v":1,"d":"1.0"},91,1,4.1,61,4,1.1,74,3,2.4,70,2.5,{"v":2,"d":"2.0"},76,3,2.6,84,3,3.4,86,0.3,3.6,80,3,{"v":3,"d":"3.0"},70,1,{"v":2,"d":"2.0"},64,4,1.4,79,5,2.9,68,2,1.8,72,4,2.2,95,0.3,4.5,63,6,1.3,62,3,1.2,74,4,2.4,89,3,3.9,86,2,3.6,85,1,3.5,76,3,2.6,94,3,4.4,82,0.3,3.2,93,2,4.3,73,3,2.3,96,2,4.6,86,1,3.6,85,1,3.5,88,2,3.8,90,0.3,{"v":4,"d":"4.0"},71,3,2.1,88,3,3.8,85,2.5,3.5,84,1.5,3.4,91,1,4.1,94,0.3,4.4,104.29999999999998,266.90999999999997,{"v":2.559060402684564,"d":"2.56"}]
["201312200501004","高丽娜",79,86,87,83,70,4,{"v":2,"d":"2.0"},96,2,4.6,95,1,4.5,90,3,{"v":4,"d":"4.0"},86,2,3.6,94,0.3,4.4,86,2,3.6,62,3,1.2,76,3,2.6,94,1,4.4,60,4,{"v":1,"d":"1.0"},75,3,2.5,84,2.5,3.4,83,3,3.3,88,3,3.8,87,0.3,3.7,89,3,3.9,82,1,3.2,60,4,{"v":1,"d":"1.0"},82,5,3.2,79,2,2.9,68,4,1.8,98,0.3,4.8,86,6,3.6,76,3,2.6,79,4,2.9,91,3,4.1,92,2,4.2,82,1,3.2,88,3,3.8,84,3,3.4,78,0.3,2.8,97,2,4.7,88,3,3.8,93,2,4.3,88,1,3.8,89,1,3.9,89,2,3.9,92,0.3,4.2,84,3,3.4,91,3,4.1,87,2.5,3.7,92,1.5,4.2,91,1,4.1,97,0.3,4.7,104.29999999999998,334.0300000000001,{"v":3.202588686481305,"d":"3.20"}]
["201312200501005","李梦杰",81,61,79,76,81,4,3.1,91,2,4.1,90,1,{"v":4,"d":"4.0"},83,3,3.3,81,2,3.1,89,0.3,3.9,88,2,3.8,80,3,{"v":3,"d":"3.0"},79,3,2.9,93,1,4.3,75,4,2.5,70,3,{"v":2,"d":"2.0"},88,2.5,3.8,95,3,4.5,93,3,4.3,93,0.3,4.3,92,3,4.2,84,1,3.4,72,4,2.2,85,5,3.5,81,2,3.1,76,4,2.6,97,0.3,4.7,80,6,{"v":3,"d":"3.0"},92,3,4.2,78,4,2.8,93,3,4.3,94,2,4.4,88,1,3.8,92,3,4.2,78,3,2.8,84,0.3,3.4,97,2,4.7,89,3,3.9,93,2,4.3,90,1,{"v":4,"d":"4.0"},93,1,4.3,87,2,3.7,92,0.3,4.2,89,3,3.9,93,3,4.3,91,2.5,4.1,84,1.5,3.4,92,1,4.2,91,0.3,4.1,104.29999999999998,366.33,{"v":3.512272291466923,"d":"3.51"}]
["201312200501006","吴鸿章",71,81,76,87,76,4,2.6,91,2,4.1,90,1,{"v":4,"d":"4.0"},83,3,3.3,81,2,3.1,89,0.3,3.9,81,2,3.1,77,3,2.7,85,3,3.5,91,1,4.1,68,4,1.8,88,3,3.8,60,2.5,{"v":1,"d":"1.0"},82,3,3.2,87,3,3.7,87,0.3,3.7,95,3,4.5,78,1,2.8,70,4,{"v":2,"d":"2.0"},91,5,4.1,84,2,3.4,64,4,1.4,97,0.3,4.7,80,6,{"v":3,"d":"3.0"},74,3,2.4,79,4,2.9,87,3,3.7,90,2,{"v":4,"d":"4.0"},86,1,3.6,91,3,4.1,90,3,{"v":4,"d":"4.0"},82,0.3,3.2,89,2,3.9,87,3,3.7,90,2,{"v":4,"d":"4.0"},86,1,3.6,89,1,3.9,89,2,3.9,93,0.3,4.3,85,3,3.5,89,3,3.9,93,2.5,4.3,91,1.5,4.1,91,1,4.1,93,0.3,4.3,104.29999999999998,343.03000000000003,{"v":3.2888782358581024,"d":"3.29"}]
["201312200501008","陈怡平",76,87,85,88,80,4,{"v":3,"d":"3.0"},92,2,4.2,88,1,3.8,90,3,{"v":4,"d":"4.0"},75,2,2.5,91,0.3,4.1,91,2,4.1,69,3,1.9,84,3,3.4,89,1,3.9,64,4,1.4,60,3,{"v":1,"d":"1.0"},72,2.5,2.2,82,3,3.2,84,3,3.4,87,0.3,3.7,75,3,2.5,79,1,2.9,69,4,1.9,84,5,3.4,73,2,2.3,75,4,2.5,96,0.3,4.6,69,6,1.9,71,3,2.1,82,4,3.2,80,3,{"v":3,"d":"3.0"},90,2,{"v":4,"d":"4.0"},74,1,2.4,83,3,3.3,78,3,2.8,80,0.3,{"v":3,"d":"3.0"},81,2,3.1,82,3,3.2,92,2,4.2,88,1,3.8,87,1,3.7,88,2,3.8,87,0.3,3.7,83,3,3.3,93,3,4.3,90,2.5,{"v":4,"d":"4.0"},92,1.5,4.2,91,1,4.1,93,0.3,4.3,104.29999999999998,310.4200000000001,{"v":2.976222435282839,"d":"2.98"}]
["201312200501009","王教峰",72,79,89,69,77,4,2.7,84,2,3.4,89,1,3.9,76,3,2.6,76,2,2.6,90,0.3,{"v":4,"d":"4.0"},94,2,4.4,70,3,{"v":2,"d":"2.0"},80,3,{"v":3,"d":"3.0"},92,1,4.2,66,4,1.6,73,3,2.3,90,2.5,{"v":4,"d":"4.0"},84,3,3.4,89,3,3.9,89,0.3,3.9,95,3,4.5,81,1,3.1,91,4,4.1,93,5,4.3,86,2,3.6,72,4,2.2,96,0.3,4.6,76,6,2.6,94,3,4.4,80,4,{"v":3,"d":"3.0"},97,3,4.7,81,2,3.1,84,1,3.4,89,3,3.9,70,3,{"v":2,"d":"2.0"},71,0.3,2.1,95,2,4.5,89,3,3.9,81,2,3.1,82,1,3.2,88,1,3.8,93,2,4.3,89,0.3,3.9,97,3,4.7,95,3,4.5,82,2.5,3.2,90,1.5,{"v":4,"d":"4.0"},90.5,1,{"v":4.05,"d":"4.1"},90,0.3,{"v":4,"d":"4.0"},104.29999999999998,355.3,{"v":3.4065196548418033,"d":"3.41"}]
["201312200501011","杨有广",86,92,85,95,74,4,2.4,88,2,3.8,89,1,3.9,74,3,2.4,70,2,{"v":2,"d":"2.0"},87,0.3,3.7,80,2,{"v":3,"d":"3.0"},60,3,{"v":1,"d":"1.0"},71,3,2.1,91,1,4.1,66,4,1.6,60,3,{"v":1,"d":"1.0"},81,2.5,3.1,77,3,2.7,85,3,3.5,88,0.3,3.8,83,3,3.3,77,1,2.7,65,4,1.5,80,5,{"v":3,"d":"3.0"},85,2,3.5,68,4,1.8,97,0.3,4.7,77,6,2.7,65,3,1.5,77,4,2.7,85,3,3.5,88,2,3.8,84,1,3.4,81,3,3.1,80,3,{"v":3,"d":"3.0"},77,0.3,2.7,85,2,3.5,93,3,4.3,85,2,3.5,82,1,3.2,89,1,3.9,90,2,{"v":4,"d":"4.0"},88,0.3,3.8,68,3,1.8,90,3,{"v":4,"d":"4.0"},80,2.5,{"v":3,"d":"3.0"},84,1.5,3.4,93,1,4.3,89,0.3,3.9,104.29999999999998,289.63000000000005,{"v":2.7768935762224363,"d":"2.78"}]
["201312200501012","朱慈君",75,72,72,81,76,4,2.6,92,2,4.2,94,1,4.4,62,3,1.2,83,2,3.3,91,0.3,4.1,86,2,3.6,60,3,{"v":1,"d":"1.0"},62,3,1.2,94,1,4.4,65,4,1.5,60,3,{"v":1,"d":"1.0"},60,2.5,{"v":1,"d":"1.0"},76,3,2.6,87,3,3.7,85,0.3,3.5,60,3,{"v":1,"d":"1.0"},80,1,{"v":3,"d":"3.0"},64,4,1.4,72,5,2.2,70,2,{"v":2,"d":"2.0"},83,4,3.3,95,0.3,4.5,86,6,3.6,62,3,1.2,81,4,3.1,88,3,3.8,85,2,3.5,83,1,3.3,77,3,2.7,82,3,3.2,81,0.3,3.1,82,2,3.2,76,3,2.6,80,2,{"v":3,"d":"3.0"},87,1,3.7,80,1,{"v":3,"d":"3.0"},85,2,3.5,89,0.3,3.9,75,3,2.5,80,3,{"v":3,"d":"3.0"},86,2.5,3.6,84,1.5,3.4,89,1,3.9,91,0.3,4.1,104.29999999999998,274.16,{"v":2.6285714285714294,"d":"2.63"}]
["201312200501013","郑思彤",85,60,79,93,75,4,2.5,94,2,4.4,89,1,3.9,60,3,{"v":1,"d":"1.0"},73,2,2.3,93,0.3,4.3,89,2,3.9,60,3,{"v":1,"d":"1.0"},61,3,1.1,93,1,4.3,63,4,1.3,69,3,1.9,60,2.5,{"v":1,"d":"1.0"},70,3,{"v":2,"d":"2.0"},90,3,{"v":4,"d":"4.0"},87,0.3,3.7,60,3,{"v":1,"d":"1.0"},75,1,2.5,61,4,1.1,73,5,2.3,71,2,2.1,71,4,2.1,98,0.3,4.8,77,6,2.7,61,3,1.1,71,4,2.1,74,3,2.4,87,2,3.7,77,1,2.7,81,3,3.1,88,3,3.8,83,0.3,3.3,83,2,3.3,77,3,2.7,78,2,2.8,89,1,3.9,82,1,3.2,80,2,{"v":3,"d":"3.0"},90,0.3,{"v":4,"d":"4.0"},71,3,2.1,85,3,3.5,87,2.5,3.7,78,1.5,2.8,89,1,3.9,88,0.3,3.8,104.29999999999998,254.71999999999997,{"v":2.4421860019175456,"d":"2.44"}]
["201312200501014","张咪",77,88,81,86,60,4,{"v":1,"d":"1.0"},90,2,{"v":4,"d":"4.0"},94,1,4.4,81,3,3.1,75,2,2.5,90,0.3,{"v":4,"d":"4.0"},89,2,3.9,75,3,2.5,61,3,1.1,91,1,4.1,61,4,1.1,75,3,2.5,70,2.5,{"v":2,"d":"2.0"},72,3,2.2,90,3,{"v":4,"d":"4.0"},90,0.3,{"v":4,"d":"4.0"},83,3,3.3,76,1,2.6,63,4,1.3,74,5,2.4,80,2,{"v":3,"d":"3.0"},68,4,1.8,99,0.3,4.9,81,6,3.1,64,3,1.4,77,4,2.7,80,3,{"v":3,"d":"3.0"},88,2,3.8,83,1,3.3,81,3,3.1,84,3,3.4,77,0.3,2.7,74,2,2.4,81,3,3.1,78,2,2.8,88,1,3.8,83,1,3.3,84,2,3.4,91,0.3,4.1,72,3,2.2,90,3,{"v":4,"d":"4.0"},81,2.5,3.1,75,1.5,2.5,90,1,{"v":4,"d":"4.0"},97,0.3,4.7,104.29999999999998,279.82000000000005,{"v":2.682837967401727,"d":"2.68"}]
["201312200501015","郁吉锋",75,63,60,81,70,4,{"v":2,"d":"2.0"},71,2,2.1,89,1,3.9,69,3,1.9,72,2,2.2,79,0.3,2.9,78,2,2.8,64,3,1.4,60,3,{"v":1,"d":"1.0"},88,1,3.8,60,4,{"v":1,"d":"1.0"},60,3,{"v":1,"d":"1.0"},60,2.5,{"v":1,"d":"1.0"},73,3,2.3,82,3,3.2,85,0.3,3.5,90,3,{"v":4,"d":"4.0"},78,1,2.8,61,4,1.1,69,5,1.9,68,2,1.8,81,4,3.1,85,0.3,3.5,75,6,2.5,62,3,1.2,77,4,2.7,74,3,2.4,81,2,3.1,77,1,2.7,79,3,2.9,62,3,1.2,76,0.3,2.6,90,2,{"v":4,"d":"4.0"},83,3,3.3,91,2,4.1,79,1,2.9,75,1,2.5,85,2,3.5,89,0.3,3.9,78,3,2.8,86,3,3.6,72,2.5,2.2,86,1.5,3.6,88,1,3.8,83,0.3,3.3,104.29999999999998,249.60999999999996,{"v":2.3931927133269415,"d":"2.39"}]
["201312200501018","程霖",77,86,87,88,71,4,2.1,92,2,4.2,87,1,3.7,60,3,{"v":1,"d":"1.0"},83,2,3.3,86,0.3,3.6,82,2,3.2,62,3,1.2,60,3,{"v":1,"d":"1.0"},92,1,4.2,62,4,1.2,60,3,{"v":1,"d":"1.0"},64,2.5,1.4,67,3,1.7,91,3,4.1,86,0.3,3.6,60,3,{"v":1,"d":"1.0"},73,1,2.3,61,4,1.1,66,5,1.6,66,2,1.6,64,4,1.4,99,0.3,4.9,78,6,2.8,63,3,1.3,72,4,2.2,60,3,{"v":1,"d":"1.0"},75,2,2.5,75,1,2.5,84,3,3.4,82,3,3.2,79,0.3,2.9,76,2,2.6,79,3,2.9,81,2,3.1,86,1,3.6,74,1,2.4,87,2,3.7,91,0.3,4.1,63,3,1.3,69,3,1.9,87,2.5,3.7,83,1.5,3.3,88,1,3.8,86,0.3,3.6,104.29999999999998,230.20999999999995,{"v":2.2071907957813997,"d":"2.21"}]
["201312200501019","徐甜甜",79,60,78,81,90,4,{"v":4,"d":"4.0"},94,2,4.4,88,1,3.8,72,3,2.2,83,2,3.3,88,0.3,3.8,86,2,3.6,65,3,1.5,92,3,4.2,91,1,4.1,78,4,2.8,72,3,2.2,66,2.5,1.6,87,3,3.7,88,3,3.8,90,0.3,{"v":4,"d":"4.0"},76,3,2.6,77,1,2.7,83,4,3.3,79,5,2.9,72,2,2.2,82,4,3.2,97,0.3,4.7,81,6,3.1,77,3,2.7,90,4,{"v":4,"d":"4.0"},89,3,3.9,88,2,3.8,82,1,3.2,89,3,3.9,86,3,3.6,82,0.3,3.2,85,2,3.5,87,3,3.7,90,2,{"v":4,"d":"4.0"},84,1,3.4,92,1,4.2,90,2,{"v":4,"d":"4.0"},91,0.3,4.1,87,3,3.7,92,3,4.2,91,2.5,4.1,91,1.5,4.1,93,1,4.3,94,0.3,4.4,104.29999999999998,350.96,{"v":3.3649089165867694,"d":"3.36"}]
["201312200501020","陈剑锋",74,74,69,89,65,4,1.5,68,2,1.8,87,1,3.7,62,3,1.2,72,2,2.2,82,0.3,3.2,78,2,2.8,60,3,{"v":1,"d":"1.0"},61,3,1.1,92,1,4.2,60,4,{"v":1,"d":"1.0"},60,3,{"v":1,"d":"1.0"},60,2.5,{"v":1,"d":"1.0"},69,3,1.9,84,3,3.4,88,0.3,3.8,65,3,1.5,75,1,2.5,60,4,{"v":1,"d":"1.0"},64,5,1.4,73,2,2.3,65,4,1.5,88,0.3,3.8,77,6,2.7,60,3,{"v":1,"d":"1.0"},67,4,1.7,81,3,3.1,73,2,2.3,71,1,2.1,80,3,{"v":3,"d":"3.0"},82,3,3.2,80,0.3,{"v":3,"d":"3.0"},68,2,1.8,60,3,{"v":1,"d":"1.0"},76,2,2.6,86,1,3.6,75,1,2.5,85,2,3.5,93,0.3,4.3,60,3,{"v":1,"d":"1.0"},62,3,1.2,86,2.5,3.6,76,1.5,2.6,89,1,3.9,85,0.3,3.5,104.29999999999998,206.77999999999997,{"v":1.98255033557047,"d":"1.98"}]
["201312200501022","刘勇",78,88,81,80,60,4,{"v":1,"d":"1.0"},91,2,4.1,92,1,4.2,78,3,2.8,73,2,2.3,87,0.3,3.7,76,2,2.6,60,3,{"v":1,"d":"1.0"},60,3,{"v":1,"d":"1.0"},93,1,4.3,81,4,3.1,63,3,1.3,60,2.5,{"v":1,"d":"1.0"},67,3,1.7,93,3,4.3,87,0.3,3.7,70,3,{"v":2,"d":"2.0"},84,1,3.4,60,4,{"v":1,"d":"1.0"},70,5,{"v":2,"d":"2.0"},71,2,2.1,74,4,2.4,95,0.3,4.5,69,6,1.9,68,3,1.8,65,4,1.5,74,3,2.4,89,2,3.9,72,1,2.2,78,3,2.8,80,3,{"v":3,"d":"3.0"},80,0.3,{"v":3,"d":"3.0"},83,2,3.3,77,3,2.7,85,2,3.5,85,1,3.5,84,1,3.4,85,2,3.5,94,0.3,4.4,68,3,1.8,73,3,2.3,84,2.5,3.4,72,1.5,2.2,89,1,3.9,94,0.3,4.4,104.29999999999998,247.01000000000002,{"v":2.368264621284756,"d":"2.37"}]
["201312200501023","李浙鑫",66,69,77,71,82,4,3.2,93,2,4.3,89,1,3.9,77,3,2.7,71,2,2.1,87,0.3,3.7,88,2,3.8,65,3,1.5,62,3,1.2,93,1,4.3,82,4,3.2,77,3,2.7,88,2.5,3.8,80,3,{"v":3,"d":"3.0"},90,3,{"v":4,"d":"4.0"},90,0.3,{"v":4,"d":"4.0"},75,3,2.5,82,1,3.2,73,4,2.3,71,5,2.1,72,2,2.2,78,4,2.8,97,0.3,4.7,85,6,3.5,77,3,2.7,84,4,3.4,87,3,3.7,89,2,3.9,82,1,3.2,87,3,3.7,76,3,2.6,73,0.3,2.3,82,2,3.2,88,3,3.8,87,2,3.7,88,1,3.8,78,1,2.8,88,2,3.8,92,0.3,4.2,80,3,{"v":3,"d":"3.0"},85,3,3.5,86,2.5,3.6,83,1.5,3.3,92,1,4.2,91,0.3,4.1,104.29999999999998,322.65,{"v":3.0934803451581976,"d":"3.09"}]
["201312200501024","季晓静",76,72,76,73,79,4,2.9,94,2,4.4,87,1,3.7,87,3,3.7,74,2,2.4,81,0.3,3.1,82,2,3.2,65,3,1.5,60,3,{"v":1,"d":"1.0"},91,1,4.1,71,4,2.1,68,3,1.8,86,2.5,3.6,89,3,3.9,86,3,3.6,90,0.3,{"v":4,"d":"4.0"},67,3,1.7,78,1,2.8,64,4,1.4,67,5,1.7,70,2,{"v":2,"d":"2.0"},84,4,3.4,94,0.3,4.4,72,6,2.2,72,3,2.2,74,4,2.4,86,3,3.6,82,2,3.2,74,1,2.4,86,3,3.6,66,3,1.6,77,0.3,2.7,82,2,3.2,72,3,2.2,83,2,3.3,82,1,3.2,90,1,{"v":4,"d":"4.0"},87,2,3.7,93,0.3,4.3,76,3,2.6,87,3,3.7,91,2.5,4.1,88,1.5,3.8,90,1,{"v":4,"d":"4.0"},92,0.3,4.2,104.29999999999998,287.36,{"v":2.7551294343240658,"d":"2.76"}]
["201312200501025","丁秦超",81,87,80,68,74,4,2.4,88,2,3.8,89,1,3.9,62,3,1.2,66,2,1.6,87,0.3,3.7,75,2,2.5,70,3,{"v":2,"d":"2.0"},63,3,1.3,91,1,4.1,60,4,{"v":1,"d":"1.0"},72,3,2.2,64,2.5,1.4,69,3,1.9,89,3,3.9,86,0.3,3.6,78,3,2.8,74,1,2.4,63,4,1.3,74,5,2.4,79,2,2.9,72,4,2.2,98,0.3,4.8,75,6,2.5,65,3,1.5,67,4,1.7,81,3,3.1,83,2,3.3,74,1,2.4,84,3,3.4,86,3,3.6,79,0.3,2.9,96,2,4.6,84,3,3.4,88,2,3.8,79,1,2.9,87,1,3.7,87,2,3.7,89,0.3,3.9,69,3,1.9,89,3,3.9,84,2.5,3.4,91,1.5,4.1,88,1,3.8,83,0.3,3.3,104.29999999999998,270.10999999999996,{"v":2.5897411313518695,"d":"2.59"}]
["201312200501026","秦珊",78,85,77,86,87,4,3.7,86,2,3.6,90,1,{"v":4,"d":"4.0"},64,3,1.4,65,2,1.5,83,0.3,3.3,80,2,{"v":3,"d":"3.0"},72,3,2.2,73,3,2.3,89,1,3.9,73,4,2.3,60,3,{"v":1,"d":"1.0"},60,2.5,{"v":1,"d":"1.0"},60,3,{"v":1,"d":"1.0"},91,3,4.1,87,0.3,3.7,69,3,1.9,82,1,3.2,78,4,2.8,66,5,1.6,68,2,1.8,68,4,1.8,97,0.3,4.7,79,6,2.9,75,3,2.5,80,4,{"v":3,"d":"3.0"},77,3,2.7,90,2,{"v":4,"d":"4.0"},79,1,2.9,84,3,3.4,74,3,2.4,75,0.3,2.5,79,2,2.9,80,3,{"v":3,"d":"3.0"},79,2,2.9,87,1,3.7,85,1,3.5,89,2,3.9,90,0.3,{"v":4,"d":"4.0"},78,3,2.8,90,3,{"v":4,"d":"4.0"},89,2.5,3.9,82,1.5,3.2,91,1,4.1,90,0.3,{"v":4,"d":"4.0"},104.29999999999998,280.11,{"v":2.685618408437201,"d":"2.69"}]
["201312200501027","祝冬红",69,71,65,75,77,4,2.7,91,2,4.1,88,1,3.8,84,3,3.4,78,2,2.8,88,0.3,3.8,85,2,3.5,67,3,1.7,76,3,2.6,60,1,{"v":1,"d":"1.0"},60,4,{"v":1,"d":"1.0"},60,3,{"v":1,"d":"1.0"},86,2.5,3.6,60,3,{"v":1,"d":"1.0"},60,3,{"v":1,"d":"1.0"},87,0.3,3.7,82,3,3.2,84,1,3.4,68,4,1.8,83,5,3.3,80,2,{"v":3,"d":"3.0"},72,4,2.2,96,0.3,4.6,73,6,2.3,89,3,3.9,72,4,2.2,76,3,2.6,92,2,4.2,79,1,2.9,78,3,2.8,90,3,{"v":4,"d":"4.0"},79,0.3,2.9,80,2,{"v":3,"d":"3.0"},75,3,2.5,92,2,4.2,86,1,3.6,87,1,3.7,87,2,3.7,90,0.3,{"v":4,"d":"4.0"},83,3,3.3,87,3,3.7,87,2.5,3.7,88,1.5,3.8,90,1,{"v":4,"d":"4.0"},91,0.3,4.1,104.29999999999998,290.28000000000003,{"v":2.7831255992329824,"d":"2.78"}]
["201312200501028","俞婷婷",70,92,60,62,74,4,2.4,90,2,{"v":4,"d":"4.0"},89,1,3.9,78,3,2.8,77,2,2.7,81,0.3,3.1,81,2,3.1,64,3,1.4,85,3,3.5,92,1,4.2,70,4,{"v":2,"d":"2.0"},68,3,1.8,72,2.5,2.2,83,3,3.3,83,3,3.3,85,0.3,3.5,85,3,3.5,86,1,3.6,66,4,1.6,62,5,1.2,74,2,2.4,87,4,3.7,96,0.3,4.6,84,6,3.4,91,3,4.1,77,4,2.7,85,3,3.5,88,2,3.8,79,1,2.9,82,3,3.2,74,3,2.4,72,0.3,2.2,78,2,2.8,79,3,2.9,81,2,3.1,89,1,3.9,86,1,3.6,86,2,3.6,94,0.3,4.4,91,3,4.1,84,3,3.4,87,2.5,3.7,83,1.5,3.3,93,1,4.3,90,0.3,{"v":4,"d":"4.0"},104.29999999999998,309.23999999999995,{"v":2.964908916586769,"d":"2.96"}]
["201312200501029","毛佩威",84,81,88,89,76,4,2.6,76,2,2.6,89,1,3.9,60,3,{"v":1,"d":"1.0"},83,2,3.3,83,0.3,3.3,76,2,2.6,62,3,1.2,68,3,1.8,91,1,4.1,70,4,{"v":2,"d":"2.0"},70,3,{"v":2,"d":"2.0"},62,2.5,1.2,74,3,2.4,89,3,3.9,82,0.3,3.2,62,3,1.2,74,1,2.4,61,4,1.1,67,5,1.7,68,2,1.8,76,4,2.6,95,0.3,4.5,80,6,{"v":3,"d":"3.0"},73,3,2.3,75,4,2.5,80,3,{"v":3,"d":"3.0"},81,2,3.1,79,1,2.9,83,3,3.3,74,3,2.4,74,0.3,2.4,87,2,3.7,75,3,2.5,85,2,3.5,82,1,3.2,74,1,2.4,85,2,3.5,88,0.3,3.8,60,3,{"v":1,"d":"1.0"},71,3,2.1,75,2.5,2.5,89,1.5,3.9,89,1,3.9,86,0.3,3.6,104.29999999999998,252.34,{"v":2.419367209971237,"d":"2.42"}]
["201312200501030","张小敏",81,68,84,76,71,4,2.1,89,2,3.9,89,1,3.9,85,3,3.5,76,2,2.6,85,0.3,3.5,90,2,{"v":4,"d":"4.0"},60,3,{"v":1,"d":"1.0"},68,3,1.8,91,1,4.1,64,4,1.4,72,3,2.2,74,2.5,2.4,79,3,2.9,84,3,3.4,87,0.3,3.7,86,3,3.6,78,1,2.8,70,4,{"v":2,"d":"2.0"},76,5,2.6,77,2,2.7,74,4,2.4,96,0.3,4.6,71,6,2.1,89,3,3.9,77,4,2.7,85,3,3.5,88,2,3.8,78,1,2.8,85,3,3.5,90,3,{"v":4,"d":"4.0"},76,0.3,2.6,86,2,3.6,93,3,4.3,90,2,{"v":4,"d":"4.0"},88,1,3.8,88,1,3.8,87,2,3.7,93,0.3,4.3,72,3,2.2,91,3,4.1,89,2.5,3.9,73,1.5,2.3,91,1,4.1,92,0.3,4.2,104.29999999999998,307.67,{"v":2.9498561840843727,"d":"2.95"}]

{"sheet":"生技必修课成绩汇总","index":1,"n_rows":2,"n_cols":135,"rows_kept":2,"flags":["formulas_cached_only"]}
["学号","姓名","体育（1） [2]","体育2 [2]","体育3 [2]","体育4[2]","无机化学 [3]","学分","绩点","大学英语（1） [4]","学分","绩点","思想道德修养与法律基础 [3]","学分","绩点","形势与政策 [.3]","学分","绩点","大学生心理健康教育 [2]","学分","绩点","高等数学 [3]","学分","绩点","大学生就业指导与创业教育 [1]","学分","绩点","大学英语（2） [4]","学分","绩点","军事理论课 [2]","学分","绩点","普通生物学 [3]","学分","绩点","普通生物学实践 [1.5]","学分","绩点","计算机文化基础 [4]","学分","绩点","生理学 [3]","学分","绩点","中国近现代史纲要 [2]","学分","绩点","形势与政策 [.3]","学分","绩点","有机化学 [3]","学分","绩点","分析化学 [3]","学分","绩点","大学生就业与创业 [1]","学分","绩点","大学英语（3） [4]","学分","绩点","生物化学 [5]","学分","绩点","马克思主义基本原理概论 [3]","学分","绩点","形势与政策 [.3]","学分","绩点","大学英语（4） [4]","学分","绩点","微生物学 [3]","学分","绩点","生物化学大实验 [2]","学分","绩点","微生物学实验 [1]","学分","绩点","植物生理学 [3]","学分","绩点","形势与政策 [.3]","学分","绩点","毛泽东思想和中国特色社会主义理论体系 [6]","学分","绩点","大学生就业与创业 [1]","学分","绩点","生物统计学 [3]","学分","绩点","遗传学 [2]","学分","绩点","细胞生物学 [3]","学分","绩点","分子生物学 [3]","学分","绩点","遗传学实验 [1]","学分","绩点","形势与政策 [.3]","学分","绩点","发酵工程实验 [2]","学分","绩点","细胞工程 [3]","学分","绩点","分子生物学大实验 [2]","学分","绩点","蛋白质工程 [2.5]","学分","绩点","形势与政策 [.3]","学分","绩点","发酵工程 [2]","学分","绩点","总学分","总学分绩点","加权平均绩点"]
["201323201701027","章沙沙",78,84,80,85,79,3,2.9,76,4,2.6,87,3,3.7,90,0.3,{"v":4,"d":"4.0"},73,2,2.3,78,3,2.8,94,1,4.4,68,4,1.8,87,2,3.7,88,3,3.8,74,1.5,2.4,78,4,2.8,87,3,3.7,81,2,3.1,94,0.3,4.4,84,3,3.4,89,3,3.9,91,1,4.1,67,4,1.7,99,5,4.9,80,3,{"v":3,"d":"3.0"},93,0.3,4.3,78,4,2.8,89,3,3.9,95,2,4.5,88,1,3.8,81,3,3.1,94,0.3,4.4,86,6,3.6,97,1,4.7,88,3,3.8,88,2,3.8,91,3,4.1,93,3,4.3,93,1,4.3,94,0.3,4.4,81,2,3.1,92,3,4.2,92,2,4.2,93,2.5,4.3,89,0.3,3.9,85,2,3.5,99.79999999999998,344.36999999999995,{"v":3.4506012024048096,"d":"3.45"}]

{"sheet":"必修课成绩排名","index":2,"n_rows":28,"n_cols":5,"rows_kept":28,"merged":[[0,0,0,4]],"flags":["formulas_cached_only"]}
["生命科学学院2017届生物科学专业（含生物技术专业1人）本部学生推荐免试攻读硕士研究生必修课成绩排名"]
["序号","学号","姓名","必修课加权平均绩点","成绩排名"]
[1,"201312200501005","李梦杰",{"v":3.512272291466923,"d":"3.51"},1]
[2,"201323201701027","章沙沙",{"v":3.4506012024048096,"d":"3.45"},2]
[3,"201312200501009","王教峰",{"v":3.4065196548418033,"d":"3.41"},3]
[4,"201312200501019","徐甜甜",{"v":3.3649089165867694,"d":"3.36"},4]
[5,"201312200501006","吴鸿章",{"v":3.2888782358581024,"d":"3.29"},5]
[6,"201312200501004","高丽娜",{"v":3.202588686481305,"d":"3.20"},6]
[7,"201312200501023","李浙鑫",{"v":3.0934803451581976,"d":"3.09"},7]
[8,"201312200501008","陈怡平",{"v":2.976222435282839,"d":"2.98"},8]
[9,"201312200501028","俞婷婷",{"v":2.964908916586769,"d":"2.96"},9]
[10,"201312200501030","张小敏",{"v":2.9498561840843727,"d":"2.95"},10]
[11,"201312200501027","祝冬红",{"v":2.7831255992329824,"d":"2.78"},11]
[12,"201312200501011","杨有广",{"v":2.7768935762224363,"d":"2.78"},12]
[13,"201312200501024","季晓静",{"v":2.7551294343240658,"d":"2.76"},13]
[14,"201312200501026","秦珊",{"v":2.685618408437201,"d":"2.69"},14]
[15,"201312200501014","张咪",{"v":2.682837967401727,"d":"2.68"},15]
[16,"201312200501012","朱慈君",{"v":2.6285714285714294,"d":"2.63"},16]
[17,"201312200501025","丁秦超",{"v":2.5897411313518695,"d":"2.59"},17]
[18,"201312200501003","方来",{"v":2.559060402684564,"d":"2.56"},18]
[19,"201312200501002","王蒙",{"v":2.499424736337489,"d":"2.50"},19]
[20,"201312200501001","吴飞",{"v":2.4485139022051774,"d":"2.45"},20]
[21,"201312200501013","郑思彤",{"v":2.4421860019175456,"d":"2.44"},21]
[22,"201312200501029","毛佩威",{"v":2.419367209971237,"d":"2.42"},22]
[23,"201312200501015","郁吉锋",{"v":2.3931927133269415,"d":"2.39"},23]
[24,"201312200501022","刘勇",{"v":2.368264621284756,"d":"2.37"},24]
[25,"201312200501018","程霖",{"v":2.2071907957813997,"d":"2.21"},25]
[26,"201312200501020","陈剑锋",{"v":1.98255033557047,"d":"1.98"},26]

{"sheet":"资格审查","index":3,"n_rows":31,"n_cols":12,"rows_kept":31,"merged":[[0,0,0,11]],"flags":["formulas_cached_only"]}
["生命科学学院2017届生物科学（含生物技术1人）专业本部学生推荐免试攻读硕士研究生综合测评情况 "]
["序号","学号","姓名","必修课加权平均绩点","加分项","综合测评总分","综合测评总分排名","备注","CET4成绩","CET6成绩","符合条件情况","备注"]
[1,"201312200501005","李梦杰",{"v":3.512272291466923,"d":"3.51"},0.2,{"v":3.712272291466923,"d":"3.71"},1,"必修课程加权平均学分绩点列专业前20%",473,447,"符合","推荐"]
[2,"201323201701027","章沙沙",{"v":3.4506012024048096,"d":"3.45"},0.2,{"v":3.65060120240481,"d":"3.65"},2,"必修课程加权平均学分绩点列专业前20%",439,425,"符合"]
[4,"201312200501019","徐甜甜",{"v":3.3649089165867694,"d":"3.36"},0.2,{"v":3.5649089165867696,"d":"3.56"},3,"必修课程加权平均学分绩点列专业前20%",508,512,"符合"]
[3,"201312200501009","王教峰",{"v":3.4065196548418033,"d":"3.41"},0,{"v":3.4065196548418033,"d":"3.41"},4,"必修课程加权平均学分绩点列专业前20%",463,386]
[5,"201312200501006","吴鸿章",{"v":3.2888782358581024,"d":"3.29"},0,{"v":3.2888782358581024,"d":"3.29"},5,"必修课程加权平均学分绩点列专业前20%",430,366]
[6,"201312200501004","高丽娜",{"v":3.202588686481305,"d":"3.20"},0,{"v":3.202588686481305,"d":"3.20"},6]
[7,"201312200501023","李浙鑫",{"v":3.0934803451581976,"d":"3.09"},0,{"v":3.0934803451581976,"d":"3.09"},7]
[8,"201312200501008","陈怡平",{"v":2.976222435282839,"d":"2.98"},0,{"v":2.976222435282839,"d":"2.98"},8]
[9,"201312200501028","俞婷婷",{"v":2.964908916586769,"d":"2.96"},0,{"v":2.964908916586769,"d":"2.96"},9]
[10,"201312200501030","张小敏",{"v":2.9498561840843727,"d":"2.95"},0,{"v":2.9498561840843727,"d":"2.95"},10]
[11,"201312200501027","祝冬红",{"v":2.7831255992329824,"d":"2.78"},0,{"v":2.7831255992329824,"d":"2.78"},11]
[12,"201312200501011","杨有广",{"v":2.7768935762224363,"d":"2.78"},0,{"v":2.7768935762224363,"d":"2.78"},12]
[13,"201312200501024","季晓静",{"v":2.7551294343240658,"d":"2.76"},0,{"v":2.7551294343240658,"d":"2.76"},13]
[14,"201312200501026","秦珊",{"v":2.685618408437201,"d":"2.69"},0,{"v":2.685618408437201,"d":"2.69"},14]
[15,"201312200501014","张咪",{"v":2.682837967401727,"d":"2.68"},0,{"v":2.682837967401727,"d":"2.68"},15]
[16,"201312200501012","朱慈君",{"v":2.6285714285714294,"d":"2.63"},0,{"v":2.6285714285714294,"d":"2.63"},16]
[17,"201312200501025","丁秦超",{"v":2.5897411313518695,"d":"2.59"},0,{"v":2.5897411313518695,"d":"2.59"},17]
[18,"201312200501003","方来",{"v":2.559060402684564,"d":"2.56"},0,{"v":2.559060402684564,"d":"2.56"},18]
[19,"201312200501002","王蒙",{"v":2.499424736337489,"d":"2.50"},0,{"v":2.499424736337489,"d":"2.50"},19]
[20,"201312200501001","吴飞",{"v":2.4485139022051774,"d":"2.45"},0,{"v":2.4485139022051774,"d":"2.45"},20]
[21,"201312200501013","郑思彤",{"v":2.4421860019175456,"d":"2.44"},0,{"v":2.4421860019175456,"d":"2.44"},21]
[22,"201312200501029","毛佩威",{"v":2.419367209971237,"d":"2.42"},0,{"v":2.419367209971237,"d":"2.42"},22]
[23,"201312200501015","郁吉锋",{"v":2.3931927133269415,"d":"2.39"},0,{"v":2.3931927133269415,"d":"2.39"},23]
[24,"201312200501022","刘勇",{"v":2.368264621284756,"d":"2.37"},0,{"v":2.368264621284756,"d":"2.37"},24]
[25,"201312200501018","程霖",{"v":2.2071907957813997,"d":"2.21"},0,{"v":2.2071907957813997,"d":"2.21"},25]
[26,"201312200501020","陈剑锋",{"v":1.98255033557047,"d":"1.98"},0,{"v":1.98255033557047,"d":"1.98"},26]
[]
["备注："]
["1、加分项为0表示该生未向学院提交加分项目证明材料。"]

{"sheet":"Sheet1","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet2","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}