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

{"sheet":"Sheet1","index":0,"n_rows":56,"n_cols":8,"rows_kept":56,"merged":[[0,0,0,7],[55,0,55,7]]}
["2021年公开招聘综合成绩表"]
["报考   岗位","考生号","笔试成绩","面试成绩","试讲成绩","综合成绩","本岗位排名","是否\n入围"]
["02","202102001",{"v":89,"d":"89.00"},{"v":86.8,"d":"86.80"},{"v":89.8,"d":"89.80"},{"$f":"C3*0.3+D3*0.3+E3*0.4","v":88.66},1,"是"]
["02","202102038",{"v":85,"d":"85.00"},{"v":80.4,"d":"80.40"},{"v":81.8,"d":"81.80"},{"$f":"C4*0.3+D4*0.3+E4*0.4","v":82.34},2,"否"]
["02","202102010",{"v":81,"d":"81.00"},{"v":84.2,"d":"84.20"},{"v":80.4,"d":"80.40"},{"$f":"C5*0.3+D5*0.3+E5*0.4","v":81.72},3,"否"]
["03","202103001",{"v":92,"d":"92.00"},{"v":82.2,"d":"82.20"},{"v":92,"d":"92.00"},{"$f":"C6*0.3+D6*0.3+E6*0.4","v":89.06},1,"是"]
["03","202103008",{"v":84,"d":"84.00"},{"v":81.1,"d":"81.10"},{"v":81,"d":"81.00"},{"$f":"C7*0.3+D7*0.3+E7*0.4","v":81.93},2,"否"]
["03","202103004",{"v":78,"d":"78.00"},{"v":73.4,"d":"73.40"},{"v":71.6,"d":"71.60"},{"$f":"C8*0.3+D8*0.3+E8*0.4","v":74.06},3,"否"]
["04","202104007",{"v":85,"d":"85.00"},{"v":84.8,"d":"84.80"},{"v":90.6,"d":"90.60"},{"$f":"C9*0.3+D9*0.3+E9*0.4","v":87.18},1,"是"]
["04","202104005",{"v":60,"d":"60.00"},{"v":81.6,"d":"81.60"},{"v":81.4,"d":"81.40"},{"$f":"C10*0.3+D10*0.3+E10*0.4","v":{"v":75.03999999999999,"d":"75.04"}},2,"否"]
["04","202104001",{"v":67,"d":"67.00"},{"v":78.4,"d":"78.40"},{"v":76.2,"d":"76.20"},{"$f":"C11*0.3+D11*0.3+E11*0.4","v":{"v":74.1,"d":"74.10"}},3,"否"]
["05","202105004",{"v":71,"d":"71.00"},{"v":80.6,"d":"80.60"},{"v":86.8,"d":"86.80"},{"$f":"C12*0.3+D12*0.3+E12*0.4","v":{"v":80.19999999999999,"d":"80.20"}},1,"是"]
["05","202105002",{"v":62,"d":"62.00"},{"v":78.6,"d":"78.60"},{"v":85.6,"d":"85.60"},{"$f":"C13*0.3+D13*0.3+E13*0.4","v":{"v":76.41999999999999,"d":"76.42"}},2,"否"]
["05","202105006",{"v":64,"d":"64.00"},{"v":76,"d":"76.00"},{"v":75.6,"d":"75.60"},{"$f":"C14*0.3+D14*0.3+E14*0.4","v":72.24},3,"否"]
["06","202106006",{"v":69,"d":"69.00"},{"v":80.6,"d":"80.60"},{"v":89,"d":"89.00"},{"$f":"C15*0.3+D15*0.3+E15*0.4","v":{"v":80.47999999999999,"d":"80.48"}},1,"是"]
["06","202106005",{"v":65,"d":"65.00"},{"v":82.6,"d":"82.60"},{"v":81.4,"d":"81.40"},{"$f":"C16*0.3+D16*0.3+E16*0.4","v":76.84},2,"否"]
["06","202106001",{"v":60,"d":"60.00"},{"v":79.2,"d":"79.20"},{"v":81.2,"d":"81.20"},{"$f":"C17*0.3+D17*0.3+E17*0.4","v":{"v":74.24000000000001,"d":"74.24"}},3,"否"]
["07","202107008",{"v":80,"d":"80.00"},{"v":77.8,"d":"77.80"},{"v":84.2,"d":"84.20"},{"$f":"C18*0.3+D18*0.3+E18*0.4","v":{"v":81.02000000000001,"d":"81.02"}},1,"是"]
["07","202107003",{"v":87,"d":"87.00"},{"v":80,"d":"80.00"},{"v":75.8,"d":"75.80"},{"$f":"C19*0.3+D19*0.3+E19*0.4","v":{"v":80.41999999999999,"d":"80.42"}},2,"否"]
["07","202107014",{"v":73,"d":"73.00"},{"v":81.6,"d":"81.60"},{"v":84,"d":"84.00"},{"$f":"C20*0.3+D20*0.3+E20*0.4","v":{"v":79.97999999999999,"d":"79.98"}},3,"否"]
["08","202108001",{"v":68,"d":"68.00"},{"v":80.8,"d":"80.80"},{"v":84,"d":"84.00"},{"$f":"C21*0.3+D21*0.3+E21*0.4","v":{"v":78.24000000000001,"d":"78.24"}},1,"是"]
["08","202108002",{"v":64,"d":"64.00"},{"v":77.6,"d":"77.60"},{"v":85.6,"d":"85.60"},76.72,2,"否"]
["08","202108004",{"v":67,"d":"67.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":20.099999999999998,"d":"20.10"},3,"否"]
["09","202109015",{"v":64,"d":"64.00"},{"v":80.4,"d":"80.40"},{"v":88.2,"d":"88.20"},{"$f":"C24*0.3+D24*0.3+E24*0.4","v":{"v":78.6,"d":"78.60"}},1,"是"]
["09","202109002",{"v":64,"d":"64.00"},{"v":84.4,"d":"84.40"},{"v":79.4,"d":"79.40"},{"$f":"C25*0.3+D25*0.3+E25*0.4","v":76.28},2,"否"]
["09","202109011",{"v":67,"d":"67.00"},{"v":73.7,"d":"73.70"},{"v":78.2,"d":"78.20"},{"$f":"C26*0.3+D26*0.3+E26*0.4","v":73.49},3,"否"]
["11","202111004",{"v":78,"d":"78.00"},{"v":85.8,"d":"85.80"},{"v":75.8,"d":"75.80"},{"v":79.46000000000001,"d":"79.46"},1,"是"]
["11","202111007",{"v":71,"d":"71.00"},{"v":84.4,"d":"84.40"},{"v":81.4,"d":"81.40"},79.18,2,"否"]
["11","202111009",{"v":64,"d":"64.00"},{"v":83,"d":"83.00"},{"v":87,"d":"87.00"},{"v":78.9,"d":"78.90"},3,"否"]
["12","202112003",{"v":64,"d":"64.00"},{"v":90.6,"d":"90.60"},{"v":86.6,"d":"86.60"},81.02,1,"是"]
["12","202112004",{"v":68,"d":"68.00"},{"v":80.4,"d":"80.40"},{"v":90.6,"d":"90.60"},{"v":80.75999999999999,"d":"80.76"},2,"否"]
["12","202112005",{"v":62,"d":"62.00"},{"v":90.2,"d":"90.20"},{"v":83.8,"d":"83.80"},79.18,3,"否"]
["12","202112007",{"v":62,"d":"62.00"},{"v":87.2,"d":"87.20"},{"v":84,"d":"84.00"},78.36,4,"否"]
["12","202112009",{"v":62,"d":"62.00"},{"v":83,"d":"83.00"},{"v":78.6,"d":"78.60"},74.94,5,"否"]
["13","202113001",{"v":65,"d":"65.00"},{"v":90.6,"d":"90.60"},{"v":89.8,"d":"89.80"},{"$f":"C35*0.3+D35*0.3+E35*0.4","v":{"v":82.6,"d":"82.60"}},1,"是"]
["13","202113003",{"v":72,"d":"72.00"},{"v":81.2,"d":"81.20"},{"v":83.8,"d":"83.80"},{"$f":"C36*0.3+D36*0.3+E36*0.4","v":{"v":79.47999999999999,"d":"79.48"}},2,"否"]
["13","202113002",{"v":67,"d":"67.00"},{"v":78.2,"d":"78.20"},{"v":81.6,"d":"81.60"},{"$f":"C37*0.3+D37*0.3+E37*0.4","v":{"v":76.2,"d":"76.20"}},3,"否"]
["14","202114003",{"v":75,"d":"75.00"},{"v":86,"d":"86.00"},{"v":90.6,"d":"90.60"},{"v":84.53999999999999,"d":"84.54"},1,"是"]
["14","202114012",{"v":75,"d":"75.00"},{"v":85.4,"d":"85.40"},{"v":79.4,"d":"79.40"},{"v":79.88000000000001,"d":"79.88"},2,"否"]
["14","202114025",{"v":73,"d":"73.00"},{"v":81.2,"d":"81.20"},{"v":79.6,"d":"79.60"},{"v":78.1,"d":"78.10"},3,"否"]
["16","202116003",{"v":81,"d":"81.00"},{"v":89.4,"d":"89.40"},{"v":82.4,"d":"82.40"},{"$f":"C41*0.3+D41*0.3+E41*0.4","v":{"v":84.08000000000001,"d":"84.08"}},1,"是"]
["16","202116039",{"v":77,"d":"77.00"},{"v":81,"d":"81.00"},{"v":89.4,"d":"89.40"},{"$f":"C42*0.3+D42*0.3+E42*0.4","v":83.16},2,"否"]
["16","202116001",{"v":75,"d":"75.00"},{"v":84.8,"d":"84.80"},{"v":85,"d":"85.00"},{"$f":"C43*0.3+D43*0.3+E43*0.4","v":81.94},3,"否"]
[17,"202117017",{"v":75,"d":"75.00"},{"v":85,"d":"85.00"},{"v":88.2,"d":"88.20"},{"$f":"C44*0.4+D44*0.3+E44*0.3","v":{"v":81.96000000000001,"d":"81.96"}},1,"是"]
[17,"202117028",{"v":75,"d":"75.00"},{"v":85.2,"d":"85.20"},{"v":78.8,"d":"78.80"},{"$f":"C45*0.4+D45*0.3+E45*0.3","v":{"v":79.2,"d":"79.20"}},2,"否"]
[17,"202117001",{"v":75,"d":"75.00"},{"v":81.4,"d":"81.40"},{"v":74.6,"d":"74.60"},{"$f":"C46*0.4+D46*0.3+E46*0.3","v":{"v":76.8,"d":"76.80"}},3,"否"]
[17,"202117025",{"v":79,"d":"79.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C47*0.4+D47*0.3+E47*0.3","v":{"v":31.6,"d":"31.60"}},4,"否"]
[18,"202118063",{"v":84,"d":"84.00"},{"v":89.2,"d":"89.20"},{"v":89,"d":"89.00"},{"$f":"C48*0.4+D48*0.3+E48*0.3","v":87.06},1,"是"]
[18,"202118094",{"v":84,"d":"84.00"},{"v":83.2,"d":"83.20"},{"v":89.4,"d":"89.40"},{"$f":"C49*0.4+D49*0.3+E49*0.3","v":85.38},2,"是"]
[18,"202118264",{"v":83,"d":"83.00"},{"v":91.6,"d":"91.60"},{"v":80.2,"d":"80.20"},{"$f":"C50*0.4+D50*0.3+E50*0.3","v":84.74},3,"否"]
[18,"202118215",{"v":83,"d":"83.00"},{"v":82.6,"d":"82.60"},{"v":88,"d":"88.00"},{"$f":"C51*0.4+D51*0.3+E51*0.3","v":84.38},4,"否"]
[18,"202118247",{"v":86,"d":"86.00"},{"v":85.8,"d":"85.80"},{"v":80.8,"d":"80.80"},{"$f":"C52*0.4+D52*0.3+E52*0.3","v":84.38},4,"否"]
[18,"202118213",{"v":86,"d":"86.00"},{"v":88,"d":"88.00"},{"v":76.8,"d":"76.80"},{"$f":"C53*0.4+D53*0.3+E53*0.3","v":83.84},6,"否"]
[18,"202118198",{"v":88,"d":"88.00"},{"v":83.6,"d":"83.60"},{"v":75.8,"d":"75.80"},{"$f":"C54*0.4+D54*0.3+E54*0.3","v":83.02},7,"否"]
[18,"202118186",{"v":83,"d":"83.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C55*0.4+D55*0.3+E55*0.3","v":{"v":33.2,"d":"33.20"}},8,"否"]
["备注：1.02-16岗按百分制折算综合成绩，其中笔试占综合成绩的30%，面试占综合成绩的30%，试讲成绩占综合成绩的40%；2.17、18岗按百分制折算综合成绩，其中笔试占综合成绩的40%，面试占综合成绩的30%，试讲占综合成绩的30%；3.成绩计算结果精确到小数点后两位数。"]