Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesProject & Task ManagementProject PlanningTeam Resource Allocation

SpreadsheetProject PlanningFree

Team Resource Allocation

Plan hours by person, project and week for the next eight weeks, and see who is over or under capacity.

Shown with sample data

Colour

Team Resource Allocation

Plan hours by person, project and week for the next eight weeks, and see who is over or under capacity.

Hours planned
1,240
Next eight weeks
Client hours
1,088
Billable share
91%
Client hours as a share of working hours
Over-allocated weeks
5
Person-weeks above 100%
Peak utilisation by person
  • Lea Martin137.5%
  • Raj Mehta110%
  • Kai Novak110%
  • Ana Lopez90%
  • Mia Chen75%
  • Tom Becker70%
Hours by project
  • Atlas rollout61450%
  • Cedar integration37630%
  • Beacon pitch988%
  • Admin and meetings645%
  • Internal tools484%
  • Holiday403%

How to use it

  1. 1On the Capacity sheet, enter each person's role and weekly hours.
  2. 2On the Assignments sheet, add a row per person per project with planned hours for each week, and a Time off row for holidays.
  3. 3Read utilisation by week: over 100% means over-allocated, under 70% means spare time.
  4. 4Move hours between people or weeks until nobody is over 100%.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

A capacity plan for the next eight weeks. Record who is assigned to which project and for how many hours each week; the Capacity sheet adds everything up per person per week, compares it with their available hours (minus time off), shows utilisation for every week and flags the people and weeks that are over-allocated, so you can rebalance before anyone burns out or a project stalls.

Who it’s for

  • Agencies and consultancies staffing several projects
  • Team leads planning the next sprint or month
  • Spotting over-allocation early

What’s included

  • Assignments sheet: Planned hours for each person on each project, week by week.
  • Capacity sheet: Utilisation for each person in each week.

How to use it

  1. 1On the Capacity sheet, enter each person's role and weekly hours.
  2. 2On the Assignments sheet, add a row per person per project with planned hours for each week, and a Time off row for holidays.
  3. 3Read utilisation by week: over 100% means over-allocated, under 70% means spare time.
  4. 4Move hours between people or weeks until nobody is over 100%.

Tips

  • Plan people at about 80% of their hours; meetings and admin take the rest.
  • Re-plan every Monday and roll the eight weeks forward.
  • Put holidays in Time off so capacity is real.

Questions

How is utilisation worked out?

Hours assigned that week, including time off, divided by weekly hours.

Can I track more people?

Add them to the Person list on Assignments and a row on Capacity.

Related searchesresource planningresource allocationcapacity planningteam workloadutilisationstaffing plan

Details

Format
Spreadsheet
Category
Project Planning
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetProject PlanningFree

Team Resource Allocation

Plan hours by person, project and week for the next eight weeks, and see who is over or under capacity.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Project Planning
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More project planning templates

View all
Project Plan with Gantt Timeline
Task
W1W2W3W4W5W6W7W8W9W10
Kick-off and charter sign-off
Stakeholder interviews
Requirements document
Budget and resource plan
Plan approved
Wireframes
SpreadsheetProject Planning

Project Plan with Gantt Timeline

A real Gantt chart: tasks by phase with dates, owners, dependencies, progress bars across 16 weeks and schedule status.

10 min setupPreview
Project Tracker
Task
OctNov
Customer survey launched
Pricing page copy
Partner contract signed
Onboarding email sequence
Analytics dashboard
Sales training deck
SpreadsheetProject Planning

Project Tracker

Deliverables with owner, priority, dates, progress, health and a workload view by person.

10 min setupPreview
Work Breakdown Structure (WBS)2 sheets

Work packages

9

Total effort (hours)

386

Total cost

$42,040

ABCD
1WBS codeStageDeliverableWork package
21.11 DiscoveryRequirementsStakeholder interviews
31.21 DiscoveryRequirementsRequirements document and sign-off
42.12 DesignExperience designUser flows and wireframes
52.22 DesignVisual designDesign system and page designs
WBS
SpreadsheetProject Planning

Work Breakdown Structure (WBS)

Break a project into phases, deliverables and work packages with effort, cost and owner rolled up by phase.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ