Performance Appraisal Management - Spreadsheets

Samij
Hello Fellow HR comrades,
I am trying to bulid an excel spreadsheet that forecasts an employees next performance appraisal due date. I currently have a long list of employees, their start dates and when their last appraisal was complete. But there must be a better way to format it or report from it so I can see what reviews I need to do this month.
if anyone has anything that may assist I would dearly enjoy some assistance.
Thank you Kindly
mirza
Hi Samij,
Let me ask you few questions before getting into the suggestion mode
How big is the list and what is the turnover ratio
How frequently you do the assessment (Quarterly, Half or Annual)
if you have a longer list then i would suggest you to have a timeline for everybody....may be those who join post Sep 30th may not be eligible for annual assessment for that particular year..... n i think if you follow this, you may have to do the assessment for every one at the end of the year keeping in mind whatever the month they have joined and It is very easy for you to assess based on the vintage too
It you have a very minimal number then may be you can have an excel sheet prepared wherein make the DOJ as a unique key and caclulate their vintage and use the conditional format with colors for different stage
hope this is clear .....
tanuja.g@west-coast.in
Dear Friend,
Can you please provide me MIS Hr & Admin department fortmat. i am not aware of function as well but wants to prepare MIS report. kindly help me out.
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute