{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["综合成绩、体检人员公布"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"综合成绩、体检人员公布","index":0,"n_rows":196,"n_cols":21,"rows_kept":196,"merged":[[0,0,0,20]]}
["榕江县2022年“特岗计划” 教师招聘笔试、面试考生综合成绩及进入体检人员名单"]
["序号","姓名","报考县","报考学段","报考学科","考场号","座位号","笔试\n准考证号","笔试成绩\n（四舍五入后保留2位小数）","笔试分组排名","候考室号","考场号","面试场次","面试准考证号","面试成绩\n（四舍五入后保留2位小数）","面试分组排名","笔试成绩折算（50%）","面试成绩折算（50%）","综合分\n（笔试50%+面试50%）","综合分组排名","是否入围\n体检"]
[{"$f":"IF(B3<>\"\",SUBTOTAL(3,$B$3:B3)+0,\"\")","v":1},"张贵源","榕江县","幼儿园","学前教育","007","27","05011300727",62,1,"第42候考室","第42考场","下午场","20501164231",83,1,{"$f":"ROUND(I3*0.5,2)","v":31},{"$f":"ROUND(O3*0.5,2)","v":41.5},{"$f":"Q3+R3","v":72.5},{"$f":"IF(S3=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA3)*($T$3:$T$196>S3))+1)","v":1},"入围体检"]
[{"$f":"IF(B4<>\"\",SUBTOTAL(3,$B$3:B4)+0,\"\")","v":2},"吴书菲","榕江县","幼儿园","学前教育","010","01","05011301001",60,2,"第42候考室","第42考场","下午场","20501164233",78.33,4,30,39.17,69.17,{"$f":"IF(S4=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA4)*($T$3:$T$196>S4))+1)","v":2},"入围体检"]
[{"$f":"IF(B5<>\"\",SUBTOTAL(3,$B$3:B5)+0,\"\")","v":3},"吴丹","榕江县","幼儿园","学前教育","010","02","05011301002",58.5,4,"第42候考室","第42考场","下午场","20501164234",79.67,2,29.25,39.84,69.09,{"$f":"IF(S5=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA5)*($T$3:$T$196>S5))+1)","v":3},"入围体检"]
[{"$f":"IF(B6<>\"\",SUBTOTAL(3,$B$3:B6)+0,\"\")","v":4},"杨青青","榕江县","幼儿园","学前教育","009","03","05011300903",60,2,"第42候考室","第42考场","下午场","20501164232",77.67,5,30,38.84,68.84,{"$f":"IF(S6=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA6)*($T$3:$T$196>S6))+1)","v":4},"入围体检"]
[{"$f":"IF(B7<>\"\",SUBTOTAL(3,$B$3:B7)+0,\"\")","v":5},"王莹","榕江县","幼儿园","学前教育","015","29","05011301529",58.5,4,"第42候考室","第42考场","下午场","20501164235",76.67,8,29.25,38.34,67.59,{"$f":"IF(S7=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA7)*($T$3:$T$196>S7))+1)","v":5},"入围体检"]
[{"$f":"IF(B8<>\"\",SUBTOTAL(3,$B$3:B8)+0,\"\")","v":6},"吴秀花","榕江县","幼儿园","学前教育","017","21","05011301721",57,6,"第42候考室","第42考场","下午场","20501164236",76.67,8,28.5,38.34,66.84,{"$f":"IF(S8=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA8)*($T$3:$T$196>S8))+1)","v":6},"入围体检"]
[{"$f":"IF(B9<>\"\",SUBTOTAL(3,$B$3:B9)+0,\"\")","v":7},"黄彩蝶","榕江县","幼儿园","学前教育","009","29","05011300929",54,9,"第42候考室","第42考场","下午场","20501164239",78.67,3,27,39.34,66.34,{"$f":"IF(S9=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA9)*($T$3:$T$196>S9))+1)","v":7},"入围体检"]
[{"$f":"IF(B10<>\"\",SUBTOTAL(3,$B$3:B10)+0,\"\")","v":8},"吴苇芗","榕江县","幼儿园","学前教育","008","21","05011300821",53,11,"第42候考室","第42考场","下午场","20501164241",77.67,5,26.5,38.84,65.34,{"$f":"IF(S10=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA10)*($T$3:$T$196>S10))+1)","v":8},""]
[{"$f":"IF(B11<>\"\",SUBTOTAL(3,$B$3:B11)+0,\"\")","v":9},"杨鸿玉","榕江县","幼儿园","学前教育","011","12","05011301112",52.8,12,"第42候考室","第42考场","下午场","20501164242",77.33,7,26.4,38.67,65.07,{"$f":"IF(S11=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA11)*($T$3:$T$196>S11))+1)","v":9},""]
[{"$f":"IF(B12<>\"\",SUBTOTAL(3,$B$3:B12)+0,\"\")","v":10},"姚元颖","榕江县","幼儿园","学前教育","010","05","05011301005",52,13,"第42候考室","第42考场","下午场","20501164243",75.67,12,26,37.84,63.84,{"$f":"IF(S12=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA12)*($T$3:$T$196>S12))+1)","v":10},""]
[{"$f":"IF(B13<>\"\",SUBTOTAL(3,$B$3:B13)+0,\"\")","v":11},"罗文霞","榕江县","幼儿园","学前教育","010","19","05011301019",56,7,"第42候考室","第42考场","下午场","20501164237",71.33,17,28,35.67,63.67,{"$f":"IF(S13=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA13)*($T$3:$T$196>S13))+1)","v":11},""]
[{"$f":"IF(B14<>\"\",SUBTOTAL(3,$B$3:B14)+0,\"\")","v":12},"梁小随","榕江县","幼儿园","学前教育","009","08","05011300908",51,18,"第42候考室","第42考场","下午场","20501164249",76.33,10,25.5,38.17,63.67,{"$f":"IF(S14=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA14)*($T$3:$T$196>S14))+1)","v":11},""]
[{"$f":"IF(B15<>\"\",SUBTOTAL(3,$B$3:B15)+0,\"\")","v":13},"莫美秀","榕江县","幼儿园","学前教育","008","28","05011300828",50.5,20,"第42候考室","第42考场","下午场","20501164250",76.33,10,25.25,38.17,63.42,{"$f":"IF(S15=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA15)*($T$3:$T$196>S15))+1)","v":13},""]
[{"$f":"IF(B16<>\"\",SUBTOTAL(3,$B$3:B16)+0,\"\")","v":14},"李仁春","榕江县","幼儿园","学前教育","011","16","05011301116",53.3,10,"第42候考室","第42考场","下午场","20501164240",73.33,15,26.65,36.67,63.32,{"$f":"IF(S16=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA16)*($T$3:$T$196>S16))+1)","v":14},""]
[{"$f":"IF(B17<>\"\",SUBTOTAL(3,$B$3:B17)+0,\"\")","v":15},"王西希","榕江县","幼儿园","学前教育","015","05","05011301505",55,8,"第42候考室","第42考场","下午场","20501164238",70.67,19,27.5,35.34,62.84,{"$f":"IF(S17=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA17)*($T$3:$T$196>S17))+1)","v":15},""]
[{"$f":"IF(B18<>\"\",SUBTOTAL(3,$B$3:B18)+0,\"\")","v":16},"杨正姣","榕江县","幼儿园","学前教育","010","27","05011301027",51.5,15,"第42候考室","第42考场","下午场","20501164246",73.67,14,25.75,36.84,62.59,{"$f":"IF(S18=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA18)*($T$3:$T$196>S18))+1)","v":16},""]
[{"$f":"IF(B19<>\"\",SUBTOTAL(3,$B$3:B19)+0,\"\")","v":17},"龙晓","榕江县","幼儿园","学前教育","009","04","05011300904",50,21,"第42候考室","第42考场","下午场","20501164251",74.67,13,25,37.34,62.34,{"$f":"IF(S19=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA19)*($T$3:$T$196>S19))+1)","v":17},""]
[{"$f":"IF(B20<>\"\",SUBTOTAL(3,$B$3:B20)+0,\"\")","v":18},"石港归","榕江县","幼儿园","学前教育","017","09","05011301709",52,13,"第42候考室","第42考场","下午场","20501164244",72.33,16,26,36.17,62.17,{"$f":"IF(S20=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA20)*($T$3:$T$196>S20))+1)","v":18},""]
[{"$f":"IF(B21<>\"\",SUBTOTAL(3,$B$3:B21)+0,\"\")","v":19},"杨泓","榕江县","幼儿园","学前教育","008","19","05011300819",51,18,"第42候考室","第42考场","下午场","20501164248",71,18,25.5,35.5,61,{"$f":"IF(S21=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA21)*($T$3:$T$196>S21))+1)","v":19},""]
[{"$f":"IF(B22<>\"\",SUBTOTAL(3,$B$3:B22)+0,\"\")","v":20},"梁婷婷","榕江县","幼儿园","学前教育","011","09","05011301109",51.5,15,"第42候考室","第42考场","下午场","20501164247",69,20,25.75,34.5,60.25,{"$f":"IF(S22=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA22)*($T$3:$T$196>S22))+1)","v":20},""]
[{"$f":"IF(B23<>\"\",SUBTOTAL(3,$B$3:B23)+0,\"\")","v":21},"石媛媛","榕江县","幼儿园","学前教育","009","20","05011300920",51.5,15,"第42候考室","第42考场","下午场","20501164245",68.33,21,25.75,34.17,59.92,{"$f":"IF(S23=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA23)*($T$3:$T$196>S23))+1)","v":21},""]
[{"$f":"IF(B24<>\"\",SUBTOTAL(3,$B$3:B24)+0,\"\")","v":22},"张克慈","榕江县","幼儿园","学前教育","016","25","05011301625",50,21,"第42候考室","第42考场","下午场","20501164252",0,"",25,0,25,{"$f":"IF(S24=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA24)*($T$3:$T$196>S24))+1)","v":22},""]
[{"$f":"IF(B25<>\"\",SUBTOTAL(3,$B$3:B25)+0,\"\")","v":23},"李艳兰","榕江县","小学","语文","022","17","05020102217",76.5,1,"第03-1候考室","第03考场","上午场","10502010301",84,4,38.25,42,80.25,{"$f":"IF(S25=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA25)*($T$3:$T$196>S25))+1)","v":1},"入围体检"]
[{"$f":"IF(B26<>\"\",SUBTOTAL(3,$B$3:B26)+0,\"\")","v":24},"杨俨","榕江县","小学","语文","021","09","05020102109",76,2,"第03-1候考室","第03考场","上午场","10502010302",84.33,2,38,42.17,80.17,{"$f":"IF(S26=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA26)*($T$3:$T$196>S26))+1)","v":2},"入围体检"]
[{"$f":"IF(B27<>\"\",SUBTOTAL(3,$B$3:B27)+0,\"\")","v":25},"廖毓勤","榕江县","小学","语文","022","30","05020102230",73,6,"第03-1候考室","第03考场","上午场","10502010307",85,1,36.5,42.5,79,{"$f":"IF(S27=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA27)*($T$3:$T$196>S27))+1)","v":3},"入围体检"]
[{"$f":"IF(B28<>\"\",SUBTOTAL(3,$B$3:B28)+0,\"\")","v":26},"黄远利","榕江县","小学","语文","022","01","05020102201",74,4,"第03-1候考室","第03考场","上午场","10502010305",83.33,8,37,41.67,78.67,{"$f":"IF(S28=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA28)*($T$3:$T$196>S28))+1)","v":4},"入围体检"]
[{"$f":"IF(B29<>\"\",SUBTOTAL(3,$B$3:B29)+0,\"\")","v":27},"邰政菊","榕江县","小学","语文","023","07","05020102307",75.5,3,"第03-1候考室","第03考场","上午场","10502010303",80.33,37,37.75,40.17,77.92,{"$f":"IF(S29=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA29)*($T$3:$T$196>S29))+1)","v":5},"入围体检"]
[{"$f":"IF(B30<>\"\",SUBTOTAL(3,$B$3:B30)+0,\"\")","v":28},"杨正月","榕江县","小学","语文","024","22","05020102422",70,15,"第03-1候考室","第03考场","上午场","10502010318",84.33,2,35,42.17,77.17,{"$f":"IF(S30=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA30)*($T$3:$T$196>S30))+1)","v":6},"入围体检"]
[{"$f":"IF(B31<>\"\",SUBTOTAL(3,$B$3:B31)+0,\"\")","v":29},"莫孟兰","榕江县","小学","语文","021","18","05020102118",71,9,"第03-1候考室","第03考场","上午场","10502010311",82.67,15,35.5,41.34,76.84,{"$f":"IF(S31=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA31)*($T$3:$T$196>S31))+1)","v":7},"入围体检"]
[{"$f":"IF(B32<>\"\",SUBTOTAL(3,$B$3:B32)+0,\"\")","v":30},"吴松立","榕江县","小学","语文","021","15","05020102115",73,6,"第03-1候考室","第03考场","上午场","10502010306",80.33,37,36.5,40.17,76.67,{"$f":"IF(S32=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA32)*($T$3:$T$196>S32))+1)","v":8},"入围体检"]
[{"$f":"IF(B33<>\"\",SUBTOTAL(3,$B$3:B33)+0,\"\")","v":31},"吴姣姣","榕江县","小学","语文","019","16","05020101916",70,15,"第03-1候考室","第03考场","上午场","10502010315",83.33,8,35,41.67,76.67,{"$f":"IF(S33=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA33)*($T$3:$T$196>S33))+1)","v":8},"入围体检"]
[{"$f":"IF(B34<>\"\",SUBTOTAL(3,$B$3:B34)+0,\"\")","v":32},"潘巧祝","榕江县","小学","语文","020","24","05020102024",74,4,"第03-1候考室","第03考场","上午场","10502010304",79,57,37,39.5,76.5,{"$f":"IF(S34=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA34)*($T$3:$T$196>S34))+1)","v":10},"入围体检"]
[{"$f":"IF(B35<>\"\",SUBTOTAL(3,$B$3:B35)+0,\"\")","v":33},"李依芳","榕江县","小学","语文","024","29","05020102429",70.5,14,"第03-1候考室","第03考场","上午场","10502010314",82.33,18,35.25,41.17,76.42,{"$f":"IF(S35=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA35)*($T$3:$T$196>S35))+1)","v":11},"入围体检"]
[{"$f":"IF(B36<>\"\",SUBTOTAL(3,$B$3:B36)+0,\"\")","v":34},"吴艺婷","榕江县","小学","语文","019","10","05020101910",71,9,"第03-1候考室","第03考场","上午场","10502010309",81.67,25,35.5,40.84,76.34,{"$f":"IF(S36=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA36)*($T$3:$T$196>S36))+1)","v":12},"入围体检"]
[{"$f":"IF(B37<>\"\",SUBTOTAL(3,$B$3:B37)+0,\"\")","v":35},"文贤杰","榕江县","小学","语文","020","08","05020102008",69,22,"第03-1候考室","第03考场","上午场","10502010323",83,11,34.5,41.5,76,{"$f":"IF(S37=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA37)*($T$3:$T$196>S37))+1)","v":13},"入围体检"]
[{"$f":"IF(B38<>\"\",SUBTOTAL(3,$B$3:B38)+0,\"\")","v":36},"雍文乡","榕江县","小学","语文","019","13","05020101913",69.5,20,"第03-1候考室","第03考场","上午场","10502010320",82.33,18,34.75,41.17,75.92,{"$f":"IF(S38=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA38)*($T$3:$T$196>S38))+1)","v":14},"入围体检"]
[{"$f":"IF(B39<>\"\",SUBTOTAL(3,$B$3:B39)+0,\"\")","v":37},"刘世六","榕江县","小学","语文","019","01","05020101901",72,8,"第03-1候考室","第03考场","上午场","10502010308",79.67,48,36,39.84,75.84,{"$f":"IF(S39=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA39)*($T$3:$T$196>S39))+1)","v":15},"入围体检"]
[{"$f":"IF(B40<>\"\",SUBTOTAL(3,$B$3:B40)+0,\"\")","v":38},"付云佩","榕江县","小学","语文","020","07","05020102007",70,15,"第03-1候考室","第03考场","上午场","10502010316",81.67,25,35,40.84,75.84,{"$f":"IF(S40=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA40)*($T$3:$T$196>S40))+1)","v":15},"入围体检"]
[{"$f":"IF(B41<>\"\",SUBTOTAL(3,$B$3:B41)+0,\"\")","v":39},"杨通珍","榕江县","小学","语文","021","29","05020102129",68,24,"第03-1候考室","第03考场","上午场","10502010327",83,11,34,41.5,75.5,{"$f":"IF(S41=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA41)*($T$3:$T$196>S41))+1)","v":17},"入围体检"]
[{"$f":"IF(B42<>\"\",SUBTOTAL(3,$B$3:B42)+0,\"\")","v":40},"段丽晴","榕江县","小学","语文","019","30","05020101930",71,9,"第03-1候考室","第03考场","上午场","10502010310",79.67,48,35.5,39.84,75.34,{"$f":"IF(S42=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA42)*($T$3:$T$196>S42))+1)","v":18},"入围体检"]
[{"$f":"IF(B43<>\"\",SUBTOTAL(3,$B$3:B43)+0,\"\")","v":41},"文奇银","榕江县","小学","语文","021","20","05020102120",71,9,"第03-1候考室","第03考场","上午场","10502010312",79.67,48,35.5,39.84,75.34,{"$f":"IF(S43=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA43)*($T$3:$T$196>S43))+1)","v":18},"入围体检"]
[{"$f":"IF(B44<>\"\",SUBTOTAL(3,$B$3:B44)+0,\"\")","v":42},"龚学芳","榕江县","小学","语文","020","23","05020102023",67,33,"第03-1候考室","第03考场","上午场","10502010334",83.67,6,33.5,41.84,75.34,{"$f":"IF(S44=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA44)*($T$3:$T$196>S44))+1)","v":18},"入围体检"]
[{"$f":"IF(B45<>\"\",SUBTOTAL(3,$B$3:B45)+0,\"\")","v":43},"龙玉莲","榕江县","小学","语文","024","21","05020102421",67.5,31,"第03-1候考室","第03考场","上午场","10502010332",82.67,15,33.75,41.34,75.09,{"$f":"IF(S45=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA45)*($T$3:$T$196>S45))+1)","v":21},"入围体检"]
[{"$f":"IF(B46<>\"\",SUBTOTAL(3,$B$3:B46)+0,\"\")","v":44},"陆胜玲","榕江县","小学","语文","019","25","05020101925",69,22,"第03-1候考室","第03考场","上午场","10502010322",80.67,35,34.5,40.34,74.84,{"$f":"IF(S46=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA46)*($T$3:$T$196>S46))+1)","v":22},"入围体检"]
[{"$f":"IF(B47<>\"\",SUBTOTAL(3,$B$3:B47)+0,\"\")","v":45},"金荣月","榕江县","小学","语文","020","15","05020102015",68,24,"第03-1候考室","第03考场","上午场","10502010326",81.67,25,34,40.84,74.84,{"$f":"IF(S47=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA47)*($T$3:$T$196>S47))+1)","v":22},"入围体检"]
[{"$f":"IF(B48<>\"\",SUBTOTAL(3,$B$3:B48)+0,\"\")","v":46},"胡春梅","榕江县","小学","语文","025","06","05020102506",68,24,"第03-1候考室","第03考场","上午场","10502010330",81.67,25,34,40.84,74.84,{"$f":"IF(S48=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA48)*($T$3:$T$196>S48))+1)","v":22},"入围体检"]
[{"$f":"IF(B49<>\"\",SUBTOTAL(3,$B$3:B49)+0,\"\")","v":47},"杨文艳","榕江县","小学","语文","022","29","05020102229",69.5,20,"第03-1候考室","第03考场","上午场","10502010321",80,45,34.75,40,74.75,{"$f":"IF(S49=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA49)*($T$3:$T$196>S49))+1)","v":25},""]
[{"$f":"IF(B50<>\"\",SUBTOTAL(3,$B$3:B50)+0,\"\")","v":48},"李盼盼","榕江县","小学","语文","021","11","05020102111",65.5,41,"第03-2候考室","第03考场","上午场","10502010342",84,4,32.75,42,74.75,{"$f":"IF(S50=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA50)*($T$3:$T$196>S50))+1)","v":25},""]
[{"$f":"IF(B51<>\"\",SUBTOTAL(3,$B$3:B51)+0,\"\")","v":49},"吴青凤","榕江县","小学","语文","022","20","05020102220",70,15,"第03-1候考室","第03考场","上午场","10502010317",79.33,52,35,39.67,74.67,{"$f":"IF(S51=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA51)*($T$3:$T$196>S51))+1)","v":27},""]
[{"$f":"IF(B52<>\"\",SUBTOTAL(3,$B$3:B52)+0,\"\")","v":50},"黄钦滢","榕江县","小学","语文","023","20","05020102320",68,24,"第03-1候考室","第03考场","上午场","10502010329",81,31,34,40.5,74.5,{"$f":"IF(S52=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA52)*($T$3:$T$196>S52))+1)","v":28},""]
[{"$f":"IF(B53<>\"\",SUBTOTAL(3,$B$3:B53)+0,\"\")","v":51},"韦庭青","榕江县","小学","语文","019","07","05020101907",66.5,35,"第03-1候考室","第03考场","上午场","10502010335",82.33,18,33.25,41.17,74.42,{"$f":"IF(S53=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA53)*($T$3:$T$196>S53))+1)","v":29},""]
[{"$f":"IF(B54<>\"\",SUBTOTAL(3,$B$3:B54)+0,\"\")","v":52},"吴冬叶","榕江县","小学","语文","022","16","05020102216",66.5,35,"第03-1候考室","第03考场","上午场","10502010336",82,21,33.25,41,74.25,{"$f":"IF(S54=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA54)*($T$3:$T$196>S54))+1)","v":30},""]
[{"$f":"IF(B55<>\"\",SUBTOTAL(3,$B$3:B55)+0,\"\")","v":53},"杨通云","榕江县","小学","语文","020","13","05020102013",65.5,41,"第03-2候考室","第03考场","上午场","10502010341",83,11,32.75,41.5,74.25,{"$f":"IF(S55=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA55)*($T$3:$T$196>S55))+1)","v":30},""]
[{"$f":"IF(B56<>\"\",SUBTOTAL(3,$B$3:B56)+0,\"\")","v":54},"雷小英","榕江县","小学","语文","021","22","05020102122",71,9,"第03-1候考室","第03考场","上午场","10502010313",77.33,64,35.5,38.67,74.17,{"$f":"IF(S56=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA56)*($T$3:$T$196>S56))+1)","v":32},""]
[{"$f":"IF(B57<>\"\",SUBTOTAL(3,$B$3:B57)+0,\"\")","v":55},"潘亭杰","榕江县","小学","语文","019","24","05020101924",68,24,"第03-1候考室","第03考场","上午场","10502010324",80.33,37,34,40.17,74.17,{"$f":"IF(S57=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA57)*($T$3:$T$196>S57))+1)","v":32},""]
[{"$f":"IF(B58<>\"\",SUBTOTAL(3,$B$3:B58)+0,\"\")","v":56},"罗组敏","榕江县","小学","语文","020","21","05020102021",66,37,"第03-1候考室","第03考场","上午场","10502010337",82,21,33,41,74,{"$f":"IF(S58=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA58)*($T$3:$T$196>S58))+1)","v":34},""]
[{"$f":"IF(B59<>\"\",SUBTOTAL(3,$B$3:B59)+0,\"\")","v":57},"杨国艳","榕江县","小学","语文","022","24","05020102224",66,37,"第03-2候考室","第03考场","上午场","10502010339",81.67,25,33,40.84,73.84,{"$f":"IF(S59=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA59)*($T$3:$T$196>S59))+1)","v":35},""]
[{"$f":"IF(B60<>\"\",SUBTOTAL(3,$B$3:B60)+0,\"\")","v":58},"叶家春","榕江县","小学","语文","023","02","05020102302",65,46,"第03-2候考室","第03考场","上午场","10502010349",82.67,15,32.5,41.34,73.84,{"$f":"IF(S60=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA60)*($T$3:$T$196>S60))+1)","v":35},""]
[{"$f":"IF(B61<>\"\",SUBTOTAL(3,$B$3:B61)+0,\"\")","v":59},"朱天丝","榕江县","小学","语文","024","04","05020102404",67.5,31,"第03-1候考室","第03考场","上午场","10502010331",80,45,33.75,40,73.75,{"$f":"IF(S61=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA61)*($T$3:$T$196>S61))+1)","v":37},""]
[{"$f":"IF(B62<>\"\",SUBTOTAL(3,$B$3:B62)+0,\"\")","v":60},"杨园莉","榕江县","小学","语文","019","08","05020101908",64.5,50,"第03-2候考室","第03考场","上午场","10502010350",83,11,32.25,41.5,73.75,{"$f":"IF(S62=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA62)*($T$3:$T$196>S62))+1)","v":37},""]
[{"$f":"IF(B63<>\"\",SUBTOTAL(3,$B$3:B63)+0,\"\")","v":61},"黎芸","榕江县","小学","语文","019","19","05020101919",63.5,59,"第03-2候考室","第03考场","上午场","10502010359",83.33,8,31.75,41.67,73.42,{"$f":"IF(S63=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA63)*($T$3:$T$196>S63))+1)","v":39},""]
[{"$f":"IF(B64<>\"\",SUBTOTAL(3,$B$3:B64)+0,\"\")","v":62},"韦美丽","榕江县","小学","语文","020","14","05020102014",68,24,"第03-1候考室","第03考场","上午场","10502010325",78.67,59,34,39.34,73.34,{"$f":"IF(S64=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA64)*($T$3:$T$196>S64))+1)","v":40},""]
[{"$f":"IF(B65<>\"\",SUBTOTAL(3,$B$3:B65)+0,\"\")","v":63},"石倩","榕江县","小学","语文","019","02","05020101902",65,46,"第03-2候考室","第03考场","上午场","10502010346",81.67,25,32.5,40.84,73.34,{"$f":"IF(S65=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA65)*($T$3:$T$196>S65))+1)","v":40},""]
[{"$f":"IF(B66<>\"\",SUBTOTAL(3,$B$3:B66)+0,\"\")","v":64},"杨情缘","榕江县","小学","语文","021","30","05020102130",66,37,"第03-2候考室","第03考场","上午场","10502010338",80.33,37,33,40.17,73.17,{"$f":"IF(S66=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA66)*($T$3:$T$196>S66))+1)","v":42},""]
[{"$f":"IF(B67<>\"\",SUBTOTAL(3,$B$3:B67)+0,\"\")","v":65},"汪亚萍","榕江县","小学","语文","023","01","05020102301",66,37,"第03-2候考室","第03考场","上午场","10502010340",80.33,37,{"$f":"ROUND(I67*0.5,2)","v":33},{"$f":"ROUND(O67*0.5,2)","v":40.17},{"$f":"Q67+R67","v":73.17},{"$f":"IF(S67=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA67)*($T$3:$T$196>S67))+1)","v":42},""]
[{"$f":"IF(B68<>\"\",SUBTOTAL(3,$B$3:B68)+0,\"\")","v":66},"潘明星","榕江县","小学","语文","022","26","05020102226",65.5,41,"第03-2候考室","第03考场","上午场","10502010344",80.67,35,32.75,40.34,73.09,{"$f":"IF(S68=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA68)*($T$3:$T$196>S68))+1)","v":44},""]
[{"$f":"IF(B69<>\"\",SUBTOTAL(3,$B$3:B69)+0,\"\")","v":67},"王米票","榕江县","小学","语文","022","21","05020102221",62.5,69,"第03-2候考室","第03考场","上午场","10502010370",83.67,6,31.25,41.84,73.09,{"$f":"IF(S69=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA69)*($T$3:$T$196>S69))+1)","v":44},""]
[{"$f":"IF(B70<>\"\",SUBTOTAL(3,$B$3:B70)+0,\"\")","v":68},"张娟娟","榕江县","小学","语文","020","22","05020102022",65,46,"第03-2候考室","第03考场","上午场","10502010347",81,31,32.5,40.5,73,{"$f":"IF(S70=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA70)*($T$3:$T$196>S70))+1)","v":46},""]
[{"$f":"IF(B71<>\"\",SUBTOTAL(3,$B$3:B71)+0,\"\")","v":69},"余洋","榕江县","小学","语文","025","15","05020102515",70,15,"第03-1候考室","第03考场","上午场","10502010319",75.67,67,35,37.84,72.84,{"$f":"IF(S71=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA71)*($T$3:$T$196>S71))+1)","v":47},""]
[{"$f":"IF(B72<>\"\",SUBTOTAL(3,$B$3:B72)+0,\"\")","v":70},"王银银","榕江县","小学","语文","021","23","05020102123",63.5,59,"第03-2候考室","第03考场","上午场","10502010363",82,21,31.75,41,72.75,{"$f":"IF(S72=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA72)*($T$3:$T$196>S72))+1)","v":48},""]
[{"$f":"IF(B73<>\"\",SUBTOTAL(3,$B$3:B73)+0,\"\")","v":71},"王承美","榕江县","小学","语文","020","19","05020102019",67,33,"第03-1候考室","第03考场","上午场","10502010333",78,62,33.5,39,72.5,{"$f":"IF(S73=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA73)*($T$3:$T$196>S73))+1)","v":49},""]
[{"$f":"IF(B74<>\"\",SUBTOTAL(3,$B$3:B74)+0,\"\")","v":72},"潘世云","榕江县","小学","语文","021","26","05020102126",64,55,"第03-2候考室","第03考场","上午场","10502010357",81,31,32,40.5,72.5,{"$f":"IF(S74=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA74)*($T$3:$T$196>S74))+1)","v":49},""]
[{"$f":"IF(B75<>\"\",SUBTOTAL(3,$B$3:B75)+0,\"\")","v":73},"朱永琴","榕江县","小学","语文","019","03","05020101903",63,66,"第03-2候考室","第03考场","上午场","10502010366",82,21,31.5,41,72.5,{"$f":"IF(S75=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA75)*($T$3:$T$196>S75))+1)","v":49},""]
[{"$f":"IF(B76<>\"\",SUBTOTAL(3,$B$3:B76)+0,\"\")","v":74},"杨瑜荣","榕江县","小学","语文","022","03","05020102203",65.5,41,"第03-2候考室","第03考场","上午场","10502010343",79.33,52,32.75,39.67,72.42,{"$f":"IF(S76=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA76)*($T$3:$T$196>S76))+1)","v":52},""]
[{"$f":"IF(B77<>\"\",SUBTOTAL(3,$B$3:B77)+0,\"\")","v":75},"欧星星","榕江县","小学","语文","024","14","05020102414",65.5,41,"第03-2候考室","第03考场","上午场","10502010345",79.33,52,32.75,39.67,72.42,{"$f":"IF(S77=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA77)*($T$3:$T$196>S77))+1)","v":52},""]
[{"$f":"IF(B78<>\"\",SUBTOTAL(3,$B$3:B78)+0,\"\")","v":76},"高迅","榕江县","小学","语文","021","25","05020102125",64.5,50,"第03-2候考室","第03考场","上午场","10502010351",80.33,37,32.25,40.17,72.42,{"$f":"IF(S78=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA78)*($T$3:$T$196>S78))+1)","v":52},""]
[{"$f":"IF(B79<>\"\",SUBTOTAL(3,$B$3:B79)+0,\"\")","v":77},"李小艳","榕江县","小学","语文","024","16","05020102416",64.5,50,"第03-2候考室","第03考场","上午场","10502010354",80.33,37,32.25,40.17,72.42,{"$f":"IF(S79=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA79)*($T$3:$T$196>S79))+1)","v":52},""]
[{"$f":"IF(B80<>\"\",SUBTOTAL(3,$B$3:B80)+0,\"\")","v":78},"杨红连","榕江县","小学","语文","022","18","05020102218",63.5,59,"第03-2候考室","第03考场","上午场","10502010365",81,31,31.75,40.5,72.25,{"$f":"IF(S80=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA80)*($T$3:$T$196>S80))+1)","v":56},""]
[{"$f":"IF(B81<>\"\",SUBTOTAL(3,$B$3:B81)+0,\"\")","v":79},"文婧","榕江县","小学","语文","020","20","05020102020",63.5,59,"第03-2候考室","第03考场","上午场","10502010361",80.33,37,31.75,40.17,71.92,{"$f":"IF(S81=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA81)*($T$3:$T$196>S81))+1)","v":57},""]
[{"$f":"IF(B82<>\"\",SUBTOTAL(3,$B$3:B82)+0,\"\")","v":80},"杨正慧","榕江县","小学","语文","020","16","05020102016",63.5,59,"第03-2候考室","第03考场","上午场","10502010360",80,45,31.75,40,71.75,{"$f":"IF(S82=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA82)*($T$3:$T$196>S82))+1)","v":58},""]
[{"$f":"IF(B83<>\"\",SUBTOTAL(3,$B$3:B83)+0,\"\")","v":81},"杨柳","榕江县","小学","语文","019","20","05020101920",64,55,"第03-2候考室","第03考场","上午场","10502010355",79.33,52,32,39.67,71.67,{"$f":"IF(S83=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA83)*($T$3:$T$196>S83))+1)","v":59},""]
[{"$f":"IF(B84<>\"\",SUBTOTAL(3,$B$3:B84)+0,\"\")","v":82},"严家盼","榕江县","小学","语文","020","03","05020102003",64,55,"第03-2候考室","第03考场","上午场","10502010356",79.33,52,32,39.67,71.67,{"$f":"IF(S84=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA84)*($T$3:$T$196>S84))+1)","v":59},""]
[{"$f":"IF(B85<>\"\",SUBTOTAL(3,$B$3:B85)+0,\"\")","v":83},"何琴","榕江县","小学","语文","022","10","05020102210",68,24,"第03-1候考室","第03考场","上午场","10502010328",75,68,34,37.5,71.5,{"$f":"IF(S85=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA85)*($T$3:$T$196>S85))+1)","v":61},""]
[{"$f":"IF(B86<>\"\",SUBTOTAL(3,$B$3:B86)+0,\"\")","v":84},"岑应妮","榕江县","小学","语文","021","02","05020102102",63.5,59,"第03-2候考室","第03考场","上午场","10502010362",79,57,31.75,39.5,71.25,{"$f":"IF(S86=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA86)*($T$3:$T$196>S86))+1)","v":62},""]
[{"$f":"IF(B87<>\"\",SUBTOTAL(3,$B$3:B87)+0,\"\")","v":85},"彭婷","榕江县","小学","语文","022","11","05020102211",63.5,59,"第03-2候考室","第03考场","上午场","10502010364",78.67,59,31.75,39.34,71.09,{"$f":"IF(S87=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA87)*($T$3:$T$196>S87))+1)","v":63},""]
[{"$f":"IF(B88<>\"\",SUBTOTAL(3,$B$3:B88)+0,\"\")","v":86},"潘东丽","榕江县","小学","语文","022","07","05020102207",62.5,69,"第03-2候考室","第03考场","上午场","10502010369",79.67,48,31.25,39.84,71.09,{"$f":"IF(S88=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA88)*($T$3:$T$196>S88))+1)","v":63},""]
[{"$f":"IF(B89<>\"\",SUBTOTAL(3,$B$3:B89)+0,\"\")","v":87},"李茂菁","榕江县","小学","语文","024","12","05020102412",63,66,"第03-2候考室","第03考场","上午场","10502010367",78,62,31.5,39,70.5,{"$f":"IF(S89=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA89)*($T$3:$T$196>S89))+1)","v":65},""]
[{"$f":"IF(B90<>\"\",SUBTOTAL(3,$B$3:B90)+0,\"\")","v":88},"杨琼","榕江县","小学","语文","024","13","05020102413",64.5,50,"第03-2候考室","第03考场","上午场","10502010353",76.33,65,32.25,38.17,70.42,{"$f":"IF(S90=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA90)*($T$3:$T$196>S90))+1)","v":66},""]
[{"$f":"IF(B91<>\"\",SUBTOTAL(3,$B$3:B91)+0,\"\")","v":89},"李红兰","榕江县","小学","语文","019","26","05020101926",62,72,"第03-2候考室","第03考场","上午场","10502010372",78.33,61,31,39.17,70.17,{"$f":"IF(S91=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA91)*($T$3:$T$196>S91))+1)","v":67},""]
[{"$f":"IF(B92<>\"\",SUBTOTAL(3,$B$3:B92)+0,\"\")","v":90},"廖青梅","榕江县","小学","语文","024","19","05020102419",63,66,"第03-2候考室","第03考场","上午场","10502010368",76,66,31.5,38,69.5,{"$f":"IF(S92=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA92)*($T$3:$T$196>S92))+1)","v":68},""]
[{"$f":"IF(B93<>\"\",SUBTOTAL(3,$B$3:B93)+0,\"\")","v":91},"杨秋菊","榕江县","小学","语文","022","02","05020102202",65,46,"第03-2候考室","第03考场","上午场","10502010348",0,"",32.5,0,32.5,{"$f":"IF(S93=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA93)*($T$3:$T$196>S93))+1)","v":69},""]
[{"$f":"IF(B94<>\"\",SUBTOTAL(3,$B$3:B94)+0,\"\")","v":92},"张传秀","榕江县","小学","语文","023","11","05020102311",64.5,50,"第03-2候考室","第03考场","上午场","10502010352",0,"",32.25,0,32.25,{"$f":"IF(S94=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA94)*($T$3:$T$196>S94))+1)","v":70},""]
[{"$f":"IF(B95<>\"\",SUBTOTAL(3,$B$3:B95)+0,\"\")","v":93},"徐国云","榕江县","小学","语文","023","05","05020102305",64,55,"第03-2候考室","第03考场","上午场","10502010358",0,"",32,0,32,{"$f":"IF(S95=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA95)*($T$3:$T$196>S95))+1)","v":71},""]
[{"$f":"IF(B96<>\"\",SUBTOTAL(3,$B$3:B96)+0,\"\")","v":94},"吴思叶","榕江县","小学","语文","025","04","05020102504",62.5,69,"第03-2候考室","第03考场","上午场","10502010371",0,"",31.25,0,31.25,{"$f":"IF(S96=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA96)*($T$3:$T$196>S96))+1)","v":72},""]
[{"$f":"IF(B97<>\"\",SUBTOTAL(3,$B$3:B97)+0,\"\")","v":95},"龙虑伊","榕江县","小学","语文","023","19","05020102319",62,72,"第03-2候考室","第03考场","上午场","10502010373",0,"",31,0,31,{"$f":"IF(S97=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA97)*($T$3:$T$196>S97))+1)","v":73},""]
[{"$f":"IF(B98<>\"\",SUBTOTAL(3,$B$3:B98)+0,\"\")","v":96},"杨贵蓝","榕江县","小学","数学","004","15","05020200415",79.5,1,"第13候考室","第13考场","上午场","10502021301",91,12,39.75,45.5,85.25,{"$f":"IF(S98=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA98)*($T$3:$T$196>S98))+1)","v":1},"入围体检"]
[{"$f":"IF(B99<>\"\",SUBTOTAL(3,$B$3:B99)+0,\"\")","v":97},"潘家俊","榕江县","小学","数学","002","01","05020200201",76,3,"第13候考室","第13考场","上午场","10502021303",94,4,38,47,85,{"$f":"IF(S99=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA99)*($T$3:$T$196>S99))+1)","v":2},"入围体检"]
[{"$f":"IF(B100<>\"\",SUBTOTAL(3,$B$3:B100)+0,\"\")","v":98},"刘桥红","榕江县","小学","数学","002","07","05020200207",73.5,5,"第13候考室","第13考场","上午场","10502021306",95,1,36.75,47.5,84.25,{"$f":"IF(S100=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA100)*($T$3:$T$196>S100))+1)","v":3},"入围体检"]
[{"$f":"IF(B101<>\"\",SUBTOTAL(3,$B$3:B101)+0,\"\")","v":99},"杨银艳","榕江县","小学","数学","002","16","05020200216",78,2,"第13候考室","第13考场","上午场","10502021302",88,29,39,44,83,{"$f":"IF(S101=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA101)*($T$3:$T$196>S101))+1)","v":4},"入围体检"]
[{"$f":"IF(B102<>\"\",SUBTOTAL(3,$B$3:B102)+0,\"\")","v":100},"罗化宣","榕江县","小学","数学","002","05","05020200205",72.5,7,"第13候考室","第13考场","上午场","10502021307",92,7,36.25,46,82.25,{"$f":"IF(S102=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA102)*($T$3:$T$196>S102))+1)","v":5},"入围体检"]
[{"$f":"IF(B103<>\"\",SUBTOTAL(3,$B$3:B103)+0,\"\")","v":101},"李佐梅","榕江县","小学","数学","002","09","05020200209",74,4,"第13候考室","第13考场","上午场","10502021304",90.33,17,37,45.17,82.17,{"$f":"IF(S103=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA103)*($T$3:$T$196>S103))+1)","v":6},"入围体检"]
[{"$f":"IF(B104<>\"\",SUBTOTAL(3,$B$3:B104)+0,\"\")","v":102},"杨丽","榕江县","小学","数学","002","06","05020200206",73.5,5,"第13候考室","第13考场","上午场","10502021305",89.67,19,36.75,44.84,81.59,{"$f":"IF(S104=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA104)*($T$3:$T$196>S104))+1)","v":7},"入围体检"]
[{"$f":"IF(B105<>\"\",SUBTOTAL(3,$B$3:B105)+0,\"\")","v":103},"施坪","榕江县","小学","数学","003","16","05020200316",72.5,7,"第13候考室","第13考场","上午场","10502021308",90.67,13,36.25,45.34,81.59,{"$f":"IF(S105=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA105)*($T$3:$T$196>S105))+1)","v":7},"入围体检"]
[{"$f":"IF(B106<>\"\",SUBTOTAL(3,$B$3:B106)+0,\"\")","v":104},"龙银桃","榕江县","小学","数学","004","12","05020200412",68.5,11,"第13候考室","第13考场","上午场","10502021311",92.33,6,34.25,46.17,80.42,{"$f":"IF(S106=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA106)*($T$3:$T$196>S106))+1)","v":9},"入围体检"]
[{"$f":"IF(B107<>\"\",SUBTOTAL(3,$B$3:B107)+0,\"\")","v":105},"王婷婷","榕江县","小学","数学","003","08","05020200308",72,9,"第13候考室","第13考场","上午场","10502021309",88.33,26,36,44.17,80.17,{"$f":"IF(S107=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA107)*($T$3:$T$196>S107))+1)","v":10},"入围体检"]
[{"$f":"IF(B108<>\"\",SUBTOTAL(3,$B$3:B108)+0,\"\")","v":106},"吴兴威","榕江县","小学","数学","003","15","05020200315",72,9,"第13候考室","第13考场","上午场","10502021310",86.67,32,36,43.34,79.34,{"$f":"IF(S108=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA108)*($T$3:$T$196>S108))+1)","v":11},"入围体检"]
[{"$f":"IF(B109<>\"\",SUBTOTAL(3,$B$3:B109)+0,\"\")","v":107},"张炼琳","榕江县","小学","数学","003","25","05020200325",62.5,12,"第13候考室","第13考场","上午场","10502021312",95,1,31.25,47.5,78.75,{"$f":"IF(S109=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA109)*($T$3:$T$196>S109))+1)","v":12},"入围体检"]
[{"$f":"IF(B110<>\"\",SUBTOTAL(3,$B$3:B110)+0,\"\")","v":108},"简荣婷","榕江县","小学","数学","003","29","05020200329",58,17,"第13候考室","第13考场","上午场","10502021317",94.33,3,29,47.17,76.17,{"$f":"IF(S110=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA110)*($T$3:$T$196>S110))+1)","v":13},"入围体检"]
[{"$f":"IF(B111<>\"\",SUBTOTAL(3,$B$3:B111)+0,\"\")","v":109},"杨绍排","榕江县","小学","数学","002","20","05020200220",62,13,"第13候考室","第13考场","上午场","10502021313",89,23,31,44.5,75.5,{"$f":"IF(S111=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA111)*($T$3:$T$196>S111))+1)","v":14},"入围体检"]
[{"$f":"IF(B112<>\"\",SUBTOTAL(3,$B$3:B112)+0,\"\")","v":110},"彭佳蝶","榕江县","小学","数学","004","09","05020200409",61,14,"第13候考室","第13考场","上午场","10502021314",88.33,26,30.5,44.17,74.67,{"$f":"IF(S112=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA112)*($T$3:$T$196>S112))+1)","v":15},"入围体检"]
[{"$f":"IF(B113<>\"\",SUBTOTAL(3,$B$3:B113)+0,\"\")","v":111},"马爱林","榕江县","小学","数学","003","09","05020200309",60,15,"第13候考室","第13考场","上午场","10502021315",87,31,30,43.5,73.5,{"$f":"IF(S113=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA113)*($T$3:$T$196>S113))+1)","v":16},"入围体检"]
[{"$f":"IF(B114<>\"\",SUBTOTAL(3,$B$3:B114)+0,\"\")","v":112},"陆金芝","榕江县","小学","数学","002","14","05020200214",58.5,16,"第13候考室","第13考场","上午场","10502021316",86.33,34,29.25,43.17,72.42,{"$f":"IF(S114=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA114)*($T$3:$T$196>S114))+1)","v":17},"入围体检"]
[{"$f":"IF(B115<>\"\",SUBTOTAL(3,$B$3:B115)+0,\"\")","v":113},"杨成功","榕江县","小学","数学","002","03","05020200203",56,19,"第13候考室","第13考场","上午场","10502021319",88.33,26,28,44.17,72.17,{"$f":"IF(S115=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA115)*($T$3:$T$196>S115))+1)","v":18},"入围体检"]
[{"$f":"IF(B116<>\"\",SUBTOTAL(3,$B$3:B116)+0,\"\")","v":114},"吴林海","榕江县","小学","数学","002","21","05020200221",56.5,18,"第13候考室","第13考场","上午场","10502021318",87.33,30,28.25,43.67,71.92,{"$f":"IF(S116=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA116)*($T$3:$T$196>S116))+1)","v":19},"入围体检"]
[{"$f":"IF(B117<>\"\",SUBTOTAL(3,$B$3:B117)+0,\"\")","v":115},"吴丽花","榕江县","小学","数学","003","24","05020200324",50.5,22,"第13候考室","第13考场","上午场","10502021323",91.33,10,25.25,45.67,70.92,{"$f":"IF(S117=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA117)*($T$3:$T$196>S117))+1)","v":20},"入围体检"]
[{"$f":"IF(B118<>\"\",SUBTOTAL(3,$B$3:B118)+0,\"\")","v":116},"王大芬","榕江县","小学","数学","003","06","05020200306",48.5,25,"第13候考室","第13考场","上午场","10502021325",93,5,24.25,46.5,70.75,{"$f":"IF(S118=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA118)*($T$3:$T$196>S118))+1)","v":21},""]
[{"$f":"IF(B119<>\"\",SUBTOTAL(3,$B$3:B119)+0,\"\")","v":117},"王兴金","榕江县","小学","数学","003","02","05020200302",54.5,20,"第13候考室","第13考场","上午场","10502021320",83.67,38,27.25,41.84,69.09,{"$f":"IF(S119=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA119)*($T$3:$T$196>S119))+1)","v":22},""]
[{"$f":"IF(B120<>\"\",SUBTOTAL(3,$B$3:B120)+0,\"\")","v":118},"石秀红","榕江县","小学","数学","004","08","05020200408",47,27,"第13候考室","第13考场","上午场","10502021327",89.67,19,23.5,44.84,68.34,{"$f":"IF(S120=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA120)*($T$3:$T$196>S120))+1)","v":23},""]
[{"$f":"IF(B121<>\"\",SUBTOTAL(3,$B$3:B121)+0,\"\")","v":119},"杨永兰","榕江县","小学","数学","002","19","05020200219",43.5,30,"第13候考室","第13考场","上午场","10502021330",91.67,9,21.75,45.84,67.59,{"$f":"IF(S121=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA121)*($T$3:$T$196>S121))+1)","v":24},""]
[{"$f":"IF(B122<>\"\",SUBTOTAL(3,$B$3:B122)+0,\"\")","v":120},"杨再云","榕江县","小学","数学","002","04","05020200204",52,21,"第13候考室","第13考场","上午场","10502021321",83,39,26,41.5,67.5,{"$f":"IF(S122=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA122)*($T$3:$T$196>S122))+1)","v":25},""]
[{"$f":"IF(B123<>\"\",SUBTOTAL(3,$B$3:B123)+0,\"\")","v":121},"陈诗","榕江县","小学","数学","003","01","05020200301",43,32,"第13候考室","第13考场","上午场","10502021332",92,7,21.5,46,67.5,{"$f":"IF(S123=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA123)*($T$3:$T$196>S123))+1)","v":25},""]
[{"$f":"IF(B124<>\"\",SUBTOTAL(3,$B$3:B124)+0,\"\")","v":122},"陈娟美","榕江县","小学","数学","004","03","05020200403",43.5,30,"第13候考室","第13考场","上午场","10502021331",90.33,17,21.75,45.17,66.92,{"$f":"IF(S124=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA124)*($T$3:$T$196>S124))+1)","v":27},""]
[{"$f":"IF(B125<>\"\",SUBTOTAL(3,$B$3:B125)+0,\"\")","v":123},"杨兰艳","榕江县","小学","数学","002","28","05020200228",50.5,22,"第13候考室","第13考场","上午场","10502021322",82.33,40,25.25,41.17,66.42,{"$f":"IF(S125=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA125)*($T$3:$T$196>S125))+1)","v":28},""]
[{"$f":"IF(B126<>\"\",SUBTOTAL(3,$B$3:B126)+0,\"\")","v":124},"李开燕","榕江县","小学","数学","002","22","05020200222",40.5,34,"第13候考室","第13考场","上午场","10502021334",90.67,13,20.25,45.34,65.59,{"$f":"IF(S126=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA126)*($T$3:$T$196>S126))+1)","v":29},""]
[{"$f":"IF(B127<>\"\",SUBTOTAL(3,$B$3:B127)+0,\"\")","v":125},"王文东","榕江县","小学","数学","004","10","05020200410",44,29,"第13候考室","第13考场","上午场","10502021329",85.33,36,22,42.67,64.67,{"$f":"IF(S127=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA127)*($T$3:$T$196>S127))+1)","v":30},""]
[{"$f":"IF(B128<>\"\",SUBTOTAL(3,$B$3:B128)+0,\"\")","v":126},"杨秀蓝","榕江县","小学","数学","004","16","05020200416",40.5,34,"第13候考室","第13考场","上午场","10502021335",88.67,25,20.25,44.34,64.59,{"$f":"IF(S128=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA128)*($T$3:$T$196>S128))+1)","v":31},""]
[{"$f":"IF(B129<>\"\",SUBTOTAL(3,$B$3:B129)+0,\"\")","v":127},"熊欢欢","榕江县","小学","数学","003","17","05020200317",36,42,"第13候考室","第13考场","上午场","10502021342",91.33,10,18,45.67,63.67,{"$f":"IF(S129=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA129)*($T$3:$T$196>S129))+1)","v":32},""]
[{"$f":"IF(B130<>\"\",SUBTOTAL(3,$B$3:B130)+0,\"\")","v":128},"宋德玉","榕江县","小学","数学","003","27","05020200327",36,42,"第13候考室","第13考场","上午场","10502021343",90.67,13,18,45.34,63.34,{"$f":"IF(S130=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA130)*($T$3:$T$196>S130))+1)","v":33},""]
[{"$f":"IF(B131<>\"\",SUBTOTAL(3,$B$3:B131)+0,\"\")","v":129},"杨昌珠","榕江县","小学","数学","004","13","05020200413",37.5,38,"第13候考室","第13考场","上午场","10502021339",89,23,{"$f":"ROUND(I131*0.5,2)","v":18.75},{"$f":"ROUND(O131*0.5,2)","v":44.5},{"$f":"Q131+R131","v":63.25},{"$f":"IF(S131=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA131)*($T$3:$T$196>S131))+1)","v":34},""]
[{"$f":"IF(B132<>\"\",SUBTOTAL(3,$B$3:B132)+0,\"\")","v":130},"杨秋凤","榕江县","小学","数学","002","29","05020200229",36.5,40,"第13候考室","第13考场","上午场","10502021340",89.67,19,18.25,44.84,63.09,{"$f":"IF(S132=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA132)*($T$3:$T$196>S132))+1)","v":35},""]
[{"$f":"IF(B133<>\"\",SUBTOTAL(3,$B$3:B133)+0,\"\")","v":131},"赵胜毅","榕江县","小学","数学","003","20","05020200320",37.5,38,"第13候考室","第13考场","上午场","10502021338",85.33,36,18.75,42.67,61.42,{"$f":"IF(S133=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA133)*($T$3:$T$196>S133))+1)","v":36},""]
[{"$f":"IF(B134<>\"\",SUBTOTAL(3,$B$3:B134)+0,\"\")","v":132},"杨秀雪","榕江县","小学","数学","003","26","05020200326",32.5,45,"第13候考室","第13考场","上午场","10502021345",89.67,19,16.25,44.84,61.09,{"$f":"IF(S134=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA134)*($T$3:$T$196>S134))+1)","v":37},""]
[{"$f":"IF(B135<>\"\",SUBTOTAL(3,$B$3:B135)+0,\"\")","v":133},"王银先","榕江县","小学","数学","004","05","05020200405",39,37,"第13候考室","第13考场","上午场","10502021337",82.33,40,19.5,41.17,60.67,{"$f":"IF(S135=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA135)*($T$3:$T$196>S135))+1)","v":38},""]
[{"$f":"IF(B136<>\"\",SUBTOTAL(3,$B$3:B136)+0,\"\")","v":134},"蒙誉斐","榕江县","小学","数学","003","28","05020200328",35.5,44,"第13候考室","第13考场","上午场","10502021344",85.67,35,17.75,42.84,60.59,{"$f":"IF(S136=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA136)*($T$3:$T$196>S136))+1)","v":39},""]
[{"$f":"IF(B137<>\"\",SUBTOTAL(3,$B$3:B137)+0,\"\")","v":135},"周丽娟","榕江县","小学","数学","003","11","05020200311",40,36,"第13候考室","第13考场","上午场","10502021336",81,42,20,40.5,60.5,{"$f":"IF(S137=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA137)*($T$3:$T$196>S137))+1)","v":40},""]
[{"$f":"IF(B138<>\"\",SUBTOTAL(3,$B$3:B138)+0,\"\")","v":136},"白从微","榕江县","小学","数学","002","11","05020200211",41,33,"第13候考室","第13考场","上午场","10502021333",79.67,43,20.5,39.84,60.34,{"$f":"IF(S138=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA138)*($T$3:$T$196>S138))+1)","v":41},""]
[{"$f":"IF(B139<>\"\",SUBTOTAL(3,$B$3:B139)+0,\"\")","v":137},"王珍","榕江县","小学","数学","002","02","05020200202",29.5,49,"第13候考室","第13考场","上午场","10502021349",90.67,13,14.75,45.34,60.09,{"$f":"IF(S139=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA139)*($T$3:$T$196>S139))+1)","v":42},""]
[{"$f":"IF(B140<>\"\",SUBTOTAL(3,$B$3:B140)+0,\"\")","v":138},"伍艳","榕江县","小学","数学","002","08","05020200208",32,46,"第13候考室","第13考场","上午场","10502021346",86.67,32,16,43.34,59.34,{"$f":"IF(S140=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA140)*($T$3:$T$196>S140))+1)","v":43},""]
[{"$f":"IF(B141<>\"\",SUBTOTAL(3,$B$3:B141)+0,\"\")","v":139},"舒超","榕江县","小学","数学","002","15","05020200215",49.5,24,"第13候考室","第13考场","上午场","10502021324",0,"",24.75,0,24.75,{"$f":"IF(S141=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA141)*($T$3:$T$196>S141))+1)","v":44},""]
[{"$f":"IF(B142<>\"\",SUBTOTAL(3,$B$3:B142)+0,\"\")","v":140},"张小丹","榕江县","小学","数学","002","26","05020200226",48,26,"第13候考室","第13考场","上午场","10502021326",0,"",24,0,24,{"$f":"IF(S142=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA142)*($T$3:$T$196>S142))+1)","v":45},""]
[{"$f":"IF(B143<>\"\",SUBTOTAL(3,$B$3:B143)+0,\"\")","v":141},"刘成艳","榕江县","小学","数学","002","17","05020200217",46.5,28,"第13候考室","第13考场","上午场","10502021328",0,"",23.25,0,23.25,{"$f":"IF(S143=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA143)*($T$3:$T$196>S143))+1)","v":46},""]
[{"$f":"IF(B144<>\"\",SUBTOTAL(3,$B$3:B144)+0,\"\")","v":142},"杨菊花","榕江县","小学","数学","004","04","05020200404",36.5,40,"第13候考室","第13考场","上午场","10502021341",0,"",18.25,0,18.25,{"$f":"IF(S144=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA144)*($T$3:$T$196>S144))+1)","v":47},""]
[{"$f":"IF(B145<>\"\",SUBTOTAL(3,$B$3:B145)+0,\"\")","v":143},"王小英","榕江县","小学","数学","002","13","05020200213",32,46,"第13候考室","第13考场","上午场","10502021347",0,"",16,0,16,{"$f":"IF(S145=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA145)*($T$3:$T$196>S145))+1)","v":48},""]
[{"$f":"IF(B146<>\"\",SUBTOTAL(3,$B$3:B146)+0,\"\")","v":144},"韦清利","榕江县","小学","数学","004","06","05020200406",32,46,"第13候考室","第13考场","上午场","10502021348",0,"",16,0,16,{"$f":"IF(S146=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA146)*($T$3:$T$196>S146))+1)","v":48},""]
[{"$f":"IF(B147<>\"\",SUBTOTAL(3,$B$3:B147)+0,\"\")","v":145},"孙国","榕江县","小学","数学","003","05","05020200305",29.5,49,"第13候考室","第13考场","上午场","10502021350",0,"",14.75,0,14.75,{"$f":"IF(S147=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA147)*($T$3:$T$196>S147))+1)","v":50},""]
[{"$f":"IF(B148<>\"\",SUBTOTAL(3,$B$3:B148)+0,\"\")","v":146},"龙安燕","榕江县","小学","数学","003","21","05020200321",29,51,"第13候考室","第13考场","上午场","10502021351",0,"",14.5,0,14.5,{"$f":"IF(S148=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA148)*($T$3:$T$196>S148))+1)","v":51},""]
[{"$f":"IF(B149<>\"\",SUBTOTAL(3,$B$3:B149)+0,\"\")","v":147},"金源烽","榕江县","小学","数学","003","03","05020200303",28.5,52,"第13候考室","第13考场","上午场","10502021352",0,"",14.25,0,14.25,{"$f":"IF(S149=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA149)*($T$3:$T$196>S149))+1)","v":52},""]
[{"$f":"IF(B150<>\"\",SUBTOTAL(3,$B$3:B150)+0,\"\")","v":148},"李莎","榕江县","小学","数学","003","18","05020200318",28.5,52,"第13候考室","第13考场","上午场","10502021353",0,"",14.25,0,14.25,{"$f":"IF(S150=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA150)*($T$3:$T$196>S150))+1)","v":52},""]
[{"$f":"IF(B151<>\"\",SUBTOTAL(3,$B$3:B151)+0,\"\")","v":149},"吴金梅","榕江县","小学","数学","004","18","05020200418",28.5,52,"第13候考室","第13考场","上午场","10502021354",0,"",14.25,0,14.25,{"$f":"IF(S151=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA151)*($T$3:$T$196>S151))+1)","v":52},""]
[{"$f":"IF(B152<>\"\",SUBTOTAL(3,$B$3:B152)+0,\"\")","v":150},"何超令","榕江县","小学","数学","003","10","05020200310",28,55,"第13候考室","第13考场","上午场","10502021355",0,"",14,0,14,{"$f":"IF(S152=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA152)*($T$3:$T$196>S152))+1)","v":55},""]
[{"$f":"IF(B153<>\"\",SUBTOTAL(3,$B$3:B153)+0,\"\")","v":151},"李成美","榕江县","小学","数学","004","01","05020200401",26.5,56,"第13候考室","第13考场","上午场","10502021356",0,"",13.25,0,13.25,{"$f":"IF(S153=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA153)*($T$3:$T$196>S153))+1)","v":56},""]
[{"$f":"IF(B154<>\"\",SUBTOTAL(3,$B$3:B154)+0,\"\")","v":152},"龙彦余","榕江县","小学","数学","002","12","05020200212",26,57,"第13候考室","第13考场","上午场","10502021357",0,"",13,0,13,{"$f":"IF(S154=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA154)*($T$3:$T$196>S154))+1)","v":57},""]
[{"$f":"IF(B155<>\"\",SUBTOTAL(3,$B$3:B155)+0,\"\")","v":153},"蒋青龙","榕江县","小学","数学","004","02","05020200402",26,57,"第13候考室","第13考场","上午场","10502021358",0,"",13,0,13,{"$f":"IF(S155=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA155)*($T$3:$T$196>S155))+1)","v":57},""]
[{"$f":"IF(B156<>\"\",SUBTOTAL(3,$B$3:B156)+0,\"\")","v":154},"潘德智","榕江县","小学","数学","004","19","05020200419",26,57,"第13候考室","第13考场","上午场","10502021359",0,"",13,0,13,{"$f":"IF(S156=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA156)*($T$3:$T$196>S156))+1)","v":57},""]
[{"$f":"IF(B157<>\"\",SUBTOTAL(3,$B$3:B157)+0,\"\")","v":155},"杨武芝","榕江县","小学","数学","003","04","05020200304",25,60,"第13候考室","第13考场","上午场","10502021360",0,"",12.5,0,12.5,{"$f":"IF(S157=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA157)*($T$3:$T$196>S157))+1)","v":60},""]
[{"$f":"IF(B158<>\"\",SUBTOTAL(3,$B$3:B158)+0,\"\")","v":156},"杨瑜霞","榕江县","小学","英语","006","16","05020300616",76,2,"第20候考室","第20考场","下午场","20502032053",89.67,2,38,44.84,82.84,{"$f":"IF(S158=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA158)*($T$3:$T$196>S158))+1)","v":1},"入围体检"]
[{"$f":"IF(B159<>\"\",SUBTOTAL(3,$B$3:B159)+0,\"\")","v":157},"杨宁","榕江县","小学","英语","006","04","05020300604",78.5,1,"第20候考室","第20考场","下午场","20502032052",85.33,7,39.25,42.67,81.92,{"$f":"IF(S159=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA159)*($T$3:$T$196>S159))+1)","v":2},"入围体检"]
[{"$f":"IF(B160<>\"\",SUBTOTAL(3,$B$3:B160)+0,\"\")","v":158},"唐建建","榕江县","小学","英语","006","03","05020300603",71,5,"第20候考室","第20考场","下午场","20502032056",90.67,1,35.5,45.34,80.84,{"$f":"IF(S160=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA160)*($T$3:$T$196>S160))+1)","v":3},"入围体检"]
[{"$f":"IF(B161<>\"\",SUBTOTAL(3,$B$3:B161)+0,\"\")","v":159},"潘维维","榕江县","小学","英语","006","15","05020300615",70.5,6,"第20候考室","第20考场","下午场","20502032057",89.67,2,35.25,44.84,80.09,{"$f":"IF(S161=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA161)*($T$3:$T$196>S161))+1)","v":4},"入围体检"]
[{"$f":"IF(B162<>\"\",SUBTOTAL(3,$B$3:B162)+0,\"\")","v":160},"杨珍艳","榕江县","小学","英语","006","11","05020300611",74,3,"第20候考室","第20考场","下午场","20502032054",85.67,6,37,42.84,79.84,{"$f":"IF(S162=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA162)*($T$3:$T$196>S162))+1)","v":5},""]
[{"$f":"IF(B163<>\"\",SUBTOTAL(3,$B$3:B163)+0,\"\")","v":161},"宁家惠","榕江县","小学","英语","006","12","05020300612",67,8,"第20候考室","第20考场","下午场","20502032059",88.67,4,33.5,44.34,77.84,{"$f":"IF(S163=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA163)*($T$3:$T$196>S163))+1)","v":6},""]
[{"$f":"IF(B164<>\"\",SUBTOTAL(3,$B$3:B164)+0,\"\")","v":162},"姚晴","榕江县","小学","英语","006","01","05020300601",72,4,"第20候考室","第20考场","下午场","20502032055",82,9,36,41,77,{"$f":"IF(S164=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA164)*($T$3:$T$196>S164))+1)","v":7},""]
[{"$f":"IF(B165<>\"\",SUBTOTAL(3,$B$3:B165)+0,\"\")","v":163},"刘灿宇","榕江县","小学","英语","006","18","05020300618",67,8,"第20候考室","第20考场","下午场","20502032060",86.67,5,33.5,43.34,76.84,{"$f":"IF(S165=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA165)*($T$3:$T$196>S165))+1)","v":8},""]
[{"$f":"IF(B166<>\"\",SUBTOTAL(3,$B$3:B166)+0,\"\")","v":164},"杨盼妮","榕江县","小学","英语","006","10","05020300610",68.5,7,"第20候考室","第20考场","下午场","20502032058",82.67,8,34.25,41.34,75.59,{"$f":"IF(S166=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA166)*($T$3:$T$196>S166))+1)","v":9},""]
[{"$f":"IF(B167<>\"\",SUBTOTAL(3,$B$3:B167)+0,\"\")","v":165},"杨圆霞","榕江县","小学","英语","006","02","05020300602",63,11,"第20候考室","第20考场","下午场","20502032062",33.33,10,31.5,16.67,48.17,{"$f":"IF(S167=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA167)*($T$3:$T$196>S167))+1)","v":10},""]
[{"$f":"IF(B168<>\"\",SUBTOTAL(3,$B$3:B168)+0,\"\")","v":166},"李珏","榕江县","小学","英语","006","05","05020300605",63.5,10,"第20候考室","第20考场","下午场","20502032061",0,"",31.75,0,31.75,{"$f":"IF(S168=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA168)*($T$3:$T$196>S168))+1)","v":11},""]
[{"$f":"IF(B169<>\"\",SUBTOTAL(3,$B$3:B169)+0,\"\")","v":167},"吴丽琴","榕江县","小学","英语","006","23","05020300623",63,11,"第20候考室","第20考场","下午场","20502032063",0,"",31.5,0,31.5,{"$f":"IF(S169=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA169)*($T$3:$T$196>S169))+1)","v":12},""]
[{"$f":"IF(B170<>\"\",SUBTOTAL(3,$B$3:B170)+0,\"\")","v":168},"杨大跃","榕江县","小学","政治","025","29","05020902529",62,1,"第28候考室","第28考场","上午场","10502092801",79.33,1,31,39.67,70.67,{"$f":"IF(S170=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA170)*($T$3:$T$196>S170))+1)","v":1},"入围体检"]
[{"$f":"IF(B171<>\"\",SUBTOTAL(3,$B$3:B171)+0,\"\")","v":169},"石珍远","榕江县","小学","信息技术","001","03","05020200103",33,1,"第38候考室","第38考场","上午场","10502133813",82.33,1,16.5,41.17,57.67,{"$f":"IF(S171=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA171)*($T$3:$T$196>S171))+1)","v":1},"入围体检"]
[{"$f":"IF(B172<>\"\",SUBTOTAL(3,$B$3:B172)+0,\"\")","v":170},"韩梅","榕江县","小学","信息技术","001","01","05020200101",28,2,"第38候考室","第38考场","上午场","10502133814",80,2,14,40,54,{"$f":"IF(S172=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA172)*($T$3:$T$196>S172))+1)","v":2},""]
[{"$f":"IF(B173<>\"\",SUBTOTAL(3,$B$3:B173)+0,\"\")","v":171},"张吉荣","榕江县","小学","信息技术","001","04","05020200104",25,3,"第38候考室","第38考场","上午场","10502133815",79.33,3,12.5,39.67,52.17,{"$f":"IF(S173=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA173)*($T$3:$T$196>S173))+1)","v":3},""]
[{"$f":"IF(B174<>\"\",SUBTOTAL(3,$B$3:B174)+0,\"\")","v":172},"龙春玲","榕江县","小学","科学","001","12","05020200112",63,2,"第39候考室","第39考场","上午场","10502143923",88.33,1,31.5,44.17,75.67,{"$f":"IF(S174=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA174)*($T$3:$T$196>S174))+1)","v":1},"入围体检"]
[{"$f":"IF(B175<>\"\",SUBTOTAL(3,$B$3:B175)+0,\"\")","v":173},"江开浪","榕江县","小学","科学","001","21","05020200121",64,1,"第39候考室","第39考场","上午场","10502143922",85.33,5,32,42.67,74.67,{"$f":"IF(S175=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA175)*($T$3:$T$196>S175))+1)","v":2},"入围体检"]
[{"$f":"IF(B176<>\"\",SUBTOTAL(3,$B$3:B176)+0,\"\")","v":174},"何璇娜","榕江县","小学","科学","001","23","05020200123",58.5,3,"第39候考室","第39考场","上午场","10502143924",86.33,3,29.25,43.17,72.42,{"$f":"IF(S176=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA176)*($T$3:$T$196>S176))+1)","v":3},"入围体检"]
[{"$f":"IF(B177<>\"\",SUBTOTAL(3,$B$3:B177)+0,\"\")","v":175},"夏绍萍","榕江县","小学","科学","001","25","05020200125",55,4,"第39候考室","第39考场","上午场","10502143925",88,2,27.5,44,71.5,{"$f":"IF(S177=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA177)*($T$3:$T$196>S177))+1)","v":4},""]
[{"$f":"IF(B178<>\"\",SUBTOTAL(3,$B$3:B178)+0,\"\")","v":176},"林翠萍","榕江县","小学","科学","001","08","05020200108",54.5,5,"第39候考室","第39考场","上午场","10502143926",81,7,27.25,40.5,67.75,{"$f":"IF(S178=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA178)*($T$3:$T$196>S178))+1)","v":5},""]
[{"$f":"IF(B179<>\"\",SUBTOTAL(3,$B$3:B179)+0,\"\")","v":177},"邰诗萱","榕江县","小学","科学","001","19","05020200119",45,7,"第39候考室","第39考场","上午场","10502143928",85.5,4,22.5,42.75,65.25,{"$f":"IF(S179=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA179)*($T$3:$T$196>S179))+1)","v":6},""]
[{"$f":"IF(B180<>\"\",SUBTOTAL(3,$B$3:B180)+0,\"\")","v":178},"杨涛","榕江县","小学","科学","001","09","05020200109",45.5,6,"第39候考室","第39考场","上午场","10502143927",84.33,6,22.75,42.17,64.92,{"$f":"IF(S180=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA180)*($T$3:$T$196>S180))+1)","v":7},""]
[{"$f":"IF(B181<>\"\",SUBTOTAL(3,$B$3:B181)+0,\"\")","v":179},"杨再明","榕江县","小学","科学","001","16","05020200116",41,8,"第39候考室","第39考场","上午场","10502143929",0,"",20.5,0,20.5,{"$f":"IF(S181=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA181)*($T$3:$T$196>S181))+1)","v":8},""]
[{"$f":"IF(B182<>\"\",SUBTOTAL(3,$B$3:B182)+0,\"\")","v":180},"金秀兰","榕江县","小学","科学","001","26","05020200126",41,8,"第39候考室","第39考场","上午场","10502143930",0,"",20.5,0,20.5,{"$f":"IF(S182=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA182)*($T$3:$T$196>S182))+1)","v":8},""]
[{"$f":"IF(B183<>\"\",SUBTOTAL(3,$B$3:B183)+0,\"\")","v":181},"陆东山","榕江县","初中","数学","003","19","05030200319",75.5,2,"第19候考室","第19考场","上午场","10503021920",84.67,4,37.75,42.34,80.09,{"$f":"IF(S183=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA183)*($T$3:$T$196>S183))+1)","v":1},"入围体检"]
[{"$f":"IF(B184<>\"\",SUBTOTAL(3,$B$3:B184)+0,\"\")","v":182},"石吉昌","榕江县","初中","数学","003","14","05030200314",79,1,"第19候考室","第19考场","上午场","10503021919",79.33,5,39.5,39.67,79.17,{"$f":"IF(S184=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA184)*($T$3:$T$196>S184))+1)","v":2},"入围体检"]
[{"$f":"IF(B185<>\"\",SUBTOTAL(3,$B$3:B185)+0,\"\")","v":183},"吴冬霞","榕江县","初中","数学","004","11","05030200411",60,3,"第19候考室","第19考场","上午场","10503021921",85,2,30,42.5,72.5,{"$f":"IF(S185=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA185)*($T$3:$T$196>S185))+1)","v":3},"入围体检"]
[{"$f":"IF(B186<>\"\",SUBTOTAL(3,$B$3:B186)+0,\"\")","v":184},"吴义","榕江县","初中","数学","002","24","05030200224",52,4,"第19候考室","第19考场","上午场","10503021922",85.5,1,26,42.75,68.75,{"$f":"IF(S186=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA186)*($T$3:$T$196>S186))+1)","v":4},"入围体检"]
[{"$f":"IF(B187<>\"\",SUBTOTAL(3,$B$3:B187)+0,\"\")","v":185},"余秀芝","榕江县","初中","数学","004","17","05030200417",39.5,5,"第19候考室","第19考场","上午场","10503021923",85,2,19.75,42.5,62.25,{"$f":"IF(S187=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA187)*($T$3:$T$196>S187))+1)","v":5},""]
[{"$f":"IF(B188<>\"\",SUBTOTAL(3,$B$3:B188)+0,\"\")","v":186},"李尧","榕江县","初中","物理","005","09","05030400509",69,1,"第25候考室","第25考场","上午场","10503042512",86.67,1,34.5,43.34,77.84,{"$f":"IF(S188=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA188)*($T$3:$T$196>S188))+1)","v":1},"入围体检"]
[{"$f":"IF(B189<>\"\",SUBTOTAL(3,$B$3:B189)+0,\"\")","v":187},"潘新元","榕江县","初中","物理","005","11","05030400511",64,2,"第25候考室","第25考场","上午场","10503042513",77.67,2,32,38.84,70.84,{"$f":"IF(S189=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA189)*($T$3:$T$196>S189))+1)","v":2},""]
[{"$f":"IF(B190<>\"\",SUBTOTAL(3,$B$3:B190)+0,\"\")","v":188},"杨再伟","榕江县","初中","物理","005","10","05030400510",47,3,"第25候考室","第25考场","上午场","10503042514",0,"",23.5,0,23.5,{"$f":"IF(S190=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA190)*($T$3:$T$196>S190))+1)","v":3},""]
[{"$f":"IF(B191<>\"\",SUBTOTAL(3,$B$3:B191)+0,\"\")","v":189},"王仕义","榕江县","初中","政治","025","27","05030902527",72.5,1,"第28候考室","第28考场","下午场","20503092833",90,1,36.25,45,81.25,{"$f":"IF(S191=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA191)*($T$3:$T$196>S191))+1)","v":1},"入围体检"]
[{"$f":"IF(B192<>\"\",SUBTOTAL(3,$B$3:B192)+0,\"\")","v":190},"吴宁艳","榕江县","初中","政治","025","23","05030902523",72,2,"第28候考室","第28考场","下午场","20503092834",86.33,2,36,43.17,79.17,{"$f":"IF(S192=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA192)*($T$3:$T$196>S192))+1)","v":2},""]
[{"$f":"IF(B193<>\"\",SUBTOTAL(3,$B$3:B193)+0,\"\")","v":191},"李常娥","榕江县","初中","政治","025","24","05030902524",67.5,3,"第28候考室","第28考场","下午场","20503092835",80.33,3,33.75,40.17,73.92,{"$f":"IF(S193=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA193)*($T$3:$T$196>S193))+1)","v":3},""]
[{"$f":"IF(B194<>\"\",SUBTOTAL(3,$B$3:B194)+0,\"\")","v":192},"吴益默","榕江县","初中","体育","005","04","05031100504",77,1,"第32候考室","第32考场","上午场","10503113207",85,1,38.5,42.5,81,{"$f":"IF(S194=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA194)*($T$3:$T$196>S194))+1)","v":1},"入围体检"]
[{"$f":"IF(B195<>\"\",SUBTOTAL(3,$B$3:B195)+0,\"\")","v":193},"杨森","榕江县","初中","体育","005","01","05031100501",52,2,"第32候考室","第32考场","上午场","10503113208",80,2,{"$f":"ROUND(I195*0.5,2)","v":26},{"$f":"ROUND(O195*0.5,2)","v":40},{"$f":"Q195+R195","v":66},{"$f":"IF(S195=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA195)*($T$3:$T$196>S195))+1)","v":2},""]
[{"$f":"IF(B196<>\"\",SUBTOTAL(3,$B$3:B196)+0,\"\")","v":194},"龙启坤","榕江县","初中","体育","005","05","05031100505",51,3,"第32候考室","第32考场","上午场","10503113209",0,"",{"$f":"ROUND(I196*0.5,2)","v":25.5},{"$f":"ROUND(O196*0.5,2)","v":0},{"$f":"Q196+R196","v":25.5},{"$f":"IF(S196=0,\"\",SUMPRODUCT(($AB$3:$AB$196=AA196)*($T$3:$T$196>S196))+1)","v":3},""]