{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["公示"],"read":"whole","date_system":"1900"}

{"sheet":"公示","index":0,"n_rows":34,"n_cols":12,"rows_kept":34,"merged":[[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[1,10,2,10],[1,11,2,11],[27,0,27,1]]}
[]
["学号","绩点","总加分","总绩点\n（原始为4位）","权重1\n（取5位）","笔试成绩","面试成绩","考试平均成绩","折合绩点\n（取8位）","权重2\n（取9位）","总成绩\n（取9位）","合成百分制总成绩"]
[]
["2200015107","3.856",0.0424,{"$f":"B4+C4","v":3.8984},{"$f":"D4*90%","v":3.50856},73,85.8,{"$f":"AVERAGE(F4:G4)","v":79.4},{"$f":"4-3*(100-H4)*(100-H4)/1600","v":{"v":3.204325,"d":"3.20432500"}},{"$f":"I4*10%","v":{"v":0.3204325,"d":"0.320432500"}},{"$f":"E4+J4","v":{"v":3.8289925,"d":"3.828992500"}},{"$f":"100-SQRT((4-K4)*1600/3)","v":{"v":90.4499214662915,"d":"90.45"}}]
["2200015135","3.834",0.0164,{"$f":"B5+C5","v":3.8504},{"$f":"D5*90%","v":3.46536},78,94,{"$f":"AVERAGE(F5:G5)","v":86},{"$f":"4-3*(100-H5)*(100-H5)/1600","v":{"v":3.6325,"d":"3.63250000"}},{"$f":"I5*10%","v":{"v":0.36325,"d":"0.363250000"}},{"$f":"E5+J5","v":{"v":3.82861,"d":"3.828610000"}},{"$f":"100-SQRT((4-K5)*1600/3)","v":{"v":90.4392468915885,"d":"90.44"}}]
["2200015166","3.820",0.023,{"$f":"B6+C6","v":{"v":3.843,"d":"3.8430"}},{"$f":"D6*90%","v":3.4587},84,81.4,{"$f":"AVERAGE(F6:G6)","v":82.7},{"$f":"4-3*(100-H6)*(100-H6)/1600","v":3.43883125},{"$f":"I6*10%","v":0.343883125},{"$f":"E6+J6","v":3.802583125},{"$f":"100-SQRT((4-K6)*1600/3)","v":{"v":89.7389571680067,"d":"89.74"}}]
["2200015140","3.801",0.0364,{"$f":"B7+C7","v":3.8374},{"$f":"D7*90%","v":3.45366},71,90,{"$f":"AVERAGE(F7:G7)","v":80.5},{"$f":"4-3*(100-H7)*(100-H7)/1600","v":3.28703125},{"$f":"I7*10%","v":0.328703125},{"$f":"E7+J7","v":3.782363125},{"$f":"100-SQRT((4-K7)*1600/3)","v":{"v":89.2262819788153,"d":"89.23"}}]
["2200015128","3.792",0.012,{"$f":"B8+C8","v":{"v":3.804,"d":"3.8040"}},{"$f":"D8*90%","v":3.4236},79,88.8,{"$f":"AVERAGE(F8:G8)","v":83.9},{"$f":"4-3*(100-H8)*(100-H8)/1600","v":3.51398125},{"$f":"I8*10%","v":0.351398125},{"$f":"E8+J8","v":3.774998125},{"$f":"100-SQRT((4-K8)*1600/3)","v":{"v":89.0455032064453,"d":"89.05"}}]
["2200015167","3.759",0.0427,{"$f":"B9+C9","v":3.8017},{"$f":"D9*90%","v":3.42153},81,87.2,{"$f":"AVERAGE(F9:G9)","v":84.1},{"$f":"4-3*(100-H9)*(100-H9)/1600","v":3.52598125},{"$f":"I9*10%","v":0.352598125},{"$f":"E9+J9","v":3.774128125},{"$f":"100-SQRT((4-K9)*1600/3)","v":{"v":89.024345122044,"d":"89.02"}}]
["2200015150","3.830",0.014,{"$f":"B10+C10","v":{"v":3.844,"d":"3.8440"}},{"$f":"D10*90%","v":3.4596},72,84.2,{"$f":"AVERAGE(F10:G10)","v":78.1},{"$f":"4-3*(100-H10)*(100-H10)/1600","v":3.10073125},{"$f":"I10*10%","v":0.310073125},{"$f":"E10+J10","v":3.769673125},{"$f":"100-SQRT((4-K10)*1600/3)","v":{"v":88.9166340852609,"d":"88.92"}}]
["2200015171","3.808",0.028,{"$f":"B11+C11","v":{"v":3.836,"d":"3.8360"}},{"$f":"D11*90%","v":3.4524},67,90.4,{"$f":"AVERAGE(F11:G11)","v":78.7},{"$f":"4-3*(100-H11)*(100-H11)/1600","v":3.14933125},{"$f":"I11*10%","v":0.314933125},{"$f":"E11+J11","v":3.767333125},{"$f":"100-SQRT((4-K11)*1600/3)","v":{"v":88.8604757731759,"d":"88.86"}}]
["2200015125","3.743",0.043,{"$f":"B12+C12","v":{"v":3.786,"d":"3.7860"}},{"$f":"D12*90%","v":3.4074},78,85.8,{"$f":"AVERAGE(F12:G12)","v":81.9},{"$f":"4-3*(100-H12)*(100-H12)/1600","v":3.38573125},{"$f":"I12*10%","v":0.338573125},{"$f":"E12+J12","v":3.745973125},{"$f":"100-SQRT((4-K12)*1600/3)","v":{"v":88.3603694216698,"d":"88.36"}}]
["2200015159","3.771",0.031,{"$f":"B13+C13","v":{"v":3.802,"d":"3.8020"}},{"$f":"D13*90%","v":3.4218},74,85.6,{"$f":"AVERAGE(F13:G13)","v":79.8},{"$f":"4-3*(100-H13)*(100-H13)/1600","v":{"v":3.234925,"d":"3.23492500"}},{"$f":"I13*10%","v":{"v":0.3234925,"d":"0.323492500"}},{"$f":"E13+J13","v":{"v":3.7452925,"d":"3.745292500"}},{"$f":"100-SQRT((4-K13)*1600/3)","v":{"v":88.3447865742407,"d":"88.34"}}]
["2200017413","3.722",0,{"$f":"B14+C14","v":{"v":3.722,"d":"3.7220"}},{"$f":"D14*90%","v":3.3498},87,86.2,{"$f":"AVERAGE(F14:G14)","v":86.6},{"$f":"4-3*(100-H14)*(100-H14)/1600","v":{"v":3.663325,"d":"3.66332500"}},{"$f":"I14*10%","v":{"v":0.3663325,"d":"0.366332500"}},{"$f":"E14+J14","v":{"v":3.7161325,"d":"3.716132500"}},{"$f":"100-SQRT((4-K14)*1600/3)","v":{"v":87.695691811402,"d":"87.70"}}]
["2200015146","3.751",0.02,{"$f":"B15+C15","v":{"v":3.771,"d":"3.7710"}},{"$f":"D15*90%","v":3.3939},69,86.8,{"$f":"AVERAGE(F15:G15)","v":77.9},{"$f":"4-3*(100-H15)*(100-H15)/1600","v":3.08423125},{"$f":"I15*10%","v":0.308423125},{"$f":"E15+J15","v":3.702323125},{"$f":"100-SQRT((4-K15)*1600/3)","v":{"v":87.3999603175228,"d":"87.40"}}]
["2200015162","3.752",0.019,{"$f":"B16+C16","v":{"v":3.771,"d":"3.7710"}},{"$f":"D16*90%","v":3.3939},74,76,{"$f":"AVERAGE(F16:G16)","v":75},{"$f":"4-3*(100-H16)*(100-H16)/1600","v":{"v":2.828125,"d":"2.82812500"}},{"$f":"I16*10%","v":{"v":0.2828125,"d":"0.282812500"}},{"$f":"E16+J16","v":{"v":3.6767125,"d":"3.676712500"}},{"$f":"100-SQRT((4-K16)*1600/3)","v":{"v":86.8691203645757,"d":"86.87"}}]
["2200015104","3.694",0.037,{"$f":"B17+C17","v":{"v":3.731,"d":"3.7310"}},{"$f":"D17*90%","v":3.3579},72,85,{"$f":"AVERAGE(F17:G17)","v":78.5},{"$f":"4-3*(100-H17)*(100-H17)/1600","v":3.13328125},{"$f":"I17*10%","v":0.313328125},{"$f":"E17+J17","v":3.671228125},{"$f":"100-SQRT((4-K17)*1600/3)","v":{"v":86.758210090777,"d":"86.76"}}]
["2200015129","3.722",0,{"$f":"B18+C18","v":{"v":3.722,"d":"3.7220"}},{"$f":"D18*90%","v":3.3498},67,89.2,{"$f":"AVERAGE(F18:G18)","v":78.1},{"$f":"4-3*(100-H18)*(100-H18)/1600","v":3.10073125},{"$f":"I18*10%","v":0.310073125},{"$f":"E18+J18","v":3.659873125},{"$f":"100-SQRT((4-K18)*1600/3)","v":{"v":86.5314811504754,"d":"86.53"}}]
["2200015152","3.749",0.0084,{"$f":"B19+C19","v":3.7574},{"$f":"D19*90%","v":3.38166},64,84.6,{"$f":"AVERAGE(F19:G19)","v":74.3},{"$f":"4-3*(100-H19)*(100-H19)/1600","v":2.76158125},{"$f":"I19*10%","v":0.276158125},{"$f":"E19+J19","v":3.657818125},{"$f":"100-SQRT((4-K19)*1600/3)","v":{"v":86.4908549493315,"d":"86.49"}}]
["2200015176","3.708",0.026,{"$f":"B20+C20","v":{"v":3.734,"d":"3.7340"}},{"$f":"D20*90%","v":3.3606},69,75.8,{"$f":"AVERAGE(F20:G20)","v":72.4},{"$f":"4-3*(100-H20)*(100-H20)/1600","v":{"v":2.5717,"d":"2.57170000"}},{"$f":"I20*10%","v":{"v":0.25717,"d":"0.257170000"}},{"$f":"E20+J20","v":{"v":3.61777,"d":"3.617770000"}},{"$f":"100-SQRT((4-K20)*1600/3)","v":{"v":85.7221850411206,"d":"85.72"}}]
["2200015157","3.591",0.048,{"$f":"B21+C21","v":{"v":3.639,"d":"3.6390"}},{"$f":"D21*90%","v":3.2751},74,87,{"$f":"AVERAGE(F21:G21)","v":80.5},{"$f":"4-3*(100-H21)*(100-H21)/1600","v":3.28703125},{"$f":"I21*10%","v":0.328703125},{"$f":"E21+J21","v":3.603803125},{"$f":"100-SQRT((4-K21)*1600/3)","v":{"v":85.4636662118676,"d":"85.46"}}]
["2200015102","3.701",0.0234,{"$f":"B22+C22","v":3.7244},{"$f":"D22*90%","v":3.35196},60,80.2,{"$f":"AVERAGE(F22:G22)","v":70.1},{"$f":"4-3*(100-H22)*(100-H22)/1600","v":2.32373125},{"$f":"I22*10%","v":0.232373125},{"$f":"E22+J22","v":3.584333125},{"$f":"100-SQRT((4-K22)*1600/3)","v":{"v":85.1107757085871,"d":"85.11"}}]
["2200016643","3.607",0.008,{"$f":"B23+C23","v":{"v":3.615,"d":"3.6150"}},{"$f":"D23*90%","v":3.2535},61,82.8,{"$f":"AVERAGE(F23:G23)","v":71.9},{"$f":"4-3*(100-H23)*(100-H23)/1600","v":2.51948125},{"$f":"I23*10%","v":0.251948125},{"$f":"E23+J23","v":3.505448125},{"$f":"100-SQRT((4-K23)*1600/3)","v":{"v":83.7592795726298,"d":"83.76"}}]
["2100015130","3.581",0.037,{"$f":"B24+C24","v":{"v":3.618,"d":"3.6180"}},{"$f":"D24*90%","v":3.2562},62,77.6,{"$f":"AVERAGE(F24:G24)","v":69.8},{"$f":"4-3*(100-H24)*(100-H24)/1600","v":{"v":2.289925,"d":"2.28992500"}},{"$f":"I24*10%","v":{"v":0.2289925,"d":"0.228992500"}},{"$f":"E24+J24","v":{"v":3.4851925,"d":"3.485192500"}},{"$f":"100-SQRT((4-K24)*1600/3)","v":{"v":83.4300271575358,"d":"83.43"}}]
[]
[]
[]
["院外排队名单（普通项目）"]
["推免申请ID","笔试成绩","面试成绩","平均分"]
["SQ202525054",72,92.2,{"$f":"AVERAGE(B30:C30)","v":82.1}]
["SQ202511436",74,88.6,{"$f":"AVERAGE(B31:C31)","v":81.3}]
["SQ202517551",77,80.4,{"$f":"AVERAGE(B32:C32)","v":78.7}]
["SQ202526155",60,89.6,{"$f":"AVERAGE(B33:C33)","v":74.8}]
["SQ202510853",50,88.2,{"$f":"AVERAGE(B34:C34)","v":69.1}]