{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["特岗初中道德与法治","特岗初中地理","特岗初中化学","特岗初中历史","特岗初中生物","特岗初中数学","特岗初中美术","特岗初中体育与健康","特岗初中音乐","特岗初中物理","特岗初中心理健康教育","特岗初中英语","特岗初中语文"],"read":"whole","date_system":"1900"}

{"sheet":"特岗初中道德与法治","index":0,"n_rows":19,"n_cols":8,"rows_kept":19,"merged":[[0,0,0,7]]}
["乐平市2024年教师招聘成绩表                            　　　　　　　　     （特岗初中道德与法治）（招聘7人）"]
["排名","姓名","准考证号","笔试成绩","笔试总分（×20%）","面试成绩","面试总分（×50%）","总成绩"]
[1,"胡思维","154020104115",219,{"$f":"D3*0.2","v":{"v":43.8,"d":"43.80"}},{"v":88,"d":"88.00"},{"$f":"F3*0.5","v":{"v":44,"d":"44.00"}},{"$f":"E3+G3","v":{"v":87.8,"d":"87.80"}}]
[2,"余清玲","154230201505",214.5,{"$f":"D4*0.2","v":{"v":42.9,"d":"42.90"}},{"v":87.6,"d":"87.60"},{"$f":"F4*0.5","v":{"v":43.8,"d":"43.80"}},{"$f":"E4+G4","v":{"v":86.7,"d":"86.70"}}]
[3,"郑佳敏","154230201601",213,{"$f":"D5*0.2","v":{"v":42.6,"d":"42.60"}},88.03,{"$f":"F5*0.5","v":{"v":44.015,"d":"44.02"}},{"$f":"E5+G5","v":{"v":86.615,"d":"86.62"}}]
[4,"汪萍","154010301617",213,{"$f":"D6*0.2","v":{"v":42.6,"d":"42.60"}},{"v":87.7,"d":"87.70"},{"$f":"F6*0.5","v":43.85},{"$f":"E6+G6","v":86.45}]
[5,"范玉婷","154020104107",215.5,{"$f":"D7*0.2","v":{"v":43.1,"d":"43.10"}},85.57,{"$f":"F7*0.5","v":{"v":42.785,"d":"42.79"}},{"$f":"E7+G7","v":{"v":85.885,"d":"85.89"}}]
[6,"汪慧慧","154020104112",208,{"$f":"D8*0.2","v":{"v":41.6,"d":"41.60"}},87.67,{"$f":"F8*0.5","v":{"v":43.835,"d":"43.84"}},{"$f":"E8+G8","v":{"v":85.435,"d":"85.44"}}]
[7,"朱琪","154040105413",210.5,{"$f":"D9*0.2","v":{"v":42.1,"d":"42.10"}},{"v":86.6,"d":"86.60"},{"$f":"F9*0.5","v":{"v":43.3,"d":"43.30"}},{"$f":"E9+G9","v":{"v":85.4,"d":"85.40"}}]
[8,"卢荣荣","154010301920",206,{"$f":"D10*0.2","v":{"v":41.2,"d":"41.20"}},88.13,{"$f":"F10*0.5","v":{"v":44.065,"d":"44.07"}},{"$f":"E10+G10","v":{"v":85.265,"d":"85.27"}}]
[9,"胡紫薇","154010301722",211.5,{"$f":"D11*0.2","v":{"v":42.3,"d":"42.30"}},{"v":84.9,"d":"84.90"},{"$f":"F11*0.5","v":42.45},{"$f":"E11+G11","v":84.75}]
[10,"柴小琴","154060103316",203.5,{"$f":"D12*0.2","v":{"v":40.7,"d":"40.70"}},{"v":87.4,"d":"87.40"},{"$f":"F12*0.5","v":{"v":43.7,"d":"43.70"}},{"$f":"E12+G12","v":{"v":84.4,"d":"84.40"}}]
[11,"沈小丽","154010301424",200.5,{"$f":"D13*0.2","v":{"v":40.1,"d":"40.10"}},88.27,{"$f":"F13*0.5","v":{"v":44.135,"d":"44.14"}},{"$f":"E13+G13","v":{"v":84.235,"d":"84.24"}}]
[12,"彭正妹","154010301811",201,{"$f":"D14*0.2","v":{"v":40.2,"d":"40.20"}},87.93,{"$f":"F14*0.5","v":{"v":43.965,"d":"43.97"}},{"$f":"E14+G14","v":{"v":84.165,"d":"84.17"}}]
[13,"王瑱","154020104121",202.5,{"$f":"D15*0.2","v":{"v":40.5,"d":"40.50"}},{"v":87.2,"d":"87.20"},{"$f":"F15*0.5","v":{"v":43.6,"d":"43.60"}},{"$f":"E15+G15","v":{"v":84.1,"d":"84.10"}}]
[14,"刘丽华","154210101607",204,{"$f":"D16*0.2","v":{"v":40.8,"d":"40.80"}},86.07,{"$f":"F16*0.5","v":{"v":43.035,"d":"43.04"}},{"$f":"E16+G16","v":{"v":83.835,"d":"83.84"}}]
[15,"陈亚婷","154230201510",207,{"$f":"D17*0.2","v":{"v":41.4,"d":"41.40"}},84.17,{"$f":"F17*0.5","v":{"v":42.085,"d":"42.09"}},{"$f":"E17+G17","v":{"v":83.485,"d":"83.49"}}]
[16,"赖小丽","154010301410",199,{"$f":"D18*0.2","v":{"v":39.8,"d":"39.80"}},{"v":86.8,"d":"86.80"},{"$f":"F18*0.5","v":{"v":43.4,"d":"43.40"}},{"$f":"E18+G18","v":{"v":83.2,"d":"83.20"}}]
[17,"陈萍","154230201404",200,{"$f":"D19*0.2","v":{"v":40,"d":"40.00"}},85.47,{"$f":"F19*0.5","v":{"v":42.735,"d":"42.74"}},{"$f":"E19+G19","v":{"v":82.735,"d":"82.74"}}]

{"sheet":"特岗初中地理","index":1,"n_rows":15,"n_cols":8,"rows_kept":15,"merged":[[0,0,0,7]]}
["乐平市2024年教师招聘成绩表                            　　　　　　　　     (特岗初中地理）（招聘5人）"]
["排名","姓名","准考证号","笔试成绩","笔试总分（×20%）","面试成绩","面试总分（×50%）","总成绩"]
[1,"周冰燕","254010606105",218,{"$f":"D3*0.2","v":{"v":43.6,"d":"43.60"}},88.23,{"$f":"F3*0.5","v":{"v":44.115,"d":"44.12"}},{"$f":"E3+G3","v":{"v":87.715,"d":"87.72"}}]
[2,"杜梦琦","254010606015",213.5,{"$f":"D4*0.2","v":{"v":42.7,"d":"42.70"}},86.03,{"$f":"F4*0.5","v":{"v":43.015,"d":"43.02"}},{"$f":"E4+G4","v":{"v":85.715,"d":"85.72"}}]
[3,"马婷娜","254020105217",207,{"$f":"D5*0.2","v":{"v":41.4,"d":"41.40"}},87.73,{"$f":"F5*0.5","v":{"v":43.865,"d":"43.87"}},{"$f":"E5+G5","v":{"v":85.265,"d":"85.27"}}]
[4,"余百惠","254020105212",195.5,{"$f":"D6*0.2","v":{"v":39.1,"d":"39.10"}},88.9,{"$f":"F6*0.5","v":44.45},{"$f":"E6+G6","v":83.55}]
[5,"徐雅梅","254230203711",203,{"$f":"D7*0.2","v":{"v":40.6,"d":"40.60"}},85.63,{"$f":"F7*0.5","v":{"v":42.815,"d":"42.82"}},{"$f":"E7+G7","v":{"v":83.415,"d":"83.42"}}]
[6,"尹象文","254020105211",201,{"$f":"D8*0.2","v":{"v":40.2,"d":"40.20"}},86.17,{"$f":"F8*0.5","v":{"v":43.085,"d":"43.09"}},{"$f":"E8+G8","v":{"v":83.285,"d":"83.29"}}]
[7,"张诗晨","254020105215",195,{"$f":"D9*0.2","v":{"v":39,"d":"39.00"}},86.7,{"$f":"F9*0.5","v":43.35},{"$f":"E9+G9","v":82.35}]
[8,"杨向昀","254010606021",193,{"$f":"D10*0.2","v":{"v":38.6,"d":"38.60"}},86.3,{"$f":"F10*0.5","v":43.15},{"$f":"E10+G10","v":81.75}]
[9,"江霞英","254040106206",202,{"$f":"D11*0.2","v":{"v":40.4,"d":"40.40"}},{"v":81.1,"d":"81.10"},{"$f":"F11*0.5","v":40.55},{"$f":"E11+G11","v":80.95}]
[10,"刘育红","254210104019",198,{"$f":"D12*0.2","v":{"v":39.6,"d":"39.60"}},82.67,{"$f":"F12*0.5","v":{"v":41.335,"d":"41.34"}},{"$f":"E12+G12","v":{"v":80.935,"d":"80.94"}}]
[11,"李霞","254010606112",197,{"$f":"D13*0.2","v":{"v":39.4,"d":"39.40"}},0,{"$f":"F13*0.5","v":{"v":0,"d":"0.00"}},{"$f":"E13+G13","v":{"v":39.4,"d":"39.40"}}]
[12,"段紫婷","254020105209",184,{"$f":"D14*0.2","v":{"v":36.8,"d":"36.80"}},0,{"$f":"F14*0.5","v":{"v":0,"d":"0.00"}},{"$f":"E14+G14","v":{"v":36.8,"d":"36.80"}}]
[13,"汪雅情","254020105219",181,{"$f":"D15*0.2","v":{"v":36.2,"d":"36.20"}},0,{"$f":"F15*0.5","v":{"v":0,"d":"0.00"}},{"$f":"E15+G15","v":{"v":36.2,"d":"36.20"}}]

{"sheet":"特岗初中化学","index":2,"n_rows":12,"n_cols":8,"rows_kept":12,"merged":[[0,0,0,7]]}
["乐平市2024年教师招聘成绩表                            　　　　　　　　     (特岗初中化学）（招聘6人）"]
["排名","姓名","准考证号","笔试成绩","笔试总分（×20%）","面试成绩","面试总分（×50%）","总成绩"]
[1,"李文婷","254020105303",202.5,{"$f":"D3*0.2","v":{"v":40.5,"d":"40.50"}},86.53,{"$f":"F3*0.5","v":{"v":43.265,"d":"43.27"}},{"$f":"E3+G3","v":{"v":83.765,"d":"83.77"}}]
[2,"汪慧敏","254040106309",184,{"$f":"D4*0.2","v":{"v":36.8,"d":"36.80"}},86.77,{"$f":"F4*0.5","v":{"v":43.385,"d":"43.39"}},{"$f":"E4+G4","v":{"v":80.185,"d":"80.19"}}]
[3,"谭瑞阳","254020105304",187.5,{"$f":"D5*0.2","v":{"v":37.5,"d":"37.50"}},84.67,{"$f":"F5*0.5","v":{"v":42.335,"d":"42.34"}},{"$f":"E5+G5","v":{"v":79.835,"d":"79.84"}}]
[4,"艾雨航","254010202610",183,{"$f":"D6*0.2","v":{"v":36.6,"d":"36.60"}},83.57,{"$f":"F6*0.5","v":{"v":41.785,"d":"41.79"}},{"$f":"E6+G6","v":{"v":78.385,"d":"78.39"}}]
[5,"钟岚馨","254010202606",174,{"v":34.8,"d":"34.80"},83.93,{"v":41.965,"d":"41.97"},{"v":76.765,"d":"76.77"}]
[6,"黎发斌","254020105319",167.5,{"v":33.5,"d":"33.50"},83.43,{"v":41.715,"d":"41.72"},{"v":75.215,"d":"75.22"}]
[7,"侯媛","254010202720",161.5,{"v":32.3,"d":"32.30"},84.33,{"v":42.165,"d":"42.17"},{"v":74.465,"d":"74.47"}]
[8,"杨玲","254250201103",160,{"v":32,"d":"32.00"},{"v":84.9,"d":"84.90"},42.45,74.45]
[9,"夏冰雪","254020105309",146.5,{"v":29.3,"d":"29.30"},{"v":83.1,"d":"83.10"},41.55,70.85]
[10,"汪珍珍","254020105305",145.5,{"v":29.1,"d":"29.10"},82.97,{"v":41.485,"d":"41.49"},{"v":70.585,"d":"70.59"}]

{"sheet":"特岗初中历史","index":3,"n_rows":11,"n_cols":8,"rows_kept":11,"merged":[[0,0,0,7]]}
["乐平市2024年教师招聘成绩表                            　　　　　　　　     (特岗初中历史）（招聘3人）"]
["排名","姓名","准考证号","笔试成绩","笔试总分（×20%）","面试成绩","面试总分（×50%）","总成绩"]
[1,"金勤娥","254020105101",215,{"$f":"D3*0.2","v":{"v":43,"d":"43.00"}},87.53,{"$f":"F3*0.5","v":{"v":43.765,"d":"43.77"}},{"$f":"E3+G3","v":{"v":86.765,"d":"86.77"}}]
[2,"钟阳","254020105005",205,{"v":41,"d":"41.00"},85.07,{"v":42.535,"d":"42.54"},{"v":83.535,"d":"83.54"}]
[3,"吴文斌","254230203513",195,{"v":39,"d":"39.00"},86.87,{"v":43.435,"d":"43.44"},{"v":82.435,"d":"82.44"}]
[4,"黄玥","254020105020",186,{"v":37.2,"d":"37.20"},86.13,{"v":43.065,"d":"43.07"},{"v":80.265,"d":"80.27"}]
[5,"江子怡","254040106118",179,{"v":35.8,"d":"35.80"},82.4,{"v":41.2,"d":"41.20"},{"v":77,"d":"77.00"}]
[6,"方兰萍","254230203607",171.5,{"v":34.3,"d":"34.30"},84.03,{"v":42.015,"d":"42.02"},{"v":76.315,"d":"76.32"}]
[7,"彭秋芳","254020105013",169,{"v":33.8,"d":"33.80"},85,{"v":42.5,"d":"42.50"},{"v":76.3,"d":"76.30"}]
[8,"黄玉婷","254020105028",169,{"v":33.8,"d":"33.80"},84.23,{"v":42.115,"d":"42.12"},{"v":75.915,"d":"75.92"}]
[9,"叶一平","254230203603",158.5,{"v":31.7,"d":"31.70"},82.37,{"v":41.185,"d":"41.19"},{"v":72.885,"d":"72.89"}]

{"sheet":"特岗初中生物","index":4,"n_rows":14,"n_cols":8,"rows_kept":14,"merged":[[0,0,0,7]]}
["乐平市2024年教师招聘成绩表                            　　　　　　　　     (特岗初中生物）（招聘4人）"]
["排名","姓名","准考证号","笔试成绩","笔试总分（×20%）","面试成绩","面试总分（×50%）","总成绩"]
["1","王行","254040106528",220,{"$f":"D3*0.2","v":{"v":44,"d":"44.00"}},85.27,{"$f":"F3*0.5","v":{"v":42.635,"d":"42.64"}},{"$f":"E3+G3","v":{"v":86.635,"d":"86.64"}}]
["2","李扬","254010502920",216,{"$f":"D4*0.2","v":{"v":43.2,"d":"43.20"}},{"v":86.3,"d":"86.30"},{"$f":"F4*0.5","v":43.15},{"$f":"E4+G4","v":86.35}]
["3","安悦","254040106506",210,{"$f":"D5*0.2","v":{"v":42,"d":"42.00"}},{"v":86.7,"d":"86.70"},{"$f":"F5*0.5","v":43.35},{"$f":"E5+G5","v":85.35}]
["4","黄颖彦","254020105608",216,{"$f":"D6*0.2","v":{"v":43.2,"d":"43.20"}},84.13,{"$f":"F6*0.5","v":{"v":42.065,"d":"42.07"}},{"$f":"E6+G6","v":{"v":85.265,"d":"85.27"}}]
["5","张栎楠","254040106510",205.5,{"$f":"D7*0.2","v":{"v":41.1,"d":"41.10"}},86.43,{"$f":"F7*0.5","v":{"v":43.215,"d":"43.22"}},{"$f":"E7+G7","v":{"v":84.315,"d":"84.32"}}]
["6","胡双颖","254020105605",205,{"$f":"D8*0.2","v":{"v":41,"d":"41.00"}},86.23,{"$f":"F8*0.5","v":{"v":43.115,"d":"43.12"}},{"$f":"E8+G8","v":{"v":84.115,"d":"84.12"}}]
["7","杨潇","254010502724",209,{"$f":"D9*0.2","v":{"v":41.8,"d":"41.80"}},{"v":83.5,"d":"83.50"},{"$f":"F9*0.5","v":41.75},{"$f":"E9+G9","v":83.55}]
["8","梅甜甜","254010502711",202.5,{"$f":"D10*0.2","v":{"v":40.5,"d":"40.50"}},84.93,{"$f":"F10*0.5","v":{"v":42.465,"d":"42.47"}},{"$f":"E10+G10","v":{"v":82.965,"d":"82.97"}}]
["9","王静","254010502716",188.5,{"$f":"D11*0.2","v":{"v":37.7,"d":"37.70"}},84.93,{"$f":"F11*0.5","v":{"v":42.465,"d":"42.47"}},{"$f":"E11+G11","v":{"v":80.165,"d":"80.17"}}]
["10","王璐","254010502916",179,{"$f":"D12*0.2","v":{"v":35.8,"d":"35.80"}},85.67,{"$f":"F12*0.5","v":{"v":42.835,"d":"42.84"}},{"$f":"E12+G12","v":{"v":78.635,"d":"78.64"}}]
["11","罗丽霞","254040106512",187.5,{"$f":"D13*0.2","v":{"v":37.5,"d":"37.50"}},80.57,{"$f":"F13*0.5","v":{"v":40.285,"d":"40.29"}},{"$f":"E13+G13","v":{"v":77.785,"d":"77.79"}}]
["12","李婷","254020105610",183,{"$f":"D14*0.2","v":{"v":36.6,"d":"36.60"}},{"v":81.6,"d":"81.60"},{"$f":"F14*0.5","v":{"v":40.8,"d":"40.80"}},{"$f":"E14+G14","v":{"v":77.4,"d":"77.40"}}]

{"sheet":"特岗初中数学","index":5,"n_rows":19,"n_cols":8,"rows_kept":19,"merged":[[0,0,0,7]]}
["乐平市2024年教师招聘成绩表                            　　　　　　　　     (特岗初中数学）（招聘7人）"]
["排名","姓名","准考证号","笔试成绩","笔试总分（×20%）","面试成绩","面试总分（×50%）","总成绩"]
["1","黄飘","254060102914",215.5,{"$f":"D3*0.2","v":{"v":43.1,"d":"43.10"}},85.43,{"$f":"F3*0.5","v":{"v":42.715,"d":"42.72"}},{"$f":"E3+G3","v":{"v":85.815,"d":"85.82"}}]
["2","乐玉婷","254020103007",209.5,{"$f":"D4*0.2","v":{"v":41.9,"d":"41.90"}},87.23,{"$f":"F4*0.5","v":{"v":43.615,"d":"43.62"}},{"$f":"E4+G4","v":{"v":85.515,"d":"85.52"}}]
["3","夏丽君","254010302507",212.5,{"v":42.5,"d":"42.50"},85.63,{"v":42.815,"d":"42.82"},{"v":85.315,"d":"85.32"}]
["4","文雯","254040104422",212.5,{"$f":"D6*0.2","v":{"v":42.5,"d":"42.50"}},85.53,{"$f":"F6*0.5","v":{"v":42.765,"d":"42.77"}},{"$f":"E6+G6","v":{"v":85.265,"d":"85.27"}}]
["5","余晨","254020103207",207.5,{"$f":"D7*0.2","v":{"v":41.5,"d":"41.50"}},87.5,{"$f":"F7*0.5","v":43.75},{"$f":"E7+G7","v":85.25}]
["6","魏婷","254010302710",209.5,{"$f":"D8*0.2","v":{"v":41.9,"d":"41.90"}},85.87,{"$f":"F8*0.5","v":{"v":42.935,"d":"42.94"}},{"$f":"E8+G8","v":{"v":84.835,"d":"84.84"}}]
["7","周梦情","254020102923",203.5,{"v":40.7,"d":"40.70"},85.53,{"v":42.765,"d":"42.77"},{"v":83.465,"d":"83.47"}]
["8","吴金枝","254020103214",202.5,{"v":40.5,"d":"40.50"},85.57,{"v":42.785,"d":"42.79"},{"v":83.285,"d":"83.29"}]
["9","程素素","254010302112",196.5,{"$f":"D11*0.2","v":{"v":39.3,"d":"39.30"}},85.93,{"$f":"F11*0.5","v":{"v":42.965,"d":"42.97"}},{"$f":"E11+G11","v":{"v":82.265,"d":"82.27"}}]
["10","谭莎莎","254040104513",200,{"$f":"D12*0.2","v":{"v":40,"d":"40.00"}},84.03,{"$f":"F12*0.5","v":{"v":42.015,"d":"42.02"}},{"$f":"E12+G12","v":{"v":82.015,"d":"82.02"}}]
["11","朱崟","254020102909",195,{"v":39,"d":"39.00"},85.87,{"v":42.935,"d":"42.94"},{"v":81.935,"d":"81.94"}]
["12","王丹民","254010302614",193.5,{"v":38.7,"d":"38.70"},84.4,{"v":42.2,"d":"42.20"},{"v":80.9,"d":"80.90"}]
["13","石芳","254020103110",189,{"v":37.8,"d":"37.80"},83.63,{"v":41.815,"d":"41.82"},{"v":79.615,"d":"79.62"}]
["14","邵佳一","254010302717",182.5,{"$f":"D16*0.2","v":{"v":36.5,"d":"36.50"}},86.23,{"$f":"F16*0.5","v":{"v":43.115,"d":"43.12"}},{"$f":"E16+G16","v":{"v":79.615,"d":"79.62"}}]
["15","罗文亭","254010302702",187,{"$f":"D17*0.2","v":{"v":37.4,"d":"37.40"}},84.37,{"$f":"F17*0.5","v":{"v":42.185,"d":"42.19"}},{"$f":"E17+G17","v":{"v":79.585,"d":"79.59"}}]
["16","张雨含","254020103209",183,{"v":36.6,"d":"36.60"},85.1,42.55,79.15]
["17","彭兆聪","254020102922",183.5,{"$f":"D19*0.2","v":{"v":36.7,"d":"36.70"}},83.77,{"$f":"F19*0.5","v":{"v":41.885,"d":"41.89"}},{"$f":"E19+G19","v":{"v":78.585,"d":"78.59"}}]

{"sheet":"特岗初中美术","index":6,"n_rows":12,"n_cols":8,"rows_kept":12,"merged":[[0,0,0,7]]}
["乐平市2024年教师招聘成绩表                            　　　　　　　　     (特岗初中美术）（招聘3人）"]
["排名","姓名","准考证号","笔试成绩","笔试总分（×16%）","面试成绩","面试总分（×60%）","总成绩"]
[1,"匡梦琦","254010102427",203,{"$f":"D3*0.16","v":32.48},88.27,{"$f":"F3*0.6","v":{"v":52.962,"d":"52.96"}},{"$f":"E3+G3","v":{"v":85.442,"d":"85.44"}}]
[2,"何晶","254010103004",204.5,{"$f":"D4*0.16","v":32.72},87.63,{"$f":"F4*0.6","v":{"v":52.578,"d":"52.58"}},{"$f":"E4+G4","v":{"v":85.298,"d":"85.30"}}]
[3,"孙清霞","254010102501",199.5,{"$f":"D5*0.16","v":31.92},87.53,{"$f":"F5*0.6","v":{"v":52.518,"d":"52.52"}},{"$f":"E5+G5","v":{"v":84.438,"d":"84.44"}}]
[4,"徐雨婷","254020104611",196,{"$f":"D6*0.16","v":31.36},86.23,{"$f":"F6*0.6","v":{"v":51.738,"d":"51.74"}},{"$f":"E6+G6","v":{"v":83.098,"d":"83.10"}}]
[5,"章思龙","254050102403",190.5,{"$f":"D7*0.16","v":30.48},87.47,{"$f":"F7*0.6","v":{"v":52.482,"d":"52.48"}},{"$f":"E7+G7","v":{"v":82.962,"d":"82.96"}}]
[6,"彭梦丽","254020104802",200.5,{"$f":"D8*0.16","v":32.08},83.23,{"$f":"F8*0.6","v":{"v":49.938,"d":"49.94"}},{"$f":"E8+G8","v":{"v":82.018,"d":"82.02"}}]
[7,"舒龙怡","254050102330",191.5,{"$f":"D9*0.16","v":30.64},85.27,{"$f":"F9*0.6","v":{"v":51.162,"d":"51.16"}},{"$f":"E9+G9","v":{"v":81.802,"d":"81.80"}}]
[8,"石河琴","254020104703",185,{"$f":"D10*0.16","v":{"v":29.6,"d":"29.60"}},84.73,{"$f":"F10*0.6","v":{"v":50.838,"d":"50.84"}},{"$f":"E10+G10","v":{"v":80.438,"d":"80.44"}}]
[9,"邱琦","254010102519",184.5,29.52,0,{"v":0,"d":"0.00"},29.52]
[10,"黄琴","254250200720",184.5,29.52,0,{"v":0,"d":"0.00"},29.52]

{"sheet":"特岗初中体育与健康","index":7,"n_rows":7,"n_cols":8,"rows_kept":7,"merged":[[0,0,0,7]]}
["乐平市2024年教师招聘成绩表                            　　　　　　　　     (特岗初中体育与健康）（招聘2人）"]
["排名","姓名","准考证号","笔试成绩","笔试总分（×16%）","面试成绩","面试总分（×60%）","总成绩"]
["1","李威","254010605424",181,{"$f":"D3*0.16","v":28.96},82.27,{"$f":"F3*0.6","v":{"v":49.362,"d":"49.36"}},{"$f":"E3+G3","v":{"v":78.322,"d":"78.32"}}]
["2","阳志广","254040105504",179,{"$f":"D4*0.16","v":28.64},80.57,{"$f":"F4*0.6","v":{"v":48.342,"d":"48.34"}},{"$f":"E4+G4","v":{"v":76.982,"d":"76.98"}}]
["3","李瑶","254050102201",165,{"$f":"D5*0.16","v":{"v":26.4,"d":"26.40"}},74.07,{"$f":"F5*0.6","v":{"v":44.442,"d":"44.44"}},{"$f":"E5+G5","v":{"v":70.842,"d":"70.84"}}]
["4","陶贵敏","254020104302",154,{"$f":"D6*0.16","v":24.64},80.13,{"$f":"F6*0.6","v":{"v":48.078,"d":"48.08"}},{"$f":"E6+G6","v":{"v":72.718,"d":"72.72"}}]
["5","邹云微","254050102210",141,{"$f":"D7*0.16","v":22.56},0,{"$f":"F7*0.6","v":{"v":0,"d":"0.00"}},{"$f":"E7+G7","v":22.56}]

{"sheet":"特岗初中音乐","index":8,"n_rows":8,"n_cols":8,"rows_kept":8,"merged":[[0,0,0,7]]}
["乐平市2024年教师招聘成绩表                            　　　　　　　　     (特岗初中音乐）（招聘2人）"]
["排名","姓名","准考证号","笔试成绩","笔试总分（×16%）","面试成绩","面试总分（×60%）","总成绩"]
["1","彭晨辉","254010101528",161.5,{"$f":"D3*0.16","v":25.84},84.87,{"$f":"F3*0.6","v":{"v":50.922,"d":"50.92"}},{"$f":"E3+G3","v":{"v":76.762,"d":"76.76"}}]
["2","刘汉乾","254020104905",147,{"$f":"D4*0.16","v":23.52},86.17,{"$f":"F4*0.6","v":{"v":51.702,"d":"51.70"}},{"$f":"E4+G4","v":{"v":75.222,"d":"75.22"}}]
["3","李莎","254020104909",150,{"$f":"D5*0.16","v":{"v":24,"d":"24.00"}},83.87,{"$f":"F5*0.6","v":{"v":50.322,"d":"50.32"}},{"$f":"E5+G5","v":{"v":74.322,"d":"74.32"}}]
["4","付盈盈","254010101217",145,{"v":23.2,"d":"23.20"},84.47,{"v":50.682,"d":"50.68"},{"v":73.882,"d":"73.88"}]
["5","潘嘉诚","254010101211",137.5,{"v":22,"d":"22.00"},84.43,{"v":50.658,"d":"50.66"},{"v":72.658,"d":"72.66"}]
["6","王畑甜","254020104904",131,20.96,83.77,{"v":50.262,"d":"50.26"},{"v":71.222,"d":"71.22"}]

{"sheet":"特岗初中物理","index":9,"n_rows":13,"n_cols":8,"rows_kept":13,"merged":[[0,0,0,7]]}
["乐平市2024年教师招聘成绩表                            　　　　　　　　     (特岗初中物理）（招聘6人）"]
["排名","姓名","准考证号","笔试成绩","笔试总分（×20%）","面试成绩","面试总分（×50%）","总成绩"]
["1","马乐忠","254020105426",192.5,{"$f":"D3*0.2","v":{"v":38.5,"d":"38.50"}},83.23,{"$f":"F3*0.5","v":{"v":41.615,"d":"41.62"}},{"$f":"E3+G3","v":{"v":80.115,"d":"80.12"}}]
["2","石杰灵","254020105501",187.5,{"$f":"D4*0.2","v":{"v":37.5,"d":"37.50"}},{"v":84.5,"d":"84.50"},{"$f":"F4*0.5","v":42.25},{"$f":"E4+G4","v":79.75}]
["3","王泽斌","254010202919",184.5,{"$f":"D5*0.2","v":{"v":36.9,"d":"36.90"}},84.17,{"$f":"F5*0.5","v":{"v":42.085,"d":"42.09"}},{"$f":"E5+G5","v":{"v":78.985,"d":"78.99"}}]
["4","吴敏敏","254020105408",172.5,{"$f":"D6*0.2","v":{"v":34.5,"d":"34.50"}},86.27,{"$f":"F6*0.5","v":{"v":43.135,"d":"43.14"}},{"$f":"E6+G6","v":{"v":77.635,"d":"77.64"}}]
["5","朱文寿","254010202908",170,{"$f":"D7*0.2","v":{"v":34,"d":"34.00"}},85.03,{"$f":"F7*0.5","v":{"v":42.515,"d":"42.52"}},{"$f":"E7+G7","v":{"v":76.515,"d":"76.52"}}]
["6","徐乐阳","254020105508",163,{"$f":"D8*0.2","v":{"v":32.6,"d":"32.60"}},84.77,{"$f":"F8*0.5","v":{"v":42.385,"d":"42.39"}},{"$f":"E8+G8","v":{"v":74.985,"d":"74.99"}}]
["7","朱胜名","254040106412",155.5,{"$f":"D9*0.2","v":{"v":31.1,"d":"31.10"}},83.87,{"$f":"F9*0.5","v":{"v":41.935,"d":"41.94"}},{"$f":"E9+G9","v":{"v":73.035,"d":"73.04"}}]
["8","邹琳","254010203014",149,{"$f":"D10*0.2","v":{"v":29.8,"d":"29.80"}},{"v":84.8,"d":"84.80"},{"$f":"F10*0.5","v":{"v":42.4,"d":"42.40"}},{"$f":"E10+G10","v":{"v":72.2,"d":"72.20"}}]
["9","邵婧琦","254020105425",147.5,{"$f":"D11*0.2","v":{"v":29.5,"d":"29.50"}},85.23,{"$f":"F11*0.5","v":{"v":42.615,"d":"42.62"}},{"$f":"E11+G11","v":{"v":72.115,"d":"72.12"}}]
["10","孟秋景","254020105410",182.5,{"$f":"D12*0.2","v":{"v":36.5,"d":"36.50"}},{"v":0,"d":"0.00"},{"$f":"F12*0.5","v":{"v":0,"d":"0.00"}},{"$f":"E12+G12","v":{"v":36.5,"d":"36.50"}}]
["11","江美霞","254020105404",151,{"$f":"D13*0.2","v":{"v":30.2,"d":"30.20"}},{"v":0,"d":"0.00"},{"$f":"F13*0.5","v":{"v":0,"d":"0.00"}},{"$f":"E13+G13","v":{"v":30.2,"d":"30.20"}}]

{"sheet":"特岗初中心理健康教育","index":10,"n_rows":5,"n_cols":8,"rows_kept":5,"merged":[[0,0,0,7]]}
["乐平市2024年教师招聘成绩表                            　　　　　　　　     (特岗初中心理健康教育）（招聘1人）"]
["排名","姓名","准考证号","笔试成绩","笔试总分（×20%）","面试成绩","面试总分（×50%）","总成绩"]
["1","刘雅雯","254020105818",217,{"$f":"D3*0.2","v":{"v":43.4,"d":"43.40"}},88.33,{"$f":"F3*0.5","v":{"v":44.165,"d":"44.17"}},{"$f":"E3+G3","v":{"v":87.565,"d":"87.57"}}]
["2","宁诗琦","254060104502",213,{"$f":"D4*0.2","v":{"v":42.6,"d":"42.60"}},85.5,{"$f":"F4*0.5","v":42.75},{"$f":"E4+G4","v":85.35}]
["3","程璐","254020105822",203.5,{"$f":"D5*0.2","v":{"v":40.7,"d":"40.70"}},86.23,{"$f":"F5*0.5","v":{"v":43.115,"d":"43.12"}},{"$f":"E5+G5","v":{"v":83.815,"d":"83.82"}}]

{"sheet":"特岗初中英语","index":11,"n_rows":24,"n_cols":8,"rows_kept":24,"merged":[[0,0,0,7]]}
["乐平市2024年教师招聘成绩表                            　　　　　　　　     (特岗初中英语）（招聘11人）"]
["排名","姓名","准考证号","笔试成绩","笔试总分（×20%）","面试成绩","面试总分（×50%）","总成绩"]
["1","谢灵灵","254010604420",218,{"$f":"D3*0.2","v":{"v":43.6,"d":"43.60"}},87.77,{"$f":"F3*0.5","v":{"v":43.885,"d":"43.89"}},{"$f":"E3+G3","v":{"v":87.485,"d":"87.49"}}]
["2","方宜静","254040104710",210.5,{"$f":"D4*0.2","v":{"v":42.1,"d":"42.10"}},88.1,{"$f":"F4*0.5","v":44.05},{"$f":"E4+G4","v":86.15}]
["3","陈乐梅","254010604603",206.5,{"$f":"D5*0.2","v":{"v":41.3,"d":"41.30"}},89.03,{"$f":"F5*0.5","v":{"v":44.515,"d":"44.52"}},{"$f":"E5+G5","v":{"v":85.815,"d":"85.82"}}]
["4","胡溢","254230200801",205,{"$f":"D6*0.2","v":{"v":41,"d":"41.00"}},88.07,{"$f":"F6*0.5","v":{"v":44.035,"d":"44.04"}},{"$f":"E6+G6","v":{"v":85.035,"d":"85.04"}}]
["5","王祯","254010603630",202,{"$f":"D7*0.2","v":{"v":40.4,"d":"40.40"}},88.03,{"$f":"F7*0.5","v":{"v":44.015,"d":"44.02"}},{"$f":"E7+G7","v":{"v":84.415,"d":"84.42"}}]
["6","唐佳舒","254010603504",207,{"$f":"D8*0.2","v":{"v":41.4,"d":"41.40"}},85.57,{"$f":"F8*0.5","v":{"v":42.785,"d":"42.79"}},{"$f":"E8+G8","v":{"v":84.185,"d":"84.19"}}]
["7","朱翠婷","254020103409",201.5,{"$f":"D9*0.2","v":{"v":40.3,"d":"40.30"}},87.63,{"$f":"F9*0.5","v":{"v":43.815,"d":"43.82"}},{"$f":"E9+G9","v":{"v":84.115,"d":"84.12"}}]
["8","丁欣怡","254010604127",201,{"$f":"D10*0.2","v":{"v":40.2,"d":"40.20"}},87.67,{"$f":"F10*0.5","v":{"v":43.835,"d":"43.84"}},{"$f":"E10+G10","v":{"v":84.035,"d":"84.04"}}]
["9","江慧","254010603307",197,{"$f":"D11*0.2","v":{"v":39.4,"d":"39.40"}},88.23,{"$f":"F11*0.5","v":{"v":44.115,"d":"44.12"}},{"$f":"E11+G11","v":{"v":83.515,"d":"83.52"}}]
["10","程芳慧","254020103529",195,{"$f":"D12*0.2","v":{"v":39,"d":"39.00"}},88.73,{"$f":"F12*0.5","v":{"v":44.365,"d":"44.37"}},{"$f":"E12+G12","v":{"v":83.365,"d":"83.37"}}]
["11","王思","254010604329",200,{"$f":"D13*0.2","v":{"v":40,"d":"40.00"}},86.17,{"$f":"F13*0.5","v":{"v":43.085,"d":"43.09"}},{"$f":"E13+G13","v":{"v":83.085,"d":"83.09"}}]
["12","张惠悯","254010604126",197,{"$f":"D14*0.2","v":{"v":39.4,"d":"39.40"}},87.17,{"$f":"F14*0.5","v":{"v":43.585,"d":"43.59"}},{"$f":"E14+G14","v":{"v":82.985,"d":"82.99"}}]
["13","周星","254020103710",194.5,{"$f":"D15*0.2","v":{"v":38.9,"d":"38.90"}},88,{"$f":"F15*0.5","v":{"v":44,"d":"44.00"}},{"$f":"E15+G15","v":{"v":82.9,"d":"82.90"}}]
["14","张梦婷","254230201209",196,{"$f":"D16*0.2","v":{"v":39.2,"d":"39.20"}},87.3,{"$f":"F16*0.5","v":43.65},{"$f":"E16+G16","v":82.85}]
["15","盛婉怡","254020103814",196,{"$f":"D17*0.2","v":{"v":39.2,"d":"39.20"}},87.1,{"$f":"F17*0.5","v":43.55},{"$f":"E17+G17","v":82.75}]
["16","周一凡","254040104917",193,{"$f":"D18*0.2","v":{"v":38.6,"d":"38.60"}},88.2,{"$f":"F18*0.5","v":{"v":44.1,"d":"44.10"}},{"$f":"E18+G18","v":{"v":82.7,"d":"82.70"}}]
["17","张薇","254230201121",196.5,{"$f":"D19*0.2","v":{"v":39.3,"d":"39.30"}},86.77,{"$f":"F19*0.5","v":{"v":43.385,"d":"43.39"}},{"$f":"E19+G19","v":{"v":82.685,"d":"82.69"}}]
["18","叶梦琳","254230201321",195.5,{"$f":"D20*0.2","v":{"v":39.1,"d":"39.10"}},87.17,{"$f":"F20*0.5","v":{"v":43.585,"d":"43.59"}},{"$f":"E20+G20","v":{"v":82.685,"d":"82.69"}}]
["19","陈淑娟","254010603121",192.5,{"$f":"D21*0.2","v":{"v":38.5,"d":"38.50"}},87.63,{"$f":"F21*0.5","v":{"v":43.815,"d":"43.82"}},{"$f":"E21+G21","v":{"v":82.315,"d":"82.32"}}]
["20","彭宝赢","254020103801",192.5,{"$f":"D22*0.2","v":{"v":38.5,"d":"38.50"}},86.87,{"$f":"F22*0.5","v":{"v":43.435,"d":"43.44"}},{"$f":"E22+G22","v":{"v":81.935,"d":"81.94"}}]
["21","叶颖","254010603707",194.5,{"$f":"D23*0.2","v":{"v":38.9,"d":"38.90"}},84.63,{"$f":"F23*0.5","v":{"v":42.315,"d":"42.32"}},{"$f":"E23+G23","v":{"v":81.215,"d":"81.22"}}]
["22","刘佳慧","254040105213",195.5,{"$f":"D24*0.2","v":{"v":39.1,"d":"39.10"}},0,{"$f":"F24*0.5","v":{"v":0,"d":"0.00"}},{"$f":"E24+G24","v":{"v":39.1,"d":"39.10"}}]

{"sheet":"特岗初中语文","index":12,"n_rows":28,"n_cols":8,"rows_kept":28,"merged":[[0,0,0,7]]}
["乐平市2024年教师招聘成绩表                            　　　　　　　　     (特岗初中语文）（招聘13人）"]
["排名","姓名","准考证号","笔试成绩","笔试总分（×20%）","面试成绩","面试总分（×50%）","总成绩"]
["1","汪玉琦","254230200203",207,{"$f":"D3*0.2","v":{"v":41.4,"d":"41.40"}},84.83,{"$f":"F3*0.5","v":{"v":42.415,"d":"42.42"}},{"$f":"E3+G3","v":{"v":83.815,"d":"83.82"}}]
["2","胡渺婷","254020102630",198,{"$f":"D4*0.2","v":{"v":39.6,"d":"39.60"}},87.57,{"$f":"F4*0.5","v":{"v":43.785,"d":"43.79"}},{"$f":"E4+G4","v":{"v":83.385,"d":"83.39"}}]
["3","余柳秀","254020102430",199.5,{"$f":"D5*0.2","v":{"v":39.9,"d":"39.90"}},86.43,{"$f":"F5*0.5","v":{"v":43.215,"d":"43.22"}},{"$f":"E5+G5","v":{"v":83.115,"d":"83.12"}}]
["4","李媛媛","254230200401",202,{"$f":"D6*0.2","v":{"v":40.4,"d":"40.40"}},84.7,{"$f":"F6*0.5","v":42.35},{"$f":"E6+G6","v":82.75}]
["5","华燕","254010300929",207.5,{"$f":"D7*0.2","v":{"v":41.5,"d":"41.50"}},82.47,{"$f":"F7*0.5","v":{"v":41.235,"d":"41.24"}},{"$f":"E7+G7","v":{"v":82.735,"d":"82.74"}}]
["6","彭雅琴","254020102805",195,{"$f":"D8*0.2","v":{"v":39,"d":"39.00"}},86.43,{"$f":"F8*0.5","v":{"v":43.215,"d":"43.22"}},{"$f":"E8+G8","v":{"v":82.215,"d":"82.22"}}]
["7","罗娇娇","254010300902",195.5,{"$f":"D9*0.2","v":{"v":39.1,"d":"39.10"}},86.13,{"$f":"F9*0.5","v":{"v":43.065,"d":"43.07"}},{"$f":"E9+G9","v":{"v":82.165,"d":"82.17"}}]
["8","王璐瑶","254020102413",195,{"$f":"D10*0.2","v":{"v":39,"d":"39.00"}},85.9,{"$f":"F10*0.5","v":42.95},{"$f":"E10+G10","v":81.95}]
["9","宋雅文","254230200404",196.5,{"$f":"D11*0.2","v":{"v":39.3,"d":"39.30"}},84.07,{"$f":"F11*0.5","v":{"v":42.035,"d":"42.04"}},{"$f":"E11+G11","v":{"v":81.335,"d":"81.34"}}]
["10","余玉霞","254020102808",195,{"$f":"D12*0.2","v":{"v":39,"d":"39.00"}},84.37,{"$f":"F12*0.5","v":{"v":42.185,"d":"42.19"}},{"$f":"E12+G12","v":{"v":81.185,"d":"81.19"}}]
["11","何静雯","254040104230",195,{"$f":"D13*0.2","v":{"v":39,"d":"39.00"}},84.3,{"$f":"F13*0.5","v":42.15},{"$f":"E13+G13","v":81.15}]
["12","彭琬昱","254020102708",191.5,{"$f":"D14*0.2","v":{"v":38.3,"d":"38.30"}},84.93,{"$f":"F14*0.5","v":{"v":42.465,"d":"42.47"}},{"$f":"E14+G14","v":{"v":80.765,"d":"80.77"}}]
["13","何雯雅","254020102720",186,{"$f":"D15*0.2","v":{"v":37.2,"d":"37.20"}},87.1,{"$f":"F15*0.5","v":43.55},{"$f":"E15+G15","v":80.75}]
["14","汪永琪","254060102708",188,{"$f":"D16*0.2","v":{"v":37.6,"d":"37.60"}},85.57,{"$f":"F16*0.5","v":{"v":42.785,"d":"42.79"}},{"$f":"E16+G16","v":{"v":80.385,"d":"80.39"}}]
["15","雷英姿","254010300206",182,{"$f":"D17*0.2","v":{"v":36.4,"d":"36.40"}},87.4,{"$f":"F17*0.5","v":{"v":43.7,"d":"43.70"}},{"$f":"E17+G17","v":{"v":80.1,"d":"80.10"}}]
["16","吴丹萍","254020102425",185.5,{"$f":"D18*0.2","v":{"v":37.1,"d":"37.10"}},85.57,{"$f":"F18*0.5","v":{"v":42.785,"d":"42.79"}},{"$f":"E18+G18","v":{"v":79.885,"d":"79.89"}}]
["17","余丽红","254020102617",189,{"$f":"D19*0.2","v":{"v":37.8,"d":"37.80"}},83.93,{"$f":"F19*0.5","v":{"v":41.965,"d":"41.97"}},{"$f":"E19+G19","v":{"v":79.765,"d":"79.77"}}]
["18","时尚","254020102717",185,{"$f":"D20*0.2","v":{"v":37,"d":"37.00"}},85.5,{"$f":"F20*0.5","v":42.75},{"$f":"E20+G20","v":79.75}]
["19","夏婧","254250200203",185,{"$f":"D21*0.2","v":{"v":37,"d":"37.00"}},85.47,{"$f":"F21*0.5","v":{"v":42.735,"d":"42.74"}},{"$f":"E21+G21","v":{"v":79.735,"d":"79.74"}}]
["20","郑曾琦","254230200103",186.5,{"$f":"D22*0.2","v":{"v":37.3,"d":"37.30"}},84.23,{"$f":"F22*0.5","v":{"v":42.115,"d":"42.12"}},{"$f":"E22+G22","v":{"v":79.415,"d":"79.42"}}]
["21","王欣","254040104120",183.5,{"$f":"D23*0.2","v":{"v":36.7,"d":"36.70"}},85.33,{"$f":"F23*0.5","v":{"v":42.665,"d":"42.67"}},{"$f":"E23+G23","v":{"v":79.365,"d":"79.37"}}]
["22","吴萍","254020102802",181,{"$f":"D24*0.2","v":{"v":36.2,"d":"36.20"}},85.93,{"$f":"F24*0.5","v":{"v":42.965,"d":"42.97"}},{"$f":"E24+G24","v":{"v":79.165,"d":"79.17"}}]
["23","张茜","254040104304",185.5,{"$f":"D25*0.2","v":{"v":37.1,"d":"37.10"}},83.87,{"$f":"F25*0.5","v":{"v":41.935,"d":"41.94"}},{"$f":"E25+G25","v":{"v":79.035,"d":"79.04"}}]
["24","叶莲琪","254010300814",184,{"$f":"D26*0.2","v":{"v":36.8,"d":"36.80"}},83.17,{"$f":"F26*0.5","v":{"v":41.585,"d":"41.59"}},{"$f":"E26+G26","v":{"v":78.385,"d":"78.39"}}]
["25","曾玥","254040104318",182,{"$f":"D27*0.2","v":{"v":36.4,"d":"36.40"}},83.57,{"$f":"F27*0.5","v":{"v":41.785,"d":"41.79"}},{"$f":"E27+G27","v":{"v":78.185,"d":"78.19"}}]
["26","张莉颖","254060102629",181,{"$f":"D28*0.2","v":{"v":36.2,"d":"36.20"}},0,{"$f":"F28*0.5","v":{"v":0,"d":"0.00"}},{"$f":"E28+G28","v":{"v":36.2,"d":"36.20"}}]