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

{"sheet":"总成绩","index":0,"n_rows":51,"n_cols":12,"rows_kept":51,"merged":[[0,0,0,11]]}
["龙里县2024年面向镇（街道）公开考调工作人员总成绩"]
["序号","姓名","准考证号","报考单位名称","报考职位名称及代码","笔试成绩","面试成绩","总成绩","排名","是否列为考察对象",{"$f":"SUMPRODUCT(($O$2:$O$7055=O2)*($P$2:$P$7055>P2))+1","v":1},"备注"]
[1,"陈奕志","llkd20240105","龙里县委办公室综合服务中心","工作人员01",{"v":63.7,"d":"63.70"},83.05,{"$f":"ROUND(F3*0.4,2)+ROUND(G3*0.6,2)","v":75.31},{"$f":"SUMPRODUCT(($K$3:$K$51=K3)*($H$3:$H$51>H3))+1","v":1},"是",{"$f":"D3&E3","v":"龙里县委办公室综合服务中心工作人员01"}]
[2,"陈智燊","llkd20240103","龙里县委办公室综合服务中心","工作人员01",{"v":64.2,"d":"64.20"},81.89,74.81,{"$f":"SUMPRODUCT(($K$3:$K$51=K4)*($H$3:$H$51>H4))+1","v":2},"是","龙里县委办公室综合服务中心工作人员01"]
[3,"张涵","llkd20240101","龙里县委办公室综合服务中心","工作人员01",{"v":60.8,"d":"60.80"},83.56,74.46,{"$f":"SUMPRODUCT(($K$3:$K$51=K5)*($H$3:$H$51>H5))+1","v":3},"是","龙里县委办公室综合服务中心工作人员01"]
[4,"段伟程","llkd20240106","龙里县委办公室综合服务中心","工作人员01",{"v":63.8,"d":"63.80"},81.03,74.14,{"$f":"SUMPRODUCT(($K$3:$K$51=K6)*($H$3:$H$51>H6))+1","v":4},"是","龙里县委办公室综合服务中心工作人员01"]
[5,"李子易","llkd20240107","龙里县委办公室综合服务中心","工作人员01",{"v":60.1,"d":"60.10"},81.76,{"v":73.1,"d":"73.10"},{"$f":"SUMPRODUCT(($K$3:$K$51=K7)*($H$3:$H$51>H7))+1","v":5},"是","龙里县委办公室综合服务中心工作人员01"]
[6,"周文玲","llkd20240109","龙里县委办公室综合服务中心","工作人员01",{"v":58.5,"d":"58.50"},79.51,71.11,{"$f":"SUMPRODUCT(($K$3:$K$51=K8)*($H$3:$H$51>H8))+1","v":6},"是","龙里县委办公室综合服务中心工作人员01"]
[7,"谭宇杰","llkd20240116","龙里县保密技术服务中心","工作人员01",{"v":60.5,"d":"60.50"},82.32,73.59,{"$f":"SUMPRODUCT(($K$3:$K$51=K9)*($H$3:$H$51>H9))+1","v":1},"是","龙里县保密技术服务中心工作人员01"]
[8,"付宗政","llkd20240122","龙里县重大项目服务中心","工作人员01",{"v":63.5,"d":"63.50"},82.04,74.62,{"$f":"SUMPRODUCT(($K$3:$K$51=K10)*($H$3:$H$51>H10))+1","v":1},"是","龙里县重大项目服务中心工作人员01"]
[9,"胡涛","llkd20240118","龙里县重大项目服务中心","工作人员01",{"v":60.5,"d":"60.50"},79.21,71.73,{"$f":"SUMPRODUCT(($K$3:$K$51=K11)*($H$3:$H$51>H11))+1","v":2},"是","龙里县重大项目服务中心工作人员01"]
[10,"陈婷婷","llkd20240120","龙里县重大项目服务中心","工作人员01",{"v":61.6,"d":"61.60"},{"v":70.5,"d":"70.50"},66.94,{"$f":"SUMPRODUCT(($K$3:$K$51=K12)*($H$3:$H$51>H12))+1","v":3},"是","龙里县重大项目服务中心工作人员01"]
[11,"娄红红","llkd20240121","龙里县重大项目服务中心","工作人员01",{"v":49.9,"d":"49.90"},73.59,64.11,{"$f":"SUMPRODUCT(($K$3:$K$51=K13)*($H$3:$H$51>H13))+1","v":4},null,"龙里县重大项目服务中心工作人员01"]
[12,"彭游","llkd20240123","龙里县重大项目服务中心","工作人员01",{"v":51.7,"d":"51.70"},70.35,62.89,{"$f":"SUMPRODUCT(($K$3:$K$51=K14)*($H$3:$H$51>H14))+1","v":5},null,"龙里县重大项目服务中心工作人员01"]
[13,"韦熙菊","llkd20240124","龙里县档案史志馆","工作人员01",{"v":61.4,"d":"61.40"},74.43,69.22,{"$f":"SUMPRODUCT(($K$3:$K$51=K15)*($H$3:$H$51>H15))+1","v":1},"是","龙里县档案史志馆工作人员01"]
[14,"陈凤蓉","llkd20240203","龙里县人民政府办公室","工作人员01",{"v":74.6,"d":"74.60"},80.66,78.24,{"$f":"SUMPRODUCT(($K$3:$K$51=K16)*($H$3:$H$51>H16))+1","v":1},"是","龙里县人民政府办公室工作人员01"]
[15,"冯明菊","llkd20240204","龙里县人民政府办公室","工作人员01",{"v":60.4,"d":"60.40"},77.72,70.79,{"$f":"SUMPRODUCT(($K$3:$K$51=K17)*($H$3:$H$51>H17))+1","v":2},"是","龙里县人民政府办公室工作人员01"]
[16,"崔旭张","llkd20240201","龙里县人民政府办公室","工作人员01",{"v":52.8,"d":"52.80"},81.22,69.85,{"$f":"SUMPRODUCT(($K$3:$K$51=K18)*($H$3:$H$51>H18))+1","v":3},"是","龙里县人民政府办公室工作人员01"]
[17,"刘俊兰","llkd20240206","龙里县人民政府经济发展研究中心","工作人员01",{"v":67.8,"d":"67.80"},78.75,74.37,{"$f":"SUMPRODUCT(($K$3:$K$51=K19)*($H$3:$H$51>H19))+1","v":1},"是","龙里县人民政府经济发展研究中心工作人员01"]
[18,"胡基刚","llkd20240209","龙里县人民政府经济发展研究中心","工作人员01",{"v":65.2,"d":"65.20"},76.78,72.15,{"$f":"SUMPRODUCT(($K$3:$K$51=K20)*($H$3:$H$51>H20))+1","v":2},"是","龙里县人民政府经济发展研究中心工作人员01"]
[19,"李红云","llkd20240208","龙里县人民政府经济发展研究中心","工作人员01",{"v":59.8,"d":"59.80"},79.61,71.69,{"$f":"SUMPRODUCT(($K$3:$K$51=K21)*($H$3:$H$51>H21))+1","v":3},"是","龙里县人民政府经济发展研究中心工作人员01"]
[20,"罗林祥","llkd20240213","龙里县人民政府经济发展研究中心","工作人员01",{"v":60.3,"d":"60.30"},77.58,70.67,{"$f":"SUMPRODUCT(($K$3:$K$51=K22)*($H$3:$H$51>H22))+1","v":4},null,"龙里县人民政府经济发展研究中心工作人员01"]
[21,"罗倩梅","llkd20240210","龙里县人民政府经济发展研究中心","工作人员01",{"v":55.5,"d":"55.50"},76.46,68.08,{"$f":"SUMPRODUCT(($K$3:$K$51=K23)*($H$3:$H$51>H23))+1","v":5},null,"龙里县人民政府经济发展研究中心工作人员01"]
[22,"周璇","llkd20240214","龙里县人民政府办公室综合服务中心","工作人员01",{"v":69.7,"d":"69.70"},77.77,74.54,{"$f":"SUMPRODUCT(($K$3:$K$51=K24)*($H$3:$H$51>H24))+1","v":1},"是","龙里县人民政府办公室综合服务中心工作人员01"]
[23,"杨娟","llkd20240218","龙里县人民政府办公室综合服务中心","工作人员01",{"v":68.9,"d":"68.90"},77.99,74.35,{"$f":"SUMPRODUCT(($K$3:$K$51=K25)*($H$3:$H$51>H25))+1","v":2},"是","龙里县人民政府办公室综合服务中心工作人员01"]
[24,"罗艳","llkd20240215","龙里县人民政府办公室综合服务中心","工作人员01",{"v":59,"d":"59.00"},77.64,70.18,{"$f":"SUMPRODUCT(($K$3:$K$51=K26)*($H$3:$H$51>H26))+1","v":3},"是","龙里县人民政府办公室综合服务中心工作人员01"]
[25,"龙潜","llkd20240219","龙里县人民政府办公室综合服务中心","工作人员01",{"v":52.6,"d":"52.60"},76.89,67.17,{"$f":"SUMPRODUCT(($K$3:$K$51=K27)*($H$3:$H$51>H27))+1","v":4},null,"龙里县人民政府办公室综合服务中心工作人员01"]
[26,"邓菲","llkd20240225","龙里县总工会","工作人员01",{"v":43.6,"d":"43.60"},{"v":77.6,"d":"77.60"},{"v":64,"d":"64.00"},{"$f":"SUMPRODUCT(($K$3:$K$51=K28)*($H$3:$H$51>H28))+1","v":1},"是","龙里县总工会工作人员01"]
[27,"韦熙红","llkd20240301","龙里县干部信息中心","工作人员01",{"v":73,"d":"73.00"},79.28,76.77,{"$f":"SUMPRODUCT(($K$3:$K$51=K29)*($H$3:$H$51>H29))+1","v":1},"是","龙里县干部信息中心工作人员01"]
[28,"黄福星","llkd20240303","龙里县关心下一代工作委员会办公室","工作人员01",{"v":62.6,"d":"62.60"},80.67,73.44,{"$f":"SUMPRODUCT(($K$3:$K$51=K30)*($H$3:$H$51>H30))+1","v":1},"是","龙里县关心下一代工作委员会办公室工作人员01"]
[29,"赵春兰","llkd20240305","龙里县人才工作服务中心","工作人员01",{"v":69.9,"d":"69.90"},{"v":80.8,"d":"80.80"},76.44,{"$f":"SUMPRODUCT(($K$3:$K$51=K31)*($H$3:$H$51>H31))+1","v":1},"是","龙里县人才工作服务中心工作人员01"]
[30,"伍小兵","llkd20240307","龙里县人才工作服务中心","工作人员01",{"v":63.4,"d":"63.40"},{"v":79.9,"d":"79.90"},{"v":73.3,"d":"73.30"},{"$f":"SUMPRODUCT(($K$3:$K$51=K32)*($H$3:$H$51>H32))+1","v":2},"是","龙里县人才工作服务中心工作人员01"]
[31,"吴学鹏","llkd20240310","龙里县人才工作服务中心","工作人员01",{"v":58.6,"d":"58.60"},75.05,68.47,{"$f":"SUMPRODUCT(($K$3:$K$51=K33)*($H$3:$H$51>H33))+1","v":3},"是","龙里县人才工作服务中心工作人员01"]
[32,"宋子玮","llkd20240312","龙里县基层财政服务中心","工作人员01",{"v":60.8,"d":"60.80"},78.52,71.43,{"$f":"SUMPRODUCT(($K$3:$K$51=K34)*($H$3:$H$51>H34))+1","v":1},"是","龙里县基层财政服务中心工作人员01"]
[33,"朱怀荣","llkd20240311","龙里县基层财政服务中心","工作人员01",{"v":54.3,"d":"54.30"},77.68,68.33,{"$f":"SUMPRODUCT(($K$3:$K$51=K35)*($H$3:$H$51>H35))+1","v":2},"是","龙里县基层财政服务中心工作人员01"]
[34,"田金梅","llkd20240314","龙里县财政投资评价中心","工作人员01",{"v":61.1,"d":"61.10"},78.36,71.46,{"$f":"SUMPRODUCT(($K$3:$K$51=K36)*($H$3:$H$51>H36))+1","v":1},"是","龙里县财政投资评价中心工作人员01"]
[35,"游雁云","llkd20240315","龙里县财政投资评价中心","工作人员01",{"v":57,"d":"57.00"},76.58,68.75,{"$f":"SUMPRODUCT(($K$3:$K$51=K37)*($H$3:$H$51>H37))+1","v":2},"是","龙里县财政投资评价中心工作人员01"]
[36,"崔秋雪","llkd20240317","龙里县人力资源服务中心","工作人员01",{"v":61.2,"d":"61.20"},{"v":78.2,"d":"78.20"},{"v":71.4,"d":"71.40"},{"$f":"SUMPRODUCT(($K$3:$K$51=K38)*($H$3:$H$51>H38))+1","v":1},"是","龙里县人力资源服务中心工作人员01"]
[37,"吴攀群","llkd20240319","龙里县人力资源服务中心","工作人员01",{"v":56.2,"d":"56.20"},78.05,69.31,{"$f":"SUMPRODUCT(($K$3:$K$51=K39)*($H$3:$H$51>H39))+1","v":2},"是","龙里县人力资源服务中心工作人员01"]
[38,"吴艳平","llkd20240318","龙里县人力资源服务中心","工作人员01",{"v":55.1,"d":"55.10"},74.01,66.45,{"$f":"SUMPRODUCT(($K$3:$K$51=K40)*($H$3:$H$51>H40))+1","v":3},null,"龙里县人力资源服务中心工作人员01"]
[39,"雷涛","llkd20240404","中共龙里县纪委县监委机关","工作人员01",{"v":71.8,"d":"71.80"},79.13,{"v":76.2,"d":"76.20"},{"$f":"SUMPRODUCT(($K$3:$K$51=K41)*($H$3:$H$51>H41))+1","v":1},"是","中共龙里县纪委县监委机关工作人员01"]
[40,"周定杰","llkd20240401","中共龙里县纪委县监委机关","工作人员01",{"v":67.9,"d":"67.90"},76.61,73.13,{"$f":"SUMPRODUCT(($K$3:$K$51=K42)*($H$3:$H$51>H42))+1","v":2},"是","中共龙里县纪委县监委机关工作人员01"]
[41,"朱兴露","llkd20240402","中共龙里县纪委县监委机关","工作人员01",{"v":60.4,"d":"60.40"},80.39,72.39,{"$f":"SUMPRODUCT(($K$3:$K$51=K43)*($H$3:$H$51>H43))+1","v":3},"是","中共龙里县纪委县监委机关工作人员01"]
[42,"姜发娟","llkd20240403","中共龙里县纪委县监委机关","工作人员01",{"v":60,"d":"60.00"},78.29,70.97,{"$f":"SUMPRODUCT(($K$3:$K$51=K44)*($H$3:$H$51>H44))+1","v":4},"是","中共龙里县纪委县监委机关工作人员01"]
[43,"周珊珊","llkd20240412","龙里县统计普查中心","工作人员01",{"v":69.4,"d":"69.40"},80.47,76.04,{"$f":"SUMPRODUCT(($K$3:$K$51=K45)*($H$3:$H$51>H45))+1","v":1},"是","龙里县统计普查中心工作人员01"]
[44,"黄凯鹏","llkd20240416","龙里县统计普查中心","工作人员01",{"v":59.1,"d":"59.10"},79.36,71.26,{"$f":"SUMPRODUCT(($K$3:$K$51=K46)*($H$3:$H$51>H46))+1","v":2},"是","龙里县统计普查中心工作人员01"]
[45,"吴莉","llkd20240411","龙里县统计普查中心","工作人员01",{"v":60,"d":"60.00"},74.16,{"v":68.5,"d":"68.50"},{"$f":"SUMPRODUCT(($K$3:$K$51=K47)*($H$3:$H$51>H47))+1","v":3},null,"龙里县统计普查中心工作人员01"]
[46,"张晴","llkd20240417","龙里县投资促进局","工作人员01",{"v":72.1,"d":"72.10"},78.59,75.99,{"$f":"SUMPRODUCT(($K$3:$K$51=K48)*($H$3:$H$51>H48))+1","v":1},"是","龙里县投资促进局工作人员01"]
[47,"罗莲","llkd20240419","贵州快递物流集聚区管理委员会","工作人员01",{"v":69.2,"d":"69.20"},79.12,75.15,{"$f":"SUMPRODUCT(($K$3:$K$51=K49)*($H$3:$H$51>H49))+1","v":1},"是","贵州快递物流集聚区管理委员会工作人员01"]
[48,"杜坪","llkd20240425","贵州快递物流集聚区管理委员会","工作人员01",{"v":67.7,"d":"67.70"},74.23,71.62,{"$f":"SUMPRODUCT(($K$3:$K$51=K50)*($H$3:$H$51>H50))+1","v":2},"是","贵州快递物流集聚区管理委员会工作人员01"]
[49,"张耀","llkd20240422","贵州快递物流集聚区管理委员会","工作人员01",{"v":62.6,"d":"62.60"},75.08,70.09,{"$f":"SUMPRODUCT(($K$3:$K$51=K51)*($H$3:$H$51>H51))+1","v":3},null,"贵州快递物流集聚区管理委员会工作人员01"]