Free TimeTrex resource
Calculate the percentage of required shift positions that have confirmed assignments. See open positions and the additional fills needed for a chosen target, then export your results.
Use the same team, schedule period, role group and confirmation cutoff for both counts. The defaults are an example.
Use approved schedule requirements. Exclude canceled positions consistently from both counts, and do not lower genuine requirements just to improve the percentage. This worksheet stays in your browser and does not read or update TimeTrex records.
This is a position-count measure, not an hours-weighted rate. One four-hour position and one twelve-hour position each count once. Count separate role or duration groups if combining them would hide important gaps.
Confirm qualifications, availability, rest and break requirements, overlapping assignments and required approvals before filling a position. Reaching the target does not establish that a schedule is safe, lawful, affordable or workable. A confirmed assignment also does not prove that the shift will be worked.
Fill rate = 100 × filled / required. Open rate = 100 × (required − filled) / required. Minimum filled positions for a target = round upward(required × target / 100). Additional fills = max(0, minimum filled − already filled).
For 40 required positions and 35 confirmed fills, the fill rate is 87.50% and five positions remain open. A chosen 95% target needs 38 confirmed fills, so three additional positions must be filled. Two positions can still remain open at that target; whether those gaps are acceptable requires separate operational review.
Positions are whole assignments. With three required positions, a target of 66.67% needs three fills because two out of three is only 66.666…%. The displayed rate rounds to two decimals, but target decisions use the unrounded values.
The target accepts two decimal places. Required and filled counts accept whole numbers from 0 to 1,000,000. The target calculation uses an integer scale of 10,000 to avoid a floating-point rounding error at whole-position boundaries.
With zero required positions, the fill and open rates are N/A rather than 100%. Filled positions must also be zero. The arithmetic target count and additional fills are zero, but no coverage conclusion can be drawn. A zero-percent target needs zero fills and does not mean an uncovered schedule is acceptable.
Keep a consistent denominator when comparing teams or periods. When pooling groups, sum their filled counts and required counts before dividing. Do not average their percentages without weighting. Separate canceled demand, tentative assignments and actual attendance from confirmed coverage.
Review open positions by time, location and required skills. A high overall rate can still conceal a completely uncovered critical shift. This aggregate worksheet cannot identify overlaps or evaluate workload, hours, pay or staffing sufficiency.
Explore TimeTrex scheduling and leave management to review schedule preferences, availability and approvals in an authorized workflow.
Copy this CSV if your browser blocks the download.
Primary product sources checked October 21, 2026. They support the operational scheduling context. The formulas and counting rules on this page define a voluntary planning measure; they are not an official reporting standard, benchmark or staffing recommendation.
Disclaimer: This voluntary planning worksheet uses aggregate user-entered shift-position counts and a chosen target. It does not create schedules, verify worker qualifications or availability, measure worked hours, predict attendance, or determine safe staffing, pay obligations or legal compliance. Targets are illustrative, not recommended benchmarks. Different shift durations and roles need separate review; a high aggregate rate can hide critical gaps. 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.