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

{"sheet":"Sheet1 ","index":0,"n_rows":48,"n_cols":8,"rows_kept":48,"merged":[[0,0,0,7]]}
["2019年广东梅县外国语学校公开招聘教师总成绩"]
["序号","岗位代码","准考证号","笔试成绩","面试成绩","总成绩(笔试占60%，面试占40%）","排名","备注"]
[1,"mx001","2019001",68.65,77.85,{"$f":"D3*0.6+E3*0.4","v":{"v":72.33000000000001,"d":"72.33"}},{"$f":"RANK(F3,$F$3:$F$13)","v":7}]
[2,"mx001","2019002",{"v":74.2,"d":"74.20"},{"v":82,"d":"82.00"},{"$f":"D4*0.6+E4*0.4","v":{"v":77.32000000000001,"d":"77.32"}},{"$f":"RANK(F4,$F$3:$F$13)","v":5}]
[3,"mx001","2019003",{"v":71.3,"d":"71.30"},{"v":87.2,"d":"87.20"},77.66,4]
[4,"mx001","2019004",{"v":84.5,"d":"84.50"},90.05,86.72,1]
[5,"mx001","2019005",68.25,{"v":0,"d":"0.00"},{"v":40.949999999999996,"d":"40.95"},10,"缺考"]
[6,"mx001","2019006",{"v":76.7,"d":"76.70"},{"v":73.8,"d":"73.80"},75.54,6]
[7,"mx001","2019007",77.65,{"v":89.1,"d":"89.10"},82.23,3]
[8,"mx001","2019008",64.35,{"v":0,"d":"0.00"},{"v":38.60999999999999,"d":"38.61"},11,"缺考"]
[9,"mx001","2019009",{"v":63.9,"d":"63.90"},74.65,{"v":68.2,"d":"68.20"},9]
[10,"mx001","2019010",84.65,80.05,82.81,2]
[11,"mx001","2019011",66.65,{"v":73.7,"d":"73.70"},69.47,8]
[12,"mx002","2019012",{"v":73.1,"d":"73.10"},84.65,77.72,{"$f":"RANK(F14,$F$14:$F$23)","v":5}]
[13,"mx002","2019013",{"v":72.9,"d":"72.90"},{"v":80.5,"d":"80.50"},75.94,{"$f":"RANK(F15,$F$14:$F$23)","v":6}]
[14,"mx002","2019014",{"v":61.6,"d":"61.60"},73.25,66.26,10]
[15,"mx002","2019015",68.15,72.55,69.91,9]
[16,"mx002","2019016",63.85,84.55,72.13,7]
[17,"mx002","2019017",78.75,{"v":85.3,"d":"85.30"},81.37,2]
[18,"mx002","2019018",80.55,88.05,83.55,1]
[19,"mx002","2019019",66.85,76.95,{"v":70.88999999999999,"d":"70.89"},8]
[20,"mx002","2019020",77.65,{"v":83.1,"d":"83.10"},{"v":79.83000000000001,"d":"79.83"},3]
[21,"mx002","2019021",78.55,80.45,79.31,4]
[22,"mx003","2019022",62.85,{"v":74.9,"d":"74.90"},67.67,{"$f":"RANK(F24,$F$24:$F$28)","v":5}]
[23,"mx003","2019023",{"v":82.4,"d":"82.40"},81.55,82.06,{"$f":"RANK(F25,$F$24:$F$28)","v":1}]
[24,"mx003","2019024",79.75,{"v":82.3,"d":"82.30"},{"v":80.77000000000001,"d":"80.77"},{"$f":"RANK(F26,$F$24:$F$28)","v":2}]
[25,"mx003","2019025",79.85,{"v":79.3,"d":"79.30"},79.63,{"$f":"RANK(F27,$F$24:$F$28)","v":3}]
[26,"mx003","2019026",76.15,69.45,73.47,{"$f":"RANK(F28,$F$24:$F$28)","v":4}]
[27,"mx004","2019027",68.65,{"v":81.9,"d":"81.90"},{"v":73.95000000000002,"d":"73.95"},{"$f":"RANK(F29,$F$29:$F$33)","v":4}]
[28,"mx004","2019028",66.25,83.05,72.97,{"$f":"RANK(F30,$F$29:$F$33)","v":5}]
[29,"mx004","2019029",73.05,81.15,{"v":76.28999999999999,"d":"76.29"},{"$f":"RANK(F31,$F$29:$F$33)","v":2}]
[30,"mx004","2019030",{"v":73.4,"d":"73.40"},{"v":77.8,"d":"77.80"},75.16,{"$f":"RANK(F32,$F$29:$F$33)","v":3}]
[31,"mx004","2019031",{"v":84,"d":"84.00"},{"v":76.1,"d":"76.10"},80.84,{"$f":"RANK(F33,$F$29:$F$33)","v":1}]
[32,"mx005","2019032",{"v":65.6,"d":"65.60"},{"v":86.3,"d":"86.30"},73.88,{"$f":"RANK(F34,$F$34:$F$39)","v":5}]
[33,"mx005","2019033",{"v":67.5,"d":"67.50"},86.25,{"v":75,"d":"75.00"},4]
[34,"mx005","2019034",76.35,74.85,75.75,3]
[35,"mx005","2019035",{"v":81,"d":"81.00"},82.65,81.66,2]
[36,"mx005","2019036",{"v":83.2,"d":"83.20"},{"v":83.4,"d":"83.40"},83.28,1]
[37,"mx005","2019037",66.05,{"v":76.3,"d":"76.30"},{"v":70.14999999999999,"d":"70.15"},6]
[38,"mx006","2019038",73.05,{"v":0,"d":"0.00"},43.83,{"$f":"RANK(F40,$F$40:$F$42)","v":3},"缺考"]
[39,"mx006","2019039",{"v":84.3,"d":"84.30"},{"v":0,"d":"0.00"},50.58,{"$f":"RANK(F41,$F$40:$F$42)","v":2},"缺考"]
[40,"mx006","2019040",{"v":81.9,"d":"81.90"},{"v":82.4,"d":"82.40"},{"v":82.1,"d":"82.10"},{"$f":"RANK(F42,$F$40:$F$42)","v":1}]
[41,"mx007","2019041",{"v":65.7,"d":"65.70"},{"v":0,"d":"0.00"},39.42,{"$f":"RANK(F43,$F$43:$F$45)","v":3},"缺考"]
[42,"mx007","2019042",73.65,66.95,70.97,{"$f":"RANK(F44,$F$43:$F$45)","v":1}]
[43,"mx007","2019043",66.25,{"v":0,"d":"0.00"},39.75,{"$f":"RANK(F45,$F$43:$F$45)","v":2},"缺考"]
[44,"mx008","2019044",78.25,{"v":78.7,"d":"78.70"},78.43,{"$f":"RANK(F46,$F$46:$F$48)","v":2}]
[45,"mx008","2019045",77.15,{"v":73.7,"d":"73.70"},{"v":75.77000000000001,"d":"75.77"},{"$f":"RANK(F47,$F$46:$F$48)","v":3}]
[46,"mx008","2019046",{"v":84.3,"d":"84.30"},{"v":81.2,"d":"81.20"},83.06,{"$f":"RANK(F48,$F$46:$F$48)","v":1}]