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

From India, Bangalore
Attached Files (Download Requires Membership)
File Type: xls Attrition Calculator and Annual Register.xls (33.0 KB, 1797 views)

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

From India, Bangalore
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.