{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["15-16-1","15-16-2","成绩汇总表","成绩排名"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"15-16-1","index":0,"n_rows":59,"n_cols":29,"rows_kept":59,"flags":["formulas_cached_only"]}
["学号","姓名","体育 [2]","无机化学 [3]","学分","绩点","人体解剖学 [4]","学分","绩点","专业导论(生物科学) [1]","学分","绩点","大学英语 [5]","学分","绩点","中国近现代史纲要 [2]","学分","绩点","形势与政策 [.3]","学分","绩点","军事理论课 [2]","学分","绩点","大学生心理健康教育 [2]","学分","绩点","学期学分","学期学分绩点"]
["201512200501001","陆艺军",69,77,3,2.7,80,4,{"v":3,"d":"3.0"},92,1,4.2,80,5,{"v":3,"d":"3.0"},83,2,3.3,80,0.3,{"v":3,"d":"3.0"},91,2,4.1,90,2,{"v":4,"d":"4.0"},19.3,63]
["201512200501003","蒋思凡",69,85,3,3.5,80,4,{"v":3,"d":"3.0"},90,1,{"v":4,"d":"4.0"},85,5,3.5,82,2,3.2,79,0.3,2.9,79,2,2.9,90,2,{"v":4,"d":"4.0"},19.3,65.07]
["201512200501006","王潇妮",73,54,3,{"v":0,"d":"0.0"},53,4,{"v":0,"d":"0.0"},89,1,3.9,70,5,{"v":2,"d":"2.0"},81,2,3.1,82,0.3,3.2,86,2,3.6,90,2,{"v":4,"d":"4.0"},19.3,36.260000000000005]
["201512200501007","李紫妍",80,75,3,2.5,66,4,1.6,86,1,3.6,73,5,2.3,77,2,2.7,83,0.3,3.3,93,2,4.3,86,2,3.6,19.3,51.190000000000005]
["201512200501008","陈旭旭",72,83,3,3.3,74,4,2.4,85,1,3.5,78,5,2.8,82,2,3.2,84,0.3,3.4,87,2,3.7,89,2,3.9,19.3,59.62]
["201512200501009","徐锦绣",80,52,3,{"v":0,"d":"0.0"},50,4,{"v":0,"d":"0.0"},91,1,4.1,78,5,2.8,81,2,3.1,83,0.3,3.3,87,2,3.7,88,2,3.8,19.3,40.29]
["201512200501010","何倩虹",72,54,3,{"v":0,"d":"0.0"},49,4,{"v":0,"d":"0.0"},86,1,3.6,77,5,2.7,77,2,2.7,84,0.3,3.4,79,2,2.9,89,2,3.9,19.3,37.12]
["201512200501011","胡洪豪",80,76,3,2.6,61,4,1.1,93,1,4.3,75,5,2.5,83,2,3.3,75,0.3,2.5,78,2,2.8,87,2,3.7,19.3,49.35]
["201512200501013","杨华杰",84,84,3,3.4,64,4,1.4,87,1,3.7,65,5,1.5,80,2,{"v":3,"d":"3.0"},76,0.3,2.6,77,2,2.7,85,2,3.5,19.3,46.18]
["201512200501014","江楠楠",78,65,3,1.5,64,4,1.4,86,1,3.6,78,5,2.8,76,2,2.6,84,0.3,3.4,81,2,3.1,88,2,3.8,19.3,47.720000000000006]
["201512200501015","李佳",70,69,3,1.9,61,4,1.1,84,1,3.4,76,5,2.6,80,2,{"v":3,"d":"3.0"},82,0.3,3.2,78,2,2.8,84,2,3.4,19.3,45.86]
["201512200501016","施祖建",75,67,3,1.7,61,4,1.1,89,1,3.9,60,5,{"v":1,"d":"1.0"},81,2,3.1,83,0.3,3.3,69,2,1.9,80,2,{"v":3,"d":"3.0"},19.3,35.39]
["201512200501017","黄正栋",78,77,3,2.7,75,4,2.5,89,1,3.9,72,5,2.2,78,2,2.8,77,0.3,2.7,87,2,3.7,88,2,3.8,19.3,54.410000000000004]
["201512200501018","管丽萍",80,81,3,3.1,80,4,{"v":3,"d":"3.0"},85,1,3.5,85,5,3.5,78,2,2.8,84,0.3,3.4,85,2,3.5,88,2,3.8,19.3,63.52]
["201512200501019","孙洁",78,70,3,{"v":2,"d":"2.0"},83,4,3.3,93,1,4.3,76,5,2.6,89,2,3.9,84,0.3,3.4,95,2,4.5,88,2,3.8,19.3,61.92]
["201512200501020","王嘉辉",71,80,3,{"v":3,"d":"3.0"},71,4,2.1,89,1,3.9,60,5,{"v":1,"d":"1.0"},82,2,3.2,79,0.3,2.9,89,2,3.9,85,2,3.5,19.3,48.36999999999999]
["201512200501021","廖灵琳",73,61,3,1.1,50,4,{"v":0,"d":"0.0"},87,1,3.7,71,5,2.1,82,2,3.2,85,0.3,3.5,71,2,2.1,83,2,3.3,19.3,35.75]
["201512200501023","刘丹琪",83,73,3,2.3,79,4,2.9,85,1,3.5,62,5,1.2,84,2,3.4,76,0.3,2.6,77,2,2.7,86,2,3.6,19.3,48.18]
["201512200501024","朱思迪",74,66,3,1.6,78,4,2.8,90,1,{"v":4,"d":"4.0"},65,5,1.5,82,2,3.2,79,0.3,2.9,87,2,3.7,88,2,3.8,19.3,49.769999999999996]
["201512200501028","杜国强",70,68,3,1.8,72,4,2.2,93,1,4.3,60,5,{"v":1,"d":"1.0"},74,2,2.4,81,0.3,3.1,90,2,{"v":4,"d":"4.0"},87,2,3.7,19.3,44.63]
["201512200501029","盛俊祥",74,68,3,1.8,60,4,{"v":1,"d":"1.0"},86,1,3.6,54,5,{"v":0,"d":"0.0"},83,2,3.3,76,0.3,2.6,87,2,3.7,78,2,2.8,19.3,33.38]
["201512200501030","刘禹臣",86,76,3,2.6,85,4,3.5,89,1,3.9,55,5,{"v":0,"d":"0.0"},85,2,3.5,80,0.3,{"v":3,"d":"3.0"},88,2,3.8,88,2,3.8,19.3,48.800000000000004]
["201512200501031","常开心",87,62,3,1.2,79,4,2.9,85,1,3.5,68,5,1.8,84,2,3.4,78,0.3,2.8,87,2,3.7,86,2,3.6,19.3,49.940000000000005]
["201512200501032","赵方方",86,82,3,3.2,82,4,3.2,89,1,3.9,75,5,2.5,82,2,3.2,85,0.3,3.5,93,2,4.3,88,2,3.8,19.3,62.449999999999996]
["201512200501033","沈明",74,42,3,{"v":0,"d":"0.0"},40,4,{"v":0,"d":"0.0"},83,1,3.3,67,5,1.7,71,2,2.1,77,0.3,2.7,92,2,4.2,84,2,3.4,19.3,32.01]
["201512200501034","常俊一",73,68,3,1.8,79,4,2.9,87,1,3.7,73,5,2.3,75,2,2.5,80,0.3,{"v":3,"d":"3.0"},92,2,4.2,87,2,3.7,19.3,53.9]
["201512200501035","马莹莹",71,68,3,1.8,63,4,1.3,85,1,3.5,76,5,2.6,80,2,{"v":3,"d":"3.0"},82,0.3,3.2,94,2,4.4,91,2,4.1,19.3,51.06]
["201512200502003","蔡丽",75,60,3,{"v":1,"d":"1.0"},76,4,2.6,85,1,3.5,85,5,3.5,84,2,3.4,80,0.3,{"v":3,"d":"3.0"},87,2,3.7,91,2,4.1,19.3,57.69999999999999]
["201512200502005","徐卓政",60,87,3,3.7,76,4,2.6,91,1,4.1,72,5,2.2,80,2,{"v":3,"d":"3.0"},78,0.3,2.8,93,2,4.3,85,2,3.5,19.3,59.040000000000006]
["201512200502006","梁浩威",69,82,3,3.2,55,4,{"v":0,"d":"0.0"},86,1,3.6,57,5,{"v":0,"d":"0.0"},80,2,{"v":3,"d":"3.0"},84,0.3,3.4,67,2,1.7,75,2,2.5,19.3,28.62]
["201512200502007","丁沈威",79,86,3,3.6,86,4,3.6,87,1,3.7,88,5,3.8,82,2,3.2,81,0.3,3.1,89,2,3.9,90,2,{"v":4,"d":"4.0"},19.3,71.03]
["201512200502010","陈嘉威",80,69,3,1.9,67,4,1.7,85,1,3.5,73,5,2.3,79,2,2.9,77,0.3,2.7,84,2,3.4,88,2,3.8,19.3,48.51]
["201512200502012","朱彦超",85,93,3,4.3,77,4,2.7,93,1,4.3,76,5,2.6,88,2,3.8,81,0.3,3.1,92,2,4.2,90,2,{"v":4,"d":"4.0"},19.3,65.93]
["201512200502013","岳凯平",78,76,3,2.6,71,4,2.1,85,1,3.5,79,5,2.9,79,2,2.9,82,0.3,3.2,93,2,4.3,85,2,3.5,19.3,56.56]
["201512200502014","倪煜",71,68,3,1.8,71,4,2.1,85,1,3.5,73,5,2.3,78,2,2.8,77,0.3,2.7,81,2,3.1,85,2,3.5,19.3,48.410000000000004]
["201512200502015","蒋凯",81,77,3,2.7,61,4,1.1,85,1,3.5,66,5,1.6,80,2,{"v":3,"d":"3.0"},76,0.3,2.6,82,2,3.2,89,2,3.9,19.3,44.98]
["201512200502016","胡霏旭",77,72,3,2.2,68,4,1.8,85,1,3.5,80,5,{"v":3,"d":"3.0"},78,2,2.8,82,0.3,3.2,82,2,3.2,86,2,3.6,19.3,52.46]
["201512200502017","章沛沛",79,60,3,{"v":1,"d":"1.0"},70,4,{"v":2,"d":"2.0"},85,1,3.5,64,5,1.4,82,2,3.2,83,0.3,3.3,83,2,3.3,84,2,3.4,19.3,42.28999999999999]
["201512200502018","王宇萍",72,60,3,{"v":1,"d":"1.0"},67,4,1.7,90,1,{"v":4,"d":"4.0"},74,5,2.4,85,2,3.5,81,0.3,3.1,83,2,3.3,85,2,3.5,19.3,47.33]
["201512200502019","陆张璐",80,75,3,2.5,74,4,2.4,86,1,3.6,77,5,2.7,82,2,3.2,79,0.3,2.9,76,2,2.6,86,2,3.6,19.3,53.870000000000005]
["201512200502020","钱怡卉",82,82,3,3.2,75,4,2.5,89,1,3.9,80,5,{"v":3,"d":"3.0"},80,2,{"v":3,"d":"3.0"},81,0.3,3.1,91,2,4.1,89,2,3.9,19.3,61.42999999999999]
["201512200502021","钱得进",64,62,3,1.2,55,4,{"v":0,"d":"0.0"},85,1,3.5,64,5,1.4,73,2,2.3,81,0.3,3.1,82,2,3.2,79,2,2.9,19.3,31.830000000000002]
["201512200502022","刘大庆",77,74,3,2.4,74,4,2.4,85,1,3.5,63,5,1.3,70,2,{"v":2,"d":"2.0"},76,0.3,2.6,63,2,1.3,86,2,3.6,19.3,41.38]
["201512200502023","岑满如",89,64,3,1.4,73,4,2.3,85,1,3.5,70,5,{"v":2,"d":"2.0"},77,2,2.7,80,0.3,{"v":3,"d":"3.0"},83,2,3.3,88,2,3.8,19.3,47.4]
["201512200502024","燕若鹏",81,76,3,2.6,73,4,2.3,85,1,3.5,85,5,3.5,85,2,3.5,84,0.3,3.4,81,2,3.1,86,2,3.6,19.3,59.42000000000001]
["201512200502025","毛明杰",68,65,3,1.5,66,4,1.6,85,1,3.5,76,5,2.6,71,2,2.1,76,0.3,2.6,80,2,{"v":3,"d":"3.0"},85,2,3.5,19.3,45.379999999999995]
["201512200502026","金卓",74,75,3,2.5,82,4,3.2,85,1,3.5,84,5,3.4,79,2,2.9,78,0.3,2.8,87,2,3.7,82,2,3.2,19.3,61.239999999999995]
["201512200502027","任璇",79,77,3,2.7,78,4,2.8,90,1,{"v":4,"d":"4.0"},53,5,{"v":0,"d":"0.0"},78,2,2.8,76,0.3,2.6,91,2,4.1,84,2,3.4,19.3,44.67999999999999]
["201512200502028","王家洁",90,78,3,2.8,78,4,2.8,92,1,4.2,56,5,{"v":0,"d":"0.0"},83,2,3.3,79,0.3,2.9,83,2,3.3,90,2,{"v":4,"d":"4.0"},19.3,45.87]
["201512200502029","陆桂桃",85,69,3,1.9,72,4,2.2,89,1,3.9,85,5,3.5,77,2,2.7,75,0.3,2.5,82,2,3.2,90,2,{"v":4,"d":"4.0"},19.3,56.449999999999996]
["201512200502030","王书卿",62,60,3,{"v":1,"d":"1.0"},49,4,{"v":0,"d":"0.0"},85,1,3.5,60,5,{"v":1,"d":"1.0"},66,2,1.6,78,0.3,2.8,80,2,{"v":3,"d":"3.0"},79,2,2.9,19.3,27.34]
["201512200502031","张琪",66,69,3,1.9,76,4,2.6,87,1,3.7,70,5,{"v":2,"d":"2.0"},77,2,2.7,75,0.3,2.5,76,2,2.6,90,2,{"v":4,"d":"4.0"},19.3,49.150000000000006]
["201512200502032","王晓玉",67,54,3,{"v":0,"d":"0.0"},77,4,2.7,85,1,3.5,53,5,{"v":0,"d":"0.0"},77,2,2.7,82,0.3,3.2,81,2,3.1,85,2,3.5,19.3,33.86]
["201512200502033","刘玉媛",66,52,3,{"v":0,"d":"0.0"},63,4,1.3,86,1,3.6,67,5,1.7,79,2,2.9,79,0.3,2.9,64,2,1.4,81,2,3.1,19.3,32.970000000000006]
["201512200502034","吴琼",76,74,3,2.4,75,4,2.5,90,1,{"v":4,"d":"4.0"},77,5,2.7,85,2,3.5,77,0.3,2.7,81,2,3.1,89,2,3.9,19.3,56.510000000000005]
["201512200502035","唐世帆",75,82,3,3.2,88,4,3.8,91,1,4.1,84,5,3.4,84,2,3.4,80,0.3,{"v":3,"d":"3.0"},90,2,{"v":4,"d":"4.0"},89,2,3.9,19.3,69.39999999999999]
["201512200601020","吴相尧",74,{"$nulls":3},62,4,1.2,85,1,3.5,74,5,2.4,76,2,2.6,83,0.3,3.3,90,2,{"v":4,"d":"4.0"},92,2,4.2,16.3,42.88999999999999]
["201512202401019","王烨",76,{"$nulls":6},"良好",1,3.5,78,5,2.8,82,2,3.2,81,0.3,3.1,85,2,3.5,86,2,3.6,12.3,39.03]

{"sheet":"15-16-2","index":1,"n_rows":59,"n_cols":32,"rows_kept":59,"flags":["formulas_cached_only"]}
["学号","姓名","体育（2） [2]","有机化学 [3]","学分","绩点","分析化学 [3]","学分","绩点","高等数学 [3]","学分","绩点","植物学 [3]","学分","绩点","动物学 [2.5]","学分","绩点","思想道德修养与法律基础 [3]","学分","绩点","形势与政策 [.3]","学分","绩点","大学生就业指导与创业教育 [1]","学分","绩点","大学英语（2） [5]","学分","绩点","学期学分","学期学分绩点"]
["201512200501001","陆艺军",81,68,3,1.8,62,3,1.2,66,3,1.6,66,3,1.6,89,2.5,3.9,86,3,3.6,86,0.3,3.6,92,1,4.2,85,5,3.5,23.8,61.93000000000001]
["201512200501003","蒋思凡",84,89,3,3.9,79,3,2.9,83,3,3.3,69,3,1.9,89,2.5,3.9,86,3,3.6,83,0.3,3.3,91,1,4.1,84,5,3.4,23.8,78.64]
["201512200501006","王潇妮",72,60,3,{"v":1,"d":"1.0"},65,3,1.5,66,3,1.6,66,3,1.6,90,2.5,{"v":4,"d":"4.0"},83,3,3.3,88,0.3,3.8,94,1,4.4,74,5,2.4,23.8,54.54]
["201512200501007","李紫妍",89,80,3,{"v":3,"d":"3.0"},75,3,2.5,78,3,2.8,73,3,2.3,91,2.5,4.1,86,3,3.6,89,0.3,3.9,96,1,4.6,75,5,2.5,23.8,71.12]
["201512200501008","陈旭旭",83,83,3,3.3,86,3,3.6,82,3,3.2,81,3,3.1,88,2.5,3.8,87,3,3.7,92,0.3,4.2,93,1,4.3,82,5,3.2,23.8,81.76]
["201512200501009","徐锦绣",90,77,3,2.7,69,3,1.9,74,3,2.4,60,3,{"v":1,"d":"1.0"},81,2.5,3.1,86,3,3.6,96,0.3,4.6,94,1,4.4,78,5,2.8,23.8,62.33]
["201512200501010","何倩虹",88,78,3,2.8,76,3,2.6,70,3,{"v":2,"d":"2.0"},70,3,{"v":2,"d":"2.0"},79,2.5,2.9,86,3,3.6,87,0.3,3.7,92,1,4.2,77,5,2.7,23.8,65.06]
["201512200501011","胡洪豪",88,69,3,1.9,71,3,2.1,84,3,3.4,69,3,1.9,85,2.5,3.5,84,3,3.4,88,0.3,3.8,96,1,4.6,78,5,2.8,23.8,66.59]
["201512200501013","杨华杰",81,65,3,1.5,68,3,1.8,82,3,3.2,60,3,{"v":1,"d":"1.0"},76,2.5,2.6,84,3,3.4,79,0.3,2.9,94,1,4.4,66,5,1.6,23.8,52.47]
["201512200501014","江楠楠",84,70,3,{"v":2,"d":"2.0"},62,3,1.2,64,3,1.4,68,3,1.8,76,2.5,2.6,86,3,3.6,95,0.3,4.5,94,1,4.4,86,5,3.6,23.8,60.25]
["201512200501015","李佳",84,79,3,2.9,77,3,2.7,93,3,4.3,60,3,{"v":1,"d":"1.0"},85,2.5,3.5,86,3,3.6,94,0.3,4.4,94,1,4.4,81,5,3.1,23.8,73.47]
["201512200501016","施祖建",79,78,3,2.8,61,3,1.1,75,3,2.5,67,3,1.7,84,2.5,3.4,85,3,3.5,90,0.3,{"v":4,"d":"4.0"},94,1,4.4,60,5,{"v":1,"d":"1.0"},23.8,53.9]
["201512200501017","黄正栋",86,68,3,1.8,64,3,1.4,74,3,2.4,61,3,1.1,86,2.5,3.6,85,3,3.5,89,0.3,3.9,90,1,{"v":4,"d":"4.0"},71,5,2.1,23.8,55.269999999999996]
["201512200501018","管丽萍",95,67,3,1.7,79,3,2.9,69,3,1.9,75,3,2.5,93,2.5,4.3,87,3,3.7,90,0.3,{"v":4,"d":"4.0"},97,1,4.7,80,5,{"v":3,"d":"3.0"},23.8,69.75]
["201512200501019","孙洁",84,71,3,2.1,76,3,2.6,75,3,2.5,77,3,2.7,82,2.5,3.2,89,3,3.9,88,0.3,3.8,93,1,4.3,72,5,2.2,23.8,65.84]
["201512200501020","王嘉辉",82,78,3,2.8,60,3,{"v":1,"d":"1.0"},74,3,2.4,60,3,{"v":1,"d":"1.0"},88,2.5,3.8,82,3,3.2,86,0.3,3.6,93,1,4.3,60,5,{"v":1,"d":"1.0"},23.8,51.08]
["201512200501021","廖灵琳",76,61,3,1.1,62,3,1.2,61,3,1.1,60,3,{"v":1,"d":"1.0"},67,2.5,1.7,88,3,3.8,88,0.3,3.8,95,1,4.5,71,5,2.1,23.8,44.99]
["201512200501023","刘丹琪",84,73,3,2.3,67,3,1.7,71,3,2.1,71,3,2.1,86,2.5,3.6,87,3,3.7,83,0.3,3.3,92,1,4.2,68,5,1.8,23.8,58.89000000000001]
["201512200501024","朱思迪",79,74,3,2.4,82,3,3.2,65,3,1.5,64,3,1.4,89,2.5,3.9,91,3,4.1,88,0.3,3.8,91,1,4.1,66,5,1.6,23.8,60.79]
["201512200501028","杜国强",70,71,3,2.1,48,3,{"v":0,"d":"0.0"},75,3,2.5,64,3,1.4,90,2.5,{"v":4,"d":"4.0"},84,3,3.4,94,0.3,4.4,91,1,4.1,57,5,{"v":0,"d":"0.0"},23.8,43.620000000000005]
["201512200501029","盛俊祥",81,52,3,{"v":0,"d":"0.0"},61,3,1.1,70,3,{"v":2,"d":"2.0"},66,3,1.6,87,2.5,3.7,85,3,3.5,87,0.3,3.7,90,1,{"v":4,"d":"4.0"},58,5,{"v":0,"d":"0.0"},23.8,38.96]
["201512200501030","刘禹臣",82,84,3,3.4,71,3,2.1,87,3,3.7,76,3,2.6,88,2.5,3.8,86,3,3.6,90,0.3,{"v":4,"d":"4.0"},94,1,4.4,69,5,1.9,23.8,70.80000000000001]
["201512200501031","常开心",82,66,3,1.6,67,3,1.7,82,3,3.2,69,3,1.9,93,2.5,4.3,87,3,3.7,91,0.3,4.1,92,1,4.2,60,5,{"v":1,"d":"1.0"},23.8,57.480000000000004]
["201512200501032","赵方方",85,66,3,1.6,65,3,1.5,71,3,2.1,72,3,2.2,78,2.5,2.8,87,3,3.7,91,0.3,4.1,95,1,4.5,73,5,2.3,23.8,57.53]
["201512200501033","沈明",80,64,3,1.4,51,3,{"v":0,"d":"0.0"},71,3,2.1,75,3,2.5,72,2.5,2.2,89,3,3.9,86,0.3,3.6,93,1,4.3,66,5,1.6,23.8,48.58]
["201512200501034","常俊一",90,88,3,3.8,74,3,2.4,70,3,{"v":2,"d":"2.0"},84,3,3.4,87,2.5,3.7,90,3,{"v":4,"d":"4.0"},88,0.3,3.8,93,1,4.3,69,5,1.9,23.8,70.99]
["201512200501035","马莹莹",85,65,3,1.5,76,3,2.6,76,3,2.6,81,3,3.1,79,2.5,2.9,89,3,3.9,87,0.3,3.7,94,1,4.4,69,5,1.9,23.8,63.36000000000001]
["201512200502003","蔡丽",87,60,3,{"v":1,"d":"1.0"},65,3,1.5,60,3,{"v":1,"d":"1.0"},66,3,1.6,71,2.5,2.1,85,3,3.5,74,0.3,2.4,94,1,4.4,87,5,3.7,23.8,54.67]
["201512200502005","徐卓政",60,84,3,3.4,71,3,2.1,74,3,2.4,73,3,2.3,89,2.5,3.9,89,3,3.9,94,0.3,4.4,96,1,4.6,80,5,{"v":3,"d":"3.0"},23.8,72.97]
["201512200502006","梁浩威",81,70,3,{"v":2,"d":"2.0"},69,3,1.9,74,3,2.4,70,3,{"v":2,"d":"2.0"},85,2.5,3.5,87,3,3.7,89,0.3,3.9,91,1,4.1,73,5,2.3,23.8,61.52]
["201512200502007","丁沈威",82,84,3,3.4,85,3,3.5,86,3,3.6,75,3,2.5,92,2.5,4.2,84,3,3.4,88,0.3,3.8,93,1,4.3,82,5,3.2,23.8,81.14]
["201512200502010","陈嘉威",71,66,3,1.6,61,3,1.1,82,3,3.2,78,3,2.8,80,2.5,{"v":3,"d":"3.0"},86,3,3.6,84,0.3,3.4,94,1,4.4,72,5,2.2,23.8,60.82000000000001]
["201512200502012","朱彦超",85,88,3,3.8,87,3,3.7,88,3,3.8,74,3,2.4,91,2.5,4.1,89,3,3.9,96,0.3,4.6,97,1,4.7,67,5,1.7,23.8,77.63]
["201512200502013","岳凯平",87,80,3,{"v":3,"d":"3.0"},62,3,1.2,79,3,2.9,66,3,1.6,78,2.5,2.8,86,3,3.6,76,0.3,2.6,91,1,4.1,75,5,2.5,23.8,61.279999999999994]
["201512200502014","倪煜",75,72,3,2.2,65,3,1.5,73,3,2.3,60,3,{"v":1,"d":"1.0"},72,2.5,2.2,87,3,3.7,77,0.3,2.7,94,1,4.4,76,5,2.6,23.8,55.81]
["201512200502015","蒋凯",74,71,3,2.1,69,3,1.9,81,3,3.1,75,3,2.5,88,2.5,3.8,86,3,3.6,81,0.3,3.1,96,1,4.6,64,5,1.4,23.8,61.629999999999995]
["201512200502016","胡霏旭",89,80,3,{"v":3,"d":"3.0"},75,3,2.5,82,3,3.2,67,3,1.7,90,2.5,{"v":4,"d":"4.0"},88,3,3.8,91,0.3,4.1,97,1,4.7,88,5,3.8,23.8,77.53]
["201512200502017","章沛沛",82,74,3,2.4,60,3,{"v":1,"d":"1.0"},73,3,2.3,70,3,{"v":2,"d":"2.0"},82,2.5,3.2,85,3,3.5,80,0.3,{"v":3,"d":"3.0"},94,1,4.4,70,5,{"v":2,"d":"2.0"},23.8,56.89999999999999]
["201512200502018","王宇萍",71,68,3,1.8,72,3,2.2,78,3,2.8,70,3,{"v":2,"d":"2.0"},83,2.5,3.3,84,3,3.4,90,0.3,{"v":4,"d":"4.0"},95,1,4.5,86,5,3.6,23.8,68.55]
["201512200502019","陆张璐",85,76,3,2.6,79,3,2.9,83,3,3.3,74,3,2.4,86,2.5,3.6,86,3,3.6,94,0.3,4.4,96,1,4.6,86,5,3.6,23.8,77.32]
["201512200502020","钱怡卉",87,80,3,{"v":3,"d":"3.0"},75,3,2.5,70,3,{"v":2,"d":"2.0"},75,3,2.5,87,2.5,3.7,88,3,3.8,84,0.3,3.4,94,1,4.4,74,5,2.4,23.8,68.07]
["201512200502021","钱得进",0,50,3,{"v":0,"d":"0.0"},54,3,{"v":0,"d":"0.0"},76,3,2.6,0,3,{"v":0,"d":"0.0"},79,2.5,2.9,86,3,3.6,88,0.3,3.8,90,1,{"v":4,"d":"4.0"},69,5,1.9,23.8,40.49]
["201512200502022","刘大庆",77,60,3,{"v":1,"d":"1.0"},60,3,{"v":1,"d":"1.0"},64,3,1.4,66,3,1.6,73,2.5,2.3,83,3,3.3,81,0.3,3.1,94,1,4.4,65,5,1.5,23.8,43.48]
["201512200502023","岑满如",84,75,3,2.5,61,3,1.1,66,3,1.6,68,3,1.8,86,2.5,3.6,83,3,3.3,89,0.3,3.9,93,1,4.3,68,5,1.8,23.8,54.37]
["201512200502024","燕若鹏",84,66,3,1.6,68,3,1.8,80,3,{"v":3,"d":"3.0"},68,3,1.8,93,2.5,4.3,88,3,3.8,88,0.3,3.8,97,1,4.7,87,5,3.7,23.8,71.09]
["201512200502025","毛明杰",80,61,3,1.1,47,3,{"v":0,"d":"0.0"},76,3,2.6,71,3,2.1,69,2.5,1.9,84,3,3.4,89,0.3,3.9,91,1,4.1,71,5,2.1,23.8,48.120000000000005]
["201512200502026","金卓",83,76,3,2.6,85,3,3.5,87,3,3.7,75,3,2.5,88,2.5,3.8,87,3,3.7,97,0.3,4.7,97,1,4.7,81,5,3.1,23.8,79.11000000000001]
["201512200502027","任璇",75,87,3,3.7,78,3,2.8,85,3,3.5,72,3,2.2,86,2.5,3.6,88,3,3.8,90,0.3,{"v":4,"d":"4.0"},97,1,4.7,56,5,{"v":0,"d":"0.0"},23.8,62.900000000000006]
["201512200502028","王家洁",88,84,3,3.4,76,3,2.6,78,3,2.8,74,3,2.4,83,2.5,3.3,89,3,3.9,99,0.3,4.9,97,1,4.7,72,5,2.2,23.8,70.72]
["201512200502029","陆桂桃",92,75,3,2.5,69,3,1.9,82,3,3.2,79,3,2.9,79,2.5,2.9,86,3,3.6,73,0.3,2.3,96,1,4.6,82,5,3.2,23.8,70.84]
["201512200502030","王书卿",78,60,3,{"v":1,"d":"1.0"},48,3,{"v":0,"d":"0.0"},67,3,1.7,60,3,{"v":1,"d":"1.0"},75,2.5,2.5,85,3,3.5,92,0.3,4.2,95,1,4.5,71,5,2.1,23.8,44.11]
["201512200502031","张琪",77,60,3,{"v":1,"d":"1.0"},64,3,1.4,62,3,1.2,77,3,2.7,79,2.5,2.9,82,3,3.2,90,0.3,{"v":4,"d":"4.0"},90,1,{"v":4,"d":"4.0"},62,5,1.2,23.8,46.95]
["201512200502032","王晓玉",67,64,3,1.4,42,3,{"v":0,"d":"0.0"},61,3,1.1,64,3,1.4,68,2.5,1.8,84,3,3.4,84,0.3,3.4,94,1,4.4,53,5,{"v":0,"d":"0.0"},23.8,31.82]
["201512200502033","刘玉媛",70,62,3,1.2,50,3,{"v":0,"d":"0.0"},55,3,{"v":0,"d":"0.0"},0,3,{"v":0,"d":"0.0"},68,2.5,1.8,83,3,3.3,89,0.3,3.9,92,1,4.2,75,5,2.5,23.8,35.870000000000005]
["201512200502034","吴琼",79,66,3,1.6,52,3,{"v":0,"d":"0.0"},65,3,1.5,0,3,{"v":0,"d":"0.0"},85,2.5,3.5,85,3,3.5,88,0.3,3.8,96,1,4.6,78,5,2.8,23.8,48.29]
["201512200502035","唐世帆",73,77,3,2.7,82,3,3.2,84,3,3.4,76,3,2.6,86,2.5,3.6,87,3,3.7,88,0.3,3.8,97,1,4.7,86,5,3.6,23.8,79.64000000000001]
["201512200601020","吴相尧",60,65,3,1.5,60,3,{"v":1,"d":"1.0"},67,3,1.7,64,3,1.4,66,2.5,1.6,87,3,3.7,67,0.3,1.7,93,1,4.3,70,5,{"v":2,"d":"2.0"},23.8,46.709999999999994]
["201512202401019","王烨",89,69,3,1.9,62,3,1.2,76,3,2.6,79,3,2.9,85,2.5,3.5,83,3,3.3,97,0.3,4.7,96,1,4.6,83,5,3.3,23.8,66.96]

{"sheet":"成绩汇总表","index":2,"n_rows":59,"n_cols":58,"rows_kept":59,"flags":["formulas_cached_only"]}
["学号","姓名","体育 [2]","体育（2） [2]","无机化学 [3]","学分","绩点","人体解剖学 [4]","学分","绩点","专业导论(生物科学) [1]","学分","绩点","大学英语 [5]","学分","绩点","中国近现代史纲要 [2]","学分","绩点","形势与政策 [.3]","学分","绩点","军事理论课 [2]","学分","绩点","大学生心理健康教育 [2]","学分","绩点","有机化学 [3]","学分","绩点","分析化学 [3]","学分","绩点","高等数学 [3]","学分","绩点","植物学 [3]","学分","绩点","动物学 [2.5]","学分","绩点","思想道德修养与法律基础 [3]","学分","绩点","形势与政策 [.3]","学分","绩点","大学生就业指导与创业教育 [1]","学分","绩点","大学英语（2） [5]","学分","绩点","总学分","总学分绩点","加权平均绩点"]
["201512200501001","陆艺军",69,81,77,3,2.7,80,4,{"v":3,"d":"3.0"},92,1,4.2,80,5,{"v":3,"d":"3.0"},83,2,3.3,80,0.3,{"v":3,"d":"3.0"},91,2,4.1,90,2,{"v":4,"d":"4.0"},68,3,1.8,62,3,1.2,66,3,1.6,66,3,1.6,89,2.5,3.9,86,3,3.6,86,0.3,3.6,92,1,4.2,85,5,3.5,43.099999999999994,124.92999999999999,{"v":2.8986078886310906,"d":"2.90"}]
["201512200501003","蒋思凡",69,84,85,3,3.5,80,4,{"v":3,"d":"3.0"},90,1,{"v":4,"d":"4.0"},85,5,3.5,82,2,3.2,79,0.3,2.9,79,2,2.9,90,2,{"v":4,"d":"4.0"},89,3,3.9,79,3,2.9,83,3,3.3,69,3,1.9,89,2.5,3.9,86,3,3.6,83,0.3,3.3,91,1,4.1,84,5,3.4,43.099999999999994,143.70999999999998,{"v":3.334338747099768,"d":"3.33"}]
["201512200501006","王潇妮",73,72,54,3,{"v":0,"d":"0.0"},53,4,{"v":0,"d":"0.0"},89,1,3.9,70,5,{"v":2,"d":"2.0"},81,2,3.1,82,0.3,3.2,86,2,3.6,90,2,{"v":4,"d":"4.0"},60,3,{"v":1,"d":"1.0"},65,3,1.5,66,3,1.6,66,3,1.6,90,2.5,{"v":4,"d":"4.0"},83,3,3.3,88,0.3,3.8,94,1,4.4,74,5,2.4,43.099999999999994,90.8,{"v":2.106728538283063,"d":"2.11"}]
["201512200501007","李紫妍",80,89,75,3,2.5,66,4,1.6,86,1,3.6,73,5,2.3,77,2,2.7,83,0.3,3.3,93,2,4.3,86,2,3.6,80,3,{"v":3,"d":"3.0"},75,3,2.5,78,3,2.8,73,3,2.3,91,2.5,4.1,86,3,3.6,89,0.3,3.9,96,1,4.6,75,5,2.5,43.099999999999994,122.31,{"v":2.8378190255220423,"d":"2.84"}]
["201512200501008","陈旭旭",72,83,83,3,3.3,74,4,2.4,85,1,3.5,78,5,2.8,82,2,3.2,84,0.3,3.4,87,2,3.7,89,2,3.9,83,3,3.3,86,3,3.6,82,3,3.2,81,3,3.1,88,2.5,3.8,87,3,3.7,92,0.3,4.2,93,1,4.3,82,5,3.2,43.099999999999994,141.38,{"v":3.280278422273782,"d":"3.28"}]
["201512200501009","徐锦绣",80,90,52,3,{"v":0,"d":"0.0"},50,4,{"v":0,"d":"0.0"},91,1,4.1,78,5,2.8,81,2,3.1,83,0.3,3.3,87,2,3.7,88,2,3.8,77,3,2.7,69,3,1.9,74,3,2.4,60,3,{"v":1,"d":"1.0"},81,2.5,3.1,86,3,3.6,96,0.3,4.6,94,1,4.4,78,5,2.8,43.099999999999994,102.62,{"v":2.380974477958237,"d":"2.38"}]
["201512200501010","何倩虹",72,88,54,3,{"v":0,"d":"0.0"},49,4,{"v":0,"d":"0.0"},86,1,3.6,77,5,2.7,77,2,2.7,84,0.3,3.4,79,2,2.9,89,2,3.9,78,3,2.8,76,3,2.6,70,3,{"v":2,"d":"2.0"},70,3,{"v":2,"d":"2.0"},79,2.5,2.9,86,3,3.6,87,0.3,3.7,92,1,4.2,77,5,2.7,43.099999999999994,102.17999999999999,{"v":2.3707656612529004,"d":"2.37"}]
["201512200501011","胡洪豪",80,88,76,3,2.6,61,4,1.1,93,1,4.3,75,5,2.5,83,2,3.3,75,0.3,2.5,78,2,2.8,87,2,3.7,69,3,1.9,71,3,2.1,84,3,3.4,69,3,1.9,85,2.5,3.5,84,3,3.4,88,0.3,3.8,96,1,4.6,78,5,2.8,43.099999999999994,115.94,{"v":2.6900232018561487,"d":"2.69"}]
["201512200501013","杨华杰",84,81,84,3,3.4,64,4,1.4,87,1,3.7,65,5,1.5,80,2,{"v":3,"d":"3.0"},76,0.3,2.6,77,2,2.7,85,2,3.5,65,3,1.5,68,3,1.8,82,3,3.2,60,3,{"v":1,"d":"1.0"},76,2.5,2.6,84,3,3.4,79,0.3,2.9,94,1,4.4,66,5,1.6,43.099999999999994,98.65000000000002,{"v":2.288863109048725,"d":"2.29"}]
["201512200501014","江楠楠",78,84,65,3,1.5,64,4,1.4,86,1,3.6,78,5,2.8,76,2,2.6,84,0.3,3.4,81,2,3.1,88,2,3.8,70,3,{"v":2,"d":"2.0"},62,3,1.2,64,3,1.4,68,3,1.8,76,2.5,2.6,86,3,3.6,95,0.3,4.5,94,1,4.4,86,5,3.6,43.099999999999994,107.97000000000001,{"v":2.505104408352669,"d":"2.51"}]
["201512200501015","李佳",70,84,69,3,1.9,61,4,1.1,84,1,3.4,76,5,2.6,80,2,{"v":3,"d":"3.0"},82,0.3,3.2,78,2,2.8,84,2,3.4,79,3,2.9,77,3,2.7,93,3,4.3,60,3,{"v":1,"d":"1.0"},85,2.5,3.5,86,3,3.6,94,0.3,4.4,94,1,4.4,81,5,3.1,43.099999999999994,119.33,{"v":2.7686774941995362,"d":"2.77"}]
["201512200501016","施祖建",75,79,67,3,1.7,61,4,1.1,89,1,3.9,60,5,{"v":1,"d":"1.0"},81,2,3.1,83,0.3,3.3,69,2,1.9,80,2,{"v":3,"d":"3.0"},78,3,2.8,61,3,1.1,75,3,2.5,67,3,1.7,84,2.5,3.4,85,3,3.5,90,0.3,{"v":4,"d":"4.0"},94,1,4.4,60,5,{"v":1,"d":"1.0"},43.099999999999994,89.29,{"v":2.0716937354988403,"d":"2.07"}]
["201512200501017","黄正栋",78,86,77,3,2.7,75,4,2.5,89,1,3.9,72,5,2.2,78,2,2.8,77,0.3,2.7,87,2,3.7,88,2,3.8,68,3,1.8,64,3,1.4,74,3,2.4,61,3,1.1,86,2.5,3.6,85,3,3.5,89,0.3,3.9,90,1,{"v":4,"d":"4.0"},71,5,2.1,43.099999999999994,109.68,{"v":2.5447795823665897,"d":"2.54"}]
["201512200501018","管丽萍",80,95,81,3,3.1,80,4,{"v":3,"d":"3.0"},85,1,3.5,85,5,3.5,78,2,2.8,84,0.3,3.4,85,2,3.5,88,2,3.8,67,3,1.7,79,3,2.9,69,3,1.9,75,3,2.5,93,2.5,4.3,87,3,3.7,90,0.3,{"v":4,"d":"4.0"},97,1,4.7,80,5,{"v":3,"d":"3.0"},43.099999999999994,133.27,{"v":3.092111368909513,"d":"3.09"}]
["201512200501019","孙洁",78,84,70,3,{"v":2,"d":"2.0"},83,4,3.3,93,1,4.3,76,5,2.6,89,2,3.9,84,0.3,3.4,95,2,4.5,88,2,3.8,71,3,2.1,76,3,2.6,75,3,2.5,77,3,2.7,82,2.5,3.2,89,3,3.9,88,0.3,3.8,93,1,4.3,72,5,2.2,43.099999999999994,127.76,{"v":2.964269141531323,"d":"2.96"}]
["201512200501020","王嘉辉",71,82,80,3,{"v":3,"d":"3.0"},71,4,2.1,89,1,3.9,60,5,{"v":1,"d":"1.0"},82,2,3.2,79,0.3,2.9,89,2,3.9,85,2,3.5,78,3,2.8,60,3,{"v":1,"d":"1.0"},74,3,2.4,60,3,{"v":1,"d":"1.0"},88,2.5,3.8,82,3,3.2,86,0.3,3.6,93,1,4.3,60,5,{"v":1,"d":"1.0"},43.099999999999994,99.44999999999999,{"v":2.3074245939675175,"d":"2.31"}]
["201512200501021","廖灵琳",73,76,61,3,1.1,50,4,{"v":0,"d":"0.0"},87,1,3.7,71,5,2.1,82,2,3.2,85,0.3,3.5,71,2,2.1,83,2,3.3,61,3,1.1,62,3,1.2,61,3,1.1,60,3,{"v":1,"d":"1.0"},67,2.5,1.7,88,3,3.8,88,0.3,3.8,95,1,4.5,71,5,2.1,43.099999999999994,80.74,{"v":1.8733178654292344,"d":"1.87"}]
["201512200501023","刘丹琪",83,84,73,3,2.3,79,4,2.9,85,1,3.5,62,5,1.2,84,2,3.4,76,0.3,2.6,77,2,2.7,86,2,3.6,73,3,2.3,67,3,1.7,71,3,2.1,71,3,2.1,86,2.5,3.6,87,3,3.7,83,0.3,3.3,92,1,4.2,68,5,1.8,43.099999999999994,107.07,{"v":2.484222737819026,"d":"2.48"}]
["201512200501024","朱思迪",74,79,66,3,1.6,78,4,2.8,90,1,{"v":4,"d":"4.0"},65,5,1.5,82,2,3.2,79,0.3,2.9,87,2,3.7,88,2,3.8,74,3,2.4,82,3,3.2,65,3,1.5,64,3,1.4,89,2.5,3.9,91,3,4.1,88,0.3,3.8,91,1,4.1,66,5,1.6,43.099999999999994,110.55999999999999,{"v":2.5651972157772622,"d":"2.57"}]
["201512200501028","杜国强",70,70,68,3,1.8,72,4,2.2,93,1,4.3,60,5,{"v":1,"d":"1.0"},74,2,2.4,81,0.3,3.1,90,2,{"v":4,"d":"4.0"},87,2,3.7,71,3,2.1,48,3,{"v":0,"d":"0.0"},75,3,2.5,64,3,1.4,90,2.5,{"v":4,"d":"4.0"},84,3,3.4,94,0.3,4.4,91,1,4.1,57,5,{"v":0,"d":"0.0"},43.099999999999994,88.25,{"v":2.0475638051044087,"d":"2.05"}]
["201512200501029","盛俊祥",74,81,68,3,1.8,60,4,{"v":1,"d":"1.0"},86,1,3.6,54,5,{"v":0,"d":"0.0"},83,2,3.3,76,0.3,2.6,87,2,3.7,78,2,2.8,52,3,{"v":0,"d":"0.0"},61,3,1.1,70,3,{"v":2,"d":"2.0"},66,3,1.6,87,2.5,3.7,85,3,3.5,87,0.3,3.7,90,1,{"v":4,"d":"4.0"},58,5,{"v":0,"d":"0.0"},43.099999999999994,72.34,{"v":1.6784222737819028,"d":"1.68"}]
["201512200501030","刘禹臣",86,82,76,3,2.6,85,4,3.5,89,1,3.9,55,5,{"v":0,"d":"0.0"},85,2,3.5,80,0.3,{"v":3,"d":"3.0"},88,2,3.8,88,2,3.8,84,3,3.4,71,3,2.1,87,3,3.7,76,3,2.6,88,2.5,3.8,86,3,3.6,90,0.3,{"v":4,"d":"4.0"},94,1,4.4,69,5,1.9,43.099999999999994,119.60000000000001,{"v":2.7749419953596295,"d":"2.77"}]
["201512200501031","常开心",87,82,62,3,1.2,79,4,2.9,85,1,3.5,68,5,1.8,84,2,3.4,78,0.3,2.8,87,2,3.7,86,2,3.6,66,3,1.6,67,3,1.7,82,3,3.2,69,3,1.9,93,2.5,4.3,87,3,3.7,91,0.3,4.1,92,1,4.2,60,5,{"v":1,"d":"1.0"},43.099999999999994,107.42000000000002,{"v":2.4923433874709984,"d":"2.49"}]
["201512200501032","赵方方",86,85,82,3,3.2,82,4,3.2,89,1,3.9,75,5,2.5,82,2,3.2,85,0.3,3.5,93,2,4.3,88,2,3.8,66,3,1.6,65,3,1.5,71,3,2.1,72,3,2.2,78,2.5,2.8,87,3,3.7,91,0.3,4.1,95,1,4.5,73,5,2.3,43.099999999999994,119.98,{"v":2.783758700696056,"d":"2.78"}]
["201512200501033","沈明",74,80,42,3,{"v":0,"d":"0.0"},40,4,{"v":0,"d":"0.0"},83,1,3.3,67,5,1.7,71,2,2.1,77,0.3,2.7,92,2,4.2,84,2,3.4,64,3,1.4,51,3,{"v":0,"d":"0.0"},71,3,2.1,75,3,2.5,72,2.5,2.2,89,3,3.9,86,0.3,3.6,93,1,4.3,66,5,1.6,43.099999999999994,80.58999999999999,{"v":1.8698375870069606,"d":"1.87"}]
["201512200501034","常俊一",73,90,68,3,1.8,79,4,2.9,87,1,3.7,73,5,2.3,75,2,2.5,80,0.3,{"v":3,"d":"3.0"},92,2,4.2,87,2,3.7,88,3,3.8,74,3,2.4,70,3,{"v":2,"d":"2.0"},84,3,3.4,87,2.5,3.7,90,3,{"v":4,"d":"4.0"},88,0.3,3.8,93,1,4.3,69,5,1.9,43.099999999999994,124.89,{"v":2.897679814385151,"d":"2.90"}]
["201512200501035","马莹莹",71,85,68,3,1.8,63,4,1.3,85,1,3.5,76,5,2.6,80,2,{"v":3,"d":"3.0"},82,0.3,3.2,94,2,4.4,91,2,4.1,65,3,1.5,76,3,2.6,76,3,2.6,81,3,3.1,79,2.5,2.9,89,3,3.9,87,0.3,3.7,94,1,4.4,69,5,1.9,43.099999999999994,114.42,{"v":2.6547563805104413,"d":"2.65"}]
["201512200502003","蔡丽",75,87,60,3,{"v":1,"d":"1.0"},76,4,2.6,85,1,3.5,85,5,3.5,84,2,3.4,80,0.3,{"v":3,"d":"3.0"},87,2,3.7,91,2,4.1,60,3,{"v":1,"d":"1.0"},65,3,1.5,60,3,{"v":1,"d":"1.0"},66,3,1.6,71,2.5,2.1,85,3,3.5,74,0.3,2.4,94,1,4.4,87,5,3.7,43.099999999999994,112.36999999999999,{"v":2.6071925754060326,"d":"2.61"}]
["201512200502005","徐卓政",60,60,87,3,3.7,76,4,2.6,91,1,4.1,72,5,2.2,80,2,{"v":3,"d":"3.0"},78,0.3,2.8,93,2,4.3,85,2,3.5,84,3,3.4,71,3,2.1,74,3,2.4,73,3,2.3,89,2.5,3.9,89,3,3.9,94,0.3,4.4,96,1,4.6,80,5,{"v":3,"d":"3.0"},43.099999999999994,132.01,{"v":3.0628770301624133,"d":"3.06"}]
["201512200502006","梁浩威",69,81,82,3,3.2,55,4,{"v":0,"d":"0.0"},86,1,3.6,57,5,{"v":0,"d":"0.0"},80,2,{"v":3,"d":"3.0"},84,0.3,3.4,67,2,1.7,75,2,2.5,70,3,{"v":2,"d":"2.0"},69,3,1.9,74,3,2.4,70,3,{"v":2,"d":"2.0"},85,2.5,3.5,87,3,3.7,89,0.3,3.9,91,1,4.1,73,5,2.3,43.099999999999994,90.14,{"v":2.0914153132250584,"d":"2.09"}]
["201512200502007","丁沈威",79,82,86,3,3.6,86,4,3.6,87,1,3.7,88,5,3.8,82,2,3.2,81,0.3,3.1,89,2,3.9,90,2,{"v":4,"d":"4.0"},84,3,3.4,85,3,3.5,86,3,3.6,75,3,2.5,92,2.5,4.2,84,3,3.4,88,0.3,3.8,93,1,4.3,82,5,3.2,43.099999999999994,152.17,{"v":3.5306264501160096,"d":"3.53"}]
["201512200502010","陈嘉威",80,71,69,3,1.9,67,4,1.7,85,1,3.5,73,5,2.3,79,2,2.9,77,0.3,2.7,84,2,3.4,88,2,3.8,66,3,1.6,61,3,1.1,82,3,3.2,78,3,2.8,80,2.5,{"v":3,"d":"3.0"},86,3,3.6,84,0.3,3.4,94,1,4.4,72,5,2.2,43.099999999999994,109.33000000000001,{"v":2.5366589327146176,"d":"2.54"}]
["201512200502012","朱彦超",85,85,93,3,4.3,77,4,2.7,93,1,4.3,76,5,2.6,88,2,3.8,81,0.3,3.1,92,2,4.2,90,2,{"v":4,"d":"4.0"},88,3,3.8,87,3,3.7,88,3,3.8,74,3,2.4,91,2.5,4.1,89,3,3.9,96,0.3,4.6,97,1,4.7,67,5,1.7,43.099999999999994,143.56,{"v":3.3308584686774947,"d":"3.33"}]
["201512200502013","岳凯平",78,87,76,3,2.6,71,4,2.1,85,1,3.5,79,5,2.9,79,2,2.9,82,0.3,3.2,93,2,4.3,85,2,3.5,80,3,{"v":3,"d":"3.0"},62,3,1.2,79,3,2.9,66,3,1.6,78,2.5,2.8,86,3,3.6,76,0.3,2.6,91,1,4.1,75,5,2.5,43.099999999999994,117.83999999999999,{"v":2.734106728538283,"d":"2.73"}]
["201512200502014","倪煜",71,75,68,3,1.8,71,4,2.1,85,1,3.5,73,5,2.3,78,2,2.8,77,0.3,2.7,81,2,3.1,85,2,3.5,72,3,2.2,65,3,1.5,73,3,2.3,60,3,{"v":1,"d":"1.0"},72,2.5,2.2,87,3,3.7,77,0.3,2.7,94,1,4.4,76,5,2.6,43.099999999999994,104.22000000000003,{"v":2.418097447795825,"d":"2.42"}]
["201512200502015","蒋凯",81,74,77,3,2.7,61,4,1.1,85,1,3.5,66,5,1.6,80,2,{"v":3,"d":"3.0"},76,0.3,2.6,82,2,3.2,89,2,3.9,71,3,2.1,69,3,1.9,81,3,3.1,75,3,2.5,88,2.5,3.8,86,3,3.6,81,0.3,3.1,96,1,4.6,64,5,1.4,43.099999999999994,106.61,{"v":2.4735498839907195,"d":"2.47"}]
["201512200502016","胡霏旭",77,89,72,3,2.2,68,4,1.8,85,1,3.5,80,5,{"v":3,"d":"3.0"},78,2,2.8,82,0.3,3.2,82,2,3.2,86,2,3.6,80,3,{"v":3,"d":"3.0"},75,3,2.5,82,3,3.2,67,3,1.7,90,2.5,{"v":4,"d":"4.0"},88,3,3.8,91,0.3,4.1,97,1,4.7,88,5,3.8,43.099999999999994,129.99,{"v":3.01600928074246,"d":"3.02"}]
["201512200502017","章沛沛",79,82,60,3,{"v":1,"d":"1.0"},70,4,{"v":2,"d":"2.0"},85,1,3.5,64,5,1.4,82,2,3.2,83,0.3,3.3,83,2,3.3,84,2,3.4,74,3,2.4,60,3,{"v":1,"d":"1.0"},73,3,2.3,70,3,{"v":2,"d":"2.0"},82,2.5,3.2,85,3,3.5,80,0.3,{"v":3,"d":"3.0"},94,1,4.4,70,5,{"v":2,"d":"2.0"},43.099999999999994,99.19,{"v":2.30139211136891,"d":"2.30"}]
["201512200502018","王宇萍",72,71,60,3,{"v":1,"d":"1.0"},67,4,1.7,90,1,{"v":4,"d":"4.0"},74,5,2.4,85,2,3.5,81,0.3,3.1,83,2,3.3,85,2,3.5,68,3,1.8,72,3,2.2,78,3,2.8,70,3,{"v":2,"d":"2.0"},83,2.5,3.3,84,3,3.4,90,0.3,{"v":4,"d":"4.0"},95,1,4.5,86,5,3.6,43.099999999999994,115.88,{"v":2.688631090487239,"d":"2.69"}]
["201512200502019","陆张璐",80,85,75,3,2.5,74,4,2.4,86,1,3.6,77,5,2.7,82,2,3.2,79,0.3,2.9,76,2,2.6,86,2,3.6,76,3,2.6,79,3,2.9,83,3,3.3,74,3,2.4,86,2.5,3.6,86,3,3.6,94,0.3,4.4,96,1,4.6,86,5,3.6,43.099999999999994,131.19,{"v":3.04385150812065,"d":"3.04"}]
["201512200502020","钱怡卉",82,87,82,3,3.2,75,4,2.5,89,1,3.9,80,5,{"v":3,"d":"3.0"},80,2,{"v":3,"d":"3.0"},81,0.3,3.1,91,2,4.1,89,2,3.9,80,3,{"v":3,"d":"3.0"},75,3,2.5,70,3,{"v":2,"d":"2.0"},75,3,2.5,87,2.5,3.7,88,3,3.8,84,0.3,3.4,94,1,4.4,74,5,2.4,43.099999999999994,129.5,{"v":3.0046403712296987,"d":"3.00"}]
["201512200502021","钱得进",64,0,62,3,1.2,55,4,{"v":0,"d":"0.0"},85,1,3.5,64,5,1.4,73,2,2.3,81,0.3,3.1,82,2,3.2,79,2,2.9,50,3,{"v":0,"d":"0.0"},54,3,{"v":0,"d":"0.0"},76,3,2.6,0,3,{"v":0,"d":"0.0"},79,2.5,2.9,86,3,3.6,88,0.3,3.8,90,1,{"v":4,"d":"4.0"},69,5,1.9,43.099999999999994,72.32000000000001,{"v":1.6779582366589332,"d":"1.68"}]
["201512200502022","刘大庆",77,77,74,3,2.4,74,4,2.4,85,1,3.5,63,5,1.3,70,2,{"v":2,"d":"2.0"},76,0.3,2.6,63,2,1.3,86,2,3.6,60,3,{"v":1,"d":"1.0"},60,3,{"v":1,"d":"1.0"},64,3,1.4,66,3,1.6,73,2.5,2.3,83,3,3.3,81,0.3,3.1,94,1,4.4,65,5,1.5,43.099999999999994,84.86000000000001,{"v":1.9689095127610214,"d":"1.97"}]
["201512200502023","岑满如",89,84,64,3,1.4,73,4,2.3,85,1,3.5,70,5,{"v":2,"d":"2.0"},77,2,2.7,80,0.3,{"v":3,"d":"3.0"},83,2,3.3,88,2,3.8,75,3,2.5,61,3,1.1,66,3,1.6,68,3,1.8,86,2.5,3.6,83,3,3.3,89,0.3,3.9,93,1,4.3,68,5,1.8,43.099999999999994,101.77000000000001,{"v":2.361252900232019,"d":"2.36"}]
["201512200502024","燕若鹏",81,84,76,3,2.6,73,4,2.3,85,1,3.5,85,5,3.5,85,2,3.5,84,0.3,3.4,81,2,3.1,86,2,3.6,66,3,1.6,68,3,1.8,80,3,{"v":3,"d":"3.0"},68,3,1.8,93,2.5,4.3,88,3,3.8,88,0.3,3.8,97,1,4.7,87,5,3.7,43.099999999999994,130.51000000000002,{"v":3.028074245939676,"d":"3.03"}]
["201512200502025","毛明杰",68,80,65,3,1.5,66,4,1.6,85,1,3.5,76,5,2.6,71,2,2.1,76,0.3,2.6,80,2,{"v":3,"d":"3.0"},85,2,3.5,61,3,1.1,47,3,{"v":0,"d":"0.0"},76,3,2.6,71,3,2.1,69,2.5,1.9,84,3,3.4,89,0.3,3.9,91,1,4.1,71,5,2.1,43.099999999999994,93.49999999999999,{"v":2.1693735498839906,"d":"2.17"}]
["201512200502026","金卓",74,83,75,3,2.5,82,4,3.2,85,1,3.5,84,5,3.4,79,2,2.9,78,0.3,2.8,87,2,3.7,82,2,3.2,76,3,2.6,85,3,3.5,87,3,3.7,75,3,2.5,88,2.5,3.8,87,3,3.7,97,0.3,4.7,97,1,4.7,81,5,3.1,43.099999999999994,140.34999999999997,{"v":3.256380510440835,"d":"3.26"}]
["201512200502027","任璇",79,75,77,3,2.7,78,4,2.8,90,1,{"v":4,"d":"4.0"},53,5,{"v":0,"d":"0.0"},78,2,2.8,76,0.3,2.6,91,2,4.1,84,2,3.4,87,3,3.7,78,3,2.8,85,3,3.5,72,3,2.2,86,2.5,3.6,88,3,3.8,90,0.3,{"v":4,"d":"4.0"},97,1,4.7,56,5,{"v":0,"d":"0.0"},43.099999999999994,107.57999999999998,{"v":2.496055684454756,"d":"2.50"}]
["201512200502028","王家洁",90,88,78,3,2.8,78,4,2.8,92,1,4.2,56,5,{"v":0,"d":"0.0"},83,2,3.3,79,0.3,2.9,83,2,3.3,90,2,{"v":4,"d":"4.0"},84,3,3.4,76,3,2.6,78,3,2.8,74,3,2.4,83,2.5,3.3,89,3,3.9,99,0.3,4.9,97,1,4.7,72,5,2.2,43.099999999999994,116.58999999999999,{"v":2.7051044083526685,"d":"2.71"}]
["201512200502029","陆桂桃",85,92,69,3,1.9,72,4,2.2,89,1,3.9,85,5,3.5,77,2,2.7,75,0.3,2.5,82,2,3.2,90,2,{"v":4,"d":"4.0"},75,3,2.5,69,3,1.9,82,3,3.2,79,3,2.9,79,2.5,2.9,86,3,3.6,73,0.3,2.3,96,1,4.6,82,5,3.2,43.099999999999994,127.28999999999999,{"v":2.9533642691415314,"d":"2.95"}]
["201512200502030","王书卿",62,78,60,3,{"v":1,"d":"1.0"},49,4,{"v":0,"d":"0.0"},85,1,3.5,60,5,{"v":1,"d":"1.0"},66,2,1.6,78,0.3,2.8,80,2,{"v":3,"d":"3.0"},79,2,2.9,60,3,{"v":1,"d":"1.0"},48,3,{"v":0,"d":"0.0"},67,3,1.7,60,3,{"v":1,"d":"1.0"},75,2.5,2.5,85,3,3.5,92,0.3,4.2,95,1,4.5,71,5,2.1,43.099999999999994,71.44999999999999,{"v":1.6577726218097448,"d":"1.66"}]
["201512200502031","张琪",66,77,69,3,1.9,76,4,2.6,87,1,3.7,70,5,{"v":2,"d":"2.0"},77,2,2.7,75,0.3,2.5,76,2,2.6,90,2,{"v":4,"d":"4.0"},60,3,{"v":1,"d":"1.0"},64,3,1.4,62,3,1.2,77,3,2.7,79,2.5,2.9,82,3,3.2,90,0.3,{"v":4,"d":"4.0"},90,1,{"v":4,"d":"4.0"},62,5,1.2,43.099999999999994,96.10000000000001,{"v":2.22969837587007,"d":"2.23"}]
["201512200502032","王晓玉",67,67,54,3,{"v":0,"d":"0.0"},77,4,2.7,85,1,3.5,53,5,{"v":0,"d":"0.0"},77,2,2.7,82,0.3,3.2,81,2,3.1,85,2,3.5,64,3,1.4,42,3,{"v":0,"d":"0.0"},61,3,1.1,64,3,1.4,68,2.5,1.8,84,3,3.4,84,0.3,3.4,94,1,4.4,53,5,{"v":0,"d":"0.0"},43.099999999999994,65.68,{"v":1.523897911832947,"d":"1.52"}]
["201512200502033","刘玉媛",66,70,52,3,{"v":0,"d":"0.0"},63,4,1.3,86,1,3.6,67,5,1.7,79,2,2.9,79,0.3,2.9,64,2,1.4,81,2,3.1,62,3,1.2,50,3,{"v":0,"d":"0.0"},55,3,{"v":0,"d":"0.0"},0,3,{"v":0,"d":"0.0"},68,2.5,1.8,83,3,3.3,89,0.3,3.9,92,1,4.2,75,5,2.5,43.099999999999994,68.84,{"v":1.5972157772621813,"d":"1.60"}]
["201512200502034","吴琼",76,79,74,3,2.4,75,4,2.5,90,1,{"v":4,"d":"4.0"},77,5,2.7,85,2,3.5,77,0.3,2.7,81,2,3.1,89,2,3.9,66,3,1.6,52,3,{"v":0,"d":"0.0"},65,3,1.5,0,3,{"v":0,"d":"0.0"},85,2.5,3.5,85,3,3.5,88,0.3,3.8,96,1,4.6,78,5,2.8,43.099999999999994,104.8,{"v":2.431554524361949,"d":"2.43"}]
["201512200502035","唐世帆",75,73,82,3,3.2,88,4,3.8,91,1,4.1,84,5,3.4,84,2,3.4,80,0.3,{"v":3,"d":"3.0"},90,2,{"v":4,"d":"4.0"},89,2,3.9,77,3,2.7,82,3,3.2,84,3,3.4,76,3,2.6,86,2.5,3.6,87,3,3.7,88,0.3,3.8,97,1,4.7,86,5,3.6,43.099999999999994,149.04,{"v":3.45800464037123,"d":"3.46"}]
["201512200601020","吴相尧",74,60,{"$nulls":3},62,4,1.2,85,1,3.5,74,5,2.4,76,2,2.6,83,0.3,3.3,90,2,{"v":4,"d":"4.0"},92,2,4.2,65,3,1.5,60,3,{"v":1,"d":"1.0"},67,3,1.7,64,3,1.4,66,2.5,1.6,87,3,3.7,67,0.3,1.7,93,1,4.3,70,5,{"v":2,"d":"2.0"},40.099999999999994,89.6,{"v":2.234413965087282,"d":"2.23"}]
["201512202401019","王烨",76,89,{"$nulls":6},"良好",1,3.5,78,5,2.8,82,2,3.2,81,0.3,3.1,85,2,3.5,86,2,3.6,69,3,1.9,62,3,1.2,76,3,2.6,79,3,2.9,85,2.5,3.5,83,3,3.3,97,0.3,4.7,96,1,4.6,83,5,3.3,36.1,105.99000000000001,{"v":2.93601108033241,"d":"2.94"}]

{"sheet":"成绩排名","index":3,"n_rows":59,"n_cols":4,"rows_kept":59,"flags":["formulas_cached_only"]}
["学号","姓名","加权平均绩点","排名"]
["201512200502007","丁沈威",{"v":3.5306264501160096,"d":"3.53"},1]
["201512200502035","唐世帆",{"v":3.45800464037123,"d":"3.46"},2]
["201512200501003","蒋思凡",{"v":3.334338747099768,"d":"3.33"},3]
["201512200502012","朱彦超",{"v":3.3308584686774947,"d":"3.33"},4]
["201512200501008","陈旭旭",{"v":3.280278422273782,"d":"3.28"},5]
["201512200502026","金卓",{"v":3.256380510440835,"d":"3.26"},6]
["201512200501018","管丽萍",{"v":3.092111368909513,"d":"3.09"},7]
["201512200502005","徐卓政",{"v":3.0628770301624133,"d":"3.06"},8]
["201512200502019","陆张璐",{"v":3.04385150812065,"d":"3.04"},9]
["201512200502024","燕若鹏",{"v":3.028074245939676,"d":"3.03"},10]
["201512200502016","胡霏旭",{"v":3.01600928074246,"d":"3.02"},11]
["201512200502020","钱怡卉",{"v":3.0046403712296987,"d":"3.00"},12]
["201512200501019","孙洁",{"v":2.964269141531323,"d":"2.96"},13]
["201512200502029","陆桂桃",{"v":2.9533642691415314,"d":"2.95"},14]
["201512202401019","王烨",{"v":2.93601108033241,"d":"2.94"},15]
["201512200501001","陆艺军",{"v":2.8986078886310906,"d":"2.90"},16]
["201512200501034","常俊一",{"v":2.897679814385151,"d":"2.90"},17]
["201512200501007","李紫妍",{"v":2.8378190255220423,"d":"2.84"},18]
["201512200501032","赵方方",{"v":2.783758700696056,"d":"2.78"},19]
["201512200501030","刘禹臣",{"v":2.7749419953596295,"d":"2.77"},20]
["201512200501015","李佳",{"v":2.7686774941995362,"d":"2.77"},21]
["201512200502013","岳凯平",{"v":2.734106728538283,"d":"2.73"},22]
["201512200502028","王家洁",{"v":2.7051044083526685,"d":"2.71"},23]
["201512200501011","胡洪豪",{"v":2.6900232018561487,"d":"2.69"},24]
["201512200502018","王宇萍",{"v":2.688631090487239,"d":"2.69"},25]
["201512200501035","马莹莹",{"v":2.6547563805104413,"d":"2.65"},26]
["201512200502003","蔡丽",{"v":2.6071925754060326,"d":"2.61"},27]
["201512200501024","朱思迪",{"v":2.5651972157772622,"d":"2.57"},28]
["201512200501017","黄正栋",{"v":2.5447795823665897,"d":"2.54"},29]
["201512200502010","陈嘉威",{"v":2.5366589327146176,"d":"2.54"},30]
["201512200501014","江楠楠",{"v":2.505104408352669,"d":"2.51"},31]
["201512200502027","任璇",{"v":2.496055684454756,"d":"2.50"},32]
["201512200501031","常开心",{"v":2.4923433874709984,"d":"2.49"},33]
["201512200501023","刘丹琪",{"v":2.484222737819026,"d":"2.48"},34]
["201512200502015","蒋凯",{"v":2.4735498839907195,"d":"2.47"},35]
["201512200502034","吴琼",{"v":2.431554524361949,"d":"2.43"},36]
["201512200502014","倪煜",{"v":2.418097447795825,"d":"2.42"},37]
["201512200501009","徐锦绣",{"v":2.380974477958237,"d":"2.38"},38]
["201512200501010","何倩虹",{"v":2.3707656612529004,"d":"2.37"},39]
["201512200502023","岑满如",{"v":2.361252900232019,"d":"2.36"},40]
["201512200501020","王嘉辉",{"v":2.3074245939675175,"d":"2.31"},41]
["201512200502017","章沛沛",{"v":2.30139211136891,"d":"2.30"},42]
["201512200501013","杨华杰",{"v":2.288863109048725,"d":"2.29"},43]
["201512200601020","吴相尧",{"v":2.234413965087282,"d":"2.23"},44]
["201512200502031","张琪",{"v":2.22969837587007,"d":"2.23"},45]
["201512200502025","毛明杰",{"v":2.1693735498839906,"d":"2.17"},46]
["201512200501006","王潇妮",{"v":2.106728538283063,"d":"2.11"},47]
["201512200502006","梁浩威",{"v":2.0914153132250584,"d":"2.09"},48]
["201512200501016","施祖建",{"v":2.0716937354988403,"d":"2.07"},49]
["201512200501028","杜国强",{"v":2.0475638051044087,"d":"2.05"},50]
["201512200502022","刘大庆",{"v":1.9689095127610214,"d":"1.97"},51]
["201512200501021","廖灵琳",{"v":1.8733178654292344,"d":"1.87"},52]
["201512200501033","沈明",{"v":1.8698375870069606,"d":"1.87"},53]
["201512200501029","盛俊祥",{"v":1.6784222737819028,"d":"1.68"},54]
["201512200502021","钱得进",{"v":1.6779582366589332,"d":"1.68"},55]
["201512200502030","王书卿",{"v":1.6577726218097448,"d":"1.66"},56]
["201512200502033","刘玉媛",{"v":1.5972157772621813,"d":"1.60"},57]
["201512200502032","王晓玉",{"v":1.523897911832947,"d":"1.52"},58]