Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do We Build the Weekly Guarding Rota Across Sites Without a Spreadsheet That Takes Two Days?
Problems We Solve

How Do We Build the Weekly Guarding Rota Across Sites Without a Spreadsheet That Takes Two Days?

Guarding rotas take days to build by hand across sites, licences and rest rules. We build rota planning that suggests eligible guards and flags gaps.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Building the guarding rota takes days because every site has its own hours, trained guards and client rules, and every guard has licence, availability and rest limits, all held in separate sheets. We build rota planning that holds site requirements and guard details together, suggests a rota that respects your rules, flags gaps and conflicts, and publishes shifts to guards' phones.

Tuesday and Wednesday, every week

The scheduler sits down with the master rota spreadsheet. Twenty-odd sites, some static 24/7, some night-only, some with a weekend extra, a retail client with a Saturday event, a construction site closing for a week. Seventy guards, each with preferred shifts, a holiday booked, a second job on Mondays, a licence expiring next month and site inductions for some sites but not others.

The scheduler copies last week, then fixes it. A guard on holiday. A new site starting Thursday that needs two inducted guards. A guard whose hours are creeping up because he keeps picking up extras. By Wednesday afternoon it is done, sent out as a PDF or a WhatsApp message, and by Wednesday evening three guards have asked for changes.

Why the rota eats two days

A guarding rota is a matching problem with lots of rules. Each shift has requirements, each guard has limits, and the rules interact. A spreadsheet can show the answer but cannot help find it, so the scheduler holds all the rules in their head and checks each cell by eye.

  • Site requirements such as hours, number of guards and client-specific training are in contract files.
  • Guard availability, holidays and preferences are in messages and a holiday sheet.
  • Licence expiry and site inductions are in separate records.
  • Rest and hours rules your company follows are checked by adding up cells.
  • Changes after publication are made by text and not always reflected in the master.

What a hand-built rota costs

Two days of a skilled person's week, every week. Mistakes that reach the site: a guard without the induction, a double booking, a guard with too little rest. Uneven hours, which upsets guards and can create cost through overtime you did not plan. And a published rota that is out of date by the time the week starts, so the control room and the payroll team work from different versions.

Working time and licensing requirements are for your company and its advisers. The system applies the rules you give it.

Rota planning built around guarding rules

  1. Each site is set up with its shift pattern, number of guards per shift, required licence type, required site induction and any client rules.
  2. Each guard's record holds licence type and expiry, site inductions, contracted hours, availability, holidays and preferences.
  3. Your rules are held as checks: minimum rest between shifts, maximum hours in a period, maximum consecutive nights, and anything else your policy sets.
  4. The planner suggests a rota for the week, starting from each guard's regular pattern, and fills gaps with eligible guards, balancing hours.
  5. The scheduler reviews and adjusts. Every change is checked immediately, and a rule broken is shown in red with the reason.
  6. Unfilled shifts are listed clearly, so recruitment or subcontract needs are visible early.
  7. Publishing sends each guard their shifts by app or text, and changes after publishing are sent as updates, with the guard confirming.
Rule typeExample the planner checks
EligibilityLicence valid on the shift date, site induction completed
RestEnough hours between a night finish and the next start
HoursWeekly and period totals within your limits
ClientOnly named or vetted guards on a particular site
PreferenceGuards not rostered on days they have said they cannot work

A week with rota planning

On Tuesday morning the scheduler opens next week's suggested rota, sees three gaps and two warnings, fixes them, and publishes by lunchtime. Guards confirm on their phones. When a guard asks to swap, the swap is checked against the rules before it is approved. The control room and payroll see the same rota. When a new site starts, its inducted guards are clear, and if there are not enough, the planner shows that before the week starts.

Does this sound like your scheduling week?

  • The rota is copied from last week and fixed by hand.
  • Licence and induction checks are done by eye.
  • Rest and hours are added up in the scheduler's head.
  • The rota goes out as a PDF or a group message.
  • Payroll and the control room work from different versions.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Does it build the rota automatically?

It suggests one that follows your rules, and the scheduler reviews and changes it. The final rota is always a person's decision.

We already use workforce software. Is this for us?

Possibly not. If your system can hold these rules and you are not using that part, we will say so and help you set it up.

Can guards swap shifts themselves?

They can request swaps, which are checked against the rules and approved by the scheduler.

Does it handle subcontracted guards?

Yes, if you record their licence and training details, they can be rostered like your own guards.

What affects the cost?

The number of sites and guards, how complex your rules are, and what it needs to connect to, such as payroll and your control room.

Keep reading

More on Problems We Solve

Start here

Tell us how your guarding operation runs its shifts

Describe your sites, how shifts are planned and covered now, and the systems your office and control room already use. We will tell you what we would build around them, and if your existing workforce system can already do it with better setup, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →