Dear All, Please find attached the newly developed Early Warning Attrition Tracker. This might help you all. It’s an automated sheet. In case you have queries please get back to me.
From India, Hyderabad
Attached Files (Download Requires Membership)
File Type: xls ewat_412.xls (34.0 KB, 9949 views)

Acknowledge(0)
Amend(0)

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.

From India, Vijayawada
Acknowledge(0)
Amend(0)

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

From India, Mumbai
Acknowledge(0)
Amend(0)

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
Acknowledge(0)
Amend(0)

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,

From India, Andheri
Acknowledge(0)
Amend(0)

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

From India, Vadodara
Acknowledge(0)
Amend(0)

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:

From India, Madras
Acknowledge(0)
Amend(0)

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

From India, Kochi
Acknowledge(0)
Amend(0)

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
Acknowledge(0)
Amend(0)

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

From India, Hyderabad
Acknowledge(0)
Amend(0)

Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.