Dear Jerry Anthony,
This post is on the MS Excel Workbook that you have shared. I have gone through the contents of the first worksheet. I found the glaring anomalies. These are as below:
a) Column B has the heading "KRA/KPI". This is incorrect. The heading projects that KRA and KPI both are the same. No these are not!
b) Some of the performance standards are not measurable at all. Yet, these are passed off as measurable.
c) The formula to calculate "Result" should be [(target/actual)*weight]*100. In the first example, since the target was equal to actual, the calculation error was nullified. However, in the second example, since the proper formula was not used, the score is coming to 30% instead of 60%. This would be a gross injustice to the employee!
Do you use this worksheet in your company or you have downloaded it from somewhere and uploaded it on this forum?
I have provided consulting services to establish a comprehensive Performance Management System (PMS). I write this post because of my experience in providing consulting services to several companies.
Thanks,
Dinesh Divekar
This post is on the MS Excel Workbook that you have shared. I have gone through the contents of the first worksheet. I found the glaring anomalies. These are as below:
a) Column B has the heading "KRA/KPI". This is incorrect. The heading projects that KRA and KPI both are the same. No these are not!
b) Some of the performance standards are not measurable at all. Yet, these are passed off as measurable.
c) The formula to calculate "Result" should be [(target/actual)*weight]*100. In the first example, since the target was equal to actual, the calculation error was nullified. However, in the second example, since the proper formula was not used, the score is coming to 30% instead of 60%. This would be a gross injustice to the employee!
Do you use this worksheet in your company or you have downloaded it from somewhere and uploaded it on this forum?
I have provided consulting services to establish a comprehensive Performance Management System (PMS). I write this post because of my experience in providing consulting services to several companies.
Thanks,
Dinesh Divekar