1、 人力资源管理实用工具绩效考核评价等级转换加权分值工具（以试用期员工考核为例）说明：本工具主要用于将绩效考核等级评价结果（各项指标的考核评价为等级评价方式）直接转换为评分值以及加权分值。只需要将每位员工的评价结果信息（各项指标评价后等级）录入以下表格中，即可自动计算出各指标加权分值及加权总分值。使用方法：先在以下表格上方，设置好各项指标内容及其权重值（本表格以试用期员工绩效考核指标为例，已经设置好），然后在表格右侧设置好等级评分标准，最后填入评价等级便自动生成所有数据。注意：表格上方的指标权重值可以随便调整，只要保证数值科学合理即可，但是如果要增减指标项目，请注意调整相应的自动计算函数，所以不2、建议进行大调整。指指标标类类别别考勤方面10%专业知识和技能方面 45%实际工作达成情况方面指指标标明明细细指标110.00%指标220.00%指标35.00%指标45.00%指标55.00%指标65.00%指标75.00%指标812.00%指标9出勤情况专业知识能力沟通及理解能力团队协作能力服务意识和亲和力创新能力学习进取能力工作执行力工作效率及抗压性员工姓名评价等级转换分值实际分值评价等级转换分值实际分值评价等级转换分值实际分值评价等级转换分值实际分值评价等级转换分值实际分值评价等级转换分值实际分值评价等级转换分值实际分值评价等级转换分值实际分值评价等级美人鱼1A510.00B416.003、C33.00D22.00C33.00C33.00D22.00A512.00D美人鱼2A510.00D28.00D22.00C33.00D22.00A55.00B44.00A512.00C美人鱼3D24.00C312.00B44.00D22.00B44.00C33.00D22.00D24.80E美人鱼4B48.00D28.00D22.00C33.00D22.00D22.00C33.00B49.60C美人鱼5D24.00C312.00C33.00A55.00C33.00A55.00E11.00D24.80A美人鱼6C36.00A520.00E11.00C33.00E11.00B44.00C33.04、0C37.20C美人鱼7E12.00C312.00C33.00D22.00C33.00A55.00A55.00C37.20D美人鱼8C36.00D28.00A55.00A55.00A55.00B44.00C33.00D24.80A美人鱼9A510.00A520.00C33.00B44.00C33.00A55.00A55.00A512.00E版权所有：北京未名潮管理顾问有限公司何建湘美人鱼10C36.00B416.00D22.00A55.00D22.00B44.00C33.00B49.60C美人鱼11D24.00A520.00A55.00B44.00A55.00A55.00B44.00A512.5、00A美人鱼12A510.00B416.00E11.00A55.00E11.00C33.00A55.00B49.60B美人鱼13E12.00A520.00C33.00A55.00D22.00D22.00B44.00D24.80A美人鱼14A510.00B416.00A55.00D22.00C33.00A55.00A55.00A512.00B美人鱼15B48.00A520.00C33.00B44.00A55.00B44.00B44.00E12.40A美人鱼16A510.00C312.00D22.00D22.00C33.00A55.00A55.00C37.20B美人鱼17B48.00D28.00A6、55.00C33.00D22.00B44.00B44.00A512.00D美人鱼18D24.00A520.00E11.00E11.00A55.00A55.00A55.00C37.20C美人鱼19C36.00B416.00A55.00C33.00B44.00B44.00B44.00D24.80A美人鱼20A510.00A520.00B44.00A55.00A55.00D22.00A55.00A512.00C美人鱼21C36.00B416.00A55.00B44.00B44.00C33.00B44.00E12.40D美人鱼22D24.00A520.00B44.00A55.00A55.00A55.07、0A55.00C37.20C美人鱼23F00.00B416.00A55.00B44.00B44.00C33.00B44.00B49.60B美人鱼24A510.00D28.00B44.00A55.00A55.00A55.00A55.00D24.80B美人鱼25C36.00C312.00A55.00B44.00C33.00C33.00B44.00C37.20C美人鱼26D24.00A520.00B44.00D22.00D22.00D22.00D22.00A512.00A美人鱼27C36.00C312.00D22.00C33.00A55.00A55.00C33.00C37.20C美人鱼28D24.08、0A520.00C33.00A55.00B44.00B44.00A55.00A512.00A美人鱼29F00.00C312.00A55.00C33.00A55.00A55.00C33.00C37.20C美人鱼30A510.00D28.00C33.00A55.00A55.00B44.00A55.00D24.80D版权所有：北京未名潮管理顾问有限公司何建湘30%态度和品质方面 15%加权后实际分值合计5.00%指标105.00%指标118.00%指标125.00%指标135.00%指标143.00%指标152.00%工作任务饱和度和难易度工作经验契合度诚实守信责任心职业道德工作热情与精神面貌转换分9、值实际分值评价等级转换分值实际分值评价等级转换分值实际分值评价等级转换分值实际分值评价等级转换分值实际分值评价等级转换分值实际分值评价等级转换分值实际分值等级评分标准22.00E11.00B46.40A55.00B44.00B42.40A52.0073.80满满分分33.00C33.00D23.20D22.00A55.00C31.80B41.6065.60等等级级11.00A55.00C34.80B44.00B44.00D21.20D20.8056.60A A33.00C33.00E11.60D22.00C33.00B42.40C31.2053.80B B55.00D22.00C34.80C310、3.00D22.00A53.00A52.0059.60C C33.00A55.00A58.00C33.00A55.00B42.40C31.2072.80D D22.00E11.00C34.80D22.00B44.00C31.80A52.0056.80E E55.00D22.00A58.00A55.00A55.00D21.20C31.2068.20F F11.00C33.00C34.80B44.00B44.00A53.00D20.8082.60各项指标权重值标准实际工作达成情况方面指标9工作效率及抗压性版权所有：北京未名潮管理顾问有限公司何建湘33.00A55.00B46.40A55.00A5511、.00B42.40A52.0076.4055.00C33.00A58.00B44.00B44.00A53.00C31.2087.20满满分分44.00D22.00B46.40D22.00A55.00B42.40D20.8073.20指指标标序序号号55.00A55.00C34.80A55.00C33.00A53.00B41.6070.20指指标标1 144.00B44.00D23.20E11.00D22.00B42.40A52.0076.60指指标标2 255.00C33.00A58.00B44.00A55.00A53.00B41.6080.00指指标标3 344.00B44.00B46.4012、A55.00C33.00C31.80A52.0072.40指指标标4 4 22.00A55.00A58.00B44.00D22.00D21.20B41.6069.80指指标标5 533.00B44.00B46.40A55.00A55.00C31.80A52.0075.40指指标标6 655.00A55.00A58.00B44.00E11.00A53.00C31.2074.00指指标标7 733.00B44.00B46.40D22.00D22.00B42.40D20.8083.60指指标标8 822.00A55.00A58.00C33.00C33.00A53.00C31.2069.60指指标标913、 933.00C33.00C34.80A55.00A55.00B42.40B41.6080.00指指标标101044.00A55.00D23.20B44.00D22.00A53.00A52.0068.80指指标标111144.00C33.00A58.00A55.00C33.00C31.80B41.6073.20指指标标121233.00D22.00B46.40C33.00A55.00D21.20C31.2066.00指指标标131355.00C33.00A58.00C33.00D22.00A53.00D20.8072.80指指标标141433.00B44.00C34.80A55.00C33.014、0B42.40A52.0067.40指指标标151555.00D22.00A58.00C33.00B44.00A53.00B41.6083.60合计33.00C33.00B46.40C33.00B44.00C31.80A52.0063.4022.00B44.00A58.00B44.00A55.00B42.40B41.6071.80各项指标权重值标准版权所有：北京未名潮管理顾问有限公司何建湘请在此输入等级评分标准。5 5分分值值标标准准其中，字母序号表示等级或者程度，例如表现很好、比较好、一般、不太好、不好、很不好。5 54 43 32 21 10 0此处权重值标准为自动生成。等级评分标准各项指15、标权重值标准版权所有：北京未名潮管理顾问有限公司何建湘100100权权重重比比例例权权重重值值1.左侧表格中指标序号、权重比例及权重值为自动生成，数据来源：考核评分统计总表；2.此处也可以手工输入数据，但需要与总表中保持一致；3.本表还可以用来检测表格中权重值是否设置正确。（若合计值自动显示满分值，则表明设置准确无误）10%10%101020%20%20205%5%5 55%5%5 55%5%5 55%5%5 55%5%5 512%12%12125%5%5 55%5%5 58%8%8 85%5%5 55%5%5 53%3%3 32%2%2 2100%100各项指标权重值标准满满分分此处权重值标准为自动生成。版权所有：北京未名潮管理顾问有限公司何建湘