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

{"sheet":"Sheet1","index":0,"n_rows":27,"n_cols":19,"rows_kept":27,"merged":[[0,0,0,18],[1,0,2,0],[1,1,1,5],[1,6,1,10],[1,11,1,15],[1,16,2,16],[1,17,2,17],[1,18,2,18]]}
["中国石油大学（北京）外国语学院23级汉语国际教育专业研究生综合测评汇总表"]
["学号","智育成绩",{"$nulls":4},"德育成绩",{"$nulls":4},"文体成绩",{"$nulls":4},"综测总分","排名","签字"]
[null,"学习成绩分数","奖励分","惩罚分","智育总分","智育成绩","基础分","奖励分","惩罚分","德育总分","德育成绩","基础分","奖励分","惩罚分","文体总分","文体成绩"]
[2023216404,92.66,21.15,0,113.81,{"$f":"E4/113.81*100*0.7","v":{"v":70,"d":"70.00"}},100,{"$f":"J4-G4","v":21},0,121,{"$f":"J4/121*100*0.2","v":{"v":20,"d":"20.00"}},100,{"$f":"O4-L4","v":16.6},0,116.6,{"$f":"O4/116.6*100*0.1","v":{"v":10,"d":"10.00"}},{"$f":"P4+K4+F4","v":{"v":100,"d":"100.00"}},1,"同学本人已签字"]
[2023216403,94.77,15,0,{"$f":"SUM(B5,C5)","v":109.77},{"$f":"E5/113.81*100*0.7","v":{"v":67.5151568403479,"d":"67.52"}},100,{"$f":"J5-G5","v":21},0,121,{"$f":"J5/121*100*0.2","v":{"v":20,"d":"20.00"}},100,{"$f":"O5-L5","v":11.2},0,111.2,{"$f":"O5/116.6*100*0.1","v":{"v":9.5368782161235,"d":"9.54"}},{"$f":"P5+K5+F5","v":{"v":97.0520350564714,"d":"97.05"}},2,"同学本人已签字"]
[2023216418,94.57,5,0,99.57,{"v":61.2415429224145,"d":"61.24"},100,12,0,112,{"v":18.5123966942149,"d":"18.51"},100,8.40000000000001,0,108.4,{"v":9.2967409948542,"d":"9.30"},{"$f":"P6+K6+F6","v":{"v":89.0506806114836,"d":"89.05"}},3,"同学本人已签字"]
[2023216413,92.05,3.25,0,95.3,{"v":58.615235919515,"d":"58.62"},100,18,0,118,{"v":19.504132231405,"d":"19.50"},100,0,0,100,{"v":8.57632933104631,"d":"8.58"},{"v":86.6956974819662,"d":"86.70"},4,"同学本人已签字"]
[2023216414,93.04,0.57,0,{"$f":"SUM(B8,C8)","v":93.61},{"v":57.5757842017397,"d":"57.58"},100,16,0,116,{"v":19.1735537190083,"d":"19.17"},100,7,0,107,{"v":9.17667238421956,"d":"9.18"},{"v":85.9260103049675,"d":"85.93"},5,"同学本人已签字"]
[2023216407,93.53,0,0,{"$f":"SUM(B9,C9)","v":93.53},{"v":57.5265793866971,"d":"57.53"},100,7,0,107,{"v":17.6859504132231,"d":"17.69"},100,2.40000000000001,0,102.4,{"v":8.78216123499143,"d":"8.78"},{"v":83.9946910349117,"d":"83.99"},6,"同学本人已签字"]
[2023216412,91.54,0,0,91.54,{"v":56.3026096125121,"d":"56.30"},100,8.59999999999999,0,108.6,{"v":17.9504132231405,"d":"17.95"},100,12,0,112,{"v":9.60548885077187,"d":"9.61"},{"v":83.8585116864244,"d":"83.86"},7,"同学本人已签字"]
[2023216406,{"v":91.3,"d":"91.30"},0,0,{"v":91.3,"d":"91.30"},{"v":56.1549951673842,"d":"56.15"},100,12.3,0,112.3,{"v":18.5619834710744,"d":"18.56"},100,5.40000000000001,0,105.4,{"v":9.03945111492281,"d":"9.04"},{"v":83.7564297533814,"d":"83.76"},8,"同学本人已签字"]
[2023216415,91.29,0,0,91.29,{"v":56.1488445655039,"d":"56.15"},100,9.8,0,109.8,{"v":18.1487603305785,"d":"18.15"},100,6.40000000000001,0,106.4,{"v":9.12521440823328,"d":"9.13"},{"v":83.4228193043157,"d":"83.42"},9,"同学本人已签字"]
[2023216422,{"v":93.1,"d":"93.10"},0,0,{"v":93.1,"d":"93.10"},{"v":57.2621035058431,"d":"57.26"},100,2,0,102,{"v":16.8595041322314,"d":"16.86"},100,8,0,108,{"v":9.26243567753002,"d":"9.26"},{"v":83.3840433156045,"d":"83.38"},10,"同学本人已签字"]
[2023216408,92.89,0,0,92.89,{"v":57.1329408663562,"d":"57.13"},100,4,0,104,{"v":17.1900826446281,"d":"17.19"},100,0,0,100,{"v":8.57632933104631,"d":"8.58"},{"v":82.8993528420306,"d":"82.90"},11,"同学本人已签字"]
[2023216416,92.65,0,0,92.65,{"v":56.9853264212284,"d":"56.99"},100,3,0,103,{"v":17.0247933884298,"d":"17.02"},100,2,0,102,{"v":8.74785591766724,"d":"8.75"},{"v":82.7579757273254,"d":"82.76"},12,"同学本人已签字"]
[2023216410,91.98,0,0,91.98,{"v":56.5732360952465,"d":"56.57"},100,4.59999999999999,0,104.6,{"v":17.2892561983471,"d":"17.29"},100,0,0,100,{"v":8.57632933104631,"d":"8.58"},{"v":82.4388216246399,"d":"82.44"},13,"同学本人已签字"]
[2023216411,90.39,0,0,90.39,{"v":55.5952903962745,"d":"55.60"},100,6,0,106,{"v":17.5206611570248,"d":"17.52"},100,7.40000000000001,0,107.4,{"v":9.21097770154374,"d":"9.21"},{"v":82.326929254843,"d":"82.33"},14,"同学本人已签字"]
[2023216417,88.93,0,0,88.93,{"v":54.6973025217468,"d":"54.70"},100,8.8,0,108.8,{"v":17.9834710743802,"d":"17.98"},100,11,0,111,{"v":9.51972555746141,"d":"9.52"},{"v":82.2004991535883,"d":"82.20"},15,"同学本人已签字"]
[2023216401,91.81,0,0,91.81,{"v":56.4686758632809,"d":"56.47"},100,1,0,101,{"v":16.6942148760331,"d":"16.69"},100,4,0,104,{"v":8.91938250428816,"d":"8.92"},{"v":82.0822732436021,"d":"82.08"},16,"同学本人已签字"]
[2023216421,89.61,0,0,89.61,{"$f":"E20/113.81*100*0.7","v":{"v":55.115543449609,"d":"55.12"}},100,{"$f":"J20-G20","v":8.8},0,108.8,{"$f":"J20/121*100*0.2","v":{"v":17.9834710743802,"d":"17.98"}},100,{"$f":"O20-L20","v":4},0,104,{"$f":"O20/116.6*100*0.1","v":{"v":8.91938250428816,"d":"8.92"}},{"$f":"P20+K20+F20","v":{"v":82.0183970282773,"d":"82.02"}},17,"同学本人已签字"]
[2023216409,90.79,0,0,90.79,{"$f":"E21/113.81*100*0.7","v":{"v":55.8413144714876,"d":"55.84"}},100,{"$f":"J21-G21","v":4},0,104,{"$f":"J21/121*100*0.2","v":{"v":17.1900826446281,"d":"17.19"}},100,{"$f":"O21-L21","v":4},0,104,{"$f":"O21/116.6*100*0.1","v":{"v":8.91938250428816,"d":"8.92"}},{"$f":"P21+K21+F21","v":{"v":81.9507796204038,"d":"81.95"}},18,"同学本人已签字"]
[2023216425,{"v":91.37182,"d":"91.37"},0,0,91.37,{"v":56.1980493805465,"d":"56.20"},100,2,0,102,{"v":16.8595041322314,"d":"16.86"},100,0,0,100,{"v":8.57632933104631,"d":"8.58"},{"v":81.6338828438242,"d":"81.63"},19,"同学本人已签字"]
[2023216419,90.24,0,0,90.24,{"v":55.5030313680696,"d":"55.50"},100,5,0,105,{"v":17.3553719008264,"d":"17.36"},100,0,0,100,{"v":8.57632933104631,"d":"8.58"},{"v":81.4347325999423,"d":"81.43"},20,"同学本人已签字"]
[2023216405,90.73,0,0,90.73,{"v":55.8044108602056,"d":"55.80"},100,3,0,103,{"v":17.0247933884298,"d":"17.02"},100,0,0,100,{"v":8.57632933104631,"d":"8.58"},{"v":81.4055335796817,"d":"81.41"},21,"同学本人已签字"]
[2023216424,91.17,0,0,91.17,{"v":56.07503734294,"d":"56.08"},100,0,0,100,{"v":16.5289256198347,"d":"16.53"},100,0,0,100,{"v":8.57632933104631,"d":"8.58"},{"v":81.180292293821,"d":"81.18"},22,"同学本人已签字"]
[2023216420,89.48,0,0,89.48,{"v":55.0355856251647,"d":"55.04"},100,3,0,103,{"v":17.0247933884298,"d":"17.02"},100,0,0,100,{"v":8.57632933104631,"d":"8.58"},{"v":80.6367083446408,"d":"80.64"},23,"同学本人已签字"]
[2023216402,87.88,0,0,87.88,{"v":54.0514893243124,"d":"54.05"},100,0,0,100,{"v":16.5289256198347,"d":"16.53"},100,0,0,100,{"v":8.57632933104631,"d":"8.58"},{"v":79.1567442751935,"d":"79.16"},24,"同学本人已签字"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}