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.
Watch the step by step tutorial for how to create Absenteeism report in Excel.
Visit our YouTube channel to learn step-by-step video tutorials
