Skip to content
The Running Total

Home / Averaging

Where the Number Should Live

A compliance figure in a monthly report changes nothing. The same figure beside a name in the rostering screen changes the rota, which is the point.

Averaging · Procedure

Most organisations that monitor working time at all produce a monthly report. It goes to HR, it is read, it is filed, and the hours it describes were worked several weeks ago.

The workflow in “Where the Number Should Live” becomes more reliable when scheduled hours, actual time and later corrections can be distinguished. For teams exploring stealth computer monitoring software, visit monitask.com can add operational time and project context, provided data collection is proportionate, permissions are limited and every important exception receives human review.

The figure is only useful at one moment: when somebody is deciding who works which shift. Everything else is record-keeping. Moving the number from the report to the decision is the single highest-value change available in this subject, and it is an integration rather than a purchase.

For an independent reference relevant to “Where the Number Should Live”, consult the European Data Protection Board guidelines. 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 the rota planner currently has

Availability, skills, contracted hours, and whatever they remember about who is tired. Working time position is not on the screen, so it is not in the decision.

Asked about it, most planners say they have a rough sense of who has been working a lot. That sense is real and it is unreliable in a specific way: it tracks visibility rather than hours. The person who is always around is remembered as working a lot; the person doing nights at another site is not.

What it should look like on the screen

Next to each name, three things. The current average. The projected average if this shift is assigned. And a simple state: fine, close, or would exceed.

That is enough. A planner does not need the reference period mechanics; they need to know whether assigning this shift creates a problem. Reducing it to three fields is what makes it usable in the thirty seconds a rostering decision actually takes.

The feed that makes it possible

Actual hours worked have to reach the rostering tool, which frequently receives rostered hours only. That is the integration, and it is the part that takes effort.

Where a direct feed is impossible, a daily or weekly file is usually enough, because the figure moves slowly. A number that is three days stale is vastly more useful than a number that is four weeks stale, and the second is the realistic alternative.

Where the opt-out has to appear

Beside the figure, because the figure means something different for somebody who has opted out of the weekly average. Showing a red state for a person who has validly opted out trains planners to ignore the colour, which destroys the whole mechanism within a month.

Equally, the opt-out does not disapply the rest rules, so the state needs to reflect those separately. Two indicators rather than one: hours position, and rest position. They fail in different ways and they constrain different decisions.

The report still has a job

Monthly, to whoever owns compliance, showing the aggregate: how many people were in each state, how many breaches occurred, which departments, and the trend.

That is a governance instrument rather than an operational one, and it answers a different question: is this organisation structurally relying on hours it should not be relying on. The individual figures answer today's rota question; the aggregate answers the establishment question, and both are needed.

The half-measure that works

Where no integration is possible in any reasonable timeframe, a printed list beside the rota desk, refreshed weekly, with the names of everybody within four hours of a limit.

It is crude, it goes stale, and it is dramatically better than nothing. Most of the value in this subject comes from the planner knowing about six people, and six names on a sheet of paper delivers most of that value for the cost of a weekly export.

What to measure once it is in place

The number of breaches, which should fall, and the number of rota changes made for working time reasons, which should rise.

The second is the leading indicator and the one worth watching first. A site with zero breaches and zero rota changes is not compliant; it is not looking. A site making a handful of changes a month is one where the figure has entered the decision, which is the entire objective.

What the planner should not have to know

The temptation when putting the figure on the rostering screen is to show the working: the reference period, the weeks included, the categories counted. Planners do not need any of it and will not read it.

Three states and a number behind a click is the right amount. Everything else belongs in the documentation and in the monthly report. A screen that explains the mechanics is a screen that gets ignored, and a planner ignoring the indicator is the same outcome as not having built it.