{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["成绩"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"成绩","index":0,"n_rows":88,"n_cols":11,"rows_kept":88,"merged":[[0,0,0,10]]}
["贵州能投产业集团有限公司招聘总成绩名单"]
["序号","姓名","岗位","笔试分数","折算分数","面试分数","折算分数","总成绩","名次","是否进入下一环节","备注"]
[{"$f":"ROW()-2","v":1},"熊兵","党委办公室主任",77,{"$f":"ROUND((D3/1.5)*40%,2)","v":20.53},77.33,{"$f":"ROUND(F3*60%,2)","v":46.4},{"$f":"E3+G3","v":66.93},{"$f":"RANK(H3,$H$3:$H$5)","v":1},"是"]
[{"$f":"ROW()-2","v":2},"赵宏登","党委办公室主任",59,15.73,76.33,45.8,61.53,{"$f":"RANK(H4,$H$3:$H$5)","v":2},"否"]
[3,"张浩","党委办公室主任",64,17.07,55,33,50.07,{"$f":"RANK(H5,$H$3:$H$5)","v":3},"否"]
[4,"周登梅","党建工作员",77,20.53,83.4,50.04,70.57,{"$f":"RANK(H6,$H$6:$H$8)","v":1},"是"]
[5,"韦飞龙","党建工作员",79,21.07,72.4,43.44,64.51,{"$f":"RANK(H7,$H$6:$H$8)","v":2},"否"]
[6,"余亚东","党建工作员",78,{"v":20.8,"d":"20.80"},null,0,20.8,null,"否","缺考"]
[7,"李安安","资产管理员",96,{"v":25.6,"d":"25.60"},54.4,32.64,58.24,{"$f":"RANK(H9,$H$9:$H$15)","v":1},"否"]
[8,"王治庭","资产管理员",80,21.33,54.8,32.88,54.21,2,"否"]
[9,"李丹","资产管理员",70,18.67,58,34.8,53.47,3,"否"]
[10,"罗好","资产管理员",81,{"v":21.6,"d":"21.60"},52.2,31.32,52.92,4,"否"]
[11,"肖霄","资产管理员",70,18.67,54,32.4,51.07,5,"否"]
[{"$f":"ROW()-2","v":12},"彭颖雪","资产管理员",75,{"v":20,"d":"20.00"},51.6,30.96,50.96,6,"否"]
[13,"黄玲玲","资产管理员",70,18.67,null,0,18.67,null,"否","缺考"]
[14,"屠定益","后勤工作员",85,22.67,75.8,45.48,68.15,{"$f":"RANK(H16,$H$16:$H$19)","v":1},"是"]
[15,"罗品瑶","后勤工作员",86,22.93,65.2,39.12,62.05,{"$f":"RANK(H17,$H$16:$H$19)","v":2},"否"]
[16,"杨秀洪","后勤工作员",85,22.67,54,32.4,55.07,{"$f":"RANK(H18,$H$16:$H$19)","v":3},"否"]
[17,"李玉峰","后勤工作员",87,{"v":23.2,"d":"23.20"},52.6,31.56,54.76,{"$f":"RANK(H19,$H$16:$H$19)","v":4},"否"]
[18,"李宝","人力资源部工作员",75.5,20.13,88,52.8,72.93,{"$f":"RANK(H20,$H$20:$H$27)","v":1},"是"]
[19,"杨汉佳","人力资源部工作员",77,20.53,87.17,52.3,72.83,{"$f":"RANK(H21,$H$20:$H$27)","v":2},"是"]
[20,"沈贵","人力资源部工作员",92.5,24.67,69.83,41.9,66.57,3,"否"]
[21,"张涛","人力资源部工作员",65.5,17.47,65.67,39.4,56.87,4,"否"]
[{"$f":"ROW()-2","v":22},"陈⽞婕","人力资源部工作员",74.5,19.87,57.17,34.3,54.17,5,"否"]
[23,"骆科俊","人力资源部工作员",66,{"v":17.6,"d":"17.60"},60.83,36.5,54.1,6,"否"]
[24,"徐冕娅","人力资源部工作员",57.5,15.33,56.83,34.1,49.43,7,"否"]
[25,"韦帆","人力资源部工作员",52.5,{"v":14,"d":"14.00"},58.33,35,49,8,"否"]
[26,"张品贵","项目经理",72,{"v":19.2,"d":"19.20"},75,45,64.2,{"$f":"RANK(H28,$H$28:$H$30)","v":1},"是"]
[27,"韦朝威","项目经理",83,22.13,67.5,40.5,62.63,{"$f":"RANK(H29,$H$28:$H$30)","v":2},"否"]
[28,"许明松","项目经理",61.5,{"v":16.4,"d":"16.40"},67,40.2,56.6,{"$f":"RANK(H30,$H$28:$H$30)","v":3},"否"]
[29,"段朝成","工程师",78,{"v":20.8,"d":"20.80"},70.5,42.3,63.1,{"$f":"RANK(H31,$H$31:$H$39)","v":1},"是"]
[30,"邹书林","工程师",54,{"v":14.4,"d":"14.40"},79,47.4,61.8,2,"是"]
[31,"梁玉洪","工程师",57,{"v":15.2,"d":"15.20"},76,45.6,60.8,3,"是"]
[{"$f":"ROW()-2","v":32},"巫金","工程师",55.5,{"v":14.8,"d":"14.80"},70,42,56.8,4,"否"]
[33,"岑振优","工程师",68,18.13,64,38.4,56.53,5,"否"]
[34,"麻仕法","工程师",58,15.47,65,39,54.47,6,"否"]
[35,"付鹏翔","工程师",60,{"v":16,"d":"16.00"},63.5,38.1,54.1,7,"否"]
[36,"李鹏飞","工程师",57,{"v":15.2,"d":"15.20"},62.5,37.5,52.7,8,"否"]
[37,"周开州","工程师",53,14.13,61,36.6,50.73,9,"否","面试递补人员"]
[38,"饶乃鑫","工程师",53,{"$f":"ROUND((D40/1.5)*40%,2)","v":14.13},null,null,{"$f":"E40+G40","v":14.13},null,"否","自愿放弃面试"]
[39,"高凤琴","资料员",61.5,{"$f":"ROUND((D41/1.5)*40%,2)","v":{"v":16.4,"d":"16.40"}},77.67,{"$f":"ROUND(F41*60%,2)","v":46.6},{"$f":"E41+G41","v":63},{"$f":"RANK(H41,$H$41:$H$43)","v":1},"是"]
[40,"罗铭浩","资料员",61,{"$f":"ROUND((D42/1.5)*40%,2)","v":16.27},66.67,{"$f":"ROUND(F42*60%,2)","v":40},{"$f":"E42+G42","v":56.27},{"$f":"RANK(H42,$H$41:$H$43)","v":2},"否"]
[41,"杨金融","资料员",62,{"$f":"ROUND((D43/1.5)*40%,2)","v":16.53},61,{"$f":"ROUND(F43*60%,2)","v":36.6},{"$f":"E43+G43","v":53.13},{"$f":"RANK(H43,$H$41:$H$43)","v":3},"否"]
[{"$f":"ROW()-2","v":42},"毛德美","融资部工作员",61,{"$f":"ROUND((D44/1.5)*40%,2)","v":16.27},81.6,{"$f":"ROUND(F44*60%,2)","v":48.96},{"$f":"E44+G44","v":65.23},{"$f":"RANK(H44,$H$44:$H$50)","v":1},"是"]
[43,"周凤","融资部工作员",54,{"$f":"ROUND((D45/1.5)*40%,2)","v":{"v":14.4,"d":"14.40"}},66.8,{"$f":"ROUND(F45*60%,2)","v":40.08},{"$f":"E45+G45","v":54.48},2,"否"]
[44,"陈建宇","融资部工作员",57,{"$f":"ROUND((D46/1.5)*40%,2)","v":{"v":15.2,"d":"15.20"}},64.2,{"$f":"ROUND(F46*60%,2)","v":38.52},{"$f":"E46+G46","v":53.72},3,"否"]
[45,"王一博","融资部工作员",50,{"$f":"ROUND((D47/1.5)*40%,2)","v":13.33},61,{"$f":"ROUND(F47*60%,2)","v":36.6},{"$f":"E47+G47","v":49.93},4,"否"]
[46,"刘畅","融资部工作员",56,{"$f":"ROUND((D48/1.5)*40%,2)","v":14.93},45.2,{"$f":"ROUND(F48*60%,2)","v":27.12},{"$f":"E48+G48","v":42.05},5,"否"]
[47,"董晓康","融资部工作员",52,{"$f":"ROUND((D49/1.5)*40%,2)","v":13.87},null,{"$f":"ROUND(F49*60%,2)","v":0},{"$f":"E49+G49","v":13.87},null,"否","缺考"]
[48,"匡小浪","融资部工作员",47,{"$f":"ROUND((D50/1.5)*40%,2)","v":12.53},null,{"$f":"ROUND(F50*60%,2)","v":0},{"$f":"E50+G50","v":12.53},null,"否","缺考"]
[49,"李健华","安环企管部经理",73,{"$f":"ROUND((D51/1.5)*40%,2)","v":19.47},62.75,{"$f":"ROUND(F51*60%,2)","v":37.65},{"$f":"E51+G51","v":57.12},{"$f":"RANK(H51,$H$51:$H$53)","v":1},"否"]
[50,"杨成","安环企管部经理",71,{"$f":"ROUND((D52/1.5)*40%,2)","v":18.93},57,{"$f":"ROUND(F52*60%,2)","v":34.2},{"$f":"E52+G52","v":53.13},{"$f":"RANK(H52,$H$51:$H$53)","v":2},"否"]
[51,"朱鹏","安环企管部经理",66,{"$f":"ROUND((D53/1.5)*40%,2)","v":{"v":17.6,"d":"17.60"}},58.25,{"$f":"ROUND(F53*60%,2)","v":34.95},{"$f":"E53+G53","v":52.55},{"$f":"RANK(H53,$H$51:$H$53)","v":3},"否"]
[{"$f":"ROW()-2","v":52},"金孝梅","综合管理员",82,{"$f":"ROUND((D54/1.5)*40%,2)","v":21.87},77.6,{"$f":"ROUND(F54*60%,2)","v":46.56},{"$f":"E54+G54","v":68.43},{"$f":"RANK(H54,$H$54:$H$59)","v":1},"是"]
[53,"李虹妍","综合管理员",80.5,{"$f":"ROUND((D55/1.5)*40%,2)","v":21.47},77.6,{"$f":"ROUND(F55*60%,2)","v":46.56},{"$f":"E55+G55","v":68.03},2,"是"]
[54,"舒适","综合管理员",92,{"$f":"ROUND((D56/1.5)*40%,2)","v":24.53},61.8,{"$f":"ROUND(F56*60%,2)","v":37.08},{"$f":"E56+G56","v":61.61},3,"否"]
[55,"王婷婷","综合管理员",82,{"$f":"ROUND((D57/1.5)*40%,2)","v":21.87},64.4,{"$f":"ROUND(F57*60%,2)","v":38.64},{"$f":"E57+G57","v":60.51},4,"否"]
[56,"黄香渝","综合管理员",90,{"$f":"ROUND((D58/1.5)*40%,2)","v":{"v":24,"d":"24.00"}},60.2,{"$f":"ROUND(F58*60%,2)","v":36.12},{"$f":"E58+G58","v":60.12},5,"否"]
[57,"刘友志","综合管理员",89,{"$f":"ROUND((D59/1.5)*40%,2)","v":23.73},59,{"$f":"ROUND(F59*60%,2)","v":35.4},{"$f":"E59+G59","v":59.13},6,"否"]
[58,"王宏艳","战略发展部工作员",104,{"$f":"ROUND((D60/1.5)*40%,2)","v":27.73},81.6,{"$f":"ROUND(F60*60%,2)","v":48.96},{"$f":"E60+G60","v":76.69},{"$f":"RANK(H60,$H$60:$H$70)","v":1},"是"]
[59,"翟安满","战略发展部工作员",73,{"$f":"ROUND((D61/1.5)*40%,2)","v":19.47},63.6,{"$f":"ROUND(F61*60%,2)","v":38.16},{"$f":"E61+G61","v":57.63},{"$f":"RANK(H61,$H$60:$H$70)","v":2},"否"]
[60,"刘俊伶","战略发展部工作员",61,{"$f":"ROUND((D62/1.5)*40%,2)","v":16.27},62.6,{"$f":"ROUND(F62*60%,2)","v":37.56},{"$f":"E62+G62","v":53.83},3,"否"]
[61,"孙其建","战略发展部工作员",68,{"$f":"ROUND((D63/1.5)*40%,2)","v":18.13},59,{"$f":"ROUND(F63*60%,2)","v":35.4},{"$f":"E63+G63","v":53.53},4,"否"]
[{"$f":"ROW()-2","v":62},"王颖","战略发展部工作员",65,{"$f":"ROUND((D64/1.5)*40%,2)","v":17.33},58.6,{"$f":"ROUND(F64*60%,2)","v":35.16},{"$f":"E64+G64","v":52.49},5,"否","面试递补人员"]
[63,"白奎","战略发展部工作员",61,{"$f":"ROUND((D65/1.5)*40%,2)","v":16.27},58.4,{"$f":"ROUND(F65*60%,2)","v":35.04},{"$f":"E65+G65","v":51.31},6,"否"]
[64,"陈柄龙","战略发展部工作员",60,{"$f":"ROUND((D66/1.5)*40%,2)","v":{"v":16,"d":"16.00"}},53.4,{"$f":"ROUND(F66*60%,2)","v":32.04},{"$f":"E66+G66","v":48.04},7,"否"]
[65,"李佳航","战略发展部工作员",55,{"$f":"ROUND((D67/1.5)*40%,2)","v":14.67},52.2,{"$f":"ROUND(F67*60%,2)","v":31.32},{"$f":"E67+G67","v":45.99},8,"否"]
[66,"张红梅","战略发展部工作员",65,{"$f":"ROUND((D68/1.5)*40%,2)","v":17.33},null,null,{"$f":"E68+G68","v":17.33},null,"否","资格审查未通过"]
[67,"孙庆磊","战略发展部工作员",54,{"$f":"ROUND((D69/1.5)*40%,2)","v":{"v":14.4,"d":"14.40"}},null,null,{"$f":"E69+G69","v":14.4},null,"否","自愿放弃面试"]
[68,"穆欢","战略发展部工作员",54,{"$f":"ROUND((D70/1.5)*40%,2)","v":{"v":14.4,"d":"14.40"}},null,{"$f":"ROUND(F70*60%,2)","v":0},{"$f":"E70+G70","v":14.4},null,"否","缺考"]
[69,"郑维","法务工作员",90,{"v":24,"d":"24.00"},74.8,44.88,68.88,{"$f":"RANK(H71,$H$71:$H$78)","v":1},"是"]
[70,"罗鑫尧","法务工作员",72,{"v":19.2,"d":"19.20"},81.6,48.96,68.16,{"$f":"RANK(H72,$H$71:$H$78)","v":2},"是"]
[71,"吴远超","法务工作员",88,23.47,73.8,44.28,67.75,{"$f":"RANK(H73,$H$71:$H$78)","v":3},"是"]
[{"$f":"ROW()-2","v":72},"周贵发","法务工作员",66,{"v":17.6,"d":"17.60"},58,34.8,52.4,{"$f":"RANK(H74,$H$71:$H$78)","v":4},"否"]
[73,"季双成","法务工作员",63,{"v":16.8,"d":"16.80"},54.8,32.88,49.68,{"$f":"RANK(H75,$H$71:$H$78)","v":5},"否"]
[74,"余大伟","法务工作员",64,17.07,null,0,17.07,null,"否","自愿放弃面试，无面试递补人员"]
[75,"成克媛","法务工作员",57,{"v":15.2,"d":"15.20"},null,0,15.2,null,"否","缺考"]
[76,"周金春","法务工作员",39,{"v":10.4,"d":"10.40"},null,0,10.4,null,"否","缺考"]
[77,"王健","审计主管",62,16.53,74.2,44.52,61.05,{"$f":"RANK(H79,$H$79:$H$81)","v":1},"是"]
[78,"刘繁雄","审计主管",75,{"v":20,"d":"20.00"},61.8,37.08,57.08,{"$f":"RANK(H80,$H$79:$H$81)","v":2},"否"]
[79,"严兵","审计主管",42,{"v":11.2,"d":"11.20"},null,0,11.2,null,"否","缺考"]
[80,"保正菊","审计工作员",80,21.33,77,46.2,67.53,{"$f":"RANK(H82,$H$82:$H$88)","v":1},"是"]
[81,"李涛","审计工作员",75,{"v":20,"d":"20.00"},75,45,65,2,"是"]
[82,"陆林林","审计工作员",85,22.67,66.8,40.08,62.75,3,"否"]
[83,"张达","审计工作员",84,{"v":22.4,"d":"22.40"},63.8,38.28,60.68,4,"否"]
[84,"王若飞","审计工作员",81,{"v":21.6,"d":"21.60"},62,37.2,58.8,5,"否"]
[85,"赵荣丽","审计工作员",76,20.27,61.6,36.96,57.23,6,"否"]
[86,"李浩然","审计工作员",75,{"v":20,"d":"20.00"},null,0,20,null,"否","缺考"]