Rota Creator
Your step-by-step guide to configuring shifts, adding employees, reviewing availability and building a weekly rota in Excel.
Excel · Weekly scheduling · Setup guideWelcome to Rota Creator
This guide walks through the main areas of your workbook. Start with the basics, or use the menu to jump straight to the feature you need.
Get ready
Set up shifts first, then add employees and review availability before scheduling.
Build the week
Select employees and shift times. The workbook calculates scheduled paid hours.
Quick start
Follow these steps in order when setting up Rota Creator for the first time.
Settings
Define roles, shifts, times, unpaid breaks and your working week.
Employees
Add names, roles and contracted weekly hours.
Availability
Review which days each employee can work.
Rota
Assign shifts and review calculated hours.
Settings — start here
Begin on the Settings worksheet. Set up the shifts used in your business before adding employees or building a weekly rota.
- 1Enter a Shift name, then select its Role.
- 2Choose the Start and End times.
- 3Enter the Unpaid break in minutes. Paid hours calculate automatically.
- 4Add the remaining shift patterns required by your business.
- 5Select the first day of the week (for example, Monday).
Employees
Once your shift settings are ready, add your team. The workbook uses employee roles and weekly hours when creating the rota.
- 1Open the Employees worksheet.
- 2Enter each employee's name, role and weekly hours.
- 3Set whether the employee normally works weekends, then check for duplicate names.
Availability
Availability determines which employees can be selected for a given day. Review it before creating a new rota.
- 1Open Availability and review each employee's days.
- 2Mark individual days as Yes or No as required.
- 3Use the weekly holiday or absence flag when the employee is away for the full week.
Build your weekly rota
Use the rota view to choose employees and assign their shift times. Employee selections take role and availability into account.
- 1Open Rota and select the correct week.
- 2Choose an available employee from the appropriate dropdown.
- 3Set shift Start, End and break values.
- 4Review the calculated Paid Hours and daily staff totals.
Hours & indicators
Rota Creator helps you compare scheduled time with contracted hours and spot missing or unusual entries.
| Item | Meaning |
|---|---|
| Paid hours | Shift duration less the unpaid break. |
| Scheduled hours | Total paid hours currently allocated in the week. |
| Daily staff count | Number of scheduled employees for a day. |
| Colour indicators | Visual guidance for entries and hour comparisons; see the Coloured Hours legend in the workbook. |
Reset & protection
Rota Creator may be supplied in versions with or without a Reset button, and with different visual indicators.
With Reset button
Use the provided button to clear the weekly schedule as intended by that workbook version.
Without Reset button
Clear only the manual schedule entries. Avoid deleting cells containing formulas.
Saving & Backup
Save a dated copy of your completed rota before preparing another week. Keep a backup of the original template.
Installing the Reset Script
For the With Reset versions, install the supplied Office Script in a compatible Excel environment. See the user guide for setup and protection details.
Worksheet Protection
Protect formula cells after making approved changes. The workbook includes instructions for restoring protection settings.
Frequently asked questions
Why can't I select an employee?
Check that the employee exists in Employees, has the correct role, and is marked available for that day.
Why are paid hours different from the shift length?
Paid hours subtract the configured unpaid break from the total shift duration.
Can I change the working week?
Yes. Use the week/date controls in your workbook, then verify the dates shown on Rota.
Where are the short tutorial videos?
All 10 numbered video tutorials are available on this Help Centre page.