{"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":27,"n_cols":23,"rows_kept":27,"flags":["formulas_cached_only"]}
["学号","姓名","体育 [2]","高等数学 [3]","学分","绩点","无机及分析化学 [5]","学分","绩点","大学英语 [5]","学分","绩点","思想道德修养与法律基础 [3]","学分","绩点","形势与政策 [.3]","学分","绩点","大学生心理健康教育 [2]","学分","绩点","学期学分","学期学分绩点"]
["201523201801002","王晶",75,84,3,3.4,74,5,2.4,74,5,2.4,86,3,3.6,89,0.3,3.9,72,2,2.2,18.3,50.57]
["201523201801003","徐扬",85,74,3,2.4,72,5,2.2,69,5,1.9,89,3,3.9,89,0.3,3.9,79,2,2.9,18.3,46.37]
["201523201801004","朱徐琳",80,72,3,2.2,68,5,1.8,72,5,2.2,88,3,3.8,79,0.3,2.9,75,2,2.5,18.3,43.87]
["201523201801005","郎帅英",79,84,3,3.4,76,5,2.6,77,5,2.7,87,3,3.7,91,0.3,4.1,82,2,3.2,18.3,55.43]
["201523201801006","王媛",83,63,3,1.3,72,5,2.2,78,5,2.8,92,3,4.2,79,0.3,2.9,90,2,{"v":4,"d":"4.0"},18.3,50.37]
["201523201801007","鲁勇华",85,74,3,2.4,60,5,{"v":1,"d":"1.0"},70,5,{"v":2,"d":"2.0"},81,3,3.1,85,0.3,3.5,63,2,1.3,18.3,35.15]
["201523201801008","丁鹏",79,80,3,{"v":3,"d":"3.0"},63,5,1.3,74,5,2.4,86,3,3.6,84,0.3,3.4,70,2,{"v":2,"d":"2.0"},18.3,43.32]
["201523201801009","郑佳芸",80,79,3,2.9,70,5,{"v":2,"d":"2.0"},74,5,2.4,87,3,3.7,89,0.3,3.9,73,2,2.3,18.3,47.57]
["201523201801011","李吉二",74,81,3,3.1,80,5,{"v":3,"d":"3.0"},79,5,2.9,84,3,3.4,91,0.3,4.1,82,2,3.2,18.3,{"v":56.629999999999995,"d":"56.63"}]
["201523201801013","石文钦",94,89,3,3.9,81,5,3.1,79,5,2.9,83,3,3.3,84,0.3,3.4,83,2,3.3,18.3,{"v":59.220000000000006,"d":"59.22"}]
["201523201801014","郑文涛",78,86,3,3.6,79,5,2.9,75,5,2.5,81,3,3.1,75,0.3,2.5,81,2,3.1,18.3,54.05]
["201523201801015","张弘宇",86,86,3,3.6,83,5,3.3,84,5,3.4,79,3,2.9,84,0.3,3.4,83,2,3.3,18.3,{"v":60.620000000000005,"d":"60.62"}]
["201523201801017","薛玲玲",84,94,3,4.4,84,5,3.4,78,5,2.8,79,3,2.9,91,0.3,4.1,85,2,3.5,18.3,61.13]
["201523201801018","韩子亮",88,80,3,{"v":3,"d":"3.0"},66,5,1.6,82,5,3.2,85,3,3.5,77,0.3,2.7,78,2,2.8,18.3,{"v":49.910000000000004,"d":"49.91"}]
["201523201801019","王叶红",79,61,3,1.1,65,5,1.5,77,5,2.7,90,3,{"v":4,"d":"4.0"},82,0.3,3.2,85,2,3.5,18.3,44.26]
["201523201801020","史悦悦",78,86,3,3.6,70,5,{"v":2,"d":"2.0"},82,5,3.2,89,3,3.9,82,0.3,3.2,89,2,3.9,18.3,57.26]
["201523201801021","朱小峰",70,74,3,2.4,53,5,{"v":0,"d":"0.0"},60,5,{"v":1,"d":"1.0"},84,3,3.4,72,0.3,2.2,63,2,1.3,18.3,25.66]
["201523201801022","卢楚霨",82,61,3,1.1,69,5,1.9,68,5,1.8,87,3,3.7,79,0.3,2.9,74,2,2.4,18.3,38.57]
["201523201801023","黄俊健",78,85,3,3.5,70,5,{"v":2,"d":"2.0"},64,5,1.4,79,3,2.9,78,0.3,2.8,66,2,1.6,18.3,{"v":40.24000000000001,"d":"40.24"}]
["201523201801024","陈玉琼",78,69,3,1.9,60,5,{"v":1,"d":"1.0"},86,5,3.6,90,3,{"v":4,"d":"4.0"},84,0.3,3.4,84,2,3.4,18.3,48.52]
["201523201801025","沈晨君",80,82,3,3.2,65,5,1.5,78,5,2.8,87,3,3.7,88,0.3,3.8,73,2,2.3,18.3,{"v":47.940000000000005,"d":"47.94"}]
["201523201801026","蔡侠蘅",71,72,3,2.2,70,5,{"v":2,"d":"2.0"},72,5,2.2,87,3,3.7,86,0.3,3.6,89,2,3.9,18.3,47.58]
["201523201801027","王惠仪",78,90,3,{"v":4,"d":"4.0"},66,5,1.6,75,5,2.5,88,3,3.8,86,0.3,3.6,88,2,3.8,18.3,52.58]
["201523201801028","云婷婷",93,71,3,2.1,63,5,1.3,72,5,2.2,81,3,3.1,75,0.3,2.5,72,2,2.2,18.3,38.25]
["201523201801031","杨奥",68,75,3,2.5,54,5,{"v":0,"d":"0.0"},46,5,{"v":0,"d":"0.0"},88,3,3.8,82,0.3,3.2,68,2,1.8,18.3,23.46]
["201523201801039","何盼",88,72,3,2.2,55,5,{"v":0,"d":"0.0"},70,5,{"v":2,"d":"2.0"},85,3,3.5,88,0.3,3.8,80,2,{"v":3,"d":"3.0"},18.3,34.24]

{"sheet":"15-16-2","index":1,"n_rows":27,"n_cols":32,"rows_kept":27,"flags":["formulas_cached_only"]}
["学号","姓名","体育（2） [2]","计算机文化基础 [4]","学分","绩点","有机化学 [4]","学分","绩点","物理化学 [2.5]","学分","绩点","高等数学2 [3]","学分","绩点","中国近现代史纲要 [2]","学分","绩点","形势与政策 [.3]","学分","绩点","军事理论课 [2]","学分","绩点","大学生就业指导与创业教育 [1]","学分","绩点","大学英语（2） [5]","学分","绩点","学期学分","学期学分绩点"]
["201523201801002","王晶",60,85,4,3.5,74,4,2.4,83,2.5,3.3,83,3,3.3,76,2,2.6,81,0.3,3.1,95,2,4.5,96,1,4.6,72,5,2.2,23.8,72.48]
["201523201801003","徐扬",90,50,4,{"v":0,"d":"0.0"},75,4,2.5,69,2.5,1.9,61,3,1.1,84,2,3.4,86,0.3,3.6,86,2,3.6,98,1,4.8,70,5,{"v":2,"d":"2.0"},23.8,47.93]
["201523201801004","朱徐琳",83,76,4,2.6,73,4,2.3,80,2.5,{"v":3,"d":"3.0"},69,3,1.9,78,2,2.8,73,0.3,2.3,94,2,4.4,90,1,{"v":4,"d":"4.0"},71,5,2.1,23.8,62.39]
["201523201801005","郎帅英",80,68,4,1.8,57,4,{"v":0,"d":"0.0"},86,2.5,3.6,61,3,1.1,79,2,2.9,73,0.3,2.3,89,2,3.9,93,1,4.3,74,5,2.4,23.8,50.089999999999996]
["201523201801006","王媛",83,53,4,{"v":0,"d":"0.0"},53,4,{"v":0,"d":"0.0"},41,2.5,{"v":0,"d":"0.0"},63,3,1.3,70,2,{"v":2,"d":"2.0"},77,0.3,2.7,91,2,4.1,96,1,4.6,64,5,1.4,23.8,28.509999999999998]
["201523201801007","鲁勇华",88,62,4,1.2,64,4,1.4,60,2.5,{"v":1,"d":"1.0"},30,3,{"v":0,"d":"0.0"},71,2,2.1,73,0.3,2.3,87,2,3.7,91,1,4.1,60,5,{"v":1,"d":"1.0"},23.8,34.29]
["201523201801008","丁鹏",80,66,4,1.6,67,4,1.7,76,2.5,2.6,75,3,2.5,77,2,2.7,83,0.3,3.3,88,2,3.8,92,1,4.2,67,5,1.7,23.8,53.89000000000001]
["201523201801009","郑佳芸",91,82,4,3.2,82,4,3.2,83,2.5,3.3,88,3,3.8,83,2,3.3,87,0.3,3.7,91,2,4.1,93,1,4.3,70,5,{"v":2,"d":"2.0"},23.8,75.46]
["201523201801011","李吉二",88,88,4,3.8,75,4,2.5,80,2.5,{"v":3,"d":"3.0"},89,3,3.9,84,2,3.4,99,0.3,4.9,91,2,4.1,97,1,4.7,83,5,3.3,23.8,82.07000000000001]
["201523201801013","石文钦",92,84,4,3.4,94,4,4.4,88,2.5,3.8,88,3,3.8,74,2,2.4,87,0.3,3.7,98,2,4.8,96,1,4.6,73,5,2.3,23.8,83.71]
["201523201801014","郑文涛",83,56,4,{"v":0,"d":"0.0"},78,4,2.8,69,2.5,1.9,61,3,1.1,69,2,1.9,77,0.3,2.7,88,2,3.8,85,1,3.5,72,5,2.2,23.8,45.96]
["201523201801015","张弘宇",88,68,4,1.8,95,4,4.5,86,2.5,3.6,88,3,3.8,72,2,2.2,87,0.3,3.7,91,2,4.1,96,1,4.6,91,5,4.1,23.8,84.41]
["201523201801017","薛玲玲",85,90,4,{"v":4,"d":"4.0"},96,4,4.6,93,2.5,4.3,88,3,3.8,82,2,3.2,78,0.3,2.8,92,2,4.2,93,1,4.3,85,5,3.5,23.8,93.99]
["201523201801018","韩子亮",70,85,4,3.5,77,4,2.7,86,2.5,3.6,63,3,1.3,78,2,2.8,73,0.3,2.3,91,2,4.1,93,1,4.3,78,5,2.8,23.8,70.49]
["201523201801019","王叶红",80,57,4,{"v":0,"d":"0.0"},60,4,{"v":1,"d":"1.0"},86,2.5,3.6,63,3,1.3,82,2,3.2,75,0.3,2.5,95,2,4.5,94,1,4.4,80,5,{"v":3,"d":"3.0"},23.8,52.449999999999996]
["201523201801020","史悦悦",86,72,4,2.2,90,4,{"v":4,"d":"4.0"},90,2.5,{"v":4,"d":"4.0"},85,3,3.5,85,2,3.5,82,0.3,3.2,98,2,4.8,97,1,4.7,80,5,{"v":3,"d":"3.0"},23.8,82.56]
["201523201801021","朱小峰",90,70,4,{"v":2,"d":"2.0"},73,4,2.3,73,2.5,2.3,78,3,2.8,65,2,1.5,86,0.3,3.6,88,2,3.8,89,1,3.9,76,5,2.6,23.8,59.92999999999999]
["201523201801022","卢楚霨",79,83,4,3.3,81,4,3.1,77,2.5,2.7,46,3,{"v":0,"d":"0.0"},81,2,3.1,72,0.3,2.2,91,2,4.1,93,1,4.3,68,5,1.8,23.8,60.709999999999994]
["201523201801023","黄俊健",79,70,4,{"v":2,"d":"2.0"},81,4,3.1,81,2.5,3.1,59,3,{"v":0,"d":"0.0"},62,2,1.2,73,0.3,2.3,82,2,3.2,92,1,4.2,53,5,{"v":0,"d":"0.0"},23.8,41.84]
["201523201801024","陈玉琼",81,79,4,2.9,57,4,{"v":0,"d":"0.0"},68,2.5,1.8,60,3,{"v":1,"d":"1.0"},79,2,2.9,91,0.3,4.1,79,2,2.9,99,1,4.9,90,5,{"v":4,"d":"4.0"},23.8,56.830000000000005]
["201523201801025","沈晨君",79,65,4,1.5,86,4,3.6,87,2.5,3.7,69,3,1.9,78,2,2.8,87,0.3,3.7,85,2,3.5,95,1,4.5,80,5,{"v":3,"d":"3.0"},23.8,68.56]
["201523201801026","蔡侠蘅",75,87,4,3.7,76,4,2.6,75,2.5,2.5,69,3,1.9,79,2,2.9,87,0.3,3.7,88,2,3.8,97,1,4.7,80,5,{"v":3,"d":"3.0"},23.8,71.36000000000001]
["201523201801027","王惠仪",81,82,4,3.2,77,4,2.7,81,2.5,3.1,60,3,{"v":1,"d":"1.0"},78,2,2.8,87,0.3,3.7,86,2,3.6,95,1,4.5,71,5,2.1,23.8,63.260000000000005]
["201523201801028","云婷婷",94,77,4,2.7,63,4,1.3,77,2.5,2.7,73,3,2.3,76,2,2.6,90,0.3,{"v":4,"d":"4.0"},92,2,4.2,92,1,4.2,79,5,2.9,23.8,63.150000000000006]
["201523201801031","杨奥",74,68,4,1.8,60,4,{"v":1,"d":"1.0"},50,2.5,{"v":0,"d":"0.0"},44,3,{"v":0,"d":"0.0"},70,2,{"v":2,"d":"2.0"},79,0.3,2.9,84,2,3.4,94,1,4.4,37,5,{"v":0,"d":"0.0"},23.8,27.270000000000003]
["201523201801039","何盼",84,78,4,2.8,77,4,2.7,69,2.5,1.9,41,3,{"v":0,"d":"0.0"},80,2,{"v":3,"d":"3.0"},83,0.3,3.3,79,2,2.9,94,1,4.4,50,5,{"v":0,"d":"0.0"},23.8,43.94]

{"sheet":"成绩汇总表","index":2,"n_rows":27,"n_cols":52,"rows_kept":27,"flags":["formulas_cached_only"]}
["学号","姓名","体育 [2]","体育（2） [2]","高等数学 [3]","学分","绩点","无机及分析化学 [5]","学分","绩点","大学英语 [5]","学分","绩点","思想道德修养与法律基础 [3]","学分","绩点","形势与政策 [.3]","学分","绩点","大学生心理健康教育 [2]","学分","绩点","计算机文化基础 [4]","学分","绩点","有机化学 [4]","学分","绩点","物理化学 [2.5]","学分","绩点","高等数学2 [3]","学分","绩点","中国近现代史纲要 [2]","学分","绩点","形势与政策 [.3]","学分","绩点","军事理论课 [2]","学分","绩点","大学生就业指导与创业教育 [1]","学分","绩点","大学英语（2） [5]","学分","绩点","总学分","总学分绩点","加权平均绩点"]
["201523201801002","王晶",75,60,84,3,3.4,74,5,2.4,74,5,2.4,86,3,3.6,89,0.3,3.9,72,2,2.2,85,4,3.5,74,4,2.4,83,2.5,3.3,83,3,3.3,76,2,2.6,81,0.3,3.1,95,2,4.5,96,1,4.6,72,5,2.2,42.099999999999994,123.05,{"v":2.922802850356295,"d":"2.92"}]
["201523201801003","徐扬",85,90,74,3,2.4,72,5,2.2,69,5,1.9,89,3,3.9,89,0.3,3.9,79,2,2.9,50,4,{"v":0,"d":"0.0"},75,4,2.5,69,2.5,1.9,61,3,1.1,84,2,3.4,86,0.3,3.6,86,2,3.6,98,1,4.8,70,5,{"v":2,"d":"2.0"},42.099999999999994,94.3,{"v":2.2399049881235156,"d":"2.24"}]
["201523201801004","朱徐琳",80,83,72,3,2.2,68,5,1.8,72,5,2.2,88,3,3.8,79,0.3,2.9,75,2,2.5,76,4,2.6,73,4,2.3,80,2.5,{"v":3,"d":"3.0"},69,3,1.9,78,2,2.8,73,0.3,2.3,94,2,4.4,90,1,{"v":4,"d":"4.0"},71,5,2.1,42.099999999999994,106.25999999999999,{"v":2.523990498812352,"d":"2.52"}]
["201523201801005","郎帅英",79,80,84,3,3.4,76,5,2.6,77,5,2.7,87,3,3.7,91,0.3,4.1,82,2,3.2,68,4,1.8,57,4,{"v":0,"d":"0.0"},86,2.5,3.6,61,3,1.1,79,2,2.9,73,0.3,2.3,89,2,3.9,93,1,4.3,74,5,2.4,42.099999999999994,105.51999999999998,{"v":2.506413301662708,"d":"2.51"}]
["201523201801006","王媛",83,83,63,3,1.3,72,5,2.2,78,5,2.8,92,3,4.2,79,0.3,2.9,90,2,{"v":4,"d":"4.0"},53,4,{"v":0,"d":"0.0"},53,4,{"v":0,"d":"0.0"},41,2.5,{"v":0,"d":"0.0"},63,3,1.3,70,2,{"v":2,"d":"2.0"},77,0.3,2.7,91,2,4.1,96,1,4.6,64,5,1.4,42.099999999999994,78.88,{"v":1.8736342042755345,"d":"1.87"}]
["201523201801007","鲁勇华",85,88,74,3,2.4,60,5,{"v":1,"d":"1.0"},70,5,{"v":2,"d":"2.0"},81,3,3.1,85,0.3,3.5,63,2,1.3,62,4,1.2,64,4,1.4,60,2.5,{"v":1,"d":"1.0"},30,3,{"v":0,"d":"0.0"},71,2,2.1,73,0.3,2.3,87,2,3.7,91,1,4.1,60,5,{"v":1,"d":"1.0"},42.099999999999994,69.44,{"v":1.6494061757719716,"d":"1.65"}]
["201523201801008","丁鹏",79,80,80,3,{"v":3,"d":"3.0"},63,5,1.3,74,5,2.4,86,3,3.6,84,0.3,3.4,70,2,{"v":2,"d":"2.0"},66,4,1.6,67,4,1.7,76,2.5,2.6,75,3,2.5,77,2,2.7,83,0.3,3.3,88,2,3.8,92,1,4.2,67,5,1.7,42.099999999999994,97.21,{"v":2.3090261282660336,"d":"2.31"}]
["201523201801009","郑佳芸",80,91,79,3,2.9,70,5,{"v":2,"d":"2.0"},74,5,2.4,87,3,3.7,89,0.3,3.9,73,2,2.3,82,4,3.2,82,4,3.2,83,2.5,3.3,88,3,3.8,83,2,3.3,87,0.3,3.7,91,2,4.1,93,1,4.3,70,5,{"v":2,"d":"2.0"},42.099999999999994,123.02999999999999,{"v":2.922327790973872,"d":"2.92"}]
["201523201801011","李吉二",74,88,81,3,3.1,80,5,{"v":3,"d":"3.0"},79,5,2.9,84,3,3.4,91,0.3,4.1,82,2,3.2,88,4,3.8,75,4,2.5,80,2.5,{"v":3,"d":"3.0"},89,3,3.9,84,2,3.4,99,0.3,4.9,91,2,4.1,97,1,4.7,83,5,3.3,42.099999999999994,138.7,{"v":3.294536817102138,"d":"3.29"}]
["201523201801013","石文钦",94,92,89,3,3.9,81,5,3.1,79,5,2.9,83,3,3.3,84,0.3,3.4,83,2,3.3,84,4,3.4,94,4,4.4,88,2.5,3.8,88,3,3.8,74,2,2.4,87,0.3,3.7,98,2,4.8,96,1,4.6,73,5,2.3,42.099999999999994,142.93,{"v":3.395011876484561,"d":"3.40"}]
["201523201801014","郑文涛",78,83,86,3,3.6,79,5,2.9,75,5,2.5,81,3,3.1,75,0.3,2.5,81,2,3.1,56,4,{"v":0,"d":"0.0"},78,4,2.8,69,2.5,1.9,61,3,1.1,69,2,1.9,77,0.3,2.7,88,2,3.8,85,1,3.5,72,5,2.2,42.099999999999994,100.00999999999999,{"v":2.3755344418052258,"d":"2.38"}]
["201523201801015","张弘宇",86,88,86,3,3.6,83,5,3.3,84,5,3.4,79,3,2.9,84,0.3,3.4,83,2,3.3,68,4,1.8,95,4,4.5,86,2.5,3.6,88,3,3.8,72,2,2.2,87,0.3,3.7,91,2,4.1,96,1,4.6,91,5,4.1,42.099999999999994,145.03,{"v":3.4448931116389554,"d":"3.44"}]
["201523201801017","薛玲玲",84,85,94,3,4.4,84,5,3.4,78,5,2.8,79,3,2.9,91,0.3,4.1,85,2,3.5,90,4,{"v":4,"d":"4.0"},96,4,4.6,93,2.5,4.3,88,3,3.8,82,2,3.2,78,0.3,2.8,92,2,4.2,93,1,4.3,85,5,3.5,42.099999999999994,155.12000000000003,{"v":3.6845605700712603,"d":"3.68"}]
["201523201801018","韩子亮",88,70,80,3,{"v":3,"d":"3.0"},66,5,1.6,82,5,3.2,85,3,3.5,77,0.3,2.7,78,2,2.8,85,4,3.5,77,4,2.7,86,2.5,3.6,63,3,1.3,78,2,2.8,73,0.3,2.3,91,2,4.1,93,1,4.3,78,5,2.8,42.099999999999994,120.4,{"v":2.859857482185274,"d":"2.86"}]
["201523201801019","王叶红",79,80,61,3,1.1,65,5,1.5,77,5,2.7,90,3,{"v":4,"d":"4.0"},82,0.3,3.2,85,2,3.5,57,4,{"v":0,"d":"0.0"},60,4,{"v":1,"d":"1.0"},86,2.5,3.6,63,3,1.3,82,2,3.2,75,0.3,2.5,95,2,4.5,94,1,4.4,80,5,{"v":3,"d":"3.0"},42.099999999999994,96.71000000000001,{"v":2.2971496437054637,"d":"2.30"}]
["201523201801020","史悦悦",78,86,86,3,3.6,70,5,{"v":2,"d":"2.0"},82,5,3.2,89,3,3.9,82,0.3,3.2,89,2,3.9,72,4,2.2,90,4,{"v":4,"d":"4.0"},90,2.5,{"v":4,"d":"4.0"},85,3,3.5,85,2,3.5,82,0.3,3.2,98,2,4.8,97,1,4.7,80,5,{"v":3,"d":"3.0"},42.099999999999994,139.82,{"v":3.321140142517815,"d":"3.32"}]
["201523201801021","朱小峰",70,90,74,3,2.4,53,5,{"v":0,"d":"0.0"},60,5,{"v":1,"d":"1.0"},84,3,3.4,72,0.3,2.2,63,2,1.3,70,4,{"v":2,"d":"2.0"},73,4,2.3,73,2.5,2.3,78,3,2.8,65,2,1.5,86,0.3,3.6,88,2,3.8,89,1,3.9,76,5,2.6,42.099999999999994,85.59,{"v":2.033016627078385,"d":"2.03"}]
["201523201801022","卢楚霨",82,79,61,3,1.1,69,5,1.9,68,5,1.8,87,3,3.7,79,0.3,2.9,74,2,2.4,83,4,3.3,81,4,3.1,77,2.5,2.7,46,3,{"v":0,"d":"0.0"},81,2,3.1,72,0.3,2.2,91,2,4.1,93,1,4.3,68,5,1.8,42.099999999999994,99.28,{"v":2.3581947743467935,"d":"2.36"}]
["201523201801023","黄俊健",78,79,85,3,3.5,70,5,{"v":2,"d":"2.0"},64,5,1.4,79,3,2.9,78,0.3,2.8,66,2,1.6,70,4,{"v":2,"d":"2.0"},81,4,3.1,81,2.5,3.1,59,3,{"v":0,"d":"0.0"},62,2,1.2,73,0.3,2.3,82,2,3.2,92,1,4.2,53,5,{"v":0,"d":"0.0"},42.099999999999994,82.08000000000003,{"v":1.9496437054631839,"d":"1.95"}]
["201523201801024","陈玉琼",78,81,69,3,1.9,60,5,{"v":1,"d":"1.0"},86,5,3.6,90,3,{"v":4,"d":"4.0"},84,0.3,3.4,84,2,3.4,79,4,2.9,57,4,{"v":0,"d":"0.0"},68,2.5,1.8,60,3,{"v":1,"d":"1.0"},79,2,2.9,91,0.3,4.1,79,2,2.9,99,1,4.9,90,5,{"v":4,"d":"4.0"},42.099999999999994,105.35000000000001,{"v":2.5023752969121147,"d":"2.50"}]
["201523201801025","沈晨君",80,79,82,3,3.2,65,5,1.5,78,5,2.8,87,3,3.7,88,0.3,3.8,73,2,2.3,65,4,1.5,86,4,3.6,87,2.5,3.7,69,3,1.9,78,2,2.8,87,0.3,3.7,85,2,3.5,95,1,4.5,80,5,{"v":3,"d":"3.0"},42.099999999999994,116.5,{"v":2.767220902612827,"d":"2.77"}]
["201523201801026","蔡侠蘅",71,75,72,3,2.2,70,5,{"v":2,"d":"2.0"},72,5,2.2,87,3,3.7,86,0.3,3.6,89,2,3.9,87,4,3.7,76,4,2.6,75,2.5,2.5,69,3,1.9,79,2,2.9,87,0.3,3.7,88,2,3.8,97,1,4.7,80,5,{"v":3,"d":"3.0"},42.099999999999994,118.94,{"v":2.8251781472684088,"d":"2.83"}]
["201523201801027","王惠仪",78,81,90,3,{"v":4,"d":"4.0"},66,5,1.6,75,5,2.5,88,3,3.8,86,0.3,3.6,88,2,3.8,82,4,3.2,77,4,2.7,81,2.5,3.1,60,3,{"v":1,"d":"1.0"},78,2,2.8,87,0.3,3.7,86,2,3.6,95,1,4.5,71,5,2.1,42.099999999999994,115.83999999999999,{"v":2.7515439429928743,"d":"2.75"}]
["201523201801028","云婷婷",93,94,71,3,2.1,63,5,1.3,72,5,2.2,81,3,3.1,75,0.3,2.5,72,2,2.2,77,4,2.7,63,4,1.3,77,2.5,2.7,73,3,2.3,76,2,2.6,90,0.3,{"v":4,"d":"4.0"},92,2,4.2,92,1,4.2,79,5,2.9,42.099999999999994,101.40000000000002,{"v":2.4085510688836114,"d":"2.41"}]
["201523201801031","杨奥",68,74,75,3,2.5,54,5,{"v":0,"d":"0.0"},46,5,{"v":0,"d":"0.0"},88,3,3.8,82,0.3,3.2,68,2,1.8,68,4,1.8,60,4,{"v":1,"d":"1.0"},50,2.5,{"v":0,"d":"0.0"},44,3,{"v":0,"d":"0.0"},70,2,{"v":2,"d":"2.0"},79,0.3,2.9,84,2,3.4,94,1,4.4,37,5,{"v":0,"d":"0.0"},42.099999999999994,50.72999999999999,{"v":1.2049881235154394,"d":"1.20"}]
["201523201801039","何盼",88,84,72,3,2.2,55,5,{"v":0,"d":"0.0"},70,5,{"v":2,"d":"2.0"},85,3,3.5,88,0.3,3.8,80,2,{"v":3,"d":"3.0"},78,4,2.8,77,4,2.7,69,2.5,1.9,41,3,{"v":0,"d":"0.0"},80,2,{"v":3,"d":"3.0"},83,0.3,3.3,79,2,2.9,94,1,4.4,50,5,{"v":0,"d":"0.0"},42.099999999999994,78.17999999999999,{"v":1.8570071258907364,"d":"1.86"}]

{"sheet":"成绩排名","index":3,"n_rows":27,"n_cols":4,"rows_kept":27,"flags":["formulas_cached_only"]}
["学号","姓名","加权平均绩点","排名"]
["201523201801017","薛玲玲",{"v":3.6845605700712603,"d":"3.68"},1]
["201523201801015","张弘宇",{"v":3.4448931116389554,"d":"3.44"},2]
["201523201801013","石文钦",{"v":3.395011876484561,"d":"3.40"},3]
["201523201801020","史悦悦",{"v":3.321140142517815,"d":"3.32"},4]
["201523201801011","李吉二",{"v":3.294536817102138,"d":"3.29"},5]
["201523201801002","王晶",{"v":2.922802850356295,"d":"2.92"},6]
["201523201801009","郑佳芸",{"v":2.922327790973872,"d":"2.92"},7]
["201523201801018","韩子亮",{"v":2.859857482185274,"d":"2.86"},8]
["201523201801026","蔡侠蘅",{"v":2.8251781472684088,"d":"2.83"},9]
["201523201801025","沈晨君",{"v":2.767220902612827,"d":"2.77"},10]
["201523201801027","王惠仪",{"v":2.7515439429928743,"d":"2.75"},11]
["201523201801004","朱徐琳",{"v":2.523990498812352,"d":"2.52"},12]
["201523201801005","郎帅英",{"v":2.506413301662708,"d":"2.51"},13]
["201523201801024","陈玉琼",{"v":2.5023752969121147,"d":"2.50"},14]
["201523201801028","云婷婷",{"v":2.4085510688836114,"d":"2.41"},15]
["201523201801014","郑文涛",{"v":2.3755344418052258,"d":"2.38"},16]
["201523201801022","卢楚霨",{"v":2.3581947743467935,"d":"2.36"},17]
["201523201801008","丁鹏",{"v":2.3090261282660336,"d":"2.31"},18]
["201523201801019","王叶红",{"v":2.2971496437054637,"d":"2.30"},19]
["201523201801003","徐扬",{"v":2.2399049881235156,"d":"2.24"},20]
["201523201801021","朱小峰",{"v":2.033016627078385,"d":"2.03"},21]
["201523201801023","黄俊健",{"v":1.9496437054631839,"d":"1.95"},22]
["201523201801006","王媛",{"v":1.8736342042755345,"d":"1.87"},23]
["201523201801039","何盼",{"v":1.8570071258907364,"d":"1.86"},24]
["201523201801007","鲁勇华",{"v":1.6494061757719716,"d":"1.65"},25]
["201523201801031","杨奥",{"v":1.2049881235154394,"d":"1.20"},26]