Free TimeTrex resource
Measure unique changes to a posted roster, reconcile cancellations and additions, and compare two periods with an explicit baseline.
Use whole shift records, not hours, people or edit events. The defaults are an illustrative example. Blank inputs are errors; enter 0 for a confirmed zero.
Let B be baseline shifts, C unique changed baseline shifts, K canceled baseline shifts, A active added shifts, P previous baseline shifts and Q previous changed shifts. Change rate = C ÷ B × 100; never-changed count = B − C; changed records still active = C − K; cancellation rate = K ÷ B × 100; active additions relative to baseline = A ÷ B × 100. Active count at cutoff = B − K + A; net count change = A − K. Previous rate = Q ÷ P × 100. Current minus previous is a percentage-point difference, not a relative percent change.
In the example, 36 of 200 baseline shifts changed: 18.00%. There are 164 never-changed and 28 changed-but-active baseline records. Eight cancellations represent 4.00% of the baseline; 12 active additions represent 6.00%. The reconstructed active roster is 200 − 8 + 12 = 204 shifts, a net increase of 4. The previous rate is 45 ÷ 180 = 25.00%, so the current rate is 7.00 percentage points lower.
Changed shifts cannot exceed their baseline; cancellations cannot exceed changed shifts. Zero baseline permits only zero baseline changes and cancellations. It can still have active additions, which remain visible, but all baseline percentage metrics are N/A. A previous baseline of zero disables the comparison. Active additions can exceed the original baseline and their relative rate can exceed 100%; this does not change the baseline change rate. The cancellation rate overlaps the change rate, so do not add them. Rounding is for display; exports retain unrounded numeric ratios. No target, grade, legal notice threshold or recommended change rate is supplied. This tool measures neither attendance adherence nor whether an open shift was filled.
Copy this CSV if your browser blocks the download.
Checked October 30, 2026. This is an independent operational worksheet. It uses no jurisdiction-specific rules, legal thresholds or study performance claims.
Disclaimer: This voluntary aggregate worksheet uses a fixed posted-roster baseline and the unique-shift counting rules shown in the tool. It does not audit a change log, measure notice time or hours affected, attribute changes to an employer or employee, or establish whether a change was necessary or agreed. Reconcile split, merged and restored shifts consistently; cancellations are a subset of changed baseline shifts and additions stay outside that denominator. Period comparisons require comparable scope and observation windows. Results do not determine scheduling-law compliance, premiums, wages, staffing adequacy, worker well-being or individual performance, and no universal change-rate benchmark is implied. Verify all inputs, results and assumptions against appropriate records and obtain qualified advice before relying on them. To the fullest extent permitted by applicable law, this resource is provided “as is” without warranties of accuracy, completeness or fitness for a particular purpose, and TimeTrex and its affiliates disclaim liability for losses, damages, costs or claims arising from its use, inability to use, or reliance on it, including errors or omissions. Nothing in this disclaimer excludes or limits liability or rights that cannot lawfully be excluded or limited.
Trusted By
Join our ever-growing community of satisfied customers today and experience the unparalleled benefits of TimeTrex.
Strength In Numbers
Time To Clock-In
Experience the Ultimate Workforce Solution and Revolutionize Your Business Today
Saving businesses time and money through better workforce management since 2003.
Copyright © 2026 TimeTrex. All Rights Reserved.