{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["化学工艺（学硕）","化学工程（学硕）","能源催化（学硕）","环境工程（学硕）","环境科学","化学工艺（专硕）","化学工程（专硕）","能源催化（专硕）","环境工程（专硕）","国际班"],"read":"whole","date_system":"1900"}

{"sheet":"化学工艺（学硕）","index":0,"n_rows":52,"n_cols":16,"rows_kept":52,"merged":[[0,0,1,0],[0,1,1,1],[0,2,0,5],[0,6,0,9],[0,10,0,13],[0,14,1,14],[0,15,1,15]]}
["学号","姓名","智育",{"$nulls":3},"德育",{"$nulls":3},"体育",{"$nulls":3},"综合测评总分","排名"]
[null,null,"基本分","奖惩分","总分","最终成绩","基本分","奖惩分","总分","最终成绩","基本分","奖惩分","总分","最终成绩"]
[2019210601,"王一帆",82.1375001,23.333333,105.4708331,97.36892709,101.6851849,11.9,113.5851849,83.08383197,100.5,0,100.5,90.95022624,94.82501536,1]
[2019210629,"刘萌萌",85.1732917,22.142857,107.3161487,99.0724919,98.9259259,0.4,99.3259259,72.65365237,100.5,0,100.5,90.95022624,93.9314748,2]
[2019210619,"闫星儒",81.4458332,26.875,108.3208332,100,93.4892705,-0.5,92.9892705,68.01859707,100,0,100,90.49773756,93.60371941,3]
[2019210580,"吴明珍",87.16708075,20.326,107.4930807,99.23583264,97.70769231,-1.5,96.20769231,70.37276692,100,0,100,90.49773756,93.53963623,4]
[2019210558,"闫璐",83.78583333,9.714,93.49983333,86.31749828,99.73846154,8,107.7384615,78.80714587,102.5,0,102.5,92.760181,86.43367797,5]
[2019210622,"要馨惠",86.1791669,0.8,86.9791669,80.29772698,112.4888892,18.3,130.7888892,95.6677766,100.5,1,101.5,91.85520362,85.4919642,6]
[2019210618,"孙思远",82.4416668,12.5,94.9416668,87.64857507,94.6925928,-1,93.6925928,68.53305424,100.9,0,100.9,91.31221719,85.15061339,7]
[2019210520,"赵洋",84.17883333,0,84.17883333,77.71250538,116.3115385,20.4,136.7115385,100,102.5,1,103.5,93.66515837,84.74875377,8]
[2019210559,"孙衍鹍",82.29416667,7.6435,89.93766667,83.02896498,101.4192308,11.2,112.6192308,82.37726825,100.5,0,100.5,90.95022624,84.64572914,9]
[2019210614,"蒋涛",86.684472,0,86.684472,80.02566952,108.4037036,9.9,118.3037036,86.53527342,110.5,0,110.5,100,84.37502335,10]
[2019210576,"张琪",88.175,0,88.175,81.4017003,98.80384615,9.9,108.7038462,79.51329301,102.5,0,102.5,92.760181,83.13384881,11]
[2019210536,"吕明珠",87.76086957,0.4,88.16086957,81.38865531,99.93076923,5.4,105.3307692,77.04599803,100.5,0,100.5,90.95022624,82.43125833,12]
[2019210575,"殷梦凡",85.92916667,1,86.92916667,80.25156759,98.83076923,10.4,109.2307692,79.89871993,102.5,0,102.5,92.760181,82.4058413,13]
[2019210553,"张平华",87.40869665,0,87.40869665,80.69426173,100.2076923,3,103.2076923,75.493037,102.5,0,102.5,92.760181,81.83459061,14]
[2019210574,"李孟岩",87.50869565,0,87.50869565,80.78657915,98.37692308,2.4,100.7769231,73.71500914,100.5,0,100.5,90.95022624,81.34360724,15]
[2019210529,"王奥诚",85.0975,3.6113333,88.7088333,81.89452636,97.54615385,-2.5,95.04615385,69.52313968,100.5,0,100.5,90.95022624,81.28079639,16]
[2019210541,"梁瑀晨",86.41180125,0,86.41180125,79.7739444,102.0730769,1,103.0730769,75.39457026,102.5,1,103.5,93.66515837,81.27067513,17]
[2019210550,"尹凯",87.37307692,0,87.37307692,80.66137819,99.41153846,-0.5,98.91153846,72.35054157,100,0,100,90.49773756,80.93307304,18]
[2019210625,"董美君",87.7310557,0,87.7310557,80.99185827,95.8518518,0,95.8518518,70.11248127,100.5,0,100.5,90.95022624,80.76679704,19]
[2019210623,"王永春",84.4708331,0,84.4708331,77.98207474,106.1074072,3,109.1074072,79.80848466,100.5,1,101.5,91.85520362,80.69914925,20]
[2019210630,"魏俊",87.9895654,0,87.9895654,81.23051014,94.4037036,-0.5,93.9037036,68.68747485,100.5,0,100.5,90.95022624,80.64885207,21]
[2019210631,"秦晨",88.2391301,0,88.2391301,81.46090414,95.2481482,-2.5,92.7481482,67.84222403,100.5,0,100.5,90.95022624,80.64107771,22]
[2019210624,"邢梦可",87.4546585,0,87.4546585,80.73669295,95.5925928,0,95.5925928,69.92284183,100.5,0,100.5,90.95022624,80.55025343,23]
[2019210635,"成艳",84.4838512,0.3,84.7838512,78.27104786,99.1851849,6,105.1851849,76.93950787,100.9,0,100.9,91.31221719,80.26763508,24]
[2019210620,"王朋",84.1583331,3.130333,87.2886661,80.58345151,94.2037036,0,94.2037036,68.906915,100.5,0,100.5,90.95022624,80.23979906,25]
[2019210551,"赵欣怡",89.775,0,89.775,82.87879381,91.16923077,-10,81.16923077,59.37262625,102,0,102,92.30769231,80.08968092,26]
[2019210606,"许顺年",86.1950308,0,86.1950308,79.57382551,100.040741,-5,95.040741,69.51918036,102.72,0,102.72,92.95927602,79.87751393,27]
[2019210632,"李聪聪",83.8043481,0,83.8043481,77.36678682,99.0222223,5.9,{"v":104.9222223,"d":"104.922222"},76.74715937,100,0,100,90.49773756,79.50618265,28]
[2019210617,"王梅",83.9461539,0,83.9461539,77.49769958,100.9,2.5,103.4,75.63370376,100.9,0,100.9,91.31221719,79.46513046,29]
[2019210603,"罗梦杰",85.4,0,85.4,78.83986624,94.3296295,2,{"v":96.3296295,"d":"96.329630"},70.46195997,100.5,0,100.5,90.95022624,79.33029836,30]
[2019210610,"黄萌",82.2043481,0,82.2043481,75.8896933,100.0222223,7.3,{"v":107.3222223,"d":"107.322222"},78.50268054,100.5,0,100.5,90.95022624,78.87332142,31]
[2019210540,"谢青青",83.7583851,0,83.7583851,77.32435454,99.27692308,0,{"v":99.27692308,"d":"99.276923"},72.61780841,100,1,101,91.40271493,78.75060986,32]
[2019210611,"贾亦静",83.6155277,0,83.6155277,77.19247095,99.4444446,0.5,{"v":99.9444446,"d":"99.944445"},73.10607848,100.5,0,100.5,90.95022624,78.70594536,33]
[2019210537,"霍佳宁",82.01521739,0,82.01521739,75.71509096,97.76153846,8,{"v":105.7615385,"d":"105.761539"},77.36109157,100.5,0,100.5,90.95022624,78.52278199,34]
[2019210519,"侯昆",83.47934783,0,83.47934783,77.06675194,93.75,3,{"v":96.75,"d":"96.750000"},70.76944718,100.5,0,100.5,90.95022624,78.1506158,35]
[2019210589,"李佳奇",83.64596273,0,83.64596273,77.22056807,94.80384615,1.5,{"v":96.30384615,"d":"96.303846"},70.4431003,100,0,100,90.49773756,78.14301771,36]
[2019210615,"范英韬",83.675155,0,83.675155,77.24751789,93.4962964,0,{"v":93.4962964,"d":"93.496296"},68.38946987,100,0,100,90.49773756,77.75115649,37]
[2019210586,"王叶",80.36956522,0.4,80.76956522,74.5651255,101.8192308,1,{"v":102.8192308,"d":"102.819231"},75.20889014,102.5,0,102.5,92.760181,77.48736588,38]
[2019210590,"李瞳",81.85217391,0,81.85217391,75.56457192,94.33076923,-0.5,{"v":93.83076923,"d":"93.830769"},68.63412576,102,0,102,92.30769231,76.8220255,39]
[2019210598,"史艳美",81.778882,0,81.778882,75.49691004,94.5925928,0,{"v":94.5925928,"d":"94.592593"},69.19137467,100.5,0,100.5,90.95022624,76.73611197,40]
[2019210557,"李正轩",80.7922619,1.339,82.1312619,75.82222134,93.69615385,-5,{"v":88.69615385,"d":"88.696154"},64.87832325,100,0,100,90.49773756,76.05121959,41]
[2019210637,"王武芹",79.9510872,0,79.9510872,73.80952014,99.459259,-2,97.459259,71.28824684,100.5,0,100.5,90.95022624,75.97431347,42]
[2019210554,"张红娟",77.54596273,0.05,77.59596273,71.63530822,101.1576923,4.5,{"v":105.6576923,"d":"105.657692"},77.28513152,100,0,100,90.49773756,75.60174206,43]
[2019210636,"闫金鹏",80.017391,0,80.017391,73.87073071,94.6,-3.5,{"v":91.1,"d":"91.100000"},66.63665776,104,0,104,94.11764706,75.43684305,44]
[2019210593,"李子为",78.7559007,0,78.7559007,72.70614375,98.2740741,0.5,{"v":98.7740741,"d":"98.774074"},72.2499909,100.9,0,100.9,91.31221719,75.43429881,45]
[2019210585,"李博凤",80.18136646,0,80.18136646,74.02211014,93.70769231,-1,{"v":92.70769231,"d":"92.707692"},67.81263188,100,0,100,90.49773756,75.37800348,46]
[2019210596,"李晗",76.8836955,0,76.8836955,70.97775491,108.3074072,-1.5,{"v":106.8074072,"d":"106.807407"},78.1261102,100.5,0,100.5,90.95022624,75.35965047,47]
[2019210528,"宋亦冬",77.01666667,3.6113333,80.62799997,74.4344348,93.25,-3,{"v":90.25,"d":"90.250000"},66.01491068,100.5,0,100.5,90.95022624,75.3570865,48]
[2019210581,"揭玮玮",74.48322981,0,74.48322981,68.76168472,100.7269231,1.9,{"v":102.6269231,"d":"102.626923"},75.06822338,100,0,100,90.49773756,73.14682398,49]
[2019210594,"张辉",74.5565218,0,74.5565218,68.82934667,98.5481482,-1.5,{"v":97.0481482,"d":"97.048148"},70.9875328,100.5,0,100.5,90.95022624,72.42804923,50]

{"sheet":"化学工程（学硕）","index":1,"n_rows":38,"n_cols":16,"rows_kept":38,"merged":[[0,0,1,0],[0,1,1,1],[0,2,0,5],[0,6,0,9],[0,10,0,13],[0,14,1,14],[0,15,1,15]]}
["学号","姓名","智育",{"$nulls":3},"德育",{"$nulls":3},"文体活动",{"$nulls":3},"综合测评总分","排名"]
[null,null,"基本分","奖惩分","总分","最终成绩","基本分","奖惩分","总分","最终成绩","基本分","奖惩分","总分","最终成绩"]
["2019210524","龚雅妮",{"v":94.0333343333333,"d":"94.033334"},{"v":13.8,"d":"13.800000"},{"v":107.833334333333,"d":"107.833334"},{"v":100,"d":"100.000000"},{"v":105.369411764706,"d":"105.369412"},{"v":11.4,"d":"11.400000"},{"v":116.769411764706,"d":"116.769412"},{"v":95.5194291199815,"d":"95.519429"},{"v":103.170588235294,"d":"103.170588"},{"v":0,"d":"0.000000"},{"v":103.170588235294,"d":"103.170588"},{"v":84.0580867787079,"d":"84.058087"},{"$f":"N3*0.1+J3*0.2+F3*0.7","v":{"v":97.5096945018671,"d":"97.509695"}},1]
["2019210607","武兴红",87.3086956521739,12.5,99.8086956521739,{"v":92.5582949551076,"d":"92.558295"},103.567352941176,{"v":5,"d":"5.000000"},108.567352941176,88.8100009864329,104.33431372549,0,104.33431372549,85.0062304300594,{"v":91.0534297088678,"d":"91.053430"},2]
["2019210526","陆炫彤",{"v":87.2758695652174,"d":"87.275870"},{"v":12,"d":"12.000000"},{"v":99.2758695652174,"d":"99.275870"},{"v":92.0641749408739,"d":"92.064175"},{"v":99.2694117647059,"d":"99.269412"},{"v":7,"d":"7.000000"},{"v":106.269411764706,"d":"106.269412"},{"v":86.9302447556654,"d":"86.930245"},{"v":104.337254901961,"d":"104.337255"},{"v":0,"d":"0.000000"},{"v":104.337254901961,"d":"104.337255"},{"v":85.008626749313,"d":"85.008627"},{"v":90.3318340846761,"d":"90.331834"},3]
["2019210608","张凌玮",91.1086956521739,7.5,98.6086956521739,{"v":91.4454665264785,"d":"91.445467"},98.2385294117647,{"v":-1,"d":"(1.000000)"},97.2385294117647,79.5428244221548,99.6264705882353,0,99.6264705882353,81.1705220780881,{"v":88.0374436607747,"d":"88.037444"},4]
["2019210515","陈弘男",{"v":93.4547609047619,"d":"93.454761"},{"v":0,"d":"0.000000"},{"v":93.4547609047619,"d":"93.454761"},{"v":86.6659289379622,"d":"86.665929"},{"v":101.257058823529,"d":"101.257059"},{"v":5,"d":"5.000000"},{"v":106.257058823529,"d":"106.257059"},{"v":86.9201398328838,"d":"86.920140"},{"v":100.152941176471,"d":"100.152941"},{"v":0,"d":"0.000000"},{"v":100.152941176471,"d":"100.152941"},{"v":81.5994632244872,"d":"81.599463"},{"v":86.2101245455991,"d":"86.210125"},5]
["2019210600","张红亮",{"$f":"E8-D8","v":87.1916666666667},6.25,93.4416666666667,{"v":86.6537859042926,"d":"86.653786"},107.057058823529,{"v":-1,"d":"(1.000000)"},106.057058823529,86.7565363211826,100.152941176471,0,100.152941176471,81.5994632244872,{"v":86.16890371969,"d":"86.168904"},6]
["2019210517","王惠珊",{"v":89.3833323333333,"d":"89.383332"},{"v":0,"d":"0.000000"},{"v":89.3833323333333,"d":"89.383332"},{"v":82.8902610551135,"d":"82.890261"},{"v":107.869411764706,"d":"107.869412"},{"v":9.5,"d":"9.500000"},{"v":117.369411764706,"d":"117.369412"},{"v":96.0102396550853,"d":"96.010240"},{"v":104.337254901961,"d":"104.337255"},{"v":0,"d":"0.000000"},{"v":104.337254901961,"d":"104.337255"},{"v":85.0086267493131,"d":"85.008627"},{"v":85.7260933445278,"d":"85.726093"},7]
["2019210512","梅馨元",87.500001,{"v":0,"d":"0.000000"},87.500001,{"v":81.1437405148958,"d":"81.143741"},{"v":109.069411764706,"d":"109.069412"},{"v":4.3,"d":"4.300000"},{"v":113.369411764706,"d":"113.369412"},{"v":92.7381694210601,"d":"92.738169"},{"v":111.070588235294,"d":"111.070588"},{"v":11.6666666666667,"d":"11.666667"},{"v":122.737254901961,"d":"122.737255"},100,{"v":85.3482522446391,"d":"85.348252"},8]
["2019210562","李佳",{"v":84.3304247826087,"d":"84.330425"},{"v":6.5,"d":"6.500000"},{"v":90.8304247826087,"d":"90.830425"},{"v":84.2322324021203,"d":"84.232232"},{"v":107.085882352941,"d":"107.085882"},{"v":0.9,"d":"0.900000"},{"v":107.985882352941,"d":"107.985882"},{"v":88.3343478355015,"d":"88.334348"},{"v":104.360784313725,"d":"104.360784"},{"v":0,"d":"0.000000"},{"v":104.360784313725,"d":"104.360784"},{"v":85.0277973033421,"d":"85.027797"},{"v":85.1322119789187,"d":"85.132212"},9]
["2019210579","唐钊艇",89.2608695652174,1.125,90.3858695652174,{"v":83.8199709987799,"d":"83.819971"},107.083823529412,{"v":0.5,"d":"0.500000"},107.583823529412,88.005456658302,100.191176470588,0,100.191176470588,81.6306153747843,{"v":84.4381325682848,"d":"84.438133"},10]
["2019210578","董滢滢",87.8347826086956,3,90.8347826086956,{"v":84.2362736627508,"d":"84.236274"},105.965294117647,{"v":-2.5,"d":"(2.500000)"},103.465294117647,84.6364272842539,99.6647058823529,0,99.6647058823529,81.2016742283852,{"v":84.0128444436149,"d":"84.012844"},11]
["2019210599","曾辉",88.1666666666667,0,88.1666666666667,{"v":81.7619776034438,"d":"81.761978"},102.777647058824,{"v":6,"d":"6.000000"},108.777647058824,88.9820252671188,99.6823529411765,0,99.6823529411765,81.216052143907,{"v":83.1513945902252,"d":"83.151395"},12]
["2019210563","王明龙",{"v":84.8833333333333,"d":"84.883333"},{"v":0,"d":"0.000000"},{"v":84.8833333333333,"d":"84.883333"},{"v":78.7171553751114,"d":"78.717155"},{"v":112.550882352941,"d":"112.550882"},{"v":2.9,"d":"2.900000"},{"v":115.450882352941,"d":"115.450882"},{"v":94.440848909751,"d":"94.440849"},{"v":104.810784313726,"d":"104.810784"},{"v":0,"d":"0.000000"},{"v":104.810784313726,"d":"104.810784"},{"v":85.3944341491469,"d":"85.394434"},{"v":82.5296219594429,"d":"82.529622"},13]
["2019210570","韩月明",{"v":87.2895652173913,"d":"87.289565"},{"v":0,"d":"0.000000"},{"v":87.2895652173913,"d":"87.289565"},{"v":80.9485914138226,"d":"80.948591"},{"v":104.281764705882,"d":"104.281765"},{"v":-0.5,"d":"(0.500000)"},{"v":103.781764705882,"d":"103.781765"},{"v":84.8953057821812,"d":"84.895306"},{"v":104.854901960784,"d":"104.854902"},{"v":0,"d":"0.000000"},{"v":104.854901960784,"d":"104.854902"},{"v":85.4303789379513,"d":"85.430379"},{"v":82.1861130399072,"d":"82.186113"},14]
["2019210572","尚伟康",{"v":85.6521639130435,"d":"85.652164"},{"v":2.23214285714286,"d":"2.232143"},{"v":87.8843067701863,"d":"87.884307"},{"v":81.5001291701871,"d":"81.500129"},{"v":101.748823529412,"d":"101.748824"},{"v":1,"d":"1.000000"},{"v":102.748823529412,"d":"102.748824"},84.0503417629241,{"v":101.641176470588,"d":"101.641176"},{"v":0,"d":"0.000000"},{"v":101.641176470588,"d":"101.641176"},{"v":82.8120007668222,"d":"82.812001"},{"v":82.141358848398,"d":"82.141359"},15]
["2019210511","邢中彬",{"v":82.1521729130435,"d":"82.152173"},{"v":5,"d":"5.000000"},{"v":87.1521729130435,"d":"87.152173"},{"v":80.8211796953617,"d":"80.821180"},{"v":98.7508823529412,"d":"98.750882"},{"v":-1,"d":"(1.000000)"},{"v":97.7508823529412,"d":"97.750882"},{"v":79.9619381241895,"d":"79.961938"},{"v":107.977450980392,"d":"107.977451"},{"v":8,"d":"8.000000"},{"v":115.977450980392,"d":"115.977451"},{"v":94.4924595820819,"d":"94.492460"},{"v":82.0164593697993,"d":"82.016459"},16]
["2019210613","曲美橙",86.05,0,86.05,{"v":79.7990719029453,"d":"79.799072"},106.777647058824,{"v":0.5,"d":"0.500000"},107.277647058824,87.7549989293593,100.182352941176,0,100.182352941176,81.6234264170234,{"v":81.5726927596359,"d":"81.572693"},17]
["2019210544","苏志勇",{"v":81.6416766666667,"d":"81.641677"},{"v":0,"d":"0.000000"},{"v":81.6416766666667,"d":"81.641677"},{"v":75.7109822963433,"d":"75.710982"},{"v":110.246764705882,"d":"110.246765"},{"v":12,"d":"12.000000"},{"v":122.246764705882,"d":"122.246765"},{"v":100,"d":"100.000000"},{"v":104.804901960784,"d":"104.804902"},{"v":0,"d":"0.000000"},{"v":104.804901960784,"d":"104.804902"},{"v":85.3896415106397,"d":"85.389642"},{"v":81.5366517585043,"d":"81.536652"},18]
["2019210571","朱碧才",{"v":87.5026086956522,"d":"87.502609"},{"v":0,"d":"0.000000"},{"v":87.5026086956522,"d":"87.502609"},{"v":81.1461587797749,"d":"81.146159"},{"v":99.2529411764706,"d":"99.252941"},{"v":0,"d":"0.000000"},{"v":99.2529411764706,"d":"99.252941"},{"v":81.1906486157459,"d":"81.190649"},{"v":100.147058823529,"d":"100.147059"},{"v":0,"d":"0.000000"},{"v":100.147058823529,"d":"100.147059"},{"v":81.5946705859799,"d":"81.594671"},{"v":81.1999079275896,"d":"81.199908"},19]
["2019210556","刘铭",{"v":85.76249,"d":"85.762490"},{"v":0,"d":"0.000000"},{"v":85.76249,"d":"85.762490"},{"v":79.532447485016,"d":"79.532447"},{"v":105.059117647059,"d":"105.059118"},{"v":-1,"d":"(1.000000)"},{"v":104.059117647059,"d":"104.059118"},{"v":85.1221853579669,"d":"85.122185"},{"v":99.6558823529412,"d":"99.655882"},{"v":0,"d":"0.000000"},{"v":99.6558823529412,"d":"99.655882"},{"v":81.1944852706243,"d":"81.194485"},{"v":80.816598838167,"d":"80.816599"},20]
["2019210555","魏如成",{"v":86.2916666666667,"d":"86.291667"},{"v":0,"d":"0.000000"},{"v":86.2916666666667,"d":"86.291667"},{"v":80.0231831837109,"d":"80.023183"},{"v":99.79,"d":"99.790000"},{"v":-0.5,"d":"(0.500000)"},{"v":99.29,"d":"99.290000"},{"v":81.2209633840905,"d":"81.220963"},{"v":104.366666666667,"d":"104.366667"},{"v":0,"d":"0.000000"},{"v":104.366666666667,"d":"104.366667"},{"v":85.0325899418493,"d":"85.032590"},{"v":80.7636798996006,"d":"80.763680"},21]
["2019210543","焦丛哲",{"v":84.4708233333333,"d":"84.470823"},{"v":0,"d":"0.000000"},{"v":84.4708233333333,"d":"84.470823"},{"v":78.3346113291999,"d":"78.334611"},{"v":105.544705882353,"d":"105.544706"},{"v":0,"d":"0.000000"},{"v":105.544705882353,"d":"105.544706"},{"v":86.3374226191478,"d":"86.337423"},{"v":99.635294117647,"d":"99.635294"},{"v":0,"d":"0.000000"},{"v":99.635294117647,"d":"99.635294"},{"v":81.1777110358489,"d":"81.177711"},{"v":80.2194835578544,"d":"80.219484"},22]
["2019210639","赵子毅",86.5333333333333,0,86.5333333333333,{"v":80.2472944644764,"d":"80.247294"},98.7879411764706,{"v":-1.5,"d":"(1.500000)"},97.2879411764706,79.583244113281,99.6970588235294,0,99.6970588235294,81.2280337401751,{"v":80.2125583218072,"d":"80.212558"},23]
["2019210633","张秋宁",83.4509316770186,0,83.4509316770186,{"v":77.3888076381428,"d":"77.388808"},106.052941176471,{"v":0,"d":"0.000000"},106.052941176471,86.7531680135887,99.6470588235294,0,99.6470588235294,81.1872963128634,{"v":79.641528580704,"d":"79.641529"},24]
["2019210573","宋子寒",85.0217391304348,0,85.0217391304348,{"v":78.8455069631961,"d":"78.845507"},98.7735294117647,{"v":0.5,"d":"0.500000"},99.2735294117647,81.2074901537151,100.176470588235,0,100.176470588235,81.6186337785162,{"v":79.5952162828319,"d":"79.595216"},25]
["2019210634","孔德凯",83.0708074534162,0,83.0708074534162,{"v":77.0362967694466,"d":"77.036297"},103.375588235294,{"v":0,"d":"0.000000"},103.375588235294,84.5630462973878,100.179411764706,0,100.179411764706,81.6210300977698,{"v":79.0001200078672,"d":"79.000120"},26]
["2019210516","陈欢",{"v":83.3916676666667,"d":"83.391668"},{"v":0,"d":"0.000000"},{"v":83.3916676666667,"d":"83.391668"},{"v":77.3338487418809,"d":"77.333849"},{"v":102.267352941176,"d":"102.267353"},{"v":0,"d":"0.000000"},{"v":102.267352941176,"d":"102.267353"},{"v":83.6564903678432,"d":"83.656490"},{"v":99.6676470588235,"d":"99.667647"},{"v":0,"d":"0.000000"},{"v":99.6676470588235,"d":"99.667647"},{"v":81.2040705476388,"d":"81.204071"},{"v":78.9853992476491,"d":"78.985399"},27]
["2019210542","王炳植",{"v":84.06249,"d":"84.062490"},{"v":0,"d":"0.000000"},{"v":84.06249,"d":"84.062490"},{"v":77.9559405444581,"d":"77.955941"},{"v":98.255,"d":"98.255000"},{"v":-1.5,"d":"(1.500000)"},{"v":96.755,"d":"96.755000"},{"v":79.147288873277,"d":"79.147289"},{"v":99.65,"d":"99.650000"},{"v":0,"d":"0.000000"},{"v":99.65,"d":"99.650000"},{"v":81.1896926321171,"d":"81.189693"},{"v":78.5175854189878,"d":"78.517585"},28]
["2019210538","苑学卿",{"v":82.2703713703704,"d":"82.270371"},{"v":0,"d":"0.000000"},{"v":82.2703713703704,"d":"82.270371"},{"v":76.294006745685,"d":"76.294007"},{"v":101.769411764706,"d":"101.769412"},{"v":0.5,"d":"0.500000"},{"v":102.269411764706,"d":"102.269412"},{"v":83.6581745216402,"d":"83.658175"},{"v":100.170588235294,"d":"100.170588"},{"v":0,"d":"0.000000"},{"v":100.170588235294,"d":"100.170588"},{"v":81.613841140009,"d":"81.613841"},{"v":78.2988237403084,"d":"78.298824"},29]
["2019210638","程真",83.6,0,83.6,{"v":77.5270471944942,"d":"77.527047"},98.2488235294118,{"v":-2.5,"d":"(2.500000)"},95.7488235294118,78.32421885338,99.6411764705882,0,99.6411764705882,81.1825036743562,{"v":78.0520271742575,"d":"78.052027"},30]
["2019210531","袁茜娅",{"v":81.6217401304348,"d":"81.621740"},{"v":0,"d":"0.000000"},{"v":81.6217401304348,"d":"81.621740"},{"v":75.6924940094373,"d":"75.692494"},{"v":102.748823529412,"d":"102.748824"},{"v":-0.5,"d":"(0.500000)"},{"v":102.248823529412,"d":"102.248824"},{"v":83.6413329836709,"d":"83.641333"},{"v":99.6411764705882,"d":"99.641176"},{"v":0,"d":"0.000000"},{"v":99.6411764705882,"d":"99.641176"},{"v":81.1825036743562,"d":"81.182504"},{"v":77.8312627707759,"d":"77.831263"},31]
["2019210549","蔡品希",{"v":79.975,"d":"79.975000"},{"v":0,"d":"0.000000"},{"v":79.975,"d":"79.975000"},{"v":74.1653779830104,"d":"74.165378"},{"v":104.746764705882,"d":"104.746765"},{"v":-0.5,"d":"(0.500000)"},{"v":104.246764705882,"d":"104.246765"},{"v":85.2756839468866,"d":"85.275684"},{"v":104.304901960784,"d":"104.304902"},{"v":0,"d":"0.000000"},{"v":104.304901960784,"d":"104.304902"},{"v":84.9822672375232,"d":"84.982267"},{"v":77.4691281012369,"d":"77.469128"},32]
["2019210577","李永祺",81.1652173913044,0.808333333333333,81.9735507246377,{"v":76.0187480350389,"d":"76.018748"},98.7611764705882,{"v":-1,"d":"(1.000000)"},97.7611764705882,79.9703588931741,99.6588235294118,0,99.6588235294118,81.1968815898779,{"v":77.3268835621498,"d":"77.326884"},33]
["2019210539","郑蕾",{"v":81.4041566666667,"d":"81.404157"},{"v":0,"d":"0.000000"},{"v":81.4041566666667,"d":"81.404157"},{"v":75.4907164560367,"d":"75.490716"},{"v":98.79,"d":"98.790000"},{"v":0,"d":"0.000000"},{"v":98.79,"d":"98.790000"},{"v":80.8119546048374,"d":"80.811955"},{"v":100.2,"d":"100.200000"},{"v":0,"d":"0.000000"},{"v":100.2,"d":"100.200000"},{"v":81.6378043325452,"d":"81.637804"},{"v":77.1696728734477,"d":"77.169673"},34]
["2019210597","张宇",80.325,0,80.325,{"v":74.4899529413606,"d":"74.489953"},98.2591176470588,{"v":3,"d":"3.000000"},101.259117647059,82.8317361941492,99.6558823529412,0,99.6558823529412,81.1944852706243,{"v":76.8287628248447,"d":"76.828763"},35]
["2019210530","崔峻巍",{"v":72.8596260434783,"d":"72.859626"},{"v":0.1,"d":"0.100000"},{"v":72.9596260434783,"d":"72.959626"},{"v":67.6596216694424,"d":"67.659622"},{"v":98.2570588235294,"d":"98.257059"},{"v":-2.5,"d":"(2.500000)"},{"v":95.7570588235294,"d":"95.757059"},{"v":78.3309554685677,"d":"78.330955"},{"v":99.6529411764706,"d":"99.652941"},{"v":0,"d":"0.000000"},{"v":99.6529411764706,"d":"99.652941"},{"v":81.1920889513707,"d":"81.192089"},{"v":71.1471351574603,"d":"71.147135"},36]

{"sheet":"能源催化（学硕）","index":2,"n_rows":29,"n_cols":16,"rows_kept":29,"merged":[[0,0,1,0],[0,1,1,1],[0,2,0,5],[0,6,0,9],[0,10,0,13],[0,14,1,14],[0,15,1,15]]}
["学号","姓名","智育",{"$nulls":3},"德育",{"$nulls":3},"体育",{"$nulls":3},"综合测评总分","排名"]
[null,null,"基本分","奖惩分","总分","最终成绩","基本分","奖惩分","总分","最终成绩","基本分","奖惩分","总分","最终成绩"]
["2019210513","杨正康",80.3900621118012,0.375,{"v":80.7650621118012,"d":"80.7651"},{"v":75.4771311762464,"d":"75.4771"},{"v":96.4,"d":"96.4000"},4,{"v":100.4,"d":"100.4000"},{"v":87.7255831916385,"d":"87.7256"},{"v":96.4,"d":"96.4000"},{"v":0.5,"d":"0.5000"},{"v":96.9,"d":"96.9000"},{"v":94.893477419955,"d":"94.8935"},79.8684562036957,23]
["2019210514","方华",82.1341614906832,0.46875,{"v":82.6029114906832,"d":"82.6029"},{"v":77.1946510422008,"d":"77.1947"},{"v":96.3086956521739,"d":"96.3087"},10,{"v":106.308695652174,"d":"106.3087"},{"v":92.8883697652326,"d":"92.8884"},{"v":96.3086956521739,"d":"96.3087"},{"v":0,"d":"0.0000"},{"v":96.3086956521739,"d":"96.3087"},{"v":94.3144172983992,"d":"94.3144"},82.045371412427,18]
["2019210522","武宝强",82.6726708074534,24.3333333333333,{"v":107.006004140787,"d":"107.0060"},{"v":100,"d":"100.0000"},{"v":96.4,"d":"96.4000"},-3,{"v":93.4,"d":"93.4000"},{"v":81.6092576703091,"d":"81.6093"},{"v":96.4,"d":"96.4000"},{"v":0.5,"d":"0.5000"},{"v":96.9,"d":"96.9000"},{"v":94.893477419955,"d":"94.8935"},95.8111992760573,1]
["2019210523","曹轶华",83.6149068322981,10.625,{"v":94.2399068322981,"d":"94.2399"},{"v":88.0697373843692,"d":"88.0697"},{"v":96.1869565217391,"d":"96.1870"},0,{"v":96.1869565217391,"d":"96.1870"},{"v":84.0443909989874,"d":"84.0444"},{"v":96.1869565217391,"d":"96.1870"},{"v":5.16666666666667,"d":"5.1667"},{"v":101.353623188406,"d":"101.3536"},{"v":99.254878776673,"d":"99.2549"},88.3831822465232,3]
["2019210527","范梦莹",89.1041666666667,7.5,{"v":96.6041666666667,"d":"96.6042"},{"v":90.2792020339022,"d":"90.2792"},{"v":96.2478260869565,"d":"96.2478"},13.9,{"v":110.147826086957,"d":"110.1478"},{"v":96.242851402086,"d":"96.2429"},{"v":96.2478260869565,"d":"96.2478"},{"v":5.16666666666667,"d":"5.1667"},{"v":101.414492753623,"d":"101.4145"},{"v":99.3144879068332,"d":"99.3145"},92.3754604948321,2]
["2019210532","陈超",90.8266666666667,0,{"v":90.8266666666667,"d":"90.8267"},{"v":84.8799722931125,"d":"84.8800"},{"v":96.3695652173913,"d":"96.3696"},14.7,{"v":111.069565217391,"d":"111.0696"},{"v":97.0482309117268,"d":"97.0482"},{"v":96.3695652173913,"d":"96.3696"},{"v":0.5,"d":"0.5000"},{"v":96.8695652173913,"d":"96.8696"},{"v":94.8636728548749,"d":"94.8637"},88.3119940730116,4]
["2019210533","孙炳",85.8625,0,85.8625,{"v":80.2408245120821,"d":"80.2408"},{"v":96.1869565217391,"d":"96.1870"},0.5,{"v":96.6869565217391,"d":"96.6870"},{"v":84.4812713933681,"d":"84.4813"},{"v":96.1869565217391,"d":"96.1870"},{"v":0.5,"d":"0.5000"},{"v":96.6869565217391,"d":"96.6870"},{"v":94.6848454643945,"d":"94.6848"},82.5333159835705,17]
["2019210534","栾孟坤",84.3875,0,84.3875,{"v":78.8623971875187,"d":"78.8624"},{"v":96.1565217391304,"d":"96.1565"},-3,{"v":93.1565217391304,"d":"93.1565"},{"v":81.3965159130454,"d":"81.3965"},{"v":96.1565217391304,"d":"96.1565"},{"v":0.5,"d":"0.5000"},{"v":96.6565217391304,"d":"96.6565"},{"v":94.6550408993144,"d":"94.6550"},80.9484853038036,20]
["2019210545","曹磊",80.9006211180124,0,{"v":80.9006211180124,"d":"80.9006"},{"v":75.6038147276038,"d":"75.6038"},{"v":96.1565217391304,"d":"96.1565"},-0.5,{"v":95.6565217391304,"d":"95.6565"},{"v":83.5809178849488,"d":"83.5809"},{"v":96.1565217391304,"d":"96.1565"},{"v":0,"d":"0.0000"},{"v":96.1565217391304,"d":"96.1565"},{"v":94.1653944729989,"d":"94.1654"},79.0553933336123,25]
["2019210547","马丽娅",83.495652173913,2.54285714285714,{"v":86.0385093167702,"d":"86.0385"},{"v":80.4053099708033,"d":"80.4053"},{"v":96.2173913043478,"d":"96.2174"},6,{"v":102.217391304348,"d":"102.2174"},{"v":89.3135484512134,"d":"89.3135"},{"v":96.2173913043478,"d":"96.2174"},{"v":0,"d":"0.0000"},{"v":96.2173913043478,"d":"96.2174"},{"v":94.225003603159,"d":"94.2250"},83.5689270301209,14]
["2019210548","刘园园",85.3347826086957,2.08333333333333,{"v":87.418115942029,"d":"87.4181"},{"v":81.6945896110781,"d":"81.6946"},{"v":96.9478260869565,"d":"96.9478"},17.5,{"v":114.447826086957,"d":"114.4478"},{"v":100.00002279376,"d":"100.0000"},{"v":96.9478260869565,"d":"96.9478"},{"v":5.16666666666667,"d":"5.1667"},{"v":102.114492753623,"d":"102.1145"},{"v":99.999992903675,"d":"100.0000"},87.1862165768741,5]
["2019210560","唐玉虎",82.8755434782609,8.86875,{"v":91.7442934782609,"d":"91.7443"},{"v":85.7375193241996,"d":"85.7375"},{"v":96.1565217391304,"d":"96.1565"},4,{"v":100.15652173913,"d":"100.1565"},{"v":87.5128414343748,"d":"87.5128"},{"v":96.1565217391304,"d":"96.1565"},{"v":0,"d":"0.0000"},{"v":96.1565217391304,"d":"96.1565"},{"v":94.1653944729989,"d":"94.1654"},86.9353712611146,6]
["2019210561","肖浩",87.5,1.53125,{"v":89.03125,"d":"89.0313"},{"v":83.2021069423941,"d":"83.2021"},{"v":96.8869565217391,"d":"96.8870"},7.4,{"v":104.286956521739,"d":"104.2870"},{"v":91.1218533879542,"d":"91.1219"},{"v":96.8869565217391,"d":"96.8870"},{"v":0,"d":"0.0000"},{"v":96.8869565217391,"d":"96.8870"},{"v":94.8807040349207,"d":"94.8807"},85.9539159407588,8]
["2019210565","邱锦涵",79.1217391304348,0,{"v":79.1217391304348,"d":"79.1217"},{"v":73.9414014809254,"d":"73.9414"},{"v":95.6695652173913,"d":"95.6696"},0,{"v":95.6695652173913,"d":"95.6696"},{"v":83.5923147648022,"d":"83.5923"},{"v":95.6695652173913,"d":"95.6696"},{"v":4.66666666666667,"d":"4.6667"},{"v":100.336231884058,"d":"100.3362"},{"v":98.2585547439961,"d":"98.2586"},78.3032994640078,26]
["2019210566","李呈玉",82.0093167701863,0,{"v":82.0093167701863,"d":"82.0093"},{"v":76.6399207490147,"d":"76.6399"},{"v":95.9434782608695,"d":"95.9435"},-1.5,{"v":94.4434782608695,"d":"94.4435"},{"v":82.5210080585818,"d":"82.5210"},{"v":95.9434782608695,"d":"95.9435"},{"v":0.5,"d":"0.5000"},{"v":96.4434782608695,"d":"96.4435"},{"v":94.4464089437539,"d":"94.4464"},79.596787030402,24]
["2019210567","周静",86.0141304347826,0.4375,{"v":86.4516304347826,"d":"86.4516"},{"v":80.7913828097338,"d":"80.7914"},{"v":96.1565217391304,"d":"96.1565"},7,{"v":103.15652173913,"d":"103.1565"},{"v":90.1341238006589,"d":"90.1341"},{"v":96.1565217391304,"d":"96.1565"},{"v":4.66666666666667,"d":"4.6667"},{"v":100.823188405797,"d":"100.8232"},{"v":98.7354277852774,"d":"98.7354"},84.4543355054732,10]
["2019210568","唐贺",87.3857142857143,0.40625,{"v":87.7919642857143,"d":"87.7920"},{"v":82.0439609820466,"d":"82.0440"},{"v":95.9739130434783,"d":"95.9739"},-1,{"v":94.9739130434783,"d":"94.9739"},{"v":82.9844811726204,"d":"82.9845"},{"v":95.9739130434783,"d":"95.9739"},{"v":4.66666666666667,"d":"4.6667"},{"v":100.640579710145,"d":"100.6406"},{"v":98.5566003947969,"d":"98.5566"},83.8833289614364,12]
["2019210569","翟文杰",79.2695652173913,0,{"v":79.2695652173913,"d":"79.2696"},{"v":74.0795489504468,"d":"74.0795"},{"v":95.9434782608695,"d":"95.9435"},-3.5,{"v":92.4434782608695,"d":"92.4435"},{"v":80.7734864810591,"d":"80.7735"},{"v":95.9434782608695,"d":"95.9435"},{"v":0,"d":"0.0000"},{"v":95.9434782608695,"d":"95.9435"},{"v":93.9567625174383,"d":"93.9568"},77.4060578132684,28]
["2019210587","武宗会",79.2309782608696,0.375,{"v":79.6059782608696,"d":"79.6060"},{"v":74.3939360226299,"d":"74.3939"},{"v":95.9130434782609,"d":"95.9130"},-4.5,{"v":91.4130434782609,"d":"91.4130"},{"v":79.8731329726398,"d":"79.8731"},{"v":95.9130434782609,"d":"95.9130"},{"v":4.66666666666667,"d":"4.6667"},{"v":100.579710144928,"d":"100.5797"},{"v":98.4969912646368,"d":"98.4970"},77.9000809368326,27]
["2019210588","李晴阳",82.8652173913043,0.375,{"v":83.2402173913043,"d":"83.2402"},{"v":77.7902306134018,"d":"77.7902"},{"v":96.1869565217391,"d":"96.1870"},1,{"v":97.1869565217391,"d":"97.1870"},{"v":84.9181517877487,"d":"84.9182"},{"v":96.1869565217391,"d":"96.1870"},{"v":0,"d":"0.0000"},{"v":96.1869565217391,"d":"96.1870"},{"v":94.1951990380789,"d":"94.1952"},80.8563116907389,21]
["2019210591","赵吉雨",85.3987577639752,0.375,{"v":85.7737577639752,"d":"85.7738"},{"v":80.1578924965028,"d":"80.1579"},{"v":96.3695652173913,"d":"96.3696"},7,{"v":103.369565217391,"d":"103.3696"},{"v":90.3202728382645,"d":"90.3203"},{"v":96.3695652173913,"d":"96.3696"},{"v":0,"d":"0.0000"},{"v":96.3695652173913,"d":"96.3696"},{"v":94.3740264285594,"d":"94.3740"},83.6119819580608,13]
["2019210592","夏添",84.2875776397516,0.1875,{"v":84.4750776397516,"d":"84.4751"},{"v":78.9442408564369,"d":"78.9442"},{"v":96.2173913043478,"d":"96.2174"},5.5,{"v":101.717391304348,"d":"101.7174"},{"v":88.8766680568327,"d":"88.8767"},{"v":96.2173913043478,"d":"96.2174"},{"v":5.16666666666667,"d":"5.1667"},{"v":101.384057971014,"d":"101.3841"},{"v":99.2846833417531,"d":"99.2847"},82.9647705450477,16]
["2019210612","杨江蒨",87.7491666666667,0.375,{"v":88.1241666666667,"d":"88.1242"},{"v":82.3544130764126,"d":"82.3544"},{"v":95.6086956521739,"d":"95.6087"},10.2,{"v":105.808695652174,"d":"105.8087"},{"v":92.451489370852,"d":"92.4515"},{"v":95.6086956521739,"d":"95.6087"},{"v":0,"d":"0.0000"},{"v":95.6086956521739,"d":"95.6087"},{"v":93.6289123015575,"d":"93.6289"},85.5012782578149,9]
["2019210616","刘昊",86.904347826087,0,{"v":86.904347826087,"d":"86.9043"},{"v":81.2144594351433,"d":"81.2145"},{"v":95.8826086956522,"d":"95.8826"},1,{"v":96.8826086956522,"d":"96.8826"},{"v":84.6522245911692,"d":"84.6522"},{"v":95.8826086956522,"d":"95.8826"},{"v":0,"d":"0.0000"},{"v":95.8826086956522,"d":"95.8826"},{"v":93.8971533872782,"d":"93.8972"},83.1702818615619,15]
["2019210621","任东成",89.8217391304348,0.883333333333333,{"v":90.7050724637681,"d":"90.7051"},{"v":84.7663392274964,"d":"84.7663"},{"v":96.2478260869565,"d":"96.2478"},7,{"v":103.247826086957,"d":"103.2478"},{"v":90.2139019596327,"d":"90.2139"},{"v":96.2478260869565,"d":"96.2478"},{"v":0,"d":"0.0000"},{"v":96.2478260869565,"d":"96.2478"},{"v":94.2548081682391,"d":"94.2548"},86.8046986679979,7]
["2019210640","杨子瑶",84.3141666666667,0.375,{"v":84.6891666666667,"d":"84.6892"},{"v":79.1443128324294,"d":"79.1443"},{"v":96.4,"d":"96.4000"},-1,{"v":95.4,"d":"95.4000"},{"v":83.3567792478318,"d":"83.3568"},{"v":96.4,"d":"96.4000"},{"v":0.5,"d":"0.5000"},{"v":96.9,"d":"96.9000"},{"v":94.893477419955,"d":"94.8935"},81.5617225742624,19]
["2019210641","刘孟",79.2928571428571,2.1,{"v":81.3928571428571,"d":"81.3929"},{"v":76.0638225830481,"d":"76.0638"},{"v":96.8869565217391,"d":"96.8870"},6,{"v":102.886956521739,"d":"102.8870"},{"v":89.8985882836884,"d":"89.8986"},{"v":96.8869565217391,"d":"96.8870"},{"v":0.5,"d":"0.5000"},{"v":97.3869565217391,"d":"97.3870"},{"v":95.3703504612363,"d":"95.3704"},80.761428510995,22]

{"sheet":"环境工程（学硕）","index":3,"n_rows":22,"n_cols":16,"rows_kept":22,"merged":[[0,0,1,0],[0,1,1,1],[0,2,0,5],[0,6,0,9],[0,10,0,13],[0,14,1,14],[0,15,1,15]]}
["学号","姓名","智育",{"$nulls":3},"德育",{"$nulls":3},"体育",{"$nulls":3},"综合测评总分","排名"]
[null,null,"基本分","奖惩分","总分","最终成绩","基本分","奖惩分","总分","最终成绩","基本分","奖惩分","总分","最终成绩"]
["2019210646","李倩文",80.7577540106952,null,80.7577540106952,72.893037085186,99.5725,4,103.5725,85.5826079052723,98.625,null,98.625,95.8144740331846,77.7230949440031,16]
["2019210647","王玉欢",85.1,null,85.1,76.8124068325105,102.52,9,111.52,92.1496771208184,98.675,null,98.675,95.8630491784486,81.7849251247659,6]
["2019210648","王储",84.0227272727273,null,84.0227272727273,75.8400459512315,105.5375,13,118.5375,97.9482814894997,98.55,0.5,99.05,96.2273627679284,82.3004247405548,4]
["2019210649","邵晨",82.027840911,1,83.027840911,74.9420481137567,98.0025,9,107.0025,88.4168384695155,98.575,1,99.575,96.7374017932001,79.8165415528528,9]
["2019210650","张可",80.5923076923077,null,80.5923076923077,72.7437030086064,102.055,10.5,112.555,93.0049041278131,98.675,0.5,99.175,96.3488006310883,79.1564529946959,11]
["2019210651","揭靖成",80.7115384615385,null,80.7115384615385,72.8513223077028,97.6075,5,102.6075,84.7852223383642,98.575,null,98.575,95.7658988879206,77.5295599718569,17]
["2019210652","李敏",84.7692307692308,7,91.7692307692308,{"$f":"E9/E13*100","v":82.8321444013242},103.082,8.4,111.482,92.1182774819142,98.625,0.5,99.125,96.3002254858243,{"$f":"F9*0.7+J9*0.2+N9*0.1","v":86.0361791258922},2]
["2019210653","翟光耀",82.4111111111111,0.125,82.5361111111111,74.4982061696822,104.855,7.4,112.255,92.7570122417277,98.55,0.5,99.05,96.2273627679284,80.3228830439159,7]
["2019210654","李娟娟",79.9307692307692,0.875,80.8057692307692,72.936376269892,97.95,11,108.95,90.0260699633533,98.625,null,98.625,95.8144740331846,78.6421247849135,13]
["2019210655","黄子萌",89.0238636363636,null,89.0238636363636,80.3541390298273,97.5725,19.5,117.0725,96.7377427791159,98.6,4.3333,102.9333,100,85.5954458767023,3]
["2019210656","姜梁妍",90.5227272727273,20.2666666666667,110.789393939394,100,104.5205,16.5,121.0205,100,98.75,1,99.75,96.907414801624,99.6907414801624,1]
["2019210657","李晓萌",75.41,null,75.41,68.066082247234,97.5375,5,102.5375,84.7273808982776,98.575,null,98.575,95.7658988879206,74.1683236415114,20]
["2019210658","马志楠",80.9772727272727,null,80.9772727272727,73.0911776370673,101.125,3,104.125,86.0391421288129,98.7,3.3333,102.0333,99.1256473852485,78.2842175102346,15]
["2019210659","刘涛",82.0261363636364,null,82.0261363636364,74.0378960900425,97.5725,5,102.5725,84.7563016183209,98.575,null,98.575,95.7658988879206,78.354377475486,14]
["2019210660","郭晓培",82.3530303030303,null,82.3530303030303,74.3329549650579,101.4675,4,105.4675,87.1484583190451,98.525,null,98.525,95.7173237426567,79.0344925136152,12]
["2019210661","肖向群",77.3857142857143,0.233333333333333,77.6190476190476,70.0599983979588,98.485,9.5,107.985,89.2286843964452,98.675,0.5,99.175,96.3488006310883,76.522615820969,18]
["2019210662","尹子涵",86.5255681818182,null,86.5255681818182,78.0991438847937,99.485,7,106.485,87.9892249660182,98.675,null,98.675,95.8630491784486,81.8535506304041,5]
["2019210663","李鹏",77.2754010695187,null,77.2754010695187,69.7498183912725,100.2925,5,105.2925,87.0038547188286,98.225,null,98.225,95.4258728710728,75.7682311047637,19]
["2019210664","张瑞哲",83.5096590909091,null,83.5096590909091,75.3769436960654,102.4595,6,108.4595,89.6207667296037,98.55,0.5,99.05,96.2273627679284,80.3107502099594,8]
["2019210665","曲金秋",81.5511363636364,null,81.5511363636364,73.6091546888035,103.963,6.5,110.463,91.2762713755108,98.625,null,98.625,95.8144740331846,79.363109960583,10]

{"sheet":"环境科学","index":4,"n_rows":9,"n_cols":16,"rows_kept":9,"merged":[[0,0,1,0],[0,1,1,1],[0,2,0,5],[0,6,0,9],[0,10,0,13],[0,14,1,14],[0,15,1,15]]}
["学号","姓名","智育",{"$nulls":3},"德育",{"$nulls":3},"体育",{"$nulls":3},"综合测评总分","排名"]
[null,null,"基本分","奖惩分","总分","最终成绩","基本分","奖惩分","总分","最终成绩","基本分","奖惩分","总分","最终成绩"]
["2019210501","陈滢谕",86.3088888888889,null,86.3088888888889,88.5689302719539,97.555,7,104.555,85.9898017929106,98.6,null,98.6,99.8481012658228,89.1810216755322,5]
["2019210504","邓萌",89.1555555555556,null,89.1555555555556,91.4901383277322,102.225,10,112.225,92.2978863393371,98.75,null,98.75,100,92.50267409728,3]
["2019210505","梁宇航",88.5933333333333,5,93.5933333333333,96.0441215341251,102.0285,12.4,114.4285,94.1101241878444,98.5,null,98.5,99.746835443038,96.0275934557602,2]
["2019210506","刘欣渝",85.0633333333333,null,85.0633333333333,87.2907592217871,104.39,17.2,121.59,100,98.7,null,98.7,99.9493670886076,91.0984681641117,4]
["2019210507","王靖菡",83.5366666666667,null,83.5366666666667,85.7241160255969,97.45,5,102.45,84.2585738958796,98.525,null,98.525,99.7721518987342,86.8358111869671,7]
["2019210508","周博瑶",87.4212121212121,10.0270562770563,97.4482683982684,100,101.5025,7,108.5025,89.2363681223785,98.55,null,98.55,99.7974683544304,97.8270204599187,1]
["2019210510","曾成",84.5833333333333,null,84.5833333333333,86.7981901819369,97.5725,3.5,101.0725,83.1256682292952,98.675,null,98.675,99.9240506329114,87.376271836506,6]

{"sheet":"化学工艺（专硕）","index":5,"n_rows":45,"n_cols":16,"rows_kept":45,"merged":[[0,0,1,0],[0,1,1,1],[0,2,0,5],[0,6,0,9],[0,10,0,13],[0,14,1,14],[0,15,1,15]]}
["学号","姓名","智育",{"$nulls":3},"德育",{"$nulls":3},"体育",{"$nulls":3},"综合测评总分","排名"]
[null,null,"基本分","奖惩分","总分","最终成绩","基本分","奖惩分","总分","最终成绩","基本分","奖惩分","总分","最终成绩"]
[2019215203,"谢浩东",{"v":82.6,"d":"82.600000"},{"v":0.875,"d":"0.875000"},{"v":83.475,"d":"83.475000"},{"v":73.3307080054829,"d":"73.330708"},108.679069767442,{"v":8.2,"d":"8.20"},{"v":116.879069767442,"d":"116.879070"},{"v":93.2828479524046,"d":"93.2828480"},{"v":97.5930232558139,"d":"97.593023"},{"v":0,"d":"0.000000"},{"v":97.5930232558139,"d":"97.593023"},{"v":88.8768875833837,"d":"88.876888"},{"$f":"F3*0.7+J3*0.2+N3*0.1","v":{"v":78.8757539526573,"d":"78.875754"}},{"$f":"RANK(O3,$O$3:$O$44)","v":7}]
[2019215204,"于亚楠",85.296875,{"v":0.177083333333333,"d":"0.177083"},{"v":85.4739583333333,"d":"85.473958"},{"v":75.0867431040968,"d":"75.086743"},103.613953488372,{"v":8.2,"d":"8.20"},{"v":111.813953488372,"d":"111.813953"},{"v":89.2403066089302,"d":"89.2403066"},{"v":97.5,"d":"97.500000"},{"v":0,"d":"0.000000"},{"v":97.5,"d":"97.500000"},{"v":88.7921723325,"d":"89"},{"v":79.2879987279038,"d":"79.287999"},{"$f":"RANK(O4,$O$3:$O$45)","v":6}]
[2019215205,"李益衡",{"v":79.5933333333333,"d":"79.593333"},null,{"v":79.5933333333333,"d":"79.593333"},{"v":69.9207605372834,"d":"69.920761"},96.753488372093,{"v":-3,"d":"-3.00"},{"v":93.753488372093,"d":"93.753488"},{"v":74.8259925256326,"d":"74.8259925"},{"v":97.5232558139535,"d":"97.523256"},{"v":0,"d":"0.000000"},{"v":97.5232558139535,"d":"97.523256"},{"v":88.8133511452209,"d":"88.813351"},{"v":72.791065995747,"d":"72.791066"},{"$f":"RANK(O5,$O$3:$O$45)","v":37}]
[2019215206,"刘欣",{"v":83.9241379310345,"d":"83.924138"},null,{"v":83.9241379310345,"d":"83.924138"},{"v":73.7252644891592,"d":"73.725264"},102.513953488372,{"v":5.5,"d":"5.50"},{"v":108.013953488372,"d":"108.013953"},{"v":86.2074725615302,"d":"86.2074726"},{"v":103.980620488372,"d":"103.980620"},{"v":0,"d":"0.000000"},{"v":103.980620488372,"d":"103.980620"},{"v":94.6940017809622,"d":"94.694002"},{"v":78.3185798328137,"d":"78.318580"},{"$f":"RANK(O6,$O$3:$O$45)","v":11}]
[2019215207,"赵芳钰",{"v":80.1566666666667,"d":"80.156667"},null,{"v":80.1566666666667,"d":"80.156667"},{"v":70.4156348370908,"d":"70.415635"},111.574418604651,{"v":7.2,"d":"7.20"},{"v":118.774418604651,"d":"118.77441860"},{"v":94.7955528169279,"d":"94.795553"},{"v":97.8255813953488,"d":"97.825581"},{"v":0,"d":"0.000000"},{"v":98.8255813953488,"d":"98.825581"},{"v":89.999364657593,"d":"89.999365"},{"v":77.2499914151085,"d":"77.249991"},{"$f":"RANK(O7,$O$3:$O$45)","v":20}]
[2019215208,"王梦雅",{"v":79.7931034482759,"d":"79.793103"},null,{"v":79.7931034482759,"d":"79.793103"},{"v":70.0962536066704,"d":"70.096254"},113.932558139535,{"v":-5,"d":"-5.00"},{"v":108.932558139535,"d":"108.932558"},{"v":86.9406239989372,"d":"86.9406240"},{"v":104.375969325581,"d":"104.375969"},{"v":0,"d":"0.000000"},{"v":104.375969325581,"d":"104.375969"},{"v":95.054041597218,"d":"95.054042"},{"v":75.9609064841785,"d":"75.960906"},{"$f":"RANK(O8,$O$3:$O$45)","v":27}]
[2019215214,"林正令",{"v":78.8958620689655,"d":"78.895862"},null,{"v":78.8958620689655,"d":"78.895862"},{"v":69.3080494066507,"d":"69.308049"},96.9813953488372,{"v":-5,"d":"-5.00"},{"v":91.9813953488372,"d":"91.981395"},{"v":73.411659879293,"d":"73.4116599"},{"v":97.7790697674419,"d":"97.779070"},{"v":0,"d":"0.000000"},{"v":97.7790697674419,"d":"97.779070"},{"v":89.0463180851512,"d":"89.046318"},{"v":72.1025983690292,"d":"72.102598"},{"$f":"RANK(O9,$O$3:$O$45)","v":40}]
[2019215218,"史永鑫",{"v":84.0344827586207,"d":"84.034483"},null,{"v":84.0344827586207,"d":"84.034483"},{"v":73.8221996713291,"d":"73.822200"},101.993023255814,{"v":-2,"d":"-2.00"},{"v":99.993023255814,"d":"99.993023"},{"v":79.8058540612349,"d":"79.8058541"},{"v":96.6046511627907,"d":"96.604651"},{"v":0,"d":"0.000000"},{"v":96.6046511627907,"d":"96.604651"},{"v":87.9767880427442,"d":"87.976788"},{"v":76.4343893864518,"d":"76.434389"},{"$f":"RANK(O10,$O$3:$O$45)","v":23}]
[2019215219,"刘俊良",{"v":83.2413793103448,"d":"83.241379"},null,{"v":83.2413793103448,"d":"83.241379"},{"v":73.1254780494824,"d":"73.125478"},108.744186046512,{"v":2.7,"d":"2.70"},{"v":111.444186046512,"d":"111.444186"},{"v":88.9451899543791,"d":"88.9451900"},{"v":97.7558139534884,"d":"97.755814"},{"v":0,"d":"0.000000"},{"v":97.7558139534884,"d":"97.755814"},{"v":89.0251392724302,"d":"89.025139"},{"v":77.8793865527565,"d":"77.879387"},{"$f":"RANK(O11,$O$3:$O$45)","v":14}]
[2019215225,"王璇",{"v":82.5862068965517,"d":"82.586207"},null,{"v":82.5862068965517,"d":"82.586207"},{"v":72.5499254053481,"d":"72.549925"},100.323255813953,{"v":1,"d":"1.00"},{"v":101.323255813953,"d":"101.323256"},{"v":80.8675315857837,"d":"80.8675316"},{"v":97.2906976744186,"d":"97.290698"},{"v":0,"d":"0.000000"},{"v":97.2906976744186,"d":"97.290698"},{"v":88.6015630180116,"d":"88.601563"},{"v":75.8186104027016,"d":"75.818610"},{"$f":"RANK(O12,$O$3:$O$45)","v":28}]
[2019215226,"徐文元",{"v":84.24137931,"d":"84.241379"},null,{"v":84.24137931,"d":"84.241379"},{"v":74.0039531375949,"d":"74.003953"},98.193023255814,{"v":-1,"d":"-1.00"},{"v":97.193023255814,"d":"97.193023"},{"v":77.5711342368349,"d":"77.5711342"},{"v":97.8023255813954,"d":"97.802326"},{"v":0,"d":"0.000000"},{"v":97.8023255813954,"d":"97.802326"},{"v":89.0674968978721,"d":"89.067497"},{"v":76.2237437334706,"d":"76.223744"},{"$f":"RANK(O13,$O$3:$O$45)","v":25}]
[2019215236,"张娟",{"v":78.65625,"d":"78.656250"},{"v":0.125,"d":"0.125000"},{"v":78.78125,"d":"78.781250"},{"v":69.2073655592327,"d":"69.207366"},96.7372093023256,{"v":-3,"d":"-3.00"},{"v":93.7372093023256,"d":"93.737209"},{"v":74.8129999685139,"d":"74.8130000"},{"v":97.4302325581395,"d":"97.430233"},{"v":0,"d":"0.000000"},{"v":97.4302325581395,"d":"97.430233"},{"v":88.7286358943372,"d":"88.728636"},{"v":72.2806194745994,"d":"72.280619"},{"$f":"RANK(O14,$O$3:$O$45)","v":38}]
[2019215238,"杨子盼",{"v":82.4451409931034,"d":"82.445141"},{"v":12.5,"d":"12.500000"},{"v":94.9451409931035,"d":"94.945141"},{"v":83.4069411285376,"d":"83.406941"},99.4651162790698,{"v":-0.5,"d":"-0.50"},{"v":98.9651162790698,"d":"98.965116"},{"v":78.9854668831744,"d":"78.9854669"},{"v":96.9069767441861,"d":"96.906977"},{"v":0,"d":"0.000000"},{"v":96.9069767441861,"d":"96.906977"},{"v":88.2521126081163,"d":"88.252113"},{"v":83.0071634274228,"d":"83.007163"},{"$f":"RANK(O15,$O$3:$O$45)","v":2}]
[2019215240,"许佳翠",{"v":86.8666666666667,"d":"86.866667"},null,{"v":86.8666666666667,"d":"86.866667"},{"v":76.3102026803588,"d":"76.310203"},98.4,{"v":-3,"d":"-3.00"},{"v":95.4,"d":"95.400000"},{"v":76.1400968742,"d":"76.1400969"},{"v":97.6162790697674,"d":"97.616279"},{"v":0,"d":"0.000000"},{"v":97.6162790697674,"d":"97.616279"},{"v":88.8980663961047,"d":"88.898066"},{"v":77.5349678907016,"d":"77.534968"},{"$f":"RANK(O16,$O$3:$O$45)","v":16}]
[2019215241,"宋传洋",{"v":82.9827586206897,"d":"82.982759"},null,{"v":82.9827586206897,"d":"82.982759"},{"v":72.8982862162715,"d":"72.898286"},101.774418604651,{"v":1,"d":"1.00"},{"v":102.774418604651,"d":"102.774419"},{"v":82.0257252489279,"d":"82.0257252"},{"v":109.806976744186,"d":"109.806977"},{"v":0,"d":"0.000000"},{"v":109.806976744186,"d":"109.806977"},{"v":100.000000024416,"d":"100.000000"},{"v":77.4339454036173,"d":"77.433945"},{"$f":"RANK(O17,$O$3:$O$45)","v":18}]
[2019215242,"孙冬",{"v":78.2413793103448,"d":"78.241379"},{"v":0.5555556,"d":"0.555556"},{"v":78.7969349103448,"d":"78.796935"},{"v":69.2211443622347,"d":"69.221144"},101.404651162791,{"v":-1.5,"d":"-1.50"},{"v":99.9046511627907,"d":"99.904651"},{"v":79.7353230368767,"d":"79.7353230"},{"v":98.1511627906977,"d":"98.151163"},{"v":0,"d":"0.000000"},{"v":98.1511627906977,"d":"98.151163"},{"v":89.385179088686,"d":"89.385179"},{"v":73.3403835698082,"d":"73.340384"},{"$f":"RANK(O18,$O$3:$O$45)","v":34}]
[2019215243,"俎文波",{"v":84.6551724137931,"d":"84.655172"},{"v":0.125,"d":"0.125000"},{"v":84.7801724137931,"d":"84.780172"},{"v":74.4772694570873,"d":"74.477269"},96.3186046511628,{"v":0,"d":"0.00"},{"v":96.3186046511628,"d":"96.318605"},{"v":76.873248311607,"d":"76.8732483"},{"v":97.2906976744186,"d":"97.290698"},{"v":0,"d":"0.000000"},{"v":97.2906976744186,"d":"97.290698"},{"v":88.6015630180116,"d":"88.601563"},{"v":76.3688945840836,"d":"76.368895"},{"$f":"RANK(O19,$O$3:$O$45)","v":24}]
[2019215244,"王钢",{"v":80.83448276,"d":"80.834483"},null,{"v":80.83448276,"d":"80.834483"},{"v":71.0110793896113,"d":"71.011079"},97.2697674418605,{"v":-1.5,"d":"-1.50"},{"v":95.7697674418605,"d":"95.769767"},{"v":76.4352135287512,"d":"76.4352135"},{"v":97.1976744186046,"d":"97.197674"},{"v":0,"d":"0.000000"},{"v":97.1976744186046,"d":"97.197674"},{"v":88.5168477671279,"d":"88.516848"},{"v":73.8464830551909,"d":"73.846483"},{"$f":"RANK(O20,$O$3:$O$45)","v":32}]
[2019215245,"张翠娇",{"v":85.0551724137931,"d":"85.055172"},null,{"v":85.0551724137931,"d":"85.055172"},{"v":74.7188501064015,"d":"74.718850"},99.2697674418605,{"v":0,"d":"0.00"},{"v":99.2697674418605,"d":"99.269767"},{"v":79.2286133092512,"d":"79.2286133"},{"v":97.453488372093,"d":"97.453488"},{"v":0,"d":"0.000000"},{"v":97.453488372093,"d":"97.453488"},{"v":88.7498147070581,"d":"88.749815"},{"v":77.0238992070371,"d":"77.023899"},{"$f":"RANK(O21,$O$3:$O$45)","v":22}]
[2019215247,"徐世梅",{"v":81.8965517241379,"d":"81.896552"},null,{"v":81.8965517241379,"d":"81.896552"},{"v":71.9440805167857,"d":"71.944081"},97.9488372093023,{"v":-2.5,"d":"-2.50"},{"v":95.4488372093023,"d":"95.448837"},{"v":76.1790745455558,"d":"76.1790745"},{"v":97.546511627907,"d":"97.546512"},{"v":0,"d":"0.000000"},{"v":97.546511627907,"d":"97.546512"},{"v":88.8345299579419,"d":"88.834530"},{"v":74.4801242666553,"d":"74.480124"},{"$f":"RANK(O22,$O$3:$O$45)","v":31}]
[2019215248,"高慧慧",{"v":84.2931034482759,"d":"84.293103"},{"v":1.25,"d":"1.250000"},{"v":85.5431034482759,"d":"85.543103"},{"v":75.1474853650594,"d":"75.147485"},102.627906976744,{"v":0,"d":"0.00"},{"v":102.627906976744,"d":"102.627907"},{"v":81.9087922348605,"d":"81.9087922"},{"v":97.4767441860465,"d":"97.476744"},{"v":0,"d":"0.000000"},{"v":97.4767441860465,"d":"97.476744"},{"v":88.7709935197791,"d":"88.770994"},{"v":77.8620975544916,"d":"77.862098"},{"$f":"RANK(O23,$O$3:$O$45)","v":15}]
[2019215249,"高海洋",85.448275862069,null,85.448275862069,{"v":75.0641816928821,"d":"75.064182"},106.079069767442,{"v":-1,"d":"-1.00"},105.079069767442,{"v":83.8651001210046,"d":"83.8651001"},99.7790697674419,{"v":0,"d":"0.000000"},{"v":99.7790697674419,"d":"99.779070"},90.8676959791512,{"v":78.4047168071335,"d":"78.404717"},{"$f":"RANK(O24,$O$3:$O$45)","v":9}]
[2019215251,"栾明月",89.7793103448276,null,89.7793103448276,{"v":78.868887593054,"d":"78.868888"},101.660465116279,{"v":8.5,"d":"8.50"},110.160465116279,{"v":87.9206340215977,"d":"87.9206340"},97.9418604651163,{"v":0,"d":"0.000000"},{"v":97.9418604651163,"d":"97.941860"},89.1945697741977,{"v":81.7118050968771,"d":"81.711805"},{"$f":"RANK(O25,$O$3:$O$45)","v":4}]
[2019215254,"李之辉",80.1379310344828,null,80.1379310344828,{"v":70.3991760509516,"d":"70.399176"},96.4488372093023,{"v":-4.5,"d":"-4.50"},91.9488372093023,{"v":73.3856747650558,"d":"73.3856748"},97.7790697674419,{"v":0,"d":"0.000000"},{"v":97.7790697674419,"d":"97.779070"},89.0463180851512,{"v":72.8611899971924,"d":"72.861190"},{"$f":"RANK(O26,$O$3:$O$45)","v":36}]
[2019215255,"刘子成",81.2758620689655,null,81.2758620689655,{"v":71.3988201170795,"d":"71.398820"},100.241860465116,{"v":1,"d":"1.00"},101.241860465116,{"v":80.8025688001907,"d":"80.8025688"},97.7325581395349,{"v":0,"d":"0.000000"},{"v":97.7325581395349,"d":"97.732558"},89.0039604597093,{"v":75.0400838879648,"d":"75.040084"},{"$f":"RANK(O27,$O$3:$O$45)","v":29}]
[2019215257,"李正宇",90.4586206896552,{"v":23.375,"d":"23.375000"},113.833620689655,{"v":100,"d":"100.000000"},103.981395348837,{"v":19.5,"d":"19.50"},119.481395348837,{"v":95.359801011793,"d":"95.3598010"},99.9418604651163,{"v":0,"d":"0.000000"},{"v":99.9418604651163,"d":"99.941860"},91.0159476681977,{"v":98.1735549691784,"d":"98.173555"},{"$f":"RANK(O28,$O$3:$O$45)","v":1}]
[2019215258,"易天立",86.8275862068966,{"v":0.5,"d":"0.500000"},87.3275862068966,{"v":76.7151090142146,"d":"76.715109"},97.6279069767442,{"v":-1.5,"d":"-1.50"},96.1279069767442,{"v":76.7210497853605,"d":"76.7210498"},97.4069767441861,{"v":0,"d":"0.000000"},{"v":97.4069767441861,"d":"97.406977"},88.7074570816163,{"v":77.915531975184,"d":"77.915532"},{"$f":"RANK(O29,$O$3:$O$45)","v":13}]
[2019215260,"王浩泽",73.1172413793103,null,73.1172413793103,{"v":64.2316750853863,"d":"64.231675"},97.0790697674419,{"v":-42.5,"d":"-42.50"},54.5790697674419,{"v":43.5603318595046,"d":"43.5603319"},97.9186046511628,{"v":0,"d":"0.000000"},{"v":97.9186046511628,"d":"97.918605"},89.1733909614768,{"v":62.591578027819,"d":"62.591578"},{"$f":"RANK(O30,$O$3:$O$45)","v":43}]
[2019215261,"苏倩倩",89.6310344827586,null,89.6310344827586,{"v":78.7386309420131,"d":"78.738631"},101.127906976744,{"v":16.5,"d":"16.50"},117.627906976744,{"v":93.8805055798605,"d":"93.8805056"},99.9186046511628,{"v":0,"d":"0.000000"},{"v":99.9186046511628,"d":"99.918605"},90.9947688554767,{"v":82.9926196609289,"d":"82.992620"},{"$f":"RANK(O31,$O$3:$O$45)","v":3}]
[2019215264,"苏凯宁",81.8620689655172,null,81.8620689655172,{"v":71.9137882723576,"d":"71.913788"},106.86511627907,{"v":11,"d":"11.00"},117.86511627907,{"v":94.0698256978744,"d":"94.0698257"},98.5697674418605,{"v":0,"d":"0.000000"},{"v":98.5697674418605,"d":"98.569767"},89.7663977176628,{"v":78.1302567019915,"d":"78.130257"},{"$f":"RANK(O32,$O$3:$O$45)","v":12}]
[2019215266,"王倩倩",80.448275862069,null,80.448275862069,{"v":70.6718062508046,"d":"70.671806"},104.895348837209,{"v":20.4,"d":"20.40"},125.295348837209,{"v":99.9999999827232,"d":"100.0000000"},100.011627906977,{"v":0,"d":"0.000000"},{"v":100.011627906977,"d":"100.011628"},91.0794841063605,{"v":78.5782127827439,"d":"78.578213"},{"$f":"RANK(O33,$O$3:$O$45)","v":8}]
[2019215267,"李晓龙",81,null,81,{"v":71.1564821616546,"d":"71.156482"},97.0302325581395,{"v":-4,"d":"-4.00"},93.0302325581395,{"v":74.2487517736488,"d":"74.2487518"},97.2093023255814,{"v":0,"d":"0.000000"},{"v":97.2093023255814,"d":"97.209302"},88.5274371734884,{"v":73.5120315852368,"d":"73.512032"},{"$f":"RANK(O34,$O$3:$O$45)","v":33}]
[2019215268,"耿子硕",82.8,{"v":1.875,"d":"1.875000"},84.675,{"v":74.3848781115815,"d":"74.384878"},101.906976744186,{"v":-0.5,"d":"-0.50"},101.406976744186,{"v":80.9343504509651,"d":"80.9343505"},97.6860465116279,{"v":0,"d":"0.000000"},{"v":97.6860465116279,"d":"97.686047"},88.9616028342674,{"v":77.1524450517268,"d":"77.152445"},{"$f":"RANK(O35,$O$3:$O$45)","v":21}]
[2019215269,"孔一丹",86.2,null,86.2,{"v":75.7245526214151,"d":"75.724553"},97.953488372093,{"v":4,"d":"4.00"},101.953488372093,{"v":81.3705291542326,"d":"81.3705292"},99.6162790697674,{"v":0,"d":"0.000000"},{"v":99.6162790697674,"d":"99.616279"},90.7194442901047,{"v":78.3532370948476,"d":"78.353237"},{"$f":"RANK(O36,$O$3:$O$45)","v":10}]
[2019215272,"刘鑫智",75.551724137931,null,75.551724137931,{"v":66.3703075420116,"d":"66.370308"},107.497674418605,{"v":-2,"d":"-2.00"},105.497674418605,{"v":84.1991944469116,"d":"84.1991944"},97.8023255813954,{"v":0,"d":"0.000000"},{"v":97.8023255813954,"d":"97.802326"},89.0674968978721,{"v":72.2058038585776,"d":"72.205804"},{"$f":"RANK(O37,$O$3:$O$45)","v":39}]
[2019215273,"孙宁",79,null,79,{"v":69.3995319848236,"d":"69.399532"},112.611627906977,{"v":-1,"d":"-1.00"},111.611627906977,{"v":89.0788276847419,"d":"89.0788277"},104.678294906977,{"v":0,"d":"0.000000"},{"v":105.678294906977,"d":"105.678295"},96.2400551095901,{"v":76.0194434372839,"d":"76.019443"},{"$f":"RANK(O38,$O$3:$O$45)","v":26}]
[2019215275,"王惠琳",85.44482759,null,85.44482759,{"v":75.0611524717714,"d":"75.061152"},104.802325581395,{"v":16,"d":"16.00"},120.802325581395,{"v":96.4140542179884,"d":"96.4140542"},98.2674418604651,{"v":0,"d":"0.000000"},{"v":98.2674418604651,"d":"98.267442"},89.4910731522907,{"v":80.7747248890667,"d":"80.774725"},{"$f":"RANK(O39,$O$3:$O$45)","v":5}]
[2019215276,"张福灿",75.1692307692308,{"v":8,"d":"8.000000"},83.95,{"v":73.7479836724803,"d":"73.747984"},102.06511627907,{"v":0,"d":"0.00"},102.06511627907,{"v":81.4596209744744,"d":"81.4596210"},104.771318162791,{"v":0,"d":"0.000000"},{"v":104.771318162791,"d":"104.771318"},95.4140814134739,{"v":77.4569209069785,"d":"77.456921"},{"$f":"RANK(O40,$O$3:$O$45)","v":17}]
[2019215277,"郭侃",84.2172413793103,null,84.2172413793103,{"v":73.9827485667982,"d":"73.982749"},102.904651162791,{"v":1.5,"d":"1.50"},104.404651162791,{"v":83.3268370403767,"d":"83.3268370"},98.1511627906977,{"v":0,"d":"0.000000"},{"v":98.1511627906977,"d":"98.151163"},89.385179088686,{"v":77.3918093137027,"d":"77.391809"},{"$f":"RANK(O41,$O$3:$O$45)","v":19}]
[2019215278,"黄琛",78.1862068965517,null,78.1862068965517,{"v":68.6846350163199,"d":"68.684635"},106.660465116279,{"v":-6.5,"d":"-6.50"},100.160465116279,{"v":79.9394917915977,"d":"79.9394918"},97.8255813953488,{"v":0,"d":"0.000000"},{"v":98.8255813953488,"d":"98.825581"},89.999364657593,{"v":73.0670793355028,"d":"73.067079"},{"$f":"RANK(O42,$O$3:$O$45)","v":35}]
[2019215279,"代校军",78.72413793,{"v":1.5,"d":"1.500000"},80.22413793,{"v":70.4749066611131,"d":"70.474907"},100.802325581395,{"v":3,"d":"3.00"},103.802325581395,{"v":82.8461124269884,"d":"82.8461124"},97.6162790697674,{"v":0,"d":"0.000000"},{"v":97.6162790697674,"d":"97.616279"},88.8980663961047,{"v":74.7914637877873,"d":"74.791464"},{"$f":"RANK(O43,$O$3:$O$45)","v":30}]
[2019215280,"姚颖",75.7931034482759,null,75.7931034482759,{"v":66.5823532530084,"d":"66.582353"},102.195348837209,{"v":-17,"d":"-17.00"},85.1953488372093,{"v":67.9956196404232,"d":"67.9956196"},99.546511627907,{"v":0,"d":"0.000000"},{"v":99.546511627907,"d":"99.546512"},90.6559078519419,{"v":69.2723619903847,"d":"69.272362"},{"$f":"RANK(O44,$O$3:$O$45)","v":42}]
["2018213519","郝亮",{"v":73.225,"d":"73.23"},null,73.225,{"v":64.3263383492241,"d":"64.326338"},97.490625,{"v":0,"d":"0.00"},97.490625,{"v":77.8086544216594,"d":"77.8086544"},98.25,{"v":0,"d":"0.000000"},{"v":98.25,"d":"98.250000"},89.47518904275,{"v":69.5376866330638,"d":"69.537687"},{"$f":"RANK(O45,$O$3:$O$45)","v":41}]

{"sheet":"化学工程（专硕）","index":6,"n_rows":26,"n_cols":16,"rows_kept":26,"merged":[[0,0,1,0],[0,1,1,1],[0,2,0,5],[0,6,0,9],[0,10,0,13],[0,14,1,14],[0,15,1,15]]}
["学号","姓名","智育",{"$nulls":3},"德育",{"$nulls":3},"体育",{"$nulls":3},"综合测评总分","排名"]
[null,null,"基本分","奖惩分","总分","最终成绩","基本分","奖惩分","总分","最终成绩","基本分","奖惩分","总分","最终成绩"]
["2019215201","王舍川",{"v":83.5172413793103,"d":"83.5172"},null,{"$f":"C3+D3","v":{"v":83.5172413793103,"d":"83.5172"}},{"v":92.6939415974587,"d":"92.6939"},{"v":97.9389565217391,"d":"97.9390"},null,{"v":97.9389565217391,"d":"97.9390"},{"v":83.8417250329704,"d":"83.8417"},{"v":100.5,"d":"100.5000"},{"v":0,"d":"0.0000"},{"v":100.5,"d":"100.5000"},{"v":93.7792185251748,"d":"93.7792"},{"$f":"F3*0.7+J3*0.2+N3*0.1","v":{"v":91.0320259773327,"d":"91.0320"}},{"$f":"RANK(O3,O$3:O$26)","v":14}]
["2019215202","徐宇翔",{"v":84.2068965517241,"d":"84.2069"},null,{"v":84.2068965517241,"d":"84.2069"},{"v":93.4593746412032,"d":"93.4594"},{"v":98.2624347826087,"d":"98.2624"},{"v":0.5,"d":"0.5000"},{"v":98.7624347826087,"d":"98.7624"},{"v":84.5466726898625,"d":"84.5467"},{"v":100.5,"d":"100.5000"},{"v":0,"d":"0.0000"},{"v":100.5,"d":"100.5000"},{"v":93.7792185251748,"d":"93.7792"},{"v":91.7088186393322,"d":"91.7088"},{"$f":"RANK(O4,O$3:O$26)","v":11}]
["2019215210","李玥",{"v":84.1333333333333,"d":"84.1333"},null,{"v":84.1333333333333,"d":"84.1333"},{"v":93.3777284498705,"d":"93.3777"},{"v":98.2438695652174,"d":"98.2439"},{"v":-4,"d":"-4.0000"},{"v":94.2438695652174,"d":"94.2439"},{"v":80.67850504795,"d":"80.6785"},{"v":100.5,"d":"100.5000"},{"v":0,"d":"0.0000"},{"v":100.5,"d":"100.5000"},{"v":93.7792185251748,"d":"93.7792"},{"v":90.8780327770168,"d":"90.8780"},{"$f":"RANK(O5,O$3:O$26)","v":15}]
["2019215211","张雷浩",{"v":82.1379310344828,"d":"82.1379"},null,{"v":82.1379310344828,"d":"82.1379"},{"v":91.1630755099698,"d":"91.1631"},{"v":97.5908260869565,"d":"97.5908"},{"v":-2.5,"d":"-2.5000"},{"v":95.0908260869565,"d":"95.0908"},{"v":81.403551529273,"d":"81.4036"},{"v":100.5,"d":"100.5000"},{"v":0,"d":"0.0000"},{"v":100.5,"d":"100.5000"},{"v":93.7792185251748,"d":"93.7792"},{"v":89.472785015351,"d":"89.4728"},{"$f":"RANK(O6,O$3:O$26)","v":20}]
["2019215212","刘燕",{"v":85.3034482758621,"d":"85.3034"},null,{"v":85.3034482758621,"d":"85.3034"},{"v":94.6764131807571,"d":"94.6764"},{"v":98.5064782608695,"d":"98.5065"},null,{"v":98.5064782608695,"d":"98.5065"},{"v":84.3275582835202,"d":"84.3276"},{"v":100.5,"d":"100.5000"},{"v":0,"d":"0.0000"},{"v":100.5,"d":"100.5000"},{"v":93.7792185251748,"d":"93.7792"},{"v":92.5169227357514,"d":"92.5169"},{"$f":"RANK(O7,O$3:O$26)","v":10}]
["2019215215","唐宇",{"v":86.7333333333333,"d":"86.7333"},null,{"v":86.7333333333333,"d":"86.7333"},{"v":96.2634110247872,"d":"96.2634"},{"v":102.914065217391,"d":"102.9141"},{"v":13.9,"d":"13.9000"},{"v":116.814065217391,"d":"116.8141"},{"v":99.9999702239638,"d":"100.0000"},107.1666,{"v":0,"d":"0.0000"},107.1666,{"v":100,"d":"100.0000"},{"v":97.3843817621438,"d":"97.3844"},{"$f":"RANK(O8,O$3:O$26)","v":3}]
["2019215216","窦鑫桐",{"v":86.5333333333333,"d":"86.5333"},{"v":1.04,"d":"1.0400"},{"v":87.5733333333333,"d":"87.5733"},{"v":97.195708472068,"d":"97.1957"},{"v":97.2134347826087,"d":"97.2134"},{"v":4.5,"d":"4.5000"},{"v":101.713434782609,"d":"101.7134"},{"v":87.0729088206036,"d":"87.0729"},107.1666,{"v":0,"d":"0.0000"},107.1666,{"v":100,"d":"100.0000"},{"v":95.4515776945684,"d":"95.4516"},{"$f":"RANK(O9,O$3:O$26)","v":5}]
["2019215217","罗景泉",{"v":84.7666666666667,"d":"84.7667"},null,{"v":84.7666666666667,"d":"84.7667"},{"v":94.0806511283759,"d":"94.0807"},{"v":104.397147826087,"d":"104.3971"},{"v":4.5,"d":"4.5000"},{"v":108.897147826087,"d":"108.8971"},{"v":93.2226056838061,"d":"93.2226"},107.1666,{"v":0,"d":"0.0000"},107.1666,{"v":100,"d":"100.0000"},{"v":94.5009769266243,"d":"94.5010"},{"$f":"RANK(O10,O$3:O$26)","v":6}]
["2019215220","蒋志强",{"v":90.1,"d":"90.1000"},null,{"v":90.1,"d":"90.1000"},{"v":100,"d":"100.0000"},{"v":100.638869565217,"d":"100.6389"},{"v":6,"d":"6.0000"},{"v":106.638869565217,"d":"106.6389"},{"v":91.2893816458949,"d":"91.2894"},{"v":100.5,"d":"100.5000"},{"v":0,"d":"0.0000"},{"v":100.5,"d":"100.5000"},{"v":93.7792185251748,"d":"93.7792"},{"v":97.6357981816965,"d":"97.6358"},{"$f":"RANK(O11,O$3:O$26)","v":2}]
["2019215221","郭梦全",{"v":86.3,"d":"86.3000"},null,{"v":86.3,"d":"86.3000"},{"v":95.7824639289678,"d":"95.7825"},{"v":100.620608695652,"d":"100.6206"},{"v":-4,"d":"-4.0000"},{"v":96.6206086956522,"d":"96.6206"},{"v":82.7131388211288,"d":"82.7131"},{"v":100.5,"d":"100.5000"},{"v":0,"d":"0.0000"},{"v":100.5,"d":"100.5000"},{"v":93.7792185251748,"d":"93.7792"},{"v":92.9682743670207,"d":"92.9683"},{"$f":"RANK(O12,O$3:O$26)","v":7}]
["2019215222","李正凯",{"v":84.4333333333333,"d":"84.4333"},null,{"v":84.4333333333333,"d":"84.4333"},{"v":93.7106918238993,"d":"93.7107"},{"v":96.9569130434783,"d":"96.9569"},{"v":-1,"d":"-1.0000"},{"v":95.9569130434783,"d":"95.9569"},{"v":82.1449748305027,"d":"82.1450"},{"v":100.5,"d":"100.5000"},{"v":0,"d":"0.0000"},{"v":100.5,"d":"100.5000"},{"v":93.7792185251748,"d":"93.7792"},{"v":91.4044010953476,"d":"91.4044"},{"$f":"RANK(O13,O$3:O$26)","v":13}]
["2019215231","王梦钶",{"v":85.6413793103448,"d":"85.6414"},null,{"v":85.6413793103448,"d":"85.6414"},{"v":95.0514753721918,"d":"95.0515"},{"v":97.4197391304348,"d":"97.4197"},null,{"v":97.4197391304348,"d":"97.4197"},{"v":83.3972432526851,"d":"83.3972"},{"v":100.5,"d":"100.5000"},{"v":0,"d":"0.0000"},{"v":100.5,"d":"100.5000"},{"v":93.7792185251748,"d":"93.7792"},{"v":92.5934032635887,"d":"92.5934"},{"$f":"RANK(O14,O$3:O$26)","v":9}]
["2019215232","付钰",{"v":80.7827586206896,"d":"80.7828"},{"v":0.5,"d":"0.5000"},{"v":81.2827586206896,"d":"81.2828"},{"v":90.2139385357265,"d":"90.2139"},{"v":96.938652173913,"d":"96.9387"},{"v":-5,"d":"-5.0000"},{"v":91.938652173913,"d":"91.9387"},{"v":78.7050982491951,"d":"78.7051"},{"v":100.5,"d":"100.5000"},{"v":0,"d":"0.0000"},{"v":100.5,"d":"100.5000"},{"v":93.7792185251748,"d":"93.7792"},{"v":88.2686984773651,"d":"88.2687"},{"$f":"RANK(O15,O$3:O$26)","v":23}]
["2019215233","姜信舟",{"v":89.2758620689655,"d":"89.2759"},null,{"v":89.2758620689655,"d":"89.2759"},{"v":99.0853075127253,"d":"99.0853"},{"v":103.004391304348,"d":"103.0044"},{"v":5,"d":"5.0000"},{"v":108.004391304348,"d":"108.0044"},{"v":92.4583516068247,"d":"92.4584"},107.1666,{"v":0,"d":"0.0000"},107.1666,{"v":100,"d":"100.0000"},{"v":97.8513855802726,"d":"97.8514"},{"$f":"RANK(O16,O$3:O$26)","v":1}]
["2019215234","陈广怀",{"v":86.551724137931,"d":"86.5517"},null,{"v":86.551724137931,"d":"86.5517"},{"v":96.0618469899345,"d":"96.0618"},{"v":97.8716956521739,"d":"97.8717"},{"v":-2.5,"d":"-2.5000"},{"v":95.3716956521739,"d":"95.3717"},{"v":81.6439930215393,"d":"81.6440"},{"v":100.5,"d":"100.5000"},{"v":0,"d":"0.0000"},{"v":100.5,"d":"100.5000"},{"v":93.7792185251748,"d":"93.7792"},{"v":92.9500133497795,"d":"92.9500"},{"$f":"RANK(O17,O$3:O$26)","v":8}]
["2019215235","王思斯",{"v":83.0344827586207,"d":"83.0345"},null,{"v":83.0344827586207,"d":"83.0345"},{"v":92.1581384668376,"d":"92.1581"},{"v":95.9608260869565,"d":"95.9608"},null,{"v":95.9608260869565,"d":"95.9608"},{"v":82.1483246345745,"d":"82.1483"},{"v":100.5,"d":"100.5000"},{"v":0,"d":"0.0000"},{"v":100.5,"d":"100.5000"},{"v":93.7792185251748,"d":"93.7792"},{"v":90.3182837062187,"d":"90.3183"},{"$f":"RANK(O18,O$3:O$26)","v":17}]
["2019215237","张启涵",{"v":78.4862068965517,"d":"78.4862"},null,{"v":78.4862068965517,"d":"78.4862"},{"v":87.1101075433426,"d":"87.1101"},{"v":101.712820289855,"d":"101.7128"},{"v":1.4,"d":"1.4000"},{"v":103.112820289855,"d":"103.1128"},{"v":88.2708682341045,"d":"88.2709"},{"v":100.5,"d":"100.5000"},{"v":0,"d":"0.0000"},{"v":100.5,"d":"100.5000"},{"v":93.7792185251748,"d":"93.7792"},{"v":88.0091707796782,"d":"88.0092"},{"$f":"RANK(O19,O$3:O$26)","v":24}]
["2019215250","王昊宇",{"v":82.3,"d":"82.3000"},null,{"v":82.3,"d":"82.3000"},{"v":91.3429522752497,"d":"91.3430"},{"v":97.5052608695652,"d":"97.5053"},{"v":-1.5,"d":"-1.5000"},{"v":96.0052608695652,"d":"96.0053"},{"v":82.1863635208123,"d":"82.1864"},{"v":100.5,"d":"100.5000"},{"v":0,"d":"0.0000"},{"v":100.5,"d":"100.5000"},{"v":93.7792185251748,"d":"93.7792"},{"v":89.7552611493547,"d":"89.7553"},{"$f":"RANK(O20,O$3:O$26)","v":18}]
["2019215252","白金虎",{"v":82.4,"d":"82.4000"},null,{"v":82.4,"d":"82.4000"},{"v":91.4539400665927,"d":"91.4539"},{"v":97.6175652173913,"d":"97.6176"},{"v":-2.5,"d":"-2.5000"},{"v":95.1175652173913,"d":"95.1176"},{"v":81.4264418570971,"d":"81.4264"},{"v":100.5,"d":"100.5000"},{"v":0,"d":"0.0000"},{"v":100.5,"d":"100.5000"},{"v":93.7792185251748,"d":"93.7792"},{"v":89.6809682705518,"d":"89.6810"},{"$f":"RANK(O21,O$3:O$26)","v":19}]
["2019215253","蒋志成",{"v":83.8,"d":"83.8000"},null,{"v":83.8,"d":"83.8000"},{"v":93.007769145394,"d":"93.0078"},{"v":98.0749565217391,"d":"98.0750"},{"v":-1.4,"d":"-1.4000"},{"v":96.6749565217391,"d":"96.6750"},{"v":82.7596638776818,"d":"82.7597"},107.1666,{"v":0,"d":"0.0000"},107.1666,{"v":100,"d":"100.0000"},{"v":91.6573711773122,"d":"91.6574"},{"$f":"RANK(O22,O$3:O$26)","v":12}]
["2019215259","秦洪岭",{"v":81.6896551724138,"d":"81.6897"},null,{"v":81.6896551724138,"d":"81.6897"},{"v":90.6655440315358,"d":"90.6655"},{"v":96.6769130434783,"d":"96.6769"},{"v":-3.5,"d":"-3.5000"},{"v":93.1769130434783,"d":"93.1769"},{"v":79.7651251377002,"d":"79.7651"},{"v":100.5,"d":"100.5000"},{"v":0,"d":"0.0000"},{"v":100.5,"d":"100.5000"},{"v":93.7792185251748,"d":"93.7792"},{"v":88.7968277021326,"d":"88.7968"},{"$f":"RANK(O23,O$3:O$26)","v":21}]
["2019215263","吴江",{"v":82.4448275862069,"d":"82.4448"},{"v":0.04,"d":"0.0400"},{"v":82.4848275862069,"d":"82.4848"},{"v":91.5480883309733,"d":"91.5481"},{"v":97.1193913043478,"d":"97.1194"},{"v":-1.5,"d":"-1.5000"},{"v":95.6193913043478,"d":"95.6194"},{"v":81.8560356192855,"d":"81.8560"},107.1666,{"v":0,"d":"0.0000"},107.1666,{"v":100,"d":"100.0000"},{"v":90.4548689555384,"d":"90.4549"},{"$f":"RANK(O24,O$3:O$26)","v":16}]
["2019215271","王青",{"v":87.1,"d":"87.1000"},null,{"v":87.1,"d":"87.1000"},{"v":96.6703662597114,"d":"96.6704"},{"v":103.025699130435,"d":"103.0257"},{"v":2,"d":"2.0000"},{"v":105.025699130435,"d":"105.0257"},{"v":89.9084092848678,"d":"89.9084"},107.1666,{"v":0,"d":"0.0000"},107.1666,{"v":100,"d":"100.0000"},{"v":95.6509382387716,"d":"95.6509"},{"$f":"RANK(O25,O$3:O$26)","v":4}]
["2019215281","杨松",{"v":80.3120689655172,"d":"80.3121"},null,{"v":80.3120689655172,"d":"80.3121"},{"v":89.1365915266562,"d":"89.1366"},{"v":96.8719565217391,"d":"96.8720"},{"v":-0.5,"d":"-0.5000"},{"v":96.3719565217391,"d":"96.3720"},{"v":82.5002773823871,"d":"82.5003"},{"v":100.5,"d":"100.5000"},{"v":0,"d":"0.0000"},{"v":100.5,"d":"100.5000"},{"v":93.7792185251748,"d":"93.7792"},{"v":88.2735913976542,"d":"88.2736"},{"$f":"RANK(O26,O$3:O$26)","v":22}]

{"sheet":"能源催化（专硕）","index":7,"n_rows":15,"n_cols":16,"rows_kept":15,"merged":[[0,0,1,0],[0,1,1,1],[0,2,0,5],[0,6,0,9],[0,10,0,13],[0,14,1,14],[0,15,1,15]]}
["学号","姓名","智育",{"$nulls":3},"德育",{"$nulls":3},"体育",{"$nulls":3},"综合测评总分","排名"]
[null,null,"基本分","奖惩分","总分","最终成绩","基本分","奖惩分","总分","最终成绩","基本分","奖惩分","总分","最终成绩"]
["2019215209","田园",81.72413793,{"v":0,"d":"0.000000"},81.72413793,{"$f":"E3/85.51034483*100","v":95.5722235625091},{"v":96.4583333333333,"d":"96.4583"},{"v":3,"d":"3.0000"},{"v":99.4583333333333,"d":"99.4583"},{"v":83.7412459585264,"d":"83.741246"},{"v":100.5,"d":"100.5000"},{"v":0,"d":"0.0000"},{"v":100.5,"d":"100.500000"},{"v":92.6267281105991,"d":"92.626728"},{"$f":"F3*0.7+J3*0.2+N3*0.1","v":{"v":92.9114784965215,"d":"92.911478"}},6]
["2019215213","张旖旎",83.76666667,{"v":0,"d":"0.000000"},83.76666667,97.9608570594979,{"v":103.1,"d":"103.1000"},{"v":-1.5,"d":"-1.5000"},{"v":101.6,"d":"101.6000"},{"v":85.5444717826857,"d":"85.544472"},{"v":100.5,"d":"100.5000"},{"v":0,"d":"0.0000"},{"v":100.5,"d":"100.500000"},{"v":92.6267281105991,"d":"93"},{"v":94.9441671092455,"d":"94.944167"},3]
["2019215223","鹿瑾",80.05862069,{"v":0,"d":"0.000000"},80.05862069,93.6244858433931,{"v":95.6416666666667,"d":"95.6417"},{"v":-1.5,"d":"-1.5000"},{"v":94.1416666666667,"d":"94.1417"},{"v":79.2647553911582,"d":"79.264755"},{"v":100,"d":"100.0000"},{"v":0,"d":"0.0000"},{"v":100,"d":"100.000000"},{"v":92.1658986175115,"d":"92.165899"},{"v":90.606681030358,"d":"90.606681"},10]
["2019215224","张淑莹",81.62758621,{"v":0.38,"d":"0.380000"},82.00758621,95.9037019123666,{"v":98.9,"d":"98.9000"},{"v":1,"d":"1.0000"},{"v":99.9,"d":"99.9000"},{"v":84.1131174319912,"d":"84.113117"},{"v":100.5,"d":"100.5000"},{"v":0,"d":"0.0000"},{"v":100.5,"d":"100.500000"},{"v":92.6267281105991,"d":"92.626728"},{"v":93.2178876361148,"d":"93.217888"},5]
["2019215227","李佳晴",85.51034483,{"v":0,"d":"0.000000"},85.51034483,100,{"v":102.116633333333,"d":"102.1166"},{"v":2.5,"d":"2.5000"},{"v":104.616633333333,"d":"104.6166"},{"v":88.0843960451074,"d":"88.084396"},{"v":100.5,"d":"100.5000"},{"v":0,"d":"0.0000"},{"v":100.5,"d":"100.500000"},{"v":92.6267281105991,"d":"92.626728"},{"v":96.8795520200814,"d":"96.879552"},2]
["2019215228","李心童",75.351724137931,{"v":0,"d":"0.000000"},75.351724137931,88.1200096757124,{"v":97.2833333333333,"d":"97.2833"},{"v":1.5,"d":"1.5000"},{"v":98.7833333333333,"d":"98.7833"},{"v":83.1729140839859,"d":"83.172914"},{"v":108.5,"d":"108.5000"},{"v":0,"d":"0.0000"},{"v":108.5,"d":"108.500000"},{"v":100,"d":"100.000000"},{"v":88.3185895897958,"d":"88.318590"},13]
["2019215229","张小亮",80.548275862069,{"v":0,"d":"0.000000"},80.548275862069,94.1971126677177,{"v":97.3416666666667,"d":"97.3417"},{"v":4.5,"d":"4.5000"},{"v":101.841666666667,"d":"101.8417"},{"v":85.747948626657,"d":"85.747949"},{"v":100.5,"d":"100.5000"},{"v":0,"d":"0.0000"},{"v":100.5,"d":"100.500000"},{"v":92.6267281105991,"d":"92.626728"},{"v":92.3502414037937,"d":"92.350241"},7]
["2019215230","马宇航",79.6333333333333,{"v":0,"d":"0.000000"},79.6333333333333,93.1271339060197,{"v":98.2,"d":"98.2000"},{"v":1,"d":"1.0000"},{"v":99.2,"d":"99.2000"},{"v":83.523736228764,"d":"83.523736"},{"v":100.5,"d":"100.5000"},{"v":0,"d":"0.0000"},{"v":100.5,"d":"100.500000"},{"v":92.6267281105991,"d":"92.626728"},{"v":91.1564137910265,"d":"91.156414"},8]
["2019215246","周传行",77.87931034,{"v":0,"d":"0.000000"},77.87931034,91.0758932089784,{"v":97.05,"d":"97.0500"},{"v":-5,"d":"-5.0000"},{"v":92.05,"d":"92.0500"},{"v":77.5036282243723,"d":"77.503628"},{"v":100.5,"d":"100.5000"},{"v":0,"d":"0.0000"},{"v":100.5,"d":"100.500000"},{"v":92.6267281105991,"d":"92.626728"},{"v":88.5165237022192,"d":"88.516524"},12]
["2019215262","张浩",80.624137932,{"v":0,"d":"0.000000"},80.624137932,94.2858295008468,{"v":103.283366666667,"d":"103.2834"},{"v":13.5,"d":"13.5000"},{"v":116.783366666667,"d":"116.7834"},{"v":98.3284588041704,"d":"98.328459"},{"v":100.5,"d":"100.5000"},{"v":0,"d":"0.0000"},{"v":100.5,"d":"100.500000"},{"v":92.6267281105991,"d":"92.626728"},{"v":94.9284452224868,"d":"94.928445"},4]
["2019215265","高宁晗",84.1724137931034,{"v":0,"d":"0.000000"},84.1724137931034,98.4353576873576,{"v":105.268633333333,"d":"105.2686"},{"v":13.5,"d":"13.5000"},{"v":118.768633333333,"d":"118.7686"},{"v":100.000000028066,"d":"100.000000"},107.1667,{"v":0,"d":"0.0000"},{"v":107.1667,"d":"107.166700"},{"v":98.7711520737327,"d":"98.771152"},{"v":98.7818655941368,"d":"98.781866"},1]
["2019215270","鲁阳",77.7241379310345,{"v":0,"d":"0.000000"},77.7241379310345,90.8944269673512,102.7583,{"v":1.5,"d":"1.5000"},104.2583,{"v":87.7826890005983,"d":"87.782689"},{"v":100.5,"d":"100.5000"},{"v":0,"d":"0.0000"},{"v":100.5,"d":"100.500000"},{"v":92.6267281105991,"d":"92.626728"},{"v":90.4453094883254,"d":"90.445309"},11]
["2019215274","王艳平",78.7,{"v":0,"d":"0.000000"},78.7,92.035648033534,{"v":101.908333333333,"d":"101.9083"},{"v":-2,"d":"-2.0000"},{"v":99.9083333333333,"d":"99.9083"},{"v":84.1201338748867,"d":"84.120134"},107.1667,{"v":0,"d":"0.0000"},{"v":107.1667,"d":"107.166700"},{"v":98.7711520737327,"d":"98.771152"},{"v":91.1260956058244,"d":"91.126096"},9]

{"sheet":"环境工程（专硕）","index":8,"n_rows":16,"n_cols":16,"rows_kept":16,"merged":[[0,0,1,0],[0,1,1,1],[0,2,0,5],[0,6,0,9],[0,10,0,13],[0,14,1,14],[0,15,1,15]]}
["学号","姓名","智育",{"$nulls":3},"德育",{"$nulls":3},"体育",{"$nulls":3},"综合测评总分","排名"]
[null,null,"基本分","奖惩分","总分","最终成绩","基本分","奖惩分","总分","最终成绩","基本分","奖惩分","总分","最终成绩"]
["2019215284","王冀星",83.7719298245614,null,83.7719298245614,83.2768949490311,97.985,9,106.985,87.2207728680907,100.025,null,100.025,97.6727472284961,85.5052557607895,9]
["2019215285","王小鹏",84.9666666666667,null,84.9666666666667,84.4645717125973,98.38,10.5,110.38,89.9885863362139,102.0083,null,102.0083,99.6094066594212,87.083858132003,6]
["2019215286","纪奕辉",78.4833333333333,null,78.4833333333333,78.0195504501022,97.4325,5,99.9325,81.4711397358552,99.45,null,99.45,97.1112693014141,80.619040192384,12]
["2019215287","王育堃",100.594444444444,null,100.594444444444,100,103.88,6,113.38,92.4343714332301,98.95,null,98.95,96.6230276256905,98.1491770492151,1]
["2019215288","张雯滔",85.1142857142857,null,85.1142857142857,84.6113184324926,100.4675,5,101.9675,83.1301972933312,99.325,null,99.325,96.9892088824832,85.5528832496593,8]
["2019215289","刘彦博",84.6333333333333,{"$f":"10*1/10*1/8","v":0.125},84.7583333333333,84.2574694869387,95.985,13,108.985,88.8512962661014,102.4083,null,102.4083,100,86.7504878940774,7]
["2019215290","王珏",86.6809523809524,null,86.6809523809524,86.1687271694451,102.645,16.5,121.145,98.7648785260069,99.225,null,99.225,96.8915605473384,89.7602407785468,3]
["2019215291","池皓",82.4333333333333,{"v":0.4,"d":"0.4000"},82.8333333333333,82.3438449218534,97.1075,9.5,105.6075,86.0977498777107,100.25,null,100.25,97.8924559825717,84.6494870190967,10]
["2019215292","刘莎莎",90.1666666666667,null,90.1666666666667,89.6338432650356,104.1425,11,118.1425,96.3170552747432,99.875,null,99.875,97.5262747257791,91.7597288130515,2]
["2019215293","刘冠男",74.8833333333333,null,74.8833333333333,74.4408239907218,97.5375,3.5,98.5375,80.3338496657427,98.85,null,98.85,96.5253792905458,77.8278846557084,14]
["2019215294","赵东松",76.6666666666667,null,76.6666666666667,76.2136190423593,98.95,5,102.45,83.5235610631013,98.9,null,98.9,96.5742034581181,79.7116658880836,13]
["2019215295","南少帅",85.9428904761905,null,85.9428904761905,85.4350267063251,102.1565,10,115.1565,93.8826838415131,99.8,null,99.8,97.4530384744205,88.3263593101723,5]
["2019215296","何旭",82.7511278195489,null,82.7511278195489,82.2621251864958,97.985,5.5,100.485,81.9215718245557,98.75,null,98.75,96.4277309554011,83.6105750909983,11]
["2019215298","王雨竹",84.3888888888889,null,84.3888888888889,83.8902082067709,106.16,16.5,122.66,100,98.8,null,98.8,96.4765551229734,88.370801257037,4]

{"sheet":"国际班","index":9,"n_rows":15,"n_cols":16,"rows_kept":15,"merged":[[0,0,1,0],[0,1,1,1],[0,2,0,5],[0,6,0,9],[0,10,0,13],[0,14,1,14],[0,15,1,15]]}
["学号","姓名","智育",{"$nulls":3},"德育",{"$nulls":3},"体育",{"$nulls":3},"综合测评总分","排名"]
[null,null,"基本分","奖惩分","总分","最终成绩","基本分","奖惩分","总分","最终成绩","基本分","奖惩分","总分","最终成绩"]
[2019210509,"郭靖涵",92.3090909090909,14.0213744588745,106.330465367965,100,95.2333333333333,5,100.233333333333,78.7378894998691,100,null,100,89.7397547381812,94.7215533737919,2]
[2019210521,"刘雅欣",88.4027272727273,null,88.4027272727273,83.1396034681146,105.133333333333,-3,102.133333333333,80.2304268133019,100.5,1,101.5,91.0858510592539,83.352392896266,8]
[2019210535,"魏斌",89.2290909090909,null,89.2290909090909,83.9167689150106,98.4,-1.5,96.9,76.1194029850746,100,null,100,89.7397547381812,82.9395943113405,9]
[2019210546,"陈延达",89.71,null,89.71,84.3690467163396,98.7666666666667,-1,97.7666666666667,76.8002094789212,100,null,100,89.7397547381812,83.3923500710401,7]
[2019210595,"李硕凡",88.2396103896104,0.75,88.9896103896104,83.6915460509408,99.2,-2.5,96.7,75.962293794187,100,null,100,89.7397547381812,82.7505164683141,11]
[2019210604,"孔涛",91.2354285714286,0.5,91.7354285714286,86.2738898527064,94.8666666666667,2.5,97.3666666666667,76.4859910971459,106.6666667,null,106.6666667,95.7224050839732,85.261161624721,5]
[2019210626,"王震",90.3318181818182,2.869,93.2008181818182,87.6520363747954,99.8,-2.5,97.3,76.43362136685,100,null,100,89.7397547381812,85.6171252095449,4]
[2019210627,"高煜峰",84.4354545454545,0.7675,85.2029545454545,80.1303316510491,102.2,7.8,110,86.4100549882168,100.5,null,100.5,90.1884535118721,82.3920885045649,12]
[2019210642,"陈霖",90.1318181818182,9.017,99.1488181818182,93.2459176574705,102.4,24.9,127.3,100,104.4333333,7,111.4333333,100,95.2721423602294,1]
[2019210645,"王华君",85.0045454545455,3.1667,88.1712454545455,82.92190309656,95.0666666666667,12.5,107.566666666667,84.4985598324169,101,5,106,95.1241400224721,84.4574581363226,6]
[2019215282,"潘星成",85.4827586206897,null,85.4827586206897,80.3934773772216,101.7,0,101.7,79.8900235663786,100,null,100,89.7397547381812,81.227414351149,13]
[2019215283,"曹越",86.8074074074074,null,86.8074074074074,81.6392621879376,97.2666666666667,7,104.266666666667,81.9062581827704,104.4333333,null,104.4333333,93.7182171683273,82.9005568849431,10]
[2019215297,"赵景宜",82.9125,11.0880952380952,94.0005952380952,88.4041980939314,94.2333333333333,5,99.2333333333333,77.9523435454307,100,null,100,89.7397547381812,86.4473828486562,3]