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

{"sheet":"Sheet1","index":0,"n_rows":11,"n_cols":17,"rows_kept":11,"merged":[[0,0,0,16],[1,0,2,0],[1,1,1,5],[1,6,1,10],[1,11,1,14],[1,15,2,15],[1,16,2,16]]}
["中国石油大学（北京）马克思主义学院马克思主义理论专业2020级博士研究生综合测评汇总表"]
["学号","德育成绩",{"$nulls":4},"智育成绩",{"$nulls":4},"文体成绩",{"$nulls":3},"总分","排名"]
[null,"基础分","奖励分","惩罚分","总 分","基准后总分","学习成绩分","奖励分","惩罚分","总分","基准后总分","基本分","奖励分","惩罚分","总 分"]
[2020311001,100,9,0,{"$f":"B4+C4","v":109},{"$f":"E4/MAX($E$4:$E$11)*100","v":94.7826086956522},100,11.8,0,{"$f":"G4+H4","v":111.8},{"$f":"J4/MAX($J$4:$J$11)*100","v":91.9407894736842},100,0,0,100,{"$f":"F4*0.2+K4*0.7+O4*0.1","v":93.3150743707094},{"$f":"RANK(P4,$P$4:$P$11,0)","v":3}]
[2020311002,100,15,0,{"$f":"B5+C5","v":115},{"$f":"E5/MAX($E$4:$E$11)*100","v":100},100,11,0,{"$f":"G5+H5","v":111},{"$f":"J5/MAX($J$4:$J$11)*100","v":91.2828947368421},100,0,0,100,{"$f":"F5*0.2+K5*0.7+O5*0.1","v":93.8980263157895},{"$f":"RANK(P5,$P$4:$P$11,0)","v":2}]
[2020311003,100,8,0,108,93.9130434782609,100,0,0,100,82.2368421052632,100,0,0,100,86.3483981693364,7]
[2020311004,100,8,0,108,93.9130434782609,100,0,0,100,82.2368421052632,100,0,0,100,86.3483981693364,7]
[2020311005,100,11,0,111,96.5217391304348,100,21.6,0,121.6,100,100,0,0,100,99.304347826087,1]
[2020311006,100,11,0,111,96.5217391304348,100,0,0,100,82.2368421052632,100,0,0,100,86.8701372997712,6]
[2020311007,100,14,0,114,99.1304347826087,100,3,0,103,84.7039473684211,100,0,0,100,89.1188501144165,4]
[2020311008,100,8,0,108,93.9130434782609,100,4.8,0,104.8,86.1842105263158,100,0,0,100,89.1115560640732,5]