Human Resources
Business Consultant - Hr
Hr Executive
Manager Hr
Hr Executive
Hr Manager
State Hr Manager
Senior Analyst - Talent Management
Hr Professional
Agm-hr (training)
Hr Executive
Tapash Dey
Hr Mnager
Service(pvt. Sector)
Senior Manger

PRIME SPONSOR - FACTOHR - Customised Payroll, GPS Enabled Attendance, Travel, Performance Management, HRMS. Explore Features
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

Attached Files
Membership is required for download. Create An Account First
File Type: xls ewat_412.xls (34.0 KB, 8463 views)

Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
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.
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.
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
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.
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....
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:
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
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
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.
PRIME SPONSOR - TALENTEDGE "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA. View Courses

Add Reply Start A New Discussion

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™