Confuse Of Calculating Attrition - Xls Download

Dear All,
I m very confuse that what formula should i use for calculating Attrition rate (%), monthly as well as quartely & annually.
which formula is right:-
1) Attriotion = ((no. of attrition *100)/(actual emp. + new joinee))/100
OR
2) Attrition = (no. of attrition)/((Op. bal+Cl. bal.)/2))*100
from both formula the % come is different.
Pls. I need your inputs & guidance in this frnds. & need any standard formula which is being used in every organization.
som

Dear Friend,
According to my knowledge, the formula for attrition is
= ( No of Employees left * 100 )/ Total No of Employees.
Regards,
Sinju

Hey Som !!!!!!!!!!
I m attaching an excel sheet with this ........... This sheet was posted by some citehr member only........... Hope u find it useful.........
Regards,
Monika

Dear Monica,
Thank you so much, for attaching the excel sheet for attrition cal., and I have used ur sheet for calculating % but, monica in your sheet both the formula Attrition 1 & Attrition 2 give different %age.
And that was my problem is, that which formula or %age is right????
waiting for your response.
Soma

Hi Soma
I have a attrition calculation register in which u just need to fill in details about some particulars and it automatically tells u d attrition %....
Unfortunately m unable to attach it here....kindly mail me at [Login to view] and i wil, mail it to u

Hello !!!!!!!!!
I m attaching another format............... this is better one........... try this n let me know wether its helpful or not..........
Regards,
Monika

Hello Vinay!!!!!
The formula is correct for sure.......... r u finding any kind of problem...................... if yes than let me know..............
Warm Regards,
Monika

Dear Friend,
Kindly click on the following link, it will give you some required information,
https://www.citehr.com/search_new.ph...tion&submit=Go
Pls let me know was this information useful,,
If not let me try out more & give information,,,,
In CiteHR you will get A to Z information on HR…..
Regards
M. Peer Mohamed Sardhar
093831 93832

Hi Monica,
I am in need of comp & Benefits details and also various appraisal systems used in across the organizations.
Is there any particular appraisal system are followed by each industries? If so what are they and how they differ from each of its...
1) 360 appraisal
2) Score card
3) Bell curve analysis
and methodologies most commonly used in appraisal system which are in practiced by most of the organizations.
Kindly provide me with related documents if possible with the explanations for the same. So that i can move on further
Kindly help me out at the earliest.
You can post the same on below mail id's also...
[Login to view]
[Login to view]
Awaiting for your earliest reply...
Thanks & Regards
Charan Kedar.C.
+91-98407-18607

hi monika
this is in reference to the attritin calculator u have sent. Actually i want to see the formula for the second sheet which is password protected. can u pls provide me the passsword because d formula i m using has some different value.
my e mail id is [Login to view]
rahul verma