{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["综合成绩表"],"read":"whole","date_system":"1900"}

{"sheet":"综合成绩表","index":0,"n_rows":101,"n_cols":8,"rows_kept":101,"merged":[[0,0,0,7],[1,0,1,7],[2,4,2,6],[3,0,5,0],[3,4,3,6],[4,4,4,6],[5,4,5,6],[8,0,38,0],[41,0,92,0],[95,0,100,0]]}
["2020年碧溪街道下属单位招聘合同制工作人员综合成绩汇总表"]
["                                                                                       2020.07"]
["岗位编号","序号","姓名","身份证号","综合成绩",null,null,"备注"]
["01","1","季宇舟","3205811992****3013",{"v":64.6,"d":"64.60"},null,null,"进入体检"]
[null,"3","郑景柯","3205811993****3319",{"v":58.6,"d":"58.60"}]
[null,"2","周子涵","3205811996****3210",{"v":56,"d":"56.00"}]
[]
["岗位编号","序号","姓名","身份证号","笔试成绩\n（40%）","面试成绩\n（60%）","综合成绩","备注"]
["02","1","徐凯迪","3205811995****3229",{"v":79.5,"d":"79.50"},{"v":77.8,"d":"77.80"},{"$f":"ROUND(E9*40%+F9*60%,2)","v":78.48},"进入体检"]
[null,"2","仲佳澜","3205811993****3225",{"v":70,"d":"70.00"},{"v":78.4,"d":"78.40"},75.04,"进入体检"]
[null,"3","王佳蕾","3205811996****3123",{"v":72,"d":"72.00"},{"v":76,"d":"76.00"},{"v":74.4,"d":"74.40"}]
[null,"4","李敏","3205811987****3248",{"v":73,"d":"73.00"},{"v":75,"d":"75.00"},{"v":74.2,"d":"74.20"}]
[null,"5","顾佳蕾","3205811997****3327",{"v":73,"d":"73.00"},{"v":70.2,"d":"70.20"},71.32]
[null,"6","陈佳希","3205811991****332X",{"v":70,"d":"70.00"},{"v":73.2,"d":"73.20"},71.92]
[null,"7","蒋梦丹","3205811993****3023",{"v":70,"d":"70.00"},{"v":63.4,"d":"63.40"},66.04]
[null,"8","朱莉妍","3205811997****3127",{"v":71.5,"d":"71.50"},{"v":0,"d":"0.00"},{"v":28.6,"d":"28.60"},"放弃"]
[null,"9","张琰洋","3205811991****3142",{"v":69.5,"d":"69.50"}]
[null,"10","顾倩","3205811992****3244",{"v":69.5,"d":"69.50"}]
[null,"11","徐丹","3205811989****3042",{"v":69,"d":"69.00"}]
[null,"12","周沐子","3205811998****3128",{"v":68,"d":"68.00"}]
[null,"13","杨洋","3205811994****3023",{"v":66.5,"d":"66.50"}]
[null,"14","丁钰镓","3205811988****326X",{"v":66.5,"d":"66.50"}]
[null,"15","王嘉秋","3205811997****3120",{"v":66.5,"d":"66.50"}]
[null,"16","谢雪靖","3205811994****3225",{"v":66,"d":"66.00"}]
[null,"17","魏蒙蒙","3205811987****1424",{"v":65,"d":"65.00"}]
[null,"18","李晔","3205811996****3128",{"v":64,"d":"64.00"}]
[null,"19","陆叶","3205811992****3429",{"v":62.5,"d":"62.50"}]
[null,"20","陶静","3205811987****324X",{"v":62,"d":"62.00"}]
[null,"21","潘洁","3205811996****3025",{"v":61,"d":"61.00"}]
[null,"22","陆倩楠","3205201992****3024",{"v":60.5,"d":"60.50"}]
[null,"23","王欢","3205811987****3228",{"v":59,"d":"59.00"}]
[null,"24","崔露","3205811988****3026",{"v":59,"d":"59.00"}]
[null,"25","徐晶","3205811988****3222",{"v":58.5,"d":"58.50"}]
[null,"26","张婷","3213221986****5423",{"v":57.5,"d":"57.50"}]
[null,"27","陈蒙","3205811995****3321",{"v":56.5,"d":"56.50"}]
[null,"28","王薇","3205811988****3226",{"v":55.5,"d":"55.50"}]
[null,"29","范铭迪","3205811994****322X",{"v":51,"d":"51.00"}]
[null,"30","李雨晴","3205811998****322X",{"v":41.5,"d":"41.50"}]
[null,"31","陈慧","3209221994****2744","放弃"]
[]
["岗位编号","序号","姓名","身份证号","笔试成绩\n（40%）","面试成绩\n（60%）","综合成绩","备注"]
["03","1","王晶莹","3205811996****0221",{"v":78,"d":"78.00"},{"v":67.8,"d":"67.80"},{"$f":"ROUND(E42*40%+F42*60%,2)","v":71.88},"进入体检"]
[null,"2","陆彬","3205811991****3543",{"v":77,"d":"77.00"},{"v":66.6,"d":"66.60"},{"$f":"ROUND(E43*40%+F43*60%,2)","v":70.76}]
[null,"3","曹梦佳","3205811989****3028",{"v":68,"d":"68.00"},{"v":70.4,"d":"70.40"},{"$f":"ROUND(E44*40%+F44*60%,2)","v":69.44}]
[null,"4","叶梦娜","3205811991****3224",{"v":67.5,"d":"67.50"}]
[null,"5","倪  丹","3205811987****3326",{"v":67.5,"d":"67.50"}]
[null,"6","伍丽春","3205811990****3149",{"v":67.5,"d":"67.50"}]
[null,"7","徐超怡","3205811998****3125",{"v":65,"d":"65.00"}]
[null,"8","徐霜婷","3205811996****3027",{"v":64.5,"d":"64.50"}]
[null,"9","顾晶","3205811988****3221",{"v":62.5,"d":"62.50"}]
[null,"10","桑晓劼","3205811998****3225",{"v":62.5,"d":"62.50"}]
[null,"11","蔡羽月","3205811996****3222",{"v":62,"d":"62.00"}]
[null,"12","王璐","3205811997****3026",{"v":62,"d":"62.00"}]
[null,"13","徐秋萍","3205811987****152X",{"v":62,"d":"62.00"}]
[null,"14","刘倩","3205811995****332X",{"v":62,"d":"62.00"}]
[null,"15","王荀","3205811986****3342",{"v":62,"d":"62.00"}]
[null,"16","蒋梦婷","3205811987****0223",{"v":61.5,"d":"61.50"}]
[null,"17","陈琼","3205811986****3126",{"v":61.5,"d":"61.50"}]
[null,"18","徐晴","3205811997****3227",{"v":61.5,"d":"61.50"}]
[null,"19","王娇娇","3205811993****3327",{"v":61,"d":"61.00"}]
[null,"20","高 原","3204811993****5820",{"v":60.5,"d":"60.50"}]
[null,"21","惠欣怡","3205811998****3026",{"v":60,"d":"60.00"}]
[null,"22","王敏亚","3205811984****3046",{"v":60,"d":"60.00"}]
[null,"23","张梅丹","3205811990****3220",{"v":59.5,"d":"59.50"}]
[null,"24","殷新","3205811985****3216",{"v":59.5,"d":"59.50"}]
[null,"25","曹怡","3205811989****3224",{"v":59,"d":"59.00"}]
[null,"26","徐静雯","3205811996****3323",{"v":57,"d":"57.00"}]
[null,"27","褚秋慧","3205811992****0046",{"v":57,"d":"57.00"}]
[null,"28","马雯瑜","3205811994****3043",{"v":57,"d":"57.00"}]
[null,"29","闻柯漪","3205812000****3225",{"v":57,"d":"57.00"}]
[null,"30","程雪星","3205811994****3026",{"v":57,"d":"57.00"}]
[null,"31","周颖琪","3205811997****3024",{"v":56.5,"d":"56.50"}]
[null,"32","殷匡斐","3205811998****0321",{"v":56.5,"d":"56.50"}]
[null,"33","陆 羽","3205811993****3122",{"v":56,"d":"56.00"}]
[null,"34","韩铭燏","3205811998****3121",{"v":55.5,"d":"55.50"}]
[null,"35","徐晓婷","3205811994****3429",{"v":55,"d":"55.00"}]
[null,"36","陈伊","3205811987****302X",{"v":53,"d":"53.00"}]
[null,"37","朱  琼","3205811990****3128",{"v":52.5,"d":"52.50"}]
[null,"38","严梦凡","3205811993****3228",{"v":51.5,"d":"51.50"}]
[null,"39","杨瑛","3205811997****3229",{"v":50,"d":"50.00"}]
[null,"40","钱怡秋","3205811998****3225",{"v":48,"d":"48.00"}]
[null,"41","金铭","3205811995****3328",{"v":48,"d":"48.00"}]
[null,"42","龚怡","3205811990****3224",{"v":47,"d":"47.00"}]
[null,"43","薛怡娇","3205811989****3123",{"v":46.5,"d":"46.50"}]
[null,"44","夏建英","3205811987****1424",{"v":46,"d":"46.00"}]
[null,"45","龚幸佳","3205811998****3226",{"v":45,"d":"45.00"}]
[null,"46","陆情依","3205811996****322X",{"v":43,"d":"43.00"}]
[null,"47","曾心竹","3205811987****3320",{"v":30,"d":"30.00"}]
[null,"48","龚幸珏","3205811995****3221","缺考"]
[null,"49","姚静蓉","3205811997****3222","缺考"]
[null,"50","季敏琪","3205811996****3025","缺考"]
[null,"51","皇英姿","3205811996****3222","放弃"]
[null,"52","吴晓雯","3205811997****3024","放弃"]
[]
["岗位编号","序号","姓名","身份证号","笔试成绩\n（40%）","面试成绩\n（60%）","综合成绩","备注"]
["04","1","王宋宋","3203211991****3612",{"v":62.5,"d":"62.50"},{"v":70.6,"d":"70.60"},{"$f":"ROUND(E96*40%+F96*60%,2)","v":67.36},"进入体检"]
[null,"2","江怡","3205811994****313X",{"v":53.5,"d":"53.50"},{"v":62.4,"d":"62.40"},58.84,"进入体检"]
[null,"3","王谢渊","3205811997****1415",{"v":60,"d":"60.00"},{"v":56.4,"d":"56.40"},57.84]
[null,"4","李花雨","3205811994****3023",{"v":51.5,"d":"51.50"},{"v":55,"d":"55.00"},{"v":53.6,"d":"53.60"}]
[null,"5","曹庆丹","3205811992****3147",{"v":56.5,"d":"56.50"},{"v":0,"d":"0.00"},{"v":22.6,"d":"22.60"},"放弃"]
[null,"6","徐佳","3205811988****322X",{"v":29,"d":"29.00"},{"v":0,"d":"0.00"},{"v":11.6,"d":"11.60"},"放弃"]