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

{"sheet":"Sheet1","index":0,"n_rows":97,"n_cols":13,"rows_kept":97}
["序号","班级","学号","姓名","德育总成绩","智育成绩","体育成绩","必修课优良率","必修课成绩","选修课成绩","课程成绩","综测成绩","综测排名"]
[80,"化工21-3班",2021010454,"黄凯涵",107.18,123.718604651163,90.52,{"v":1,"d":"100.00%"},90.5232558139535,89,90.2186046511628,117.091023255814,1]
[92,"化工21-3班",2021010520,"刘益安",107.4,112.443902439024,80.02,{"v":1,"d":"100.00%"},89.8048780487805,93,90.4439024390244,108.192731707317,2]
[18,"化工21-2班",2021010416,"刘庆炽",114.424193548387,107.69512195122,84.58,{"v":1,"d":"100.00%"},89.2439024390244,84,{"$f":"I4*0.8+J4*0.2","v":88.1951219512195},106.729424075531,3]
[53,"化工21-1班","2021010473","朱家玉",103.41875,111.155238095238,80.32,{"v":1,"d":"100.00%"},90.1190476190476,92.8,90.6552380952381,106.524416666667,4]
[5,"化工21-2班",2021010397,"林楚媛",126.671505376677,98.519512195122,97.36,{"v":0.55,"d":"55.00%"},76.5243902439024,81.5,{"$f":"I6*0.8+J6*0.2","v":77.519512195122},104.033959611921,5]
[38,"化工21-1班","2021010370","闫晨琛",115.46875,102.761904761905,82.24,{"v":1,"d":"100.00%"},89.9523809523809,91.5,90.2619047619048,{"$f":"E7*0.2+F7*0.7+G7*0.1","v":103.251083333333},6]
[36,"化工21-1班","2021010367","余燕伶",108.41875,102.307619047619,95.52,{"v":1,"d":"100.00%"},90.0595238095238,88.8,89.8076190476191,102.851083333333,7]
[14,"化工21-2班",2021010408,"张梦涵",118.085483870968,96.0105691090244,114.68,{"v":0.9,"d":"90.00%"},85.3048780487805,83,{"$f":"I9*0.8+J9*0.2","v":84.8439024390244},102.292495150511,8]
[79,"化工21-3班",2021010453,"池双佑",108.04,102.628571428571,82.84,{"v":0.857142857142857,"d":"85.71%"},86.0357142857143,84,85.6285714285714,101.732,9]
[86,"化工21-3班",2021010497,"郭飞扬",113.746666666667,97.3772357723577,102.48,{"v":0.75,"d":"75.00%"},82.8048780487805,89,84.0439024390244,101.161398373984,10]
[34,"化工21-1班","2021010365","魏雯静",108.26875,95.4952380952381,82.24,{"v":1,"d":"100.00%"},88.3690476190476,94,89.4952380952381,96.7244166666667,11]
[32,"化工21-2班",2021010518,"康歆宇",105.790322580645,94.9449477351916,81.84,{"v":0.85,"d":"85.00%"},83.109756097561,82.2857142857143,{"$f":"I13*0.8+J13*0.2","v":82.9449477351916},95.8035279307632,12]
[27,"化工21-2班",2021010510,"侯拓阳",106.193548387097,94.4224390243902,84.58,{"v":0.95,"d":"95.00%"},86.8780487804878,79.6,{"$f":"I14*0.8+J14*0.2","v":85.4224390243902},95.7924169944925,13]
[95,"化工21-3班",2021010609,"陈毅闽",107.14,93.941935483871,79.24,{"v":0.875,"d":"87.50%"},85.6774193548387,87,85.941935483871,95.1113548387097,14]
[88,"化工21-3班",2021010500,"齐嘉莹",103.1,93.759437751004,88.38,{"v":0.904761904761905,"d":"90.48%"},85.2409638554217,85.3333333333333,85.259437751004,95.0896064257028,15]
[68,"化工21-3班",2021010436,"李佳蕊",105.626666666667,92.3536585365854,86.94,{"v":0.8,"d":"80.00%"},82.3170731707317,80,81.8536585365854,94.4668943089432,16]
[52,"化工21-1班","2021010472","汪涵伊",113.01875,88.5657142857143,92.86,{"v":0.9,"d":"90.00%"},84.8571428571429,83.4,84.5657142857143,{"$f":"E18*0.2+F18*0.7+G18*0.1","v":93.88575},17]
[84,"化工21-3班",2021010474,"张金泽",99.6,94.1824390243902,77.8,{"v":0.9,"d":"90.00%"},86.8780487804878,93.4,88.1824390243902,93.6277073170732,18]
[51,"化工21-1班","2021010469","李晓娇",111.085416666667,90.1942857142857,81.28,{"v":0.9,"d":"90.00%"},85.8928571428571,87.4,86.1942857142857,93.4810833333333,19]
[45,"化工21-1班","2021010385","界绪森",104.91875,90.6666666666667,81.72,{"v":0.9,"d":"90.00%"},83.3333333333333,90,84.6666666666667,92.6224166666667,20]
[13,"化工21-2班",2021010407,"杨雯婷",106.116129032258,85.4975609756098,109.18,{"v":0.7,"d":"70.00%"},83.1219512195122,80,{"$f":"I22*0.8+J22*0.2","v":82.4975609756098},91.9895184893784,21]
[91,"化工21-3班",2021010519,"李春霖",108.18,87.409756097561,77.56,{"v":0.75,"d":"75.00%"},82.5121951219512,77,81.409756097561,90.5788292682927,22]
[11,"化工21-2班",2021010404,"郭昕苑",103.422580645161,88.380487804878,77.8,{"v":0.9,"d":"90.00%"},84.4756097560976,74,{"$f":"I24*0.8+J24*0.2","v":82.380487804878},90.3308575924469,23]
[50,"化工21-1班","2021010468","王彩雲",103.01875,86.4133333333334,89.02,{"v":0.95,"d":"95.00%"},86.9166666666667,84.4,86.4133333333334,89.9950833333333,24]
[9,"化工21-2班",2021010401,"宋思雨",108.825806451613,86.3609756097561,77.44,{"v":0.65,"d":"65.00%"},77.4512195121951,82,{"$f":"I26*0.8+J26*0.2","v":78.3609756097561},89.9618442171518,25]
[66,"化工21-3班",2021010434,"何丹丹",102.94,87.4585365853659,81.52,{"v":0.7,"d":"70.00%"},82.5731707317073,87,83.4585365853659,89.9609756097561,26]
[31,"化工21-2班",2021010517,"胡海峰",103.790322580645,87.130243902439,81.76,{"v":0.9,"d":"90.00%"},83.9878048780488,77.2,{"$f":"I28*0.8+J28*0.2","v":82.630243902439},89.9252352478363,27]
[65,"化工21-1班","2021010629","张添棋",99.91875,87.4,85.36,{"v":0.954545454545455,"d":"95.45%"},87.25,88,87.4,89.69975,28]
[72,"化工21-3班",2021010441,"张伊蕊",103,87.4073170731707,78.4,{"v":0.65,"d":"65.00%"},82.6341463414634,94,84.9073170731707,89.6251219512195,29]
[35,"化工21-1班","2021010366","廖安安",107.41875,86.0666666666667,76.84,{"v":0.9,"d":"90.00%"},85.3333333333333,89,86.0666666666667,89.4144166666667,30]
[71,"化工21-3班",2021010440,"于瑛琦",110.586666666667,83.8282926829268,83.74,{"v":0.7,"d":"70.00%"},82.5853658536585,88.8,83.8282926829268,89.1711382113821,31]
[25,"化工21-2班",2021010508,"鞠明錡",103.887096774194,86.369756097561,78.1,{"v":0.85,"d":"85.00%"},86.0121951219512,87.8,{"$f":"I33*0.8+J33*0.2","v":86.369756097561},89.0462486231314,32]
[41,"化工21-1班","2021010378","王鹏琪",100.01875,86.1340996168583,82.12,{"v":0.818181818181818,"d":"81.82%"},82.5287356321839,80.5555555555556,82.1340996168583,88.5096197318008,33]
[1,"化工21-2班",2021010196,"项宇",102.106451612903,84.1819121447028,91.6,{"v":0.761904761904762,"d":"76.19%"},81.6162790697674,79.4444444444444,{"$f":"I35*0.8+J35*0.2","v":81.1819121447028},88.5086288238726,34]
[90,"化工21-3班",2021010504,"张春雨",103.12,84.9492682926829,78.16,{"v":0.8,"d":"80.00%"},84.5365853658537,86.6,84.9492682926829,87.904487804878,35]
[67,"化工21-3班",2021010435,"张芳",99.58,84.3634146341464,88.48,{"v":0.7,"d":"70.00%"},82.8292682926829,90.5,84.3634146341464,87.8183902439024,36]
[37,"化工21-1班","2021010369","赵欣茹",105.01875,82.5458823529412,88.12,{"v":0.80952380952381,"d":"80.95%"},81.4823529411765,86.8,82.5458823529412,87.5978676470588,37]
[30,"化工21-2班",2021010516,"韩昌金",108.312903225806,82.9985365853659,76,{"v":0.5,"d":"50.00%"},78.5731707317073,78.2,{"$f":"I39*0.8+J39*0.2","v":78.4985365853659},87.3615562549174,38]
[29,"化工21-2班",2021010512,"麦尔旦·买买提江",105.770967741935,84.9073170731707,67.48,{"v":0.9,"d":"90.00%"},84.1341463414634,88,{"$f":"I40*0.8+J40*0.2","v":84.9073170731707},87.3373154996066,39]
[76,"化工21-3班",2021010449,"宝佳庆",107.04,81.5658536585366,85.42,{"v":0.7,"d":"70.00%"},81.7073170731707,81,81.5658536585366,87.0460975609756,40]
[8,"化工21-2班",2021010400,"马颖",115.086555806452,76.0909090909091,106.96,{"v":0.523809523809524,"d":"52.38%"},75.3636363636364,64,{"$f":"I42*0.8+J42*0.2","v":73.0909090909091},{"$f":"E42*0.2+F42*0.7+G42*0.1","v":86.9769475249267},41]
[40,"化工21-1班","2021010372","马雪",104.11875,81.6238095238095,89.86,{"v":0.85,"d":"85.00%"},81.6547619047619,81.5,81.6238095238095,86.9464166666667,42]
[2,"化工21-2班",2021010373,"高菀珠",102.993548387097,82.1414634146341,85.48,{"v":0.65,"d":"65.00%"},82.4268292682927,81,{"$f":"I44*0.8+J44*0.2","v":82.1414634146341},86.6457340676633,43]
[64,"化工21-1班","2021010611","刘杨",102.41875,83.2347826086957,76.84,{"v":0.772727272727273,"d":"77.27%"},83.0434782608696,84,83.2347826086957,86.432097826087,44]
[69,"化工21-3班",2021010437,"刘思雨",103.08,81.8360975609756,83.32,{"v":0.7,"d":"70.00%"},82.1951219512195,80.4,81.8360975609756,86.2332682926829,45]
[28,"化工21-2班",2021010511,"黄德胜",103.635483870968,82.0839024390244,78.4,{"v":0.75,"d":"75.00%"},83.8048780487805,75.2,{"$f":"I47*0.8+J47*0.2","v":82.0839024390244},86.0258284815106,46]
[70,"化工21-3班",2021010438,"卢宇晶",100.04,82.8380487804878,78.94,{"v":0.75,"d":"75.00%"},81.5975609756098,87.8,82.8380487804878,85.8886341463415,47]
[33,"化工21-1班","2021010363","冶艳",99.51875,82.2990476190476,76.78,{"v":0.85,"d":"85.00%"},81.2738095238095,86.4,82.2990476190476,85.1910833333333,48]
[20,"化工21-2班",2021010418,"杨琨",103.035483870968,81.6682926829268,74.14,{"v":0.65,"d":"65.00%"},79.0853658536585,92,{"$f":"I50*0.8+J50*0.2","v":81.6682926829268},85.1889016522423,49]
[19,"化工21-2班",2021010417,"姬方剑",106.441935483871,80.0760975609756,77.8,{"v":0.75,"d":"75.00%"},78.6951219512195,85.6,{"$f":"I51*0.8+J51*0.2","v":80.0760975609756},85.1216553894571,50]
[93,"化工21-3班",2021010522,"张晓生",99.4,81.5492682926829,79.84,{"v":0.8,"d":"80.00%"},81.0365853658537,83.6,81.5492682926829,84.948487804878,51]
[75,"化工21-3班",2021010448,"李奇",107.22,78.8829268292683,79.6,{"v":0.6,"d":"60.00%"},78.3536585365854,81,78.8829268292683,84.6220487804878,52]
[49,"化工21-1班","2021010394","王浩熙",106.31875,77.76,82.96,{"v":0.55,"d":"55.00%"},78.25,75.8,77.76,83.99175,53]
[82,"化工21-3班",2021010459,"张盛",101.4,79.6731707317073,78.46,{"v":0.55,"d":"55.00%"},77.8414634146341,87,79.6731707317073,83.8972195121951,54]
[77,"化工21-3班",2021010451,"陈乐宁",102.92,80.3141463414634,66.88,{"v":0.7,"d":"70.00%"},78.7926829268293,86.4,80.3141463414634,83.4919024390244,55]
[87,"化工21-3班",2021010499,"董小娜",103.1,78.300487804878,80.56,{"v":0.5,"d":"50.00%"},77.9756097560976,79.6,78.300487804878,83.4863414634146,56]
[4,"化工21-2班",2021010396,"范静琳",103.461290322581,77.96,80.68,{"v":0.6,"d":"60.00%"},78.5,75.8,{"$f":"I58*0.8+J58*0.2","v":77.96},83.3322580645161,57]
[89,"化工21-3班",2021010503,"杨依璇",101.44,78.2331707317073,80.32,{"v":0.6,"d":"60.00%"},77.3414634146341,81.8,78.2331707317073,83.0832195121951,58]
[43,"化工21-1班","2021010383","何亚飞",100.852083333333,76.8457142857143,87.58,{"v":0.476190476190476,"d":"47.62%"},75.7,81.4285714285714,76.8457142857143,{"$f":"E60*0.2+F60*0.7+G60*0.1","v":82.7204166666667},59]
[94,"化工21-3班",2021010523,"张野",102.8,78.8970731707317,68.92,{"v":0.4,"d":"40.00%"},75.1463414634146,71.4,74.3970731707317,82.6799512195122,60]
[62,"化工21-1班","2021010491","詹宇航",99.01875,78.2952380952381,76,{"v":0.578947368421053,"d":"57.89%"},76.6190476190476,85,78.2952380952381,82.2104166666666,61]
[46,"化工21-1班","2021010388","李奕飞",101.885416666667,77.9390476190476,72.64,{"v":0.65,"d":"65.00%"},78.5238095238095,75.6,77.9390476190476,{"$f":"E63*0.2+F63*0.7+G63*0.1","v":82.1984166666667},62]
[12,"化工21-2班",2021010405,"霍子云",103.383870967742,75.9688888888889,83.02,{"v":0.521739130434783,"d":"52.17%"},75.7111111111111,77,{"$f":"I64*0.8+J64*0.2","v":75.9688888888889},82.1569964157706,63]
[39,"化工21-1班","2021010371","买然木古力·艾合买提",103.91875,75.847619047619,81.94,{"v":0.4,"d":"40.00%"},75.5595238095238,77,75.847619047619,82.0710833333333,64]
[17,"化工21-2班",2021010415,"王贤东",103.325806451613,76.4673170731707,77.98,{"v":0.5,"d":"50.00%"},75.6341463414634,79.8,{"$f":"I66*0.8+J66*0.2","v":76.4673170731707},81.9902832415421,65]
[48,"化工21-1班","2021010391","钱俊宇",101.01875,76.4933333333333,82.36,{"v":0.45,"d":"45.00%"},75.1666666666667,81.8,76.4933333333333,81.9850833333333,66]
[23,"化工21-2班",2021010430,"应郁香",103.5,75.0663414634146,82.36,{"v":0.5,"d":"50.00%"},76.1829268292683,70.6,{"$f":"I68*0.8+J68*0.2","v":75.0663414634146},81.4824390243902,67]
[26,"化工21-2班",2021010509,"谢富亮",103.732258064516,75.2330623306233,78.52,{"v":0.4,"d":"40.00%"},74.9024390243902,76.5555555555556,{"$f":"I69*0.8+J69*0.2","v":75.2330623306233},81.2615952443395,68]
[16,"化工21-2班",2021010414,"朱思学",101.093548387097,75.7623693379791,76,{"v":0.4,"d":"40.00%"},75.0243902439024,78.7142857142857,{"$f":"I70*0.8+J70*0.2","v":75.7623693379791},80.8523682140047,69]
[3,"化工21-2班",2021010375,"李润桐",100.438709677419,74.9818181818182,81.22,{"v":0.476190476190476,"d":"47.62%"},73.4772727272727,81,{"$f":"I71*0.8+J71*0.2","v":74.9818181818182},80.6970146627566,70]
[63,"化工21-1班","2021010505","杨志刚",99.51875,74.9828571428571,75.64,{"v":0.473684210526316,"d":"47.37%"},75.9285714285714,71.2,74.9828571428571,79.95575,71]
[54,"化工21-1班","2021010480","魏博轩",99.01875,73.6838095238095,81.52,{"v":0.4,"d":"40.00%"},72.9047619047619,76.8,73.6838095238095,79.5344166666667,72]
[24,"化工21-2班",2021010507,"高鑫",101.422580645161,73.1560975609756,76,{"v":0.15,"d":"15.00%"},70.6951219512195,83,{"$f":"I74*0.8+J74*0.2","v":73.1560975609756},79.0937844217152,73]
[60,"化工21-1班","2021010489","闫珅",101.01875,71.6,76,{"v":0.35,"d":"35.00%"},70.5,76,71.6,77.92375,74]
[10,"化工21-2班",2021010402,"迪力努尔·哈尼亚孜",103.538709677419,70.0072289156627,79.24,{"v":0.238095238095238,"d":"23.81%"},68.7590361445783,75,{"$f":"I76*0.8+J76*0.2","v":70.0072289156627},77.6368021764477,75]
[47,"化工21-1班","2021010390","彭孝杨",99.01875,74.6457142857143,54.64,{"v":0.55,"d":"55.00%"},73.8571428571429,77.8,74.6457142857143,77.51975,76]
[83,"化工21-3班",2021010460,"庄宏锐",98.42,71.9047619047619,69.88,{"v":0.380952380952381,"d":"38.10%"},72.8809523809524,68,71.9047619047619,77.0053333333333,77]
[6,"化工21-2班",2021010398,"王雅靖",107.783870967742,67.5756097560976,80.86,{"v":0.3,"d":"30.00%"},65.719512195122,75,{"$f":"I79*0.8+J79*0.2","v":67.5756097560976},76.9457010228167,78]
[58,"化工21-1班","2021010485","刘羲阳",104.852083333333,68.2609523809524,81.16,{"v":0.263157894736842,"d":"26.32%"},69.4761904761905,63.4,68.2609523809524,76.8690833333333,79]
[15,"化工21-2班",2021010410,"李梓轩",105.364516129032,68.7609756097561,76,{"v":0.15,"d":"15.00%"},68.9512195121951,68,{"$f":"I81*0.8+J81*0.2","v":68.7609756097561},76.8055861526357,80]
[42,"化工21-1班","2021010379","吴阳",99.51875,68.4857142857143,85.12,{"v":0.263157894736842,"d":"26.32%"},68.6785714285714,67.7142857142857,68.4857142857143,76.35575,81]
[7,"化工21-2班",2021010399,"李文喧",107.364516129032,67.0711111111111,79,{"v":0.227272727272727,"d":"22.73%"},65.9888888888889,71.4,{"$f":"I83*0.8+J83*0.2","v":67.0711111111111},76.3226810035843,82]
[74,"化工21-3班",2021010447,"冷明洋",98.84,69.3365853658537,79.66,{"v":0.25,"d":"25.00%"},70.1707317073171,66,69.3365853658537,76.2696097560976,83]
[81,"化工21-3班",2021010456,"刘洋阳",100.2,68.2031683168317,76.42,{"v":0.304347826086957,"d":"30.43%"},67.6039603960396,70.6,68.2031683168317,75.4242178217822,84]
[73,"化工21-3班",2021010446,"周江楠",101.92,66.6654545454546,82.12,{"v":0.19047619047619,"d":"19.05%"},66.1818181818182,68.6,66.6654545454546,75.2618181818182,85]
[78,"化工21-3班",2021010452,"陈杰",98.82,69.0527272727273,71.5,{"v":0.19047619047619,"d":"19.05%"},67.7159090909091,74.4,69.0527272727273,75.2509090909091,86]
[22,"化工21-2班",2021010422,"孙钰翔",104.583870967742,66.8926829268293,74.62,{"v":0.1,"d":"10.00%"},66.3658536585366,69,{"$f":"I88*0.8+J88*0.2","v":66.8926829268293},75.2036522423289,87]
[57,"化工21-1班","2021010484","李梓枫",99.51875,68.1302857142857,72.1,{"v":0.2,"d":"20.00%"},66.52,74.5714285714286,68.1302857142857,74.80495,88]
[61,"化工21-1班","2021010490","游洋",99.01875,66.5674418604651,76.06,{"v":0.176470588235294,"d":"17.65%"},68.2093023255814,60,66.5674418604651,74.0069593023256,89]
[21,"化工21-2班",2021010421,"倪嘉义",102.467741935484,68.2459627329193,54.4,{"v":0.285714285714286,"d":"28.57%"},67.0217391304348,73.1428571428571,{"$f":"I91*0.8+J91*0.2","v":68.2459627329193},73.7057223001403,90]
[44,"化工21-1班","2021010384","贾坤",99.01875,66,74.56,{"v":0.166666666666667,"d":"16.67%"},66.5,64,66,73.45975,91]
[59,"化工21-1班","2021010488","向卫",98.61875,65.8667736757624,73.96,{"v":0.3,"d":"30.00%"},67.7977528089888,58.1428571428571,65.8667736757624,73.2264915730337,92]
[56,"化工21-1班","2021010483","丁致远",99.01875,65.4666666666667,73.18,{"v":0.166666666666667,"d":"16.67%"},64.5476190476191,69.1428571428571,65.4666666666667,72.9484166666667,93]
[55,"化工21-1班","2021010481","李翱翔",98.71875,64.7114563106796,75.46,{"v":0.166666666666667,"d":"16.67%"},62.6893203883495,72.8,64.7114563106796,72.5877694174757,94]
[85,"化工21-3班",2021010495,"唐安雅",99.62,63.4842105263158,68.92,{"v":0.0909090909090909,"d":"9.09%"},63.1052631578947,65,63.4842105263158,71.2549473684211,95]
[96,"化工21-3班",2021010635,"潘瑞彬",103.02,52.8633663366337,84.28,{"v":0.208333333333333,"d":"20.83%"},66.0792079207921,0,52.8633663366337,66.0363564356436,96]