10T Studios
← All articles

Blog

Planning jobs and shifts for field crews without a spreadsheet

6 min read

Photo: Semen Machin / Unsplash

Short answer

A planner replaces the spreadsheet when it can answer, by itself, the three questions you now put to the dispatcher: who is free that day, who is allowed and able to do the job, and can they make it after the previous one. A spreadsheet answers none of them; whoever maintains it keeps it all in their head. If one person plans for three people and jobs rarely move, the spreadsheet is still enough.

01What a planner has to handle

A schedule is just a table until it can tell you something will not work. A planner earns its place by warning you before the mistake reaches the customer.

  • 01Availability: holidays, sick leave, part-time hours and days someone works elsewhere. A plan with a person who is on holiday that day must not pass without a warning.
  • 02Conflicts: one person in two places, but also one van, scaffold or machine needed by two crews at once.
  • 03Qualifications: who holds the inspection certificate, who may work at height, who can operate that machine. This is what a spreadsheet loses most often.
  • 04Travel time between jobs: if the first job is in Bratislava and the second in Trnava, there has to be room for the drive between them.
  • 05Job length: an estimate that improves as real jobs come in, not a window typed in by eye.
  • 06Changes during the day: when a job overruns or a customer cancels, the change has to reach the people in the field, not just the office.

02Travel time: what is enough and what is overkill

For most companies it is enough that the system calculates drive time from map data for each pair of consecutive addresses and warns when there is not enough room between jobs. That is about one integration with a mapping service, not a project of its own.

Automatic route optimisation is a different league. For a crew of five to fifteen people a dispatcher with a map often beats an algorithm, because the dispatcher knows what is not in the data: the customer is not home at two, that street is dug up all day. A planner should suggest and warn; a person decides.

03How the people in the field see the plan

A plan only the office can see solves half the problem. Each person has their own day on their phone: where, when, what, the customer's contact and the notes. A change arrives as a notification and they confirm they have seen it.

The confirmation is not surveillance. It answers “does Peter know he starts somewhere else tomorrow?”, which today is settled by a phone call at six in the morning.

04When a sheet or a calendar is still enough

When one person plans, the group is small, jobs seldom move and nobody else needs to see the plan. A shared calendar with a colour per person does more than companies tend to think.

The line is usually where two questions arrive at once: “who is free and able to do it?” and “will they make it?”. At that point the system has to evaluate them for you. If you are starting planning from nothing, note that a job sheet filled in on site often pays back sooner than scheduling — the article on systems for service and installation work covers that.

Frequently asked

How do you plan field staff without Excel?
With a planner that knows people's availability, their qualifications and the travel time between jobs, and warns about a conflict before it happens. Everyone sees their own day on their phone.
Should a planner assign jobs automatically?
For smaller crews, usually not. It should suggest and warn, and the dispatcher decides, because the dispatcher knows things that are not in the data.
When is a shared calendar enough?
When one person plans, the group is small, jobs rarely move and nobody needs to check qualifications or travel time.

Related

More articles