Description
Keep your front desk, housekeeping, kitchen, and maintenance coverage clear without juggling chats and sticky notes.
Features
- Teams and people lists with roles and contact fields
- Reusable shift templates (start, end, capacity)
- Weekly schedule with auto Open / Full status (formula)
- Attendance log (Present / Absent / Late)
- Dashboard with open-shift count, fill rate, attendance counts, and estimated hours by person
- Premium styling: frozen panes, conditional formatting, landscape print for Schedule
- CSV exports for Google Sheets import
What’s calculated for you
- Schedule Status — Full when assigned name count ≥ Capacity, else Open (LEN/SUBSTITUTE helper)
- Assigned # — counts comma-separated names on each shift row
- Dashboard Open / Full counts — COUNTIF on Status
- Dashboard Fill rate % — Full ÷ Total scheduled
- Dashboard Present / Absent / Late counts — COUNTIF on Attendance
- Hours by person — COUNTIFS (Present+Late) × 8h estimate
- Conditional formatting — Open=amber, Full=green; Absent rows highlighted
Who it’s for
Small hotels, guesthouses, cafés, and ops teams that need a simple roster—not a full HR system.
What’s included
- Outzone-Shift-Roster.xlsx
- csv/ exports (Teams, People, Shift Templates, Schedule, Attendance)
- README.txt with Google Sheets import steps
License
One-time digital download for your organization. Use on unlimited devices within your team. Do not resell or redistribute.
Reviews
There are no reviews yet.