{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["综合测评表","智育","德育","体育"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"综合测评表","index":0,"n_rows":49,"n_cols":12,"rows_kept":49,"merged":[[0,0,0,11]],"flags":["formulas_cached_only"]}
["外国语学院2012级2013-2014学年综合测评汇总表"]
["序号","学号","姓名","德育成绩","智育成绩","体育成绩","综合测评成绩","优良率","不及格门数","有无纪律处分","名次","签字"]
[1,2012011860,"常若男   ",21.66,{"v":60.526666666666664,"d":"60.53"},{"v":9.040000000000001,"d":"9.04"},{"v":91.22666666666667,"d":"91.23"},{"v":0.9333,"d":"93.33%"},0,"无",11]
[2,2012011861,"陈雯娴   ",{"v":21.200000000000003,"d":"21.20"},{"v":53.54913333333333,"d":"53.55"},{"v":9.700000000000001,"d":"9.70"},{"v":84.44913333333334,"d":"84.45"},{"v":0.4,"d":"40.00%"},0,"无",30]
[3,2012011862,"单忆  ",21.12,{"v":53.4667179487179,"d":"53.47"},{"v":9.4,"d":"9.40"},{"v":83.98671794871791,"d":"83.99"},{"v":0.3333,"d":"33.33%"},0,"无",35]
[4,2012011864,"姬佳芸   ",{"v":20,"d":"20.00"},60.36,9.52,89.88,{"v":0.6666,"d":"66.66%"},0,"无",18]
[5,2012011865,"乐晨佳   ",{"v":20.880000000000003,"d":"20.88"},{"v":62.5,"d":"62.50"},9.28,92.66,{"v":0.9333,"d":"93.33%"},0,"无",10]
[6,2012011866,"刘丹丹   ",{"v":19.8,"d":"19.80"},{"v":57.55108333333333,"d":"57.55"},{"v":9.4,"d":"9.40"},{"v":86.75108333333334,"d":"86.75"},{"v":0.7333,"d":"73.33%"},0,"无",25]
[7,2012011867,"马悍妮   ",{"v":19.8,"d":"19.80"},{"v":52.218133333333334,"d":"52.22"},9.13,{"v":81.14813333333333,"d":"81.15"},{"v":0.2666,"d":"26.66%"},0,"无",39]
[8,2012011868,"邱爽  ",{"v":19.8,"d":"19.80"},{"v":54.68268235294117,"d":"54.68"},{"v":8.950000000000001,"d":"8.95"},{"v":83.43268235294117,"d":"83.43"},{"v":0.46659999999999996,"d":"46.66%"},0,"无",38]
[9,2012011869,"任丽丽   ",21.76,{"v":59.0188,"d":"59.02"},9.65,{"v":90.42880000000001,"d":"90.43"},{"v":0.8,"d":"80.00%"},0,"无",15]
[10,2012011870,"唐静悦   ",{"v":21,"d":"21.00"},{"v":55.31767500000001,"d":"55.32"},8.89,{"v":85.20767500000001,"d":"85.21"},{"v":0.5333,"d":"53.33%"},0,"无",29]
[11,2012011871,"汪妍  ",{"v":19.8,"d":"19.80"},{"v":54.279951515151524,"d":"54.28"},9.37,{"v":83.44995151515153,"d":"83.45"},{"v":0.46659999999999996,"d":"46.66%"},0,"无",37]
[12,2012011873,"王月月   ",23.92,{"v":50.26466666666667,"d":"50.26"},9.74,{"v":83.92466666666667,"d":"83.92"},{"v":0.3333,"d":"33.33%"},1,"无",36]
[13,2012011874,"吴辰  ",{"v":21.5,"d":"21.50"},{"v":61.4719,"d":"61.47"},{"v":9.700000000000001,"d":"9.70"},{"v":92.67190000000001,"d":"92.67"},{"v":0.8665999999999999,"d":"86.66%"},0,"无",9]
[14,2012011875,"谢晓雅   ",{"v":21.4,"d":"21.40"},{"v":64.56093913043478,"d":"64.56"},10.27,{"v":96.23093913043478,"d":"96.23"},{"v":0.8,"d":"80.00%"},0,"无",4]
[15,2012011876,"徐一  ",{"v":20.4,"d":"20.40"},{"v":73.4,"d":"73.40"},9.25,{"v":103.05000000000001,"d":"103.05"},{"v":0.7333,"d":"73.33%"},0,"无",2]
[16,2012011877,"严昕  ",20.84,{"v":58.916783333333335,"d":"58.92"},9.54,{"v":89.29678333333334,"d":"89.30"},{"v":0.7333,"d":"73.33%"},0,"无",22]
[17,2012011878,"叶晓姣   ",{"v":20.680000000000003,"d":"20.68"},{"v":59.433733333333336,"d":"59.43"},{"v":9.450000000000001,"d":"9.45"},{"v":89.56373333333335,"d":"89.56"},{"v":0.8665999999999999,"d":"86.66%"},0,"无",19]
[18,2012011879,"张微  ",{"v":21.1,"d":"21.10"},65.06,9.31,95.47,{"v":0.5333,"d":"53.33%"},0,"无",5]
[19,2012011880,"张赢赢   ",20.58,{"v":63.10106666666667,"d":"63.10"},11.46,{"v":95.14106666666666,"d":"95.14"},{"v":1,"d":"100.00%"},0,"无",6]
[20,2012011881,"赵天娇   ",21.18,{"v":59.8864,"d":"59.89"},9.31,{"v":90.3764,"d":"90.38"},{"v":0.7333,"d":"73.33%"},0,"无",16]
[21,2012011883,"方正  ",{"v":20.1,"d":"20.10"},{"v":48.04800000000001,"d":"48.05"},10.47,{"v":78.61800000000001,"d":"78.62"},{"v":0.2,"d":"20.00%"},1,"无",40]
[22,2012011884,"韩彬  ",21.48,{"v":55.665866666666666,"d":"55.67"},9.31,{"v":86.45586666666667,"d":"86.46"},{"v":0.46659999999999996,"d":"46.66%"},0,"无",26]
[23,2012011885,"江凡  ",{"v":20.9,"d":"20.90"},{"v":59.127569892473126,"d":"59.13"},9.31,{"v":89.33756989247313,"d":"89.34"},{"v":0.8,"d":"80.00%"},0,"无",21]
[24,2012011888,"吴振峰   ",{"v":20.3,"d":"20.30"},{"v":54.09786666666667,"d":"54.10"},9.73,{"v":84.12786666666668,"d":"84.13"},{"v":0.4,"d":"40.00%"},0,"无",33]
[25,"2011011761          ","李曌毓   ",{"v":19.682000000000002,"d":"19.68"},{"v":55.35652582159624,"d":"55.36"},8.98,{"v":84.01852582159624,"d":"84.02"},{"v":0.5,"d":"50.00%"},0,"无",34]
[26,"2012011889          ","边圆圆   ",{"v":21.186,"d":"21.19"},{"v":63.53666666666667,"d":"63.54"},{"v":8.950000000000001,"d":"8.95"},{"v":93.67266666666667,"d":"93.67"},{"v":0.9333333333333333,"d":"93.33%"},0,"无",8]
[null,"  共   2  页，第  1 页",{"$nulls":4},"签章："]
[{"$nulls":6},"            2014 年  9 月    日"]
["序号","学号","姓名","德育成绩","智育成绩","体育成绩","综合测评成绩","优良率","不及格门数","有无纪律处分","名次","签字"]
[27,"2012011893          ","范小嫄   ",{"v":21.788,"d":"21.79"},{"v":57.789199999999994,"d":"57.79"},{"v":9.190000000000001,"d":"9.19"},{"v":88.76719999999999,"d":"88.77"},{"v":0.6666666666666666,"d":"66.67%"},0,"无",23]
[28,"2012011894          ","国圆  ",{"v":21.528,"d":"21.53"},{"v":53.385266666666666,"d":"53.39"},{"v":9.4,"d":"9.40"},{"v":84.31326666666666,"d":"84.31"},{"v":0.4,"d":"40.00%"},0,"无",31]
[29,"2012011895          ","黄丹虹   ",21.92,{"v":59.53826666666666,"d":"59.54"},9.37,{"v":90.82826666666666,"d":"90.83"},{"v":0.8,"d":"80.00%"},0,"无",14]
[30,"2012011901          ","尚田毓慧    ",21.24,{"v":55.486200000000004,"d":"55.49"},8.89,{"v":85.6162,"d":"85.62"},{"v":0.4666666666666667,"d":"46.67%"},0,"无",28]
[31,"2012011902          ","孙晓彤   ",{"v":20.214,"d":"20.21"},{"v":78.52133333333333,"d":"78.52"},9.76,{"v":108.49533333333333,"d":"108.50"},{"v":0.8666666666666667,"d":"86.67%"},0,"无",1]
[32,"2012011903          ","汪倩  ",{"v":21.176000000000002,"d":"21.18"},{"v":64.08126666666666,"d":"64.08"},8.89,{"v":94.14726666666667,"d":"94.15"},{"v":0.8666666666666667,"d":"86.67%"},0,"无",7]
[33,"2012011904          ","王俊佳   ",{"v":21.516000000000002,"d":"21.52"},{"v":58.7888,"d":"58.79"},9.96,{"v":90.26480000000001,"d":"90.26"},{"v":0.8,"d":"80.00%"},0,"无",17]
[34,"2012011905          ","王琳博   ",{"v":19.972,"d":"19.97"},{"v":61.7484,"d":"61.75"},9.28,{"v":91.0004,"d":"91.00"},{"v":1,"d":"100.00%"},0,"无",13]
[35,"2012011907          ","王亦然   ",{"v":20.738,"d":"20.74"},{"v":48.428799999999995,"d":"48.43"},8.92,{"v":78.0868,"d":"78.09"},{"v":0.13333333333333333,"d":"13.33%"},2,"无",41]
[36,"2012011908          ","熊上毓   ",{"v":21.232,"d":"21.23"},{"v":61.18606666666667,"d":"61.19"},{"v":8.590000000000002,"d":"8.59"},{"v":91.00806666666668,"d":"91.01"},{"v":0.7333333333333333,"d":"73.33%"},0,"无",12]
[37,"2012011909          ","闫晓旭   ",{"v":20.802000000000003,"d":"20.80"},{"v":57.12326666666666,"d":"57.12"},9.28,{"v":87.20526666666666,"d":"87.21"},{"v":0.6,"d":"60.00%"},0,"无",24]
[38,"2012011910          ","叶舒楠   ",{"v":20.598,"d":"20.60"},{"v":57.1648,"d":"57.16"},8.65,{"v":86.4128,"d":"86.41"},{"v":0.5333333333333333,"d":"53.33%"},0,"无",27]
[39,"2012011911          ","张宇晴   ",{"v":19.802000000000003,"d":"19.80"},{"v":70.69346666666667,"d":"70.69"},9.01,{"v":99.50546666666668,"d":"99.51"},{"v":0.6,"d":"60.00%"},0,"无",3]
[40,"2012011913          ","段阳蕃   ",{"v":21.036,"d":"21.04"},{"v":59.07942564102563,"d":"59.08"},9.31,{"v":89.42542564102564,"d":"89.43"},{"v":0.8,"d":"80.00%"},0,"无",20]
[41,"2012011914          ","胡洋  ",{"v":18.988,"d":"18.99"},{"v":41.63413333333333,"d":"41.63"},9.55,{"v":70.17213333333333,"d":"70.17"},{"v":0.26666666666666666,"d":"26.67%"},5,"无",42]
[42,"2012011915          ","卢旺达   ",{"v":20.372,"d":"20.37"},{"v":54.59626666666667,"d":"54.60"},{"v":9.340000000000002,"d":"9.34"},{"v":84.30826666666667,"d":"84.31"},{"v":0.6,"d":"60.00%"},1,"无",32]
[null,"  共   2  页，第  2 页",{"$nulls":4},"签章："]
[{"$nulls":6},"            2014 年  9 月    日"]

{"sheet":"智育","index":1,"n_rows":55,"n_cols":7,"rows_kept":55,"merged":[[3,0,4,0],[3,1,4,1],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[5,0,6,0],[5,1,6,1],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,6,6,6],[16,0,17,0],[16,1,17,1],[16,3,17,3],[16,4,17,4],[16,5,17,5],[16,6,17,6],[18,0,24,0],[18,1,24,1],[18,3,24,3],[18,4,24,4],[18,5,24,5],[18,6,24,6],[27,1,29,1],[27,3,29,3],[27,4,29,4],[27,5,29,5],[27,6,29,6],[28,0,29,0],[31,0,32,0],[31,1,32,1],[31,3,32,3],[31,4,32,4],[31,5,32,5],[31,6,32,6]],"flags":["formulas_cached_only"]}
["学  号    ","  姓  名    ","奖惩名称","智育加分总分","智育总成绩","智育总成绩*0.7","签字"]
["2012011860          ","常若男   ","科创结题",0.5,86.46666666666667,{"v":60.526666666666664,"d":"60.526667"}]
["2012011861          ","陈雯娴   ",null,0,76.4987619047619,{"v":53.54913333333333,"d":"53.549133"}]
["2012011862          ","单忆  ","第二届中国石油大学秋季英语辩论赛优秀奖",2,76.38102564102564,{"v":53.46671794871795,"d":"53.466718"}]
[null,null,"第二届中国石油大学春季英语辩论赛优秀奖"]
[2012011864,"姬佳芸   ","第二届校级春季英语辩论赛三等奖",4,86.23156989247312,{"v":60.36209892473118,"d":"60.362099"}]
[null,null,"校级秋季英语辩论赛三等奖"]
["2012011865          ","乐晨佳   ","科创结题",0.5,89.28266666666667,{"v":62.49786666666667,"d":"62.497867"}]
["2012011866          ","刘丹丹   ",null,0,82.21583333333334,{"v":57.55108333333333,"d":"57.551083"}]
["2012011867          ","马悍妮   ",null,0,74.59733333333334,{"v":52.218133333333334,"d":"52.218133"}]
["2012011868          ","邱爽  ",null,0,78.11811764705882,{"v":54.68268235294117,"d":"54.682682"}]
["2012011869          ","任丽丽   ","科创结题",0.5,84.31257142857143,{"v":59.0188,"d":"59.018800"}]
["2012011870          ","唐静悦   ",null,0,79.02525000000001,{"v":55.31767500000001,"d":"55.317675"}]
["2012011871          ","汪妍  ",null,0,77.54278787878789,{"v":54.279951515151524,"d":"54.279952"}]
["2012011873          ","王月月   ","科创结题",0.5,71.80666666666667,{"v":50.26466666666667,"d":"50.264667"}]
["2012011874          ","吴辰  ","科创结题",0.5,87.81700000000001,{"v":61.4719,"d":"61.471900"}]
["2012011875          ","谢晓雅   ","2013“外研社杯”全国英语写作大赛初赛二等奖",5,92.22991304347826,{"v":64.56093913043478,"d":"64.560939"}]
[null,null,"21世纪 可口可乐杯全国英语演讲比赛北京市优秀奖"]
["2012011876          ","徐一  ","北京市可口可乐杯英语演讲比赛校园选拔赛特等奖、京津冀赛区三等奖",20.5,104.86266666666667,{"v":73.40386666666666,"d":"73.403867"}]
[null,null,"2013外研社杯英语演讲比赛校级三等奖"]
[null,null,"科创结题"]
[null,null,"2013希望之星英语风采大赛北京赛区三等奖"]
[null,null,"2014希望之星英语风采大赛北京赛区三等奖"]
[null,null,"第二届校级秋季英语辩论赛三等奖"]
[null,null,"第二届校级春季英语辩论赛三等奖"]
["2012011877          ","严昕  ","21世纪可口可乐杯全国英语演讲比赛优秀奖",1,84.16683333333334,{"v":58.916783333333335,"d":"58.916783"}]
["2012011878          ","叶晓姣   ",null,0,84.90533333333335,{"v":59.433733333333336,"d":"59.433733"}]
[null,"张微  ","亚洲辩论赛国家级优秀奖",13,92.94933333333333,{"v":65.06453333333333,"d":"65.064533"}]
["2012011879          ",null,"第二届校级秋季英语辩论赛二等奖"]
[null,null,"第二届校级春季英语辩论赛二等奖"]
["2012011880          ","张赢赢   ","外研社英语写作大赛校内三等奖",2,90.14438095238096,{"v":63.10106666666667,"d":"63.101067"}]
["2012011881          ","赵天娇   ","21世纪可口可乐杯全国英语演讲比赛优秀奖",2,85.552,{"v":59.8864,"d":"59.886400"}]
[null,null,"2013“外研社杯”全国英语写作大赛初赛三等奖"]
["2012011883          ","方正  ",null,0,68.64000000000001,{"v":48.04800000000001,"d":"48.048000"}]
["2012011884          ","韩彬  ",null,0,79.52266666666667,{"v":55.665866666666666,"d":"55.665867"}]
["2012011885          ","江凡  ",null,0,84.46795698924733,{"v":59.127569892473126,"d":"59.127570"}]
["2012011888          ","吴振峰   ",null,0,77.28266666666667,{"v":54.09786666666667,"d":"54.097867"}]
["2011011761          ","李曌毓   ",null,0,79.08075117370892,{"v":55.35652582159624,"d":"55.356526"}]
["2012011889          ","边圆圆   ","可口可乐杯21世纪英语演讲比赛三等奖（校级）2                  大学生科技创新结题0.5",2.5,90.76666666666668,{"v":63.53666666666667,"d":"63.536667"}]
["2012011893          ","范小嫄   ","大学生科技创新结题0.5",0.5,82.556,{"v":57.789199999999994,"d":"57.789200"}]
["2012011894          ","国圆  ","GMC校内三等奖（校级）2",2,76.26466666666667,{"v":53.385266666666666,"d":"53.385267"}]
["2012011895          ","黄丹虹   ","大学生科技创新结题0.5",0.5,85.05466666666666,{"v":59.53826666666666,"d":"59.538267"}]
["2012011901          ","尚田毓慧    ",null,0,79.266,{"v":55.486200000000004,"d":"55.486200"}]
["2012011902          ","孙晓彤   ","中国第三届英国议会制辩论赛优秀辩手（国家级）2.5                   北京市“外研社”杯双语主持人风采大赛二等奖（省部级）6          cctv“希望之星”英语风采大赛北京市二等奖（省部级）6 \n“外研社”杯英语演讲比赛二等奖（校级）4                          可口可乐杯英语演讲比赛二等奖（校级）4                                                             第二届石大秋季英语辩论赛三等奖（校级）1                       第二届石大春季英语辩论赛三等奖（校级）1                                                             大学生科技创新结题0.5   ",25,112.17333333333333,{"v":78.52133333333333,"d":"78.521333"}]
["2012011903          ","汪倩  ","第二届石大秋季英语辩论赛二等奖（校级）2                       第二届石大春季英语辩论赛三等奖（校级）1                               大学生科技创新结题0.5",3.5,91.54466666666667,{"v":64.08126666666666,"d":"64.081267"}]
["2012011904          ","王俊佳   ",null,0,83.98400000000001,{"v":58.7888,"d":"58.788800"}]
["2012011905          ","王琳博   ","大学生科技创新结题0.5",0.5,88.212,{"v":61.7484,"d":"61.748400"}]
["2012011907          ","王亦然   ",null,0,69.184,{"v":48.428799999999995,"d":"48.428800"}]
["2012011908          ","熊上毓   ",null,0,87.40866666666668,{"v":61.18606666666667,"d":"61.186067"}]
["2012011909          ","闫晓旭   ",null,0,81.60466666666666,{"v":57.12326666666666,"d":"57.123267"}]
["2012011910          ","叶舒楠   ",null,0,81.664,{"v":57.1648,"d":"57.164800"}]
["2012011911          ","张宇晴   ","2014外研社杯全国大学生英语辩论精英赛二等奖（国家级）4               “康奈尔”杯中国大学生英国议会制辩论赛一等奖（省部级）4           第二届石大秋季英语辩论二等奖（校级）2                        第二届石大春季英语辩论一等奖（校级）2.5                       北京市外研社杯双语主持人英语演讲比赛石大赛区一等奖（校级）5                                ",17.5,100.99066666666667,{"v":70.69346666666667,"d":"70.693467"}]
["2012011913          ","段阳蕃   ",null,0,84.39917948717948,{"v":59.07942564102563,"d":"59.079426"}]
["2012011914          ","胡洋  ",null,0,59.477333333333334,{"v":41.63413333333333,"d":"41.634133"}]
["2012011915          ","卢旺达   ",null,0,77.99466666666667,{"v":54.59626666666667,"d":"54.596267"}]

{"sheet":"德育","index":2,"n_rows":130,"n_cols":9,"rows_kept":130,"merged":[[1,0,5,0],[1,1,5,1],[1,4,5,4],[1,5,5,5],[1,6,5,6],[1,7,5,7],[1,8,5,8],[6,0,8,0],[6,1,8,1],[6,4,8,4],[6,5,8,5],[6,6,8,6],[6,7,8,7],[6,8,8,8],[9,0,12,0],[9,1,12,1],[9,4,12,4],[9,5,12,5],[9,6,12,6],[9,7,12,7],[9,8,12,8],[13,0,14,0],[13,1,14,1],[13,4,14,4],[13,5,14,5],[13,6,14,6],[13,7,14,7],[13,8,14,8],[15,0,16,0],[15,1,16,1],[15,4,16,4],[15,5,16,5],[15,6,16,6],[15,7,16,7],[15,8,16,8],[20,0,24,0],[20,1,24,1],[20,4,24,4],[20,5,24,5],[20,6,24,6],[20,7,24,7],[20,8,24,8],[27,0,31,0],[27,1,31,1],[27,4,31,4],[27,5,31,5],[27,6,31,6],[27,7,31,7],[27,8,31,8],[32,0,34,0],[32,1,34,1],[32,4,34,4],[32,5,34,5],[32,6,34,6],[32,7,34,7],[32,8,34,8],[35,0,39,0],[35,1,39,1],[35,4,39,4],[35,5,39,5],[35,6,39,6],[35,7,39,7],[35,8,39,8],[40,0,42,0],[40,1,42,1],[40,4,42,4],[40,5,42,5],[40,6,42,6],[40,7,42,7],[40,8,42,8],[43,0,46,0],[43,1,46,1],[43,4,46,4],[43,5,46,5],[43,6,46,6],[43,7,46,7],[43,8,46,8],[47,0,48,0],[47,1,48,1],[47,4,48,4],[47,5,48,5],[47,6,48,6],[47,7,48,7],[47,8,48,8],[49,0,52,0],[49,1,52,1],[49,4,52,4],[49,5,52,5],[49,6,52,6],[49,7,52,7],[49,8,52,8],[53,0,55,0],[53,1,55,1],[53,4,55,4],[53,5,55,5],[53,6,55,6],[53,7,55,7],[53,8,55,8],[56,0,59,0],[56,1,59,1],[56,4,59,4],[56,5,59,5],[56,6,59,6],[56,7,59,7],[56,8,59,8],[60,0,62,0],[60,1,62,1],[60,4,62,4],[60,5,62,5],[60,6,62,6],[60,7,62,7],[60,8,62,8],[63,0,67,0],[63,1,67,1],[63,4,67,4],[63,5,67,5],[63,6,67,6],[63,7,67,7],[63,8,67,8],[68,0,71,0],[68,1,71,1],[68,4,71,4],[68,5,71,5],[68,6,71,6],[68,7,71,7],[68,8,71,8],[72,0,74,0],[72,1,74,1],[72,4,74,4],[72,5,74,5],[72,6,74,6],[72,7,74,7],[75,0,76,0],[75,1,76,1],[75,4,76,4],[75,5,76,5],[75,6,76,6],[75,7,76,7],[77,0,78,0],[77,1,78,1],[77,4,78,4],[77,5,78,5],[77,6,78,6],[77,7,78,7],[79,0,81,0],[79,1,81,1],[79,4,81,4],[79,5,81,5],[79,6,81,6],[79,7,81,7],[82,0,85,0],[82,1,85,1],[82,4,85,4],[82,5,85,5],[82,6,85,6],[82,7,85,7],[86,0,89,0],[86,1,89,1],[86,4,89,4],[86,5,89,5],[86,6,89,6],[86,7,89,7],[90,0,93,0],[90,1,93,1],[90,4,93,4],[90,5,93,5],[90,6,93,6],[90,7,93,7],[94,0,96,0],[94,1,96,1],[94,4,96,4],[94,5,96,5],[94,6,96,6],[94,7,96,7],[97,0,98,0],[97,1,98,1],[97,4,98,4],[97,5,98,5],[97,6,98,6],[97,7,98,7],[99,0,103,0],[99,1,103,1],[99,4,103,4],[99,5,103,5],[99,6,103,6],[99,7,103,7],[105,0,108,0],[105,1,108,1],[105,4,108,4],[105,5,108,5],[105,6,108,6],[105,7,108,7],[107,2,108,2],[107,3,108,3],[109,0,112,0],[109,1,112,1],[109,4,112,4],[109,5,112,5],[109,6,112,6],[109,7,112,7],[113,0,116,0],[113,1,116,1],[113,4,116,4],[113,5,116,5],[113,6,116,6],[113,7,116,7],[117,0,119,0],[117,1,119,1],[117,4,119,4],[117,5,119,5],[117,6,119,6],[117,7,119,7],[120,0,122,0],[120,1,122,1],[120,4,122,4],[120,5,122,5],[120,6,122,6],[120,7,122,7],[123,0,125,0],[123,1,125,1],[123,4,125,4],[123,5,125,5],[123,6,125,6],[123,7,125,7],[127,0,129,0],[127,1,129,1],[127,4,129,4],[127,5,129,5],[127,6,129,6],[127,7,129,7]],"flags":["formulas_cached_only"]}
["学  号    ","姓  名    ","奖惩名称","德育加分","德育加分总分","德育互评","德育总分","德育加分*0.2","签字"]
[2012011860,"常若男","北京国际长走大会1天、校庆3天、石油工程设计大师志愿者5天",1.8,9.3,99,108.3,21.66]
[null,null,"社会实践三等奖",0.5]
[null,null,"阳光讲坛",0.5]
[null,null,"社会实践结题",0.5]
[null,null,"职务：院青协",6]
["2012011861          ","陈雯娴   ","温暖衣冬",0.4,7,99,106,21.200000000000003]
[null,null,"职务：院青协",6]
[null,null,"职务：寝室长",0.6]
["2012011862          ","单忆  ","职务：院学生会文艺部",6,6.6,99,105.6,21.12]
[null,null,"迟到",-0.5]
[null,null,"职务：寝室长",0.6]
[null,null,"校庆演出",0.5]
["2012011864          ","姬佳芸   ","旷课",-1,1,99,100,20]
[null,null,"职务：模拟联合国","2"]
["2012011865          ","乐晨佳   ","温暖衣冬","0.4",5.4,99,104.4,20.880000000000003]
[null,null,"职务：院学生会宣传部",5]
["2012011866          ","刘丹丹   ","无",0,0,99,99,19.8]
["2012011867          ","马悍妮   ","无",0,0,99,99,19.8]
["2012011868          ","邱爽  ","无",0,0,99,99,19.8]
["2012011869          ","任丽丽   ","园博会志愿者等时长大于20天",2,9.8,99,108.8,21.76]
[null,null,"阳光讲坛物理讲座",0.5]
[null,null,"职务：院青协",6]
[null,null,"职务：宣传委员",0.8]
[null,null,"社会实践结题",0.5]
["2012011870          ","唐静悦   ","职务：院学生会外联部",6,6,99,105,21]
["2012011871          ","汪妍  ","无",0,0,99,99,19.8]
["2012011873          ","王月月   ","校庆志愿者",0.6,20.6,99,119.6,23.92]
[null,null,"职务：校友联络会部长",1]
[null,null,"“青春深处的力量”北京市一等奖",8]
[null,null,"读书报告校内一等奖",5]
[null,null,"职务：团支书",6]
["2012011874          ","吴辰  ","阳光讲坛",0.5,8.5,99,107.5,21.5]
[null,null,"园博会志愿者、校庆志愿者",2]
[null,null,"职务：校青协",6]
["2012011875          ","谢晓雅   ","温暖衣冬",0.4,8,99,107,21.400000000000002]
[null,null,"校庆表演",0.5]
[null,null,"阳光讲坛",0.5]
[null,null,"职务：寝室长",0.6]
[null,null,"职务：学生社团联合会",6]
["2012011876          ","徐一  ","职务：模拟联合国",2,3,99,102,20.400000000000002]
[null,null,"旷课",-1]
[null,null,"艺术展演大合唱二等奖、艺术展小合唱二等奖","2"]
[2012011877,"严昕  ","北京国际长走志愿者1天","0.2",5.2,99,104.2,20.840000000000003]
[null,null,"旷课","-1"]
[null,null,"社会实践三等奖","1"]
[null,null,"职务：院学生会学习部",5]
["2012011878          ","叶晓姣   ","温暖衣冬",0.4,4.4,99,103.4,20.680000000000003]
[null,null,"生活委员、心理委员",4]
["2012011879          ","张微  ","职务：大学生艺术团",6,6.5,99,105.5,21.1]
[null,null,"迟到",-0.5]
[null,null,"温暖衣冬",0.4]
[null,null,"职务：英语协会",0.6]
["2012011880          ","张赢赢   ","旷课",-0.5,3.9,99,102.9,20.580000000000002]
[null,null,"温暖衣冬",0.4]
[null,null,"职务：学习委员",4]
["2012011881          ","赵天娇   ","职务：院学生会文艺部",1,6.9,99,105.9,21.180000000000003]
[null,null,"迟到",-0.5]
[null,null,"北京市大学生艺术展演二等奖",1]
[null,null,"职务：大学生艺术团",5.4]
["2012011883          ","方正  ","旷课",-1,1.5,99,100.5,20.1]
[null,null,"社会实践结题",0.5]
[null,null,"廉政征文二等奖",2]
[2012011884,"韩彬  ","职务：院学生会体育部",1.2,8.4,99,107.4,21.480000000000004]
[null,null,"回龙观心理讲座",0.5]
[null,null,"自闭症儿童志愿者",0.2]
[null,null,"社会实践结题",0.5]
[null,null,"职务：班长",6]
["2012011885          ","江凡  ","职务：院学生会外联部",4,5.5,99,104.5,20.900000000000002]
[null,null,"回龙观心理讲座",0.5]
[null,null,"自闭症儿童志愿者",0.2]
[null,null,"职务：体育委员",0.8]
["2012011888          ","吴振峰   ","旷课",-2,2.5,99,101.5,20.3]
[null,null,"社会实践结题",0.5]
[null,null,"职务：组织委员",4]
["2011011761          ","李瞾毓","温暖衣冬； 爱心包裹； 学雷锋捐衣服",0.8,1.8,96.61,98.41,19.682000000000002]
[null,null,"回龙观心理讲座；阳光讲坛",1]
[2012011889,"边圆圆","职务：院学生会生活心理部部长",6,6.6,99.33,105.92999999999999,21.186]
[null,null,"温暖衣冬；学雷锋捐衣服",0.6]
["2012011893          ","范小嫄","职务：院学生会体育部副部长；团支书",7,9.5,99.44,108.94,21.788]
[null,null,"暑期湖南支教志愿者10天",2]
[null,null,"社会实践结题",0.5]
["2012011894          ","国圆","职务：院学生会宣传部正部长；寝室长",6.6,8.7,98.94,107.64,21.528000000000002]
[null,null,"爱心包裹；学雷锋捐衣服； 关爱自闭症儿童",0.6]
[null,null,"社会实践结题",0.5]
[null,null,"阳光讲坛2次",1]
["2012011895          ","黄丹虹","职务：班长；院青协项目部正部长",7.2,10.1,99.5,109.6,21.92]
[null,null,"温暖衣冬；爱心包裹；自闭症儿童；学雷锋捐衣服；欢喜杂志；汉语角   ",1.4]
[null,null,"社会实践结题",0.5]
[null,null,"阳光讲坛2次",1]
["2012011901          ","尚田毓慧","2014年2月28日英语语法综合实践迟到",-0.5,7.6,98.6,106.19999999999999,21.24]
[null,null,"职务：院学生会办公室部长；寝室长",6.6]
[null,null,"温暖衣冬；学雷锋捐衣服；爱心包裹； 关爱自闭者儿童",1]
[null,null,"社会实践结题",0.5]
["2012011902          ","孙晓彤","2014年5月12日英语国家概况旷课",-1,1.8,99.27,101.07,20.214]
[null,null,"温暖冬衣；学雷锋捐衣服；关爱自闭症儿童",0.8]
[null,null,"北京市大学生艺术展演二等奖；暑期社会实践成果评审通过； 2014年毕业生晚会跳开场舞",2]
["2012011903          ","汪倩","院学生会学习部正部长",6,6.6,99.28,105.88,21.176]
[null,null,"温暖衣冬；学雷锋捐衣服",0.6]
["2012011904          ","王俊佳","2014年5月12日英语国家概况旷课",-1,8.3,99.28,107.58,21.516]
[null,null,"院青协办公室主任",6]
[null,null,"组织委员",0.8]
[null,null,"温暖衣冬；学雷锋捐衣服；spe博士论坛五天1；暑假国际志愿者六周",2]
[null,null,"参加阳光讲坛",0.5]
["2012011905          ","王琳博","温暖衣冬；爱心包裹； 关爱自闭者儿童；",0.8,0.8,99.06,99.86,19.972]
["2012011907          ","王亦然","合唱团部委",4,4.3,96.39,103.69,20.738]
[null,null,"温暖衣冬；爱心包裹；学雷锋捐衣服",0.8]
[null,null,"暑期社会实践成果评审通过；青年艺术节铜奖；艺术节展演大合唱二等奖；艺术节展演小合唱二等奖",2.5]
[]
["2012011908          ","熊上毓","院青协宣传部部长",6,8.6,97.56,106.16,21.232]
[null,null,"寝室长",0.6]
[null,null,"参加阳光讲坛；参加回龙观医院心理讲座",1]
[null,null,"温暖衣冬；爱心包裹； 学雷锋捐衣服；关爱自闭症儿童",1]
["2012011909          ","闫晓旭","职务：生活心理委员",4,5.9,98.11,104.01,20.802000000000003]
[null,null,"爱心包裹；学雷锋捐衣服",0.4]
[null,null,"暑期社会实践成果评审通过0.5         ",0.5]
[null,null,"参加阳光讲坛；参加回龙观医院心理讲座 ",1]
["2012011910          ","叶舒楠   ","职务：宣传委员",4,5.6,97.39,102.99,20.598]
[null,null,"爱心包裹；学雷锋捐衣服；关爱自闭症儿童",0.6]
[null,null,"参加阳光讲坛；参加回龙观医院心理讲座 ",1]
["2012011911          ","张宇晴   ","职务：模拟联合国学术部部长；学习委员",4.4,8.4,90.61,99.01,19.802000000000003]
[null,null,"greenway国际支教；南京青奥会会场志愿者11天；爱心包裹；spe博士论坛5天",2]
[null,null,"石大“我的未来不是梦”学生就业征文比赛三等奖",2]
["2012011913          ","段阳蕃   ","2014年5月12日英语国家概况旷课",-1,6.4,98.78,105.18,21.036]
[null,null,"职务：院青协外事部副部长",6]
[null,null,"温暖衣冬；2013昌平国际长走大会； 汉语角三天；铁人三项",1.4]
["2012011914          ","胡洋  ","2013年11月25日英语短篇小说赏析旷课",-1,-1,95.94,94.94,18.988]
["2012011915          ","卢旺达   ","2013年11月25日英语短篇小说赏析旷课",-1,3.8,98.06,101.86,20.372]
[null,null,"职务：体育委员；寝室长",4.6]
[null,null,"       汉语角",0.2]

{"sheet":"体育","index":3,"n_rows":43,"n_cols":13,"rows_kept":43,"flags":["formulas_cached_only"]}
["学号","姓名","大学体育Ⅲ（必修项目）           ","大学体育Ⅳ（必修项目）           ","体育课加权成绩","体育成绩*0.6","平时锻炼成绩","平时锻炼成绩*0.4","体育加分项","体育加分","总成绩","总成绩*0.1","签字"]
[2012011860,"常若男   ","85.0    ","83.0    ",84,50.4,100,40,null,0,{"v":90.4,"d":"90.4000"},{"v":9.040000000000001,"d":"9.04"}]
[2012011861,"陈雯娴   ","94.0    ","96.0    ",95,57,100,40,null,0,{"v":97,"d":"97.0000"},{"v":9.700000000000001,"d":"9.70"}]
[2012011862,"单忆  ","93.0    ","87.0    ",90,54,100,40,null,0,{"v":94,"d":"94.0000"},{"v":9.4,"d":"9.40"}]
[2012011864,"姬佳芸   ","94.0    ","90.0    ",92,55.199999999999996,100,40,null,0,{"v":95.19999999999999,"d":"95.2000"},9.52]
[2012011865,"乐晨佳   ","94.0    ","82.0    ",88,52.8,100,40,null,0,{"v":92.8,"d":"92.8000"},9.28]
[2012011866,"刘丹丹   ","85.0    ","95.0    ",90,54,100,40,null,0,{"v":94,"d":"94.0000"},{"v":9.4,"d":"9.40"}]
[2012011867,"马悍妮   ","86.0    ","85.0    ",85.5,51.3,100,40,null,0,{"v":91.3,"d":"91.3000"},9.13]
[2012011868,"邱爽  ","85.0    ","80.0    ",82.5,49.5,100,40,null,0,{"v":89.5,"d":"89.5000"},{"v":8.950000000000001,"d":"8.95"}]
[2012011869,"任丽丽   ","94.0    ","81.0    ",87.5,52.5,100,40,"体测校级第六名",4,{"v":96.5,"d":"96.5000"},9.65]
[2012011870,"唐静悦   ","84.0    ","79.0    ",81.5,48.9,100,40,null,0,{"v":88.9,"d":"88.9000"},8.89]
[2012011871,"汪妍  ","96.0    ","83.0    ",89.5,53.699999999999996,100,40,null,0,{"v":93.69999999999999,"d":"93.7000"},9.37]
[2012011873,"王月月   ","93.0    ","95.0    ",94,56.4,100,40,"运动会方阵",1,{"v":97.4,"d":"97.4000"},9.74]
[2012011874,"吴辰  ","99.0    ","91.0    ",95,57,100,40,null,0,{"v":97,"d":"97.0000"},{"v":9.700000000000001,"d":"9.70"}]
[2012011875,"谢晓雅   ","93.0    ","96.0    ",94.5,56.699999999999996,100,40,"2014年中国石油大学游泳比赛男女双人蛙泳接力第三名",6,{"v":102.69999999999999,"d":"102.7000"},10.27]
[2012011876,"徐一  ","90.0    ","85.0    ",87.5,52.5,100,40,null,0,{"v":92.5,"d":"92.5000"},9.25]
[2012011877,"严昕  ","90.0    ","98.0    ",94,56.4,100,40,null,0,{"v":96.4,"d":"96.4000"},9.64]
[2012011878,"叶晓姣   ","90.0    ","85.0    ",87.5,52.5,100,40,"运动会方阵",1,{"v":93.5,"d":"93.5000"},9.35]
[2012011879,"张微  ","86.0    ","91.0    ",88.5,53.1,100,40,null,0,{"v":93.1,"d":"93.1000"},9.31]
[2012011880,"张赢赢   ","98.0    ","94.0    ",96,57.599999999999994,100,40,"运动会方阵、北京市国旗班比赛二等奖",17,{"v":114.6,"d":"114.6000"},11.46]
[2012011881,"赵天娇   ","88.0    ","89.0    ",88.5,53.1,100,40,null,0,{"v":93.1,"d":"93.1000"},9.31]
[2012011883,"方正  ","92.0    ","81.0    ",86.5,51.9,100,40,"2014年中国石油大学游泳比赛蛙泳第八名、仰泳第四",8,{"v":99.9,"d":"99.9000"},10.47]
[2012011884,"韩彬  ","95.0    ","82.0    ",88.5,53.1,100,40,null,0,{"v":93.1,"d":"93.1000"},9.31]
[2012011885,"江凡  ","90.0    ","87.0    ",88.5,53.1,100,40,null,0,{"v":93.1,"d":"93.1000"},9.31]
[2012011888,"吴振峰   ","98.0    ","93.0    ",95.5,57.3,100,40,null,0,{"v":97.3,"d":"97.3000"},9.73]
["2011011761          ","李曌毓   ",77,89,83,49.8,100,40,null,0,{"v":89.8,"d":"89.8000"},8.98]
["2012011889          ","边圆圆   ","82.0    ","83.0    ",82.5,49.5,100,40,null,0,{"v":89.5,"d":"89.5000"},{"v":8.950000000000001,"d":"8.95"}]
["2012011893          ","范小嫄   ","88.0    ","85.0    ",86.5,51.9,100,40,null,0,{"v":91.9,"d":"91.9000"},{"v":9.190000000000001,"d":"9.19"}]
["2012011894          ","国圆  ","97.0    ","83.0    ",90,54,100,40,null,0,{"v":94,"d":"94.0000"},{"v":9.4,"d":"9.40"}]
["2012011895          ","黄丹虹   ","88.0    ","91.0    ",89.5,53.699999999999996,100,40,null,0,{"v":93.69999999999999,"d":"93.7000"},9.37]
["2012011901          ","尚田毓慧    ","93.0    ","70.0    ",81.5,48.9,100,40,null,0,{"v":88.9,"d":"88.9000"},8.89]
["2012011902          ","孙晓彤   ","93.0    ","99.0    ",96,57.599999999999994,100,40,null,0,{"v":97.6,"d":"97.6000"},9.76]
["2012011903          ","汪倩  ","87.0    ","76.0    ",81.5,48.9,100,40,null,0,{"v":88.9,"d":"88.9000"},8.89]
["2012011904          ","王俊佳   ","89.0    ","93.0    ",91,54.6,100,40,"校游泳比赛第五名+4、参加校级羽毛球比赛+1",5,{"v":99.6,"d":"99.6000"},9.96]
["2012011905          ","王琳博   ","88.0    ","- ",88,52.8,100,40,null,0,{"v":92.8,"d":"92.8000"},9.28]
["2012011907          ","王亦然   ","71.0    ","93.0    ",82,49.199999999999996,100,40,null,0,{"v":89.19999999999999,"d":"89.2000"},8.92]
["2012011908          ","熊上毓   ","68.0    ","85.0    ",76.5,45.9,100,40,null,0,{"v":85.9,"d":"85.9000"},{"v":8.590000000000002,"d":"8.59"}]
["2012011909          ","闫晓旭   ","87.0    ","89.0    ",88,52.8,100,40,null,0,{"v":92.8,"d":"92.8000"},9.28]
["2012011910          ","叶舒楠   ","76.0    ","79.0    ",77.5,46.5,100,40,null,0,{"v":86.5,"d":"86.5000"},8.65]
["2012011911          ","张宇晴   ","89.0    ","78.0    ",83.5,50.1,100,40,null,0,{"v":90.1,"d":"90.1000"},9.01]
["2012011913          ","段阳蕃   ","83.0    ","94.0    ",88.5,53.1,100,40,null,0,{"v":93.1,"d":"93.1000"},9.31]
["2012011914          ","胡洋  ","99.0    ","86.0    ",92.5,55.5,100,40,null,0,{"v":95.5,"d":"95.5000"},9.55]
["2012011915          ","卢旺达   ","89.0    ",null,89,53.4,100,40,null,0,{"v":93.4,"d":"93.4000"},{"v":9.340000000000002,"d":"9.34"}]