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

{"sheet":"制药必修课成绩汇总","index":0,"n_rows":38,"n_cols":132,"rows_kept":38,"flags":["formulas_cached_only"]}
["学号","姓名","体育（1） [2]","体育2 [2]","体育3 [2]","体育4[2]","无机及分析化学 [5]","学分","绩点","大学英语（1） [4]","学分","绩点","军事理论课 [2]","学分","绩点","专业导论(制药工程) [1]","学分","绩点","中国近现代史纲要 [2]","学分","绩点","形势与政策 [.3]","学分","绩点","大学生心理健康教育 [2]","学分","绩点","有机化学 [4]","学分","绩点","高等数学 [4]","学分","绩点","大学生就业指导与创业教育 [1]","学分","绩点","大学英语（2） [4]","学分","绩点","工程制图 [2]","学分","绩点","思想道德修养与法律基础 [3]","学分","绩点","形势与政策 [.3]","学分","绩点","物理化学 [2.5]","学分","绩点","高等数学 [4]","学分","绩点","大学生就业指导与创业教育 [1]","学分","绩点","基础生物学 [2]","学分","绩点","现代仪器分析 [2.5]","学分","绩点","计算机文化基础 [4]","学分","绩点","生物化学 [5]","学分","绩点","形势与政策 [.3]","学分","绩点","毛泽东思想和中国特色社会主义理论体系 [6]","学分","绩点","大学英语（3） [4]","学分","绩点","药物化学 [3]","学分","绩点","大学英语（4） [4]","学分","绩点","药物合成反应 [2]","学分","绩点","电工技术基础 [2]","学分","绩点","化学制药实验 [1.5]","学分","绩点","药物分析 [1.5]","学分","绩点","马克思主义基本原理概论 [3]","学分","绩点","形势与政策 [.3]","学分","绩点","生化工程 [3]","学分","绩点","化工原理 [5]","学分","绩点","工业微生物学 [3]","学分","绩点","形势与政策 [.3]","学分","绩点","药理学 [2]","学分","绩点","药剂学 [4]","学分","绩点","生物工艺学 [3]","学分","绩点","发酵工程实验 [1]","学分","绩点","形势与政策 [.3]","学分","绩点","总学分","总学分绩点","加权平均绩点"]
["201312201801001","陈杭茜",81,65,71,79,84,5,3.4,88,4,3.8,87,2,3.7,60,1,{"v":1,"d":"1.0"},67,2,1.7,89,0.3,3.9,74,2,2.4,85,4,3.5,69,4,1.9,82,1,3.2,70,4,{"v":2,"d":"2.0"},64,2,1.4,79,3,2.9,89,0.3,3.9,87,2.5,3.7,60,4,{"v":1,"d":"1.0"},86,1,3.6,78,2,2.8,86,2.5,3.6,81,4,3.1,70,5,{"v":2,"d":"2.0"},92,0.3,4.2,72,6,2.2,60,4,{"v":1,"d":"1.0"},77,3,2.7,83,4,3.3,81,2,3.1,65,2,1.5,84,1.5,3.4,97,1.5,4.7,74,3,2.4,87,0.3,3.7,83,3,3.3,70,5,{"v":2,"d":"2.0"},81,3,3.1,75,0.3,2.5,78,2,2.8,85,4,3.5,76,3,2.6,90,1,{"v":4,"d":"4.0"},81,0.3,3.1,{"v":104.79999999999998,"d":"104.8"},280.99,{"v":2.6812022900763366,"d":"2.68"}]
["201312201801002","陈杭萍",81,89,70,79,85,5,3.5,82,4,3.2,94,2,4.4,60,1,{"v":1,"d":"1.0"},81,2,3.1,85,0.3,3.5,75,2,2.5,84,4,3.4,79,4,2.9,84,1,3.4,79,4,2.9,86,2,3.6,82,3,3.2,82,0.3,3.2,82,2.5,3.2,83,4,3.3,83,1,3.3,78,2,2.8,84,2.5,3.4,62,4,1.2,70,5,{"v":2,"d":"2.0"},89,0.3,3.9,80,6,{"v":3,"d":"3.0"},72,4,2.2,79,3,2.9,76,4,2.6,84,2,3.4,83,2,3.3,87,1.5,3.7,83,1.5,3.3,82,3,3.2,89,0.3,3.9,88,3,3.8,81,5,3.1,71,3,2.1,82,0.3,3.2,77,2,2.7,90,4,{"v":4,"d":"4.0"},81,3,3.1,92,1,4.2,87,0.3,3.7,{"v":104.79999999999998,"d":"104.8"},315.61999999999995,{"v":3.0116412213740458,"d":"3.01"}]
["201312201801003","叶富城",80,60,76,80,68,5,1.8,76,4,2.6,89,2,3.9,60,1,{"v":1,"d":"1.0"},78,2,2.8,81,0.3,3.1,75,2,2.5,65,4,1.5,73,4,2.3,83,1,3.3,70,4,{"v":2,"d":"2.0"},82,2,3.2,78,3,2.8,87,0.3,3.7,72,2.5,2.2,66,4,1.6,83,1,3.3,70,2,{"v":2,"d":"2.0"},79,2.5,2.9,78,4,2.8,75,5,2.5,92,0.3,4.2,84,6,3.4,66,4,1.6,60,3,{"v":1,"d":"1.0"},74,4,2.4,65,2,1.5,66,2,1.6,82,1.5,3.2,74,1.5,2.4,62,3,1.2,85,0.3,3.5,83,3,3.3,60,5,{"v":1,"d":"1.0"},80,3,{"v":3,"d":"3.0"},82,0.3,3.2,67,2,1.7,65,4,1.5,72,3,2.2,86,1,3.6,84,0.3,3.4,{"v":104.79999999999998,"d":"104.8"},237.68000000000004,{"v":2.2679389312977105,"d":"2.27"}]
["201312201801004","陈怡心",75,76,75,83,74,5,2.4,90,4,{"v":4,"d":"4.0"},90,2,{"v":4,"d":"4.0"},60,1,{"v":1,"d":"1.0"},70,2,{"v":2,"d":"2.0"},88,0.3,3.8,76,2,2.6,72,4,2.2,77,4,2.7,86,1,3.6,73,4,2.3,82,2,3.2,90,3,{"v":4,"d":"4.0"},87,0.3,3.7,81,2.5,3.1,88,4,3.8,94,1,4.4,79,2,2.9,78,2.5,2.8,72,4,2.2,78,5,2.8,89,0.3,3.9,90,6,{"v":4,"d":"4.0"},78,4,2.8,71,3,2.1,85,4,3.5,77,2,2.7,83,2,3.3,88,1.5,3.8,89,1.5,3.9,90,3,{"v":4,"d":"4.0"},91,0.3,4.1,87,3,3.7,75,5,2.5,83,3,3.3,86,0.3,3.6,90,2,{"v":4,"d":"4.0"},84,4,3.4,77,3,2.7,94,1,4.4,87,0.3,3.7,{"v":104.79999999999998,"d":"104.8"},325.44,{"v":3.105343511450382,"d":"3.11"}]
["201312201801005","边莉娜",76,77,77,87,96,5,4.6,88,4,3.8,85,2,3.5,60,1,{"v":1,"d":"1.0"},77,2,2.7,88,0.3,3.8,81,2,3.1,96,4,4.6,99,4,4.9,83,1,3.3,85,4,3.5,91,2,4.1,82,3,3.2,91,0.3,4.1,93,2.5,4.3,96,4,4.6,92,1,4.2,76,2,2.6,86,2.5,3.6,92,4,4.2,94,5,4.4,90,0.3,{"v":4,"d":"4.0"},83,6,3.3,84,4,3.4,84,3,3.4,92,4,4.2,91,2,4.1,85,2,3.5,87,1.5,3.7,95,1.5,4.5,89,3,3.9,88,0.3,3.8,95,3,4.5,94,5,4.4,98,3,4.8,87,0.3,3.7,84,2,3.4,84,4,3.4,84,3,3.4,90,1,{"v":4,"d":"4.0"},85,0.3,3.5,{"v":104.79999999999998,"d":"104.8"},408.21999999999997,{"v":3.895229007633588,"d":"3.90"}]
["201312201801006","孙兴华",76,71,66,69,66,5,1.6,60,4,{"v":1,"d":"1.0"},80,2,{"v":3,"d":"3.0"},60,1,{"v":1,"d":"1.0"},70,2,{"v":2,"d":"2.0"},77,0.3,2.7,74,2,2.4,63,4,1.3,61,4,1.1,77,1,2.7,68,4,1.8,75,2,2.5,78,3,2.8,83,0.3,3.3,64,2.5,1.4,65,4,1.5,80,1,{"v":3,"d":"3.0"},70,2,{"v":2,"d":"2.0"},64,2.5,1.4,62,4,1.2,60,5,{"v":1,"d":"1.0"},79,0.3,2.9,76,6,2.6,57,4,{"v":0,"d":"0.0"},61,3,1.1,60,4,{"v":1,"d":"1.0"},66,2,1.6,76,2,2.6,83,1.5,3.3,69,1.5,1.9,82,3,3.2,88,0.3,3.8,80,3,{"v":3,"d":"3.0"},71,5,2.1,60,3,{"v":1,"d":"1.0"},79,0.3,2.9,61,2,1.1,60,4,{"v":1,"d":"1.0"},69,3,1.9,80,1,{"v":3,"d":"3.0"},82,0.3,3.2,{"v":104.79999999999998,"d":"104.8"},182.23999999999998,{"v":1.7389312977099238,"d":"1.74"}]
["201312201801007","吴金明",77,65,77,74,75,5,2.5,79,4,2.9,86,2,3.6,60,1,{"v":1,"d":"1.0"},64,2,1.4,78,0.3,2.8,71,2,2.1,60,4,{"v":1,"d":"1.0"},71,4,2.1,79,1,2.9,62,4,1.2,62,2,1.2,81,3,3.1,79,0.3,2.9,68,2.5,1.8,77,4,2.7,76,1,2.6,79,2,2.9,65,2.5,1.5,62,4,1.2,66,5,1.6,93,0.3,4.3,69,6,1.9,66,4,1.6,60,3,{"v":1,"d":"1.0"},76,4,2.6,70,2,{"v":2,"d":"2.0"},72,2,2.2,82,1.5,3.2,83,1.5,3.3,72,3,2.2,88,0.3,3.8,79,3,2.9,69,5,1.9,75,3,2.5,84,0.3,3.4,67,2,1.7,60,4,{"v":1,"d":"1.0"},82,3,3.2,86,1,3.6,80,0.3,{"v":3,"d":"3.0"},{"v":104.79999999999998,"d":"104.8"},219.66,{"v":2.095992366412214,"d":"2.10"}]
["201312201801008","周灵强",82,84,80,78,71,5,2.1,60,4,{"v":1,"d":"1.0"},78,2,2.8,60,1,{"v":1,"d":"1.0"},61,2,1.1,76,0.3,2.6,72,2,2.2,79,4,2.9,89,4,3.9,73,1,2.3,69,4,1.9,77,2,2.7,76,3,2.6,75,0.3,2.5,81,2.5,3.1,66,4,1.6,60,1,{"v":1,"d":"1.0"},76,2,2.6,77,2.5,2.7,86,4,3.6,76,5,2.6,97,0.3,4.7,76,6,2.6,76,4,2.6,68,3,1.8,71,4,2.1,87,2,3.7,86,2,3.6,82,1.5,3.2,81,1.5,3.1,88,3,3.8,82,0.3,3.2,81,3,3.1,76,5,2.6,65,3,1.5,85,0.3,3.5,69,2,1.9,72,4,2.2,68,3,1.8,77,1,2.7,81,0.3,3.1,{"v":104.79999999999998,"d":"104.8"},261.1300000000001,{"v":2.4916984732824443,"d":"2.49"}]
["201312201801009","杨寒",83,91,78,87,75,5,2.5,76,4,2.6,79,2,2.9,60,1,{"v":1,"d":"1.0"},74,2,2.4,76,0.3,2.6,67,2,1.7,60,4,{"v":1,"d":"1.0"},79,4,2.9,80,1,{"v":3,"d":"3.0"},74,4,2.4,75,2,2.5,78,3,2.8,78,0.3,2.8,78,2.5,2.8,72,4,2.2,67,1,1.7,73,2,2.3,75,2.5,2.5,88,4,3.8,75,5,2.5,93,0.3,4.3,80,6,{"v":3,"d":"3.0"},66,4,1.6,68,3,1.8,77,4,2.7,85,2,3.5,81,2,3.1,82,1.5,3.2,94,1.5,4.4,76,3,2.6,80,0.3,{"v":3,"d":"3.0"},84,3,3.4,82,5,3.2,64,3,1.4,85,0.3,3.5,79,2,2.9,60,4,{"v":1,"d":"1.0"},76,3,2.6,89,1,3.9,85,0.3,3.5,{"v":104.79999999999998,"d":"104.8"},266.36,{"v":2.541603053435115,"d":"2.54"}]
["201312201801010","陈林",75,60,74,69,72,5,2.2,77,4,2.7,83,2,3.3,60,1,{"v":1,"d":"1.0"},62,2,1.2,76,0.3,2.6,70,2,{"v":2,"d":"2.0"},68,4,1.8,68,4,1.8,80,1,{"v":3,"d":"3.0"},63,4,1.3,69,2,1.9,81,3,3.1,77,0.3,2.7,78,2.5,2.8,74,4,2.4,81,1,3.1,76,2,2.6,68,2.5,1.8,66,4,1.6,74,5,2.4,72,0.3,2.2,78,6,2.8,65,4,1.5,63,3,1.3,75,4,2.5,70,2,{"v":2,"d":"2.0"},66,2,1.6,82,1.5,3.2,89,1.5,3.9,84,3,3.4,85,0.3,3.5,79,3,2.9,67,5,1.7,63,3,1.3,81,0.3,3.1,68,2,1.8,65,4,1.5,72,3,2.2,78,1,2.8,86,0.3,3.6,{"v":104.79999999999998,"d":"104.8"},229.46,{"v":2.1895038167938936,"d":"2.19"}]
["201312201801012","梁春燕",83,82,84,79,91,5,4.1,84,4,3.4,91,2,4.1,60,1,{"v":1,"d":"1.0"},75,2,2.5,89,0.3,3.9,82,2,3.2,93,4,4.3,92,4,4.2,83,1,3.3,74,4,2.4,94,2,4.4,90,3,{"v":4,"d":"4.0"},91,0.3,4.1,82,2.5,3.2,94,4,4.4,86,1,3.6,86,2,3.6,83,2.5,3.3,74,4,2.4,79,5,2.9,89,0.3,3.9,83,6,3.3,78,4,2.8,82,3,3.2,82,4,3.2,80,2,{"v":3,"d":"3.0"},73,2,2.3,85,1.5,3.5,90,1.5,{"v":4,"d":"4.0"},86,3,3.6,89,0.3,3.9,93,3,4.3,80,5,{"v":3,"d":"3.0"},84,3,3.4,86,0.3,3.6,89,2,3.9,88,4,3.8,88,3,3.8,94,1,4.4,92,0.3,4.2,{"v":104.79999999999998,"d":"104.8"},361.17999999999984,{"v":3.4463740458015257,"d":"3.45"}]
["201312201801013","宋小康",81,78,81,86,72,5,2.2,76,4,2.6,91,2,4.1,60,1,{"v":1,"d":"1.0"},61,2,1.1,87,0.3,3.7,70,2,{"v":2,"d":"2.0"},62,4,1.2,67,4,1.7,80,1,{"v":3,"d":"3.0"},66,4,1.6,74,2,2.4,84,3,3.4,73,0.3,2.3,64,2.5,1.4,60,4,{"v":1,"d":"1.0"},90,1,{"v":4,"d":"4.0"},66,2,1.6,75,2.5,2.5,72,4,2.2,67,5,1.7,91,0.3,4.1,77,6,2.7,69,4,1.9,60,3,{"v":1,"d":"1.0"},68,4,1.8,64,2,1.4,63,2,1.3,79,1.5,2.9,81,1.5,3.1,77,3,2.7,89,0.3,3.9,71,3,2.1,64,5,1.4,64,3,1.4,85,0.3,3.5,73,2,2.3,55,4,{"v":0,"d":"0.0"},71,3,2.1,86,1,3.6,85,0.3,3.5,{"v":104.79999999999998,"d":"104.8"},205.84999999999997,{"v":1.9642175572519085,"d":"1.96"}]
["201312201801014","高婷婷",75,83,78,77,80,5,{"v":3,"d":"3.0"},78,4,2.8,97,2,4.7,60,1,{"v":1,"d":"1.0"},66,2,1.6,90,0.3,{"v":4,"d":"4.0"},81,2,3.1,79,4,2.9,69,4,1.9,84,1,3.4,64,4,1.4,84,2,3.4,82,3,3.2,85,0.3,3.5,73,2.5,2.3,69,4,1.9,86,1,3.6,82,2,3.2,76,2.5,2.6,64,4,1.4,74,5,2.4,89,0.3,3.9,74,6,2.4,60,4,{"v":1,"d":"1.0"},68,3,1.8,76,4,2.6,72,2,2.2,91,2,4.1,89,1.5,3.9,86,1.5,3.6,88,3,3.8,89,0.3,3.9,88,3,3.8,73,5,2.3,81,3,3.1,84,0.3,3.4,74,2,2.4,75,4,2.5,83,3,3.3,95,1,4.5,87,0.3,3.7,{"v":104.79999999999998,"d":"104.8"},275.62,{"v":2.629961832061069,"d":"2.63"}]
["201312201801015","贺妙星",84,81,85,86,79,5,2.9,60,4,{"v":1,"d":"1.0"},95,2,4.5,60,1,{"v":1,"d":"1.0"},77,2,2.7,88,0.3,3.8,80,2,{"v":3,"d":"3.0"},87,4,3.7,69,4,1.9,83,1,3.3,60,4,{"v":1,"d":"1.0"},82,2,3.2,87,3,3.7,84,0.3,3.4,73,2.5,2.3,61,4,1.1,83,1,3.3,79,2,2.9,81,2.5,3.1,74,4,2.4,74,5,2.4,92,0.3,4.2,81,6,3.1,96,4,4.6,77,3,2.7,76,4,2.6,80,2,{"v":3,"d":"3.0"},78,2,2.8,82,1.5,3.2,92,1.5,4.2,76,3,2.6,90,0.3,{"v":4,"d":"4.0"},94,3,4.4,74,5,2.4,86,3,3.6,85,0.3,3.5,81,2,3.1,85,4,3.5,74,3,2.4,92,1,4.2,90,0.3,{"v":4,"d":"4.0"},{"v":104.79999999999998,"d":"104.8"},296.16999999999996,{"v":2.826049618320611,"d":"2.83"}]
["201312201801016","洪峰",77,72,68,88,63,5,1.3,62,4,1.2,89,2,3.9,60,1,{"v":1,"d":"1.0"},72,2,2.2,90,0.3,{"v":4,"d":"4.0"},87,2,3.7,75,4,2.5,71,4,2.1,77,1,2.7,62,4,1.2,73,2,2.3,80,3,{"v":3,"d":"3.0"},87,0.3,3.7,68,2.5,1.8,61,4,1.1,91,1,4.1,73,2,2.3,74,2.5,2.4,72,4,2.2,65,5,1.5,94,0.3,4.4,77,6,2.7,62,4,1.2,56,3,{"v":0,"d":"0.0"},71,4,2.1,60,2,{"v":1,"d":"1.0"},80,2,{"v":3,"d":"3.0"},82,1.5,3.2,82,1.5,3.2,74,3,2.4,87,0.3,3.7,82,3,3.2,64,5,1.4,68,3,1.8,83,0.3,3.3,72,2,2.2,51,4,{"v":0,"d":"0.0"},71,3,2.1,72,1,2.2,85,0.3,3.5,{"v":104.79999999999998,"d":"104.8"},207.18000000000006,{"v":1.9769083969465657,"d":"1.98"}]
["201312201801017","刘婧",79,80,66,70,70,5,{"v":2,"d":"2.0"},83,4,3.3,87,2,3.7,60,1,{"v":1,"d":"1.0"},74,2,2.4,88,0.3,3.8,80,2,{"v":3,"d":"3.0"},88,4,3.8,82,4,3.2,82,1,3.2,80,4,{"v":3,"d":"3.0"},79,2,2.9,82,3,3.2,87,0.3,3.7,72,2.5,2.2,69,4,1.9,83,1,3.3,78,2,2.8,79,2.5,2.9,86,4,3.6,72,5,2.2,94,0.3,4.4,79,6,2.9,81,4,3.1,60,3,{"v":1,"d":"1.0"},78,4,2.8,61,2,1.1,74,2,2.4,77,1.5,2.7,78,1.5,2.8,86,3,3.6,80,0.3,{"v":3,"d":"3.0"},66,3,1.6,67,5,1.7,74,3,2.4,81,0.3,3.1,73,2,2.3,76,4,2.6,76,3,2.6,92,1,4.2,91,0.3,4.1,{"v":104.79999999999998,"d":"104.8"},279.83,{"v":2.67013358778626,"d":"2.67"}]
["201312201801019","金光美",79,82,74,86,77,5,2.7,69,4,1.9,90,2,{"v":4,"d":"4.0"},60,1,{"v":1,"d":"1.0"},67,2,1.7,90,0.3,{"v":4,"d":"4.0"},83,2,3.3,86,4,3.6,76,4,2.6,79,1,2.9,68,4,1.8,92,2,4.2,81,3,3.1,90,0.3,{"v":4,"d":"4.0"},84,2.5,3.4,67,4,1.7,88,1,3.8,78,2,2.8,83,2.5,3.3,81,4,3.1,70,5,{"v":2,"d":"2.0"},92,0.3,4.2,81,6,3.1,60,4,{"v":1,"d":"1.0"},82,3,3.2,70,4,{"v":2,"d":"2.0"},80,2,{"v":3,"d":"3.0"},79,2,2.9,80,1.5,{"v":3,"d":"3.0"},89,1.5,3.9,80,3,{"v":3,"d":"3.0"},88,0.3,3.8,91,3,4.1,84,5,3.4,69,3,1.9,82,0.3,3.2,73,2,2.3,79,4,2.9,86,3,3.6,92,1,4.2,85,0.3,3.5,{"v":104.79999999999998,"d":"104.8"},292.41,{"v":2.7901717557251917,"d":"2.79"}]
["201312201801020","王泓华",77,81,69,87,69,5,1.9,73,4,2.3,92,2,4.2,60,1,{"v":1,"d":"1.0"},71,2,2.1,93,0.3,4.3,81,2,3.1,77,4,2.7,90,4,{"v":4,"d":"4.0"},83,1,3.3,77,4,2.7,82,2,3.2,84,3,3.4,88,0.3,3.8,76,2.5,2.6,85,4,3.5,88,1,3.8,74,2,2.4,80,2.5,{"v":3,"d":"3.0"},70,4,{"v":2,"d":"2.0"},69,5,1.9,94,0.3,4.4,78,6,2.8,71,4,2.1,69,3,1.9,78,4,2.8,81,2,3.1,86,2,3.6,86,1.5,3.6,95,1.5,4.5,76,3,2.6,91,0.3,4.1,94,3,4.4,84,5,3.4,79,3,2.9,83,0.3,3.3,80,2,{"v":3,"d":"3.0"},85,4,3.5,83,3,3.3,89,1,3.9,86,0.3,3.6,{"v":104.79999999999998,"d":"104.8"},305.29999999999984,{"v":2.9131679389312968,"d":"2.91"}]
["201312201802001","余振",78,85,62,78,80,5,{"v":3,"d":"3.0"},77,4,2.7,84,2,3.4,60,1,{"v":1,"d":"1.0"},73,2,2.3,82,0.3,3.2,72,2,2.2,75,4,2.5,85,4,3.5,83,1,3.3,67,4,1.7,91,2,4.1,81,3,3.1,80,0.3,{"v":3,"d":"3.0"},88,2.5,3.8,87,4,3.7,83,1,3.3,78,2,2.8,82,2.5,3.2,82,4,3.2,80,5,{"v":3,"d":"3.0"},84,0.3,3.4,80,6,{"v":3,"d":"3.0"},65,4,1.5,74,3,2.4,78,4,2.8,80,2,{"v":3,"d":"3.0"},88,2,3.8,85,1.5,3.5,97,1.5,4.7,80,3,{"v":3,"d":"3.0"},90,0.3,{"v":4,"d":"4.0"},87,3,3.7,78,5,2.8,86,3,3.6,85,0.3,3.5,83,2,3.3,83,4,3.3,82,3,3.2,91,1,4.1,75,0.3,2.5,{"v":104.79999999999998,"d":"104.8"},315.78000000000003,{"v":3.0131679389312986,"d":"3.01"}]
["201312201802002","周展羽",85,86,91,74,67,5,1.7,61,4,1.1,76,2,2.6,60,1,{"v":1,"d":"1.0"},73,2,2.3,80,0.3,{"v":3,"d":"3.0"},74,2,2.4,67,4,1.7,96,4,4.6,76,1,2.6,60,4,{"v":1,"d":"1.0"},77,2,2.7,81,3,3.1,74,0.3,2.4,73,2.5,2.3,81,4,3.1,83,1,3.3,74,2,2.4,83,2.5,3.3,60,4,{"v":1,"d":"1.0"},81,5,3.1,88,0.3,3.8,65,6,1.5,60,4,{"v":1,"d":"1.0"},68,3,1.8,63,4,1.3,71,2,2.1,81,2,3.1,82,1.5,3.2,80,1.5,{"v":3,"d":"3.0"},60,3,{"v":1,"d":"1.0"},83,0.3,3.3,82,3,3.2,71,5,2.1,76,3,2.6,77,0.3,2.7,77,2,2.7,73,4,2.3,62,3,1.2,82,1,3.2,74,0.3,2.4,{"v":104.79999999999998,"d":"104.8"},229.87999999999997,{"v":2.1935114503816795,"d":"2.19"}]
["201312201802003","张姁",83,88,92,95,83,5,3.3,82,4,3.2,93,2,4.3,60,1,{"v":1,"d":"1.0"},63,2,1.3,92,0.3,4.2,80,2,{"v":3,"d":"3.0"},85,4,3.5,84,4,3.4,86,1,3.6,64,4,1.4,85,2,3.5,86,3,3.6,89,0.3,3.9,65,2.5,1.5,76,4,2.6,91,1,4.1,80,2,{"v":3,"d":"3.0"},82,2.5,3.2,64,4,1.4,81,5,3.1,84,0.3,3.4,83,6,3.3,60,4,{"v":1,"d":"1.0"},80,3,{"v":3,"d":"3.0"},69,4,1.9,90,2,{"v":4,"d":"4.0"},70,2,{"v":2,"d":"2.0"},92,1.5,4.2,95,1.5,4.5,83,3,3.3,92,0.3,4.2,95,3,4.5,87,5,3.7,92,3,4.2,87,0.3,3.7,96,2,4.6,94,4,4.4,88,3,3.8,95,1,4.5,86,0.3,3.6,{"v":104.79999999999998,"d":"104.8"},325,{"v":3.1011450381679393,"d":"3.10"}]
["201312201802004","杨明",69,60,60,68,82,5,3.2,77,4,2.7,90,2,{"v":4,"d":"4.0"},60,1,{"v":1,"d":"1.0"},77,2,2.7,87,0.3,3.7,72,2,2.2,84,4,3.4,94,4,4.4,83,1,3.3,71,4,2.1,84,2,3.4,81,3,3.1,80,0.3,{"v":3,"d":"3.0"},87,2.5,3.7,92,4,4.2,86,1,3.6,83,2,3.3,81,2.5,3.1,60,4,{"v":1,"d":"1.0"},81,5,3.1,90,0.3,{"v":4,"d":"4.0"},83,6,3.3,68,4,1.8,72,3,2.2,63,4,1.3,74,2,2.4,87,2,3.7,88,1.5,3.8,95,1.5,4.5,78,3,2.8,89,0.3,3.9,81,3,3.1,77,5,2.7,84,3,3.4,82,0.3,3.2,80,2,{"v":3,"d":"3.0"},81,4,3.1,78,3,2.8,91,1,4.1,82,0.3,3.2,{"v":104.79999999999998,"d":"104.8"},310.14999999999986,{"v":2.9594465648854955,"d":"2.96"}]
["201312201802005","冯迪",79,72,77,83,86,5,3.6,82,4,3.2,91,2,4.1,60,1,{"v":1,"d":"1.0"},69,2,1.9,83,0.3,3.3,76,2,2.6,89,4,3.9,88,4,3.8,83,1,3.3,64,4,1.4,90,2,{"v":4,"d":"4.0"},82,3,3.2,82,0.3,3.2,86,2.5,3.6,95,4,4.5,88,1,3.8,82,2,3.2,87,2.5,3.7,80,4,{"v":3,"d":"3.0"},88,5,3.8,83,0.3,3.3,89,6,3.9,72,4,2.2,93,3,4.3,81,4,3.1,97,2,4.7,85,2,3.5,89,1.5,3.9,91,1.5,4.1,79,3,2.9,85,0.3,3.5,93,3,4.3,84,5,3.4,84,3,3.4,82,0.3,3.2,93,2,4.3,96,4,4.6,81,3,3.1,91,1,4.1,82,0.3,3.2,{"v":104.79999999999998,"d":"104.8"},364.76,{"v":3.480534351145039,"d":"3.48"}]
["201312201802006","张则一",75,96,69,78,76,5,2.6,71,4,2.1,85,2,3.5,60,1,{"v":1,"d":"1.0"},67,2,1.7,83,0.3,3.3,67,2,1.7,79,4,2.9,79,4,2.9,83,1,3.3,67,4,1.7,91,2,4.1,79,3,2.9,85,0.3,3.5,77,2.5,2.7,69,4,1.9,65,1,1.5,73,2,2.3,82,2.5,3.2,83,4,3.3,82,5,3.2,83,0.3,3.3,77,6,2.7,64,4,1.4,81,3,3.1,73,4,2.3,86,2,3.6,78,2,2.8,85,1.5,3.5,79,1.5,2.9,71,3,2.1,85,0.3,3.5,82,3,3.2,76,5,2.6,80,3,{"v":3,"d":"3.0"},84,0.3,3.4,79,2,2.9,67,4,1.7,71,3,2.1,90,1,{"v":4,"d":"4.0"},81,0.3,3.1,{"v":104.79999999999998,"d":"104.8"},273.58,{"v":2.610496183206107,"d":"2.61"}]
["201312201802007","钱丽莎",79,65,69,69,75,5,2.5,89,4,3.9,92,2,4.2,60,1,{"v":1,"d":"1.0"},76,2,2.6,92,0.3,4.2,80,2,{"v":3,"d":"3.0"},87,4,3.7,85,4,3.5,83,1,3.3,87,4,3.7,87,2,3.7,86,3,3.6,88,0.3,3.8,78,2.5,2.8,82,4,3.2,85,1,3.5,84,2,3.4,80,2.5,{"v":3,"d":"3.0"},87,4,3.7,82,5,3.2,90,0.3,{"v":4,"d":"4.0"},82,6,3.2,83,4,3.3,82,3,3.2,91,4,4.1,70,2,{"v":2,"d":"2.0"},82,2,3.2,86,1.5,3.6,84,1.5,3.4,76,3,2.6,88,0.3,3.8,86,3,3.6,70,5,{"v":2,"d":"2.0"},74,3,2.4,80,0.3,{"v":3,"d":"3.0"},81,2,3.1,75,4,2.5,80,3,{"v":3,"d":"3.0"},94,1,4.4,87,0.3,3.7,{"v":104.79999999999998,"d":"104.8"},333.65,{"v":3.1836832061068705,"d":"3.18"}]
["201312201802008","沈霖",77,84,73,87,74,5,2.4,75,4,2.5,88,2,3.8,60,1,{"v":1,"d":"1.0"},72,2,2.2,85,0.3,3.5,74,2,2.4,60,4,{"v":1,"d":"1.0"},74,4,2.4,82,1,3.2,68,4,1.8,68,2,1.8,82,3,3.2,79,0.3,2.9,64,2.5,1.4,61,4,1.1,80,1,{"v":3,"d":"3.0"},79,2,2.9,78,2.5,2.8,80,4,{"v":3,"d":"3.0"},80,5,{"v":3,"d":"3.0"},82,0.3,3.2,77,6,2.7,62,4,1.2,74,3,2.4,73,4,2.3,67,2,1.7,78,2,2.8,87,1.5,3.7,84,1.5,3.4,60,3,{"v":1,"d":"1.0"},89,0.3,3.9,76,3,2.6,60,5,{"v":1,"d":"1.0"},69,3,1.9,78,0.3,2.8,80,2,{"v":3,"d":"3.0"},73,4,2.3,82,3,3.2,88,1,3.8,77,0.3,2.7,{"v":104.79999999999998,"d":"104.8"},240.55,{"v":2.2953244274809164,"d":"2.30"}]
["201312201802009","徐樟燕",75,86,74,91,91,5,4.1,87,4,3.7,93,2,4.3,60,1,{"v":1,"d":"1.0"},83,2,3.3,88,0.3,3.8,80,2,{"v":3,"d":"3.0"},94,4,4.4,94,4,4.4,82,1,3.2,83,4,3.3,95,2,4.5,83,3,3.3,89,0.3,3.9,93,2.5,4.3,90,4,{"v":4,"d":"4.0"},90,1,{"v":4,"d":"4.0"},80,2,{"v":3,"d":"3.0"},91,2.5,4.1,89,4,3.9,86,5,3.6,87,0.3,3.7,84,6,3.4,69,4,1.9,92,3,4.2,84,4,3.4,70,2,{"v":2,"d":"2.0"},88,2,3.8,92,1.5,4.2,96,1.5,4.6,84,3,3.4,88,0.3,3.8,89,3,3.9,88,5,3.8,79,3,2.9,89,0.3,3.9,85,2,3.5,90,4,{"v":4,"d":"4.0"},89,3,3.9,94,1,4.4,85,0.3,3.5,{"v":104.79999999999998,"d":"104.8"},383.08,{"v":3.6553435114503823,"d":"3.66"}]
["201312201802010","雷美玲",81,89,76,92,74,5,2.4,83,4,3.3,92,2,4.2,60,1,{"v":1,"d":"1.0"},73,2,2.3,88,0.3,3.8,84,2,3.4,93,4,4.3,86,4,3.6,86,1,3.6,72,4,2.2,95,2,4.5,88,3,3.8,91,0.3,4.1,88,2.5,3.8,85,4,3.5,86,1,3.6,88,2,3.8,84,2.5,3.4,70,4,{"v":2,"d":"2.0"},83,5,3.3,87,0.3,3.7,84,6,3.4,72,4,2.2,82,3,3.2,81,4,3.1,82,2,3.2,89,2,3.9,88,1.5,3.8,89,1.5,3.9,81,3,3.1,87,0.3,3.7,96,3,4.6,85,5,3.5,83,3,3.3,87,0.3,3.7,78,2,2.8,89,4,3.9,80,3,{"v":3,"d":"3.0"},95,1,4.5,86,0.3,3.6,{"v":104.79999999999998,"d":"104.8"},347.0300000000001,{"v":3.3113549618320626,"d":"3.31"}]
["201312201802012","徐梦南",78,83,80,90,75,5,2.5,74,4,2.4,91,2,4.1,60,1,{"v":1,"d":"1.0"},66,2,1.6,90,0.3,{"v":4,"d":"4.0"},84,2,3.4,80,4,{"v":3,"d":"3.0"},85,4,3.5,83,1,3.3,72,4,2.2,85,2,3.5,88,3,3.8,87,0.3,3.7,77,2.5,2.7,81,4,3.1,86,1,3.6,84,2,3.4,80,2.5,{"v":3,"d":"3.0"},61,4,1.1,63,5,1.3,85,0.3,3.5,78,6,2.8,71,4,2.1,69,3,1.9,81,4,3.1,73,2,2.3,64,2,1.4,84,1.5,3.4,83,1.5,3.3,82,3,3.2,90,0.3,{"v":4,"d":"4.0"},80,3,{"v":3,"d":"3.0"},61,5,1.1,77,3,2.7,87,0.3,3.7,77,2,2.7,78,4,2.8,74,3,2.4,91,1,4.1,84,0.3,3.4,{"v":104.79999999999998,"d":"104.8"},273.29,{"v":2.6077290076335884,"d":"2.61"}]
["201312201802013","王振江",77,70,72,84,70,5,{"v":2,"d":"2.0"},66,4,1.6,84,2,3.4,60,1,{"v":1,"d":"1.0"},60,2,{"v":1,"d":"1.0"},87,0.3,3.7,72,2,2.2,60,4,{"v":1,"d":"1.0"},72,4,2.2,83,1,3.3,63,4,1.3,81,2,3.1,79,3,2.9,81,0.3,3.1,60,2.5,{"v":1,"d":"1.0"},62,4,1.2,85,1,3.5,69,2,1.9,71,2.5,2.1,68,4,1.8,60,5,{"v":1,"d":"1.0"},87,0.3,3.7,82,6,3.2,60,4,{"v":1,"d":"1.0"},60,3,{"v":1,"d":"1.0"},70,4,{"v":2,"d":"2.0"},60,2,{"v":1,"d":"1.0"},60,2,{"v":1,"d":"1.0"},83,1.5,3.3,79,1.5,2.9,80,3,{"v":3,"d":"3.0"},87,0.3,3.7,77,3,2.7,60,5,{"v":1,"d":"1.0"},60,3,{"v":1,"d":"1.0"},84,0.3,3.4,63,2,1.3,65,4,1.5,80,3,{"v":3,"d":"3.0"},93,1,4.3,84,0.3,3.4,{"v":104.79999999999998,"d":"104.8"},199.65000000000003,{"v":1.9050572519083975,"d":"1.91"}]
["201312201802014","畅健钢",83,76,71,84,84,5,3.4,64,4,1.4,88,2,3.8,60,1,{"v":1,"d":"1.0"},62,2,1.2,89,0.3,3.9,81,2,3.1,80,4,{"v":3,"d":"3.0"},71,4,2.1,86,1,3.6,60,4,{"v":1,"d":"1.0"},67,2,1.7,81,3,3.1,79,0.3,2.9,73,2.5,2.3,90,4,{"v":4,"d":"4.0"},83,1,3.3,79,2,2.9,86,2.5,3.6,81,4,3.1,81,5,3.1,85,0.3,3.5,83,6,3.3,60,4,{"v":1,"d":"1.0"},67,3,1.7,71,4,2.1,78,2,2.8,82,2,3.2,84,1.5,3.4,86,1.5,3.6,76,3,2.6,86,0.3,3.6,84,3,3.4,66,5,1.6,79,3,2.9,85,0.3,3.5,77,2,2.7,66,4,1.6,71,3,2.1,86,1,3.6,83,0.3,3.3,{"v":104.79999999999998,"d":"104.8"},270.66,{"v":2.58263358778626,"d":"2.58"}]
["201312201802015","严朝阳",76,66,73,81,70,5,{"v":2,"d":"2.0"},65,4,1.5,96,2,4.6,60,1,{"v":1,"d":"1.0"},61,2,1.1,85,0.3,3.5,85,2,3.5,65,4,1.5,86,4,3.6,83,1,3.3,60,4,{"v":1,"d":"1.0"},90,2,{"v":4,"d":"4.0"},88,3,3.8,87,0.3,3.7,64,2.5,1.4,71,4,2.1,86,1,3.6,76,2,2.6,64,2.5,1.4,74,4,2.4,65,5,1.5,87,0.3,3.7,80,6,{"v":3,"d":"3.0"},63,4,1.3,60,3,{"v":1,"d":"1.0"},62,4,1.2,60,2,{"v":1,"d":"1.0"},74,2,2.4,83,1.5,3.3,62,1.5,1.2,70,3,{"v":2,"d":"2.0"},90,0.3,{"v":4,"d":"4.0"},72,3,2.2,60,5,{"v":1,"d":"1.0"},73,3,2.3,83,0.3,3.3,69,2,1.9,72,4,2.2,72,3,2.2,87,1,3.7,88,0.3,3.8,{"v":104.79999999999998,"d":"104.8"},222.35,{"v":2.1216603053435117,"d":"2.12"}]
["201312201802016","陈梦静",80,80,64,80,60,5,{"v":1,"d":"1.0"},73,4,2.3,90,2,{"v":4,"d":"4.0"},60,1,{"v":1,"d":"1.0"},67,2,1.7,89,0.3,3.9,80,2,{"v":3,"d":"3.0"},81,4,3.1,78,4,2.8,82,1,3.2,69,4,1.9,75,2,2.5,79,3,2.9,92,0.3,4.2,70,2.5,{"v":2,"d":"2.0"},64,4,1.4,76,1,2.6,73,2,2.3,77,2.5,2.7,78,4,2.8,68,5,1.8,88,0.3,3.8,82,6,3.2,67,4,1.7,60,3,{"v":1,"d":"1.0"},69,4,1.9,65,2,1.5,67,2,1.7,84,1.5,3.4,73,1.5,2.3,78,3,2.8,89,0.3,3.9,78,3,2.8,74,5,2.4,76,3,2.6,80,0.3,{"v":3,"d":"3.0"},75,2,2.5,71,4,2.1,66,3,1.6,91,1,4.1,82,0.3,3.2,{"v":104.79999999999998,"d":"104.8"},242.5,{"v":2.313931297709924,"d":"2.31"}]
["201312201802017","张琳琳",77,94,76,81,89,5,3.9,85,4,3.5,93,2,4.3,60,1,{"v":1,"d":"1.0"},87,2,3.7,89,0.3,3.9,83,2,3.3,90,4,{"v":4,"d":"4.0"},92,4,4.2,83,1,3.3,71,4,2.1,94,2,4.4,86,3,3.6,95,0.3,4.5,88,2.5,3.8,89,4,3.9,86,1,3.6,81,2,3.1,80,2.5,{"v":3,"d":"3.0"},70,4,{"v":2,"d":"2.0"},77,5,2.7,85,0.3,3.5,80,6,{"v":3,"d":"3.0"},65,4,1.5,79,3,2.9,78,4,2.8,76,2,2.6,70,2,{"v":2,"d":"2.0"},85,1.5,3.5,94,1.5,4.4,86,3,3.6,92,0.3,4.2,89,3,3.9,75,5,2.5,94,3,4.4,90,0.3,{"v":4,"d":"4.0"},84,2,3.4,87,4,3.7,78,3,2.8,92,1,4.2,94,0.3,4.4,{"v":104.79999999999998,"d":"104.8"},339.7999999999999,{"v":3.24236641221374,"d":"3.24"}]
["201312201802018","秦苗苗",84,76,83,89,80,5,{"v":3,"d":"3.0"},81,4,3.1,92,2,4.2,60,1,{"v":1,"d":"1.0"},67,2,1.7,87,0.3,3.7,80,2,{"v":3,"d":"3.0"},87,4,3.7,81,4,3.1,83,1,3.3,78,4,2.8,90,2,{"v":4,"d":"4.0"},85,3,3.5,89,0.3,3.9,81,2.5,3.1,63,4,1.3,83,1,3.3,83,2,3.3,74,2.5,2.4,83,4,3.3,72,5,2.2,92,0.3,4.2,82,6,3.2,77,4,2.7,73,3,2.3,82,4,3.2,72,2,2.2,91,2,4.1,87,1.5,3.7,95,1.5,4.5,70,3,{"v":2,"d":"2.0"},92,0.3,4.2,96,3,4.6,81,5,3.1,86,3,3.6,87,0.3,3.7,82,2,3.2,90,4,{"v":4,"d":"4.0"},87,3,3.7,88,1,3.8,88,0.3,3.8,{"v":104.79999999999998,"d":"104.8"},324.50000000000006,{"v":3.096374045801528,"d":"3.10"}]
["201312201802019","任艳丽",87,84,83,86,83,5,3.3,71,4,2.1,94,2,4.4,60,1,{"v":1,"d":"1.0"},76,2,2.6,90,0.3,{"v":4,"d":"4.0"},81,2,3.1,77,4,2.7,85,4,3.5,80,1,{"v":3,"d":"3.0"},63,4,1.3,87,2,3.7,81,3,3.1,96,0.3,4.6,76,2.5,2.6,68,4,1.8,86,1,3.6,76,2,2.6,72,2.5,2.2,62,4,1.2,63,5,1.3,92,0.3,4.2,71,6,2.1,60,4,{"v":1,"d":"1.0"},78,3,2.8,67,4,1.7,73,2,2.3,63,2,1.3,85,1.5,3.5,81,1.5,3.1,66,3,1.6,86,0.3,3.6,93,3,4.3,69,5,1.9,72,3,2.2,83,0.3,3.3,75,2,2.5,79,4,2.9,87,3,3.7,93,1,4.3,82,0.3,3.2,{"v":104.79999999999998,"d":"104.8"},256.67,{"v":2.449141221374046,"d":"2.45"}]
["201312201802020","朱智刚",70,60,62,69,67,5,1.7,60,4,{"v":1,"d":"1.0"},86,2,3.6,60,1,{"v":1,"d":"1.0"},62,2,1.2,72,0.3,2.2,73,2,2.3,83.5,4,{"v":3.35,"d":"3.4"},60,4,{"v":1,"d":"1.0"},74,1,2.4,63,4,1.3,67,2,1.7,80,3,{"v":3,"d":"3.0"},73,0.3,2.3,60,2.5,{"v":1,"d":"1.0"},47,4,{"v":0,"d":"0.0"},91,1,4.1,66,2,1.6,67,2.5,1.7,62,4,1.2,60,5,{"v":1,"d":"1.0"},87,0.3,3.7,76,6,2.6,60,4,{"v":1,"d":"1.0"},60,3,{"v":1,"d":"1.0"},67,4,1.7,73,2,2.3,67,2,1.7,84,1.5,3.4,67,1.5,1.7,74,3,2.4,85,0.3,3.5,75,3,2.5,65,5,1.5,75,3,2.5,75,0.3,2.5,75,2,2.5,60,4,{"v":1,"d":"1.0"},68,3,1.8,74,1,2.4,83,0.3,3.3,{"v":104.79999999999998,"d":"104.8"},185.75,{"v":1.7724236641221376,"d":"1.77"}]

{"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]","学分","绩点","无机及分析化学 [5]","学分","绩点","大学英语（1） [4]","学分","绩点","思想道德修养与法律基础 [3]","学分","绩点","形势与政策 [.3]","学分","绩点","大学生心理健康教育 [2]","学分","绩点","高等数学 [3]","学分","绩点","大学生就业指导与创业教育 [1]","学分","绩点","大学英语（2） [4]","学分","绩点","军事理论课 [2]","学分","绩点","工程制图 [2]","学分","绩点","计算机文化基础 [4]","学分","绩点","中国近现代史纲要 [2]","学分","绩点","形势与政策 [.3]","学分","绩点","有机化学 [4]","学分","绩点","物理化学 [2.5]","学分","绩点","大学生就业与创业 [1]","学分","绩点","大学英语（3） [4]","学分","绩点","基础生物学 [3]","学分","绩点","电工技术基础 [2]","学分","绩点","现代仪器分析 [2]","学分","绩点","生物化学 [5]","学分","绩点","马克思主义基本原理概论 [3]","学分","绩点","形势与政策 [.3]","学分","绩点","大学英语（4） [4]","学分","绩点","药物合成反应 [1.5]","学分","绩点","基因工程 [3]","学分","绩点","基因工程实验 [1.5]","学分","绩点","化学制药实验 [1]","学分","绩点","形势与政策 [.3]","学分","绩点","毛泽东思想和中国特色社会主义理论体系 [6]","学分","绩点","大学生就业与创业 [1]","学分","绩点","生化工程 [5]","学分","绩点","化工原理 [5]","学分","绩点","工业微生物学 [4]","学分","绩点","形势与政策 [.3]","学分","绩点","制药工程 [2]","学分","绩点","细胞工程 [3]","学分","绩点","生物工艺学 [3.5]","学分","绩点","酶工程 [3]","学分","绩点","发酵工程实验 [1.5]","学分","绩点","形势与政策 [.3]","学分","绩点","总学分","总学分绩点","加权平均绩点"]
["201323202301008","周旭晨",68,87,77,90,95,3,4.5,78,5,2.8,82,4,3.2,88,3,3.8,85,0.3,3.5,87,2,3.7,78,3,2.8,93,1,4.3,78,4,2.8,93,2,4.3,96,2,4.6,87,4,3.7,89,2,3.9,94,0.3,4.4,91,4,4.1,87,2.5,3.7,96,1,4.6,67,4,1.7,81,3,3.1,79,2,2.9,85,2,3.5,84,5,3.4,82,3,3.2,99,0.3,4.9,76,4,2.6,80,1.5,{"v":3,"d":"3.0"},77,3,2.7,87,1.5,3.7,93,1,4.3,93,0.3,4.3,84,6,3.4,90,1,{"v":4,"d":"4.0"},87,5,3.7,81,5,3.1,90,4,{"v":4,"d":"4.0"},85,0.3,3.5,89,2,3.9,99,3,4.9,83,3.5,3.3,88,3,3.8,96,1.5,4.6,86,0.3,3.6,108.29999999999998,376.00999999999993,{"v":3.4719298245614034,"d":"3.47"}]

{"sheet":"必修课成绩排名","index":2,"n_rows":40,"n_cols":5,"rows_kept":40,"merged":[[0,0,0,4]],"flags":["formulas_cached_only"]}
["生命科学学院2017届制药工程专业（含生物工程专业1人）本部学生推荐免试攻读硕士研究生必修课成绩排名"]
["序号","学号","姓名","必修课加权平均绩点","成绩排名"]
[1,"201312201801005","边莉娜",{"v":3.895229007633588,"d":"3.90"},1]
[2,"201312201802009","徐樟燕",{"v":3.6553435114503823,"d":"3.66"},2]
[3,"201312201802005","冯迪",{"v":3.480534351145039,"d":"3.48"},3]
[4,"201323202301008","周旭晨",{"v":3.4719298245614034,"d":"3.47"},4]
[5,"201312201801012","梁春燕",{"v":3.4463740458015257,"d":"3.45"},5]
[6,"201312201802010","雷美玲",{"v":3.3113549618320626,"d":"3.31"},6]
[7,"201312201802017","张琳琳",{"v":3.24236641221374,"d":"3.24"},7]
[8,"201312201802007","钱丽莎",{"v":3.1836832061068705,"d":"3.18"},8]
[9,"201312201801004","陈怡心",{"v":3.105343511450382,"d":"3.11"},9]
[10,"201312201802003","张姁",{"v":3.1011450381679393,"d":"3.10"},10]
[11,"201312201802018","秦苗苗",{"v":3.096374045801528,"d":"3.10"},11]
[12,"201312201802001","余振",{"v":3.0131679389312986,"d":"3.01"},12]
[13,"201312201801002","陈杭萍",{"v":3.0116412213740458,"d":"3.01"},13]
[14,"201312201802004","杨明",{"v":2.9594465648854955,"d":"2.96"},14]
[15,"201312201801020","王泓华",{"v":2.9131679389312968,"d":"2.91"},15]
[16,"201312201801015","贺妙星",{"v":2.826049618320611,"d":"2.83"},16]
[17,"201312201801019","金光美",{"v":2.7901717557251917,"d":"2.79"},17]
[18,"201312201801001","陈杭茜",{"v":2.6812022900763366,"d":"2.68"},18]
[19,"201312201801017","刘婧",{"v":2.67013358778626,"d":"2.67"},19]
[20,"201312201801014","高婷婷",{"v":2.629961832061069,"d":"2.63"},20]
[21,"201312201802006","张则一",{"v":2.610496183206107,"d":"2.61"},21]
[22,"201312201802012","徐梦南",{"v":2.6077290076335884,"d":"2.61"},22]
[23,"201312201802014","畅健钢",{"v":2.58263358778626,"d":"2.58"},23]
[24,"201312201801009","杨寒",{"v":2.541603053435115,"d":"2.54"},24]
[25,"201312201801008","周灵强",{"v":2.4916984732824443,"d":"2.49"},25]
[26,"201312201802019","任艳丽",{"v":2.449141221374046,"d":"2.45"},26]
[27,"201312201802016","陈梦静",{"v":2.313931297709924,"d":"2.31"},27]
[28,"201312201802008","沈霖",{"v":2.2953244274809164,"d":"2.30"},28]
[29,"201312201801003","叶富城",{"v":2.2679389312977105,"d":"2.27"},29]
[30,"201312201802002","周展羽",{"v":2.1935114503816795,"d":"2.19"},30]
[31,"201312201801010","陈林",{"v":2.1895038167938936,"d":"2.19"},31]
[32,"201312201802015","严朝阳",{"v":2.1216603053435117,"d":"2.12"},32]
[33,"201312201801007","吴金明",{"v":2.095992366412214,"d":"2.10"},33]
[34,"201312201801016","洪峰",{"v":1.9769083969465657,"d":"1.98"},34]
[35,"201312201801013","宋小康",{"v":1.9642175572519085,"d":"1.96"},35]
[36,"201312201802013","王振江",{"v":1.9050572519083975,"d":"1.91"},36]
[37,"201312201802020","朱智刚",{"v":1.7724236641221376,"d":"1.77"},37]
[38,"201312201801006","孙兴华",{"v":1.7389312977099238,"d":"1.74"},38]

{"sheet":"资格审查","index":3,"n_rows":43,"n_cols":12,"rows_kept":43,"merged":[[0,0,0,11]],"flags":["formulas_cached_only"]}
["生命科学学院2017届制药工程（含生物工程1人）专业本部学生推荐免试攻读硕士研究生综合测评情况 "]
["序号","学号","姓名","必修课加权平均绩点","加分项","综合测评总分","综合测评总分排名","备注","CET4成绩","CET6成绩","符合条件情况","备注"]
[1,"201312201801005","边莉娜",{"v":3.895229007633588,"d":"3.90"},0,{"v":3.895229007633588,"d":"3.90"},1,"必修课程加权平均学分绩点列专业前20%",504,472,"符合","推荐"]
[2,"201312201802009","徐樟燕",{"v":3.6553435114503823,"d":"3.66"},0,{"v":3.6553435114503823,"d":"3.66"},2,"必修课程加权平均学分绩点列专业前20%",477,473,"符合"]
[3,"201312201802005","冯迪",{"v":3.480534351145039,"d":"3.48"},0,{"v":3.480534351145039,"d":"3.48"},3,"必修课程加权平均学分绩点列专业前20%",510,389,"符合"]
[4,"201323202301008","周旭晨",{"v":3.4719298245614034,"d":"3.47"},0,{"v":3.4719298245614034,"d":"3.47"},4,"必修课程加权平均学分绩点列专业前20%",505,372,"符合"]
[5,"201312201801012","梁春燕",{"v":3.4463740458015257,"d":"3.45"},0,{"v":3.4463740458015257,"d":"3.45"},5,"必修课程加权平均学分绩点列专业前20%",476,436,"符合"]
[6,"201312201802010","雷美玲",{"v":3.3113549618320626,"d":"3.31"},0,{"v":3.3113549618320626,"d":"3.31"},6,"必修课程加权平均学分绩点列专业前20%",427,358]
[7,"201312201802017","张琳琳",{"v":3.24236641221374,"d":"3.24"},0,{"v":3.24236641221374,"d":"3.24"},7,"必修课程加权平均学分绩点列专业前20%",509,427,"符合"]
[8,"201312201802007","钱丽莎",{"v":3.1836832061068705,"d":"3.18"},0,{"v":3.1836832061068705,"d":"3.18"},8,"必修课程加权平均学分绩点列专业前20%",556,473,"符合"]
[9,"201312201801004","陈怡心",{"v":3.105343511450382,"d":"3.11"},0,{"v":3.105343511450382,"d":"3.11"},9]
[10,"201312201802003","张姁",{"v":3.1011450381679393,"d":"3.10"},0,{"v":3.1011450381679393,"d":"3.10"},10]
[11,"201312201802018","秦苗苗",{"v":3.096374045801528,"d":"3.10"},0,{"v":3.096374045801528,"d":"3.10"},11]
[12,"201312201802001","余振",{"v":3.0131679389312986,"d":"3.01"},0,{"v":3.0131679389312986,"d":"3.01"},12]
[13,"201312201801002","陈杭萍",{"v":3.0116412213740458,"d":"3.01"},0,{"v":3.0116412213740458,"d":"3.01"},13]
[14,"201312201802004","杨明",{"v":2.9594465648854955,"d":"2.96"},0,{"v":2.9594465648854955,"d":"2.96"},14]
[15,"201312201801020","王泓华",{"v":2.9131679389312968,"d":"2.91"},0,{"v":2.9131679389312968,"d":"2.91"},15]
[16,"201312201801015","贺妙星",{"v":2.826049618320611,"d":"2.83"},0,{"v":2.826049618320611,"d":"2.83"},16]
[17,"201312201801019","金光美",{"v":2.7901717557251917,"d":"2.79"},0,{"v":2.7901717557251917,"d":"2.79"},17]
[18,"201312201801001","陈杭茜",{"v":2.6812022900763366,"d":"2.68"},0,{"v":2.6812022900763366,"d":"2.68"},18]
[19,"201312201801017","刘婧",{"v":2.67013358778626,"d":"2.67"},0,{"v":2.67013358778626,"d":"2.67"},19]
[20,"201312201801014","高婷婷",{"v":2.629961832061069,"d":"2.63"},0,{"v":2.629961832061069,"d":"2.63"},20]
[21,"201312201802006","张则一",{"v":2.610496183206107,"d":"2.61"},0,{"v":2.610496183206107,"d":"2.61"},21]
[22,"201312201802012","徐梦南",{"v":2.6077290076335884,"d":"2.61"},0,{"v":2.6077290076335884,"d":"2.61"},22]
[23,"201312201802014","畅健钢",{"v":2.58263358778626,"d":"2.58"},0,{"v":2.58263358778626,"d":"2.58"},23]
[24,"201312201801009","杨寒",{"v":2.541603053435115,"d":"2.54"},0,{"v":2.541603053435115,"d":"2.54"},24]
[25,"201312201801008","周灵强",{"v":2.4916984732824443,"d":"2.49"},0,{"v":2.4916984732824443,"d":"2.49"},25]
[26,"201312201802019","任艳丽",{"v":2.449141221374046,"d":"2.45"},0,{"v":2.449141221374046,"d":"2.45"},26]
[27,"201312201802016","陈梦静",{"v":2.313931297709924,"d":"2.31"},0,{"v":2.313931297709924,"d":"2.31"},27]
[28,"201312201802008","沈霖",{"v":2.2953244274809164,"d":"2.30"},0,{"v":2.2953244274809164,"d":"2.30"},28]
[29,"201312201801003","叶富城",{"v":2.2679389312977105,"d":"2.27"},0,{"v":2.2679389312977105,"d":"2.27"},29]
[30,"201312201802002","周展羽",{"v":2.1935114503816795,"d":"2.19"},0,{"v":2.1935114503816795,"d":"2.19"},30]
[31,"201312201801010","陈林",{"v":2.1895038167938936,"d":"2.19"},0,{"v":2.1895038167938936,"d":"2.19"},31]
[32,"201312201802015","严朝阳",{"v":2.1216603053435117,"d":"2.12"},0,{"v":2.1216603053435117,"d":"2.12"},32]
[33,"201312201801007","吴金明",{"v":2.095992366412214,"d":"2.10"},0,{"v":2.095992366412214,"d":"2.10"},33]
[34,"201312201801016","洪峰",{"v":1.9769083969465657,"d":"1.98"},0,{"v":1.9769083969465657,"d":"1.98"},34]
[35,"201312201801013","宋小康",{"v":1.9642175572519085,"d":"1.96"},0,{"v":1.9642175572519085,"d":"1.96"},35]
[36,"201312201802013","王振江",{"v":1.9050572519083975,"d":"1.91"},0,{"v":1.9050572519083975,"d":"1.91"},36]
[37,"201312201802020","朱智刚",{"v":1.7724236641221376,"d":"1.77"},0,{"v":1.7724236641221376,"d":"1.77"},37]
[38,"201312201801006","孙兴华",{"v":1.7389312977099238,"d":"1.74"},0,{"v":1.7389312977099238,"d":"1.74"},38]
[]
["备注："]
["加分项为0表示该生未向学院提交加分项目证明材料。"]

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

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