{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["全院","16材料","16应化","17材料","17应化","18材料","18应化"],"not_rendered":{"defined_names":1},"read":"part_unreadable","date_system":"1900"}

{"sheet":"全院","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"read":"part_unreadable"}

{"sheet":"16材料","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"read":"part_unreadable"}

{"sheet":"16应化","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"read":"part_unreadable"}

{"sheet":"17材料","index":3,"n_rows":58,"n_cols":21,"rows_kept":58}
["班级","学号","姓名","专业排名","综测排名","专业人数","比例","综测总分","必修与选修折算成绩之和","基本素质(辅导员)","基本素质(班主任)","实践与创新能力(辅导员)","实践与创新能力(班主任)","成果分","加分","减分","基本素质(学生)","基本素质","实践与创新能力(学生)","实践与创新能力","已获学分"]
["17材料物理2班","20171338050","仲秋雪",1,2,"57","3.51","93.66","54.48","12.00","9.00","2.00","1.50","5.00",null,null,"27.47","29.24","4.79","4.94"]
["17材料物理2班","20171338069","彭敬润",2,3,"57","5.26","93.46","54.24","12.00","9.00","2.00","1.50","5.00",null,null,"27.58","29.27","4.84","4.95"]
["17材料物理1班","20171338001","王亚丹",3,1,"57","1.75","94.16","53.77","12.00","9.00","2.00","1.50","5.00","0.50",null,"29.72","29.92","4.90","4.97"]
["17材料物理2班","20171338054","李子贤",4,11,"57","19.30","87.09","53.61","11.30","9.00","2.00","1.50",{"$nulls":3},"27.47","28.54","4.79","4.94"]
["17材料物理1班","20171338002","韦加雯",5,4,"57","7.02","93.22","52.91","12.00","9.00","2.00","1.50","5.00","0.50",null,"29.48","29.84","4.90","4.97"]
["17材料物理2班","20171338042","王彦",6,10,"57","17.54","87.14","52.58","12.00","9.00","2.00","1.50",null,"0.30",null,"27.74","29.32","4.79","4.94"]
["17材料物理1班","20171338016","李婕馨",7,5,"57","8.77","92.41","52.55","11.70","9.00","2.00","1.50","5.00","0.30",null,"29.67","29.60","4.88","4.96"]
["17材料物理2班","20171338038","于高远",8,7,"57","12.28","88.81","52.49","12.00","9.00","2.00","1.50","2.00",null,null,"27.89","29.37","4.84","4.95"]
["17材料物理2班","20171338047","龙群",9,16,"57","28.07","86.07","51.90","12.00","9.00","2.00","1.50",{"$nulls":3},"27.42","29.23","4.79","4.94"]
["17材料物理1班","20171338027","周昱帆",10,6,"57","10.53","89.60","51.35","12.00","9.00","2.00","1.50","3.00","0.40",null,"29.62","29.89","4.88","4.96"]
["17材料物理1班","20171338015","李振宇",11,17,"57","29.82","85.98","50.84","12.00","9.00","2.00","0.50","1.00","0.30",null,"29.60","29.88","4.88","3.96"]
["17材料物理2班","20171338040","王豪",12,13,"57","22.81","86.82","50.35","12.00","9.00","2.00","1.50","2.00","0.30",null,"27.42","29.23","4.79","4.94"]
["17材料物理1班","20171338017","宋子豪",13,23,"57","40.35","84.10","50.23","11.70","9.00","2.00","0.50",null,"0.30",null,"29.67","29.60","4.89","3.97"]
["17材料物理2班","20171338051","朱明璋",14,25,"57","43.86","84.00","50.06","11.70","9.00","2.00","1.50",{"$nulls":3},"27.63","28.99","4.84","4.95"]
["17材料物理2班","20171338062","倪瑞安",15,15,"57","26.32","86.17","49.93","12.00","9.00","2.00","1.50","2.00",null,null,"27.63","29.29","4.84","4.95"]
["17材料物理2班","20171338048","司锐",15,24,"57","42.11","84.09","49.93","12.00","9.00","2.00","1.50",{"$nulls":3},"27.40","29.22","4.80","4.94"]
["17材料物理1班","20171338024","张羽羽",17,8,"57","14.04","87.68","49.41","12.00","9.00","2.00","1.50","3.00","0.40",null,"29.65","29.90","4.89","4.97"]
["17材料物理1班","20171338011","陈铭源",18,14,"57","24.56","86.81","49.34","12.00","9.00","2.00","1.00","3.00","0.30",null,"29.02","29.71","4.85","4.46"]
["17材料物理2班","20171338071","覃龙偿",19,27,"57","47.37","83.07","49.22","11.70","9.00","2.00","1.50",{"$nulls":3},"27.35","28.91","4.80","4.94"]
["17材料物理2班","20171338068","董建辉",20,26,"57","45.61","83.30","49.15","12.00","9.00","2.00","1.50",{"$nulls":3},"27.37","29.21","4.79","4.94"]
["17材料物理2班","20171338053","李清华",21,22,"57","38.60","84.65","48.72","11.70","9.00","2.00","1.50","2.00",null,null,"27.63","28.99","4.79","4.94"]
["17材料物理1班","20171338006","任静",22,19,"57","33.33","85.53","48.67","11.50","9.00","2.00","0.50","3.00","0.50",null,"29.65","29.40","4.88","3.96"]
["17材料物理2班","20171338052","陈雨",23,29,"57","50.88","82.83","48.62","12.00","9.00","2.00","1.50",{"$nulls":3},"27.58","29.27","4.79","4.94"]
["17材料物理1班","20171338005","吕崇杉",24,9,"57","15.79","87.29","48.20","12.00","9.00","2.00","1.50","4.00","0.30",null,"29.43","29.83","4.87","4.96"]
["17材料物理2班","20171338061","姜伯儒",25,12,"57","21.05","86.90","47.81","12.00","9.00","2.00","1.50","5.00",null,null,"27.16","29.15","4.79","4.94"]
["17材料物理2班","20171338046","王澍霖",26,34,"57","59.65","81.51","47.64","11.70","9.00","2.00","1.50",{"$nulls":3},"27.42","28.93","4.79","4.94"]
["17材料物理2班","20171338041","王磊",27,21,"57","36.84","84.95","47.47","12.00","9.00","2.00","1.50","3.00","0.30",null,"27.47","29.24","4.79","4.94"]
["17材料物理1班","20171338025","单雨帆",28,33,"57","57.89","81.59","47.45","12.00","9.00","2.00","0.50",null,"0.30",null,"29.60","29.88","4.88","3.96"]
["17材料物理1班","20171338026","林立涛",28,35,"57","61.40","80.91","47.45","11.30","9.00","2.00","0.50",null,"0.30",null,"29.62","29.19","4.89","3.97"]
["17材料物理1班","20171338019","严良玮",30,32,"57","56.14","81.75","47.20","11.90","9.00","2.00","1.00",null,"0.30",null,"29.63","29.79","4.88","4.46"]
["17材料物理1班","20171338032","栾鸿康",31,28,"57","49.12","82.93","46.81","12.00","9.00","2.00","0.50","2.00","0.30",null,"29.60","29.88","4.80","3.94"]
["17材料物理2班","20171338070","彭招刚",32,20,"57","35.09","85.22","46.38","11.70","9.00","2.00","1.50","5.00",null,null,"27.32","28.90","4.79","4.94"]
["17材料物理1班","20171338010","闫莹洁",33,31,"57","54.39","81.90","46.34","12.00","9.00","2.00","0.50","1.00","0.80",null,"29.30","29.79","4.90","3.97"]
["17材料物理2班","20171338060","周翔",34,18,"57","31.58","85.59","46.13","12.00","9.00","2.00","1.50","5.00","0.30",null,"27.37","29.21","4.84","4.95"]
["17材料物理1班","20171338003","刘海清",35,30,"57","52.63","82.04","45.18","11.70","9.00","2.00","1.50","2.00","0.30",null,"29.64","29.59","4.89","4.97"]
["17材料物理1班","20171338004","刘新刚",36,38,"57","66.67","79.44","44.56","11.70","9.00","2.00","1.50",null,"0.30",null,"29.70","29.61","4.90","4.97"]
["17材料物理2班","20171338045","王奕骁",37,40,"57","70.18","78.33","44.18","12.00","9.00","2.00","1.50",{"$nulls":3},"27.35","29.21","4.80","4.94"]
["17材料物理1班","20171338064","夏昊",38,55,"57","96.49","54.39","43.97",{"$nulls":7},"29.79","8.94","4.92","1.48"]
["17材料物理1班","20171338031","耿尚",39,36,"57","63.16","80.66","43.79","12.00","9.00","2.00","1.50","2.00",null,null,"29.67","29.90","4.90","4.97"]
["17材料物理1班","20171338012","陈一锋",40,37,"57","64.91","80.62","43.42","12.00","9.00","2.00","1.50","2.00","0.30",null,"29.75","29.93","4.90","4.97"]
["17材料物理1班","20171338023","张屹琳",41,41,"57","71.93","76.59","42.92","11.30","9.00","2.00","0.50",null,"0.40",null,"29.90","29.27","4.99","4.00"]
["17材料物理2班","20171338066","袁洪波",42,42,"57","73.68","76.56","42.35","12.00","9.00","2.00","1.50",{"$nulls":3},"27.53","29.26","4.84","4.95"]
["17材料物理1班","20171338008","许超",43,39,"57","68.42","79.31","42.22","12.00","9.00","2.00","1.50","2.00","0.30",null,"29.44","29.83","4.88","4.96"]
["17材料物理2班","20171338055","沈俊堯",44,43,"57","75.44","75.96","41.95","12.00","8.50","2.00","1.50",null,"0.30",null,"27.55","28.77","4.80","4.94"]
["17材料物理2班","20171338067","黄文诗",44,44,"57","77.19","75.63","41.95","12.00","8.50","2.00","1.50",{"$nulls":3},"27.45","28.74","4.80","4.94"]
["17材料物理2班","20171338065","徐雪晴",46,45,"57","78.95","74.95","41.60","11.70","8.50","2.00","1.50",{"$nulls":3},"27.30","28.39","4.85","4.96"]
["17材料物理1班","20171338021","张仁超",47,47,"57","82.46","74.11","40.69","11.30","9.00","2.00","0.50",null,"0.30",null,"29.51","29.15","4.89","3.97"]
["17材料物理1班","20171338030","赵常江",48,46,"57","80.70","74.17","40.34","12.00","9.00","2.00","0.50",{"$nulls":3},"29.53","29.86","4.89","3.97"]
["17材料物理1班","20171338029","南名展",49,48,"57","84.21","73.85","40.05","12.00","9.00","2.00","0.50",{"$nulls":3},"29.47","29.84","4.88","3.96"]
["17材料物理2班","20171338057","杨九龄",50,50,"57","87.72","73.13","39.69","12.00","8.00","2.00","1.50",null,"0.30",null,"27.32","28.20","4.79","4.94"]
["17材料物理2班","20171338063","唐小艳",51,52,"57","91.23","72.88","39.25","12.00","8.50","2.00","1.50",{"$nulls":3},"27.26","28.68","4.84","4.95"]
["17材料物理1班","20171338020","杨晓麟",52,49,"57","85.96","73.67","39.22","11.30","9.00","2.00","1.50",null,"0.30",null,"29.60","29.18","4.89","4.97"]
["17材料物理2班","20171338043","王立伟",53,51,"57","89.47","73.07","39.11","11.50","9.00","2.00","1.50",null,"0.30",null,"27.40","28.72","4.80","4.94"]
["17材料物理1班","20171338035","潘旭辉",54,53,"57","92.98","71.88","38.06","11.70","9.00","2.00","0.50",null,"0.30",null,"29.49","29.55","4.90","3.97"]
["17材料物理2班","20171338037","马威克",55,54,"57","94.74","70.38","36.70","12.00","8.50","2.00","1.50",{"$nulls":3},"27.45","28.74","4.80","4.94"]
["17材料物理2班","20171338059","张鋆涵",56,56,"57","98.25","47.48","15.02","11.00","8.00","2.00","1.50",null,"0.30",null,"27.40","27.22","4.80","4.94"]
["17材料物理2班","20171338049","任伟",57,57,"57","100.00","34.19",null,"12.00","9.00","2.00","1.50",{"$nulls":3},"27.50","29.25","4.80","4.94"]

{"sheet":"17应化","index":4,"n_rows":50,"n_cols":21,"rows_kept":50}
["班级","学号","姓名","专业排名","综测排名","专业人数","比例","综测总分","必修与选修折算成绩之和","基本素质(辅导员)","基本素质(班主任)","实践与创新能力(辅导员)","实践与创新能力(班主任)","成果分","加分","减分","基本素质(学生)","基本素质","实践与创新能力(学生)","实践与创新能力","已获学分"]
["17应化1班","20171337013","李宏宇",1,1,"49","2.04","92.83","53.51","11.90","9.00","2.00","1.50","5.00",null,null,"28.11","29.33","4.95","4.99"]
["17应化2班","20171337044","刘遨",2,8,"49","16.33","89.19","52.68","12.00","9.00","2.00","1.45","2.00",null,null,"28.59","29.58","4.93","4.93"]
["17应化1班","20171337025","胡欣",3,3,"49","6.12","91.89","52.04","12.00","9.00","2.00","1.50","5.00","0.40",null,"28.21","29.46","4.95","4.99"]
["17应化2班","20171337043","刘琳",4,2,"49","4.08","92.00","51.98","12.00","9.00","2.00","1.50","5.00","0.50",null,"28.48","29.54","4.93","4.98"]
["17应化1班","20171337029","徐志薇",5,4,"49","8.16","91.81","51.97","12.00","9.00","2.00","1.50","5.00","0.40",null,"28.16","29.45","4.95","4.99"]
["17应化2班","20171337065","高皖玉",6,11,"49","22.45","88.09","51.17","12.00","9.00","2.00","1.40","2.50",null,null,"28.48","29.54","4.93","4.88"]
["17应化2班","20171337055","李一然",7,15,"49","30.61","85.66","51.14","12.00","9.00","2.00","1.45",{"$nulls":3},"28.63","29.59","4.93","4.93"]
["17应化1班","20171337014","李语林",8,6,"49","12.24","90.08","50.66","12.00","9.00","2.00","1.50","5.00",null,null,"28.11","29.43","4.95","4.99"]
["17应化2班","20171337051","李斌",9,10,"49","20.41","88.36","50.64","11.70","9.00","2.00","1.45","3.50",null,null,"28.63","29.29","4.93","4.93"]
["17应化2班","20171337056","吴旭东",10,9,"49","18.37","89.11","50.61","12.00","8.90","2.00","1.50","4.00",null,null,"28.70","29.51","4.96","4.99"]
["17应化1班","20171337011","陈泽林",11,5,"49","10.20","91.09","50.38","12.00","9.00","2.00","1.50","5.00","1.50",null,"27.53","29.26","4.84","4.95"]
["17应化2班","20171337066","徐子康",12,20,"49","40.82","84.22","50.15","11.70","9.00","2.00","1.35",{"$nulls":3},"28.48","29.24","4.93","4.83"]
["17应化2班","20171337038","王静漪",13,7,"49","14.29","89.87","50.11","12.00","8.80","2.00","1.50","5.00","0.50",null,"28.26","29.28","4.93","4.98"]
["17应化2班","20171337040","王宇翔",14,13,"49","26.53","86.64","50.08","11.70","8.80","2.00","1.50","2.50",null,null,"28.59","29.08","4.93","4.98"]
["17应化2班","20171337050","杜晓玉",15,12,"49","24.49","87.26","49.93","11.80","9.00","2.00","1.50","3.00",null,null,"28.48","29.34","4.96","4.99"]
["17应化2班","20171337054","李叔宝",16,14,"49","28.57","85.84","49.45","11.70","8.80","2.00","1.40","2.50","0.40",null,"27.22","28.67","4.74","4.82"]
["17应化1班","20171337005","龙娇娇",17,22,"49","44.90","84.05","49.36","12.00","7.50","2.00","1.25","2.00",null,null,"28.16","27.95","4.95","4.74"]
["17应化2班","20171337045","刘芳妤",18,19,"49","38.78","84.71","49.15","11.30","8.80","2.00","1.50","3.50","0.50","2.00","28.26","28.58","4.93","4.98"]
["17应化2班","20171337070","蔡株仟",19,23,"49","46.94","83.13","48.96","12.00","8.80","2.00","1.35",{"$nulls":3},"28.48","29.34","4.93","4.83"]
["17应化1班","20171337033","傅依航",20,25,"49","51.02","82.55","48.58","11.30","7.50","2.00","1.25","2.00",null,null,"28.11","27.23","4.95","4.74"]
["17应化1班","20171337006","丘容美",21,17,"49","34.69","85.24","48.55","12.00","7.50","2.00","1.25","4.00",null,null,"28.16","27.95","4.95","4.74"]
["17应化1班","20171337020","张琳浩",22,16,"49","32.65","85.37","47.81","12.00","8.50","2.00","1.42","4.00",null,null,"27.32","28.70","4.79","4.86"]
["17应化2班","20171337047","阮超",23,28,"49","57.14","81.41","47.50","11.70","8.90","2.00","1.35",{"$nulls":3},"28.26","29.08","4.93","4.83"]
["17应化1班","20171337002","王晨苏",24,33,"49","67.35","79.79","47.48","11.30","7.80","2.00","1.30",{"$nulls":3},"28.05","27.52","4.95","4.79"]
["17应化2班","20171337049","陈洪果",25,21,"49","42.86","84.18","47.42","11.70","8.90","2.00","1.40","2.50","0.30",null,"28.26","29.08","4.93","4.88"]
["17应化2班","20171337064","赵子奇",26,30,"49","61.22","81.16","47.12","11.70","8.80","2.00","1.40",{"$nulls":3},"28.85","29.16","4.93","4.88"]
["17应化2班","20171337052","李波",27,32,"49","65.31","80.48","46.98","11.30","8.80","2.00","1.35",{"$nulls":3},"28.59","28.68","4.89","4.82"]
["17应化1班","20171337017","杨金山",28,31,"49","63.27","80.88","46.48","11.30","7.80","2.00","1.30","2.00",null,null,"28.32","27.60","5.00","4.80"]
["17应化1班","20171337012","陈玮伊",29,27,"49","55.10","81.45","46.43","12.00","7.80","2.00","1.30","2.00",null,null,"28.11","28.23","4.95","4.79"]
["17应化1班","20171337008","孙嘉希",30,35,"49","71.43","79.35","46.33","12.00","7.80","2.00","1.30",{"$nulls":3},"28.11","28.23","4.95","4.79"]
["17应化1班","20171337009","陈佳乐",31,36,"49","73.47","79.24","45.94","12.00","8.00","2.00","1.33",{"$nulls":3},"28.26","28.48","4.95","4.82"]
["17应化2班","20171337062","岳江涛",32,34,"49","69.39","79.67","45.48","12.00","8.80","2.00","1.35",{"$nulls":3},"28.52","29.36","4.93","4.83"]
["17应化2班","20171337042","刘欢",33,37,"49","75.51","79.15","45.35","11.70","8.80","2.00","1.35",{"$nulls":3},"28.26","28.98","4.89","4.82"]
["17应化1班","20171337022","范奔",34,39,"49","79.59","78.29","45.32","11.40","8.00","2.00","1.33","2.00","0.40","2.00","27.84","27.75","4.95","4.82"]
["17应化2班","20171337039","王雅仪",35,18,"49","36.73","84.88","45.15","12.00","8.80","2.00","1.50","5.00","0.50",null,"28.15","29.25","4.93","4.98"]
["17应化1班","20171337028","涂天成",36,24,"49","48.98","82.87","44.83","11.30","9.00","2.00","1.50","4.00","0.40",null,"27.84","28.65","4.95","4.99"]
["17应化2班","20171337037","王懿",37,26,"49","53.06","81.64","44.26","11.70","8.80","2.00","1.40","3.50",null,null,"28.33","29.00","4.93","4.88"]
["17应化2班","20171337057","杨倩",38,29,"49","59.18","81.31","44.23","11.50","8.80","2.00","1.35","3.50",null,null,"28.15","28.75","4.93","4.83"]
["17应化2班","20171337058","张睿",39,42,"49","85.71","76.91","44.09","11.40","8.80","2.00","1.40",{"$nulls":3},"26.15","28.05","4.56","4.77"]
["17应化2班","20171337048","向颖",40,40,"49","81.63","77.60","43.71","11.70","8.80","2.00","1.35",{"$nulls":3},"28.56","29.07","4.89","4.82"]
["17应化2班","20171337063","周文相如",41,41,"49","83.67","77.37","43.28","12.00","8.70","2.00","1.35",{"$nulls":3},"28.56","29.27","4.89","4.82"]
["17应化1班","20171337031","殷若洋",42,43,"49","87.76","76.85","42.61","11.30","7.50","2.00","1.25","2.00","0.40",null,"27.68","27.10","4.95","4.74"]
["17应化2班","20171337060","张诗琦",43,38,"49","77.55","78.38","42.49","11.70","8.80","2.00","1.40","2.00",null,null,"28.35","29.01","4.92","4.88"]
["17应化1班","20171337010","陈佳美",44,49,"49","100.00","70.95","42.38","11.90","7.20","2.00","1.20",null,null,"3.50","27.70","27.41","4.85","4.66"]
["17应化1班","20171337004","韦继源",45,44,"49","89.80","75.85","41.89","11.30","7.50","2.00","1.25","2.00",null,null,"28.05","27.22","4.95","4.74"]
["17应化2班","20171337036","万伟",46,45,"49","91.84","75.19","41.85","11.30","8.70","2.00","1.35",{"$nulls":3},"28.41","28.52","4.89","4.82"]
["17应化1班","20171337018","张岩",47,46,"49","93.88","75.02","41.60","11.30","7.20","2.00","1.20","2.00",null,null,"27.42","26.73","4.95","4.69"]
["17应化2班","20171337059","张丽玮",48,47,"49","95.92","73.92","40.13","11.70","8.70","2.00","1.40",{"$nulls":3},"28.38","28.91","4.92","4.88"]
["17应化1班","20171337034","谢正宇",49,48,"49","97.96","70.98","39.12","11.30","7.50","2.00","1.25",{"$nulls":3},"27.74","27.12","4.95","4.74"]

{"sheet":"18材料","index":5,"n_rows":47,"n_cols":21,"rows_kept":47}
["班级","学号","姓名","专业排名","综测排名","专业人数","比例","综测总分","必修与选修折算成绩之和","基本素质(辅导员)","基本素质(班主任)","实践与创新能力(辅导员)","实践与创新能力(班主任)","成果分","加分","减分","基本素质(学生)","基本素质","实践与创新能力(学生)","实践与创新能力","已获学分"]
["18材料物理1班","201813380017","陈子琛",1,2,"46","4.35","89.77","52.00","11.70","8.60","2.00","1.40","3.00","0.80",null,"29.34","29.10","4.91","4.87"]
["18材料物理1班","201813380013","孙培杰",2,1,"46","2.17","89.87","51.71","12.00","8.60","2.00","1.40","3.00","0.80",null,"29.59","29.48","4.93","4.88"]
["18材料物理1班","201813380025","张宇豪",3,3,"46","6.52","89.39","51.29","12.00","8.60","2.00","1.40","3.00","0.80",null,"29.39","29.42","4.93","4.88"]
["18材料物理1班","201813380028","林纪栋",4,4,"46","8.70","89.18","51.09","12.00","8.60","2.00","1.40","3.00","0.80",null,"29.41","29.42","4.91","4.87"]
["18材料物理1班","201813380041","董雅凤",5,11,"46","23.91","86.18","50.35","11.70","8.60","2.00","1.40","1.00","0.80",null,"29.50","29.15","4.93","4.88"]
["18材料物理1班","201813380010","刘铭烁",6,12,"46","26.09","85.92","50.12","11.70","8.60","2.00","1.40","1.00","0.80",null,"29.45","29.14","4.86","4.86"]
["18材料物理1班","201813380023","张书博",7,6,"46","13.04","87.89","50.00","11.70","8.60","2.00","1.40","3.00","0.90",null,"29.41","29.12","4.91","4.87"]
["18材料物理1班","201813380024","张译文",8,7,"46","15.22","87.38","49.59","11.70","8.60","2.00","1.40","3.00","0.90",null,"29.07","29.02","4.91","4.87"]
["18材料物理1班","201813380045","蔡熙明",9,9,"46","19.57","86.66","49.51","12.00","8.60","2.00","1.40","2.00","0.80",null,"29.55","29.47","4.93","4.88"]
["18材料物理1班","201813380020","宋仁杰",10,5,"46","10.87","88.11","49.22","11.70","8.60","2.00","1.40","4.00","0.90",null,"29.36","29.11","4.93","4.88"]
["18材料物理1班","201813380027","范栋梁",11,17,"46","36.96","84.58","48.91","11.50","8.60","2.00","1.40","1.00","0.80",null,"29.64","28.99","4.93","4.88"]
["18材料物理1班","201813380018","李辰",12,8,"46","17.39","87.33","48.79","11.30","8.60","2.00","1.40","4.00","0.90",null,"29.57","28.77","4.91","4.87"]
["18材料物理1班","201813380021","张祎",13,16,"46","34.78","84.86","47.96","11.70","8.60","2.00","1.40","2.00","0.90",null,"29.43","29.13","4.91","4.87"]
["18材料物理1班","201813380042","谢颖",14,10,"46","21.74","86.35","47.50","11.70","8.60","2.00","1.40","4.00","0.80",null,"29.55","29.17","4.93","4.88"]
["18材料物理1班","201813380016","陈诗宇",15,15,"46","32.61","84.94","47.20","12.00","8.60","2.00","1.40","2.00","1.40",null,"29.52","29.46","4.93","4.88"]
["18材料物理1班","201813380033","赵志洋",16,18,"46","39.13","84.49","46.97","11.30","8.60","2.00","1.40","3.00","0.90",null,"29.48","28.74","4.93","4.88"]
["18材料物理1班","201813380002","于乐逸",17,13,"46","28.26","85.01","46.63","12.00","8.60","2.00","1.40","3.00","1.00",null,"29.66","29.50","4.93","4.88"]
["18材料物理1班","201813380006","冯星斐",17,21,"46","45.65","83.63","46.63","11.70","8.60","2.00","1.40","2.00","0.90",null,"29.70","29.21","4.95","4.89"]
["18材料物理1班","201813380037","符号",19,23,"46","50.00","83.13","46.10","12.00","8.60","2.00","1.40","1.00","1.80",null,"29.16","29.35","4.93","4.88"]
["18材料物理1班","201813380032","姚明智",20,24,"46","52.17","82.66","45.74","11.70","8.60","2.00","1.40","2.00","0.90",null,"29.48","29.14","4.93","4.88"]
["18材料物理1班","201813380008","左佳一",21,22,"46","47.83","83.44","45.48","11.70","8.60","2.00","1.40","3.00","0.90",null,"29.61","29.18","4.93","4.88"]
["18材料物理1班","201813380040","梁世芃",22,14,"46","30.43","84.98","45.33","12.00","8.60","2.00","1.40","4.00","1.30",null,"29.55","29.47","4.93","4.88"]
["18材料物理1班","201813380039","康博",23,20,"46","43.48","83.72","45.07","12.00","8.60","2.00","1.40","3.00","1.30",null,"29.55","29.47","4.93","4.88"]
["18材料物理1班","201813380047","潘随",24,31,"46","67.39","80.81","44.96","11.70","8.60","2.00","1.40","1.00","0.80",null,"29.57","29.17","4.93","4.88"]
["18材料物理1班","201813380044","谢忠俊",25,30,"46","65.22","81.42","44.87","11.40","8.60","2.00","1.40","2.00","0.80",null,"29.57","28.87","4.93","4.88"]
["18材料物理1班","201813380019","李林珂",26,19,"46","41.30","83.87","44.78","12.00","8.60","2.00","1.40","3.00","1.90",null,"29.07","29.32","4.91","4.87"]
["18材料物理1班","201813380026","张浙锐",27,25,"46","54.35","82.52","44.57","11.40","8.60","2.00","1.40","3.00","1.30",null,"29.27","28.78","4.89","4.87"]
["18材料物理1班","201813380022","张菲凡",28,26,"46","56.52","82.05","44.36","12.00","8.60","2.00","1.40","2.00","1.40",null,"29.39","29.42","4.91","4.87"]
["18材料物理1班","201813380004","王新龙",29,27,"46","58.70","81.92","44.35","11.70","8.60","2.00","1.40","3.00","0.50",null,"29.64","29.19","4.93","4.88"]
["18材料物理1班","201813380036","徐泽龙",30,32,"46","69.57","80.77","44.29","11.30","8.60","2.00","1.40","2.00","0.90",null,"29.34","28.70","4.93","4.88"]
["18材料物理1班","201813380001","于皓",31,28,"46","60.87","81.85","44.27","11.70","8.60","2.00","1.40","3.00","0.50",null,"29.66","29.20","4.93","4.88"]
["18材料物理1班","201813380007","龙昌万",32,36,"46","78.26","79.88","43.88","11.70","8.60","2.00","1.40","1.00","0.90",null,"29.70","29.21","4.95","4.89"]
["18材料物理1班","201813380046","慎浩",33,33,"46","71.74","80.34","43.80","11.40","8.60","2.00","1.40","2.00","0.80",null,"29.52","28.86","4.93","4.88"]
["18材料物理1班","201813380034","郭力群",34,29,"46","63.04","81.76","43.74","12.00","8.60","2.00","1.40","2.00","1.80",null,"29.14","29.34","4.93","4.88"]
["18材料物理1班","201813380012","孙国民",35,34,"46","73.91","80.15","43.30","11.70","8.60","2.00","1.40","2.00","0.80",null,"29.57","29.17","4.93","4.88"]
["18材料物理1班","201813380015","朱玉梅",36,35,"46","76.09","80.00","42.53","11.30","8.60","2.00","1.40","3.00","0.80",null,"29.64","28.79","4.93","4.88"]
["18材料物理1班","201813380009","成敏",37,41,"46","89.13","77.52","41.72","11.70","8.60","2.00","1.40","1.00","0.80",null,"29.43","29.13","4.91","4.87"]
["18材料物理1班","201813380043","谢泽毅",38,38,"46","82.61","78.25","41.70","11.40","8.60","2.00","1.40","2.00","0.80",null,"29.55","28.87","4.93","4.88"]
["18材料物理1班","201813380035","夏雨萱",39,37,"46","80.43","79.82","41.30","12.00","8.60","2.00","1.40","3.00","1.30",null,"29.18","29.35","4.91","4.87"]
["18材料物理1班","201813380030","胡睿霖",40,42,"46","91.30","77.40","40.85","11.70","8.60","2.00","1.40","2.00","0.50",null,"29.56","29.17","4.93","4.88"]
["18材料物理1班","201813380005","王宇鑫",41,40,"46","86.96","77.96","40.64","12.00","8.60","2.00","1.40","2.00","0.90",null,"29.77","29.53","4.95","4.89"]
["18材料物理1班","201813380014","向成燕",42,39,"46","84.78","78.21","40.33","11.70","8.60","2.00","1.40","3.00","0.80",null,"29.66","29.20","4.93","4.88"]
["18材料物理1班","201813380029","周雨霏",43,43,"46","93.48","76.47","40.07","11.30","8.60","2.00","1.40","2.00","0.80",null,"29.39","28.72","4.93","4.88"]
["18材料物理1班","201813380003","孔小龙",44,44,"46","95.65","74.64","38.78","12.00","8.60","2.00","1.40","1.00","0.50",null,"29.61","29.48","4.93","4.88"]
["18材料物理1班","201813380011","刘星宇",45,45,"46","97.83","74.56","38.77","11.70","8.60","2.00","1.40","1.00","0.80",null,"29.36","29.11","4.93","4.88"]
["18材料物理1班","201813380038","黄艺如",46,46,"46","100.00","74.07","38.75","11.50","8.60","2.00","1.40","1.00","0.50",null,"29.48","28.94","4.93","4.88"]

{"sheet":"18应化","index":6,"n_rows":45,"n_cols":21,"rows_kept":45}
["班级","学号","姓名","专业排名","综测排名","专业人数","比例","综测总分","必修与选修折算成绩之和","基本素质(辅导员)","基本素质(班主任)","实践与创新能力(辅导员)","实践与创新能力(班主任)","成果分","加分","减分","基本素质(学生)","基本素质","实践与创新能力(学生)","实践与创新能力","已获学分"]
["18应化1班","201813370035","徐泽瑞",1,2,"45","4.44","94.18","54.82","11.50","9.00","2.00","1.50","4.95","0.40",null,"28.42","29.03","4.92","4.98"]
["18应化1班","201813370040","熊翔晨",2,1,"45","2.22","94.76","54.66","12.00","9.00","2.00","1.50","5.00","0.50",null,"28.74","29.62","4.94","4.98"]
["18应化1班","201813370012","李欣烨",3,4,"45","8.89","92.38","53.59","12.00","9.00","2.00","1.50","3.91","0.50",null,"28.01","29.40","4.92","4.98"]
["18应化1班","201813370036","黄宝磊",4,3,"45","6.67","93.49","53.55","12.00","9.00","2.00","1.50","5.00","0.40",null,"28.54","29.56","4.94","4.98"]
["18应化1班","201813370021","张辰孛",5,9,"45","20.00","86.93","52.39","11.50","8.00","2.00","1.40","1.64",null,null,"28.46","28.04","4.85","4.86"]
["18应化1班","201813370002","王玮",6,17,"45","37.78","83.73","52.20","11.40","7.00","2.00","1.20",null,"0.09",null,"27.85","26.76","4.92","4.68"]
["18应化1班","201813370023","张丽娇",7,5,"45","11.11","90.39","51.86","12.00","9.00","2.00","1.50","3.59","0.40",null,"28.54","29.56","4.94","4.98"]
["18应化1班","201813370015","李志豪",8,6,"45","13.33","90.01","51.38","11.70","9.00","2.00","1.40","4.18","0.50",null,"27.92","29.08","4.90","4.87"]
["18应化1班","201813370007","孙昊",9,8,"45","17.78","88.89","51.10","11.70","9.00","2.00","1.50","4.00",null,"0.20","27.78","29.03","4.85","4.96"]
["18应化1班","201813370020","杨修悦",10,7,"45","15.56","88.90","50.94","11.70","9.00","2.00","1.50","3.41","0.40",null,"28.30","29.19","4.85","4.96"]
["18应化1班","201813370025","林楷峰",11,13,"45","28.89","84.42","50.09","11.70","8.00","2.00","1.40","1.27",null,null,"28.31","28.19","4.90","4.87"]
["18应化1班","201813370026","罗潇",12,12,"45","26.67","84.64","49.79","11.30","9.00","2.00","1.50","1.09",null,null,"28.32","28.80","4.88","4.96"]
["18应化1班","201813370032","钱海涛",13,10,"45","22.22","86.69","49.24","11.50","9.00","2.00","1.50","3.00","0.50",null,"28.28","28.98","4.89","4.97"]
["18应化1班","201813370009","冷胜男",14,11,"45","24.44","85.96","48.76","12.00","9.00","2.00","1.50","2.27","0.50",null,"28.15","29.45","4.94","4.98"]
["18应化1班","201813370027","孟玉",15,16,"45","35.56","83.89","48.25","12.00","9.00","2.00","1.50","1.14",null,null,"28.43","29.53","4.90","4.97"]
["18应化1班","201813370030","侯宇佳",16,18,"45","40.00","82.05","48.10","11.50","9.00","2.00","1.50",{"$nulls":3},"28.28","28.98","4.91","4.97"]
["18应化1班","201813370019","杨佳瑛",17,14,"45","31.11","84.29","47.81","11.70","9.00","2.00","1.50","1.86","0.40",null,"28.49","29.25","4.91","4.97"]
["18应化1班","201813370028","周彬",18,20,"45","44.44","81.70","47.73","12.00","8.00","2.00","1.50","0.09","0.50",null,"28.07","28.42","4.85","4.96"]
["18应化1班","201813370024","张子煜",19,21,"45","46.67","81.05","46.91","11.30","9.00","2.00","1.50","0.36",null,null,"28.40","28.82","4.88","4.96"]
["18应化1班","201813370014","李洋铭",20,15,"45","33.33","83.90","46.82","11.70","9.00","2.00","1.50","2.55","0.50",null,"27.85","29.06","4.90","4.97"]
["18应化1班","201813370037","黄颐暄",21,19,"45","42.22","81.91","46.24","12.00","6.00","2.00","1.10","4.00","0.50",null,"28.61","26.58","4.95","4.59"]
["18应化1班","201813370005","刘彦陟",22,26,"45","57.78","79.93","45.80","11.70","9.00","2.00","1.50",null,"0.09",null,"27.87","29.06","4.93","4.98"]
["18应化1班","201813370039","雷蕾",23,25,"45","55.56","79.98","45.74","11.70","9.00","2.00","1.50","0.09",null,null,"28.25","29.18","4.89","4.97"]
["18应化1班","20171337019","张俊涛",24,23,"45","51.11","80.73","45.73","12.00","8.00","2.00","1.20","1.45","0.50",null,"27.91","28.37","4.94","4.68"]
["18应化1班","201813370010","李澳",25,32,"45","71.11","77.10","45.49","12.00","7.00","2.00","1.10",null,null,"0.20","27.48","27.24","4.89","4.57"]
["18应化1班","201813370031","高鑫宇",26,22,"45","48.89","81.02","44.86","11.50","9.00","2.00","1.50","1.68","0.50",null,"28.39","29.02","4.88","4.96"]
["18应化1班","201813370006","刘玉玺",27,28,"45","62.22","79.14","44.74","12.00","9.00","2.00","1.50",null,"0.09",null,"27.79","29.34","4.89","4.97"]
["18应化1班","201813370001","王帅",28,30,"45","66.67","77.78","44.54","11.70","7.00","2.00","1.20","1.00","0.50",null,"27.85","27.06","4.92","4.68"]
["18应化1班","201813370029","贺逸龙",29,27,"45","60.00","79.87","44.16","11.70","9.00","2.00","1.50","1.00","0.50",null,"28.45","29.24","4.91","4.97"]
["18应化1班","201813370033","唐铭灿",30,36,"45","80.00","76.31","43.96","12.00","7.00","2.00","1.20",null,"0.15",null,"28.43","27.53","4.91","4.67"]
["18应化1班","201813370008","陈炜中",31,37,"45","82.22","76.16","43.60","11.70","8.00","2.00","1.30",null,null,"0.20","27.62","27.99","4.91","4.77"]
["18应化1班","201813370017","杨芹",32,39,"45","86.67","75.38","43.49","11.60","7.00","2.00","1.20",null,"0.11",null,"28.34","27.10","4.93","4.68"]
["18应化1班","201813370004","王廷雪",33,24,"45","53.33","80.16","42.08","11.70","9.00","2.00","1.50","3.55","0.50",null,"27.85","29.06","4.91","4.97"]
["18应化1班","201813370022","张宏喆",34,38,"45","84.44","75.97","41.97","11.70","9.00","2.00","1.40",{"$nulls":3},"28.16","29.15","4.83","4.85"]
["18应化1班","201813370038","彭睿骁",35,31,"45","68.89","77.66","41.72","12.00","9.00","2.00","1.50","0.91","0.50",null,"28.58","29.57","4.88","4.96"]
["18应化1班","201813370013","李亚龙",36,33,"45","73.33","76.91","41.29","11.70","9.00","2.00","1.40","1.23","0.50",null,"27.77","29.03","4.88","4.86"]
["18应化1班","201813370003","王发萍",37,34,"45","75.56","76.88","41.16","12.00","9.00","2.00","1.30","1.41","0.14",null,"27.96","29.39","4.93","4.78"]
["18应化1班","201813370016","杨超",38,29,"45","64.44","77.85","41.06","11.60","9.00","2.00","1.50","2.32","0.50",null,"27.98","28.99","4.93","4.98"]
["18应化1班","201813370018","杨铮",39,40,"45","88.89","74.96","40.69","11.70","9.00","2.00","1.50",{"$nulls":3},"28.62","29.29","4.93","4.98"]
["18应化1班","201813370011","李东泽",40,35,"45","77.78","76.33","40.10","12.00","8.00","2.00","1.50","3.09",null,"0.20","27.85","28.36","4.94","4.98"]
["18应化1班","201813370034","夏方丽",41,41,"45","91.11","72.49","38.99","12.00","8.00","2.00","1.50","0.09",null,null,"28.11","28.43","4.93","4.98"]
["18应化1班","20171337067","韩林",42,42,"45","93.33","69.31","35.39","11.50","9.00","2.00","1.50",null,"0.18","0.02","27.64","28.79","4.91","4.97"]
["18应化1班","20171337015","吴明新",43,43,"45","95.56","66.26","34.18","11.30","8.00","2.00","1.20",{"$nulls":3},"27.16","27.45","4.75","4.63"]
["18应化1班","20171337003","王雨辰",44,44,"45","97.78","39.37","8.50","11.30","7.00","2.00","1.20",null,null,"0.15","27.00","26.40","4.73","4.62"]