formula/s

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
 
K

Kirandeep Singh

Sorry group. I appologise for sending it a couple of times as it was telling
me that unless u make outlook ur default client i cannot send.... but now i
have deleted them

Have you thought of any resolution for little me.

:)) Chears

Kirandeep
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top