Shift schedule – spreadsheet template (XLSX)
A weekly plan for shift work. Enter one code per person and day; the template calculates each person’s hours from the shift legend and counts the staff per shift, highlighting days below the minimum.
Work & timeXLSX · CSV
Preview and fill in
This is the template with sample values. Tap a cell to change it – the formulas recalculate at once. Then download your version.
The preview needs JavaScript. You can also open the template in the FaLe PDF app.
What is inside
The sheet labels are in German; here is what the template does.
- Shift codes with colours (early, late, night, holiday, sick, off)
- Hours per person from the shift times (also over midnight)
- Staff count per shift and day
- Minimum staffing check
Good for
- Care homes, restaurants, shops, production
- Checking staffing before publishing the rota
Frequently asked questions
Do the formulas work in other programs?
Yes. The file is a normal Excel file (XLSX) with real formulas. Every template is checked in a free spreadsheet program that recalculates the formulas. Drop-down lists and colour rules are stored in the file as well.
Is anything I type stored?
No. Preview, editing and download all happen in your browser. There is no account and nothing is uploaded. Download the file before you close the page.
Why are the labels in German?
The templates were made for everyday use in Germany – things like the mileage log, the club cash report or the profit-and-loss sheet follow German practice. Formulas and numbers work the same in any language version of your spreadsheet program.
Excel is a trademark of its owner. “Excel (XLSX)” only names the file format here; FaleNetwork is not affiliated with the manufacturer.
Related templates
Timesheet
Monthly timesheet with target hours and overtimeWork & timeHoliday planner
Leave days per person, remaining leave and public holidaysWork & timeTeam leave overview
Leave entitlement, remaining days and working days per personWork & timeTask list
Tasks with priority, due date and statusWork & time