{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["计数统计表","工艺学硕","工艺专硕","工程学硕 ","工程专硕","催化学硕","催化专硕","环境学硕","环境专硕","国际班"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"计数统计表","index":0,"n_rows":2,"n_cols":11,"rows_kept":2}
["方向","工艺学硕","工艺专硕","催化学硕","催化专硕","工程学硕","工程专硕","环境学硕","环境专硕","国际班","总计"]
["人数",63,36,36,20,48,28,31,13,22,{"$f":"SUM(B2:J2)","v":297}]

{"sheet":"工艺学硕","index":1,"n_rows":65,"n_cols":25,"rows_kept":65,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,0,9],[0,10,0,15],[0,16,0,21],[0,22,1,22],[0,23,1,23]]}
["序号","学号","姓名","方向","德育成绩",{"$nulls":5},"智育成绩",{"$nulls":5},"文体成绩",{"$nulls":5},"总分","排名"]
[{"$nulls":4},"基础分","奖励分","惩罚分","个人德育总分","个人德育总分/基准","德育总成绩","基础分","奖励分","惩罚分","个人智育总分","个人智育总分/基准","智育总成绩","基础分","奖励分","惩罚分","个人文体总分","个人文体总分/基准","文体总成绩"]
[1,2022210594,"王新茹","工艺学硕","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","助管"]
[2,2022210520,"倪鹏磊","工艺学硕","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","兼职辅导员"]
[3,2022210551,"张欣颖","工艺学硕","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","助管"]
[4,2021210601,"邱皓月","工艺学硕","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","助管"]
[5,2021210638,"马雯妍","工艺学硕","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","助管"]
[6,2022210521,"乔亮","工艺学硕",97.5134375,11.3,0,{"$f":"E8+F8+G8","v":108.81343749999999},{"$f":"H8/117.44","v":0.9265449378405994},{"$f":"100*H8/117.44","v":92.65449378405995},92.84,6.8,0,{"$f":"K8+L8+M8","v":99.64},{"$f":"N8/99.64","v":1},{"$f":"100*N8/99.64","v":100},100,8,0,{"$f":"Q8+R8+S8","v":108},{"$f":"T8/116.4","v":0.9278350515463917},{"$f":"100*T8/116.4","v":92.78350515463917},{"$f":"J8*0.2+P8*0.7+V8*0.1","v":97.8092492722759},{"$f":"RANK(W8,$W$8:$W$65,)","v":1}]
[7,2022210519,"刘英杰","工艺学硕",97.6218181818182,10,0,{"$f":"E9+F9","v":{"v":107.6218181818182,"d":"107.62"}},{"v":0.916398315580877,"d":"0.9163983"},91.6398315580877,91.309,0,0,{"$f":"K9+L9","v":{"v":91.309,"d":"91.31"}},{"v":0.9163890004014452,"d":"0.9163890"},91.63890004014452,100,0,0,{"$f":"Q9+R9","v":100},{"v":0.8591065292096219,"d":"0.8591065"},85.91065292096219,91.06626163181492,2]
[8,2022210583,"王艳霖","工艺学硕",97.804375,11.634,0,{"$f":"E10+F10+G10","v":109.438375},0.9318662721389646,93.18662721389646,89.2368421052632,0,0,{"$f":"K10+L10+M10","v":89.2368421052632},0.8955925542479245,89.55925542479244,100,8,0,{"$f":"Q10+R10+S10","v":108},0.9278350515463917,92.78350515463917,90.6071547555979,3]
[9,2022210592,"王美杰","工艺学硕",97.410625,10.8,0,{"$f":"E11+F11+G11","v":108.210625},0.9214119976158037,92.14119976158038,89.4666666666667,0,0,{"$f":"K11+L11+M11","v":89.4666666666667},0.8978991034390476,89.78991034390475,100,0,0,{"$f":"Q11+R11+S11","v":100},0.8591065292096219,85.91065292096219,89.8722424851456,4]
[10,2022210570,"黄启广","工艺学硕",97.384375,4,0,{"$f":"E12+F12+G12","v":101.384375},0.863286571866485,86.3286571866485,90.83125,0,0,{"$f":"K12+L12+M12","v":90.83125},0.9115942392613408,91.15942392613408,100,0,0,{"$f":"Q12+R12+S12","v":100},0.8591065292096219,85.91065292096219,89.66839347771977,5]
[11,2022210580,"曹欣","工艺学硕",97.856875,9.7,0,{"$f":"E13+F13+G13","v":107.556875},0.9158453252724796,91.58453252724796,88.9125,0,0,{"$f":"K13+L13+M13","v":88.9125},0.8923374146928944,89.23374146928944,100,2,0,{"$f":"Q13+R13+S13","v":102},0.8762886597938144,87.62886597938144,89.54341213189035,6]
[12,2022210628,"王琛琳","工艺学硕",97.506875,17.32,0,{"$f":"E14+F14+G14","v":114.826875},0.977749276226158,97.7749276226158,84.3529411764706,1.012857,0,{"$f":"K14+L14+M14","v":85.36579817647059},0.8567422538786691,85.67422538786691,100,7.6667,0,{"$f":"Q14+R14+S14","v":107.6667},0.9249716494845361,92.4971649484536,88.77665979087536,7]
[13,2022210621,"王淙恺","工艺学硕",96.9642424242424,0,0,{"$f":"E15+F15","v":{"v":96.9642424242424,"d":"96.96"}},{"v":0.825649203203699,"d":"0.8256492"},82.5649203203699,90.482,0,0,{"$f":"K15+L15","v":{"v":90.482,"d":"90.48"}},{"v":0.908089120835006,"d":"0.9080891"},90.80891208350062,100,0,0,{"$f":"Q15+R15","v":100},{"v":0.8591065292096219,"d":"0.8591065"},85.91065292096219,88.67028781462062,8]
[14,2022210582,"焦琳凯","工艺学硕",97.139375,4,0,{"$f":"E16+F16+G16","v":101.139375},0.8612004002043597,86.12004002043597,88.8210526315789,0,0,{"$f":"K16+L16+M16","v":88.8210526315789},0.8914196370090214,89.14196370090214,100,0,0,{"$f":"Q16+R16+S16","v":100},0.8591065292096219,85.91065292096219,88.21444788681491,9]
[15,2022210573,"杨建宇","工艺学硕",97.02125,2,0,{"$f":"E17+F17+G17","v":99.02125},0.8431645946866485,84.31645946866485,89.0967032967033,0,0,{"$f":"K17+L17+M17","v":89.0967032967033},0.8941861029376084,89.41861029376084,100,0,0,{"$f":"Q17+R17+S17","v":100},0.8591065292096219,85.91065292096219,88.04738439146176,10]
[16,2022210531,"李铎","工艺学硕",97.603125,8.4,0,{"$f":"E18+F18+G18","v":106.00312500000001},0.9026151651907358,90.26151651907358,87.275,0,0,{"$f":"K18+L18+M18","v":87.275},0.8759032517061421,87.59032517061421,100,0,0,{"$f":"Q18+R18+S18","v":100},0.8591065292096219,85.91065292096219,87.95659621534087,11]
[17,2022210548,"李昊明","工艺学硕",97.6218181818182,4,0,{"$f":"E19+F19","v":{"v":101.6218181818182,"d":"101.62"}},{"v":0.8653083973247463,"d":"0.8653084"},86.53083973247463,86.816,0,0,{"$f":"K19+L19","v":{"v":86.816,"d":"86.82"}},{"v":0.8712966680048173,"d":"0.8712967"},87.12966680048174,100,12,0,{"$f":"Q19+R19","v":112},{"v":0.9621993127147765,"d":"0.9621993"},96.21993127147766,87.91892783397992,12]
[18,2022210620,"陈心宇","工艺学硕",97.1984375,3.67,0,{"$f":"E20+F20+G20","v":100.8684375},0.8588933710831063,85.88933710831063,88.465,0,0,{"$f":"K20+L20+M20","v":88.465},0.8878462464873546,88.78462464873544,100,0,0,{"$f":"Q20+R20+S20","v":100},0.8591065292096219,85.91065292096219,87.91816996787315,13]
[19,2022210624,"李丽莎","工艺学硕",97.47625,6.8,0,{"$f":"E21+F21+G21","v":104.27624999999999},0.887910848092643,88.79108480926429,86.75,0,0,{"$f":"K21+L21+M21","v":86.75},0.8706342834203131,87.06342834203132,100,7,0,{"$f":"Q21+R21+S21","v":107},0.9192439862542955,91.92439862542955,87.89505666381774,14]
[20,2022210633,"孙博","工艺学硕",96.9430303030303,20.5,0,{"$f":"E22+F22","v":{"v":117.4430303030303,"d":"117.44"}},{"v":1.0000258029890183,"d":"1.0000258"},100.00258029890182,83.18,0.625,0,{"$f":"K22+L22","v":{"v":83.805,"d":"83.81"}},{"v":0.8410778803693296,"d":"0.8410779"},84.10778803693296,100,0,0,{"$f":"Q22+R22","v":100},{"v":0.8591065292096219,"d":"0.8591065"},85.91065292096219,87.46703297772966,15]
[21,2202210639,"李丹","工艺学硕",97.0321875,5.83,0,{"$f":"E23+F23+G23","v":102.8621875},0.8758701251702998,87.58701251702998,87.1315789473684,0,0,{"$f":"K23+L23+M23","v":87.1315789473684},0.8744638593674067,87.44638593674067,100,0,0,{"$f":"Q23+R23+S23","v":100},0.8591065292096219,85.91065292096219,87.32093795122067,16]
[22,2022210509,"晏燕","工艺学硕",97.5878125,4,0,{"$f":"E24+F24+G24","v":101.5878125},0.8650188394073569,86.5018839407357,87.1852941176471,0,0,{"$f":"K24+L24+M24","v":87.1852941176471},0.8750029518029617,87.50029518029616,100,0,0,{"$f":"Q24+R24+S24","v":100},0.8591065292096219,85.91065292096219,87.14164870645067,17]
[23,2022210612,"王凯宁","工艺学硕",97.3248484848485,4,0,{"$f":"E25+F25","v":{"v":101.3248484848485,"d":"101.32"}},{"v":0.862779704400958,"d":"0.8627797"},86.2779704400958,87,0,0,{"$f":"K25+L25","v":{"v":87,"d":"87.00"}},{"v":0.8731433159373746,"d":"0.8731433"},87.31433159373745,100,0,0,{"$f":"Q25+R25","v":100},{"v":0.8591065292096219,"d":"0.8591065"},85.91065292096219,86.9666914957316,18]
[24,2022210523,"杨乐琪","工艺学硕",97.6430303030303,7.67,0,{"$f":"E26+F26","v":{"v":105.3130303030303,"d":"105.31"}},{"v":0.8967390182478738,"d":"0.8967390"},89.67390182478738,85.526,0,0,{"$f":"K26+L26","v":{"v":85.526,"d":"85.53"}},{"v":0.8583500602167804,"d":"0.8583501"},85.83500602167804,100,1,0,{"$f":"Q26+R26","v":101},{"v":0.8676975945017181,"d":"0.8676976"},86.76975945017182,86.69626052514928,19]
[25,2022210571,"罗湘旭","工艺学硕",98.3430303030303,6.5,0,{"$f":"E27+F27","v":104.8430303030303},0.8927369746511437,89.27369746511435,85.13,0,0,{"$f":"K27+L27","v":85.13},0.8543757527097551,85.43757527097551,100,4,0,{"$f":"Q27+R27","v":104},0.8934707903780068,89.34707903780068,86.5957500864858,20]
[26,2022210601,"冯晓","工艺学硕",97.9187878787879,9,0,{"$f":"E28+F28","v":106.9187878787879},0.9104120221286436,91.04120221286436,83.03,0,0,{"$f":"K28+L28","v":83.03},0.8332998795664391,83.32998795664392,100,16.4,0,{"$f":"Q28+R28","v":116.4},1,100,86.53923201222361,21]
[27,2022210625,"许诺","工艺学硕",97.12625,4,0,{"$f":"E29+F29+G29","v":101.12625},0.8610886410081744,86.10886410081744,85.6454545454545,0,0,{"$f":"K29+L29+M29","v":85.6454545454545},0.859548921572205,85.9548921572205,100,0,0,{"$f":"Q29+R29+S29","v":100},0.8591065292096219,85.91065292096219,85.98126262231405,22]
[28,2022210533,"吴佳媛","工艺学硕",97.4521212121212,6.7,0,{"$f":"E30+F30","v":104.1521212121212},0.886853893154983,88.6853893154983,84.571,0,0,{"$f":"K30+L30","v":84.571},0.8487655560016057,84.87655560016059,100,2,0,{"$f":"Q30+R30","v":102},0.8762886597938144,87.62886597938144,85.91355338115021,23]
[29,2022210547,"何裕农","工艺学硕",97.226875,0,0,{"$f":"E31+F31+G31","v":97.226875},0.8278855160081745,82.78855160081744,86.3888888888889,0,0,{"$f":"K31+L31+M31","v":86.3888888888889},0.8670101253401135,86.70101253401134,100,0,0,{"$f":"Q31+R31+S31","v":100},0.8591065292096219,85.91065292096219,85.83948438606764,24]
[30,2022210538,"王欣悦","工艺学硕",97.1678125,5.8,0,{"$f":"E32+F32+G32","v":102.9678125},0.876769520606267,87.6769520606267,84.8684210526316,0,0,{"$f":"K32+L32+M32","v":84.8684210526316},0.8517505123708511,85.17505123708511,100,0,0,{"$f":"Q32+R32+S32","v":100},0.8591065292096219,85.91065292096219,85.74899157018113,25]
[31,2022210641,"程小洛","工艺学硕",98.2157575757576,8.8,0,{"$f":"E33+F33","v":107.0157575757576},0.9112377177772276,91.12377177772275,83.22,0,0,{"$f":"K33+L33","v":83.22},0.8352067442794059,83.52067442794059,100,4,0,{"$f":"Q33+R33","v":104},0.8934707903780068,89.34707903780068,85.62393435888302,26]
[32,2022210642,"张欣燕","工艺学硕",97.0803125,2,0,{"$f":"E34+F34+G34","v":99.0803125},0.8436675110694823,84.36675110694823,85.5368421052632,0,0,{"$f":"K34+L34+M34","v":85.5368421052632},0.8584588729954156,85.84588729954156,100,0,0,{"$f":"Q34+R34+S34","v":100},0.8591065292096219,85.91065292096219,85.55653662316494,27]
[33,2022210640,"吴雨琪","工艺学硕",97.1339393939394,2,0,{"$f":"E35+F35","v":99.1339393939394},0.8441241433407647,84.41241433407646,84.905,0,0,{"$f":"K35+L35","v":84.905},0.8521176234443999,85.21176234443999,100,0,0,{"$f":"Q35+R35","v":100},0.8591065292096219,85.91065292096219,85.12178180001949,28]
[34,2022210630,"卫可鑫","工艺学硕",97.1551515151515,19.5,0,116.6551515151515,0.9933170258442737,99.33170258442738,79.847,0.625,0,80.472,0.8076274588518667,80.76274588518667,100,0,0,100,0.8591065292096219,85.91065292096219,84.99132792861236,29]
[35,2022210609,"郭际玲","工艺学硕",96.8157575757576,3.83,0,100.6457575757576,0.8569972545619686,85.69972545619687,84.03,0,0,84.03,0.8433360096346849,84.33360096346848,100,0,0,100,0.8591065292096219,85.91065292096219,84.76453105776353,30]
[36,2022210602,"赵文龙","工艺学硕",97.2824242424242,4,0,101.2824242424242,0.862418462554702,86.24184625547021,82.539,0,0,82.539,0.8283721397029306,82.83721397029305,100,10,0,110,0.9450171821305842,94.50171821305841,84.68459085160502,31]
[37,2022210530,"陈龙","工艺学硕",97.1763636363636,0,0,97.1763636363636,0.8274554124349762,82.74554124349763,84.7,0,0,84.7,0.8500602167804095,85.00602167804095,100,0,0,100,0.8591065292096219,85.91065292096219,84.6443887154244,32]
[38,2022210587,"牛俊敏","工艺学硕",97.3036363636364,7,0,104.3036363636364,0.8881440426058957,88.81440426058958,82.77,0,0,82.77,0.8306904857486953,83.06904857486953,100,0,0,100,0.8591065292096219,85.91065292096219,84.5022801466228,{"$f":"RANK(W40,$W$8:$W$65,)","v":33}]
[39,2022210510,"俞非","工艺学硕",96.6460606060606,0,0,96.6460606060606,0.8229398893567831,82.2939889356783,84.62,0,0,84.62,0.8492573263749499,84.92573263749499,100,0,0,100,0.8591065292096219,85.91065292096219,84.49787592547837,34]
[40,2022210572,"王倩","工艺学硕",97.1109375,7.786,0,{"$f":"E42+F42+G42","v":104.8969375},0.8931959936989101,89.31959936989101,82.5526315789474,0,0,{"$f":"K42+L42+M42","v":82.5526315789474},0.8285089480022821,82.85089480022822,100,0,0,{"$f":"Q42+R42+S42","v":100},0.8591065292096219,85.91065292096219,84.45061152623417,35]
[41,2022210532,"陶塬","工艺学硕",97.1371875,7.8,0,{"$f":"E43+F43+G43","v":104.9371875},0.893538721900545,89.3538721900545,81.435,0,0,{"$f":"K43+L43+M43","v":81.435},0.8172922521075874,81.72922521075873,100,8,0,{"$f":"Q43+R43+S43","v":108},0.9278350515463917,92.78350515463917,84.35958260100593,36]
[42,2022210622,"赵乾煜","工艺学硕",96.973125,2,0,{"$f":"E44+F44+G44","v":98.973125},0.8427548109673024,84.27548109673025,83.7555555555555,0,0,{"$f":"K44+L44+M44","v":83.7555555555555},0.8405816494937325,84.05816494937325,100,0,0,{"$f":"Q44+R44+S44","v":100},0.8591065292096219,85.91065292096219,84.28687697600354,37]
[43,2022210593,"王婧","工艺学硕",96.9854545454545,3.5,0,{"$f":"E45+F45","v":100.4854545454545},0.8556322764429027,85.56322764429028,83.001,0,0,{"$f":"K45+L45","v":83.001},0.8330088317944601,83.300883179446,100,3,0,{"$f":"Q45+R45","v":103},0.8848797250859106,88.48797250859106,84.27206100532936,38]
[44,2022210591,"戈涵娜","工艺学硕",96.8046875,2,0,{"$f":"E46+F46+G46","v":98.8046875},0.8413205679495913,84.13205679495913,83.625,0,0,{"$f":"K46+L46+M46","v":83.625},0.8392713769570453,83.92713769570453,100,0,0,{"$f":"Q46+R46+S46","v":100},0.8591065292096219,85.91065292096219,84.16647303808121,39]
[45,2022210536,"韩琳琳","工艺学硕",97.1551515151515,2,0,{"$f":"E47+F47","v":99.1551515151515},0.8443047642638922,84.43047642638922,83.518,0,0,{"$f":"K47+L47","v":83.518},0.838197511039743,83.8197511039743,100,0,0,{"$f":"Q47+R47","v":100},0.8591065292096219,85.91065292096219,84.15098635015606,40]
[46,2022210550,"张纯","工艺学硕",97.0146875,0,0,{"$f":"E48+F48+G48","v":97.0146875},0.8260787423365122,82.60787423365123,84,0,0,{"$f":"K48+L48+M48","v":84},0.8430349257326375,84.30349257326375,100,0,0,{"$f":"Q48+R48+S48","v":100},0.8591065292096219,85.91065292096219,84.12508494011108,41]
[47,2022210537,"郝保康","工艺学硕",97.183125,0,0,{"$f":"E49+F49+G49","v":97.183125},0.8275129853542235,82.75129853542235,83.7263157894737,0,0,{"$f":"K49+L49+M49","v":83.7263157894737},0.8402881953981705,84.02881953981704,100,0,0,{"$f":"Q49+R49+S49","v":100},0.8591065292096219,85.91065292096219,83.9614986770526,42]
[48,2022210549,"刘佳豪","工艺学硕",97.4653125,0,0,{"$f":"E50+F50+G50","v":97.4653125},0.8299158080722071,82.99158080722071,83.0944444444444,0,0,{"$f":"K50+L50+M50","v":83.0944444444444},0.8339466523930591,83.3946652393059,100,0,0,{"$f":"Q50+R50+S50","v":100},0.8591065292096219,85.91065292096219,83.56564712105448,43]
[49,2022210599,"邓百炼","工艺学硕",97.139375,0,0,{"$f":"E51+F51+G51","v":97.139375},0.8271404547002725,82.71404547002724,82.5,0,0,{"$f":"K51+L51+M51","v":82.5},0.827980730630269,82.79807306302689,100,0,0,{"$f":"Q51+R51+S51","v":100},0.8591065292096219,85.91065292096219,83.09252553022048,44]
[50,2022210578,"马壮","工艺学硕",97.10875,0,0,{"$f":"E52+F52+G52","v":97.10875},0.8268796832425068,82.68796832425068,82.42375,0,0,{"$f":"K52+L52+M52","v":82.42375},0.8272154757125653,82.72154757125652,100,0,0,{"$f":"Q52+R52+S52","v":100},0.8591065292096219,85.91065292096219,83.03374225682592,45]
[51,2022210511,"张润清","工艺学硕",96.6672727272727,0,0,{"$f":"E53+F53","v":96.6672727272727},0.8231205102799106,82.31205102799106,82.385,0,0,{"$f":"K53+L53","v":82.385},0.8268265756724208,82.68265756724207,100,0,0,{"$f":"Q53+R53","v":100},0.8591065292096219,85.91065292096219,82.93133579476388,46]
[52,2022210584,"王玉茹","工艺学硕",97.034375,0.5,0,{"$f":"E54+F54+G54","v":97.534375},0.8305038743188011,83.05038743188011,82.1315789473684,0,0,{"$f":"K54+L54+M54","v":82.1315789473684},0.8242832090261782,82.42832090261783,100,0,0,{"$f":"Q54+R54+S54","v":100},0.8591065292096219,85.91065292096219,82.90096741030472,47]
[53,2022210588,"任俊颖","工艺学硕",97.0915151515151,4,0,{"$f":"E55+F55","v":101.0915151515151},0.8607928742465523,86.07928742465523,80.731,0,0,{"$f":"K55+L55","v":80.731},0.8102268165395423,81.02268165395422,100,0,0,{"$f":"Q55+R55","v":100},0.8591065292096219,85.91065292096219,82.52279993479522,48]
[54,2022210647,"闫思源","工艺学硕",96.7521212121212,2.83,0,{"$f":"E56+F56","v":99.5821212121212},0.8479404054165633,84.79404054165634,80.07,0,0,{"$f":"K56+L56","v":80.07},0.8035929345644319,80.35929345644318,100,0,0,{"$f":"Q56+R56","v":100},0.8591065292096219,85.91065292096219,81.80137881993771,49]
[55,2022210581,"耿晓瑞","工艺学硕",96.5612121212121,2,0,{"$f":"E57+F57","v":98.5612121212121},0.8392473784163156,83.92473784163155,80.316,0,0,{"$f":"K57+L57","v":80.316},0.8060618225612204,80.60618225612204,100,0,0,{"$f":"Q57+R57","v":100},0.8591065292096219,85.91065292096219,81.80034043970795,50]
[56,2022210579,"张祺","工艺学硕",97.0671875,4.4,0,{"$f":"E58+F58+G58","v":101.46718750000001},0.8639917191757495,86.39917191757493,79.525,0,0,{"$f":"K58+L58+M58","v":79.525},0.7981232436772381,79.81232436772382,100,0,0,{"$f":"Q58+R58+S58","v":100},0.8591065292096219,85.91065292096219,81.73952673301788,51]
[57,2022210526,"霍德玺","工艺学硕",97.135,4,0,{"$f":"E59+F59","v":101.135},0.8611631471389647,86.11631471389646,79.469,0,0,{"$f":"K59+L59","v":79.469},0.7975612203934163,79.75612203934162,100,0,0,{"$f":"Q59+R59","v":100},0.8591065292096219,85.91065292096219,81.64361366241464,52]
[58,2022210522,"宋新园","工艺学硕",97.8127272727273,8.8,0,{"$f":"E60+F60","v":106.6127272727273},0.9078059202378006,90.78059202378006,77.147,0,0,{"$f":"K60+L60","v":77.147},0.7742573263749498,77.42573263749499,100,4.67,0,{"$f":"Q60+R60","v":104.67},0.8992268041237114,89.92268041237114,81.34639929223961,53]
[59,2022210613,"薛西楠","工艺学硕",96.8793939393939,2,0,{"$f":"E61+F61","v":98.8793939393939},0.8419566922632316,84.19566922632315,79.203,0,0,{"$f":"K61+L61","v":79.203},0.794891609795263,79.48916097952629,100,0,0,{"$f":"Q61+R61","v":100},0.8591065292096219,85.91065292096219,81.07261182302925,54]
[60,2022210610,"虢江波","工艺学硕",97.065,0,0,{"$f":"E62+F62+G62","v":97.065},0.8265071525885559,82.65071525885558,78.2958333333333,0,0,{"$f":"K62+L62+M62","v":78.2958333333333},0.7857871671350192,78.5787167135019,100,8,0,{"$f":"Q62+R62+S62","v":108},0.9278350515463917,92.78350515463917,80.81359526668636,55]
[61,2022210629,"王键烽","工艺学硕",97.1763636363636,12.5,0,{"$f":"E63+F63","v":109.6763636363636},0.9338927421352486,93.38927421352487,73.11,0,0,{"$f":"K63+L63","v":73.11},0.733741469289442,73.3741469289442,100,10,0,{"$f":"Q63+R63","v":110},0.9450171821305842,94.50171821305841,79.48992951427175,56]
[62,2022210645,"高清逸","工艺学硕",97.24875,2,0,{"$f":"E64+F64+G64","v":99.24875},0.8451017540871935,84.51017540871935,76.055,0,0,{"$f":"K64+L64+M64","v":76.055},0.7632978723404256,76.32978723404256,100,0,0,{"$f":"Q64+R64+S64","v":100},0.8591065292096219,85.91065292096219,78.92395143766987,57]
[63,2022210600,"路兵","工艺学硕",97.1127272727273,0.5,0,{"$f":"E65+F65","v":97.6127272727273},0.8311710428536044,83.11710428536044,76.18,0,0,{"$f":"K65+L65","v":76.18},0.7645523885989564,76.45523885989563,100,0,0,{"$f":"Q65+R65","v":100},0.8591065292096219,85.91065292096219,78.73315335109524,58]

{"sheet":"工艺专硕","index":2,"n_rows":38,"n_cols":24,"rows_kept":38,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,0,9],[0,10,0,15],[0,16,0,21],[0,22,1,22],[0,23,1,23]]}
["序号","学号","姓名","方向","德育成绩",{"$nulls":5},"智育成绩",{"$nulls":5},"文体成绩",{"$nulls":5},"总分","排名"]
[{"$nulls":4},"基础分","奖励分","惩罚分","个人德育总分","个人德育总分/基准","德育总成绩","基础分","奖励分","惩罚分","个人智育总分","个人智育总分/基准","智育总成绩","基础分","奖励分","惩罚分","个人文体总分","个人文体总分/基准","文体总成绩"]
[1,2022215374,"郭庆","工艺专硕",{"v":96.3416666666667,"d":"96.3416667"},{"v":17.25,"d":"17"},0,{"v":113.591666666667,"d":"113.5916667"},{"$f":"J3/100","v":{"v":1,"d":"1.0000000"}},{"v":100,"d":"100.0000000"},{"v":86.97895,"d":"86.9789500"},{"v":3.8034188034188,"d":"3.8034188"},0,90.7823688034188,{"$f":"P3/100","v":{"v":0.9999996563587079,"d":"0.9999997"}},99.9999656358708,100,{"v":0.5,"d":"0.5000000"},0,100.5,{"$f":"V3/100","v":{"v":0.910876408119761,"d":"0.9108764"}},{"v":91.0876408119761,"d":"91.0876408"},{"v":99.1087400263072,"d":"99.1087400"},1]
[2,2022215385,"赵凡","工艺专硕",{"v":96.5166666666667,"d":"96.5166667"},{"v":8.726,"d":"9"},0,{"v":105.242666666667,"d":"105.2426667"},{"v":0.9264998899567171,"d":"0.9264999"},{"v":92.6499889956717,"d":"92.6499890"},{"v":90.51765,"d":"90.5176500"},{"v":0,"d":"0.0000000"},0,90.51765,{"v":0.997083685824565,"d":"0.9970837"},99.7083685824565,100,{"v":7.5667,"d":"7.5667000"},0,107.5667,{"v":0.974925067953193,"d":"0.9749251"},{"v":97.4925067953193,"d":"97.4925068"},{"v":98.0751064863858,"d":"98.0751065"},2]
[3,2022215376,"丁怡","工艺专硕",96.5361111111111,13.666,0,110.202111111111,{"v":0.9701601741129291,"d":"0.9701602"},97.0160174112929,86.40625,1.35714285714286,0,87.7633928571429,{"v":0.96674457667062,"d":"0.9667446"},96.674457667062,100,8.6667,0,108.6667,{"v":0.984894859484852,"d":"0.9848949"},98.4894859484852,96.9242724440505,3]
[4,2022215371,"曹宇琦","工艺专硕",96.84,6,0,102.84,{"v":0.905348103587411,"d":"0.9053481"},90.5348103587411,89.755,0,0,89.755,{"v":0.988682828389644,"d":"0.9886828"},98.8682828389644,100,0.5,0,100.5,{"v":0.910876408119761,"d":"0.9108764"},91.0876408119761,96.4235241402209,4]
[5,2022215329,"张大庆","工艺专硕",96.62,7.766,0,104.386,{"v":0.918958256914387,"d":"0.9189583"},91.8958256914387,88.26111,0,0,88.26111,{"v":0.972227105694496,"d":"0.9722271"},97.2227105694496,100,10,0,110,{"v":0.9969791531659069,"d":"0.9969792"},99.6979153165907,96.4048540685615,5]
[6,2022215342,"王佳冉","工艺专硕",97.0805555555555,8,0,105.080555555556,{"v":0.925072750837551,"d":"0.9250728"},92.5072750837551,87.875,0,0,87.875,{"v":0.967973968522533,"d":"0.9679740"},96.7973968522533,100,9,0,109,{"v":0.987915706318945,"d":"0.9879157"},98.7915706318945,96.1387898765178,6]
[7,2022215373,"安俊蒲","工艺专硕",96.1666666666667,14.25,0,110.416666666667,{"v":0.972049005942338,"d":"0.9720490"},97.2049005942338,87.09875,0.142857142857143,0,87.2416071428571,{"v":0.9609969238845539,"d":"0.9609969"},96.0996923884554,100,0.5,0,100.5,{"v":0.910876408119761,"d":"0.9108764"},91.0876408119761,95.8195288719631,7]
[8,2022215365,"高成双","工艺专硕",96.2444444444444,8,0,104.244444444444,{"v":0.917712077861736,"d":"0.9177121"},91.7712077861736,87.60556,0,0,87.60556,{"v":0.96500599235094,"d":"0.9650060"},96.500599235094,100,8.1,0,108.1,{"v":0.9797586041566779,"d":"0.9797586"},97.9758604156678,95.7022470633673,8]
[9,2022215370,"王亚琦","工艺专硕",96.9444444444444,4.8,0,101.744444444444,{"v":0.895703421123419,"d":"0.8957034"},89.5703421123419,87.18333,0,0,87.18333,{"v":0.960354980701105,"d":"0.9603550"},96.0354980701105,100,10.3333,0,110.3333,{"v":1,"d":"1.0000000"},100,95.1389170715457,9]
[10,2022215352,"陈瑶","工艺专硕",96.1083333333333,0,0,96.1083333333333,{"v":0.846086127210036,"d":"0.8460861"},84.6086127210036,89.42778,0,0,89.42778,{"v":0.9850783852376669,"d":"0.9850784"},98.5078385237667,100,0,0,100,{"v":0.906344684696279,"d":"0.9063447"},90.6344684696279,94.9406563578002,10]
[11,2022215338,"马威","工艺专硕",95.9527777777778,2,0,97.9527777777778,{"v":0.862323625070306,"d":"0.8623236"},86.2323625070306,87.8375,0,0,87.8375,{"v":0.9675608928602899,"d":"0.9675609"},96.756089286029,100,0.5,0,100.5,{"v":0.910876408119761,"d":"0.9108764"},91.0876408119761,94.084499082824,11]
[12,2022215322,"朱云霄","工艺专硕",96.0305555555556,3.5,0,99.5305555555556,{"v":0.876213532878488,"d":"0.8762135"},87.6213532878488,85.71912,1.18,0,86.89912,{"v":0.9572243077953441,"d":"0.9572243"},95.7224307795344,100,0.5,0,100.5,{"v":0.910876408119761,"d":"0.9108764"},91.0876408119761,93.6387362844414,12]
[13,2022215321,"师人博","工艺专硕",95.9527777777778,0,0,95.9527777777778,{"v":0.844716699679652,"d":"0.8447167"},84.4716699679652,87.18676,0,0,87.18676,{"v":0.960392763355012,"d":"0.9603928"},96.0392763355012,100,0,0,100,{"v":0.906344684696279,"d":"0.9063447"},90.6344684696279,93.1852742754066,13]
[14,2022215328,"董金业","工艺专硕",96.1083333333333,4.8,0,100.908333333333,{"v":0.888342748147605,"d":"0.8883427"},88.8342748147605,85.70222,0,0,85.70222,{"v":0.94404003419165,"d":"0.9440400"},94.404003419165,100,0.5,0,100.5,{"v":0.910876408119761,"d":"0.9108764"},91.0876408119761,92.9584214375652,14]
[15,2022215317,"张楠","工艺专硕",96.2444444444444,4.8,0,101.044444444444,{"v":0.960109123464916,"d":"0.9601091"},96.0109123464916,84.56302,0.4,0,84.96302,{"v":0.935897486737517,"d":"0.9358975"},93.5897486737517,100,2,0,102,{"v":0.9244715783902051,"d":"0.9244716"},92.4471578390205,93.9597223248266,16]
[16,2022215381,"王兵","工艺专硕",96.0694444444444,3,0,99.0694444444444,{"v":0.8721541584134199,"d":"0.8721542"},87.215415841342,85.625,0,0,85.625,{"v":0.943189428787959,"d":"0.9431894"},94.3189428787959,100,0,0,100,{"v":0.906344684696279,"d":"0.9063447"},90.6344684696279,92.5297900303883,15]
[17,2022215343,"杨金兴","工艺专硕",96.4972222222222,0,0,96.4972222222222,{"v":0.84951,"d":"0.8495100"},84.951,84.7625,0,0,84.7625,{"v":0.933688688556372,"d":"0.9336887"},93.3688688556372,100,8.1,0,108.1,{"v":0.9797586041566779,"d":"0.9797586"},97.9758604156678,92.1459942405128,17]
[18,2022215375,"陈凯毅","工艺专硕",95.7777777777778,15.25,0,111.027777777778,{"v":0.9774288998117041,"d":"0.9774289"},97.7428899811704,81.83125,0.357142857142857,0,82.1883928571429,{"v":0.905333994883842,"d":"0.9053340"},90.5333994883842,100,1,0,101,{"v":0.915408131543242,"d":"0.9154081"},91.5408131543242,92.0760389535354,18]
[19,2022215339,"于星渤","工艺专硕",96.0305555555556,4,0,100.030555555556,{"v":0.880615264226152,"d":"0.8806153"},88.0615264226152,84.51176,0,0,84.51176,{"v":0.9309266994483509,"d":"0.9309267"},93.0926699448351,100,0.5,0,100.5,{"v":0.910876408119761,"d":"0.9108764"},91.0876408119761,91.8859383271052,19]
[20,2022215366,"吴达","工艺专硕",96.0305555555556,3,0,99.0305555555556,{"v":0.8718118015308249,"d":"0.8718118"},87.1811801530825,84.48889,0,0,84.48889,{"v":0.930674778371138,"d":"0.9306748"},93.0674778371138,100,1,0,101,{"v":0.915408131543242,"d":"0.9154081"},91.5408131543242,91.7375518320286,20]
[21,202215361,"范崇翔","工艺专硕",95.9138888888889,0,0,95.9138888888889,{"v":0.844374342797056,"d":"0.8443743"},84.4374342797056,84.93971,0,0,84.93971,{"v":0.9356407189058671,"d":"0.9356407"},93.5640718905867,100,0,0,100,{"v":0.906344684696279,"d":"0.9063447"},90.6344684696279,91.4457840263146,21]
[22,2022215349,"王延新","工艺专硕",95.9916666666667,4,0,99.9916666666667,{"v":0.880272907343556,"d":"0.8802729"},88.0272907343556,83.66875,0,0,83.66875,{"v":0.9216406484076209,"d":"0.9216406"},92.1640648407621,100,0.5,0,100.5,{"v":0.910876408119761,"d":"0.9108764"},91.0876408119761,91.2290676166022,22]
[23,2022215353,"刘雨轩","工艺专硕",95.1361111111111,0,0,95.1361111111111,{"v":0.837527205145135,"d":"0.8375272"},83.7527205145135,84.825,0,0,84.825,{"v":0.9343771479934441,"d":"0.9343771"},93.4377147993444,100,0,0,100,{"v":0.906344684696279,"d":"0.9063447"},90.6344684696279,91.2203913094066,23]
[24,2022215312,"闫妍","工艺专硕",96.1861111111111,0,0,96.1861111111111,{"v":0.8467708409752279,"d":"0.8467708"},84.6770840975228,84.13158,0,0,84.13158,{"v":0.926738883307778,"d":"0.9267389"},92.6738883307778,100,0.5,0,100.5,{"v":0.910876408119761,"d":"0.9108764"},91.0876408119761,90.9159027322466,24]
[25,2022215360,"陈琪","工艺专硕",95.9916666666667,0,0,95.9916666666667,{"v":0.845059056562248,"d":"0.8450591"},84.5059056562248,83.94118,0,0,83.94118,{"v":0.924641560478683,"d":"0.9246416"},92.4641560478683,100,0.5,0,100.5,{"v":0.910876408119761,"d":"0.9108764"},91.0876408119761,90.7348544459504,25]
[26,2022215369,"张世豪","工艺专硕",95.8361111111111,4,0,99.8361111111111,{"v":0.8789034798131711,"d":"0.8789035"},87.8903479813171,82.77647,0,0,82.77647,{"v":0.9118118710234581,"d":"0.9118119"},91.1811871023458,100,0.5,0,100.5,{"v":0.910876408119761,"d":"0.9108764"},91.0876408119761,90.5136646491031,26]
[27,2022215345,"张希峰","工艺专硕",95.7583333333333,0,0,95.7583333333333,{"v":0.843004915266671,"d":"0.8430049"},84.3004915266671,83.24211,0,0,83.24211,{"v":0.916941059059906,"d":"0.9169411"},91.6941059059906,100,0,0,100,{"v":0.906344684696279,"d":"0.9063447"},90.6344684696279,90.1094192864896,27]
[28,2022215307,"宋光耀","工艺专硕",95.82,3.73,0,99.55,{"v":0.876384711319786,"d":"0.8763847"},87.6384711319786,81.16051,0,0,81.16051,{"v":0.894011504432577,"d":"0.8940115"},89.4011504432577,100,8.1,0,108.1,{"v":0.9797586041566779,"d":"0.9797586"},97.9758604156678,89.9060855782429,28]
[29,2022215348,"任爽","工艺专硕",95.9722222222222,4.4,0,100.372222222222,{"v":0.883623113980388,"d":"0.8836231"},88.3623113980388,81.76125,0,0,81.76125,{"v":0.9006288663881991,"d":"0.9006289"},90.0628866388199,100,0.5,0,100.5,{"v":0.910876408119761,"d":"0.9108764"},91.0876408119761,89.8252470079793,29]
[30,2022215318,"陈文倩","工艺专硕",96.4972222222222,0,0,96.4972222222222,{"v":0.849509696035996,"d":"0.8495097"},84.9509696035996,82.03949,0,0,82.03949,{"v":0.903693777648531,"d":"0.9036938"},90.3693777648531,100,0.5,0,100.5,{"v":0.910876408119761,"d":"0.9108764"},91.0876408119761,89.3575224373147,30]
[31,2022215380,"吴熙","工艺专硕",95.7388888888889,0,0,95.7388888888889,{"v":0.842833736825374,"d":"0.8428337"},84.2833736825374,81.88889,0,0,81.88889,{"v":0.9020348657889641,"d":"0.9020349"},90.2034865788964,100,0,0,100,{"v":0.906344684696279,"d":"0.9063447"},90.6344684696279,89.0625621886977,31]
[32,2022215384,"王俊帅","工艺专硕",97.12,10,0,107.12,{"v":0.94302692392341,"d":"0.9430269"},94.302692392341,78.61118,0,0,78.61118,{"v":0.865929739685225,"d":"0.8659297"},86.5929739685225,100,2,0,102,{"v":0.9244715783902051,"d":"0.9244716"},92.4471578390205,88.720336040336,32]
[33,2022215311,"张峰铭","工艺专硕",96.0111111111111,0,0,96.0111111111111,{"v":0.845230235003546,"d":"0.8452302"},84.5230235003546,78.985,0,0,78.985,{"v":0.870047498193482,"d":"0.8700475"},87.0047498193482,100,0.5,0,100.5,{"v":0.910876408119761,"d":"0.9108764"},91.0876408119761,86.9166936548123,33]
[34,2022215344,"樊嘉琛","工艺专硕",96.0694444444444,0,0,96.0694444444444,{"v":0.84574377032744,"d":"0.8457438"},84.574377032744,78.70526,0,0,78.70526,{"v":0.8669660639066601,"d":"0.8669661"},86.696606390666,100,0.5,0,100.5,{"v":0.910876408119761,"d":"0.9108764"},91.0876408119761,86.7112639612126,34]
[35,2022215372,"封亚楠","工艺专硕",96.1666666666667,0,0,96.1666666666667,{"v":0.8465996625339309,"d":"0.8465997"},84.6599662533931,76.73,0,0,76.73,{"v":0.845207881703943,"d":"0.8452079"},84.5207881703943,100,8.1667,0,108.1667,{"v":0.98036313606137,"d":"0.9803631"},98.036313606137,85.9001763305683,35]
[36,2022215306,"马德利","工艺专硕",95.5055555555556,0,0,95.5055555555556,{"v":0.8407795955297981,"d":"0.8407796"},84.0779595529798,77.26975,0,0,77.26975,{"v":0.8511534174024921,"d":"0.8511534"},85.1153417402492,100,0.5,0,100.5,{"v":0.910876408119761,"d":"0.9108764"},91.0876408119761,85.505095209968,36]

{"sheet":"工程学硕 ","index":3,"n_rows":50,"n_cols":25,"rows_kept":50,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,0,9],[0,10,0,15],[0,16,0,21],[0,22,1,22],[0,23,1,23]]}
["序号","学号","姓名","方向","德育成绩",{"$nulls":5},"智育成绩",{"$nulls":5},"文体成绩",{"$nulls":5},"总分","排名"]
[{"$nulls":4},"基础分","奖励分","惩罚分","个人德育总分","个人德育总分/基准","德育总成绩","基础分","奖励分","惩罚分","个人智育总分","个人智育总分/基准","智育总成绩","基础分","奖励分","惩罚分","个人文体总分","个人文体总分/基准","文体总成绩"]
[1,2021210596,"李昕阳","工程学硕","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","助管"]
[2,2021210597,"王艺慧","工程学硕","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","助管"]
[3,2021210582,"李湍 ","工程学硕","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","助管"]
[4,2022210607,"林海","工程学硕","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","助管"]
[5,2022210597,"刘宇","工程学硕","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","助管"]
[6,2022210553,"亢华旭","工程学硕","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","兼职辅导员"]
[7,2021200506,"何祉桥","工程学硕","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","兼职辅导员"]
[8,2022210539,"陈行健","工程学硕",93.502,6,0,99.502,0.945288378411757,94.5288378411757,89.0476,2,0,91.0476,0.998432950800796,99.8432950800796,100,1.5,0,101.5,0.939780008147846,93.9780008147846,{"$f":"J10*0.2+P10*0.7+V10*0.1","v":98.19387420576933},{"$f":"RANK(W10,$W$10:$W$50,)","v":1}]
[9,2022210575,"李欣磊","工程学硕",93.747,8.53,0,102.277,0.971651418854087,97.1651418854087,88.84439,0,0,88.84439,0.974272429693883,97.4272429693883,100,6.67,0,106.67,0.9876486056072,98.76486056072,97.50858451172554,2]
[10,2022210501,"张洪业","工程学硕",93.208,0,0,93.208,0.885494152630129,88.5494152630129,91.1905,0,0,91.1905,1,100,100,5,0,105,0.972186215325358,97.2186215325358,97.43174520585616,3]
[11,2022210508,"赵文龙","工程学硕",94.461,10.8,0,105.261,1,100,88.5,0,0,88.5,0.970495830157747,97.0495830157747,100,2,0,102,0.944409466316062,94.4409466316062,97.37880277420291,4]
[12,2022210544,"李雨晴","工程学硕",93.474,2,0,95.474,0.907021593942676,90.7021593942676,86.92099,3.75,0,90.67099,0.994303024986155,99.4303024986155,100,0,0,100,0.925891633643198,92.5891633643198,97.00055996431635,5]
[13,2022210560,"刘明明","工程学硕",93.656,10.13,0,103.786,0.985987212737861,98.5987212737861,87.03126,0,0,87.03126,0.954389547156776,95.4389547156776,100,4.67,0,104.67,0.969130772934336,96.9130772934336,96.2183202850749,6]
[14,2022210618,"胡渤","工程学硕",93.572,0.5,0,94.072,0.893702320897579,89.3702320897578,89.28375,0,0,89.28375,0.979090475433296,97.9090475433296,100,0,0,100,0.925891633643198,92.5891633643198,95.66929603471426,7]
[15,2022210577,"周燏","工程学硕",93.67,0,0,93.67,0.889883242606473,88.9883242606473,89.06108,0,0,89.06108,0.976648664060401,97.6648664060401,100,0.5,0,100.5,0.930521091811414,93.0521091811414,95.46828225447167,8]
[16,2022210608,"赵婷婷","工程学硕",93.537,7,0,100.537,0.95512107998214,95.512107998214,86.684,0,0,86.684,0.950581475044001,95.0581475044001,100,5.37,0,105.37,0.975612014369838,97.5612014369838,95.39924499642126,9]
[17,2022210574,"韩雨芹","工程学硕",93.887,6.6,0,100.487,0.95464607024444,95.464607024444,87.05,0,0,87.05,0.954595051019569,95.4595051019569,100,2,0,102,0.944409466316062,94.4409466316062,95.35866963941925,10]
[18,2022210527,"王贵方","工程学硕",93.131,2,0,95.131,0.903763027142056,90.3763027142056,88.39376,0,0,88.39376,0.969330796519374,96.9330796519374,100,0.5,0,100.5,0.930521091811414,93.0521091811414,95.23362721731144,11]
[19,2022210606,"崔子元","工程学硕",93.453,11.8,0,105.253,0.999923998441968,99.9923998441968,84.86841,0.75,0,85.61841,0.938896156946173,93.8896156946173,100,2,0,102,0.944409466316062,94.4409466316062,95.16530561823208,12]
[20,2022210502,"朱金铸","工程学硕",94.062,10.8,0,104.862,0.996209422293157,99.6209422293157,85.5238,0.19,0,85.7138,0.939942208892374,93.9942208892374,100,2,0,102,0.944409466316062,94.4409466316062,95.16423773148992,13]
[21,2022210505,"郝一博","工程学硕",94.153,10,0,104.153,0.989473784212577,98.9473784212577,85.72,0,0,85.72,0.940010198430758,94.0010198430758,100,2,0,102,0.944409466316062,94.4409466316062,95.0342842375652,14]
[22,2022210506,"覃海航","工程学硕",93.523,5.4,0,98.923,0.939787765649196,93.9787765649196,87.1,0,0,87.1,0.955143353748472,95.5143353748472,100,0,0,100,0.925891633643198,92.5891633643198,94.91470641180894,15]
[23,2022210516,"梁爽爽","工程学硕",93.25,5,0,98.25,0.933394134579759,93.3394134579759,87.18885,0,0,87.18885,0.956117687697732,95.6117687697732,100,0,0,100,0.925891633643198,92.5891633643198,94.8550371668684,16]
[24,2022210515,"李重燃","工程学硕",93.677,11,0,104.677,0.994451886263669,99.4451886263669,84.7916,0,0,84.7916,0.929829313360493,92.9829313360493,100,4.67,0,104.67,0.969130772934336,96.9130772934336,94.66839738985125,17]
[25,2022210569,"王旖旎","工程学硕",93.509,0,0,93.509,0.888353711251081,88.8353711251081,88.03126,0,0,88.03126,0.96535560173483,96.535560173483,100,0,0,100,0.925891633643198,92.5891633643198,94.6008826828917,18]
[26,2022210525,"李延辉","工程学硕",93.726,8,0,101.726,0.966416811544637,96.6416811544637,81.167,3.57,0,84.737,0.929230566780531,92.9230566780531,100,8.004,0,108.004,1,100,94.3744759055299,19]
[27,2022210552,"高龙燕","工程学硕",93.488,4.43,0,97.918,0.930240069921434,93.0240069921434,86.5946,0,0,86.5946,0.949601109764723,94.9601109764723,100,0,0,100,0.925891633643198,92.5891633643198,94.33579541839126,20]
[28,2022210648,"包梦慧","工程学硕",93.579,0,0,93.579,0.88901872488386,88.901872488386,87.06876,0,0,87.06876,0.954800774203453,95.4800774203453,100,0,0,100,0.925891633643198,92.5891633643198,93.87534502835088,21]
[29,2022210540,"皮婧婧","工程学硕",93.509,0,0,93.509,0.888353711251081,88.8353711251081,87,0,0,87,0.954046748290666,95.4046748290666,100,0.5,0,100.5,0.930521091811414,93.0521091811414,93.85555752348237,22]
[30,2022210561,"刘勇泉","工程学硕",93.208,0,0,93.208,0.885494152630129,88.5494152630129,86.64376,0,0,86.64376,0.95014020100778,95.014020100778,100,3,0,103,0.953668382652494,95.3668382652494,93.7563809496721,23]
[31,2022210576,"袁炳昊","工程学硕",93.719,0,0,93.719,0.890348752149419,89.0348752149419,86.47777,0,0,86.47777,0.948319945608369,94.8319945608369,100,1,0,101,0.93515054997963,93.515054997963,93.54087673537052,24]
[32,2022210626,"武立宁","工程学硕",94.062,8,0,102.062,0.969608876981978,96.9608876981978,84.0529,0,0,84.0529,0.921728688843684,92.1728688843684,100,2,0,102,0.944409466316062,94.4409466316062,93.35728042185806,25]
[33,2022210524,"蒋梦瑶","工程学硕",93.712,4,0,97.712,0.928283029802111,92.8283029802111,84.12625,0.4,0,84.52625,0.926919470778206,92.6919470778206,100,4.67,0,104.67,0.969130772934336,96.9130772934336,93.14133127986,26]
[34,2022210595,"吴玥函","工程学硕",93.579,8,0,101.579,0.9650202829158,96.50202829158,84.07,0,0,84.07,0.921916208376969,92.1916208376969,100,0,0,100,0.925891633643198,92.5891633643198,93.0934565811358,27]
[35,2022210568,"李庆旭","工程学硕",93.803,3,0,96.803,0.919647352770732,91.9647352770732,84.63124,0,0,84.63124,0.928070796848356,92.8070796848356,100,4.67,0,104.67,0.969130772934336,96.9130772934336,93.04921056414292,28]
[36,2022210598,"马晓存","工程学硕",93.292,2,0,95.292,0.905292558497449,90.5292558497449,85.50554,0,0,85.50554,0.937658418365948,93.7658418365948,100,0,0,100,0.925891633643198,92.5891633643198,93.00085679199732,29]
[37,2022210649,"李雅丽","工程学硕",93.691,0.5,0,94.191,0.894832844073304,89.4832844073304,85.53125,0,0,85.53125,0.93794035562915,93.794035562915,100,0,0,100,0.925891633643198,92.5891633643198,92.81139811193856,30]
[38,2022210596,"李浩","工程学硕",93.215,6.4,0,99.615,0.946361900418959,94.6361900418959,83.40554,0,0,83.40554,0.914629703752036,91.4629703752036,100,2,0,102,0.944409466316062,94.4409466316062,92.3954119341823,31]
[39,2022210627,"赵荣鹏","工程学硕",93.404,0,0,93.404,0.887356190801911,88.7356190801911,85.16174,0,0,85.16174,0.933888288802013,93.3888288802013,100,0,0,100,0.925891633643198,92.5891633643198,92.37822036861111,32]
[40,2022210604,"武屹威","工程学硕",93.733,4,0,97.733,0.928482533891945,92.8482533891945,82.97216,0.1,0,83.07216,0.910973840476804,91.0973840476804,100,2,0,102,0.944409466316062,94.4409466316062,91.7819141743758,33]
[41,2022210559,"胡冰阳","工程学硕",93.362,6,0,99.362,0.943958351146198,94.3958351146198,81.23126,0,0,81.23126,0.890786430604065,89.0786430604065,100,6.67,0,106.67,0.9876486056072,98.76486056072,91.1107032212805,34]
[42,2022210507,"汪雪敏","工程学硕",93.222,2,0,95.222,0.90462754486467,90.462754486467,83.035,0,0,83.035,0.910566341888684,91.0566341888684,100,0,0,100,0.925891633643198,92.5891633643198,91.09111116593326,35]
[43,2022210619,"占彬","工程学硕",93.425,0,0,93.425,0.887555694891745,88.7555694891745,83.41248,0,0,83.41248,0.914705808170807,91.4705808170807,100,0,0,100,0.925891633643198,92.5891633643198,91.03943680622336,36]
[44,2022210611,"牛苗苗","工程学硕",93.887,4,0,97.887,0.92994556388406,92.994556388406,82.14581,0,0,82.14581,0.900815435818424,90.0815435818424,100,0,0,100,0.925891633643198,92.5891633643198,90.91490812140286,37]
[45,2022210554,"赵波","工程学硕",93.222,2,0,95.222,0.90462754486467,90.462754486467,81.61108,0,0,81.61108,0.894951557453902,89.4951557453901,100,0,0,100,0.925891633643198,92.5891633643198,89.99807625549845,38]
[46,2022210636,"刘雪","工程学硕",93.439,0,0,93.439,0.887688697618301,88.7688697618301,81.52355,0,0,81.52355,0.893991698696684,89.3991698696684,100,0.5,0,100.5,0.930521091811414,93.0521091811414,89.63840377924804,39]
[47,2022210545,"王刚","工程学硕",93.691,2,0,95.691,0.909083136204292,90.9083136204292,79.41053,0,0,79.41053,0.870820206052166,87.0820206052166,100,8,0,108,0.999962964334654,99.9962964334654,89.13870679108399,40]
[48,2022210637,"王琦","工程学硕",93.313,4.4,0,97.71,0.928292529996865,92.8292529996865,77.56174,0,0,77.56174,0.850546274008806,85.0546274008806,100,1,0,101,0.93515054997963,93.515054997963,87.45559528035002,41]

{"sheet":"工程专硕","index":4,"n_rows":30,"n_cols":23,"rows_kept":30,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,0,8],[0,9,0,14],[0,15,0,20],[0,21,1,21],[0,22,1,22]]}
["序号","姓名","方向","德育部分",{"$nulls":5},"智育部分",{"$nulls":5},"文体部分",{"$nulls":5},"总分","排名"]
[{"$nulls":3},"基础分","奖励分","惩罚分","个人德育总分","个人德育总分/基准","德育总成绩","基础分","奖励分","惩罚分","个人智育总分","个人智育总分/基准","智育总成绩","基础分","奖励分","惩罚分","个人文体总分","个人文体总分/基准","文体总成绩"]
[1,"赵宏宇","化学工程专硕",95.7,13.4,0,109.1,0.990018148820327,99.0018148820327,89.54,0,0,89.54,0.984064182877239,98.4064182877239,100,15.5,0,115.5,1,100,98.6848557778133,1]
[2,"董丽","化学工程专硕",96.4,13.8,0,110.2,1,100,87.58,0,0,87.58,0.962523354214749,96.2523354214749,100,6.17,0,106.17,0.919220779220779,91.9220779220779,96.5688425872402,2]
[3,"宋艳雯","化学工程专硕",95.7,0,0,95.7,0.868421052631579,86.8421052631579,90.99,0,0,90.99,1,100,100,0.5,0,100.5,0.87012987012987,87.012987012987,96.0697197539303,3]
[4,"卢芳芳","化学工程专硕",95,0.5,0,95.5,0.866606170598911,86.6606170598911,90.65,0,0,90.65,0.99626332564018,99.626332564018,100,3.83,0,103.83,0.898961038961039,89.8961038961039,96.0601665964012,4]
[5,"李汉成","化学工程专硕",96.4,6.33,0,102.73,0.932214156079855,93.2214156079855,87.24,0.4,0,87.64,0.96318276733707,96.318276733707,100,5.67,0,105.67,0.914891774891775,91.4891774891775,95.2159945841098,5]
[6,"陈巧玲","化学工程专硕",95.7,2,0,97.7,0.886569872958258,88.6569872958258,87.58,0,0,87.58,0.962523354214749,96.2523354214749,100,15.5,0,115.5,1,100,95.1080322541976,6]
[7,"史天乐","化学工程专硕",95.7,8.734,0,104.434,0.947676950998185,94.7676950998185,87.56,0,0,87.56,0.962303549840642,96.2303549840642,100,1.5,0,101.5,0.878787878787879,87.8787878787879,95.1026662966874,7]
[8,"戎清","化学工程专硕",95.4,2,0,97.4,0.883847549909256,88.3847549909256,89.09,0,0,89.09,0.979118584459831,97.9118584459831,100,1,0,101,0.874458874458874,87.4458874458875,94.959840654962,8]
[9,"王延硕","化学工程专硕",95.7,9.47,0,105.17,0.954355716878403,95.4355716878403,86.1,0,0,86.1,0.946257830530828,94.6257830530828,100,6.17,0,106.17,0.919220779220779,91.9220779220779,94.5173702669338,9]
[10,"魏学洋","化学工程专硕",93.6,5.67,0,99.27,0.9008166969147,90.08166969147,87.09,0,0,87.09,0.957138147049126,95.7138147049126,100,7.67,0,107.67,0.932207792207792,93.2207792207792,94.3380821538108,10]
[11,"张藤铧","化学工程专硕",95.7,4,0,99.7,0.904718693284936,90.4718693284937,87.37,0.0125,0,87.3825,0.960352786020442,96.0352786020442,100,0.5,0,100.5,0.87012987012987,87.012987012987,94.0203675884284,11]
[12,"关晶","化学工程专硕",95.7,4,0,99.7,0.904718693284936,90.4718693284937,86.04,0,0,86.04,0.945598417408507,94.5598417408507,100,12,0,112,0.96969696969697,96.969696969697,93.9832327812639,12]
[13,"王凤凤","化学工程专硕",95.1,4.5,0,99.6,0.903811252268602,90.3811252268602,86.99,0,0,86.99,0.956039125178591,95.6039125178591,100,0.5,0,100.5,0.87012987012987,87.012987012987,93.7002625091721,13]
[14,"齐保辉","化学工程专硕",95.7,6.13,0,101.83,0.924047186932849,92.4047186932849,85.26,0,0,85.26,0.937026046818332,93.7026046818332,100,8.5,0,108.5,0.939393939393939,93.9393939393939,93.4667064098796,14]
[15,"王宁宁","化学工程专硕",95.7,0,0,95.7,0.868421052631579,86.8421052631579,87.52,0,0,87.52,0.961863941092428,96.1863941092428,100,0.5,0,100.5,0.87012987012987,87.012987012987,93.4001956304002,15]
[16,"李逸飞","化学工程专硕",95,3,0,98,0.88929219600726,88.929219600726,86.4,0,0,86.4,0.949554896142433,94.9554896142433,100,3,0,103,0.891774891774892,89.1774891774892,93.1724355678645,16]
[17,"陈瑜洲","化学工程专硕",95,2,0,97,0.88021778584392,88.021778584392,85.49,0,0,85.49,0.939553797120563,93.9553797120563,100,5.17,0,105.17,0.910562770562771,91.0562770562771,92.4787492209455,17]
[18,"李宝隆","化学工程专硕",95,10.4,0,105.4,0.956442831215971,95.6442831215971,82.93,0,0,82.93,0.911418837234861,91.1418837234861,100,5.67,0,105.67,0.914891774891775,91.4891774891775,92.0770929796774,18]
[19,"王琳","化学工程专硕",95.7,0,0,95.7,0.868421052631579,86.8421052631579,84.38,0,0,84.38,0.927354654357622,92.7354654357622,100,8.5,0,108.5,0.939393939393939,93.9393939393939,91.6771862516045,19]
[20,"屈光仁","化学工程专硕",95.7,0,0,95.7,0.868421052631579,86.8421052631579,84.42,0,0,84.42,0.927794263105836,92.7794263105836,100,4.33,0,104.33,0.903290043290043,90.3290043290043,91.3469199029405,20]
[21,"徐文磊","化学工程专硕",95.7,0,0,95.7,0.868421052631579,86.8421052631579,84.38,0,0,84.38,0.927354654357622,92.7354654357622,100,0.5,0,100.5,0.87012987012987,87.012987012987,90.9845455589638,21]
[22,"吕琛","化学工程专硕",95,3,0,98,0.88929219600726,88.929219600726,82.58,0,0,82.58,0.907572260687988,90.7572260687988,100,5.17,0,105.17,0.910562770562771,91.0562770562771,90.421529873932,22]
[23,"边昊","化学工程专硕",95.7,2,0,97.7,0.886569872958258,88.6569872958258,81.62,0,0,81.62,0.89702165073085,89.702165073085,100,8.5,0,108.5,0.939393939393939,93.9393939393939,89.916852404264,23]
[24,"张耀森","化学工程专硕",96.4,5.67,0,102.07,0.926225045372051,92.6225045372051,78.6,0,0,78.6,0.863831190240686,86.3831190240686,100,8.5,0,108.5,0.939393939393939,93.9393939393939,88.3866236182284,24]
[25,"王程","化学工程专硕",95.7,0,0,95.7,0.868421052631579,86.8421052631579,80.6,0,0,80.6,0.88581162765139,88.581162765139,100,0.5,0,100.5,0.87012987012987,87.012987012987,88.0765336895276,25]
[26,"王鹏","化学工程专硕",95,0,0,95,0.862068965517241,86.2068965517241,80.71,0,0,80.71,0.887020551708979,88.7020551708979,100,0.5,0,100.5,0.87012987012987,87.012987012987,88.034116631272,26]
[27,"邵瀚锋","化学工程专硕",95,0,0,95,0.862068965517241,86.2068965517241,79.82,0,0,79.82,0.877239257061216,87.7239257061215,100,0.5,0,100.5,0.87012987012987,87.012987012987,87.3494260059286,27]
[28,"刘浩天","化学工程专硕",95,4.4,0,99.4,0.901996370235935,90.1996370235935,76.84,0,0,76.84,0.844488405319266,84.4488405319266,100,0.5,0,100.5,0.87012987012987,87.012987012987,85.855414478366,28]

{"sheet":"催化学硕","index":5,"n_rows":38,"n_cols":25,"rows_kept":38,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,0,9],[0,10,0,15],[0,16,0,21],[0,22,1,22],[0,23,1,23],[0,24,1,24]]}
["序号","学号","姓名","方向","德育成绩",{"$nulls":5},"智育成绩",{"$nulls":5},"文体成绩",{"$nulls":5},"总分","排名","备注"]
[{"$nulls":4},"基础分","奖励分","惩罚分","个人德育总分","个人德育总分/基准","德育总成绩","基础分","奖励分","惩罚分","个人智育总分","个人智育总分/基准","智育总成绩","基本分","奖励分","惩罚分","个人文体总分","个人文体总分/基准","文体总成绩"]
[1,2022210615,"金玮","催化学硕","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","兼职辅导员"]
[2,2022210512,"娄颖洁","催化学硕",97.59189189,6.5,0,{"$f":"E4+F4+G4","v":104.09189189},{"$f":"H4/109.4459","v":0.9510807795449624},{"$f":"I4*100","v":95.10807795449624},89.63,1.75,0,{"$f":"K4+L4","v":91.38},{"$f":"N4/91.79","v":0.9955332824926462},{"$f":"O4*100","v":99.55332824926461},100,3.33,0,{"$f":"Q4+R4","v":103.33},{"$f":"T4/115","v":0.8985217391304348},{"$f":"U4*100","v":89.85217391304347},{"$f":"J4*0.2+P4*0.7+V4*0.1","v":97.69416275668881},1]
[3,2022210534,"李章明","催化学硕",97.93243243,4,0,101.93243243,0.9313499402901343,93.13499402901343,91.79,0,0,91.79,1,100,100,0,0,100,0.8695652173913043,86.95652173913044,97.32265097971573,2]
[4,2022210614,"郭盈铄","催化学硕",97.97027027,5.9,0,103.87027027,0.9490558373589144,94.90558373589144,90.39,0,0,90.39,0.9847477938773286,98.47477938773285,100,0,0,{"$f":"Q6+R6","v":100},0.8695652173913043,86.95652173913044,96.60911449250433,3]
[5,2022210650,"王鑫雨","催化学硕",97.95135135,4.57,0,102.52135135,0.9367308537825538,93.67308537825538,89.72,0,0,89.72,0.9774485238043359,97.74485238043358,100,7.3,0,107.3,0.9330434782608695,93.30434782608695,96.48644852456327,4]
[6,2022210535,"王岚","催化学硕",97.81891892,9,0,106.81891892,0.9759974464095961,97.59974464095961,88.68,0,0,88.68,0.9661183135417801,96.61183135417801,100,0,0,100,0.8695652173913043,86.95652173913044,95.84388305002958,5]
[7,2022210514,"邬银丹","催化学硕",98.1027027,1,0,99.1027027,0.9054948856010139,90.5494885601014,89.416,0,0,89.416,0.9741366161891273,97.41366161891273,100,0,0,100,0.8695652173913043,86.95652173913044,94.99511301917224,6]
[8,2022210585,"杨驰","催化学硕",98.00810811,8.1,0,106.10810810999999,0.9695028147239869,96.95028147239869,87.18,0,0,87.18,0.9497766641246324,94.97766641246324,100,0,0,{"$f":"Q10+R10","v":100},0.8695652173913043,86.95652173913044,94.57007495711704,7]
[9,2022210565,"王娜","催化学硕",97.97027027,7.5,0,105.47027027,0.9636749322724744,96.36749322724744,{"v":86.4,"d":"86.40"},0,0,86.4,0.9412790064277154,94.12790064277155,100,7,0,107,0.9304347826086956,93.04347826086956,94.46737692147653,8]
[10,2022210528,"郭慧娟","催化学硕",97.95135135,8.7,0,106.65135135,0.9744663925281807,97.44663925281807,85.81,0,0,85.81,0.934851290990304,93.48512909903039,100,6.67,0,106.67,0.9275652173913044,92.75652173913043,94.20457039379792,9]
[11,2022210616,"马阿慧","催化学硕",98.06486486,5,0,103.06486486,0.9416969010259864,94.16969010259864,84.94,1.875,0,86.815,0.9458001960997929,94.58001960997929,100,0,0,100,0.8695652173913043,86.95652173913044,93.73560392141827,10]
[12,2022210589,"杜大兴","催化学硕",98.12162162,5,0,103.12162162,0.9422154838143777,94.22154838143777,86.74,0,0,86.74,0.9449831136289355,94.49831136289355,100,0,0,100,0.8695652173913043,86.95652173913044,93.68877980422607,11]
[13,2022210623,"王露露","催化学硕",98.29189189,9.5,0,107.79189189,0.98488743653257,98.488743653257,83.89,0,0,83.89,0.9139339797363547,91.39339797363547,100,15,0,115,1,100,93.67312731219623,12]
[14,2022210566,"王子溪","催化学硕",98.01388889,5.83,0,103.84388889,0.9488147924225577,94.88147924225578,85.89,0,0,85.89,0.9357228456258851,93.57228456258852,100,0,0,100,0.8695652173913043,86.95652173913044,93.17254721617617,13]
[15,2022210513,"王玲珑","催化学硕",97.95135135,3,0,100.95135135,0.922385866898623,92.2385866898623,86.17,0,0,86.17,0.9387732868504194,93.87732868504195,100,0,0,{"$f":"Q17+R17","v":100},0.8695652173913043,86.95652173913044,92.85749959141486,14]
[16,2022210617,"魏豪斌","催化学硕",98.02702703,5,0,103.02702703,0.9413511792584282,94.13511792584282,85.29,0,0,85.29,0.929186185859026,92.9186185859026,100,0,0,100,0.8695652173913043,86.95652173913044,92.56570876921343,15]
[17,2022210590,"檀宇航","催化学硕",98.04594595,1,0,99.04594595,0.9049763029039919,90.49763029039919,85.19,0,0,85.19,0.9280967425645494,92.80967425645494,100,0,0,100,0.8695652173913043,86.95652173913044,91.76195021151135,16]
[18,2022210562,"韩玉潇","催化学硕",98.02702703,5.9,0,103.92702703,0.9495744201473058,94.95744201473057,83.05,0,0,83.05,0.9047826560627519,90.47826560627519,100,6.67,0,106.67,0.9275652173913044,92.75652173913043,91.60192650125178,17]
[19,2022210563,"王精文","催化学硕",98.08378378,6.4,0,104.48378378000001,0.9546614700048153,95.46614700048153,83.65,0,0,83.65,0.9113193158296111,91.13193158296112,100,0,0,{"$f":"Q21+R21","v":100},0.8695652173913043,86.95652173913044,91.58123368208213,18]
[20,2022210558,"周佳玥","催化学硕",98.04594595,11.4,0,109.44594595000001,1,100,82.16,0,0,82.16,0.8950866107419108,89.50866107419108,100,0,0,100,0.8695652173913043,86.95652173913044,91.35171492584679,19]
[21,2022210564,"胡临凯","催化学硕",97.98918919,5.5,0,103.48918919,{"$f":"H23/109.4459","v":0.9455739245599881},94.55739245599881,83.34,0,0,83.34,0.9079420416167339,90.79420416167339,100,0,0,100,0.8695652173913043,86.95652173913044,91.16307357828418,20]
[22,2022210651,"徐豪","催化学硕",97.95135135,5.17,0,103.12135135,{"$f":"H24/109.4459","v":0.9422130143751388},94.22130143751389,82.96,0,0,82.96,0.9038021570977229,90.38021570977229,100,0,0,100,0.8695652173913043,86.95652173913044,90.80606345825642,21]
[23,2022210504,"郑佳硕","催化学硕",98.02702703,6.4,0,104.42702703,{"$f":"H25/109.4459","v":0.9541428873077933},95.41428873077933,82.24,0,0,82.24,0.895958165377492,89.5958165377492,100,3,0,{"$f":"Q25+R25","v":103},0.8956521739130435,89.56521739130436,90.75645106171075,23]
[24,2022210635,"王硕","催化学硕",97.83783784,1,0,98.83783784,0.9030748327712597,90.30748327712597,83.81,0,0,83.81,0.9130624251007735,91.30624251007735,100,0,0,100,0.8695652173913043,86.95652173913044,90.6715185863924,24]
[25,2022210518,"柳静","催化学硕",97.83783784,5.5,0,103.33783784,0.9441910372156472,94.41910372156472,82.71,0,0,82.71,0.9010785488615316,90.10785488615316,100,0,0,100,0.8695652173913043,86.95652173913044,90.6549713385332,25]
[26,2022210503,"李昌昕","催化学硕",97.95135135,1,0,98.95135135,0.904111998256673,90.4111998256673,83.655,0,0,83.655,0.9113737879943349,91.13737879943349,100,0,0,100,0.8695652173913043,86.95652173913044,90.57405729864995,26]
[27,2022210542,"宋杨","催化学硕",97.95135135,1,0,98.95135135,0.904111998256673,90.4111998256673,83.49,0,0,83.49,0.9095762065584485,90.95762065584485,100,0,0,100,0.8695652173913043,86.95652173913044,90.44822659813791,27]
[28,2022210644,"何刚","催化学硕",97.78108108,3,0,100.78108108,0.9208301186248185,92.08301186248184,82.85,0,0,82.85,0.9026037694737987,90.26037694737987,100,0,0,100,0.8695652173913043,86.95652173913044,90.29451840957532,28]
[29,2022210557,"张福海","催化学硕",97.83783784,1,0,98.83783784,0.9030748327712597,90.30748327712597,83.09,0,0,83.09,0.9052184333805425,90.52184333805425,100,0,0,100,0.8695652173913043,86.95652173913044,90.12243916597622,29]
[30,2022210646,"季冀涛","催化学硕",97.87567568,0,-2,95.87567568,0.8760097516672621,87.60097516672622,83.59,0,0,83.59,0.9106656498529251,91.0665649852925,100,0,0,100,0.8695652173913043,86.95652173913044,89.96244269696304,31]
[31,2022210529,"景文江","催化学硕",97.91351351,1,0,98.91351351,0.9037662763977454,90.37662763977454,81.69,0,0,81.69,0.8899662272578711,88.9966227257871,100,0,0,{"$f":"Q33+R33","v":100},0.8695652173913043,86.95652173913044,89.06861360991893,32]
[32,2022210556,"马佳倩","催化学硕",97.81891892,5.43,0,103.24891892,0.9433785908837151,94.33785908837152,80.53,0,0,80.53,0.8773286850419435,87.73286850419436,100,0,0,100,0.8695652173913043,86.95652173913044,88.9762319445234,33]
[33,2022210643,"管学峰","催化学硕",97.97027027,1,0,98.97027027,0.9042848591861368,90.42848591861367,81.45,0,0,81.45,0.8873515633511275,88.73515633511275,100,0,0,100,0.8695652173913043,86.95652173913044,88.8959587922147,34]
[34,2022210634,"王祺元","催化学硕",98.06486486,1,0,99.06486486,0.9051491637420863,90.51491637420864,{"v":80,"d":"80.00"},0,0,80,0.8715546355812179,87.1554635581218,100,0,0,100,0.8695652173913043,86.95652173913044,87.80745993944002,35]
[35,2022210555,"程伟男","催化学硕",97.83783784,1,-2,96.83783784,0.8848009641293096,88.48009641293096,77.68,0,0,77.68,0.8462795511493627,84.62795511493627,100,0,0,100,0.8695652173913043,86.95652173913044,85.63124003695462,36]
[36,2022210586,"张宇琪","催化学硕",97.87567568,1,-2,96.87567568,0.8851466859882372,88.51466859882372,69.83,0,0,69.83,0.7607582525329556,76.07582525329556,100,0,0,100,0.8695652173913043,86.95652173913044,79.65166357098468,37]

{"sheet":"催化专硕","index":6,"n_rows":22,"n_cols":24,"rows_kept":22,"merged":[[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,0,9],[0,10,0,15],[0,16,0,21],[0,22,1,22],[0,23,1,23]]}
[null,"序号","姓名","方向","德育部分",{"$nulls":5},"智育部分",{"$nulls":5},"文体部分",{"$nulls":5},"总分","排名"]
[{"$nulls":4},"基础分","奖励分","惩罚分","个人德育总分","个人德育总分/基准","德育总成绩","基础分","奖励分","惩罚分","个人智育总分","个人智育总分/基准","智育总成绩","基础分","奖励分","惩罚分","个人文体总分","个人文体总分/基准","文体总成绩"]
[1,1,"张豪丹","催化专硕",95.7,9,0,104.7,0.950090744101633,95.0090744101633,87.9,0,0,87.9,0.966040224200462,96.6040224200462,100,13.56,0,113.56,0.983203463203463,98.3203463203463,96.4566652080996,1]
[2,2,"徐智超","催化专硕",95,2,0,97,0.88021778584392,88.021778584392,90.22,0,0,90.22,0.991537531596879,99.1537531596879,100,1,0,101,0.874458874458874,87.4458874458875,95.7565716732487,2]
[3,3,"张婷","催化专硕",95,0,0,95,0.862068965517241,86.2068965517241,89.95,0,0,89.95,0.988570172546434,98.8570172546434,100,6.6,0,106.6,0.922943722943723,92.2943722943723,95.6707286180324,3]
[4,4,"汪博迪","催化专硕",94.3,0,0,94.3,0.855716878402904,85.5716878402904,90.55,0,0,90.55,0.995164303769645,99.5164303769645,100,0.5,0,100.5,0.87012987012987,87.012987012987,95.4771375332319,4]
[5,5,"乔倩","催化专硕",95,8.57,0,103.57,0.93983666061706,93.983666061706,87.04,0,0,87.04,0.956588636113859,95.6588636113859,100,2.5,0,102.5,0.887445887445887,88.7445887445888,94.6323966147702,5]
[6,6,"王银磊","催化专硕",95,2,0,97,0.88021778584392,88.021778584392,88.72,0,0,88.72,0.97505220353885,97.5052203538851,100,1,0,101,0.874458874458874,87.4458874458875,94.6025987091867,6]
[7,7,"韩心怡","催化专硕",95,0,0,95,0.862068965517241,86.2068965517241,89.24,0,0,89.24,0.980767117265634,98.0767117265634,100,0.5,0,100.5,0.87012987012987,87.012987012987,94.5963762202379,7]
[8,8,"谢保振","催化专硕",96.4,7.2,0,103.6,0.94010889292196,94.010889292196,86.16,0.58,0,86.74,0.953291570502253,95.3291570502253,100,2,0,102,0.883116883116883,88.3116883116883,94.3637566247658,8]
[9,9,"董宇晴","催化专硕",95.7,7,0,102.7,0.931941923774955,93.1941923774955,86.51,0,0,86.51,0.950763820200022,95.0763820200022,100,3,0,103,0.891774891774892,89.1774891774892,94.1100548072496,9]
[10,10,"刘涵","催化专硕",96.4,3.57,null,99.97,0.907168784029038,90.7168784029038,85.39,0,0,85.39,0.938454775250028,93.8454775250027,100,8.67,0,108.67,0.940865800865801,94.0865800865801,93.2438679567407,10]
[11,11,"王文骁","催化专硕",94.3,0,0,94.3,0.855716878402904,85.5716878402904,87.1,0,0,87.1,0.95724804923618,95.724804923618,100,3.83,0,103.83,0.898961038961039,89.8961038961039,93.111311404201,11]
[12,12,"胡丹丹","催化专硕",95.7,5,0,100.7,0.913793103448276,91.3793103448276,85.73,0,0,85.73,0.942191449609847,94.2191449609847,100,1,0,101,0.874458874458874,87.4458874458875,92.9738522862436,12]
[13,13,"李状","催化专硕",95,0,0,95,0.862068965517241,86.2068965517241,86.29,0,0,86.29,0.948345972084845,94.8345972084845,100,0.5,0,100.5,0.87012987012987,87.012987012987,92.3268960575826,13]
[14,14,"赵辰","催化专硕",95,7,0,102,0.925589836660617,92.5589836660617,83.37,0,0,83.37,0.916254533465216,91.6254533465216,100,5.67,null,105.67,0.914891774891775,91.4891774891775,91.7985318246952,14]
[15,15,"吕向杰","催化专硕",95.7,3.37,0,99.07,0.899001814882033,89.9001814882033,84.57,0,0,84.57,0.929442795911639,92.9442795911639,100,1,0,101,0.874458874458874,87.4458874458875,91.7856207560441,15]
[16,16,"李建辉","催化专硕",95.7,3.67,0,99.37,0.901724137931034,90.1724137931034,84.125,0,0,84.125,0.924552148587757,92.4552148587757,100,1,0,101,0.874458874458874,87.4458874458875,91.4977219043524,16]
[17,17,"王延一","催化专硕",95.7,6,0,101.7,0.922867513611615,92.2867513611615,83.48,0,0,83.48,0.917463457522805,91.7463457522805,100,0.5,0,100.5,0.87012987012987,87.012987012987,91.3810910001273,17]
[18,18,"翟敏慧","催化专硕",95,0.5,0,95.5,0.866606170598911,86.6606170598911,82.28,0,0,82.28,0.904275195076382,90.4275195076382,100,0.5,0,100.5,0.87012987012987,87.012987012987,89.3326857686237,18]
[19,19,"安海涛","催化专硕",95.7,3.67,0,99.37,0.901724137931034,90.1724137931034,77.36,0,0,77.36,0.850203319046049,85.0203319046049,100,9.67,0,109.67,0.94952380952381,94.9523809523809,87.0439531870822,19]
[20,20,"徐焘","催化专硕",95,0,0,95,0.862068965517241,86.2068965517241,78.36,0,0,78.36,0.861193537751401,86.1193537751401,100,0,0,100,0.865800865800866,86.5800865800866,86.1829356109516,20]

{"sheet":"环境学硕","index":7,"n_rows":28,"n_cols":25,"rows_kept":28,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,0,9],[0,10,0,15],[0,16,0,21],[0,22,1,22],[0,23,1,23]]}
["序号","学号","姓名","方向","德育成绩",{"$nulls":5},"智育成绩",{"$nulls":5},"文体成绩",{"$nulls":5},"总分","排名"]
[{"$nulls":4},"基础分","奖励分","惩罚分","个人德育总分","个人德育总分/基准","德育总成绩","基础分","奖励分","惩罚分","个人智育总分","个人智育总分/基准","智育总成绩","基础分","奖励分","惩罚分","个人文体总分","个人文体总分/基准","文体总成绩"]
[1,2021210659,"冯扬帆","环境学硕","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","助管"]
[2,2021210666,"熊子馨","环境学硕","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","助管"]
[3,"2022210665","李翀","环境学硕",95.5083333333333,16.1,0,111.608333333333,{"$f":"J5/100","v":{"v":0.999626809971637,"d":"0.9996268"}},99.9626809971637,84.6764705882353,3.875,0,88.5514705882353,{"$f":"P5/100","v":{"v":0.985273664403174,"d":"0.9852737"}},98.5273664403174,100,4.67,0,104.67,{"$f":"V5/100","v":{"v":0.9395870736086179,"d":"0.9395871"}},93.9587073608618,{"$f":"J5*0.2+P5*0.7+V5*0.1","v":{"v":98.3575634437411,"d":"98.3575634"}},1]
[4,"2022210679","桂雨飞","环境学硕",95.0942857142857,11,0,106.094285714286,{"v":0.950239907875376,"d":"0.9502399"},95.0239907875376,87.9991596638655,0,0,87.9991596638655,{"v":0.979128341183483,"d":"0.9791283"},97.9128341183483,100,10.93,0,110.93,{"v":0.995780969479354,"d":"0.9957810"},99.5780969479354,{"v":97.50159173514487,"d":"97.5015917"},2]
[5,"2022210664","曹谨慧","环境学硕",95.2228571428571,2.5,0,97.7228571428571,{"v":0.875260699891242,"d":"0.8752607"},87.5260699891242,86,3.875,0,89.875,{"v":1,"d":"1.0000000"},100,100,0,0,100,{"v":0.8976660682226211,"d":"0.8976661"},89.7666068222621,{"v":96.48187468005105,"d":"96.4818747"},3]
[6,"2022210657","李莉","环境学硕",{"v":95.2142857142857,"d":"95.2142857"},9,0,{"v":104.214285714286,"d":"104.2142857"},{"v":0.9334015737956619,"d":"0.9334016"},{"v":93.3401573795662,"d":"93.3401574"},{"v":88.3151260504202,"d":"88.3151261"},0,0,88.3151260504202,{"v":0.9826439616180269,"d":"0.9826440"},98.2643961618027,100,0,0,100,{"v":0.8976660682226211,"d":"0.8976661"},{"v":89.7666068222621,"d":"89.7666068"},{"v":96.42976947140133,"d":"96.4297695"},4]
[7,"2022210680","渠长双","环境学硕",95.0085714285714,5.5,0,100.508571428571,{"v":0.9002111189303309,"d":"0.9002111"},90.0211118930331,85.6252100840336,2,0,87.6252100840336,{"v":0.974967566998983,"d":"0.9749676"},97.4967566998983,100,3.8,0,103.8,{"v":0.9317773788150809,"d":"0.9317774"},93.1777378815081,{"v":95.56972585668623,"d":"95.5697259"},5]
[8,"2022210666","李瑶","环境学硕",95.1166666666667,10.5,0,105.616666666667,{"v":0.945962083893118,"d":"0.9459621"},94.5962083893118,86.84,0,0,86.84,{"v":0.966230876216968,"d":"0.9662309"},96.6230876216968,100,0,0,100,{"v":0.8976660682226211,"d":"0.8976661"},89.7666068222621,{"v":95.53206369527632,"d":"95.5320637"},6]
[9,"2022210652","方洁","环境学硕",{"v":95.1,"d":"95.1000000"},{"v":10.3,"d":"10"},0,{"v":105.4,"d":"105.4000000"},{"v":0.944021495745634,"d":"0.9440215"},{"v":94.4021495745634,"d":"94.4021496"},{"v":85.8806722689076,"d":"85.8806723"},0,0,85.8806722689076,{"v":0.955556854174215,"d":"0.9555569"},95.5556854174215,100,6.67,0,106.67,{"v":0.9575403949730701,"d":"0.9575404"},{"v":95.754039497307,"d":"95.7540395"},{"v":95.34481365683843,"d":"95.3448137"},7]
[10,"2022210681","孙舵","环境学硕",95.1028571428571,9.3,0,104.402857142857,{"v":0.935090525238308,"d":"0.9350905"},93.5090525238308,85.8705882352941,0,0,85.8705882352941,{"v":0.955444653522049,"d":"0.9554447"},95.5444653522049,100,0,0,100,{"v":0.8976660682226211,"d":"0.8976661"},89.7666068222621,{"v":94.55959693353579,"d":"94.5595969"},8]
[11,"2022210667","沈燕婷","环境学硕",95.0942857142857,9.5,0,104.594285714286,{"v":0.9368050668543281,"d":"0.9368051"},93.6805066854328,85.54,0,0,85.54,{"v":0.951766342141864,"d":"0.9517663"},95.1766342141864,100,0,0,100,{"v":0.8976660682226211,"d":"0.8976661"},89.7666068222621,{"v":94.33640596924324,"d":"94.3364060"},9]
[12,"2022210685","石云飞","环境学硕",95.1416666666667,3,0,98.1416666666667,{"v":0.879011792804896,"d":"0.8790118"},87.9011792804896,86.1,0,0,86.1,{"v":0.957997218358832,"d":"0.9579972"},95.7997218358832,100,4.67,0,104.67,{"v":0.9395870736086179,"d":"0.9395871"},93.9587073608618,{"v":94.03591187730234,"d":"94.0359119"},10]
[13,"2022210673","谭鑫","环境学硕",95.0416666666667,5,0,100.041666666667,{"v":0.896029258098224,"d":"0.8960293"},89.6029258098224,85.1333333333333,0,0,85.1333333333333,{"v":0.947241539174779,"d":"0.9472415"},94.7241539174779,100,0,0,100,{"v":0.8976660682226211,"d":"0.8976661"},89.7666068222621,{"v":93.20415358642522,"d":"93.2041536"},11]
[14,"2022210658","薛甜甜","环境学硕",{"v":95.18,"d":"95.1800000"},{"v":6.8,"d":"7"},0,{"v":101.98,"d":"101.9800000"},{"v":0.9133900582176441,"d":"0.9133901"},{"v":91.3390058217644,"d":"91.3390058"},{"v":84.3210084033613,"d":"84.3210084"},0,0,84.3210084033613,{"v":0.938203153305829,"d":"0.9382032"},93.8203153305829,100,0,0,100,{"v":0.8976660682226211,"d":"0.8976661"},{"v":89.7666068222621,"d":"89.7666068"},{"v":92.91868257798713,"d":"92.9186826"},12]
[15,"2022210663","王添谊","环境学硕",95.025,{"v":2.5,"d":"3"},0,{"v":97.525,"d":"97.5250000"},{"v":0.873488580385132,"d":"0.8734886"},{"v":87.3488580385132,"d":"87.3488580"},{"v":84.2285714285714,"d":"84.2285714"},0,0,84.2285714285714,{"v":0.937174647327638,"d":"0.9371746"},93.7174647327638,100,0,0,100,{"v":0.8976660682226211,"d":"0.8976661"},{"v":89.7666068222621,"d":"89.7666068"},{"v":92.04865760286351,"d":"92.0486576"},13]
[16,"2022210671","李智豪","环境学硕",94.9,5.5,0,100.4,{"v":0.8992386923421409,"d":"0.8992387"},89.9238692342141,82.5825396825397,0,0,82.5825396825397,{"v":0.918859968651346,"d":"0.9188600"},91.8859968651346,100,0,0,100,{"v":0.8976660682226211,"d":"0.8976661"},89.7666068222621,{"v":91.28163233466326,"d":"91.2816323"},14]
[17,"2022210682","步路通","环境学硕",95.0916666666667,2.5,0,97.5916666666667,{"v":0.8740856844305119,"d":"0.8740857"},87.4085684430512,83.1933333333333,0,0,83.1933333333333,{"v":0.925656003708855,"d":"0.9256560"},92.5656003708855,100,0,0,100,{"v":0.8976660682226211,"d":"0.8976661"},89.7666068222621,{"v":91.2542946304563,"d":"91.2542946"},15]
[18,"2022210661","黄德安","环境学硕",{"v":95.55,"d":"95.5500000"},{"v":16.1,"d":"16"},0,{"v":111.65,"d":"111.6500000"},{"v":1,"d":"1.0000000"},{"v":100,"d":"100.0000000"},{"v":79.2714285714286,"d":"79.2714286"},0,0,79.2714285714286,{"v":0.882018676733558,"d":"0.8820187"},88.2018676733558,100,0,0,100,{"v":0.8976660682226211,"d":"0.8976661"},{"v":89.7666068222621,"d":"89.7666068"},{"v":90.71796805357526,"d":"90.7179681"},16]
[19,"2022210676","赵政翰","环境学硕",95.12,8,0,103.12,{"v":0.923600537393641,"d":"0.9236005"},92.3600537393641,80.8420168067227,0,0,80.8420168067227,{"v":0.899493928308458,"d":"0.8994939"},89.9493928308458,100,0,0,100,{"v":0.8976660682226211,"d":"0.8976661"},89.7666068222621,{"v":90.41324641169108,"d":"90.4132464"},17]
[20,"2022210669","郭川钰","环境学硕",95.075,1,0,96.075,{"v":0.860501567398119,"d":"0.8605016"},86.0501567398119,81.1117647058824,0.2,0,81.3117647058824,{"v":0.904720608688538,"d":"0.9047206"},90.4720608688538,100,6.67,0,106.67,{"v":0.9575403949730701,"d":"0.9575404"},95.754039497307,{"v":90.11587790589074,"d":"90.1158779"},18]
[21,"2022210678","胡若晖","环境学硕",94.9914285714286,2,0,96.9914285714286,{"v":0.868709615507645,"d":"0.8687096"},86.8709615507645,81.8388888888889,0,0,81.8388888888889,{"v":0.9105856900015451,"d":"0.9105857"},91.0585690001545,100,0,0,100,{"v":0.8976660682226211,"d":"0.8976661"},89.7666068222621,{"v":90.09185129248726,"d":"90.0918513"},19]
[22,"2022210683","宋登昊","环境学硕",94.9083333333333,2.5,0,97.4083333333333,{"v":0.872443648305717,"d":"0.8724436"},87.2443648305717,80.2188888888889,0,0,80.2188888888889,{"v":0.892560655231031,"d":"0.8925607"},89.2560655231031,100,11.4,0,111.4,{"v":1,"d":"1.0000000"},100,{"v":89.92811883228651,"d":"89.9281188"},20]
[23,"2022210662","孙国庆","环境学硕",94.9657142857143,5,0,{"v":99.9657142857143,"d":"99.9657143"},{"v":0.89534898598938,"d":"0.8953490"},{"v":89.534898598938,"d":"89.5348986"},{"v":80.6714285714286,"d":"80.6714286"},0,0,80.6714285714286,{"v":0.8975958672759791,"d":"0.8975959"},89.7595867275979,100,0,0,100,{"v":0.8976660682226211,"d":"0.8976661"},{"v":89.7666068222621,"d":"89.7666068"},{"v":89.71535111133234,"d":"89.7153511"},21]
[24,"2022210674","邢甜甜","环境学硕",94.7857142857143,2.5,0,97.2857142857143,{"v":0.8713454033651079,"d":"0.8713454"},87.1345403365108,80.5666666666667,0,0,80.5666666666667,{"v":0.896430227167362,"d":"0.8964302"},89.6430227167362,100,0,0,100,{"v":0.8976660682226211,"d":"0.8976661"},89.7666068222621,{"v":89.15368465124371,"d":"89.1536847"},22]
[25,"2022210675","李启明","环境学硕",94.9666666666667,3,0,97.9666666666667,{"v":0.877444394685774,"d":"0.8774444"},87.7444394685774,79.8705882352941,0,0,79.8705882352941,{"v":0.888685265483106,"d":"0.8886853"},88.8685265483106,100,0,0,100,{"v":0.8976660682226211,"d":"0.8976661"},89.7666068222621,{"v":88.7335171597591,"d":"88.7335172"},23]
[26,"2022210653","郭鹏涛","环境学硕",{"v":94.9314285714286,"d":"94.9314286"},5,0,{"v":99.9314285714286,"d":"99.9314286"},{"v":0.895041903908899,"d":"0.8950419"},{"v":89.5041903908899,"d":"89.5041904"},{"v":75.4847058823529,"d":"75.4847059"},0,0,75.4847058823529,{"v":0.8398854618342471,"d":"0.8398855"},83.9885461834247,100,0,0,100,{"v":0.8976660682226211,"d":"0.8976661"},{"v":89.7666068222621,"d":"89.7666068"},{"v":85.66948108880148,"d":"85.6694811"},24]

{"sheet":"环境专硕","index":8,"n_rows":15,"n_cols":24,"rows_kept":15,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,0,9],[0,10,0,15],[0,16,0,21],[0,22,1,22],[0,23,1,23]]}
["序号","学号","姓名","方向","德育成绩",{"$nulls":5},"智育成绩",{"$nulls":5},"文体成绩",{"$nulls":5},"总分","排名"]
[{"$nulls":4},"基础分","奖励分","惩罚分","个人德育总分","个人德育总分/基准","德育总成绩","基础分","奖励分","惩罚分","个人智育总分","个人智育总分/基准","智育总成绩","基础分","奖励分","惩罚分","个人文体总分","个人文体总分/基准","文体总成绩"]
[1,"2022215390","冯博","环境专硕",{"v":95.2,"d":"95.2000000"},9,0,{"v":104.2,"d":"104.2000000"},{"$f":"J3/100","v":{"v":0.9858222170824912,"d":"0.9858222"}},{"$f":"H3*100/105.6985714","v":98.58222170824912},{"v":88.8027777777778,"d":"88.8027778"},0,0,88.8027777777778,{"$f":"P3/100","v":{"v":0.990494426164495,"d":"0.9904944"}},99.0494426164495,100,0,0,100,{"$f":"V3/100","v":{"v":0.901469395114036,"d":"0.9014694"}},{"v":90.1469395114036,"d":"90.1469395"},{"$f":"J3*0.2+P3*0.7+V3*0.1","v":{"v":98.06574812430482,"d":"98.0657481"}},1]
[2,2022215389,"颜薇","环境专硕",{"v":95.5228571428571,"d":"95.5228571"},{"v":2.5,"d":"3"},0,{"v":98.0228571428571,"d":"98.0228571"},{"v":0.9273810974408032,"d":"0.9273811"},92.73810974408032,{"v":89.55,"d":"89.5500000"},0,0,89.655,{"v":1,"d":"1.0000000"},100,100,0,0,100,{"v":0.901469395114036,"d":"0.9014694"},{"v":90.1469395114036,"d":"90.1469395"},{"v":97.56231589995643,"d":"97.5623159"},2]
[3,"2022215388","吴琪","环境专硕",{"v":95.36,"d":"95.3600000"},2,0,{"v":97.36,"d":"97.3600000"},{"v":0.9211098949630647,"d":"0.9211099"},92.11098949630647,{"v":89.1444444444444,"d":"89.1444444"},0,0,89.4694444444444,{"v":0.9979303379002221,"d":"0.9979303"},99.7930337900222,100,0,0,100,{"v":0.901469395114036,"d":"0.9014694"},{"v":90.1469395114036,"d":"90.1469395"},{"v":97.29201550341719,"d":"97.2920155"},3]
[4,"2022215395","王铭华","环境专硕",95.3685714285714,10.33,"0",105.698571428571,{"v":1.0000000002703062,"d":"1.0000000"},100.00000002703062,86.0666666666667,0,0,86.0666666666667,{"v":0.959976205082446,"d":"0.9599762"},95.9976205082446,100,10.93,0,110.93,{"v":1,"d":"1.0000000"},100,{"v":97.19833436117733,"d":"97.1983344"},4]
[5,"2022215392","费文博","环境专硕",95.3771428571429,7.1,"0",102.477142857143,{"v":0.9695224968494038,"d":"0.9695225"},96.95224968494038,87.7425,0,0,87.7425,{"v":0.9786682282081309,"d":"0.9786682"},97.8668228208131,100,0,0,100,{"v":0.901469395114036,"d":"0.9014694"},90.1469395114036,{"v":96.9119198626976,"d":"96.9119199"},5]
[6,"2022215402","董光宇","环境专硕",95.2583333333333,9,"0",104.258333333333,{"v":0.9863741009212258,"d":"0.9863741"},98.63741009212258,85.225,0,0,85.225,{"v":0.950588366516089,"d":"0.9505884"},95.0588366516089,100,7.6,0,107.6,{"v":0.969981069142703,"d":"0.9699811"},96.9981069142703,{"v":95.96847836597779,"d":"95.9684784"},6]
[7,"2022215403","唐国瑾","环境专硕",95.2333333333333,2,"0",97.2333333333333,{"v":0.9199115186275195,"d":"0.9199115"},91.99115186275195,85.9222222222222,0,0,85.9222222222222,{"v":0.958365090873038,"d":"0.9583651"},95.8365090873038,100,10.93,0,110.93,{"v":1,"d":"1.0000000"},100,{"v":95.48378673366304,"d":"95.4837867"},7]
[8,"2022215401","姚子旬","环境专硕",95.2828571428571,5.5,"0",100.782857142857,{"v":0.9534930870679392,"d":"0.9534931"},95.34930870679392,84.3861111111111,0,0,84.3861111111111,{"v":0.9412315109152991,"d":"0.9412315"},94.1231510915299,100,4.26,0,104.26,{"v":0.939871991345894,"d":"0.9398720"},93.9871991345894,{"v":94.35478741888866,"d":"94.3547874"},8]
[9,"2022215387","陈宇轩","环境专硕",{"v":95.4114285714286,"d":"95.4114286"},{"v":2.5,"d":"3"},0,{"v":97.9114285714286,"d":"97.9114286"},{"v":0.9263268866794598,"d":"0.9263269"},92.63268866794598,{"v":85.525,"d":"85.5250000"},0,0,85.57,{"v":0.9544364508393279,"d":"0.9544365"},95.4436450839328,100,0,0,100,{"v":0.901469395114036,"d":"0.9014694"},{"v":90.1469395114036,"d":"90.1469395"},{"v":94.3517832434825,"d":"94.3517832"},9]
[10,2022215393,"熊峰","环境专硕",{"v":95.1583333333333,"d":"95.1583333"},2,0.5,{"v":96.6583333333333,"d":"96.6583333"},{"v":0.9144715207885327,"d":"0.9144715"},91.44715207885326,{"v":84.6875,"d":"84.6875000"},0,0,84.6875,{"v":0.9445931626791589,"d":"0.9445932"},94.4593162679159,100,0,0,100,{"v":0.901469395114036,"d":"0.9014694"},{"v":90.1469395114036,"d":"90.1469395"},{"v":93.42564575445213,"d":"93.4256458"},10]
[11,"2022215394","安宏坤","环境专硕",95.2583333333333,2,"0.5",96.7583333333333,{"v":0.915417607369226,"d":"0.9154176"},91.5417607369226,82.7777777777778,0,0,82.7777777777778,{"v":0.9232923738528559,"d":"0.9232924"},92.3292373852856,100,0,0,100,{"v":0.901469395114036,"d":"0.9014694"},90.1469395114036,{"v":91.9535122682248,"d":"91.9535123"},11]
[12,2021215383,"王红燕","环境专硕",{"v":95.2294117647059,"d":"95.2294118"},9,0,{"v":104.229411764706,"d":"104.2294118"},{"v":0.9861004778415198,"d":"0.9861005"},98.61004778415197,{"v":80.14,"d":"80.1400000"},0,0,80.14,{"v":0.893870949751826,"d":"0.8938709"},89.3870949751826,100,0,0,100,{"v":0.901469395114036,"d":"0.9014694"},{"v":90.1469395114036,"d":"90.1469395"},{"v":91.30766999059857,"d":"91.3076700"},12]
[13,"2022215391","许大山","环境专硕",{"v":95.1666666666667,"d":"95.1666667"},2,0,{"v":97.1666666666667,"d":"97.1666667"},{"v":0.9192807942403911,"d":"0.9192808"},91.92807942403911,{"v":79.55,"d":"79.5500000"},0,0,79.55,{"v":0.8872901678657069,"d":"0.8872902"},88.7290167865707,100,0,0,100,{"v":0.901469395114036,"d":"0.9014694"},{"v":90.1469395114036,"d":"90.1469395"},{"v":89.51062158654767,"d":"89.5106216"},13]

{"sheet":"国际班","index":9,"n_rows":24,"n_cols":25,"rows_kept":24,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,0,9],[0,10,0,15],[0,16,0,21],[0,22,1,22],[0,23,1,23]]}
["序号","学号","姓名","方向","德育成绩",{"$nulls":5},"智育成绩",{"$nulls":5},"文体成绩",{"$nulls":5},"总分","排名"]
[{"$nulls":4},"基础分组","奖励分","惩罚分","个人德育总分","个人德育总分/基准","德育总成绩","基础分","奖励分","惩罚分","个人智育总分","个人智育总分/基准","智育总成绩","基础分","奖励分","惩罚分","个人文体总分","个人文体总分/基准","文体总成绩"]
[1,2022210656,"王皓铖","国际班","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","—","助管"]
[2,2022210632,"李思远","国际班",{"v":95.77,"d":"95.7700"},{"v":17.67,"d":"17.6700"},{"v":0,"d":"0.0000"},{"v":113.44,"d":"113.4400"},{"v":1,"d":"1.0000"},{"v":100,"d":"100.0000"},{"v":92.03125,"d":"92.0313"},{"v":10.05,"d":"10.0500"},{"v":0,"d":"0.0000"},{"v":102.08125,"d":"102.0813"},{"v":1,"d":"1.0000"},{"v":99.9999510194326,"d":"100.0000"},{"v":100,"d":"100.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":100,"d":"100.0000"},0.8197,{"v":81.9672131147541,"d":"81.9672"},{"v":98.1966870250782,"d":"98.1967"},1]
[3,2022210631,"冯若瑶","国际班",95.0525,{"v":15.25,"d":"15.2500"},{"v":0,"d":"0.0000"},110.3025,0.9723,{"v":97.2342207334274,"d":"97.2342"},{"v":86.1089285714286,"d":"86.1089"},{"v":1.85,"d":"1.8500"},{"v":0,"d":"0.0000"},{"v":87.9589285714286,"d":"87.9589"},0.8666,{"v":86.1655646738713,"d":"86.1656"},{"v":100,"d":"100.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":100,"d":"100.0000"},0.8197,{"v":81.9672131147541,"d":"81.9672"},{"v":87.9594607298708,"d":"87.9595"},2]
[4,2022210638,"程海洋","国际班",95.2275,{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},95.2275,0.8395,{"v":83.9452574047955,"d":"83.9453"},{"v":83.6159663865546,"d":"83.6160"},{"v":7.5,"d":"7.5000"},{"v":0,"d":"0.0000"},{"v":91.1159663865546,"d":"91.1160"},0.8926,{"v":89.2582347467701,"d":"89.2582"},{"v":100,"d":"100.0000"},{"v":2,"d":"2.0000"},{"v":0,"d":"0.0000"},{"v":102,"d":"102.0000"},0.8361,{"v":83.6065573770492,"d":"83.6066"},{"v":87.6304715414031,"d":"87.6305"},3]
[5,2022210660,"朱燕萍","国际班",{"v":95.28,"d":"95.2800"},{"v":7.8,"d":"7.8000"},{"v":0,"d":"0.0000"},{"v":103.08,"d":"103.0800"},0.9087,{"v":90.867418899859,"d":"90.8674"},{"v":88.6545454545455,"d":"88.6545"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":88.6545454545455,"d":"88.6545"},0.8685,{"v":86.846998867124,"d":"86.8470"},{"v":100,"d":"100.0000"},{"v":4.33,"d":"4.3300"},{"v":0,"d":"0.0000"},{"v":104.33,"d":"104.3300"},0.8552,{"v":85.516393442623,"d":"85.5164"},{"v":87.5180223312209,"d":"87.5180"},4]
[6,2022215386,"张钰萌","国际班",{"v":95.49,"d":"95.4900"},{"v":8,"d":"8.0000"},{"v":0,"d":"0.0000"},{"v":103.49,"d":"103.4900"},0.9123,{"v":91.2288434414668,"d":"91.2288"},{"v":84.5777777777778,"d":"84.5778"},{"v":2.4,"d":"2.4000"},{"v":0,"d":"0.0000"},{"v":86.9777777777778,"d":"86.9778"},{"v":0.852,"d":"0.8520"},{"v":85.2044182213371,"d":"85.2044"},{"v":100,"d":"100.0000"},{"v":14.73,"d":"14.7300"},{"v":0,"d":"0.0000"},{"v":114.73,"d":"114.7300"},0.9404,{"v":94.0409836065574,"d":"94.0410"},{"v":87.2929598038851,"d":"87.2930"},5]
[7,2022210672,"宁潇宇","国际班",96.6275,{"v":8,"d":"8.0000"},{"v":0,"d":"0.0000"},104.6275,0.9223,{"v":92.2315761636107,"d":"92.2316"},{"v":87.8588235294118,"d":"87.8588"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":87.8588235294118,"d":"87.8588"},0.8607,{"v":86.0675006386201,"d":"86.0675"},{"v":100,"d":"100.0000"},{"v":1,"d":"1.0000"},{"v":0,"d":"0.0000"},{"v":101,"d":"101.0000"},0.8279,{"v":82.7868852459016,"d":"82.7869"},{"v":86.9722542043464,"d":"86.9723"},6]
[8,2022210655,"马浩天","国际班",{"v":95.385,"d":"95.3850"},{"v":4,"d":"4.0000"},{"v":0,"d":"0.0000"},{"v":99.385,"d":"99.3850"},0.8761,{"v":87.6101904090268,"d":"87.6102"},{"v":88.9818181818182,"d":"88.9818"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":88.9818181818182,"d":"88.9818"},0.8717,{"v":87.1675989449764,"d":"87.1676"},{"v":100,"d":"100.0000"},{"v":1,"d":"1.0000"},{"v":0,"d":"0.0000"},{"v":101,"d":"101.0000"},0.8279,{"v":82.7868852459016,"d":"82.7869"},{"v":86.818045867879,"d":"86.8180"},7]
[9,2022210654,"刘浩威","国际班",95.1575,{"v":5,"d":"5.0000"},{"v":0,"d":"0.0000"},100.1575,0.8829,{"v":88.2911671368124,"d":"88.2912"},{"v":88.2909090909091,"d":"88.2909"},{"v":0.25,"d":"0.2500"},{"v":0,"d":"0.0000"},{"v":88.5409090909091,"d":"88.5409"},0.8674,{"v":86.7356793956475,"d":"86.7357"},{"v":100,"d":"100.0000"},{"v":1,"d":"1.0000"},{"v":0,"d":"0.0000"},{"v":101,"d":"101.0000"},0.8279,{"v":82.7868852459016,"d":"82.7869"},{"v":86.6518975289059,"d":"86.6519"},8]
[10,2022210605,"韩哲","国际班",{"v":95.7,"d":"95.7000"},{"v":6.4,"d":"6.4000"},{"v":0,"d":"0.0000"},{"v":102.1,"d":"102.1000"},{"v":0.9,"d":"0.9000"},{"v":90.0035260930889,"d":"90.0035"},{"v":85.4882352941176,"d":"85.4882"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":85.4882352941176,"d":"85.4882"},0.8375,{"v":83.7452454995358,"d":"83.7452"},{"v":100,"d":"100.0000"},{"v":22,"d":"22.0000"},{"v":0,"d":"0.0000"},{"v":122,"d":"122.0000"},{"v":1,"d":"1.0000"},{"v":100,"d":"100.0000"},{"v":86.6223770682928,"d":"86.6224"},9]
[11,2022215398,"李炯","国际班",95.2275,{"v":6.4,"d":"6.4000"},{"v":0,"d":"0.0000"},101.6275,0.8959,{"v":89.5870063469676,"d":"89.5870"},{"v":87.9,"d":"87.9000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":87.9,"d":"87.9000"},0.8611,{"v":86.1078375765199,"d":"86.1078"},{"v":100,"d":"100.0000"},{"v":1,"d":"1.0000"},{"v":0,"d":"0.0000"},{"v":101,"d":"101.0000"},0.8279,{"v":82.7868852459016,"d":"82.7869"},{"v":86.4715760975476,"d":"86.4716"},10]
[12,2022210659,"刘浩","国际班",95.3325,{"v":3,"d":"3.0000"},{"v":0,"d":"0.0000"},98.3325,0.8668,{"v":86.6823871650212,"d":"86.6824"},{"v":88.6954545454545,"d":"88.6955"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":88.6954545454545,"d":"88.6955"},0.8689,{"v":86.8870738768556,"d":"86.8871"},{"v":100,"d":"100.0000"},{"v":1,"d":"1.0000"},{"v":0,"d":"0.0000"},{"v":101,"d":"101.0000"},0.8279,{"v":82.7868852459016,"d":"82.7869"},{"v":86.4361176713933,"d":"86.4361"},11]
[13,2022215400,"刘彧","国际班",95.4725,{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},95.4725,0.8416,{"v":84.161230606488,"d":"84.1612"},{"v":88.8278787878788,"d":"88.8279"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":88.8278787878788,"d":"88.8279"},0.8702,{"v":87.0167981676162,"d":"87.0168"},{"v":100,"d":"100.0000"},{"v":2,"d":"2.0000"},{"v":0,"d":"0.0000"},{"v":102,"d":"102.0000"},0.8361,{"v":83.6065573770492,"d":"83.6066"},{"v":86.1046605763338,"d":"86.1047"},12]
[14,2022215397,"王超然","国际班",{"v":95.175,"d":"95.1750"},{"v":10,"d":"10.0000"},{"v":0,"d":"0.0000"},{"v":105.175,"d":"105.1750"},0.9271,{"v":92.7142101551481,"d":"92.7142"},{"v":85.7583333333333,"d":"85.7583"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":85.7583333333333,"d":"85.7583"},0.8401,{"v":84.0098366040923,"d":"84.0098"},{"v":100,"d":"100.0000"},{"v":2,"d":"2.0000"},{"v":0,"d":"0.0000"},{"v":102,"d":"102.0000"},0.8361,{"v":83.6065573770492,"d":"83.6066"},{"v":85.7103833915992,"d":"85.7104"},13]
[15,2022210668,"高冰洁","国际班",95.8925,{"v":2,"d":"2.0000"},{"v":0,"d":"0.0000"},97.8925,0.8629,{"v":86.2945169252468,"d":"86.2945"},{"v":87.2909090909091,"d":"87.2909"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":87.2909090909091,"d":"87.2909"},0.8551,{"v":85.5111652094057,"d":"85.5112"},{"v":100,"d":"100.0000"},{"v":1,"d":"1.0000"},{"v":0,"d":"0.0000"},{"v":101,"d":"101.0000"},0.8279,{"v":82.7868852459016,"d":"82.7869"},{"v":85.3954075562235,"d":"85.3954"},14]
[16,2022210517,"刘明嘉","国际班",95.1575,{"v":3,"d":"3.0000"},{"v":0,"d":"0.0000"},98.1575,0.8653,{"v":86.5281205923836,"d":"86.5281"},{"v":86.44,"d":"86.4400"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":86.44,"d":"86.4400"},0.8468,{"v":84.6776050069895,"d":"84.6776"},{"v":100,"d":"100.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":100,"d":"100.0000"},0.8197,{"v":81.9672131147541,"d":"81.9672"},{"v":84.7766689348448,"d":"84.7767"},15]
[17,2022210684,"刘振华","国际班",{"v":95.98,"d":"95.9800"},{"v":7,"d":"7.0000"},{"v":0,"d":"0.0000"},{"v":102.98,"d":"102.9800"},0.9078,{"v":90.7792665726375,"d":"90.7793"},{"v":84.9342105263158,"d":"84.9342"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":84.9342105263158,"d":"84.9342"},{"v":0.832,"d":"0.8320"},{"v":83.2025165493737,"d":"83.2025"},{"v":100,"d":"100.0000"},{"v":1,"d":"1.0000"},{"v":0,"d":"0.0000"},{"v":101,"d":"101.0000"},0.8279,{"v":82.7868852459016,"d":"82.7869"},{"v":84.6763034236792,"d":"84.6763"},16]
[18,2022215399,"杜帅豪","国际班",{"v":95.49,"d":"95.4900"},{"v":6.4,"d":"6.4000"},{"v":0,"d":"0.0000"},{"v":101.89,"d":"101.8900"},0.8982,{"v":89.8184062059238,"d":"89.8184"},{"v":84.0619047619048,"d":"84.0619"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":84.0619047619048,"d":"84.0619"},0.8235,{"v":82.3479959227643,"d":"82.3480"},{"v":100,"d":"100.0000"},{"v":1,"d":"1.0000"},{"v":0,"d":"0.0000"},{"v":101,"d":"101.0000"},0.8279,{"v":82.7868852459016,"d":"82.7869"},{"v":83.8859669117099,"d":"83.8860"},17]
[19,2022210546,"郭建豪","国际班",{"v":95.28,"d":"95.2800"},{"v":4,"d":"4.0000"},{"v":0,"d":"0.0000"},{"v":99.28,"d":"99.2800"},0.8752,{"v":87.5176304654443,"d":"87.5176"},{"v":84.7035714285714,"d":"84.7036"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":84.7035714285714,"d":"84.7036"},0.8298,{"v":82.9765798717017,"d":"82.9766"},{"v":100,"d":"100.0000"},{"v":1,"d":"1.0000"},{"v":0,"d":"0.0000"},{"v":101,"d":"101.0000"},0.8279,{"v":82.7868852459016,"d":"82.7869"},{"v":83.8658205278702,"d":"83.8658"},18]
[20,2022215303,"尹海川","国际班",95.6825,{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},95.6825,0.8435,{"v":84.346350493653,"d":"84.3464"},{"v":84.7153846153846,"d":"84.7154"},{"v":0.4,"d":"0.4000"},{"v":0,"d":"0.0000"},{"v":85.1153846153846,"d":"85.1154"},0.8338,{"v":83.38,"d":"83.3800"},{"v":100,"d":"100.0000"},{"v":1,"d":"1.0000"},{"v":0,"d":"0.0000"},{"v":101,"d":"101.0000"},0.8279,{"v":82.7868852459016,"d":"82.7869"},{"v":83.5139563435391,"d":"83.5140"},19]
[21,2022210677,"丁家正","国际班",95.5775,{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},95.5775,0.8425,{"v":84.2537905500705,"d":"84.2538"},{"v":84.15,"d":"84.1500"},{"v":0.6,"d":"0.6000"},{"v":0,"d":"0.0000"},{"v":84.75,"d":"84.7500"},0.8302,{"v":83.0220618271907,"d":"83.0221"},{"v":100,"d":"100.0000"},{"v":1,"d":"1.0000"},{"v":0,"d":"0.0000"},{"v":101,"d":"101.0000"},0.8279,{"v":82.7868852459016,"d":"82.7869"},{"v":83.2448899136377,"d":"83.2449"},20]
[22,2022210670,"胡昀涛","国际班",95.4375,{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},95.4375,0.8413,{"v":84.1303772919605,"d":"84.1304"},{"v":84.5272727272727,"d":"84.5273"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":84.5272727272727,"d":"84.5273"},{"v":0.828,"d":"0.8280"},{"v":82.8038756630967,"d":"82.8039"},{"v":100,"d":"100.0000"},{"v":1,"d":"1.0000"},{"v":0,"d":"0.0000"},{"v":101,"d":"101.0000"},0.8279,{"v":82.7868852459016,"d":"82.7869"},{"v":83.06747694715,"d":"83.0675"},21]