XLS《第一季》

25,2.5,16.75,14,14,12,70.5,8 93020002,"伊静馨",15,2.75,15,16.75,12.25,11.25,73,7 93010001,"曾国苹",19.75,4.25,18.5,18,18,14.75,93.25,1 93020003,"蔡美伦",11,2.75,16,14,11.5,12,67.25,11 93020004,"陈小贞",16.25,3.5,16.5,15,12,12.5,75.75,5 93010002,"杨贵阳",14.5,4.25,16,18.25,15,12.5,80.5,3 93010003,"蔡伦哲",13.5,3,15.25,16.5,13.75,12.5,74.5,6 93020005,"郭婉柔",12,2,13,14.75,15.5,11.75,69,9 93010004,"林信宇",15.5,3.25,12,14.75,12,10.5,68,10 93010005,"曾国毕",12,2.25,15.75,13.25,10.75,12.25,66.25,12 93020006,"萧贞梅",15,3.25,16.75,14.5,16,12.25,77.75,4 93020007,"陈丽羿",19.25,4.5,18.5,18.5,18.75,13.25,92.75,2 "各项考核高分",,

19.75,4.5,18.5,18.5,18.75,14.75,,

"各项考核最低分",,

11,2,12,13.25,10.75,10.5,,

"未达标准者(70分)4,"人" 绩效成绩查询 ,,

,,

, "员工绩效考核分数查询",,

,,

,,

9,"vlookup公式",,

,,

, ,"员工编号"员工编号",93020003,,

, ,"姓名",林信宇,,

,,

,,

"姓名",蔡美伦,,

, ,"产品熟悉度",15.5,"反应能力",3.25,,

,,

"产品熟悉度",11,"反应能力",2.75, ,"销售能力",12,"产品展示",14.75,,

,,

"销售能力",16,"产品展示",14,,

,"客户满意度",12,"向心力",10.5,,

,,

"客户满意度",11.5,"向心力",12, ,"总分",68,,

,,

,,

"总分",67.25,,

, ,"名次",10,,

,,

,,

"名次",11,,

,