Who is actually carrying our overtime?
- Files
- 3
- Rows
- 100,459
- Checks passed
- 19
Attrition
28.8%
Overtime on scheduled hours
5.0%
Overtime cost
$574,454
What went in
Jul 1, 2025 – Jun 30, 2026
- Project
- Rota, clock and headcount: July to June
- Subject
- People & teams
- Rows
- 100,459
Source files
- rota_2025_2026.xlsx48,900 rows
- clock_records.csv51,272 rows
- headcount_and_leavers.xlsx287 rows
The finished example
Demonstration data we built, not a customer's file.
Rendered by the same components that render your own projects.
The overtime is not spread across the team, and the people carrying it are the ones leaving.
Eleven people worked 6,884 of the year's 18,412 overtime hours, and nine of them are on the night rota. Seven of those eleven have since left. Separately, the 27% attrition the business reports is computed on closing headcount, which flatters a year in which headcount grew from 198 to 226; on average headcount the same 61 leavers give 28.8%. Seven in ten of them left inside their first year.
Most of the leaving happens in the first year
43 of 61 leavers were inside their first year
- 01Eleven people worked 37% of the overtime, and seven of them have left.
- 02Attrition is 28.8%, not the 27.0% currently reported.
- 03Seven in ten leavers went inside their first year.
Filed under
Closest to this one
Ranked by how many subjects they share with this project.
Have something like this?
Drop it in and see what comes back. You only pay once you like it.
No account needed to start. You only pay when you like what you see.