{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["两年必修课加权平均学分绩点","综合测评情况"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"两年必修课加权平均学分绩点","index":0,"n_rows":41,"n_cols":93,"rows_kept":41,"flags":["formulas_cached_only"]}
["学号","姓名","体育1 [2]","体育（2） [2]","体育3 [2]","体育4 [2]","形势与政策 [.3]","学分","绩点","无机化学 [3]","学分","绩点","高等数学 [3]","学分","绩点","大学英语 [5]","学分","绩点","思想道德修养与法律基础 [3]","学分","绩点","大学生心理健康教育 [2]","学分","绩点","形势与政策 [.3]","学分","绩点","有机化学 [3]","学分","绩点","分析化学 [3]","学分","绩点","普通生物学 [3]","学分","绩点","中国近现代史纲要 [2]","学分","绩点","军事理论课 [2]","学分","绩点","大学生就业指导与创业教育 [1]","学分","绩点","大学英语（2） [5]","学分","绩点","计算机文化基础 [4]","学分","绩点","形势与政策 [.3]","学分","绩点","大学英语（3） [3]","学分","绩点","生理学 [3]","学分","绩点","生物化学 [5]","学分","绩点","普通生物学实践 [1.5]","学分","绩点","马克思主义基本原理概论 [3]","学分","绩点","大学生就业指导与创业教育 [1]","学分","绩点","形势与政策 [.3]","学分","绩点","微生物学 [3]","学分","绩点","生物化学大实验 [2]","学分","绩点","微生物学实验 [1]","学分","绩点","植物生理学 [3]","学分","绩点","毛泽东思想和中国特色社会主义理论体系 [4]","学分","绩点","总学分","总学分绩点","加权平均学分绩点"]
["201323201702025","严发展",77,80,87,82,80,0.3,{"v":3,"d":"3.0"},66,3,1.6,0,3,{"v":0,"d":"0.0"},60,5,{"v":1,"d":"1.0"},88,3,3.8,73,2,2.3,89,0.3,3.9,"补修",null,null,"补修",null,null,51,3,{"v":0,"d":"0.0"},72,2,2.2,69,2,1.9,90,1,{"v":4,"d":"4.0"},74,5,2.4,63,4,1.3,"合格",0.3,2,65,3,1.5,62,3,1.2,60,5,{"v":1,"d":"1.0"},72,1.5,2.2,75,3,2.5,60,1,{"v":1,"d":"1.0"},"合格",0.3,2,48,3,{"v":0,"d":"0.0"},66,2,1.6,88,1,3.8,68,3,1.8,73,4,2.3,63.699999999999996,{"v":104.97,"d":"104.970"},{"v":1.6478806907378336,"d":"1.648"}]
["201523201701001","张章",71,82,60,66,77,0.3,2.7,77,3,2.7,70,3,{"v":2,"d":"2.0"},87,5,3.7,81,3,3.1,65,2,1.5,87,0.3,3.7,60,3,{"v":1,"d":"1.0"},66,3,1.6,63,3,1.3,74,2,2.4,80,2,{"v":3,"d":"3.0"},83,1,3.3,82,5,3.2,70,4,{"v":2,"d":"2.0"},"合格",0.3,2,80,3,{"v":3,"d":"3.0"},77,3,2.7,75,5,2.5,74,1.5,2.4,74,3,2.4,90,1,{"v":4,"d":"4.0"},"合格",0.3,2,64,3,1.4,85,2,3.5,82,1,3.2,78,3,2.8,67,4,1.7,69.69999999999999,{"v":171.81999999999996,"d":"171.820"},{"v":2.4651362984218075,"d":"2.465"}]
["201523201701002","乐翊飞",75,81,75,69,88,0.3,3.8,81,3,3.1,89,3,3.9,87,5,3.7,87,3,3.7,80,2,{"v":3,"d":"3.0"},96,0.3,4.6,82,3,3.2,87,3,3.7,85,3,3.5,76,2,2.6,91,2,4.1,95,1,4.5,81,5,3.1,89,4,3.9,"合格",0.3,2,87,3,3.7,100,3,{"v":5,"d":"5.0"},100,5,{"v":5,"d":"5.0"},93.4,1.5,{"v":4.340000000000001,"d":"4.3"},83,3,3.3,94,1,4.4,"合格",0.3,2,89,3,3.9,89,2,3.9,82,1,3.2,91,3,4.1,84,4,3.4,69.69999999999999,{"v":261.03,"d":"261.030"},{"v":3.7450502152080345,"d":"3.745"}]
["201523201701004","沈宗达",69,82,86,72,91,0.3,4.1,64,3,1.4,42,3,{"v":0,"d":"0.0"},73,5,2.3,88,3,3.8,76,2,2.6,90,0.3,{"v":4,"d":"4.0"},66,3,1.6,67,3,1.7,71,3,2.1,71,2,2.1,84,2,3.4,91,1,4.1,65,5,1.5,73,4,2.3,"合格",0.3,2,71,3,2.1,82,3,3.2,66,5,1.6,81,1.5,3.1,83,3,3.3,86,1,3.6,"合格",0.3,2,57,3,{"v":0,"d":"0.0"},72,2,2.2,83,1,3.3,69,3,1.9,73,4,2.3,69.69999999999999,{"v":148.57999999999998,"d":"148.580"},{"v":2.131707317073171,"d":"2.132"}]
["201523201701005","汪俊成",74,79,74,69,77,0.3,2.7,68,3,1.8,68,3,1.8,70,5,{"v":2,"d":"2.0"},84,3,3.4,84,2,3.4,99,0.3,4.9,83,3,3.3,70,3,{"v":2,"d":"2.0"},81,3,3.1,71,2,2.1,94,2,4.4,81,1,3.1,74,5,2.4,77,4,2.7,"合格",0.3,2,70,3,{"v":2,"d":"2.0"},90.4,3,{"v":4.040000000000001,"d":"4.0"},90.4,5,{"v":4.040000000000001,"d":"4.0"},87.4,1.5,{"v":3.7400000000000007,"d":"3.7"},80,3,{"v":3,"d":"3.0"},92,1,4.2,"合格",0.3,2,77,3,2.7,86,2,3.6,81,1,3.1,76,3,2.6,80,4,{"v":3,"d":"3.0"},69.69999999999999,{"v":200.70999999999998,"d":"200.710"},{"v":2.879626972740316,"d":"2.880"}]
["201523201701006","张育茗",76,87,77,76,91,0.3,4.1,77,3,2.7,65,3,1.5,92,5,4.2,91,3,4.1,85,2,3.5,95,0.3,4.5,73,3,2.3,70,3,{"v":2,"d":"2.0"},82,3,3.2,80,2,{"v":3,"d":"3.0"},94,2,4.4,94,1,4.4,96,5,4.6,80,4,{"v":3,"d":"3.0"},"合格",0.3,2,89,3,3.9,95.8,3,{"v":4.58,"d":"4.6"},82.8,5,{"v":3.28,"d":"3.3"},79,1.5,2.9,82,3,3.2,89,1,3.9,"合格",0.3,2,78,3,2.8,72,2,2.2,80,1,{"v":3,"d":"3.0"},77,3,2.7,88,4,3.8,69.69999999999999,{"v":232.17,"d":"232.170"},{"v":3.3309899569583936,"d":"3.331"}]
["201523201701007","沃媛超",72,81,76,85,87,0.3,3.7,63,3,1.3,50,3,{"v":0,"d":"0.0"},84,5,3.4,86,3,3.6,76,2,2.6,82,0.3,3.2,78,3,2.8,65,3,1.5,79,3,2.9,66,2,1.6,88,2,3.8,88,1,3.8,76,5,2.6,62,4,1.2,"合格",0.3,2,65,3,1.5,89,3,3.9,79,5,2.9,83,1.5,3.3,83,3,3.3,95,1,4.5,"合格",0.3,2,58,3,{"v":0,"d":"0.0"},85,2,3.5,83,1,3.3,79,3,2.9,79,4,2.9,69.69999999999999,{"v":174.82,"d":"174.820"},{"v":2.508177905308465,"d":"2.508"}]
["201523201701009","吕旭阳",68,81,77,70,86,0.3,3.6,78,3,2.8,76,3,2.6,80,5,{"v":3,"d":"3.0"},85,3,3.5,77,2,2.7,87,0.3,3.7,79,3,2.9,67,3,1.7,80,3,{"v":3,"d":"3.0"},77,2,2.7,88,2,3.8,91,1,4.1,73,5,2.3,68,4,1.8,"合格",0.3,2,78,3,2.8,80,3,{"v":3,"d":"3.0"},74,5,2.4,77,1.5,2.7,82,3,3.2,90,1,{"v":4,"d":"4.0"},"合格",0.3,2,74,3,2.4,79,2,2.9,82,1,3.2,83,3,3.3,72,4,2.2,69.69999999999999,{"v":191.04,"d":"191.040"},{"v":2.7408895265423245,"d":"2.741"}]
["201523201701012","朱诗聪",83,90,81,78,82,0.3,3.2,86,3,3.6,67,3,1.7,73,5,2.3,82,3,3.2,69,2,1.9,87,0.3,3.7,75,3,2.5,66,3,1.6,68,3,1.8,74,2,2.4,86,2,3.6,90,1,{"v":4,"d":"4.0"},78,5,2.8,60,4,{"v":1,"d":"1.0"},"合格",0.3,2,80,3,{"v":3,"d":"3.0"},79,3,2.9,71,5,2.1,77,1.5,2.7,79,3,2.9,86,1,3.6,"合格",0.3,2,65,3,1.5,74,2,2.4,82,1,3.2,73,3,2.3,75,4,2.5,69.69999999999999,{"v":169.72,"d":"169.720"},{"v":2.4350071736011483,"d":"2.435"}]
["201523201701014","吴尹洁",75,79,84,81,86,0.3,3.6,45,3,{"v":0,"d":"0.0"},49,3,{"v":0,"d":"0.0"},78,5,2.8,86,3,3.6,86,2,3.6,91,0.3,4.1,73,3,2.3,54,3,{"v":0,"d":"0.0"},75,3,2.5,80,2,{"v":3,"d":"3.0"},96,2,4.6,92,1,4.2,72,5,2.2,67,4,1.7,"合格",0.3,2,78,3,2.8,87,3,3.7,72,5,2.2,77,1.5,2.7,83,3,3.3,93,1,4.3,"合格",0.3,2,78,3,2.8,78,2,2.8,82,1,3.2,71,3,2.1,83,4,3.3,69.69999999999999,{"v":172.55999999999997,"d":"172.560"},{"v":2.4757532281205163,"d":"2.476"}]
["201523201701016","俞涛",73,83,81,76,70,0.3,{"v":2,"d":"2.0"},64,3,1.4,44,3,{"v":0,"d":"0.0"},60,5,{"v":1,"d":"1.0"},77,3,2.7,68,2,1.8,73,0.3,2.3,60,3,{"v":1,"d":"1.0"},60,3,{"v":1,"d":"1.0"},68,3,1.8,75,2,2.5,70,2,{"v":2,"d":"2.0"},90,1,{"v":4,"d":"4.0"},60,5,{"v":1,"d":"1.0"},57,4,{"v":0,"d":"0.0"},"合格",0.3,2,69,3,1.9,79,3,2.9,67,5,1.7,74,1.5,2.4,70,3,{"v":2,"d":"2.0"},86,1,3.6,"合格",0.3,2,69,3,1.9,68,2,1.8,72,1,2.2,80,3,{"v":3,"d":"3.0"},74,4,2.4,69.69999999999999,{"v":118.98999999999998,"d":"118.990"},{"v":1.7071736011477763,"d":"1.707"}]
["201523201701017","傅艳华",80,84,86,80,88,0.3,3.8,76,3,2.6,82,3,3.2,67,5,1.7,82,3,3.2,78,2,2.8,90,0.3,{"v":4,"d":"4.0"},79,3,2.9,66,3,1.6,79,3,2.9,76,2,2.6,97,2,4.7,84,1,3.4,68,5,1.8,62,4,1.2,"合格",0.3,2,60,3,{"v":1,"d":"1.0"},88,3,3.8,78,5,2.8,84,1.5,3.4,63,3,1.3,91,1,4.1,"合格",0.3,2,84,3,3.4,87,2,3.7,91,1,4.1,87,3,3.7,90,4,{"v":4,"d":"4.0"},69.69999999999999,{"v":188.93999999999997,"d":"188.940"},{"v":2.7107604017216644,"d":"2.711"}]
["201523201701019","陈天杭",73,82,89,72,82,0.3,3.2,75,3,2.5,77,3,2.7,75,5,2.5,85,3,3.5,78,2,2.8,96,0.3,4.6,75,3,2.5,69,3,1.9,81,3,3.1,83,2,3.3,90,2,{"v":4,"d":"4.0"},93,1,4.3,72,5,2.2,90,4,{"v":4,"d":"4.0"},"合格",0.3,2,72,3,2.2,98.4,3,{"v":4.840000000000001,"d":"4.8"},83.4,5,{"v":3.3400000000000007,"d":"3.3"},78,1.5,2.8,76,3,2.6,91,1,4.1,"合格",0.3,2,83,3,3.3,77,2,2.7,82,1,3.2,86,3,3.6,88,4,3.8,69.69999999999999,{"v":214.56,"d":"214.560"},{"v":3.0783357245337166,"d":"3.078"}]
["201523201701020","金珂",74,88,81,77,81,0.3,3.1,60,3,{"v":1,"d":"1.0"},45,3,{"v":0,"d":"0.0"},63,5,1.3,86,3,3.6,65,2,1.5,87,0.3,3.7,61,3,1.1,53,3,{"v":0,"d":"0.0"},60,3,{"v":1,"d":"1.0"},74,2,2.4,90,2,{"v":4,"d":"4.0"},88,1,3.8,60,5,{"v":1,"d":"1.0"},77,4,2.7,"合格",0.3,2,77,3,2.7,91.4,3,{"v":4.140000000000001,"d":"4.1"},83.4,5,{"v":3.3400000000000007,"d":"3.3"},85.4,1.5,{"v":3.5400000000000005,"d":"3.5"},77,3,2.7,90,1,{"v":4,"d":"4.0"},"合格",0.3,2,68,3,1.8,79,2,2.9,80,1,{"v":3,"d":"3.0"},74,3,2.4,84,4,3.4,69.69999999999999,{"v":154.86999999999998,"d":"154.870"},{"v":2.2219512195121953,"d":"2.222"}]
["201523201701021","方心怡",78,85,77,71,84,0.3,3.4,66,3,1.6,79,3,2.9,77,5,2.7,83,3,3.3,75,2,2.5,74,0.3,2.4,83,3,3.3,69,3,1.9,84,3,3.4,77,2,2.7,98,2,4.8,92,1,4.2,80,5,{"v":3,"d":"3.0"},85,4,3.5,"合格",0.3,2,62,3,1.2,91,3,4.1,75,5,2.5,82,1.5,3.2,79,3,2.9,83,1,3.3,"合格",0.3,2,85,3,3.5,89,2,3.9,88,1,3.8,0,3,{"v":0,"d":"0.0"},79,4,2.9,69.69999999999999,{"v":197.74,"d":"197.740"},{"v":2.837015781922526,"d":"2.837"}]
["201523201701022","张宏瑞",77,84,61,59,79,0.3,2.9,61,3,1.1,60,3,{"v":1,"d":"1.0"},60,5,{"v":1,"d":"1.0"},79,3,2.9,64,2,1.4,83,0.3,3.3,60,3,{"v":1,"d":"1.0"},60,3,{"v":1,"d":"1.0"},75,3,2.5,68,2,1.8,78,2,2.8,89,1,3.9,72,5,2.2,53,4,{"v":0,"d":"0.0"},"合格",0.3,2,71,3,2.1,73,3,2.3,67,5,1.7,84,1.5,3.4,70,3,{"v":2,"d":"2.0"},89,1,3.9,"合格",0.3,2,70,3,{"v":2,"d":"2.0"},58,2,{"v":0,"d":"0.0"},78,1,2.8,75,3,2.5,60,4,{"v":1,"d":"1.0"},69.69999999999999,{"v":120.46,"d":"120.460"},{"v":1.7282639885222384,"d":"1.728"}]
["201523201701024","丁丽蒙",75,91,74,75,79,0.3,2.9,85,3,3.5,65,3,1.5,79,5,2.9,84,3,3.4,72,2,2.2,84,0.3,3.4,85,3,3.5,72,3,2.2,83,3,3.3,75,2,2.5,96,2,4.6,87,1,3.7,76,5,2.6,60,4,{"v":1,"d":"1.0"},"合格",0.3,2,67,3,1.7,87,3,3.7,69,5,1.9,80,1.5,{"v":3,"d":"3.0"},77,3,2.7,89,1,3.9,"合格",0.3,2,85,3,3.5,77,2,2.7,76,1,2.6,74,3,2.4,79,4,2.9,69.69999999999999,{"v":188.58999999999997,"d":"188.590"},{"v":2.7057388809182212,"d":"2.706"}]
["201523201701026","张扬",60,61,62,61,75,0.3,2.5,53,3,{"v":0,"d":"0.0"},46,3,{"v":0,"d":"0.0"},60,5,{"v":1,"d":"1.0"},88,3,3.8,78,2,2.8,89,0.3,3.9,67,3,1.7,69,3,1.9,71,3,2.1,76,2,2.6,80,2,{"v":3,"d":"3.0"},82,1,3.2,66,5,1.6,48,4,{"v":0,"d":"0.0"},"合格",0.3,2,60,3,{"v":1,"d":"1.0"},83,3,3.3,62,5,1.2,63,1.5,1.3,82,3,3.2,87,1,3.7,"合格",0.3,2,62,3,1.2,56,2,{"v":0,"d":"0.0"},72,1,2.2,79,3,2.9,64,4,1.4,69.69999999999999,{"v":118.86999999999999,"d":"118.870"},{"v":1.70545193687231,"d":"1.705"}]
["201523201701028","贺达",75,64,77,77,72,0.3,2.2,60,3,{"v":1,"d":"1.0"},49,3,{"v":0,"d":"0.0"},33,5,{"v":0,"d":"0.0"},78,3,2.8,65,2,1.5,82,0.3,3.2,52,3,{"v":0,"d":"0.0"},52,3,{"v":0,"d":"0.0"},47,3,{"v":0,"d":"0.0"},75,2,2.5,74,2,2.4,84,1,3.4,44,5,{"v":0,"d":"0.0"},54,4,{"v":0,"d":"0.0"},"合格",0.3,2,44,3,{"v":0,"d":"0.0"},76,3,2.6,60,5,{"v":1,"d":"1.0"},74,1.5,2.4,81,3,3.1,89,1,3.9,"合格",0.3,2,51,3,{"v":0,"d":"0.0"},60,2,{"v":1,"d":"1.0"},71,1,2.1,65,3,1.5,73,4,2.3,69.69999999999999,{"v":77.82000000000001,"d":"77.820"},{"v":1.1164992826398854,"d":"1.116"}]
["201523201701030","邱黎明",71,71,75,71,70,0.3,{"v":2,"d":"2.0"},60,3,{"v":1,"d":"1.0"},42,3,{"v":0,"d":"0.0"},60,5,{"v":1,"d":"1.0"},85,3,3.5,72,2,2.2,83,0.3,3.3,61,3,1.1,53,3,{"v":0,"d":"0.0"},62,3,1.2,70,2,{"v":2,"d":"2.0"},85,2,3.5,90,1,{"v":4,"d":"4.0"},60,5,{"v":1,"d":"1.0"},51,4,{"v":0,"d":"0.0"},"合格",0.3,2,60,3,{"v":1,"d":"1.0"},75,3,2.5,62,5,1.2,72,1.5,2.2,69,3,1.9,89,1,3.9,"合格",0.3,2,72,3,2.2,55,2,{"v":0,"d":"0.0"},81,1,3.1,77,3,2.7,64,4,1.4,69.69999999999999,{"v":105.38999999999999,"d":"105.390"},{"v":1.5120516499282641,"d":"1.512"}]
["201523201702001","殷梵钧",81,87,79,79,78,0.3,2.8,90,3,{"v":4,"d":"4.0"},90,3,{"v":4,"d":"4.0"},81,5,3.1,80,3,{"v":3,"d":"3.0"},89,2,3.9,92,0.3,4.2,96,3,4.6,93,3,4.3,90,3,{"v":4,"d":"4.0"},88,2,3.8,94,2,4.4,96,1,4.6,82,5,3.2,83,4,3.3,"合格",0.3,2,84,3,3.4,100,3,{"v":5,"d":"5.0"},100,5,{"v":5,"d":"5.0"},94,1.5,4.4,80,3,{"v":3,"d":"3.0"},92,1,4.2,"合格",0.3,2,89,3,3.9,90,2,{"v":4,"d":"4.0"},87,1,3.7,92,3,4.2,85,4,3.5,69.69999999999999,{"v":268.4999999999999,"d":"268.500"},{"v":3.8522238163558096,"d":"3.852"}]
["201523201702002","高佳杰",85,88,73,77,76,0.3,2.6,84,3,3.4,83,3,3.3,71,5,2.1,80,3,{"v":3,"d":"3.0"},69,2,1.9,79,0.3,2.9,74,3,2.4,70,3,{"v":2,"d":"2.0"},83,3,3.3,74,2,2.4,96,2,4.6,85,1,3.5,79,5,2.9,67,4,1.7,"合格",0.3,2,72,3,2.2,90.4,3,{"v":4.040000000000001,"d":"4.0"},84.4,5,{"v":3.4400000000000004,"d":"3.4"},83,1.5,3.3,66,3,1.6,88,1,3.8,"合格",0.3,2,76,3,2.6,68,2,1.8,84,1,3.4,82,3,3.2,82,4,3.2,69.69999999999999,{"v":194.82,"d":"194.820"},{"v":2.7951219512195125,"d":"2.795"}]
["201523201702005","钟琦康",80,79,79,78,70,0.3,{"v":2,"d":"2.0"},82,3,3.2,85,3,3.5,74,5,2.4,77,3,2.7,66,2,1.6,85,0.3,3.5,77,3,2.7,69,3,1.9,75,3,2.5,78,2,2.8,89,2,3.9,87,1,3.7,63,5,1.3,71,4,2.1,"合格",0.3,2,60,3,{"v":1,"d":"1.0"},83,3,3.3,87,5,3.7,78,1.5,2.8,69,3,1.9,87,1,3.7,"合格",0.3,2,76,3,2.6,65,2,1.5,78,1,2.8,76,3,2.6,77,4,2.7,69.69999999999999,{"v":176.75,"d":"176.750"},{"v":2.535868005738881,"d":"2.536"}]
["201523201702006","汪嘉启",86,76,86,88,83,0.3,3.3,73,3,2.3,79,3,2.9,76,5,2.6,83,3,3.3,68,2,1.8,94,0.3,4.4,67,3,1.7,66,3,1.6,80,3,{"v":3,"d":"3.0"},73,2,2.3,86,2,3.6,89,1,3.9,79,5,2.9,83,4,3.3,"合格",0.3,2,62,3,1.2,91,3,4.1,79.4,5,{"v":2.9400000000000004,"d":"2.9"},82.4,1.5,{"v":3.2400000000000007,"d":"3.2"},71,3,2.1,86,1,3.6,"合格",0.3,2,70,3,{"v":2,"d":"2.0"},74,2,2.4,80,1,{"v":3,"d":"3.0"},86,3,3.6,71,4,2.1,69.69999999999999,{"v":186.27000000000004,"d":"186.270"},{"v":2.6724533715925403,"d":"2.672"}]
["201523201702009","郭柳青",74,65,83,78,87,0.3,3.7,65,3,1.5,54,3,{"v":0,"d":"0.0"},71,5,2.1,81,3,3.1,80,2,{"v":3,"d":"3.0"},91,0.3,4.1,79,3,2.9,60,3,{"v":1,"d":"1.0"},73,3,2.3,80,2,{"v":3,"d":"3.0"},90,2,{"v":4,"d":"4.0"},88,1,3.8,70,5,{"v":2,"d":"2.0"},64,4,1.4,"合格",0.3,2,69,3,1.9,88.4,3,{"v":3.8400000000000007,"d":"3.8"},75.4,5,{"v":2.5400000000000005,"d":"2.5"},82,1.5,3.2,76,3,2.6,91,1,4.1,"合格",0.3,2,65,3,1.5,82,2,3.2,88,1,3.8,85,3,3.5,83,4,3.3,69.69999999999999,{"v":170.86,"d":"170.860"},{"v":2.451362984218078,"d":"2.451"}]
["201523201702010","林昌鑫",85,78,77,78,82,0.3,3.2,69,3,1.9,84,3,3.4,80,5,{"v":3,"d":"3.0"},82,3,3.2,82,2,3.2,91,0.3,4.1,80,3,{"v":3,"d":"3.0"},83,3,3.3,79,3,2.9,80,2,{"v":3,"d":"3.0"},90,2,{"v":4,"d":"4.0"},88,1,3.8,77,5,2.7,67,4,1.7,"合格",0.3,2,77,3,2.7,100,3,{"v":5,"d":"5.0"},90.4,5,{"v":4.040000000000001,"d":"4.0"},86.4,1.5,{"v":3.6400000000000006,"d":"3.6"},77,3,2.7,90,1,{"v":4,"d":"4.0"},"合格",0.3,2,83,3,3.3,81,2,3.1,80,1,{"v":3,"d":"3.0"},89,3,3.9,77,4,2.7,69.69999999999999,{"v":218.45,"d":"218.450"},{"v":3.134146341463415,"d":"3.134"}]
["201523201702011","姜方乐",87,72,70,77,70,0.3,{"v":2,"d":"2.0"},65,3,1.5,60,3,{"v":1,"d":"1.0"},65,5,1.5,82,3,3.2,73,2,2.3,86,0.3,3.6,63,3,1.3,65,3,1.5,53,3,{"v":0,"d":"0.0"},71,2,2.1,77,2,2.7,81,1,3.1,66,5,1.6,62,4,1.2,"合格",0.3,2,68,3,1.8,88,3,3.8,68,5,1.8,78,1.5,2.8,72,3,2.2,84,1,3.4,"合格",0.3,2,72,3,2.2,75,2,2.5,85,1,3.5,79,3,2.9,60,4,{"v":1,"d":"1.0"},69.69999999999999,{"v":133.78,"d":"133.780"},{"v":1.919368723098996,"d":"1.919"}]
["201523201702012","金雨璐",81,86,78,85,77,0.3,2.7,61,3,1.1,60,3,{"v":1,"d":"1.0"},60,5,{"v":1,"d":"1.0"},83,3,3.3,80,2,{"v":3,"d":"3.0"},93,0.3,4.3,67,3,1.7,73,3,2.3,67,3,1.7,78,2,2.8,85,2,3.5,87,1,3.7,60,5,{"v":1,"d":"1.0"},57,4,{"v":0,"d":"0.0"},"合格",0.3,2,63,3,1.3,85,3,3.5,70,5,{"v":2,"d":"2.0"},77,1.5,2.7,79,3,2.9,92,1,4.2,"合格",0.3,2,75,3,2.5,74,2,2.4,84,1,3.4,80,3,{"v":3,"d":"3.0"},91,4,4.1,69.69999999999999,{"v":151.35,"d":"151.350"},{"v":2.171449067431851,"d":"2.171"}]
["201523201702013","冯丹燕",82,88,80,82,70,0.3,{"v":2,"d":"2.0"},72,3,2.2,72,3,2.2,79,5,2.9,85,3,3.5,78,2,2.8,92,0.3,4.2,75,3,2.5,66,3,1.6,71,3,2.1,84,2,3.4,95,2,4.5,87,1,3.7,74,5,2.4,62,4,1.2,"合格",0.3,2,75,3,2.5,74,3,2.4,68,5,1.8,67,1.5,1.7,79,3,2.9,84,1,3.4,"合格",0.3,2,64,3,1.4,64,2,1.4,79,1,2.9,76,3,2.6,87,4,3.7,69.69999999999999,{"v":172.61,"d":"172.610"},{"v":2.4764705882352946,"d":"2.476"}]
["201523201702014","龚晨晖",84,71,65,77,73,0.3,2.3,65,3,1.5,53,3,{"v":0,"d":"0.0"},60,5,{"v":1,"d":"1.0"},85,3,3.5,74,2,2.4,96,0.3,4.6,68,3,1.8,66,3,1.6,71,3,2.1,80,2,{"v":3,"d":"3.0"},83,2,3.3,89,1,3.9,60,5,{"v":1,"d":"1.0"},80,4,{"v":3,"d":"3.0"},"合格",0.3,2,60,3,{"v":1,"d":"1.0"},88.4,3,{"v":3.8400000000000007,"d":"3.8"},84.4,5,{"v":3.4400000000000004,"d":"3.4"},81,1.5,3.1,84,3,3.4,84,1,3.4,"合格",0.3,2,70,3,{"v":2,"d":"2.0"},73,2,2.3,79,1,2.9,80,3,{"v":3,"d":"3.0"},90,4,{"v":4,"d":"4.0"},69.69999999999999,{"v":166.54,"d":"166.540"},{"v":2.3893830703012915,"d":"2.389"}]
["201523201702015","沈世超",68,64,66,75,81,0.3,3.1,75,3,2.5,60,3,{"v":1,"d":"1.0"},60,5,{"v":1,"d":"1.0"},86,3,3.6,73,2,2.3,83,0.3,3.3,60,3,{"v":1,"d":"1.0"},66,3,1.6,79,3,2.9,75,2,2.5,82,2,3.2,90,1,{"v":4,"d":"4.0"},55,5,{"v":0,"d":"0.0"},62,4,1.2,"合格",0.3,2,51,3,{"v":0,"d":"0.0"},81,3,3.1,75,5,2.5,78,1.5,2.8,81,3,3.1,93,1,4.3,"合格",0.3,2,71,3,2.1,69,2,1.9,84,1,3.4,80,3,{"v":3,"d":"3.0"},71,4,2.1,69.69999999999999,{"v":141.22,"d":"141.220"},{"v":2.0261119081779055,"d":"2.026"}]
["201523201702016","卢佳漪",73,90,77,82,82,0.3,3.2,53,3,{"v":0,"d":"0.0"},54,3,{"v":0,"d":"0.0"},72,5,2.2,82,3,3.2,73,2,2.3,85,0.3,3.5,60,3,{"v":1,"d":"1.0"},54,3,{"v":0,"d":"0.0"},65,3,1.5,77,2,2.7,88,2,3.8,94,1,4.4,70,5,{"v":2,"d":"2.0"},68,4,1.8,"合格",0.3,2,69,3,1.9,80,3,{"v":3,"d":"3.0"},66,5,1.6,75,1.5,2.5,81,3,3.1,91,1,4.1,"合格",0.3,2,66,3,1.6,63,2,1.3,76,1,2.6,71,3,2.1,89,4,3.9,69.69999999999999,{"v":142.25999999999996,"d":"142.260"},{"v":2.0410329985652798,"d":"2.041"}]
["201523201702018","王童彤",80,87,81,81,67,0.3,1.7,60,3,{"v":1,"d":"1.0"},53,3,{"v":0,"d":"0.0"},65,5,1.5,82,3,3.2,67,2,1.7,86,0.3,3.6,60,3,{"v":1,"d":"1.0"},53,3,{"v":0,"d":"0.0"},65,3,1.5,80,2,{"v":3,"d":"3.0"},88,2,3.8,82,1,3.2,60,5,{"v":1,"d":"1.0"},73,4,2.3,"合格",0.3,2,64,3,1.4,62,3,1.2,60,5,{"v":1,"d":"1.0"},68,1.5,1.8,74,3,2.4,84,1,3.4,"合格",0.3,2,63,3,1.3,57,2,{"v":0,"d":"0.0"},72,1,2.2,70,3,{"v":2,"d":"2.0"},79,4,2.9,69.69999999999999,{"v":114.59,"d":"114.590"},{"v":1.644045911047346,"d":"1.644"}]
["201523201702022","傅豪",79,78,73,79,78,0.3,2.8,73,3,2.3,76,3,2.6,61,5,1.1,82,3,3.2,75,2,2.5,86,0.3,3.6,80,3,{"v":3,"d":"3.0"},66,3,1.6,76,3,2.6,68,2,1.8,94,2,4.4,84,1,3.4,61,5,1.1,69,4,1.9,"合格",0.3,2,68,3,1.8,88,3,3.8,76,5,2.6,83,1.5,3.3,70,3,{"v":2,"d":"2.0"},87,1,3.7,"合格",0.3,2,85,3,3.5,80,2,{"v":3,"d":"3.0"},81,1,3.1,87,3,3.7,83,4,3.3,69.69999999999999,{"v":176.76999999999995,"d":"176.770"},{"v":2.5361549497847915,"d":"2.536"}]
["201523201702023","李财宣",60,80,81,76,76,0.3,2.6,65,3,1.5,50,3,{"v":0,"d":"0.0"},60,5,{"v":1,"d":"1.0"},83,3,3.3,64,2,1.4,82,0.3,3.2,71,3,2.1,50,3,{"v":0,"d":"0.0"},68,3,1.8,64,2,1.4,86,2,3.6,74,1,2.4,60,5,{"v":1,"d":"1.0"},63,4,1.3,"合格",0.3,2,60,3,{"v":1,"d":"1.0"},74,3,2.4,66,5,1.6,78,1.5,2.8,63,3,1.3,85,1,3.5,"合格",0.3,2,68,3,1.8,54,2,{"v":0,"d":"0.0"},80,1,{"v":3,"d":"3.0"},71,3,2.1,78,4,2.8,69.69999999999999,{"v":115.14000000000001,"d":"115.140"},{"v":1.6519368723099002,"d":"1.652"}]
["201523201702024","陈柏辰",60,82,72,81,87,0.3,3.7,80,3,{"v":3,"d":"3.0"},75,3,2.5,74,5,2.4,86,3,3.6,79,2,2.9,87,0.3,3.7,76,3,2.6,86,3,3.6,81,3,3.1,86,2,3.6,90,2,{"v":4,"d":"4.0"},89,1,3.9,70,5,{"v":2,"d":"2.0"},80,4,{"v":3,"d":"3.0"},"合格",0.3,2,76,3,2.6,98.4,3,{"v":4.840000000000001,"d":"4.8"},94.4,5,{"v":4.44,"d":"4.4"},88,1.5,3.8,86,3,3.6,86,1,3.6,"合格",0.3,2,81,3,3.1,89,2,3.9,81,1,3.1,89,3,3.9,79,4,2.9,69.69999999999999,{"v":225.64,"d":"225.640"},{"v":3.2373027259684366,"d":"3.237"}]
["201523201702026","高宏飞",76,67,74,76,82,0.3,3.2,77,3,2.7,72,3,2.2,72,5,2.2,82,3,3.2,67,2,1.7,85,0.3,3.5,77,3,2.7,54,3,{"v":0,"d":"0.0"},69,3,1.9,70,2,{"v":2,"d":"2.0"},80,2,{"v":3,"d":"3.0"},88,1,3.8,56,5,{"v":0,"d":"0.0"},64,4,1.4,"合格",0.3,2,48,3,{"v":0,"d":"0.0"},89.4,3,{"v":3.9400000000000004,"d":"3.9"},78.4,5,{"v":2.8400000000000007,"d":"2.8"},88.4,1.5,{"v":3.8400000000000007,"d":"3.8"},70,3,{"v":2,"d":"2.0"},87,1,3.7,"合格",0.3,2,76,3,2.6,51,2,{"v":0,"d":"0.0"},83,1,3.3,71,3,2.1,70,4,{"v":2,"d":"2.0"},69.69999999999999,{"v":141.98999999999998,"d":"141.990"},{"v":2.0371592539454806,"d":"2.037"}]
["201523201702027","李维",77,82,72,73,70,0.3,{"v":2,"d":"2.0"},51,3,{"v":0,"d":"0.0"},60,3,{"v":1,"d":"1.0"},62,5,1.2,83,3,3.3,67,2,1.7,91,0.3,4.1,64,3,1.4,48,3,{"v":0,"d":"0.0"},63,3,1.3,67,2,1.7,78,2,2.8,77,1,2.7,60,5,{"v":1,"d":"1.0"},43,4,{"v":0,"d":"0.0"},"合格",0.3,2,66,3,1.6,78,3,2.8,69,5,1.9,72,1.5,2.2,66,3,1.6,87,1,3.7,"合格",0.3,2,74,3,2.4,49,2,{"v":0,"d":"0.0"},61,1,1.1,69,3,1.9,60,4,{"v":1,"d":"1.0"},69.69999999999999,{"v":102.62999999999998,"d":"102.630"},{"v":1.4724533715925394,"d":"1.472"}]
["201523201702030","黄昊",76,67,69,77,70,0.3,{"v":2,"d":"2.0"},61,3,1.1,64,3,1.4,60,5,{"v":1,"d":"1.0"},82,3,3.2,72,2,2.2,88,0.3,3.8,63,3,1.3,49,3,{"v":0,"d":"0.0"},73,3,2.3,74,2,2.4,79,2,2.9,84,1,3.4,56,5,{"v":0,"d":"0.0"},84,4,3.4,"合格",0.3,2,67,3,1.7,82.4,3,{"v":3.2400000000000007,"d":"3.2"},80.4,5,{"v":3.0400000000000005,"d":"3.0"},87.4,1.5,{"v":3.7400000000000007,"d":"3.7"},69,3,1.9,86,1,3.6,"合格",0.3,2,84,3,3.4,73,2,2.3,75,1,2.5,87,3,3.7,67,4,1.7,69.69999999999999,{"v":147.96999999999997,"d":"147.970"},{"v":2.122955523672884,"d":"2.123"}]
["201523202101029","刘汉卿",63,84,70,66,88,0.3,3.8,"补修",null,null,81,3,3.1,60,5,{"v":1,"d":"1.0"},83,3,3.3,87,2,3.7,82,0.3,3.2,68,3,1.8,45,3,{"v":0,"d":"0.0"},61,3,1.1,75,2,2.5,87,2,3.7,86,1,3.6,60,5,{"v":1,"d":"1.0"},83,4,3.3,"合格",0.3,2,36,3,{"v":0,"d":"0.0"},62,3,1.2,39,5,{"v":0,"d":"0.0"},74,1.5,2.4,65,3,1.5,85,1,3.5,"合格",0.3,2,55,3,{"v":0,"d":"0.0"},72,2,2.2,77,1,2.7,72,3,2.2,71,4,2.1,66.69999999999999,{"v":115.09999999999998,"d":"115.100"},{"v":1.7256371814092955,"d":"1.726"}]

{"sheet":"综合测评情况","index":1,"n_rows":43,"n_cols":7,"rows_kept":43,"flags":["formulas_cached_only"]}
["学号","姓名","两年必修课加权平均学分绩点","加分项","综合测评分","综合测评排名","备注"]
["201523201702001","殷梵钧",{"v":3.8522238163558096,"d":"3.852"},{"v":0.06,"d":"0.060"},{"v":3.9122238163558096,"d":"3.912"},1]
["201523201701002","乐翊飞",{"v":3.7450502152080345,"d":"3.745"},0.165,{"v":3.9100502152080345,"d":"3.910"},2]
["201523201701006","张育茗",{"v":3.3309899569583936,"d":"3.331"},{"v":0,"d":"0.000"},{"v":3.3309899569583936,"d":"3.331"},3]
["201523201702024","陈柏辰",{"v":3.2373027259684366,"d":"3.237"},{"v":0,"d":"0.000"},{"v":3.2373027259684366,"d":"3.237"},4]
["201523201702010","林昌鑫",{"v":3.134146341463415,"d":"3.134"},{"v":0,"d":"0.000"},{"v":3.134146341463415,"d":"3.134"},5]
["201523201701019","陈天杭",{"v":3.0783357245337166,"d":"3.078"},{"v":0,"d":"0.000"},{"v":3.0783357245337166,"d":"3.078"},6]
["201523201701005","汪俊成",{"v":2.879626972740316,"d":"2.880"},{"v":0,"d":"0.000"},{"v":2.879626972740316,"d":"2.880"},7]
["201523201701021","方心怡",{"v":2.837015781922526,"d":"2.837"},{"v":0,"d":"0.000"},{"v":2.837015781922526,"d":"2.837"},8]
["201523201702002","高佳杰",{"v":2.7951219512195125,"d":"2.795"},{"v":0,"d":"0.000"},{"v":2.7951219512195125,"d":"2.795"},9]
["201523201701009","吕旭阳",{"v":2.7408895265423245,"d":"2.741"},{"v":0,"d":"0.000"},{"v":2.7408895265423245,"d":"2.741"},10]
["201523201701017","傅艳华",{"v":2.7107604017216644,"d":"2.711"},{"v":0,"d":"0.000"},{"v":2.7107604017216644,"d":"2.711"},11]
["201523201701024","丁丽蒙",{"v":2.7057388809182212,"d":"2.706"},{"v":0,"d":"0.000"},{"v":2.7057388809182212,"d":"2.706"},12]
["201523201702006","汪嘉启",{"v":2.6724533715925403,"d":"2.672"},{"v":0,"d":"0.000"},{"v":2.6724533715925403,"d":"2.672"},13]
["201523201702022","傅豪",{"v":2.5361549497847915,"d":"2.536"},{"v":0,"d":"0.000"},{"v":2.5361549497847915,"d":"2.536"},14]
["201523201702005","钟琦康",{"v":2.535868005738881,"d":"2.536"},{"v":0,"d":"0.000"},{"v":2.535868005738881,"d":"2.536"},15]
["201523201701007","沃媛超",{"v":2.508177905308465,"d":"2.508"},{"v":0,"d":"0.000"},{"v":2.508177905308465,"d":"2.508"},16]
["201523201702013","冯丹燕",{"v":2.4764705882352946,"d":"2.476"},{"v":0,"d":"0.000"},{"v":2.4764705882352946,"d":"2.476"},17]
["201523201701014","吴尹洁",{"v":2.4757532281205163,"d":"2.476"},{"v":0,"d":"0.000"},{"v":2.4757532281205163,"d":"2.476"},18]
["201523201701001","张章",{"v":2.4651362984218075,"d":"2.465"},{"v":0,"d":"0.000"},{"v":2.4651362984218075,"d":"2.465"},19]
["201523201702009","郭柳青",{"v":2.451362984218078,"d":"2.451"},{"v":0,"d":"0.000"},{"v":2.451362984218078,"d":"2.451"},20]
["201523201701012","朱诗聪",{"v":2.4350071736011483,"d":"2.435"},{"v":0,"d":"0.000"},{"v":2.4350071736011483,"d":"2.435"},21]
["201523201702014","龚晨晖",{"v":2.3893830703012915,"d":"2.389"},{"v":0,"d":"0.000"},{"v":2.3893830703012915,"d":"2.389"},22]
["201523201701020","金珂",{"v":2.2219512195121953,"d":"2.222"},{"v":0,"d":"0.000"},{"v":2.2219512195121953,"d":"2.222"},23]
["201523201702012","金雨璐",{"v":2.171449067431851,"d":"2.171"},{"v":0,"d":"0.000"},{"v":2.171449067431851,"d":"2.171"},24]
["201523201701004","沈宗达",{"v":2.131707317073171,"d":"2.132"},{"v":0,"d":"0.000"},{"v":2.131707317073171,"d":"2.132"},25]
["201523201702030","黄昊",{"v":2.122955523672884,"d":"2.123"},{"v":0,"d":"0.000"},{"v":2.122955523672884,"d":"2.123"},26]
["201523201702016","卢佳漪",{"v":2.0410329985652798,"d":"2.041"},{"v":0,"d":"0.000"},{"v":2.0410329985652798,"d":"2.041"},27]
["201523201702026","高宏飞",{"v":2.0371592539454806,"d":"2.037"},{"v":0,"d":"0.000"},{"v":2.0371592539454806,"d":"2.037"},28]
["201523201702015","沈世超",{"v":2.0261119081779055,"d":"2.026"},{"v":0,"d":"0.000"},{"v":2.0261119081779055,"d":"2.026"},29]
["201523201702011","姜方乐",{"v":1.919368723098996,"d":"1.919"},{"v":0,"d":"0.000"},{"v":1.919368723098996,"d":"1.919"},30]
["201523201701022","张宏瑞",{"v":1.7282639885222384,"d":"1.728"},{"v":0,"d":"0.000"},{"v":1.7282639885222384,"d":"1.728"},31]
["201523202101029","刘汉卿",{"v":1.7256371814092955,"d":"1.726"},{"v":0,"d":"0.000"},{"v":1.7256371814092955,"d":"1.726"},32]
["201523201701016","俞涛",{"v":1.7071736011477763,"d":"1.707"},{"v":0,"d":"0.000"},{"v":1.7071736011477763,"d":"1.707"},33]
["201523201701026","张扬",{"v":1.70545193687231,"d":"1.705"},{"v":0,"d":"0.000"},{"v":1.70545193687231,"d":"1.705"},34]
["201523201702023","李财宣",{"v":1.6519368723099002,"d":"1.652"},{"v":0,"d":"0.000"},{"v":1.6519368723099002,"d":"1.652"},35]
["201323201702025","严发展",{"v":1.6478806907378336,"d":"1.648"},{"v":0,"d":"0.000"},{"v":1.6478806907378336,"d":"1.648"},36]
["201523201702018","王童彤",{"v":1.644045911047346,"d":"1.644"},{"v":0,"d":"0.000"},{"v":1.644045911047346,"d":"1.644"},37]
["201523201701030","邱黎明",{"v":1.5120516499282641,"d":"1.512"},{"v":0,"d":"0.000"},{"v":1.5120516499282641,"d":"1.512"},38]
["201523201702027","李维",{"v":1.4724533715925394,"d":"1.472"},{"v":0,"d":"0.000"},{"v":1.4724533715925394,"d":"1.472"},39]
["201523201701028","贺达",{"v":1.1164992826398854,"d":"1.116"},{"v":0,"d":"0.000"},{"v":1.1164992826398854,"d":"1.116"},40]
[]
["备注：加分项为0表示该生未向学院提交加分项目证明材料。"]