Shift Wise Report in Excel

June 22, 2012
by

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

Related Sample Formats:

  1. Shiftwise Working Details – Report
  2. Shiftwise Working Details – Report

Related Posts

Hrformats

Leave a Reply

Previous Story

Job Handover Format In Excel

Next Story

Performance Improvement Plan Example

Latest from HR

Go toTop

Don't Miss

Daily Report Format for Employees in Excel

Format For Staff Details