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

{"sheet":"成绩表","index":0,"n_rows":112,"n_cols":11,"rows_kept":112,"merged":[[0,0,0,10],[2,1,16,1],[2,2,6,2],[2,3,6,3],[7,2,16,2],[7,3,16,3],[17,1,21,1],[17,2,21,2],[17,3,21,3],[22,1,23,1],[22,2,23,2],[22,3,23,3],[24,1,26,1],[24,2,26,2],[24,3,26,3],[27,1,36,1],[27,2,36,2],[27,3,36,3],[37,1,41,1],[37,2,41,2],[37,3,41,3],[42,1,46,1],[42,2,46,2],[42,3,46,3],[47,1,51,1],[47,2,51,2],[47,3,51,3],[52,1,54,1],[52,2,54,2],[52,3,54,3],[55,1,56,1],[55,2,56,2],[55,3,56,3],[57,1,61,1],[57,2,61,2],[57,3,61,3],[62,1,71,1],[62,2,66,2],[62,3,66,3],[67,2,71,2],[67,3,71,3],[72,1,76,1],[72,2,76,2],[72,3,76,3],[77,1,86,1],[77,2,86,2],[77,3,86,3],[87,1,96,1],[87,2,91,2],[87,3,91,3],[92,2,96,2],[92,3,96,3],[97,1,111,1],[97,2,101,2],[97,3,101,3],[102,2,106,2],[102,3,106,3],[107,2,111,2],[107,3,111,3]]}
["附件\n　　　　　　　广东省事业单位2024年集中公开招聘高校毕业生\n　　　河源市市直事业单位考试总成绩及进入体检人员名单"]
["序号","报考单位","岗位代码","招聘人数","准考证号","笔试\n成绩","面试\n成绩","总成绩\n(按笔试、面试成绩各50%合成)","总排名","是否进入体检","备注"]
["1","河源市网络安全\n应急指挥中心","2412121070361","1","241070508003","74.60",76.42,{"$f":"ROUND(F3*0.5+G3*0.5,2)","v":75.51},{"$f":"RANK(H3,$H$3:$H$7)","v":1},{"$f":"IF(I3=1,\"是\",\"否\")","v":"是"}]
["2",{"$nulls":3},"241070102106","70.30",76.92,73.61,{"$f":"RANK(H4,$H$3:$H$7)","v":2},"否"]
["3",{"$nulls":3},"241070501730","71.60",71.83,71.72,{"$f":"RANK(H5,$H$3:$H$7)","v":3},"否"]
["4",{"$nulls":3},"241070202528","79.90",{"v":0,"d":"0.00"},39.95,{"$f":"RANK(H6,$H$3:$H$7)","v":4},"否","面试缺考"]
["5",{"$nulls":3},"241070110114","70.40",{"v":0,"d":"0.00"},{"v":35.2,"d":"35.20"},{"$f":"RANK(H7,$H$3:$H$7)","v":5},"否","面试缺考"]
["6",null,"2412121070362","2","241070206815","81.40",73.42,77.41,{"$f":"RANK(H8,$H$8:$H$17)","v":1},"是"]
["7",{"$nulls":3},"241070106821","76.00",{"v":78,"d":"78.00"},{"v":77,"d":"77.00"},2,"是"]
["8",{"$nulls":3},"241070300410","78.60",74.25,76.43,3,{"$f":"IF(I10=1,\"是\",\"否\")","v":"否"}]
["9",{"$nulls":3},"241070500715","79.80",72.83,76.32,4,"否"]
["10",{"$nulls":3},"241070400622","78.20",74.33,76.27,5,"否"]
["11",{"$nulls":3},"241070504324","77.40",74.75,76.08,6,"否"]
["12",{"$nulls":3},"241070202727","75.80",74.83,75.32,7,"否"]
["13",{"$nulls":3},"241070102326","74.90",73.08,73.99,8,"否"]
["14",{"$nulls":3},"241070109817","79.20",67.75,73.48,9,"否"]
["15",{"$nulls":3},"241070108227","74.50",64.83,69.67,10,"否"]
["16","河源市经济技术\n开发中心","2412121070406","1","241070701129","82.90",80.25,81.58,{"$f":"RANK(H18,$H$18:$H$22)","v":1},"是"]
["17",{"$nulls":3},"241070201126","73.00",84.25,78.63,{"$f":"RANK(H19,$H$18:$H$22)","v":2},"否"]
["18",{"$nulls":3},"241070603809","75.10",72.58,73.84,{"$f":"RANK(H20,$H$18:$H$22)","v":3},"否"]
["19",{"$nulls":3},"241070601426","72.50",73.67,73.09,{"$f":"RANK(H21,$H$18:$H$22)","v":4},"否"]
["20",{"$nulls":3},"241070200327","77.40",67.83,72.62,{"$f":"RANK(H22,$H$18:$H$22)","v":5},"否"]
["21","河源市国有黎明林场","2412121070114","1","241070203209",{"v":58.5,"d":"58.50"},72.58,65.54,1,"是"]
["22",{"$nulls":3},"241070200326",{"v":53.5,"d":"53.50"},59.25,26.75,2,"否","面试成绩不合格，不计入总成绩"]
["23","河源市国有红星林场","2412121070115","1","241070600725",{"v":71.4,"d":"71.40"},78.92,75.16,1,"是"]
["24",{"$nulls":3},"241070603302",{"v":61,"d":"61.00"},69.92,65.46,2,"否"]
["25",{"$nulls":3},"241070507409",{"v":66,"d":"66.00"},{"v":0,"d":"0.00"},{"v":33,"d":"33.00"},3,"否","面试缺考"]
["26","河源职业技术学院","2412121070010","2","241070110424","76.50",81.83,79.17,{"$f":"RANK(H28,$H$28:$H$37)","v":1},"是"]
["27",{"$nulls":3},"241070509227","76.50",79.75,78.13,2,"是"]
["28",{"$nulls":3},"241070505002","75.80",80.25,78.03,3,{"$f":"IF(I30=1,\"是\",\"否\")","v":"否"}]
["29",{"$nulls":3},"241070106627","69.60",81.83,75.72,4,"否"]
["30",{"$nulls":3},"241070404425","70.80",75.83,73.32,5,"否"]
["31",{"$nulls":3},"241070603815","69.30",{"v":75,"d":"75.00"},72.15,6,"否"]
["32",{"$nulls":3},"241070601821","65.60",74.67,70.14,7,"否"]
["33",{"$nulls":3},"241070508612","67.40",71.08,69.24,8,"否"]
["34",{"$nulls":3},"241070205115","66.20",{"v":72,"d":"72.00"},{"v":69.1,"d":"69.10"},9,"否"]
["35",{"$nulls":3},"241070300116","67.10",{"v":0,"d":"0.00"},33.55,10,"否","面试缺考"]
["36","河源市公路交通量\n观测站","2412121070408","1","241070100203","75.80",79.58,77.69,{"$f":"RANK(H38,$H$38:$H$42)","v":1},"是"]
["37",{"$nulls":3},"241070107029","78.00",77.08,77.54,{"$f":"RANK(H39,$H$38:$H$42)","v":2},"否"]
["38",{"$nulls":3},"241070300313","72.50",{"v":77,"d":"77.00"},74.75,{"$f":"RANK(H40,$H$38:$H$42)","v":3},"否"]
["39",{"$nulls":3},"241070106005","72.20",76.42,74.31,{"$f":"RANK(H41,$H$38:$H$42)","v":4},"否"]
["40",{"$nulls":3},"241070106530","75.20",68.42,71.81,{"$f":"RANK(H42,$H$38:$H$42)","v":5},"否"]
["41","河源市人大代表\n活动中心","2412121070407","1","241070604430","76.10",77.42,76.76,{"$f":"RANK(H43,$H$43:$H$47)","v":1},"是"]
["42",{"$nulls":3},"241070400822","76.50",75.33,75.92,{"$f":"RANK(H44,$H$43:$H$47)","v":2},"否"]
["43",{"$nulls":3},"241070500926","72.70",{"v":76.5,"d":"76.50"},{"v":74.6,"d":"74.60"},{"$f":"RANK(H45,$H$43:$H$47)","v":3},"否"]
["44",{"$nulls":3},"241070204322","78.80",{"v":0,"d":"0.00"},{"v":39.4,"d":"39.40"},{"$f":"RANK(H46,$H$43:$H$47)","v":4},"否","面试缺考"]
["45",{"$nulls":3},"241070104412","76.30",{"v":0,"d":"0.00"},38.15,{"$f":"RANK(H47,$H$43:$H$47)","v":5},"否","面试缺考"]
["46","河源市动物疫病预防\n控制中心","2412121070404","1","241070404401","80.50",73.83,77.17,{"$f":"RANK(H48,$H$48:$H$52)","v":1},"是"]
["47",{"$nulls":3},"241070401119","71.90",76.42,74.16,{"$f":"RANK(H49,$H$48:$H$52)","v":2},"否"]
["48",{"$nulls":3},"241070201008","69.90",71.67,70.79,{"$f":"RANK(H50,$H$48:$H$52)","v":3},"否"]
["49",{"$nulls":3},"241070206409","69.50",71.75,70.63,{"$f":"RANK(H51,$H$48:$H$52)","v":4},"否"]
["50",{"$nulls":3},"241070106826","68.80",64.67,66.74,{"$f":"RANK(H52,$H$48:$H$52)","v":5},"否"]
["51","河源市农业技术\n推广中心","2412121070405","1","241070603527","79.00",82.08,80.54,1,"是"]
["52",{"$nulls":3},"241070701709","68.10",79.75,73.93,2,"否"]
["53",{"$nulls":3},"241070203828","71.30",73.75,72.53,3,"否"]
["54","河源市农业技术\n推广中心","2412121070405","1","241070508428","81.20",{"v":0,"d":"0.00"},{"v":40.6,"d":"40.60"},4,"否","面试缺考"]
["55",{"$nulls":3},"241070503915","79.10",{"v":0,"d":"0.00"},39.55,5,"否","面试缺考"]
["56","河源市高新技术开发区管理委员会","2412121070116","1","241070111725","79.10",79.58,79.34,{"$f":"RANK(H58,$H$58:$H$62)","v":1},"是"]
["57",{"$nulls":3},"241070109522","75.30",82.92,79.11,{"$f":"RANK(H59,$H$58:$H$62)","v":2},"否"]
["58",{"$nulls":3},"241070105014","74.10",76.33,75.22,{"$f":"RANK(H60,$H$58:$H$62)","v":3},"否"]
["59",{"$nulls":3},"241070701009","73.70",75.92,74.81,{"$f":"RANK(H61,$H$58:$H$62)","v":4},"否"]
["60",{"$nulls":3},"241070303922","74.10",{"v":0,"d":"0.00"},37.05,{"$f":"RANK(H62,$H$58:$H$62)","v":5},"否","面试缺考"]
["61","河源市医疗保障\n事业管理中心","2412121070382","1","241070400418","83.40",80.83,82.12,{"$f":"RANK(H63,$H$63:$H$67)","v":1},"是"]
["62",{"$nulls":3},"241070601807","74.70",81.83,78.27,{"$f":"RANK(H64,$H$63:$H$67)","v":2},"否"]
["63",{"$nulls":3},"241070303520","77.80",{"v":76,"d":"76.00"},{"v":76.9,"d":"76.90"},{"$f":"RANK(H65,$H$63:$H$67)","v":3},"否"]
["64",{"$nulls":3},"241070105630","77.70",{"v":0,"d":"0.00"},38.85,{"$f":"RANK(H66,$H$63:$H$67)","v":4},"否","面试缺考"]
["65",{"$nulls":3},"241070703216","72.20",{"v":0,"d":"0.00"},{"$f":"ROUND(F67*0.5+G67*0.5,2)","v":{"v":36.1,"d":"36.10"}},{"$f":"RANK(H67,$H$63:$H$67)","v":5},"否","面试缺考"]
["66",null,"2412121070383","1","241070204526","69.90",78.58,74.24,{"$f":"RANK(H68,$H$68:$H$72)","v":1},"是"]
["67",{"$nulls":3},"241070603628","71.90",70.83,71.37,{"$f":"RANK(H69,$H$68:$H$72)","v":2},"否"]
["68",{"$nulls":3},"241070502505","65.30",77.42,71.36,{"$f":"RANK(H70,$H$68:$H$72)","v":3},"否"]
["69",{"$nulls":3},"241070303417","64.60",76.08,70.34,{"$f":"RANK(H71,$H$68:$H$72)","v":4},"否"]
["70",{"$nulls":3},"241070500530","64.10",{"v":0,"d":"0.00"},32.05,{"$f":"RANK(H72,$H$68:$H$72)","v":5},"否","面试缺考"]
["71","河源市龙川生态环境\n监测站","2412121070220","1","241070505429","78.00",84.25,81.13,{"$f":"RANK(H73,$H$73:$H$77)","v":1},"是"]
["72",{"$nulls":3},"241070402222","77.20",81.33,79.27,{"$f":"RANK(H74,$H$73:$H$77)","v":2},"否"]
["73",{"$nulls":3},"241070400303\n","77.90",80.33,79.12,{"$f":"RANK(H75,$H$73:$H$77)","v":3},"否"]
["74",{"$nulls":3},"241070300308","75.60",77.08,76.34,{"$f":"RANK(H76,$H$73:$H$77)","v":4},"否"]
["75",{"$nulls":3},"241070303420","75.30",{"v":72,"d":"72.00"},73.65,{"$f":"RANK(H77,$H$73:$H$77)","v":5},"否"]
["76","河源市和平生态环境\n监测站","2412121070221","2","241070508202","74.20",81.75,77.98,{"$f":"RANK(H78,$H$78:$H$87)","v":1},"是"]
["77",{"$nulls":3},"241070102329","79.50",74.33,76.92,2,"是"]
["78",{"$nulls":3},"241070203714","72.70",{"v":80.5,"d":"80.50"},{"v":76.6,"d":"76.60"},3,{"$f":"IF(I80=1,\"是\",\"否\")","v":"否"}]
["79",{"$nulls":3},"241070600425","73.10",78.67,75.89,4,"否"]
["80",{"$nulls":3},"241070602109","71.00",80.25,75.63,5,"否"]
["81",{"$nulls":3},"241070102205","71.20",77.83,74.52,6,"否"]
["82",{"$nulls":3},"241070701730","72.90",72.92,72.91,7,"否"]
["83",{"$nulls":3},"241070604318","72.60",72.75,72.68,8,"否"]
["84",{"$nulls":3},"241070203508","72.40",69.92,71.16,9,"否"]
["85",{"$nulls":3},"241070203203","76.90",{"v":0,"d":"0.00"},38.45,10,"否","面试缺考"]
["86","河源市连平生态环境\n监测站","2412121070200","1","241070110714","76.50",79.58,78.04,{"$f":"RANK(H88,$H$88:$H$92)","v":1},"是"]
["87",{"$nulls":3},"241070500817","77.40",77.33,77.37,{"$f":"RANK(H89,$H$88:$H$92)","v":2},"否"]
["88",{"$nulls":3},"241070101205","71.20",76.92,74.06,{"$f":"RANK(H90,$H$88:$H$92)","v":3},"否"]
["89",{"$nulls":3},"241070606019","66.00",{"v":76.5,"d":"76.50"},71.25,{"$f":"RANK(H91,$H$88:$H$92)","v":4},"否"]
["90",{"$nulls":3},"241070106828","68.90",72.17,70.54,{"$f":"RANK(H92,$H$88:$H$92)","v":5},"否"]
["91",null,"2412121070201","1","241070204122","59.10",77.75,68.43,{"$f":"RANK(H93,$H$93:$H$97)","v":1},"是"]
["92",{"$nulls":3},"241070606211","61.20",74.67,67.94,{"$f":"RANK(H94,$H$93:$H$97)","v":2},"否"]
["93",{"$nulls":3},"241070202418","55.70",75.83,65.77,{"$f":"RANK(H95,$H$93:$H$97)","v":3},"否"]
["94",{"$nulls":3},"241070102115","55.40",74.17,64.79,{"$f":"RANK(H96,$H$93:$H$97)","v":4},"否"]
["95",{"$nulls":3},"241070200504","55.20",{"v":63,"d":"63.00"},{"v":59.1,"d":"59.10"},{"$f":"RANK(H97,$H$93:$H$97)","v":5},"否"]
["96","河源技师学院（河源市高级技工学校）","2412121070394","1","241070205328","71.20",82.75,76.98,{"$f":"RANK(H98,$H$98:$H$102)","v":1},"是"]
["97",{"$nulls":3},"241070304318","74.10",75.75,74.93,{"$f":"RANK(H99,$H$98:$H$102)","v":2},"否"]
["98",{"$nulls":3},"241070304813","60.60",{"v":74.5,"d":"74.50"},67.55,{"$f":"RANK(H100,$H$98:$H$102)","v":3},"否"]
["99",{"$nulls":3},"241070304025","57.70",{"v":73.5,"d":"73.50"},{"v":65.6,"d":"65.60"},{"$f":"RANK(H101,$H$98:$H$102)","v":4},"否"]
["100",{"$nulls":3},"241070111630","58.40",{"v":0,"d":"0.00"},{"v":29.2,"d":"29.20"},{"$f":"RANK(H102,$H$98:$H$102)","v":5},"否","面试缺考"]
["101",null,"2412121070395","1","241070303317","74.00",74.25,74.13,{"$f":"RANK(H103,$H$103:$H$107)","v":1},"是"]
["102",{"$nulls":3},"241070402311","74.10",{"v":74,"d":"74.00"},74.05,{"$f":"RANK(H104,$H$103:$H$107)","v":2},"否"]
["103",{"$nulls":3},"241070301811","71.80",{"v":69,"d":"69.00"},{"v":70.4,"d":"70.40"},{"$f":"RANK(H105,$H$103:$H$107)","v":3},"否"]
["104",{"$nulls":3},"241070100503","70.50",{"v":69,"d":"69.00"},69.75,{"$f":"RANK(H106,$H$103:$H$107)","v":4},"否"]
["105",{"$nulls":3},"241070503508","72.90",{"v":0,"d":"0.00"},36.45,{"$f":"RANK(H107,$H$103:$H$107)","v":5},"否","面试缺考"]
["106",null,"2412121070396","1","241070200323","76.30",80.25,78.28,{"$f":"RANK(H108,$H$108:$H$112)","v":1},"是"]
["107",{"$nulls":3},"241070604120","72.90",{"v":76.5,"d":"76.50"},{"v":74.7,"d":"74.70"},{"$f":"RANK(H109,$H$108:$H$112)","v":2},"否"]
["108",{"$nulls":3},"241070503506","70.40",78.25,74.33,{"$f":"RANK(H110,$H$108:$H$112)","v":3},"否"]
["109",{"$nulls":3},"241070505601","71.10",76.75,73.93,{"$f":"RANK(H111,$H$108:$H$112)","v":4},"否"]
["110",{"$nulls":3},"241070203621","71.30",{"v":72.5,"d":"72.50"},{"v":71.9,"d":"71.90"},{"$f":"RANK(H112,$H$108:$H$112)","v":5},"否"]