SDSimpleDesigns

Home/Spreadsheets/Small Business/Team Capacity Planner

Team Capacity Planner

A team capacity planner spreadsheet that shows who is booked, who is free and who is over capacity, week by week, on a color-coded utilization heatmap. The files open in Microsoft Excel and in Google Sheets, have no macros and nothing to install, and are yours to reuse as often as you like.

What it does

  • Up to 30 people across 26 weeks (half a year)
  • Utilization heatmap: green = healthy, amber = near the limit, red = over capacity, gray = away all week
  • A "fix these first" list: the worst over-capacity weeks, ranked, with how many hours to move
  • At a glance: team use, over-capacity person-weeks, the busiest person and the peak week
  • A status for every person (OK, near limit, over or under-used) and team totals per week
  • Time off (holiday, leave, training) comes off that week's available hours
  • Make it yours: your title, start date and limits on the Settings tab
  • Opens in Excel and in Google Sheets
$4.99one-time, no subscription
Buy on Etsy

Instant digital download · one-time purchase · no subscription

Team Capacity Planner — the workbook open in Excel

What it looks like

Team Capacity Planner screenshot
Team Capacity Planner screenshot

What is in the bundle

Works in

Honest scope

This is a planning and bookkeeping template, not tax or accounting advice. The numbers it reports are the numbers you enter.

Others in Small Business

Team Capacity Planner$4.99Buy on Etsy