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

{"sheet":"Sheet1","index":0,"n_rows":41,"n_cols":13,"rows_kept":41,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4],[0,5,1,5],[0,6,1,6],[0,7,1,7],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12]]}
["学号","绩点","总加分","总绩点\n（原始为4位）","权重1（取5位）","笔试成绩","面试成绩","考试平均成绩","折合绩点取8位","权重2取9位","总成绩取9位","合成百分制总成绩","总成绩排名"]
[]
["2000015143","3.828",{"v":0.041999999999999996,"d":"0.0420"},{"$f":"B3+C3","v":{"v":3.8699999999999997,"d":"3.8700"}},{"$f":"D3*90%","v":3.4829999999999997},83.5,86.2,{"$f":"AVERAGE(F3:G3)","v":84.85},{"$f":"4-3*(100-H3)*(100-H3)/1600","v":{"v":3.5696453124999996,"d":"3.56964531"}},{"$f":"I3*10%","v":{"v":0.35696453125,"d":"0.356964531"}},{"$f":"E3+J3","v":{"v":3.8399645312499997,"d":"3.839964531"}},{"$f":"100-SQRT((4-K3)*1600/3)","v":{"v":90.76137185508583,"d":"90.76"}},1]
["2000017475","3.810",0.0213,3.8313,3.44817,93.5,88.8,91.15,{"v":3.8531453125,"d":"3.85314531"},{"v":0.38531453125000004,"d":"0.385314531"},{"v":3.8334845312500003,"d":"3.833484531"},{"v":90.57618707740865,"d":"90.58"},2]
["1900015139","3.820",0.0523,{"v":3.8722999999999996,"d":"3.8723"},3.48507,71.5,77.4,74.45,{"v":2.7759953125,"d":"2.77599531"},{"v":0.27759953125000003,"d":"0.277599531"},{"v":3.76266953125,"d":"3.762669531"},{"v":88.74938890548606,"d":"88.75"},3]
["2000015153","3.723",{"v":0.024,"d":"0.0240"},{"v":3.747,"d":"3.7470"},3.3723,87,87.6,87.3,3.69758125,0.369758125,{"v":3.7420581250000002,"d":"3.742058125"},{"v":88.27101879957172,"d":"88.27"},4]
["2000015192","3.700",{"v":0.036,"d":"0.0360"},{"v":3.736,"d":"3.7360"},3.3624,90,85.2,87.6,{"v":3.7116999999999996,"d":"3.71170000"},{"v":0.37117,"d":"0.371170000"},{"v":3.7335700000000003,"d":"3.733570000"},{"v":88.07959732223782,"d":"88.08"},5]
["2000015172","3.733",{"v":0.03,"d":"0.0300"},{"v":3.763,"d":"3.7630"},3.3867,72,90,81,{"v":3.323125,"d":"3.32312500"},{"v":0.3323125,"d":"0.332312500"},{"v":3.7190125,"d":"3.719012500"},{"v":87.7582680963844,"d":"87.76"},6]
["2000015168","3.719",{"v":0.041999999999999996,"d":"0.0420"},{"v":3.7609999999999997,"d":"3.7610"},3.3848999999999996,74,88.4,81.2,{"v":3.3373,"d":"3.33730000"},{"v":0.33373,"d":"0.333730000"},{"v":3.7186299999999997,"d":"3.718630000"},{"v":87.7499387756632,"d":"87.75"},7]
["2000015109","3.717",{"v":0.053000000000000005,"d":"0.0530"},{"v":3.77,"d":"3.7700"},3.3930000000000002,68.5,89.4,78.95,{"v":3.1691828125000003,"d":"3.16918281"},{"v":0.31691828125000004,"d":"0.316918281"},{"v":3.7099182812500002,"d":"3.709918281"},{"v":87.56174248538004,"d":"87.56"},8]
["2000015173","3.732",{"v":0.018000000000000002,"d":"0.0180"},{"v":3.75,"d":"3.7500"},3.375,72.5,88.8,80.65,{"v":3.2979578125000004,"d":"3.29795781"},{"v":0.3297957812500001,"d":"0.329795781"},{"v":3.70479578125,"d":"3.704795781"},{"v":87.45240062800856,"d":"87.45"},9]
["2000015155","3.734",{"v":0.006,"d":"0.0060"},{"v":3.7399999999999998,"d":"3.7400"},3.3659999999999997,76,87,81.5,3.35828125,{"v":0.33582812500000003,"d":"0.335828125"},{"v":3.7018281249999996,"d":"3.701828125"},{"v":87.38948851156306,"d":"87.39"},10]
["2000015141","3.729",{"v":0.016,"d":"0.0160"},{"v":3.745,"d":"3.7450"},3.3705000000000003,79,82,80.5,3.28703125,{"v":0.32870312500000004,"d":"0.328703125"},{"v":3.6992031250000004,"d":"3.699203125"},{"v":87.33410090044927,"d":"87.33"},11]
["2000015152","3.704",{"v":0.012,"d":"0.0120"},{"v":3.716,"d":"3.7160"},3.3444000000000003,80.5,86.6,83.55,{"v":3.4926203124999997,"d":"3.49262031"},{"v":0.34926203125,"d":"0.349262031"},{"v":3.69366203125,"d":"3.693662031"},{"v":87.21797160072002,"d":"87.22"},12]
["2000015159","3.696",{"v":0.014,"d":"0.0140"},{"v":3.71,"d":"3.7100"},3.339,77,84.8,80.9,{"v":3.3159812500000005,"d":"3.31598125"},{"v":0.3315981250000001,"d":"0.331598125"},3.670598125,{"v":86.74552905620145,"d":"86.75"},13]
["2000015114","3.711",{"v":0.013000000000000001,"d":"0.0130"},{"v":3.7239999999999998,"d":"3.7240"},3.3516,66,88.8,77.4,{"v":3.0423250000000004,"d":"3.04232500"},{"v":0.3042325000000001,"d":"0.304232500"},{"v":3.6558325,"d":"3.655832500"},{"v":86.4517159758145,"d":"86.45"},14]
["2000015131","3.665",{"v":0.037,"d":"0.0370"},{"v":3.702,"d":"3.7020"},3.3318,66.5,90.2,78.35,{"v":3.1211453124999995,"d":"3.12114531"},{"v":0.31211453125,"d":"0.312114531"},{"v":3.64391453125,"d":"3.643914531"},{"v":86.21913464255601,"d":"86.22"},15]
["2000015184","3.634",0.0297,3.6637,3.29733,65.5,82.2,73.85,{"v":2.7178328124999993,"d":"2.71783281"},{"v":0.27178328124999995,"d":"0.271783281"},{"v":3.56911328125,"d":"3.569113281"},{"v":84.84063820604574,"d":"84.84"},16]
["1900014706","3.685",{"v":0,"d":"0.0000"},{"v":3.685,"d":"3.6850"},3.3165,61.5,78.6,70.05,{"v":2.3181203124999996,"d":"2.31812031"},{"v":0.23181203124999997,"d":"0.231812031"},{"v":3.54831203125,"d":"3.548312031"},{"v":84.47903836742066,"d":"84.48"},17]
["2000015142","3.553",{"v":0.026,"d":"0.0260"},{"v":3.5789999999999997,"d":"3.5790"},3.2211,77,83.2,80.1,{"v":3.2574812499999997,"d":"3.25748125"},0.325748125,3.546848125,{"v":84.45390724329744,"d":"84.45"},18]
[1900015126,"3.643",{"v":0.046,"d":"0.0460"},{"v":3.6889999999999996,"d":"3.6890"},3.3200999999999996,63,76.2,69.6,{"v":2.2671999999999994,"d":"2.26720000"},{"v":0.22671999999999995,"d":"0.226720000"},{"v":3.5468199999999994,"d":"3.546820000"},{"v":84.45342481444867,"d":"84.45"},19]
["2000015170","3.543",{"v":0.031,"d":"0.0310"},{"v":3.5740000000000003,"d":"3.5740"},3.2166,74.5,84.8,79.65,{"v":3.2235203125000003,"d":"3.22352031"},{"v":0.32235203125000006,"d":"0.322352031"},{"v":3.53895203125,"d":"3.538952031"},{"v":84.31904817939932,"d":"84.32"},20]
["2000015186","3.497",{"v":0.018,"d":"0.0180"},{"v":3.5149999999999997,"d":"3.5150"},3.1635,68,83.4,75.7,{"v":2.8928312500000004,"d":"2.89283125"},{"v":0.28928312500000003,"d":"0.289283125"},3.452783125,{"v":82.91641138402122,"d":"82.92"},21]
["1900015116","3.382",{"v":0.026,"d":"0.0260"},{"v":3.408,"d":"3.4080"},3.0672,65.5,88,76.75,{"v":2.9864453125,"d":"2.98644531"},{"v":0.29864453125,"d":"0.298644531"},{"v":3.36584453125,"d":"3.365844531"},{"v":81.60934340486996,"d":"81.61"},22]
["1900015101","3.360",{"v":0.01,"d":"0.0100"},{"v":3.3699999999999997,"d":"3.3700"},3.033,61,69.6,65.3,{"v":1.7423312499999999,"d":"1.74233125"},0.174233125,3.207233125,{"v":79.43768009197406,"d":"79.44"},23]
["2000015182","3.701",{"v":0.047,"d":"0.0470"},{"v":3.748,"d":"3.7480"},3.3732,77,0,38.5,-3.09171875,{"v":-0.30917187500000004,"d":"-0.309171875"},3.064028125,{"v":77.65755161133856,"d":"77.66"},24]
[]
["院外"]
["学校","姓名","笔试","面试","平均分"]
["北京大学外院","崔心怡",48.5,78.4,{"$f":"(C30+D30)/2","v":63.45}]
["山东大学","巩浩宇",88.5,91.6,{"$f":"(C31+D31)/2","v":90.05}]
["复旦大学","余嘉荣",79,92.4,85.7]
["南开大学","李添翼",87.5,78,82.75]
["同济大学","万志高",86.5,86.2,86.35]
["厦门大学","邵雨欣",64,65,64.5]
["吉林大学","田园",65.5,81.8,73.65]
["北京外国语大学","门易安",61.5,86,73.75]
["中国人民大学","章浩新",88.5,90.6,89.55]
["外交学院","刘奕辰",66.5,87.6,77.05]
["武汉大学","郑安琪",81.5,90.6,86.05]
["国际关系学院","沈易",79.5,90.2,84.85]