The attached Turnover (Attrition) Rate Excel workbook, "to_rate.xls", allows the user to track turnover for 12 months. Bob Gately gately@csi.com
From United States, Chelsea
45From United States, Chelsea
hey thatz gr8.. mind blowing.. i work out every month manually.. bt let me know the password also . the sheets are protected can not do anything..is it software developed??? or formula based??
regards
mausam
regards
mausam
Enter data in cells that are RED in color.
On the Annual Sheet enter data in RED cells on lines 1, 2, 5 and 9
W2s in Line 9 refers to the number of income/tax statements issued to current and former employees for the previous tax year. Most managers are surprised to learn the total number of people who worked for their company during the year.
In Column B of Row 10 on Monthly Sheet enter a number from 1 to 12 to correspond to the desired starting month for the workbook; 1 = January to 12 = December.
In Columns E and F of Row 10 to 21 on Monthly Sheet enter the number of employees who left during the month (Col. E) and the number employees who were hired during the month (Col. F).
Bob Gately
From United States, Chelsea
On the Annual Sheet enter data in RED cells on lines 1, 2, 5 and 9
W2s in Line 9 refers to the number of income/tax statements issued to current and former employees for the previous tax year. Most managers are surprised to learn the total number of people who worked for their company during the year.
In Column B of Row 10 on Monthly Sheet enter a number from 1 to 12 to correspond to the desired starting month for the workbook; 1 = January to 12 = December.
In Columns E and F of Row 10 to 21 on Monthly Sheet enter the number of employees who left during the month (Col. E) and the number employees who were hired during the month (Col. F).
Bob Gately
From United States, Chelsea
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Attrition-rate. xls
Attrition-rate- in-different-se ctors_906.jpg