Crew Workload Balancer
See how the week's hours land across your crews, and which clients are worth moving to even them out.
Files stay on this computer. Close the tab and they're gone.
Which services count
Recurring route work only. Leave as-needed jobs off so they don't distort the picture.
Statuses to include
Crew yards and crew sizes
Every crew starts and ends at its yard. Untick a crew that isn't running this week and the remaining crews pick up its clients. Tulsa-area and OKC-area crews are kept separate — no client ever moves between metros.
| Crew | Working this week |
Yard address | People | Area |
|---|
Address accuracy
Even out the week
Every crew member should end up with about the same hours. A one-person crew gets roughly a third of what a three-person crew gets. The tool moves clients to the closest crew that has room, and tells you which ones are worth leaving alone.
Optimise for balance, or keep faces the same?
How many crews and people does this work need?
Redraws the territories from scratch by geography and works out the smallest crew count that keeps everyone busy without passing your hours cap. Use it at the start of a season to decide how many people to bring on.
Your trucks
Seats is the hard limit for that truck. How many people actually ride is solved for you. Set a truck to keep its clients and it holds the list it already has.
| Truck | Use this truck? | Seats | Existing clients |
|---|
Trucks committed per area
Commit an area to a fixed number of trucks and all of its work is spread across exactly those trucks. Leave an area flexible and it takes as few trucks as the work needs, out of whatever the committed areas didn't use.
| Area | Trucks | Clients in the file |
|---|