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

{"sheet":"Sheet1","index":0,"n_rows":53,"n_cols":20,"rows_kept":53,"merged":[[0,0,0,19],[1,0,2,19],[3,0,4,0],[3,1,3,5],[3,6,3,10],[3,11,3,15],[3,16,4,16],[3,17,4,17],[3,18,4,18],[3,19,4,19]],"flags":["formulas_cached_only"]}
["2016-2017年度中国石油大学（北京）外国语学院翻译硕士专业研究生综合测评汇总表"]
["1.智育分=100分×个人智育总分/智育基准分，德育和文体计算方式同理\n2.个人智育总分=学习成绩分+奖惩分，德育和文体计算方式同理\n3.智育基准分取学生所在集体参评成员的最高个人智育总分（2016级翻译硕士班智育基准分为117.487，德育基准分为107.511，文体基准分为103.256）                             \n"]
[]
["学号","智育成绩",{"$nulls":4},"德育成绩",{"$nulls":4},"文体成绩",{"$nulls":4},"总分","排名","不及格门数","有无纪律处分"]
[null,"学习成绩分","奖励分","惩罚分","总 分","有效分","基础分","奖励分","惩罚分","总 分","有效分","基本分","奖励分","惩罚分","总 分","有效分"]
[2016219554,89.487,28,0,117.487,100,{"v":96.33333333333333,"d":"96.333"},8.736,0,{"v":105.06933333333333,"d":"105.069"},{"v":97.72891456068061,"d":"97.729"},96.244,0,0,96.244,93.20911133493453,98.86669404562957,1]
[2016219525,88.039,16,0,104.039,88.55362720981896,{"v":96.28888888888889,"d":"96.289"},9,0,{"v":105.28888888888889,"d":"105.289"},{"v":97.933131390173,"d":"97.933"},96.178,5.4,0,101.578,98.3749128379949,91.41165660870736,2]
[2016219557,86.943,13,0,99.943,85.06728403993633,{"v":96.26666666666667,"d":"96.267"},11,0,{"v":107.26666666666667,"d":"107.267"},{"v":99.77273643317118,"d":"99.773"},96.156,0,0,96.156,93.12388626326799,88.81403474091645,3]
[2016219566,85.5,14,0,99.5,84.69022104573273,{"v":96.31111111111112,"d":"96.311"},{"v":11.2,"d":"11.200"},0,{"v":107.51111111111112,"d":"107.511"},{"v":100.00010334859793,"d":"100.000"},96.333,0,0,96.333,93.29530487332454,88.61270588906494,4]
[2016219531,88.305,10.5,0,98.805,84.09866623541329,{"v":96.08888888888889,"d":"96.089"},9,0,{"v":105.08888888888889,"d":"105.089"},{"v":97.74710391391476,"d":"97.747"},95.978,0.25,0,96.228,93.19361586735879,87.73784873430813,5]
[2016219555,87.841,12,0,99.841,84.98046592388944,{"v":96.42222222222222,"d":"96.422"},3.9,0,{"v":100.32222222222222,"d":"100.322"},{"v":93.31344906309329,"d":"93.313"},96.289,0,0,96.289,93.25269233749128,87.47428519309038,6]
[2016219545,87.451,10,0,97.451,82.94619830279093,{"v":95.95555555555555,"d":"95.956"},9,0,{"v":104.95555555555555,"d":"104.956"},{"v":97.62308559640925,"d":"97.623"},95.844,0,0,95.844,92.82172464554118,86.86912839578963,7]
[2016219540,87.265,9.6,0,96.865,82.44741971452162,{"v":96.62222222222222,"d":"96.622"},9.12,0,{"v":105.74222222222222,"d":"105.742"},{"v":98.35479366969169,"d":"98.355"},96.556,1.1,0,97.65599999999999,94.57658634849305,86.84181116895277,8]
[2016219577,88.39,8,0,96.39,82.04311966430329,{"v":96.17777777777778,"d":"96.178"},7.736,0,{"v":103.91377777777778,"d":"103.914"},{"v":96.65408914229965,"d":"96.654"},96.156,0.5,0,96.656,93.60811962500969,86.1218135559732,9]
[2016219544,85.513,9.5,0,95.013,80.8710750976704,{"v":95.86666666666666,"d":"95.867"},8.8,0,{"v":104.66666666666666,"d":"104.667"},{"v":97.35437924181402,"d":"97.354"},95.822,0,0,95.822,92.80041837762455,85.36067025449454,10]
[2016219574,86.472,4,0,90.472,77.00596661758321,{"v":96.88888888888889,"d":"96.889"},8.289,0,{"v":105.17788888888889,"d":"105.178"},{"v":97.82988614084967,"d":"97.830"},96.956,2.1,0,99.056,95.9324397613698,83.06339783661517,11,1]
[2016219519,83.662,7,0,90.662,77.16768663767056,{"v":96.37777777777778,"d":"96.378"},7.7,0,{"v":104.07777777777778,"d":"104.078"},{"v":96.80663167283141,"d":"96.807"},96.2,2.067,0,98.267,95.1683195165414,82.89553893258982,12]
[2016219549,86.313,4,0,90.313,76.87063249551015,96.711,8.738,0,105.449,{"v":98.08205671977751,"d":"98.082"},96.644,0.6,0,97.244,94.17757805841791,82.8436118966544,13,1]
[2016219575,84.889,6,0,90.889,77.36089950377489,{"v":96.24444444444444,"d":"96.244"},7.67,0,{"v":103.91444444444444,"d":"103.914"},{"v":96.65470923388717,"d":"96.655"},96.222,0,0,96.222,93.18780506701789,82.80235200612164,14,1]
[2016219518,87.289,3,0,90.289,76.85020470349912,{"v":96.37777777777778,"d":"96.378"},7.8,0,{"v":104.17777777777778,"d":"104.178"},{"v":96.89964541096053,"d":"96.900"},96.333,2.373,0,98.706,95.59347640815062,82.73442001545655,15]
[2016219517,88.386,1.25,0,89.636,76.29439852919899,{"v":96.91111111111111,"d":"96.911"},10.2,0,{"v":107.11111111111111,"d":"107.111"},{"v":99.62804839608144,"d":"99.628"},96.556,0.373,0,96.929,93.87251104052065,82.71893975370764,16]
[2016219571,85.499,5,0,90.499,77.02894788359563,{"v":96.24444444444444,"d":"96.244"},7.444,0,{"v":103.68844444444444,"d":"103.688"},{"v":96.44449818571537,"d":"96.444"},95.911,0.667,0,96.578,93.53257922057799,82.5624210777178,17]
[2016219516,86.14,2,0,88.14,75.02106616051138,{"v":96.26666666666667,"d":"96.267"},9,0,{"v":105.26666666666667,"d":"105.267"},{"v":97.91246167058874,"d":"97.912"},96.133,2.333,0,98.466,95.3610443945146,81.63334308592718,18]
[2015219516,84.614,6,0,90.614,77.12683105364849,{"v":95.95555555555555,"d":"95.956"},2.3,0,{"v":98.25555555555555,"d":"98.256"},{"v":91.3911651417581,"d":"91.391"},95.778,0,0,95.778,92.75780584179128,81.54279535008469,19]
[2016219539,86.736,2,0,88.736,75.52835632878532,{"v":96.35555555555555,"d":"96.356"},6.6,0,{"v":102.95555555555555,"d":"102.956"},{"v":95.76281083382682,"d":"95.763"},96.178,0.25,0,96.428,93.38730921205547,81.36114251812063,20]
[2016219547,86.933,1.5,0,88.433,75.27045545464605,{"v":96.04444444444445,"d":"96.044"},7.8,0,{"v":103.84444444444445,"d":"103.844"},{"v":96.58959961719681,"d":"96.590"},95.889,0.25,0,96.139,93.10742232896877,81.31798097458847,21]
[2016219551,85.246,3,0,88.246,75.1112889085601,{"v":96.22222222222223,"d":"96.222"},8,0,{"v":104.22222222222223,"d":"104.222"},{"v":96.94098485012904,"d":"96.941"},96.089,0,0,96.089,93.0589989927946,81.27199910529734,22]
[2016219538,88.013,0,0,88.013,74.91296909445302,{"v":95.86666666666666,"d":"95.867"},6.214,0,{"v":102.08066666666666,"d":"102.081"},{"v":94.94904397379493,"d":"94.949"},95.756,2,0,97.756,94.6734330208414,80.89623046296023,23]
[2016219550,83.404,4,0,87.404,74.3946138721731,{"v":96,"d":"96.000"},5,0,{"v":101,"d":"101.000"},{"v":93.9438755104129,"d":"93.944"},96.156,7.1,0,103.256,100,80.86500481260374,24]
[2015219515,85.313,3,0,88.313,75.1683164945909,{"v":96.13333333333334,"d":"96.133"},4.6,0,{"v":100.73333333333333,"d":"100.733"},{"v":93.6958388754019,"d":"93.696"},96.089,0,0,96.089,93.0589989927946,80.66288922057348,25]
[2016219564,83.863,4,0,87.863,74.78529539438405,{"v":95.75555555555556,"d":"95.756"},6,0,{"v":101.75555555555556,"d":"101.756"},{"v":94.64664597627737,"d":"94.647"},95.711,0,0,95.711,92.69291857131789,80.5483278284561,26]
[2015219535,85.181,3,0,88.181,75.05596363853023,{"v":95.88888888888889,"d":"95.889"},2.5,0,{"v":98.38888888888889,"d":"98.389"},{"v":91.5151834592636,"d":"91.515"},95.822,2.25,0,98.072,94.97946850546217,80.34015808937009,27]
[2015219524,84.477,4,0,88.477,75.30790640666628,{"v":96.08888888888889,"d":"96.089"},2,0,{"v":98.08888888888889,"d":"98.089"},{"v":91.23614224487623,"d":"91.236"},96.022,0,0,96.022,92.99411172232122,80.26217410587377,28]
[2015219560,84.192,3,0,87.192,74.21416837607565,{"v":96.22222222222223,"d":"96.222"},4.4,0,{"v":100.62222222222223,"d":"100.622"},{"v":93.59249027748066,"d":"93.592"},96.089,2.2,0,98.289,95.18962578445804,80.18737849719489,29]
[2016219521,86.604,0,0,86.604,73.71368747180539,{"v":96.28888888888889,"d":"96.289"},6.6,0,{"v":102.88888888888889,"d":"102.889"},{"v":95.70080167507408,"d":"95.701"},96.111,0.55,0,96.661,93.61296195862711,80.10103776114128,30]
[2016219535,85.783,0,0,85.783,73.01488675342803,{"v":96.62222222222222,"d":"96.622"},7.6,0,{"v":104.22222222222221,"d":"104.222"},{"v":96.94098485012903,"d":"96.941"},96.578,2.3,0,98.878,95.76005268458975,80.0746229658844,31]
[2016219528,83.889,2,0,85.889,73.10510950147676,{"v":95.97777777777777,"d":"95.978"},7.2,0,{"v":103.17777777777778,"d":"103.178"},{"v":95.96950802966931,"d":"95.970"},96.111,0.75,0,96.861,93.80665530332378,79.74814378729997,32,1]
[2016219556,83.557,4,0,87.557,74.52484104624342,{"v":95.82222222222222,"d":"95.822"},1,0,{"v":96.82222222222222,"d":"96.822"},{"v":90.05796822857404,"d":"90.058"},96.956,0,0,96.956,93.8986596420547,79.56884834229066,33]
[2016219546,85.519,0,0,85.519,72.79018104130671,{"v":95.95555555555555,"d":"95.956"},7.6,0,{"v":103.55555555555554,"d":"103.556"},{"v":96.32089326260154,"d":"96.321"},95.911,0,0,95.911,92.88661191601457,79.50596657303647,34]
[2016219543,84.887,0,0,84.887,72.25224918501623,{"v":96.28888888888889,"d":"96.289"},5.5,0,{"v":101.78888888888889,"d":"101.789"},{"v":94.67765055565374,"d":"94.678"},96.244,5.4,0,101.644,98.4388316417448,79.35598770481658,35]
[2016219569,86.51,0,0,86.51,73.6336786197622,{"v":95.75555555555556,"d":"95.756"},3,0,{"v":98.75555555555556,"d":"98.756"},{"v":91.85623383240373,"d":"91.856"},95.933,0,0,95.933,92.90791818393122,79.2056136187074,36]
[2015219530,85.723,0,0,85.723,72.96381727340045,{"v":95.97777777777777,"d":"95.978"},3.3,0,{"v":99.27777777777777,"d":"99.278"},{"v":92.34197224263357,"d":"92.342"},95.911,0,0,95.911,92.88661191601457,78.8317277315085,37]
[2016219534,84.39,0,0,84.39,71.82922365878778,{"v":95.84444444444445,"d":"95.844"},7,0,{"v":102.84444444444445,"d":"102.844"},{"v":95.6594622359056,"d":"95.659"},95.711,0,0,95.711,92.69291857131789,78.68164086546436,38]
[2016219533,80.652,2,0,82.652,70.34991105398896,{"v":97.15555555555555,"d":"97.156"},9.142,0,{"v":106.29755555555555,"d":"106.298"},{"v":98.87132996210207,"d":"98.871"},96.956,2.1,0,99.056,95.9324397613698,78.61244770634966,39]
[2016219561,84.175,0,0,84.175,71.64622468868896,{"v":95.71111111111111,"d":"95.711"},7.2,0,{"v":102.91111111111111,"d":"102.911"},{"v":95.72147139465832,"d":"95.721"},95.667,0,0,95.667,92.65030603548463,78.5616821645624,40]
[2016219576,83.632,0,0,83.632,71.1840458944394,{"v":96.13333333333334,"d":"96.133"},5.8,0,{"v":101.93333333333334,"d":"101.933"},{"v":94.81200373295137,"d":"94.812"},96.222,2.75,0,98.972,95.85108855659719,78.37634172835757,41]
[2016219529,81.418,1.5,0,82.918,70.57631908211123,{"v":96.11111111111111,"d":"96.111"},9,0,{"v":105.11111111111111,"d":"105.111"},{"v":97.767773633499,"d":"97.768"},96.2,0,0,96.2,93.16649879910126,78.27362796408778,42,1]
[2016219563,82.628,0,0,82.628,70.32948326197791,{"v":96.22222222222223,"d":"96.222"},9,0,{"v":105.22222222222223,"d":"105.222"},{"v":97.87112223142026,"d":"97.871"},96.178,0.6,0,96.77799999999999,93.72627256527466,78.17748998619605,43]
[2016219542,83.659,0,0,83.659,71.20702716045182,{"v":96,"d":"96.000"},4.149,0,100.149,{"v":93.15232859893406,"d":"93.152"},95.933,2.05,0,97.983,94.89327496707214,77.9647122288103,44]
[2016219532,82.581,0,0,82.581,70.28947883595633,{"v":95.91111111111111,"d":"95.911"},4.5,0,{"v":100.41111111111111,"d":"100.411"},{"v":93.3961279414303,"d":"93.396"},95.867,0,0,95.867,92.8439993801813,77.16626071147361,45]
[2016219568,79.056,1,0,80.056,68.14030488479577,{"v":95.55555555555556,"d":"95.556"},8.173,0,{"v":103.72855555555556,"d":"103.729"},{"v":96.48180702956493,"d":"96.482"},95.578,0,0,95.578,92.56411249709461,76.25098607497948,46]
[2016219523,82.349,0,0,82.349,70.09201017984968,{"v":94.68888888888888,"d":"94.689"},0,0,{"v":94.68888888888888,"d":"94.689"},{"v":88.0736751484861,"d":"88.074"},95.267,0,0,95.267,92.26291934609125,75.90543409020111,47]
[2016219537,81.106,0,0,81.106,69.03402078527837,{"v":95.97777777777777,"d":"95.978"},0,0,{"v":95.97777777777777,"d":"95.978"},{"v":89.27251888437256,"d":"89.273"},95.867,0,0,95.867,92.8439993801813,75.4627182645875,48]