{"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":75,"n_cols":27,"rows_kept":75,"flags":["formulas_cached_only"]}
["学号","姓名","体育Ⅰ [1]","形势与政策A [2]","系统解剖学C [2.5]","学分","绩点","无机化学B [3]","学分","绩点","大学英语Ⅰ(B) [4]","学分","绩点","信息技术应用导论 [2]","学分","绩点","毛泽东思想和中国特色社会主义理论体系概论 [4]","学分","绩点","马克思主义基本原理概论 [3]","学分","绩点","总学分","总学分绩点","加权平均绩点","成绩排名","备注"]
["201612203902029","王齐敏",76,"合格",96,2.5,4.6,95,3,4.5,94,4,4.4,87,2,3.7,85,4,3.5,83,3,3.3,18.5,{"v":73.9,"d":"73.90"},{"v":3.994594594594595,"d":"3.99"},1,"前30%"]
["201612203901033","吴乾昌",80,"合格",87,2.5,3.7,93,3,4.3,91,4,4.1,94,2,4.4,85,4,3.5,82,3,3.2,18.5,{"v":70.94999999999999,"d":"70.95"},{"v":3.8351351351351344,"d":"3.84"},2,"前30%"]
["201612203902011","王薪",84,"合格",95,2.5,4.5,88,3,3.8,88,4,3.8,95,2,4.5,84,4,3.4,81,3,3.1,18.5,69.75,{"v":3.77027027027027,"d":"3.77"},3,"前30%"]
["201612203901036","王与嫣",84,"合格",93,2.5,4.3,89,3,3.9,89,4,3.9,92,2,4.2,83,4,3.3,80,3,{"v":3,"d":"3.0"},18.5,{"v":68.64999999999999,"d":"68.65"},{"v":3.7108108108108104,"d":"3.71"},4,"前30%"]
["201612203902008","胡紫怡",77,"合格",85,2.5,3.5,89,3,3.9,90,4,{"v":4,"d":"4.0"},86,2,3.6,87,4,3.7,81,3,3.1,18.5,67.75,{"v":3.6621621621621623,"d":"3.66"},5,"前30%"]
["201612203901003","徐娇娇",85,"合格",92,2.5,4.2,93,3,4.3,90,4,{"v":4,"d":"4.0"},82,2,3.2,80,4,{"v":3,"d":"3.0"},80,3,{"v":3,"d":"3.0"},18.5,{"v":66.8,"d":"66.80"},{"v":3.610810810810811,"d":"3.61"},6,"前30%"]
["201612203901028","郭雪璠",73,"合格",87,2.5,3.7,91,3,4.1,89,4,3.9,82,2,3.2,85,4,3.5,78,3,2.8,18.5,{"v":65.94999999999999,"d":"65.95"},{"v":3.564864864864864,"d":"3.56"},7,"前30%"]
["201612203902023","章韫琳",82,"合格",93,2.5,4.3,93,3,4.3,88,4,3.8,87,2,3.7,79,4,2.9,75,3,2.5,18.5,65.35,{"v":3.532432432432432,"d":"3.53"},8,"前30%"]
["201612203901017","施一丁",87,"合格",93,2.5,4.3,85,3,3.5,81,4,3.1,83,2,3.3,85,4,3.5,84,3,3.4,18.5,64.45,{"v":3.483783783783784,"d":"3.48"},9,"前30%"]
["201612203901004","柴鑫心",84,"合格",92,2.5,4.2,82,3,3.2,92,4,4.2,83,2,3.3,74,4,2.4,87,3,3.7,18.5,{"v":64.20000000000002,"d":"64.20"},{"v":3.4702702702702712,"d":"3.47"},10,"前30%"]
["201612203901031","高洁",74,"合格",90,2.5,{"v":4,"d":"4.0"},78,3,2.8,88,4,3.8,89,2,3.9,81,4,3.1,84,3,3.4,18.5,{"v":63.999999999999986,"d":"64.00"},{"v":3.4594594594594588,"d":"3.46"},11,"前30%"]
["201612203901030","姚玥",69,"合格",91,2.5,4.1,84,3,3.4,90,4,{"v":4,"d":"4.0"},81,2,3.1,79,4,2.9,80,3,{"v":3,"d":"3.0"},18.5,{"v":63.25000000000001,"d":"63.25"},{"v":3.4189189189189193,"d":"3.42"},12,"前30%"]
["201612203901001","梅晨璇",64,"合格",88,2.5,3.8,79,3,2.9,87,4,3.7,86,2,3.6,78,4,2.8,89,3,3.9,18.5,{"v":63.10000000000001,"d":"63.10"},{"v":3.410810810810811,"d":"3.41"},13,"前30%"]
["201612203901009","沈溢超",85,"合格",99,2.5,4.9,68,3,1.8,91,4,4.1,92,2,4.2,84,4,3.4,72,3,2.2,18.5,62.65,{"v":3.3864864864864863,"d":"3.39"},14,"前30%"]
["201612203902018","林敏秋",87,"合格",90,2.5,{"v":4,"d":"4.0"},86,3,3.6,77,4,2.7,90,2,{"v":4,"d":"4.0"},85,4,3.5,80,3,{"v":3,"d":"3.0"},18.5,{"v":62.6,"d":"62.60"},{"v":3.383783783783784,"d":"3.38"},15,"前30%"]
["201612203901002","吴亚彬",75,"合格",77,2.5,2.7,85,3,3.5,92,4,4.2,90,2,{"v":4,"d":"4.0"},76,4,2.6,83,3,3.3,18.5,{"v":62.349999999999994,"d":"62.35"},{"v":3.37027027027027,"d":"3.37"},16,"前30%"]
["201612203902020","温思思",76,"合格",90,2.5,{"v":4,"d":"4.0"},80,3,{"v":3,"d":"3.0"},90,4,{"v":4,"d":"4.0"},79,2,2.9,82,4,3.2,78,3,2.8,18.5,{"v":61.99999999999999,"d":"62.00"},{"v":3.351351351351351,"d":"3.35"},17,"前30%"]
["201612203902016","周竹晨",80,"合格",96,2.5,4.6,75,3,2.5,91,4,4.1,81,2,3.1,79,4,2.9,75,3,2.5,18.5,{"v":60.7,"d":"60.70"},{"v":3.2810810810810813,"d":"3.28"},18,"前30%"]
["201612203902022","杨佳盈",80,"合格",79,2.5,2.9,80,3,{"v":3,"d":"3.0"},87,4,3.7,87,2,3.7,84,4,3.4,78,3,2.8,18.5,60.45,{"v":3.2675675675675677,"d":"3.27"},19,"前30%"]
["201612203902027","孙嘉莹",80,"合格",90,2.5,{"v":4,"d":"4.0"},86,3,3.6,84,4,3.4,86,2,3.6,79,4,2.9,74,3,2.4,18.5,{"v":60.400000000000006,"d":"60.40"},{"v":3.2648648648648653,"d":"3.26"},20,"前30%"]
["201612203901038","谢双丹",77,"合格",90,2.5,{"v":4,"d":"4.0"},85,3,3.5,73,4,2.3,95,2,4.5,83,4,3.3,78,3,2.8,18.5,{"v":60.300000000000004,"d":"60.30"},{"v":3.2594594594594595,"d":"3.26"},21,"前30%"]
["201612203902024","徐康",84,"合格",84,2.5,3.4,78,3,2.8,89,4,3.9,90,2,{"v":4,"d":"4.0"},77,4,2.7,78,3,2.8,18.5,{"v":59.699999999999996,"d":"59.70"},{"v":3.227027027027027,"d":"3.23"},22,"前30%"]
["201612203901032","徐梦婷",78,"合格",79,2.5,2.9,78,3,2.8,85,4,3.5,88,2,3.8,82,4,3.2,81,3,3.1,18.5,{"v":59.349999999999994,"d":"59.35"},{"v":3.208108108108108,"d":"3.21"},23]
["201612203902034","易秀秀",65,"合格",79,2.5,2.9,87,3,3.7,89,4,3.9,79,2,2.9,79,4,2.9,75,3,2.5,18.5,58.85,{"v":3.1810810810810812,"d":"3.18"},24]
["201612203902015","林彤",72,"合格",87,2.5,3.7,82,3,3.2,86,4,3.6,92,2,4.2,73,4,2.3,74,3,2.4,18.5,58.05,{"v":3.1378378378378375,"d":"3.14"},25]
["201612203901012","徐浩桢",79,"合格",77,2.5,2.7,85,3,3.5,93,4,4.3,93,2,4.3,75,4,2.5,66,3,1.6,18.5,{"v":57.85000000000001,"d":"57.85"},{"v":3.1270270270270273,"d":"3.13"},26]
["201612203901029","郭明晨",87,"合格",74,2.5,2.4,78,3,2.8,84,4,3.4,72,2,2.2,83,4,3.3,89,3,3.9,18.5,{"v":57.3,"d":"57.30"},{"v":3.097297297297297,"d":"3.10"},27]
["201612203902017","杜雨洁",86,"合格",80,2.5,{"v":3,"d":"3.0"},81,3,3.1,74,4,2.4,89,2,3.9,82,4,3.2,83,3,3.3,18.5,{"v":56.9,"d":"56.90"},{"v":3.075675675675676,"d":"3.08"},28]
["201612203902019","包晓樟",74,"合格",83,2.5,3.3,86,3,3.6,78,4,2.8,98,2,4.8,76,4,2.6,71,3,2.1,18.5,56.55,{"v":3.0567567567567564,"d":"3.06"},29]
["201612203901011","李迪锋",81,"合格",76,2.5,2.6,82,3,3.2,87,4,3.7,79,2,2.9,82,4,3.2,73,3,2.3,18.5,{"v":56.4,"d":"56.40"},{"v":3.0486486486486486,"d":"3.05"},30]
["201612203901019","王照磊",82,"合格",87,2.5,3.7,74,3,2.4,82,4,3.2,89,2,3.9,78,4,2.8,75,3,2.5,18.5,55.75,{"v":3.0135135135135136,"d":"3.01"},31]
["201612203901018","俞明静",64,"合格",88,2.5,3.8,77,3,2.7,77,4,2.7,73,2,2.3,80,4,{"v":3,"d":"3.0"},85,3,3.5,18.5,{"v":55.5,"d":"55.50"},{"v":3,"d":"3.00"},32]
["201612203901035","苏瑞平",77,"合格",87,2.5,3.7,82,3,3.2,74,4,2.4,70,2,{"v":2,"d":"2.0"},82,4,3.2,84,3,3.4,18.5,55.45,{"v":2.9972972972972975,"d":"3.00"},33]
["201612203902030","秦瑶",79,"合格",85,2.5,3.5,79,3,2.9,83,4,3.3,79,2,2.9,81,4,3.1,71,3,2.1,18.5,{"v":55.14999999999999,"d":"55.15"},{"v":2.9810810810810806,"d":"2.98"},34]
["201612203901027","邱雅",76,"合格",87,2.5,3.7,80,3,{"v":3,"d":"3.0"},70,4,{"v":2,"d":"2.0"},84,2,3.4,83,4,3.3,79,3,2.9,18.5,54.95,{"v":2.9702702702702704,"d":"2.97"},35]
["201612203901010","郭佳楠",84,"合格",82,2.5,3.2,70,3,{"v":2,"d":"2.0"},88,4,3.8,91,2,4.1,78,4,2.8,70,3,{"v":2,"d":"2.0"},18.5,{"v":54.599999999999994,"d":"54.60"},{"v":2.951351351351351,"d":"2.95"},36]
["201612203902006","毛伟阳",83,"合格",84,2.5,3.4,73,3,2.3,77,4,2.7,85,2,3.5,81,4,3.1,79,3,2.9,18.5,{"v":54.3,"d":"54.30"},{"v":2.935135135135135,"d":"2.94"},37]
["201612203902010","胡人杰",76,"合格",77,2.5,2.7,72,3,2.2,88,4,3.8,78,2,2.8,83,4,3.3,71,3,2.1,18.5,{"v":53.64999999999999,"d":"53.65"},{"v":2.8999999999999995,"d":"2.90"},38]
["201612203902035","张宁",75,"合格",78,2.5,2.8,85,3,3.5,82,4,3.2,68,2,1.8,81,4,3.1,74,3,2.4,18.5,{"v":53.5,"d":"53.50"},{"v":2.891891891891892,"d":"2.89"},39]
["201612203902014","章美萍",77,"合格",86,2.5,3.6,75,3,2.5,79,4,2.9,70,2,{"v":2,"d":"2.0"},80,4,{"v":3,"d":"3.0"},81,3,3.1,18.5,{"v":53.400000000000006,"d":"53.40"},{"v":2.8864864864864868,"d":"2.89"},40]
["201612203901026","滕俊玮",78,"合格",79,2.5,2.9,73,3,2.3,83,4,3.3,91,2,4.1,80,4,{"v":3,"d":"3.0"},69,3,1.9,18.5,53.25,{"v":2.8783783783783785,"d":"2.88"},41]
["201612203901005","郑留燕",77,"合格",83,2.5,3.3,65,3,1.5,90,4,{"v":4,"d":"4.0"},75,2,2.5,75,4,2.5,80,3,{"v":3,"d":"3.0"},18.5,52.75,{"v":2.8513513513513513,"d":"2.85"},42]
["201612203902033","张智婕",69,"合格",79,2.5,2.9,72,3,2.2,79,4,2.9,87,2,3.7,83,4,3.3,71,3,2.1,18.5,{"v":52.349999999999994,"d":"52.35"},{"v":2.8297297297297295,"d":"2.83"},43]
["201612203901025","王云杰",79,"合格",79,2.5,2.9,76,3,2.6,82,4,3.2,88,2,3.8,76,4,2.6,71,3,2.1,18.5,{"v":52.150000000000006,"d":"52.15"},{"v":2.818918918918919,"d":"2.82"},44]
["201612203901024","倪鑫韬",78,"合格",81,2.5,3.1,71,3,2.1,78,4,2.8,81,2,3.1,80,4,{"v":3,"d":"3.0"},78,3,2.8,18.5,51.85,{"v":2.8027027027027027,"d":"2.80"},45]
["201612203901020","王渊",90,"合格",87,2.5,3.7,84,3,3.4,71,4,2.1,81,2,3.1,75,4,2.5,74,3,2.4,18.5,51.25,{"v":2.77027027027027,"d":"2.77"},46]
["201612203901008","严诗卉",79,"合格",76,2.5,2.6,68,3,1.8,80,4,{"v":3,"d":"3.0"},79,2,2.9,80,4,{"v":3,"d":"3.0"},74,3,2.4,18.5,{"v":48.900000000000006,"d":"48.90"},{"v":2.6432432432432433,"d":"2.64"},47]
["201612203902007","陈义妃",77,"合格",79,2.5,2.9,77,3,2.7,77,4,2.7,84,2,3.4,74,4,2.4,71,3,2.1,18.5,{"v":48.85000000000001,"d":"48.85"},{"v":2.640540540540541,"d":"2.64"},48]
["201612203901014","洪鑫",69,"合格",79,2.5,2.9,68,3,1.8,80,4,{"v":3,"d":"3.0"},76,2,2.6,81,4,3.1,70,3,{"v":2,"d":"2.0"},18.5,48.25,{"v":2.608108108108108,"d":"2.61"},49]
["201612203902003","周琪凡",77,"合格",78,2.5,2.8,79,3,2.9,76,4,2.6,86,2,3.6,68,4,1.8,73,3,2.3,18.5,{"v":47.400000000000006,"d":"47.40"},{"v":2.5621621621621626,"d":"2.56"},50]
["201612203902002","马国鑫",71,"合格",74,2.5,2.4,79,3,2.9,71,4,2.1,78,2,2.8,78,4,2.8,71,3,2.1,18.5,{"v":46.2,"d":"46.20"},{"v":2.4972972972972975,"d":"2.50"},51]
["201612203902009","王奕吉",73,"合格",71,2.5,2.1,71,3,2.1,73,4,2.3,81,2,3.1,80,4,{"v":3,"d":"3.0"},74,3,2.4,18.5,{"v":46.150000000000006,"d":"46.15"},{"v":2.494594594594595,"d":"2.49"},52]
["201612203901023","王星茗",83,"合格",74,2.5,2.4,65,3,1.5,77,4,2.7,79,2,2.9,81,4,3.1,72,3,2.2,18.5,{"v":46.1,"d":"46.10"},{"v":2.4918918918918918,"d":"2.49"},53]
["201612203902025","胡正超",74,"合格",64,2.5,1.4,71,3,2.1,76,4,2.6,87,2,3.7,79,4,2.9,70,3,{"v":2,"d":"2.0"},18.5,{"v":45.2,"d":"45.20"},{"v":2.4432432432432436,"d":"2.44"},54]
["201612203902028","靳子轩",70,"合格",81,2.5,3.1,72,3,2.2,65,4,1.5,77,2,2.7,84,4,3.4,69,3,1.9,18.5,45.05,{"v":2.435135135135135,"d":"2.44"},55]
["201612203901006","周毓绚",78,"合格",76,2.5,2.6,68,3,1.8,75,4,2.5,72,2,2.2,80,4,{"v":3,"d":"3.0"},72,3,2.2,18.5,{"v":44.9,"d":"44.90"},{"v":2.427027027027027,"d":"2.43"},56]
["201612203902013","咸書晴",78,"合格",76,2.5,2.6,64,3,1.4,76,4,2.6,72,2,2.2,77,4,2.7,75,3,2.5,18.5,{"v":43.8,"d":"43.80"},{"v":2.3675675675675674,"d":"2.37"},57]
["201612203901015","蒋风波",87,"合格",71,2.5,2.1,66,3,1.6,75,4,2.5,79,2,2.9,79,4,2.9,70,3,{"v":2,"d":"2.0"},18.5,43.45,{"v":2.348648648648649,"d":"2.35"},58]
["201612203902031","裴俊弛",75,"合格",70,2.5,{"v":2,"d":"2.0"},75,3,2.5,84,4,3.4,62,2,1.2,69,4,1.9,66,3,1.6,18.5,{"v":40.900000000000006,"d":"40.90"},{"v":2.2108108108108113,"d":"2.21"},59]
["201612203902021","沈豪杰",79,"合格",70,2.5,{"v":2,"d":"2.0"},50,3,{"v":0,"d":"0.0"},74,4,2.4,85,2,3.5,79,4,2.9,75,3,2.5,18.5,{"v":40.7,"d":"40.70"},{"v":2.2,"d":"2.20"},60]
["201612203902037","黎宁",83,"合格",74,2.5,2.4,67,3,1.7,81,4,3.1,70,2,{"v":2,"d":"2.0"},65,4,1.5,74,3,2.4,18.5,{"v":40.7,"d":"40.70"},{"v":2.2,"d":"2.20"},61]
["201612203902012","傅杭杰",85,"合格",73,2.5,2.3,70,3,{"v":2,"d":"2.0"},69,4,1.9,80,2,{"v":3,"d":"3.0"},71,4,2.1,73,3,2.3,18.5,40.65,{"v":2.1972972972972973,"d":"2.20"},62]
["201612203901016","顾晨贤",74,"合格",81,2.5,3.1,68,3,1.8,66,4,1.6,81,2,3.1,75,4,2.5,66,3,1.6,18.5,40.55,{"v":2.191891891891892,"d":"2.19"},63]
["201612203901021","唐云佳",79,"合格",79,2.5,2.9,66,3,1.6,67,4,1.7,73,2,2.3,78,4,2.8,69,3,1.9,18.5,{"v":40.35000000000001,"d":"40.35"},{"v":2.1810810810810817,"d":"2.18"},64]
["201612203902005","毛谦平",77,"合格",72,2.5,2.2,65,3,1.5,69,4,1.9,74,2,2.4,70,4,{"v":2,"d":"2.0"},83,3,3.3,18.5,{"v":40.3,"d":"40.30"},{"v":2.1783783783783783,"d":"2.18"},65]
["201612203902001","徐凯",70,"合格",72,2.5,2.2,62,3,1.2,81,4,3.1,68,2,1.8,74,4,2.4,64,3,1.4,18.5,{"v":38.900000000000006,"d":"38.90"},{"v":2.102702702702703,"d":"2.10"},66]
["201612203901034","景德生",82,"合格",77,2.5,2.7,70,3,{"v":2,"d":"2.0"},68,4,1.8,70,2,{"v":2,"d":"2.0"},73,4,2.3,68,3,1.8,18.5,38.55,{"v":2.0837837837837836,"d":"2.08"},67]
["201612203901007","潘梓倚",73,"合格",68,2.5,1.8,46,3,{"v":0,"d":"0.0"},84,4,3.4,73,2,2.3,75,4,2.5,68,3,1.8,18.5,{"v":38.1,"d":"38.10"},{"v":2.0594594594594597,"d":"2.06"},68]
["201612203902026","金骏超",70,"合格",72,2.5,2.2,60,3,{"v":1,"d":"1.0"},70,4,{"v":2,"d":"2.0"},75,2,2.5,74,4,2.4,70,3,{"v":2,"d":"2.0"},18.5,{"v":37.1,"d":"37.10"},{"v":2.0054054054054054,"d":"2.01"},69]
["201612203901022","仲晓强",79,"合格",79,2.5,2.9,60,3,{"v":1,"d":"1.0"},60,4,{"v":1,"d":"1.0"},76,2,2.6,78,4,2.8,67,3,1.7,18.5,35.75,{"v":1.9324324324324325,"d":"1.93"},70]
["201612203901013","翁一鸣",78,"合格",41,2.5,{"v":0,"d":"0.0"},43,3,{"v":0,"d":"0.0"},66,4,1.6,84,2,3.4,81,4,3.1,69,3,1.9,18.5,{"v":31.3,"d":"31.30"},{"v":1.691891891891892,"d":"1.69"},71]
["201612203902036","李月",75,"合格",60,2.5,{"v":1,"d":"1.0"},54,3,{"v":0,"d":"0.0"},69,4,1.9,87,2,3.7,62,4,1.2,65,3,1.5,18.5,{"v":26.8,"d":"26.80"},{"v":1.4486486486486487,"d":"1.45"},72]
["201612203901037","刘安安",75,"合格",75,2.5,2.5,42,3,{"v":0,"d":"0.0"},55,4,{"v":0,"d":"0.0"},75,2,2.5,67,4,1.7,79,3,2.9,18.5,26.75,{"v":1.445945945945946,"d":"1.45"},73]
["201612203902004","邱程阳",64,"合格",70,2.5,{"v":2,"d":"2.0"},52,3,{"v":0,"d":"0.0"},48,4,{"v":0,"d":"0.0"},51,2,{"v":0,"d":"0.0"},67,4,1.7,76,3,2.6,18.5,{"v":19.6,"d":"19.60"},{"v":1.0594594594594595,"d":"1.06"},74]