Early Warning Attrition Tracker automated sheet - XLS Download

Good post. Makes sense to the Industry I belong. Can you pls throw some light on the scoring. I din't quite get the pattern.

Hi Mallet,
Really nice work done. If it is done based on last 3 yrs data then definitely we should considered it as a validated.
Its really new to the guys.
Thanks,
Amit Shah

Hi Mallet
I have made a few changes to make it more generalised instead of IT specific.
Let me know if its ok with you?

Dear Mallet,
Good work. Well I need a small clarification in this regard. Whom you think is a right person to input the score to the attrition sheet about the employee apart from HR

Hello....hello...
A Manager is a right person to score this sheet because he closely works with the team.....what do you think?

Very useful Mallet. Fantastic Post.
Just had a small query. Do we have to manually input the numeric value in the score column or the column above that ?
Kindly revert.

Good one but.. may be some guide lines at the beging of the sheet may help.. to put the figuers rightly..

Hey Mallet,
This is good work. It will be great if you can plug-in a sheet explaining usage (so that if someone else intends to use it, the sheet will be of great help)
Thanks
Kamal

Hold on team...I am working the usability part..there was a error in coding..i am rectifying that........

Hi Mallet,
Good work! However I think you might want to take a look at the one used by Genpact (formerly GE Capital Int'l Serrvices). For reasons of copyright, I will not upload it here, but you can always ask someone from Genpact to pass it on to you for a look...it is used very widely there..has been validated by use over last 7 years...is comprehensive and very well designed...though you might have to change a few assumptions for use elsewhere.
Just for the the record - Genpact's employee attrition is less than industry average by 1/3rd...of course, this tracker plays only a small part in the overall effort at conatinment