{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["2必修课成绩","3选修课成绩","综合测评排名"],"read":"whole","date_system":"1900"}

{"sheet":"2必修课成绩","index":0,"n_rows":77,"n_cols":26,"rows_kept":77,"hidden":true}
[null,"课程号   ","100616M022          ","100844M001          ","100844M002          ","100844M013          ","100844X005          ","100925P014          ","100925P015          ","100925T001          ","100925T002          ","100925T005          ","100925T143          ","100925T186          ","100925T191          ","100925T192          ","100925T193          ","100925T195          ","100925T196          ","100925T197          ","101200X001          ","101500X001          "]
[null,"课程名   ","高等数学D     ","思想道德修养与法律基础           ","中国近现代史纲要        ","马克思主义基本原理概论           ","形势与政策教育       ","英语技能实践      ","社会实践与社会调查         ","综合英语（Ⅰ）       ","综合英语（Ⅱ）       ","英语语音    ","英语短篇小说选读        ","英语散文选读      ","基础写作    ","初级英语听力（I）         ","口语（I）     ","记叙文写作     ","初级英语听力（II）          ","口语（II）      ","军事训练（Ⅰ）       ","入学教育与安全教育         ",null,"挂科门数","优良率","必修课加权成绩"]
["学生  ","学  分    ","3 ","2 ","2 ","2 ","2 ","1 ",1,6,6,2,2,2,2,2,2,2,2,2,2,1,{"$nulls":3},46]
[null,"学分比重"]
["学  号    ","姓  名    "]
[2017011934,"阿依加马丽·阿卜迪克日木",{"$f":"17*3","v":{"v":51,"d":"51.000"}},"83.0    ","98.0    ","81.0    ","88.0    ","95.0    ","93.0    ","71.0    ","74.0    ","89.0    ","55.0    ","73.0    ","80.0    ","81.0    ","96.0    ","69.0    ","80.0    ","88.0    ","92.0    ","60.0    ",null,1,{"v":0.65,"d":"65.0%"},77.7608695652174]
[2017011935,"白元格",{"v":62,"d":"62.000"},"83.0    ","99.0    ","84.0    ","85.0    ","94.0    ","94.0    ","63.0    ","77.0    ","85.0    ","67.0    ","82.0    ","81.0    ","71.0    ","96.0    ","86.0    ","83.0    ","88.0    ","90.0    ","62.0    ",null,{"$f":"COUNTIF(D7:W7,\"<=60\")","v":0},{"v":0.7,"d":"70.0%"},79.0434782608696]
[2017011936,"陈俊霖",{"v":93,"d":"93.000"},"89.0    ","98.0    ","90.0    ","91.0    ","96.0    ","97.0    ","76.0    ","89.0    ","88.0    ","88.0    ","86.0    ","84.0    ","92.0    ","97.0    ","90.0    ","90.0    ","93.0    ","93.0    ","81.0    ",null,0,{"v":0.95,"d":"95.0%"},88.7173913043478]
[2017011937,"李秋莹",{"v":79,"d":"79.000"},"93.0    ","98.0    ",{"v":93,"d":"93.000"},"93.0    ","96.0    ","98.0    ","88.0    ","87.0    ","88.0    ",{"v":76,"d":"76.0"},"82.0    ","94.0    ","92.0    ","97.0    ","93.0    ","85.0    ","93.0    ","88.0    ",{"v":61,"d":"61.000"},null,0,{"v":0.85,"d":"85.0%"},88.5217391304348]
[2017011938,"李雪霏",84,91,98,89,86,95,93,73,81,85,72,84,90,90,97,91,87,93,90,79,null,0,{"v":0.85,"d":"85.0%"},85.4130434782609]
[2017011939,"李亚静",{"v":92,"d":"92.000"},"89.0    ","91.0    ","91.0    ","89.0    ","91.0    ","93.0    ","71.0    ","72.0    ","81.0    ","82.0    ","82.0    ","84.0    ","61.0    ","95.0    ","76.0    ","65.0    ","87.0    ","91.0    ","85.0    ",null,0,{"v":0.75,"d":"75.0%"},81.1086956521739]
[2017011940,"林芊语",{"v":87,"d":"87.000"},"85.0    ","92.0    ","91.0    ","88.0    ","91.0    ","97.0    ","79.0    ","93.0    ","90.0    ","90.0    ","87.0    ","94.0    ","98.0    ","95.0    ","93.0    ","90.0    ","95.0    ","89.0    ","85.0    ",null,0,{"v":0.95,"d":"95.0%"},89.5652173913043]
[2017011941,"刘静萱",{"v":77,"d":"77.000"},"87.0    ","87.0    ","85.0    ","91.0    ","94.0    ","97.0    ","84.0    ","91.0    ","89.0    ","71.0    ","91.0    ","90.0    ","92.0    ","97.0    ","90.0    ","90.0    ","96.0    ","86.0    ","72.0    ",null,0,{"v":0.85,"d":"85.0%"},87.5652173913043]
[2017011942,"刘柳",{"v":61,"d":"61.000"},"91.0    ","96.0    ","81.0    ","92.0    ","93.0    ","96.0    ","72.0    ","87.0    ","85.0    ","72.0    ","80.0    ","84.0    ","68.0    ","93.0    ","85.0    ","81.0    ","87.0    ","90.0    ","85.0    ",null,0,{"v":0.8,"d":"80.0%"},82.195652173913]
[2017011944,"闵小霖",{"v":64,"d":"64.000"},"94.0    ","90.0    ","94.0    ","87.0    ","94.0    ","97.0    ","81.0    ","84.0    ","90.0    ","81.0    ","78.0    ","89.0    ","91.0    ","96.0    ","87.0    ","82.0    ","90.0    ","90.0    ","77.0    ",null,0,{"v":0.85,"d":"85.0%"},85.3913043478261]
[2017011945,"牛晓静",{"v":79,"d":"79.000"},"89.0    ","93.0    ","88.0    ","92.0    ","92.0    ","94.0    ","71.0    ","77.0    ","85.0    ","77.0    ","77.0    ","84.0    ","72.0    ","94.0    ","86.0    ","80.0    ","88.0    ","87.0    ","79.0    ",null,0,{"v":0.65,"d":"65.0%"},82.0434782608696]
[2017011946,"孙佩瑶",{"v":68,"d":"68.000"},"83.0    ","87.0    ","80.0    ","88.0    ","90.0    ","95.0    ","79.0    ","83.0    ","84.0    ","89.0    ","77.0    ","81.0    ","81.0    ","95.0    ","85.0    ","64.0    ","89.0    ","86.0    ","73.0    ",null,0,{"v":0.75,"d":"75.0%"},82]
[2017011947,"孙玉",{"v":84,"d":"84.000"},"90.0    ","99.0    ","86.0    ","89.0    ","90.0    ","95.0    ","67.0    ","87.0    ","86.0    ","78.0    ","84.0    ","87.0    ","83.0    ","94.0    ","87.0    ","85.0    ","90.0    ","91.0    ","77.0    ",null,0,{"v":0.85,"d":"85.0%"},84.695652173913]
[2017011948,"王婧",{"v":84,"d":"84.000"},"83.0    ","94.0    ","84.0    ","86.0    ","91.0    ","95.0    ","70.0    ","82.0    ","84.0    ","89.0    ","87.0    ","84.0    ","84.0    ","95.0    ","88.0    ","81.0    ","92.0    ","87.0    ","72.0    ",null,0,{"v":0.9,"d":"90.0%"},83.8695652173913]
[2017011949,"王思远",{"v":70,"d":"70.000"},"89.0    ","93.0    ","88.0    ","86.0    ","90.0    ","95.0    ","69.0    ","79.0    ","86.0    ","83.0    ","81.0    ","84.0    ","80.0    ","92.0    ","88.0    ","80.0    ","89.0    ","85.0    ","74.0    ",null,0,{"v":0.8,"d":"80.0%"},81.8478260869565]
[2017011950,"王盈晖",{"v":69,"d":"69.000"},"80.0    ","94.0    ","83.0    ","90.0    ","93.0    ","95.0    ","79.0    ","88.0    ","89.0    ","81.0    ","86.0    ","92.0    ","90.0    ","95.0    ","92.0    ","85.0    ","94.0    ","88.0    ","70.0    ",null,0,{"v":0.85,"d":"85.0%"},85.7608695652174]
[2017011951,"希吉尔",{"v":71,"d":"71.000"},"86.0    ","92.0    ","83.0    ","88.0    ","95.0    ","95.0    ","74.0    ","87.0    ","89.0    ","70.0    ","80.0    ","88.0    ","86.0    ","96.0    ","88.0    ","87.0    ","90.0    ","92.0    ","76.0    ",null,0,{"v":0.8,"d":"80.0%"},84.2391304347826]
[2017011952,"谢捡英",{"v":94,"d":"94.000"},"82.0    ","93.0    ","86.0    ","88.0    ","92.0    ","93.0    ","76.0    ","85.0    ","84.0    ","71.0    ","91.0    ","88.0    ","81.0    ","92.0    ","85.0    ","80.0    ","87.0    ","82.0    ","81.0    ",null,0,{"v":0.9,"d":"90.0%"},84.6521739130435]
[2017011953,"杨柳依",{"v":98,"d":"98.000"},"94.0    ","94.0    ","95.0    ","89.0    ","92.0    ","93.0    ","82.0    ","81.0    ","83.0    ","80.0    ","88.0    ","87.0    ","91.0    ","94.0    ","88.0    ","91.0    ","89.0    ","88.0    ","78.0    ",null,0,{"v":0.95,"d":"95.0%"},87.7608695652174]
[2017011954,"尹一航",99,92,97,88,85,92,90,84,80,83,{"v":83.1,"d":"83"},76,85,85,96,85,86,93,92,77,null,0,{"v":0.9,"d":"90.0%"},86.7869565217391]
[2017011955,"赵洁",{"v":87,"d":"87.000"},"80.0    ","94.0    ","88.0    ","88.0    ","93.0    ","93.0    ","76.0    ","93.0    ","84.0    ","84.0    ","91.0    ","89.0    ","88.0    ","95.0    ","92.0    ","91.0    ","90.0    ","91.0    ","80.0    ",null,0,{"v":0.95,"d":"95.0%"},87.6304347826087]
[2017011956,"赵迎",{"v":95,"d":"95.000"},"94.0    ","95.0    ","89.0    ","87.0    ","93.0    ","93.0    ","83.0    ","89.0    ","85.0    ","81.0    ","90.0    ","89.0    ","91.0    ","96.0    ","92.0    ","91.0    ","95.0    ","85.0    ","66.0    ",null,0,{"v":0.95,"d":"95.0%"},88.8913043478261]
[2017011957,"达吾拉江·巴图尔",{"v":76,"d":"76.000"},"93.0    ","95.0    ","86.0    ","89.0    ","95.0    ","97.0    ","79.0    ","82.0    ","93.0    ","86.0    ","85.0    ","88.0    ","89.0    ","97.0    ","86.0    ","86.0    ","93.0    ","94.0    ","74.0    ",null,0,{"v":0.85,"d":"85.0%"},86.5217391304348]
[2017011958,"董涛",{"v":78,"d":"78.000"},"85.0    ","95.0    ","86.0    ","86.0    ","95.0    ","88.0    ","71.0    ","82.0    ","80.0    ","73.0    ","78.0    ","84.0    ","78.0    ","92.0    ","84.0    ","61.0    ","86.0    ","92.0    ","81.0    ",null,0,{"v":0.7,"d":"70.0%"},81.2173913043478]
[2017011959,"黄星晖",{"v":86,"d":"86.000"},"83.0    ","93.0    ","83.0    ","93.0    ","91.0    ","89.0    ","63.0    ","66.0    ","78.0    ","74.0    ","70.0    ","83.0    ","66.0    ","91.0    ","82.0    ","60.0    ","86.0    ","90.0    ","74.0    ",null,0,{"v":0.6,"d":"60.0%"},77.1739130434783]
[2017011960,"亓玉乾",{"v":91,"d":"91.000"},"87.0    ","92.0    ","87.0    ","84.0    ","90.0    ","89.0    ","72.0    ","87.0    ","80.0    ","77.0    ","78.0    ","85.0    ","81.0    ","97.0    ","83.0    ","80.0    ","89.0    ","92.0    ","76.0    ",null,0,{"v":0.8,"d":"80.0%"},84.0434782608696]
[2017011961,"袁赫",{"v":67,"d":"67.000"},"80.0    ","96.0    ","84.0    ","86.0    ","60.0    ","0 ","69.0    ","68.0    ","60.0    ","70.0    ","75.0    ","77.0    ","60.0    ","69.0    ","69.0    ","60.0    ","60.0    ","85.0    ","68.0    ",null,1,{"v":0.25,"d":"25.0%"},69.8478260869565]
[2017011962,"张钰",{"v":95,"d":"95.000"},"83.0    ","94.0    ","87.0    ","89.0    ","90.0    ","89.0    ","75.0    ","85.0    ","81.0    ","70.0    ","74.0    ","86.0    ","80.0    ","95.0    ","85.0    ","77.0    ","90.0    ","93.0    ","75.0    ",null,0,{"v":0.75,"d":"75.0%"},84.0652173913043]
[2017011963,"钟智颖",{"v":89,"d":"89.000"},"86.0    ","85.0    ","89.0    ","88.0    ","90.0    ","89.0    ","66.0    ","69.0    ","82.0    ","69.0    ","68.0    ","80.0    ","74.0    ","95.0    ","85.0    ","60.0    ","88.0    ","90.0    ","79.0    ",null,0,{"v":0.65,"d":"65.0%"},78.5434782608696]
[2017011964,"陈阿丽娜"]
[2017011965,"陈芊颖"]
[2017011966,"胡芬"]
[2017011967,"胡红"]
[2017011968,"贾婷"]
[2017011969,"李嘉欣"]
[2017011970,"李桢"]
[2017011971,"刘月"]
[2017011972,"吕晶"]
[2017011973,"谭怡敏"]
[2017011974,"唐杰婧"]
[2017011975,"王一凡"]
[2017011976,"王依甜"]
[2017011977,"魏嘉祯"]
[2017011978,"温馨"]
[2017011979,"吴函慧"]
[2017011980,"肖云舫"]
[2017011981,"谢华"]
[2017011982,"熊瑶"]
[2017011983,"杨茜"]
[2017011984,"张慧影"]
[2017011985,"周知悦"]
[2017011986,"佐拉力·多力昆江"]
[2017011987,"雷永兴"]
[2017011988,"刘丰恺"]
[2017011989,"孙伟"]
[2017011990,"王圣钊"]
[2017011991,"王者风"]
[2017011992,"杨壮"]
{"$rows_empty":10}
["补考成绩高于60分按60分算"]
["缓考、学分替代学生须上交缓考证明材料"]
["民族生（综合教务系统有明确显示）及格分数线低于普通学生，注意"]
["缓考中无成绩的科目不计入综合测评"]

{"sheet":"3选修课成绩","index":1,"n_rows":34,"n_cols":45,"rows_kept":34,"hidden":true}
[null,"课程号   ","100514X002          ","100855G004          ","100888G008          ","100925T104          ","100925T142          ","100925T181          ","101400G002          ","100723G002          ","100866G010          ","100866G008          ","100877G009          ","100514G016          ","100855G018          ","100866G002          ","100888G010          ","100855G001          ","100855G022          ","100866G006          ","100925T065          ","100855G028          ","100866G011          ","100877G012          ","100888G013          ","100855G025          ","100877G006          ","100719G001          ","100866G001          ","100925G096          ","100925T070          ","100724G007          ","100877G018          ","100866G017          ","100877G017          ","100514G039          ","100724G001          ","100866G004          ","100877G015          ","100855G023          ","100101G001          ","100514G032          ","100627G006          "]
[null,"课程名   ","大学计算机基础实践         ","外国文学名著赏析        ","大学生心理素质调适         ","英语戏剧选读      ","英语学习导论      ","跨文化交际     ","信息检索与网络资源利用           ","经济法概论     ","音乐审美与名曲博览         ","外国音乐赏析      ","西方哲学思潮      ","网页设计与网站建设         ","国学经典研读      ","素描  ","口才训练    ","大学语文    ","人类学入门     ","乐理与视唱     ","第二外语(Ⅰ)(日语)           ","中国传统文化拓展与实践           ","合唱艺术（双语）        ","公司法   ","汉字与中国传统文化         ","中国现代文学名家评介          ","两岸关系与台海问题         ","经济学基础     ","水彩画技法     ","英美电影欣赏      ","第二外语(Ⅰ)(法语)           ","企业文化    ","西方政治思想史       ","陶笛基础教程      ","现代政治学     ","C语言程序设计（B）          ","决策与评价     ","书法鉴赏    ","当代世界经济与政治         ","社会研究与当代中国         ","地球科学概论      ","Linux系统及应用          ","物理技术与实践 "]
["学生  ","学  分    ","1 ","2 ","1 ","2 ","1 ","2 ","2 ","2 ","2 ","2 ","2 ","2 ","1 ","2 ","2 ","2 ","2 ","2 ","4 ","1 ","2 ","2 ","2 ","2 ","2 ","2 ","2 ","2 ","4 ","1 ","2 ","2 ","2 ","4 ","1 ","2 ","2 ","2 ","2 ","2 ","2 ","大一选修课加权平均成绩","不及格科目数"]
[null,"学分比重",0.012987013,0.025974026,0.012987013,0.025974026,0.012987013,0.025974026,0.025974026,0.025974026,0.025974026,0.025974026,0.025974026,0.025974026,0.012987013,0.025974026,0.025974026,0.025974026,0.025974026,0.025974026,0.051948052,0.012987013,0.025974026,0.025974026,0.025974026,0.025974026,0.025974026,0.025974026,0.025974026,0.025974026,0.051948052,0.012987013,0.025974026,0.025974026,0.025974026,0.051948052,0.012987013,0.025974026,0.025974026,0.025974026,0.025974026,0.025974026,0.025974026,1]
["学  号    ","姓  名    "]
[2017011934,"阿依加马丽·阿卜迪克日木",{"v":86,"d":"86.00"},{"v":86,"d":"86.00"},{"v":90,"d":"90.00"},{"v":87,"d":"87.00"},{"v":73,"d":"73.00"},{"v":85,"d":"85.00"},{"v":67,"d":"67.00"},{"$nulls":34},{"$f":"16.34545454/0.2","v":{"v":81.72727269999999,"d":"81.72727270"}},0]
[2017011935,"白元格",{"v":93,"d":"93.00"},null,{"v":94,"d":"94.00"},{"v":90,"d":"90.00"},{"v":85,"d":"85.00"},{"v":82,"d":"82.00"},null,{"v":86,"d":"86.00"},{"v":62,"d":"62.00"},{"$nulls":32},{"$f":"16.58181818/0.2","v":{"v":82.9090909,"d":"82.90909090"}},0]
[2017011936,"陈俊霖",{"v":97,"d":"97.00"},null,{"v":89,"d":"89.00"},{"v":87,"d":"87.00"},{"v":94,"d":"94.00"},{"v":93,"d":"93.00"},{"v":90,"d":"90.00"},null,null,{"v":95,"d":"95.00"},{"v":90,"d":"90.00"},{"$nulls":30},{"$f":"18.3076923/0.2","v":{"v":91.5384615,"d":"91.53846150"}},0]
[2017011937,"李秋莹",{"v":98,"d":"98.00"},{"v":92,"d":"92.00"},{"v":92,"d":"92.00"},{"v":87,"d":"87.00"},{"v":94,"d":"94.00"},{"v":94,"d":"94.00"},{"$nulls":5},{"v":91,"d":"91.00"},{"v":96,"d":"96.00"},{"v":90,"d":"90.00"},{"v":89,"d":"89.00"},{"$nulls":26},{"$f":"18.325/0.2","v":{"v":91.62499999999999,"d":"91.62500000"}},0]
[2017011938,"李雪霏",null,null,94,null,94,null,88,null,73,94,{"$nulls":6},94,{"$nulls":7},96,{"$nulls":16},{"$f":"17.966666667/0.2","v":89.83333333499999},0]
[2017011939,"李亚静",{"v":86,"d":"86.00"},null,{"v":95,"d":"95.00"},{"v":83,"d":"83.00"},{"v":93,"d":"93.00"},{"v":78,"d":"78.00"},{"v":80,"d":"80.00"},{"$nulls":8},{"v":88,"d":"88.00"},{"v":91,"d":"91.00"},{"$nulls":24},{"$f":"17.13846153/0.2","v":85.69230765},0]
[2017011940,"林芊语",null,null,{"v":92,"d":"92.00"},null,{"v":93,"d":"93.00"},{"v":91,"d":"91.00"},{"$nulls":3},{"v":93,"d":"93.00"},{"$nulls":7},{"v":98,"d":"98.00"},{"v":99,"d":"99.00"},{"$nulls":22},{"$f":"19.08333333/0.2","v":{"v":95.41666664999998,"d":"95.41666665"}},0]
[2017011941,"刘静萱",{"v":82,"d":"82.00"},{"v":90,"d":"90.00"},{"v":94,"d":"94.00"},{"v":88,"d":"88.00"},{"v":95,"d":"95.00"},{"v":85,"d":"85.00"},{"$nulls":8},{"v":91,"d":"91.00"},{"$nulls":3},{"v":94,"d":"94.00"},{"v":94,"d":"94.00"},{"v":89,"d":"89.00"},{"v":90,"d":"90.00"},{"$nulls":19},{"$f":"18.07/0.2","v":{"v":90.35,"d":"90.35000000"}},0]
[2017011942,"刘柳",null,null,{"v":97,"d":"97.00"},{"v":90,"d":"90.00"},{"v":90,"d":"90.00"},null,{"v":77,"d":"77.00"},{"$nulls":15},{"v":83,"d":"83.00"},{"$nulls":18},{"$f":"17.175/0.2","v":{"v":85.875,"d":"85.87500000"}},0]
[2017011944,"闵小霖",null,null,{"v":93,"d":"93.00"},null,{"v":92,"d":"92.00"},{"v":87,"d":"87.00"},{"$nulls":3},{"v":96,"d":"96.00"},{"v":94,"d":"94.00"},{"$nulls":12},{"v":90,"d":"90.00"},{"v":91,"d":"91.00"},{"$nulls":16},{"$f":"18.35/0.2","v":{"v":91.75,"d":"91.75000000"}},0]
[2017011945,"牛晓静",{"v":95,"d":"95.00"},null,{"v":93,"d":"93.00"},null,{"v":90,"d":"90.00"},{"v":83,"d":"83.00"},{"$nulls":3},{"v":88,"d":"88.00"},{"$nulls":31},{"$f":"17.71428571/0.2","v":88.57142855},0]
[2017011946,"孙佩瑶",null,null,{"v":91,"d":"91.00"},{"v":81,"d":"81.00"},{"v":88,"d":"88.00"},{"v":87,"d":"87.00"},{"$nulls":12},{"v":92,"d":"92.00"},null,{"v":85,"d":"85.00"},{"v":89,"d":"89.00"},{"$nulls":19},{"$f":"17.58571429/0.2","v":87.92857144999999},0]
[2017011947,"孙玉",{"v":91,"d":"91.00"},null,{"v":92,"d":"92.00"},{"v":82,"d":"82.00"},{"v":87,"d":"87.00"},{"v":79,"d":"79.00"},{"v":89,"d":"89.00"},{"$nulls":5},{"v":88,"d":"88.00"},{"$nulls":8},{"v":86,"d":"86.00"},{"$nulls":3},{"v":93,"d":"93.00"},{"v":85,"d":"85.00"},{"v":79,"d":"79.00"},{"$nulls":13},{"$f":"17.075/0.2","v":85.37499999999999},0]
[2017011948,"王婧",{"v":97,"d":"97.00"},null,{"v":86,"d":"86.00"},{"v":86,"d":"86.00"},{"v":87,"d":"87.00"},{"v":88,"d":"88.00"},{"$nulls":4},{"v":80,"d":"80.00"},null,{"v":92,"d":"92.00"},{"$nulls":8},{"v":83,"d":"83.00"},{"$nulls":3},{"v":85,"d":"85.00"},{"v":86,"d":"86.00"},null,{"v":93,"d":"93.00"},{"$nulls":12},{"$f":"17.5/0.2","v":87.5},0]
[2017011949,"王思远",null,null,{"v":93,"d":"93.00"},{"v":89,"d":"89.00"},{"v":87,"d":"87.00"},{"v":77,"d":"77.00"},{"$nulls":3},{"v":94,"d":"94.00"},{"$nulls":11},{"v":77,"d":"77.00"},{"$nulls":7},{"v":78,"d":"78.00"},{"v":87,"d":"87.00"},{"$nulls":10},{"$f":"17.01538462/0.2","v":85.07692309999999},0]
[2017011950,"王盈晖",null,null,{"v":91,"d":"91.00"},{"v":86,"d":"86.00"},{"v":90,"d":"90.00"},{"v":78,"d":"78.00"},{"$nulls":12},{"v":92,"d":"92.00"},null,null,{"v":81,"d":"81.00"},{"$nulls":4},{"v":80,"d":"80.00"},{"$nulls":14},{"$f":"17.12857143/0.2","v":85.64285715},0]
[2017011951,"希吉尔",null,null,{"v":90,"d":"90.00"},{"v":79,"d":"79.00"},{"v":83,"d":"83.00"},{"v":78,"d":"78.00"},{"$nulls":12},{"v":90,"d":"90.00"},null,{"v":84,"d":"84.00"},{"v":80,"d":"80.00"},{"$nulls":19},{"$f":"16.78571429/0.2","v":83.92857145},0]
[2017011952,"谢捡英",{"v":62,"d":"62.00"},null,{"v":91,"d":"91.00"},null,{"v":88,"d":"88.00"},{"v":94,"d":"94.00"},{"$nulls":19},{"v":95,"d":"95.00"},null,{"v":84,"d":"84.00"},{"$nulls":3},{"v":81,"d":"81.00"},{"v":94,"d":"94.00"},{"$nulls":8},{"$f":"17.49230769/0.2","v":87.46153844999999},0]
[2017011953,"杨柳依",null,{"v":87,"d":"87.00"},{"v":96,"d":"96.00"},{"v":90,"d":"90.00"},{"v":94,"d":"94.00"},{"v":95,"d":"95.00"},{"v":85,"d":"85.00"},{"$nulls":9},{"v":88,"d":"88.00"},{"$nulls":13},{"v":89,"d":"89.00"},{"$nulls":10},{"$f":"17.97142857/0.2","v":89.85714285},0]
[2017011954,"尹一航",73,null,89,79,92,{"$nulls":16},96,{"$nulls":3},89,{"$nulls":6},90,{"$nulls":8},{"$f":"17.490909091/0.2","v":87.45454545499999},0]
[2017011955,"赵洁",91,{"$nulls":3},{"v":93,"d":"93.0"},null,{"v":85,"d":"85.0"},null,{"v":81,"d":"81.0"},{"$nulls":24},{"v":88,"d":"88.0"},{"$nulls":7},{"$f":"17.36/0.2","v":86.8},0]
[2017011956,"赵迎",null,null,{"v":92,"d":"92.0"},null,{"v":94,"d":"94.0"},{"v":91,"d":"91.0"},{"v":88,"d":"88.0"},{"$nulls":13},{"v":88,"d":"88.0"},{"$nulls":4},{"v":95,"d":"95.0"},{"$nulls":15},{"$f":"18.2/0.2","v":90.99999999999999},0]
[2017011957,"达吾拉江·巴图尔",null,null,{"v":93,"d":"93.0"},{"v":90,"d":"90.0"},{"v":83,"d":"83.0"},{"v":89,"d":"89.0"},{"$nulls":5},{"v":77,"d":"77.0"},null,null,{"v":87,"d":"87.0"},{"$nulls":20},{"v":80,"d":"80.0"},{"$nulls":5},{"$f":"17.033333333/0.2","v":85.16666666500001},0]
[2017011958,"董涛",87,{"v":94,"d":"94.0"},{"v":96,"d":"96.0"},{"v":75,"d":"75.0"},{"v":77,"d":"77.0"},{"v":81,"d":"81.0"},{"$nulls":5},{"v":76,"d":"76.0"},{"$nulls":12},{"v":91,"d":"91.0"},{"$nulls":9},{"v":87,"d":"87.0"},null,{"v":87,"d":"87.0"},{"$nulls":4},{"$f":"16.9375/0.2","v":84.6875},0]
[2017011959,"黄星晖",62,null,{"v":91,"d":"91.0"},{"v":75,"d":"75.0"},{"v":80,"d":"80.0"},{"v":64,"d":"64.0"},null,null,{"v":73,"d":"73.0"},{"$nulls":5},{"v":87,"d":"87.0"},{"$nulls":21},{"v":77,"d":"77.0"},{"$nulls":4},{"$f":"15.153846154/0.2","v":75.76923077},0]
[2017011960,"亓玉乾",81,null,{"v":96,"d":"96.0"},{"v":79,"d":"79.0"},{"v":84,"d":"84.0"},{"v":77,"d":"77.0"},{"$nulls":5},{"v":74,"d":"74.0"},{"$nulls":11},{"v":87,"d":"87.0"},{"$nulls":13},{"v":92,"d":"92.0"},{"$nulls":3},{"$f":"16.6/0.2","v":83},0]
[2017011961,"袁赫",73,null,{"v":89,"d":"89.0"},null,{"v":66,"d":"66.0"},{"$nulls":10},{"v":86,"d":"86.0"},{"$nulls":22},{"v":90,"d":"90.0"},{"v":87,"d":"87.0"},null,{"$f":"16.755555556/0.2","v":83.77777778},0]
[2017011962,"张钰",77,null,{"v":94,"d":"94.0"},{"v":86,"d":"86.0"},{"v":86,"d":"86.0"},{"v":88,"d":"88.0"},{"v":89,"d":"89.0"},{"$nulls":16},{"v":87,"d":"87.0"},{"$nulls":13},{"v":85,"d":"85.0"},{"$nulls":3},{"$f":"17.64/0.2","v":88.2},0]
[2017011963,"钟智颖",91,null,{"v":82,"d":"82.0"},null,{"v":87,"d":"87.0"},{"$nulls":28},{"v":83,"d":"83.0"},{"v":80,"d":"80.0"},{"$nulls":5},{"v":83,"d":"83.0"},{"$f":"15.236363636/0.2","v":76.18181818},0]

{"sheet":"综合测评排名","index":2,"n_rows":57,"n_cols":11,"rows_kept":57,"merged":[[0,0,0,10]]}
["中国石油大学（北京）外国语学院英语专业本科生综合测评汇总表"]
["序号","学号","德育总成绩","智育总成绩","体育总成绩","必修课优良率%","综合测评成绩","专业四级成绩","体测成绩","不及格门数","有无纪律处分"]
[1,2018011973,{"v":144,"d":"144.00"},{"v":187.78204081632654,"d":"187.78"},{"v":81.7,"d":"81.70"},{"v":1,"d":"100.00%"},{"v":168.41742857142856,"d":"168.42"},"无",{"v":81.7,"d":"81.70"},0,"无"]
[2,2018011983,{"v":131,"d":"131.00"},{"v":176.90969387755104,"d":"176.91"},{"v":78.4,"d":"78.40"},{"v":1,"d":"100.00%"},{"v":157.87678571428572,"d":"157.88"},"无",{"v":78.4,"d":"78.40"},0,"无"]
[3,2018011970,{"v":162,"d":"162.00"},{"v":166.0408163265306,"d":"166.04"},{"v":84,"d":"84.00"},{"v":1,"d":"100.00%"},{"v":157.0285714285714,"d":"157.03"},"无",{"v":84,"d":"84.00"},0,"无"]
[4,2018011980,{"v":110.5,"d":"110.50"},{"v":150.44897959183675,"d":"150.45"},{"v":77.8,"d":"77.80"},{"v":1,"d":"100.00%"},{"v":135.1942857142857,"d":"135.19"},"无",{"v":77.8,"d":"77.80"},0,"无"]
[5,2018011931,{"v":106.5,"d":"106.50"},147.25,{"v":62.2,"d":"62.20"},{"v":1,"d":"100.00%"},{"v":130.595,"d":"130.60"},"无",{"v":62.2,"d":"62.20"},0,"无"]
[6,2018011976,{"v":100.5,"d":"100.50"},{"v":124.05404644616468,"d":"124.05"},{"v":74.7,"d":"74.70"},{"v":1,"d":"100.00%"},{"v":114.40783251231528,"d":"114.41"},"无",{"v":74.7,"d":"74.70"},0,"无"]
[7,2018010170,{"v":99,"d":"99.00"},{"v":118.49710691823901,"d":"118.50"},{"v":65.8,"d":"65.80"},{"v":1,"d":"100.00%"},{"v":109.3279748427673,"d":"109.33"},"无",{"v":65.8,"d":"65.80"},0,"无"]
[8,2018011974,{"v":119.5,"d":"119.50"},{"v":106.29795918367347,"d":"106.30"},{"v":77,"d":"77.00"},{"v":0.9090909090909091,"d":"90.91%"},{"v":106.00857142857143,"d":"106.01"},"无",{"v":77,"d":"77.00"},0,"无"]
[9,2018011950,{"v":88,"d":"88.00"},{"v":112.19061224489796,"d":"112.19"},{"v":77.3,"d":"77.30"},{"v":1,"d":"100.00%"},{"v":103.86342857142857,"d":"103.86"},"无",{"v":77.3,"d":"77.30"},0,"无"]
[10,2018011964,{"v":122,"d":"122.00"},{"v":102.35142857142857,"d":"102.35"},{"v":78,"d":"78.00"},{"v":1,"d":"100.00%"},{"v":103.846,"d":"103.85"},"无",{"v":78,"d":"78.00"},0,"无"]
[11,2018011963,{"v":96,"d":"96.00"},{"v":107.27891156462584,"d":"107.28"},{"v":60,"d":"60.00"},{"v":0.8181818181818182,"d":"81.82%"},{"v":100.29523809523809,"d":"100.30"},"无",{"v":60,"d":"60.00"},0,"无"]
[12,2018011948,{"v":128.9,"d":"128.90"},{"v":94.72619047619048,"d":"94.73"},{"v":73.8,"d":"73.80"},{"v":1,"d":"100.00%"},{"v":99.46833333333333,"d":"99.47"},"无",{"v":73.8,"d":"73.80"},0,"无"]
[13,2018011935,{"v":95,"d":"95.00"},{"v":104.08390022675736,"d":"104.08"},{"v":73.9,"d":"73.90"},{"v":0.9090909090909091,"d":"90.91%"},{"v":99.24873015873015,"d":"99.25"},"无",{"v":73.9,"d":"73.90"},0,"无"]
[14,2018011961,{"v":108,"d":"108.00"},{"v":98.73843537414966,"d":"98.74"},{"v":82.8,"d":"82.80"},{"v":0.9090909090909091,"d":"90.91%"},{"v":98.99690476190477,"d":"99.00"},"无",{"v":82.8,"d":"82.80"},0,"无"]
[15,2018011971,{"v":104.5,"d":"104.50"},{"v":100.49396226415095,"d":"100.49"},{"v":72.8,"d":"72.80"},{"v":0.75,"d":"75.00%"},{"v":98.52577358490566,"d":"98.53"},"无",{"v":72.8,"d":"72.80"},0,"无"]
[16,2018011949,{"v":98.5,"d":"98.50"},{"v":102.52838589981447,"d":"102.53"},{"v":62.4,"d":"62.40"},{"v":1,"d":"100.00%"},{"v":97.70987012987013,"d":"97.71"},"无",{"v":62.4,"d":"62.40"},0,"无"]
[17,2018011960,{"v":109.5,"d":"109.50"},{"v":97.12142857142858,"d":"97.12"},{"v":73,"d":"73.00"},{"v":0.8181818181818182,"d":"81.82%"},{"v":97.185,"d":"97.19"},"无",{"v":73,"d":"73.00"},0,"无"]
[18,2018011985,{"v":95,"d":"95.00"},{"v":101.04761904761907,"d":"101.05"},{"v":72.7,"d":"72.70"},{"v":0.5454545454545454,"d":"54.55%"},{"v":97.00333333333333,"d":"97.00"},"无",{"v":72.7,"d":"72.70"},0,"无"]
[19,2018011932,{"v":98,"d":"98.00"},{"v":98.3687074829932,"d":"98.37"},{"v":73.3,"d":"73.30"},{"v":0.9090909090909091,"d":"90.91%"},{"v":95.78809523809524,"d":"95.79"},"无",{"v":73.3,"d":"73.30"},0,"无"]
[20,2018011936,{"v":131.5,"d":"131.50"},{"v":85.80377358490566,"d":"85.80"},{"v":64.9,"d":"64.90"},{"v":0.6666666666666666,"d":"66.67%"},{"v":92.85264150943395,"d":"92.85"},"无",{"v":64.9,"d":"64.90"},0,"无"]
[21,2018011937,{"v":118.5,"d":"118.50"},{"v":88.57031539888682,"d":"88.57"},{"v":66.9,"d":"66.90"},{"v":0.8181818181818182,"d":"81.82%"},{"v":92.38922077922078,"d":"92.39"},"无",{"v":66.9,"d":"66.90"},0,"无"]
[22,2018011988,{"v":132.5,"d":"132.50"},{"v":86.8671201814059,"d":"86.87"},{"v":46.6,"d":"46.60"},{"v":0.9090909090909091,"d":"90.91%"},{"v":91.96698412698412,"d":"91.97"},"无",{"v":46.6,"d":"46.60"},0,"无"]
[23,2018011933,{"v":90,"d":"90.00"},{"v":94.83492063492065,"d":"94.83"},{"v":70,"d":"70.00"},{"v":0.9090909090909091,"d":"90.91%"},{"v":91.38444444444445,"d":"91.38"},"无",{"v":70,"d":"70.00"},0,"无"]
[24,2018011972,{"v":102.5,"d":"102.50"},{"v":93.02285714285716,"d":"93.02"},{"v":57.4,"d":"57.40"},{"v":0.7272727272727273,"d":"72.73%"},{"v":91.35600000000001,"d":"91.36"},"无",{"v":57.4,"d":"57.40"},0,"无"]
[25,2018011975,{"v":100,"d":"100.00"},{"v":90.9543817527011,"d":"90.95"},{"v":67.9,"d":"67.90"},{"v":0.7272727272727273,"d":"72.73%"},{"v":90.45806722689078,"d":"90.46"},"无",{"v":67.9,"d":"67.90"},0,"无"]
[26,2018011943,{"v":83.5,"d":"83.50"},{"v":93.46122448979591,"d":"93.46"},{"v":77.8,"d":"77.80"},{"v":1,"d":"100.00%"},{"v":89.90285714285714,"d":"89.90"},"无",{"v":77.8,"d":"77.80"},0,"有"]
[27,2018011951,{"v":100,"d":"100.00"},{"v":91.84981132075472,"d":"91.85"},{"v":55.9,"d":"55.90"},{"v":0.8461538461538461,"d":"84.62%"},{"v":89.88486792452831,"d":"89.88"},"无",{"v":55.9,"d":"55.90"},0,"无"]
[28,2018011934,{"v":97.5,"d":"97.50"},{"v":89.66775510204081,"d":"89.67"},{"v":75,"d":"75.00"},{"v":0.7272727272727273,"d":"72.73%"},{"v":89.76742857142857,"d":"89.77"},"无",{"v":75,"d":"75.00"},0,"无"]
[29,2018011959,{"v":109.5,"d":"109.50"},{"v":85.82823129251702,"d":"85.83"},{"v":75.4,"d":"75.40"},{"v":0.9090909090909091,"d":"90.91%"},{"v":89.51976190476192,"d":"89.52"},"无",{"v":75.4,"d":"75.40"},0,"无"]
[30,2018011945,{"v":96,"d":"96.00"},{"v":90.88344671201814,"d":"90.88"},{"v":66.5,"d":"66.50"},{"v":1,"d":"100.00%"},{"v":89.4684126984127,"d":"89.47"},"无",{"v":66.5,"d":"66.50"},0,"无"]
[31,2018011947,{"v":95,"d":"95.00"},{"v":89.06632653061226,"d":"89.07"},{"v":71.5,"d":"71.50"},{"v":0.9090909090909091,"d":"90.91%"},{"v":88.49642857142858,"d":"88.50"},"无",{"v":71.5,"d":"71.50"},0,"无"]
[32,2018011946,{"v":95,"d":"95.00"},{"v":89.66463785757762,"d":"89.66"},{"v":66.2,"d":"66.20"},{"v":0.8333333333333334,"d":"83.33%"},{"v":88.38524650030433,"d":"88.39"},"无",{"v":66.2,"d":"66.20"},0,"无"]
[33,2018011954,{"v":107.5,"d":"107.50"},{"v":87.94948979591837,"d":"87.95"},{"v":51.1,"d":"51.10"},{"v":0.8181818181818182,"d":"81.82%"},{"v":88.17464285714284,"d":"88.17"},"无",{"v":51.1,"d":"51.10"},0,"无"]
[34,2018011978,{"v":101.5,"d":"101.50"},{"v":87.68003549245785,"d":"87.68"},{"v":60.4,"d":"60.40"},{"v":1,"d":"100.00%"},{"v":87.7160248447205,"d":"87.72"},"无",{"v":60.4,"d":"60.40"},0,"无"]
[35,2018011967,{"v":100,"d":"100.00"},{"v":87.42734693877551,"d":"87.43"},{"v":57.8,"d":"57.80"},{"v":0.8181818181818182,"d":"81.82%"},{"v":86.97914285714285,"d":"86.98"},"无",{"v":57.8,"d":"57.80"},0,"无"]
[36,2018011929,{"v":98,"d":"98.00"},{"v":86.73233082706768,"d":"86.73"},{"v":64.5,"d":"64.50"},{"v":0.7272727272727273,"d":"72.73%"},{"v":86.76263157894738,"d":"86.76"},"无",{"v":64.5,"d":"64.50"},0,"无"]
[37,2018011930,{"v":97.5,"d":"97.50"},{"v":86.53558118899736,"d":"86.54"},{"v":60,"d":"60.00"},{"v":0.8181818181818182,"d":"81.82%"},{"v":86.07490683229815,"d":"86.07"},"无",{"v":60,"d":"60.00"},0,"无"]
[38,2018011965,{"v":108,"d":"108.00"},{"v":81.59546485260772,"d":"81.60"},{"v":71.2,"d":"71.20"},{"v":0.6363636363636364,"d":"63.64%"},{"v":85.8368253968254,"d":"85.84"},"无",{"v":71.2,"d":"71.20"},0,"无"]
[39,2018011979,{"v":99,"d":"99.00"},{"v":84.11224489795919,"d":"84.11"},{"v":71.2,"d":"71.20"},{"v":0.8181818181818182,"d":"81.82%"},{"v":85.79857142857144,"d":"85.80"},"无",{"v":71.2,"d":"71.20"},0,"无"]
[40,2018011952,{"v":97.5,"d":"97.50"},{"v":84.2344671201814,"d":"84.23"},{"v":70.9,"d":"70.90"},{"v":0.7272727272727273,"d":"72.73%"},{"v":85.55412698412698,"d":"85.55"},"无",{"v":70.9,"d":"70.90"},0,"无"]
[41,2018011966,{"v":98.5,"d":"98.50"},{"v":83.28859543817526,"d":"83.29"},{"v":73.6,"d":"73.60"},{"v":0.45454545454545453,"d":"45.45%"},{"v":85.36201680672268,"d":"85.36"},"无",{"v":73.6,"d":"73.60"},0,"无"]
[42,2018011955,{"v":89.5,"d":"89.50"},{"v":87.04030612244898,"d":"87.04"},{"v":64.9,"d":"64.90"},{"v":0.9090909090909091,"d":"90.91%"},{"v":85.31821428571428,"d":"85.32"},"无",{"v":64.9,"d":"64.90"},0,"无"]
[43,2018011953,{"v":97.5,"d":"97.50"},{"v":83.63599257884972,"d":"83.64"},{"v":66.5,"d":"66.50"},{"v":0.7272727272727273,"d":"72.73%"},{"v":84.6951948051948,"d":"84.70"},"无",{"v":66.5,"d":"66.50"},0,"无"]
[44,2018011981,{"v":95,"d":"95.00"},{"v":84.60102040816327,"d":"84.60"},{"v":62.4,"d":"62.40"},{"v":0.5454545454545454,"d":"54.55%"},{"v":84.46071428571427,"d":"84.46"},"无",{"v":62.4,"d":"62.40"},0,"无"]
[45,2018011939,{"v":103.5,"d":"103.50"},{"v":78.4452690166976,"d":"78.45"},{"v":85,"d":"85.00"},{"v":0.45454545454545453,"d":"45.45%"},{"v":84.11168831168831,"d":"84.11"},"无",{"v":85,"d":"85.00"},0,"无"]
[46,2018011940,{"v":95,"d":"95.00"},{"v":81.68237476808905,"d":"81.68"},{"v":76.6,"d":"76.60"},{"v":0.7272727272727273,"d":"72.73%"},{"v":83.83766233766232,"d":"83.84"},"无",{"v":76.6,"d":"76.60"},0,"无"]
[47,2018011987,{"v":95.5,"d":"95.50"},{"v":83.184126984127,"d":"83.18"},{"v":60.3,"d":"60.30"},{"v":0.5454545454545454,"d":"54.55%"},{"v":83.3588888888889,"d":"83.36"},"无",{"v":60.3,"d":"60.30"},0,"无"]
[48,2018011962,{"v":106,"d":"106.00"},{"v":82.4096603773585,"d":"82.41"},{"v":43.9,"d":"43.90"},{"v":0.38461538461538464,"d":"38.46%"},{"v":83.27676226415095,"d":"83.28"},"无",{"v":43.9,"d":"43.90"},0,"无"]
[49,2018011957,{"v":111.5,"d":"111.50"},{"v":74.03503401360544,"d":"74.04"},{"v":54,"d":"54.00"},{"v":0.2727272727272727,"d":"27.27%"},{"v":79.52452380952381,"d":"79.52"},"无",{"v":54,"d":"54.00"},0,"无"]
[50,2018011941,{"v":82,"d":"82.00"},{"v":79.28497217068646,"d":"79.28"},{"v":70,"d":"70.00"},{"v":0.36363636363636365,"d":"36.36%"},{"v":78.89948051948052,"d":"78.90"},"无",{"v":70,"d":"70.00"},0,"有"]
[51,2018011969,{"v":95,"d":"95.00"},{"v":75.7904761904762,"d":"75.79"},{"v":60,"d":"60.00"},{"v":0.36363636363636365,"d":"36.36%"},{"v":78.05333333333334,"d":"78.05"},"无",{"v":60,"d":"60.00"},0,"无"]
[52,2018011956,{"v":97.5,"d":"97.50"},{"v":69.86530612244897,"d":"69.87"},{"v":74.4,"d":"74.40"},{"v":0.18181818181818182,"d":"18.18%"},{"v":75.84571428571428,"d":"75.85"},"无",{"v":74.4,"d":"74.40"},1,"无"]
[53,2018010030,{"v":95,"d":"95.00"},{"v":80.51217838765008,"d":"80.51"},{"v":0,"d":"0.00"},{"v":0.5,"d":"50.00%"},{"v":75.35852487135506,"d":"75.36"},"无",{"v":0,"d":"0.00"},0,"无"]
[54,2018011984,{"v":97,"d":"97.00"},{"v":62.4682261208577,"d":"62.47"},{"v":105,"d":"105.00"},{"v":0.16666666666666666,"d":"16.67%"},{"v":73.62775828460039,"d":"73.63"},"无",{"v":85,"d":"85.00"},3,"无"]
[55,2018011982,{"v":84,"d":"84.00"},{"v":68.59183673469389,"d":"68.59"},{"v":65.6,"d":"65.60"},{"v":0.36363636363636365,"d":"36.36%"},{"v":71.37428571428572,"d":"71.37"},"无",{"v":65.6,"d":"65.60"},1,"无"]