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

{"sheet":"Sheet1","index":0,"n_rows":55,"n_cols":12,"rows_kept":55,"merged":[[0,0,0,11]]}
["中国石油大学（北京）外国语学院学院英语专业2014级本科生综合测评公示表"]
["名次","学号","德育总成绩","智育总成绩","体育成绩","必修课优良率","综合测评成绩","四级成绩","体测成绩","不及格门数","有无纪律处分","智育排名"]
[1,2014011898,23.192,83.41557,7.08,{"v":1,"d":"100.00%"},{"$f":"SUM(C3:E3)","v":113.68757},"无",70.8,0,"无",1]
[2,"2014011920          ",{"v":20.6666666666667,"d":"20.67"},{"v":79.344,"d":"79.34"},7.87,{"v":1,"d":"100.00%"},{"$f":"C4+D4+E4","v":{"v":107.880666666667,"d":"107.88"}},"无",78.7,0,"无",2]
[3,"2014011911          ",{"v":22.9955555555556,"d":"23.00"},72.12,11.93,{"v":0.916666666666667,"d":"91.67%"},{"$f":"C5+D5+E5","v":{"v":107.045555555556,"d":"107.05"}},"无",84.3,0,"无",6]
[4,2014011904,22.008,72.64271,7.73,{"v":1,"d":"100.00%"},{"$f":"SUM(C6:E6)","v":102.38071},"无",77.3,0,"无",5]
[5,"2014011929          ",{"v":21.0044444444444,"d":"21.00"},{"v":73.4922222222222,"d":"73.49"},7.36,{"v":1,"d":"100.00%"},{"$f":"C7+D7+E7","v":{"v":101.856666666667,"d":"101.86"}},"无",73.6,0,"无",3]
[6,2014011890,18.8,73.04262,8.61,{"v":1,"d":"100.00%"},{"$f":"SUM(C8:E8)","v":100.45262},"无",86.1,0,"无",4]
[7,2014011884,21.212,68.4222,7.72,{"v":0.666666666666667,"d":"66.67%"},{"$f":"SUM(C9:E9)","v":97.3542},"无",77.2,0,"无",7]
[8,"2014011919          ",{"v":20.8288888888889,"d":"20.83"},{"v":66.2811111111111,"d":"66.28"},{"v":7.9,"d":"7.90"},{"v":0.916666666666667,"d":"91.67%"},{"$f":"C10+D10+E10","v":95.01},"无",79,0,"无",9]
[9,2014011892,19.488,67.235,7.4,{"v":0.916666666666667,"d":"91.67%"},{"$f":"SUM(C11:E11)","v":94.123},"无",74,0,"无",8]
[10,2014011878,20.5,65.28802,8.22,{"v":1,"d":"100.00%"},{"$f":"SUM(C12:E12)","v":94.00802},"无",82.2,0,"无",11]
[11,"2014011917          ",{"v":21.8222222222222,"d":"21.82"},{"v":64.462,"d":"64.46"},7.69,{"v":1,"d":"100.00%"},{"$f":"C13+D13+E13","v":{"v":93.9742222222222,"d":"93.97"}},"无",76.9,0,"无",14]
[12,"2014011909          ",{"v":21.232,"d":"21.23"},{"v":63.918,"d":"63.92"},8.65,{"v":0.916666666666667,"d":"91.67%"},{"$f":"C14+D14+E14","v":{"v":93.8,"d":"93.80"}},"无",86.5,0,"无",17]
[13,2014011888,20.324,64.9117,8.52,{"v":1,"d":"100.00%"},{"$f":"SUM(C15:E15)","v":93.7557},"无",85.2,0,"无",12]
[14,2014011877,20.14,64.63548,7.75,{"v":1,"d":"100.00%"},{"$f":"SUM(C16:E16)","v":92.52548},"无",77.5,0,"无",13]
[15,2014011880,19.064,65.43999,7.92,{"v":1,"d":"100.00%"},{"$f":"SUM(C17:E17)","v":92.42399},"无",79.2,0,"无",10]
[16,"2014011922          ",{"v":21.2422222222222,"d":"21.24"},{"v":63.2109090909091,"d":"63.21"},7.69,{"v":1,"d":"100.00%"},{"$f":"C18+D18+E18","v":{"v":92.1431313131313,"d":"92.14"}},"无",76.9,0,"无",21]
[17,"2014011918          ",{"v":20.0622222222222,"d":"20.06"},{"v":63.916,"d":"63.92"},7.69,{"v":0.916666666666667,"d":"91.67%"},{"$f":"C19+D19+E19","v":{"v":91.6682222222222,"d":"91.67"}},"无",76.9,0,"无",18]
[18,"2014011906          ",{"v":19.4577777777778,"d":"19.46"},{"v":62.3772413793103,"d":"62.38"},9.27,{"v":0.9,"d":"90.00%"},{"$f":"C20+D20+E20","v":{"v":91.1050191570881,"d":"91.11"}},"无",92.7,0,"无",23]
[19,"2014011912          ",{"v":18.9466666666667,"d":"18.95"},64.23,{"v":7.9,"d":"7.90"},{"v":0.916666666666667,"d":"91.67%"},{"$f":"C21+D21+E21","v":{"v":91.0766666666667,"d":"91.08"}},"无",79,0,"无",15]
[20,2014011894,18.196,64.10397,8.01,{"v":1,"d":"100.00%"},{"$f":"SUM(C22:E22)","v":90.30997},"无",80.1,0,"无",16]
[21,"2014011907          ",{"v":19.4666666666667,"d":"19.47"},{"v":62.338947368421,"d":"62.34"},8.22,{"v":0.916666666666667,"d":"91.67%"},{"$f":"C23+D23+E23","v":{"v":90.0256140350877,"d":"90.03"}},"无",82.2,0,"无",24]
[22,"2014011926          ",{"v":19.6866666666667,"d":"19.69"},{"v":62.216,"d":"62.22"},7.84,{"v":0.75,"d":"75.00%"},{"$f":"C24+D24+E24","v":{"v":89.7426666666667,"d":"89.74"}},"无",78.4,0,"无",26]
[23,2014011893,19.332,63.17276,7.03,{"v":0.916666666666667,"d":"91.67%"},{"$f":"SUM(C25:E25)","v":89.53476},"无",70.3,0,"无",22]
[24,2014011896,19.212,62.08727,7.58,{"v":1,"d":"100.00%"},{"$f":"SUM(C26:E26)","v":88.87927},"无",75.8,0,"无",27]
[25,2014011895,18.976,62.32457,7.48,{"v":0.916666666666667,"d":"91.67%"},{"$f":"SUM(C27:E27)","v":88.78057},"无",74.8,0,"无",25]
[26,"2014011925          ",{"v":18.8622222222222,"d":"18.86"},{"v":61.5844444444445,"d":"61.58"},8.17,{"v":0.916666666666667,"d":"91.67%"},{"$f":"C28+D28+E28","v":{"v":88.6166666666667,"d":"88.62"}},"无",81.7,0,"无",29]
[27,"2014011913          ",{"v":19.7444444444444,"d":"19.74"},{"v":61.6777777777778,"d":"61.68"},{"v":7.1,"d":"7.10"},{"v":0.833333333333333,"d":"83.33%"},{"$f":"C29+D29+E29","v":{"v":88.5222222222222,"d":"88.52"}},"无",71,0,"无",28]
[28,2014011887,19.588,60.92443,7.74,{"v":1,"d":"100.00%"},{"$f":"SUM(C30:E30)","v":88.25243},"无",77.4,0,"无",30]
[29,2014011902,17.532,63.39802,7.2,{"v":1,"d":"100.00%"},{"$f":"SUM(C31:E31)","v":88.13002},"无",72,0,"无",20]
[30,2014011886,20.046,59.24996,8.37,{"v":0.75,"d":"75.00%"},{"$f":"SUM(C32:E32)","v":87.66596},"无",83.7,0,"无",36]
[31,"2014011924          ",{"v":19.5955555555556,"d":"19.60"},{"v":59.8533333333333,"d":"59.85"},8.14,{"v":1,"d":"100.00%"},{"$f":"C33+D33+E33","v":{"v":87.5888888888889,"d":"87.59"}},"无",81.4,0,"无",33]
[32,"2014011931          ",{"v":22.1911111111111,"d":"22.19"},{"v":57.9355555555556,"d":"57.94"},7.36,{"v":0.666666666666667,"d":"66.67%"},{"$f":"C34+D34+E34","v":{"v":87.4866666666667,"d":"87.49"}},"无",73.6,0,"无",40]
[33,2014011889,18.648,63.40348,4.65,{"v":1,"d":"100.00%"},{"$f":"SUM(C35:E35)","v":86.70148},"无",46.5,0,"无",19]
[34,2014011897,18.092,60.70183,7.16,{"v":1,"d":"100.00%"},{"$f":"SUM(C36:E36)","v":85.95383},"无",71.6,0,"无",31]
[35,2014011876,19.632,58.0867,7.95,{"v":0.666666666666667,"d":"66.67%"},{"$f":"SUM(C37:E37)","v":85.6687},"无",79.5,0,"无",39]
[36,"2014011923          ",{"v":19.4355555555556,"d":"19.44"},58.69,7.15,{"v":0.666666666666667,"d":"66.67%"},{"$f":"C38+D38+E38","v":{"v":85.2755555555556,"d":"85.28"}},"无",71.5,0,"无",37]
[37,2014011901,17.668,59.61235,7.6,{"v":0.583333333333333,"d":"58.33%"},{"$f":"SUM(C39:E39)","v":84.88035},"无",76,0,"无",35]
[38,"2014011910          ",18.82,{"v":59.618,"d":"59.62"},{"v":6.2,"d":"6.20"},{"v":0.75,"d":"75.00%"},{"$f":"C40+D40+E40","v":{"v":84.638,"d":"84.64"}},"无",62,0,"无",34]
[39,"2014011927          ",{"v":20.1511111111111,"d":"20.15"},{"v":58.2555555555556,"d":"58.26"},5.49,{"v":0.583333333333333,"d":"58.33%"},{"$f":"C41+D41+E41","v":{"v":83.8966666666667,"d":"83.90"}},"无",54.9,0,"无",38]
[40,"2014011908          ",{"v":19.1271111111111,"d":"19.13"},{"v":56.6933333333333,"d":"56.69"},7.92,{"v":0.583333333333333,"d":"58.33%"},{"$f":"C42+D42+E42","v":{"v":83.7404444444444,"d":"83.74"}},"无",79.2,0,"无",42]
[41,2014011900,15.432,60.572036,6.29,{"v":0.916666666666667,"d":"91.67%"},{"$f":"SUM(C43:E43)","v":82.294036},"无",62.9,0,"无",32]
[42,"2014011916          ",{"v":18.5555555555556,"d":"18.56"},{"v":57.0254545454546,"d":"57.03"},6.19,{"v":0.75,"d":"75.00%"},{"$f":"C44+D44+E44","v":{"v":81.7710101010102,"d":"81.77"}},"无",61.9,0,"无",41]
[43,2014011903,18.112,55.31001,6.64,{"v":0.5,"d":"50.00%"},{"$f":"SUM(C45:E45)","v":80.06201},"无",66.4,0,"无",43]
[44,2014011875,18.856,53.11502,7.84,{"v":0.333333333333333,"d":"33.33%"},{"$f":"SUM(C46:E46)","v":79.81102},"无",78.4,1,"无",48]
[45,"2014011914          ",{"v":18.2777777777778,"d":"18.28"},{"v":53.7216666666667,"d":"53.72"},7.56,{"v":0.583333333333333,"d":"58.33%"},{"$f":"C47+D47+E47","v":{"v":79.5594444444445,"d":"79.56"}},"无",75.6,0,"无",46]
[46,"2014011905          ",{"v":18.4111111111111,"d":"18.41"},{"v":54.2176,"d":"54.22"},6.86,{"v":0.583333333333333,"d":"58.33%"},{"v":79.4887111111111,"d":"79.49"},"无",68.6,1,"无",45]
[47,"2014011933          ",{"v":19.1333333333333,"d":"19.13"},{"v":52.2733333333333,"d":"52.27"},6.51,{"v":0.416666666666667,"d":"41.67%"},{"v":77.9166666666666,"d":"77.92"},"无",65.1,3,"无",49]
[48,"2014011928          ",{"v":18.2333333333333,"d":"18.23"},{"v":51.532,"d":"51.53"},6.18,{"v":0.333333333333333,"d":"33.33%"},{"v":75.9453333333333,"d":"75.95"},"无",61.8,0,"无",51]
[49,"2014011932          ",{"v":18.0777777777778,"d":"18.08"},{"v":50.7825,"d":"50.78"},6.66,{"v":0.166666666666667,"d":"16.67%"},{"v":75.5202777777778,"d":"75.52"},"无",66.6,2,"无",53]
[50,"2013011222          ",{"v":17.7777777777778,"d":"17.78"},{"v":53.3553846153846,"d":"53.36"},3.62,{"v":0.416666666666667,"d":"41.67%"},{"v":74.7531623931624,"d":"74.75"},"无",36.2,0,"无",47]
[51,2014011885,16.672,51.68443,6.2,{"v":0.25,"d":"25.00%"},{"$f":"SUM(C53:E53)","v":74.55643},"无",62,1,"无",50]
[52,"2014011934          ",{"v":18.0888888888889,"d":"18.09"},{"v":50.8822222216,"d":"50.88"},{"v":5.2,"d":"5.20"},{"v":0.25,"d":"25.00%"},{"$f":"C54+D54+E54","v":{"v":74.1711111104889,"d":"74.17"}},"无",52,2,"无",52]
[53,2013010430,13.772,54.44551,3.8,{"v":0.583333333333333,"d":"58.33%"},{"$f":"SUM(C55:E55)","v":72.01751},"无",38,0,"无",44]

{"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}