EXCELCRAFT PRO TEMPLATE
Employee shift schedule
with coverage.
Build the rota, see the cost and spot the gaps. Add shifts and the week view fills in, hours and labor cost add up per person, and every position is checked against how many people you need each day.
Planned pricing: $8 a month or $60 a year. No payment is taken today.
- Printable weekly rota
- Labor cost
- Coverage gaps
INSIDE THE WORKBOOK
Every sheet
has one job.
Mint cells are where you type. White cells calculate. Instructions inside the file explain each field.
- Week View
- The rota: every employee across seven days with shift times, hours for the week and shifts per day.
- Dashboard
- Scheduled hours, labor cost, coverage gaps and people over their maximum, with hours by day and cost by position.
- Shifts
- One row per shift: date, employee, position, start, end and break; hours and cost calculate.
- Employees · Coverage
- People with position, rate and maximum hours; staffing needed per position per day with the gaps.
- Settings · Checks · Instructions
- Business name, week and positions; checks for double bookings and missing times.
WHY IT HELPS
Built around
the real task.
Weekly rota with hours, labor cost and coverage against staffing needs.
A rota you can pin up
Week View shows who works when, colour-coded for morning and evening shifts, ready to print or export as PDF.
Cost before you publish
Each shift is costed at the employee's rate, so you see the week's labor cost while you are still building it.
Coverage, not just headcount
Enter how many people each position needs per day. Short days turn red before anyone notices on the floor.
GETTING STARTED
Three steps
to your own version.
The sample shows a working example; the blank version keeps every formula ready for your records.
Set up the team
Add positions on Settings and employees with their rate and maximum hours.
Say what you need
On Coverage, enter how many people each position needs each day.
Build the week
Add shifts, then check Week View, the Dashboard and Coverage for gaps and overtime.
QUESTIONS
Before you begin.
Short answers about how the workbook behaves.
Can it handle night shifts?
Yes. If a shift ends after midnight, enter the end time as normal; hours are calculated correctly.
Can someone work two shifts in a day?
The week view shows one shift per person per day, so a second shift is flagged. Record a split shift as one shift with a longer break.
How do I plan next week?
Change the week on Settings and add shifts with next week's dates. All weeks stay in one shift list.
Does it check labor law?
It flags people over the maximum hours you set. It does not check break, rest or notice rules.
How do I keep my changes?
Use Download XLSX or PDF in the editor before closing the tab. Nothing is saved to a server automatically, and your workbook never leaves your device while you edit.
Will it work in Excel and Google Sheets?
The files use standard XLSX formulas without macros, pivot tables or external links. They are checked with the ExcelCraft engine; compatibility with every Excel or Google Sheets version is not guaranteed. Review formulas, charts and formatting in your app before relying on important figures.
Can I change the currency?
Amounts use a $ number format. Change the cell format to your currency; the formulas do not convert between currencies.
EXCELCRAFT PRO · EARLY ACCESS
Part of
ExcelCraft Pro.
Pro workbooks cover whole workflows: purchasing to receiving, journal to balance sheet, tasks to portfolio health. Pro is planned to include AI credits for editing through chat. Pro downloads and the AI assistant are not available yet.
- Every Pro workbook as it is released, with dashboards, checks and instructions
- Planned: monthly AI credits for editing spreadsheets through chat
- Planned launch pricing; final terms are not set
$8/ month
or $60 / year · planned launch price
No payment today. We email you once when Pro opens.
How Pro worksRELATED
Works well with.
Separate workbooks for neighbouring jobs. Records do not sync between files.
Leave & Attendance Planner
Leave requests, balances, a monthly team calendar and overlap checks.
See what is inside
Project Timeline & Resource Planner
Weekly hours per person against capacity, with over-allocation flagged in red.
See what is insideYour workbook stays in this browser while you edit. Use Download in the editor to keep your work, and review important figures in the saved copy. How local files are handled.
Original ExcelCraft workbook design, formulas and fictional sample data · CC0. Management tool only; not tax, legal or accounting advice.