A filled-in example: one evening, two crews
| Crew | Site | Start | End | Travel in | Gap from last job | Check |
|---|---|---|---|---|---|---|
| A: Luis, Nina | Harbor Dental, 14 Pier St | 17:30 | 19:00 | |||
| A: Luis, Nina | Kent and Ross Law, 220 Main St | 19:20 | 21:20 | 20 min | 20 min | OK |
| A: Luis, Nina | Maple Pediatrics, 9 Elm Ave | 21:30 | 23:30 | 15 min | 10 min | Gap shorter than travel |
| B: Ray, Jo | FitWorks gym, 55 Mill Rd | 18:00 | 20:30 | |||
| B: Ray, Jo | Northside Retail Unit 4 | 20:45 | 23:00 | 15 min | 15 min | OK |
| B: Ray, Jo | Cedar Office Park, Bldg 2 | 23:30 | 02:00 | 25 min | 30 min | OK |
Crew A's third job starts 10 minutes after the second ends, but the drive takes 15. The template flags it, so you can move the start to 21:35 or tell the client the crew will arrive a little later.
What each column does
- Date, crew and the people on it. List each person's name so their hours can be totalled.
- Site name and address, plus access notes such as alarm codes kept off the printout.
- Start and end. Jobs that end after midnight are counted correctly.
- Travel in: the planned minutes from the previous job. Gap from last job is calculated from the times.
- Check: flags a gap shorter than the travel time, or an overlap with the crew's previous job.
- A second tab totals hours per person for the week, including paid travel if you count it.
Building the week
- List every recurring job with its usual day, time window and crew size.
- Order each crew's jobs by location to keep the drives short.
- Set start times using the travel time, plus a few minutes to park and get in.
- Check each person's weekly total on the hours tab before you send the schedule.
- Send each crew their jobs with addresses. Keep alarm codes out of shared printouts.
For planning the drives themselves, read travel time between job sites. For clock-ins at each address, see GPS clock-in at multiple job sites.