Example data

See an example, start to finish.

A walkthrough built entirely on a synthetic roster for six fictional people over one week. It isn't customer data, and nothing here is uploaded or saved.

Step 1 · Upload your roster

One row per shift.

An excerpt of the synthetic roster. After you upload it, RosterWise shows a preview like this and asks about anything it can’t read, before it checks a single shift.

Mapping preview · 4 of 38 rows Example data
Excerpt of the synthetic roster, with the column each heading was mapped to
Rowworker_ref → Workerstart → Shift startend → Shift endrole → Role
13W-03Wed 5 Mar, 15:00Wed 5 Mar, 23:00Supervisor
14W-03Thu 6 Mar, 15:00Thu 6 Mar, 23:00Supervisor
15W-03Fri 7 Mar, 07:00Fri 7 Mar, 15:00Supervisor
21W-06Mon 3 Mar, 09:00Mon 3 Mar, 17:00Team member
Step 2 · See what needs attention

What needs attention first, and why.

Synthetic roster · 6 people · 7 days

Schedule review

  • OK
  • Watch
  • Review
  • Limited data
Example schedule review. Each cell shows the status for that person's shift on that day; "Off" means no shift.
MonTueWedThuFriSatSun
Worker 01 · LatesOKOKOffOKOKWatchOff
Worker 02 · EarliesOKOKOKOffOffOKOK
Worker 03 · MixedOKWatchOKReviewReviewOffOff
Worker 04 · NightsOffOKWatchWatchOffOffOK
Worker 05 · LatesOKOKOKOKWatchWatchOff
Worker 06 · New starterLimitedLimitedOffLimitedLimitedOffLimited
Step 2 · Why each shift was flagged

Each flagged shift shows the reason.

Three findings from the example, and a decision a manager recorded.

Review

Worker 03, Thursday into Friday. A 23:00 finish followed by an 07:00 start leaves 8 hours between shifts. Rule: Working Time · 11h daily rest. Evidence: the Thursday and Friday shifts in the upload.

Watch

Worker 04, Wednesday and Thursday. Both shifts run through the night, so each is flagged under the night-work rule. Rule: Working Time · night work. Evidence: the Wednesday and Thursday shifts in the upload.

Limited data

Worker 06, every supplied shift. No earlier shifts were supplied, so rest and consecutive-day checks stay Limited data rather than being assumed fine. Adding a few weeks of earlier shifts would let them run.

Decision

Worker 03, Friday. Suggested change: reassign Friday's 07:00 shift to Worker 02, who is off on Thursday and already works at this site. A reviewer applied it, with the reason "Cover confirmed by Worker 02".

Example data Rows, rules and decisions shown are synthetic and for illustration.

Step 3 · Decide what to change

Talk it through, then decide.

Each finding shows the shifts behind it, so you can talk it through with the people on the rota. Questions a manager and Worker 03 might discuss:

Example dataQuestions drawn from the findings

Example questions to discuss

  1. Worker 03 finishes at 23:00 on Thursday and starts again at 07:00 on Friday. That leaves 8 hours between shifts, under the 11-hour daily rest reference. Could Friday's start be later, or Thursday's shift end earlier?
  2. Wednesday and Thursday are both late shifts finishing at 23:00, followed by an early start on Friday. Is a run of lates into an early a regular part of the rota?

The findings describe the shift pattern only. RosterWise can't know how anyone slept or feels, and it isn't a medical or fitness assessment.

Optional · Sales against staffing

Staffing against trading, before you change it.

With sales data added, the same roster can be read against demand. This staffing-level scenario removes one worker from the quiet 07:00 to 11:00 period and compares the result with what was observed.

  • Sales per labour hour is shown for every observed period; the strongest is highlighted
  • The cost shown is allocated labour cost at an example rate, not a cash saving
  • A scenario is a model and claims no saving
Synthetic store · Saturday

Hourly sales against staff on shift, for illustration; in the app, trading periods are grouped into two-hour slots. The shaded hours are the quiet morning. The dashed line models one fewer worker in that period.

Example data
£0 £400 £800 £1200 0 2 4 6 07:00 09:00 11:00 13:00 15:00 17:00 19:00 Sales Staff
  • Sales
  • On shift (observed)
  • Scenario (modelled)
Sales per labour hour, 07:00 to 11:00
£95 → £120observed → modelled
Paid hours
60 → 56one worker, four hours
Allocated cost of those hours
£50example rate; not a cash saving

The £50 becomes a saving only if you actually remove the hours. Workforce and service checks are shown with every scenario; where data is missing, a service check shows as unknown rather than OK.

Ready to see it on your own roster?

Tell us about your sites and the data you have, and we'll agree the right plan with you. This example is synthetic; analysing your own rosters starts once your plan is in place.