SVER Help Centre

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 guide

Welcome 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.

01 / SETUP

Get ready

Set up shifts first, then add employees and review availability before scheduling.

02 / SCHEDULE

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.

STEP 1

Settings

Define roles, shifts, times, unpaid breaks and your working week.

STEP 2

Employees

Add names, roles and contracted weekly hours.

STEP 3

Availability

Review which days each employee can work.

STEP 4

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.

  1. 1Enter a Shift name, then select its Role.
  2. 2Choose the Start and End times.
  3. 3Enter the Unpaid break in minutes. Paid hours calculate automatically.
  4. 4Add the remaining shift patterns required by your business.
  5. 5Select the first day of the week (for example, Monday).
After changing a shift’s role, times or break, reselect any affected shifts on the Rota sheet. Existing rota selections do not update automatically.

Employees

Once your shift settings are ready, add your team. The workbook uses employee roles and weekly hours when creating the rota.

  1. 1Open the Employees worksheet.
  2. 2Enter each employee's name, role and weekly hours.
  3. 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.

  1. 1Open Availability and review each employee's days.
  2. 2Mark individual days as Yes or No as required.
  3. 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.

  1. 1Open Rota and select the correct week.
  2. 2Choose an available employee from the appropriate dropdown.
  3. 3Set shift Start, End and break values.
  4. 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.

ItemMeaning
Paid hoursShift duration less the unpaid break.
Scheduled hoursTotal paid hours currently allocated in the week.
Daily staff countNumber of scheduled employees for a day.
Colour indicatorsVisual guidance for entries and hour comparisons; see the Coloured Hours legend in the workbook.
Standard Hours and Coloured Hours are both included in the purchase. Choose the style that works best for you.

Reset & protection

Rota Creator may be supplied in versions with or without a Reset button, and with different visual indicators.

VERSION A

With Reset button

Use the provided button to clear the weekly schedule as intended by that workbook version.

VERSION B

Without Reset button

Clear only the manual schedule entries. Avoid deleting cells containing formulas.

Keep a backup copy before clearing a completed week. Worksheet protection is used to reduce accidental changes, but it is not a security guarantee.

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.

↑ Back to top

These tutorials use the actual Rota Creator workbook. Confirm workbook-specific steps in the included user guide.