I will set up your shift rota, holiday and absence tracker pack
About this Gig
Three ready-made spreadsheets to get your shift admin under control, set up for your team.
You get a weekly shift rota, a holiday tracker and an absence log, built in Excel or Google Sheets. I set them up for your team size, shift pattern and site, with the formulas already in place: hours totals, holiday allowance used and remaining, and absence counts by person.
Standard adds a staff-hours dashboard so you can see cover and gaps at a glance. Premium goes further: I tailor the sheets to your actual shift patterns, add skills tags and include a simple handover note layout.
I work on a factory floor myself, so these are the layouts that actually get used - no bloated template pack, just the three sheets that get asked for most.
Send me your team size and shift pattern after ordering and I'll get started.
Platform:
Excel
•
Google Sheets
•
Microsoft Office
Development technology:
Excel
Expertise:
Formulas
•
Dashboard
•
Data validation
FAQ
Do I need Excel or can I use Google Sheets?
Either. Tell me which one you use when you order and I will build for that. Both versions work the same way.
Can you change the sheets after delivery?
Yes - every package includes at least one revision. Small tweaks like extra columns or a different week layout are quick.
