Attrition Calculator And Annual Register - XLS Download

Hi,
I have enclosed a 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/ organisation/ firm
2nd Sheet - Find the attrition % age calculated as per your 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 password.
Can you please share that password with us or please mail me that password on [Login to view].
Thnaks & 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 Month + Strength on last day of month> / 2) * 100
Thanks,
Pradeep

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

This is a wonderful tool and i am sure it will suffice the needs of a lot of members here who keep yearning for some tool to keep track of attrition. simple and effective. Thank you Pradeep.
Cheers,
Shashikanth
Chennai

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

Dear Pradeep,
The Attrition Calculator sheet was fine.
would you kindly provide me with calculation that you have done to calculate Attrition rate & percentage for both monthly & quaterly.
Regards
M. Peer Mohamed Sardhar
93831 93832

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

Dear All
Please find the calculator with the formula to calculate the attrition.
Thanks
Kavitha S