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
From India, Hyderabad

Attached Files (Download Requires Membership)
File Type: xls ewat_412.xls (34.0 KB, 9300 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.

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.

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

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

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.
Majestuoso. :wink:

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.
~Raghav V

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

From India, Hyderabad

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

Please Login To Add Reply →

About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 CiteHRô

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server