{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["【总表】","【德育】同学互评","【德育】学生职务","【德育】学生职务附录","【德育】志愿时长","【智育】必修成绩","【智育】选修成绩","【体育】体测成绩","【德育·智育·文体】1班竞赛加分","【德育·智育·文体】2班竞赛加分"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"【总表】","index":0,"n_rows":61,"n_cols":32,"rows_kept":61,"merged":[[0,3,0,15],[0,16,0,21],[0,22,0,27],[1,3,1,8],[1,17,1,19],[2,3,2,6]]}
[{"$nulls":3},"德育",{"$nulls":12},"智育",{"$nulls":5},"体育",{"$nulls":5},"综测成绩",null,"必修课是否有资格评选奖学金","体测是否有资格评选奖学金"]
[{"$nulls":3},"思想品德评估成绩",{"$nulls":5},"奖惩赋分","学生荣誉","学生干部及社团","大型会议、讲座","社会实践获奖","志愿服务","德育总成绩",null,"课程成绩",{"$nulls":3},"智育成绩","体测成绩","平时成绩","体测备注","文艺加分","体育加分","体育成绩"]
[null,null,"班级","辅导员评价",{"$nulls":3},"同学互评",{"$nulls":8},"必修课优良率","必修课成绩","选修课成绩","课程成绩","（学科竞赛）智育加分"]
["学号","姓名",null,"辅导员评价总分","政治表现+集体观念+团结正直+爱护公物+诚实守信（满45）","学风学德+文明礼貌+勤俭节约（满25）","组织纪律+劳动卫生+社会实践（满30）",null,"思想品德评估成绩"]
[2020010644,"李硕","能化21-1班",{"$f":"E5+F5+G5","v":98},44,25,29,{"v":94.15384615384616,"d":"94.15"},{"$f":"0.4*D5+H5*0.6","v":{"v":95.69230769230771,"d":"95.6923"}},{"$nulls":6},{"$f":"I5+J5+K5+L5+M5+N5+O5","v":{"v":95.69230769230771,"d":"95.6923"}},{"v":0.2727272727272727,"d":"27.27%"},{"v":54.8,"d":"54.8000"},{"v":84,"d":"84.0000"},{"$f":"R5*0.8+S5*0.2","v":{"v":60.64,"d":"60.6400"}},null,{"$f":"T5+U5","v":{"v":60.64,"d":"60.6400"}},{"v":60,"d":"60.0"},{"v":100,"d":"100.0"},"20级大三体测",null,null,{"$f":"W5*0.6+X5*0.4+Z5+AA5","v":{"v":76,"d":"76.0"}},{"$f":"AB5*0.1+V5*0.7+P5*0.2","v":{"v":69.18646153846154,"d":"69.1865"}},null,"否","否"]
["2021010374","何若妍","能化21-1班",99,45,25,29,96.56,{"$f":"0.4*D6+H6*0.6","v":{"v":97.536,"d":"97.5360"}},null,null,{"v":4,"d":"4.00"},null,null,4,{"$f":"I6+J6+K6+L6+M6+N6+O6","v":{"v":105.536,"d":"105.5360"}},{"v":1,"d":"100.00%"},{"v":92.10714285714286,"d":"92.1071"},{"v":95,"d":"95.0000"},{"$f":"R6*0.8+S6*0.2","v":{"v":92.6857142857143,"d":"92.6857"}},{"$f":"6+8","v":14},{"$f":"T6+U6","v":{"v":106.6857142857143,"d":"106.6857"}},60.8,{"v":100,"d":"100.0"},{"$nulls":3},{"$f":"W6*0.6+X6*0.4+Z6+AA6","v":{"v":76.47999999999999,"d":"76.5"}},{"$f":"AB6*0.1+V6*0.7+P6*0.2","v":{"v":103.43520000000001,"d":"103.4352"}},null,"是","是"]
["2021010376","李传洋","能化21-1班",94,45,20,29,95.24,{"v":94.744,"d":"94.7440"},null,null,{"v":1,"d":"1.00"},{"$nulls":3},{"v":95.744,"d":"95.7440"},{"v":0.24,"d":"24.00%"},{"v":58.015151515151516,"d":"58.0152"},{"v":53.857142857142854,"d":"53.8571"},{"v":57.183549783549786,"d":"57.1835"},null,{"v":57.183549783549786,"d":"57.1835"},73.8,{"v":100,"d":"100.0"},{"$nulls":3},{"v":84.28,"d":"84.3"},{"v":67.60528484848484,"d":"67.6053"},null,"否","是"]
["2021010377","甘浩","能化21-1班",97,45,23,29,95.44,{"v":96.064,"d":"96.0640"},null,null,{"v":2,"d":"2.00"},{"$nulls":3},{"v":98.064,"d":"98.0640"},{"v":0.1,"d":"10.00%"},{"v":65.53333333333333,"d":"65.5333"},{"v":54.285714285714285,"d":"54.2857"},{"v":63.28380952380952,"d":"63.2838"},null,{"v":63.28380952380952,"d":"63.2838"},61.9,{"v":100,"d":"100.0"},{"$nulls":3},{"v":77.14,"d":"77.1"},{"v":71.62546666666665,"d":"71.6255"},null,"否","是"]
["2021010380","詹作鑫","能化21-1班",99,45,25,29,{"v":96.6,"d":"96.60"},{"v":97.56,"d":"97.5600"},{"$nulls":6},{"v":97.56,"d":"97.5600"},{"v":0.35,"d":"35.00%"},{"v":76.92222222222222,"d":"76.9222"},{"v":86.47368421052632,"d":"86.4737"},{"v":78.83251461988304,"d":"78.8325"},null,{"v":78.83251461988304,"d":"78.8325"},41.3,{"v":100,"d":"100.0"},{"$nulls":3},{"v":64.78,"d":"64.8"},{"v":81.17276023391813,"d":"81.1728"},null,"是","否"]
["2021010381","李维昊","能化21-1班",97,45,23,29,96.24,{"v":96.544,"d":"96.5440"},{"$nulls":6},{"v":96.544,"d":"96.5440"},{"v":0.18181818181818182,"d":"18.18%"},{"v":62.647619047619045,"d":"62.6476"},{"v":51,"d":"51.0000"},{"v":60.31809523809524,"d":"60.3181"},null,{"v":60.31809523809524,"d":"60.3181"},86.2,{"v":100,"d":"100.0"},{"$nulls":3},{"v":91.72,"d":"91.7"},{"v":70.70346666666667,"d":"70.7035"},null,"否","是"]
["2021010382","王理哲","能化21-1班",99,45,25,29,95.92,{"v":97.152,"d":"97.1520"},{"$nulls":6},{"v":97.152,"d":"97.1520"},{"v":0.3,"d":"30.00%"},{"v":70.03333333333333,"d":"70.0333"},{"v":71,"d":"71.0000"},{"v":70.22666666666667,"d":"70.2267"},null,{"v":70.22666666666667,"d":"70.2267"},43.4,{"v":100,"d":"100.0"},"补测",null,null,{"v":66.03999999999999,"d":"66.0"},{"v":75.19306666666667,"d":"75.1931"},null,"否","否"]
["2021010387","李洪博","能化21-1班",99,45,25,29,95.76,{"v":97.05600000000001,"d":"97.0560"},null,null,{"v":2,"d":"2.00"},{"$nulls":3},{"v":99.05600000000001,"d":"99.0560"},{"v":0.16666666666666666,"d":"16.67%"},{"v":68.43478260869566,"d":"68.4348"},{"v":78,"d":"78.0000"},{"v":70.34782608695653,"d":"70.3478"},null,{"v":70.34782608695653,"d":"70.3478"},56.6,{"v":100,"d":"100.0"},{"$nulls":3},{"v":73.96000000000001,"d":"74.0"},{"v":76.45067826086957,"d":"76.4507"},null,"否","否"]
["2021010389","李臻彦","能化21-1班",99,45,25,29,95.88,{"v":97.128,"d":"97.1280"},{"$nulls":6},{"v":97.128,"d":"97.1280"},{"v":0.3333333333333333,"d":"33.33%"},{"v":71,"d":"71.0000"},{"v":71.66666666666667,"d":"71.6667"},{"v":71.13333333333334,"d":"71.1333"},null,{"v":71.13333333333334,"d":"71.1333"},55.6,{"v":100,"d":"100.0"},{"$nulls":3},{"v":73.36,"d":"73.4"},{"v":76.55493333333334,"d":"76.5549"},null,"否","否"]
["2021010392","苏辛一","能化21-1班",100,45,25,30,96.72,{"v":98.032,"d":"98.0320"},null,null,{"v":6.2,"d":"6.20"},{"$nulls":3},{"v":104.232,"d":"104.2320"},{"v":0.043478260869565216,"d":"4.35%"},{"v":59.78504672897196,"d":"59.7850"},{"v":75,"d":"75.0000"},{"v":62.82803738317757,"d":"62.8280"},null,{"v":62.82803738317757,"d":"62.8280"},56.4,{"v":100,"d":"100.0"},{"$nulls":3},{"v":73.84,"d":"73.8"},{"v":72.2100261682243,"d":"72.2100"},null,"否","否"]
["2021010393","唐顾玮","能化21-1班",99,45,25,29,95.64,{"v":96.98400000000001,"d":"96.9840"},{"$nulls":6},{"v":96.98400000000001,"d":"96.9840"},{"v":0.14285714285714285,"d":"14.29%"},{"v":69.53191489361703,"d":"69.5319"},{"v":65,"d":"65.0000"},{"v":68.62553191489363,"d":"68.6255"},null,{"v":68.62553191489363,"d":"68.6255"},65.6,{"v":100,"d":"100.0"},{"$nulls":3},{"v":79.35999999999999,"d":"79.4"},{"v":75.37067234042554,"d":"75.3707"},null,"否","是"]
["2021010428","周忠康","能化21-1班",99,45,25,29,96.32,{"v":97.392,"d":"97.3920"},{"$nulls":6},{"v":97.392,"d":"97.3920"},{"v":0.7,"d":"70.00%"},{"v":80.67045454545455,"d":"80.6705"},{"v":81.5,"d":"81.5000"},{"v":80.83636363636364,"d":"80.8364"},null,{"v":80.83636363636364,"d":"80.8364"},{"v":60,"d":"60.0"},{"v":100,"d":"100.0"},"补测",null,null,{"v":76,"d":"76.0"},{"v":83.66385454545454,"d":"83.6639"},null,"是","是"]
["2021010431","王医灵","能化21-1班",99,45,25,29,96.52,{"v":97.512,"d":"97.5120"},null,null,{"v":4.2,"d":"4.20"},{"v":2,"d":"2.0"},null,4,{"v":107.712,"d":"107.7120"},{"v":0.7222222222222222,"d":"72.22%"},{"v":83.7710843373494,"d":"83.7711"},{"v":84,"d":"84.0000"},{"v":83.81686746987951,"d":"83.8169"},null,{"v":83.81686746987951,"d":"83.8169"},71.8,{"v":100,"d":"100.0"},{"$nulls":3},{"v":83.08,"d":"83.1"},{"v":88.52220722891566,"d":"88.5222"},null,"是","是"]
["2021010432","梁卓文","能化21-1班",99,45,25,29,95.88,{"v":97.128,"d":"97.1280"},{"$nulls":6},{"v":97.128,"d":"97.1280"},{"v":0.47619047619047616,"d":"47.62%"},{"v":78.7127659574468,"d":"78.7128"},{"v":67,"d":"67.0000"},{"v":76.37021276595745,"d":"76.3702"},null,{"v":76.37021276595745,"d":"76.3702"},{"v":60,"d":"60.0"},{"v":100,"d":"100.0"},"补测",null,null,{"v":76,"d":"76.0"},{"$f":"AB18*0.1+V18*0.7+P18*0.2","v":{"v":80.4847489361702,"d":"80.4847"}},null,"是","是"]
["2021010433","朱佳怡","能化21-1班",99,45,25,29,95.96,{"v":97.17599999999999,"d":"97.1760"},{"$nulls":6},{"v":97.17599999999999,"d":"97.1760"},{"v":0.19047619047619047,"d":"19.05%"},{"v":67.38297872340425,"d":"67.3830"},{"v":66,"d":"66.0000"},{"v":67.1063829787234,"d":"67.1064"},null,{"v":67.1063829787234,"d":"67.1064"},67.8,{"v":100,"d":"100.0"},{"$nulls":3},{"v":80.68,"d":"80.7"},{"v":74.47766808510637,"d":"74.4777"},null,"否","是"]
["2021010442","裴俊豪","能化21-1班",99,45,25,29,95.56,{"v":96.936,"d":"96.9360"},null,null,{"v":4,"d":"4.00"},{"$nulls":3},{"v":100.936,"d":"100.9360"},{"v":0.95,"d":"95.00%"},{"v":89.57954545454545,"d":"89.5795"},{"v":86.5,"d":"86.5000"},{"v":88.96363636363637,"d":"88.9636"},null,{"v":88.96363636363637,"d":"88.9636"},69.1,{"v":100,"d":"100.0"},{"$nulls":3},{"v":81.46,"d":"81.5"},{"v":90.60774545454545,"d":"90.6077"},null,"是","是"]
["2021010443","鲍怡帅","能化21-1班",99,45,25,29,96.28,{"v":97.368,"d":"97.3680"},null,null,{"v":4,"d":"4.00"},{"$nulls":3},{"v":101.368,"d":"101.3680"},{"v":0.631578947368421,"d":"63.16%"},{"v":78.14285714285714,"d":"78.1429"},{"v":74.66666666666667,"d":"74.6667"},{"v":77.44761904761904,"d":"77.4476"},null,{"v":77.44761904761904,"d":"77.4476"},64.6,{"v":100,"d":"100.0"},{"$nulls":3},{"v":78.75999999999999,"d":"78.8"},{"v":82.36293333333333,"d":"82.3629"},null,"否","是"]
["2021010445","耿智鸿","能化21-1班",99,45,25,29,95.84,{"v":97.104,"d":"97.1040"},null,null,{"v":1,"d":"1.00"},{"$nulls":3},{"v":98.104,"d":"98.1040"},{"v":0.38095238095238093,"d":"38.10%"},{"v":71.76595744680851,"d":"71.7660"},{"v":76.5,"d":"76.5000"},{"v":72.71276595744682,"d":"72.7128"},null,{"v":72.71276595744682,"d":"72.7128"},67.8,{"v":100,"d":"100.0"},{"$nulls":3},{"v":80.68,"d":"80.7"},{"v":78.58773617021278,"d":"78.5877"},null,"否","是"]
["2021010457","栾俊添","能化21-1班",99,45,25,29,95.84,{"v":97.104,"d":"97.1040"},null,null,{"v":4.2,"d":"4.20"},null,null,4,{"v":105.304,"d":"105.3040"},{"v":0.9473684210526315,"d":"94.74%"},{"v":87.73809523809524,"d":"87.7381"},{"v":90,"d":"90.0000"},{"v":88.19047619047619,"d":"88.1905"},{"$f":"8*2/3+5*2/3+4+4","v":{"v":16.666666666666664,"d":"16.6667"}},{"v":104.85714285714286,"d":"104.8571"},85.4,{"v":100,"d":"100.0"},{"$nulls":3},{"v":91.24000000000001,"d":"91.2"},{"v":103.58479999999999,"d":"103.5848"},null,"是","是"]
["2021010465","潘思迪","能化21-1班",96,42,25,29,95.84,{"v":95.904,"d":"95.9040"},null,null,{"v":6.666666666666667,"d":"6.67"},null,null,4,{"v":106.57066666666667,"d":"106.5707"},{"v":0.9523809523809523,"d":"95.24%"},{"v":86.44444444444444,"d":"86.4444"},{"v":89.5,"d":"89.5000"},{"v":87.05555555555556,"d":"87.0556"},12,{"v":99.05555555555556,"d":"99.0556"},71.7,{"v":100,"d":"100.0"},{"$nulls":3},{"v":83.02000000000001,"d":"83.0"},{"v":98.95502222222223,"d":"98.9550"},null,"是","是"]
["2021010482","王岩青","能化21-1班",99,45,25,29,{"v":96.26923076923077,"d":"96.27"},{"v":97.36153846153846,"d":"97.3615"},null,null,{"v":4,"d":"4.00"},{"v":2,"d":"2.0"},{"v":1.5,"d":"1.500"},null,{"v":104.86153846153846,"d":"104.8615"},{"v":0.42857142857142855,"d":"42.86%"},{"v":71.98969072164948,"d":"71.9897"},{"v":76.5,"d":"76.5000"},{"v":72.8917525773196,"d":"72.8918"},null,{"v":72.8917525773196,"d":"72.8918"},64.6,{"v":100,"d":"100.0"},null,{"$f":"5+2.5","v":{"v":7.5,"d":"8"}},null,{"v":86.25999999999999,"d":"86.3"},{"v":80.6225344964314,"d":"80.6225"},null,"是","是"]
["2021010493","李燕琴","能化21-1班",99,45,25,29,95.32,{"v":96.792,"d":"96.7920"},{"$nulls":6},{"v":96.792,"d":"96.7920"},{"v":0.34782608695652173,"d":"34.78%"},{"v":71.1743119266055,"d":"71.1743"},{"v":70,"d":"70.0000"},{"v":70.9394495412844,"d":"70.9394"},null,{"v":70.9394495412844,"d":"70.9394"},73.2,{"v":100,"d":"100.0"},{"$nulls":3},{"v":83.92,"d":"83.9"},{"v":77.4080146788991,"d":"77.4080"},null,"否","是"]
["2021010494","黄镜","能化21-1班",100,45,25,30,96.24,{"v":97.744,"d":"97.7440"},null,null,{"v":6,"d":"6.00"},null,null,3,{"v":106.744,"d":"106.7440"},{"v":0.21739130434782608,"d":"21.74%"},{"v":65.45714285714286,"d":"65.4571"},{"v":75,"d":"75.0000"},{"v":67.36571428571429,"d":"67.3657"},null,{"v":67.36571428571429,"d":"67.3657"},{"v":60,"d":"60.0"},{"v":100,"d":"100.0"},"免测",null,null,{"v":76,"d":"76.0"},76.1048,null,"否","是"]
["2021010496","解天羽","能化21-1班",99,45,25,29,95.16,{"v":96.696,"d":"96.6960"},{"$nulls":5},2,{"v":98.696,"d":"98.6960"},{"v":0.47368421052631576,"d":"47.37%"},{"v":74,"d":"74.0000"},{"v":80.5,"d":"80.5000"},{"v":75.30000000000001,"d":"75.3000"},null,{"v":75.30000000000001,"d":"75.3000"},63.3,{"v":100,"d":"100.0"},{"$nulls":3},{"v":77.97999999999999,"d":"78.0"},80.2472,null,"否","是"]
["2021010498","阿力木努·赛买提","能化21-1班",99,45,25,29,95.84,{"v":97.104,"d":"97.1040"},{"$nulls":6},{"v":97.104,"d":"97.1040"},{"v":0.4090909090909091,"d":"40.91%"},{"v":70.80851063829788,"d":"70.8085"},{"v":64,"d":"64.0000"},{"v":69.4468085106383,"d":"69.4468"},null,{"v":69.4468085106383,"d":"69.4468"},68.2,{"v":100,"d":"100.0"},{"$nulls":3},{"v":80.92,"d":"80.9"},{"v":76.12556595744681,"d":"76.1256"},null,"否","是"]
["2021010513","曹逸恒","能化21-1班",97,45,23,29,{"v":95.8,"d":"95.80"},{"v":96.28,"d":"96.2800"},{"$nulls":6},{"v":96.28,"d":"96.2800"},{"v":0.21739130434782608,"d":"21.74%"},{"v":61.052173913043475,"d":"61.0522"},{"v":69,"d":"69.0000"},{"v":62.641739130434786,"d":"62.6417"},null,{"v":62.641739130434786,"d":"62.6417"},{"v":34,"d":"34.0"},{"v":100,"d":"100.0"},{"$nulls":3},60.4,{"v":69.14521739130436,"d":"69.1452"},null,"否","否"]
["2021010514","曹哲仁","能化21-1班",99,45,25,29,{"v":96.2,"d":"96.20"},{"v":97.32,"d":"97.3200"},null,null,{"v":4,"d":"4.00"},null,null,2,{"v":103.32,"d":"103.3200"},{"v":0.8947368421052632,"d":"89.47%"},{"v":85.8452380952381,"d":"85.8452"},{"v":82,"d":"82.0000"},{"v":85.07619047619049,"d":"85.0762"},8.5,{"v":93.57619047619049,"d":"93.5762"},63.2,{"v":100,"d":"100.0"},{"$nulls":3},{"v":77.92,"d":"77.9"},{"v":93.95933333333335,"d":"93.9593"},null,"是","是"]
["2021010515","陈骄阳","能化21-1班",99,45,25,29,95.48,{"v":96.888,"d":"96.8880"},null,null,{"v":2,"d":"2.00"},{"$nulls":3},{"v":98.888,"d":"98.8880"},{"v":0.4,"d":"40.00%"},{"v":77.48913043478261,"d":"77.4891"},{"v":70.33333333333333,"d":"70.3333"},{"v":76.05797101449275,"d":"76.0580"},null,{"v":76.05797101449275,"d":"76.0580"},56.7,{"v":100,"d":"100.0"},{"$nulls":3},{"v":74.02000000000001,"d":"74.0"},{"v":80.42017971014492,"d":"80.4202"},null,"否","否"]
["2021010395","王浙","能化21-2班",100,45,25,30,{"v":98.92857142857143,"d":"98.93"},{"$f":"0.4*D33+H33*0.6","v":{"v":99.35714285714286,"d":"99.3571"}},null,null,{"v":4.4,"d":"4.40"},{"$nulls":3},{"$f":"I33+J33+K33+L33+M33+N33+O33","v":{"v":103.75714285714287,"d":"103.7571"}},{"v":0.9473684210526315,"d":"94.74%"},{"v":89.32142857142857,"d":"89.3214"},{"v":94,"d":"94.0000"},{"v":90.25714285714285,"d":"90.2571"},34,{"v":124.25714285714285,"d":"124.2571"},68.4,{"v":100,"d":"100.0"},{"$nulls":3},{"v":81.03999999999999,"d":"81.0"},{"v":115.83542857142857,"d":"115.8354"},null,"是","是"]
["2021010403","崔珈榕","能化21-2班",99,45,25,29,97.25,{"v":97.94999999999999,"d":"97.9500"},{"$nulls":6},{"v":97.94999999999999,"d":"97.9500"},{"v":0.3,"d":"30.00%"},{"v":68.74444444444444,"d":"68.7444"},{"v":77,"d":"77.0000"},{"v":70.39555555555556,"d":"70.3956"},null,{"v":70.39555555555556,"d":"70.3956"},{"v":62,"d":"62.0"},{"v":100,"d":"100.0"},{"$nulls":3},{"v":77.19999999999999,"d":"77.2"},{"v":76.5868888888889,"d":"76.5869"},null,"否","是"]
["2021010409","刘兴旺","能化21-2班",99,45,25,29,{"v":98.35714285714286,"d":"98.36"},{"v":98.61428571428571,"d":"98.6143"},null,null,{"v":2,"d":"2.00"},{"$nulls":3},{"v":100.61428571428571,"d":"100.6143"},{"v":0.2631578947368421,"d":"26.32%"},{"v":72.47619047619048,"d":"72.4762"},{"v":69.93333333333334,"d":"69.9333"},{"v":71.96761904761905,"d":"71.9676"},null,{"v":71.96761904761905,"d":"71.9676"},{"v":60,"d":"60.0"},{"v":100,"d":"100.0"},"补测",null,null,{"v":76,"d":"76.0"},{"v":78.10019047619048,"d":"78.1002"},null,"是","是"]
["2021010412","陈逸飞","能化21-2班",99,45,25,29,{"v":98.35714285714286,"d":"98.36"},{"v":98.61428571428571,"d":"98.6143"},null,null,{"v":3.2,"d":"3.20"},{"$nulls":3},{"v":101.81428571428572,"d":"101.8143"},{"v":0.5263157894736842,"d":"52.63%"},{"v":77.57142857142857,"d":"77.5714"},{"v":76.5,"d":"76.5000"},{"v":77.35714285714286,"d":"77.3571"},null,{"v":77.35714285714286,"d":"77.3571"},{"v":41,"d":"41.0"},{"v":100,"d":"100.0"},{"$nulls":3},64.6,{"v":80.97285714285715,"d":"80.9729"},null,"是","否"]
["2021010413","林云志","能化21-2班",99,45,25,29,{"v":98.46428571428571,"d":"98.46"},{"v":98.67857142857142,"d":"98.6786"},{"$nulls":6},{"v":98.67857142857142,"d":"98.6786"},{"v":0.22727272727272727,"d":"22.73%"},{"v":70.02884615384616,"d":"70.0288"},{"v":66,"d":"66.0000"},{"v":69.22307692307693,"d":"69.2231"},null,{"v":69.22307692307693,"d":"69.2231"},66.1,{"v":100,"d":"100.0"},{"$nulls":3},{"v":79.66,"d":"79.7"},{"v":76.15786813186813,"d":"76.1579"},null,"否","是"]
["2021010419","鲁鹤宇","能化21-2班",94,45,20,29,{"v":97.5,"d":"97.50"},{"v":96.1,"d":"96.1000"},{"$nulls":6},{"v":96.1,"d":"96.1000"},{"v":0.043478260869565216,"d":"4.35%"},{"v":49.509433962264154,"d":"49.5094"},{"v":27,"d":"27.0000"},{"v":45.007547169811325,"d":"45.0075"},null,{"v":45.007547169811325,"d":"45.0075"},{"v":20,"d":"20.0"},{"v":100,"d":"100.0"},{"$nulls":3},{"v":52,"d":"52.0"},{"v":55.92528301886792,"d":"55.9253"},null,"否","否"]
["2021010426","杨凯迪","能化21-2班",99,45,25,29,{"v":98.10714285714286,"d":"98.11"},{"v":98.46428571428572,"d":"98.4643"},{"$nulls":6},{"v":98.46428571428572,"d":"98.4643"},{"v":0.09090909090909091,"d":"9.09%"},{"v":61.77570093457944,"d":"61.7757"},{"v":68,"d":"68.0000"},{"v":63.02056074766356,"d":"63.0206"},null,{"v":63.02056074766356,"d":"63.0206"},54.8,{"v":100,"d":"100.0"},{"$nulls":3},{"v":72.88,"d":"72.9"},{"v":71.09524966622163,"d":"71.0952"},null,"否","否"]
["2021010427","张金坤","能化21-2班",99,45,25,29,{"v":98.14285714285714,"d":"98.14"},{"v":98.48571428571428,"d":"98.4857"},{"$nulls":6},{"v":98.48571428571428,"d":"98.4857"},{"v":0.35,"d":"35.00%"},{"v":72.08888888888889,"d":"72.0889"},{"v":77.5,"d":"77.5000"},{"v":73.17111111111112,"d":"73.1711"},null,{"v":73.17111111111112,"d":"73.1711"},60.3,{"v":100,"d":"100.0"},{"$nulls":3},{"v":76.18,"d":"76.2"},{"v":78.53492063492064,"d":"78.5349"},null,"否","是"]
["2021010439","吴晗毓","能化21-2班",99,45,25,29,{"v":98.60714285714286,"d":"98.61"},{"v":98.7642857142857,"d":"98.7643"},{"$nulls":6},{"v":98.7642857142857,"d":"98.7643"},{"v":0.5,"d":"50.00%"},{"v":75.44578313253012,"d":"75.4458"},{"v":74.5,"d":"74.5000"},{"v":75.2566265060241,"d":"75.2566"},null,{"v":75.2566265060241,"d":"75.2566"},{"v":60,"d":"60.0"},{"v":100,"d":"100.0"},"补测",null,null,{"v":76,"d":"76.0"},{"v":80.03249569707401,"d":"80.0325"},null,"否","是"]
["2021010450","周围","能化21-2班",99,45,25,29,{"v":99,"d":"99.00"},{"v":99,"d":"99.0000"},{"$nulls":6},{"v":99,"d":"99.0000"},{"v":0.43478260869565216,"d":"43.48%"},{"v":74.05102040816327,"d":"74.0510"},{"v":75.5,"d":"75.5000"},{"v":74.34081632653061,"d":"74.3408"},null,{"v":74.34081632653061,"d":"74.3408"},58.2,{"v":100,"d":"100.0"},{"$nulls":3},{"v":74.92,"d":"74.9"},{"v":79.33057142857143,"d":"79.3306"},null,"否","否"]
["2021010461","杨嘉琦","能化21-2班",99,45,25,29,{"v":98.85714285714286,"d":"98.86"},{"v":98.91428571428571,"d":"98.9143"},null,null,{"v":7.066666666666667,"d":"7.07"},null,null,3,{"v":108.98095238095237,"d":"108.9810"},{"v":0.6842105263157895,"d":"68.42%"},{"v":81.4047619047619,"d":"81.4048"},{"v":82,"d":"82.0000"},{"v":81.52380952380953,"d":"81.5238"},3,{"v":84.52380952380953,"d":"84.5238"},68.2,{"v":100,"d":"100.0"},{"$nulls":3},{"v":80.92,"d":"80.9"},{"v":89.05485714285714,"d":"89.0549"},null,"是","是"]
["2021010462","武晗","能化21-2班",99,45,25,29,{"v":98.35714285714286,"d":"98.36"},{"v":98.61428571428571,"d":"98.6143"},null,null,{"v":2,"d":"2.00"},{"$nulls":3},{"$f":"I44+J44+K44+L44+M44+N44+O44","v":{"v":100.61428571428571,"d":"100.6143"}},{"v":0.38095238095238093,"d":"38.10%"},{"v":71.3917525773196,"d":"71.3918"},{"v":84.5,"d":"84.5000"},{"v":74.01340206185569,"d":"74.0134"},null,{"v":74.01340206185569,"d":"74.0134"},63.4,{"v":100,"d":"100.0"},{"$nulls":3},{"v":78.03999999999999,"d":"78.0"},{"v":79.73623858615612,"d":"79.7362"},null,"否","是"]
["2021010464","周香格","能化21-2班",97,45,23,29,{"v":98.32142857142857,"d":"98.32"},{"v":97.79285714285714,"d":"97.7929"},{"$nulls":6},{"v":97.79285714285714,"d":"97.7929"},{"v":0.18181818181818182,"d":"18.18%"},{"v":66.2621359223301,"d":"66.2621"},{"v":78.2,"d":"78.2000"},{"v":68.64970873786409,"d":"68.6497"},null,{"v":68.64970873786409,"d":"68.6497"},70.6,{"v":100,"d":"100.0"},{"$nulls":3},{"v":82.35999999999999,"d":"82.4"},{"v":75.84936754507629,"d":"75.8494"},null,"否","是"]
["2021010466","程嘉欣","能化21-2班",100,45,25,30,{"v":99.39285714285714,"d":"99.39"},{"v":99.63571428571427,"d":"99.6357"},null,null,{"v":4.2,"d":"4.20"},{"$nulls":3},{"v":103.83571428571427,"d":"103.8357"},{"v":0.6190476190476191,"d":"61.90%"},{"v":80.1413043478261,"d":"80.1413"},{"v":86,"d":"86.0000"},{"v":81.31304347826088,"d":"81.3130"},null,{"v":81.31304347826088,"d":"81.3130"},76.4,{"v":100,"d":"100.0"},{"$nulls":3},{"v":85.84,"d":"85.8"},{"v":86.27027329192546,"d":"86.2703"},null,"是","是"]
["2021010467","颜伊宁","能化21-2班",99,45,25,29,{"v":98.89285714285714,"d":"98.89"},{"v":98.93571428571428,"d":"98.9357"},{"$nulls":6},{"v":98.93571428571428,"d":"98.9357"},{"v":0.6842105263157895,"d":"68.42%"},{"v":81.35714285714286,"d":"81.3571"},{"v":89.66666666666667,"d":"89.6667"},{"v":83.01904761904763,"d":"83.0190"},null,{"v":83.01904761904763,"d":"83.0190"},70.4,{"v":100,"d":"100.0"},{"$nulls":3},{"v":82.24000000000001,"d":"82.2"},{"v":86.12447619047619,"d":"86.1245"},null,"是","是"]
["2021010470","刘睿扬","能化21-2班",100,45,25,30,{"v":99.10714285714286,"d":"99.11"},{"v":99.46428571428572,"d":"99.4643"},null,null,{"v":6.2,"d":"6.20"},null,null,4,{"v":109.66428571428573,"d":"109.6643"},{"v":0.7142857142857143,"d":"71.43%"},{"v":81.30434782608695,"d":"81.3043"},{"v":92,"d":"92.0000"},{"v":83.44347826086957,"d":"83.4435"},4,{"v":87.44347826086957,"d":"87.4435"},{"v":60,"d":"60.0"},{"v":100,"d":"100.0"},"免测",null,null,{"v":76,"d":"76.0"},{"v":90.74329192546584,"d":"90.7433"},null,"是","是"]
["2021010471","柳子涵","能化21-2班",98,45,24,29,{"v":97.96428571428571,"d":"97.96"},{"v":97.97857142857143,"d":"97.9786"},{"$nulls":6},{"v":97.97857142857143,"d":"97.9786"},{"v":0.34782608695652173,"d":"34.78%"},{"v":67.87610619469027,"d":"67.8761"},{"v":81,"d":"81.0000"},{"v":70.50088495575221,"d":"70.5009"},null,{"v":70.50088495575221,"d":"70.5009"},62.6,{"v":100,"d":"100.0"},{"$nulls":3},{"v":77.56,"d":"77.6"},{"v":76.70233375474083,"d":"76.7023"},null,"否","是"]
["2021010475","蒲文博","能化21-2班",99,45,25,29,{"v":98.17857142857143,"d":"98.18"},{"v":98.50714285714287,"d":"98.5071"},{"$nulls":6},{"v":98.50714285714287,"d":"98.5071"},{"v":0.38095238095238093,"d":"38.10%"},{"v":73.5,"d":"73.5000"},{"v":80.5,"d":"80.5000"},{"v":74.9,"d":"74.9000"},null,{"v":74.9,"d":"74.9000"},60.2,{"v":100,"d":"100.0"},{"$nulls":3},{"v":76.12,"d":"76.1"},{"v":79.74342857142858,"d":"79.7434"},null,"是","是"]
["2021010476","齐翔龙","能化21-2班",97,45,23,29,{"v":98.78571428571429,"d":"98.79"},{"v":98.07142857142858,"d":"98.0714"},{"$nulls":6},{"v":98.07142857142858,"d":"98.0714"},{"v":0.32,"d":"32.00%"},{"v":67.00884955752213,"d":"67.0088"},{"v":77.66666666666667,"d":"77.6667"},{"v":69.14041297935104,"d":"69.1404"},null,{"v":69.14041297935104,"d":"69.1404"},55.2,{"v":100,"d":"100.0"},"补测",null,null,{"v":73.12,"d":"73.1"},{"v":75.32457479983144,"d":"75.3246"},null,"否","否"]
["2021010477","何余胜","能化21-2班",97,45,23,29,{"v":98.42857142857143,"d":"98.43"},{"v":97.85714285714286,"d":"97.8571"},{"$nulls":6},{"v":97.85714285714286,"d":"97.8571"},{"v":0.18181818181818182,"d":"18.18%"},{"v":62.49514563106796,"d":"62.4951"},{"v":74.66666666666667,"d":"74.6667"},{"v":64.92944983818771,"d":"64.9294"},null,{"v":64.92944983818771,"d":"64.9294"},57.9,{"v":100,"d":"100.0"},"补测",null,null,{"v":74.74,"d":"74.7"},{"v":72.49604345815996,"d":"72.4960"},null,"否","否"]
["2021010478","常一帆","能化21-2班",97,45,23,29,{"v":98.96428571428571,"d":"98.96"},{"v":98.17857142857142,"d":"98.1786"},null,null,{"v":2,"d":"2.00"},{"$nulls":3},{"v":100.17857142857142,"d":"100.1786"},{"v":0.19047619047619047,"d":"19.05%"},{"v":69.18556701030928,"d":"69.1856"},{"v":69,"d":"69.0000"},{"v":69.14845360824744,"d":"69.1485"},null,{"v":69.14845360824744,"d":"69.1485"},69.8,{"v":100,"d":"100.0"},{"$nulls":3},{"v":81.88,"d":"81.9"},{"v":76.62763181148749,"d":"76.6276"},null,"否","是"]
["2021010479","覃师凯","能化21-2班",100,45,25,30,{"v":98.82142857142857,"d":"98.82"},{"v":99.29285714285714,"d":"99.2929"},null,null,{"v":3.4,"d":"3.40"},0.5,null,3,{"v":106.19285714285715,"d":"106.1929"},{"v":0.38095238095238093,"d":"38.10%"},{"v":72.23913043478261,"d":"72.2391"},{"v":63,"d":"63.0000"},{"v":70.3913043478261,"d":"70.3913"},2,{"v":72.3913043478261,"d":"72.3913"},100.7,{"v":100,"d":"100.0"},null,null,25,{"$f":"W54*0.6+X54*0.4+Z54+AA54","v":{"v":125.42,"d":"125.4"}},{"v":84.4544844720497,"d":"84.4545"},null,"否","是"]
["2021010486","鹿麒麟","能化21-2班",100,45,25,30,{"v":99.89285714285714,"d":"99.89"},{"v":99.93571428571428,"d":"99.9357"},null,null,{"v":6.4,"d":"6.40"},null,1.875,4,{"v":112.21071428571429,"d":"112.2107"},{"v":1,"d":"100.00%"},{"v":94.39285714285714,"d":"94.3929"},{"v":97,"d":"97.0000"},{"v":94.91428571428573,"d":"94.9143"},35.5,{"v":130.4142857142857,"d":"130.4143"},79.4,{"v":100,"d":"100.0"},null,8,null,{"v":95.64,"d":"95.6"},{"v":123.29614285714284,"d":"123.2961"},null,"是","是"]
["2021010487","吴隆卓","能化21-2班",99,45,25,29,{"v":98.28571428571429,"d":"98.29"},{"v":98.57142857142858,"d":"98.5714"},{"$nulls":6},{"v":98.57142857142858,"d":"98.5714"},{"v":0.18181818181818182,"d":"18.18%"},{"v":67.04854368932038,"d":"67.0485"},{"v":80,"d":"80.0000"},{"v":69.63883495145632,"d":"69.6388"},null,{"v":69.63883495145632,"d":"69.6388"},40.8,{"v":100,"d":"100.0"},{"$nulls":3},{"v":64.47999999999999,"d":"64.5"},{"v":74.90947018030514,"d":"74.9095"},null,"否","否"]
["2021010492","左笑维","能化21-2班",99,45,25,29,{"v":98.89285714285714,"d":"98.89"},{"v":98.93571428571428,"d":"98.9357"},null,null,{"v":2,"d":"2.00"},{"$nulls":3},{"v":100.93571428571428,"d":"100.9357"},{"v":1,"d":"100.00%"},{"v":85.38095238095238,"d":"85.3810"},{"v":85,"d":"85.0000"},{"v":85.3047619047619,"d":"85.3048"},6,{"v":91.3047619047619,"d":"91.3048"},{"v":66,"d":"66.0"},{"v":100,"d":"100.0"},null,8,8,95.6,{"v":93.66047619047619,"d":"93.6605"},null,"是","是"]
["2021010501","陈湘宜","能化21-2班",99,45,25,29,{"v":98.96428571428571,"d":"98.96"},{"v":98.97857142857143,"d":"98.9786"},{"$nulls":6},{"v":98.97857142857143,"d":"98.9786"},{"v":0.3,"d":"30.00%"},{"v":73.08888888888889,"d":"73.0889"},{"v":91,"d":"91.0000"},{"v":76.67111111111112,"d":"76.6711"},null,{"v":76.67111111111112,"d":"76.6711"},{"v":53,"d":"53.0"},{"v":100,"d":"100.0"},{"$nulls":3},71.8,{"v":80.64549206349207,"d":"80.6455"},null,"是","否"]
["2021010502","王晨宣","能化21-2班",99,45,25,29,{"v":99.10714285714286,"d":"99.11"},{"v":99.06428571428572,"d":"99.0643"},{"$nulls":5},4,{"v":103.06428571428572,"d":"103.0643"},{"v":0.7894736842105263,"d":"78.95%"},{"v":81.63095238095238,"d":"81.6310"},{"v":93,"d":"93.0000"},{"v":83.9047619047619,"d":"83.9048"},null,{"v":83.9047619047619,"d":"83.9048"},64.7,{"v":100,"d":"100.0"},{"$nulls":3},{"v":78.82,"d":"78.8"},{"v":87.22819047619046,"d":"87.2282"},null,"是","是"]
["2021010506","陈国荣","能化21-2班",99,45,25,29,{"v":98,"d":"98.00"},{"v":98.4,"d":"98.4000"},{"$nulls":6},{"v":98.4,"d":"98.4000"},{"v":0.45454545454545453,"d":"45.45%"},{"v":78.7872340425532,"d":"78.7872"},{"v":73.5,"d":"73.5000"},{"v":77.72978723404256,"d":"77.7298"},null,{"v":77.72978723404256,"d":"77.7298"},66.8,{"v":100,"d":"100.0"},{"$nulls":3},{"v":80.08,"d":"80.1"},{"v":82.0988510638298,"d":"82.0989"},null,"是","是"]
["2021010521","王梓涵","能化21-2班",100,45,25,30,{"v":98.89285714285714,"d":"98.89"},{"v":99.33571428571429,"d":"99.3357"},null,null,{"v":3,"d":"3.00"},0.5,null,null,{"v":102.83571428571429,"d":"102.8357"},{"v":0.7368421052631579,"d":"73.68%"},{"v":83.66666666666667,"d":"83.6667"},{"v":91,"d":"91.0000"},{"v":85.13333333333334,"d":"85.1333"},null,{"v":85.13333333333334,"d":"85.1333"},67.2,{"v":100,"d":"100.0"},{"$nulls":3},{"v":80.32,"d":"80.3"},{"v":88.19247619047619,"d":"88.1925"},null,"是","是"]

{"sheet":"【德育】同学互评","index":1,"n_rows":59,"n_cols":3,"rows_kept":59,"merged":[[0,0,0,2]]}
["能化21级综测班内同学互评"]
["姓名","学号","互评分数"]
["李硕",2020010644,{"v":94.15384615384616,"d":"94.15"}]
["何若妍","2021010374",96.56]
["李传洋","2021010376",95.24]
["甘浩","2021010377",95.44]
["詹作鑫","2021010380",{"v":96.6,"d":"96.60"}]
["李维昊","2021010381",96.24]
["王理哲","2021010382",95.92]
["李洪博","2021010387",95.76]
["李臻彦","2021010389",95.88]
["苏辛一","2021010392",96.72]
["唐顾玮","2021010393",95.64]
["周忠康","2021010428",96.32]
["王医灵","2021010431",96.52]
["梁卓文","2021010432",95.88]
["朱佳怡","2021010433",95.96]
["裴俊豪","2021010442",95.56]
["鲍怡帅","2021010443",96.28]
["耿智鸿","2021010445",95.84]
["栾俊添","2021010457",95.84]
["潘思迪","2021010465",95.84]
["王岩青","2021010482",{"v":96.26923076923077,"d":"96.27"}]
["李燕琴","2021010493",95.32]
["黄镜","2021010494",96.24]
["解天羽","2021010496",95.16]
["阿力木努·赛买提","2021010498",95.84]
["曹逸恒","2021010513",{"v":95.8,"d":"95.80"}]
["曹哲仁","2021010514",{"v":96.2,"d":"96.20"}]
["陈骄阳","2021010515",95.48]
["王浙","2021010395",{"v":98.92857142857143,"d":"98.93"}]
["崔珈榕","2021010403",97.25]
["刘兴旺","2021010409",{"v":98.35714285714286,"d":"98.36"}]
["陈逸飞","2021010412",{"v":98.35714285714286,"d":"98.36"}]
["林云志","2021010413",{"v":98.46428571428571,"d":"98.46"}]
["鲁鹤宇","2021010419",{"v":97.5,"d":"97.50"}]
["杨凯迪","2021010426",{"v":98.10714285714286,"d":"98.11"}]
["张金坤","2021010427",{"v":98.14285714285714,"d":"98.14"}]
["吴晗毓","2021010439",{"v":98.60714285714286,"d":"98.61"}]
["周围","2021010450",{"v":99,"d":"99.00"}]
["杨嘉琦","2021010461",{"v":98.85714285714286,"d":"98.86"}]
["武晗","2021010462",{"v":98.35714285714286,"d":"98.36"}]
["周香格","2021010464",{"v":98.32142857142857,"d":"98.32"}]
["程嘉欣","2021010466",{"v":99.39285714285714,"d":"99.39"}]
["颜伊宁","2021010467",{"v":98.89285714285714,"d":"98.89"}]
["刘睿扬","2021010470",{"v":99.10714285714286,"d":"99.11"}]
["柳子涵","2021010471",{"v":97.96428571428571,"d":"97.96"}]
["蒲文博","2021010475",{"v":98.17857142857143,"d":"98.18"}]
["齐翔龙","2021010476",{"v":98.78571428571429,"d":"98.79"}]
["何余胜","2021010477",{"v":98.42857142857143,"d":"98.43"}]
["常一帆","2021010478",{"v":98.96428571428571,"d":"98.96"}]
["覃师凯","2021010479",{"v":98.82142857142857,"d":"98.82"}]
["鹿麒麟","2021010486",{"v":99.89285714285714,"d":"99.89"}]
["吴隆卓","2021010487",{"v":98.28571428571429,"d":"98.29"}]
["左笑维","2021010492",{"v":98.89285714285714,"d":"98.89"}]
["陈湘宜","2021010501",{"v":98.96428571428571,"d":"98.96"}]
["王晨宣","2021010502",{"v":99.10714285714286,"d":"99.11"}]
["陈国荣","2021010506",{"v":98,"d":"98.00"}]
["王梓涵","2021010521",{"v":98.89285714285714,"d":"98.89"}]

{"sheet":"【德育】学生职务","index":2,"n_rows":61,"n_cols":15,"rows_kept":61,"merged":[[0,0,0,14],[60,0,60,14]]}
["能化21级 大三学年学生职务加分汇总"]
["姓名","学号","班级","核分","中国石油大学（北京）红十字会","中国石油大学（北京）篮球协会","飞扬毽绳协会","管弦乐团","田径协会","陶笛社","化学爱好者协会","中石大辩论队","化成天下","班委、课代表、宿舍长加分","班委、课代表宿舍长备注"]
["李硕",2020010644,"能化21-1班"]
["何若妍","2021010374","能化21-1班",4,{"$nulls":9},4,"心理委员"]
["李传洋","2021010376","能化21-1班",1,{"$nulls":9},1,"能化设计基础课代表"]
["甘浩","2021010377","能化21-1班",2,{"$nulls":9},2,"宿舍长"]
["詹作鑫","2021010380","能化21-1班"]
["李维昊","2021010381","能化21-1班"]
["王理哲","2021010382","能化21-1班"]
["李洪博","2021010387","能化21-1班",2,{"$nulls":9},2,"宿舍长"]
["李臻彦","2021010389","能化21-1班"]
["苏辛一","2021010392","能化21-1班",6.2,{"$nulls":9},"6+1","班长，生产实习课代表"]
["唐顾玮","2021010393","能化21-1班"]
["周忠康","2021010428","能化21-1班"]
["王医灵","2021010431","能化21-1班",4.2,{"$nulls":9},"4+1","学习委员，化反课代表"]
["梁卓文","2021010432","能化21-1班"]
["朱佳怡","2021010433","能化21-1班"]
["裴俊豪","2021010442","能化21-1班",4,{"$nulls":9},4,"宣传委员"]
["鲍怡帅","2021010443","能化21-1班",4,{"$nulls":9},4,"生活委员"]
["耿智鸿","2021010445","能化21-1班",1,{"$nulls":9},1,"化工用能评价课代表"]
["栾俊添","2021010457","能化21-1班",{"$f":"4+0.2","v":{"v":4.2,"d":"4.20"}},{"$nulls":9},"4+1","体育委员，课代表"]
["潘思迪","2021010465","能化21-1班",{"$f":"M22","v":{"v":6.666666666666667,"d":"6.67"}},{"$nulls":8},{"$f":"10*2/3","v":{"v":6.666666666666667,"d":"6.67"}}]
["王岩青","2021010482","能化21-1班",{"$f":"H23","v":4},{"$nulls":3},4]
["李燕琴","2021010493","能化21-1班"]
["黄镜","2021010494","能化21-1班",6,{"$nulls":9},6,"团支书"]
["解天羽","2021010496","能化21-1班"]
["阿力木努·赛买提","2021010498","能化21-1班"]
["曹逸恒","2021010513","能化21-1班"]
["曹哲仁","2021010514","能化21-1班",4,{"$nulls":9},4,"副班长(组织委员)"]
["陈骄阳","2021010515","能化21-1班",2,{"$nulls":9},2,"宿舍长"]
["王浙",2021010395,"能化21-2班",4.4,{"$nulls":6},2,null,null,"4+1","生活委员、物化实验课代表"]
["崔珈榕",2021010403,"能化21-2班"]
["刘兴旺",2021010409,"能化21-2班",2,{"$nulls":9},2,"心理委员"]
["陈逸飞",2021010412,"能化21-2班",3.2,{"$nulls":9},"3+1","副班长、化原课设课代表"]
["林云志",2021010413,"能化21-2班"]
["鲁鹤宇",2021010419,"能化21-2班"]
["杨凯迪",2021010426,"能化21-2班"]
["张金坤",2021010427,"能化21-2班"]
["吴晗毓",2021010439,"能化21-2班"]
["周围",2021010450,"能化21-2班"]
["杨嘉琦",2021010461,"能化21-2班",{"$f":"E41+0.4","v":{"v":7.066666666666667,"d":"7.07"}},{"$f":"10*2/3","v":{"v":6.666666666666667,"d":"6.67"}},{"$nulls":8},2,"心理委员"]
["武晗",2021010462,"能化21-2班",2,{"$nulls":9},2,"宿舍长"]
["周香格",2021010464,"能化21-2班"]
["程嘉欣",2021010466,"能化21-2班",4.2,{"$nulls":9},"4+1+1","学习委员、化热+煤化工课代表"]
["颜伊宁",2021010467,"能化21-2班"]
["刘睿扬",2021010470,"能化21-2班",6.2,{"$nulls":9},"6+1","团支书、生产实习课代表"]
["柳子涵",2021010471,"能化21-2班"]
["蒲文博",2021010475,"能化21-2班"]
["齐翔龙",2021010476,"能化21-2班"]
["何余胜",2021010477,"能化21-2班"]
["常一帆",2021010478,"能化21-2班",2,{"$nulls":9},2,"宿舍长"]
["覃师凯",2021010479,"能化21-2班",{"$f":"3+G52*0.2","v":{"v":3.4,"d":"3.40"}},null,null,2,null,1,{"$nulls":4},"3+1","体育委员、化原课代表"]
["鹿麒麟",2021010486,"能化21-2班",{"$f":"6+2*0.2","v":6.4},{"$nulls":9},"6+2+1+1+1+1","班长、宿舍长、电工学+化工装备+能化设计基础+就业课代表"]
["吴隆卓",2021010487,"能化21-2班"]
["左笑维",2021010492,"能化21-2班",{"$f":"L55+F55*0.2","v":2},{"$nulls":7},{"v":2,"d":"2.0"}]
["陈湘宜",2021010501,"能化21-2班"]
["王晨宣",2021010502,"能化21-2班"]
["陈国荣",2021010506,"能化21-2班"]
["王梓涵",2021010521,"能化21-2班",3,{"$nulls":9},3,"宣传委员"]
[]
["注：正副主席、正副部长、部委加分全部按2/3折算；班级及各社团有担任两个班委职务的同学 第二项×0.2，只能累加2项，一个班有两个心理委员的班级 两人平分心委加分  课代表统一加1分 宿舍长加2分  "]

{"sheet":"【德育】学生职务附录","index":3,"n_rows":12,"n_cols":9,"rows_kept":12,"merged":[[0,0,0,8]]}
["化学工程学院加分情况"]
["社团名","姓名","职务","加分","学号","院系","专业","班级","分值"]
["中国石油大学（北京）篮球协会","左笑维","部委","兴趣类部委不加",2021010492,"化学工程与环境学院","能源化学工程","能化21-2班",4]
["飞扬毽绳协会","覃师凯","主席","兴趣类主席加2分不折算2/3",2021010479,"化学工程与环境学院","能源化学工程","能化21-2班",8]
["飞扬毽绳协会","鹿麒麟","部委","兴趣类部委不加",2021010486,"化学工程与环境学院","能源化学工程","能化21-2班",3]
["飞扬毽绳协会","栾俊添","部委","兴趣类部委不加",2021010457,"化学工程与环境学院","能源化学工程","能化21-1班",2]
["田径协会","覃师凯","部长","兴趣类部长加1分不折算2/3",2021010479,"化学工程与环境学院","能源化学工程","能化21-2班",6]
["陶笛社","栾俊添","部委","兴趣类部委不加",2021010457,"化学工程与环境学院","能源化学工程","能化21-1班",4]
["中石大辩论队","左笑维","主席","兴趣类主席加2分不折算2/3",2021010492,"化学工程与环境学院","能源化学工程","能化21-2班",10]
["中国石油大学（北京）红十字会","杨嘉琦","主席","功能性社团主席加10分折算2/3",2021010461,"化学工程与环境学院","能源化学工程","能化21-2班",10]
["管弦乐团","王岩青","团员","功能性社团团员加分折算2/3",2021010492,"化学工程与环境学院","能源化学工程","能化21-1班",6]
["化学爱好者协会","王浙","主席","兴趣类主席加2分不折算2/3",2021010461,"化学工程与环境学院","能源化学工程","能化21-2班",2]

{"sheet":"【德育】志愿时长","index":4,"n_rows":58,"n_cols":5,"rows_kept":58}
["学号","姓名","班级","时长","分数"]
[2020010644,"李硕","能化21-1班",{"v":0,"d":"0.0"},{"$f":"IF(D2>=48,\"4\",IF(D2>=36,\"3\",IF(D2>=24,\"2\",\"\")))","v":""}]
["2021010374","何若妍","能化21-1班",{"v":51,"d":"51.0"},"4"]
["2021010376","李传洋","能化21-1班",{"v":5,"d":"5.0"},""]
["2021010377","甘浩","能化21-1班",{"v":8,"d":"8.0"},""]
["2021010380","詹作鑫","能化21-1班",{"v":8,"d":"8.0"},""]
["2021010381","李维昊","能化21-1班",{"v":8,"d":"8.0"},""]
["2021010382","王理哲","能化21-1班",{"v":8,"d":"8.0"},""]
["2021010387","李洪博","能化21-1班",{"v":8,"d":"8.0"},""]
["2021010389","李臻彦","能化21-1班",{"v":8,"d":"8.0"},""]
["2021010392","苏辛一","能化21-1班",{"v":5,"d":"5.0"},""]
["2021010393","唐顾玮","能化21-1班",{"v":5,"d":"5.0"},""]
["2021010428","周忠康","能化21-1班",{"v":8,"d":"8.0"},""]
["2021010431","王医灵","能化21-1班",181.5,"4"]
["2021010432","梁卓文","能化21-1班",{"v":10,"d":"10.0"},""]
["2021010433","朱佳怡","能化21-1班",{"v":8,"d":"8.0"},""]
["2021010442","裴俊豪","能化21-1班",{"v":10,"d":"10.0"},""]
["2021010443","鲍怡帅","能化21-1班",{"v":10,"d":"10.0"},""]
["2021010445","耿智鸿","能化21-1班",{"v":8,"d":"8.0"},""]
["2021010457","栾俊添","能化21-1班",{"v":5,"d":"5.0"},""]
["2021010465","潘思迪","能化21-1班",{"v":77,"d":"77.0"},"4"]
["2021010482","王岩青","能化21-1班",{"v":8,"d":"8.0"},""]
["2021010493","李燕琴","能化21-1班",{"v":18,"d":"18.0"},""]
["2021010494","黄镜","能化21-1班",{"v":43,"d":"43.0"},"3"]
["2021010496","解天羽","能化21-1班",{"v":28,"d":"28.0"},"2"]
["2021010498","阿力木努·赛买提","能化21-1班",{"v":8,"d":"8.0"},""]
["2021010513","曹逸恒","能化21-1班",{"v":8,"d":"8.0"},""]
["2021010514","曹哲仁","能化21-1班",{"v":26,"d":"26.0"},"2"]
["2021010515","陈骄阳","能化21-1班",{"v":5,"d":"5.0"},""]
["2021010395","王浙","能化21-2班",{"v":3,"d":"3.0"},{"$f":"IF(D30>=48,\"4\",IF(D30>=36,\"3\",IF(D30>=24,\"2\",\"\")))","v":""}]
["2021010403","崔珈榕","能化21-2班",{"v":0,"d":"0.0"},{"$f":"IF(D31>=48,\"4\",IF(D31>=36,\"3\",IF(D31>=24,\"2\",\"\")))","v":""}]
["2021010409","刘兴旺","能化21-2班",{"v":4,"d":"4.0"},""]
["2021010412","陈逸飞","能化21-2班",{"v":5,"d":"5.0"},""]
["2021010413","林云志","能化21-2班",{"v":4,"d":"4.0"},""]
["2021010419","鲁鹤宇","能化21-2班",{"v":3,"d":"3.0"},""]
["2021010426","杨凯迪","能化21-2班",{"v":5,"d":"5.0"},""]
["2021010427","张金坤","能化21-2班",{"v":5,"d":"5.0"},""]
["2021010439","吴晗毓","能化21-2班",{"v":0,"d":"0.0"},""]
["2021010450","周围","能化21-2班",{"v":17,"d":"17.0"},""]
["2021010461","杨嘉琦","能化21-2班",{"v":46,"d":"46.0"},"3"]
["2021010462","武晗","能化21-2班",{"v":5,"d":"5.0"},""]
["2021010464","周香格","能化21-2班",{"v":4,"d":"4.0"},""]
["2021010466","程嘉欣","能化21-2班",{"v":12,"d":"12.0"},""]
["2021010467","颜伊宁","能化21-2班",{"v":5,"d":"5.0"},""]
["2021010470","刘睿扬","能化21-2班",{"v":49,"d":"49.0"},"4"]
["2021010471","柳子涵","能化21-2班",{"v":5,"d":"5.0"},""]
["2021010475","蒲文博","能化21-2班",{"v":3,"d":"3.0"},""]
["2021010476","齐翔龙","能化21-2班",{"v":3,"d":"3.0"},""]
["2021010477","何余胜","能化21-2班",{"v":2,"d":"2.0"},""]
["2021010478","常一帆","能化21-2班",{"v":0,"d":"0.0"},""]
["2021010479","覃师凯","能化21-2班",39.5,"3"]
["2021010486","鹿麒麟","能化21-2班",{"v":49,"d":"49.0"},"4"]
["2021010487","吴隆卓","能化21-2班",{"v":0,"d":"0.0"},""]
["2021010492","左笑维","能化21-2班",9.5,""]
["2021010501","陈湘宜","能化21-2班",{"v":4,"d":"4.0"},""]
["2021010502","王晨宣","能化21-2班",61.5,"4"]
["2021010506","陈国荣","能化21-2班",{"v":10,"d":"10.0"},""]
["2021010521","王梓涵","能化21-2班",{"v":0,"d":"0.0"},""]

{"sheet":"【智育】必修成绩","index":5,"n_rows":183,"n_cols":52,"rows_kept":183,"merged":[[1,0,2,2]]}
[]
[{"$nulls":3},"100305C001","100305L007","100305L008","100305P019","100305T032","100305T064","100305T075","100305T076","100305T081","100305T099","100305T109","100308P006","100308P009","100308T015","100308T016","100328T001","100328T005","100328T014","100513E006","100616M003","100616M005","100616M018","100616M019","100617L014","100617L025","100617L027","100617T005","100617T006","100617T059","100617T061","100627M012","100627M016","100627M017","101000T001","101099G045","101099M008","101099M010","101099M013","101300X003","101500X002"]
[{"$nulls":3},"化工应用软件","化工原理实验（Ⅰ）","化工原理实验（Ⅱ）","化工原理课程设计","化工装备与控制","化工热力学","化工原理（Ⅰ）","化工原理（Ⅱ）","生物化学","化学反应工程","化工安全与环保","能化认识实习","能化生产实习","煤化学转化工程","天然气处理与转化工程","化工用能评价","能源化工设计基础","石油加工工程","电工学及实验","线性代数","概率统计基础","高等数学B（Ⅰ）","高等数学B（Ⅱ）","有机化学实验","有机化学实验","物理化学实验（Ⅱ）","物理化学（Ⅰ）","物理化学（Ⅱ）","无机化学与分析化学","有机化学","大学物理C（Ⅱ）","大学物理实验B（Ⅰ）","大学物理实验B（Ⅱ）","项目管理与经济决策","专项运动训练课Ⅰ","大学体育必修（篮球）","大学体育必修（健美）","大学体育必修（健美操）","就业指导","入学教育与安全教育"]
["班级","学号","姓名",2,0.5,0.5,3,3,3.5,3.5,3.5,2,3.5,2,1.5,3,3,2,2,2,3,2,3,3,6,5,2,1,1,3,3,4,3.5,3,2,1.5,2,1,1,1,1,0.5,0]
["能化21-1班","2020010644","李硕","","","","","","35","62","12","61","","","","","","80","","","","","","69","53","","","","","60","","60","","","","87","","","","","","84",""]
["能化21-1班","2021010374","何若妍","91","90","95","92","95","84","","93","","90","97","","92","92","96","97","93","94","90","","","","","","","88","","","","","","","","93","","","","","89",""]
["能化21-1班","2021010376","李传洋","16 [16,16补1]","69","78","4","71 [53,71补1]","40 [40,40补1]","70","23 [23,23补1]","","33 [33,33补1]","82","","86","82","73 [50,73补1]","38 [38,38补1]","68 [36,68补1]","73","83","60","","65","63","","","87","","","","60","80","","","60","","","","","79",""]
["能化21-1班","2021010377","甘浩","60 [44,60补1]","73","69","72","73","46 [46,46补1]","","35 [35,35补1]","","70","77","","85","78","79","62 [52,62补1]","76","60","60","60","","","","","","80","","","","","","","","61","","","","","79",""]
["能化21-1班","2021010380","詹作鑫","70","77","81","78","86","60","","68","","77","78","","91","73","93","74","79","81","70","","","","","","","83","","79","","","","","","74","","","","","84",""]
["能化21-1班","2021010381","李维昊","60","76","68","63","65","58 [46,58补1]","63","62","","50 [50,50补1]","71","","86","80","71","60","63","72","66 [51,66补1]","56","","","","","","82","","","28","","","","","65","","","","","83",""]
["能化21-1班","2021010382","王理哲","60","81","71","84","77","61","","63","","63 [53,63补1]","81","","90","76","77","62","70","69","63 [51,63补1]","56","","","","","","80","","","","","","","","66","","","","","87",""]
["能化21-1班","2021010387","李洪博","60","74","70","78","67","61","72","61","","61","77","","83","80","68","62 [53,62补1]","63","70","61","","","","63","79","","78","","61","","","","80","","61","","","","","85",""]
["能化21-1班","2021010389","李臻彦","60 [48,60补1]","80","82","82","71","67","","49 [39,49补1]","","60","81","","80","86","74","75","66","75","60","","","","","","","75","71","","","","","72","","76","","","","","84",""]
["能化21-1班","2021010392","苏辛一","60","76","71","61","66","49 [41,49补1]","67","19","","60","66","","76","81","78","60","67","73","60 [49,60补1]","46","","","","","","75","","55","","","","25","","61","","","","","79",""]
["能化21-1班","2021010393","唐顾玮","49 [49,49补1]","71","75","76","79","62","","60","","60","81","","78","78","80","60","71","74","70","60","","","","","","78","","","","","","79","","62","","","","","82",""]
["能化21-1班","2021010428","周忠康","80","82","87","88","86","70","","80","","67","87","","92","82","88","79","78","79","62","","","","","","","88","","","","","","89","","85","","","","","81",""]
["能化21-1班","2021010431","王医灵","83","76","85","73","93","72","","84","","78","88","","91","94","95","91","83","81","73","","","","","","","87","","","","","","","","84","","","","","",""]
["能化21-1班","2021010432","梁卓文","75","77","85","91","85","74","","80","","70","80","","90","82","91","74","71","67","71","74","","","","79","","83","","","","","","","","79","","","","","89",""]
["能化21-1班","2021010433","朱佳怡","38 [38,38补1]","75","73","70","61","57 [50,57补1]","","49 [37,49补1]","","61","76","","84","84","83","88 [51,88补1]","64","69","80 [54,80补1]","57","","","","73","","71","","","","","","","","76","","","","","85",""]
["能化21-1班","2021010442","裴俊豪","92","84","91","91","93","84","","89","","87","94","","93","92","91","93","79","91","85","","","","","","","90","","","","","","90","","90","","","","","92",""]
["能化21-1班","2021010443","鲍怡帅","86","80","80","85","85","65 [54,65补1]","","67","","60","71","","93","88","95","75","76","82","74","","","","","","","85","","","","","","","","83","","","","","87",""]
["能化21-1班","2021010445","耿智鸿","60","75","75","81","69","57 [46,57补1]","","62 [53,62补1]","","79 [54,79补1]","81","","84","81","71","71","75","70","76","61","","","","","","87","","","","","","86","","85","","","","","87",""]
["能化21-1班","2021010457","栾俊添","92","85","93","83","92","82","","88","","86","92","","90","91","95","90","83","87","77","","","","","","","91","","","","","","","","88","","","","","92",""]
["能化21-1班","2021010465","潘思迪","80","85","93","89","91","86","","87","","83","89","","88","90","81","94","75","88","80","","","","","","90","87","","","","","","87","","86 [86缓1]","","","","","92",""]
["能化21-1班","2021010482","王岩青","91","85","92","85","78","60","60","61","","67","80","","85","83","66","62","79","68","65","","","","","","","86","","62","","","","","","68","","","","","88",""]
["能化21-1班","2021010493","李燕琴","60","82","76","82","71","68","72","62","","55 [55,55补1]","71","","88","83","69","60 [45,60补1]","69","73","63","","","66 [66缓1]","","83","","91","","","","","","","","70","","","90","","85",""]
["能化21-1班","2021010494","黄镜","64","79","75","71","75","50 [46,50补1]","54","62","","55 [44,55补1]","76","","83","86","75","52 [34,52补1]","65","69","60","47","","","","","","84","","57","","","","","","64","","","","82","88",""]
["能化21-1班","2021010496","解天羽","60","84","87","87","79","63","","56 [56,56补1]","","62","78","","85","79","84","66","66","80","89","","","","","","","91","","","","","","","","69","","","","","88",""]
["能化21-1班","2021010498","阿力木努·赛买提","65","84","83","78","70","61","","56","","55","78","","82","87","77","60","65","72","48","","","","","83","","86","","","","","","88","","67","","","","84","87",""]
["能化21-1班","2021010513","曹逸恒","71","83","69","80","75","44 [36,44补1]","43","40 [40,40补1]","","54 [52,54补1]","80","","76","60","64","63","60","68","60","56","","53","","","","86","","63","","","","","","63","","","","","82",""]
["能化21-1班","2021010514","曹哲仁","83","91","88","77","92","83","","96","","86","92","","85","79","89","87","80","83","89","","","","","","","89","","","","","","","","84","","","","","87",""]
["能化21-1班","2021010515","陈骄阳","70","86","85","78","75","71","","74","","72","82","","87","75","83","77","81 [55,81补1]","82","75","","","","","","","88","","","79","","","","","79","","","","","85",""]
["能化21-2班","2021010395","王浙","96","94","91","88","95","82","","96","","83","92","","94","92","92","87","75","89","87","","","","","","","84","","","","","","","","92","","","","","91",""]
["能化21-2班","2021010403","崔珈榕","63","72","73","82","72","56 [46,56补1]","","46 [46,46补1]","","68 [52,68补1]","84","","79","82","82","60","70","72","60","","","","","","","80","","61","","","","","","75","","","","","84",""]
["能化21-2班","2021010409","刘兴旺","62","85","80","81","74","60","","75","","70","74","","88","79","77","60","72","69","61","","","","","","","79","","","","","","","","70","","","","","80",""]
["能化21-2班","2021010412","陈逸飞","61","81","86","84","81","66","","82","","77","75","","88","83","79","64","75","78","70","","","","","","","80","","","","","","","","87","","","","","86",""]
["能化21-2班","2021010413","林云志","60","66","77","77","67","63","","66","","67 [52,67补1]","73","","87","86","70","61","67","71","67","","","","60","","","80","","","","","76","86","","63","","","","","85",""]
["能化21-2班","2021010419","鲁鹤宇","33 [33,33补1]","75","75","9","70","34 [34,34补1]","","42 [42,42补1]","","45 [45,45补1]","74","69","21","76","53 [53,53补1]","61","66","66","50 [50,50补1]","","","47","","","","78","","","","","","11","47","63","","","","","87",""]
["能化21-2班","2021010426","杨凯迪","60","66","74","74","69","39","70","38","","63 [49,63补1]","71","","82","74","65","35 [35,35补1]","65","66","60","","","","51","","","78","","69","","","","","","61","","","","","83",""]
["能化21-2班","2021010427","张金坤","70","84","70","64","67","63","","60","","81 [55,81补1]","71","","91","81","85","61","71","71","71","69","","","","","","80","","","","","","","","82","","","","","86",""]
["能化21-2班","2021010439","吴晗毓","75","86","","82","85","61","","64","","61","82","","89","80","77","86","69","73","77","","","","","","","84","","","","","","","","74","","","","","92",""]
["能化21-2班","2021010450","周围","72","83","89","80","72","58 [51,58补1]","","67","","72","76","","88","91","83","65 [50,65补1]","73","70","60","","","","","79","","80","","67","","","","84","","76","","","","","86","85"]
["能化21-2班","2021010461","杨嘉琦","82","90","84","88","88","70","","76","","75","80","","89","86","97","87","71","79","71","","","","","","","85","","","","","","","","81","","","","","91",""]
["能化21-2班","2021010462","武晗","60","89","86","78","84","52 [52,52补1]","60","71","","61","85","","79","80","80","68","68","70","75","","","","","","","84","","","","","64","","","79","","","","","84",""]
["能化21-2班","2021010464","周香格","60 [50,60补1]","75","77","68","77","60","60","52 [48,52补1]","","60","73","","82","83","70","63 [45,63补1]","64","62","68","50","","","","","","83","","62","","","","","","79","","","","","83",""]
["能化21-2班","2021010466","程嘉欣","72","90","91","87","87","64","","62","","70","89","","89","91","77","86","79","79","75","","","","","86","","86","","","","","","87","","89 [89缓1]","","","","","90",""]
["能化21-2班","2021010467","颜伊宁","74","91","92","86","87","64","","82","","73","87","","89","87","83","89","75","79","79","","","","","","","84","","","","","","","","86","","","","","90",""]
["能化21-2班","2021010470","刘睿扬","80","91","92","85","90","62","","75","","67","84","","87","88","95","88","77","88","71","","","","","85","","83","","","","","","87","","79","","","","","91",""]
["能化21-2班","2021010471","柳子涵","72","81","90","80","83","49 [44,49补1]","55","62","","60","79","","87","78","67","60","65","78","75","55","","","56","","","81","","51","","","","","","91","","","","","87",""]
["能化21-2班","2021010475","蒲文博","70","84","73","84","82","61","","66","","66","70","","85","80","68","60","76","75","62","74","","","","","","85","","","","","","","","77","95","","","","82",""]
["能化21-2班","2021010476","齐翔龙","66","81","83","72","78","51 [46,51补1]","41","63","","66 [50,66补1]","66","","83","81","74 [56,74补1]","47 [47,47补1]","74","74","61","60","","","","85","","83","","","","","56","85","","78","","70","","","85",""]
["能化21-2班","2021010477","何余胜","62 [50,62补1]","72","79","78","69","36 [34,36补1]","37","39 [39,39补1]","","60 [52,60补1]","73","","83","73","80","60","70","68","61","55","","","","","","82","","60","","","","","","75","","","","","86",""]
["能化21-2班","2021010478","常一帆","68","78","82","71","72","55 [55,55补1]","58","68","","61","78","","79","75","72","67","70","72","80","","","","","","","80","","60","","","","","","75","","","","","83",""]
["能化21-2班","2021010479","覃师凯","70","73","81","73","67","62 [54,62补1]","","60 [49,60补1]","","69 [51,69补1]","82","","88","79","83","60","66","69","72","69","","","","","","90","","","","","","","","90","100","","","","90",""]
["能化21-2班","2021010486","鹿麒麟","99","96","94","94","97","87","","97","","90","93","","96","95","99","100","96","94","87","","","","","","","92","","","","","","","","97","","","","","97",""]
["能化21-2班","2021010487","吴隆卓","65","72","66","76","67","54 [50,54补1]","67","43 [36,43补1]","","62","75","","85","78","84","60","69","71","61","63","","","","","","84","","60","","","","","","69","","","","","86",""]
["能化21-2班","2021010492","左笑维","93","88","90","85","83","81","","92","","80","88","","84","88","85","95","87","83","81","","","","","","","80","","","","","","","","87","","","","","91",""]
["能化21-2班","2021010501","陈湘宜","62","79","85","83","75","60","","66","","60","78","","88","83","71","67","68","79","67","75","","","","","","81","","","","","","","","79","","","","","84",""]
["能化21-2班","2021010502","王晨宣","71","88","82","81","87","71","","80","","71","84","","90","84","93","93","82","86","72","","","","","","","82","","","","","","","","84","","","","","85",""]
["能化21-2班","2021010506","陈国荣","80","84","84","78","75","72","","86","","73","76","","82","84","78","76","76","77","76","","","","","76","","80","","","","","","79","","84","96","","","","89",""]
["能化21-2班","2021010521","王梓涵","81","80","85","74","90","72","","85","","76","85","","92","91","92","94","77","79","86","","","","","","","81","","","","","","","","91","","","","","90",""]
[]
[]
[{"$nulls":3},"100305C001","100305L007","100305L008","100305P019","100305T032","100305T064","100305T075","100305T076","100305T081","100305T099","100305T109","100308P006","100308P009","100308T015","100308T016","100328T001","100328T005","100328T014",{"v":100513000000,"d":"1.01E+11"},"100616M003","100616M005","100616M018","100616M019","100617L014","100617L025","100617L027","100617T005","100617T006","100617T059","100617T061","100627M012","100627M016","100627M017","101000T001","101099G045","101099M008","101099M010","101099M013","101300X003","101500X002"]
[{"$nulls":3},"化工应用软件","化工原理实验（Ⅰ）","化工原理实验（Ⅱ）","化工原理课程设计","化工装备与控制","化工热力学","化工原理（Ⅰ）","化工原理（Ⅱ）","生物化学","化学反应工程","化工安全与环保","能化认识实习","能化生产实习","煤化学转化工程","天然气处理与转化工程","化工用能评价","能源化工设计基础","石油加工工程","电工学及实验","线性代数","概率统计基础","高等数学B（Ⅰ）","高等数学B（Ⅱ）","有机化学实验","有机化学实验","物理化学实验（Ⅱ）","物理化学（Ⅰ）","物理化学（Ⅱ）","无机化学与分析化学","有机化学","大学物理C（Ⅱ）","大学物理实验B（Ⅰ）","大学物理实验B（Ⅱ）","项目管理与经济决策","专项运动训练课Ⅰ","大学体育必修（篮球）","大学体育必修（健美）","大学体育必修（健美操）","就业指导","入学教育与安全教育"]
["班级","学号","姓名",{"v":2,"d":"2.0"},0.5,0.5,{"v":3,"d":"3.0"},{"v":3,"d":"3.0"},3.5,3.5,3.5,{"v":2,"d":"2.0"},3.5,{"v":2,"d":"2.0"},1.5,{"v":3,"d":"3.0"},{"v":3,"d":"3.0"},{"v":2,"d":"2.0"},{"v":2,"d":"2.0"},{"v":2,"d":"2.0"},{"v":3,"d":"3.0"},{"v":2,"d":"2.0"},{"v":3,"d":"3.0"},{"v":3,"d":"3.0"},{"v":6,"d":"6.0"},{"v":5,"d":"5.0"},{"v":2,"d":"2.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":3,"d":"3.0"},{"v":3,"d":"3.0"},{"v":4,"d":"4.0"},3.5,{"v":3,"d":"3.0"},{"v":2,"d":"2.0"},1.5,{"v":2,"d":"2.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},0.5,{"v":0,"d":"0.0"},"必修门数","优良门数","必修课优良率","必修课学分绩","所修总学分","必修课加权平均分"," 挂科门数","是否可以评选奖学金","备注原因"]
["能化21-1班",2020010644,"李硕",{"$nulls":5},35,62,12,61,{"$nulls":5},80,{"$nulls":5},69,53,{"$nulls":4},60,null,60,{"$nulls":3},87,{"$nulls":5},84,null,{"$f":"COUNTA(D67:AQ67)","v":11},{"$f":"COUNTIF(D67:AQ67,\">=80\")","v":3},{"$f":"AS67/AR67","v":{"v":0.2727272727272727,"d":"27.27%"}},{"v":1781,"d":"1781.0"},{"$f":"SUMIF(D67:AQ67,\">0\",$D$66:$AQ$66)","v":32.5},{"$f":"AU67/AV67","v":{"v":54.8,"d":"54.800"}},{"$f":"COUNTIF(D67:AQ67,\"<60\")","v":{"v":3,"d":"3.0"}},{"$f":"IF(AX67=0,\"是\",\"否\")","v":"否"}]
["能化21-1班",2021010374,"何若妍",91,90,95,92,95,84,null,93,null,90,97,null,92,92,96,97,93,94,90,{"$nulls":6},88,{"$nulls":7},93,{"$nulls":4},89,null,19,19,{"$f":"AS68/AR68","v":{"v":1,"d":"100.00%"}},3868.5,{"$f":"SUMIF(D68:AQ68,\">0\",$D$66:$AQ$66)","v":{"v":42,"d":"42.0"}},{"$f":"AU68/AV68","v":{"v":92.10714285714286,"d":"92.107"}},{"$f":"COUNTIF(D68:AQ68,\"<60\")","v":{"v":0,"d":"0.0"}},{"$f":"IF(AX68=0,\"是\",\"否\")","v":"是"}]
["能化21-1班",2021010376,"李传洋",16,69,78,4,60,40,70,23,null,33,82,null,86,82,60,38,60,73,83,60,null,65,63,null,null,87,{"$nulls":3},60,80,null,null,60,{"$nulls":4},79,null,25,6,{"v":0.24,"d":"24.00%"},{"v":3829,"d":"3829.0"},{"v":66,"d":"66.0"},{"v":58.015151515151516,"d":"58.015"},{"v":6,"d":"6.0"},"否"]
["能化21-1班",2021010377,"甘浩",60,73,69,72,73,46,null,35,null,70,77,null,85,78,79,60,76,60,60,60,{"$nulls":5},80,{"$nulls":7},61,{"$nulls":4},79,null,20,2,{"v":0.1,"d":"10.00%"},{"v":2949,"d":"2949.0"},{"v":45,"d":"45.0"},{"v":65.53333333333333,"d":"65.533"},{"v":2,"d":"2.0"},"否"]
["能化21-1班",2021010380,"詹作鑫",70,77,81,78,86,60,null,68,null,77,78,null,91,73,93,74,79,81,70,{"$nulls":6},83,null,79,{"$nulls":5},74,{"$nulls":4},84,null,20,7,{"v":0.35,"d":"35.00%"},3461.5,{"v":45,"d":"45.0"},{"v":76.92222222222222,"d":"76.922"},{"v":0,"d":"0.0"},"是"]
["能化21-1班",2021010381,"李维昊",60,76,68,63,65,58,63,62,null,50,71,null,86,80,71,60,63,72,60,56,{"$nulls":5},82,null,null,28,{"$nulls":4},65,{"$nulls":4},83,null,22,4,{"v":0.18181818181818182,"d":"18.18%"},{"v":3289,"d":"3289.0"},52.5,{"v":62.647619047619045,"d":"62.648"},{"v":4,"d":"4.0"},"否"]
["能化21-1班",2021010382,"王理哲",60,81,71,84,77,61,null,63,null,60,81,null,90,76,77,62,70,69,60,56,{"$nulls":5},80,{"$nulls":7},66,{"$nulls":4},87,null,20,6,{"v":0.3,"d":"30.00%"},3151.5,{"v":45,"d":"45.0"},{"v":70.03333333333333,"d":"70.033"},{"v":1,"d":"1.0"},"否"]
["能化21-1班",2021010387,"李洪博",60,74,70,78,67,61,72,61,null,61,77,null,83,80,68,60,63,70,61,{"$nulls":3},63,79,null,78,null,61,{"$nulls":3},80,null,61,{"$nulls":4},85,null,24,4,{"v":0.16666666666666666,"d":"16.67%"},{"v":3935,"d":"3935.0"},57.5,{"v":68.43478260869566,"d":"68.435"},{"v":0,"d":"0.0"},"是"]
["能化21-1班",2021010389,"李臻彦",60,80,82,82,71,67,null,49,null,60,81,null,80,86,74,75,66,75,60,{"$nulls":6},75,71,{"$nulls":4},72,null,76,{"$nulls":4},84,null,21,7,{"v":0.3333333333333333,"d":"33.33%"},{"v":3337,"d":"3337.0"},{"v":47,"d":"47.0"},{"v":71,"d":"71.000"},{"v":1,"d":"1.0"},"否"]
["能化21-1班",2021010392,"苏辛一",60,76,71,61,66,49,67,19,null,60,66,null,76,81,78,60,67,73,60,46,{"$nulls":5},75,null,55,{"$nulls":3},25,null,61,{"$nulls":4},79,null,23,1,{"v":0.043478260869565216,"d":"4.35%"},3198.5,53.5,{"v":59.78504672897196,"d":"59.785"},{"v":5,"d":"5.0"},"否"]
["能化21-1班",2021010393,"唐顾玮",49,71,75,76,79,62,null,60,null,60,81,null,78,78,80,60,71,74,70,60,{"$nulls":5},78,{"$nulls":5},79,null,62,{"$nulls":4},82,null,21,3,{"v":0.14285714285714285,"d":"14.29%"},{"v":3268,"d":"3268.0"},{"v":47,"d":"47.0"},{"v":69.53191489361703,"d":"69.532"},{"v":1,"d":"1.0"},"否"]
["能化21-1班",2021010428,"周忠康",80,82,87,88,86,70,null,80,null,67,87,null,92,82,88,79,78,79,62,{"$nulls":6},88,{"$nulls":5},89,null,85,{"$nulls":4},81,null,20,14,{"v":0.7,"d":"70.00%"},3549.5,{"v":44,"d":"44.0"},{"v":80.67045454545455,"d":"80.670"},{"v":0,"d":"0.0"},"是"]
["能化21-1班",2021010431,"王医灵",83,76,85,73,93,72,null,84,null,78,88,null,91,94,95,91,83,81,73,{"$nulls":6},87,{"$nulls":7},84,{"$nulls":6},18,13,{"v":0.7222222222222222,"d":"72.22%"},3476.5,41.5,{"v":83.7710843373494,"d":"83.771"},{"v":0,"d":"0.0"},"是"]
["能化21-1班",2021010432,"梁卓文",75,77,85,91,85,74,null,80,null,70,80,null,90,82,91,74,71,67,71,74,{"$nulls":3},79,null,83,{"$nulls":7},79,{"$nulls":4},89,null,21,10,{"v":0.47619047619047616,"d":"47.62%"},3699.5,{"v":47,"d":"47.0"},{"v":78.7127659574468,"d":"78.713"},{"v":0,"d":"0.0"},"是"]
["能化21-1班",2021010433,"朱佳怡",38,75,73,70,61,57,null,49,null,61,76,null,84,84,83,75,64,69,75,57,{"$nulls":3},73,null,71,{"$nulls":7},76,{"$nulls":4},85,null,21,4,{"v":0.19047619047619047,"d":"19.05%"},{"v":3167,"d":"3167.0"},{"v":47,"d":"47.0"},{"v":67.38297872340425,"d":"67.383"},{"v":4,"d":"4.0"},"否"]
["能化21-1班",2021010442,"裴俊豪",92,84,91,91,93,84,null,89,null,87,94,null,93,92,91,93,79,91,85,{"$nulls":6},90,{"$nulls":5},90,null,90,{"$nulls":4},92,null,20,19,{"v":0.95,"d":"95.00%"},3941.5,{"v":44,"d":"44.0"},{"v":89.57954545454545,"d":"89.580"},{"v":0,"d":"0.0"},"是"]
["能化21-1班",2021010443,"鲍怡帅",86,80,80,85,85,60,null,67,null,60,71,null,93,88,95,75,76,82,74,{"$nulls":6},85,{"$nulls":7},83,{"$nulls":4},87,null,19,12,{"v":0.631578947368421,"d":"63.16%"},{"v":3282,"d":"3282.0"},{"v":42,"d":"42.0"},{"v":78.14285714285714,"d":"78.143"},{"v":0,"d":"0.0"},"否","化工热力学第一次正考未通过"]
["能化21-1班",2021010445,"耿智鸿",60,75,75,81,69,57,null,60,null,60,81,null,84,81,71,71,75,70,76,61,{"$nulls":5},87,{"$nulls":5},86,null,85,{"$nulls":4},87,null,21,8,{"v":0.38095238095238093,"d":"38.10%"},{"v":3373,"d":"3373.0"},{"v":47,"d":"47.0"},{"v":71.76595744680851,"d":"71.766"},{"v":1,"d":"1.0"},"否"]
["能化21-1班",2021010457,"栾俊添",92,85,93,83,92,82,null,88,null,86,92,null,90,91,95,90,83,87,77,{"$nulls":6},91,{"$nulls":7},88,{"$nulls":4},92,null,19,18,{"v":0.9473684210526315,"d":"94.74%"},{"v":3685,"d":"3685.0"},{"v":42,"d":"42.0"},{"v":87.73809523809524,"d":"87.738"},{"v":0,"d":"0.0"},"是"]
["能化21-1班",2021010465,"潘思迪",80,85,93,89,91,86,null,87,null,83,89,null,88,90,81,94,75,88,80,{"$nulls":5},90,87,{"$nulls":5},87,null,86,{"$nulls":4},92,null,21,20,{"v":0.9523809523809523,"d":"95.24%"},{"v":3890,"d":"3890.0"},{"v":45,"d":"45.0"},{"v":86.44444444444444,"d":"86.444"},{"v":0,"d":"0.0"},"是"]
["能化21-1班",2021010482,"王岩青",91,85,92,85,78,60,60,61,null,67,80,null,85,83,66,62,79,68,65,{"$nulls":6},86,null,62,{"$nulls":5},68,{"$nulls":4},88,null,21,9,{"v":0.42857142857142855,"d":"42.86%"},3491.5,48.5,{"v":71.98969072164948,"d":"71.990"},{"v":0,"d":"0.0"},"是"]
["能化21-1班",2021010493,"李燕琴",60,82,76,82,71,68,72,62,null,55,71,null,88,83,69,60,69,73,63,null,null,66,null,83,null,91,{"$nulls":7},70,null,null,90,null,85,null,23,8,{"v":0.34782608695652173,"d":"34.78%"},{"v":3879,"d":"3879.0"},54.5,{"v":71.1743119266055,"d":"71.174"},{"v":1,"d":"1.0"},"否"]
["能化21-1班",2021010494,"黄镜",64,79,75,71,75,50,54,62,null,55,76,null,83,86,75,52,65,69,60,47,{"$nulls":5},84,null,57,{"$nulls":5},64,{"$nulls":3},82,88,null,23,5,{"v":0.21739130434782608,"d":"21.74%"},3436.5,52.5,{"v":65.45714285714286,"d":"65.457"},{"v":6,"d":"6.0"},"否"]
["能化21-1班",2021010496,"解天羽",60,84,87,87,79,63,null,56,null,62,78,null,85,79,84,66,66,80,89,{"$nulls":6},91,{"$nulls":7},69,{"$nulls":4},88,null,19,9,{"v":0.47368421052631576,"d":"47.37%"},{"v":3108,"d":"3108.0"},{"v":42,"d":"42.0"},{"v":74,"d":"74.000"},{"v":1,"d":"1.0"},"否"]
["能化21-1班",2021010498,"阿力木努·赛买提",65,84,83,78,70,61,null,56,null,55,78,null,82,87,77,60,65,72,48,{"$nulls":4},83,null,86,{"$nulls":5},88,null,67,{"$nulls":3},84,87,null,22,9,{"v":0.4090909090909091,"d":"40.91%"},{"v":3328,"d":"3328.0"},{"v":47,"d":"47.0"},{"v":70.80851063829788,"d":"70.809"},{"v":3,"d":"3.0"},"否"]
["能化21-1班",2021010513,"曹逸恒",71,83,69,80,75,44,43,40,null,54,80,null,76,60,64,63,60,68,60,56,null,53,{"$nulls":3},86,null,63,{"$nulls":5},63,{"$nulls":4},82,null,23,5,{"v":0.21739130434782608,"d":"21.74%"},3510.5,57.5,{"v":61.052173913043475,"d":"61.052"},{"v":6,"d":"6.0"},"否"]
["能化21-1班",2021010514,"曹哲仁",83,91,88,77,92,83,null,96,null,86,92,null,85,79,89,87,80,83,89,{"$nulls":6},89,{"$nulls":7},84,{"$nulls":4},87,null,19,17,{"v":0.8947368421052632,"d":"89.47%"},3605.5,{"v":42,"d":"42.0"},{"v":85.8452380952381,"d":"85.845"},{"v":0,"d":"0.0"},"是"]
["能化21-1班",2021010515,"陈骄阳",70,86,85,78,75,71,null,74,null,72,82,null,87,75,83,77,75,82,75,{"$nulls":6},88,null,null,79,{"$nulls":4},79,{"$nulls":4},85,null,20,8,{"v":0.4,"d":"40.00%"},3564.5,{"v":46,"d":"46.0"},{"v":77.48913043478261,"d":"77.489"},{"v":0,"d":"0.0"},"是"]
["能化21-2班",2021010395,"王浙",96,94,91,88,95,82,null,96,null,83,92,null,94,92,92,87,75,89,87,{"$nulls":6},84,{"$nulls":7},92,{"$nulls":4},91,null,19,18,{"v":0.9473684210526315,"d":"94.74%"},3751.5,{"v":42,"d":"42.0"},{"v":89.32142857142857,"d":"89.321"},{"v":0,"d":"0.0"},"是"]
["能化21-2班",2021010403,"崔珈榕",63,72,73,82,72,56,null,46,null,60,84,null,79,82,82,60,70,72,60,{"$nulls":6},80,null,61,{"$nulls":5},75,{"$nulls":4},84,null,20,6,{"v":0.3,"d":"30.00%"},3093.5,{"v":45,"d":"45.0"},{"v":68.74444444444444,"d":"68.744"},{"v":2,"d":"2.0"},"否"]
["能化21-2班",2021010409,"刘兴旺",62,85,80,81,74,60,null,75,null,70,74,null,88,79,77,60,72,69,61,{"$nulls":6},79,{"$nulls":7},70,{"$nulls":4},80,null,19,5,{"v":0.2631578947368421,"d":"26.32%"},{"v":3044,"d":"3044.0"},{"v":42,"d":"42.0"},{"v":72.47619047619048,"d":"72.476"},{"v":0,"d":"0.0"},"是"]
["能化21-2班",2021010412,"陈逸飞",61,81,86,84,81,66,null,82,null,77,75,null,88,83,79,64,75,78,70,{"$nulls":6},80,{"$nulls":7},87,{"$nulls":4},86,null,19,10,{"v":0.5263157894736842,"d":"52.63%"},{"v":3258,"d":"3258.0"},{"v":42,"d":"42.0"},{"v":77.57142857142857,"d":"77.571"},{"v":0,"d":"0.0"},"是"]
["能化21-2班",2021010413,"林云志",60,66,77,77,67,63,null,66,null,60,73,null,87,86,70,61,67,71,67,{"$nulls":3},60,null,null,80,{"$nulls":4},76,86,null,63,{"$nulls":4},85,null,{"$f":"COUNTA(D99:AQ99)","v":22},{"$f":"COUNTIF(D99:AQ99,\">=80\")","v":5},{"v":0.22727272727272727,"d":"22.73%"},3641.5,{"v":52,"d":"52.0"},{"v":70.02884615384616,"d":"70.029"},{"v":0,"d":"0.0"},"是"]
["能化21-2班",2021010419,"鲁鹤宇",33,75,75,9,70,34,null,42,null,45,74,69,21,76,53,61,66,66,50,null,null,47,{"$nulls":3},78,{"$nulls":5},11,47,63,{"$nulls":4},87,null,23,1,{"v":0.043478260869565216,"d":"4.35%"},{"v":2624,"d":"2624.0"},{"v":53,"d":"53.0"},{"v":49.509433962264154,"d":"49.509"},{"v":11,"d":"11.0"},"否"]
["能化21-2班",2021010426,"杨凯迪",60,66,74,74,69,39,70,38,null,60,71,null,82,74,65,35,65,66,60,{"$nulls":3},51,null,null,78,null,69,{"$nulls":5},61,{"$nulls":4},83,null,22,2,{"v":0.09090909090909091,"d":"9.09%"},{"v":3305,"d":"3305.0"},53.5,{"v":61.77570093457944,"d":"61.776"},{"v":4,"d":"4.0"},"否"]
["能化21-2班",2021010427,"张金坤",70,84,70,64,67,63,null,60,null,75,71,null,91,81,85,61,71,71,71,69,{"$nulls":5},80,{"$nulls":7},82,{"$nulls":4},86,null,20,7,{"v":0.35,"d":"35.00%"},{"v":3244,"d":"3244.0"},{"v":45,"d":"45.0"},{"v":72.08888888888889,"d":"72.089"},{"v":0,"d":"0.0"},"是"]
["能化21-2班",2021010439,"吴晗毓",75,86,null,82,85,61,null,64,null,61,82,null,89,80,77,86,69,73,77,{"$nulls":6},84,{"$nulls":7},74,{"$nulls":4},92,null,18,9,{"v":0.5,"d":"50.00%"},{"v":3131,"d":"3131.0"},41.5,{"v":75.44578313253012,"d":"75.446"},{"v":0,"d":"0.0"},"否","化工原理实验II未修"]
["能化21-2班",2021010450,"周围",72,83,89,80,72,58,null,67,null,72,76,null,88,91,83,60,73,70,60,{"$nulls":4},79,null,80,null,67,{"$nulls":3},84,null,76,{"$nulls":4},86,85,23,10,{"v":0.43478260869565216,"d":"43.48%"},3628.5,{"v":49,"d":"49.0"},{"v":74.05102040816327,"d":"74.051"},{"v":1,"d":"1.0"},"否"]
["能化21-2班",2021010461,"杨嘉琦",82,90,84,88,88,70,null,76,null,75,80,null,89,86,97,87,71,79,71,{"$nulls":6},85,{"$nulls":7},81,{"$nulls":4},91,null,19,13,{"v":0.6842105263157895,"d":"68.42%"},{"v":3419,"d":"3419.0"},{"v":42,"d":"42.0"},{"v":81.4047619047619,"d":"81.405"},{"v":0,"d":"0.0"},"是"]
["能化21-2班",2021010462,"武晗",60,89,86,78,84,52,60,71,null,61,85,null,79,80,80,68,68,70,75,{"$nulls":6},84,{"$nulls":4},64,null,null,79,{"$nulls":4},84,null,21,8,{"v":0.38095238095238093,"d":"38.10%"},3462.5,48.5,{"v":71.3917525773196,"d":"71.392"},{"v":1,"d":"1.0"},"否"]
["能化21-2班",2021010464,"周香格",60,75,77,68,77,60,60,52,null,60,73,null,82,83,70,60,64,62,68,50,{"$nulls":5},83,null,62,{"$nulls":5},79,{"$nulls":4},83,null,22,4,{"v":0.18181818181818182,"d":"18.18%"},3412.5,51.5,{"v":66.2621359223301,"d":"66.262"},{"v":2,"d":"2.0"},"否"]
["能化21-2班",2021010466,"程嘉欣",72,90,91,87,87,64,null,62,null,70,89,null,89,91,77,86,79,79,75,{"$nulls":4},86,null,86,{"$nulls":5},87,null,89,{"$nulls":4},90,null,21,13,{"v":0.6190476190476191,"d":"61.90%"},3686.5,{"v":46,"d":"46.0"},{"v":80.1413043478261,"d":"80.141"},{"v":0,"d":"0.0"},"是"]
["能化21-2班",2021010467,"颜伊宁",74,91,92,86,87,64,null,82,null,73,87,null,89,87,83,89,75,79,79,{"$nulls":6},84,{"$nulls":7},86,{"$nulls":4},90,null,19,13,{"v":0.6842105263157895,"d":"68.42%"},{"v":3417,"d":"3417.0"},{"v":42,"d":"42.0"},{"v":81.35714285714286,"d":"81.357"},{"v":0,"d":"0.0"},"是"]
["能化21-2班",2021010470,"刘睿扬",80,91,92,85,90,62,null,75,null,67,84,null,87,88,95,88,77,88,71,{"$nulls":4},85,null,83,{"$nulls":5},87,null,79,{"$nulls":4},91,null,21,15,{"v":0.7142857142857143,"d":"71.43%"},{"v":3740,"d":"3740.0"},{"v":46,"d":"46.0"},{"v":81.30434782608695,"d":"81.304"},{"v":0,"d":"0.0"},"是"]
["能化21-2班",2021010471,"柳子涵",72,81,90,80,83,49,55,62,null,60,79,null,87,78,67,60,65,78,75,55,null,null,56,null,null,81,null,51,{"$nulls":5},91,{"$nulls":4},87,null,23,8,{"v":0.34782608695652173,"d":"34.78%"},{"v":3835,"d":"3835.0"},56.5,{"v":67.87610619469027,"d":"67.876"},{"v":5,"d":"5.0"},"否"]
["能化21-2班",2021010475,"蒲文博",70,84,73,84,82,61,null,66,null,66,70,null,85,80,68,60,76,75,62,74,{"$nulls":5},85,{"$nulls":7},77,95,{"$nulls":3},82,null,21,8,{"v":0.38095238095238093,"d":"38.10%"},{"v":3381,"d":"3381.0"},{"v":46,"d":"46.0"},{"v":73.5,"d":"73.500"},{"v":0,"d":"0.0"},"是"]
["能化21-2班",2021010476,"齐翔龙",66,81,83,72,78,51,41,63,null,60,66,null,83,81,60,47,74,74,61,60,{"$nulls":3},85,null,83,{"$nulls":4},56,85,null,78,null,70,null,null,85,null,25,8,{"v":0.32,"d":"32.00%"},{"v":3786,"d":"3786.0"},56.5,{"v":67.00884955752213,"d":"67.009"},{"v":4,"d":"4.0"},"否"]
["能化21-2班",2021010477,"何余胜",60,72,79,78,69,36,37,39,null,60,73,null,83,73,80,60,70,68,61,55,{"$nulls":5},82,null,60,{"$nulls":5},75,{"$nulls":4},86,null,22,4,{"v":0.18181818181818182,"d":"18.18%"},3218.5,51.5,{"v":62.49514563106796,"d":"62.495"},{"v":4,"d":"4.0"},"否"]
["能化21-2班",2021010478,"常一帆",68,78,82,71,72,55,58,68,null,61,78,null,79,75,72,67,70,72,80,{"$nulls":6},80,null,60,{"$nulls":5},75,{"$nulls":4},83,null,21,4,{"v":0.19047619047619047,"d":"19.05%"},3355.5,48.5,{"v":69.18556701030928,"d":"69.186"},{"v":2,"d":"2.0"},"否"]
["能化21-2班",2021010479,"覃师凯",70,73,81,73,67,60,null,60,null,60,82,null,88,79,83,60,66,69,72,69,{"$nulls":5},90,{"$nulls":7},90,100,{"$nulls":3},90,null,21,8,{"v":0.38095238095238093,"d":"38.10%"},{"v":3323,"d":"3323.0"},{"v":46,"d":"46.0"},{"v":72.23913043478261,"d":"72.239"},{"v":0,"d":"0.0"},"是"]
["能化21-2班",2021010486,"鹿麒麟",99,96,94,94,97,87,null,97,null,90,93,null,96,95,99,100,96,94,87,{"$nulls":6},92,{"$nulls":7},97,{"$nulls":4},97,null,19,19,{"v":1,"d":"100.00%"},3964.5,{"v":42,"d":"42.0"},{"v":94.39285714285714,"d":"94.393"},{"v":0,"d":"0.0"},"是"]
["能化21-2班",2021010487,"吴隆卓",65,72,66,76,67,54,67,43,null,62,75,null,85,78,84,60,69,71,61,63,{"$nulls":5},84,null,60,{"$nulls":5},69,{"$nulls":4},86,null,22,4,{"v":0.18181818181818182,"d":"18.18%"},{"v":3453,"d":"3453.0"},51.5,{"v":67.04854368932038,"d":"67.049"},{"v":2,"d":"2.0"},"否"]
["能化21-2班",2021010492,"左笑维",93,88,60,85,83,81,null,92,null,80,88,null,84,88,85,95,87,83,81,{"$nulls":6},80,{"$nulls":7},87,{"$nulls":4},91,null,19,18,{"v":0.9473684210526315,"d":"94.74%"},{"v":3586,"d":"3586.0"},{"v":42,"d":"42.0"},{"v":85.38095238095238,"d":"85.381"},{"v":0,"d":"0.0"},"是"]
["能化21-2班",2021010501,"陈湘宜",62,79,85,83,75,60,null,66,null,60,78,null,88,83,71,67,68,79,67,75,{"$nulls":5},81,{"$nulls":7},79,{"$nulls":4},84,null,20,6,{"v":0.3,"d":"30.00%"},{"v":3289,"d":"3289.0"},{"v":45,"d":"45.0"},{"v":73.08888888888889,"d":"73.089"},{"v":0,"d":"0.0"},"是"]
["能化21-2班",2021010502,"王晨宣",71,88,82,81,87,71,null,80,null,71,84,null,90,84,93,93,82,86,72,{"$nulls":6},82,{"$nulls":7},84,{"$nulls":4},85,null,19,15,{"v":0.7894736842105263,"d":"78.95%"},3428.5,{"v":42,"d":"42.0"},{"v":81.63095238095238,"d":"81.631"},{"v":0,"d":"0.0"},"是"]
["能化21-2班",2021010506,"陈国荣",80,84,84,78,75,72,null,86,null,73,76,null,82,84,78,76,76,77,76,{"$nulls":4},76,null,80,{"$nulls":5},79,null,84,96,{"$nulls":3},89,null,22,10,{"v":0.45454545454545453,"d":"45.45%"},{"v":3703,"d":"3703.0"},{"v":47,"d":"47.0"},{"v":78.7872340425532,"d":"78.787"},{"v":0,"d":"0.0"},"是"]
["能化21-2班",2021010521,"王梓涵",81,80,85,74,90,72,null,85,null,76,85,null,92,91,92,94,77,79,86,{"$nulls":6},81,{"$nulls":7},91,{"$nulls":4},90,null,19,14,{"v":0.7368421052631579,"d":"73.68%"},{"v":3514,"d":"3514.0"},{"v":42,"d":"42.0"},{"v":83.66666666666667,"d":"83.667"},{"v":0,"d":"0.0"},"是"]
[]
[{"$nulls":3},"100305C001","100305L007","100305L008","100305P019","100305T032","100305T064","100305T075","100305T076","100305T081","100305T099","100305T109","100308P006","100308P009","100308T015","100308T016","100328T001","100328T005","100328T014",{"v":100513000000,"d":"1.01E+11"},"100616M003","100616M005","100616M018","100616M019","100617L014","100617L025","100617L027","100617T005","100617T006","100617T059","100617T061","100627M012","100627M016","100627M017","101000T001","101099G045","101099M008","101099M010","101099M013","101300X003","101500X002"]
["班级","学号","姓名","化工应用软件","化工原理实验（Ⅰ）","化工原理实验（Ⅱ）","化工原理课程设计","化工装备与控制","化工热力学","化工原理（Ⅰ）","化工原理（Ⅱ）","生物化学","化学反应工程","化工安全与环保","能化认识实习","能化生产实习","煤化学转化工程","天然气处理与转化工程","化工用能评价","能源化工设计基础","石油加工工程","电工学及实验","线性代数","概率统计基础","高等数学B（Ⅰ）","高等数学B（Ⅱ）","有机化学实验","有机化学实验","物理化学实验（Ⅱ）","物理化学（Ⅰ）","物理化学（Ⅱ）","无机化学与分析化学","有机化学","大学物理C（Ⅱ）","大学物理实验B（Ⅰ）","大学物理实验B（Ⅱ）","项目管理与经济决策","专项运动训练课Ⅰ","大学体育必修（篮球）","大学体育必修（健美）","大学体育必修（健美操）","就业指导","入学教育与安全教育"]
["能化21-1班",2020010644,"李硕",{"$f":"D67*D$66","v":0},{"$f":"E67*E$66","v":0},0,0,0,{"v":122.5,"d":"123"},217,42,122,0,0,0,0,0,160,0,0,0,0,0,207,318,0,0,0,0,180,0,240,0,0,0,{"v":130.5,"d":"131"},0,0,0,0,0,42,0,{"$f":"SUM(D127:AQ127)","v":1781}]
["能化21-1班",2021010374,"何若妍",{"$f":"D68*D$66","v":182},45,{"v":47.5,"d":"48"},276,285,294,0,{"v":325.5,"d":"326"},0,315,194,0,276,276,192,194,186,282,180,0,0,0,0,0,0,88,0,0,0,0,0,0,0,186,0,0,0,0,{"v":44.5,"d":"45"},0,{"$f":"SUM(D128:AQ128)","v":{"v":3868.5,"d":"3869"}}]
["能化21-1班",2021010376,"李传洋",{"$f":"D69*D$66","v":32},{"v":34.5,"d":"35"},39,12,180,140,245,{"v":80.5,"d":"81"},0,{"v":115.5,"d":"116"},164,0,258,246,120,76,120,219,166,180,0,390,315,0,0,87,0,0,0,210,240,0,0,120,0,0,0,0,{"v":39.5,"d":"40"},0,3829]
["能化21-1班",2021010377,"甘浩",{"$f":"D70*D$66","v":120},{"v":36.5,"d":"37"},{"v":34.5,"d":"35"},216,219,161,0,{"v":122.5,"d":"123"},0,245,154,0,255,234,158,120,152,180,120,180,0,0,0,0,0,80,0,0,0,0,0,0,0,122,0,0,0,0,{"v":39.5,"d":"40"},0,2949]
["能化21-1班",2021010380,"詹作鑫",{"$f":"D71*D$66","v":140},{"v":38.5,"d":"39"},{"v":40.5,"d":"41"},234,258,210,0,238,0,{"v":269.5,"d":"270"},156,0,273,219,186,148,158,243,140,0,0,0,0,0,0,83,0,237,0,0,0,0,0,148,0,0,0,0,42,0,{"v":3461.5,"d":"3462"}]
["能化21-1班",2021010381,"李维昊",{"$f":"D72*D$66","v":120},38,34,189,195,203,{"v":220.5,"d":"221"},217,0,175,142,0,258,240,142,120,126,216,120,168,0,0,0,0,0,82,0,0,112,0,0,0,0,130,0,0,0,0,{"v":41.5,"d":"42"},0,3289]
["能化21-1班",2021010382,"王理哲",{"$f":"D73*D$66","v":120},{"v":40.5,"d":"41"},{"v":35.5,"d":"36"},252,231,{"v":213.5,"d":"214"},0,{"v":220.5,"d":"221"},0,210,162,0,270,228,154,124,140,207,120,168,0,0,0,0,0,80,0,0,0,0,0,0,0,132,0,0,0,0,{"v":43.5,"d":"44"},0,{"v":3151.5,"d":"3152"}]
["能化21-1班",2021010387,"李洪博",{"$f":"D74*D$66","v":120},37,35,234,201,{"v":213.5,"d":"214"},252,{"v":213.5,"d":"214"},0,{"v":213.5,"d":"214"},154,0,249,240,136,120,126,210,122,0,0,0,315,158,0,78,0,183,0,0,0,160,0,122,0,0,0,0,{"v":42.5,"d":"43"},0,3935]
["能化21-1班",2021010389,"李臻彦",{"$f":"D75*D$66","v":120},40,41,246,213,{"v":234.5,"d":"235"},0,{"v":171.5,"d":"172"},0,210,162,0,240,258,148,150,132,225,120,0,0,0,0,0,0,75,213,0,0,0,0,144,0,152,0,0,0,0,42,0,3337]
["能化21-1班",2021010392,"苏辛一",{"$f":"D76*D$66","v":120},38,{"v":35.5,"d":"36"},183,198,{"v":171.5,"d":"172"},{"v":234.5,"d":"235"},{"v":66.5,"d":"67"},0,210,132,0,228,243,156,120,134,219,120,138,0,0,0,0,0,75,0,165,0,0,0,50,0,122,0,0,0,0,{"v":39.5,"d":"40"},0,{"v":3198.5,"d":"3199"}]
["能化21-1班",2021010393,"唐顾玮",{"$f":"D77*D$66","v":98},{"v":35.5,"d":"36"},{"v":37.5,"d":"38"},228,237,217,0,210,0,210,162,0,234,234,160,120,142,222,140,180,0,0,0,0,0,78,0,0,0,0,0,158,0,124,0,0,0,0,41,0,3268]
["能化21-1班",2021010428,"周忠康",{"$f":"D78*D$66","v":160},41,{"v":43.5,"d":"44"},264,258,245,0,280,0,{"v":234.5,"d":"235"},174,0,276,246,176,158,156,237,124,0,0,0,0,0,0,88,0,0,0,0,0,178,0,170,0,0,0,0,{"v":40.5,"d":"41"},0,{"v":3549.5,"d":"3550"}]
["能化21-1班",2021010431,"王医灵",{"$f":"D79*D$66","v":166},38,{"v":42.5,"d":"43"},219,279,252,0,294,0,273,176,0,273,282,190,182,166,243,146,0,0,0,0,0,0,87,0,0,0,0,0,0,0,168,0,0,0,0,0,0,{"v":3476.5,"d":"3477"}]
["能化21-1班",2021010432,"梁卓文",{"$f":"D80*D$66","v":150},{"v":38.5,"d":"39"},{"v":42.5,"d":"43"},273,255,259,0,280,0,245,160,0,270,246,182,148,142,201,142,222,0,0,0,158,0,83,0,0,0,0,0,0,0,158,0,0,0,0,{"v":44.5,"d":"45"},0,{"v":3699.5,"d":"3700"}]
["能化21-1班",2021010433,"朱佳怡",{"$f":"D81*D$66","v":76},{"v":37.5,"d":"38"},{"v":36.5,"d":"37"},210,183,{"v":199.5,"d":"200"},0,{"v":171.5,"d":"172"},0,{"v":213.5,"d":"214"},152,0,252,252,166,150,128,207,150,171,0,0,0,146,0,71,0,0,0,0,0,0,0,152,0,0,0,0,{"v":42.5,"d":"43"},0,3167]
["能化21-1班",2021010442,"裴俊豪",{"$f":"D82*D$66","v":184},42,{"v":45.5,"d":"46"},273,279,294,0,{"v":311.5,"d":"312"},0,{"v":304.5,"d":"305"},188,0,279,276,182,186,158,273,170,0,0,0,0,0,0,90,0,0,0,0,0,180,0,180,0,0,0,0,46,0,{"v":3941.5,"d":"3942"}]
["能化21-1班",2021010443,"鲍怡帅",{"$f":"D83*D$66","v":172},40,40,255,255,210,0,{"v":234.5,"d":"235"},0,210,142,0,279,264,190,150,152,246,148,0,0,0,0,0,0,85,0,0,0,0,0,0,0,166,0,0,0,0,{"v":43.5,"d":"44"},0,3282]
["能化21-1班",2021010445,"耿智鸿",{"$f":"D84*D$66","v":120},{"v":37.5,"d":"38"},{"v":37.5,"d":"38"},243,207,{"v":199.5,"d":"200"},0,210,0,210,162,0,252,243,142,142,150,210,152,183,0,0,0,0,0,87,0,0,0,0,0,172,0,170,0,0,0,0,{"v":43.5,"d":"44"},0,3373]
["能化21-1班",2021010457,"栾俊添",{"$f":"D85*D$66","v":184},{"v":42.5,"d":"43"},{"v":46.5,"d":"47"},249,276,287,0,308,0,301,184,0,270,273,190,180,166,261,154,0,0,0,0,0,0,91,0,0,0,0,0,0,0,176,0,0,0,0,46,0,3685]
["能化21-1班",2021010465,"潘思迪",{"$f":"D86*D$66","v":160},{"v":42.5,"d":"43"},{"v":46.5,"d":"47"},267,273,301,0,{"v":304.5,"d":"305"},0,{"v":290.5,"d":"291"},178,0,264,270,162,188,150,264,160,0,0,0,0,0,90,87,0,0,0,0,0,174,0,172,0,0,0,0,46,0,3890]
["能化21-1班",2021010482,"王岩青",{"$f":"D87*D$66","v":182},{"v":42.5,"d":"43"},46,255,234,210,210,{"v":213.5,"d":"214"},0,{"v":234.5,"d":"235"},160,0,255,249,132,124,158,204,130,0,0,0,0,0,0,86,0,186,0,0,0,0,0,136,0,0,0,0,44,0,{"v":3491.5,"d":"3492"}]
["能化21-1班",2021010493,"李燕琴",{"$f":"D88*D$66","v":120},41,38,246,213,238,252,217,0,{"v":192.5,"d":"193"},142,0,264,249,138,120,138,219,126,0,0,396,0,166,0,91,0,0,0,0,0,0,0,140,0,0,90,0,{"v":42.5,"d":"43"},0,3879]
["能化21-1班",2021010494,"黄镜",{"$f":"D89*D$66","v":128},{"v":39.5,"d":"40"},{"v":37.5,"d":"38"},213,225,175,189,217,0,{"v":192.5,"d":"193"},152,0,249,258,150,104,130,207,120,141,0,0,0,0,0,84,0,171,0,0,0,0,0,128,0,0,0,82,44,0,{"v":3436.5,"d":"3437"}]
["能化21-1班",2021010496,"解天羽",{"$f":"D90*D$66","v":120},42,{"v":43.5,"d":"44"},261,237,{"v":220.5,"d":"221"},0,196,0,217,156,0,255,237,168,132,132,240,178,0,0,0,0,0,0,91,0,0,0,0,0,0,0,138,0,0,0,0,44,0,3108]
["能化21-1班",2021010498,"阿力木努·赛买提",{"$f":"D91*D$66","v":130},42,{"v":41.5,"d":"42"},234,210,{"v":213.5,"d":"214"},0,196,0,{"v":192.5,"d":"193"},156,0,246,261,154,120,130,216,96,0,0,0,0,166,0,86,0,0,0,0,0,176,0,134,0,0,0,84,{"v":43.5,"d":"44"},0,3328]
["能化21-1班",2021010513,"曹逸恒",{"$f":"D92*D$66","v":142},{"v":41.5,"d":"42"},{"v":34.5,"d":"35"},240,225,154,{"v":150.5,"d":"151"},140,0,189,160,0,228,180,128,126,120,204,120,168,0,318,0,0,0,86,0,189,0,0,0,0,0,126,0,0,0,0,41,0,{"v":3510.5,"d":"3511"}]
["能化21-1班",2021010514,"曹哲仁",{"$f":"D93*D$66","v":166},{"v":45.5,"d":"46"},44,231,276,{"v":290.5,"d":"291"},0,336,0,301,184,0,255,237,178,174,160,249,178,0,0,0,0,0,0,89,0,0,0,0,0,0,0,168,0,0,0,0,{"v":43.5,"d":"44"},0,{"v":3605.5,"d":"3606"}]
["能化21-1班",2021010515,"陈骄阳",{"$f":"D94*D$66","v":140},43,{"v":42.5,"d":"43"},234,225,{"v":248.5,"d":"249"},0,259,0,252,164,0,261,225,166,154,150,246,150,0,0,0,0,0,0,88,0,0,316,0,0,0,0,158,0,0,0,0,{"v":42.5,"d":"43"},0,{"v":3564.5,"d":"3565"}]
["能化21-2班",2021010395,"王浙",{"$f":"D95*D$66","v":192},47,{"v":45.5,"d":"46"},264,285,287,0,336,0,{"v":290.5,"d":"291"},184,0,282,276,184,174,150,267,174,0,0,0,0,0,0,84,0,0,0,0,0,0,0,184,0,0,0,0,{"v":45.5,"d":"46"},0,{"v":3751.5,"d":"3752"}]
["能化21-2班",2021010403,"崔珈榕",{"$f":"D96*D$66","v":126},36,{"v":36.5,"d":"37"},246,216,196,0,161,0,210,168,0,237,246,164,120,140,216,120,0,0,0,0,0,0,80,0,183,0,0,0,0,0,150,0,0,0,0,42,0,{"v":3093.5,"d":"3094"}]
["能化21-2班",2021010409,"刘兴旺",{"$f":"D97*D$66","v":124},{"v":42.5,"d":"43"},40,243,222,210,0,{"v":262.5,"d":"263"},0,245,148,0,264,237,154,120,144,207,122,0,0,0,0,0,0,79,0,0,0,0,0,0,0,140,0,0,0,0,40,0,3044]
["能化21-2班",2021010412,"陈逸飞",{"$f":"D98*D$66","v":122},{"v":40.5,"d":"41"},43,252,243,231,0,287,0,{"v":269.5,"d":"270"},150,0,264,249,158,128,150,234,140,0,0,0,0,0,0,80,0,0,0,0,0,0,0,174,0,0,0,0,43,0,3258]
["能化21-2班",2021010413,"林云志",{"$f":"D99*D$66","v":120},33,{"v":38.5,"d":"39"},231,201,{"v":220.5,"d":"221"},0,231,0,210,146,0,261,258,140,122,134,213,134,0,0,0,300,0,0,80,0,0,0,0,228,172,0,126,0,0,0,0,{"v":42.5,"d":"43"},0,{"v":3641.5,"d":"3642"}]
["能化21-2班",2021010419,"鲁鹤宇",{"$f":"D100*D$66","v":66},{"v":37.5,"d":"38"},{"v":37.5,"d":"38"},27,210,119,0,147,0,{"v":157.5,"d":"158"},148,{"v":103.5,"d":"104"},63,228,106,122,132,198,100,0,0,282,0,0,0,78,0,0,0,0,0,22,{"v":70.5,"d":"71"},126,0,0,0,0,{"v":43.5,"d":"44"},0,2624]
["能化21-2班",2021010426,"杨凯迪",{"$f":"D101*D$66","v":120},33,37,222,207,{"v":136.5,"d":"137"},245,133,0,210,142,0,246,222,130,70,130,198,120,0,0,0,255,0,0,78,0,207,0,0,0,0,0,122,0,0,0,0,{"v":41.5,"d":"42"},0,3305]
["能化21-2班",2021010427,"张金坤",{"$f":"D102*D$66","v":140},42,35,192,201,{"v":220.5,"d":"221"},0,210,0,{"v":262.5,"d":"263"},142,0,273,243,170,122,142,213,142,207,0,0,0,0,0,80,0,0,0,0,0,0,0,164,0,0,0,0,43,0,3244]
["能化21-2班",2021010439,"吴晗毓",{"$f":"D103*D$66","v":150},43,0,246,255,{"v":213.5,"d":"214"},0,224,0,{"v":213.5,"d":"214"},164,0,267,240,154,172,138,219,154,0,0,0,0,0,0,84,0,0,0,0,0,0,0,148,0,0,0,0,46,0,3131]
["能化21-2班",2021010450,"周围",{"$f":"D104*D$66","v":144},{"v":41.5,"d":"42"},{"v":44.5,"d":"45"},240,216,203,0,{"v":234.5,"d":"235"},0,252,152,0,264,273,166,120,146,210,120,0,0,0,0,158,0,80,0,201,0,0,0,168,0,152,0,0,0,0,43,0,{"v":3628.5,"d":"3629"}]
["能化21-2班",2021010461,"杨嘉琦",{"$f":"D105*D$66","v":164},45,42,264,264,245,0,266,0,{"v":262.5,"d":"263"},160,0,267,258,194,174,142,237,142,0,0,0,0,0,0,85,0,0,0,0,0,0,0,162,0,0,0,0,{"v":45.5,"d":"46"},0,3419]
["能化21-2班",2021010462,"武晗",{"$f":"D106*D$66","v":120},{"v":44.5,"d":"45"},43,234,252,182,210,{"v":248.5,"d":"249"},0,{"v":213.5,"d":"214"},170,0,237,240,160,136,136,210,150,0,0,0,0,0,0,84,0,0,0,0,192,0,0,158,0,0,0,0,42,0,{"v":3462.5,"d":"3463"}]
["能化21-2班",2021010464,"周香格",{"$f":"D107*D$66","v":120},{"v":37.5,"d":"38"},{"v":38.5,"d":"39"},204,231,210,210,182,0,210,146,0,246,249,140,120,128,186,136,150,0,0,0,0,0,83,0,186,0,0,0,0,0,158,0,0,0,0,{"v":41.5,"d":"42"},0,{"v":3412.5,"d":"3413"}]
["能化21-2班",2021010466,"程嘉欣",{"$f":"D108*D$66","v":144},45,{"v":45.5,"d":"46"},261,261,224,0,217,0,245,178,0,267,273,154,172,158,237,150,0,0,0,0,172,0,86,0,0,0,0,0,174,0,178,0,0,0,0,45,0,{"v":3686.5,"d":"3687"}]
["能化21-2班",2021010467,"颜伊宁",{"$f":"D109*D$66","v":148},{"v":45.5,"d":"46"},46,258,261,224,0,287,0,{"v":255.5,"d":"256"},174,0,267,261,166,178,150,237,158,0,0,0,0,0,0,84,0,0,0,0,0,0,0,172,0,0,0,0,45,0,3417]
["能化21-2班",2021010470,"刘睿扬",{"$f":"D110*D$66","v":160},{"v":45.5,"d":"46"},46,255,270,217,0,{"v":262.5,"d":"263"},0,{"v":234.5,"d":"235"},168,0,261,264,190,176,154,264,142,0,0,0,0,170,0,83,0,0,0,0,0,174,0,158,0,0,0,0,{"v":45.5,"d":"46"},0,3740]
["能化21-2班",2021010471,"柳子涵",{"$f":"D111*D$66","v":144},{"v":40.5,"d":"41"},45,240,249,{"v":171.5,"d":"172"},{"v":192.5,"d":"193"},217,0,210,158,0,261,234,134,120,130,234,150,165,0,0,280,0,0,81,0,153,0,0,0,0,0,182,0,0,0,0,{"v":43.5,"d":"44"},0,3835]
["能化21-2班",2021010475,"蒲文博",{"$f":"D112*D$66","v":140},42,{"v":36.5,"d":"37"},252,246,{"v":213.5,"d":"214"},0,231,0,231,140,0,255,240,136,120,152,225,124,222,0,0,0,0,0,85,0,0,0,0,0,0,0,154,95,0,0,0,41,0,3381]
["能化21-2班",2021010476,"齐翔龙",{"$f":"D113*D$66","v":132},{"v":40.5,"d":"41"},{"v":41.5,"d":"42"},216,234,{"v":178.5,"d":"179"},{"v":143.5,"d":"144"},{"v":220.5,"d":"221"},0,210,132,0,249,243,120,94,148,222,122,180,0,0,0,170,0,83,0,0,0,0,168,170,0,156,0,70,0,0,{"v":42.5,"d":"43"},0,3786]
["能化21-2班",2021010477,"何余胜",{"$f":"D114*D$66","v":120},36,{"v":39.5,"d":"40"},234,207,126,{"v":129.5,"d":"130"},{"v":136.5,"d":"137"},0,210,146,0,249,219,160,120,140,204,122,165,0,0,0,0,0,82,0,180,0,0,0,0,0,150,0,0,0,0,43,0,{"v":3218.5,"d":"3219"}]
["能化21-2班",2021010478,"常一帆",{"$f":"D115*D$66","v":136},39,41,213,216,{"v":192.5,"d":"193"},203,238,0,{"v":213.5,"d":"214"},156,0,237,225,144,134,140,216,160,0,0,0,0,0,0,80,0,180,0,0,0,0,0,150,0,0,0,0,{"v":41.5,"d":"42"},0,{"v":3355.5,"d":"3356"}]
["能化21-2班",2021010479,"覃师凯",{"$f":"D116*D$66","v":140},{"v":36.5,"d":"37"},{"v":40.5,"d":"41"},219,201,210,0,210,0,210,164,0,264,237,166,120,132,207,144,207,0,0,0,0,0,90,0,0,0,0,0,0,0,180,100,0,0,0,45,0,3323]
["能化21-2班",2021010486,"鹿麒麟",{"$f":"D117*D$66","v":198},48,47,282,291,{"v":304.5,"d":"305"},0,{"v":339.5,"d":"340"},0,315,186,0,288,285,198,200,192,282,174,0,0,0,0,0,0,92,0,0,0,0,0,0,0,194,0,0,0,0,{"v":48.5,"d":"49"},0,{"v":3964.5,"d":"3965"}]
["能化21-2班",2021010487,"吴隆卓",{"$f":"D118*D$66","v":130},36,33,228,201,189,{"v":234.5,"d":"235"},{"v":150.5,"d":"151"},0,217,150,0,255,234,168,120,138,213,122,189,0,0,0,0,0,84,0,180,0,0,0,0,0,138,0,0,0,0,43,0,3453]
["能化21-2班",2021010492,"左笑维",{"$f":"D119*D$66","v":186},44,30,255,249,{"v":283.5,"d":"284"},0,322,0,280,176,0,252,264,170,190,174,249,162,0,0,0,0,0,0,80,0,0,0,0,0,0,0,174,0,0,0,0,{"v":45.5,"d":"46"},0,3586]
["能化21-2班",2021010501,"陈湘宜",{"$f":"D120*D$66","v":124},{"v":39.5,"d":"40"},{"v":42.5,"d":"43"},249,225,210,0,231,0,210,156,0,264,249,142,134,136,237,134,225,0,0,0,0,0,81,0,0,0,0,0,0,0,158,0,0,0,0,42,0,3289]
["能化21-2班",2021010502,"王晨宣",{"$f":"D121*D$66","v":142},44,41,243,261,{"v":248.5,"d":"249"},0,280,0,{"v":248.5,"d":"249"},168,0,270,252,186,186,164,258,144,0,0,0,0,0,0,82,0,0,0,0,0,0,0,168,0,0,0,0,{"v":42.5,"d":"43"},0,{"v":3428.5,"d":"3429"}]
["能化21-2班",2021010506,"陈国荣",{"$f":"D122*D$66","v":160},42,42,234,225,252,0,301,0,{"v":255.5,"d":"256"},152,0,246,252,156,152,152,231,152,0,0,0,0,152,0,80,0,0,0,0,0,158,0,168,96,0,0,0,{"v":44.5,"d":"45"},0,3703]
["能化21-2班",2021010521,"王梓涵",{"$f":"D123*D$66","v":162},40,{"v":42.5,"d":"43"},222,270,252,0,{"v":297.5,"d":"298"},0,266,170,0,276,273,184,188,154,237,172,0,0,0,0,0,0,81,0,0,0,0,0,0,0,182,0,0,0,0,45,0,3514]

{"sheet":"【智育】选修成绩","index":6,"n_rows":186,"n_cols":25,"rows_kept":186,"merged":[[1,0,2,2]]}
[]
[{"$nulls":3},"100305T067","100308T009","100308T017","100328T003","100514G032","100719G001","100855G007","100866G002","100866G006","100866G010","100877G006","100877G009","100877G011","100877G038","100925G058","100925G085","100925G114","101099G040","101400G002"]
[{"$nulls":3},"新材料概论（全英文）","能源化学工程专业英语","能源工程基础","能源转化催化原理","Linux系统及应用","经济学基础","中国古代小说赏析","素描","乐理与视唱","音乐审美与名曲博览","两岸关系与台海问题","西方哲学思潮","民法概论","国际能源政治","日语入门","英美戏剧赏读","英汉互译实践与技巧","围棋（慕课）","信息检索与网络资源利用"]
["班级","学号","姓名",2,2,2,2,2,2,2,2,2,2,2,2,2,2,4,2,2,1.5,2]
["能化21-1班","2020010644","李硕","","","","","84","","","","","","","","","","","","","",""]
["能化21-1班","2021010374","何若妍","","","","95","","","","","","","","","","","","","","",""]
["能化21-1班","2021010376","李传洋","","68","67","","","9","","0","","83","",72,"","","","78","","",""]
["能化21-1班","2021010377","甘浩","16","","60","","","","","80","","75","","",0,"","","77","","","72"]
["能化21-1班","2021010380","詹作鑫","","","90","","","","","","","","","","","87","82","","","93",""]
["能化21-1班","2021010381","李维昊","","","60","","","","","82","","","","","0","","","","","","62"]
["能化21-1班","2021010382","王理哲","","81","61","","","","","","","","","","","","","","","",""]
["能化21-1班","2021010387","李洪博","","88","68 [49,68重1]","","","","","","","","","","","","","","","",""]
["能化21-1班","2021010389","李臻彦","","85","60","70","","","","","","","","","","","","","","",""]
["能化21-1班","2021010392","苏辛一","","","","60","","","","","","","","","","","","","90","",""]
["能化21-1班","2021010393","唐顾玮","","","61","69","","","","","","","","","","","","","","",""]
["能化21-1班","2021010428","周忠康","","88","75","","","","","","","","","","","","","","","",""]
["能化21-1班","2021010431","王医灵","","90","","76","","","","","","","","","","","","","","","86"]
["能化21-1班","2021010432","梁卓文","","","60","74","","","","","","","","","","","","","","",""]
["能化21-1班","2021010433","朱佳怡","","","65","67","","","","","","","","","","","","","","",""]
["能化21-1班","2021010442","裴俊豪","","","80","","","","","","","","","","","","","","","","93"]
["能化21-1班","2021010443","鲍怡帅","","78","61","","","","","","","","","","","","","","","","85"]
["能化21-1班","2021010445","耿智鸿","","","72","","","","","","","","","","","","","","","","81"]
["能化21-1班","2021010457","栾俊添","","","","90","","","","","","","","","","","","","","",""]
["能化21-1班","2021010465","潘思迪","","87","","92","","","","","","","","","","","","","","",""]
["能化21-1班","2021010482","王岩青","","","70","83","","","","","","","","","","","","","","",""]
["能化21-1班","2021010493","李燕琴","","","64","76","","","","","","","","","","","","","","",""]
["能化21-1班","2021010494","黄镜","","","","70","","","","","","","","","","","","","","","80"]
["能化21-1班","2021010496","解天羽","","","75","86","","","","","","","","","","","","","","",""]
["能化21-1班","2021010498","阿力木努·赛买提","","","","64","","","","","","","","","","","","","","",""]
["能化21-1班","2021010513","曹逸恒","","76","56","60","","","","","","","63","","","","","","","","90"]
["能化21-1班","2021010514","曹哲仁","","","71","85","","","","","","","","","","","","","","","90"]
["能化21-1班","2021010515","陈骄阳","","","61","64","","","","","","","","","","","","","","","86"]
["能化21-2班","2021010395","王浙","","","","94","","","","","","","","","","","","","","",""]
["能化21-2班","2021010403","崔珈榕","","","77","","","","","","","","","","","","","","","",""]
["能化21-2班","2021010409","刘兴旺","","","70","64","","","","","","","","","","","","","","75","72"]
["能化21-2班","2021010412","陈逸飞","","","74","79","","","","","","","","","","","","","","",""]
["能化21-2班","2021010413","林云志","","","","","","","","","","","","","","","","","","","66"]
["能化21-2班","2021010419","鲁鹤宇","","","27","","","","","","","","","","","","","","","",""]
["能化21-2班","2021010426","杨凯迪","","","79 [44,79重1]","65","","","","","","","","","","","","","","","60"]
["能化21-2班","2021010427","张金坤","","85","70","","","","","","","","","","","","","","","",""]
["能化21-2班","2021010439","吴晗毓","","","65","","","","84","","","","","","","","","","","",""]
["能化21-2班","2021010450","周围","","","","71","","","","","","","","","","","","","","","80"]
["能化21-2班","2021010461","杨嘉琦","","","81","","","","","","","","","","","","","","","","83"]
["能化21-2班","2021010462","武晗","","","87","82","","","","","","","","","","","","","","",""]
["能化21-2班","2021010464","周香格","","","70","73","","","","","88","83","","","","","","","","","77"]
["能化21-2班","2021010466","程嘉欣","","","","86","","","","","","","","","","","","","","",""]
["能化21-2班","2021010467","颜伊宁","","","88","91","","","","","","","","","","","","","","","90"]
["能化21-2班","2021010470","刘睿扬","","","","","","","","","","","","","","","","","","","92"]
["能化21-2班","2021010471","柳子涵","","","81","","","","","","","","","","","","","","","",""]
["能化21-2班","2021010475","蒲文博","","","69","","","","","","","","","","","","","","","","92"]
["能化21-2班","2021010476","齐翔龙","","83","67","","","","","","","","","","","","","","","","83"]
["能化21-2班","2021010477","何余胜","","76","77 [55,77重1]","","","","","","","","","","","","","","","","71"]
["能化21-2班","2021010478","常一帆","","","62","76","","","","","","","","","","","","","","",""]
["能化21-2班","2021010479","覃师凯","","","","63","","","","","","","","","","","","","","",""]
["能化21-2班","2021010486","鹿麒麟","","","","","","","","","","","","","","","","","","","97"]
["能化21-2班","2021010487","吴隆卓","","82","81","","","","","","","","","77","","","","","","","80"]
["能化21-2班","2021010492","左笑维","","","79","91","","","","","","","","","","","","","","",""]
["能化21-2班","2021010501","陈湘宜","","","","91","","","","","","","","","","","","","","",""]
["能化21-2班","2021010502","王晨宣","","","","93","","","","","","","","","","","","","","",""]
["能化21-2班","2021010506","陈国荣","","","70","","","","","","","","","","","","","","","","77"]
["能化21-2班","2021010521","王梓涵","","91","","90","","","","","","","","","","","","","","","92"]
[]
[]
[{"$nulls":3},"100305T067","100308T009","100308T017","100328T003","100514G032","100719G001","100855G007","100866G002","100866G006","100866G010","100877G006","100877G009","100877G011","100877G038","100925G058","100925G085","100925G114","101099G040","101400G002"]
[{"$nulls":3},"新材料概论（全英文）","能源化学工程专业英语","能源工程基础","能源转化催化原理","Linux系统及应用","经济学基础","中国古代小说赏析","素描","乐理与视唱","音乐审美与名曲博览","两岸关系与台海问题","西方哲学思潮","民法概论","国际能源政治","日语入门","英美戏剧赏读","英汉互译实践与技巧","围棋（慕课）","信息检索与网络资源利用"]
["班级","学号","姓名",{"v":2,"d":"2.0"},{"v":2,"d":"2.0"},{"v":2,"d":"2.0"},{"v":2,"d":"2.0"},{"v":2,"d":"2.0"},{"v":2,"d":"2.0"},{"v":2,"d":"2.0"},{"v":2,"d":"2.0"},{"v":2,"d":"2.0"},{"v":2,"d":"2.0"},{"v":2,"d":"2.0"},{"v":2,"d":"2.0"},{"v":2,"d":"2.0"},{"v":2,"d":"2.0"},{"v":4,"d":"4.0"},{"v":2,"d":"2.0"},{"v":2,"d":"2.0"},1.5,{"v":2,"d":"2.0"},"选修学分","选修学分绩","选修加权平均绩"]
["能化21-1班",2020010644,"李硕",{"$nulls":4},84,{"$nulls":14},{"$f":"SUMIF(D67:V67,\">=0\",D$66:V$66)","v":{"v":2,"d":"2.0"}},168,{"$f":"X67/W67","v":{"v":84,"d":"84.000"}}]
["能化21-1班",2021010374,"何若妍",{"$nulls":3},95,{"$nulls":15},{"$f":"SUMIF(D68:V68,\">=0\",D$66:V$66)","v":{"v":2,"d":"2.0"}},190,{"$f":"X68/W68","v":{"v":95,"d":"95.000"}}]
["能化21-1班",2021010376,"李传洋",null,68,67,null,null,9,null,0,null,83,null,72,{"$nulls":3},78,{"$nulls":3},{"v":14,"d":"14.0"},754,{"v":53.857142857142854,"d":"53.857"}]
["能化21-1班",2021010377,"甘浩",16,null,60,{"$nulls":4},80,null,75,null,null,0,null,null,77,null,null,72,{"v":14,"d":"14.0"},760,{"v":54.285714285714285,"d":"54.286"}]
["能化21-1班",2021010380,"詹作鑫",null,null,90,{"$nulls":10},87,82,null,null,93,null,9.5,{"v":821.5,"d":"822"},{"v":86.47368421052632,"d":"86.474"}]
["能化21-1班",2021010381,"李维昊",null,null,60,{"$nulls":4},82,{"$nulls":4},0,{"$nulls":5},62,{"v":8,"d":"8.0"},408,{"v":51,"d":"51.000"}]
["能化21-1班",2021010382,"王理哲",null,81,61,{"$nulls":16},{"v":4,"d":"4.0"},284,{"v":71,"d":"71.000"}]
["能化21-1班",2021010387,"李洪博",null,88,68,{"$nulls":16},{"v":4,"d":"4.0"},312,{"v":78,"d":"78.000"}]
["能化21-1班",2021010389,"李臻彦",null,85,60,70,{"$nulls":15},{"v":6,"d":"6.0"},430,{"v":71.66666666666667,"d":"71.667"}]
["能化21-1班",2021010392,"苏辛一",{"$nulls":3},60,{"$nulls":12},90,null,null,{"v":4,"d":"4.0"},300,{"v":75,"d":"75.000"}]
["能化21-1班",2021010393,"唐顾玮",null,null,61,69,{"$nulls":15},{"v":4,"d":"4.0"},260,{"v":65,"d":"65.000"}]
["能化21-1班",2021010428,"周忠康",null,88,75,{"$nulls":16},{"v":4,"d":"4.0"},326,{"v":81.5,"d":"81.500"}]
["能化21-1班",2021010431,"王医灵",null,90,null,76,{"$nulls":14},86,{"v":6,"d":"6.0"},504,{"v":84,"d":"84.000"}]
["能化21-1班",2021010432,"梁卓文",null,null,60,74,{"$nulls":15},{"v":4,"d":"4.0"},268,{"v":67,"d":"67.000"}]
["能化21-1班",2021010433,"朱佳怡",null,null,65,67,{"$nulls":15},{"v":4,"d":"4.0"},264,{"v":66,"d":"66.000"}]
["能化21-1班",2021010442,"裴俊豪",null,null,80,{"$nulls":15},93,{"v":4,"d":"4.0"},346,{"v":86.5,"d":"86.500"}]
["能化21-1班",2021010443,"鲍怡帅",null,78,61,{"$nulls":15},85,{"v":6,"d":"6.0"},448,{"v":74.66666666666667,"d":"74.667"}]
["能化21-1班",2021010445,"耿智鸿",null,null,72,{"$nulls":15},81,{"v":4,"d":"4.0"},306,{"v":76.5,"d":"76.500"}]
["能化21-1班",2021010457,"栾俊添",{"$nulls":3},90,{"$nulls":15},{"v":2,"d":"2.0"},180,{"v":90,"d":"90.000"}]
["能化21-1班",2021010465,"潘思迪",null,87,null,92,{"$nulls":15},{"v":4,"d":"4.0"},358,{"v":89.5,"d":"89.500"}]
["能化21-1班",2021010482,"王岩青",null,null,70,83,{"$nulls":15},{"v":4,"d":"4.0"},306,{"v":76.5,"d":"76.500"}]
["能化21-1班",2021010493,"李燕琴",null,null,64,76,{"$nulls":15},{"v":4,"d":"4.0"},280,{"v":70,"d":"70.000"}]
["能化21-1班",2021010494,"黄镜",{"$nulls":3},70,{"$nulls":14},80,{"v":4,"d":"4.0"},300,{"v":75,"d":"75.000"}]
["能化21-1班",2021010496,"解天羽",null,null,75,86,{"$nulls":15},{"v":4,"d":"4.0"},322,{"v":80.5,"d":"80.500"}]
["能化21-1班",2021010498,"阿力木努·赛买提",{"$nulls":3},64,{"$nulls":15},{"v":2,"d":"2.0"},128,{"v":64,"d":"64.000"}]
["能化21-1班",2021010513,"曹逸恒",null,76,56,60,{"$nulls":6},63,{"$nulls":7},90,{"v":10,"d":"10.0"},690,{"v":69,"d":"69.000"}]
["能化21-1班",2021010514,"曹哲仁",null,null,71,85,{"$nulls":14},90,{"v":6,"d":"6.0"},492,{"v":82,"d":"82.000"}]
["能化21-1班",2021010515,"陈骄阳",null,null,61,64,{"$nulls":14},86,{"v":6,"d":"6.0"},422,{"v":70.33333333333333,"d":"70.333"}]
["能化21-2班",2021010395,"王浙",{"$nulls":3},94,{"$nulls":15},{"v":2,"d":"2.0"},188,{"v":94,"d":"94.000"}]
["能化21-2班",2021010403,"崔珈榕",null,null,77,{"$nulls":16},{"v":2,"d":"2.0"},154,{"v":77,"d":"77.000"}]
["能化21-2班",2021010409,"刘兴旺",null,null,70,64,{"$nulls":13},75,72,7.5,{"v":524.5,"d":"525"},{"v":69.93333333333334,"d":"69.933"}]
["能化21-2班",2021010412,"陈逸飞",null,null,74,79,{"$nulls":15},{"v":4,"d":"4.0"},306,{"v":76.5,"d":"76.500"}]
["能化21-2班",2021010413,"林云志",{"$nulls":18},66,{"v":2,"d":"2.0"},132,{"v":66,"d":"66.000"}]
["能化21-2班",2021010419,"鲁鹤宇",null,null,27,{"$nulls":16},{"v":2,"d":"2.0"},54,{"v":27,"d":"27.000"}]
["能化21-2班",2021010426,"杨凯迪",null,null,79,65,{"$nulls":14},60,{"v":6,"d":"6.0"},408,{"v":68,"d":"68.000"}]
["能化21-2班",2021010427,"张金坤",null,85,70,{"$nulls":16},{"v":4,"d":"4.0"},310,{"v":77.5,"d":"77.500"}]
["能化21-2班",2021010439,"吴晗毓",null,null,65,{"$nulls":3},84,{"$nulls":12},{"v":4,"d":"4.0"},298,{"v":74.5,"d":"74.500"}]
["能化21-2班",2021010450,"周围",{"$nulls":3},71,{"$nulls":14},80,{"v":4,"d":"4.0"},302,{"v":75.5,"d":"75.500"}]
["能化21-2班",2021010461,"杨嘉琦",null,null,81,{"$nulls":15},83,{"v":4,"d":"4.0"},328,{"v":82,"d":"82.000"}]
["能化21-2班",2021010462,"武晗",null,null,87,82,{"$nulls":15},{"v":4,"d":"4.0"},338,{"v":84.5,"d":"84.500"}]
["能化21-2班",2021010464,"周香格",null,null,70,73,{"$nulls":4},88,83,{"$nulls":8},77,{"v":10,"d":"10.0"},782,{"v":78.2,"d":"78.200"}]
["能化21-2班",2021010466,"程嘉欣",{"$nulls":3},86,{"$nulls":15},{"v":2,"d":"2.0"},172,{"v":86,"d":"86.000"}]
["能化21-2班",2021010467,"颜伊宁",null,null,88,91,{"$nulls":14},90,{"v":6,"d":"6.0"},538,{"v":89.66666666666667,"d":"89.667"}]
["能化21-2班",2021010470,"刘睿扬",{"$nulls":18},92,{"v":2,"d":"2.0"},184,{"v":92,"d":"92.000"}]
["能化21-2班",2021010471,"柳子涵",null,null,81,{"$nulls":16},{"v":2,"d":"2.0"},162,{"v":81,"d":"81.000"}]
["能化21-2班",2021010475,"蒲文博",null,null,69,{"$nulls":15},92,{"v":4,"d":"4.0"},322,{"v":80.5,"d":"80.500"}]
["能化21-2班",2021010476,"齐翔龙",null,83,67,{"$nulls":15},83,{"v":6,"d":"6.0"},466,{"v":77.66666666666667,"d":"77.667"}]
["能化21-2班",2021010477,"何余胜",null,76,77,{"$nulls":15},71,{"v":6,"d":"6.0"},448,{"v":74.66666666666667,"d":"74.667"}]
["能化21-2班",2021010478,"常一帆",null,null,62,76,{"$nulls":15},{"v":4,"d":"4.0"},276,{"v":69,"d":"69.000"}]
["能化21-2班",2021010479,"覃师凯",{"$nulls":3},63,{"$nulls":15},{"v":2,"d":"2.0"},126,{"v":63,"d":"63.000"}]
["能化21-2班",2021010486,"鹿麒麟",{"$nulls":18},97,{"v":2,"d":"2.0"},194,{"v":97,"d":"97.000"}]
["能化21-2班",2021010487,"吴隆卓",null,82,81,{"$nulls":8},77,{"$nulls":6},80,{"v":8,"d":"8.0"},640,{"v":80,"d":"80.000"}]
["能化21-2班",2021010492,"左笑维",null,null,79,91,{"$nulls":15},{"v":4,"d":"4.0"},340,{"v":85,"d":"85.000"}]
["能化21-2班",2021010501,"陈湘宜",{"$nulls":3},91,{"$nulls":15},{"v":2,"d":"2.0"},182,{"v":91,"d":"91.000"}]
["能化21-2班",2021010502,"王晨宣",{"$nulls":3},93,{"$nulls":15},{"v":2,"d":"2.0"},186,{"v":93,"d":"93.000"}]
["能化21-2班",2021010506,"陈国荣",null,null,70,{"$nulls":15},77,{"v":4,"d":"4.0"},294,{"v":73.5,"d":"73.500"}]
["能化21-2班",2021010521,"王梓涵",null,91,null,90,{"$nulls":14},92,{"v":6,"d":"6.0"},546,{"v":91,"d":"91.000"}]
[]
[]
[]
[]
[{"$nulls":3},"100305T067","100308T009","100308T017","100328T003","100514G032","100719G001","100855G007","100866G002","100866G006","100866G010","100877G006","100877G009","100877G011","100877G038","100925G058","100925G085","100925G114","101099G040","101400G002"]
["班级","学号","姓名","新材料概论（全英文）","能源化学工程专业英语","能源工程基础","能源转化催化原理","Linux系统及应用","经济学基础","中国古代小说赏析","素描","乐理与视唱","音乐审美与名曲博览","两岸关系与台海问题","西方哲学思潮","民法概论","国际能源政治","日语入门","英美戏剧赏读","英汉互译实践与技巧","围棋（慕课）","信息检索与网络资源利用","选修学分绩"]
["能化21-1班",2020010644,"李硕",{"$f":"D$66*D67","v":0},{"$f":"E$66*E67","v":0},0,0,168,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D130:V130)","v":168}]
["能化21-1班",2021010374,"何若妍",{"$f":"D$66*D68","v":0},0,0,190,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D131:V131)","v":190}]
["能化21-1班",2021010376,"李传洋",{"$f":"D$66*D69","v":0},136,134,0,0,18,0,0,0,166,0,144,0,0,0,156,0,0,0,754]
["能化21-1班",2021010377,"甘浩",{"$f":"D$66*D70","v":32},0,120,0,0,0,0,160,0,150,0,0,0,0,0,154,0,0,144,760]
["能化21-1班",2021010380,"詹作鑫",{"$f":"D$66*D71","v":0},0,180,0,0,0,0,0,0,0,0,0,0,174,328,0,0,139.5,0,821.5]
["能化21-1班",2021010381,"李维昊",{"$f":"D$66*D72","v":0},0,120,0,0,0,0,164,0,0,0,0,0,0,0,0,0,0,124,408]
["能化21-1班",2021010382,"王理哲",{"$f":"D$66*D73","v":0},162,122,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,284]
["能化21-1班",2021010387,"李洪博",{"$f":"D$66*D74","v":0},176,136,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,312]
["能化21-1班",2021010389,"李臻彦",{"$f":"D$66*D75","v":0},170,120,140,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,430]
["能化21-1班",2021010392,"苏辛一",{"$f":"D$66*D76","v":0},0,0,120,0,0,0,0,0,0,0,0,0,0,0,0,180,0,0,300]
["能化21-1班",2021010393,"唐顾玮",{"$f":"D$66*D77","v":0},0,122,138,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,260]
["能化21-1班",2021010428,"周忠康",{"$f":"D$66*D78","v":0},176,150,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,326]
["能化21-1班",2021010431,"王医灵",{"$f":"D$66*D79","v":0},180,0,152,0,0,0,0,0,0,0,0,0,0,0,0,0,0,172,504]
["能化21-1班",2021010432,"梁卓文",{"$f":"D$66*D80","v":0},0,120,148,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,268]
["能化21-1班",2021010433,"朱佳怡",{"$f":"D$66*D81","v":0},0,130,134,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,264]
["能化21-1班",2021010442,"裴俊豪",{"$f":"D$66*D82","v":0},0,160,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,186,346]
["能化21-1班",2021010443,"鲍怡帅",{"$f":"D$66*D83","v":0},156,122,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,170,448]
["能化21-1班",2021010445,"耿智鸿",{"$f":"D$66*D84","v":0},0,144,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,162,306]
["能化21-1班",2021010457,"栾俊添",{"$f":"D$66*D85","v":0},0,0,180,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,180]
["能化21-1班",2021010465,"潘思迪",{"$f":"D$66*D86","v":0},174,0,184,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,358]
["能化21-1班",2021010482,"王岩青",{"$f":"D$66*D87","v":0},0,140,166,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,306]
["能化21-1班",2021010493,"李燕琴",{"$f":"D$66*D88","v":0},0,128,152,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,280]
["能化21-1班",2021010494,"黄镜",{"$f":"D$66*D89","v":0},0,0,140,0,0,0,0,0,0,0,0,0,0,0,0,0,0,160,300]
["能化21-1班",2021010496,"解天羽",{"$f":"D$66*D90","v":0},0,150,172,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,322]
["能化21-1班",2021010498,"阿力木努·赛买提",{"$f":"D$66*D91","v":0},0,0,128,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,128]
["能化21-1班",2021010513,"曹逸恒",{"$f":"D$66*D92","v":0},152,112,120,0,0,0,0,0,0,126,0,0,0,0,0,0,0,180,690]
["能化21-1班",2021010514,"曹哲仁",{"$f":"D$66*D93","v":0},0,142,170,0,0,0,0,0,0,0,0,0,0,0,0,0,0,180,492]
["能化21-1班",2021010515,"陈骄阳",{"$f":"D$66*D94","v":0},0,122,128,0,0,0,0,0,0,0,0,0,0,0,0,0,0,172,422]
["能化21-2班",2021010395,"王浙",{"$f":"D$66*D95","v":0},0,0,188,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,188]
["能化21-2班",2021010403,"崔珈榕",{"$f":"D$66*D96","v":0},0,154,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,154]
["能化21-2班",2021010409,"刘兴旺",{"$f":"D$66*D97","v":0},0,140,128,0,0,0,0,0,0,0,0,0,0,0,0,0,112.5,144,524.5]
["能化21-2班",2021010412,"陈逸飞",{"$f":"D$66*D98","v":0},0,148,158,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,306]
["能化21-2班",2021010413,"林云志",{"$f":"D$66*D99","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,132,132]
["能化21-2班",2021010419,"鲁鹤宇",{"$f":"D$66*D100","v":0},0,54,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,54]
["能化21-2班",2021010426,"杨凯迪",{"$f":"D$66*D101","v":0},0,158,130,0,0,0,0,0,0,0,0,0,0,0,0,0,0,120,408]
["能化21-2班",2021010427,"张金坤",{"$f":"D$66*D102","v":0},170,140,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,310]
["能化21-2班",2021010439,"吴晗毓",{"$f":"D$66*D103","v":0},0,130,0,0,0,168,0,0,0,0,0,0,0,0,0,0,0,0,298]
["能化21-2班",2021010450,"周围",{"$f":"D$66*D104","v":0},0,0,142,0,0,0,0,0,0,0,0,0,0,0,0,0,0,160,302]
["能化21-2班",2021010461,"杨嘉琦",{"$f":"D$66*D105","v":0},0,162,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,166,328]
["能化21-2班",2021010462,"武晗",{"$f":"D$66*D106","v":0},0,174,164,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,338]
["能化21-2班",2021010464,"周香格",{"$f":"D$66*D107","v":0},0,140,146,0,0,0,0,176,166,0,0,0,0,0,0,0,0,154,782]
["能化21-2班",2021010466,"程嘉欣",{"$f":"D$66*D108","v":0},0,0,172,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,172]
["能化21-2班",2021010467,"颜伊宁",{"$f":"D$66*D109","v":0},0,176,182,0,0,0,0,0,0,0,0,0,0,0,0,0,0,180,538]
["能化21-2班",2021010470,"刘睿扬",{"$f":"D$66*D110","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,184,184]
["能化21-2班",2021010471,"柳子涵",{"$f":"D$66*D111","v":0},0,162,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,162]
["能化21-2班",2021010475,"蒲文博",{"$f":"D$66*D112","v":0},0,138,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,184,322]
["能化21-2班",2021010476,"齐翔龙",{"$f":"D$66*D113","v":0},166,134,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,166,466]
["能化21-2班",2021010477,"何余胜",{"$f":"D$66*D114","v":0},152,154,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,142,448]
["能化21-2班",2021010478,"常一帆",{"$f":"D$66*D115","v":0},0,124,152,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,276]
["能化21-2班",2021010479,"覃师凯",{"$f":"D$66*D116","v":0},0,0,126,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,126]
["能化21-2班",2021010486,"鹿麒麟",{"$f":"D$66*D117","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,194,194]
["能化21-2班",2021010487,"吴隆卓",{"$f":"D$66*D118","v":0},164,162,0,0,0,0,0,0,0,0,154,0,0,0,0,0,0,160,640]
["能化21-2班",2021010492,"左笑维",{"$f":"D$66*D119","v":0},0,158,182,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,340]
["能化21-2班",2021010501,"陈湘宜",{"$f":"D$66*D120","v":0},0,0,182,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,182]
["能化21-2班",2021010502,"王晨宣",{"$f":"D$66*D121","v":0},0,0,186,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,186]
["能化21-2班",2021010506,"陈国荣",{"$f":"D$66*D122","v":0},0,140,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,154,294]
["能化21-2班",2021010521,"王梓涵",{"$f":"D$66*D123","v":0},182,0,180,0,0,0,0,0,0,0,0,0,0,0,0,0,0,184,546]

{"sheet":"【体育】体测成绩","index":7,"n_rows":58,"n_cols":18,"rows_kept":58}
["年级","院系","行政班级","学籍号","姓名","性别","备注","身高","体重","肺活量","50米跑","立定跳远","坐位体前屈","800米/1000米","仰卧起坐/引体向上","总分","等级","是否可以评选奖学金"]
[2021,"化学工程与环境学院","能化21-1班","2020010511","严皓禹","男",null,"暂无","暂无","暂无","暂无","暂无","暂无","暂无","暂无",0,"不及格",{"$f":"IF(P2>=60,\"是\",\"否\")","v":"否"}]
[2021,"化学工程与环境学院","能化21-1班","2021010374","何若妍","女",null,163,57.2,3565,11.2,141,13.4,"4'18''",27,60.8,"及格",{"$f":"IF(P3>=60,\"是\",\"否\")","v":"是"}]
[2021,"化学工程与环境学院","能化21-1班","2021010376","李传洋","男",null,169,54.6,5570,7.9,247,3.8,"3'26''","暂无",73.8,"及格","是"]
[2021,"化学工程与环境学院","能化21-1班","2021010377","甘浩","男",null,178.5,58.8,3673,8.8,209,5,"4'09''","暂无",61.9,"及格","是"]
[2021,"化学工程与环境学院","能化21-1班","2021010380","詹作鑫","男",null,161.5,68.2,3562,8.7,165,11.4,"暂无","暂无",41.3,"不及格","否"]
[2021,"化学工程与环境学院","能化21-1班","2021010381","李维昊","男",null,185,75.9,6215,7.6,247,26,"3'43''",16,86.2,"良好","是"]
[2021,"化学工程与环境学院","能化21-1班","2021010382","王理哲","男","补测",180.5,119,6392,8.8,194,3.9,"暂无","暂无",43.4,"不及格","否"]
[2021,"化学工程与环境学院","能化21-1班","2021010387","李洪博","男",null,176,80.4,5298,8.1,208,1.7,"5'06''","暂无",56.6,"不及格","否"]
[2021,"化学工程与环境学院","能化21-1班","2021010389","李臻彦","男",null,175,62.3,4460,7.9,224,-6.4,"4'58''","暂无",55.6,"不及格","否"]
[2021,"化学工程与环境学院","能化21-1班","2021010392","苏辛一","男",null,182.5,93.4,8161,8,237,13.9,"5'49''","暂无",56.4,"不及格","否"]
[2021,"化学工程与环境学院","能化21-1班","2021010393","唐顾玮","男",null,168,62.5,4210,8.2,225,3.7,"4'44''",9,65.6,"及格","是"]
[2021,"化学工程与环境学院","能化21-1班","2021010428","周忠康","男","补测",184,63.5,4987,8.6,204,3.8,"3'52''",4,60,"及格","是"]
[2021,"化学工程与环境学院","能化21-1班","2021010431","王医灵","女",null,154,73.6,3474,9.5,178,16.7,"4'10''",27,71.8,"及格","是"]
[2021,"化学工程与环境学院","能化21-1班","2021010432","梁卓文","女","补测",162.5,50.3,4019,10.1,151,18,"4'54''",36,60,"及格","是"]
[2021,"化学工程与环境学院","能化21-1班","2021010433","朱佳怡","女",null,164.5,62.9,3689,9.9,151,3.8,"4'24''",28,67.8,"及格","是"]
[2021,"化学工程与环境学院","能化21-1班","2021010442","裴俊豪","男",null,174.5,62.1,4923,8.2,208,12.7,"3'54''","暂无",69.1,"及格","是"]
[2021,"化学工程与环境学院","能化21-1班","2021010443","鲍怡帅","男",null,178,73.3,5178,7.7,202,12.7,"4'51''",6,64.6,"及格","是"]
[2021,"化学工程与环境学院","能化21-1班","2021010445","耿智鸿","男",null,171,58.5,4538,8.3,206,6.9,"4'24''",9,67.8,"及格","是"]
[2021,"化学工程与环境学院","能化21-1班","2021010457","栾俊添","男",null,170,73.2,5805,8,222,21.6,"4'20''",26,85.4,"良好","是"]
[2021,"化学工程与环境学院","能化21-1班","2021010465","潘思迪","女",null,150.5,45.8,2751,9.8,186,16.5,"4'23''",25,71.7,"及格","是"]
[2021,"化学工程与环境学院","能化21-1班","2021010482","王岩青","男",null,171,81.7,5933,8.4,208,11.2,"4'22''",3,64.6,"及格","是"]
[2021,"化学工程与环境学院","能化21-1班","2021010493","李燕琴","女",null,156,45.4,3301,9.4,151,8.9,"3'58''",29,73.2,"及格","是"]
[2021,"化学工程与环境学院","能化21-1班","2021010494","黄镜","女","免测","暂无","暂无","暂无","暂无","暂无","暂无","暂无","暂无",60,"免测","是"]
[2021,"化学工程与环境学院","能化21-1班","2021010496","解天羽","女",null,157,43.7,2767,10.4,154,12,"4'51''",31,63.3,"及格","是"]
[2021,"化学工程与环境学院","能化21-1班","2021010498","阿力木努·赛买提","女",null,161,64.6,3235,10.1,139,19.8,"4'18''",43,68.2,"及格","是"]
[2021,"化学工程与环境学院","能化21-1班","2021010513","曹逸恒","男",null,180,112,5455,9.2,"暂无","暂无","暂无","暂无",34,"不及格","否"]
[2021,"化学工程与环境学院","能化21-1班","2021010514","曹哲仁","男",null,169,55,3694,8.6,212,13.6,"4'28''","暂无",63.2,"及格","是"]
[2021,"化学工程与环境学院","能化21-1班","2021010515","陈骄阳","男",null,171,75.7,5075,8.7,224,14.2,"5'40''","暂无",56.7,"不及格","否"]
[2021,"化学工程与环境学院","能化21-2班","2021010395","王浙","男",null,167,55.2,4660,8.4,238,18.4,"4'28''","暂无",68.4,"及格","是"]
[2021,"化学工程与环境学院","能化21-2班","2021010403","崔珈榕","女",null,169.5,77.5,4234,10.3,164,16.1,"5'11''",35,62,"及格","是"]
[2021,"化学工程与环境学院","能化21-2班",2021010409,"刘兴旺","男","补测",172.5,83.1,3724,7.8,223,11.3,"5'05''",7,60,"及格","是"]
[2021,"化学工程与环境学院","能化21-2班","2021010412","陈逸飞","男",null,175,62.2,5300,"暂无",209,5.4,"暂无","暂无",41,"不及格","否"]
[2021,"化学工程与环境学院","能化21-2班","2021010413","林云志","男",null,175.5,71.3,5031,8.5,238,9.2,"4'34''",3,66.1,"及格","是"]
[2021,"化学工程与环境学院","能化21-2班","2021010419","鲁鹤宇","男",null,"暂无","暂无","暂无",8.9,"暂无","暂无","5'05''","暂无",20,"不及格","否"]
[2021,"化学工程与环境学院","能化21-2班","2021010426","杨凯迪","男",null,187,94.7,6436,8.5,231,3,"5'39''","暂无",54.8,"不及格","否"]
[2021,"化学工程与环境学院","能化21-2班","2021010427","张金坤","男",null,178.5,75.1,5096,8.2,199,8,"4'55''",2,60.3,"及格","是"]
[2021,"化学工程与环境学院","能化21-2班","2021010439","吴晗毓","女","补测",149,32.5,2600,10.4,151,6,"4'27''",38,60,"及格","是"]
[2021,"化学工程与环境学院","能化21-2班","2021010450","周围","男",null,171,75.2,6298,8.6,205,14.5,"5'17''","暂无",58.2,"不及格","否"]
[2021,"化学工程与环境学院","能化21-2班","2021010461","杨嘉琦","女",null,166,62.7,4068,10,158,13.7,"4'58''",32,68.2,"及格","是"]
[2021,"化学工程与环境学院","能化21-2班","2021010462","武晗","女",null,173,65,2710,9.9,156,13.3,"4'54''",28,63.4,"及格","是"]
[2021,"化学工程与环境学院","能化21-2班","2021010464","周香格","女",null,164.5,63.5,4440,10.4,134,17.4,"3'57''",29,70.6,"及格","是"]
[2021,"化学工程与环境学院","能化21-2班","2021010466","程嘉欣","女",null,171,56.7,3556,10,169,8.6,"4'07''",35,76.4,"及格","是"]
[2021,"化学工程与环境学院","能化21-2班","2021010467","颜伊宁","女",null,163.5,61.6,3233,10.4,156,13.4,"4'24''",37,70.4,"及格","是"]
[2021,"化学工程与环境学院","能化21-2班","2021010470","刘睿扬","女","免测","暂无","暂无","暂无","暂无","暂无","暂无","暂无","暂无",60,"免测","是"]
[2021,"化学工程与环境学院","能化21-2班","2021010471","柳子涵","女",null,175.5,80.2,4909,9.4,152,19.6,"5'04''",24,62.6,"及格","是"]
[2021,"化学工程与环境学院","能化21-2班","2021010475","蒲文博","男",null,179,86.1,4732,7.8,206,4.5,"4'45''","暂无",60.2,"及格","是"]
[2021,"化学工程与环境学院","能化21-2班","2021010476","齐翔龙","男","补测",170.5,79.7,5550,8,187,-6,"4'15''","暂无",55.2,"不及格","否"]
[2021,"化学工程与环境学院","能化21-2班","2021010477","何余胜","男","补测",171.5,50.2,4049,7.6,207,"暂无","4'30''",8,57.9,"不及格","否"]
[2021,"化学工程与环境学院","能化21-2班","2021010478","常一帆","男",null,180.5,78.3,4019,7.9,233,13.5,"4'26''",13,69.8,"及格","是"]
[2021,"化学工程与环境学院","能化21-2班","2021010479","覃师凯","男",null,169,67,4286,6,280,11.8,"3'05''",25,100.7,"优秀","是"]
[2021,"化学工程与环境学院","能化21-2班","2021010486","鹿麒麟","男",null,173.5,71.4,5497,7.9,209,16.7,"3'41''",14,79.4,"及格","是"]
[2021,"化学工程与环境学院","能化21-2班","2021010487","吴隆卓","男",null,174,91.7,3986,9.1,189,3.1,"5'25''","暂无",40.8,"不及格","否"]
[2021,"化学工程与环境学院","能化21-2班","2021010492","左笑维","男",null,173.5,72.9,4878,8.3,224,17.7,"4'09''","暂无",66,"及格","是"]
[2021,"化学工程与环境学院","能化21-2班","2021010501","陈湘宜","女",null,163.5,58.7,3919,12.1,124,23.2,"4'51''",28,53,"不及格","否"]
[2021,"化学工程与环境学院","能化21-2班","2021010502","王晨宣","女",null,174,72.3,2623,9.4,154,23.5,"5'10''",34,64.7,"及格","是"]
[2021,"化学工程与环境学院","能化21-2班","2021010506","陈国荣","男",null,171,68.2,5153,8.8,206,14.7,"4'29''","暂无",66.8,"及格","是"]
[2021,"化学工程与环境学院","能化21-2班","2021010521","王梓涵","男",null,174.5,74.2,5737,7.6,210,11.3,"4'25''","暂无",67.2,"及格","是"]

{"sheet":"【德育·智育·文体】1班竞赛加分","index":8,"n_rows":15,"n_cols":6,"rows_kept":15,"merged":[[11,4,13,4]]}
["姓名","学号","奖项","职位","竞赛等级","备注"]
["潘思迪",null,"2024年第七届全国“互联网+化学反应工程”课模设计大赛  二等奖","队员","D",4]
[null,null,"2024年中国大学生Chem-E-Car竞赛性能竞赛  一等奖","队长","C",8]
["曹哲仁",null,"2024年中国石油大学（北京）大学生化工原理竞赛  校级二等奖",null,"C",4]
[null,null,"第18届“旭阳杯”全国大学生化工设计竞赛（华北赛区）  一等奖","队员","B",4.5]
["栾俊添",null,"2024年第七届互联网+化学反应工程 课模设计大赛 二等奖 ","队长","D",5.33333]
[null,null,"北京市节能节水低碳减排社会实践与科技竞赛  三等奖","队长","B",3.33333]
[null,null,"2024年第十四届mathor cup 数学应用挑战赛  三等奖",null,"D",4]
[null,null,"2024年中国国际大学生创新比赛  二等奖","队员","A",4]
["何若妍",null,"2024年第七届全国“互联网+化学反应工程”课模设计大赛  一等奖","队员","D",6]
[null,null,"2024年北京市大学生化工原理竞赛  个人一等奖",null,"C",8]
["王岩青",null,"2022年北京市大学生音乐节器乐类展演   优秀表演奖   节目：《查尔达什》",null,"文体类，未从清单中发现",5]
[null,null,"2022年北京市大学生音乐节器乐类展演   优秀表演奖   节目：《北京喜讯到边塞》",null,null,5]
[null,null,"2022年北京市大学生音乐节器乐类展演   优秀表演奖   节目：《不忘初心》",null,null,5]
[null,null,"中国石油大学（北京）2023年暑期社会实践  优秀实践团队一等奖",null,null,3]

{"sheet":"【德育·智育·文体】2班竞赛加分","index":9,"n_rows":39,"n_cols":16,"rows_kept":39,"merged":[[0,0,0,15],[2,15,9,15],[11,15,18,15],[19,15,22,15],[24,15,25,15],[27,15,28,15],[29,15,33,15],[38,0,38,15]]}
["2023-2024 大三学年综测 能化21-2班竞赛活动获奖证明统计表"]
["序号","姓名","学号","比赛类型","比赛全称（请输入）","学科竞赛级别（参考清单，校内赛事选择“校赛”）","获奖级别","获奖等级","获奖时间（xxxx年xx月）","竞赛类型","（团队竞赛填写）是否为队长","备注","体育及文艺竞赛在此备注名次","列入加分（何导已初审）","具体单项加分/不加分原因（何导已初审）","单项加分汇总"]
[1,"王浙",2021010395,"智育竞赛","2024年北京市大学生化工原理竞赛","C级","省部级（北京市级）","一等奖","2024-05-01","个人竞赛",{"$nulls":3},"是",8,34]
[2,"王浙",2021010395,"智育竞赛","第六届北京市大学生节能节水低碳减排社会实践与科技竞赛","B级","省部级（北京市级）","一等奖","2024-05-01","团队竞赛","否",null,null,"是",4.5]
[3,"王浙",2021010395,"智育竞赛","第十四届北京市大学生化学实验竞赛（2023）","C级","省部级（北京市级）","二等奖","2023-12-01","个人竞赛",{"$nulls":3},"是",6]
[4,"王浙",2021010395,"智育竞赛","2024年挑战杯中国大学生创业竞赛校内选拔赛","校赛","校级","一等奖","2024-04-01","团队竞赛","否",null,null,"是",2.5]
[5,"王浙",2021010395,"智育竞赛","第十五届北京市化学实验竞赛校赛","校赛","校级","一等奖","2024-05-01","个人竞赛",{"$nulls":3},"是",5]
[6,"王浙",2021010395,"智育竞赛","2024年第七届全国“互联网+化学反应工程”课模设计大赛","D级","国家级","一等奖","2024-08-01","团队竞赛","是",null,null,"是",8]
[7,"王浙",2021010395,"智育竞赛","第十五届中国石油大学（北京）节能减排社会实践和科技竞赛","校赛","校级","一等奖","2024-05-01","团队竞赛","否",null,null,"否","同一比赛只加等级最高项"]
[8,"王浙",2021010395,"智育竞赛","北京市化学实验竞赛校内选拔赛","校赛","校级","一等奖","2023-11-01","个人竞赛",{"$nulls":3},"否","同一比赛只加等级最高项"]
[1,"程嘉欣",2021010466,"文艺竞赛","中国石油大学（北京）“学史爱校 悟思传薪”党史校情应知应会知识竞赛（初赛）",null,"校级","三等奖","2023-08-01","个人竞赛",{"$nulls":3},"否","竞赛中初赛获奖不加分",0]
[1,"鹿麒麟",2021010486,"智育竞赛","第十四届北京市大学生化学实验竞赛（2023）","C级","省部级（北京市级）","特等奖","2023-12-01","个人竞赛",{"$nulls":3},"是",8,35.5]
[2,"鹿麒麟",2021010486,"智育竞赛","全国大学生英语竞赛","C级","校级","三等奖","2024-04-01","个人竞赛",{"$nulls":3},"是",2]
[3,"鹿麒麟",2021010486,"智育竞赛","2024年北京市大学生化工原理竞赛","C级","省部级（北京市级）","一等奖","2024-05-01","个人竞赛",{"$nulls":3},"是",8]
[4,"鹿麒麟",2021010486,"智育竞赛","第十五届北京市化学实验竞赛校赛","校赛","校级","一等奖","2024-05-01","个人竞赛",{"$nulls":3},"是",5]
[5,"鹿麒麟",2021010486,"智育竞赛","2024年“天正设计杯”第十八届全国大学生化工设计竞赛","B级","省部级（北京市级）","一等奖","2024-08-01","团队竞赛","否",null,null,"是",4.5]
[6,"鹿麒麟",2021010486,"智育竞赛","2024年第七届全国“互联网+化学反应工程”课模设计大赛","D级","国家级","二等奖","2024-08-01","团队竞赛","否",null,null,"是",4]
[7,"鹿麒麟",2021010486,"智育竞赛","北京市化学实验竞赛校内选拔赛","校赛","校级","一等奖","2023-11-01","个人竞赛",{"$nulls":3},"否","同一比赛只加等级最高项"]
[8,"鹿麒麟",2021010486,"智育竞赛","中国石油大学（北京）第二届信息素养大赛","校赛","校级","二等奖","2024-05-01","个人竞赛",{"$nulls":3},"是",4]
[9,"鹿麒麟",2021010486,"文艺竞赛","中国石油大学（北京）2023年暑期社会实践优秀实践团队",null,"校级","二等奖","2023-10-01","团队竞赛","否",null,null,"是",1.25,1.875]
[10,"鹿麒麟",2021010486,"文艺竞赛","2022-2023年度中国石油大学（北京）社会实践优秀个人",null,"校级","优秀奖&鼓励奖","2023-12-01","个人竞赛",{"$nulls":3},"是","参加多项社会实践，团体与个人可叠加一项*0.5，上述已加"]
[11,"鹿麒麟",2021010486,"文艺竞赛","中国石油大学（北京）2023年暑期社会实践优秀实践报告",null,"校级","优秀奖&鼓励奖","2023-10-01","个人竞赛",{"$nulls":3},"否","已加社会实践分数，不再累加实践报告分数"]
[12,"鹿麒麟",2021010486,"文艺竞赛","中国石油大学（北京）2023年暑期社会实践优秀个人",null,"校级","优秀奖&鼓励奖","2023-10-01","个人竞赛",{"$nulls":3},"否",0.625]
[13,"鹿麒麟",2021010486,"体育竞赛","2024年中国石油大学（北京）春季学生运动会跳大绳男子组",null,"校级","名次奖（体育竞赛勾选）在备注中注明名次","2024-04-01","团队竞赛","不区分队员与队长",null,"第一名","是",8,8]
[1,"左笑维",2021010492,"智育竞赛","大学生创新创业大赛","校赛","校级","一等奖","2024-06-01","团队竞赛","是",null,null,"否","科创类项目不计分",6]
[2,"左笑维",2021010492,"智育竞赛","2024年第七届全国“互联网+化学反应工程”课模设计大赛","D级","国家级","一等奖","2024-08-01","团队竞赛","否",null,null,"是",6]
[3,"左笑维",2021010492,"文艺竞赛","2023年石辩闳议杯华语辩论赛",null,"校级","名次奖（体育竞赛勾选）在备注中注明名次","2023-12-01","团队竞赛","不区分队员与队长","为该竞赛领队","第二名","是",8,8]
[4,"左笑维",2021010492,"体育竞赛","化工杯篮球比赛",null,"校级","名次奖（体育竞赛勾选）在备注中注明名次","2024-06-01","团队竞赛","否",null,"第二名","是",8,8]
[5,"左笑维",2021010492,"体育竞赛","2024石油杯优秀裁判员","校赛","校级","优秀奖&鼓励奖","2024-05-01","个人竞赛","不区分队员与队长",null,null,"否","体育优秀奖无加分"]
[1,"覃师凯",2021010479,"体育竞赛","2024年中国石油大学（北京）春季学生运动会三级跳",null,"校级","名次奖（体育竞赛勾选）在备注中注明名次","2024-04-01","个人竞赛",null,null,"第一名","否","体育类比赛最多可累加两项",25]
[2,"覃师凯",2021010479,"体育竞赛","2024年中国石油大学（北京）春季学生运动会100m",null,"校级","名次奖（体育竞赛勾选）在备注中注明名次","2024-04-01","个人竞赛",null,null,"第五名","否","体育类比赛最多可累加两项"]
[3,"覃师凯",2021010479,"体育竞赛","首都高校田径精英赛4*400接力",null,"省部级（北京市级）","名次奖（体育竞赛勾选）在备注中注明名次","2023-12-01","团队竞赛","不区分队员与队长",null,"第三名","是",15]
[4,"覃师凯",2021010479,"体育竞赛","首都高校田径精英赛60m",null,"省部级（北京市级）","名次奖（体育竞赛勾选）在备注中注明名次","2023-12-01","个人竞赛",null,null,"第六名","是",10]
[5,"覃师凯",2021010479,"体育竞赛","2024年中国石油大学（北京）春季学生运动会跳大绳",null,"校级","名次奖（体育竞赛勾选）在备注中注明名次","2024-04-01","个人竞赛",null,null,"第一名","否","体育类比赛最多可累加两项"]
[6,"覃师凯",2021010479,"智育竞赛","第十四届北京市大学生化学实验竞赛校赛","校赛","校级","三等奖","2023-11-01","个人竞赛",{"$nulls":3},"是",2,2]
[1,"刘睿扬",2021010470,"智育竞赛","第十五届北京市大学生化学实验竞赛校赛","校赛","校级","二等奖","2024-05-01","个人竞赛",{"$nulls":3},"是",4,4]
[1,"杨嘉琦",2021010461,"智育竞赛","“青创北京”2024“挑战杯”首都大学生创业计划竞赛","C级","省部级（北京市级）","二等奖","2024-06-01","团队竞赛","否",null,null,"是",3,3]
[]
["目前加分仅作参考，2024综测办法已出，有改动，最终加分情况仍需公示确认后才可生效，特此延长公示时间，请有疑问的同学于9.5 17:00前反馈"]