Free download
Download it free.
Download the PDF to keep or print.
Printable reference (editable copy is a Google Sheet, linked above)
Draft only. Proposed URL; do not publish without client approval.
A missed shift and a departing team member affect coverage differently. This free workforce absence tracker separates the two signals so site managers can spot gaps and plan a response without recording a worker’s reason for absence.
Need the live spreadsheet with formulas? Open an editable Google Sheets copy (works without signing in on a link-shared sheet).
What is inside the workbook
The Weekly Counts tab records a Monday-to-Sunday period, site cohort, planned shifts, full missed shifts, opening and closing headcount, joins, exits and transfers. Rates stay blank when a denominator is missing or zero. A headcount check flags a mismatch before you interpret turnover.
Use trends to plan coverage
The Trends tab charts both rates across entered rows. Compare like-for-like site cohorts rather than treating the chart as a benchmark. In Staffing Actions, assign a role, date and follow-up for cover, roster changes or recruitment. Do not enter names, diagnoses or absence reasons. The OAIC explains that employee-records privacy exemptions have limits, including for contractors handling another employer’s information.
Related Resources
Seasonal absenteeism and winter staffing
Staff turnover planning for production teams
Seasonal staffing review numbers to keep
Warehouse headcount from volume
Warehousing and logistics staffing
Frequently Asked Questions
How is absence rate calculated?
Divide full planned person-shifts missed by all planned person-shifts for that week and cohort. This is an operational count, not a statutory payroll measure.
What counts as turnover?
Count departures from the defined site cohort and divide by the average opening and closing headcount. State whether the cohort includes direct or agency staff.
Can I record sick leave reasons?
No. The shared workbook uses aggregate counts only; keep any individual records in an approved, access-controlled system.
Does a high weekly rate mean we need more staff?
Not by itself. Small teams can swing sharply. Review demand, cover and several consistent periods before acting.
Plan the next shift with a clearer count
Need staffing support for your site? Request staff from Chandler Personnel and discuss your next roster or seasonal peak.
General information only. Confirm site processes, local law and advice applicable to your circumstances. The download is a planning aid, not evidence of compliance.
