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

{"sheet":"总成绩 ","index":0,"n_rows":93,"n_cols":11,"rows_kept":93,"merged":[[0,0,0,1],[1,0,1,10]]}
["附件1"]
["红谷滩区2022年幼儿园教师招聘面试考生\n考试总成绩及入闱体检人员名单"]
["序号","职位代码","准考证号","姓名","笔试成绩","原始面试成绩","修正系数","修正后\n面试成绩","总成绩","是否入闱体检","备注"]
[1,"100190401049","336012707226","汤慧玲","89.0",{"$f":"VLOOKUP(D4,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":89.12},{"$f":"VLOOKUP(D4,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0078135},{"$f":"VLOOKUP(D4,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":89.82},{"$f":"H4*0.6+E4*0.4","v":{"v":89.49199999999999,"d":"89.49"}},"入闱体检"]
[2,"100190401049","336012603217","夏梦婷","86.0",{"$f":"VLOOKUP(D5,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":89.4},{"$f":"VLOOKUP(D5,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0078135},{"$f":"VLOOKUP(D5,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":90.1},88.46,"入闱体检"]
[3,"100190401049","336012402619","涂雯婧","89.5",{"$f":"VLOOKUP(D6,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":89.16},{"$f":"VLOOKUP(D6,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9822703},{"$f":"VLOOKUP(D6,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":87.58},{"v":88.348,"d":"88.35"},"入闱体检"]
[4,"100190401049","336211201121","胡露连","88.0",{"$f":"VLOOKUP(D7,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":89},{"$f":"VLOOKUP(D7,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9822703},{"$f":"VLOOKUP(D7,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":87.42},{"v":87.652,"d":"87.65"},"入闱体检"]
[5,"100190401049","336012502025","张思雨","85.5",{"$f":"VLOOKUP(D8,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":88},{"$f":"VLOOKUP(D8,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0078135},{"$f":"VLOOKUP(D8,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":88.69},{"v":87.414,"d":"87.41"},"入闱体检"]
[6,"100190401049","336012707514","熊越","84.5",{"$f":"VLOOKUP(D9,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":90.72},{"$f":"VLOOKUP(D9,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9822703},{"$f":"VLOOKUP(D9,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":89.11},{"v":87.266,"d":"87.27"},"入闱体检"]
[7,"100190401049","336012601518","肖静","87.5",{"$f":"VLOOKUP(D10,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":86.24},{"$f":"VLOOKUP(D10,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0065846},{"$f":"VLOOKUP(D10,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":86.81},{"v":87.086,"d":"87.09"},"入闱体检"]
[8,"100190401049","336012602306","万若莲","91.0",{"$f":"VLOOKUP(D11,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":83.44},{"$f":"VLOOKUP(D11,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0065846},{"$f":"VLOOKUP(D11,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":83.99},{"v":86.794,"d":"86.79"},"入闱体检"]
[9,"100190401049","336012601317","王美慧","88.0",{"$f":"VLOOKUP(D12,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":85.2},{"$f":"VLOOKUP(D12,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0065846},{"$f":"VLOOKUP(D12,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":85.76},{"v":86.656,"d":"86.66"},"入闱体检"]
[10,"100190401049","336012601417","涂梦颖","82.5",{"$f":"VLOOKUP(D13,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":88.4},{"$f":"VLOOKUP(D13,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0065846},{"$f":"VLOOKUP(D13,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":88.98},{"v":86.388,"d":"86.39"},"入闱体检"]
[11,"100190401049","336012400219","刘媛媛","87.5",{"$f":"VLOOKUP(D14,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":86.72},{"$f":"VLOOKUP(D14,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9822703},{"$f":"VLOOKUP(D14,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":85.18},{"v":86.108,"d":"86.11"},"入闱体检"]
[12,"100190401049","336040602416","徐子菲","86.5",{"$f":"VLOOKUP(D15,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":84.76},{"$f":"VLOOKUP(D15,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0065846},{"$f":"VLOOKUP(D15,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":85.32},{"v":85.792,"d":"85.79"},"入闱体检"]
[13,"100190401049","336012707224","高章敏","82.5",{"$f":"VLOOKUP(D16,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":87.28},{"$f":"VLOOKUP(D16,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0078135},{"$f":"VLOOKUP(D16,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":87.96},{"v":85.776,"d":"85.78"},"入闱体检"]
[14,"100190401049","336012502316","邹琦","86.5",{"$f":"VLOOKUP(D17,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":86.52},{"$f":"VLOOKUP(D17,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9822703},{"$f":"VLOOKUP(D17,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":84.99},{"v":85.594,"d":"85.59"},"入闱体检"]
[15,"100190401049","336012601816","江倩","83.5",{"$f":"VLOOKUP(D18,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":86.24},{"$f":"VLOOKUP(D18,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0078135},{"$f":"VLOOKUP(D18,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":86.91},{"v":85.54599999999999,"d":"85.55"},"入闱体检"]
[16,"100190401049","336012602611","杨林慧","79.0",{"$f":"VLOOKUP(D19,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":87.96},{"$f":"VLOOKUP(D19,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0078135},{"$f":"VLOOKUP(D19,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":88.65},84.79,"入闱体检"]
[17,"100190401049","336012601002","邹伟","86.5",{"$f":"VLOOKUP(D20,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":82.72},{"$f":"VLOOKUP(D20,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0078135},{"$f":"VLOOKUP(D20,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":83.37},{"v":84.622,"d":"84.62"},"入闱体检"]
[18,"100190401049","336012600315","万婷","82.5",{"$f":"VLOOKUP(D21,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":87.52},{"$f":"VLOOKUP(D21,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9822703},{"$f":"VLOOKUP(D21,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":85.97},{"v":84.582,"d":"84.58"},"入闱体检"]
[19,"100190401049","336012600707","罗云宇","89.0",{"$f":"VLOOKUP(D22,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":81.04},{"$f":"VLOOKUP(D22,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0065846},{"$f":"VLOOKUP(D22,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":81.57},{"v":84.542,"d":"84.54"},"入闱体检"]
[20,"100190401049","336012501302","黄雨萱","86.5",{"$f":"VLOOKUP(D23,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":83.84},{"$f":"VLOOKUP(D23,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9822703},{"$f":"VLOOKUP(D23,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":82.35},{"v":84.00999999999999,"d":"84.01"},"入闱体检"]
[21,"100190401049","336012603427","龚诗萱","89.0",{"$f":"VLOOKUP(D24,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":81.88},{"$f":"VLOOKUP(D24,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9822703},{"$f":"VLOOKUP(D24,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":80.43},{"v":83.858,"d":"83.86"},"入闱体检"]
[22,"100190401049","336012601014","李小洋","77.5",{"$f":"VLOOKUP(D25,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":87.4},{"$f":"VLOOKUP(D25,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0078135},{"$f":"VLOOKUP(D25,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":88.08},{"v":83.848,"d":"83.85"},"入闱体检"]
[23,"100190401049","336012400710","潘丽","82.5",{"$f":"VLOOKUP(D26,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":84.08},{"$f":"VLOOKUP(D26,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0078135},{"$f":"VLOOKUP(D26,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":84.74},{"v":83.844,"d":"83.84"},"入闱体检"]
[24,"100190401049","336012600814","金小芸","81.5",{"$f":"VLOOKUP(D27,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":84.64},{"$f":"VLOOKUP(D27,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0065846},{"$f":"VLOOKUP(D27,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":85.2},83.72,"入闱体检"]
[25,"100190401049","336012400713","郭奇","85.5",{"$f":"VLOOKUP(D28,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":81.88},{"$f":"VLOOKUP(D28,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0065846},{"$f":"VLOOKUP(D28,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":82.42},{"v":83.652,"d":"83.65"},"入闱体检"]
[26,"100190401049","336211402710","舒昕悦","84.5",{"$f":"VLOOKUP(D29,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":84.08},{"$f":"VLOOKUP(D29,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9822703},{"$f":"VLOOKUP(D29,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":82.59},{"v":83.35400000000001,"d":"83.35"},"入闱体检"]
[27,"100190401049","336012400401","危郁瑾","81.5",{"$f":"VLOOKUP(D30,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":83.84},{"$f":"VLOOKUP(D30,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0078135},{"$f":"VLOOKUP(D30,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":84.5},{"v":83.3,"d":"83.30"},"入闱体检"]
[28,"100190401049","336211304128","王菲","83.5",{"$f":"VLOOKUP(D31,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":82.04},{"$f":"VLOOKUP(D31,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0078135},{"$f":"VLOOKUP(D31,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":82.68},{"v":83.00800000000001,"d":"83.01"}]
[29,"100190401049","336012602724","王雪嫣","86.5",{"$f":"VLOOKUP(D32,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":81.92},{"$f":"VLOOKUP(D32,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9822703},{"$f":"VLOOKUP(D32,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":80.47},{"v":82.882,"d":"82.88"}]
[30,"100190401049","336250107004","邹狄嫒","80.0",{"$f":"VLOOKUP(D33,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":83.84},{"$f":"VLOOKUP(D33,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0065846},{"$f":"VLOOKUP(D33,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":84.39},{"v":82.634,"d":"82.63"}]
[31,"100190401049","336012500716","樊妮娇","79.5",{"$f":"VLOOKUP(D34,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":83.96},{"$f":"VLOOKUP(D34,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0065846},{"$f":"VLOOKUP(D34,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":84.51},{"v":82.506,"d":"82.51"}]
[32,"100190401049","336012601519","邹子珺","82.5",{"$f":"VLOOKUP(D35,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":81.96},{"$f":"VLOOKUP(D35,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0065846},{"$f":"VLOOKUP(D35,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":82.5},{"v":82.5,"d":"82.50"}]
[33,"100190401049","336012502703","曾婷婷","87.5",{"$f":"VLOOKUP(D36,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":80.2},{"$f":"VLOOKUP(D36,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9822703},{"$f":"VLOOKUP(D36,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":78.78},{"$f":"H36*0.6+E36*0.4","v":{"v":82.268,"d":"82.27"}}]
[34,"100190401049","336012400821","吴雪娜","77.5",{"$f":"VLOOKUP(D37,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":84.76},{"$f":"VLOOKUP(D37,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0065846},{"$f":"VLOOKUP(D37,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":85.32},{"v":82.192,"d":"82.19"}]
[35,"100190401049","336230301126","方翠霞","81.0",{"$f":"VLOOKUP(D38,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":84.2},{"$f":"VLOOKUP(D38,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9822703},{"$f":"VLOOKUP(D38,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":82.71},{"v":82.026,"d":"82.03"}]
[36,"100190401049","336012400306","聂影思","80.0",{"$f":"VLOOKUP(D39,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":84.48},{"$f":"VLOOKUP(D39,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9822703},{"$f":"VLOOKUP(D39,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":82.98},{"v":81.78800000000001,"d":"81.79"}]
[37,"100190401049","336012502209","彭丽琪","85.5",{"$f":"VLOOKUP(D40,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":78.76},{"$f":"VLOOKUP(D40,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0065846},{"$f":"VLOOKUP(D40,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":79.28},{"v":81.768,"d":"81.77"}]
[38,"100190401049","336012403026","罗嘉欣","83.5",{"$f":"VLOOKUP(D41,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":79.92},{"$f":"VLOOKUP(D41,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0078135},{"$f":"VLOOKUP(D41,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":80.54},{"v":81.724,"d":"81.72"}]
[39,"100190401049","336060110024","黄晶","83.5",{"$f":"VLOOKUP(D42,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":79.48},{"$f":"VLOOKUP(D42,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0065846},{"$f":"VLOOKUP(D42,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":80},{"v":81.4,"d":"81.40"}]
[40,"100190401049","336211504227","詹洁","83.0",{"$f":"VLOOKUP(D43,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":81.76},{"$f":"VLOOKUP(D43,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9822703},{"$f":"VLOOKUP(D43,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":80.31},{"v":81.386,"d":"81.39"}]
[41,"100190401049","336012400612","章双双","84.0",{"$f":"VLOOKUP(D44,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":79.12},{"$f":"VLOOKUP(D44,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0065846},{"$f":"VLOOKUP(D44,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":79.64},{"v":81.384,"d":"81.38"}]
[42,"100190401049","336012603113","孔雅莉","84.5",{"$f":"VLOOKUP(D45,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":80.4},{"$f":"VLOOKUP(D45,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9822703},{"$f":"VLOOKUP(D45,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":78.97},{"v":81.182,"d":"81.18"}]
[43,"100190401049","336221808229","余翘","87.0",{"$f":"VLOOKUP(D46,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":75.36},{"$f":"VLOOKUP(D46,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0065846},{"$f":"VLOOKUP(D46,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":75.86},{"v":80.316,"d":"80.32"}]
[44,"100190401049","336012401925","许阿平","81.0",{"$f":"VLOOKUP(D47,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":80},{"$f":"VLOOKUP(D47,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9822703},{"$f":"VLOOKUP(D47,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":78.58},{"v":79.548,"d":"79.55"}]
[45,"100190401049","336012502008","龚梦琴","84.5",{"$f":"VLOOKUP(D48,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":75.04},{"$f":"VLOOKUP(D48,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0065846},{"$f":"VLOOKUP(D48,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":75.53},{"v":79.118,"d":"79.12"}]
[46,"100190401049","336012500709","吴紫芸","81.0",{"$f":"VLOOKUP(D49,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":79},{"$f":"VLOOKUP(D49,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9822703},{"$f":"VLOOKUP(D49,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":77.6},78.96]
[47,"100190401049","336012602101","徐童","78.5",{"$f":"VLOOKUP(D50,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":76.6},{"$f":"VLOOKUP(D50,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0078135},{"$f":"VLOOKUP(D50,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":77.2},77.72]
[48,"100190401049","336012401204","黄红","79.0",{"$f":"VLOOKUP(D51,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":75.08},{"$f":"VLOOKUP(D51,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0078135},{"$f":"VLOOKUP(D51,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":75.67},{"v":77.00200000000001,"d":"77.00"}]
[49,"100190401049","336012601625","巩玉伟","77.5",{"$f":"VLOOKUP(D52,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":73.48},{"$f":"VLOOKUP(D52,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0078135},{"$f":"VLOOKUP(D52,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":74.05},75.43]
[50,"100190401049","336012501902","周洛艺","85.5",{"$f":"VLOOKUP(D53,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":67.92},{"$f":"VLOOKUP(D53,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0078135},{"$f":"VLOOKUP(D53,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":68.45},{"v":75.27000000000001,"d":"75.27"}]
[51,"100190401049","336012400213","刘惠兰","81.0",{"$f":"VLOOKUP(D54,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":70.72},{"$f":"VLOOKUP(D54,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0065846},{"$f":"VLOOKUP(D54,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":71.19},{"v":75.114,"d":"75.11"}]
[52,"100190401049","336012500505","程笑","78.0",{"$f":"VLOOKUP(D55,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":72.08},{"$f":"VLOOKUP(D55,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0078135},{"$f":"VLOOKUP(D55,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":72.64},{"v":74.78399999999999,"d":"74.78"}]
[53,"100190401049","336012401917","万梦倩","77.5",{"$f":"VLOOKUP(D56,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":65.48},{"$f":"VLOOKUP(D56,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0078135},{"$f":"VLOOKUP(D56,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":65.99},{"v":70.594,"d":"70.59"}]
[54,"100190401049","336012601630","周璐璐","79.5",{"$f":"VLOOKUP(D57,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":0},{"$f":"VLOOKUP(D57,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9822703},{"$f":"VLOOKUP(D57,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":0},{"v":31.8,"d":"31.80"}]
[55,"100190401050","336012707421","邹宇帆","85.0",{"$f":"VLOOKUP(D58,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":92.24},{"$f":"VLOOKUP(D58,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9860574},{"$f":"VLOOKUP(D58,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":90.95},88.57,"入闱体检"]
[56,"100190401050","336221808108","丁林美","89.5",{"$f":"VLOOKUP(D59,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":85.76},{"$f":"VLOOKUP(D59,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0161797},{"$f":"VLOOKUP(D59,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":87.15},88.09,"入闱体检"]
[57,"100190401050","336012602721","齐昕怡","84.5",{"$f":"VLOOKUP(D60,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":88.84},{"$f":"VLOOKUP(D60,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0161797},{"$f":"VLOOKUP(D60,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":90.28},{"v":87.968,"d":"87.97"},"入闱体检"]
[58,"100190401050","336040602711","叶益青","85.5",{"$f":"VLOOKUP(D61,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":88.4},{"$f":"VLOOKUP(D61,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9860574},{"$f":"VLOOKUP(D61,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":87.17},{"v":86.50200000000001,"d":"86.50"},"入闱体检"]
[59,"100190401050","336012401207","欧阳嘉嫔","81.5",{"$f":"VLOOKUP(D62,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":91},{"$f":"VLOOKUP(D62,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9860574},{"$f":"VLOOKUP(D62,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":89.73},{"v":86.438,"d":"86.44"},"入闱体检"]
[60,"100190401050","336012602511","俞志玲","86.0",{"$f":"VLOOKUP(D63,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":84.72},{"$f":"VLOOKUP(D63,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0161797},{"$f":"VLOOKUP(D63,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":86.09},{"v":86.054,"d":"86.05"},"入闱体检"]
[61,"100190401050","336012602127","何龙娟","78.0",{"$f":"VLOOKUP(D64,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":91.44},{"$f":"VLOOKUP(D64,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9860574},{"$f":"VLOOKUP(D64,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":90.17},{"v":85.30199999999999,"d":"85.30"},"入闱体检"]
[62,"100190401050","336012600325","夏博颖","86.0",{"$f":"VLOOKUP(D65,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":83.16},{"$f":"VLOOKUP(D65,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0161797},{"$f":"VLOOKUP(D65,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":84.51},{"v":85.106,"d":"85.11"},"入闱体检"]
[63,"100190401050","336012400704","熊怡","85.0",{"$f":"VLOOKUP(D66,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":83.68},{"$f":"VLOOKUP(D66,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0161797},{"$f":"VLOOKUP(D66,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":85.03},{"v":85.018,"d":"85.02"},"入闱体检"]
[64,"100190401050","336012601425","陈雅琪","87.0",{"$f":"VLOOKUP(D67,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":82.36},{"$f":"VLOOKUP(D67,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0161797},{"$f":"VLOOKUP(D67,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":83.69},{"v":85.01400000000001,"d":"85.01"},"入闱体检"]
[65,"100190401050","336012600321","刘凯棋","88.0",{"$f":"VLOOKUP(D68,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":81.4},{"$f":"VLOOKUP(D68,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0161797},{"$f":"VLOOKUP(D68,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":82.72},{"$f":"H68*0.6+E68*0.4","v":{"v":84.832,"d":"84.83"}},"入闱体检"]
[66,"100190401050","336012501413","占佳玲","85.5",{"$f":"VLOOKUP(D69,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":85.44},{"$f":"VLOOKUP(D69,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9860574},{"$f":"VLOOKUP(D69,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":84.25},84.75,"入闱体检"]
[67,"100190401050","336012603325","张小雪","86.5",{"$f":"VLOOKUP(D70,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":81.96},{"$f":"VLOOKUP(D70,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0161797},{"$f":"VLOOKUP(D70,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":83.29},{"v":84.57400000000001,"d":"84.57"},"入闱体检"]
[68,"100190401050","336012602201","王欣月","85.0",{"$f":"VLOOKUP(D71,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":82.88},{"$f":"VLOOKUP(D71,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0161797},{"$f":"VLOOKUP(D71,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":84.22},{"v":84.532,"d":"84.53"},"入闱体检"]
[69,"100190401050","336012401920","吴明燕","86.5",{"$f":"VLOOKUP(D72,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":83.64},{"$f":"VLOOKUP(D72,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9860574},{"$f":"VLOOKUP(D72,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":82.47},{"v":84.082,"d":"84.08"},"入闱体检"]
[70,"100190401050","336040600912","冯娜燕","83.0",{"$f":"VLOOKUP(D73,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":83.36},{"$f":"VLOOKUP(D73,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0161797},{"$f":"VLOOKUP(D73,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":84.71},{"v":84.026,"d":"84.03"},"入闱体检"]
[71,"100190401050","336012401411","刘洁","81.5",{"$f":"VLOOKUP(D74,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":86.72},{"$f":"VLOOKUP(D74,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9860574},{"$f":"VLOOKUP(D74,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":85.51},{"v":83.906,"d":"83.91"},"入闱体检"]
[72,"100190401050","336012401003","邱燕琴","83.0",{"$f":"VLOOKUP(D75,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":85.64},{"$f":"VLOOKUP(D75,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9860574},{"$f":"VLOOKUP(D75,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":84.45},83.87,"入闱体检"]
[73,"100190401050","336012603226","夏妹","84.0",{"$f":"VLOOKUP(D76,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":84.96},{"$f":"VLOOKUP(D76,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9860574},{"$f":"VLOOKUP(D76,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":83.78},{"v":83.868,"d":"83.87"}]
[74,"100190401050","336012600116","唐凯婷","84.5",{"$f":"VLOOKUP(D77,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":81.92},{"$f":"VLOOKUP(D77,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0161797},{"$f":"VLOOKUP(D77,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":83.25},83.75]
[75,"100190401050","336012401924","陈嘉妮","78.5",{"$f":"VLOOKUP(D78,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":85.84},{"$f":"VLOOKUP(D78,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0161797},{"$f":"VLOOKUP(D78,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":87.23},{"v":83.738,"d":"83.74"}]
[76,"100190401050","336012500613","涂艳芳","80.0",{"$f":"VLOOKUP(D79,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":86.68},{"$f":"VLOOKUP(D79,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9860574},{"$f":"VLOOKUP(D79,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":85.47},{"v":83.282,"d":"83.28"}]
[77,"100190401050","336012600802","舒雨佳","82.5",{"$f":"VLOOKUP(D80,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":84.92},{"$f":"VLOOKUP(D80,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9860574},{"$f":"VLOOKUP(D80,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":83.74},{"v":83.244,"d":"83.24"}]
[78,"100190401050","336012602001","文佳","85.5",{"$f":"VLOOKUP(D81,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":80.32},{"$f":"VLOOKUP(D81,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0161797},{"$f":"VLOOKUP(D81,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":81.62},{"v":83.172,"d":"83.17"}]
[79,"100190401050","336012402422","谭杜娟","86.0",{"$f":"VLOOKUP(D82,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":82.4},{"$f":"VLOOKUP(D82,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9860574},{"$f":"VLOOKUP(D82,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":81.25},83.15]
[80,"100190401050","336012603104","陈慧","85.0",{"$f":"VLOOKUP(D83,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":83.04},{"$f":"VLOOKUP(D83,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9860574},{"$f":"VLOOKUP(D83,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":81.88},{"v":83.12799999999999,"d":"83.13"}]
[81,"100190401050","336012402224","盛钰","82.5",{"$f":"VLOOKUP(D84,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":82.2},{"$f":"VLOOKUP(D84,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0161797},{"$f":"VLOOKUP(D84,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":83.53},{"v":83.118,"d":"83.12"}]
[82,"100190401050","336012502611","魏欣宇","81.5",{"$f":"VLOOKUP(D85,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":85.24},{"$f":"VLOOKUP(D85,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9860574},{"$f":"VLOOKUP(D85,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":84.05},83.03]
[83,"100190401050","336012602703","陈茜","84.0",{"$f":"VLOOKUP(D86,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":83.4},{"$f":"VLOOKUP(D86,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9860574},{"$f":"VLOOKUP(D86,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":82.24},{"v":82.94399999999999,"d":"82.94"}]
[84,"100190401050","336012601219","熊安平","84.5",{"$f":"VLOOKUP(D87,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":80.44},{"$f":"VLOOKUP(D87,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0161797},{"$f":"VLOOKUP(D87,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":81.74},{"v":82.844,"d":"82.84"}]
[85,"100190401050","336012707313","胡文琦","83.5",{"$f":"VLOOKUP(D88,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":79.84},{"$f":"VLOOKUP(D88,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0161797},{"$f":"VLOOKUP(D88,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":81.13},{"v":82.078,"d":"82.08"}]
[86,"100190401050","336012707505","舒志艳","77.5",{"$f":"VLOOKUP(D89,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":82.88},{"$f":"VLOOKUP(D89,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0161797},{"$f":"VLOOKUP(D89,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":84.22},{"v":81.532,"d":"81.53"}]
[87,"100190401050","336221807905","丁玉欣","79.0",{"$f":"VLOOKUP(D90,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":83.08},{"$f":"VLOOKUP(D90,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9860574},{"$f":"VLOOKUP(D90,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":81.92},{"v":80.75200000000001,"d":"80.75"}]
[88,"100190401050","336012602230","陈奕君","78.5",{"$f":"VLOOKUP(D91,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":82.72},{"$f":"VLOOKUP(D91,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9860574},{"$f":"VLOOKUP(D91,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":81.57},{"v":80.342,"d":"80.34"}]
[89,"100190401050","336012600201","熊果","81.5",{"$f":"VLOOKUP(D92,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":76.64},{"$f":"VLOOKUP(D92,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":0.9860574},{"$f":"VLOOKUP(D92,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":75.57},{"v":77.942,"d":"77.94"}]
[90,"100190401050","336250106628","曾佩秀","81.0",{"$f":"VLOOKUP(D93,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,7,0)","v":0},{"$f":"VLOOKUP(D93,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,8,0)","v":1.0161797},{"$f":"VLOOKUP(D93,'[1]修正后的面试成绩（排名 )'!$B$2:$J$92,9,0)","v":0},{"v":32.4,"d":"32.40"}]