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
Acknowledge(2)
Amend(0)
45From United States, Chelsea
Acknowledge(2)Amend(0)
Hi I have gone through the attrition excel sheet and did not follow what is the meaning of W2 forms. Can you please explain ? Regards
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
Please 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 the 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 Rows 10 to 21 on the Monthly Sheet, enter the number of employees who left during the month (Col. E) and the number of employees who were hired during the month (Col. F).
Bob Gately
gately@csi.com
From United States, Chelsea
Acknowledge(0)Amend(0)
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 the 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 Rows 10 to 21 on the Monthly Sheet, enter the number of employees who left during the month (Col. E) and the number of employees who were hired during the month (Col. F).
Bob Gately
gately@csi.com
From United States, Chelsea
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-rate. xls