{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["2022特岗教师招聘综合成绩及拟入围体检考生名单公示"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"2022特岗教师招聘综合成绩及拟入围体检考生名单公示","index":0,"n_rows":76,"n_cols":11,"rows_kept":76,"merged":[[0,0,0,10]]}
["附件1:丹寨县2022年“特岗计划” 教师招聘综合成绩及拟入围体检考生名单公示"]
["序号","姓名","报考县","报考学段","报考学科","笔试成绩\n（四舍五入后保留2位小数）","面试成绩\n（四舍五入后保留2位小数）","笔试成绩折算（50%）","面试成绩折算（50%）","综合分\n（笔试50%+面试50%）","是否入围体检"]
[{"$f":"IF(B3<>\"\",SUBTOTAL(3,$B$3:B3)+0,\"\")","v":1},"刘少雨","丹寨县","小学","语文",{"v":70.5,"d":"70.50"},86.33,{"$f":"ROUND(F3*0.5,2)","v":35.25},{"$f":"ROUND(G3*0.5,2)","v":43.17},{"$f":"H3+I3","v":78.42},"入围体检"]
[{"$f":"IF(B4<>\"\",SUBTOTAL(3,$B$3:B4)+0,\"\")","v":2},"周艳玲","丹寨县","小学","语文",{"v":68,"d":"68.00"},84.33,34,42.17,76.17,"入围体检"]
[{"$f":"IF(B5<>\"\",SUBTOTAL(3,$B$3:B5)+0,\"\")","v":3},"王秋丽","丹寨县","小学","语文",{"v":69.5,"d":"69.50"},{"v":81,"d":"81.00"},34.75,40.5,75.25,""]
[{"$f":"IF(B6<>\"\",SUBTOTAL(3,$B$3:B6)+0,\"\")","v":4},"赵燕","丹寨县","小学","语文",{"v":64.5,"d":"64.50"},{"v":84,"d":"84.00"},32.25,42,74.25,""]
[{"$f":"IF(B7<>\"\",SUBTOTAL(3,$B$3:B7)+0,\"\")","v":5},"陆晓秀","丹寨县","小学","语文",{"v":63.5,"d":"63.50"},76.33,31.75,38.17,69.92,""]
[{"$f":"IF(B8<>\"\",SUBTOTAL(3,$B$3:B8)+0,\"\")","v":6},"文春丽","丹寨县","小学","语文",{"v":62.5,"d":"62.50"},{"v":77,"d":"77.00"},31.25,38.5,69.75,""]
[{"$f":"IF(B9<>\"\",SUBTOTAL(3,$B$3:B9)+0,\"\")","v":7},"刘青","丹寨县","小学","数学",{"v":59,"d":"59.00"},{"v":88,"d":"88.00"},29.5,44,73.5,"入围体检"]
[{"$f":"IF(B10<>\"\",SUBTOTAL(3,$B$3:B10)+0,\"\")","v":8},"农佩文","丹寨县","小学","数学",{"v":52.5,"d":"52.50"},{"v":88,"d":"88.00"},26.25,44,70.25,"入围体检"]
[{"$f":"IF(B11<>\"\",SUBTOTAL(3,$B$3:B11)+0,\"\")","v":9},"谢进会","丹寨县","小学","数学",{"v":52,"d":"52.00"},{"v":81,"d":"81.00"},26,40.5,66.5,""]
[{"$f":"IF(B12<>\"\",SUBTOTAL(3,$B$3:B12)+0,\"\")","v":10},"吴泰云","丹寨县","小学","数学",{"v":34,"d":"34.00"},69.67,17,34.84,51.84,""]
[{"$f":"IF(B13<>\"\",SUBTOTAL(3,$B$3:B13)+0,\"\")","v":11},"王应兰","丹寨县","小学","数学",{"v":33.5,"d":"33.50"},{"v":0,"d":"0.00"},16.75,0,16.75,""]
[{"$f":"IF(B14<>\"\",SUBTOTAL(3,$B$3:B14)+0,\"\")","v":12},"杨雪","丹寨县","小学","数学",{"v":32,"d":"32.00"},{"v":0,"d":"0.00"},16,0,16,""]
[{"$f":"IF(B15<>\"\",SUBTOTAL(3,$B$3:B15)+0,\"\")","v":13},"夏小芳","丹寨县","小学","英语",{"v":87.5,"d":"87.50"},91.33,43.75,45.67,89.42,"入围体检"]
[{"$f":"IF(B16<>\"\",SUBTOTAL(3,$B$3:B16)+0,\"\")","v":14},"王雪","丹寨县","小学","英语",{"v":77,"d":"77.00"},{"v":88,"d":"88.00"},38.5,44,82.5,"入围体检"]
[{"$f":"IF(B17<>\"\",SUBTOTAL(3,$B$3:B17)+0,\"\")","v":15},"杨倩","丹寨县","小学","英语",{"v":75.5,"d":"75.50"},89.33,37.75,44.67,82.42,"入围体检"]
[{"$f":"IF(B18<>\"\",SUBTOTAL(3,$B$3:B18)+0,\"\")","v":16},"龙小妹","丹寨县","小学","英语",{"v":76.5,"d":"76.50"},86.33,38.25,43.17,81.42,"入围体检"]
[{"$f":"IF(B19<>\"\",SUBTOTAL(3,$B$3:B19)+0,\"\")","v":17},"姜基桃","丹寨县","小学","英语",{"v":74,"d":"74.00"},88.33,37,44.17,81.17,"入围体检"]
[{"$f":"IF(B20<>\"\",SUBTOTAL(3,$B$3:B20)+0,\"\")","v":18},"余海花","丹寨县","小学","英语",{"v":73.5,"d":"73.50"},88.33,36.75,44.17,80.92,""]
[{"$f":"IF(B21<>\"\",SUBTOTAL(3,$B$3:B21)+0,\"\")","v":19},"黎忠琴","丹寨县","小学","英语",{"v":72,"d":"72.00"},89.67,36,44.84,80.84,""]
[{"$f":"IF(B22<>\"\",SUBTOTAL(3,$B$3:B22)+0,\"\")","v":20},"金应弛","丹寨县","小学","英语",{"v":71,"d":"71.00"},90.33,35.5,45.17,80.67,""]
[{"$f":"IF(B23<>\"\",SUBTOTAL(3,$B$3:B23)+0,\"\")","v":21},"石静一","丹寨县","小学","英语",{"v":72,"d":"72.00"},87.67,36,43.84,79.84,""]
[{"$f":"IF(B24<>\"\",SUBTOTAL(3,$B$3:B24)+0,\"\")","v":22},"梁任燕","丹寨县","小学","英语",{"v":76.5,"d":"76.50"},{"v":81,"d":"81.00"},38.25,40.5,78.75,""]
[{"$f":"IF(B25<>\"\",SUBTOTAL(3,$B$3:B25)+0,\"\")","v":23},"宋定周","丹寨县","小学","英语",{"v":73,"d":"73.00"},83.67,36.5,41.84,78.34,""]
[{"$f":"IF(B26<>\"\",SUBTOTAL(3,$B$3:B26)+0,\"\")","v":24},"杨光叶","丹寨县","小学","英语",{"v":71,"d":"71.00"},{"v":85,"d":"85.00"},35.5,42.5,78,""]
[{"$f":"IF(B27<>\"\",SUBTOTAL(3,$B$3:B27)+0,\"\")","v":25},"张晓芳","丹寨县","小学","英语",{"v":71,"d":"71.00"},83.67,35.5,41.84,77.34,""]
[{"$f":"IF(B28<>\"\",SUBTOTAL(3,$B$3:B28)+0,\"\")","v":26},"余祝英","丹寨县","小学","英语",{"v":70.5,"d":"70.50"},{"v":83,"d":"83.00"},35.25,41.5,76.75,""]
[{"$f":"IF(B29<>\"\",SUBTOTAL(3,$B$3:B29)+0,\"\")","v":27},"杨胜英","丹寨县","小学","英语",{"v":70.5,"d":"70.50"},{"v":0,"d":"0.00"},35.25,0,35.25,""]
[{"$f":"IF(B30<>\"\",SUBTOTAL(3,$B$3:B30)+0,\"\")","v":28},"吴雍康","丹寨县","小学","体育",{"v":74.5,"d":"74.50"},79.67,37.25,39.84,77.09,"入围体检"]
[{"$f":"IF(B31<>\"\",SUBTOTAL(3,$B$3:B31)+0,\"\")","v":29},"王昌胜","丹寨县","小学","体育",{"v":65.5,"d":"65.50"},81.33,32.75,40.67,73.42,"入围体检"]
[{"$f":"IF(B32<>\"\",SUBTOTAL(3,$B$3:B32)+0,\"\")","v":30},"马应莉","丹寨县","小学","体育",{"v":61.5,"d":"61.50"},82.33,30.75,41.17,71.92,"入围体检"]
[{"$f":"IF(B33<>\"\",SUBTOTAL(3,$B$3:B33)+0,\"\")","v":31},"田如军","丹寨县","小学","体育",{"v":65,"d":"65.00"},78.67,32.5,39.34,71.84,""]
[{"$f":"IF(B34<>\"\",SUBTOTAL(3,$B$3:B34)+0,\"\")","v":32},"杨明艳","丹寨县","小学","体育",{"v":60.5,"d":"60.50"},81.67,30.25,40.84,71.09,""]
[{"$f":"IF(B35<>\"\",SUBTOTAL(3,$B$3:B35)+0,\"\")","v":33},"李通","丹寨县","小学","体育",{"v":59.5,"d":"59.50"},{"v":80,"d":"80.00"},29.75,40,69.75,""]
[{"$f":"IF(B36<>\"\",SUBTOTAL(3,$B$3:B36)+0,\"\")","v":34},"王荣","丹寨县","小学","体育",{"v":59.5,"d":"59.50"},{"v":79,"d":"79.00"},29.75,39.5,69.25,""]
[{"$f":"IF(B37<>\"\",SUBTOTAL(3,$B$3:B37)+0,\"\")","v":35},"文海燕","丹寨县","小学","体育",{"v":57.5,"d":"57.50"},{"v":75,"d":"75.00"},28.75,37.5,66.25,""]
[{"$f":"IF(B38<>\"\",SUBTOTAL(3,$B$3:B38)+0,\"\")","v":36},"文良顺","丹寨县","小学","体育",{"v":55.5,"d":"55.50"},{"v":0,"d":"0.00"},27.75,0,27.75,""]
[{"$f":"IF(B39<>\"\",SUBTOTAL(3,$B$3:B39)+0,\"\")","v":37},"李佳琴","丹寨县","小学","心理健康",{"v":71.5,"d":"71.50"},73.83,35.75,36.92,72.67,"入围体检"]
[{"$f":"IF(B40<>\"\",SUBTOTAL(3,$B$3:B40)+0,\"\")","v":38},"高芮","丹寨县","小学","心理健康",{"v":67.5,"d":"67.50"},{"v":76,"d":"76.00"},33.75,38,71.75,"入围体检"]
[{"$f":"IF(B41<>\"\",SUBTOTAL(3,$B$3:B41)+0,\"\")","v":39},"杨梅花","丹寨县","小学","心理健康",{"v":67.5,"d":"67.50"},{"v":76,"d":"76.00"},33.75,38,71.75,"入围体检"]
[{"$f":"IF(B42<>\"\",SUBTOTAL(3,$B$3:B42)+0,\"\")","v":40},"沈建兰","丹寨县","小学","心理健康",{"v":58.5,"d":"58.50"},{"v":81.5,"d":"81.50"},29.25,40.75,70,"入围体检"]
[{"$f":"IF(B43<>\"\",SUBTOTAL(3,$B$3:B43)+0,\"\")","v":41},"杨涓","丹寨县","小学","心理健康",{"v":68.5,"d":"68.50"},70.83,34.25,35.42,69.67,"入围体检"]
[{"$f":"IF(B44<>\"\",SUBTOTAL(3,$B$3:B44)+0,\"\")","v":42},"王强","丹寨县","小学","心理健康",{"v":66.5,"d":"66.50"},{"v":72.5,"d":"72.50"},33.25,36.25,69.5,"入围体检"]
[{"$f":"IF(B45<>\"\",SUBTOTAL(3,$B$3:B45)+0,\"\")","v":43},"杨琴","丹寨县","小学","心理健康",{"v":58.5,"d":"58.50"},77.33,29.25,38.67,67.92,"入围体检"]
[{"$f":"IF(B46<>\"\",SUBTOTAL(3,$B$3:B46)+0,\"\")","v":44},"屠丽龙","丹寨县","小学","心理健康",{"v":63,"d":"63.00"},{"v":70,"d":"70.00"},31.5,35,66.5,""]
[{"$f":"IF(B47<>\"\",SUBTOTAL(3,$B$3:B47)+0,\"\")","v":45},"彭占清","丹寨县","小学","心理健康",{"v":55,"d":"55.00"},{"v":78,"d":"78.00"},27.5,39,66.5,""]
[{"$f":"IF(B48<>\"\",SUBTOTAL(3,$B$3:B48)+0,\"\")","v":46},"韦金花","丹寨县","小学","心理健康",{"v":69,"d":"69.00"},62.33,34.5,31.17,65.67,""]
[{"$f":"IF(B49<>\"\",SUBTOTAL(3,$B$3:B49)+0,\"\")","v":47},"文艳","丹寨县","小学","心理健康",{"v":65,"d":"65.00"},66.17,32.5,33.09,65.59,""]
[{"$f":"IF(B50<>\"\",SUBTOTAL(3,$B$3:B50)+0,\"\")","v":48},"刘佐琴","丹寨县","小学","心理健康",{"v":62,"d":"62.00"},69.17,31,34.59,65.59,""]
[{"$f":"IF(B51<>\"\",SUBTOTAL(3,$B$3:B51)+0,\"\")","v":49},"莫维雯","丹寨县","小学","心理健康",{"v":63.5,"d":"63.50"},67.33,31.75,33.67,65.42,""]
[{"$f":"IF(B52<>\"\",SUBTOTAL(3,$B$3:B52)+0,\"\")","v":50},"罗林美","丹寨县","小学","心理健康",{"v":58,"d":"58.00"},72.33,29,36.17,65.17,""]
[{"$f":"IF(B53<>\"\",SUBTOTAL(3,$B$3:B53)+0,\"\")","v":51},"李银","丹寨县","小学","心理健康",{"v":60.5,"d":"60.50"},69.33,30.25,34.67,64.92,""]
[{"$f":"IF(B54<>\"\",SUBTOTAL(3,$B$3:B54)+0,\"\")","v":52},"范琳","丹寨县","小学","心理健康",{"v":62.5,"d":"62.50"},67.17,31.25,33.59,64.84,""]
[{"$f":"IF(B55<>\"\",SUBTOTAL(3,$B$3:B55)+0,\"\")","v":53},"王婕","丹寨县","小学","心理健康",{"v":59.5,"d":"59.50"},69.83,29.75,34.92,64.67,""]
[{"$f":"IF(B56<>\"\",SUBTOTAL(3,$B$3:B56)+0,\"\")","v":54},"杨蛟","丹寨县","小学","心理健康",{"v":53,"d":"53.00"},{"v":62.5,"d":"62.50"},26.5,31.25,57.75,""]
[{"$f":"IF(B57<>\"\",SUBTOTAL(3,$B$3:B57)+0,\"\")","v":55},"王定燕","丹寨县","小学","心理健康",{"v":56.5,"d":"56.50"},58.67,28.25,29.34,57.59,""]
[{"$f":"IF(B58<>\"\",SUBTOTAL(3,$B$3:B58)+0,\"\")","v":56},"韦晓媚","丹寨县","小学","心理健康",{"v":49.5,"d":"49.50"},{"v":64,"d":"64.00"},24.75,32,56.75,""]
[{"$f":"IF(B59<>\"\",SUBTOTAL(3,$B$3:B59)+0,\"\")","v":57},"蒙永良","丹寨县","小学","心理健康",{"v":50.5,"d":"50.50"},{"v":0,"d":"0.00"},25.25,0,25.25,""]
[{"$f":"IF(B60<>\"\",SUBTOTAL(3,$B$3:B60)+0,\"\")","v":58},"丁欣羽","丹寨县","初中","语文",{"v":69.5,"d":"69.50"},90.83,34.75,45.42,80.17,"入围体检"]
[{"$f":"IF(B61<>\"\",SUBTOTAL(3,$B$3:B61)+0,\"\")","v":59},"罗世银","丹寨县","初中","语文",{"v":71.5,"d":"71.50"},87.67,35.75,43.84,79.59,""]
[{"$f":"IF(B62<>\"\",SUBTOTAL(3,$B$3:B62)+0,\"\")","v":60},"潘文练","丹寨县","初中","语文",{"v":69,"d":"69.00"},{"v":81,"d":"81.00"},34.5,40.5,75,""]
[{"$f":"IF(B63<>\"\",SUBTOTAL(3,$B$3:B63)+0,\"\")","v":61},"罗顺群","丹寨县","初中","语文",{"v":69,"d":"69.00"},{"v":0,"d":"0.00"},34.5,0,34.5,""]
[{"$f":"IF(B64<>\"\",SUBTOTAL(3,$B$3:B64)+0,\"\")","v":62},"蒙礼梅","丹寨县","初中","数学",{"v":74.5,"d":"74.50"},89.33,37.25,44.67,81.92,"入围体检"]
[{"$f":"IF(B65<>\"\",SUBTOTAL(3,$B$3:B65)+0,\"\")","v":63},"杨杰","丹寨县","初中","数学",{"v":74,"d":"74.00"},{"v":87,"d":"87.00"},37,43.5,80.5,"入围体检"]
[{"$f":"IF(B66<>\"\",SUBTOTAL(3,$B$3:B66)+0,\"\")","v":64},"刘正龙","丹寨县","初中","数学",{"v":63,"d":"63.00"},{"v":0,"d":"0.00"},31.5,0,31.5,""]
[{"$f":"IF(B67<>\"\",SUBTOTAL(3,$B$3:B67)+0,\"\")","v":65},"李文杰","丹寨县","初中","数学",{"v":53,"d":"53.00"},{"v":0,"d":"0.00"},{"$f":"ROUND(F67*0.5,2)","v":26.5},{"$f":"ROUND(G67*0.5,2)","v":0},{"$f":"H67+I67","v":26.5},""]
[{"$f":"IF(B68<>\"\",SUBTOTAL(3,$B$3:B68)+0,\"\")","v":66},"龙宇","丹寨县","初中","英语",{"v":85.5,"d":"85.50"},89.67,42.75,44.84,87.59,"入围体检"]
[{"$f":"IF(B69<>\"\",SUBTOTAL(3,$B$3:B69)+0,\"\")","v":67},"文光英","丹寨县","初中","英语",{"v":81.5,"d":"81.50"},90.33,40.75,45.17,85.92,"入围体检"]
[{"$f":"IF(B70<>\"\",SUBTOTAL(3,$B$3:B70)+0,\"\")","v":68},"张萌","丹寨县","初中","英语",{"v":80.5,"d":"80.50"},{"v":86,"d":"86.00"},40.25,43,83.25,""]
[{"$f":"IF(B71<>\"\",SUBTOTAL(3,$B$3:B71)+0,\"\")","v":69},"唐艺","丹寨县","初中","英语",{"v":76.5,"d":"76.50"},88.33,38.25,44.17,82.42,""]
[{"$f":"IF(B72<>\"\",SUBTOTAL(3,$B$3:B72)+0,\"\")","v":70},"周华艳","丹寨县","初中","英语",{"v":74,"d":"74.00"},{"v":89,"d":"89.00"},37,44.5,81.5,""]
[{"$f":"IF(B73<>\"\",SUBTOTAL(3,$B$3:B73)+0,\"\")","v":71},"吴依依","丹寨县","初中","英语",{"v":76.5,"d":"76.50"},{"v":85,"d":"85.00"},38.25,42.5,80.75,""]
[{"$f":"IF(B74<>\"\",SUBTOTAL(3,$B$3:B74)+0,\"\")","v":72},"吴小春","丹寨县","初中","政治",{"v":76.5,"d":"76.50"},87.67,38.25,43.84,82.09,"入围体检"]
[{"$f":"IF(B75<>\"\",SUBTOTAL(3,$B$3:B75)+0,\"\")","v":73},"李旭梅","丹寨县","初中","政治",{"v":75.5,"d":"75.50"},{"v":88,"d":"88.00"},37.75,44,81.75,""]
[{"$f":"IF(B76<>\"\",SUBTOTAL(3,$B$3:B76)+0,\"\")","v":74},"李秋灵","丹寨县","初中","政治",{"v":77.5,"d":"77.50"},85.67,38.75,42.84,81.59,""]