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

{"sheet":"Sheet2","index":0,"n_rows":62,"n_cols":6,"rows_kept":62,"merged":[[0,0,0,5]]}
["2018年公开招聘综合成绩表"]
["考生号","笔试成绩","面试成绩","试讲成绩","综合成绩","排名"]
["20180102002",80,{"v":81.6,"d":"81.60"},{"v":82.8,"d":"82.80"},{"$f":"B3*0.3+C3*0.3+D3*0.4","v":{"v":81.6,"d":"81.60"}},1]
["20180102003",76,{"v":78.4,"d":"78.40"},{"v":86.6,"d":"86.60"},{"v":80.96000000000001,"d":"80.96"},2]
["20180102001",94,{"v":72.2,"d":"72.20"},{"v":77.6,"d":"77.60"},{"v":80.9,"d":"80.90"},3]
["20180103009",64.4,{"v":87.8,"d":"87.80"},{"v":75.4,"d":"75.40"},75.82,1]
["20180103008",63.9,{"v":82.8,"d":"82.80"},{"v":79,"d":"79.00"},75.61,2]
["20180103007",64.4,{"v":82.6,"d":"82.60"},{"v":76.2,"d":"76.20"},74.58,3]
["20180104002",59,{"v":82.4,"d":"82.40"},{"v":75.4,"d":"75.40"},{"v":72.58000000000001,"d":"72.58"},1]
["20180104001",54,{"v":73.2,"d":"73.20"},{"v":65.8,"d":"65.80"},{"v":64.47999999999999,"d":"64.48"},2]
["20180104003",56,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":16.8,"d":"16.80"},3]
["20180105001",null,{"v":84.2,"d":"84.20"},{"v":88.8,"d":"88.80"},{"$f":"C12*0.5+D12*0.5","v":{"v":86.5,"d":"86.50"}},1]
["20180106002",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C13*0.5+D13*0.5","v":{"v":0,"d":"0.00"}},2]
["20180106001",null,{"v":87.4,"d":"87.40"},{"v":88.2,"d":"88.20"},{"v":87.80000000000001,"d":"87.80"},1]
["20180107002",61,{"v":79.6,"d":"79.60"},{"v":75.4,"d":"75.40"},{"$f":"B15*0.3+C15*0.3+D15*0.4","v":72.34},1]
["20180107001",34,{"v":82,"d":"82.00"},{"v":70.2,"d":"70.20"},{"$f":"B16*0.3+C16*0.3+D16*0.4","v":{"v":62.879999999999995,"d":"62.88"}},2]
["20180109003",67.2,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},20.16,3]
["20180109006",71.1,{"v":84,"d":"84.00"},{"v":85.4,"d":"85.40"},{"$f":"B18*0.3+C18*0.3+D18*0.4","v":80.69},1]
["20180109002",73.9,{"v":83.4,"d":"83.40"},{"v":80.2,"d":"80.20"},{"$f":"B19*0.3+C19*0.3+D19*0.4","v":{"v":79.27000000000001,"d":"79.27"}},2]
["20180111001",null,{"v":87.8,"d":"87.80"},{"v":91.2,"d":"91.20"},{"$f":"C20*0.5+D20*0.5","v":{"v":89.5,"d":"89.50"}},1]
["20180112005",67.1,{"v":89.6,"d":"89.60"},null,{"$f":"B21*0.5+C21*0.5","v":78.35},1]
["20180112006",68.7,{"v":83.6,"d":"83.60"},null,76.15,2]
["20180112007",64.8,{"v":0,"d":"0.00"},null,{"v":32.4,"d":"32.40"},3]
["20180113011",70.8,{"v":87.8,"d":"87.80"},null,{"v":79.3,"d":"79.30"},1]
["20180113006",{"v":72,"d":"72.0"},{"v":85.4,"d":"85.40"},null,{"v":78.7,"d":"78.70"},2]
["20180113013",74.4,{"v":79.8,"d":"79.80"},null,{"v":77.1,"d":"77.10"},3]
["20180113030",69.9,{"v":84.2,"d":"84.20"},null,{"v":77.05000000000001,"d":"77.05"},4]
["20180113035",71.7,{"v":82,"d":"82.00"},null,76.85,5]
["20180113017",71.6,{"v":69.8,"d":"69.80"},null,{"v":70.69999999999999,"d":"70.70"},6]
["20180114001",63.7,{"v":86,"d":"86.00"},null,74.85,1]
["20180114017",62.3,{"v":83,"d":"83.00"},null,72.65,2]
["20180114004",60.3,{"v":84,"d":"84.00"},null,72.15,3]
["20180114002",55.7,{"v":84.6,"d":"84.60"},null,70.15,4]
["20180114005",57.4,{"v":73.8,"d":"73.80"},null,{"v":65.6,"d":"65.60"},5]
["20180114014",55.9,{"v":0,"d":"0.00"},null,27.95,6]
["20180115012",75.2,{"v":84.6,"d":"84.60"},{"v":85.6,"d":"85.60"},{"$f":"B36*0.4+C36*0.3+D36*0.3","v":81.14},1]
["20180115006",76.8,{"v":86,"d":"86.00"},{"v":78.2,"d":"78.20"},{"v":79.97999999999999,"d":"79.98"},2]
["20180115004",75.4,{"v":82.1,"d":"82.10"},{"v":82.6,"d":"82.60"},{"v":79.57000000000001,"d":"79.57"},3]
["20180116175",68.5,{"v":91.8,"d":"91.80"},{"v":94,"d":"94.00"},83.14,1]
["20180116332",{"v":69,"d":"69.0"},{"v":88.8,"d":"88.80"},{"v":90,"d":"90.00"},81.24,2]
["20180116387",{"v":68,"d":"68.0"},{"v":90.5,"d":"90.50"},{"v":89.4,"d":"89.40"},81.17,3]
["20180116384",67.5,{"v":90.8,"d":"90.80"},{"v":89.6,"d":"89.60"},{"v":81.11999999999999,"d":"81.12"},4]
["20180116042",69.5,{"v":86.8,"d":"86.80"},{"v":90.2,"d":"90.20"},{"v":80.9,"d":"80.90"},5]
["20180116037",69.5,{"v":87.7,"d":"87.70"},{"v":88.4,"d":"88.40"},80.63,6]
["20180116140",72.5,{"v":86.2,"d":"86.20"},{"v":85.2,"d":"85.20"},80.42,7]
["20180116260",{"v":68,"d":"68.0"},{"v":90,"d":"90.00"},{"v":87,"d":"87.00"},{"v":80.3,"d":"80.30"},8]
["20180116319",67.5,{"v":88.4,"d":"88.40"},{"v":89.2,"d":"89.20"},80.28,9]
["20180116192",67.5,{"v":86.4,"d":"86.40"},{"v":88.6,"d":"88.60"},{"v":79.5,"d":"79.50"},10]
["20180116142",67.5,{"v":88.6,"d":"88.60"},{"v":85.4,"d":"85.40"},{"v":79.2,"d":"79.20"},11]
["20180116048",{"v":68,"d":"68.0"},{"v":86.5,"d":"86.50"},{"v":85.6,"d":"85.60"},78.83,12]
["20180116323",{"v":70,"d":"70.0"},{"v":78.5,"d":"78.50"},{"v":88.4,"d":"88.40"},78.07,13]
["20180116084",71.5,{"v":81.6,"d":"81.60"},{"v":82,"d":"82.00"},{"v":77.67999999999999,"d":"77.68"},14]
["20180116347",68.5,{"v":82,"d":"82.00"},{"v":85.4,"d":"85.40"},77.62,15]
["20180116103",{"v":71,"d":"71.0"},{"v":78.9,"d":"78.90"},{"v":83.4,"d":"83.40"},77.09,16]
["20180116395",67.5,{"v":83,"d":"83.00"},{"v":82.4,"d":"82.40"},76.62,17]
["20180116118",67.5,{"v":83.2,"d":"83.20"},{"v":82.2,"d":"82.20"},76.62,18]
["20180116266",67.5,{"v":79.6,"d":"79.60"},{"v":84.6,"d":"84.60"},{"v":76.25999999999999,"d":"76.26"},19]
["20180116206",69.5,{"v":77.5,"d":"77.50"},{"v":83.8,"d":"83.80"},76.19,20]
["20180116187",67.5,{"v":79.8,"d":"79.80"},{"v":81,"d":"81.00"},75.24,21]
["20180116195",{"v":68,"d":"68.0"},{"v":78.8,"d":"78.80"},{"v":81.2,"d":"81.20"},{"v":75.2,"d":"75.20"},22]
["20180116131",67.5,{"v":79.7,"d":"79.70"},{"v":79,"d":"79.00"},74.61,23]
["20180116067",68.5,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":27.400000000000002,"d":"27.40"},24]