{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["能化16级保研面试排名","化工16级保研面试排名","环工16级保研面试排名","环科16级保研面试排名"],"read":"whole","date_system":"1900"}

{"sheet":"能化16级保研面试排名","index":0,"n_rows":14,"n_cols":13,"rows_kept":14,"merged":[[0,0,0,13]]}
["能化16级保研面试排名"]
["序号","学号","姓名","必修课成绩","综测成绩","前两年加权+面试成绩","面试成绩","总成绩","优良率","挂科数","四级成绩","六级成绩","备注（类别）"]
[1,2016010697,"张亚楠   ",92.77445255,98.77420869,{"$f":"D3*0.7+E3*0.2+G3*0.1","v":93.40095852299999},87.03999999999999,{"$f":"F3","v":93.40095852299999},{"v":0.9483,"d":"94.83%"},0,{"v":542,"d":"542.0"},{"v":478,"d":"478.0"},"普通1"]
[2,2016010711,"孙帆  ",89.58029197,96.44011577,90.866227533,88.72,90.866227533,{"v":0.8793,"d":"87.93%"},0,{"v":595,"d":"595.0"},{"v":577,"d":"577.0"},"普通2"]
[3,2016010696,"张岱  ",88.48613139,93.60970348,89.39023266899999,87.28,89.39023266899999,{"v":0.9138,"d":"91.38%"},0,{"v":531,"d":"531.0"},{"v":429,"d":"429.0"},"普通3"]
[4,2016010713,"徐明吕   ",89.15839416,91.08050372,89.130976656,85.03999999999999,89.130976656,{"v":0.9483,"d":"94.83%"},0,{"v":505,"d":"505.0"},{"v":426,"d":"426.0"},"普通4"]
[5,2016010714,"杨欢  ",86.44087591,93.64595021,87.31380317899999,80.75999999999999,87.31380317899999,{"v":0.931,"d":"93.10%"},0,{"v":427,"d":"427.0"},{"v":294,"d":"294.0"},"普通5"]
[6,2016010716,"张睿  ",84.38613139,94.36461946,86.459215865,85.16,86.459215865,{"v":0.8793,"d":"87.93%"},0,{"v":467,"d":"467.0"},{"v":470,"d":"470.0"},"普通6"]
[7,2016010694,"谭言  ",83.02627737,90.45892312,84.490178783,82.80000000000001,84.490178783,{"v":0.7931,"d":"79.31%"},0,{"v":515,"d":"515.0"},{"v":437,"d":"437.0"},"普通7"]
[8,2016010709,"任政星   ",81.45912409,85.29374364,82.416135591,83.36,82.416135591,{"v":0.7931,"d":"79.31%"},0,{"v":437,"d":"437.0"},"-","普通8"]
[9,2016010705,"刘波  ",80.76642336,84.96360054,81.92521646,83.96000000000001,81.92521646,{"v":0.6207,"d":"62.07%"},1,{"v":444,"d":"444.0"},"-","助管1"]
[10,2016010718,"郑汪洋   ",79.57591241,85.67666692,81.514472071,86.75999999999999,81.514472071,{"v":0.5862,"d":"58.62%"},0,{"v":457,"d":"457.0"},{"v":348,"d":"348.0"},"辅导员"]
[11,2016010665,"李昆鸿   ",{"v":78.8722627737226,"d":"78.87226277"},{"v":86.3695531767307,"d":"86.36955318"},80.93249457695197,{"v":84.48,"d":"84.48000000"},80.93249457695197,{"v":0.672413793103448,"d":"67.24%"},1,{"v":492,"d":"492.0"},{"v":509,"d":"509.0"},"助管2"]
[12,2016010664,"雷湘杰   ",{"v":79.1277372262774,"d":"79.12773723"},{"v":84.2039956593096,"d":"84.20399566"},80.42221519025611,{"v":81.92,"d":"81.92000000"},80.42221519025611,{"v":0.724137931034483,"d":"72.41%"},0,{"v":429,"d":"429.0"},{"v":289,"d":"289.0"},"双一流1"]

{"sheet":"化工16级保研面试排名","index":1,"n_rows":33,"n_cols":13,"rows_kept":33,"merged":[[0,0,0,12]]}
["化工16级保研面试排名"]
["序号","学号","姓名","必修课成绩","综测成绩","前两项加权成绩","面试成绩","总成绩","优良率","挂科数","四级成绩","六级成绩","备注（类别）"]
[1,2016010411,"崔世彤",{"v":92.8608365019011,"d":"92.860837"},{"v":100,"d":"100.000000"},{"$f":"D3*0.7+E3*0.2","v":{"v":85.00258555133077,"d":"85.002586"}},94.32000000000001,{"$f":"D3*0.7+E3*0.2+G3*0.1","v":94.43458555133077},{"v":0.9818,"d":"98.18%"},0,605,580,"普通1"]
[2,2016010440,"吴艳芬",{"v":92.0921933085502,"d":"92.092193"},{"v":97.07999578507808,"d":"97.079996"},{"v":83.88053447300075,"d":"83.880534"},93.52000000000001,93.23253447300075,{"v":0.9454545454545454,"d":"94.55%"},0,566,527,"普通2"]
[3,2016010601,"何姿颖",{"v":90.4379182156134,"d":"90.437918"},{"v":99.49022193072796,"d":"99.490222"},{"v":83.20458713707497,"d":"83.204587"},94.44,92.64858713707497,{"v":0.9818181818181818,"d":"98.18%"},0,587,568,"普通3"]
[4,2016010431,"张新意",{"v":87.7186311787072,"d":"87.718631"},{"v":98.9924987300253,"d":"98.992499"},{"v":81.20154157110011,"d":"81.201542"},92.07999999999998,90.4095415711001,{"v":0.8727,"d":"87.27%"},0,459,416,"普通4"]
[5,2016010430,"张翔瑞",{"v":87.1966542750929,"d":"87.196654"},{"v":96.17653740054831,"d":"96.176537"},{"v":80.27296547267468,"d":"80.272965"},91.88,89.46096547267469,{"v":0.8181818181818182,"d":"81.82%"},0,465,467,"普通5"]
[6,2016011809,"宋明霞",{"v":88.1847583643123,"d":"88.184758"},{"v":88.56741000628318,"d":"88.567410"},{"v":79.44281285627525,"d":"79.442813"},91.4,88.58281285627525,{"v":0.9272727272727272,"d":"92.73%"},0,503,493,"普通6"]
[7,2016010446,"程小杰",{"v":88.5003802281369,"d":"88.500380"},{"v":84.3067975807097,"d":"84.306798"},{"v":78.81162567583777,"d":"78.811626"},89.32000000000001,87.74362567583778,{"v":0.8727272727272727,"d":"87.27%"},0,462,381,"普通7"]
[8,2016010438,"王璧琮",{"v":88.2273764258555,"d":"88.227376"},{"v":84.22939558027703,"d":"84.229396"},{"v":78.60504261415426,"d":"78.605043"},91.12,87.71704261415425,{"v":0.8909090909090909,"d":"89.09%"},0,488,"-","普通8"]
[9,2016010401,"冯江丽",{"v":88.2243346,"d":"88.224335"},{"v":82.52235860467702,"d":"82.522359"},{"v":78.26150594093541,"d":"78.261506"},90.72,87.33350594093541,{"v":0.9091,"d":"90.91%"},0,553,515,"普通9"]
[10,2016010436,"李昭颐",{"v":87.6349442379182,"d":"87.634944"},{"v":85.95913651275274,"d":"85.959137"},{"v":78.53628826909329,"d":"78.536288"},87.96000000000001,87.3322882690933,{"v":0.8909090909090909,"d":"89.09%"},0,487,486,"普通10"]
[11,2016010545,"李建",{"v":86.2182156133829,"d":"86.218216"},{"v":88.18683783663235,"d":"88.186838"},{"v":77.99011849669449,"d":"77.990118"},89.96,86.98611849669449,{"v":0.8363636363636363,"d":"83.64%"},0,483,"-","普通11"]
[12,2016011085,"徐晴",{"v":87.2130111524163,"d":"87.213011"},{"v":85.73915421479533,"d":"85.739154"},{"v":78.19693864965046,"d":"78.196939"},87.24000000000001,86.92093864965047,{"v":0.8727272727272727,"d":"87.27%"},0,511,479,"普通12"]
[13,2016010400,"丁婉艳",{"v":88.0479087452471,"d":"88.047909"},{"v":81.3131767039938,"d":"81.313177"},{"v":77.89617146247173,"d":"77.896171"},88.16,86.71217146247173,{"v":0.9697,"d":"96.97%"},0,484,431,"普通13"]
[14,2016010432,"左长江",{"v":86.90874525,"d":"86.908745"},{"v":83.65660531,"d":"83.656605"},{"v":77.567442737,"d":"77.567443"},89.28,86.49544273699999,{"v":0.8727,"d":"87.27%"},0,500,430,"普通14"]
[15,2016010406,"盛奕琪",{"v":86.9513307984791,"d":"86.951331"},{"v":81.52529686272537,"d":"81.525297"},{"v":77.17099093148045,"d":"77.170991"},87.16,85.88699093148044,{"v":0.8545,"d":"85.45%"},0,480,459,"普通15"]
[16,2016010452,"刘盛琨",{"v":86.5969581749049,"d":"86.596958"},{"v":82.96080847140443,"d":"82.960808"},{"v":77.21003241671431,"d":"77.210032"},85.72,85.78203241671432,{"v":0.8727272727272727,"d":"87.27%"},0,463,"-","普通16"]
[17,2016010449,"胡浩杰",{"v":86.1026615969582,"d":"86.102662"},{"v":82.47233837483435,"d":"82.472338"},{"v":76.7663307928376,"d":"76.766331"},88.6,85.6263307928376,{"v":0.8545454545454545,"d":"85.45%"},0,504,424,"普通17"]
[18,2016010469,"刘亮",86.875285,80.963598,{"v":77.0054191,"d":"77.005419"},85.88,85.59341909999999,{"v":0.856,"d":"85.60%"},0,436,"-","普通18"]
[19,2016018468,"刘恋",86.960456,79.553962,{"v":76.7831116,"d":"76.783112"},83.96,85.1791116,{"v":0.8727,"d":"87.27%"},0,581,534,"普通19"]
[20,2016011117,"赵金",{"v":85.3163568773234,"d":"85.316357"},{"v":82.98969041868695,"d":"82.989690"},{"v":76.31938789786376,"d":"76.319388"},87.72,85.09138789786377,{"v":0.8181818181818182,"d":"81.82%"},0,543,439,"双一流1"]
[21,2016010142,"常兆恒",{"v":84.5836431226766,"d":"84.583643"},{"v":85.8946880783113,"d":"85.894688"},{"v":76.38748780153588,"d":"76.387488"},84.6,84.84748780153588,{"v":0.7090909090909091,"d":"70.91%"},0,472,469,"普通替补1"]
[22,2016010473,"石韶霏",{"v":84.7330855018587,"d":"84.733086"},{"v":82.95935778711745,"d":"82.959358"},{"v":75.90503140872457,"d":"75.905031"},86.56,84.56103140872457,{"v":0.8181818181818182,"d":"81.82%"},0,575,474,"双一流2"]
[23,2016010426,"张成霄",{"v":85.1695817490494,"d":"85.169582"},{"v":80.5838841562269,"d":"80.583884"},{"v":75.73548405557996,"d":"75.735484"},84.72,84.20748405557995,{"v":0.8909,"d":"89.09%"},0,520,456,"双一流3"]
[24,2016010666,"孟诗涵",{"v":83.7434944237918,"d":"83.743494"},{"v":82.9321984952329,"d":"82.932198"},{"v":75.20688579570083,"d":"75.206886"},89.6,84.16688579570082,{"v":0.7636363636363637,"d":"76.36%"},0,606,506,"双一流4"]
[25,2016010425,"袁俊涛",{"v":84.9391634980989,"d":"84.939163"},{"v":79.23365653087397,"d":"79.233657"},{"v":75.30414575484403,"d":"75.304146"},82.6,83.56414575484403,{"v":0.8,"d":"80.00%"},0,494,406,"双一流5"]
[26,2016010455,"司道润",{"v":84.4486692,"d":"84.448669"},{"v":78.62540199,"d":"78.625402"},{"v":74.839148838,"d":"74.839149"},86.96,83.535148838,{"v":0.8,"d":"80%"},0,498,496,"双一流6"]
[27,2016010456,"苏小刚",{"v":85.1368821292776,"d":"85.136882"},{"v":80.14742073608608,"d":"80.147421"},{"v":75.62530163771153,"d":"75.625302"},78.24000000000001,83.44930163771153,{"v":0.8545454545454545,"d":"85.45%"},0,425,333,"双一流7"]
[28,2016010876,"杨鸿伟",{"v":83.8687732342008,"d":"83.868773"},{"v":80.37903825682737,"d":"80.379038"},{"v":74.78394891530603,"d":"74.783949"},84.92,83.27594891530603,{"v":0.7272727272727273,"d":"72.73%"},0,529,"-","双一流8"]
[29,2016010690,"高灿",{"v":81.8550185873606,"d":"81.855019"},{"v":86.58348168318798,"d":"86.583482"},{"v":74.61520934779001,"d":"74.615209"},84.03999999999999,83.01920934779001,{"v":0.7272727272727273,"d":"72.73%"},0,577,487,"普通替补2"]
[30,2016010403,"刘婉琪",{"v":83.2684410646388,"d":"83.268441"},{"v":79.69372997950217,"d":"79.693730"},{"v":74.22665474114758,"d":"74.226655"},87.84,83.01065474114759,{"v":0.6909,"d":"69.09%"},0,557,456,"助管1"]
[31,2016010480,"焦晓宇",79.022053,78.536372,{"v":71.0227115,"d":"71.022712"},77.92,78.8147115,{"v":0.5818,"d":"58.18%"},0,451,"-","辅导员待定"]

{"sheet":"环工16级保研面试排名","index":2,"n_rows":18,"n_cols":13,"rows_kept":18,"merged":[[0,0,0,12]]}
["环工16级保研面试排名"]
["序号","学号","姓名","必修课成绩","综测成绩","前两项加权成绩","面试成绩","总成绩","优良率","挂科数","四级成绩","六级成绩","备注（类别）"]
[1,2016010604,"刘雅",{"v":65.3826923076923,"d":"65.38269231"},20,85.3826923076923,89.6,{"$f":"F3+G3*0.1","v":94.34269230769229},{"v":1,"d":"100.00%"},0,545,466,"普通1"]
[2,2016010602,"李异繁",{"v":64.0139230769231,"d":"64.01392308"},18.5905338690827,82.6044569460058,{"v":90,"d":"90.0"},91.6044569460058,{"v":0.96,"d":"96.00%"},0,633,567,"普通2"]
[3,2016010614,"仲英杰",{"v":62.2784615384615,"d":"62.27846154"},{"v":18.2173029657362,"d":"18.21730297"},{"v":80.4957645041978,"d":"80.49576450"},88.4,89.3357645041978,{"v":0.92,"d":"92.00%"},0,518,470,"普通3"]
[4,2016010622,"李佳奇",{"v":62.4814615384616,"d":"62.48146154"},{"v":16.7176395754621,"d":"16.71763958"},{"v":79.1991011139236,"d":"79.19910111"},{"v":87,"d":"87.0"},87.8991011139236,{"v":0.96,"d":"96.00%"},0,541,451,"普通4"]
[5,2016010617,"陈闯",{"v":60.739,"d":"60.73900000"},18.0592683709962,78.7982683709962,{"v":85,"d":"85.0"},87.2982683709962,{"v":0.88,"d":"88.00%"},0,427,"-","普通5"]
[6,2016010607,"齐泽丰",{"v":59.9221538461539,"d":"59.92215385"},{"v":17.9477420609835,"d":"17.94774206"},{"v":77.8698959071374,"d":"77.86989591"},86.6,86.5298959071374,{"v":0.82,"d":"82.00%"},0,535,428,"普通6"]
[7,2016010599,"程诗宇",{"v":60.3906153846154,"d":"60.39061538"},16.8752698891574,77.2658852737728,86.6,85.92588527377279,{"v":0.88,"d":"88.00%"},0,470,"-","普通7"]
[8,2016010613,"余美琪",{"v":60.3653076923077,"d":"60.36530769"},15.9438496939013,76.309157386209,88.8,85.18915738620899,{"v":0.82,"d":"82.00%"},0,499,436,"普通8"]
[9,2016010637,"刘姝羽",{"v":60.1854615384615,"d":"60.18546154"},{"v":15.9758917995127,"d":"15.97589180"},{"v":76.1613533379742,"d":"76.16135334"},89.8,85.14135333797421,{"v":0.78,"d":"78.00%"},0,517,463,"双一流1"]
[10,2016010603,"刘涵钰",{"v":60.0260769230769,"d":"60.02607692"},16.0673857865631,76.09346270964,87.8,84.87346270964,{"v":0.86,"d":"86.00%"},0,429,"-","双一流2"]
[11,2016010612,"游恋",{"v":60.1461538461539,"d":"60.14615385"},16.4104395382572,76.5565933844111,{"v":82,"d":"82.0"},84.7565933844111,{"v":0.86,"d":"86.00%"},0,"-","-","双一流3"]
[12,2016010608,"任玥辉",{"v":59.4682307692308,"d":"59.46823077"},16.3486387621763,75.816869531407,86.4,84.456869531407,{"v":0.84,"d":"84.00%"},0,519,"-","辅导员"]
[13,2016010635,"李昕",{"v":59.1823076923077,"d":"59.18230769"},{"v":15.8519693589563,"d":"15.85196936"},{"v":75.034277051264,"d":"75.03427705"},89.4,83.974277051264,{"v":0.8,"d":"80.00%"},0,539,480,"候补普通1"]
[14,2016010638,"陆文懿",{"v":57.9384615384615,"d":"57.93846154"},15.6874791736478,73.6259407121093,88.8,82.5059407121093,{"v":0.7,"d":"70.00%"},0,534,551,"双一流4"]
[15,2016010647,"郭全弟",{"v":58.0186923076923,"d":"58.01869231"},15.1181007282325,73.1367930359248,86.6,81.7967930359248,{"v":0.72,"d":"72.00%"},0,541,362,"候补普通2"]
[16,2016010629,"边泽晨",{"v":57.1878461538461,"d":"57.18784615"},15.1431422014546,72.3309883553007,{"v":89,"d":"89.0"},81.23098835530071,{"v":0.7,"d":"70.00%"},0,543,445,"助管1"]

{"sheet":"环科16级保研面试排名","index":3,"n_rows":12,"n_cols":13,"rows_kept":12,"merged":[[0,0,0,12]]}
["环科16级保研面试排名"]
["序号","学号","姓名","必修课成绩","综测成绩","前两项加权成绩","面试成绩","总成绩","优良率(%)","挂科数","四级成绩","六级成绩","备注（类别）"]
[1,2016010132,"郭超洁",90.3024193548387,98.5728076505449,{"$f":"D3*0.7+E3*0.2","v":82.92625507849607},91.2,{"$f":"F3+G3*0.1","v":92.04625507849607},{"v":97.9166666666667,"d":"97.92"},0,555,606,"普通1"]
[2,2016010130,"段练",88.4200787401575,99.2794495278788,81.74994502368601,89.2,90.66994502368601,{"v":95.9183673469388,"d":"95.92"},0,551,464,"普通2"]
[3,2016010138,"麻晓梅",86.1929133858268,92.1411013981974,78.76325964971824,89,87.66325964971824,{"v":87.7551020408163,"d":"87.76"},0,511,439,"普通3"]
[4,2016010139,"孙霄",85.6653543307087,91.5188016974778,78.26950837099164,89.4,87.20950837099164,{"v":89.7959183673469,"d":"89.80"},0,545,530,"普通4"]
[5,2016010141,"尹舒慧",85.503937007874,90.0705606535544,77.86686803622268,88.8,86.74686803622268,{"v":83.6734693877551,"d":"83.67"},0,505,446,"普通5"]
[6,2016010163,"刘改过",83.642125984252,89.5357930904156,76.45664680705951,84.4,84.89664680705951,{"v":77.5510204081633,"d":"77.55"},0,474,390,"普通6"]
[7,2016010165,"尚青",82.8393700787402,88.1206018401129,75.61167942314071,87.4,84.35167942314071,{"v":79.5918367346939,"d":"79.59"},0,470,364,"普通7"]
[8,2016010174,"刘靖",82.8088976377953,86.8009052162058,75.32640938969786,85.6,83.88640938969786,{"v":77.5510204081633,"d":"77.55"},0,467,441,"双一流1"]
[9,2016010140,"王明洋",80.4763779527559,87.7096065522263,73.87538587737438,87.4,82.61538587737438,{"v":69.3877551020408,"d":"69.39"},1,443,"- ","助管1"]
[10,2016010161,"李梦扬",79.5472440944882,86.436019990259,72.97027486419354,86.2,81.59027486419355,{"v":65.3061224489796,"d":"65.31"},1,492,375,"助管2"]