{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["2016级生物技术（滨）2016-2017-1转专业成绩排名"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"2016级生物技术（滨）2016-2017-1转专业成绩排名","index":0,"n_rows":65,"n_cols":23,"rows_kept":65,"flags":["formulas_cached_only"]}
["学号","姓名","体育Ⅰ [1]","形势与政策A [.3]","无机化学B [3]","学分","绩点","大学英语Ⅰ(B) [4]","学分","绩点","信息技术应用导论 [2]","学分","绩点","思想道德修养与法律基础 [3]","学分","绩点","中国近代史纲要 [2]","学分","绩点","总学分","总学分绩点","加权平均绩点","成绩排名"]
["201623201702012","上官文兵",70,"合格",92,3,4.2,84,4,3.4,96,2,4.6,89,3,3.9,89,2,3.9,14,{"v":54.900000000000006,"d":"54.90"},{"v":3.9214285714285717,"d":"3.92"},1]
["201623201702018","徐楠",94,"合格",89,3,3.9,85,4,3.5,90,2,{"v":4,"d":"4.0"},88,3,3.8,88,2,3.8,14,{"v":52.7,"d":"52.70"},{"v":3.7642857142857147,"d":"3.76"},2]
["201623201702028","王一方",81,"合格",82,3,3.2,82,4,3.2,89,2,3.9,91,3,4.1,87,2,3.7,14,{"v":49.9,"d":"49.90"},{"v":3.564285714285714,"d":"3.56"},3]
["201623201701005","葛佳敏",75,"合格",84,3,3.4,90,4,{"v":4,"d":"4.0"},82,2,3.2,85,3,3.5,81,2,3.1,14,{"v":49.300000000000004,"d":"49.30"},{"v":3.521428571428572,"d":"3.52"},4]
["201623201701009","江琮",88,"合格",87,3,3.7,76,4,2.6,87,2,3.7,92,3,4.2,82,2,3.2,14,{"v":47.9,"d":"47.90"},{"v":3.4214285714285713,"d":"3.42"},5]
["201623201702014","何雨鑫",74,"合格",82,3,3.2,79,4,2.9,91,2,4.1,85,3,3.5,86,2,3.6,14,{"v":47.10000000000001,"d":"47.10"},{"v":3.3642857142857148,"d":"3.36"},6]
["201623201701012","周佐霖",79,"合格",83,3,3.3,88,4,3.8,84,2,3.4,77,3,2.7,83,2,3.3,14,{"v":46.6,"d":"46.60"},{"v":3.3285714285714287,"d":"3.33"},7]
["201623201702024","高雪甜",71,"合格",78,3,2.8,83,4,3.3,78,2,2.8,89,3,3.9,87,2,3.7,14,{"v":46.29999999999999,"d":"46.30"},{"v":3.3071428571428565,"d":"3.31"},8]
["201623201701002","史方颖",79,"合格",72,3,2.2,77,4,2.7,87,2,3.7,92,3,4.2,91,2,4.1,14,{"v":45.60000000000001,"d":"45.60"},{"v":3.2571428571428576,"d":"3.26"},9]
["201623201701004","陈佩杰",76,"合格",78,3,2.8,80,4,{"v":3,"d":"3.0"},92,2,4.2,86,3,3.6,80,2,{"v":3,"d":"3.0"},14,{"v":45.599999999999994,"d":"45.60"},{"v":3.2571428571428567,"d":"3.26"},10]
["201623201702022","王勋",64,"合格",75,3,2.5,79,4,2.9,91,2,4.1,86,3,3.6,85,2,3.5,14,{"v":45.1,"d":"45.10"},{"v":3.2214285714285715,"d":"3.22"},11]
["201623201701022","余文斌",84,"合格",75,3,2.5,82,4,3.2,81,2,3.1,86,3,3.6,88,2,3.8,14,{"v":44.9,"d":"44.90"},{"v":3.207142857142857,"d":"3.21"},12]
["201623201702002","倪佳桐",82,"合格",69,3,1.9,74,4,2.4,90,2,{"v":4,"d":"4.0"},93,3,4.3,88,2,3.8,14,{"v":43.8,"d":"43.80"},{"v":3.1285714285714286,"d":"3.13"},13]
["201623201701011","胡铖波",76,"合格",74,3,2.4,88,4,3.8,90,2,{"v":4,"d":"4.0"},79,3,2.9,73,2,2.3,14,{"v":43.699999999999996,"d":"43.70"},{"v":3.121428571428571,"d":"3.12"},14]
["201623201701014","颜洁",81,"合格",71,3,2.1,90,4,{"v":4,"d":"4.0"},75,2,2.5,81,3,3.1,79,2,2.9,14,{"v":42.4,"d":"42.40"},{"v":3.0285714285714285,"d":"3.03"},15]
["201623201702023","周路遥",77,"合格",74,3,2.4,72,4,2.2,85,2,3.5,92,3,4.2,84,2,3.4,14,{"v":42.4,"d":"42.40"},{"v":3.0285714285714285,"d":"3.03"},16]
["201623201701013","许强",79,"合格",66,3,1.6,84,4,3.4,82,2,3.2,88,3,3.8,79,2,2.9,14,{"v":41.99999999999999,"d":"42.00"},{"v":2.9999999999999996,"d":"3.00"},17]
["201623201701028","王含玉",82,"合格",84,3,3.4,77,4,2.7,69,2,1.9,82,3,3.2,86,2,3.6,14,{"v":41.60000000000001,"d":"41.60"},{"v":2.971428571428572,"d":"2.97"},18]
["201623201701003","赵家豪",84,"合格",74,3,2.4,81,4,3.1,84,2,3.4,81,3,3.1,79,2,2.9,14,{"v":41.5,"d":"41.50"},{"v":2.9642857142857144,"d":"2.96"},19]
["201623201702013","雷明莉",79,"合格",75,3,2.5,77,4,2.7,84,2,3.4,83,3,3.3,82,2,3.2,14,{"v":41.4,"d":"41.40"},{"v":2.957142857142857,"d":"2.96"},20]
["201623201702005","项睿洁",72,"合格",73,3,2.3,82,4,3.2,83,2,3.3,78,3,2.8,83,2,3.3,14,{"v":41.3,"d":"41.30"},{"v":2.9499999999999997,"d":"2.95"},21]
["201623201702019","郦佳澄",72,"合格",77,3,2.7,72,4,2.2,70,2,{"v":2,"d":"2.0"},90,3,{"v":4,"d":"4.0"},87,2,3.7,14,{"v":40.300000000000004,"d":"40.30"},{"v":2.878571428571429,"d":"2.88"},22]
["201623201702021","吴琼",79,"合格",73,3,2.3,71,4,2.1,87,2,3.7,84,3,3.4,87,2,3.7,14,{"v":40.300000000000004,"d":"40.30"},{"v":2.878571428571429,"d":"2.88"},23]
["201623201701029","王子龙",77,"合格",82,3,3.2,63,4,1.3,77,2,2.7,91,3,4.1,84,2,3.4,14,{"v":39.3,"d":"39.30"},{"v":2.807142857142857,"d":"2.81"},24]
["201623201701018","凌轶男",83,"合格",60,3,{"v":1,"d":"1.0"},85,4,3.5,85,2,3.5,86,3,3.6,72,2,2.2,14,{"v":39.199999999999996,"d":"39.20"},{"v":2.8,"d":"2.80"},25]
["201623201701001","莫亚男",71,"合格",75,3,2.5,75,4,2.5,86,2,3.6,78,3,2.8,80,2,{"v":3,"d":"3.0"},14,{"v":39.099999999999994,"d":"39.10"},{"v":2.7928571428571423,"d":"2.79"},26]
["201623201701027","龙海波",72,"合格",63,3,1.3,76,4,2.6,79,2,2.9,91,3,4.1,80,2,{"v":3,"d":"3.0"},14,{"v":38.4,"d":"38.40"},{"v":2.742857142857143,"d":"2.74"},27]
["201623201701026","齐紫燕",86,"合格",65,3,1.5,78,4,2.8,86,2,3.6,79,3,2.9,82,2,3.2,14,{"v":38,"d":"38.00"},{"v":2.7142857142857144,"d":"2.71"},28]
["201623201701019","陈约琴",83,"合格",87,3,3.7,64,4,1.4,76,2,2.6,81,3,3.1,82,2,3.2,14,{"v":37.6,"d":"37.60"},{"v":2.685714285714286,"d":"2.69"},29]
["201623201702006","陈奇英",71,"合格",80,3,{"v":3,"d":"3.0"},69,4,1.9,78,2,2.8,82,3,3.2,78,2,2.8,14,{"v":37.400000000000006,"d":"37.40"},{"v":2.6714285714285717,"d":"2.67"},30]
["201623201702009","芦蒙蒙",69,"合格",69,3,1.9,75,4,2.5,77,2,2.7,81,3,3.1,85,2,3.5,14,{"v":37.400000000000006,"d":"37.40"},{"v":2.6714285714285717,"d":"2.67"},31]
["201623201701007","徐珂君",79,"合格",54,3,{"v":0,"d":"0.0"},84,4,3.4,83,2,3.3,89,3,3.9,77,2,2.7,14,{"v":37.3,"d":"37.30"},{"v":2.664285714285714,"d":"2.66"},32]
["201623201701033","魏宇航",79,"合格",75,3,2.5,64,4,1.4,76,2,2.6,88,3,3.8,84,2,3.4,14,{"v":36.5,"d":"36.50"},{"v":2.607142857142857,"d":"2.61"},33]
["201623201702025","何伟铭",76,"合格",78,3,2.8,76,4,2.6,77,2,2.7,75,3,2.5,74,2,2.4,14,{"v":36.49999999999999,"d":"36.50"},{"v":2.6071428571428568,"d":"2.61"},34]
["201623201701030","彭丹菊",80,"合格",63,3,1.3,75,4,2.5,72,2,2.2,91,3,4.1,78,2,2.8,14,{"v":36.2,"d":"36.20"},{"v":2.585714285714286,"d":"2.59"},35]
["201623201701006","蒋宏磊",89,"合格",60,3,{"v":1,"d":"1.0"},78,4,2.8,88,2,3.8,79,3,2.9,76,2,2.6,14,{"v":35.699999999999996,"d":"35.70"},2.55,36]
["201623201702015","周敏",74,"合格",72,3,2.2,64,4,1.4,78,2,2.8,84,3,3.4,87,2,3.7,14,{"v":35.4,"d":"35.40"},{"v":2.5285714285714285,"d":"2.53"},37]
["201623201701024","洪俏倩",77,"合格",65,3,1.5,74,4,2.4,76,2,2.6,82,3,3.2,82,2,3.2,14,{"v":35.300000000000004,"d":"35.30"},{"v":2.521428571428572,"d":"2.52"},38]
["201623201701015","张雨妍",79,"合格",61,3,1.1,79,4,2.9,76,2,2.6,79,3,2.9,76,2,2.6,14,{"v":34,"d":"34.00"},{"v":2.4285714285714284,"d":"2.43"},39]
["201623201702031","龚流娥",77,"合格",61,3,1.1,71,4,2.1,71,2,2.1,88,3,3.8,81,2,3.1,14,{"v":33.5,"d":"33.50"},{"v":2.392857142857143,"d":"2.39"},40]
["201623201701016","沈佳莹",74,"合格",51,3,{"v":0,"d":"0.0"},80,4,{"v":3,"d":"3.0"},76,2,2.6,80,3,{"v":3,"d":"3.0"},86,2,3.6,14,{"v":33.4,"d":"33.40"},{"v":2.3857142857142857,"d":"2.39"},41]
["201623201702007","陈浩",80,"合格",61,3,1.1,79,4,2.9,80,2,{"v":3,"d":"3.0"},75,3,2.5,75,2,2.5,14,{"v":33.4,"d":"33.40"},{"v":2.3857142857142857,"d":"2.39"},42]
["201623201701023","杨景森",82,"合格",74,3,2.4,58,4,{"v":0,"d":"0.0"},84,2,3.4,92,3,4.2,83,2,3.3,14,{"v":33.2,"d":"33.20"},{"v":2.3714285714285714,"d":"2.37"},43]
["201623201702027","殷玉杰",68,"合格",61,3,1.1,73,4,2.3,79,2,2.9,77,3,2.7,84,2,3.4,14,{"v":33.2,"d":"33.20"},{"v":2.3714285714285714,"d":"2.37"},44]
["201623201701021","郭飘逸",69,"合格",63,3,1.3,77,4,2.7,66,2,1.6,78,3,2.8,83,2,3.3,14,{"v":32.9,"d":"32.90"},2.35,45]
["201623201701031","卢成梅",79,"合格",73,3,2.3,63,4,1.3,75,2,2.5,80,3,{"v":3,"d":"3.0"},82,2,3.2,14,{"v":32.5,"d":"32.50"},{"v":2.3214285714285716,"d":"2.32"},46]
["201623201702001","汤文奕",73,"合格",67,3,1.7,71,4,2.1,77,2,2.7,76,3,2.6,73,2,2.3,14,{"v":31.299999999999997,"d":"31.30"},{"v":2.2357142857142853,"d":"2.24"},47]
["201623201702004","孙逸梅",60,"合格",49,3,{"v":0,"d":"0.0"},81,4,3.1,70,2,{"v":2,"d":"2.0"},79,3,2.9,76,2,2.6,14,{"v":30.299999999999997,"d":"30.30"},{"v":2.164285714285714,"d":"2.16"},48]
["201623201702026","杨芙容",63,"合格",66,3,1.6,65,4,1.5,63,2,1.3,82,3,3.2,78,2,2.8,14,{"v":28.6,"d":"28.60"},{"v":2.042857142857143,"d":"2.04"},49]
["201623201701020","王欣怡",73,"合格",61,3,1.1,71,4,2.1,81,2,3.1,67,3,1.7,77,2,2.7,14,{"v":28.4,"d":"28.40"},{"v":2.0285714285714285,"d":"2.03"},50]
["201623201702011","朱翔鸿",74,"合格",68,3,1.8,58,4,{"v":0,"d":"0.0"},87,2,3.7,81,3,3.1,80,2,{"v":3,"d":"3.0"},14,{"v":28.1,"d":"28.10"},{"v":2.007142857142857,"d":"2.01"},51]
["201623201701025","张一凡",77,"合格",60,3,{"v":1,"d":"1.0"},61,4,1.1,72,2,2.2,86,3,3.6,77,2,2.7,14,{"v":28,"d":"28.00"},{"v":2,"d":"2.00"},52]
["201623201701010","陈泓逾",72,"合格",64,3,1.4,58,4,{"v":0,"d":"0.0"},89,2,3.9,78,3,2.8,87,2,3.7,14,{"v":27.799999999999997,"d":"27.80"},{"v":1.9857142857142855,"d":"1.99"},53]
["201623201701008","朱雪婷",82,"合格",51,3,{"v":0,"d":"0.0"},73,4,2.3,67,2,1.7,78,3,2.8,79,2,2.9,14,{"v":26.8,"d":"26.80"},{"v":1.9142857142857144,"d":"1.91"},54]
["201623201702030","潘峒旭",74,"合格",44,3,{"v":0,"d":"0.0"},67,4,1.7,66,2,1.6,87,3,3.7,72,2,2.2,14,{"v":25.5,"d":"25.50"},{"v":1.8214285714285714,"d":"1.82"},55]
["201623201702008","岑娄",72,"合格",52,3,{"v":0,"d":"0.0"},64,4,1.4,76,2,2.6,79,3,2.9,75,2,2.5,14,{"v":24.5,"d":"24.50"},1.75,56]
["201623201702032","朱军杰",71,"合格",53,3,{"v":0,"d":"0.0"},44,4,{"v":0,"d":"0.0"},82,2,3.2,90,3,{"v":4,"d":"4.0"},80,2,{"v":3,"d":"3.0"},14,{"v":24.4,"d":"24.40"},{"v":1.7428571428571427,"d":"1.74"},57]
["201623201702020","马震宇",72,"合格",48,3,{"v":0,"d":"0.0"},63,4,1.3,76,2,2.6,77,3,2.7,77,2,2.7,14,{"v":23.9,"d":"23.90"},{"v":1.707142857142857,"d":"1.71"},58]
["201623201702016","冯佳伟",78,"合格",69,3,1.9,43,4,{"v":0,"d":"0.0"},70,2,{"v":2,"d":"2.0"},77,3,2.7,80,2,{"v":3,"d":"3.0"},14,{"v":23.8,"d":"23.80"},{"v":1.7,"d":"1.70"},59]
["201623201702003","周海涛",88,"合格",50,3,{"v":0,"d":"0.0"},65,4,1.5,76,2,2.6,74,3,2.4,77,2,2.7,14,{"v":23.799999999999997,"d":"23.80"},{"v":1.6999999999999997,"d":"1.70"},60]
["201623201702010","陈敏迪",70,"合格",60,3,{"v":1,"d":"1.0"},60,4,{"v":1,"d":"1.0"},68,2,1.8,75,3,2.5,71,2,2.1,14,{"v":22.3,"d":"22.30"},{"v":1.592857142857143,"d":"1.59"},61]
["201623201702017","罗鑫磊",68,"合格",65,3,1.5,49,4,{"v":0,"d":"0.0"},78,2,2.8,73,3,2.3,76,2,2.6,14,{"v":22.2,"d":"22.20"},{"v":1.5857142857142856,"d":"1.59"},62]
["201623201701032","蓝春连",80,"合格",51,3,{"v":0,"d":"0.0"},60,4,{"v":1,"d":"1.0"},39,2,{"v":0,"d":"0.0"},88,3,3.8,75,2,2.5,14,{"v":20.4,"d":"20.40"},{"v":1.457142857142857,"d":"1.46"},63]
["201623201702029","陈伟伟",84,"合格",48,3,{"v":0,"d":"0.0"},46,4,{"v":0,"d":"0.0"},76,2,2.6,81,3,3.1,75,2,2.5,14,{"v":19.5,"d":"19.50"},{"v":1.3928571428571428,"d":"1.39"},64]