Mausam Joshi
Hr Professional

The attached Turnover (Attrition) Rate Excel workbook, "to_rate.xls", allows the user to track turnover for 12 months. Bob Gately
14th June 2007 From United States, Chelsea

Attached Files
Membership is required for download. Create An Account First
File Type: xls to_rate_191.xls (40.0 KB, 6078 views)

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
15th June 2007 From India, Mumbai
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 it software developed??? or formula based??
16th June 2007
hi, i mean plz simplfy it. i put my data but i have not got proper result. Plz help me out. Regards, Binny
16th June 2007 From India, Mumbai
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

18th June 2007 From United States, Chelsea
Add Reply Start A New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™