{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["保送考试排队"],"read":"whole","date_system":"1900"}

{"sheet":"保送考试排队","index":0,"n_rows":47,"n_cols":253,"rows_kept":47,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4],[0,5,1,5],[0,6,1,6],[0,7,1,7],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12]]}
["学号","绩点","总加分","总绩点\n（原始为4位）","权重1（取5位）","笔试成绩","面试成绩","考试平均成绩","折合绩点取8位","权重2取9位","总成绩取9位","合成百分制总成绩","总成绩排名"]
[]
["2100015119",3.865,{"v":0.032,"d":"0.0320"},{"$f":"B3+C3","v":{"v":3.897,"d":"3.8970"}},{"$f":"D3*90%","v":3.5073},84,91.6,{"$f":"AVERAGE(F3:G3)","v":87.8},{"$f":"4-3*(100-H3)*(100-H3)/1600","v":{"v":3.720925,"d":"3.72092500"}},{"$f":"I3*10%","v":{"v":0.3720925,"d":"0.372092500"}},{"$f":"E3+J3","v":{"v":3.8793925,"d":"3.879392500"}},{"$f":"100-SQRT((4-K3)*1600/3)","v":{"v":91.9797755642376,"d":"91.98"}},1]
["2100015162",3.774,{"v":0.037,"d":"0.0370"},{"v":3.811,"d":"3.8110"},3.4299,88,90.6,89.3,3.78533125,0.378533125,3.808433125,{"v":89.8921317776694,"d":"89.89"},2]
["2100015126",3.782,{"v":0.024,"d":"0.0240"},{"v":3.806,"d":"3.8060"},3.4254,87,91.6,89.3,3.78533125,0.378533125,3.803933125,{"v":89.774101506469,"d":"89.77"},3]
["2100015174",3.794,0.0233,3.8173,3.43557,78,88.6,83.3,3.47708125,0.347708125,3.783278125,{"v":89.248953539306,"d":"89.25"},4]
["2100015123",3.794,0.0297,3.8237,3.44133,80,81.8,80.9,3.31598125,0.331598125,3.772928125,{"v":88.995228307684,"d":"89.00"},5]
[2100015109,3.721,0.0447,3.7657,3.38913,85,94.2,89.6,{"v":3.7972,"d":"3.79720000"},{"v":0.37972,"d":"0.379720000"},{"v":3.76885,"d":"3.768850000"},{"v":88.8968472945744,"d":"88.90"},6]
["2100015149",3.771,0.0177,3.7887,3.40983,83,86.6,84.8,{"v":3.5668,"d":"3.56680000"},{"v":0.35668,"d":"0.356680000"},{"v":3.76651,"d":"3.766510000"},{"v":88.8407885583255,"d":"88.84"},7]
["2100015156",3.724,0.0347,3.7587,3.38283,88,85.8,86.9,3.67823125,0.367823125,3.750653125,{"v":88.4680877561438,"d":"88.47"},8]
["2100015139",3.73,{"v":0.022,"d":"0.0220"},{"v":3.752,"d":"3.7520"},3.3768,88,86.8,87.4,{"v":3.702325,"d":"3.70232500"},{"v":0.3702325,"d":"0.370232500"},{"v":3.7470325,"d":"3.747032500"},{"v":88.384665308309,"d":"88.38"},9]
[2100015105,3.702,{"v":0.03,"d":"0.0300"},{"v":3.732,"d":"3.7320"},3.3588,85,91.2,88.1,3.73448125,0.373448125,3.732248125,{"v":88.0500627616711,"d":"88.05"},10]
["2100015167",3.735,0.0037,3.7387,3.36483,82,90.8,86.4,{"v":3.6532,"d":"3.65320000"},{"v":0.36532,"d":"0.365320000"},{"v":3.73015,"d":"3.730150000"},{"v":88.0033337964249,"d":"88.00"},11]
["2100015121",3.719,{"v":0.006,"d":"0.0060"},{"v":3.725,"d":"3.7250"},3.3525,93,82.8,87.9,3.72548125,0.372548125,3.725048125,{"v":87.8904583075989,"d":"87.89"},12]
[2100015107,3.7,0.0037,3.7037,3.33333,91,87.6,89.3,3.78533125,0.378533125,3.711863125,{"v":87.6035085608871,"d":"87.60"},13]
["2100015145",3.72,{"v":0.017,"d":"0.0170"},{"v":3.737,"d":"3.7370"},3.3633,85,81.6,83.3,3.47708125,0.347708125,3.711008125,{"v":87.5851298838852,"d":"87.59"},14]
["2100015166",3.684,{"v":0.031,"d":"0.0310"},{"v":3.715,"d":"3.7150"},3.3435,88,84.6,86.3,3.64808125,0.364808125,3.708308125,{"v":87.5272697455609,"d":"87.53"},15]
["2100015120",3.696,{"v":0.018,"d":"0.0180"},{"v":3.714,"d":"3.7140"},3.3426,78,91.4,84.7,3.56108125,0.356108125,3.698708125,{"v":87.3236835003223,"d":"87.32"},16]
["2100015165",3.775,{"v":0.006,"d":"0.0060"},{"v":3.781,"d":"3.7810"},3.4029,64,88.2,76.1,2.92898125,0.292898125,3.695798125,{"v":87.2626140829446,"d":"87.26"},17]
["2100015169",3.656,{"v":0.023,"d":"0.0230"},{"v":3.679,"d":"3.6790"},3.3111,87,84,85.5,3.60578125,0.360578125,3.671678125,{"v":86.767275412826,"d":"86.77"},18]
["2100015134",3.661,{"v":0.035,"d":"0.0350"},{"v":3.696,"d":"3.6960"},3.3264,79,84.4,81.7,3.37208125,0.337208125,3.663608125,{"v":86.6056355133959,"d":"86.61"},19]
["2100015153",3.671,0.0177,3.6887,3.31983,80,85.2,82.6,{"v":3.432325,"d":"3.43232500"},{"v":0.3432325,"d":"0.343232500"},{"v":3.6630625,"d":"3.663062500"},{"v":86.5947771372498,"d":"86.59"},20]
["2100015157",3.664,{"v":0.007,"d":"0.0070"},{"v":3.671,"d":"3.6710"},3.3039,80,84.8,82.4,{"v":3.4192,"d":"3.41920000"},{"v":0.34192,"d":"0.341920000"},{"v":3.64582,"d":"3.645820000"},{"v":86.2560558790426,"d":"86.26"},21]
["2100015140",3.618,{"v":0.034,"d":"0.0340"},{"v":3.652,"d":"3.6520"},3.2868,87,78.2,82.6,{"v":3.432325,"d":"3.43232500"},{"v":0.3432325,"d":"0.343232500"},{"v":3.6300325,"d":"3.630032500"},{"v":85.9530786291088,"d":"85.95"},22]
["2100015175",3.632,{"v":0.014,"d":"0.0140"},{"v":3.646,"d":"3.6460"},3.2814,72,86.2,79.1,3.18098125,0.318098125,3.599498125,{"v":85.3849050635995,"d":"85.38"},23]
["2100015150",3.624,{"v":0.013,"d":"0.0130"},{"v":3.637,"d":"3.6370"},3.2733,80,76.2,78.1,3.10073125,0.310073125,3.583373125,{"v":85.0935919819696,"d":"85.09"},24]
["2100015133",3.602,{"v":0.026,"d":"0.0260"},{"v":3.628,"d":"3.6280"},3.2652,83,70.6,76.8,{"v":2.9908,"d":"2.99080000"},{"v":0.29908,"d":"0.299080000"},{"v":3.56428,"d":"3.564280000"},{"v":84.7558535824402,"d":"84.76"},25]
[2000014801,3.565,{"v":0.008,"d":"0.0080"},{"v":3.573,"d":"3.5730"},3.2157,80,72,76,{"v":2.92,"d":"2.92000000"},{"v":0.292,"d":"0.292000000"},{"v":3.5077,"d":"3.507700000"},{"v":83.7962967195767,"d":"83.80"},26]
["2100015170",3.522,{"v":0.006,"d":"0.0060"},{"v":3.528,"d":"3.5280"},3.1752,80,78,79,{"v":3.173125,"d":"3.17312500"},{"v":0.3173125,"d":"0.317312500"},{"v":3.4925125,"d":"3.492512500"},{"v":83.5482523724681,"d":"83.55"},27]
["2100015117",3.544,{"v":0.036,"d":"0.0360"},{"v":3.58,"d":"3.5800"},3.222,74,73,73.5,2.68328125,0.268328125,3.490328125,{"v":83.5128838179626,"d":"83.51"},28]
["2100015172",3.519,{"v":0.008,"d":"0.0080"},{"v":3.527,"d":"3.5270"},3.1743,61,90.4,75.7,2.89283125,0.289283125,3.463583125,{"v":83.0858343392291,"d":"83.09"},29]
[2000015161,3.511,{"v":0.007,"d":"0.0070"},{"v":3.518,"d":"3.5180"},3.1662,69,84.2,76.6,{"v":2.973325,"d":"2.97332500"},{"v":0.2973325,"d":"0.297332500"},{"v":3.4635325,"d":"3.463532500"},{"v":83.0850362105028,"d":"83.09"},30]
["2100015110",3.385,{"v":0.048,"d":"0.0480"},{"v":3.433,"d":"3.4330"},3.0897,61,75.6,68.3,2.11583125,0.211583125,3.301283125,{"v":80.6958812684961,"d":"80.70"},31]
[2000015160,3.266,{"v":0,"d":"0.0000"},{"v":3.266,"d":"3.2660"},2.9394,75,86.6,80.8,{"v":3.3088,"d":"3.30880000"},{"v":0.33088,"d":"0.330880000"},{"v":3.27028,"d":"3.270280000"},{"v":80.2722530429854,"d":"80.27"},32]
[1800015101,3.076,{"v":0,"d":"0.0000"},{"v":3.076,"d":"3.0760"},2.7684,83,83,83,{"v":3.458125,"d":"3.45812500"},{"v":0.3458125,"d":"0.345812500"},{"v":3.1142125,"d":"3.114212500"},{"v":78.2647751334383,"d":"78.26"},33]
[]
[]
["院外成绩排名"]
[]
["推免申请ID","笔试","面试","平均分","排名",{"$nulls":124},"姓名","笔试","面试","平均分",{"$nulls":4},"姓名","笔试","面试","平均分",{"$nulls":4},"姓名","笔试","面试","平均分",{"$nulls":4},"姓名","笔试","面试","平均分",{"$nulls":4},"姓名","笔试","面试","平均分",{"$nulls":4},"姓名","笔试","面试","平均分",{"$nulls":4},"姓名","笔试","面试","平均分",{"$nulls":4},"姓名","笔试","面试","平均分",{"$nulls":4},"姓名","笔试","面试","平均分",{"$nulls":4},"姓名","笔试","面试","平均分",{"$nulls":4},"姓名","笔试","面试","平均分",{"$nulls":4},"姓名","笔试","面试","平均分",{"$nulls":4},"姓名","笔试","面试","平均分",{"$nulls":4},"姓名","笔试","面试","平均分",{"$nulls":4},"姓名","笔试","面试","平均分",{"$nulls":4},"姓名","笔试","面试","平均分"]
["SQ202433329",93,90.2,{"$f":"AVERAGE(B41:C41)","v":91.6},1,{"$nulls":124},"哈哈哈",88,null,{"$f":"AVERAGE(EA41:EB41)","v":88},{"$nulls":4},"哈哈哈",88,null,{"$f":"AVERAGE(EI41:EJ41)","v":88},{"$nulls":4},"哈哈哈",88,null,{"$f":"AVERAGE(EQ41:ER41)","v":88},{"$nulls":4},"哈哈哈",88,null,{"$f":"AVERAGE(EY41:EZ41)","v":88},{"$nulls":4},"哈哈哈",88,null,{"$f":"AVERAGE(FG41:FH41)","v":88},{"$nulls":4},"哈哈哈",88,null,{"$f":"AVERAGE(FO41:FP41)","v":88},{"$nulls":4},"哈哈哈",88,null,{"$f":"AVERAGE(FW41:FX41)","v":88},{"$nulls":4},"哈哈哈",88,null,{"$f":"AVERAGE(GE41:GF41)","v":88},{"$nulls":4},"哈哈哈",88,null,{"$f":"AVERAGE(GM41:GN41)","v":88},{"$nulls":4},"哈哈哈",88,null,{"$f":"AVERAGE(GU41:GV41)","v":88},{"$nulls":4},"哈哈哈",88,null,{"$f":"AVERAGE(HC41:HD41)","v":88},{"$nulls":4},"哈哈哈",88,null,{"$f":"AVERAGE(HK41:HL41)","v":88},{"$nulls":4},"哈哈哈",88,null,{"$f":"AVERAGE(HS41:HT41)","v":88},{"$nulls":4},"哈哈哈",88,null,{"$f":"AVERAGE(IA41:IB41)","v":88},{"$nulls":4},"哈哈哈",88,null,{"$f":"AVERAGE(II41:IJ41)","v":88},{"$nulls":4},"哈哈哈",88,null,{"$f":"AVERAGE(IQ41:IR41)","v":88}]
["SQ202435969",83,90.4,86.7,2,{"$nulls":127},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"}]
["SQ202449073",83,86.8,84.9,3,{"$nulls":127},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"}]
["SQ202441238",81,85.2,83.1,4,{"$nulls":127},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"}]
["SQ202453083",78,82.2,80.1,5,{"$nulls":127},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"}]
["SQ202458285",71,82.4,76.7,6,{"$nulls":127},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"}]
["SQ202457551",70,74.6,72.3,7,{"$nulls":127},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"},{"$nulls":7},{"$error":"#DIV/0!"}]