A field service scheduling spreadsheet stops working when the person booking can no longer see, in their head, where every truck will be at every hour. For most companies that happens somewhere between the fifth and sixth truck, and the first symptom is drive time, not double-booking.
Nobody should feel bad about running the board in a spreadsheet. It is free, everyone knows how to use it, and for a two- or three-truck company it is often the right tool. The problem is that a spreadsheet records what you booked. It never checks whether what you booked can happen.
What a spreadsheet actually does
A scheduling sheet is a grid: technicians across the top, times down the side, a customer name in each cell. That grid answers one question well: is this tech free at 10:00?
It does not answer the question that matters more: can this tech get to this address by 10:00, given where they will be at 9:30? In a spreadsheet the 9:00 job in the north end and the 10:00 job in the south end look exactly as compatible as two jobs on the same street. The cell is empty, so the slot is offered.
With two trucks, the person booking holds the map in their head and covers for the grid. They know Mike is out by the lake all morning. As the team grows, the map in the head stops keeping up, and the grid starts making the decisions.
The signs you have outgrown it
These show up in roughly this order.
1. Afternoon lateness that the morning doesn't explain. First jobs start on time. By the third stop techs are 20 to 40 minutes behind. That is drive time the sheet never counted, piling up job by job. The arithmetic behind it is in arrival window math.
2. Trucks crossing their own path. Plot one tech's day on a map in job order. If the line zig-zags, the jobs were booked in the order the phone rang, not in an order a truck can drive. That pattern is called backtracking.
3. Two people booking from two copies. The office books from the shared sheet, the owner books from his phone, and someone reconciles at 7 a.m. Every reconciliation is a chance for a double-booking or a lost job.
4. The sheet has a second tab nobody trusts. Status, ETAs, parts and notes live in texts and a whiteboard, because the sheet can't hold them. The schedule is now in three places.
5. You can't answer "how did we do last week." On-time rate, jobs per truck per day and drive share all need timestamps the sheet never captured.
If you see two or more of these, the spreadsheet is no longer the cheap option. It is costing you drive time and late arrivals that you don't see on any invoice.
What it costs, in your numbers
The cost of a sheet that can't see the drive shows up as extra drive minutes per truck per day.
These are made-up inputs. Put in your own. The windshield time post shows how to measure M from a week of your own records, and the cost is only the labor. It leaves out the job that didn't fit at 3 p.m. because the day was already used up driving.
Fixing the spreadsheet first
If you are not ready to switch, you can make the sheet better. This layout is the Excel or Google Sheets template we would use:
| Column | What goes in it | Why |
|---|---|---|
| Tech | One row per job, tech name | Filters a day per tech |
| Date, start, planned minutes | Booked start and expected duration | Lets you compute end time |
| Area | A zone name or ZIP | Makes cross-town jumps visible |
| Drive from previous (min) | Your best estimate | Forces the question before you book |
| Planned end | Start + planned minutes | Shows if the next job is reachable |
| Arrived, done | Typed in from the tech's texts | The data for on-time rate later |
Two rules make it work. Sort each tech's day by start time and read down the Area column before you book a new job. And never book a slot where the previous job's planned end plus the drive lands after the new start. That one check catches most of the bad bookings.
This helps. It does not scale, because every check is a person doing it by hand, on every call, while the customer waits.
What to look for when you switch
A replacement worth paying for does what you were doing by hand in the Drive column, automatically, at the moment of booking. When you compare tools, ask:
- When is travel checked? At booking, before a slot is offered, or later when someone runs routing? Those are different mechanisms, explained in route optimization vs feasible scheduling.
- From where? From the shop, or from where the truck will actually be: the previous job.
- Can the office and the trucks see one board? A scheduling board is only useful if every booking lands on it.
- Does it capture arrived and done? Without those timestamps you can't measure anything.
CrewLink, in early access, is built around the first two: a booking page offers only start times a qualified tech can actually make, counting their other jobs and the drive at that hour from the previous job. If you want the buyer's version of this checklist, read dispatch software for small business and the field service scheduling software page.
What to take away
- A spreadsheet records bookings. It never checks whether a truck can reach them.
- The first sign you've outgrown it is afternoon lateness and zig-zag days, usually around truck five or six.
- Add a drive and planned-end column now; the check "previous end plus drive before new start" catches most bad bookings.
- When you switch, ask when travel is checked and from where.
Common questions
Is there a free Excel technician schedule template?
The table above is one. Rows per job, with columns for tech, date, start, planned minutes, area, drive from the previous job, planned end, arrived and done. The drive and planned-end columns are the ones most templates leave out, and they matter most.
How many trucks can a spreadsheet handle?
There is no fixed number, but most companies feel it between five and six trucks, or earlier if more than one person books. The limit is how many trucks one person can hold on a mental map, not the sheet.
Can Google Sheets calculate drive time?
Not on its own. You can type estimates into a column, which is far better than nothing. Live drive time at the hour of the job needs a mapping service, which is what scheduling software adds.
Should I switch to an all-in-one platform or a scheduling tool?
It depends on what is breaking. If quoting, invoicing and CRM are fine and the schedule is the bottleneck, a scheduling-first tool fixes the actual problem. If everything is in spreadsheets, an all-in-one suite may be the better first step.