SVER / EXCEL TOOLS

Weekly Rota Creator

Staff scheduling
made simple.

Build weekly staff rotas in Excel without wrestling with formulas. Add your team, check who's available and choose shifts from simple dropdowns.

✓ Protected formulas✓ Easy to use✓ One-time purchase
£19.99One-time purchase
No subscription
Weekly Rota Creator in action18-second product trailer · click to play
REAL EXCEL DEMONSTRATION01 — Overview

See it in action

A better way to build your week.

One workbook for setting up staff, recording availability and organising a weekly schedule.

01

Simple by design

Enter staff details and use clear dropdowns instead of building spreadsheets from scratch.

02

Less room for mistakes

Protected formulas and guided entries help reduce accidental changes to the workbook.

03

Hours at a glance

Paid hours and weekly totals are calculated automatically as you build your rota.

Features

Everything in its place.

Practical features designed for people who need to get the rota done.

01 / SETTINGS

Start with your shift settings.

Set up the roles and shift patterns your business uses, including start and finish times, unpaid breaks and the first day of the working week.

View the Settings guide

Settings — tutorialNarrated demonstration · optional English captions
02 / EMPLOYEES

Set up your team once.

Add employee names, roles and contracted weekly hours. Keep this information together so it can be reused while scheduling.

Employees — tutorialNarrated demonstration · optional English captions
03 / AVAILABILITY

Know who's available.

Mark which days your team can work. If someone is away for the whole week, use the weekly absence option.

Availability — tutorialNarrated demonstration · optional English captions
04 / THE ROTA

Pick a week. Build your rota.

Choose the week, assign available employees and set shift start, end and break times. See paid hours calculate as you go.

Creating the weekly rota — tutorialNarrated demonstration · optional English captions
05 / SCHEDULED HOURS

Know how the hours add up.

See scheduled hours, weekly targets and the difference between them. Coloured Hours adds clear indicators to highlight under- and over-allocation.

More on weekly hours

▶Scheduled Hours — tutorialNarrated demonstration · optional English captions

Compare the styles

Both styles. One purchase.

Your download includes Standard Hours and Coloured Hours, each with and without Reset. The screenshots show different shift allocations.

Standard HoursGenuine Excel screenshot — click to enlarge

Standard Hours

A clean, straightforward view of scheduled hours without additional colour indicators.

Coloured HoursGenuine Excel screenshot — click to enlarge

Coloured Hours

Extra visual indicators help you compare scheduled and contracted hours.

ALL VERSIONS INCLUDED

Four Excel workbooks in one download

Standard Hours and Coloured Hours — both With Reset and No Reset.

See the complete package ↓

Reset explained

Use Reset — or don't.

Both Reset and No Reset versions are included for each display style.

↻With ResetOptional script button

With Reset

Clear the schedule using an Office Script button once the script has been installed and connected. An installation guide is included.

⌫Without ResetManual clearing of editable entries

Without Reset

Use the rota without Office Scripts. Clear the editable schedule entries manually, following the instructions.

GUIDED DEMONSTRATION

Preparing your rota for the next week

See how to save a dated copy, use the Reset command or clear entries manually, and manage Availability for a new week.

Read the Reset instructions ↗
▶Preparing a new weekNarrated tutorial · optional English captions

All four Excel versions are included. Office Scripts requires compatible Excel access and a one-time setup; the manual option requires no script.

What's included

Everything you need to get started.

One purchase includes all four Excel files and guidance to help you get started.

01

Four Excel workbooks

Standard Hours and Coloured Hours, each With Reset and No Reset.

02

Step-by-step PDF guide

Setup instructions, examples and links to tutorial videos.

03

Reset script and setup guide

Office Script code with separate installation instructions.

04

Product help and updates

Online guides and free updates for the purchased version.

Need a hand?

Step-by-step guide & video tutorials

Start with Settings, then follow the short videos through Employees, Availability and the weekly rota.

Open Help Centre ↗

Get Rota Creator

Make next week's rota easier.

One-time payment. No subscription. Free updates to your purchased version.

Includes all four Excel versions in one download.

£19.99
Buy now — £19.99 ↗Secure checkout and instant digital download via Payhip.

FAQ & support

Good to know.

Full setup and troubleshooting instructions are available in the Help Centre.

Open the Rota Creator guide
Do I need advanced Excel skills?

No. The workbook is designed around editable cells, dropdowns and protected formulas. A setup guide is provided.

Which Excel versions are supported?

Rota Creator uses modern Excel features. We recommend a recent, compatible version of Excel for Windows or Excel on the web. Older versions may not support every function. Office Scripts are only needed for the optional Reset versions and require a supported Excel environment.

Do I need the Reset feature?

No. All four Excel workbooks are included. The Reset editions offer an optional Office Script, while the No Reset editions work without it.

Are updates included?

Yes. Updates to your purchased version are free. You can opt in to update notifications or check the SVER website and request the latest version by email once contact details are available. Distinct future products may be sold separately.

Can I share the workbook?

The intended licence is for use within one purchasing business. Resale or redistribution outside that business is not permitted. Full terms will be published before checkout is enabled.

How do I protect my saved rotas?

Keep dated backup copies of completed workbooks before editing, clearing or resetting a week. The Help Centre explains the recommended approach.

Where can I get support?

The online Help Centre is available now. A support email address will be published before sales open.