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

{"sheet":"Sheet1","index":0,"n_rows":19,"n_cols":18,"rows_kept":19,"merged":[[0,0,0,17],[1,0,2,0],[1,1,1,5],[1,6,1,10],[1,11,1,15],[1,16,2,16],[1,17,2,17]]}
["中国石油大学（北京）马克思主义学院马克思主义理论专业2021级硕士研究生综合测评汇总表"]
["学号","德育成绩",{"$nulls":4},"智育成绩",{"$nulls":4},"文体成绩",{"$nulls":4},"总分","排名"]
[null,"基础分","奖励分","惩罚分","总 分","基准后总分","学习成绩分","奖励分","惩罚分","总分","基准后总分","基本分","奖励分","惩罚分","总分","基准后总分"]
[2021211508,94.3478260869565,8.5,0,{"$f":"B4+C4","v":102.847826086957},{"$f":"E4/MAX($E$4:$E$19)*100","v":78.7817225071605},93.111578947,1,0,{"$f":"G4+H4","v":94.111578947},{"$f":"J4/MAX($J$4:$J$19)*100","v":94.0296741520318},100,12,0,{"$f":"L4+M4","v":112},{"$f":"O4/MAX($O4:$O$19)*100","v":95.2380952380952},{"$f":"F4*0.2+K4*0.7+P4*0.1","v":91.1009259316639},{"$f":"RANK(Q4,$Q$4:$Q$19,0)","v":12}]
[2021211509,91.304347826087,19.5,0,{"$f":"B5+C5","v":110.804347826087},{"$f":"E5/MAX($E$4:$E$19)*100","v":84.8764404183041},93.587105263,6.5,0,{"$f":"G5+H5","v":100.087105263},{"$f":"J5/MAX($J$4:$J$19)*100","v":100},100,12.9333333333333,0,{"$f":"L5+M5","v":112.933333333333},{"$f":"O5/MAX($O4:$O$19)*100","v":96.031746031746},{"$f":"F5*0.2+K5*0.7+P5*0.1","v":96.5784626868354},{"$f":"RANK(Q5,$Q$4:$Q$19,0)","v":3}]
[2021211510,90,0,0,90,68.9402517817891,90.958315789,0,0,90.958315789,{"$f":"J6/MAX($J$4:$J$19)*100","v":90.879155261797},100,0,0,100,{"$f":"O6/MAX($O4:$O$19)*100","v":85.0340136054422},85.90686040016,16]
[2021211512,93.0434782608696,24.1,0,117.14347826087,89.7322320655432,92.563157895,4.2,0,96.763157895,96.6789454453043,100,16.3333333333333,0,116.333333333333,{"$f":"O7/MAX($O4:$O$19)*100","v":98.9229024943311},95.5139984742547,5]
[2021211513,94.7826086956522,9,0,103.782608695652,79.4977686005462,92.552631579,0,0,92.552631579,92.4720835274419,100,9.6,0,109.6,{"$f":"O8/MAX($O4:$O$19)*100","v":93.1972789115646},89.949740080475,15]
[2021211514,92.1739130434783,23.9,0,116.073913043478,88.9129421168321,94.667763158,3,0,97.667763158,97.582763435267,100,17.3333333333333,0,117.333333333333,{"$f":"O9/MAX($O4:$O$19)*100","v":99.7732426303855},96.0678470910919,4]
[2021211515,92.1739130434783,12.4,0,104.573913043478,80.1039099447146,90.541052632,3,0,93.541052632,93.4596443629788,100,16.9333333333333,0,116.933333333333,{"$f":"O10/MAX($O4:$O$19)*100","v":99.4331065759637},91.3858437006244,11]
[2021211516,92.1739130434783,19.1,0,111.273913043478,85.23612868847,91.813157895,3,0,94.813157895,94.7306425196916,100,12.1,0,112.1,{"$f":"O11/MAX($O4:$O$19)*100","v":95.3231292517007},92.8909884266482,9]
[2021211517,91.7391304347826,14.8,0,106.539130434783,81.6092719642976,91.194736842,2,0,93.194736842,93.113629969726,100,9.66666666666667,0,109.666666666667,{"$f":"O12/MAX($O4:$O$19)*100","v":93.2539682539683},{"$f":"F12*0.2+K12*0.7+P12*0.1","v":90.8267921970645},13]
[2021211518,92.6086956521739,31.7,0,124.308695652174,95.2208086325185,92.957894737,1,0,93.957894737,93.8761236925634,100,12.9333333333333,0,112.933333333333,{"$f":"O13/MAX($O4:$O$19)*100","v":96.031746031746},94.3606229144727,7]
[2021211519,94.3478260869565,17.1,0,111.447826086957,85.3693465663092,93.478947368,2.5,0,95.978947368,95.8954174124579,100,17.1,0,117.1,{"$f":"O14/MAX($O4:$O$19)*100","v":99.5748299319728},94.1581444951797,8]
[2021211520,92.1739130434783,13.1,0,105.273913043478,80.6401119030174,91.815789474,1,0,92.815789474,92.735012397558,100,12.9333333333333,0,112.933333333333,{"$f":"O15/MAX($O4:$O$19)*100","v":96.031746031746},90.6457056620687,14]
[2021211521,94.3478260869565,24.2,0,118.547826086957,90.8079664290948,93.821052632,6,0,99.821052632,99.7341789131568,100,17.2666666666667,0,117.266666666667,{"$f":"O16/MAX($O4:$O$19)*100","v":99.7165532879819},97.9471738538269,1]
[2021211522,94.3478260869565,36.2,0,130.547826086957,100,93.547368421,2,0,95.547368421,95.4642140662667,100,17.2666666666667,0,117.266666666667,{"$f":"O17/MAX($O4:$O$19)*100","v":99.7165532879819},96.7966051751849,2]
[2021211523,94.3478260869565,20.6,0,114.947826086957,88.0503563578232,93.251052632,3,0,96.251052632,96.1672858647276,100,17.6,0,117.6,{"$f":"O18/MAX($O4:$O$19)*100","v":100},94.9271713768739,6]
[2021211524,94.3478260869565,18.1,0,112.447826086957,86.1353493638846,92.306578947,0,0,92.306578947,92.2262450337084,100,17.2666666666667,0,117.266666666667,{"$f":"O19/MAX($O4:$O$19)*100","v":99.7165532879819},91.757096725171,10]