Early Warning Attrition Tracker automated sheet - XLS Download

Dear All, Please find attached the newly developed Early Warning Attrition Tracker. This might help you all. Its a automated sheet. In case you have queries please get back to me. Thanks Mallet
19th November 2007 From India, Hyderabad

Attached Files (Download Requires Membership)

ewat_412.xls (34.0 KB, 9760 views)

Hi Mallet,
Nice one indeed.But as you are expecting inputs.Let me give one I felt may be added to the file.
You can put in the major reasons(u highlighted only the "Compensations& Benefits) and score them individually.Becoz I dont think an employee leaves a organization, jus for compensation.
However, let me remind you again that the concept is interseting and you have a posted a wonderful file.
Ravi.
19th November 2007 From India, Vijayawada

Hi Mallet,
Fabulous nd a valueable post in my opinion. Thanks a TON 4 sharing. Wud u mind giveing ur mail-id or contact no. in case there's requirement 2 speak with u regarding this post.
THANKS once again 4 the valuable post.
Regds
Sharmistha
20th November 2007 From India, Mumbai

Hi Mallet, Nice file to have shared. I will use it for sometiume and then will let you know about the feedback. i really appreciate your sharing such a wonderful tool in this forum. Cheers
20th November 2007 From India, Gurgaon

Dear Mallet,
The format looks good! The parameters well defined and comprehensive. But is it feasible to rate individuals, most of us are sluggishly getting through Appraisals (annual/ half yearly), TNAs etc. Is there a way it could be developed or integrated with either the appraisal system or a group could be monitored? Just think about it.
regards,
20th November 2007 From India, Andheri

HI Mallet,
Congratulations! Good work...
I have few things to share / know on spread sheet.
1) what is the range of Scores i.e. 3 / 4 out of how many? is there any formula or rule to apply ?
2) what does figure represent colored with Black and option available to select from drop down menu ? what rule and formula to apply while selecting the cell from drop down menu...
i would suggest you to write few gideline on how to explore the spread sheet and what needs to be considered while working with spread sheet... i believe this guideline with help us to utilize the useful tool developed by you....
thanks...
Gaurang
20th November 2007 From India, Vadodara

Hi Mallet,
I would really appreciate your effort.
I tried with few employees at last what i found out is tat ppl whose is dissatisfied(looking to grow along with the company) are at high risk and need one to one. Is that you want to say through your excel?
May be im not so clear how to use you excel or in interpreting part.So could you please mail the guideline for this........
Waiting for your reply.
Regards,
Majestuoso. :wink:
20th November 2007 From India, Madras

A Fabulous work Mallet. Only one thing is missing for the beginners. GUIDELINES. Try to include that and atach it. Then it would be near perfect.
Hope you apply it soon. Anyways rated ur post. It was wonderful.
Regards,
~Raghav V
20th November 2007 From India, Kochi

Hi Mallet, I am not getting why your drop down scores have 4 and not 0 though in defining criteria you use 0-3 scores. Request you to clarify. Rgds, Shilpi
20th November 2007 From India, New Delhi

Dear All,
There is some problem with the excel sheet as the Guidelines were coded in VB on a screen which opens as soon as the excel file is opened. I will rectify that and post it soon.
Thanks
Mallet
20th November 2007 From India, Hyderabad