{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":145,"n_cols":11,"rows_kept":145,"merged":[[0,0,0,10],[142,5,147,5],[142,7,144,7],[143,8,144,9],[144,0,145,4]],"flags":["formulas_cached_only"]}
["安徽职业技术学院2018年度人才招聘专业测试（面试）成绩及合成成绩表"]
["总序号","序号","准考证号","性别","岗位号","笔试成绩","进入专业测试排名","专业测试（面试）成绩","合成成绩","拟进入体检环节人选","备注"]
[1,1,18010111,"男","机电学院（180101）",75.5,2,84.2,{"v":75.68666666666667,"d":"75.69"},"总成绩第一名"]
[2,2,18010117,"男","机电学院（180101）",71.5,3,76.6,{"v":69.79333333333332,"d":"69.79"}]
[3,3,18010105,"男","机电学院（180101）",79.5,1,0,{"v":26.5,"d":"26.50"},null,"弃考"]
[4,1,18010115,"女","机电学院（180101）",83.5,1,80.6,{"v":76.19333333333333,"d":"76.19"},"总成绩第一名"]
[5,2,18010116,"女","机电学院（180101）",79.5,2,76.2,72.22]
[6,3,18010114,"女","机电学院（180101）",78.5,3,75.2,{"v":71.28666666666666,"d":"71.29"}]
[7,1,18020117,"女","管理学院（180201）",87,2,83.2,78.92,"总成绩第一名"]
[8,2,18020107,"男","管理学院（180201）",86.5,3,80.2,{"v":76.95333333333333,"d":"76.95"}]
[9,3,18020123,"女","管理学院（180201）",89.5,1,68,{"v":70.63333333333334,"d":"70.63"}]
[10,4,18020108,"男","管理学院（180201）",86.5,3,null,{"v":28.83333333333334,"d":"28.83"},null,"缺考"]
[11,1,18020303,"女","管理学院（180203）",88.5,1,88.2,82.42,"总成绩第一名"]
[12,2,18020302,"女","管理学院（180203）",80,2,78.4,{"v":73.70666666666668,"d":"73.71"}]
[13,3,18020301,"女","管理学院（180203）",72.5,3,77.8,{"v":70.84666666666666,"d":"70.85"}]
[14,1,18020404,"女","管理学院（180204）",88.5,"1(超过平均分)",87.6,82.06,"总成绩第一名，且专业测试(面试)成绩高于平均分"]
[15,2,18020401,"女","管理学院（180204）",85.5,"2(超过平均分)",74.4,73.14]
[16,1,18020501,"男","管理学院（180205）",88,1,85.8,{"v":80.81333333333333,"d":"80.81"},"总成绩第一名"]
[17,2,18020517,"女","管理学院（180205）",87.5,2,85.8,{"v":80.64666666666668,"d":"80.65"}]
[18,3,18020515,"女","管理学院（180205）",87.5,2,81,{"v":77.76666666666668,"d":"77.77"}]
[19,1,18020605,"女 ","管理学院（180206）",84,2,80.2,76.12,"总成绩第一名，且专业测试(面试)成绩高于平均分"]
[20,2,18020601,"女","管理学院（180206）",87,1,null,{"v":29,"d":"29.00"},null,"缺考"]
[21,3,18020603,"女","管理学院（180206）",81,3,null,{"v":27,"d":"27.00"},null,"缺考"]
[22,1,18030201,"女","纺织服装学院（180302）",83.5,"1(超过平均分)",82.4,{"v":77.27333333333334,"d":"77.27"},"总成绩第一名，且专业测试(面试)成绩高于平均分"]
[23,1,18030301,"女","纺织服装学院（180303）",68,1,78.4,{"v":69.70666666666668,"d":"69.71"},"总成绩第一名"]
[24,2,18030302,"女","纺织服装学院（180303）",61.5,3,80,{"v":68.5,"d":"68.50"}]
[25,3,18030304,"女","纺织服装学院（180303）",62,2,78.2,{"v":67.58666666666667,"d":"67.59"}]
[26,1,18040108,"女","汽车学院（180401）",85,1,83.8,{"v":78.61333333333333,"d":"78.61"},"总成绩第一名"]
[27,2,18040102,"女","汽车学院（180401）",83,2,82,{"v":76.86666666666667,"d":"76.87"}]
[28,3,18040101,"女","汽车学院（180401）",76.5,3,77.3,71.88]
[29,1,18040202,"女","汽车学院（180402）",75.5,3,83.4,{"v":75.20666666666668,"d":"75.21"},"总成绩第一名"]
[30,2,18040201,"男","汽车学院（180402）",76,2,77.8,{"v":72.01333333333334,"d":"72.01"}]
[31,3,18040203,"男","汽车学院（180402）",78.5,1,73.2,{"v":70.08666666666667,"d":"70.09"}]
[32,1,18040301,"男","汽车学院（180403）",83.5,1,81.2,{"v":76.55333333333334,"d":"76.55"},"总成绩第一名"]
[33,2,18040303,"男","汽车学院（180403）",73.5,3,80.2,72.62]
[34,3,18040304,"男","汽车学院（180403）",78,2,75.8,{"v":71.47999999999999,"d":"71.48"}]
[35,1,18040404,"男","汽车学院（180404）",84.5,1,82.8,{"v":77.84666666666666,"d":"77.85"},"总成绩第一名，且专业测试(面试)成绩高于平均分"]
[36,2,18040403,"女","汽车学院（180404）",74.5,2,null,{"v":24.833333333333336,"d":"24.83"},null,"缺考"]
[37,1,18050101,"女","环境与化工学院（180501）",79,1,80.7,{"v":74.75333333333334,"d":"74.75"},"总成绩第一名"]
[38,2,18050104,"男","环境与化工学院（180501）",75,3,81.3,73.78]
[39,3,18050102,"女","环境与化工学院（180501）",78,2,77.1,{"v":72.25999999999999,"d":"72.26"}]
[40,1,18050206,"男","环境与化工学院（180502）",78,1,72.4,69.44,"总成绩第一名，但专业测试(面试)成绩低于平均分","岗位取消"]
[41,1,18050307,"女","环境与化工学院（180503）",84.5,3,83.6,{"v":78.32666666666667,"d":"78.33"},"总成绩第一名"]
[42,2,18050302,"女","环境与化工学院（180503）",87,2,80,{"v":77,"d":"77.00"}]
[43,3,18050316,"女","环境与化工学院（180503）",84.5,3,73.3,{"v":72.14666666666668,"d":"72.15"}]
[44,4,18050305,"女","环境与化工学院（180503）",94,1,null,{"v":31.33333333333334,"d":"31.33"},null,"缺考"]
[45,1,18060103,"男","信息工程学院（180601）",87.5,"1(超过平均分)",85.4,{"v":80.40666666666667,"d":"80.41"},"总成绩第一名，且专业测试(面试)成绩高于平均分"]
[46,2,18060101,"女","信息工程学院（180601）",77,"2(超过平均分)",82.4,{"v":75.10666666666668,"d":"75.11"}]
[47,1,18060302,"男","信息工程学院（180603）",89,"1(超过平均分)",85.6,{"v":81.02666666666667,"d":"81.03"},"总成绩第一名，且专业测试(面试)成绩高于平均分"]
[48,1,18060306,"女","信息工程学院（180603）",75,1,81.2,73.72,"总成绩第一名"]
[49,2,18060308,"女","信息工程学院（180603）",72.5,2,78.6,{"v":71.32666666666667,"d":"71.33"}]
[50,3,18060307,"女","信息工程学院（180603）",70,3,76.8,{"v":69.41333333333333,"d":"69.41"}]
[51,1,18070207,"男","机械工程学院（180702）",79,3,82.6,{"v":75.89333333333333,"d":"75.89"},"总成绩第一名"]
[52,2,18070217,"女","机械工程学院（180702）",73.5,5,84.8,75.38,"总成绩第二名"]
[53,3,18070215,"男","机械工程学院（180702）",91.5,1,74.2,{"v":75.02000000000001,"d":"75.02"}]
[54,4,18070219,"女","机械工程学院（180702）",80,2,78.8,{"v":73.94666666666666,"d":"73.95"}]
[55,5,18070214,"男","机械工程学院（180702）",76.5,4,78.6,72.66]
[56,6,18070203,"男","机械工程学院（180702）",73,6,74.8,{"v":69.21333333333334,"d":"69.21"}]
[57,1,18070304,"女","机械工程学院（180703）",82.5,1,80.8,{"v":75.97999999999999,"d":"75.98"},"总成绩第一名"]
[58,2,18070305,"男","机械工程学院（180703）",79.5,2,76.2,72.22,"总成绩第二名"]
[59,3,18070302,"男","机械工程学院（180703）",70.5,5,73.6,67.66]
[60,4,18070303,"男","机械工程学院（180703）",77.5,3,67.4,{"v":66.27333333333334,"d":"66.27"}]
[61,5,18070301,"女","机械工程学院（180703）",75,4,68.4,{"v":66.03999999999999,"d":"66.04"}]
[62,1,18090104,"女","财经商贸学院（180901）",78,2,83.7,76.22,"总成绩第一名"]
[63,2,18090101,"女","财经商贸学院（180901）",77.5,3,78.6,{"v":72.99333333333334,"d":"72.99"}]
[64,3,18090102,"女","财经商贸学院（180901）",80.5,1,74.2,{"v":71.35333333333334,"d":"71.35"}]
[65,1,18100122,"女","基础教学部（181001）",83,3,78.7,{"v":74.88666666666667,"d":"74.89"},"总成绩第一名，且专业测试(面试)成绩高于平均分"]
[66,2,18100123,"女","基础教学部（181001）",85,2,75.4,{"v":73.57333333333334,"d":"73.57"}]
[67,3,18100102,"女","基础教学部（181001）",85.5,1,null,{"v":28.5,"d":"28.50"},null,"缺考"]
[68,1,18100226,"女","基础教学部（181002）",90,2,84.4,80.64,"总成绩第一名"]
[69,2,18100216,"男","基础教学部（181002）",91,1,82.3,{"v":79.71333333333334,"d":"79.71"},"总成绩第二名"]
[70,3,18100213,"男","基础教学部（181002）",87.5,4,83.6,{"v":79.32666666666667,"d":"79.33"}]
[71,4,18100202,"女","基础教学部（181002）",88.5,3,80.6,{"v":77.85999999999999,"d":"77.86"}]
[72,5,18100227,"女","基础教学部（181002）",84,6,80.7,76.42]
[73,6,18100222,"女","基础教学部（181002）",87,5,75,{"v":74,"d":"74.00"}]
[74,1,18100303,"男","基础教学部（181003）网球方向",75.5,"网球 2",86.2,{"v":76.88666666666667,"d":"76.89"},"总成绩第一名，且专业测试(面试)成绩高于平均分"]
[75,2,18100301,"男","基础教学部（181003）网球方向",74.5,"网球 3",84.8,{"v":75.71333333333334,"d":"75.71"}]
[76,3,18100312,"男","基础教学部（181003）网球方向",77.5,"网球 1",null,{"v":25.83333333333334,"d":"25.83"},null,"缺考"]
[77,1,18100302,"女","基础教学部（181003）排球方向",77,"排球 1",84.8,{"v":76.54666666666667,"d":"76.55"},"总成绩第一名，且专业测试(面试)成绩高于平均分"]
[78,1,18110120,"男","马克思主义学院（181101）",80.5,3,85.8,{"v":78.31333333333333,"d":"78.31"},"总成绩第一名"]
[79,2,18110103,"男","马克思主义学院（181101）",87.5,1,80.3,{"v":77.34666666666666,"d":"77.35"}]
[80,3,18110133,"男","马克思主义学院（181101）",82.5,2,76.8,73.58]
[81,1,18110107,"女","马克思主义学院（181101）",86,1,81.3,{"v":77.44666666666666,"d":"77.45"},"总成绩第一名"]
[82,2,18110131,"女","马克思主义学院（181101）",84,2,81.3,76.78]
[83,3,18110104,"女","马克思主义学院（181101）",82,3,70.3,{"v":69.51333333333334,"d":"69.51"}]
[84,1,18120109,"男","艺术设计学院（181201）",75,1,82.6,74.56,"总成绩第一名，且专业测试(面试)成绩高于平均分"]
[85,2,18120105,"男","艺术设计学院（181201）",63,2,79.8,68.88]
[86,3,18120104,"男","艺术设计学院（181201）",61.5,3,null,{"v":20.5,"d":"20.50"},null,"缺考"]
[87,1,18120114,"女","艺术设计学院（181201）",81,1,83.3,{"v":76.97999999999999,"d":"76.98"},"总成绩第一名"]
[88,2,18120101,"女","艺术设计学院（181201）",71.5,3,78.2,{"v":70.75333333333333,"d":"70.75"}]
[89,3,18120103,"女","艺术设计学院（181201）",74.5,2,71.9,{"v":67.97333333333333,"d":"67.97"}]
[90,1,18140130,"男","组织部、纪委办（181401）",72,2,80.2,72.12,"总成绩第一名，且专业测试(面试)成绩高于平均分"]
[91,2,18140129,"男","组织部、纪委办（181401）",75,1,78.1,{"v":71.85999999999999,"d":"71.86"}]
[92,1,18140108,"女","组织部、纪委办（181401）",79.5,2,82.74,{"v":76.144,"d":"76.14"},"总成绩第一名"]
[93,2,18140117,"女","组织部、纪委办（181401）",83.5,1,80.41,{"v":76.07933333333334,"d":"76.08"}]
[94,3,18140113,"女","组织部、纪委办（181401）",79,3,77.5,{"v":72.83333333333334,"d":"72.83"}]
[95,1,18160110,"女","教务处（181601）",82,1,78.4,{"v":74.37333333333333,"d":"74.37"},"总成绩第一名"]
[96,2,18160109,"女","教务处（181601）",79.5,2,79.2,{"v":74.02000000000001,"d":"74.02"}]
[97,3,18160101,"女","教务处（181601）",79,3,74.1,{"v":70.79333333333334,"d":"70.79"}]
[98,1,18170201,"女","财务处（181702）",87.5,1,67,{"v":69.36666666666667,"d":"69.37"},"总成绩第一名"]
[99,2,18170203,"女","财务处（181702）",75,2,72.4,68.44]
[100,3,18170205,"女","财务处（181702）",74.5,3,67.7,{"v":65.45333333333333,"d":"65.45"}]
[101,1,18190109,"男","创新创业学院、国资办（181901）",85,1,74.2,{"v":72.85333333333334,"d":"72.85"},"总成绩第一名"]
[102,2,18190120,"男","创新创业学院、国资办（181901）",83.5,2,75,{"v":72.83333333333334,"d":"72.83"}]
[103,3,18190107,"男","创新创业学院、国资办（181901）",82.5,3,69.4,69.14]
[104,1,18190119,"女","创新创业学院、国资办（181901）",85.5,2,82.8,78.18,"总成绩第一名"]
[105,2,18190117,"女","创新创业学院、国资办（181901）",80.5,3,82.6,{"v":76.39333333333333,"d":"76.39"}]
[106,3,18190102,"女","创新创业学院、国资办（181901）",86.5,1,76,{"v":74.43333333333334,"d":"74.43"}]
[107,1,18200107,"女","继续教育学院、校办（外办）（182001）",89,2,84,{"v":80.06666666666666,"d":"80.07"},"总成绩第一名"]
[108,2,18200106,"女","继续教育学院、校办（外办）（182001）",88,3,81.8,{"v":78.41333333333334,"d":"78.41"}]
[109,3,18200115,"女","继续教育学院、校办（外办）（182001）",91.5,1,79.8,78.38]
[110,1,18210102,"女","校团委（182101）",68.5,2,83.5,{"v":72.93333333333334,"d":"72.93"},"总成绩第一名"]
[111,2,18210104,"女","校团委（182101）",74,1,74,{"v":69.06666666666666,"d":"69.07"}]
[112,3,18210103,"女","校团委（182101）",61,3,81.2,{"v":69.05333333333334,"d":"69.05"}]
[113,1,18230104,"女","后勤中心（182301）",79.5,1,80.4,{"v":74.74000000000001,"d":"74.74"},"总成绩第一名"]
[114,2,18230111,"女","后勤中心（182301）",78,2,70,{"v":68,"d":"68.00"}]
[115,3,18230112,"女","后勤中心（182301）",73.5,3,70.2,66.62]
[116,1,18240139,"男","学生处（182401）",80,3,86.48,{"v":78.55466666666666,"d":"78.55"},"总成绩第一名"]
[117,2,18240149,"男","学生处（182401）",81.5,2,82.08,{"v":76.41466666666668,"d":"76.41"},"总成绩第二名"]
[118,3,18240150,"男","学生处（182401）",78,5,83.9,76.34]
[119,4,18240144,"男","学生处（182401）",82,1,80.36,{"v":75.54933333333334,"d":"75.55"}]
[120,5,18240138,"男","学生处（182401）",80,3,81.16,{"v":75.36266666666667,"d":"75.36"}]
[121,6,18240146,"男","学生处（182401）",76.5,6,81.06,{"v":74.136,"d":"74.14"}]
[122,1,18240132,"女","学生处（182401）",85.5,2,83.9,78.84,"总成绩第一名"]
[123,2,18240101,"女","学生处（182401）",85,3,82.15,{"v":77.62333333333333,"d":"77.62"},"总成绩第二名"]
[124,3,18240102,"女","学生处（182401）",86.5,1,79.28,{"v":76.40133333333334,"d":"76.40"},"总成绩第三名"]
[125,4,18240106,"女","学生处（182401）",83,4,79.66,{"v":75.46266666666668,"d":"75.46"}]
[126,5,18240105,"女","学生处（182401）",79,8,81.74,{"v":75.37733333333334,"d":"75.38"}]
[127,6,18240121,"女","学生处（182401）",80,7,78.27,{"v":73.62866666666667,"d":"73.63"}]
[128,7,18240120,"女","学生处（182401）",79,8,78.32,{"v":73.32533333333333,"d":"73.33"}]
[129,8,18240118,"女","学生处（182401）",79,8,76.82,{"v":72.42533333333333,"d":"72.43"}]
[130,9,18240108,"女","学生处（182401）",81,5,74.22,{"v":71.532,"d":"71.53"}]
[131,10,18240124,"女","学生处（182401）",81,5,0,{"v":27,"d":"27.00"},null,"弃考"]
[132,1,18240102,"女","教务处（182501）",87.5,1,79,{"v":76.56666666666666,"d":"76.57"},"总成绩第一名"]
[133,2,18240101,"女","教务处（182501）",72.5,3,82.5,{"v":73.66666666666667,"d":"73.67"}]
[134,3,18240104,"女","教务处（182501）",80.5,2,77.9,{"v":73.57333333333334,"d":"73.57"}]
[135,1,18260103,"男","人事处（182601）",88.5,1,81.6,78.46,"总成绩第一名"]
[136,2,18260119,"男","人事处（182601）",79,2,81.7,{"v":75.35333333333334,"d":"75.35"}]
[137,3,18260121,"男","人事处（182601）",77.5,3,66.8,{"v":65.91333333333334,"d":"65.91"}]
[138,1,18260107,"女","人事处（182601）",86.5,1,78.4,{"v":75.87333333333333,"d":"75.87"},"总成绩第一名"]
[139,2,18260124,"女","人事处（182601）",83,3,79.4,{"v":75.30666666666667,"d":"75.31"}]
[140,3,18260114,"女","人事处（182601）",83.5,2,73.8,{"v":72.11333333333333,"d":"72.11"}]
[{"$nulls":7},"专业测试(面试)平均分：77.85"]
[{"$nulls":8},"当天参加专业测试共132人，其中2人现场弃考，为0分"]
["合成总成绩（计算公式：笔试成绩÷1.2×0.4+专业测试成绩×0.6）"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}