← Home
Resourcing
Resourcing
Forecast
The hand-painted resourcing spreadsheet, replaced with a live view of who is on which job and when. Drag to allocate, see who is over-committed, and spot the week a project has nobody in a key role before it happens.
- Tool
- 005 / People & planning
- Role
- Designed + built
- Inputs
- People, roles, project dates
- Outputs
- Timeline, capacity, gaps
01 The timeline
Construction managerSite managerContracts administratorOver-committed
JanFebMarAprMayJun
▾ Project Alpha
Person A · construction mgr
Person B · site mgr
120%
Person C · contracts admin
▾ Project Bravo
Person D · construction mgr
Person B · site mgr
+ Add a person
drag to allocate
▾ Project Charlie Upcoming
Person E · construction mgr
Drag across a row to allocate · drag a bar’s edge to change dates · an overlap turns red and asks you to confirm it’s a deliberate handover
Illustrative sample data
02 What it does
Three views, one set of data.
- TimelineA project-by-project grid, coloured by role. Drag to allocate someone, drag an edge to resize, and filter by project, person, role or stage.
- CapacityA role-by-month heatmap of how committed people are. Click a cell to see exactly which allocations make up the figure.
- GapsA soonest-first list of weeks where a project has nobody covering a single-holder role. An empty list is good news.
- Roles and scopeAdmins and planners edit. Viewers read, and can be limited to particular projects. Finished projects are tucked away by default.
03 Capacity and gaps
Utilisation by role
| Role | Jan | Feb | Mar | Apr | May | Jun |
|---|---|---|---|---|---|---|
| Construction manager | 70% | 80% | 95% | 85% | 75% | 60% |
| Site manager | 85% | 90% | 120% | 85% | 65% | 50% |
| Contracts admin | 50% | 55% | 65% | 65% | 70% | 70% |
Gaps: key role uncovered
Project Charlie · no site managerFrom 14 Apr · 5 weeks
Project Bravo · no construction managerFrom 2 Jun · 11 weeks
Illustrative sample data
04 How it’s built
A planning tool people actually enjoy using, instead of a spreadsheet they dread.
- ServiceA Node.js and Express service with its own database, deployed to Railway.
- InterfaceA React front end on the shared component library, with drag-to-create and drag-to-resize built on the timeline itself.
- Checks as you workConflict detection runs while you drag, and a bar turns red the moment it would overlap another allocation for the same person.
- AccessRestricted to named people while it is built out, with Admin, Planner and Viewer roles, and viewers can be scoped to specific projects.
- Honest limitsData starts from when it was entered here. There is no historical import from the old spreadsheet.
StackNode.jsExpressReact 18Drag-and-drop UIRole-based accessRailwayGitHub