Project Plan Template for Resource Allocation — Google Sheets

Free project plan template for Google Sheets. Allocate team resources, track capacity, budgets, and attach SOWs and timesheets to every assignment.

What's in this template

• Project Name — Name of the project or engagement this resource is assigned to
• Assigned To — Team member assigned to this project
• Role — The role this person fills on the project
• Allocation % — Percentage of this person's weekly capacity allocated to this project (0-100)
• Weekly Rate — Loaded weekly cost for this resource at their allocation level
• Start Date — Date this resource's assignment begins
• End Date — Date this resource's assignment ends
• Status — Current status of this resource assignment
• SOW or Contract — Statement of work, staffing agreement, or contractor contract PDF or DOCX for this assignment
• Timesheet or Report — Weekly timesheet, utilization report, or status update PDF or XLSX

This free Google Sheets template is built to work with FileFox, the drag-and-drop file management add-on for Google Sheets. Attach contracts, photos, invoices, and any other files directly to rows — every file stays in your own Google Drive. Download the template free and install FileFox from the Google Workspace Marketplace to add file-upload columns.