{"text_format":"3","workbook":"xls","n_sheets":9,"sheets":["工艺学硕","工艺专硕","工程学硕","催化专硕","工程专硕","催化学硕","环境学硕","环境专硕","国际班"],"not_rendered":{"external_links":1,"defined_names":9},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"工艺学硕","index":0,"n_rows":38,"n_cols":20,"rows_kept":38,"merged":[[0,0,0,19],[1,0,2,0],[1,1,2,1],[1,2,1,6],[1,7,1,11],[1,12,1,16],[1,17,2,17],[1,18,2,18],[1,19,2,19]],"flags":["formulas_cached_only"]}
["中国石油大学（北京）化学工程与环境学院23级化学工程与技术专业研究生综合测评汇总表"]
["学号","姓名","德育成绩",{"$nulls":4},"智育成绩",{"$nulls":4},"文体成绩",{"$nulls":4},"总分","排名","英语六级成绩"]
[null,null,"基础分","奖励分","惩罚分","总 分","加权分","学习成绩分","奖励分","惩罚分","总 分","加权分","基本分","奖励分","惩罚分","总 分","加权分"]
[2023210553,"李宇龙",97.065,23.1,0,120.165,17.796949052132703,79.96470579999999,53.76428571428571,0,133.7289915142857,70,100,0,0,100,8.542141230068337,96.33909028220104,1,436]
[2023210554,"张琛",97.03,5.5,0,102.53,15.185130331753555,77.1647058,37.85595238095238,0,115.02065818095238,60.20718455658558,100,0,0,100,8.542141230068337,83.93445611840748,2,436]
[2023210600,"孔令雨",97.1525,32.1,0,129.2525,19.142846563981045,81.56705869999999,15.703701298701297,0,97.2707599987013,50.91605883516828,100,9.266666666666666,0,109.26666666666667,9.333712984054669,79.392618383204,3,429]
[2023210609,"张妍",96.99499999999999,16.5,0,113.49499999999999,16.809093601895736,85.02,16.25,0,101.27,53.00944783721579,100,0,0,100,8.542141230068337,78.36068266917987,4,503]
[2023210599,"曹梓阳",97.27499999999999,24.3,0,121.57499999999999,18.00577606635071,78.8823529,16.703701298701297,0,95.5860541987013,50.03420513490015,100,17.066666666666666,0,117.06666666666666,10,78.03998120125085,5,530]
[2023210612,"佟彤",97.30999999999999,9.5,0,106.80999999999999,15.819016587677723,81.7333331,12.5,0,94.2333331,49.32612773270889,100,0,0,100,8.542141230068337,73.68728555045494,6,436]
[2023210564,"邵冰雪",97.24,37.8,0,135.04,20,85.0088232,0,0,85.0088232,44.497588418322295,100,0,0,100,8.542141230068337,73.03972964839063,7,440]
[2023210532,"刘新悦",97.1,7,0,104.1,15.417654028436019,88.466667,4.5,0,92.966667,48.663095536055195,100,0,0,100,8.542141230068337,72.62289079455955,8,455]
[2023210577,"唐阔",97.0475,1,0,98.0475,14.521252962085308,84.925,8,0,92.925,48.641285082188965,100,0,0,100,8.542141230068337,71.70467927434261,9,476]
[2023210598,"钟浩佳",97.11749999999999,11.75,0,108.8675,16.123741113744078,83.07882319999999,6.25,0,89.32882319999999,46.75887818485504,100,0,0,100,8.542141230068337,71.42476052866746,10,459]
[2023210578,"张晓军",97.0475,10,0,107.0475,15.8541913507109,88.20352969999999,0.25,0,88.45352969999999,46.30070868618315,100,0,0,100,8.542141230068337,70.69704126696239,11,324]
[2023210533,"岳子芊",96.97749999999999,9,0,105.9775,15.69571978672986,87.20000019999999,1,0,88.20000019999999,46.1679995047331,100,0,0,100,8.542141230068337,70.4058605215313,12,601]
[2023210618,"康鑫胜",97.13499999999999,7,0,104.135,15.42283767772512,86.36111079999999,1.5,0,87.86111079999999,45.990608964870496,100,0,0,100,8.542141230068337,69.95558787266395,13,454]
[2023210617,"曹珊",97.1875,5.25,0,102.4375,15.171430687203793,86.76666689999999,0,0,86.76666689999999,45.41772591137184,100,0,0,100,8.542141230068337,69.13129782864397,14,429]
[2023210597,"任锦添",97.0825,5.5,0,102.5825,15.192905805687204,80.82058839999999,5,0,85.82058839999999,44.922504237671234,100,0,0,100,8.542141230068337,68.65755127342678,15,537]
[2023210563,"李海鑫",96.87249999999999,11.75,0,108.62249999999999,16.08745556872038,83.52777769999999,0,0,83.52777769999999,43.722340031072434,100,0,0,100,8.542141230068337,68.35193682986115,16,411]
[2023210596,"马忍龙",97.03,6.15,0,103.18,15.281398104265405,83.55882319999999,1.5,0,85.05882319999999,44.52376075358308,100,0,0,100,8.542141230068337,68.34730008791682,17,336]
[2023210558,"白宇欣",97.20500000000001,23.6,0,120.805,17.891735781990523,79.4,0,0,79.4,41.561668394143716,100,0,0,100,8.542141230068337,67.99554540620258,18,424]
[2023210574,"姜冬雪",97.29250000000002,26.1,0,123.39250000000001,18.274955568720383,77.56842119999999,0.25,0,77.81842119999999,40.73379618224436,100,0,0,100,8.542141230068337,67.55089298103309,19,425]
[2023210594,"蒋洁",97.065,10,0,107.065,15.856783175355453,81.04166669,0,0,81.04166669,42.42099341408692,100,0,0,100,8.542141230068337,66.8199178195107,20,478]
[2023210523,"高文倩",97.2575,9.75,0,107.0075,15.848267180094789,80.88,0.16666666666666666,0,81.04666666666667,42.42361063539925,100,0,0,100,8.542141230068337,66.81401904556238,21,403]
[2023210555,"王诗琪",97.0475,5.65,0,102.6975,15.209937796208534,82.18823549999999,0,0,82.18823549999999,43.02116107998476,100,0,0,100,8.542141230068337,66.77324010626162,22,499]
[2023210547,"张海城",97.01249999999999,0.5,0,97.51249999999999,14.442017180094787,82.8166679,0,0,82.8166679,43.35011194921569,100,4.666666666666667,0,104.66666666666667,8.940774487471527,66.732903616782,23,495]
[2023210524,"刘士花",97.1,10,0,107.1,15.861966824644552,80.19,0.16666666666666666,0,80.35666666666667,42.06243240880026,100,0,0,100,8.542141230068337,66.46654046351316,24,435]
[2023210534,"张则扬",97.03,0,0,97.03,14.370556872037916,81.8666669,0,0,81.8666669,42.852837055813865,100,0,0,100,8.542141230068337,65.76553515792011,25,428]
[2023210562,"程学智",97.03,1,0,98.03,14.518661137440759,80.4666668,1,0,81.4666668,42.64345832138282,100,0,0,100,8.542141230068337,65.70426068889192,26,462]
[2023210610,"崔锦峰",97.13499999999999,2.75,0,99.885,14.793394549763034,80.58999999999999,0,0,80.58999999999999,42.18456997335064,100,0,0,100,8.542141230068337,65.52010575318201,27,444]
[2023210556,"张子硕",97.2225,14.95,0,112.1725,16.613225710900476,74.5722223,0,0,74.5722223,39.034584063563834,100,8.181818181818182,0,108.18181818181819,9.241043694346656,64.88885346881096,28,459]
[2023210614,"袁雨涵",96.99499999999999,6.15,0,103.145,15.276214454976305,77.4176471,0,0,77.4176471,40.52401230006349,100,0,0,100,8.542141230068337,64.34236798510813,29,426]
[2023210520,"鹿兰停",97.2225,2.5,0,99.7225,14.769327606635073,77.5888892,0.75,0,78.3388892,41.006233442014675,100,0,0,100,8.542141230068337,64.31770227871809,30,448]
[2023210611,"史国靖",97.065,2,0,99.065,14.671949052132703,77.6722223,0.41666666666666663,0,78.08888896666667,40.87537164357314,100,0,0,100,8.542141230068337,64.08946192577417,31,462]
[2023210559,"王汉卿",97.0825,3,0,100.0825,14.822645142180097,76.26666689999999,0,0,76.26666689999999,39.921535506604734,100,6.666666666666667,0,106.66666666666667,9.111617312072894,63.85579796085773,32,424]
[2023210575,"许世昌",97.11749999999999,2.25,0,99.3675,14.716750592417064,74.96315759999999,1,0,75.96315759999999,39.76266456351733,100,0,0,100,8.542141230068337,63.021556386002736,33,388]
[2023210613,"石聪超",97.0475,3,0,100.0475,14.817461492890997,75.09444359999999,0,0,75.09444359999999,39.3079390824424,100,0,0,100,8.542141230068337,62.66754180540174,34,435]
["2023210593","储东昊",96.9425,0,0,96.9425,14.357597748815166,75.93333332,0,0,75.93333332,39.747053142415915,100,0,0,100,8.542141230068337,62.64679212129942,35,236]

{"sheet":"工艺专硕","index":1,"n_rows":35,"n_cols":20,"rows_kept":35,"merged":[[0,0,0,19],[1,0,2,0],[1,1,2,1],[1,2,1,6],[1,7,1,11],[1,12,1,16],[1,17,2,17],[1,18,2,18],[1,19,2,19]],"flags":["formulas_cached_only"]}
["中国石油大学（北京）化学工程与环境学院23级化学工艺专业硕士研究生综合测评汇总表"]
["姓名","学号","德育成绩",{"$nulls":4},"智育成绩",{"$nulls":4},"文体成绩",{"$nulls":4},"综测总分","排名","英语六级成绩"]
[null,null,"基础分","奖励分","惩罚分","总分","加权分","学习成绩分","奖励分","惩罚分","总分","加权分","基础分","奖励分","惩罚分","总分","加权分"]
["肖婷",2023215340,97.471875,26.45,0,123.921875,88.23100884244374,81.2991596638655,54.65,0,135.9491596638655,100,100,2,0,102,94.9484919945389,97.14105096794265,1,451]
["谢清宝",2023215349,97.428125,42.5,0,139.928125,99.6272823840147,88.8236842105263,21.5333333333333,0,110.3570175438596,81.17521124567266,100,3.33333333,0,103.33333333,96.18964874953456,86.36706922372727,2,322]
["薛福禄",2023215358,97.5516129032258,42.9,0,140.4516129032258,100,84.0083333333333,10.0333333333333,0,94.0416666666666,69.17414340712718,100,3.7333333333,0,103.7333333333,96.56199578003599,78.07809996299261,3,436]
["王阔博",2023215366,97.40625,6.5,0,103.90625,73.98010450160773,83.9602941176471,17.4345238095238,0,101.39481792717089,74.58289420682684,100,0,0,100,93.08675685739108,76.31272253083944,4,433]
["董俊妍",2023215369,97.40625,12.75,0,110.15625,78.43003559944879,86.0285714285714,12.4347619047619,0,98.4633333333333,72.42658474446186,100,0,0,100,93.08675685739108,75.69329212675217,5,472]
["迟坚全",2023215364,97.40625,22.75,0,120.15625,85.54992535599449,85.4388888888889,2.4,0,87.8388888888889,64.61157178615204,100,0,0,100,93.08675685739108,71.64676100724444,6,458]
["郑隽琳",2023215368,97.5375,14,0,111.5375,79.41347037207166,89.5781512605042,0,0,89.5781512605042,65.89091943045938,100,0,0,100,93.08675685739108,71.315013361475,7,428]
["高鹏飞",2023215377,97.40625,15.15,0,112.55625,80.13880914101976,87.9611111111111,0,0,87.9611111111111,64.70147467523527,100,0,0,100,93.08675685739108,70.62746978660775,8,465]
["刘琦",2023215357,97.40625,15.5,0,112.90625,80.38800528249887,84.6416666666667,2.4,0,87.0416666666667,64.02515975963173,100,0,0,100,93.08675685739108,70.20388857398109,9,430]
["郭玉乾",2023215350,97.5375,14.5,0,112.0375,79.76946485989895,84.2779411764706,1,0,85.2779411764706,62.72781780139021,100,0,0,100,93.08675685739108,69.17204111869204,10,468]
["胡航",2023215374,97.49375,17,0,114.49375,81.5182877813505,83.7676470588235,0,0,83.7676470588235,61.6168921278654,100,0,0,100,93.08675685739108,68.74415773151497,11,482]
["刘佳",2023215375,97.428125,1,0,98.428125,70.07973989435003,85.25,2.5,0,87.75,64.54618786681876,100,0,0,100,93.08675685739108,68.50695517138223,12,454]
["刘亚洁",2023215381,97.384375,12,0,109.384375,77.88046910886543,84.2777777777778,0,0,84.2777777777778,61.99212851786267,100,0,0,100,93.08675685739108,68.27925947001606,13,436]
["章伟",2023215336,97.515625,5.75,0,103.265625,73.52398656407901,85.3470588235294,0,0,85.3470588235294,62.77865860631293,100,0,0,100,93.08675685739108,67.95853402297395,14,359]
["王静",2023215365,97.31875,5,0,102.31875,72.8498220027561,80.2555555555556,5,0,85.2555555555556,62.711351630528725,100,0,0,100,93.08675685739108,67.77658622766043,15,459]
["范思洁",2023215344,97.340625,12,0,109.340625,77.84931959118053,82.8778409090909,0,0,82.8778409090909,60.96237822580625,100,0,0,100,93.08675685739108,67.55220436203959,16,443]
["张想",2023215367,97.471875,12.75,0,110.221875,78.47675987597611,82.5,0,0,82.5,60.684450131197124,100,0,0,100,93.08675685739108,67.48314275277231,17,406]
["焦雪燕",2023215356,97.428125,2.5,0,99.928125,71.14772335783188,84.2157894736842,1,0,85.2157894736842,62.68210092977432,100,0,0,100,93.08675685739108,67.4156910081475,18,444]
["李春晖",2023215315,97.340625,0.5,0,97.840625,69.66144637115296,84.4416666666667,0,0,84.4416666666667,62.1126801191334,100,7.42666666666667,0,107.42666666666668,100,67.41116535762397,19,395]
["张雨",2023215342,97.384375,11.65,0,109.03437500000001,77.63127296738632,82.3777777777778,0,0,82.3777777777778,60.59454724211387,100,0,0,100,93.08675685739108,67.25111334869608,20,463]
["田宇萌",2023215359,97.49375,8,0,105.49375,75.11038700045935,82.6625,0.214285714285714,0,82.8767857142857,60.96160205712098,100,0,0,100,93.08675685739108,67.00387452581566,21,436]
["朱镜宇",2023215371,97.49375,7,0,104.49375,74.39839802480479,82.4647058823529,0,0,82.4647058823529,60.65848886910887,100,0,0,100,93.08675685739108,66.64929749907627,22,332]
["丁风瑞",2023215325,97.471875,2.5,0,99.971875,71.17887287551677,83.6381578947368,0,0,83.6381578947368,61.521643900949655,100,0,0,100,93.08675685739108,66.60960099150722,23,409]
["张诗悦",2023215383,97.45,8,0,105.45,75.07923748277447,80.3777777777778,0,0,80.3777777777778,59.12340905711516,100,0,0,100,93.08675685739108,65.71090952227462,24,434]
["郝良贤",2023215348,97.49375,2.5,0,99.99375,71.19444763435922,81.8277777777778,0,0,81.8277777777778,60.18998424123924,100,0,0,100,93.08675685739108,65.68055418147841,25,428]
["于晓雯",2023215305,97.603125,5,0,102.603125,73.05229386770786,80.025,0,0,80.025,58.86391662726121,100,0,0,100,93.08675685739108,65.12387609836352,26,431]
["宋晓",2023215319,97.340625,7.5,0,104.840625,74.64536920073496,79.2305555555556,0,0,79.2305555555556,58.27954784822008,100,0,0,100,93.08675685739108,65.03343301964016,27,350]
["况博",2023215345,97.340625,1.5,0,98.840625,70.37343534680754,80.6131578947368,0,0,80.6131578947368,59.29654739613909,100,0,0,100,93.08675685739108,64.89094593239798,28,362]
["潘新卓",2023215382,97.428125,9.5,0,106.928125,76.13164618741386,76.2111111111111,0,0,76.2111111111111,56.058537838367805,100,0,0,100,93.08675685739108,63.775981410079346,29,449]
["张荣坤",2023215320,97.384375,5,0,102.384375,72.89654627928343,76.7666666666667,0.5,0,77.2666666666667,56.83497188045049,100,0,0,100,93.08675685739108,63.672465257911135,30,514]
["赵琳",2023215337,97.384375,10.8,0,108.184375,77.02608233807993,74.5972222222222,0,0,74.5972222222222,54.871411052972995,100,0,0,100,93.08675685739108,63.12387989043619,31,447]
["李珍蓉",2023215341,97.471875,10,0,107.471875,76.51879019292605,67.6833333333333,0,0,67.6833333333333,49.78576807733159,100,0,0,100,93.08675685739108,59.46247137845643,32,380]

{"sheet":"工程学硕","index":2,"n_rows":38,"n_cols":20,"rows_kept":38,"merged":[[0,0,0,19],[1,0,2,0],[1,1,2,1],[1,2,1,6],[1,7,1,11],[1,12,1,16],[1,17,2,17],[1,18,2,18],[1,19,2,19]],"flags":["formulas_cached_only"]}
["中国石油大学（北京）化学工程与环境学院2023级化学工程与技术专业化学工程系研究生综合测评汇总表"]
["学号","姓名","德育成绩",{"$nulls":4},"智育成绩",{"$nulls":4},"文体成绩",{"$nulls":4},"总分","排名","英语六级成绩"]
[null,null,"基础分","奖励分","惩罚分","总 分","加权分","学习成绩分","奖励分","惩罚分","总 分","加权分","基本分","奖励分","惩罚分","总 分","加权分"]
[2023210551,"卢非赣",105.6097561,13,0,118.6097561,87.9220881,89.28588235,15.4,0,104.6858824,91.36886961,104.6666667,0,0,104.6666667,96.91358025,91.23398437,1,420]
[2023210545,"张帅",113.303252,21.6,0,134.903252,100,93.92222222,4.8,0,98.72222222,86.16384222,104.9333333,2,0,106.9333333,99.01234568,90.21592412,2,444]
[2023210569,"饶丹",98.32560976,8,0,106.3256098,78.81619468,89.88333333,11.82828283,0,101.7116162,88.77295759,100,0,0,100,92.59259259,87.16356851,3,451]
[2023210510,"刘沐忺",107.3146341,16.5,0,123.8146341,91.78031833,87.71184211,9.114285714,0,96.82612782,84.50894857,101.6,0.833333333,0,102.4333333,94.84567901,86.99689556,4,448]
[2023210573,"祝柯欣",105.3536585,13,0,118.3536585,87.73225015,88.70555556,7.5,0,96.20555556,83.96731884,100,2.166666667,0,102.1666667,94.59876543,85.78344976,5,444]
[2023210538,"贾舒涵",104.7097561,18.5,0,123.2097561,91.33193918,90.81578947,0,0,90.81578947,79.26318086,100,2,0,102,94.44444444,83.19505888,6,530]
[2023210550,"李凌宇",99.55853659,4,0,103.5585366,76.76504089,86.98117647,6.4,0,93.38117647,81.5022269,104.6666667,0,0,104.6666667,96.91358025,82.09592503,7,411]
[2023210516,"郑紫雨",104.5853659,14.3,0,118.8853659,88.12638988,84.68823529,1,0,85.68823529,74.78789901,100,2,0,102,94.44444444,79.42125173,8,416]
[2023210552,"吴兆龙",100.4109756,7,0,107.4109756,79.62074597,84.575,3.4,0,87.975,76.78376609,100,0,0,100,92.59259259,78.93204472,9,418]
[2023210535,"王晶",104.6036585,10,0,114.6036585,84.95248025,85.78,0,0,85.78,74.8679904,100,0,0,100,92.59259259,78.65734859,10,427]
[2023210502,"王炫杰",105.5036585,9.1,0,114.6036585,84.95248025,84.77368421,0,0,84.77368421,73.98968729,103.6,2.1,0,105.7,97.87037037,78.57031419,11,488]
[2023210513,"王燕语",100.8829268,2,0,102.8829268,76.26423031,87.39411765,0.75,0,88.14411765,76.93137041,100,1,0,101,93.51851852,78.4566572,12,430]
[2023210580,"赵乐",97.33658537,0,0,97.33658537,72.15288282,89.005,0.214285714,0,89.21928571,77.86976715,100,0,0,100,92.59259259,78.19867283,13,438]
[2023210566,"王宏帅",97.09268293,4,0,101.0926829,74.93717268,82.84736842,4.489285714,0,87.33665414,76.22662373,100,0,0,100,92.59259259,77.6053304,14,424]
[2023210539,"赵小强",97.35365854,0,0,97.35365854,72.16553869,86.92631579,0,0,86.92631579,75.86848422,103,5,0,108,100,77.54104669,15,461]
[2023210568,"尚文波",106.3878049,17,0,123.3878049,91.46392175,81.60735294,0,0,81.60735294,71.22614265,100,0,0,100,92.59259259,77.41034346,16,423]
[2023210590,"亓美霞",102.2707317,4.5,0,106.7707317,79.14615111,83.44736842,2.089285714,0,85.53665414,74.65560038,100,0,0,100,92.59259259,77.34740975,17,430]
[2023210501,"彭梦甜",102.4304878,3,0,105.4304878,78.15266587,84.12631579,0,0,84.12631579,73.42467012,101.6,1.1,0,102.7,95.09259259,76.53706152,18,503]
[2023210544,"吕国欣",96.00731707,0,0,96.00731707,71.16753349,86.51111111,0,0,86.51111111,75.50609741,100,0,0,100,92.59259259,76.34703415,19,521]
[2023210579,"包立永",96.85365854,3,0,99.85365854,74.01871862,85.215,0.214285714,0,85.42928571,74.56189022,100,0,0,100,92.59259259,76.25632613,20,434]
[2023210588,"翟梦琪",100.3536585,5.5,0,105.8536585,78.46635047,83.32222222,0,0,83.32222222,72.72286469,100,2,0,102,94.44444444,76.04371982,21,429]
[2023210621,"孙利萌",96.92195122,0,0,96.92195122,71.84552615,85.295,0,0,85.295,74.44468689,100,0,0,100,92.59259259,75.73964531,22,441]
[2023210549,"于洪懿",99.78536585,4.5,0,104.2853659,77.30381906,83.40625,0,0,83.40625,72.79620336,100,0,0,100,92.59259259,75.67736542,23,544]
[2023210571,"刘晓慧",99.42195122,4,0,103.4219512,76.66379399,83.25588235,0,0,83.25588235,72.66496387,100,0,0,100,92.59259259,75.45749276,24,425]
[2023210620,"苏雪妮",97.67804878,0,0,97.67804878,72.40600008,84.565,0,0,84.565,73.80754964,100,0,0,100,92.59259259,75.40574402,25,450]
[2023210515,"李乐妍",97.79756098,0,0,97.79756098,72.49459113,82.8496732,1,0,83.8496732,73.18321903,101.3333333,0,0,101.3333333,93.82716049,75.10988759,26,432]
[2023210589,"唐集文",97.75121951,0.5,0,98.25121951,72.83087548,83.45294118,0,0,83.45294118,72.83695499,100,0,0,100,92.59259259,74.81130285,27,423]
[2023210514,"向煜昊",96.87682927,6,0,102.8768293,76.25971036,82.23125,0,0,82.23125,71.77067423,100,0,0,100,92.59259259,74.75067329,28,480]
[2023210511,"钟梓晋",101.004878,4,0,105.004878,77.83717328,80.25789474,0,0,80.25789474,70.04834801,101.6,0,0,101.6,94.07407407,74.00868567,29,466]
[2023210603,"李春辉",96.97317073,0.5,0,97.47317073,72.25412973,81.82777778,0,0,81.82777778,71.41852741,100,0,0,100,92.59259259,73.70305439,30,454]
[2023210565,"李思阳",96.62682927,0,0,96.62682927,71.62676052,81.77894737,0,0,81.77894737,71.37590868,100,0,0,100,92.59259259,73.54774744,31,444]
[2023210581,"杨佳佳",96.07560976,0,0,96.07560976,71.21815694,75.92941176,4.772727273,0,80.70213904,70.43608033,100,0,0,100,92.59259259,72.80814688,32,436]
[2023210572,"王梦博",96.50121951,3.5,30,70.00121951,51.8899422,84.93676471,1,0,85.93676471,75.00481318,101.3333333,0,0,101.3333333,93.82716049,72.26407372,33,491]
[2023210548,"耿心怡",97.40487805,0,0,97.40487805,72.20350628,79.23,0,0,79.23,69.151211,100,0,0,100,92.59259259,72.10580821,34,451]
[2023210536,"臧蒙恩",95.66585366,0,0,95.66585366,70.91441623,74.47,0.375,0,74.845,65.32402357,108,0,0,108,100,69.90969974,35,403]

{"sheet":"催化专硕","index":3,"n_rows":25,"n_cols":20,"rows_kept":25,"merged":[[0,0,0,19],[1,0,2,0],[1,1,2,1],[1,2,1,6],[1,7,1,11],[1,12,1,16],[1,17,2,17],[1,18,2,18],[1,19,2,19]],"flags":["formulas_cached_only"]}
["中国石油大学（北京）化学工程与环境学院23级化学工程专业研究生综合测评汇总表"]
["学号","姓名","德育成绩",{"$nulls":4},"智育成绩",{"$nulls":4},"文体成绩",{"$nulls":4},"总分","排名","英语六级成绩"]
[null,null,"基础分","奖励分","惩罚分","总 分","加权分","学习成绩分","奖励分","惩罚分","总 分","加权分","基本分","奖励分","惩罚分","总 分","加权分"]
["2023215372","崔晨梦",105.8,19.5,0,125.3,20,86.91,7.196,0,94.106,70,104.7,2,0,106.7,8.6536901865369,98.6536901865369,1,471]
["2023215379","刘洪瑜",101.8,4,0,105.8,16.8874700718276,79.23,7.7,0,86.93,64.6621894459439,111.3,12,0,123.3,10,91.5496595177715,2,403]
["2023215317","孟昕蕊",97.8,0,0,97.8,15.61053471668,79.54,7.5,0,87.04,64.7440120714939,100,null,0,100,8.110300081103,88.4648468692768,3,388]
["2023215386","邓建权",97.8,0,0,97.8,15.61053471668,83.58,2,0,85.58,63.6580026778314,100,null,0,100,8.110300081103,87.3788374756144,4,432]
["2023215380","吴一凡",99.05,3,0,102.05,16.2889066241022,82.45,1.364,0,83.814,62.3443776167301,100,null,0,100,8.110300081103,86.7435843219352,5,"无"]
["2023215318","王彩莉",98.8,0,0,98.8,15.7701516360734,82.76,0.9375,0,83.6975,62.2577200178522,100,null,0,100,8.110300081103,86.1381717350286,6,324]
["2023215346","李萌",102.1,5.5,0,107.6,17.1747805267358,81.39,null,0,81.39,60.5413044864302,100,null,0,100,8.110300081103,85.826385094269,7,532]
["2023215363","刘玉玲",101.3,2.5,0,103.8,16.5682362330407,82.06,null,0,82.06,61.0396786602342,101.3,null,0,101.3,8.21573398215734,85.8236488754322,8,"无"]
["2023215308","张煜睿",102.8,8.5,0,111.3,17.7653631284916,76.86,2.778,0,79.638,59.2380932140352,100,null,0,100,8.110300081103,85.1137564236299,9,402]
["2023215331","毛彩云",104.3,0,0,104.3,16.6480446927374,79.4,null,0,79.4,59.0610588060272,105.3,null,0,105.3,8.54014598540146,84.2492494841661,10,451]
["2023215360","倪萌",102.3,9,0,111.3,17.7653631284916,76.03,null,0,76.03,56.5543110959981,108,7.6,0,115.6,9.37550689375507,83.6951811182448,11,423]
["2023215323","杨博澳",102.2,4,0,106.2,16.951316839585,78.56,null,0,78.56,58.4362314836461,100,null,0,100,8.110300081103,83.4978484043341,12,452]
["2023215332","王永发",98.55,0,0,98.55,15.7302474062251,77.79,2.16,0,79.95,59.4701719337768,100,null,0,100,8.110300081103,83.3107194211049,13,400]
["2023215387","周也",99.8,0,0,99.8,15.9297685554669,79,null,0,79,58.7635219858457,100,null,0,100,8.110300081103,82.8035906224156,14,525]
["2023215329","张子健",97.8,0,0,97.8,15.61053471668,79.11,null,0,79.11,58.8453446113957,100,null,0,100,8.110300081103,82.5661794091786,15,0]
["2023215347","孙启宇",97.8,1,0,98.8,15.7701516360734,77.06,null,0,77.06,57.3204684079655,108,null,0,108,8.75912408759124,81.8497441316302,16,465]
["2023215330","周家欣",98.8,0,0,98.8,15.7701516360734,77.42,null,0,77.42,57.5882515461288,100,null,0,100,8.110300081103,81.4687032633053,17,327]
["2023215313","李亚宁",97.8,0,0,97.8,15.61053471668,76.64,null,0,76.64,57.0080547467749,100,null,0,100,8.110300081103,80.7288895445579,18,426]
["2023215307","王心雨",98.55,5,0,103.55,16.5283320031923,72.31,3.028,0,75.338,56.0395723970842,100,null,0,100,8.110300081103,80.6782044813795,19,410]
["2023215314","潘佐丞",97.8,0,0,97.8,15.61053471668,75.95,null,0,75.95,56.4948037319618,100,null,0,100,8.110300081103,80.2156385297448,20,412]
["2023215324","张馨月",98.8,0,0,98.8,15.7701516360734,75.53,null,0,75.53,56.1823900707713,100,null,0,100,8.110300081103,80.0628417879477,21,521]
["2023215343","周旭东",99.05,3,0,102.05,16.2889066241022,72.34,null,0,72.34,53.8095339298238,100,null,0,100,8.110300081103,78.208740635029,22,0]

{"sheet":"工程专硕","index":4,"n_rows":28,"n_cols":20,"rows_kept":28,"merged":[[0,0,0,19],[1,0,2,0],[1,1,2,1],[1,2,1,6],[1,7,1,11],[1,12,1,16],[1,17,2,17],[1,18,2,18],[1,19,2,19]],"flags":["formulas_cached_only"]}
["中国石油大学（北京）化学工程与环境学院23级化学工程专业研究生综合测评汇总表"]
["学号","姓名","德育成绩",{"$nulls":4},"智育成绩",{"$nulls":4},"文体成绩",{"$nulls":4},"总分","排名","英语六级成绩"]
[null,null,"基础分","奖励分","惩罚分","总 分","加权分","学习成绩分","奖励分","惩罚分","总 分","加权分","基本分","奖励分","惩罚分","总 分","加权分"]
["2023215355","孙培杰",97.8,0,0,97.8,15.61053471668,80.94,12,0,92.94,69.1326801691709,100,null,0,100,8.110300081103,92.8535149669539,1,327]
["2023215322","张子贤",102.1,20.1,0,122.2,19.5051875498803,81.7,2.857,0,84.557,62.8970522602172,100,null,0,100,8.110300081103,90.5125398912005,2,442]
["2023215303","唐常平",103.1,6,0,109.1,17.414205905826,83.43,2.9375,0,86.3675,64.2437782925637,100,null,0,100,8.110300081103,89.7682842794927,3,378]
["2023215328","吴世健",97.8,0,0,97.8,15.61053471668,80.56,7.95,0,88.51,65.8374598856608,100,null,0,100,8.110300081103,89.5582946834438,4,449]
["2023215309","田学伏",99.8,3,0,102.8,16.4086193136472,76.82,9.65,0,86.48,64.3274605232398,100,null,0,100,8.110300081103,88.84637991799,5,406]
["2023215362","程森",97.8,0,0,97.8,15.61053471668,85.19,null,0,85.19,63.3679042781544,100,null,0,100,8.110300081103,87.0887390759374,6,410]
["2023215327","王莹",99.3,4.5,0,103.8,16.5682362330407,83.45,null,0,83.45,62.0736191103649,100,null,0,100,8.110300081103,86.7521554245086,7,477]
["2023215301","郭佩琦",97.8,0,0,97.8,15.61053471668,84.47,null,0,84.47,62.8323380018277,100,null,0,100,8.110300081103,86.5531727996107,8,426]
["2023215333","侯艳伟",100.3,0,0,100.3,16.0095770151636,83.73,null,0,83.73,62.281894884492,100,null,0,100,8.110300081103,86.4017719807586,9,424]
["2023215321","樊王臣",98.3,0,0,98.3,15.6903431763767,82.19,1.786,0,83.976,62.4648800289036,100,null,0,100,8.110300081103,86.2655232863833,10,465]
["2023215304","张瑞宁",98.3,1,0,99.3,15.8499600957702,83.05,null,0,83.05,61.7760822901834,100,null,0,100,8.110300081103,85.7363424670566,11,486]
["2023215335","朱紫橙",105.3,13.05,0,118.35,18.8906624102155,78.09,0.5,0,78.59,58.4585467451597,100,2,0,102,8.27250608272506,85.6217152381003,12,499]
["2023215310","邢鹏飞",100.8,0,0,100.8,16.0893854748603,77.35,3.75,0,81.1,60.3255902917986,100,null,0,100,8.110300081103,84.5252758477619,13,410]
["2023215352","杨博旭",97.8,0,0,97.8,15.61053471668,78.94,1.875,0,80.815,60.1135953074193,105.3,null,0,105.3,8.54014598540146,84.2642760095007,14,382]
["2023215311","方海艳",97.8,0,0,97.8,15.61053471668,81.39,null,0,81.39,60.5413044864302,100,null,0,100,8.110300081103,84.2621392842132,15,432]
["2023215312","张钊宁",98.3,0,0,98.3,15.6903431763767,80.19,null,0,80.19,59.6486940258857,100,null,0,100,8.110300081103,83.4493372833654,16,447]
["2023215385","战沚榕",101.8,3.5,0,105.3,16.8076616121309,78.68,null,0,78.68,58.5254925297006,100,null,0,100,8.110300081103,83.4434542229344,17,476]
["2023215339","范晓旭",97.8,0,0,97.8,15.61053471668,79.77,null,0,79.77,59.3362803646951,100,null,0,100,8.110300081103,83.0571151624781,18,417]
["2023215302","尹泽坤",98.8,4,0,102.8,16.4086193136472,78.63,null,0,78.63,58.4883004271779,100,null,0,100,8.110300081103,83.0072198219281,19,427]
["2023215338","张晓宇",97.8,3,0,100.8,16.0893854748603,77.74,null,0,77.74,57.826281002274,100,null,0,100,8.110300081103,82.0259665582374,20,555]
["2023215354","甘杨",97.8,0,0,97.8,15.61053471668,78.08,null,0,78.08,58.0791872994283,100,null,0,100,8.110300081103,81.8000220972113,21,442]
["2023215326","付前程",97.8,0,0,97.8,15.61053471668,77.12,null,0,77.12,57.3650989309927,100,null,0,100,8.110300081103,81.0859337287757,22,400]
["2023215384","彭旭栋",97.8,0,0,97.8,15.61053471668,76.05,null,0,76.05,56.5691879370072,100,null,0,100,8.110300081103,80.2900227347902,23,320]
["2023215353","蔡高龙",98.3,0,0,98.3,15.6903431763767,70.93,null,0,70.93,52.760716638684,103.3,null,0,103.3,8.3779399837794,76.8289997988401,24,0]
["2023215373","邵婷婷",102.3,7.5,0,109.8,17.5259377494014,67.63,null,0,67.63,50.3060378721867,100,null,0,100,8.110300081103,75.9422757026911,25,422]

{"sheet":"催化学硕","index":5,"n_rows":33,"n_cols":20,"rows_kept":33,"merged":[[0,0,0,19],[1,0,2,0],[1,1,2,1],[1,2,1,6],[1,7,1,11],[1,12,1,16],[1,17,2,17],[1,18,2,18],[1,19,2,19]],"flags":["formulas_cached_only"]}
["中国石油大学（北京）化学工程与环境学院23级化学工程与技术专业研究生综合测评汇总表"]
["学号","姓名","德育成绩",{"$nulls":4},"智育成绩",{"$nulls":4},"文体成绩",{"$nulls":4},"总分","排名","英语六级成绩"]
[null,null,"基础分","奖励分","惩罚分","总 分","加权分","学习成绩分","奖励分","惩罚分","总 分","加权分","基本分","奖励分","惩罚分","总 分","加权分"]
[2023210509,"温立坤",97.6133333333333,31.9,0,129.513333333333,100,75.944,14.11577777777778,0,90.0597777777778,97.7033260944802,100,1.33333333333333,0,101.333333333333,84.9164383140735,96.8839720975435,1,392]
[2023210508,"宋伊辰",97.6833333333333,10.85,0,108.533333333333,83.8008956606786,79.861,12.31577777777778,0,92.1767777777778,99.9999999975892,100,1.33333333333333,0,101.333333333333,84.9164383140735,95.2518229618555,2,375]
["2023210616","张雪莲",97.6366666666667,24,0,121.636666666667,93.9182580944049,83.042,4.3,0,87.342,94.7548852363453,100,1.6,0,101.6,85.1399026254263,93.6260615468653,3,480]
["2023210557","陶欣",97.6133333333333,13.5,0,111.113333333333,85.7929685489269,89.27,0.25,0,89.52,97.1177363279708,100,0,0,100,83.7991167573094,93.5209208150959,4,374]
["2023210602","王丹",97.59,22,0,119.59,92.3379832192312,80.507,6.5,0,87.007,94.3914531354754,100,5,0,105,87.9890725951748,93.3405210981965,5,449]
["2023210601","宋骥寰",97.5666666666667,5.5,0,103.066666666667,79.5799660266642,78.423,12.375,0,90.798,98.5042026709908,100,0,0,100,83.7991167573094,93.2488467507573,6,496]
["2023210586","王卓雅",97.5433333333333,22.9,0,120.443333333333,92.9968600401505,86.287,0,0,86.287,93.6103453365909,100,1.33333333333333,0,101.333333333333,84.9164383140735,92.6182575750511,7,436]
["2023210622","魏来",97.4733333333333,20,0,117.473333333333,90.7036598548414,82.589,2.4,0,84.989,92.2021815547131,100,0,0,100,83.7991167573094,91.0621707349984,8,462]
["2023210605","胡瑞珍",97.3566666666667,26.3,0,123.656666666667,95.477943068925,83.127,0,0,83.127,90.1821499970423,100,1.6,0,101.6,85.1399026254263,90.7370838742573,9,464]
["2023210528","郭萧菡",97.5666666666667,9.5,0,107.066666666667,82.6684511247236,78.644,7.5,0,86.144,93.4552086487569,100,0,0,100,83.7991167573094,90.3322479548055,10,406]
["2023210615","王宇凡",97.52,13,0,110.52,85.3348432593815,75.621,6.806,0,82.427,89.4227396370158,100,19.333,0,119.333,100,89.6628863977873,11,385]
[2023210507,"游瑞琦",97.4966666666667,3,0,100.496666666667,77.595614351161,85.544,0.25,0,85.794,93.0755034687436,100,1.33333333333333,0,101.333333333333,84.9164383140735,89.1636191297601,12,461]
[2023210518,"袁紫颖",97.59,2,0,99.59,76.8955577289342,84.469,0,0,84.469,91.6380481444076,100,1.33333333333333,0,101.333333333333,84.9164383140735,88.0173890782795,13,466]
[2023210512,"李偲珠",97.6366666666667,9.75,0,107.386666666667,82.9155299325683,82.069,0,0,82.069,89.0343554814593,100,1.33333333333333,0,101.333333333333,84.9164383140735,87.3987986549425,14,432]
["2023210624","李超超",97.6366666666667,10.15,0,107.786666666667,83.2243784423743,81.315,0,0,81.315,88.2163620365164,100,1.33333333333333,0,101.333333333333,84.9164383140735,86.8879729454437,15,494]
["2023210623","吴桐雨",97.52,19.75,0,117.27,90.5466618623567,78.389,1.071,0,79.46,86.2039245824459,100,0,0,100,83.7991167573094,86.8319912559144,16,421]
[2023210521,"秦欣妍",97.59,3.75,0,101.34,78.2467699593352,82.683,0,0,82.683,89.7004668543969,100,0,0,100,83.7991167573094,86.8195924656758,17,480]
["2023210560","孙琪",97.5433333333333,13.75,0,111.293333333333,85.9319503783396,80.438,0,0,80.438,87.2649293425974,100,1.33333333333333,0,101.333333333333,84.9164383140735,86.7634844468934,18,491]
["2023210530","张佳宁",97.6133333333333,1.5,0,99.1133333333333,76.5275132547487,83.029,0,0,83.029,90.0758325466386,100,0,0,100,83.7991167573094,86.7384971093277,19,469]
["2023210543","王青青",97.5666666666667,3.5,0,101.066666666667,78.0357234776344,81.318,0,0,81.318,88.2196166523451,100,1.33333333333333,0,101.333333333333,84.9164383140735,85.8525201835758,20,427]
["2023210541","关雪倩",97.6366666666667,1.5,0,99.1366666666667,76.5455294178208,81.284,0.5,0,81.784,88.7251669777342,100,0,0,100,83.7991167573094,85.796634443709,21,428]
[2023210522,"文博",97.6133333333333,0,0,97.6133333333333,75.3693313429764,81.293,0,0,81.293,88.1924948537727,100,0,0,100,83.7991167573094,85.1885243419671,22,403]
["2023210540","边宇",97.4733333333333,0,0,97.4733333333333,75.2612343645444,80.276,0,0,80.276,87.0891800878484,100,0,0,100,83.7991167573094,84.3945846101337,23,435]
["2023210529","姜雯雯",97.5433333333333,1.5,0,99.0433333333333,76.4734647655327,79.118,0,0,79.118,85.8328983779758,100,0,0,100,83.7991167573094,83.7576334934205,24,502]
[2023210517,"谭芃健",97.6833333333333,14.100000000000001,0,111.783333333333,86.3102898028519,76.162,0,0,76.162,82.6260169147779,100,0,0,100,83.7991167573094,83.4801814766458,25,353]
["2023210561","王虹达",97.5666666666667,0.75,0,98.3166666666667,75.9123899727186,78.181,0,0,78.181,84.8163733674831,100,0,0,100,83.7991167573094,82.9338510275128,26,420]
["2023210542","江宽",97.4966666666667,0,0,97.4966666666667,75.2792505276164,77.169,0,0,77.169,83.7184829612732,100,0,0,100,83.7991167573094,82.0386998541455,27,357]
["2023210625","梅博翔",97.45,6,0,103.45,79.8759458485615,73.701,0,0,73.701,79.956147063313,100,4.667,0,104.667,87.710021536373,80.7154942676687,28,441]
["2023210591","翟增增",97.5433333333333,0,0,97.5433333333333,75.3152828537604,74.867,0,0,74.867,81.2211077487287,100,1.33333333333333,0,101.333333333333,84.9164383140735,80.4094758262695,29,392]
["2023210606","袁晖",97.66,2,0,99.66,76.9496062181502,71.836,0,0,71.836,77.9328608898136,100,0,0,100,83.7991167573094,78.3228355422305,30,492]

{"sheet":"环境学硕","index":6,"n_rows":43,"n_cols":20,"rows_kept":43,"merged":[[0,0,0,19],[1,0,2,0],[1,1,2,1],[1,2,1,6],[1,7,1,11],[1,12,1,16],[1,17,2,17],[1,18,2,18],[1,19,2,19]],"flags":["formulas_cached_only"]}
["中国石油大学（北京）化学工程与环境学院2023级环境科学与工程专业研究生综合测评汇总表"]
["学号","姓名","德育成绩",{"$nulls":4},"智育成绩",{"$nulls":4},"文体成绩",{"$nulls":4},"总分","排名","英语六级成绩"]
[null,null,"基础分","奖励分","惩罚分","总 分","加权分","学习成绩分","奖励分","惩罚分","总 分","加权分","基本分","奖励分","惩罚分","总 分","加权分"]
["2023210671","孟德静",97.7641025641026,21,0,118.7641025641026,76.79044521149787,86.3670588235294,34.696428571,0,121.0634873945294,99.99999784784777,100,0,0,100,75.15030041295014,92.87311757708802,1,392]
["2023210651","黄康平",97.7461538461538,27,0,124.7461538461538,80.65831750042274,81.1631578947368,30,0,111.1631578947368,91.82219833141833,100,2,0,102,76.65330642120915,88.07253297419831,2,514]
["2023210662","朱文杰",97.7641025641026,18.75,0,116.5141025641026,75.33564112511483,85.4222222222222,25.03901875,0,110.4612409722222,91.24240592454603,100,8.66666666666667,0,108.66666666666667,81.66332644873917,87.1031450170791,3,448]
["2023210653","王怡",97.7461538461538,50.5,0,148.2461538461538,95.85293795820108,86.5625,6.625,0,93.1875,76.97407368645989,100,33.0666666666666,0,133.0666666666666,99.99999974949895,83.05243914711204,4,488]
["2023210643","安佳怡",97.7102564102564,30.625,0,128.33525641025642,82.978957978958,91.35625,9.33928571428567,0,100.69553571428567,83.17580776358395,100,1.33333333333333,0,101.33333333333333,76.15230441845614,82.43408747214598,5,407]
["2023210645","田丽婷",97.7641025641026,30.3,0,128.0641025641026,82.8036354352144,88.96875,9.33928571428567,0,98.30803571428567,81.20370205277055,100,7,0,107,80.41082144185667,81.44440066816793,6,515]
["2023210670","刘文婧",97.7461538461538,16,0,113.7461538461538,73.54594196699458,79.92,21.571428571,0,101.491428571,83.83322550093344,100,0,0,100,75.15030041295014,80.90747628534734,7,454]
["2023210634","张乘慧",97.8,56.86,0,154.66,100,88.89375,1.92460317460314,0,90.81835317460313,75.01712793394864,100,0,0,100,75.15030041295014,80.02701959505906,8,505]
["2023210646","周薇",97.7820512820513,10.5,0,108.2820512820513,70.01296474980687,89.35,11.73928571,0,101.08928571,83.50105032491629,100,0,0,100,75.15030041295014,79.96835821869779,9,479]
["2023210649","祁润宇",97.7641025641026,40.6,0,138.3641025641026,89.46340525287897,84.1833333333333,8.5,0,92.6833333333333,76.55762553461271,100,1.33333333333333,0,101.33333333333333,76.15230441845614,79.09824936665031,10,461]
["2023210664","周睿",97.7461538461538,10,0,107.7461538461538,69.66646440330649,89.5833333333333,9.3,0,98.8833333333333,81.67890528625377,100,0,0,100,75.15030041295014,78.62355662233395,11,452]
["2023210656","张朦",97.7461538461538,25.25,0,122.9961538461538,79.52680321101371,90.5538461538462,0.014285714285714,0,90.56813186813191,74.81044191616475,100,0,0,100,75.15030041295014,75.78770002481308,12,456]
["2023210667","赵泽玉",97.7641025641026,28,0,125.7641025641026,81.31650236913397,89.58,0.06,0,89.64,74.04379305437172,100,0,0,100,75.15030041295014,75.60898565318202,13,415]
["2023210661","朱怡霏",97.7641025641026,28.1,0,125.86410256410261,81.38116032852878,88.8625,0.158333333333333,0,89.02083333333333,73.53235342326025,100,2,0,102,76.65330642120915,75.41421010410885,14,416]
["2023210655","左慧",97.7641025641026,15,0,112.7641025641026,72.91096764780977,87.875,3.17708333333333,0,91.05208333333333,75.21019205157006,100,0,0,100,75.15030041295014,74.744358006956,15,504]
["2023210641","程诚",97.7820512820513,20,0,117.7820512820513,76.15547089231302,88.42,0,0,88.42,73.03605736130686,100,10.4,0,110.4,82.96593165589697,74.65292749696711,16,486]
["2023210675","张旭",97.7820512820513,34.5,0,132.2820512820513,85.53087500455923,85.19375,0,0,85.19375,70.37113336151138,100,6.66666666666667,0,106.66666666666667,80.16032044048018,74.38200039801782,17,442]
["2023210642","杨梦涵",97.7820512820513,16.75,0,114.5320512820513,74.05408721198197,90,0,0,90,74.34115768511217,100,0,0,100,75.15030041295014,74.36465786326993,18,322]
["2023210647","程蕊",97.7641025641026,40,0,137.7641025641026,89.07545749651014,84.610989010989,0,0,84.610989010989,69.88976528843584,100,0,0,100,75.15030041295014,74.25295724250213,19,514]
["2023210632","王瑞涵",97.7641025641026,24.6,0,122.36410256410261,79.11813174971073,85.35625,0.77,0,86.12625,71.14139035641546,100,11.0666666666667,0,111.0666666666667,83.46693365864999,73.96929296529795,20,412]
["2023210674","彭慧民",97.7820512820513,24.75,0,122.5320512820513,79.22672396356609,86.18125,0,0,86.18125,71.1868210638897,100,5,0,105,78.90781543359766,73.56690108079576,21,476]
["2023210648","史凡佳",97.7820512820513,21.75,0,119.5320512820513,77.28698518172205,86.8428571428571,0,0,86.8428571428571,71.73331707425343,100,5,0,105,78.90781543359766,73.56150053168157,22,439]
["2023210633","肖心语",97.7461538461538,14.5,0,112.2461538461538,72.57607257607256,87.41125,0,0,87.41125,72.20281688558623,100,8,0,108,81.16232444598616,73.17341877972348,23,454]
["2023210666","牛泽琳",97.7820512820513,15,0,112.7820512820513,72.92257292257294,87.6944444444444,0.158333333333333,0,87.85277777777773,72.56752450947658,100,0,0,100,75.15030041295014,72.89681178244322,24,348]
["2023210652","李昕玥",97.7820512820513,10.5,0,108.2820512820513,70.01296474980687,85.1578947368421,3.5288462,0,88.6867409368421,73.2563888062719,100,0,0,100,75.15030041295014,72.79709515564672,25,457]
["2023210669","姚玲珑",97.7641025641026,28.05,0,125.8141025641026,81.34883134883137,77.06,6.11688311688311,0,83.17688311688312,68.70517537275946,100,11.3333333333333,0,111.3333333333333,83.66733445975115,72.730122476673,26,453]
["2023210660","张慧",97.7820512820513,17.5,0,115.2820512820513,74.53902190744297,86.8125,0,0,86.8125,71.70824168376444,100,0,0,100,75.15030041295014,72.61860360141871,27,435]
["2023210644","孙金博",97.7282051282051,20.5,0,118.2282051282051,76.44394486499748,84.81875,0,0,84.81875,70.06137853782342,100,2,0,102,76.65330642120915,71.9970845915968,28,434]
["2023210637","于超凡",97.7461538461538,21.1,0,118.84615384615381,76.84349789612945,84.82875,0,0,84.82875,70.06963866645509,100,0,0,100,75.15030041295014,71.93247668703947,29,450]
["2023210668","郭晨",97.7820512820513,10.5,0,108.2820512820513,70.01296474980687,86.0933333333333,0,0,86.0933333333333,71.11420076633617,100,0,0,100,75.15030041295014,71.29756352769171,30,384]
["2023210657","周兴楠",97.7282051282051,22,0,119.7282051282051,77.4138142559195,82.4133333333333,0.014285714285714,0,82.42761904761902,68.08627361363777,100,1.33333333333333,0,101.33333333333333,76.15230441845614,70.75838482257595,31,392]
["2023210638","张晓玉",97.7820512820513,12.5,0,110.2820512820513,71.3061239377029,83.1694117647059,0.4,0,83.5694117647059,69.029409085023,100,0,0,100,75.15030041295014,70.0968411883517,32,426]
["2023210650","程子涵",97.7282051282051,11.5,0,109.2282051282051,70.62472851946535,81.865,1,0,82.865,68.44755590640911,100,0,0,100,75.15030041295014,69.55326487967446,33,375]
["2023210659","李秋实",97.7102564102564,12.5,0,110.2102564102564,71.25970283865021,82.4666666666667,0,0,82.4666666666667,68.11852744924725,100,0,0,100,75.15030041295014,69.44993982349814,34,426]
["2023210663","于京京",97.7820512820513,10,0,107.7820512820513,69.68967495283286,82.5166666666667,0,0,82.5166666666667,68.15982809240565,100,0,0,100,75.15030041295014,69.16484469654554,35,466]
["2023210636","郭鹏辉",97.7641025641026,18,0,115.7641025641026,74.85070642965383,79.1247619047619,0.75,0,79.8747619047619,65.97758077580772,100,0,0,100,75.15030041295014,68.66947787029119,36,437]
["2023210658","祝万里",97.7641025641026,16,0,113.7641025641026,73.55754724175779,75.8275,2.5,0,78.3275,64.6995225397847,100,0,0,100,75.15030041295014,67.51620526749586,37,431]
["2023210635","戴国辉",97.7820512820513,10,0,107.7820512820513,69.68967495283286,78.5210526315789,1.01666666666666,0,79.53771929824556,65.69917924738958,100,0,0,100,75.15030041295014,67.4423905050343,38,450]
["2023210673","曾子严",97.7820512820513,8.5,0,106.2820512820513,68.71980556191085,77.2692307692308,1.5,0,78.7692307692308,65.0643978372264,100,0,0,100,75.15030041295014,66.80406963973566,39,"457\n"]
["2023210672","梁璐",97.7641025641026,10,0,107.7641025641026,69.6780696780697,74.5233333333333,0,0,74.5233333333333,61.5572319394834,100,0,0,100,75.15030041295014,64.54070633454734,40,430]

{"sheet":"环境专硕","index":7,"n_rows":23,"n_cols":20,"rows_kept":23,"merged":[[0,0,0,19],[1,0,2,0],[1,1,2,1],[1,2,1,6],[1,7,1,11],[1,12,1,16],[1,17,2,17],[1,18,2,18],[1,19,2,19]],"flags":["formulas_cached_only"]}
["中国石油大学（北京）化学工程与环境学院2023级环境工程专业研究生综合测评汇总表"]
["学号","姓名","德育成绩",{"$nulls":4},"智育成绩",{"$nulls":4},"文体成绩",{"$nulls":4},"总分","排名","英语六级成绩"]
[null,null,"基础分","奖励分","惩罚分","总 分","加权分","学习成绩分","奖励分","惩罚分","总 分","加权分","基本分","奖励分","惩罚分","总 分","加权分"]
["2023215406","耿小蝶",97.7631578947368,17,0,114.7631578947368,89.11821789865212,82.9193277310924,9.8214285714285,0,92.7407563025209,100.00000032620059,100,0,0,100,83.84548953189064,96.20819276125991,1,503]
["2023215393","李若熙",97.7631578947368,24.5,0,122.2631578947368,94.9422702034253,82.1588235294118,6.06456048,0,88.2233840094118,95.12903260073898,100,19.2666666666667,0,119.26666666666671,99.99972051503494,95.57874891270583,2,403]
["2023215398","王晨露",97.7263157894737,31.05,0,128.7763157894737,99.99999983651783,88.33125,0,0,88.33125,95.24534175675686,100,0,0,100,83.84548953189064,95.05628815022243,3,446]
["2023215394","杨子茵",97.6526315789474,10.5,0,108.1526315789474,83.98487776195384,83.0588235294118,6.06456048,0,89.1233840094118,96.09947972540982,100,11.3333333333333,0,111.3333333333333,93.34797834550488,93.40140919472812,4,361]
["2023215388","罗文",97.7631578947368,15,0,112.7631578947368,87.56513728404593,88.8205882352941,0.5,0,89.3205882352941,96.3121200298325,100,0,0,100,83.84548953189064,93.316060430881,5,459]
["2023215399","楚悦",97.8,18,0,115.8,89.92336758569797,87.5894736842105,0.014285714285714,0,87.60375939849622,94.46090713180753,100,0,0,100,83.84548953189064,92.49185746259393,6,415]
["2023215400","谢承翰",97.6894736842105,15,0,112.6894736842105,87.50791852456044,83.8052631578947,0,0,83.8052631578947,90.36508518206892,100,36,0,136,114.02986576337126,92.16012990869746,7,415]
["2023215392","马海润",97.7263157894737,22.9,0,120.6263157894737,93.67119633199765,80.0052631578947,4.29166666666667,0,84.29692982456137,90.895236852028,100,14.6666666666667,0,114.6666666666667,96.14282799656796,91.97518786247592,8,400]
["2023215396","李海岩",97.7631578947368,17,0,114.7631578947368,89.11821789865212,87.0791666666667,0,0,87.0791666666667,93.89525212266621,100,0,0,100,83.84548953189064,91.93486901878583,9,508]
["2023215395","曹江浩",97.7263157894737,10,0,107.7263157894737,83.65382636778776,87.6842105263158,0.5,0,88.1842105263158,95.08679282959025,100,0,0,100,83.84548953189064,91.67606920745979,10,471]
["2023215407","胡达民",97.7631578947368,10,0,107.7631578947368,83.68243574753048,80.7781512605042,7.01587301520634,0,87.79402427571054,94.66606491293918,100,0,0,100,83.84548953189064,91.38728154175257,11,404]
["2023215391","陈晓吉",97.7631578947368,19.5,0,117.2631578947368,91.05956866690984,83.2210526315789,1,0,84.2210526315789,90.81342040340807,100,12.9333333333333,0,112.9333333333333,94.68950617801514,91.25025863356913,12,446]
["2023215397","刘畅",97.7631578947368,21,0,118.7631578947368,92.22437912786448,82.2764705882353,0,0,82.2764705882353,88.71662701157547,100,0,0,100,83.84548953189064,88.93106368686479,13,422]
["2023215389","薛世博",97.7631578947368,10.5,0,108.2631578947368,84.07070590118202,82.8573529411765,0,0,82.8573529411765,89.34297768844638,100,0,0,100,83.84548953189064,87.73877451533794,14,401]
["2023215404","朱岳恒",97.7263157894737,5,0,102.7263157894737,79.7711248312723,83.3684210526316,0,0,83.3684210526316,89.89404944319367,100,0,0,100,83.84548953189064,87.2646085296791,15,338]
["2023215402","袁野",97.7631578947368,10,0,107.7631578947368,83.68243574753048,81.1897058823529,0,0,81.1897058823529,87.54479625155622,100,0,0,100,83.84548953189064,86.40239347878452,16,452]
["2023215390","李烁",97.6894736842105,11.5,0,109.1894736842105,84.79002744899962,80.7421052631579,0,0,80.7421052631579,87.06215988055769,100,0,0,100,83.84548953189064,86.28606635937938,17,422]
["2023215401","乔兰",97.7631578947368,14.75,0,112.5131578947368,87.37100220722016,78.5991596638655,0,0,78.5991596638655,84.75147610815843,100,0,0,100,83.84548953189064,85.18478267034399,18,454]
["2023215405","吴泽笠",97.7631578947368,5,0,102.7631578947368,79.79973421101502,78.49,1.36363636363636,0,79.85363636363635,86.1041464484464,100,0,0,100,83.84548953189064,84.61739830930455,19,369]
["2023215403","张瑜亮",94.8,10,0,104.8,81.38142420536397,79.0875,0,0,79.0875,85.27804108045011,100,0,0,100,83.84548953189064,84.35546255057693,20,424]

{"sheet":"国际班","index":8,"n_rows":20,"n_cols":20,"rows_kept":20,"merged":[[0,0,0,19],[1,0,2,0],[1,1,2,1],[1,2,1,6],[1,7,1,11],[1,12,1,16],[1,17,2,17],[1,18,2,18],[1,19,2,19]],"flags":["formulas_cached_only"]}
["中国石油大学（北京）化学工程与环境学院23级国际班研究生综合测评汇总表"]
["学号","姓名","德育成绩",{"$nulls":4},"智育成绩",{"$nulls":4},"文体成绩",{"$nulls":4},"总分","排名","英语六级成绩"]
[null,null,"基础分","奖励分","惩罚分","总 分","加权分","学习成绩分","奖励分","惩罚分","总 分","加权分","基本分","奖励分","惩罚分","总 分","加权分"]
[2023215376,"刘艺霖",{"v":95.37331,"d":"95.3733"},{"v":16.3,"d":"16.3000"},{"v":0,"d":"0.0000"},{"v":111.67331,"d":"111.6733"},{"v":82.50145538685217,"d":"82.5015"},91.5909,{"v":18.2,"d":"18.2000"},{"v":0,"d":"0.0000"},{"v":109.79090000000001,"d":"109.7909"},{"v":100.00000000000003,"d":"100.0000"},{"v":100,"d":"100.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":100,"d":"100.0000"},{"v":93.74970703216552,"d":"93.7497"},{"v":95.875261780587,"d":"95.8753"},1,434]
[2023210676,"荆体瑞",96.7262,{"v":38.633,"d":"38.6330"},{"v":0,"d":"0.0000"},{"v":135.35920000000002,"d":"135.3592"},{"v":100.00000000000003,"d":"100.0000"},{"v":90.20708,"d":"90.2071"},{"v":9.6,"d":"9.6000"},{"v":0,"d":"0.0000"},{"v":99.80708,"d":"99.8071"},{"v":90.90651411000366,"d":"90.9065"},{"v":100,"d":"100.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":100,"d":"100.0000"},{"v":93.74970703216552,"d":"93.7497"},{"v":93.0095305802191,"d":"93.0095"},2,473]
[2023210640,"龚灵俐",{"v":97.05331,"d":"97.0533"},{"v":13.5,"d":"13.5000"},{"v":0,"d":"0.0000"},{"v":110.55331,"d":"110.5533"},{"v":81.67402732876671,"d":"81.6740"},{"v":86.065,"d":"86.0650"},{"v":12,"d":"12.0000"},{"v":0,"d":"0.0000"},{"v":98.065,"d":"98.0650"},{"v":89.3197887985252,"d":"89.3198"},{"v":100,"d":"100.0000"},{"v":2.667,"d":"2.6670"},{"v":0,"d":"0.0000"},{"v":102.667,"d":"102.6670"},{"v":96.25001171871338,"d":"96.2500"},{"v":88.48365879659232,"d":"88.4837"},3,491]
[2023210627,"张伟浩",96.7733,{"v":12.8,"d":"12.8000"},{"v":0,"d":"0.0000"},109.5733,{"v":80.95002039019144,"d":"80.9500"},89.6823,{"v":7.5,"d":"7.5000"},{"v":0,"d":"0.0000"},97.1823,{"v":88.51580595477402,"d":"88.5158"},{"v":100,"d":"100.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":100,"d":"100.0000"},{"v":93.74970703216552,"d":"93.7497"},{"v":87.52603894959665,"d":"87.5260"},4,464]
[2023210665,"刘程程",{"v":96.96,"d":"96.9600"},{"v":11,"d":"11.0000"},{"v":0,"d":"0.0000"},{"v":107.96,"d":"107.9600"},{"v":79.75815459902246,"d":"79.7582"},{"v":87.07348,"d":"87.0735"},{"v":7.9,"d":"7.9000"},{"v":0,"d":"0.0000"},{"v":94.97348000000001,"d":"94.9735"},{"v":86.5039634432362,"d":"86.5040"},{"v":100,"d":"100.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":100,"d":"100.0000"},{"v":93.74970703216552,"d":"93.7497"},{"v":85.87937603328638,"d":"85.8794"},5,433]
[2023210630,"王中琦",{"v":96.02669,"d":"96.0267"},{"v":10,"d":"10.0000"},{"v":0,"d":"0.0000"},{"v":106.02669,"d":"106.0267"},{"v":78.32987340350712,"d":"78.3299"},{"v":93.16174,"d":"93.1617"},{"v":0.5,"d":"0.5000"},{"v":0,"d":"0.0000"},{"v":93.66174,"d":"93.6617"},{"v":85.30920140011604,"d":"85.3092"},{"v":100,"d":"100.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":100,"d":"100.0000"},{"v":93.74970703216552,"d":"93.7497"},{"v":84.75738636399919,"d":"84.7574"},6,543]
[2023210629,"斯潮涌",{"v":96.82,"d":"96.8200"},{"v":11,"d":"11.0000"},{"v":0,"d":"0.0000"},{"v":107.82,"d":"107.8200"},{"v":79.65472609176177,"d":"79.6547"},{"v":88.88,"d":"88.8800"},{"v":2.6,"d":"2.6000"},{"v":0,"d":"0.0000"},{"v":91.47999999999999,"d":"91.4800"},{"v":83.32202395644812,"d":"83.3220"},{"v":100,"d":"100.0000"},{"v":6.667,"d":"6.6670"},{"v":0,"d":"0.0000"},{"v":106.667,"d":"106.6670"},{"v":100,"d":"100.0000"},{"v":84.25636198786603,"d":"84.2564"},7,486]
[2023210631,"祖思雅",{"v":97.19331,"d":"97.1933"},{"v":17,"d":"17.0000"},{"v":0,"d":"0.0000"},{"v":114.19331,"d":"114.1933"},{"v":84.36316851754444,"d":"84.3632"},{"v":90.121,"d":"90.1210"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":90.121,"d":"90.1210"},{"v":82.08421645145454,"d":"82.0842"},{"v":100,"d":"100.0000"},{"v":2.667,"d":"2.6670"},{"v":0,"d":"0.0000"},{"v":102.667,"d":"102.6670"},{"v":96.25001171871338,"d":"96.2500"},{"v":83.95658639139839,"d":"83.9566"},8,432]
[2023215316,"赵冬蕊",{"v":95.88669,"d":"95.8867"},{"v":12.3,"d":"12.3000"},{"v":0,"d":"0.0000"},{"v":108.18669,"d":"108.1867"},{"v":79.92562751552906,"d":"79.9256"},89.2927,{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},89.2927,{"v":81.32978234079509,"d":"81.3298"},{"v":100,"d":"100.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":100,"d":"100.0000"},{"v":93.74970703216552,"d":"93.7497"},{"v":82.29094384487891,"d":"82.2909"},9,471]
[2023210639,"甘意群",{"v":97.05331,"d":"97.0533"},{"v":14,"d":"14.0000"},{"v":0,"d":"0.0000"},{"v":111.05331,"d":"111.0533"},{"v":82.04341485469773,"d":"82.0434"},{"v":87.56,"d":"87.5600"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":87.56,"d":"87.5600"},{"v":79.75160054248576,"d":"79.7516"},{"v":100,"d":"100.0000"},{"v":6.667,"d":"6.6670"},{"v":0,"d":"0.0000"},{"v":106.667,"d":"106.6670"},{"v":100,"d":"100.0000"},{"v":82.23480335067958,"d":"82.2348"},10,426]
[2023210584,"张蕴梅",{"v":95.14,"d":"95.1400"},{"v":5,"d":"5.0000"},{"v":0,"d":"0.0000"},{"v":100.14,"d":"100.1400"},{"v":73.98093369346155,"d":"73.9809"},{"v":88.07669,"d":"88.0767"},0.9375,{"v":0,"d":"0.0000"},{"v":89.01419,"d":"89.0142"},{"v":81.07610922216686,"d":"81.0761"},{"v":100,"d":"100.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":100,"d":"100.0000"},{"v":93.74970703216552,"d":"93.7497"},{"v":80.92443389742566,"d":"80.9244"},11,447]
[2023210595,"刘佳慧",{"v":95.79331,"d":"95.7933"},{"v":10.1,"d":"10.1000"},{"v":0,"d":"0.0000"},{"v":105.89331,"d":"105.8933"},{"v":78.23133558708977,"d":"78.2313"},83.3931,{"v":1,"d":"1.0000"},{"v":0,"d":"0.0000"},84.3931,{"v":76.86711740226194,"d":"76.8671"},{"v":100,"d":"100.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":100,"d":"100.0000"},{"v":93.74970703216552,"d":"93.7497"},{"v":78.82822000221786,"d":"78.8282"},12,501]
[2023210628,"班艺宁",{"v":96.49331,"d":"96.4933"},{"v":10,"d":"10.0000"},{"v":0,"d":"0.0000"},{"v":106.49331,"d":"106.4933"},{"v":78.67460061820697,"d":"78.6746"},{"v":82.63529,"d":"82.6353"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":82.63529,"d":"82.6353"},{"v":75.26606485601266,"d":"75.2661"},{"v":100,"d":"100.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":100,"d":"100.0000"},{"v":93.74970703216552,"d":"93.7497"},{"v":77.7961362260668,"d":"77.7961"},13,471]
[2023210626,"文梦鑫",{"v":95.09331,"d":"95.0933"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":95.09331,"d":"95.0933"},{"v":70.25256502698008,"d":"70.2526"},{"v":85.285,"d":"85.2850"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":85.285,"d":"85.2850"},{"v":77.67947981116832,"d":"77.6795"},{"v":100,"d":"100.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":100,"d":"100.0000"},{"v":93.74970703216552,"d":"93.7497"},{"v":77.80111957643038,"d":"77.8011"},14,"未通过"]
[2023215370,"张文龙",{"v":95.09331,"d":"95.0933"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":95.09331,"d":"95.0933"},{"v":70.25256502698008,"d":"70.2526"},84.8638,{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},84.8638,{"v":77.29584145862727,"d":"77.2958"},{"v":100,"d":"100.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":100,"d":"100.0000"},{"v":93.74970703216552,"d":"93.7497"},{"v":77.53257272965165,"d":"77.5326"},15,432]
[2023210583,"吴华宇",{"v":95.42,"d":"95.4200"},{"v":3,"d":"3.0000"},{"v":0,"d":"0.0000"},{"v":98.42,"d":"98.4200"},{"v":72.7102406042589,"d":"72.7102"},83.8021,{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},83.8021,{"v":76.32882142326915,"d":"76.3288"},{"v":100,"d":"100.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":100,"d":"100.0000"},{"v":93.74970703216552,"d":"93.7497"},{"v":77.34719382035672,"d":"77.3472"},16,477]
[2023210592,"安翔",{"v":95.37331,"d":"95.3733"},{"v":6,"d":"6.0000"},{"v":0,"d":"0.0000"},{"v":101.37331,"d":"101.3733"},{"v":74.8920723526735,"d":"74.8921"},81.4831,{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},81.4831,{"v":74.21662451077458,"d":"74.2166"},{"v":100,"d":"100.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":100,"d":"100.0000"},{"v":93.74970703216552,"d":"93.7497"},{"v":76.30502233129344,"d":"76.3050"},17,453]