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

{"sheet":"Sheet1","index":0,"n_rows":10,"n_cols":18,"rows_kept":10,"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,"基础分","奖励分","惩罚分","总分","基准后总分","学习成绩分","奖励分","惩罚分","总分","基准后总分","基本分","奖励分","惩罚分","总 分","基准后总分"]
[2021211501,93.4782608695652,5.1,0,{"$f":"B4+C4","v":98.5782608695652},{"$f":"E4/MAX($E$4:$E$10)*100","v":86.7036328871893},92.291666667,0,0,92.291666667,{"$f":"J4/MAX($J$4:$J$10)*100","v":92.9765942449141},100,0,0,{"$f":"L4+M4","v":100},{"$f":"O4/MAX($O$4:$O$10)*100","v":84.3170320404722},{"$f":"F4*0.2+K4*0.7+P4*0.1","v":90.856045752925},{"$f":"RANK(Q4,$Q$4:$Q$10,0)","v":7}]
[2021211502,91.304347826087,13.6,0,{"$f":"B5+C5","v":104.904347826087},{"$f":"E5/MAX($E$4:$E$10)*100","v":92.2676864244742},89.506363636,0,0,89.506363636,{"$f":"J5/MAX($J$4:$J$10)*100","v":90.1706205409523},100,16.3333333333333,0,{"$f":"L5+M5","v":116.333333333333},{"$f":"O5/MAX($O$4:$O$10)*100","v":98.088813940416},{"$f":"F5*0.2+K5*0.7+P5*0.1","v":91.3818530576031},{"$f":"RANK(Q5,$Q$4:$Q$10,0)","v":6}]
[2021211503,88.695652173913,25,0,113.695652173913,100,93.263333333,6,0,99.263333333,100,100,18.6,0,118.6,100,100,1]
[2021211504,94.3478260869565,13.6,0,107.947826086957,94.944550669216,93.15166667,3,0,96.15166667,96.8652406094794,100,16.3333333333333,0,116.333333333333,98.088813940416,96.6034599545204,2]
[2021211505,91.7391304347826,11.8,0,103.539130434783,91.0669216061185,92.58666667,0,0,92.58666667,93.2737835424066,100,17.2666666666667,0,117.266666666667,98.875772906127,93.392610091521,3]
[2021211506,93.0434782608696,10.5,0,103.54347826087,91.0707456978968,91.61111111,0,0,91.61111111,92.2909880556509,100,8.66666666666667,0,108.666666666667,91.6245081506464,91.9802915935996,5]
[2021211507,90.8695652173913,13.9,0,104.769565217391,92.1491395793499,89.8,3,0,92.8,93.4887000909819,100,12,0,112,94.4350758853288,93.3154255680902,4]