DevelopmentPayment protectionDetails
- Revisions within the package are free.
- If you do not respond within 3 days of delivery, the work is accepted automatically.
The money is reserved when you pay and released only once you accept the work.

Example result
Staff rota template: a café with 11 employees and two shifts
Sheet: weekly rota (excerpt)
| Name | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Hours |
|---|---|---|---|---|---|---|---|---|
| Lena (FT) | E | E | — | E | E | L | — | 40 |
| Tom (FT) | L | L | L | — | — | E | E | 40 |
| Aisha (PT) | — | — | E | E | — | E | — | 24 |
| Marco (PT) | — | L | — | L | L | — | L | 32 |
E = early shift 7:00–15:00, L = late shift 12:00–20:00, 8 hours each.
Formulas
- Hours per week:
=(COUNTIF(B2:H2,"E")+COUNTIF(B2:H2,"L"))*8 - Cover check:
=COUNTIF(B2:B12,"E")must be at least 2 every day, otherwise the cell turns red - Limits: full-timers over 40 hours and part-timers over 30 hours are highlighted orange; here Marco is flagged with 32 hours
Extras
- Drop-down list of shift codes, plus "H" for holiday and "S" for sick leave
- A read-only staff view, shared with the team by link
- A monthly tab that totals hours for payroll
Break and overtime rules differ by state; the limits are set in one settings cell.
Client: The Corner Bean, a café open from 7:00 to 20:00 every day, with 4 full-time and 7 part-time staff Task: a Google Sheets rota the manager can fill in within 20 minutes a week, showing hours per person, overtime and gaps
The client and all details are made up.
About this service
Shift rotas in cafes, shops, clinics and warehouses break in the same places: someone works two closing and opening shifts in a row, overtime is counted by hand, and swaps are lost. We lay out a rota template in Excel or Google Sheets for your shift pattern, with formulas that total hours per employee, flag short rest between shifts and show gaps where a shift has too few staff. In Premium a script copies the rota to a new week or month in one click.
What is included
- What you getFormulas, the rota layout (columns, headers and sample rows as CSV text), conditional formatting rules and setup steps; in Premium also Apps Script or VBA code with installation steps. Everything comes as text on the order page; we do not send a ready spreadsheet file.
- Shift gridEmployees by days, with shift codes
- Hours per employeeWeekly and monthly totals, overtime
- Rest warningsShort breaks between shifts flagged
- Coverage checkShifts below minimum staff
- Copy to next periodIn Premium: one-click script
How it works
- 1BriefYou describe shifts and rules
- 2RotaWe write layout, formulas and code
- 3FixesIf something fails on your data, we fix it within your package
What we need from you
Your shift types and times, how many employees, the minimum staff per shift, rest and overtime rules, and Excel or Google Sheets.
We will ask you:
- What shifts do you run?
- How many employees does the rota cover?
- What is the minimum staff per shift?
- Which rest and overtime rules apply?
Compare packages
| Packages | Basic$10 | Standard$25 | Premium$49 |
|---|---|---|---|
| What is included | Rota formulas | Rota template | Rota with script |
| Deadline | 1 day | 2 days | 3 days |
| Revisions | 1 | 2 | 3 |
| Formulas | up to 3 | up to 10 | up to 15 |
| Rota template | No | Yes | Yes |
| Script code | No | No | Apps Script or VBA |
| Order Basic | Order Standard | Order Premium |
Payment protection
You pay when you order, but the money is released only for accepted work.
- Fixed priceThe package price does not change after you pay.
- The money is reservedWhen you pay, the amount is only reserved. It is released to the service once you accept the work.
- Checked before deliveryEvery result goes through a quality check before it reaches you, and you see it on the order page before accepting it.
- Free revisionsAsk for changes within your brief as many times as the package allows.
- Acceptance after 3 daysIf within 3 days of delivery you neither accept the work nor ask for changes, it is accepted automatically. If you write in the order chat after delivery, the order waits; once we answer, we may start the 3 days again and will say so in the chat.
- Redo or a full refundIf the result does not match your brief and the revisions did not fix it, or the work takes more than twice its deadline, write in the order chat: we will redo the work or refund the payment in full.
Questions and answers
Does it follow labour law in my country?
It applies the rest and overtime rules you give us. Check those rules with your local labour regulations; this is not legal advice.
Can employees see the rota on their phones?
Yes, if you keep it in Google Sheets and share view access. We keep the layout readable on small screens.
Will it build the rota for me?
No, you assign shifts; the formulas check hours, rest and coverage as you fill it in.
Did not find your answer?


