Gantt Chart & Milestone Planner
Weekly timeline bars with progress shading, milestones, late flags and phase progress.
See what is insideEXCELCRAFT PRO TEMPLATE
Resource planner
for team capacity.
Who is overbooked next month? Assign people to work with hours per week, and the planner shows everyone's load for the next 12 weeks against their capacity, in red where it does not fit.
Planned pricing: $8 a month or $60 a year. No payment is taken today.
ExcelCraft / Project Timeline & Resource PlannerFictional sample
- 12-week load grid
- Capacity per person
- Over-allocation flags
INSIDE THE WORKBOOK
Every sheet
has one job.
Mint cells are where you type. White cells calculate. Instructions inside the file explain each field.
- Dashboard
- Capacity and assigned hours for the next four weeks, utilization and overloaded weeks, with assigned vs capacity by week and load by person.
- Load
- Hours per person per week for 12 weeks, coloured green, amber or red against capacity, with team totals and utilization.
- Assignments
- Each piece of work: person, project, task, start, end and hours per week.
- People · Settings · Checks
- People with weekly capacity, plan start and warning level; checks for unknown people and missing dates.
WHY IT HELPS
Built around
the real task.
Weekly hours per person against capacity, with over-allocation flagged in red.
Capacity, not just availability
Set the hours each person can really give to project work. Load compares assignments with that, not a theoretical 40 hours.
Twelve weeks on one screen
The load grid shows every person across 12 weeks, so you can see a crunch forming before it lands.
Spot the fix
Amber at your warning level, red above capacity. Move dates or reassign work until the red clears.
GETTING STARTED
Three steps
to your own version.
The sample shows a working example; the blank version keeps every formula ready for your records.
Add people
List the team with roles and weekly hours available for project work.
Assign work
Add assignments with dates and hours per week.
Balance the load
Check Load and the Dashboard. Move the plan start forward each Monday.
QUESTIONS
Before you begin.
Short answers about how the workbook behaves.
How are hours counted?
An assignment adds its hours per week to every week it overlaps, from the start week to the end week.
Can one person work on several projects?
Yes. Add an assignment per project; their load is the total.
How many people does it handle?
The load grid shows 20 people; the assignment list holds 500 rows.
Does it track actual hours?
It plans. Use the Weekly Timesheet or the Project Tracker for actual hours.
How do I keep my changes?
Use Download XLSX or PDF in the editor before closing the tab. Nothing is saved to a server automatically, and your workbook never leaves your device while you edit.
Will it work in Excel and Google Sheets?
The files use standard XLSX formulas without macros, pivot tables or external links. They are checked with the ExcelCraft engine; compatibility with every Excel or Google Sheets version is not guaranteed. Review formulas, charts and formatting in your app before relying on important figures.
Can I change the currency?
Amounts use a $ number format. Change the cell format to your currency; the formulas do not convert between currencies.
EXCELCRAFT PRO · EARLY ACCESS
Part of
ExcelCraft Pro.
Pro workbooks cover whole workflows: purchasing to receiving, journal to balance sheet, tasks to portfolio health. Pro is planned to include AI credits for editing through chat. Pro downloads and the AI assistant are not available yet.
- Every Pro workbook as it is released, with dashboards, checks and instructions
- Planned: monthly AI credits for editing spreadsheets through chat
- Planned launch pricing; final terms are not set
$8/ month
or $60 / year · planned launch price
No payment today. We email you once when Pro opens.
How Pro worksRELATED
Works well with.
Separate workbooks for neighbouring jobs. Records do not sync between files.
Project Tracker & Status Dashboard
Projects, tasks, risks and a portfolio dashboard with automatic health status.
See what is inside
Employee Shift Schedule
Weekly rota with hours, labor cost and coverage against staffing needs.
See what is insideYour workbook stays in this browser while you edit. Use Download in the editor to keep your work, and review important figures in the saved copy. How local files are handled.
Original ExcelCraft workbook design, formulas and fictional sample data · CC0. Management tool only; not tax, legal or accounting advice.