Standard Hours
A clean, straightforward view of scheduled hours without additional colour indicators.
SVER / EXCEL TOOLS
Weekly Rota Creator
Build weekly staff rotas in Excel without wrestling with formulas. Add your team, check who's available and choose shifts from simple dropdowns.
See it in action
One workbook for setting up staff, recording availability and organising a weekly schedule.
Enter staff details and use clear dropdowns instead of building spreadsheets from scratch.
Protected formulas and guided entries help reduce accidental changes to the workbook.
Paid hours and weekly totals are calculated automatically as you build your rota.
Features
Practical features designed for people who need to get the rota done.
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.
Add employee names, roles and contracted weekly hours. Keep this information together so it can be reused while scheduling.
Mark which days your team can work. If someone is away for the whole week, use the weekly absence option.
Choose the week, assign available employees and set shift start, end and break times. See paid hours calculate as you go.
See scheduled hours, weekly targets and the difference between them. Coloured Hours adds clear indicators to highlight under- and over-allocation.
Compare the styles
Your download includes Standard Hours and Coloured Hours, each with and without Reset. The screenshots show different shift allocations.
A clean, straightforward view of scheduled hours without additional colour indicators.
Extra visual indicators help you compare scheduled and contracted hours.
ALL VERSIONS INCLUDED
Standard Hours and Coloured Hours — both With Reset and No Reset.
Reset explained
Both Reset and No Reset versions are included for each display style.
Clear the schedule using an Office Script button once the script has been installed and connected. An installation guide is included.
Use the rota without Office Scripts. Clear the editable schedule entries manually, following the instructions.
GUIDED DEMONSTRATION
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 ↗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
One purchase includes all four Excel files and guidance to help you get started.
Standard Hours and Coloured Hours, each With Reset and No Reset.
Setup instructions, examples and links to tutorial videos.
Office Script code with separate installation instructions.
Online guides and free updates for the purchased version.
Need a hand?
Start with Settings, then follow the short videos through Employees, Availability and the weekly rota.
Get Rota Creator
One-time payment. No subscription. Free updates to your purchased version.
Includes all four Excel versions in one download.
Before buying, read the Terms, Licence and Refund Policy.
FAQ & support
Full setup and troubleshooting instructions are available in the Help Centre.
Open the Rota Creator guideNo. The workbook is designed around editable cells, dropdowns and protected formulas. A setup guide is provided.
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.
No. All four Excel workbooks are included. The Reset editions offer an optional Office Script, while the No Reset editions work without it.
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.
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.
Keep dated backup copies of completed workbooks before editing, clearing or resetting a week. The Help Centre explains the recommended approach.
The online Help Centre is available now. A support email address will be published before sales open.