Posts tagged "Shiftwise"

Shift Wise Report in Excel

Attatched herewith for daily analysis of Manpower Status in the Factory.

Shiftwise – Working Details Report
Period From : 20/12/2011 To : 20/12/2011
SHIFT B
Department / Designation Sanction OnRoll Present Overtime. Rest Holidays Paid UnPaid Absent  Present Overtime. Rests Holidays Paid UnPaid Absent
OnRoll Contract Company Days Hours Days Days Leaves Leaves Days  Days % % % % Leaves % Leaves % Days %
<Department >
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Dept. Total . 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
<Department >
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Dept. Total . 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
<Department >
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Dept. Total . 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
<Department >
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Dept. Total . 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Grand Dept. Total . 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #### #DIV/0! #DIV/0! #DIV/0! #####

 

Click Here To Download Shiftwise Working Details – Report

Be the first to comment - What do you think?
Posted by Hrformats - June 22, 2012 at 5:45 AM

Categories: HR   Tags: , , ,

Shiftwise Working Details – Report

I have Attached Shift wise Working Details Report

Shiftwise – Working Details Report
Period From : 20/12/2011 To : 20/12/2011
SHIFT B
Department / Designation Sanction OnRoll Present Overtime. Rest Holidays Paid UnPaid Absent  Present Overtime. Rests Holidays Paid UnPaid Absent
OnRoll Contract Company Days Hours Days Days Leaves Leaves Days  Days % % % % Leaves % Leaves % Days %
<Department >
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Dept. Total . 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
<Department >
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Dept. Total . 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
<Department >
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Dept. Total . 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
<Department >
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Dept. Total . 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Grand Dept. Total . 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #### #DIV/0! #DIV/0! #DIV/0! #####

 

Click Here To Download Shiftwise Working Details – Report

1 comment - What do you think?
Posted by Hrformats - May 25, 2012 at 9:39 AM

Categories: HR   Tags: , , ,

Shiftwise Working Details – Report

I have attached the Shiftwise Working Details – Report

Shiftwise – Working Details Report
Period From : 20/12/2011 To : 20/12/2011
SHIFT B
Department / Designation Sanction OnRoll Present Overtime. Rest Holidays Paid UnPaid Absent  Present Overtime. Rests Holidays Paid UnPaid Absent
OnRoll Contract Company Days Hours Days Days Leaves Leaves Days  Days % % % % Leaves % Leaves % Days %
<Department >
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Dept. Total . 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
<Department >
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Dept. Total . 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
<Department >
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Dept. Total . 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
<Department >
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Designation # 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Dept. Total . 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! ##### #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Grand Dept. Total . 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #### #DIV/0! #DIV/0! #DIV/0! #####

 

Click Here to Download Shift Wise Report Sample

Be the first to comment - What do you think?
Posted by Hrformats - December 23, 2011 at 10:14 AM

Categories: HR   Tags: ,