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

{"sheet":"1","index":0,"n_rows":56,"n_cols":8,"rows_kept":56,"merged":[[0,0,0,7],[2,1,5,1],[6,1,19,1],[20,1,26,1],[27,1,34,1],[35,1,42,1],[43,1,47,1],[48,1,55,1],[58,3,58,5],[59,3,59,5]]}
["淮北市建投集团招聘房地产公司人员综合成绩表"]
["序号","应聘岗位","准考证号","笔试成绩\n(满分100分)","笔试占比60%","面试成绩\n(满分100分)","面试占比40%","综合成绩"]
[1,"项目经理","201904070104",{"v":75,"d":"75.00"},{"$f":"D3*0.6","v":{"v":45,"d":"45.00"}},{"v":77.8,"d":"77.80"},{"$f":"F3*0.4","v":31.12},{"$f":"E3+G3","v":76.12}]
[2,null,"201904070103",{"v":59,"d":"59.00"},{"$f":"D4*0.6","v":{"v":35.4,"d":"35.40"}},{"v":70.6,"d":"70.60"},{"$f":"F4*0.4","v":28.24},63.64]
[3,null,"201904070106",{"v":60,"d":"60.00"},{"$f":"D5*0.6","v":{"v":36,"d":"36.00"}},{"v":68.2,"d":"68.20"},{"$f":"F5*0.4","v":27.28},63.28]
[4,null,"201904070101",{"v":40,"d":"40.00"},{"$f":"D6*0.6","v":{"v":24,"d":"24.00"}},{"v":61.6,"d":"61.60"},{"$f":"F6*0.4","v":24.64},48.64]
[5,"土建工程师","201904070126",{"v":78,"d":"78.00"},{"v":46.8,"d":"46.80"},{"v":82.4,"d":"82.40"},32.96,79.76]
[6,null,"201904070125",{"v":72,"d":"72.00"},{"v":43.2,"d":"43.20"},{"v":73,"d":"73.00"},{"v":29.2,"d":"29.20"},{"v":72.4,"d":"72.40"}]
[7,null,"201904070115",{"v":66,"d":"66.00"},{"v":39.6,"d":"39.60"},{"v":79.2,"d":"79.20"},31.68,71.28]
[8,null,"201904070210",{"v":62,"d":"62.00"},{"v":37.2,"d":"37.20"},{"v":82.4,"d":"82.40"},32.96,70.16]
[9,null,"201904070122",{"v":64,"d":"64.00"},{"v":38.4,"d":"38.40"},{"v":79,"d":"79.00"},{"v":31.6,"d":"31.60"},{"v":70,"d":"70.00"}]
[10,null,"201904070118",{"v":61,"d":"61.00"},{"v":36.6,"d":"36.60"},{"v":81,"d":"81.00"},{"v":32.4,"d":"32.40"},{"v":69,"d":"69.00"}]
[11,null,"201904070129",{"v":65,"d":"65.00"},{"v":39,"d":"39.00"},{"v":71.2,"d":"71.20"},28.48,67.48]
[12,null,"201904070213",{"v":67,"d":"67.00"},{"v":40.2,"d":"40.20"},{"v":67.6,"d":"67.60"},27.04,67.24]
[13,null,"201904070117",{"v":67.5,"d":"67.50"},{"v":40.5,"d":"40.50"},{"v":65.4,"d":"65.40"},26.16,66.66]
[14,null,"201904070215",{"v":59,"d":"59.00"},{"v":35.4,"d":"35.40"},{"v":75.2,"d":"75.20"},30.08,65.48]
[15,null,"201904070127",{"v":62.5,"d":"62.50"},{"v":37.5,"d":"37.50"},{"v":69.4,"d":"69.40"},27.76,65.26]
[16,null,"201904070217",{"v":67,"d":"67.00"},{"v":40.2,"d":"40.20"},{"v":60.8,"d":"60.80"},24.32,64.52]
[17,null,"201904070124",{"v":58,"d":"58.00"},{"v":34.8,"d":"34.80"},{"v":68.6,"d":"68.60"},27.44,{"$f":"E19+G19","v":62.24}]
[18,null,"201904070206",{"v":57,"d":"57.00"},{"v":34.2,"d":"34.20"},{"v":65.6,"d":"65.60"},26.24,60.44]
[19,"项目管理","201904070225",{"v":60,"d":"60.00"},{"v":36,"d":"36.00"},{"v":83.2,"d":"83.20"},33.28,69.28]
[20,null,"201904070305",{"v":66,"d":"66.00"},{"v":39.6,"d":"39.60"},{"v":70.4,"d":"70.40"},28.16,67.76]
[21,null,"201904070223",{"v":61,"d":"61.00"},{"v":36.6,"d":"36.60"},{"v":77,"d":"77.00"},{"v":30.8,"d":"30.80"},{"v":67.4,"d":"67.40"}]
[22,null,"201904070219",{"v":56,"d":"56.00"},{"v":33.6,"d":"33.60"},{"v":78,"d":"78.00"},{"v":31.2,"d":"31.20"},{"v":64.8,"d":"64.80"}]
[23,null,"201904070226",{"v":61.5,"d":"61.50"},{"v":36.9,"d":"36.90"},{"v":67.2,"d":"67.20"},26.88,63.78]
[24,null,"201904070221",{"v":57,"d":"57.00"},{"v":34.2,"d":"34.20"},{"v":72.6,"d":"72.60"},29.04,63.24]
[25,null,"201904070222",{"v":62,"d":"62.00"},{"v":37.2,"d":"37.20"},{"v":64.6,"d":"64.60"},25.84,63.04]
[26,"安装工程师","201904070407",{"v":67.5,"d":"67.50"},{"v":40.5,"d":"40.50"},{"v":79,"d":"79.00"},{"v":31.6,"d":"31.60"},{"v":72.1,"d":"72.10"}]
[27,null,"201904070401",{"v":64,"d":"64.00"},{"v":38.4,"d":"38.40"},{"v":78,"d":"78.00"},{"v":31.2,"d":"31.20"},{"v":69.6,"d":"69.60"}]
[28,null,"201904070409",{"v":66,"d":"66.00"},{"v":39.6,"d":"39.60"},{"v":70.4,"d":"70.40"},28.16,67.76]
[29,null,"201904070408",{"v":62,"d":"62.00"},{"v":37.2,"d":"37.20"},{"v":73,"d":"73.00"},{"v":29.2,"d":"29.20"},{"v":66.4,"d":"66.40"}]
[30,null,"201904070405",{"v":53.5,"d":"53.50"},{"v":32.1,"d":"32.10"},{"v":81.8,"d":"81.80"},32.72,64.82]
[31,null,"201904070410",{"v":46.5,"d":"46.50"},{"v":27.9,"d":"27.90"},{"v":77.6,"d":"77.60"},31.04,58.94]
[32,null,"201904070403",{"v":34,"d":"34.00"},{"v":20.4,"d":"20.40"},{"v":78.8,"d":"78.80"},31.52,51.92]
[33,null,"201904070406",{"v":34,"d":"34.00"},{"v":20.4,"d":"20.40"},{"v":65.8,"d":"65.80"},26.32,46.72]
[34,"资料员","201904070307",{"v":72,"d":"72.00"},{"$f":"D36*0.6","v":{"v":43.2,"d":"43.20"}},{"v":78.6,"d":"78.60"},{"$f":"F36*0.4","v":31.44},74.64]
[35,null,"201904070311",{"v":68,"d":"68.00"},{"v":40.8,"d":"40.80"},{"v":74.8,"d":"74.80"},29.92,70.72]
[36,null,"201904070315",{"v":61,"d":"61.00"},{"v":36.6,"d":"36.60"},{"v":81,"d":"81.00"},{"v":32.4,"d":"32.40"},{"v":69,"d":"69.00"}]
[37,null,"201904070321",{"v":64.5,"d":"64.50"},{"v":38.7,"d":"38.70"},{"v":73,"d":"73.00"},{"v":29.2,"d":"29.20"},{"v":67.9,"d":"67.90"}]
[38,null,"201904070313",{"v":64,"d":"64.00"},{"v":38.4,"d":"38.40"},{"v":73.4,"d":"73.40"},29.36,67.76]
[39,null,"201904070316",{"v":63,"d":"63.00"},{"v":37.8,"d":"37.80"},{"v":74.4,"d":"74.40"},29.76,67.56]
[40,null,"201904070306",{"v":66,"d":"66.00"},{"v":39.6,"d":"39.60"},{"v":69.4,"d":"69.40"},27.76,67.36]
[41,null,"201904070317",{"v":60,"d":"60.00"},{"v":36,"d":"36.00"},{"v":75.4,"d":"75.40"},30.16,66.16]
[42,"策划主管","201904070420",{"v":62,"d":"62.00"},{"v":37.2,"d":"37.20"},{"v":83.8,"d":"83.80"},33.52,70.72]
[43,null,"201904070412",{"v":53,"d":"53.00"},{"v":31.8,"d":"31.80"},{"v":82.6,"d":"82.60"},33.04,64.84]
[44,null,"201904070418",{"v":53,"d":"53.00"},{"v":31.8,"d":"31.80"},{"v":82.2,"d":"82.20"},32.88,64.68]
[45,null,"201904070417",{"v":52,"d":"52.00"},{"v":31.2,"d":"31.20"},{"v":80.6,"d":"80.60"},32.24,63.44]
[46,null,"201904070421",{"v":46,"d":"46.00"},{"v":27.6,"d":"27.60"},{"v":77.2,"d":"77.20"},30.88,58.48]
[47,"产权管理","201904070432",{"v":73,"d":"73.00"},{"v":43.8,"d":"43.80"},{"v":72.6,"d":"72.60"},29.04,72.84]
[48,null,"201904070426",{"v":64,"d":"64.00"},{"v":38.4,"d":"38.40"},{"v":82.8,"d":"82.80"},33.12,71.52]
[49,null,"201904070428",{"v":65,"d":"65.00"},{"v":39,"d":"39.00"},{"v":79,"d":"79.00"},{"v":31.6,"d":"31.60"},{"v":70.6,"d":"70.60"}]
[50,null,"201904070425",{"v":66,"d":"66.00"},{"v":39.6,"d":"39.60"},{"v":75.6,"d":"75.60"},30.24,69.84]
[51,null,"201904070431",{"v":59,"d":"59.00"},{"v":35.4,"d":"35.40"},{"v":79.2,"d":"79.20"},31.68,67.08]
[52,null,"201904070424",{"v":56,"d":"56.00"},{"v":33.6,"d":"33.60"},{"v":76.8,"d":"76.80"},30.72,64.32]
[53,null,"201904070429",{"v":56,"d":"56.00"},{"v":33.6,"d":"33.60"},{"v":76.8,"d":"76.80"},30.72,64.32]
[54,null,"201904070422",{"v":56,"d":"56.00"},{"v":33.6,"d":"33.60"},{"v":68.8,"d":"68.80"},27.52,61.12]