{"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":63,"n_cols":13,"rows_kept":63,"merged":[[0,0,0,1],[1,0,1,12]]}
["附件："]
["雷山县2024年公开选聘城市社区工作者面试成绩、总成绩\n及进入体检环节人员名单"]
["序号","姓名","选聘单位","选聘岗位代码","面试准考\n证号","笔试\n成绩","面试\n成绩","笔试折算分数（50%）","面试折算分数（50%）","综合\n成绩","综合成绩排名","是否入围体检","备注"]
["1","唐红艳","响楼社区","24210","1420240101",{"v":76.1,"d":"76.10"},{"v":77.2,"d":"77.20"},{"$f":"ROUND(F4*50%,2)","v":38.05},{"$f":"ROUND(G4*50%,2)","v":{"v":38.6,"d":"38.60"}},{"$f":"H4+I4","v":76.65},{"$f":"SUMPRODUCT(($D$3:$D$63=D4)*($J$3:$J$63>J4))+1","v":1},"是"]
["2","杨海龙","响楼社区","24210","1420240102",{"v":73.4,"d":"73.40"},{"v":75.4,"d":"75.40"},{"v":36.7,"d":"36.70"},{"v":37.7,"d":"37.70"},{"v":74.4,"d":"74.40"},{"$f":"SUMPRODUCT(($D$3:$D$63=D5)*($J$3:$J$63>J5))+1","v":2}]
["3","张万荣","响楼社区","24210","1420240103",{"v":71.5,"d":"71.50"},{"v":38,"d":"38.00"},35.75,{"v":19,"d":"19.00"},54.75,{"$f":"SUMPRODUCT(($D$3:$D$63=D6)*($J$3:$J$63>J6))+1","v":3}]
["4","赵友芳","南门社区","24211","1420240104",{"v":84.6,"d":"84.60"},{"v":81,"d":"81.00"},{"v":42.3,"d":"42.30"},{"v":40.5,"d":"40.50"},{"v":82.8,"d":"82.80"},{"$f":"SUMPRODUCT(($D$3:$D$63=D7)*($J$3:$J$63>J7))+1","v":1},"是"]
["5","周晓群","南门社区","24211","1420240106",{"v":80.5,"d":"80.50"},{"v":80.4,"d":"80.40"},40.25,{"v":40.2,"d":"40.20"},80.45,{"$f":"SUMPRODUCT(($D$3:$D$63=D8)*($J$3:$J$63>J8))+1","v":2},"是"]
["6","林安伟","南门社区","24211","1420240105",{"v":81,"d":"81.00"},{"v":77,"d":"77.00"},{"v":40.5,"d":"40.50"},{"v":38.5,"d":"38.50"},{"v":79,"d":"79.00"},{"$f":"SUMPRODUCT(($D$3:$D$63=D9)*($J$3:$J$63>J9))+1","v":3},"是"]
["7","潘红莲","南门社区","24211","1420240110",{"v":66.9,"d":"66.90"},{"v":86.2,"d":"86.20"},33.45,{"v":43.1,"d":"43.10"},76.55,{"$f":"SUMPRODUCT(($D$3:$D$63=D10)*($J$3:$J$63>J10))+1","v":4},"是"]
["8","张仕晶","南门社区","24211","1420240107",{"v":75,"d":"75.00"},{"v":77.6,"d":"77.60"},{"v":37.5,"d":"37.50"},{"v":38.8,"d":"38.80"},{"v":76.3,"d":"76.30"},{"$f":"SUMPRODUCT(($D$3:$D$63=D11)*($J$3:$J$63>J11))+1","v":5}]
["9","任丽霜","南门社区","24211","1420240114",{"v":63.8,"d":"63.80"},{"v":79,"d":"79.00"},{"v":31.9,"d":"31.90"},{"v":39.5,"d":"39.50"},{"v":71.4,"d":"71.40"},{"$f":"SUMPRODUCT(($D$3:$D$63=D12)*($J$3:$J$63>J12))+1","v":6}]
["10","陈丹","南门社区","24211","1420240113",{"v":64.6,"d":"64.60"},{"v":77.4,"d":"77.40"},{"v":32.3,"d":"32.30"},{"v":38.7,"d":"38.70"},{"v":71,"d":"71.00"},{"$f":"SUMPRODUCT(($D$3:$D$63=D13)*($J$3:$J$63>J13))+1","v":7}]
["11","孔德荣","南门社区","24211","1420240109",{"v":69.4,"d":"69.40"},{"v":70.8,"d":"70.80"},{"v":34.7,"d":"34.70"},{"v":35.4,"d":"35.40"},{"v":70.1,"d":"70.10"},{"$f":"SUMPRODUCT(($D$3:$D$63=D14)*($J$3:$J$63>J14))+1","v":8}]
["12","莫世西","南门社区","24211","1420240108",{"v":72,"d":"72.00"},{"v":63.6,"d":"63.60"},{"v":36,"d":"36.00"},{"v":31.8,"d":"31.80"},{"v":67.8,"d":"67.80"},{"$f":"SUMPRODUCT(($D$3:$D$63=D15)*($J$3:$J$63>J15))+1","v":9}]
["13","李晓菊","南门社区","24211","1420240112",{"v":64.8,"d":"64.80"},{"v":66.4,"d":"66.40"},{"v":32.4,"d":"32.40"},{"v":33.2,"d":"33.20"},{"v":65.6,"d":"65.60"},{"$f":"SUMPRODUCT(($D$3:$D$63=D16)*($J$3:$J$63>J16))+1","v":10}]
["14","杨茂馨","南门社区","24211","1420240115",{"v":63.1,"d":"63.10"},{"v":65.6,"d":"65.60"},31.55,{"v":32.8,"d":"32.80"},64.35,{"$f":"SUMPRODUCT(($D$3:$D$63=D17)*($J$3:$J$63>J17))+1","v":11}]
["15","谢泽民","南门社区","24211","1420240111",{"v":65.5,"d":"65.50"},0,32.75,{"v":0,"d":"0.00"},32.75,{"$f":"SUMPRODUCT(($D$3:$D$63=D18)*($J$3:$J$63>J18))+1","v":12}]
["16","文仁琴","南门社区","24212","1420240116",{"v":84.5,"d":"84.50"},{"v":83.4,"d":"83.40"},42.25,{"v":41.7,"d":"41.70"},83.95,{"$f":"SUMPRODUCT(($D$3:$D$63=D19)*($J$3:$J$63>J19))+1","v":1},"是"]
["17","陆魁舰","南门社区","24212","1420240120",{"v":78.9,"d":"78.90"},{"v":87.8,"d":"87.80"},39.45,{"v":43.9,"d":"43.90"},83.35,{"$f":"SUMPRODUCT(($D$3:$D$63=D20)*($J$3:$J$63>J20))+1","v":2},"是"]
["18","李惠","南门社区","24212","1420240117",{"v":81,"d":"81.00"},{"v":82.4,"d":"82.40"},{"v":40.5,"d":"40.50"},{"v":41.2,"d":"41.20"},{"v":81.7,"d":"81.70"},{"$f":"SUMPRODUCT(($D$3:$D$63=D21)*($J$3:$J$63>J21))+1","v":3},"是"]
["19","李文艳","南门社区","24212","1420240124",{"v":76.5,"d":"76.50"},{"v":86.8,"d":"86.80"},38.25,{"v":43.4,"d":"43.40"},81.65,{"$f":"SUMPRODUCT(($D$3:$D$63=D22)*($J$3:$J$63>J22))+1","v":4},"是"]
["20","余一凡","南门社区","24212","1420240118",{"v":80,"d":"80.00"},{"v":81.2,"d":"81.20"},{"v":40,"d":"40.00"},{"v":40.6,"d":"40.60"},{"v":80.6,"d":"80.60"},{"$f":"SUMPRODUCT(($D$3:$D$63=D23)*($J$3:$J$63>J23))+1","v":5}]
["21","杨启明","南门社区","24212","1420240122",{"v":77.5,"d":"77.50"},{"v":82.4,"d":"82.40"},38.75,{"v":41.2,"d":"41.20"},79.95,{"$f":"SUMPRODUCT(($D$3:$D$63=D24)*($J$3:$J$63>J24))+1","v":6}]
["22","朱锦鸿","南门社区","24212","1420240119",{"v":78.9,"d":"78.90"},{"v":79.6,"d":"79.60"},39.45,{"v":39.8,"d":"39.80"},79.25,{"$f":"SUMPRODUCT(($D$3:$D$63=D25)*($J$3:$J$63>J25))+1","v":7}]
["23","任青青","南门社区","24212","1420240126",{"v":76.3,"d":"76.30"},{"v":80.4,"d":"80.40"},38.15,{"v":40.2,"d":"40.20"},78.35,{"$f":"SUMPRODUCT(($D$3:$D$63=D26)*($J$3:$J$63>J26))+1","v":8}]
["24","任永露","南门社区","24212","1420240125",{"v":76.3,"d":"76.30"},{"v":78.6,"d":"78.60"},38.15,{"v":39.3,"d":"39.30"},77.45,{"$f":"SUMPRODUCT(($D$3:$D$63=D27)*($J$3:$J$63>J27))+1","v":9}]
["25","吴兴志","南门社区","24212","1420240121",{"v":77.5,"d":"77.50"},{"v":77.2,"d":"77.20"},38.75,{"v":38.6,"d":"38.60"},77.35,{"$f":"SUMPRODUCT(($D$3:$D$63=D28)*($J$3:$J$63>J28))+1","v":10}]
["26","李舒婷","南门社区","24212","1420240127",{"v":76.1,"d":"76.10"},{"v":76.2,"d":"76.20"},38.05,{"v":38.1,"d":"38.10"},76.15,{"$f":"SUMPRODUCT(($D$3:$D$63=D29)*($J$3:$J$63>J29))+1","v":11}]
["27","余旭东","南门社区","24212","1420240123",{"v":76.7,"d":"76.70"},{"v":75,"d":"75.00"},38.35,{"v":37.5,"d":"37.50"},75.85,{"$f":"SUMPRODUCT(($D$3:$D$63=D30)*($J$3:$J$63>J30))+1","v":12}]
["28","李娜","教厂坝社区","24213","1420240201",{"v":76.7,"d":"76.70"},{"v":82.4,"d":"82.40"},38.35,{"v":41.2,"d":"41.20"},79.55,{"$f":"SUMPRODUCT(($D$3:$D$63=D31)*($J$3:$J$63>J31))+1","v":1},"是"]
["29","杨瑶","教厂坝社区","24213","1420240202",{"v":76,"d":"76.00"},{"v":82,"d":"82.00"},{"v":38,"d":"38.00"},{"v":41,"d":"41.00"},{"v":79,"d":"79.00"},{"$f":"SUMPRODUCT(($D$3:$D$63=D32)*($J$3:$J$63>J32))+1","v":2}]
["30","江仕香","教厂坝社区","24213","1420240203",{"v":74.6,"d":"74.60"},{"v":75,"d":"75.00"},{"v":37.3,"d":"37.30"},{"v":37.5,"d":"37.50"},{"v":74.8,"d":"74.80"},{"$f":"SUMPRODUCT(($D$3:$D$63=D33)*($J$3:$J$63>J33))+1","v":3}]
["31","白会会","城南社区","24214","1420240214",{"v":71.2,"d":"71.20"},{"v":87.4,"d":"87.40"},{"v":35.6,"d":"35.60"},{"v":43.7,"d":"43.70"},{"v":79.3,"d":"79.30"},{"$f":"SUMPRODUCT(($D$3:$D$63=D34)*($J$3:$J$63>J34))+1","v":1},"是"]
["32","文文","城南社区","24214","1420240218",{"v":70.2,"d":"70.20"},{"v":87.8,"d":"87.80"},{"v":35.1,"d":"35.10"},{"v":43.9,"d":"43.90"},{"v":79,"d":"79.00"},{"$f":"SUMPRODUCT(($D$3:$D$63=D35)*($J$3:$J$63>J35))+1","v":2},"是"]
["33","杨昌来","城南社区","24214","1420240209",{"v":73,"d":"73.00"},{"v":84.6,"d":"84.60"},{"v":36.5,"d":"36.50"},{"v":42.3,"d":"42.30"},{"v":78.8,"d":"78.80"},{"$f":"SUMPRODUCT(($D$3:$D$63=D36)*($J$3:$J$63>J36))+1","v":3},"是"]
["34","淳奥熙","城南社区","24214","1420240221",{"v":69.9,"d":"69.90"},{"v":86.6,"d":"86.60"},34.95,{"v":43.3,"d":"43.30"},78.25,{"$f":"SUMPRODUCT(($D$3:$D$63=D37)*($J$3:$J$63>J37))+1","v":4},"是"]
["35","杨再彪","城南社区","24214","1420240207",{"v":74.8,"d":"74.80"},{"v":81,"d":"81.00"},{"v":37.4,"d":"37.40"},{"v":40.5,"d":"40.50"},{"v":77.9,"d":"77.90"},{"$f":"SUMPRODUCT(($D$3:$D$63=D38)*($J$3:$J$63>J38))+1","v":5},"是"]
["36","高小丽","城南社区","24214","1420240208",{"v":73.5,"d":"73.50"},{"v":79,"d":"79.00"},36.75,{"v":39.5,"d":"39.50"},76.25,{"$f":"SUMPRODUCT(($D$3:$D$63=D39)*($J$3:$J$63>J39))+1","v":6},"是"]
["37","文思达","城南社区","24214","1420240211",{"v":72.1,"d":"72.10"},{"v":79.8,"d":"79.80"},36.05,{"v":39.9,"d":"39.90"},75.95,{"$f":"SUMPRODUCT(($D$3:$D$63=D40)*($J$3:$J$63>J40))+1","v":7}]
["38","杨金秋","城南社区","24214","1420240205",{"v":75.6,"d":"75.60"},{"v":75,"d":"75.00"},{"v":37.8,"d":"37.80"},{"v":37.5,"d":"37.50"},{"v":75.3,"d":"75.30"},{"$f":"SUMPRODUCT(($D$3:$D$63=D41)*($J$3:$J$63>J41))+1","v":8}]
["39","唐秋艳","城南社区","24214","1420240204",{"v":78.3,"d":"78.30"},{"v":71.4,"d":"71.40"},39.15,{"v":35.7,"d":"35.70"},74.85,{"$f":"SUMPRODUCT(($D$3:$D$63=D42)*($J$3:$J$63>J42))+1","v":9}]
["40","莫佳","城南社区","24214","1420240219",{"v":70.1,"d":"70.10"},{"v":79.4,"d":"79.40"},35.05,{"v":39.7,"d":"39.70"},74.75,{"$f":"SUMPRODUCT(($D$3:$D$63=D43)*($J$3:$J$63>J43))+1","v":10}]
["41","侯胜榜","城南社区","24214","1420240217",{"v":70.5,"d":"70.50"},{"v":78.8,"d":"78.80"},35.25,{"v":39.4,"d":"39.40"},74.65,{"$f":"SUMPRODUCT(($D$3:$D$63=D44)*($J$3:$J$63>J44))+1","v":11}]
["42","余成龙","城南社区","24214","1420240210",{"v":72.3,"d":"72.30"},{"v":74.4,"d":"74.40"},36.15,{"v":37.2,"d":"37.20"},73.35,{"$f":"SUMPRODUCT(($D$3:$D$63=D45)*($J$3:$J$63>J45))+1","v":12}]
["43","张浚清","城南社区","24214","1420240206",{"v":74.9,"d":"74.90"},{"v":70.6,"d":"70.60"},37.45,{"v":35.3,"d":"35.30"},72.75,{"$f":"SUMPRODUCT(($D$3:$D$63=D46)*($J$3:$J$63>J46))+1","v":13}]
["44","张凤","城南社区","24214","1420240216",{"v":70.6,"d":"70.60"},{"v":74.4,"d":"74.40"},{"v":35.3,"d":"35.30"},{"v":37.2,"d":"37.20"},{"v":72.5,"d":"72.50"},{"$f":"SUMPRODUCT(($D$3:$D$63=D47)*($J$3:$J$63>J47))+1","v":14}]
["45","姜兴平","城南社区","24214","1420240212",{"v":71.9,"d":"71.90"},{"v":73,"d":"73.00"},35.95,{"v":36.5,"d":"36.50"},72.45,{"$f":"SUMPRODUCT(($D$3:$D$63=D48)*($J$3:$J$63>J48))+1","v":15}]
["46","吴胜龙","城南社区","24214","1420240213",{"v":71.7,"d":"71.70"},{"v":67.2,"d":"67.20"},35.85,{"v":33.6,"d":"33.60"},69.45,{"$f":"SUMPRODUCT(($D$3:$D$63=D49)*($J$3:$J$63>J49))+1","v":16}]
["47","何孝燕","城南社区","24214","1420240220",{"v":70,"d":"70.00"},{"v":68,"d":"68.00"},{"v":35,"d":"35.00"},{"v":34,"d":"34.00"},{"v":69,"d":"69.00"},{"$f":"SUMPRODUCT(($D$3:$D$63=D50)*($J$3:$J$63>J50))+1","v":17}]
["48","张驰","城南社区","24214","1420240215",{"v":71.1,"d":"71.10"},0,35.55,{"v":0,"d":"0.00"},35.55,{"$f":"SUMPRODUCT(($D$3:$D$63=D51)*($J$3:$J$63>J51))+1","v":18}]
["49","李宏林","连心社区","24215","1420240222",{"v":74.6,"d":"74.60"},{"v":87.8,"d":"87.80"},{"v":37.3,"d":"37.30"},{"v":43.9,"d":"43.90"},{"v":81.2,"d":"81.20"},{"$f":"SUMPRODUCT(($D$3:$D$63=D52)*($J$3:$J$63>J52))+1","v":1},"是"]
["50","李鹏程","连心社区","24215","1420240225",{"v":69.2,"d":"69.20"},{"v":84.2,"d":"84.20"},{"v":34.6,"d":"34.60"},{"v":42.1,"d":"42.10"},{"v":76.7,"d":"76.70"},{"$f":"SUMPRODUCT(($D$3:$D$63=D53)*($J$3:$J$63>J53))+1","v":2},"是"]
["51","刘毅","连心社区","24215","1420240230",{"v":65.9,"d":"65.90"},{"v":87.4,"d":"87.40"},32.95,{"v":43.7,"d":"43.70"},76.65,{"$f":"SUMPRODUCT(($D$3:$D$63=D54)*($J$3:$J$63>J54))+1","v":3},"是"]
["52","李颖娟","连心社区","24215","1420240229",{"v":67.2,"d":"67.20"},{"v":80.4,"d":"80.40"},{"v":33.6,"d":"33.60"},{"v":40.2,"d":"40.20"},{"v":73.8,"d":"73.80"},{"$f":"SUMPRODUCT(($D$3:$D$63=D55)*($J$3:$J$63>J55))+1","v":4}]
["53","龙怀仁","连心社区","24215","1420240227",{"v":68.4,"d":"68.40"},{"v":74.6,"d":"74.60"},{"v":34.2,"d":"34.20"},{"v":37.3,"d":"37.30"},{"v":71.5,"d":"71.50"},{"$f":"SUMPRODUCT(($D$3:$D$63=D56)*($J$3:$J$63>J56))+1","v":5}]
["54","吴佳楠","连心社区","24215","1420240228",{"v":67.4,"d":"67.40"},{"v":75,"d":"75.00"},{"v":33.7,"d":"33.70"},{"v":37.5,"d":"37.50"},{"v":71.2,"d":"71.20"},{"$f":"SUMPRODUCT(($D$3:$D$63=D57)*($J$3:$J$63>J57))+1","v":6}]
["55","李富","连心社区","24215","1420240223",{"v":69.5,"d":"69.50"},{"v":69.6,"d":"69.60"},34.75,{"v":34.8,"d":"34.80"},69.55,{"$f":"SUMPRODUCT(($D$3:$D$63=D58)*($J$3:$J$63>J58))+1","v":7}]
["56","刘念","连心社区","24215","1420240226",{"v":68.9,"d":"68.90"},{"v":68.4,"d":"68.40"},34.45,{"v":34.2,"d":"34.20"},68.65,{"$f":"SUMPRODUCT(($D$3:$D$63=D59)*($J$3:$J$63>J59))+1","v":8}]
["57","蒲灵枫","连心社区","24215","1420240224",{"v":69.5,"d":"69.50"},0,34.75,{"v":0,"d":"0.00"},34.75,{"$f":"SUMPRODUCT(($D$3:$D$63=D60)*($J$3:$J$63>J60))+1","v":9}]
["58","杨建华","观音阁社区","24216","1420240129",{"v":71.6,"d":"71.60"},{"v":78.9,"d":"78.90"},{"v":35.8,"d":"35.80"},39.45,75.25,{"$f":"SUMPRODUCT(($D$3:$D$63=D61)*($J$3:$J$63>J61))+1","v":1},"是"]
["59","杨绍竹","观音阁社区","24216","1420240128",{"v":71.9,"d":"71.90"},{"v":77,"d":"77.00"},35.95,{"v":38.5,"d":"38.50"},74.45,{"$f":"SUMPRODUCT(($D$3:$D$63=D62)*($J$3:$J$63>J62))+1","v":2}]
["60","潘其周","观音阁社区","24216","1420240130",{"v":71.3,"d":"71.30"},{"v":75.2,"d":"75.20"},35.65,{"v":37.6,"d":"37.60"},73.25,{"$f":"SUMPRODUCT(($D$3:$D$63=D63)*($J$3:$J$63>J63))+1","v":3}]