How to Track Employee Turnover: A Simple Excel Tool for Monthly and Quarterly Insights

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

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 [Login to view].

Thanks & regards,
Deepak Parbat

One of the best resources to be put online, as many members have been asking about attrition calculation, formula, etc.

Hi,

The formula used for the calculation is:

Attrition %age = Attrition / (<Strength on 1st day of the Month + Strength on the last day of the month> / 2) * 100

Thanks,
Pradeep

Hi,

I have protected the 2nd sheet as it is the only result sheet, and no entries are required. However, the 1st sheet can be edited according to your data entries.

Pradeep

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

Dear All,

Please find the calculator with the formula to calculate the attrition.

Thanks,
Kavitha S

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

Hi All,

The password to unprotect the sheet is:
Go to Tools > Protection > Unprotect sheet > password
Password: ekanthappa

This is for all your information.

Regards,
Pradeep

Dear All,

Please find the unprotected file of the Attrition calculator and annual register enclosed in the attachment.

Pradeep

Enclosed attachment is password unprotected.

Regards,
Pradeep

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

Hi Pradeep,

You have really put a good article over here. Can you please tell us the formulas used in the 2nd sheet to get the percentage so that we can understand the whole concept.

Waiting for your reply.

Regards,
Sapna

Hi Pradeep,

Please tell us the formulas you have used in the second sheet of your article. It will help all of us.

Thanks & Regards,
Sapna

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

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.

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

This is really nice.

One thing that is confusing is the formula used for the calculation of the attrition rate. If you can suggest how you came to this particular formula?

Thanks in advance!

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 [Login to view].

Thanks a lot for providing this.

Regards,
Poonam

Dear Pradeep,

Can you please send me the Excel sheet format for calculating the attrition rate?

Regards,

Ramesh Bala

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

Hi!

Yes, it's a lovely tool and very useful. I have modified it as per my company's requirements. Once again, thanks a lot for the contribution.

Best wishes,
Arya 💡

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

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

Hi Sowjanya & Ruchi,

Please find an unprotected sheet emailed to your ID. If more information is required, feel free to email me back with any queries.

Thanks,
Pradeep
9980913190

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

Thank you for using this attrition calculator. Please find the enclosed attachment which is unprotected.

Regards,
Pradeep

It's a good tool for calculating attrition at any given point of time. I found it very useful.

Regards,
Dixita

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

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

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