Individual Sprint Capacity Formula With Absence Rates
Learn how individual sprint capacity is estimated after planned absence, expected unplanned absence, and focus time are allowed for.
This calculation estimates the focused sprint hours one person may realistically have available. It reduces scheduled time for known absences, limits the remainder to likely focus time, and then applies an allowance for unplanned absence.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Estimated Sprint Capacity Hours
Where:
Start with the days left after known time away. Convert them to hours, keep only the share likely to be available for sprint work, and reduce that focused time by the expected unplanned absence percentage.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| sprintWorkdays - Sprint working days | Scheduled working days in the sprint before planned absences are removed. | days |
| plannedAbsenceDays - Planned absence days | Known leave, training, holidays, appointments, or other planned time away during the sprint. | days |
| hoursPerDay - Working hours per day | Normal scheduled working hours on a workday. | hours |
| focusFactor - Focus time available | Share of scheduled available time expected to be usable for sprint work after meetings, support, and routine duties. | percent |
| unplannedAbsenceRate - Expected unplanned absence rate | Estimated percentage of focused sprint time expected to be lost to unplanned absence. | percent |
Step-by-Step Calculation
Remove planned absence
Known time away is removed from the sprint before any other adjustment.
scheduledAvailableDays = max(0, sprintWorkdays - plannedAbsenceDays)
Convert remaining days to hours
The remaining scheduled days are converted into scheduled hours.
scheduledAvailableHours = scheduledAvailableDays * hoursPerDay
Apply the focus factor
This estimates the part of available time that can be used for planned sprint work.
focusedHoursBeforeUnplannedAbsence = scheduledAvailableHours * (focusFactor / 100)
Estimate unplanned absence impact
The expected unplanned absence rate is applied to focused sprint hours.
absenceHours = focusedHoursBeforeUnplannedAbsence * (unplannedAbsenceRate / 100)
Calculate sprint capacity
The remaining hours are the estimated individual capacity for sprint work.
sprintCapacityHours = focusedHoursBeforeUnplannedAbsence - absenceHours
Express capacity as workdays
Divide estimated capacity hours by normal daily hours to show an equivalent number of full workdays.
effectiveWorkdays = sprintCapacityHours / hoursPerDay
Two-week sprint with one planned day away
Days after planned absence
max(0, 10 - 1)
9 days
Scheduled available hours
9 * 8
72 hours
Focused hours before unplanned absence
72 * (80 / 100)
57.6 hours
Expected absence impact
57.6 * (10 / 100)
5.8 hours
Estimated sprint capacity
57.6 - 5.76
51.8 hours
Effective workdays
51.84 / 8
6.5 days
Final Result
Estimated individual sprint capacity: 51.8 hours, equivalent to 6.5 effective workdays.
Assumptions
- ✓The sprint contains the stated number of scheduled working days.
- ✓Planned absence is removed before the unplanned absence allowance is calculated.
- ✓The focus factor represents time remaining after meetings, support, administration, and routine work.
- ✓The unplanned absence rate is applied to focused sprint time rather than all calendar or scheduled time.
- ✓Hours per day are consistent across the remaining sprint workdays.
Limitations
- !Actual availability can change because of urgent work, new meetings, illness, or changes in priorities.
- !A historical absence percentage may not represent a particular upcoming sprint.
- !The calculation measures time, not task complexity, dependencies, or the effort required to complete work.
- !Focus time can vary materially between sprint phases and types of work.
- !The result is a planning estimate and not a commitment or performance measure.
Common Mistakes to Avoid
Entering public holidays as normal sprint workdays instead of excluding them or recording them as planned absence.
Including known leave in both planned absence days and the unplanned absence percentage.
Applying the absence percentage to all scheduled hours when this calculator applies it after the focus-time adjustment.
Treating a focus factor of 100% as realistic when recurring meetings and support duties remain.
Using capacity hours alone to decide scope without considering dependencies, uncertainty, and historical delivery.
Related Formulas
Frequently Asked Questions
What is the formula for individual sprint capacity?
Capacity equals remaining scheduled days after planned absence, multiplied by hours per day, focus time available, and one minus the unplanned absence rate.
Why is planned absence removed before the absence rate?
Known leave and other planned time away are specific days that cannot be scheduled. The unplanned allowance is then applied to the focused time that remains.
How are effective workdays calculated?
Effective workdays equal estimated sprint capacity hours divided by normal working hours per day.
Does the unplanned absence rate apply to all sprint hours?
No. In this calculation it applies to focused sprint hours after the focus factor has been applied.
Can estimated capacity be zero?
Yes. It will be zero if planned absence equals or exceeds sprint working days, or if the focus factor is zero.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.