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

{"sheet":"sheet1","index":0,"n_rows":21,"n_cols":12,"rows_kept":21,"merged":[[1,0,1,11]]}
["附件1："]
["雷山县教育系统2024年专项招聘事业单位工作人员综合成绩排名、入围体检名单"]
["序号","姓名","招聘单位","招聘岗位代码","笔试成绩","面试成绩","笔试折算分数（50%）","面试折算分数（50%）","综合成绩","综合成绩排名","是否入围体检","备注"]
["1","余乐","雷山县第一中学","142024001",{"v":74.3,"d":"74.30"},81.85,{"$f":"ROUND(E4*50%,2)","v":37.15},{"$f":"ROUND(F4*50%,2)","v":40.93},{"$f":"G4+H4","v":78.08},{"$f":"SUMPRODUCT((D$3:D$21=D4)*(I$3:I$21>I4))+1","v":1},"是"]
["2","韩余凯","雷山县第一中学","142024001",{"v":73.6,"d":"73.60"},75.55,{"v":36.8,"d":"36.80"},37.78,74.58,{"$f":"SUMPRODUCT((D$3:D$21=D5)*(I$3:I$21>I5))+1","v":2}]
["3","胡仕洋","雷山县第一中学","142024001",{"v":69.1,"d":"69.10"},77.78,34.55,38.89,73.44,{"$f":"SUMPRODUCT((D$3:D$21=D6)*(I$3:I$21>I6))+1","v":3}]
["4","杨锌","雷山县第三中学","142024002",{"v":74.3,"d":"74.30"},80.55,37.15,40.28,77.43,{"$f":"SUMPRODUCT((D$3:D$21=D7)*(I$3:I$21>I7))+1","v":1},"是"]
["5","王元生","雷山县第三中学","142024002",{"v":72.3,"d":"72.30"},80.85,36.15,40.43,76.58,{"$f":"SUMPRODUCT((D$3:D$21=D8)*(I$3:I$21>I8))+1","v":2}]
["6","陈宗美","雷山县第三中学","142024002",{"v":75.5,"d":"75.50"},75.71,37.75,37.86,75.61,{"$f":"SUMPRODUCT((D$3:D$21=D9)*(I$3:I$21>I9))+1","v":3}]
["7","田洪明","雷山县第二中学","142024003",{"v":85.9,"d":"85.90"},81.48,42.95,40.74,83.69,{"$f":"SUMPRODUCT((D$3:D$21=D10)*(I$3:I$21>I10))+1","v":1},"是"]
["8","罗开洁","雷山县第二中学","142024003",{"v":82.6,"d":"82.60"},83.42,{"v":41.3,"d":"41.30"},41.71,83.01,{"$f":"SUMPRODUCT((D$3:D$21=D11)*(I$3:I$21>I11))+1","v":2}]
["9","甘红梅","雷山县第二中学","142024003",{"v":78.4,"d":"78.40"},83.06,{"v":39.2,"d":"39.20"},41.53,80.73,{"$f":"SUMPRODUCT((D$3:D$21=D12)*(I$3:I$21>I12))+1","v":3}]
["10","李慧","雷山县思源实验学校","142024004",{"v":78.2,"d":"78.20"},86.55,{"v":39.1,"d":"39.10"},43.28,82.38,{"$f":"SUMPRODUCT((D$3:D$21=D13)*(I$3:I$21>I13))+1","v":1},"是"]
["11","王小翠","雷山县思源实验学校","142024004",{"v":80.2,"d":"80.20"},82.81,{"v":40.1,"d":"40.10"},41.41,81.51,{"$f":"SUMPRODUCT((D$3:D$21=D14)*(I$3:I$21>I14))+1","v":2}]
["12","罗卫红","雷山县思源实验学校","142024004",{"v":78.1,"d":"78.10"},{"v":82.6,"d":"82.60"},39.05,{"v":41.3,"d":"41.30"},80.35,{"$f":"SUMPRODUCT((D$3:D$21=D15)*(I$3:I$21>I15))+1","v":3}]
["13","龙澜","雷山县第三中学","142024005",{"v":78.2,"d":"78.20"},{"v":88.6,"d":"88.60"},{"v":39.1,"d":"39.10"},{"v":44.3,"d":"44.30"},{"v":83.4,"d":"83.40"},{"$f":"SUMPRODUCT((D$3:D$21=D16)*(I$3:I$21>I16))+1","v":1},"是"]
["14","姚茂林","雷山县第三中学","142024005",{"v":79.7,"d":"79.70"},{"v":86.4,"d":"86.40"},39.85,{"v":43.2,"d":"43.20"},83.05,{"$f":"SUMPRODUCT((D$3:D$21=D17)*(I$3:I$21>I17))+1","v":2},"是"]
["15","吴艳","雷山县第三中学","142024005",{"v":82.8,"d":"82.80"},{"v":83,"d":"83.00"},{"v":41.4,"d":"41.40"},{"v":41.5,"d":"41.50"},{"v":82.9,"d":"82.90"},{"$f":"SUMPRODUCT((D$3:D$21=D18)*(I$3:I$21>I18))+1","v":3}]
["16","刘洁","雷山县第三中学","142024005",{"v":78.2,"d":"78.20"},{"v":85.2,"d":"85.20"},{"v":39.1,"d":"39.10"},{"v":42.6,"d":"42.60"},{"v":81.7,"d":"81.70"},{"$f":"SUMPRODUCT((D$3:D$21=D19)*(I$3:I$21>I19))+1","v":4}]
["17","何廷欢","雷山县第三中学","142024005",{"v":78.8,"d":"78.80"},{"v":81.6,"d":"81.60"},{"v":39.4,"d":"39.40"},{"v":40.8,"d":"40.80"},{"v":80.2,"d":"80.20"},{"$f":"SUMPRODUCT((D$3:D$21=D20)*(I$3:I$21>I20))+1","v":5}]
["18","杨陆玲","雷山县第三中学","142024005",{"v":77.4,"d":"77.40"},{"v":79.4,"d":"79.40"},{"v":38.7,"d":"38.70"},{"v":39.7,"d":"39.70"},{"v":78.4,"d":"78.40"},{"$f":"SUMPRODUCT((D$3:D$21=D21)*(I$3:I$21>I21))+1","v":6}]