Free TimeTrex resource
Measure unavailable hours within one scheduled-hours pool. Estimate gross hours for a net activity requirement and compare a clearly defined scenario.
Use the same team, period and covered activity for every input. Enter decimal hours, not hours:minutes.
Every hour in the pool is either available for your selected activity or unavailable in one category. Exclude unpaid time outside the pool from both numerator and denominator.
Let G be scheduled hours, P planned unavailable hours, U unplanned unavailable hours and D required activity hours. Shrinkage s = (P + U) ÷ G. Available hours = G − P − U. Required gross hours = D ÷ (1 − s).
With 1,000 scheduled hours, 150 planned and 100 unplanned unavailable hours, shrinkage is 25% and available activity time is 750 hours. Covering 900 activity hours at that rate requires 1,200 gross hours. A separate 20% scenario requires 1,125 gross hours.
The signed gap compares required gross hours with the current pool: positive means more gross hours; negative means fewer. It is an arithmetic comparison, not permission to change a roster. FTE capacity equivalent divides required gross hours by your gross hours per FTE for that same period.
If unpaid lunch is outside your gross-hours pool, leave it out of unavailable hours too. If an activity is inside the pool but unavailable for the chosen coverage task, count it in exactly one category. Document the policy before comparing teams or periods.
Some scheduling systems already model daily activities or use a residual shrinkage factor. Reconcile those definitions before transferring this total-pool rate. Adding an adjustment already present in the required hours overstates the estimate.
Scheduled hours and hours per FTE must be positive. Other hour inputs can be zero. Planned plus unplanned hours cannot exceed scheduled hours. Inputs accept up to two decimal places; hours are limited to 100,000 and hours per FTE to 8,760. The scenario accepts 0% through 99.99%.
At 100% measured shrinkage there are no available activity hours. A positive activity requirement has no finite gross-hours solution; a zero requirement needs zero hours. The scenario remains a separate calculation. No zero-division result is hidden as a staffing recommendation.
Gross-hours requirements round upward to the next 0.01 hour. Other displayed figures round to two decimals; exported values retain the stated measures. Calculations use the unrounded measured ratio. Very high shrinkage can create large estimates that need careful review.
This is an aggregate hours balance. A weekly total cannot prove that each shift has coverage. Evaluate the time of day, skills, workload, availability, occupancy assumptions and applicable requirements separately before making decisions. FTE equivalents are not a count of employees to hire.
No scenario recommends removing necessary rest, leave, training or other duties. The worksheet stores no inputs and does not connect to a scheduling system. Retain your exported assumptions with the underlying records.
Copy this CSV if your browser blocks the download.
Primary sources checked October 22, 2026. Definitions inform this independent worksheet. The two-category pool, scenario and rounding rules are defined here; no benchmark or legal rule is imported.
Disclaimer: This voluntary aggregate planning worksheet uses user-entered scheduled, unavailable and required activity hours. It is not a roster, service-level forecast, payroll calculation or legal, safety or staffing recommendation. Results assume consistent definitions, non-overlapping categories and a constant shrinkage rate. Necessary breaks, leave, training and other duties can be valuable; the scenario is not a recommendation to reduce them. FTE values are capacity equivalents, not employee counts. Examples are not benchmarks. 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.