Hi,

I have enclosed an Excel file, which is a ready calculator and annual register of attrition. Here you can track the attrition for a particular month and different quarters.

1st Sheet - Enter the data of your company/organization/firm.
2nd Sheet - Find the attrition percentage calculated based on the data provided in sheet 1.

Regards,
Pradeep

From India, Bangalore
Attached Files (Download Requires Membership)
File Type: xls attrition_calculator_and_register_111.xls (23.0 KB, 2751 views)

Acknowledge(0)
Amend(0)

Hi Pradeep,

When I am trying to "Unprotect" the second sheet and make certain changes, it is asking for a password. Can you please share that password with us or mail me the password to .

Thanks & regards,
Deepak Parbat

From India, Pune
Acknowledge(0)
Amend(0)

one of the best resources to be put online as many members have been asking about attrition calculation,formula etc
From India, Mumbai
Acknowledge(0)
Amend(0)

Hi, The formula used for the calculation is : Attrition %age = Attrition / ( / 2) * 100 Thanks, Pradeep
From India, Bangalore
Acknowledge(0)
Amend(0)

Hi, I have protected the 2nd sheet, as that is only result sheet and no entries are required. However, 1st sheet can be edited as per your data entries. Pradeep
From India, Bangalore
Acknowledge(0)
Amend(0)

This is a wonderful tool, and I am sure it will suffice the needs of many members here who keep yearning for a tool to keep track of attrition. Simple and effective. Thank you, Pradeep.

Cheers, Shashikanth Chennai

From India, Mumbai
Acknowledge(0)
Amend(0)

Hi Pradeep, You done really good job.... it is very useful & ready to reference..........Really gre8!!!!!!!!! Thank you very much for the same. Warm Regards Deeps
From India, Pune
Acknowledge(0)
Amend(0)

Dear Pradeep,

The Attrition Calculator sheet was fine. Would you kindly provide me with the calculations that you have done to determine the attrition rate and percentage for both monthly and quarterly data?

Regards,

M. Peer Mohamed Sardhar
93831 93832

From India, Coimbatore
Acknowledge(0)
Amend(0)

Dear Pradeep i saw the calculation, need some clarifications. Could you give me your contact number or can contact me at 93831 93832. Regards M. Peer Mohamed Sardhar
From India, Coimbatore
Acknowledge(0)
Amend(0)

Dear All Please find the calculator with the formula to calculate the attrition. Thanks Kavitha S
From India, Coimbatore
Attached Files (Download Requires Membership)
File Type: xls attrition_calculator_and_register2_126.xls (13.0 KB, 276 views)

Acknowledge(0)
Amend(0)

Hi Pradeep Its a beautiful Piece of work, can u please send me password to unprotect the 2nd sheet. Regards Abhijeet bose
From India, Mumbai
Acknowledge(0)
Amend(0)

Hi Pradeep,

I am very thankful for your attrition calculator because for the last 15 days, I have been working on it. I have gained many ideas from your calculator. Could you please share the password for the second sheet so that I can share the knowledge?

I have now started working on a Competency Matrix, but I need some help. Can you suggest some or share an excellent format for the same?

Regards,
Swati


Acknowledge(0)
Amend(0)

Hi All, password to unprotect sheet is : Go to Tools > Protection > Unprotect sheet > password password : ekanthappa This if for all your information. Regards, Pradeep
From India, Bangalore
Acknowledge(0)
Amend(0)

Dear All, Pls find the unprotected file of Attrition calculator and annual register, enclosed in the attachment. Pradeep
From India, Bangalore
Attached Files (Download Requires Membership)
File Type: xls attrition_calculator_and_register_147.xls (23.0 KB, 143 views)

Acknowledge(0)
Amend(0)

Enclosed attachment is password unprotected. Regards, Pradeep
From India, Bangalore
Attached Files (Download Requires Membership)
File Type: xls attrition_calculator_and_register_992.xls (23.0 KB, 175 views)

Acknowledge(0)
Amend(0)

Dear Friend, Good presentation it will be useful for every one, keepit up. Regards, PBS KUMAR
From India, Kakinada
Acknowledge(0)
Amend(0)

Hi Pradeep, This is an excellent job. Thank you so much. Keep up the good work and keep sharing us the new innovative things. This is simple and superb. nimmy.

Acknowledge(0)
Amend(0)

I have enclosed an Excel file, which is a ready calculator and annual register of attrition. Here you can know the attrition for the particular month and different quarters.

1st Sheet - Enter the data of your company/organization/firm.

2nd Sheet - Find the attrition percentage calculated as per the data provided in sheet 1.

Regards,
Pradeep

Hi Pradeep,
This Excel file is really good. Can you please tell us the formulas you have used (in the second sheet) so that we can understand the whole concept?
Waiting for your reply.
Regards,
Sapna

From India, Kanpur
Acknowledge(0)
Amend(0)

Hi Pradeep, You hv rly put a gud article over here. Can you pls tell us the formulae used in 2nd sheet to get the %age so that v can understand the whole concept. Wtng for your reply.. Rgs, Sapna
From India, Kanpur
Acknowledge(0)
Amend(0)

Hi Pradeep, Thanks a lot for sharing such a valuable information in the forum. Its crucial information for all HR professionals. Thanks and Regards, Sukhi
From India, Delhi
Acknowledge(0)
Amend(0)

hi Pradeep, Pls tell us the formulae you have used in the second sheet of ur article. It will help all of us. Thnx & Rgs, Sapna
From India, Kanpur
Acknowledge(0)
Amend(0)

Hi Pradeep,

Please let me know the formula to calculate the employee attrition for a month or quarter wise. Thanks a lot for sharing such valuable information in the forum. It's crucial information for all HR professionals.

Regards,
Sonia

From India, Delhi
Acknowledge(0)
Amend(0)

Hi,

I saw the calculator and would like to appreciate that it is a good Excel work. However, I have a few questions as well as a suggestion in my mind.

I have two questions here:

1) Which method has been used to calculate the attrition in the tracker? It is not possible to find out the method used to calculate the attrition. Is it a simple average method?
2) If we keep our opening strength and the closing strength as the same for a quarter, the formula does not account for the total number of attrition for the previous months. That means it is calculating only for the month's attrition.

Suggestion:
1) Ideally speaking, the closing balance of the month should automatically become the opening balance for the next month, which is not happening in the Excel. Maybe you can enhance it and link it with the closing balance of the previous month, which it will pick up as the opening of the next month.


Acknowledge(0)
Amend(0)

Hi,

Thanks for your suggestion, and I would like to make this clear:

Firstly, the method used is the average method.

Secondly, we can assume the opening and closing strength are the same, but we can arrive at the closing strength only after calculating attrition, additions, and transfers.

However, I shall look into this and update if necessary.

Thanks,
Pradeep

From India, Bangalore
Acknowledge(0)
Amend(0)

This is really nice. One thing that is confusing is formula used for calculation of attrition rate. If you can suggest how you came to this particular formula? Thanks in advance!
From India, Mumbai
Acknowledge(0)
Amend(0)

Hi there,

I work for an IT company and found the attrition report handy, but somehow I do not have the password to unprotect the sheet to customize it as per my company's requirements. Could you please provide me with the password on my personal email id - mag_zone@yahoo.com?

- Margaret Rodrigues

From India, Mumbai
Acknowledge(0)
Amend(0)

Hi Pradeep,

It's excellent!!!! Great work :D :D :D Can you please let me know how to calculate the attrition rate or the password to unprotect the 2nd worksheet? If so, please email me at .

Keep it up!!!! :D

Regards,
Abhishek

From India, Madras
Acknowledge(0)
Amend(0)

Hi Pradeep :)

You have done a great job! Can you please provide me with the password to unprotect the second sheet as I need to make some changes? Please email me at govinda.raju@relianceada.com.

Regards,
Govind
9343403469


Acknowledge(0)
Amend(0)

Hi Pradeep,

Your attrition calculator is very handy and helping me prepare my attrition reports. However, I am having difficulties with the password as I can't change anything in the second sheet. If I want to, kindly provide me with the password. My ID is .

Thanks a lot for providing this.

Regards,
Poonam

From India, Delhi
Acknowledge(0)
Amend(0)

Dear Pradeep, Can you send me the excel sheet format of attrition rate calculation to me? Regards. Ramesh Bala
From India, Hyderabad
Acknowledge(0)
Amend(0)

Hi Pradeep, You have done a excellent work. Can have your working of sheet 1 * 2 Regards. Rameshbala
From India, Hyderabad
Acknowledge(0)
Amend(0)

Hi Pradeep,

Thank you very much for the attrition calculator. I am currently working on a project focused on developing HR metrics. These metrics will encompass factors such as time to hire, cost per hire, voluntary separation ratio, performance turnover in key roles, training ROI, payback period for training, succession planning metrics, and more. If you are able to assist with any of these, please respond.

Thank you,
Priyanka


Acknowledge(0)
Amend(0)

Hi Could u pls share the paasword for the attrition rate calculator.Gud work . rehards bhawna
From India, Mumbai
Acknowledge(0)
Amend(0)

hi! ya its a lovely tool n its very usefull, I had modified it as per my company requirement. once again thanks a lot for the contribution. wishes Arya :idea:
From India, Delhi
Acknowledge(0)
Amend(0)

When I try to "Unprotect" the second sheet and make certain changes, it is asking for a password. Can you please share that password with us or mail me the password at nrajesh@capitaliq.com? I would like to see the formulas.

Thanks


Acknowledge(0)
Amend(0)

Hi,

Good work. I am planning to use the same sheet for HR usage in our organization, but the second sheet is protected. Can you please guide me so that I can put this sheet into practice? Please email me at [email]sharmaruchy@gmail.com.

Thank you,
Ruchi

From India, Delhi
Acknowledge(0)
Amend(0)

Dear Pradeep,

Thank you for sharing the file with us on the forum. Can I request you to kindly let me know how the attrition calculation is carried out on the second sheet, and also if possible provide the password to unprotect the sheet. Could you email the same to me at swapna_nairg@yahoo.co.in, as I can then make some changes for my company requirements.

Thank you in advance,

Swapna Nair

From India, New Delhi
Acknowledge(0)
Amend(0)

Hi Pradeep,

When I am trying to "Unprotect" the second sheet and make certain changes, it is asking for a password. Can you please share that password with us or email me the password at ruchisaini22@rediffmail.com? I need it urgently.

Please respond quickly.

Thanks and regards,
Ruchi

From India, Surat
Acknowledge(0)
Amend(0)

Hi Sowjanya & Ruchi, Pls find an unprotected sheet mailed to your id. If any more info required, feel free to mail me back with queries. Thanks, Pradeep 9980913190
From India, Bangalore
Acknowledge(0)
Amend(0)

Dear Pradeep,

I need to change the first and second sheet to Financial Year from your given Calendar Year. Can you please mail me the password to unprotect the 2nd sheet? My email id is: apinto@acemicromatic.com. The calculator is very useful.

Thanks,
A. Pinto

From India, Mumbai
Acknowledge(0)
Amend(0)

Thanks for all using this calculator of attrition. Pls find the enclosed attachment which is unprotected Regards, Pradeep
From India, Bangalore
Attached Files (Download Requires Membership)
File Type: xls attrition_calculator_and_register_132.xls (23.0 KB, 113 views)

Acknowledge(0)
Amend(0)

Its a good tool for calculating attrition at any given point of time. I found it very useful. Regards, Dixita
From India, Bangalore
Acknowledge(0)
Amend(0)

Hi Pradeep,

When I am trying to "Unprotect" the second sheet and make certain changes, it is asking for a password. Can you please share that password with us or email me the password at rohit.blb@gmail.com?

Thanks & Regards,
Rohit Malik



Acknowledge(0)
Amend(0)

HI there, this is an best effort any body can take for the hr people all over. Thanx and keep doing the good work for everybody. Regards Philip C. Sharma
From India, Mumbai
Acknowledge(0)
Amend(0)

Hi all,

Further to Pradeep's Excel file, I have just made a few basic changes in the format. This format calculates the opening balance for the subsequent month automatically. I hope this is of some use.

Regards,
Mohammed

From India, Mumbai
Acknowledge(0)
Amend(0)

Hi Pradeep,

When I am trying to "Unprotect" the second sheet and make certain changes, it is asking for a password. Can you please share that password? Kindly email me that password to monicakaushik@gmail.com.

Regards, Monica Kaushik

From India, Delhi
Acknowledge(0)
Amend(0)

Hi,

Could someone please share with me the cost of attrition calculator? I need it urgently for my project. My email ID is [IMG]https://www.citehr.com/misc.php?do=email_dev&email=bWxyLnJhc2htaU BnbWFpbC5jb20=[/IMG].

Thank you.

From India, Bangalore
Acknowledge(0)
Amend(0)

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.