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

From Australia, Brisbane
mirza
18

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 .....

From Saudi Arabia, Jiddah
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.
From India, Ahmadabad
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.