Attritation Calculation Work Sheet - Xls Download

Hi Frends, Can any one provide me Attrition Calculatioin worksheet as i in a need of this. wating for your response Bye to all
30th October 2007 From India, Delhi

Hi, Pls find the attrition working in excel format. Regards, Anil Ronald Corda
30th October 2007 From Oman, Muscat

Attached Files (Download Requires Membership)

attrition-rate_208.xls (73.0 KB, 752 views)

Hi Ami,
Attrition Rate = No. of resigned of that month/ Available manpower * 100
For example, if in any of the starting day of previous month the manpower was 80 and during that month 5 resigned and 10 joined.. then on the last day of the month Manpower would be 80-5+10 = 85
So Attrition rate = 5/85*100
Hope, the query must been solved now..
Regards,
Amit Seth.
30th October 2007 From India, Ahmadabad

but this excel shee says anoter thing. you have claulated no of resigned/total employee(opening manpower+resigned+joined+total manpower)*100 plz clarify
31st October 2007 From India, Delhi