How to use Team Capacity Planner
- Paste or choose an availability CSV with person, date and available_hours headers. Supply one row per person/date, including zero for an unavailable day.
- Paste or choose an allocations CSV with person, date, project and hours headers. Several projects can use the same person/date, but each needs a corresponding availability row.
- Run the comparison and review available hours, summed allocations, utilization and overload for each person/day.
- Download the report and adjust the original plan. Apply leave, holidays and local working rules in the availability source; the tool does not infer them.
Example: Team Capacity Planner
Compare dated availability with allocations across projects.
Supported inputs and limits
- Each CSV has up to 2,000 rows, 80 columns and 2 MiB.
- Availability needs distinct person/date pairs and 0–24 hours.
- Each allocation is nonnegative and capped at 168 hours; totals may exceed availability and are reported as overload.
- Every allocation must have an availability row; explicit zero represents an unavailable day.
- Dates are calendar dates without timezone or workweek inference.
More details
Holidays, leave, skill suitability and overlapping clock intervals are not derived.
No labour-law or staffing assurance is made.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
Questions about Team Capacity Planner
Will the tool subtract weekends and public holidays?
Only the entered availability controls the total. Provide the available hours for each date after applying the calendar, leave and work rules relevant to your team.
How are several projects on one day combined?
All allocations for the same person and date are summed. The report also lists project subtotals so you can find which assignments contribute to an overload.
What does unavailable utilization mean?
A person with zero available hours and a positive allocation cannot have a finite utilization percentage. The report labels that case unavailable and still shows the overload hours.