Rotation Analytics
Clarity from Complexity.
Example Rotation Analysis
A sample rotation schedule that passed manual review — and the hidden issues that structured analysis revealed.
Context
Rotations are routinely reviewed and accepted without structured analysis.
Unionized rotation schedules are typically reviewed manually by schedulers and labour relations staff. At first glance, most rotations appear to meet staffing requirements and basic rest provisions. Subtle issues, however, can persist across rotation cycles without detection.
These hidden problems include insufficient rest periods between shifts, weekends off that do not meet collective agreement thresholds, non-compliant consecutive shift sequences, on-call violations, and days off configurations that fail minimum requirements. High-impact violations carry documented fatigue risk and create grounds for grievance proceedings.
Before Analysis
A Rotation That Looks Acceptable
This rotation passed initial manual review and appeared compliant. It covers 10 weeks with 11 shift lines across day, evening, night, and on-call assignments.
Unchecked Sample Rotation
Excel Spreadsheet
This rotation appears compliant on visual inspection. Shifts are covered, staffing levels look adequate, and rest days are present throughout.
The Gap
Why Manual Review Misses Problems
Manual reviews typically confirm the fundamentals — are shifts covered, are staffing levels adequate, do workers appear to have rest days. These checks are necessary but insufficient.
Shift coverage
Are all shifts covered by an assigned worker?
Staffing levels
Are the right number of workers scheduled each day?
Basic rest windows
Do workers appear to have days off between blocks of shifts?
These checks pass. The rotation looks acceptable. But deeper issues remain.
What Gets Missed
Insufficient hours between shifts that fall just below the collective agreement threshold
Weekend off requirements across multi-week periods that are not immediately visible
Consecutive shift limits that are exceeded when counting across week boundaries
On-call shifts placed before off-duty days in violation of scheduling provisions
Single day off occurrences hidden within longer apparent rest patterns
After Analysis
The Same Rotation — With Issues Highlighted
Structured analysis applied 15 parameters drawn from the applicable collective agreement and employment standards. Cells highlighted in orange indicate insufficient hours between shifts. Cells in pink or purple indicate on-call scheduling violations.
Checked Sample Rotation
Excel Spreadsheet — violations highlighted
Following structured analysis, a number of non-conformances present themselves across this rotation — highlighted directly within the schedule for review. The full findings are documented in the executive report.
Key Issues Identified
Structured analysis of 15 parameters revealed 5 areas that did not meet requirements.
15
Parameters Applied
10
Met
5
Not Met
4
High Impact
1
Medium Impact
Regular Weekends Off
Lines 1, 3, 9, and 10 do not meet the minimum required weekends off within the specified period.
Maximum Consecutive Shifts
Line 3 exceeds the maximum permitted instances of long runs of consecutive shifts (3 instances found, 2 permitted).
Minimum Hours Off Between Shifts
Lines 1, 2, 3, 7, and 8 do not meet the required minimum of 15.5 hours off between shifts.
Full-time Minimum Consecutive Days Off
Line 3 contains single days off in weeks 3 and 8 where a minimum of 2 consecutive days off is required.
On Call Scheduling Parameters
Lines 1, 5, 6, 9, 10, and 11 have on-call shifts placed the evening before or during scheduled off-duty days.
Each issue is documented in the executive report with applicable collective agreement references, specific line numbers affected, and the relevant periods. The full report is available on the Sample Report page.
Operational Reality
Why This Happens in Real Organizations
Rotation planning is an extremely complex exercise. A 10-week rotation with 11 lines contains over 700 individual shift assignments, each governed by intersecting rules from collective agreements, employment standards, and operational requirements.
Collective agreements contain nuanced provisions — weekend off requirements averaged across multi-week periods, consecutive shift limits counted across week boundaries, minimum rest hours measured to the half-hour. Manual reviews are time-consuming and structurally unable to trace all intersecting parameters simultaneously.
Volume
A single 10-week rotation contains 700+ shift assignments across multiple line types and classifications.
Intersecting Rules
Parameters from collective agreements, employment standards, and operational policies apply simultaneously to each assignment.
Hidden Patterns
Violations often span multiple weeks or appear only when measuring exact hours across shift transitions.
Limited Time
Schedulers and labour relations staff rarely have capacity for cell-by-cell parameter verification across full rotation cycles.
The Solution
Structured, Independent Rotation Analysis
Rotation Analytics Inc conducts structured evaluation of rotation schedules, applying documented parameters against the full rotation cycle to identify issues that manual review cannot reliably detect.
Compliance Evaluation
Every shift assessed against collective agreement provisions and applicable employment standards.
Rest Interval Analysis
Exact hours between shifts calculated across the full cycle, measured against documented thresholds.
Pattern Detection
Consecutive shift sequences, weekend distribution, and on-call placement evaluated across multi-week periods.
Documented Findings
Executive report with risk-classified findings, specific line references, and applicable agreement citations.
See the Full Executive Report
This rotation generated a structured executive report documenting all 15 parameters evaluated, with risk classifications and applicable agreement references.