{"text_format":"3","workbook":"xls","n_sheets":6,"sheets":["汇总"," 应届岗","1组","2组","3组","4组"],"not_rendered":{"external_links":1,"defined_names":9,"comments":3},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"汇总","index":0,"n_rows":145,"n_cols":12,"rows_kept":145,"merged":[[0,0,0,11],[1,0,1,11],[2,1,2,10],[4,0,5,0],[4,1,5,1],[4,2,4,5],[4,6,4,8],[4,9,5,9],[4,10,5,10],[4,11,5,11]],"flags":["formulas_cached_only"]}
["    根据全省中小学教师招聘公告精神，幼儿教师岗位面试人数较多，需要分成若干个面试小组共同完成，将对面试成绩进行修正。修正公式为：考生面试成绩=考生面试得分×（同一职位全部考生平均分÷考生所在面试小组的考生平均分）。公式中计算平均分时，应先排除弃考等因素造成的零分，再去掉2个最高分、2个最低分。\n    幼儿一组修正后面试成绩=面试得分×（86.257÷88.797）\n    幼儿二组修正后面试成绩=面试得分×（86.257÷87.093）\n    幼儿三组修正后面试成绩=面试得分×（86.257÷84.893）\n    幼儿四组修正后面试成绩=面试得分×（86.257÷84.860）"]
["2020年泰和县全省统一招聘教师考试总成绩汇总表"]
[null,"（招录72人）"]
[null,"学科：幼儿园"]
["序号","姓 名","笔试折算成绩×40%",{"$nulls":3},"面试成绩（占60%）",null,null,"总成绩","总分\n排名","备注"]
[null,null,"综合知识成绩","学科专业成绩","笔试成绩","笔试折算分","面试成绩","修正后的面试成绩","面试折算分"]
[1,"章艳玲",null,null,81,32.4,87.22,{"v":88.62138857149588,"d":"88.621"},{"v":53.17283314289753,"d":"53.173"},{"v":85.57283314289754,"d":"85.573"},3,"入闱体检"]
[2,"肖慧",null,null,79.5,31.8,92,{"v":91.1168980285442,"d":"91.117"},{"v":54.67013881712652,"d":"54.670"},{"v":86.47013881712653,"d":"86.470"},1,"入闱体检"]
[3,"刘沙沙",null,null,79,31.6,89,{"v":86.45419327229524,"d":"86.454"},{"v":51.87251596337715,"d":"51.873"},{"v":83.47251596337715,"d":"83.473"},14,"入闱体检"]
[4,"汤艳香",null,null,77.5,31,84.84,{"v":86.23667075182654,"d":"86.237"},{"v":51.74200245109592,"d":"51.742"},{"v":82.74200245109591,"d":"82.742"},21,"入闱体检"]
[5,"孙家玉",null,null,77.5,31,89.7,{"v":91.14123543755082,"d":"91.141"},{"v":54.68474126253049,"d":"54.685"},{"v":85.68474126253048,"d":"85.685"},2,"入闱体检"]
[6,"杨梦莹",null,null,77,30.8,89.36,{"v":88.5022392155512,"d":"88.502"},{"v":53.10134352933072,"d":"53.101"},{"v":83.90134352933072,"d":"83.901"},12,"入闱体检"]
[7,"刘金花",null,null,77,30.8,84.8,{"v":83.98601035674508,"d":"83.986"},{"v":50.39160621404705,"d":"50.392"},{"v":81.19160621404706,"d":"81.192"},32,"入闱体检"]
[8,"孙小娟",null,null,75.5,30.2,91.82,{"v":90.93862583674922,"d":"90.939"},{"v":54.56317550204953,"d":"54.563"},{"v":84.76317550204953,"d":"84.763"},7,"入闱体检"]
[9,"杜桃花",null,null,75.5,30.2,91.2,{"v":88.59126321835198,"d":"88.591"},{"v":53.15475793101119,"d":"53.155"},{"v":83.35475793101119,"d":"83.355"},16,"入闱体检"]
[10,"欧阳倩",null,null,74.5,29.8,86.66,{"v":88.0866323356116,"d":"88.087"},{"v":52.851979401366954,"d":"52.852"},{"v":82.65197940136696,"d":"82.652"},24,"入闱体检"]
[11,"周春蓉",null,null,74.5,29.8,83.72,{"v":85.09823285411265,"d":"85.098"},{"v":51.05893971246759,"d":"51.059"},{"v":80.85893971246759,"d":"80.859"},37,"入闱体检"]
[12,"吴静",null,null,74,29.6,84.1,{"v":83.29272961087572,"d":"83.293"},{"v":49.97563776652543,"d":"49.976"},{"v":79.57563776652543,"d":"79.576"},57,"入闱体检"]
[13,"徐友红",null,null,74,29.6,79.98,{"v":77.69220649346262,"d":"77.692"},{"v":46.61532389607757,"d":"46.615"},{"v":76.21532389607756,"d":"76.215"}]
[14,"李丹",null,null,73.5,29.4,91.82,{"v":90.93862583674922,"d":"90.939"},{"v":54.56317550204953,"d":"54.563"},{"v":83.96317550204954,"d":"83.963"},10,"入闱体检"]
[15,"肖丹",null,null,73.5,29.4,90.52,{"v":87.93071432593443,"d":"87.931"},{"v":52.75842859556066,"d":"52.758"},{"v":82.15842859556066,"d":"82.158"},27,"入闱体检"]
[16,"黄云玲",null,null,73,29.2,87.2,{"v":86.36297291401146,"d":"86.363"},{"v":51.817783748406875,"d":"51.818"},{"v":81.01778374840688,"d":"81.018"},36,"入闱体检"]
[17,"杨慧",null,null,73,29.200000000000003,83.3,{"v":84.6384048154736,"d":"84.638"},{"v":50.78304288928416,"d":"50.783"},{"v":79.98304288928416,"d":"79.983"},48,"入闱体检"]
[18,"刘巧珍",null,null,73,29.2,93.06,{"v":90.39805871819995,"d":"90.398"},{"v":54.23883523091997,"d":"54.239"},{"v":83.43883523091998,"d":"83.439"},15,"入闱体检"]
[19,"龙小芳",null,null,73,29.2,93.28,{"v":90.61176571280562,"d":"90.612"},{"v":54.36705942768337,"d":"54.367"},{"v":83.56705942768338,"d":"83.567"},13,"入闱体检"]
[20,"谢非",null,null,72.5,29,90.1,{"v":91.54766235143063,"d":"91.548"},{"v":54.92859741085838,"d":"54.929"},{"v":83.92859741085837,"d":"83.929"},11,"入闱体检"]
[21,"旷荷仙",null,null,72.5,29,92.38,{"v":89.7375098257824,"d":"89.738"},{"v":53.842505895469436,"d":"53.843"},{"v":82.84250589546943,"d":"82.843"},20,"入闱体检"]
[22,"刘笑寒",null,null,72.5,29,89.68,{"v":87.11474216471278,"d":"87.115"},{"v":52.268845298827664,"d":"52.269"},{"v":81.26884529882767,"d":"81.269"},31,"入闱体检"]
[23,"衷丽霞",null,null,72.5,29,91.62,{"v":93.12828588263022,"d":"93.128"},{"v":55.876971529578135,"d":"55.877"},{"v":84.87697152957813,"d":"84.877"},6,"入闱体检"]
[24,"肖钰莹",null,null,72,28.8,89.38,{"v":90.81609390644694,"d":"90.816"},{"v":54.48965634386816,"d":"54.490"},{"v":83.28965634386816,"d":"83.290"},17,"入闱体检"]
[25,"肖海英",null,null,72,28.8,88.48,{"v":89.90163335021735,"d":"89.902"},{"v":53.94098001013041,"d":"53.941"},{"v":82.74098001013041,"d":"82.741"},22,"入闱体检"]
[26,"刘婷",null,null,72,28.8,79.6,{"v":80.91040773037945,"d":"80.910"},{"v":48.54624463822767,"d":"48.546"},{"v":77.34624463822767,"d":"77.346"},null,97.04]
[27,"熊玉",null,null,71.5,28.6,87.24,{"v":86.40258895663257,"d":"86.403"},{"v":51.84155337397954,"d":"51.842"},{"v":80.44155337397954,"d":"80.442"},44,"入闱体检"]
[28,"毛珊娟",null,null,71.5,28.6,80.68,{"v":82.00818713174641,"d":"82.008"},{"v":49.204912279047846,"d":"49.205"},{"v":77.80491227904784,"d":"77.805"}]
[29,"曾婷",null,null,70.5,28.200000000000003,77.52,{"v":78.76553590991013,"d":"78.766"},{"v":47.25932154594607,"d":"47.259"},{"v":75.45932154594607,"d":"75.459"}]
[30,"张鹃",null,null,70.5,28.200000000000003,85.84,{"v":87.2192157186105,"d":"87.219"},{"v":52.331529431166295,"d":"52.332"},{"v":80.53152943116629,"d":"80.532"},42,"入闱体检"]
[31,"任逸",null,null,70,28,86.64,{"v":88.03206954637015,"d":"88.032"},{"v":52.81924172782209,"d":"52.819"},{"v":80.81924172782209,"d":"80.819"},39,"入闱体检"]
[32,"张薇",null,null,70,28,90.29,{"v":91.77639087909499,"d":"91.776"},{"v":55.06583452745699,"d":"55.066"},{"v":83.06583452745699,"d":"83.066"},18,"99年9月出生\n入闱体检"]
[33,"张馨月",null,null,70,28,93.34,{"v":90.67004943860717,"d":"90.670"},{"v":54.4020296631643,"d":"54.402"},{"v":82.4020296631643,"d":"82.402"},26,"入闱体检"]
[34,"杨博彬",null,null,70,28,87.14,{"v":88.54010318871993,"d":"88.540"},{"v":53.124061913231955,"d":"53.124"},{"v":81.12406191323196,"d":"81.124"},34,"入闱体检"]
[35,"罗吉梅",null,null,70,28,86.7,{"v":88.09303358345213,"d":"88.093"},{"v":52.855820150071274,"d":"52.856"},{"v":80.85582015007128,"d":"80.856"},38,"入闱体检"]
[36,"曾香",null,null,70,28,84.88,{"v":86.24379112529891,"d":"86.244"},{"v":51.74627467517934,"d":"51.746"},{"v":79.74627467517934,"d":"79.746"},53,"入闱体检"]
[37,"邹鹏",null,null,69.5,27.8,91.42,{"v":88.80497021295766,"d":"88.805"},{"v":53.282982127774595,"d":"53.283"},{"v":81.0829821277746,"d":"81.083"},35,"入闱体检"]
[38,"杨文娟",null,null,69.5,27.8,87.46,{"v":86.62047719104865,"d":"86.620"},{"v":51.97228631462919,"d":"51.972"},{"v":79.77228631462918,"d":"79.772"},52,"入闱体检"]
[39,"易瑾珂",null,null,69.5,27.8,90.04,{"v":91.5222752769267,"d":"91.522"},{"v":54.91336516615602,"d":"54.913"},{"v":82.71336516615602,"d":"82.713"},23,"入闱体检"]
[40,"夏倩文",null,null,69.5,27.8,93.96,{"v":91.27231460522314,"d":"91.272"},{"v":54.76338876313388,"d":"54.763"},{"v":82.56338876313389,"d":"82.563"},25,"入闱体检"]
[41,"罗琳",null,null,69,27.6,83.12,{"v":84.4883554089088,"d":"84.488"},{"v":50.69301324534528,"d":"50.693"},{"v":78.29301324534528,"d":"78.293"},66,"入闱体检"]
[42,"康婷",null,null,69,27.6,83.8,{"v":82.99560929121743,"d":"82.996"},{"v":49.797365574730456,"d":"49.797"},{"v":77.39736557473046,"d":"77.397"}]
[43,"刘东琴",null,null,69,27.6,85.8,{"v":87.17857302722251,"d":"87.179"},{"v":52.30714381633351,"d":"52.307"},{"v":79.9071438163335,"d":"79.907"},50,"入闱体检"]
[44,"严萍筠",null,null,69,27.6,81.7,{"v":83.01269715995431,"d":"83.013"},{"v":49.80761829597259,"d":"49.808"},{"v":77.40761829597258,"d":"77.408"}]
[45,"郭木华",null,null,68.5,27.4,85.72,{"v":87.09728764444655,"d":"87.097"},{"v":52.25837258666793,"d":"52.258"},{"v":79.65837258666792,"d":"79.658"},56,"入闱体检"]
[46,"谢雨薇",null,null,68.5,27.4,91.12,{"v":88.51355158394992,"d":"88.514"},{"v":53.10813095036995,"d":"53.108"},{"v":80.50813095036995,"d":"80.508"},43,"入闱体检"]
[47,"郭丹",null,null,68.5,27.4,90.14,{"v":87.56158406252464,"d":"87.562"},{"v":52.53695043751478,"d":"52.537"},{"v":79.93695043751478,"d":"79.937"},49,"入闱体检"]
[48,"彭美玲",null,null,68.5,27.4,89.56,{"v":91.03437332076362,"d":"91.034"},{"v":54.62062399245817,"d":"54.621"},{"v":82.02062399245817,"d":"82.021"},28,"入闱体检"]
[49,"刘婧",null,null,68.5,27.4,88.7,{"v":86.1627746432875,"d":"86.163"},{"v":51.6976647859725,"d":"51.698"},{"v":79.0976647859725,"d":"79.098"},59,"入闱体检"]
[50,"黄愉红",null,null,68.5,27.4,80.02,{"v":81.33732194202216,"d":"81.337"},{"v":48.802393165213296,"d":"48.802"},{"v":76.2023931652133,"d":"76.202"}]
[51,"白晓露",null,null,68,27.2,90,{"v":89.1360958974889,"d":"89.136"},{"v":53.48165753849334,"d":"53.482"},{"v":80.68165753849334,"d":"80.682"},40,"入闱体检"]
[52,"毛婷",null,null,67.5,27,89.02,{"v":86.47362118089575,"d":"86.474"},{"v":51.88417270853745,"d":"51.884"},{"v":78.88417270853745,"d":"78.884"},61,"入闱体检"]
[53,"张昕璐",null,null,67.5,27,93.54,{"v":95.0798937072826,"d":"95.080"},{"v":57.04793622436956,"d":"57.048"},{"v":84.04793622436955,"d":"84.048"},9,"入闱体检"]
[54,"王钰",null,null,67.5,27,81.94,{"v":83.2565533082822,"d":"83.257"},{"v":49.953931984969316,"d":"49.954"},{"v":76.95393198496932,"d":"76.954"}]
[55,"吴艺婷",null,null,67.5,27,89.34,{"v":88.48243119424065,"d":"88.482"},{"v":53.089458716544385,"d":"53.089"},{"v":80.08945871654439,"d":"80.089"},46,"入闱体检"]
[56,"晏文欣",null,null,67,26.8,84,{"v":85.3496519147633,"d":"85.350"},{"v":51.20979114885798,"d":"51.210"},{"v":78.00979114885799,"d":"78.010"},71,"入闱体检"]
[57,"林鹤莲",null,null,67,26.8,84.36,{"v":81.94691847697558,"d":"81.947"},{"v":49.16815108618535,"d":"49.168"},{"v":75.96815108618534,"d":"75.968"}]
[58,"徐丽雯",null,null,67,26.8,92.38,{"v":91.49325043344471,"d":"91.493"},{"v":54.895950260066826,"d":"54.896"},{"v":81.69595026006682,"d":"81.696"},29,"入闱体检"]
[59,"陈鹏娜",null,null,67,26.8,79.3,{"v":80.60546900777751,"d":"80.605"},{"v":48.36328140466651,"d":"48.363"},{"v":75.1632814046665,"d":"75.163"}]
[60,"郭毓",null,null,66.5,26.6,79.24,{"v":80.54448126325713,"d":"80.544"},{"v":48.32668875795427,"d":"48.327"},{"v":74.92668875795428,"d":"74.927"}]
[61,"刘心怡",null,null,66.5,26.6,95.9,{"v":97.47874499175113,"d":"97.479"},{"v":58.487246995050675,"d":"58.487"},{"v":85.08724699505068,"d":"85.087"},5,"入闱体检"]
[62,"周君",null,null,66.5,26.6,73.7,{"v":74.91327951920812,"d":"74.913"},{"v":44.94796771152487,"d":"44.948"},{"v":71.54796771152488,"d":"71.548"}]
[63,"刘媛",null,null,66.5,26.6,87.84,{"v":85.32737457346532,"d":"85.327"},{"v":51.19642474407919,"d":"51.196"},{"v":77.79642474407919,"d":"77.796"}]
[64,"夏文娟",null,null,66.5,26.6,82.12,{"v":81.33173550113098,"d":"81.332"},{"v":48.79904130067859,"d":"48.799"},{"v":75.39904130067859,"d":"75.399"}]
[65,"郭慧",null,null,66,26.4,89.8,{"v":91.27832429884515,"d":"91.278"},{"v":54.76699457930709,"d":"54.767"},{"v":81.16699457930709,"d":"81.167"},33,"入闱体检"]
[66,"郑玉凤",null,null,66,26.4,78.08,{"v":77.33051519639925,"d":"77.331"},{"v":46.398309117839545,"d":"46.398"},{"v":72.79830911783955,"d":"72.798"}]
[67,"胡寒清",null,null,66,26.4,92.78,{"v":94.30738227669103,"d":"94.307"},{"v":56.58442936601462,"d":"56.584"},{"v":82.98442936601462,"d":"82.984"},19,"入闱体检"]
[68,"胡婷婷",null,null,66,26.4,89.7,{"v":88.8389755778306,"d":"88.839"},{"v":53.303385346698356,"d":"53.303"},{"v":79.70338534669835,"d":"79.703"},55,"入闱体检"]
[69,"朱晓美",null,null,65.5,26.2,88.06,{"v":85.541081568071,"d":"85.541"},{"v":51.32464894084259,"d":"51.325"},{"v":77.5246489408426,"d":"77.525"}]
[70,"曾婧",null,null,65.5,26.2,79.7,{"v":78.93496492255406,"d":"78.935"},{"v":47.36097895353243,"d":"47.361"},{"v":73.56097895353244,"d":"73.561"}]
[71,"石雅玲",null,null,65.5,26.2,87.98,{"v":87.13548574512303,"d":"87.135"},{"v":52.28129144707382,"d":"52.281"},{"v":78.48129144707383,"d":"78.481"},65,"入闱体检"]
[72,"胡园园",null,null,65.5,26.200000000000003,80.6,{"v":81.89502314678478,"d":"81.895"},{"v":49.13701388807087,"d":"49.137"},{"v":75.33701388807087,"d":"75.337"}]
[73,"罗欢欢",null,null,65,26,90.6,{"v":89.73033653680548,"d":"89.730"},{"v":53.838201922083286,"d":"53.838"},{"v":79.83820192208329,"d":"79.838"},51,"入闱体检"]
[74,"黎南",null,null,65,26,97.26,{"v":98.86113386754656,"d":"98.861"},{"v":59.31668032052793,"d":"59.317"},{"v":85.31668032052792,"d":"85.317"},4,"入闱体检"]
[75,"张茜茜",null,null,65,26,84.76,{"v":86.12186305113497,"d":"86.122"},{"v":51.67311783068098,"d":"51.673"},{"v":77.67311783068098,"d":"77.673"}]
[76,"樊梅凤",null,null,64.5,25.8,89.68,{"v":88.81916755652006,"d":"88.819"},{"v":53.291500533912036,"d":"53.292"},{"v":79.09150053391204,"d":"79.092"},60,"入闱体检"]
[77,"王玉红",null,null,64.5,25.8,91.74,{"v":89.1158167505659,"d":"89.116"},{"v":53.46949005033954,"d":"53.469"},{"v":79.26949005033954,"d":"79.269"},58,"入闱体检"]
[78,"戴瑶",null,null,64.5,25.8,87.66,{"v":85.15252339606067,"d":"85.153"},{"v":51.0915140376364,"d":"51.092"},{"v":76.8915140376364,"d":"76.892"}]
[79,"朱小燕",null,null,64.5,25.8,92.98,{"v":90.32034708379788,"d":"90.320"},{"v":54.19220825027873,"d":"54.192"},{"v":79.99220825027874,"d":"79.992"},47,"入闱体检"]
[80,"雷馨",null,null,64.5,25.8,79.66,{"v":80.97139547489984,"d":"80.971"},{"v":48.5828372849399,"d":"48.583"},{"v":74.3828372849399,"d":"74.383"}]
[81,"游蕾霞",null,null,64.5,25.8,82.86,{"v":84.19133521020579,"d":"84.191"},{"v":50.51480112612347,"d":"50.515"},{"v":76.31480112612347,"d":"76.315"}]
[82,"肖艳凤",null,null,64.5,25.8,95.34,{"v":92.61284029865875,"d":"92.613"},{"v":55.56770417919525,"d":"55.568"},{"v":81.36770417919526,"d":"81.368"},30,"入闱体检"]
[83,"谢钱英",null,null,64,25.6,84.82,{"v":86.21634150365307,"d":"86.216"},{"v":51.72980490219184,"d":"51.730"},{"v":77.32980490219184,"d":"77.330"}]
[84,"周清",null,null,64,25.6,80.2,{"v":81.48859623290497,"d":"81.489"},{"v":48.89315773974298,"d":"48.893"},{"v":74.49315773974298,"d":"74.493"}]
[85,"李叶红",null,null,64,25.6,86.4,{"v":87.78821339804226,"d":"87.788"},{"v":52.672928038825354,"d":"52.673"},{"v":78.27292803882536,"d":"78.273"},67,"入闱体检"]
[86,"张可欣",null,null,64,25.6,85.72,{"v":87.09728764444655,"d":"87.097"},{"v":52.25837258666793,"d":"52.258"},{"v":77.85837258666794,"d":"77.858"},72,"入闱体检"]
[87,"王宏秋",null,null,64,25.6,92.88,{"v":90.2232075407953,"d":"90.223"},{"v":54.13392452447718,"d":"54.134"},{"v":79.73392452447717,"d":"79.734"},54,"入闱体检"]
[88,"刘美珍",null,null,64,25.6,89.98,{"v":87.40616079372052,"d":"87.406"},{"v":52.44369647623231,"d":"52.444"},{"v":78.04369647623231,"d":"78.044"},68,"入闱体检"]
[89,"孔繁然",null,null,63.5,25.4,80.28,{"v":81.56988161568093,"d":"81.570"},{"v":48.94192896940856,"d":"48.942"},{"v":74.34192896940856,"d":"74.342"}]
[90,"刘茜",null,null,63.5,25.4,86.3,{"v":87.68660666957228,"d":"87.687"},{"v":52.61196400174337,"d":"52.612"},{"v":78.01196400174337,"d":"78.012"},70,"入闱体检"]
[91,"蒋海兰",null,null,63.5,25.4,96.92,{"v":98.51553664859769,"d":"98.516"},{"v":59.10932198915861,"d":"59.109"},{"v":84.50932198915861,"d":"84.509"},8,"入闱体检"]
[92,"冯苗苗",null,null,63.5,25.4,92.98,{"v":92.08749107276131,"d":"92.087"},{"v":55.25249464365678,"d":"55.252"},{"v":80.65249464365678,"d":"80.652"},41,"入闱体检"]
[93,"林红艳",null,null,63.5,25.4,78.74,{"v":80.03625005892057,"d":"80.036"},{"v":48.02175003535234,"d":"48.022"},{"v":73.42175003535235,"d":"73.422"}]
[94,"范小风",null,null,63.5,25.4,83.48,{"v":84.85428187603111,"d":"84.854"},{"v":50.91256912561867,"d":"50.913"},{"v":76.31256912561867,"d":"76.313"}]
[95,"何慧",null,null,63.5,25.4,81.74,{"v":83.05333985134229,"d":"83.053"},{"v":49.83200391080537,"d":"49.832"},{"v":75.23200391080536,"d":"75.232"}]
[96,"郭梁",null,null,63,25.2,92.46,{"v":91.57248251868693,"d":"91.572"},{"v":54.94348951121216,"d":"54.943"},{"v":80.14348951121215,"d":"80.143"},45,"入闱体检"]
[97,"许雅敏",null,null,63,25.200000000000003,86.08,{"v":87.46307186693839,"d":"87.463"},{"v":52.47784312016304,"d":"52.478"},{"v":77.67784312016303,"d":"77.678"}]
[98,"罗惠君",null,null,63,25.2,82.36,{"v":83.71584397831722,"d":"83.716"},{"v":50.22950638699033,"d":"50.230"},{"v":75.42950638699034,"d":"75.430"}]
[99,"曾捡娣",null,null,63,25.2,74.72,{"v":75.95007117605468,"d":"75.950"},{"v":45.57004270563281,"d":"45.570"},{"v":70.77004270563282,"d":"70.770"}]
[100,"叶丽娜",null,null,63,25.2,81.58,{"v":80.79691892574604,"d":"80.797"},{"v":48.47815135544762,"d":"48.478"},{"v":73.67815135544762,"d":"73.678"}]
[101,"曾彩云",null,null,62.5,25,84.14,{"v":85.49190133462123,"d":"85.492"},{"v":51.295140800772735,"d":"51.295"},{"v":76.29514080077274,"d":"76.295"}]
[102,"刘春连",null,null,62.5,25,82.06,{"v":81.27231143719932,"d":"81.272"},{"v":48.76338686231959,"d":"48.763"},{"v":73.76338686231959,"d":"73.763"}]
[103,"刘芳",null,null,62.5,25,83.56,{"v":81.16980213295494,"d":"81.170"},{"v":48.70188127977296,"d":"48.702"},{"v":73.70188127977296,"d":"73.702"}]
[104,"彭静",null,null,62,24.8,88.4,{"v":89.82034796744138,"d":"89.820"},{"v":53.89220878046483,"d":"53.892"},{"v":78.69220878046482,"d":"78.692"},64,"入闱体检"]
[105,"刘宁静",null,null,62,24.8,89.1,{"v":88.244734938514,"d":"88.245"},{"v":52.9468409631084,"d":"52.947"},{"v":77.7468409631084,"d":"77.747"}]
[106,"曾淑慧",null,null,62,24.8,78.22,{"v":77.46917134557313,"d":"77.469"},{"v":46.48150280734388,"d":"46.482"},{"v":71.28150280734388,"d":"71.282"}]
[107,"陈丽",null,null,62,24.8,78.98,{"v":78.22187615537415,"d":"78.222"},{"v":46.93312569322449,"d":"46.933"},{"v":71.7331256932245,"d":"71.733"}]
[108,"肖绮",null,null,62,24.8,79.9,{"v":79.13304513565959,"d":"79.133"},{"v":47.47982708139575,"d":"47.480"},{"v":72.27982708139575,"d":"72.280"}]
[109,"林敏",null,null,61.5,24.6,85.22,{"v":82.78231854679775,"d":"82.782"},{"v":49.66939112807865,"d":"49.669"},{"v":74.26939112807865,"d":"74.269"}]
[110,"王蔚铭",null,null,61.5,24.6,84.86,{"v":84.04543442067676,"d":"84.045"},{"v":50.427260652406055,"d":"50.427"},{"v":75.02726065240606,"d":"75.027"}]
[111,"夏慧敏",null,null,61.5,24.6,76.98,{"v":74.77802020338525,"d":"74.778"},{"v":44.86681212203115,"d":"44.867"},{"v":69.46681212203114,"d":"69.467"}]
[112,"王蓉",null,null,61,24.4,80.58,{"v":78.2750437514781,"d":"78.275"},{"v":46.96502625088686,"d":"46.965"},{"v":71.36502625088686,"d":"71.365"}]
[113,"周玉葵",null,null,61,24.4,91.02,{"v":88.41641204094734,"d":"88.416"},{"v":53.0498472245684,"d":"53.050"},{"v":77.4498472245684,"d":"77.450"}]
[114,"周丽琴",null,null,61,24.4,75.4,{"v":76.61147326634706,"d":"76.611"},{"v":45.966883959808236,"d":"45.967"},{"v":70.36688395980823,"d":"70.367"}]
[115,"李超然",null,null,61,24.4,87.3,{"v":88.73716827716238,"d":"88.737"},{"v":53.24230096629743,"d":"53.242"},{"v":77.64230096629743,"d":"77.642"}]
[116,"康凤",null,null,61,24.4,82.22,{"v":79.86813225672039,"d":"79.868"},{"v":47.92087935403223,"d":"47.921"},{"v":72.32087935403223,"d":"72.321"}]
[117,"蒋怡静",null,null,61,24.4,84.8,{"v":86.16250574252295,"d":"86.163"},{"v":51.69750344551377,"d":"51.698"},{"v":76.09750344551377,"d":"76.098"}]
[118,"曾素云",null,null,61,24.4,89.62,{"v":88.75974349258838,"d":"88.760"},{"v":53.25584609555303,"d":"53.256"},{"v":77.65584609555303,"d":"77.656"}]
[119,"于璐",null,null,60.5,24.2,84.82,{"v":84.00581837805564,"d":"84.006"},{"v":50.40349102683338,"d":"50.403"},{"v":74.60349102683338,"d":"74.603"}]
[120,"李莉红",null,null,60.5,24.2,93.68,{"v":91.00032388481594,"d":"91.000"},{"v":54.600194330889565,"d":"54.600"},{"v":78.80019433088957,"d":"78.800"},62,"入闱体检"]
[121,"吴琼",null,null,60,24,85.1,{"v":86.50095097808155,"d":"86.501"},{"v":51.90057058684893,"d":"51.901"},{"v":75.90057058684893,"d":"75.901"}]
[122,"万雅芳",null,null,60,24,87.26,{"v":86.42239697794312,"d":"86.422"},{"v":51.85343818676587,"d":"51.853"},{"v":75.85343818676587,"d":"75.853"}]
[123,"吴姝琪",null,null,60,24,90.56,{"v":89.69072049418439,"d":"89.691"},{"v":53.81443229651063,"d":"53.814"},{"v":77.81443229651063,"d":"77.814"}]
[124,"叶琪",null,null,60,24,87.46,{"v":84.95824431005552,"d":"84.958"},{"v":50.97494658603331,"d":"50.975"},{"v":74.97494658603331,"d":"74.975"}]
[125,"彭文娟",null,null,60,24,86.48,{"v":87.90366910205044,"d":"87.904"},{"v":52.742201461230266,"d":"52.742"},{"v":76.74220146123027,"d":"76.742"}]
[126,"余勤",null,null,59.5,23.8,82.74,{"v":84.102099693613,"d":"84.102"},{"v":50.4612598161678,"d":"50.461"},{"v":74.2612598161678,"d":"74.261"}]
[127,"钟莉兰",null,null,59.5,23.8,0,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":23.8,"d":"23.800"},null,"缺考"]
[128,"张薇",null,null,59.5,23.8,81.94,{"v":83.2565533082822,"d":"83.257"},{"v":49.953931984969316,"d":"49.954"},{"v":73.75393198496931,"d":"73.754"},null,96.03]
[129,"陈章莉",null,null,59.5,23.8,85.22,{"v":86.58925400209677,"d":"86.589"},{"v":51.95355240125806,"d":"51.954"},{"v":75.75355240125806,"d":"75.754"}]
[130,"甘瑶",null,null,59.5,23.8,64.54,{"v":65.60248385576244,"d":"65.602"},{"v":39.361490313457466,"d":"39.361"},{"v":63.16149031345746,"d":"63.161"}]
[131,"谢方芳",null,null,59.5,23.8,77.08,{"v":78.34892246052321,"d":"78.349"},{"v":47.009353476313926,"d":"47.009"},{"v":70.80935347631393,"d":"70.809"}]
[132,"卢莹",null,null,59.5,23.8,84.22,{"v":85.5731867173972,"d":"85.573"},{"v":51.343912030438325,"d":"51.344"},{"v":75.14391203043833,"d":"75.144"}]
[133,"冯燕",null,null,59.5,23.8,87.6,{"v":86.75913334022252,"d":"86.759"},{"v":52.05548000413351,"d":"52.055"},{"v":75.85548000413351,"d":"75.855"}]
[134,"赖地秀",null,null,59.5,23.8,81.84,{"v":79.49900199331059,"d":"79.499"},{"v":47.69940119598635,"d":"47.699"},{"v":71.49940119598635,"d":"71.499"}]
[135,"叶慧萍",null,null,59.5,23.8,92.44,{"v":91.55267449737637,"d":"91.553"},{"v":54.93160469842582,"d":"54.932"},{"v":78.73160469842583,"d":"78.732"},63,"入闱体检"]
[136,"罗嘉欣",null,null,59,23.6,86.78,{"v":88.20860782465238,"d":"88.209"},{"v":52.92516469479143,"d":"52.925"},{"v":76.52516469479143,"d":"76.525"}]
[137,"刘婷",null,null,59,23.6,85.84,{"v":87.25313316049966,"d":"87.253"},{"v":52.35187989629979,"d":"52.352"},{"v":75.9518798962998,"d":"75.952"},null,97.11]
[138,"邱丽",null,null,59,23.6,76.42,{"v":74.23403876257082,"d":"74.234"},{"v":44.54042325754249,"d":"44.540"},{"v":68.1404232575425,"d":"68.140"}]
[139,"龙媛",null,null,59,23.6,89.28,{"v":90.71448717797699,"d":"90.714"},{"v":54.428692306786196,"d":"54.429"},{"v":78.0286923067862,"d":"78.029"},69,"入闱体检"]

{"sheet":" 应届岗","index":1,"n_rows":43,"n_cols":11,"rows_kept":43,"merged":[[0,0,0,10],[1,1,1,9],[3,0,4,0],[3,1,4,1],[3,2,3,5],[3,6,3,7],[3,8,4,8],[3,9,4,9],[3,10,4,10]],"flags":["formulas_cached_only"]}
["2020年泰和县全省统一招聘教师考试总成绩汇总表"]
[null,"（招录19人）"]
[null,"学科：幼儿园（应届岗）"]
["序号","姓 名","笔试折算成绩×40%",{"$nulls":3},"面试成绩（占60%）",null,"总成绩","总分\n排名","备注"]
[null,null,"综合知识成绩","学科专业成绩","笔试成绩","笔试折算分","面试成绩","面试折算分"]
[1,"贺姜红",null,null,76.5,30.6,79.04,47.424,78.024,9,"入闱体检"]
[2,"阮佳欣",null,null,74,29.6,85.6,51.35999999999999,80.96,1,"入闱体检"]
[3,"尹英红",null,null,72,28.8,80.38,48.227999999999994,77.02799999999999,10,"入闱体检"]
[4,"张荆晶",null,null,72,28.8,84.44,50.663999999999994,79.464,2,"入闱体检"]
[5,"陈至怡",null,null,72,28.8,82.12,49.272,78.072,7,"入闱体检"]
[6,"刘佳琪",null,null,70.5,28.200000000000003,83.04,49.824000000000005,78.024,8,"入闱体检"]
[7,"刘敏逸",null,null,69.5,27.8,79.08,47.448,75.248,14,"入闱体检"]
[8,"肖琴",null,null,69.5,27.8,83.86,50.315999999999995,78.116,6,"入闱体检"]
[9,"陈欣格",null,null,69,27.6,81.04,48.624,76.224,11,"入闱体检"]
[10,"叶卉霞",null,null,69,27.6,80.3,48.18,75.78,13,"入闱体检"]
[11,"王诗敏",null,null,68.5,27.400000000000002,84.76,50.856,78.256,4,"入闱体检"]
[12,"万婧月",null,null,68.5,27.400000000000002,86.44,51.864,79.264,3,"入闱体检"]
[13,"颜小锋",null,null,67.5,27,77.86,46.716,73.71600000000001,16,"入闱体检"]
[14,"黄桂菊",null,null,65,26,78.24,46.943999999999996,72.94399999999999,18,"入闱体检"]
[15,"邱浮萍",null,null,63,25.200000000000003,84.44,50.663999999999994,75.864,12,"入闱体检"]
[16,"肖兰",null,null,63,25.200000000000003,"缺考",null,25.200000000000003]
[17,"郭佳音",null,null,61.5,24.6,78.5,47.1,71.7]
[18,"龙玮",null,null,60.5,24.200000000000003,90.04,54.024,78.224,5,"入闱体检"]
[19,"刘珑娟",null,null,60.5,24.200000000000003,82.84,49.704,73.904,15,"入闱体检"]
[20,"王文静",null,null,60,24,77.14,46.284,70.28399999999999]
[21,"欧阳检妹",null,null,60,24,82.76,49.656,73.656,17,"入闱体检"]
[22,"康笑",null,null,58.5,23.400000000000002,72.2,43.32,66.72]
[23,"李敏",null,null,58.5,23.400000000000002,72.38,43.428,66.828]
[24,"刘紫静",null,null,57,22.8,82.92,49.752,72.552,19,"入闱体检"]
[25,"周祺",null,null,56.5,22.6,75.02,45.01199999999999,67.612]
[26,"饶秋芳",null,null,55.5,22.200000000000003,74.18,44.508,66.708]
[27,"周玲妮",null,null,55,22,79.86,47.916,69.916]
[28,"张学霜",null,null,54.5,21.8,78.48,47.088,68.888]
[29,"郭园园",null,null,54.5,21.8,73.2,43.92,65.72]
[30,"孙怡",null,null,53.5,21.400000000000002,80.46,48.275999999999996,69.676]
[31,"胡佳馨",null,null,53.5,21.400000000000002,70.68,42.408,63.80800000000001]
[32,"彭丽芬",null,null,53,21.200000000000003,70.84,42.504,63.704]
[33,"曾婷",null,null,53,21.200000000000003,85.14,51.083999999999996,72.28399999999999]
[34,"郭奇娜",null,null,52.5,21,77.12,46.272,67.27199999999999]
[35,"谢依萍",null,null,52.5,21,77.58,46.547999999999995,67.548]
[36,"李芳",null,null,52.5,21,64.4,38.64,59.64]
[37,"傅小丹",null,null,52,20.8,"缺考",null,20.8]
[38,"张玉荣",null,null,52,20.8,75.7,45.42,66.22]

{"sheet":"1组","index":2,"n_rows":40,"n_cols":13,"rows_kept":40,"merged":[[0,0,0,11],[1,1,1,10],[3,0,4,0],[3,1,4,1],[3,2,3,5],[3,6,3,8],[3,9,4,9],[3,10,4,10],[3,11,4,11]],"flags":["formulas_cached_only"]}
["2020年泰和县全省统一招聘教师考试总成绩汇总表"]
[null,"（招录72人）"]
[null,"学科：幼儿园"]
["序号","姓 名","笔试折算成绩×40%",{"$nulls":3},"面试成绩（占60%）",null,null,"考试总\n成绩","总分\n排名","备注"]
[null,null,"综合知识成绩","学科专业成绩","总成绩","笔试折算分","面试成绩","修正后的面试成绩","面试折算分"]
[103,"刘芳",null,null,62.5,25,83.56,{"v":81.16980213295494,"d":"81.170"},{"v":48.70188127977296,"d":"48.702"},{"v":73.70188127977296,"d":"73.702"},null,null,1]
[138,"邱丽",null,null,59,23.6,76.42,{"v":74.23403876257082,"d":"74.234"},{"v":44.54042325754249,"d":"44.540"},{"v":68.1404232575425,"d":"68.140"},null,null,2]
[82,"肖艳凤",null,null,64.5,25.8,95.34,{"v":92.61284029865875,"d":"92.613"},{"v":55.56770417919525,"d":"55.568"},{"v":81.36770417919526,"d":"81.368"},null,null,3]
[120,"李莉红",null,null,60.5,24.200000000000003,93.68,{"v":91.00032388481594,"d":"91.000"},{"v":54.600194330889565,"d":"54.600"},{"v":78.80019433088957,"d":"78.800"},null,null,4]
[109,"林敏",null,null,61.5,24.6,85.22,{"v":82.78231854679775,"d":"82.782"},{"v":49.66939112807865,"d":"49.669"},{"v":74.26939112807865,"d":"74.269"},null,null,5]
[3,"刘沙沙",null,null,79,31.6,89,{"v":86.45419327229524,"d":"86.454"},{"v":51.87251596337715,"d":"51.873"},{"v":83.47251596337715,"d":"83.473"},null,null,6]
[33,"张馨月",null,null,70,28,93.34,{"v":90.67004943860717,"d":"90.670"},{"v":54.4020296631643,"d":"54.402"},{"v":82.4020296631643,"d":"82.402"},null,null,7]
[77,"王玉红",null,null,64.5,25.8,91.74,{"v":89.1158167505659,"d":"89.116"},{"v":53.46949005033954,"d":"53.469"},{"v":79.26949005033954,"d":"79.269"},null,null,8]
[134,"赖地秀",null,null,59.5,23.8,81.84,{"v":79.49900199331059,"d":"79.499"},{"v":47.69940119598635,"d":"47.699"},{"v":71.49940119598635,"d":"71.499"},null,null,9]
[15,"肖丹",null,null,73.5,29.400000000000002,90.52,{"v":87.93071432593443,"d":"87.931"},{"v":52.75842859556066,"d":"52.758"},{"v":82.15842859556066,"d":"82.158"},null,null,10]
[112,"王蓉",null,null,61,24.400000000000002,80.58,{"v":78.2750437514781,"d":"78.275"},{"v":46.96502625088686,"d":"46.965"},{"v":71.36502625088686,"d":"71.365"},null,null,11]
[52,"毛婷",null,null,67.5,27,89.02,{"v":86.47362118089575,"d":"86.474"},{"v":51.88417270853745,"d":"51.884"},{"v":78.88417270853745,"d":"78.884"},null,null,12]
[88,"刘美珍",null,null,64,25.6,89.98,{"v":87.40616079372052,"d":"87.406"},{"v":52.44369647623231,"d":"52.444"},{"v":78.04369647623231,"d":"78.044"},null,null,13]
[13,"徐友红",null,null,74,29.6,79.98,{"v":77.69220649346262,"d":"77.692"},{"v":46.61532389607757,"d":"46.615"},{"v":76.21532389607756,"d":"76.215"},null,null,14]
[78,"戴瑶",null,null,64.5,25.8,87.66,{"v":85.15252339606067,"d":"85.153"},{"v":51.0915140376364,"d":"51.092"},{"v":76.8915140376364,"d":"76.892"},null,null,15]
[79,"朱小燕",null,null,64.5,25.8,92.98,{"v":90.32034708379788,"d":"90.320"},{"v":54.19220825027873,"d":"54.192"},{"v":79.99220825027874,"d":"79.992"},null,null,16]
[57,"林鹤莲",null,null,67,26.8,84.36,{"v":81.94691847697558,"d":"81.947"},{"v":49.16815108618535,"d":"49.168"},{"v":75.96815108618534,"d":"75.968"},null,null,17]
[87,"王宏秋",null,null,64,25.6,92.88,{"v":90.2232075407953,"d":"90.223"},{"v":54.13392452447718,"d":"54.134"},{"v":79.73392452447717,"d":"79.734"},null,null,18]
[40,"夏倩文",null,null,69.5,27.8,93.96,{"v":91.27231460522314,"d":"91.272"},{"v":54.76338876313388,"d":"54.763"},{"v":82.56338876313389,"d":"82.563"},null,null,19]
[69,"朱晓美",null,null,65.5,26.200000000000003,88.06,{"v":85.541081568071,"d":"85.541"},{"v":51.32464894084259,"d":"51.325"},{"v":77.5246489408426,"d":"77.525"},null,null,20]
[46,"谢雨薇",null,null,68.5,27.400000000000002,91.12,{"v":88.51355158394992,"d":"88.514"},{"v":53.10813095036995,"d":"53.108"},{"v":80.50813095036995,"d":"80.508"},null,null,21]
[19,"龙小芳",null,null,73,29.200000000000003,93.28,{"v":90.61176571280562,"d":"90.612"},{"v":54.36705942768337,"d":"54.367"},{"v":83.56705942768338,"d":"83.567"},null,null,22]
[124,"叶琪",null,null,60,24,87.46,{"v":84.95824431005552,"d":"84.958"},{"v":50.97494658603331,"d":"50.975"},{"v":74.97494658603331,"d":"74.975"},null,null,23]
[127,"钟莉兰",null,null,59.5,23.8,0,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":23.8,"d":"23.800"},null,"缺考",24]
[49,"刘婧",null,null,68.5,27.400000000000002,88.7,{"v":86.1627746432875,"d":"86.163"},{"v":51.6976647859725,"d":"51.698"},{"v":79.0976647859725,"d":"79.098"},null,null,25]
[22,"刘笑寒",null,null,72.5,29,89.68,{"v":87.11474216471278,"d":"87.115"},{"v":52.268845298827664,"d":"52.269"},{"v":81.26884529882767,"d":"81.269"},null,null,26]
[9,"杜桃花",null,null,75.5,30.200000000000003,91.2,{"v":88.59126321835198,"d":"88.591"},{"v":53.15475793101119,"d":"53.155"},{"v":83.35475793101119,"d":"83.355"},null,null,27]
[21,"旷荷仙",null,null,72.5,29,92.38,{"v":89.7375098257824,"d":"89.738"},{"v":53.842505895469436,"d":"53.843"},{"v":82.84250589546943,"d":"82.843"},null,null,28]
[116,"康凤",null,null,61,24.400000000000002,82.22,{"v":79.86813225672039,"d":"79.868"},{"v":47.92087935403223,"d":"47.921"},{"v":72.32087935403223,"d":"72.321"},null,null,29]
[37,"邹鹏",null,null,69.5,27.8,91.42,{"v":88.80497021295766,"d":"88.805"},{"v":53.282982127774595,"d":"53.283"},{"v":81.0829821277746,"d":"81.083"},null,null,30]
[47,"郭丹",null,null,68.5,27.400000000000002,90.14,{"v":87.56158406252464,"d":"87.562"},{"v":52.53695043751478,"d":"52.537"},{"v":79.93695043751478,"d":"79.937"},null,null,31]
[63,"刘媛",null,null,66.5,26.6,87.84,{"v":85.32737457346532,"d":"85.327"},{"v":51.19642474407919,"d":"51.196"},{"v":77.79642474407919,"d":"77.796"},null,null,32]
[111,"夏慧敏",null,null,61.5,24.6,76.98,{"v":74.77802020338525,"d":"74.778"},{"v":44.86681212203115,"d":"44.867"},{"v":69.46681212203114,"d":"69.467"},null,null,33]
[18,"刘巧珍",null,null,73,29.200000000000003,93.06,{"v":90.39805871819995,"d":"90.398"},{"v":54.23883523091997,"d":"54.239"},{"v":83.43883523091998,"d":"83.439"},null,null,34]
[113,"周玉葵",null,null,61,24.400000000000002,91.02,{"v":88.41641204094734,"d":"88.416"},{"v":53.0498472245684,"d":"53.050"},{"v":77.4498472245684,"d":"77.450"},null,null,35]

{"sheet":"2组","index":3,"n_rows":40,"n_cols":13,"rows_kept":40,"merged":[[0,0,0,11],[1,1,1,10],[3,0,4,0],[3,1,4,1],[3,2,3,5],[3,6,3,8],[3,9,4,9],[3,10,4,10],[3,11,4,11],[3,12,4,12]],"flags":["formulas_cached_only"]}
["2020年泰和县全省统一招聘教师考试总成绩汇总表"]
[null,"（招录72人）"]
[null,"学科：幼儿园"]
["序号","姓 名","笔试折算成绩×40%",{"$nulls":3},"面试成绩（占60%）",null,null,"考试总\n成绩","总分\n排名","备注"]
[null,null,"综合知识成绩","学科专业成绩","总成绩","笔试折算分","面试成绩","修正后的面试成绩","面试折算分"]
[123,"吴姝琪",null,null,60,24,90.56,{"v":89.69072049418439,"d":"89.691"},{"v":53.81443229651063,"d":"53.814"},{"v":77.81443229651063,"d":"77.814"},null,null,1]
[14,"李丹",null,null,73.5,29.400000000000002,91.82,{"v":90.93862583674922,"d":"90.939"},{"v":54.56317550204953,"d":"54.563"},{"v":83.96317550204954,"d":"83.963"},null,null,2]
[66,"郑玉凤",null,null,66,26.400000000000002,78.08,{"v":77.33051519639925,"d":"77.331"},{"v":46.398309117839545,"d":"46.398"},{"v":72.79830911783955,"d":"72.798"},null,null,3]
[106,"曾淑慧",null,null,62,24.8,78.22,{"v":77.46917134557313,"d":"77.469"},{"v":46.48150280734388,"d":"46.482"},{"v":71.28150280734388,"d":"71.282"},null,null,4]
[73,"罗欢欢",null,null,65,26,90.6,{"v":89.73033653680548,"d":"89.730"},{"v":53.838201922083286,"d":"53.838"},{"v":79.83820192208329,"d":"79.838"},null,null,5]
[119,"于璐",null,null,60.5,24.200000000000003,84.82,{"v":84.00581837805564,"d":"84.006"},{"v":50.40349102683338,"d":"50.403"},{"v":74.60349102683338,"d":"74.603"},null,null,6]
[96,"郭梁",null,null,63,25.200000000000003,92.46,{"v":91.57248251868693,"d":"91.572"},{"v":54.94348951121216,"d":"54.943"},{"v":80.14348951121215,"d":"80.143"},null,null,7]
[38,"杨文娟",null,null,69.5,27.8,87.46,{"v":86.62047719104865,"d":"86.620"},{"v":51.97228631462919,"d":"51.972"},{"v":79.77228631462918,"d":"79.772"},null,null,8]
[122,"万雅芳",null,null,60,24,87.26,{"v":86.42239697794312,"d":"86.422"},{"v":51.85343818676587,"d":"51.853"},{"v":75.85343818676587,"d":"75.853"},null,null,9]
[51,"白晓露",null,null,68,27.200000000000003,90,{"v":89.1360958974889,"d":"89.136"},{"v":53.48165753849334,"d":"53.482"},{"v":80.68165753849334,"d":"80.682"},null,null,10]
[92,"冯苗苗",null,null,63.5,25.400000000000002,92.98,{"v":92.08749107276131,"d":"92.087"},{"v":55.25249464365678,"d":"55.252"},{"v":80.65249464365678,"d":"80.652"},null,null,11]
[6,"杨梦莹",null,null,77,30.8,89.36,{"v":88.5022392155512,"d":"88.502"},{"v":53.10134352933072,"d":"53.101"},{"v":83.90134352933072,"d":"83.901"},null,null,12]
[107,"陈丽",null,null,62,24.8,78.98,{"v":78.22187615537415,"d":"78.222"},{"v":46.93312569322449,"d":"46.933"},{"v":71.7331256932245,"d":"71.733"},null,null,13]
[102,"刘春连",null,null,62.5,25,82.06,{"v":81.27231143719932,"d":"81.272"},{"v":48.76338686231959,"d":"48.763"},{"v":73.76338686231959,"d":"73.763"},null,null,14]
[7,"刘金花",null,null,77,30.8,84.8,{"v":83.98601035674508,"d":"83.986"},{"v":50.39160621404705,"d":"50.392"},{"v":81.19160621404706,"d":"81.192"},null,null,15]
[100,"叶丽娜",null,null,63,25.200000000000003,81.58,{"v":80.79691892574604,"d":"80.797"},{"v":48.47815135544762,"d":"48.478"},{"v":73.67815135544762,"d":"73.678"},null,null,16]
[118,"曾素云",null,null,61,24.400000000000002,89.62,{"v":88.75974349258838,"d":"88.760"},{"v":53.25584609555303,"d":"53.256"},{"v":77.65584609555303,"d":"77.656"},null,null,17]
[12,"吴静",null,null,74,29.6,84.1,{"v":83.29272961087572,"d":"83.293"},{"v":49.97563776652543,"d":"49.976"},{"v":79.57563776652543,"d":"79.576"},null,null,18]
[71,"石雅玲",null,null,65.5,26.200000000000003,87.98,{"v":87.13548574512303,"d":"87.135"},{"v":52.28129144707382,"d":"52.281"},{"v":78.48129144707383,"d":"78.481"},null,null,19]
[70,"曾婧",null,null,65.5,26.200000000000003,79.7,{"v":78.93496492255406,"d":"78.935"},{"v":47.36097895353243,"d":"47.361"},{"v":73.56097895353244,"d":"73.561"},null,null,20]
[133,"冯燕",null,null,59.5,23.8,87.6,{"v":86.75913334022252,"d":"86.759"},{"v":52.05548000413351,"d":"52.055"},{"v":75.85548000413351,"d":"75.855"},null,null,21]
[55,"吴艺婷",null,null,67.5,27,89.34,{"v":88.48243119424065,"d":"88.482"},{"v":53.089458716544385,"d":"53.089"},{"v":80.08945871654439,"d":"80.089"},null,null,22]
[8,"孙小娟",null,null,75.5,30.200000000000003,91.82,{"v":90.93862583674922,"d":"90.939"},{"v":54.56317550204953,"d":"54.563"},{"v":84.76317550204953,"d":"84.763"},null,null,23]
[27,"熊玉",null,null,71.5,28.6,87.24,{"v":86.40258895663257,"d":"86.403"},{"v":51.84155337397954,"d":"51.842"},{"v":80.44155337397954,"d":"80.442"},null,null,24]
[58,"徐丽雯",null,null,67,26.8,92.38,{"v":91.49325043344471,"d":"91.493"},{"v":54.895950260066826,"d":"54.896"},{"v":81.69595026006682,"d":"81.696"},null,null,25]
[64,"夏文娟",null,null,66.5,26.6,82.12,{"v":81.33173550113098,"d":"81.332"},{"v":48.79904130067859,"d":"48.799"},{"v":75.39904130067859,"d":"75.399"},null,null,26]
[68,"胡婷婷",null,null,66,26.400000000000002,89.7,{"v":88.8389755778306,"d":"88.839"},{"v":53.303385346698356,"d":"53.303"},{"v":79.70338534669835,"d":"79.703"},null,null,27]
[135,"叶慧萍",null,null,59.5,23.8,92.44,{"v":91.55267449737637,"d":"91.553"},{"v":54.93160469842582,"d":"54.932"},{"v":78.73160469842583,"d":"78.732"},null,null,28]
[16,"黄云玲",null,null,73,29.200000000000003,87.2,{"v":86.36297291401146,"d":"86.363"},{"v":51.817783748406875,"d":"51.818"},{"v":81.01778374840688,"d":"81.018"},null,null,29]
[108,"肖绮",null,null,62,24.8,79.9,{"v":79.13304513565959,"d":"79.133"},{"v":47.47982708139575,"d":"47.480"},{"v":72.27982708139575,"d":"72.280"},null,null,30]
[42,"康婷",null,null,69,27.6,83.8,{"v":82.99560929121743,"d":"82.996"},{"v":49.797365574730456,"d":"49.797"},{"v":77.39736557473046,"d":"77.397"},null,null,31]
[110,"王蔚铭",null,null,61.5,24.6,84.86,{"v":84.04543442067676,"d":"84.045"},{"v":50.427260652406055,"d":"50.427"},{"v":75.02726065240606,"d":"75.027"},null,null,32]
[76,"樊梅凤",null,null,64.5,25.8,89.68,{"v":88.81916755652006,"d":"88.819"},{"v":53.291500533912036,"d":"53.292"},{"v":79.09150053391204,"d":"79.092"},null,null,33]
[105,"刘宁静",null,null,62,24.8,89.1,{"v":88.244734938514,"d":"88.245"},{"v":52.9468409631084,"d":"52.947"},{"v":77.7468409631084,"d":"77.747"},null,null,34]
[2,"肖慧",null,null,79.5,31.8,92,{"v":91.1168980285442,"d":"91.117"},{"v":54.67013881712652,"d":"54.670"},{"v":86.47013881712653,"d":"86.470"},null,null,35]

{"sheet":"3组","index":4,"n_rows":39,"n_cols":10,"rows_kept":39,"merged":[[2,0,3,0],[2,1,3,1],[2,4,2,6],[2,7,3,7],[2,8,3,8],[2,9,3,9]],"flags":["formulas_cached_only"]}
[null,"（招录72人）"]
[null,"学科：幼儿园"]
["序号","姓 名",null,null,"面试成绩（占60%）",null,null,"考试总\n成绩","总分\n排名","备注"]
[null,null,"总成绩","笔试折算分","面试成绩","修正后的面试成绩","面试折算分"]
[84,"周清",64,25.6,80.2,{"v":81.48859623290497,"d":"81.489"},{"v":48.89315773974298,"d":"48.893"},{"v":74.49315773974298,"d":"74.493"},null,1]
[72,"胡园园",65.5,26.200000000000003,80.6,{"v":81.89502314678478,"d":"81.895"},{"v":49.13701388807087,"d":"49.137"},{"v":75.33701388807087,"d":"75.337"},null,2]
[17,"杨慧",73,29.200000000000003,83.3,{"v":84.6384048154736,"d":"84.638"},{"v":50.78304288928416,"d":"50.783"},{"v":79.98304288928416,"d":"79.983"},null,3]
[75,"张茜茜",65,26,84.76,{"v":86.12186305113497,"d":"86.122"},{"v":51.67311783068098,"d":"51.673"},{"v":77.67311783068098,"d":"77.673"},null,4]
[29,"曾婷",70.5,28.200000000000003,77.52,{"v":78.76553590991013,"d":"78.766"},{"v":47.25932154594607,"d":"47.259"},{"v":75.45932154594607,"d":"75.459"},null,5]
[81,"游蕾霞",64.5,25.8,82.86,{"v":84.19133521020579,"d":"84.191"},{"v":50.51480112612347,"d":"50.515"},{"v":76.31480112612347,"d":"76.315"},null,6]
[104,"彭静",62,24.8,88.4,{"v":89.82034796744138,"d":"89.820"},{"v":53.89220878046483,"d":"53.892"},{"v":78.69220878046482,"d":"78.692"},null,7]
[25,"肖海英",72,28.8,88.48,{"v":89.90163335021735,"d":"89.902"},{"v":53.94098001013041,"d":"53.941"},{"v":82.74098001013041,"d":"82.741"},null,8]
[86,"张可欣",64,25.6,85.72,{"v":87.09728764444655,"d":"87.097"},{"v":52.25837258666793,"d":"52.258"},{"v":77.85837258666794,"d":"77.858"},null,9]
[44,"严萍筠",69,27.6,81.7,{"v":83.01269715995431,"d":"83.013"},{"v":49.80761829597259,"d":"49.808"},{"v":77.40761829597258,"d":"77.408"},null,10]
[36,"曾香",70,28,84.88,{"v":86.24379112529891,"d":"86.244"},{"v":51.74627467517934,"d":"51.746"},{"v":79.74627467517934,"d":"79.746"},null,11]
[129,"陈章莉",59.5,23.8,85.22,{"v":86.58925400209677,"d":"86.589"},{"v":51.95355240125806,"d":"51.954"},{"v":75.75355240125806,"d":"75.754"},null,12]
[1,"章艳玲",81,32.4,87.22,{"v":88.62138857149588,"d":"88.621"},{"v":53.17283314289753,"d":"53.173"},{"v":85.57283314289754,"d":"85.573"},null,13]
[30,"张鹃",70.5,28.200000000000003,85.84,{"v":87.2192157186105,"d":"87.219"},{"v":52.331529431166295,"d":"52.332"},{"v":80.53152943116629,"d":"80.532"},null,14]
[97,"许雅敏",63,25.200000000000003,86.08,{"v":87.46307186693839,"d":"87.463"},{"v":52.47784312016304,"d":"52.478"},{"v":77.67784312016303,"d":"77.678"},null,15]
[24,"肖钰莹",72,28.8,89.38,{"v":90.81609390644694,"d":"90.816"},{"v":54.48965634386816,"d":"54.490"},{"v":83.28965634386816,"d":"83.290"},null,16]
[89,"孔繁然",63.5,25.4,80.28,{"v":81.56988161568093,"d":"81.570"},{"v":48.94192896940856,"d":"48.942"},{"v":74.34192896940856,"d":"74.342"},null,17]
[35,"罗吉梅",70,28,86.7,{"v":88.09303358345213,"d":"88.093"},{"v":52.855820150071274,"d":"52.856"},{"v":80.85582015007128,"d":"80.856"},null,18]
[34,"杨博彬",70,28,87.14,{"v":88.54010318871993,"d":"88.540"},{"v":53.124061913231955,"d":"53.124"},{"v":81.12406191323196,"d":"81.124"},null,19]
[31,"任逸",70,28,86.64,{"v":88.03206954637015,"d":"88.032"},{"v":52.81924172782209,"d":"52.819"},{"v":80.81924172782209,"d":"80.819"},null,20]
[132,"卢莹",59.5,23.8,84.22,{"v":85.5731867173972,"d":"85.573"},{"v":51.343912030438325,"d":"51.344"},{"v":75.14391203043833,"d":"75.144"},null,21]
[139,"龙媛",59,23.6,89.28,{"v":90.71448717797699,"d":"90.714"},{"v":54.428692306786196,"d":"54.429"},{"v":78.0286923067862,"d":"78.029"},null,22]
[54,"王钰",67.5,27,81.94,{"v":83.2565533082822,"d":"83.257"},{"v":49.953931984969316,"d":"49.954"},{"v":76.95393198496932,"d":"76.954"},null,23]
[95,"何慧",63.5,25.4,81.74,{"v":83.05333985134229,"d":"83.053"},{"v":49.83200391080537,"d":"49.832"},{"v":75.23200391080536,"d":"75.232"},null,24]
[101,"曾彩云",62.5,25,84.14,{"v":85.49190133462123,"d":"85.492"},{"v":51.295140800772735,"d":"51.295"},{"v":76.29514080077274,"d":"76.295"},null,25]
[85,"李叶红",64,25.6,86.4,{"v":87.78821339804226,"d":"87.788"},{"v":52.672928038825354,"d":"52.673"},{"v":78.27292803882536,"d":"78.273"},null,26]
[43,"刘东琴",69,27.6,85.8,{"v":87.17857302722251,"d":"87.179"},{"v":52.30714381633351,"d":"52.307"},{"v":79.9071438163335,"d":"79.907"},null,27]
[117,"蒋怡静",61,24.4,84.8,{"v":86.16250574252295,"d":"86.163"},{"v":51.69750344551377,"d":"51.698"},{"v":76.09750344551377,"d":"76.098"},null,28]
[45,"郭木华",68.5,27.4,85.72,{"v":87.09728764444655,"d":"87.097"},{"v":52.25837258666793,"d":"52.258"},{"v":79.65837258666792,"d":"79.658"},null,29]
[90,"刘茜",63.5,25.4,86.3,{"v":87.68660666957228,"d":"87.687"},{"v":52.61196400174337,"d":"52.612"},{"v":78.01196400174337,"d":"78.012"},null,30]
[114,"周丽琴",61,24.4,75.4,{"v":76.61147326634706,"d":"76.611"},{"v":45.966883959808236,"d":"45.967"},{"v":70.36688395980823,"d":"70.367"},null,31]
[5,"孙家玉",77.5,31,89.7,{"v":91.14123543755082,"d":"91.141"},{"v":54.68474126253049,"d":"54.685"},{"v":85.68474126253048,"d":"85.685"},null,32]
[20,"谢非",72.5,29,90.1,{"v":91.54766235143063,"d":"91.548"},{"v":54.92859741085838,"d":"54.929"},{"v":83.92859741085837,"d":"83.929"},null,33]
[128,"张薇",59.5,23.8,81.94,{"v":83.2565533082822,"d":"83.257"},{"v":49.953931984969316,"d":"49.954"},{"v":73.75393198496931,"d":"73.754"},null,34]
[56,"晏文欣",67,26.8,84,{"v":85.3496519147633,"d":"85.350"},{"v":51.20979114885798,"d":"51.210"},{"v":78.00979114885799,"d":"78.010"},null,35]

{"sheet":"4组","index":5,"n_rows":39,"n_cols":13,"rows_kept":39,"merged":[[0,0,0,11],[1,1,1,10],[3,0,4,0],[3,1,4,1],[3,2,3,5],[3,6,3,8],[3,9,4,9],[3,10,4,10],[3,11,4,11]],"flags":["formulas_cached_only"]}
["2020年泰和县全省统一招聘教师考试总成绩汇总表"]
[null,"（招录72人）"]
[null,"学科：幼儿园"]
["序号","姓 名","笔试折算成绩×40%",{"$nulls":3},"面试成绩（占60%）",null,null,"总成绩","总分\n排名","备注","出生日期"]
[null,null,"综合知识成绩","学科专业成绩","笔试成绩","笔试折算分","面试成绩","修正后的面试成绩","面试折算分"]
[32,"张薇",null,null,70,28,90.29,{"v":91.77639087909499,"d":"91.776"},{"v":55.06583452745699,"d":"55.066"},{"v":83.06583452745699,"d":"83.066"},null,1,99.09]
[60,"郭毓",null,null,66.5,26.6,79.24,{"v":80.54448126325713,"d":"80.544"},{"v":48.32668875795427,"d":"48.327"},{"v":74.92668875795428,"d":"74.927"},null,2]
[28,"毛珊娟",null,null,71.5,28.6,80.68,{"v":82.00818713174641,"d":"82.008"},{"v":49.204912279047846,"d":"49.205"},{"v":77.80491227904784,"d":"77.805"},null,3]
[126,"余勤",null,null,59.5,23.8,82.74,{"v":84.102099693613,"d":"84.102"},{"v":50.4612598161678,"d":"50.461"},{"v":74.2612598161678,"d":"74.261"},null,4]
[115,"李超然",null,null,61,24.400000000000002,87.3,{"v":88.73716827716238,"d":"88.737"},{"v":53.24230096629743,"d":"53.242"},{"v":77.64230096629743,"d":"77.642"},null,5]
[94,"范小风",null,null,63.5,25.400000000000002,83.48,{"v":84.85428187603111,"d":"84.854"},{"v":50.91256912561867,"d":"50.913"},{"v":76.31256912561867,"d":"76.313"},null,6]
[83,"谢钱英",null,null,64,25.6,84.82,{"v":86.21634150365307,"d":"86.216"},{"v":51.72980490219184,"d":"51.730"},{"v":77.32980490219184,"d":"77.330"},null,7]
[136,"罗嘉欣",null,null,59,23.6,86.78,{"v":88.20860782465238,"d":"88.209"},{"v":52.92516469479143,"d":"52.925"},{"v":76.52516469479143,"d":"76.525"},null,8]
[10,"欧阳倩",null,null,74.5,29.8,86.66,{"v":88.0866323356116,"d":"88.087"},{"v":52.851979401366954,"d":"52.852"},{"v":82.65197940136696,"d":"82.652"},null,9]
[80,"雷馨",null,null,64.5,25.8,79.66,{"v":80.97139547489984,"d":"80.971"},{"v":48.5828372849399,"d":"48.583"},{"v":74.3828372849399,"d":"74.383"},null,10]
[131,"谢方芳",null,null,59.5,23.8,77.08,{"v":78.34892246052321,"d":"78.349"},{"v":47.009353476313926,"d":"47.009"},{"v":70.80935347631393,"d":"70.809"},null,11]
[121,"吴琼",null,null,60,24,85.1,{"v":86.50095097808155,"d":"86.501"},{"v":51.90057058684893,"d":"51.901"},{"v":75.90057058684893,"d":"75.901"},null,12]
[48,"彭美玲",null,null,68.5,27.400000000000002,89.56,{"v":91.03437332076362,"d":"91.034"},{"v":54.62062399245817,"d":"54.621"},{"v":82.02062399245817,"d":"82.021"},null,13]
[99,"曾捡娣",null,null,63,25.200000000000003,74.72,{"v":75.95007117605468,"d":"75.950"},{"v":45.57004270563281,"d":"45.570"},{"v":70.77004270563282,"d":"70.770"},null,14]
[130,"甘瑶",null,null,59.5,23.8,64.54,{"v":65.60248385576244,"d":"65.602"},{"v":39.361490313457466,"d":"39.361"},{"v":63.16149031345746,"d":"63.161"},null,15]
[93,"林红艳",null,null,63.5,25.400000000000002,78.74,{"v":80.03625005892057,"d":"80.036"},{"v":48.02175003535234,"d":"48.022"},{"v":73.42175003535235,"d":"73.422"},null,16]
[62,"周君",null,null,66.5,26.6,73.7,{"v":74.91327951920812,"d":"74.913"},{"v":44.94796771152487,"d":"44.948"},{"v":71.54796771152488,"d":"71.548"},null,17]
[65,"郭慧",null,null,66,26.400000000000002,89.8,{"v":91.27832429884515,"d":"91.278"},{"v":54.76699457930709,"d":"54.767"},{"v":81.16699457930709,"d":"81.167"},null,18]
[98,"罗惠君",null,null,63,25.200000000000003,82.36,{"v":83.71584397831722,"d":"83.716"},{"v":50.22950638699033,"d":"50.230"},{"v":75.42950638699034,"d":"75.430"},null,19]
[39,"易瑾珂",null,null,69.5,27.8,90.04,{"v":91.5222752769267,"d":"91.522"},{"v":54.91336516615602,"d":"54.913"},{"v":82.71336516615602,"d":"82.713"},null,20]
[4,"汤艳香",null,null,77.5,31,84.84,{"v":86.23667075182654,"d":"86.237"},{"v":51.74200245109592,"d":"51.742"},{"v":82.74200245109591,"d":"82.742"},null,21]
[41,"罗琳",null,null,69,27.6,83.12,{"v":84.4883554089088,"d":"84.488"},{"v":50.69301324534528,"d":"50.693"},{"v":78.29301324534528,"d":"78.293"},null,22]
[137,"刘婷",null,null,59,23.6,85.84,{"v":87.25313316049966,"d":"87.253"},{"v":52.35187989629979,"d":"52.352"},{"v":75.9518798962998,"d":"75.952"},null,23,97.11]
[125,"彭文娟",null,null,60,24,86.48,{"v":87.90366910205044,"d":"87.904"},{"v":52.742201461230266,"d":"52.742"},{"v":76.74220146123027,"d":"76.742"},null,24]
[23,"衷丽霞",null,null,72.5,29,91.62,{"v":93.12828588263022,"d":"93.128"},{"v":55.876971529578135,"d":"55.877"},{"v":84.87697152957813,"d":"84.877"},null,25]
[50,"黄愉红",null,null,68.5,27.400000000000002,80.02,{"v":81.33732194202216,"d":"81.337"},{"v":48.802393165213296,"d":"48.802"},{"v":76.2023931652133,"d":"76.202"},null,26]
[59,"陈鹏娜",null,null,67,26.8,79.3,{"v":80.60546900777751,"d":"80.605"},{"v":48.36328140466651,"d":"48.363"},{"v":75.1632814046665,"d":"75.163"},null,27]
[74,"黎南",null,null,65,26,97.26,{"v":98.86113386754656,"d":"98.861"},{"v":59.31668032052793,"d":"59.317"},{"v":85.31668032052792,"d":"85.317"},null,28]
[11,"周春蓉",null,null,74.5,29.8,83.72,{"v":85.09823285411265,"d":"85.098"},{"v":51.05893971246759,"d":"51.059"},{"v":80.85893971246759,"d":"80.859"},null,29]
[26,"刘婷",null,null,72,28.8,79.6,{"v":80.91040773037945,"d":"80.910"},{"v":48.54624463822767,"d":"48.546"},{"v":77.34624463822767,"d":"77.346"},null,30,97.04]
[91,"蒋海兰",null,null,63.5,25.400000000000002,96.92,{"v":98.51553664859769,"d":"98.516"},{"v":59.10932198915861,"d":"59.109"},{"v":84.50932198915861,"d":"84.509"},null,31]
[67,"胡寒清",null,null,66,26.400000000000002,92.78,{"v":94.30738227669103,"d":"94.307"},{"v":56.58442936601462,"d":"56.584"},{"v":82.98442936601462,"d":"82.984"},null,32]
[61,"刘心怡",null,null,66.5,26.6,95.9,{"v":97.47874499175113,"d":"97.479"},{"v":58.487246995050675,"d":"58.487"},{"v":85.08724699505068,"d":"85.087"},null,33]
[53,"张昕璐",null,null,67.5,27,93.54,{"v":95.0798937072826,"d":"95.080"},{"v":57.04793622436956,"d":"57.048"},{"v":84.04793622436955,"d":"84.048"},null,34]