{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":140,"n_cols":14,"rows_kept":140,"merged":[[0,0,0,13]]}
["2017级光学工程系硕士研究生二阶段学业奖学金评审汇总表"]
["序号","专业","学号","姓名","平均绩点（学院核算）","论文","专利","竞赛","思想政治表现","初审分","初审标准分","复审分","最终分","奖学金等级"]
[1,"光学工程",172390314,"郑世凯",{"v":3.336206896551724,"d":"3.34"},12.5,0.25,null,null,{"$f":"E3*0.4+0.4*(F3+G3+H3)+0.2*I3","v":6.434482758620691},50,50,{"$f":"L3+K3","v":100},"一等奖"]
[2,"光学工程",172390294,"费起来",{"v":3.0791666666666666,"d":"3.08"},7,null,5.8,null,6.3516666666666675,{"$f":"J4*K3/J3","v":49.356466595212574},49,{"$f":"L4+K4","v":98.35646659521257},"一等奖"]
[3,"光学工程",172390307,"翟珊",3.63,10.75,0.25,null,null,5.852,45.47374062165059,45,90.47374062165059,"一等奖"]
[4,"光学工程",173740598,"曾静",3.18,10,0.25,null,null,5.372000000000001,41.7438370846731,42,83.7438370846731,"一等奖"]
[5,"光学工程",173740583,"张秀翔",3.16,null,null,8,null,4.464,34.68810289389068,35,69.68810289389069,"一等奖"]
[6,"光学工程",173740626,"吴淑娴",3.35,3,null,2,2,3.7399999999999998,29.06216505894962,30,59.06216505894962,"一等奖"]
[7,"光学工程",172390308,"徐博伟",{"v":3.396551724137931,"d":"3.40"},null,2.75,2,1,3.4586206896551728,26.875669882100752,27,53.87566988210075,"一等奖"]
[8,"光学工程",173740600,"陈焘",3.42,5,{"$nulls":3},3.3680000000000003,26.17148981779207,26,52.17148981779207,"一等奖"]
[9,"光学工程",173740584,"寇天一",{"v":3.3,"d":"3.30"},null,1,4,null,3.3200000000000003,25.798499464094323,25.8,51.598499464094324,"一等奖"]
[10,"光学工程",172390337,"邓操",3.74,null,0.25,4,null,3.1960000000000006,24.83494105037514,24.8,49.63494105037514,"一等奖"]
[11,"光学工程",172390288,"殷晨晖",3.87,null,null,4,null,3.148,24.461950696677388,24.5,48.96195069667739,"一等奖"]
[12,"光学工程",173740619,"王秀花",3.49,null,0.25,4,null,3.096,24.057877813504824,24,48.057877813504824,"一等奖"]
[13,"光学工程",172390289,"王俊炜",3.59,null,null,4,null,3.036,23.591639871382636,24,47.59163987138264,"一等奖"]
[14,"光学工程",173740559,"刘志鹤",3.33,null,null,4.2,null,3.0120000000000005,23.405144694533764,24,47.40514469453376,"一等奖"]
[15,"光学工程",172390315,"潘帅",3.53,4,{"$nulls":3},3.012,23.40514469453376,24,47.40514469453376,"一等奖"]
[16,"光学工程",172390277,"张跃华",3.51,null,null,4,null,3.004,23.342979635584133,23.5,46.84297963558413,"一等奖"]
[17,"光学工程",172390283,"魏仕绅",{"v":3.5775862068965516,"d":"3.58"},1.5,null,2,null,2.831034482758621,21.998928188638796,22,43.9989281886388,"一等奖"]
[18,"光学工程",172390286,"张雨乐",{"v":3.5,"d":"3.50"},null,null,3,null,2.6000000000000005,20.20364415862808,20.5,40.70364415862808,"一等奖"]
[19,"光学工程",173740604,"仲路铭",3.14,null,0.25,2,2,2.556,19.86173633440514,20,39.86173633440514,"一等奖"]
[20,"光学工程",172390325,"史俊",{"v":3.2456896551724137,"d":"3.25"},null,1,2,null,2.498275862068966,19.413183279742764,19.5,38.91318327974277,"一等奖"]
[21,"光学工程",172390317,"徐晖",{"v":3.6379310344827585,"d":"3.64"},null,0.25,2,null,2.3551724137931034,18.301178992497313,18.5,36.80117899249731,"一等奖"]
[22,"光学工程",172390309,"周玮",3.76,null,null,2,null,2.3040000000000003,17.903536977491957,18,35.90353697749195,"二等奖"]
[23,"光学工程",173740560,"姜敏",3.49,0.25,null,2,null,2.2960000000000003,17.84137191854233,17.8,35.64137191854233,"二等奖"]
[24,"光学工程",172390273,"尹晓蒙",3.22,null,null,2,1,2.2880000000000003,17.779206859592705,17.7,35.47920685959271,"二等奖"]
[25,"光学工程",172390296,"李亚东",{"v":3.6379310344827585,"d":"3.64"},null,null,2,null,2.2551724137931037,17.524115755627,17.5,35.024115755627,"二等奖"]
[26,"光学工程",173740561,"王笑笑",3.61,null,null,2,null,2.2439999999999998,17.43729903536976,17.4,34.83729903536976,"二等奖"]
[27,"光学工程",172390326,"陈磊",{"v":3.2666666666666666,"d":"3.27"},null,0.25,2,null,2.2066666666666666,17.147195426938183,17.2,34.347195426938185,"二等奖"]
[28,"光学工程",172390282,"范成",{"v":3.5125,"d":"3.51"},null,null,2,null,2.205,17.134244372990345,17.1,34.23424437299035,"二等奖"]
[29,"光学工程",173740563,"孙静",3.49,null,null,2,null,2.196,17.064308681672017,17,34.06430868167202,"二等奖"]
[30,"光学工程",173740562,"孙文峰",3.23,null,0.25,2,null,2.192,17.033226152197205,17,34.0332261521972,"二等奖"]
[31,"光学工程",173740612,"韩晶晶",3.48,null,null,2,null,2.192,17.033226152197205,17,34.0332261521972,"二等奖"]
[32,"光学工程",173740597,"陈诚",3.45,null,null,2,null,2.18,16.939978563772765,16.94,33.87997856377277,"二等奖"]
[33,"光学工程",173740614,"卢定凡",3.43,null,null,2,null,{"$f":"E35*0.4+0.4*(F35+G35+H35)+0.2*I35","v":2.172},16.87781350482314,16.9,33.77781350482314,"二等奖"]
[34,"光学工程",173740567,"巨瑞雪",3.36,null,null,2,null,2.144,{"$f":"J36*K35/J35","v":16.660235798499453},16.7,33.36023579849945,"二等奖"]
[35,"光学工程",173740622,"陈小婉",3.32,null,null,2,null,2.128,16.5359056806002,16.54,33.0759056806002,"二等奖"]
[36,"光学工程",173740575,"孙晓宇",3.55,1.5,0.25,null,null,2.12,16.473740621650578,16.5,32.97374062165058,"二等奖"]
[37,"光学工程",172390329,"顾兆麒",{"v":3.2456896551724137,"d":"3.25"},null,null,2,null,2.0982758620689657,16.30493033226151,16.3,32.60493033226151,"二等奖"]
[38,"光学工程",172390324,"元明霞",3.21,null,null,2,null,2.084,16.193997856377266,16.2,32.39399785637727,"二等奖"]
[39,"光学工程",172390278,"姚文龙",{"v":3.1551724137931036,"d":"3.16"},null,null,2,null,2.0620689655172413,16.023579849946398,16,32.0235798499464,"二等奖"]
[40,"光学工程",173740592,"陶雷",2.91,null,null,2,null,1.9640000000000002,15.261521972132895,15.3,30.561521972132894,"二等奖"]
[41,"光学工程",172390295,"江志鹏",{"v":2.9008620689655173,"d":"2.90"},null,null,2,null,1.960344827586207,15.233118971061083,15.3,30.533118971061086,"二等奖"]
[42,"光学工程",172390299,"田程",{"v":2.9,"d":"2.90"},null,null,2,null,1.96,15.230439442658081,15.2,30.43043944265808,"二等奖"]
[43,"光学工程",172390272,"申桐",{"v":2.8491379310344827,"d":"2.85"},null,null,2,null,1.9396551724137931,15.072347266881017,15.1,30.17234726688102,"二等奖"]
[44,"光学工程",172390327,"夏克文",{"v":2.771551724137931,"d":"2.77"},null,null,2,null,1.9086206896551725,14.831189710610921,14.9,29.73118971061092,"二等奖"]
[45,"光学工程",173740625,"蒋兴乐",2.76,null,null,2,null,1.904,14.795284030010706,14.8,29.595284030010706,"二等奖"]
[46,"光学工程",173740573,"田蓉",3.43,{"$nulls":3},2,1.7720000000000002,13.769560557341899,13.8,27.5695605573419,"二等奖"]
[47,"光学工程",172390335,"寇晨昊",3.42,{"$nulls":3},2,1.7680000000000002,13.738478027867085,13.7,27.438478027867085,"二等奖"]
[48,"光学工程",173740616,"于颖",3.57,0.5,{"$nulls":3},1.628,12.65058949624865,12.7,25.35058949624865,"二等奖"]
[49,"光学工程",172390279,"王良玉",{"v":2.9913793103448274,"d":"2.99"},null,1,null,null,1.5965517241379312,12.406216505894955,12.6,25.006216505894955,"二等奖"]
[50,"光学工程",173740565,"李海",3.16,0.75,{"$nulls":3},1.5640000000000003,12.153269024651655,12.2,24.353269024651652,"二等奖"]
[51,"光学工程",173740577,"潘俊",3.61,null,0.25,null,null,1.544,11.99785637727759,12,23.99785637727759,"二等奖"]
[52,"光学工程",172390291,"孟丛",3.83,{"$nulls":4},1.532,11.904608788853153,11.5,23.404608788853153,"二等奖"]
[53,"光学工程",172390304,"贾新月",3.56,null,0.25,null,null,1.5240000000000002,11.84244372990353,11.8,23.642443729903533,"二等奖"]
[54,"光学工程",172390313,"阳婷",3.52,null,0.25,null,null,1.5080000000000002,11.71811361200428,11.6,23.318113612004282,"二等奖"]
[55,"光学工程",172390305,"徐晓立",3.46,null,0.25,null,null,1.4840000000000002,11.531618435155407,11.5,23.03161843515541,"二等奖"]
[56,"光学工程",172390297,"魏光宇",2.65,{"$nulls":3},2,1.46,11.345123258306531,11.3,22.645123258306533,"二等奖"]
[57,"光学工程",172390285,"马美林",{"v":3.6,"d":"3.60"},{"$nulls":4},1.4400000000000002,11.18971061093247,11.2,22.389710610932468,"二等奖"]
[58,"光学工程",173740629,"方明月",3.58,{"$nulls":4},1.4320000000000002,11.127545551982845,11.2,22.327545551982844,"二等奖"]
[59,"光学工程",172390310,"谢欣茹",3.57,{"$nulls":4},1.428,11.096463022508031,11.1,22.19646302250803,"二等奖"]
[60,"光学工程",172390336,"孙玉",3.56,{"$nulls":4},1.4240000000000002,11.06538049303322,11.1,22.16538049303322,"二等奖"]
[61,"光学工程",173740580,"彭丽娜",3.55,{"$nulls":4},1.42,11.034297963558407,11,22.03429796355841,"二等奖"]
[62,"光学工程",173740607,"刘星",3.55,{"$nulls":4},1.42,11.034297963558407,11,22.03429796355841,"二等奖"]
[63,"光学工程",173740620,"侯娇杰",3.55,{"$nulls":4},1.42,11.034297963558407,11,22.03429796355841,"二等奖"]
[64,"光学工程",173740623,"刘剑锐",3.53,{"$nulls":4},1.412,10.972132904608783,10.9,21.872132904608783,"二等奖"]
[65,"光学工程",172390275,"吕宋",3.51,{"$nulls":4},{"$f":"E67*0.4+0.4*(F67+G67+H67)+0.2*I67","v":1.404},{"$f":"J67*K65/J65","v":10.909967845659157},10.9,21.80996784565916,"二等奖"]
[66,"光学工程",172390306,"韩思敏",{"v":3.5,"d":"3.50"},{"$nulls":4},1.4000000000000001,{"$f":"J68*K67/J67","v":10.878885316184345},10.9,{"$f":"L68+K68","v":21.778885316184343},"二等奖"]
[67,"光学工程",173740617,"府燕君",{"v":3.5,"d":"3.50"},{"$nulls":4},1.4000000000000001,10.878885316184345,10.9,21.778885316184343,"二等奖"]
[68,"光学工程",173740615,"徐颖",3.49,{"$nulls":4},1.3960000000000001,10.847802786709533,10.85,21.69780278670953,"二等奖"]
[69,"光学工程",173740630,"高聪",3.49,{"$nulls":4},1.3960000000000001,10.847802786709533,10.85,21.69780278670953,"二等奖"]
[70,"光学工程",173740618,"张维薇",3.44971667,{"$nulls":4},1.3798866680000001,10.722592007502675,10.7,21.422592007502672,"三等奖"]
[71,"光学工程",172390322,"雷雨",2.94583333,null,0.5,null,null,1.378333332,10.710521604501603,10.7,21.410521604501604,"三等奖"]
[72,"光学工程",172390312,"王思雨",3.44,{"$nulls":4},1.3760000000000001,10.692390139335473,10.7,21.392390139335472,"三等奖"]
[73,"光学工程",173740599,"刘安琦",{"v":3.4,"d":"3.40"},{"$nulls":4},1.36,10.568060021436223,10.6,21.168060021436222,"三等奖"]
[74,"光学工程",173740569,"孙群",3.34,{"$nulls":4},1.336,10.381564844587349,10.4,20.78156484458735,"三等奖"]
[75,"光学工程",173740596,"肖海成",3.33,{"$nulls":4},1.332,10.350482315112536,10.4,20.750482315112535,"三等奖"]
[76,"光学工程",173740589,"朱清",{"v":3.3,"d":"3.30"},{"$nulls":4},1.32,10.257234726688099,10.2,20.4572347266881,"三等奖"]
[77,"光学工程",173740601,"付寒梅",3.29,{"$nulls":4},1.316,10.226152197213286,10.2,20.426152197213284,"三等奖"]
[78,"光学工程",172390298,"聂源",{"v":3.038793103448276,"d":"3.04"},null,0.25,null,null,1.3155172413793106,10.222400857449086,10.2,20.422400857449084,"三等奖"]
[79,"光学工程",172390316,"胡晓蕾",{"v":3.2758620689655173,"d":"3.28"},{"$nulls":4},1.310344827586207,10.18220793140407,10.2,20.382207931404068,"三等奖"]
[80,"光学工程",172390321,"张桂雪",3.27,{"$nulls":4},1.308,10.163987138263662,10.2,20.36398713826366,"三等奖"]
[81,"光学工程",172390331,"朱润琳",3.27,{"$nulls":4},1.308,10.163987138263662,10.2,20.36398713826366,"三等奖"]
[82,"光学工程",172390280,"焦子傲",2.76,null,0.5,null,null,1.3039999999999998,10.132904608788849,10.2,20.332904608788848,"三等奖"]
[83,"光学工程",172390323,"王云坤",3.25,{"$nulls":4},1.3,10.101822079314038,10.1,20.201822079314038,"三等奖"]
[84,"光学工程",173740603,"甘继伟",3.24,{"$nulls":4},1.2960000000000003,10.070739549839226,10.1,20.170739549839226,"三等奖"]
[85,"光学工程",172390301,"王冬",{"v":2.9875,"d":"2.99"},null,0.25,null,null,1.2950000000000002,10.062968917470522,10.1,20.162968917470522,"三等奖"]
[86,"光学工程",173740578,"郑亚辉",3.22,{"$nulls":4},1.2880000000000003,10.008574490889602,10,20.0085744908896,"三等奖"]
[87,"光学工程",173740571,"隗垚",{"v":3.2,"d":"3.20"},{"$nulls":4},1.2800000000000002,9.946409431939978,9.9,19.84640943193998,"三等奖"]
[88,"光学工程",172390319,"陈海虹",3.18,{"$nulls":4},1.2720000000000002,9.884244372990354,9.9,19.784244372990354,"三等奖"]
[89,"光学工程",173740611,"刘昶",3.16,{"$nulls":4},1.2640000000000002,9.82207931404073,9.9,19.72207931404073,"三等奖"]
[90,"光学工程",173740582,"刘群伟",3.15,{"$nulls":4},1.26,9.790996784565916,9.8,19.590996784565917,"三等奖"]
[91,"光学工程",173740591,"周建忠",3.15,{"$nulls":4},1.26,9.790996784565916,9.8,19.590996784565917,"三等奖"]
[92,"光学工程",173740595,"梁昌沛",3.05,{"$nulls":4},1.22,9.48017148981779,9.5,18.980171489817792,"三等奖"]
[93,"光学工程",172390281,"蔡文龙",{"v":2.9875,"d":"2.99"},{"$nulls":4},1.195,9.285905680600212,9.3,18.585905680600213,"三等奖"]
[94,"光学工程",173740608,"刘进",2.97,{"$nulls":4},1.1880000000000002,9.231511254019292,9.2,18.43151125401929,"三等奖"]
[95,"光学工程",173740587,"李振",2.93,{"$nulls":4},1.1720000000000002,9.107181136120042,9.1,18.20718113612004,"三等奖"]
[96,"光学工程",173740593,"袁庆斌",{"v":2.9,"d":"2.90"},{"$nulls":4},1.16,9.013933547695602,9,18.0139335476956,"三等奖"]
[97,"光学工程",173740602,"施浩",2.87,{"$nulls":4},{"$f":"E99*0.4+0.4*(F99+G99+H99)+0.2*I99","v":1.1480000000000001},8.920685959271168,9,17.920685959271168,"三等奖"]
[98,"光学工程",173740606,"顾伟民",2.75,{"$nulls":4},1.1,8.547695605573418,8.5,17.047695605573416,"三等奖"]
[99,"光学工程",173740624,"祝光泉",{"v":2.7,"d":"2.70"},{"$nulls":4},1.08,{"$f":"J101*K98/J98","v":8.392282958199356},8.4,16.79228295819936,"三等奖"]
[100,"光学工程",172390274,"李振宇","未申请",{"$nulls":8},"三等奖"]
[101,"光学工程",172390276,"张政","未申请",{"$nulls":8},"三等奖"]
[102,"光学工程",172390284,"王国旭","未申请",{"$nulls":8},"三等奖"]
[103,"光学工程",172390287,"张腾飞","未申请",{"$nulls":8},"三等奖"]
[104,"光学工程",172390290,"刘逍","未申请",{"$nulls":8},"三等奖"]
[105,"光学工程",172390292,"孙召召","未申请",{"$nulls":8},"三等奖"]
[106,"光学工程",172390293,"陈晓伟","未申请",{"$nulls":8},"三等奖"]
[107,"光学工程",172390300,"陶雪辰","未申请",{"$nulls":8},"三等奖"]
[108,"光学工程",172390302,"吴鹏","未申请",{"$nulls":8},"三等奖"]
[109,"光学工程",172390303,"张翔","未申请",{"$nulls":8},"三等奖"]
[110,"光学工程",172390311,"张肖凡","未申请",{"$nulls":8},"三等奖"]
[111,"光学工程",172390318,"庚志浩","未申请",{"$nulls":8},"三等奖"]
[112,"光学工程",172390320,"刘薇","未申请",{"$nulls":8},"三等奖"]
[113,"光学工程",172390328,"曹元广","未申请",{"$nulls":8},"三等奖"]
[114,"光学工程",172390330,"钱富琛","未申请",{"$nulls":8},"三等奖"]
[115,"光学工程",172390332,"陈同","未申请",{"$nulls":8},"三等奖"]
[116,"光学工程",172390333,"陈惠康","未申请",{"$nulls":8},"三等奖"]
[117,"光学工程",172390334,"刘少杰","未申请",{"$nulls":8},"三等奖"]
[118,"光学工程",173740564,"马志豪","未申请",{"$nulls":8},"三等奖"]
[119,"光学工程",173740566,"张善婷","未申请",{"$nulls":8},"三等奖"]
[120,"光学工程",173740568,"程朝亮","未申请",{"$nulls":8},"三等奖"]
[121,"光学工程",173740570,"郑思旭","未申请",{"$nulls":8},"三等奖"]
[122,"光学工程",173740572,"孙光瑀","未申请",{"$nulls":8},"三等奖"]
[123,"光学工程",173740574,"柳阳","未申请",{"$nulls":8},"三等奖"]
[124,"光学工程",173740576,"喻治俊","未申请",{"$nulls":8},"三等奖"]
[125,"光学工程",173740579,"贡航","未申请",{"$nulls":8},"三等奖"]
[126,"光学工程",173740581,"云竹溪","未申请",{"$nulls":8},"三等奖"]
[127,"光学工程",173740585,"宋健","未申请",{"$nulls":8},"三等奖"]
[128,"光学工程",173740586,"王祈亮","未申请",{"$nulls":8},"三等奖"]
[129,"光学工程",173740588,"罗世忠","未申请",{"$nulls":8},"三等奖"]
[130,"光学工程",173740590,"沈志威","未申请",{"$nulls":8},"三等奖"]
[131,"光学工程",173740594,"顾页妮","未申请",{"$nulls":8},"三等奖"]
[132,"光学工程",173740605,"叶飞","未申请",{"$nulls":8},"三等奖"]
[133,"光学工程",173740609,"鄢朋朋","未申请",{"$nulls":8},"三等奖"]
[134,"光学工程",173740610,"贺明洋","未申请",{"$nulls":8},"三等奖"]
[135,"光学工程",173740613,"宋可","未申请",{"$nulls":8},"三等奖"]
[136,"光学工程",173740621,"随海亮","未申请",{"$nulls":8},"三等奖"]
[137,"光学工程",173740627,"周冬杰","未申请",{"$nulls":8},"三等奖"]
[138,"光学工程",173740628,"曹顺","未申请",{"$nulls":8},"三等奖"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}