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
Acknowledge(0)
Amend(0)
4I 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
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)
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)
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)
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)
From India, Bangalore
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)
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 All Please find the calculator with the formula to calculate the attrition. Thanks Kavitha S
From India, Coimbatore
Acknowledge(0)Amend(0)
From India, Coimbatore
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)
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)
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
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
Enclosed attachment is password unprotected. Regards, Pradeep
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
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)
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)
From India, Kanpur
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)
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)
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)
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)
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)
From India, Mumbai
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)
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)
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)
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! 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)
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)
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)
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)
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)
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
Acknowledge(0)Amend(0)
From India, Bangalore
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)
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)
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 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)
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)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
ATTRITION CALCULATION.pdf
Attrition Calculator and Register.xls