Workflow · People · Opening soon
Resource capacity by week
Compare booked project hours to weekly availability by week. See who is over or under capacity for each team member.
Someone typed
“compare each team member's booked project hours to their available hours by week and show who is over or under capacity”
The agent read it as
Compare each team member's booked project hours in Booked project hours to their available hours in Weekly availability by week and show who is over or under capacity, using Team members for their names.
What the agent built
6 steps, each one an ordinary Mammoth step you can open and change.
File
Weekly availability
CSV export · 40 rows
File
Booked project hours
CSV export · 40 rows
File
Team members
CSV export · 8 rows
Step
Make availability employee key
Step 1
Step
Make booked employee key
Step 2
Step
Make member employee key
Step 3
Join
Bring in booked hours
40 of 40 paired
Join
Bring in team member names
40 of 40 paired
Step
Show weekly capacity
Step 6
Result
Weekly Capacity Check
40 rows
Schedule
Runs when you say
Proposed
- FileWeekly availabilityCSV export · 40 rows
- FileBooked project hoursCSV export · 40 rows
- FileTeam membersCSV export · 8 rows
- StepMake availability employee keyStep 1
- StepMake booked employee keyStep 2
- StepMake member employee keyStep 3
- JoinBring in booked hours40 of 40 paired
- JoinBring in team member names40 of 40 paired
- StepShow weekly capacityStep 6
- ResultWeekly Capacity Check40 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 40 rows came out, and the join paired 40 of 40 rows; the join paired 40 of 40 rows.
- Download Weekly availability sample (40 rows)Excel workbook: Capacity sheet > filter dates to last 5 weeks > export selected rows
- Download Booked project hours sample (40 rows)Excel workbook: Bookings sheet > export rows for the last 5 weeks
- Download Team members sample (8 rows)Excel workbook: Team Members sheet > select used range > copy to CSV
What you get back
The result of that run, the rows to look at first.
Weekly Capacity CheckSample data40 rows
| Team member | Week | Capacity status | Booked hours | Available hours | Capacity difference |
|---|---|---|---|---|---|
| Ben Torres | 2026-10-19 | Over capacity | 42 | 40 | 2 |
| Ben Torres | 2026-10-26 | Over capacity | 41 | 40 | 1 |
| Darius Cole | 2026-11-02 | Over capacity | 41 | 40 | 1 |
| Felix Morgan | 2026-10-12 | Over capacity | 41 | 40 | 1 |
| Felix Morgan | 2026-10-26 | Over capacity | 44 | 40 | 4 |
| Felix Morgan | 2026-11-09 | Over capacity | 42 | 40 | 2 |
| Mina Park | 2026-11-02 | Over capacity | 46 | 40 | 6 |
| Ava Patel | 2026-10-12 | Under capacity | 36 | 40 | -4 |
| Ava Patel | 2026-10-26 | Under capacity | 37 | 40 | -3 |
| Ava Patel | 2026-11-02 | Under capacity | 38 | 40 | -2 |
| Ava Patel | 2026-11-09 | Under capacity | 35 | 40 | -5 |
| Ben Torres | 2026-10-12 | Under capacity | 39 | 40 | -1 |
How do you compare booked hours to weekly capacity by week?
Export your Excel data for booked project hours, weekly availability, and team members. Mammoth matches each person, compares booked hours to available hours by week, and shows whether they are over or under capacity.
How it works
How to use the Weekly Capacity Check workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Weekly Capacity Check: questions
What export should you use?
Use exported Excel files that include booked project hours, weekly availability, and team member names. Each file should have a column that identifies the person and a column for the week.
What happens to rows that do not match?
Rows that cannot be matched to a person or a week do not appear in the final capacity view. You can fix the exported data and run the workflow again.
How do you change the rules?
Change the steps in words, such as which column is used for the employee key or which hours field is used for capacity. You can also add, remove, or rename steps to change how the weekly capacity view is built.
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Match payroll to time sheets, track headcount and hiring, and see what changed since last month.
- Salary bands compa-ratioExport employees from BambooHR, pair them with salary bands, and work out each employee's compa-ratio against the band midpoint.See the workflow Built by the agent
- On-time shipping rateCalculate on-time delivery rate from a ShipStation shipments export, grouped by carrier and week.See the workflow Built by the agent
- PTO balance reportShow each employee’s PTO accrued, taken, carryover, and remaining balance this year from BambooHR exports.See the workflow Built by the agent
- Billable utilization by employeeCalculate each employee's utilization rate by month from exported Harvest time entries and capacity files.See the workflow Built by the agent
- Employee turnover rateCalculate monthly employee turnover rate by department from a BambooHR employee export, with turnover, cleaned department names, and a status check.See the workflow Built by the agent
- Headcount reportBuild a monthly headcount report from a BambooHR employees export, grouped by department and location, with hires and leavers.See the workflow Built by the agent