{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["综合成绩表（用于公示）"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"综合成绩表（用于公示）","index":0,"n_rows":56,"n_cols":8,"rows_kept":56,"merged":[[0,0,0,7],[55,0,55,7]]}
["湖南商务职业技术学院2020年公开招聘综合成绩表"]
["报考岗位","考生号","笔试成绩","面试成绩","试讲成绩","综合成绩","本岗位排名","是否入围"]
["01",202001026,{"v":85,"d":"85.00"},{"v":81,"d":"81.00"},{"v":89,"d":"89.00"},{"$f":"C3*0.3+D3*0.3+E3*0.4","v":{"v":85.4,"d":"85.40"}},1,"是"]
["01",202001043,{"v":87,"d":"87.00"},{"v":79.4,"d":"79.40"},{"v":88.6,"d":"88.60"},85.36,2,"是"]
["01",202001002,{"v":82,"d":"82.00"},{"v":84,"d":"84.00"},{"v":81,"d":"81.00"},{"v":82.19999999999999,"d":"82.20"},3,"否"]
["01",202001037,{"v":84,"d":"84.00"},{"v":82.2,"d":"82.20"},{"v":79.4,"d":"79.40"},81.62,4,"否"]
["01",202001009,{"v":79,"d":"79.00"},{"v":79.4,"d":"79.40"},{"v":84,"d":"84.00"},81.12,5,"否"]
["01",202001035,{"v":78,"d":"78.00"},{"v":75.6,"d":"75.60"},{"v":78.8,"d":"78.80"},{"v":77.6,"d":"77.60"},6,"否"]
["02",202002003,{"v":74,"d":"74.00"},{"v":80.2,"d":"80.20"},{"v":77.4,"d":"77.40"},77.22,1,"是"]
["02",202002002,{"v":70,"d":"70.00"},{"v":78.7,"d":"78.70"},{"v":77.6,"d":"77.60"},75.65,2,"否"]
["04",202004001,{"v":89,"d":"89.00"},{"v":81.7,"d":"81.70"},{"v":85.2,"d":"85.20"},{"$f":"C11*0.3+D11*0.3+E11*0.4","v":85.29},1,"是"]
["04",202004003,{"v":87,"d":"87.00"},{"v":81,"d":"81.00"},{"v":86,"d":"86.00"},{"v":84.8,"d":"84.80"},2,"是"]
["04",202004004,{"v":77,"d":"77.00"},{"v":86.4,"d":"86.40"},{"v":78,"d":"78.00"},80.22,3,"否"]
["04",202004007,{"v":71,"d":"71.00"},{"v":82.6,"d":"82.60"},{"v":84.8,"d":"84.80"},{"v":80,"d":"80.00"},4,"否"]
["04",202004009,{"v":69,"d":"69.00"},{"v":85.4,"d":"85.40"},{"v":83,"d":"83.00"},{"v":79.52000000000001,"d":"79.52"},5,"否"]
["04",202004012,{"v":69,"d":"69.00"},{"v":80,"d":"80.00"},{"v":73.4,"d":"73.40"},74.06,6,"否"]
["05",202005003,{"v":85,"d":"85.00"},{"v":90,"d":"90.00"},{"v":91,"d":"91.00"},{"$f":"C17*0.3+D17*0.3+E17*0.4","v":{"v":88.9,"d":"88.90"}},1,"是"]
["05",202005016,{"v":75,"d":"75.00"},{"v":89.6,"d":"89.60"},{"v":89.8,"d":"89.80"},{"v":85.3,"d":"85.30"},2,"否"]
["05",202005007,{"v":81,"d":"81.00"},{"v":86.4,"d":"86.40"},{"v":80.8,"d":"80.80"},{"v":82.53999999999999,"d":"82.54"},3,"否"]
["05",202005010,{"v":75,"d":"75.00"},{"v":77.2,"d":"77.20"},{"v":75.2,"d":"75.20"},75.74,4,"否"]
["06",202006007,{"v":75,"d":"75.00"},{"v":89.4,"d":"89.40"},{"v":89,"d":"89.00"},84.92,1,"是"]
["06",202006006,{"v":65,"d":"65.00"},{"v":81.6,"d":"81.60"},{"v":87.4,"d":"87.40"},78.94,2,"否"]
["06",202006003,{"v":60,"d":"60.00"},{"v":84,"d":"84.00"},{"v":82.6,"d":"82.60"},{"v":76.24000000000001,"d":"76.24"},3,"否"]
["07",202007004,{"v":74,"d":"74.00"},{"v":84.4,"d":"84.40"},{"v":90.4,"d":"90.40"},83.68,1,"是"]
["07",202007012,{"v":68.5,"d":"68.50"},{"v":84.2,"d":"84.20"},{"v":88.2,"d":"88.20"},81.09,2,"是"]
["07",202007010,{"v":74.5,"d":"74.50"},{"v":82.4,"d":"82.40"},{"v":72.8,"d":"72.80"},76.19,3,"否"]
["07",202007007,{"v":60,"d":"60.00"},{"v":82,"d":"82.00"},{"v":82.4,"d":"82.40"},75.56,4,"否"]
["07",202007002,{"v":75,"d":"75.00"},{"v":76.8,"d":"76.80"},{"v":74.6,"d":"74.60"},75.38,5,"否"]
["07",202007009,{"v":61.5,"d":"61.50"},{"v":80.6,"d":"80.60"},{"v":72.8,"d":"72.80"},71.75,6,"否"]
["08",202008005,{"v":69,"d":"69.00"},{"v":84.4,"d":"84.40"},{"v":84,"d":"84.00"},79.62,1,"是"]
["08",202008004,{"v":76.5,"d":"76.50"},{"v":86.4,"d":"86.40"},{"v":70.6,"d":"70.60"},77.11,2,"否"]
["08",202008007,{"v":74.5,"d":"74.50"},{"v":76.8,"d":"76.80"},{"v":74.2,"d":"74.20"},{"v":75.07000000000001,"d":"75.07"},3,"否"]
["09",202009016,{"v":82,"d":"82.00"},{"v":79.2,"d":"79.20"},{"v":77.6,"d":"77.60"},{"v":79.4,"d":"79.40"},1,"是"]
["09",202009012,{"v":72,"d":"72.00"},{"v":81.4,"d":"81.40"},{"v":79.4,"d":"79.40"},77.78,2,"是"]
["09",202009022,{"v":62,"d":"62.00"},{"v":76.2,"d":"76.20"},{"v":90.6,"d":"90.60"},{"v":77.69999999999999,"d":"77.70"},3,"是"]
["09",202009015,{"v":72,"d":"72.00"},{"v":75.8,"d":"75.80"},{"v":81.4,"d":"81.40"},{"v":76.9,"d":"76.90"},4,"是"]
["09",202009027,{"v":64,"d":"64.00"},{"v":76.4,"d":"76.40"},{"v":86.6,"d":"86.60"},76.76,5,"是"]
["09",202009008,{"v":70,"d":"70.00"},{"v":79.6,"d":"79.60"},{"v":77.6,"d":"77.60"},{"v":75.91999999999999,"d":"75.92"},6,"否"]
["09",202009052,{"v":68,"d":"68.00"},{"v":74.2,"d":"74.20"},{"v":82.6,"d":"82.60"},{"v":75.69999999999999,"d":"75.70"},7,"否"]
["09",202009036,{"v":70,"d":"70.00"},{"v":76.2,"d":"76.20"},{"v":76.4,"d":"76.40"},74.42,8,"否"]
["09",202009021,{"v":62,"d":"62.00"},{"v":76.2,"d":"76.20"},{"v":82.2,"d":"82.20"},74.34,9,"否"]
["09",202009018,{"v":64,"d":"64.00"},{"v":78,"d":"78.00"},{"v":78.2,"d":"78.20"},73.88,10,"否"]
["09",202009035,{"v":64,"d":"64.00"},{"v":73.4,"d":"73.40"},{"v":71.2,"d":"71.20"},{"v":69.7,"d":"69.70"},11,"否"]
["09",202009033,{"v":66,"d":"66.00"},{"v":69.6,"d":"69.60"},{"v":71.8,"d":"71.80"},{"v":69.4,"d":"69.40"},12,"否"]
["09",202009024,{"v":60,"d":"60.00"},"缺考","缺考",{"$f":"C45*0.3","v":{"v":18,"d":"18.00"}},13,"否"]
["10",202010002,{"v":90,"d":"90.00"},{"v":84,"d":"84.00"},{"v":77.2,"d":"77.20"},{"$f":"C46*0.3+D46*0.3+E46*0.4","v":{"v":83.08000000000001,"d":"83.08"}},1,"是"]
["10",202010009,{"v":62.5,"d":"62.50"},{"v":76.8,"d":"76.80"},{"v":81.8,"d":"81.80"},{"$f":"C47*0.3+D47*0.3+E47*0.4","v":{"v":74.50999999999999,"d":"74.51"}},2,"是"]
["10",202010004,{"v":78,"d":"78.00"},{"v":78.6,"d":"78.60"},{"v":66,"d":"66.00"},{"$f":"C48*0.3+D48*0.3+E48*0.4","v":73.38},3,"否"]
["10",202010001,{"v":74,"d":"74.00"},"缺考","缺考",{"$f":"C49*0.3","v":{"v":22.2,"d":"22.20"}},4,"否"]
["11（男）",202011035,{"v":67,"d":"67.00"},{"v":89.4,"d":"89.40"},{"v":86.6,"d":"86.60"},{"$f":"C50*0.4+D50*0.3+E50*0.3","v":{"v":79.6,"d":"79.60"}},1,"是"]
["11（男）",202011022,{"v":68,"d":"68.00"},{"v":85.4,"d":"85.40"},{"v":76.2,"d":"76.20"},75.68,2,"否"]
["11（男）",202011012,{"v":63,"d":"63.00"},{"v":79,"d":"79.00"},{"v":79,"d":"79.00"},{"v":72.60000000000001,"d":"72.60"},3,"否"]
["11（女）",202011277,{"v":83,"d":"83.00"},{"v":89.2,"d":"89.20"},{"v":80.6,"d":"80.60"},84.14,1,"是"]
["11（女）",202011054,{"v":81,"d":"81.00"},{"v":86.6,"d":"86.60"},{"v":84.6,"d":"84.60"},{"v":83.75999999999999,"d":"83.76"},2,"否"]
["11（女）",202011073,{"v":90,"d":"90.00"},{"v":77.6,"d":"77.60"},{"v":79,"d":"79.00"},82.98,3,"否"]
["备注：1.01-10岗按百分制折算综合成绩，其中笔试占综合成绩的30%，面试占综合成绩的30%，试讲成绩占综合成绩的40%；2.11岗按百分制折算综合成绩，其中笔试占综合成绩的40%，面试占综合成绩的30%，试讲占综合成绩的30%；3.成绩计算结果精确到小数点后两位数。"]