{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":61,"n_cols":20,"rows_kept":61,"merged":[[0,0,0,19],[1,0,2,0],[1,1,1,5],[1,6,1,10],[1,11,1,15],[1,16,2,16],[1,17,2,17]],"flags":["formulas_cached_only"]}
["2017-2018年度中国石油大学（北京）外国语学院翻译硕士专业研究生综合测评汇总表"]
["学号","智育成绩（70%）",{"$nulls":4},"德育成绩（20%）",{"$nulls":4},"文体成绩（10%）",{"$nulls":4},"总分","排名","不及格门数","有无纪律处分"]
[null,"基础分","奖励分","惩罚分","总 分","有效分","基础分","奖励分","惩罚分","总 分","有效分","基本分","奖励分","惩罚分","总 分","有效分"]
[2017219564,86.82499999999999,18,0,104.82499999999999,99.99999999999999,97.5,10.3,0,{"v":107.8,"d":"107.800"},{"v":95.70907282945495,"d":"95.709"},97.333,4,0,101.333,93.2509409480339,98.46690866069437,1]
[2017219533,85.529287,15,0,100.529287,95.90201478654902,97.167,8.8,0,105.967,{"v":94.081663455648,"d":"94.082"},96.5,4,0,100.5,92.48437888227336,95.19618092994125,2]
[2017219545,84.50214199999999,18,0,102.50214199999999,97.78406105413784,96.667,2,0,98.667,{"v":87.60043681691867,"d":"87.600"},94.667,2,0,96.667,88.95708908868379,94.86463901014861,3]
[2016219559,85.49199999999999,10,0,95.49199999999999,91.09658955401859,96.333,9.4,0,105.733,{"v":93.87390906750244,"d":"93.874"},94.833,2,0,96.833,89.10984935629031,91.45337943694254,4]
[2017219556,87.140713,8,0,95.140713,90.76147197710469,96.5,8,0,{"v":104.5,"d":"104.500"},{"v":92.77920325304308,"d":"92.779"},99,2,0,101,92.94450017024488,91.38332105160639,5]
[2016219522,86.685,10,0,96.685,92.23467684235631,95.833,3.6,0,{"v":99.43299999999999,"d":"99.433"},{"v":88.28052169435246,"d":"88.281"},95,0,0,95,87.42304471458677,90.96268259997858,6]
[2016219524,86.836,9,0,95.836,91.42475554495589,95.667,5.4,0,{"v":101.06700000000001,"d":"101.067"},{"v":89.73125105430914,"d":"89.731"},94.333,0,0,94.333,86.80924291643277,90.62450338397423,7]
["2017219548",86.285,7,0,93.285,88.99117576913903,96.333,9.2,0,105.533,{"v":93.69634121438655,"d":"93.696"},95.333,4,0,99.333,91.41045579614786,90.17413686088942,8]
[2017219529,85.791429,7,0,92.791429,88.5203233961364,96.5,10.2,0,{"v":106.7,"d":"106.700"},{"v":94.73244963731766,"d":"94.732"},94.833,4,0,98.833,90.95033450817635,90.00574975557664,9]
[2016219520,87.27199999999999,7,0,94.27199999999999,89.93274505127593,96.333,4.4,0,100.733,{"v":89.43471273960563,"d":"89.435"},94.833,4,0,98.833,90.95033450817635,89.93489753463192,10]
[2017219555,86.961429,5,0,91.961429,87.72852754590984,96.667,7.5,0,104.167,{"v":92.48355277760515,"d":"92.484"},95.167,2,0,97.167,89.41721037665529,88.84840087532345,11]
["2017219535",86.038571,3,0,89.038571,84.94020605771524,98,8.8,0,{"v":106.8,"d":"106.800"},{"v":94.8212335638756,"d":"94.821"},99,6,0,105,96.62547047401695,88.08493800057747,12]
[2017219539,84.72857099999999,6,0,90.72857099999999,86.55241688528498,96.167,6.8,0,102.967,{"v":91.41814565890992,"d":"91.418"},96.333,2,0,98.333,90.49021322020484,87.91934227350194,13]
[2017219524,84.4425,2,0,86.4425,82.46362985928928,98.333,14.3,0,112.633,{"v":100,"d":"100.000"},95.833,4,0,99.833,91.87057708411936,86.91159860991444,14]
[2017219561,86.02,2,0,88.02,83.9685189601717,96.5,7.8,0,{"v":104.3,"d":"104.300"},{"v":92.6016353999272,"d":"92.602"},96,4,0,100,92.02425759430186,86.50071611153581,15]
[2017219532,85.7275,0,0,85.7275,81.78154066300978,95.667,12,0,107.667,{"v":95.5909902071329,"d":"95.591"},94.667,14,0,108.667,100,86.36527650553342,16]
[2017219530,82.41357099999999,4,0,86.41357099999999,82.43603243501072,95.167,12.2,0,107.367,{"v":95.3246384274591,"d":"95.325"},95,4,0,99,91.10401501835884,85.8805518918352,17]
[2015219505,83.556,2,0,85.556,81.61793465299309,97.167,13.2,0,110.367,{"v":97.98815622419718,"d":"97.988"},94.833,4,0,98.833,90.95033450817635,85.82521895275224,18]
[2017219536,86.616429,0,0,86.616429,82.62955306463152,96.833,7.4,0,104.233,{"v":92.5421501691334,"d":"92.542"},94.833,4,0,98.833,90.95033450817635,85.44415062988638,19]
[2017219525,84.07,2,0,86.07,82.10827569759122,97.167,8.2,0,105.367,{"v":93.54895989630039,"d":"93.549"},96.167,4,0,100.167,92.17793810448434,85.40337877802236,20]
[2017219553,85.33857099999999,0,0,85.33857099999999,81.41051371333174,97.833,8.8,0,106.633,{"v":94.67296440652385,"d":"94.673"},99,4,0,103,94.78498532213091,85.40045101285008,21]
[2017219558,86.539287,0,0,86.539287,82.55596184116385,96.667,8,0,104.667,{"v":92.92747241039483,"d":"92.927"},95.667,2,0,97.667,89.8773316646268,85.36240093735633,22]
[2017219563,86.236429,0,0,86.236429,82.26704412115431,96.5,5.8,0,{"v":102.3,"d":"102.300"},{"v":90.82595686876849,"d":"90.826"},99,2,0,101,92.94450017024488,85.0465722755862,23]
[2017219541,86.875,0,0,86.875,82.8762222752206,96.333,5,0,101.333,{"v":89.96741629895324,"d":"89.967"},94.667,2,0,96.667,88.95708908868379,84.90254776131343,24]
[2017219538,83.59928699999999,2,0,85.59928699999999,81.65922919150964,96,7.8,0,{"v":103.8,"d":"103.800"},{"v":92.15771576713752,"d":"92.158"},95.667,4,0,99.667,91.71781681651284,84.76478526913553,25]
[2017219540,84.9775,0,0,84.9775,81.0660624850942,96.833,8.3,0,105.133,{"v":93.3412055081548,"d":"93.341"},95.833,4,0,99.833,91.87057708411936,84.60154254960884,26]
[2016219572,86.708,0,0,86.708,82.71690913427139,96,4,0,{"v":100,"d":"100.000"},{"v":88.78392655793596,"d":"88.784"},95,2,0,97,89.2635298664728,84.58497469222443,27]
[2017219554,85.01714199999999,0,0,85.01714199999999,81.10387979966609,95.667,8.8,0,104.467,{"v":92.74990455727897,"d":"92.750"},94.833,4,0,98.833,90.95033450817635,84.4177302220397,28]
[2017219551,83.83857099999999,1.6,0,85.43857099999998,81.50591080372045,97,6.6,0,{"v":103.6,"d":"103.600"},{"v":91.98014791402164,"d":"91.980"},95.5,0,0,95.5,87.88316600255827,84.23848374566447,29]
[2016219560,86.04599999999999,0,0,86.04599999999999,82.08538039589791,96.167,4.4,0,{"v":100.56700000000001,"d":"100.567"},{"v":89.28733142151945,"d":"89.287"},94.5,2,0,96.5,88.80340857850129,84.19757341928256,30]
[2017219562,85.145713,0,0,85.145713,81.22653279274982,96.667,4.6,0,101.267,{"v":89.90881890742499,"d":"89.909"},96,4,0,100,92.02425759430186,84.04276249584005,31]
[2017219527,84.044287,0,0,84.044287,80.17580443596471,96.167,9.3,0,105.467,{"v":93.63774382285833,"d":"93.638"},95.5,4,0,99.5,91.56413630633035,84.00702550038,32]
[2017219559,84.85642899999999,0,0,84.85642899999999,80.95056427378964,96.5,4.8,0,{"v":101.3,"d":"101.300"},{"v":89.93811760318913,"d":"89.938"},99,2,0,101,92.94450017024488,83.94746852931506,33]
[2016219565,84.84,2,0,86.84,82.84283329358455,95.833,0,0,95.833,{"v":85.08430033826676,"d":"85.084"},94.833,2,0,96.833,89.10984935629031,83.91782830879156,34]
[2016219570,85.276,0,0,85.276,81.3508227999046,96,5.4,0,{"v":101.4,"d":"101.400"},{"v":90.02690152974706,"d":"90.027"},94.833,2,0,96.833,89.10984935629031,83.86194120151167,35]
[2017219523,83.61214199999999,0,0,83.61214199999999,79.76355067970425,96.833,11.5,0,108.333,{"v":96.18229115800875,"d":"96.182"},95.333,0,0,95.333,87.72948549237579,83.8438922566323,36]
[2017219537,84.725,0,0,84.725,80.82518483186263,95.5,6.6,0,{"v":102.1,"d":"102.100"},{"v":90.64838901565261,"d":"90.648"},94.833,4,0,98.833,90.95033450817635,83.802340636252,37]
[2016219558,85.26400000000001,0,0,85.26400000000001,81.33937514905797,96,4.4,0,{"v":100.4,"d":"100.400"},{"v":89.1390622641677,"d":"89.139"},94.667,2,0,96.667,88.95708908868379,83.6610839660425,38]
[2016219548,85.163,0,0,85.163,81.24302408776532,95.833,0,0,95.833,{"v":85.08430033826676,"d":"85.084"},94.5,4,0,98.5,90.64389373038733,82.95136630212781,39]
[2017219534,82.35214199999999,0,0,82.35214199999999,78.56154734080609,96.833,4,0,100.833,{"v":89.52349666616355,"d":"89.523"},99,6,0,105,96.62547047401695,82.56032951919866,40]
[2017219542,82.769287,0,0,82.769287,78.95949153350823,97,7,0,{"v":104,"d":"104.000"},{"v":92.33528362025339,"d":"92.335"},95.333,0,0,95.333,87.72948549237579,82.51164934674401,41]
[2017219528,80.057858,4,0,84.057858,80.18875077510135,94,5.2,0,{"v":99.2,"d":"99.200"},{"v":88.07365514547247,"d":"88.074"},94.167,0,0,94.167,86.65648264882624,82.41250483654807,42]
[2016219552,83.331,0,0,83.331,79.49534939184355,95.833,4.4,0,100.233,{"v":88.99079310681596,"d":"88.991"},94.667,2,0,96.667,88.95708908868379,82.34061210452205,43]
[2017219531,82.015,0,0,82.015,78.23992368232769,95.167,9,0,104.167,{"v":92.48355277760515,"d":"92.484"},94.333,4,0,98.333,90.49021322020484,82.31367845517089,44]
[2016219573,82.975,0,0,82.975,79.15573575005962,96.167,4.4,0,{"v":100.56700000000001,"d":"100.567"},{"v":89.28733142151945,"d":"89.287"},94.5,2,0,96.5,88.80340857850129,82.14682216719575,45]
[2017219543,82.72714199999999,0,0,82.72714199999999,78.91928642976387,95.833,6.4,0,102.233,{"v":90.76647163797467,"d":"90.766"},95,0,0,95,87.42304471458677,82.13909929988833,46]
[2017219560,82.88857099999998,0,0,82.88857099999998,79.07328499880752,96.167,4.4,0,{"v":100.56700000000001,"d":"100.567"},{"v":89.28733142151945,"d":"89.287"},94.5,2,0,96.5,88.80340857850129,82.08910664131929,47]
[2016219562,82.693,0,0,82.693,78.88671595516335,96,3,0,{"v":99,"d":"99.000"},{"v":87.8960872923566,"d":"87.896"},94.667,0,0,94.667,87.11660393679774,81.51157902076545,48]
[2016219536,82.012,0,0,82.012,78.23706176961603,95.667,3,0,98.667,{"v":87.60043681691867,"d":"87.600"},94.167,0,0,94.167,86.65648264882624,80.95167886699757,49]
[2017219550,81.808571,0,0,81.808571,78.04299642260911,96,1,0,{"v":97,"d":"97.000"},{"v":86.12040876119788,"d":"86.120"},94.333,2,0,96.333,88.6497280683188,80.71915205489782,50]
[2017219526,81.372858,0,0,81.372858,77.6273388981636,95.333,2,0,97.333,{"v":86.4160592366358,"d":"86.416"},94,4,0,98,90.18377244241582,80.64072632028326,51]
[2016219530,81.63499999999999,0,0,81.63499999999999,77.87741473885045,95.667,0,0,95.667,{"v":84.9369190201806,"d":"84.937"},94.5,2,0,96.5,88.80340857850129,80.38191497908156,52]
[2017219546,81.322858,0,0,81.322858,77.57964035296924,95,3,0,{"v":98,"d":"98.000"},{"v":87.00824802677724,"d":"87.008"},94.167,0,0,94.167,86.65648264882624,80.37304611731653,53]
[2017219547,81.093571,0,0,81.093571,77.36090722632959,95.5,2,0,{"v":97.5,"d":"97.500"},{"v":86.56432839398755,"d":"86.564"},94.667,0,0,94.667,87.11660393679774,80.177161130908,54]
[2017219549,80.41,0,0,80.41,76.70880038158836,95,0,0,{"v":95,"d":"95.000"},{"v":84.34473023003916,"d":"84.345"},94,0,0,94,86.50280213864374,79.21538652698406,55]
[2016219527,78.37,0,0,78.37,74.762699737658,96.167,1,0,97.167,{"v":86.26867791854964,"d":"86.269"},94.833,0,0,94.833,87.26936420440427,78.31456182051095,56,1]
[2017219557,77.7275,0,0,77.7275,74.14977343191033,95.167,2,0,97.167,{"v":86.26867791854964,"d":"86.269"},95.167,4,0,99.167,91.25769552854133,78.2843465389013,57]
[2017219544,78.245713,0,0,78.245713,74.64413355592654,95.5,0,0,{"v":95.5,"d":"95.500"},{"v":84.78864986282883,"d":"84.789"},94.333,2,0,96.333,88.6497280683188,78.07359626854623,58]