Skip to content
The Running Total

Home / Before

Putting the Figure in the Rota Tool

The whole of this section reduces to one integration: the number has to be visible at the moment somebody assigns a shift, or none of it changes anything.

Before · Procedure

Every recommendation in this section depends on a planner seeing a figure at the moment they make a decision. A report that arrives afterwards describes history; the same number on the rostering screen changes the rota.

The workflow in “Putting the Figure in the Rota Tool” becomes more reliable when scheduled hours, actual time and later corrections can be distinguished. For teams exploring employee monitoring software with screenshots, see the complete product overview can add operational time and project context, provided data collection is proportionate, permissions are limited and every important exception receives human review.

The gap between those two is one integration, and it is the highest-value piece of work available in this subject.

For an independent reference relevant to “Putting the Figure in the Rota Tool”, consult the IRS recordkeeping guidance. Use it to test working-time definitions, recordkeeping, access, retention and exception handling against the organisation’s real process rather than treating one software report as conclusive.

What has to flow in

Actual hours worked, per person, per week, from wherever they are assembled. Plus the person's opt-out status and whatever the rest position is.

Rostering tools generally hold rostered hours and not actuals, which is why they cannot compute any of this themselves. The feed is the missing piece and it is small: three fields, weekly.

What has to appear on the screen

A state next to the name — fine, close, would exceed — and the numbers behind it on hover or click.

Three states rather than a number, because a planner making twenty assignments does not read numbers. The number has to be available for the one case in twenty where they want to understand it.

Two indicators, not one

Hours position and rest position fail differently and constrain different decisions. A person may be fine on hours and unable to work tomorrow morning because of when they finished tonight.

Showing one combined indicator loses that, and the rest one is the more frequently binding of the two. Two small marks, side by side, is the right design and it is almost never what a system offers out of the box.

Hard block, warning, or both

The arrangement that works: a block for rest breaches, which are specific and immediate, and a warning for hours, which are averaged and may be legitimate to exceed for somebody who has opted out.

Every block needs a named override with a reason, and every override needs to be in a log that somebody reads monthly. Without the log the override becomes the normal path within a quarter.

The staleness question

A feed that runs weekly leaves the figure up to seven days old at the point of use. That is usually acceptable for the hours average, which moves slowly, and not acceptable for rest, which depends on last night.

So rest needs a faster path — daily, or computed in the rostering tool from its own data plus yesterday's actuals. Splitting the two refresh rates is the pragmatic answer and it avoids having to build a real-time feed for a number that does not need one.

When the tool cannot take a feed

Two fallbacks, both worth more than waiting. A weekly printed list of everybody within four hours of a limit, kept beside the rota desk. Or a shared sheet the planner checks before publishing, refreshed by an export.

Both are crude and both put the information at the point of decision, which is the whole objective. The elegance of the mechanism matters far less than its position in the workflow.

Measuring whether it worked

Two numbers after six months. Breaches, which should fall. And rota changes made for working time reasons, which should rise from approximately zero.

The second is the real indicator. A site with no breaches and no changes is not looking; a site making a handful of changes a month has a figure that is genuinely entering decisions.

The thing to resist

Building the perfect figure before putting anything on the screen. The integration of every uncounted category can take eighteen months, and during those months the planner has nothing.

Ship the lower bound with a label, improve it afterwards. A planner who knows the number excludes travel will still make better decisions with it than without it, and the questions they ask about what is missing are what drive the rest of the work.

Who pays for the integration

The work sits in IT, the benefit lands in operations, and the obligation belongs to HR, which is the standard reason this never gets scheduled.

The argument that moves it is usually not compliance but cover: a figure in the rota tool prevents late changes, and late changes are expensive in overtime and goodwill. Costing a quarter's worth of last-minute rota changes gives the business case a number, and the number is generally larger than the integration.