Absenteeism is very useful for any process. In this absenteeism report template there are 6 worksheets available
Index:
Index worksheet is used to navigate the other worksheet-like summary, month wise, date wise and supervisor wise.
Summary:
In this worksheet a chart of month on month comparison for planned% Vs Unplanned% is available. Overall NCNS (No call No show) count , Planned % and Unplanned% have been displayed in the circles above.
For filtering the data Month, Date, Supervisor Name, Quarter, and Week slicers have been displayed.
Month Wise:
In this worksheet a month wise pivot table has been displayed for P (Present count), NCNS (No Call No Show) count, A (Absent Count), L (Leave count), Scheduled count, Unplanned% and Planned %.
Traffic lights conditional formatting has been used for unplanned% and planned %. Target for unplanned is 12% and for planned is 15%.
Week Wise:
This is the same worksheet as month wise, only difference is in place of month here Week has been taken.
Supervisor Wise:
This is the same worksheet as month wise, only difference is in place of month here Supervisor Name has been taken.
Raw Data:
In this worksheet raw data of this report is available. Fields with the gray header to entered manually and for the green header it is formulated.
