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)


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 include the major reasons (you highlighted only the "Compensations & Benefits") and score them individually. Because I don't think an employee leaves an organization just for compensation.

However, let me remind you again that the concept is interesting, and you have posted a wonderful file.

Ravi.

From India, Vijayawada

Hi Mallet,

Fabulous and a valuable post in my opinion. Thanks a TON for sharing. Would you mind giving your mail ID or contact number in case there's a requirement to speak with you regarding this post?

THANKS once again for the valuable post.

Regards,
Sharmistha

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 are well defined and comprehensive. But is it feasible to rate individuals when 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 could a group be monitored? Just think about it.

Regards,

From India, Andheri

Hi Mallet,

Congratulations on the good work.

I have a few things to share/know about the spreadsheet:

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 the figure represent when colored with black and options available to select from the drop-down menu? What rule and formula should be applied while selecting the cell from the drop-down menu?

I would suggest you write a few guidelines on how to explore the spreadsheet and what needs to be considered while working with it. I believe these guidelines will help us utilize the useful tool you have developed.

Thanks,
Gaurang

From India, Vadodara

Hi Mallet,

I would really appreciate your effort. I tried with a few employees, and what I found out is that people who are dissatisfied (looking to grow along with the company) are at high risk and need one-on-one attention. Is that what you want to convey through your Excel?

Maybe I'm not so clear on how to use your Excel or interpret it. Could you please email the guidelines for this?

I am waiting for your reply.

Regards,
Majestuoso 😉

From India, Madras

A fabulous work Mallet. Only one thing is missing for the beginners: GUIDELINES. Try to include that and attach it. Then it would be near perfect.

Hope you apply it soon. Anyways, I rated your post. It was wonderful.

Regards,
~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 a problem with the Excel sheet as the guidelines were coded in VB on a screen that opens as soon as the Excel file is opened. I will rectify that and post it soon.

Thanks, Mallet

From India, Hyderabad

Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.








Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR �

All Copyright And Trademarks in Posts Held By Respective Owners.