{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["英语2016级"],"read":"whole","date_system":"1900"}

{"sheet":"英语2016级","index":0,"n_rows":60,"n_cols":11,"rows_kept":60,"merged":[[0,0,0,10],[72,3,72,9],[73,3,73,9]]}
["中国石油大学（北京）外国语学院英语专业2016级本科生综合测评汇总表"]
["名次","学号","德育总成绩","智育总成绩","体育成绩","必修课优良率","综合测评成绩","四级成绩","体测成绩","不及格门数","有无纪律处分"]
[1,2016011933,{"v":104.666666666667,"d":"104.6667"},{"v":99.6530316742082,"d":"99.65303167"},{"v":91.6,"d":"91.60"},{"v":1,"d":"100.00%"},{"$f":"C3*0.2+D3*0.7+E3*0.1","v":{"v":99.85045550527911,"d":"99.85045551"}},"无",67.4,0,"无"]
[2,2016011949,{"v":106.7,"d":"106.7000"},{"v":96.3090598290598,"d":"96.30905983"},{"v":96.4,"d":"96.40"},{"v":1,"d":"100.00%"},{"v":98.39634188034186,"d":"98.39634188"},"无",77.2,0,"无"]
[3,2016011934,{"v":106,"d":"106.0000"},{"v":96.9953846153846,"d":"96.99538462"},{"v":91.6,"d":"91.60"},{"v":1,"d":"100.00%"},{"v":98.25676923076921,"d":"98.25676923"},"无",66.7,0,"无"]
[4,2016011957,{"v":111.6,"d":"111.6000"},{"v":93.9463523573201,"d":"93.94635236"},{"v":94,"d":"94.00"},{"v":1,"d":"100.00%"},{"v":97.48244665012407,"d":"97.48244665"},"无",79.8,1,"无"]
[5,2016010965,{"v":106.666666666667,"d":"106.6667"},{"v":94.7157509157509,"d":"94.71575092"},{"v":93.7,"d":"93.70"},{"v":1,"d":"100.00%"},{"v":97.00435897435904,"d":"97.00435897"},"无",73.5,0,"无"]
[6,2016011989,{"v":105.9,"d":"105.9000"},{"v":92.3975845410628,"d":"92.39758454"},{"v":88.9,"d":"88.90"},{"v":0.875,"d":"87.50%"},{"v":94.74830917874397,"d":"94.74830918"},"无",55.3,0,"无"]
[7,"2016011969",{"v":106.1,"d":"106.1000"},{"v":91.031884057971,"d":"91.03188406"},{"v":94.3,"d":"94.30"},{"v":1,"d":"100.00%"},{"v":94.37231884057971,"d":"94.37231884"},"无",71.6,0,"无"]
[8,2016011950,{"v":107.2,"d":"107.2000"},{"v":89.2484615384615,"d":"89.24846154"},{"v":100.4,"d":"100.40"},{"v":1,"d":"100.00%"},{"v":93.95392307692305,"d":"93.95392308"},"无",83.8,0,"无"]
[9,2016011955,{"v":105.733333333333,"d":"105.7333"},{"v":89.9557190635452,"d":"89.95571906"},{"v":93.4,"d":"93.40"},{"v":1,"d":"100.00%"},{"v":93.45567001114824,"d":"93.45567001"},"无",65.1,0,"无"]
[10,"2016011971",{"v":100,"d":"100.0000"},{"v":91.1391304347826,"d":"91.13913043"},{"v":93.4,"d":"93.40"},{"v":1,"d":"100.00%"},{"v":93.13739130434783,"d":"93.13739130"},"无",69.5,0,"无"]
[11,2016011986,{"v":105,"d":"105.0000"},{"v":89.663768115942,"d":"89.66376812"},{"v":92.5,"d":"92.50"},{"v":1,"d":"100.00%"},{"v":93.0146376811594,"d":"93.01463768"},"无",68.7,0,"无"]
[12,2016011683,{"v":101.4,"d":"101.4000"},{"v":90.8514861721375,"d":"90.85148617"},{"v":91,"d":"91.00"},{"v":1,"d":"100.00%"},{"v":92.97604032049624,"d":"92.97604032"},"无",77.5,0,"无"]
[13,2016011953,{"v":103.066666666667,"d":"103.0667"},{"v":90.8006557377049,"d":"90.80065574"},{"v":87.4,"d":"87.40"},{"v":0.928571428571429,"d":"92.86%"},{"v":92.91379234972682,"d":"92.91379235"},"无",67.2,0,"无"]
[14,"2016011970",{"v":105.33333,"d":"105.3333"},{"v":88.887922705314,"d":"88.88792271"},{"v":93.1,"d":"93.10"},{"v":1,"d":"100.00%"},{"v":92.59821189371979,"d":"92.59821189"},"无",77.6,0,"无"]
[15,2016011979,{"v":107.06666,"d":"107.0667"},{"v":88.1109730848861,"d":"88.11097308"},{"v":93.4,"d":"93.40"},{"v":1,"d":"100.00%"},{"v":92.43101315942027,"d":"92.43101316"},"无",73.4,0,"无"]
[16,2016011946,{"v":102,"d":"102.0000"},{"v":88.8088888888889,"d":"88.80888889"},{"v":94.9,"d":"94.90"},{"v":1,"d":"100.00%"},{"v":92.05622222222222,"d":"92.05622222"},"无",71.1,0,"无"]
[17,2016011980,{"v":101.2,"d":"101.2000"},{"v":89.1176201372998,"d":"89.11762014"},{"v":94.3,"d":"94.30"},{"v":1,"d":"100.00%"},{"v":92.05233409610986,"d":"92.05233410"},"无",72.9,0,"无"]
[18,2016011966,{"v":105.4,"d":"105.4000"},{"v":87.7947299077734,"d":"87.79472991"},{"v":94.6,"d":"94.60"},{"v":0.8125,"d":"81.25%"},{"v":91.99631093544137,"d":"91.99631094"},"无",90.2,0,"无"]
[19,2016011990,{"v":108.6,"d":"108.6000"},{"v":87.0128146453089,"d":"87.01281465"},{"v":90.4,"d":"90.40"},{"v":0.9375,"d":"93.75%"},{"v":91.66897025171623,"d":"91.66897025"},"无",71.7,0,"无"]
[20,2016011941,{"v":105.4,"d":"105.4000"},{"v":87.4642914979757,"d":"87.46429150"},{"v":92.8,"d":"92.80"},{"v":1,"d":"100.00%"},{"v":91.58500404858299,"d":"91.58500405"},"无",69.9,0,"无"]
[21,2016011935,{"v":108.066666666667,"d":"108.0667"},{"v":86.3389743589744,"d":"86.33897436"},{"v":95.2,"d":"95.20"},{"v":0.933333333333333,"d":"93.33%"},{"v":91.57061538461546,"d":"91.57061538"},"无",76.8,0,"无"]
[22,2016011701,{"v":100.2,"d":"100.2000"},{"v":89.2380151387721,"d":"89.23801514"},{"v":90.4,"d":"90.40"},{"v":0.888888888888889,"d":"88.89%"},{"v":91.54661059714047,"d":"91.54661060"},"无",73,0,"无"]
[23,2016011977,{"v":106.33333,"d":"106.3333"},{"v":87.4567774936061,"d":"87.45677749"},{"v":90.1,"d":"90.10"},{"v":0.9375,"d":"93.75%"},{"v":91.49641024552427,"d":"91.49641025"},"无",61.1,0,"无"]
[24,2016011962,{"v":106.833333333333,"d":"106.8333"},{"v":86.6437606837607,"d":"86.64376068"},{"v":92.8,"d":"92.80"},{"v":0.933333333333333,"d":"93.33%"},{"v":91.29729914529909,"d":"91.29729915"},"无",67.6,0,"无"]
[25,2016011940,{"v":102.2,"d":"102.2000"},{"v":86.4703846153846,"d":"86.47038462"},{"v":101.7,"d":"101.70"},{"v":1,"d":"100.00%"},{"v":91.13926923076922,"d":"91.13926923"},"无",85.4,0,"无"]
[26,2016011983,{"v":102,"d":"102.0000"},{"v":86.6724637681159,"d":"86.67246377"},{"v":94.3,"d":"94.30"},{"v":0.9375,"d":"93.75%"},{"v":90.50072463768112,"d":"90.50072464"},"无",78.4,0,"无"]
[27,2016011968,{"v":106,"d":"106.0000"},{"v":85.7503432494279,"d":"85.75034325"},{"v":92.5,"d":"92.50"},{"v":0.9375,"d":"93.75%"},{"v":90.47524027459953,"d":"90.47524027"},"无",75.3,0,"无"]
[28,2016011937,{"v":107.5,"d":"107.5000"},{"v":85.2901357466063,"d":"85.29013575"},{"v":91.9,"d":"91.90"},{"v":0.666666666666667,"d":"66.67%"},{"v":90.39309502262441,"d":"90.39309502"},"无",72.1,0,"无"]
[29,2016011947,{"v":106.4,"d":"106.4000"},{"v":86.1644444444444,"d":"86.16444444"},{"v":86.5,"d":"86.50"},{"v":0.866666666666667,"d":"86.67%"},{"v":90.24511111111107,"d":"90.24511111"},"无",72.8,0,"无"]
[30,2016011975,{"v":100,"d":"100.0000"},{"v":86.0086956521739,"d":"86.00869565"},{"v":97,"d":"97.00"},{"v":0.9375,"d":"93.75%"},{"v":89.90608695652172,"d":"89.90608696"},"无",42.3,0,"无"]
[31,2016011948,{"v":100,"d":"100.0000"},{"v":85.9441595441595,"d":"85.94415954"},{"v":93.4,"d":"93.40"},{"v":0.933333333333333,"d":"93.33%"},{"v":89.50091168091166,"d":"89.50091168"},"无",64.2,0,"无"]
[32,2016011943,{"v":102,"d":"102.0000"},{"v":84.9954655870445,"d":"84.99546559"},{"v":92.2,"d":"92.20"},{"v":0.933333333333333,"d":"93.33%"},{"v":89.11682591093115,"d":"89.11682591"},"无",73.7,0,"无"]
[33,2016011982,{"v":104.8,"d":"104.8000"},{"v":76.6975845410628,"d":"76.69758454"},{"v":144.3,"d":"144.30"},{"v":0.4375,"d":"43.75%"},{"v":89.07830917874396,"d":"89.07830918"},"无",78.9,0,"无"]
[34,2016011965,{"v":109.8,"d":"109.8000"},{"v":82.0820289855073,"d":"82.08202899"},{"v":94.9,"d":"94.90"},{"v":0.625,"d":"62.50%"},{"v":88.9074202898551,"d":"88.90742029"},"无",66.4,0,"无"]
[35,2016011938,{"v":108.166666666667,"d":"108.1667"},{"v":83.0686639676113,"d":"83.06866397"},{"v":90.7,"d":"90.70"},{"v":0.933333333333333,"d":"93.33%"},{"v":88.85139811066131,"d":"88.85139811"},"无",67,0,"无"]
[36,2016011956,{"v":104,"d":"104.0000"},{"v":84.3598360655738,"d":"84.35983607"},{"v":88.9,"d":"88.90"},{"v":0.928571428571429,"d":"92.86%"},{"v":88.74188524590166,"d":"88.74188525"},"无",68.4,1,"无"]
[37,2016011936,{"v":106.333333333333,"d":"106.3333"},{"v":82.778947368421,"d":"82.77894737"},{"v":89.8,"d":"89.80"},{"v":0.8,"d":"80.00%"},{"v":88.1919298245613,"d":"88.19192982"},"无",69.3,0,"无"]
[38,2016011110,{"v":100,"d":"100.0000"},{"v":83.7019654556284,"d":"83.70196546"},{"v":94,"d":"94.00"},{"v":0.705882352941177,"d":"70.59%"},{"v":87.99137581893987,"d":"87.99137582"},"无",80.6,0,"无"]
[39,2016011959,{"v":100,"d":"100.0000"},{"v":83.8439560439561,"d":"83.84395604"},{"v":88.9,"d":"88.90"},{"v":0.866666666666667,"d":"86.67%"},{"v":87.58076923076926,"d":"87.58076923"},"无",45.7,0,"无"]
[40,"2016011972",{"v":106.86666,"d":"106.8667"},{"v":81.2144927536232,"d":"81.21449275"},{"v":91,"d":"91.00"},{"v":0.8125,"d":"81.25%"},{"v":87.32347692753623,"d":"87.32347693"},428,74.8,0,"无"]
[41,2016011985,{"v":100,"d":"100.0000"},{"v":83.1940323955669,"d":"83.19403240"},{"v":90.4,"d":"90.40"},{"v":0.6875,"d":"68.75%"},{"v":87.27582267689682,"d":"87.27582268"},"无",71.6,0,"有"]
[42,2016011942,{"v":100,"d":"100.0000"},{"v":83.1485714285714,"d":"83.14857143"},{"v":90.7,"d":"90.70"},{"v":0.8,"d":"80.00%"},{"v":87.27399999999997,"d":"87.27400000"},"无",76.3,0,"无"]
[43,2016011978,{"v":100,"d":"100.0000"},{"v":82.52,"d":"82.52000000"},{"v":92.5,"d":"92.50"},{"v":0.8125,"d":"81.25%"},{"v":87.014,"d":"87.01400000"},"无",79.9,0,"无"]
[44,2016011981,{"v":102,"d":"102.0000"},{"v":81.9871635610766,"d":"81.98716356"},{"v":91.9,"d":"91.90"},{"v":0.75,"d":"75.00%"},{"v":86.98101449275362,"d":"86.98101449"},"无",76,0,"无"]
[45,2016011987,{"v":106.6,"d":"106.6000"},{"v":80.2459627329193,"d":"80.24596273"},{"v":88.9,"d":"88.90"},{"v":0.625,"d":"62.50%"},{"v":86.3821739130435,"d":"86.38217391"},"无",70.5,0,"无"]
[46,2016011963,{"v":104.33333,"d":"104.3333"},{"v":79.7604938271605,"d":"79.76049383"},{"v":94.3,"d":"94.30"},{"v":0.705882352941177,"d":"70.59%"},{"v":86.12901167901236,"d":"86.12901168"},"无",66.4,0,"无"]
[47,2016011961,{"v":100,"d":"100.0000"},{"v":80.9308262108262,"d":"80.93082621"},{"v":91,"d":"91.00"},{"v":0.8,"d":"80.00%"},{"v":85.75157834757833,"d":"85.75157835"},"无",71.7,0,"无"]
[48,2016011954,{"v":100,"d":"100.0000"},{"v":80.9569230769231,"d":"80.95692308"},{"v":89.8,"d":"89.80"},{"v":0.6,"d":"60.00%"},{"v":85.64984615384617,"d":"85.64984615"},"无",71.3,0,"无"]
[49,2016011951,{"v":100,"d":"100.0000"},{"v":79.849364548495,"d":"79.84936455"},{"v":92.5,"d":"92.50"},{"v":0.666666666666667,"d":"66.67%"},{"v":85.1445551839465,"d":"85.14455518"},"无",68.2,0,"无"]
[50,2016011958,{"v":105,"d":"105.0000"},{"v":77.4004024144869,"d":"77.40040241"},{"v":79.3,"d":"79.30"},{"v":0.6875,"d":"68.75%"},{"v":83.11028169014082,"d":"83.11028169"},"无",56,1,"无"]
[51,2016011992,{"v":102,"d":"102.0000"},{"v":76.8738461538462,"d":"76.87384615"},{"v":87.7,"d":"87.70"},{"v":0.466666666666667,"d":"46.67%"},{"v":82.98169230769234,"d":"82.98169231"},"无",64.3,0,"无"]
[52,2016011984,{"v":100,"d":"100.0000"},{"v":80.4086538461538,"d":"80.40865385"},{"v":60,"d":"60.00"},{"v":0.785714285714286,"d":"78.57%"},{"v":82.28605769230765,"d":"82.28605769"},"无",null,1,"无"]
[53,2016011939,{"v":100,"d":"100.0000"},{"v":75.9884507042254,"d":"75.98845070"},{"v":89.8,"d":"89.80"},{"v":0.5,"d":"50.00%"},{"v":82.17191549295778,"d":"82.17191549"},"无",50.5,0,"无"]
[54,2016011967,{"v":100,"d":"100.0000"},{"v":73.8721568627451,"d":"73.87215686"},{"v":89.8,"d":"89.80"},{"v":0.470588235294118,"d":"47.06%"},{"v":80.69050980392157,"d":"80.69050980"},"无",61,2,"无"]
[55,"2016011974",{"v":100,"d":"100.0000"},{"v":71.5106666666667,"d":"71.51066667"},{"v":83.8,"d":"83.80"},{"v":0.352941176470588,"d":"35.29%"},{"v":78.43746666666668,"d":"78.43746667"},"无",64.9,2,"无"]
[56,2016011944,{"v":100,"d":"100.0000"},{"v":69.1932827735645,"d":"69.19328277"},{"v":83.5,"d":"83.50"},{"v":0.1875,"d":"18.75%"},{"v":76.78529794149514,"d":"76.78529794"},"无",65.2,2,"无"]
[57,"2016011973",{"v":100,"d":"100.0000"},{"v":68.0202111613876,"d":"68.02021116"},{"v":60,"d":"60.00"},{"v":0.363636363636364,"d":"36.36%"},{"v":73.61414781297132,"d":"73.61414781"},"无",null,3,"无"]
[58,2016011945,{"v":103,"d":"103.0000"},{"v":62.976397515528,"d":"62.97639752"},{"v":80.2,"d":"80.20"},{"v":0.2,"d":"20.00%"},{"v":72.7034782608696,"d":"72.70347826"},"无",32.9,3,"无"]