A filled-in example: one evening, two crews

Example jobs for Monday evening. Travel is the planned drive from the crew's previous job.
CrewSiteStartEndTravel inGap from last jobCheck
A: Luis, NinaHarbor Dental, 14 Pier St17:3019:00
A: Luis, NinaKent and Ross Law, 220 Main St19:2021:2020 min20 minOK
A: Luis, NinaMaple Pediatrics, 9 Elm Ave21:3023:3015 min10 minGap shorter than travel
B: Ray, JoFitWorks gym, 55 Mill Rd18:0020:30
B: Ray, JoNorthside Retail Unit 420:4523:0015 min15 minOK
B: Ray, JoCedar Office Park, Bldg 223:3002:0025 min30 minOK
Example jobs for Monday evening. Travel is the planned drive from the crew's previous job.

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

  1. List every recurring job with its usual day, time window and crew size.
  2. Order each crew's jobs by location to keep the drives short.
  3. Set start times using the travel time, plus a few minutes to park and get in.
  4. Check each person's weekly total on the hours tab before you send the schedule.
  5. 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.