05-评分值转换加权分值工具（以试用期员工考核为例） (2).xlsx

人力资源管理实用工具绩效考核评分值转换加权分值工具（以试用期员工考核为例）说明：本工具主要用于将绩效考核评分值转换为加权分值。只需要将每位员工的姓名及评分值录入以下表格（颜色标注部分无需录入数据），即可自动计算出各指标加权分值及加权总分值。使用方法：先在以下表格上方，设置好各项指标内容及其权重值（本表格以试用期员工绩效考核指标为例，已经设置好），然后在表格右侧进行等级评分标准说明，最后填入评分值即可。注意：表格上方的指标权重值可以随便调整，只要保证数值科学合理即可，但是如果要增减指标项目，请注意调整相应的自动计算函数，所以不建议进行大调整。指指标标类类别别考勤方面#专业知识和技能方面 45%实际工作达成情况方面 30%态度和品质方面指指标标明明细细指标1指标2指标3指标4指标5指标6指标7指标8指标9指标10指标11指标12指标1310.00%20.00%5.00%5.00%5.00%5.00%5.00%12.00%5.00%5.00%8.00%5.00%5.00%出勤情况专业知识能力沟通及理解能力团队协作能力服务意识和亲和力创新能力学习进取能力工作执行力工作效率及抗压性工作任务饱和度和难易度工作经验契合度诚实守信责任心员工姓名评分值加权分值评分值加权分值评分值加权分值评分值加权分值评分值加权分值评分值加权分值评分值加权分值评分值加权分值评分值加权分值评分值加权分值评分值加权分值评分值加权分值评分值加权分值美人鱼1510.00416.0033.0022.0033.0033.0022.00512.0022.0033.0046.4055.0044.00美人鱼2510.0028.0022.0033.0022.0055.0033.00512.0033.0033.0023.2022.0055.00美人鱼324.00312.0044.0044.0044.0033.0022.0024.8011.0055.0034.8044.0055.00美人鱼448.0028.0022.0033.0022.0022.0033.0049.6033.0044.0023.2022.0033.00美人鱼524.00312.0033.0055.0033.0055.0011.0024.8055.0022.0034.8033.0022.00美人鱼636.00520.0011.0033.0011.0044.0033.0037.2033.0055.0058.0033.0055.00美人鱼712.00312.0033.0022.0033.0055.0055.0037.2022.0011.0034.8022.0044.00版权所有：北京未名潮管理顾问有限公司何建湘美人鱼836.0028.0055.0055.0055.0044.0033.0024.8055.0022.0058.0055.0055.00美人鱼9510.00520.0044.0055.0044.0055.0055.00512.0044.0033.0034.8055.0055.00美人鱼1036.00416.0022.0055.0022.0044.0033.0049.6033.0055.0046.4055.0055.00美人鱼1124.00520.0055.0044.0055.0055.0044.00512.0055.0033.0058.0044.0044.00美人鱼12510.00416.0011.0055.0011.0033.0055.0049.6044.0022.0046.4022.0055.00美人鱼1312.00520.0033.0055.0022.0022.0044.0024.8055.0055.0034.8055.0033.00美人鱼14510.00416.0055.0022.0033.0055.0055.00512.0044.0044.0023.2011.0022.00美人鱼1548.00520.0033.0044.0055.0044.0044.0012.4055.0033.0058.0044.0055.00美人鱼16510.00312.0022.0022.0033.0055.0055.0037.2044.0044.0046.4055.0033.00美人鱼1748.0028.0055.0033.0022.0044.0044.00512.0022.0055.0058.0044.0022.00美人鱼1824.00520.0011.0011.0055.0055.0055.0037.2033.0044.0046.4055.0055.00美人鱼1936.00416.0055.0033.0044.0044.0044.0024.8055.0055.0058.0044.0011.00美人鱼20510.00520.0044.0055.0055.0022.0055.00512.0033.0044.0046.4022.0022.00美人鱼2136.00416.0055.0044.0044.0033.0044.0012.4022.0055.0058.0033.0033.00美人鱼2224.00520.0055.0055.0055.0055.0055.0049.6055.0055.0058.0055.0055.00美人鱼2300.00416.0055.0044.0044.0033.0044.0049.6044.0055.0023.2044.0022.00美人鱼24510.0028.0044.0055.0055.0055.0055.0024.8044.0033.0058.0055.0033.00美人鱼2536.00312.0055.0044.0033.0033.0044.0037.2033.0022.0046.4033.0055.00美人鱼2624.00520.0044.0022.0022.0022.0022.00512.0055.0033.0058.0033.0022.00美人鱼2736.00312.0022.0033.0055.0055.0033.0037.2033.0044.0034.8055.0033.00美人鱼2824.00520.0033.0055.0044.0044.0055.00512.0055.0022.0058.0033.0044.00美人鱼2900.00312.0055.0033.0055.0055.0033.0037.2033.0033.0046.4033.0044.00美人鱼30510.0028.0033.0055.0055.0044.0055.0024.8022.0044.0058.0044.0055.00版版权权所所有有：北北京京未未名名潮潮管管理理顾顾问问有有限限公公司司版权所有：北京未名潮管理顾问有限公司何建湘版版权权所所有有：北北京京未未名名潮潮管管理理顾顾问问有有限限公公司司版权所有：北京未名潮管理顾问有限公司何建湘15%加权后实际分值合计指标14指标153.00%2.00%职业道德工作热情与精神面貌评分值加权分值评分值加权分值评分标准此标准仅供参考，可自行设定。42.4052.0075.80满满分分5 531.8041.6064.60员员工工表表现现分分值值标标准准1.其中，员工表现也可以按照是否符合要求的级别来设定；2.表格中评分除了按照此标准外，也可以直接计分，例如含小数点的任一值，3.2,4.5。21.2041.6060.40表表现现很很好好5 542.4031.2056.40表表现现较较好好4 453.0052.0059.60一一般般3 342.4031.2072.80表表现现不不太太好好2 231.8052.0056.80表表现现不不好好1 1态度和品质方面版权所有：北京未名潮管理顾问有限公司何建湘21.2031.2068.20很很不不好好0 053.0052.0091.80各项指标权重值标准此处权重值标准为自动生成。42.4052.0076.4053.0031.2087.20满满分分10010042.4020.8073.20指指标标序序号号权权重重比比例例权权重重值值1.左侧表格中指标序号、权重比例及权重值为自动生成，数据来源：考核评分统计总表；2.此处也可以手工输入数据，但需要与总表中保持一致；3.本表还可以用来检测表格中权重值是否设置正确。（若合计值自动显示满分值，则表明设置准确无误）53.0041.6070.20指指标标1 110%10%101042.4052.0076.60指指标标2 220%20%202053.0041.6080.00指指标标3 35%5%5 531.8052.0072.40指指标标4 4 5%5%5 521.2041.6069.80指指标标5 55%5%5 531.8052.0075.40指指标标6 65%5%5 553.0031.2074.00指指标标7 75%5%5 542.4020.8083.60指指标标8 812%12%121253.0031.2069.60指指标标9 95%5%5 553.0041.6091.20指指标标10105%5%5 553.0052.0068.80指指标标11118%8%8 831.8041.6073.20指指标标12125%5%5 521.2031.2066.00指指标标13135%5%5 553.0020.8072.80指指标标14143%3%3 342.4052.0067.40指指标标15152%2%2 253.0041.6083.60合计100%10031.8052.0063.4042.4041.6071.801.其中，员工表现也可以按照是否符合要求的级别来设定；2.表格中评分除了按照此标准外，也可以直接计分，例如含小数点的任一值，3.2,4.5。版权所有：北京未名潮管理顾问有限公司何建湘版权所有：北京未名潮管理顾问有限公司何建湘版权所有：北京未名潮管理顾问有限公司何建湘版权所有：北京未名潮管理顾问有限公司何建湘版权所有：北京未名潮管理顾问有限公司何建湘