Labor Crews
Drag a row to reorder; priority is the order (1 = first). Click any cell to edit.
New crew
New crews get the last position; reorder in the table to change priority.
| Priority | Labor | Cleaning | Windows | Quality Control | Crew | Hours |
|---|
Subdivisions
Drag the handle to change route order (1 = first). Click any cell to edit.
New subdivision
| Route order | Builder | Subdivision | Address | Lat | Lon |
|---|
Task Types
Click any cell to edit (Enter to save, Escape to cancel).
New task type
| Type | Builder | Floor Plan | Task | Abbreviation | Hours |
|---|
Floor Plans
Click any cell to edit (Enter to save, Escape to cancel).
New floor plan
| Builder | Subdivision | Lot | Floor Plan | Original | Reclean | Windows |
|---|
Labor Jobs
Import from Excel: Builder, Subdivision, Lot, Task (required). Optional: AM Job (Yes), Notes. When Task is "Other", optional Hours column is used; otherwise hours come from the task type. Subdivision must exist in Subdivisions.
New labor job
Select builder, subdivision, and lot from Floor Plans. Add floor plans first if lists are empty.
| Builder | Subdivision | Lot | Task | Hours | AM Job | Notes |
|---|
Cleaning Jobs
Builder, Subdivision, and Lot come from Floor Plans. Hours come from the floor plan (Original, Reclean, or Windows) based on the task. Import from Excel: Builder, Subdivision, Lot, Task (required). Optional: Floor Plan, AM Job (Yes), Notes.
New cleaning job
Select builder, subdivision, and lot from Floor Plans, then choose task. Hours come from the floor plan.
| Builder | Subdivision | Lot | Task | Floor Plan | Hours | AM Job | Notes |
|---|
Labor Schedule
Assigns labor jobs to crews by priority, batching by subdivision to minimize travel. Jobs are filled until crew hours are used.
Cleaning Schedule
Assigns cleaning and window jobs to crews. Only crews with Cleaning=Yes or Windows=Yes are included. Jobs are filled until crew hours are used.
Labor Route Debug — Sorted Routes
Sorted labor jobs by route order (before assignment loop). Route order → highest hours first → lot. Same order used when scheduling.
Cleaning Route Debug — Sorted Routes
Sorted cleaning/window jobs by route order (before assignment loop). Route order → highest hours first → lot. Same order used when scheduling.