K
Kirandeep Singh
Hi Group,
Need your help.
I have these coloumns:
Employee Code Name Status Position DOJ DOL Tenure Reason of Leaving Ed
Level GENDER LOCATION
I have two sheets one with Attrition details and one with Headcount details
(only difference between the two is that Headcount does not have Reason of
Leaving).
1. Tenure has this formula =(F2-E2)/365*12
2. The data is for the previous one year
3. I have monthly headcount and monthly attrition figures.
4. In the Headcount, I have put last date of the month as the DOL (Date of
leaving) so that I can get the exact headcount tenure.
5. Status means Status of the Employee if in Process training or Accent
Training, Production Agent or Production non-agent.
6. Reason of Leaving has various reasons like: Abandoned, Health reasons
etc.
7. Education Level has levels like : MBA, BE etc.
8. Location has various locations where the employee belongs.
I want to have :
1. Total Attrition
2. Monthly Attrition
3. Total Production Attrition
4. Monthly Production attrition
5. Monthly Training attrition (Combined Accent and Training and seperately)
4. Total Training Attrition
5. Attrition in Accent Training
6. Attrition in Process Training
7. Is attrition in process training more or in accent training more and what
is their tenure
Basically, I want to see attrition from all the angles Tenure wise,
Reasonwise, Genderwise, Statuswise, Education level wise, Local/Outstation
wise and then see all these broken into Training and Production. Then
further breaking Training into Accent and Process training. I want the
attrition percentages.
Am I asking for too much or it is not that difficult.
After making all these analysis. I would make graphs and would like to
present to my boss with all this analysis.
Pls. advise if you need more inputs....and help if possible.
Thanking you in advance for your kind co-operation in this regard.
Thanks and Best Regards,
Kiran
Need your help.
I have these coloumns:
Employee Code Name Status Position DOJ DOL Tenure Reason of Leaving Ed
Level GENDER LOCATION
I have two sheets one with Attrition details and one with Headcount details
(only difference between the two is that Headcount does not have Reason of
Leaving).
1. Tenure has this formula =(F2-E2)/365*12
2. The data is for the previous one year
3. I have monthly headcount and monthly attrition figures.
4. In the Headcount, I have put last date of the month as the DOL (Date of
leaving) so that I can get the exact headcount tenure.
5. Status means Status of the Employee if in Process training or Accent
Training, Production Agent or Production non-agent.
6. Reason of Leaving has various reasons like: Abandoned, Health reasons
etc.
7. Education Level has levels like : MBA, BE etc.
8. Location has various locations where the employee belongs.
I want to have :
1. Total Attrition
2. Monthly Attrition
3. Total Production Attrition
4. Monthly Production attrition
5. Monthly Training attrition (Combined Accent and Training and seperately)
4. Total Training Attrition
5. Attrition in Accent Training
6. Attrition in Process Training
7. Is attrition in process training more or in accent training more and what
is their tenure
Basically, I want to see attrition from all the angles Tenure wise,
Reasonwise, Genderwise, Statuswise, Education level wise, Local/Outstation
wise and then see all these broken into Training and Production. Then
further breaking Training into Accent and Process training. I want the
attrition percentages.
Am I asking for too much or it is not that difficult.
After making all these analysis. I would make graphs and would like to
present to my boss with all this analysis.
Pls. advise if you need more inputs....and help if possible.
Thanking you in advance for your kind co-operation in this regard.
Thanks and Best Regards,
Kiran