Attrition Calculator & Annual Register - Updated

Bobdeep
Folks,
6 Yrs back I had shared a ready calculator as an excel file to check attrition% and maintain as a register.
https://www.citehr.com/25836-attriti...-register.html
I am really happy to have more than 2000 downloads and many more members having accessed and commented on this thread. I see that even now some of the members have saved this file and continuing to share with others as knowledge sharing.
So again I have updated the file and re-posted the same for all your ready reference, if any update need to be made pls share so that I can incorporate the same.
In this excel file, which is a ready calculator and annual register of attrition you can know the attrition for the particular month and different quarters.
1st Sheet - Enter the data of your company/ organisation/ firm
2nd Sheet - Find the attrition % age calculated as per your data provided in sheet 1.
Regards,
Pradeep
1 Attachment(s) [Login To View]

Bobdeep
Attrition Formula - Attrition during the period/Avg Head count X 100
Avg Head count formula - (Opening balance of the period + closing balance of the period) /2
Pls note that the % for quarter is on avg factor only
FYI
Rgds
Pradeep
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute