How to Schedule Recurring Inspections Across 100+ Locations

Jure Špeh, Co-founder and CTO

4/16/2026

Manual scheduling breaks down quickly and becomes opaque once the inspection count climbs. Here's what changes when 100+ recurring inspections move from spreadsheets to automated periodic work orders, based on practice at three real water utilities.

30-second summary

Manual scheduling breaks somewhere around 50 locations. By 100+, your spreadsheet is doing more harm than good. The fix isn’t a bigger spreadsheet. It’s automated periodic work orders.

The hidden cost of planning hundreds of inspections by hand

If you run a water utility with 100+ locations (often called facilities or objects — reservoirs, pumping stations, treatment plants, and so on), you already know this pain. If you plan weekly, every Monday morning someone sits down with a spreadsheet, a calendar, and a coffee. Two hours later, the routes are planned for the week. If you’re lucky, the paper comes back at the end of each day with the data on it. If you’re not, the paper is dirty, crumpled, or lost. Then someone retypes it, which costs another few hours.

That’s the visible cost. The invisible cost is bigger.

A reservoir that was supposed to be checked monthly slipped to every six weeks.
A control point hasn’t had a sample since the spreadsheet got copy-pasted.
Data from a critical pumping station was entered under a different reservoir.
The person who knew the route by heart is on vacation.

You don’t see those gaps until the inspector asks for them.

Why spreadsheets break at 50 locations

Spreadsheets are fine for 5 sites, manageable at 25, and a liability at 100. Three reasons:

Intervals get out of sync. Some inspections are weekly or bi-weekly, some monthly, some quarterly. Mixing them in one sheet means manual recalculation every time anything shifts.

Exceptions don’t propagate. Holidays, sick days, broken vehicles, frozen access roads. Each exception forces you to rewrite the next two weeks by hand.

There’s no audit trail. When an inspector asks “did you actually do the round on July 14,” the answer lives in someone’s memory. You have to trust the number written on paper.

What automated periodic scheduling has to do

Three water utilities we’ve worked with run this pattern: 130+ sites at Kanal ob Soči, 200+ at Hydrovod, 300+ at Komunala Črnomelj. The same four requirements come up every time:

Set an interval, get a schedule with work orders. Daily, weekly, monthly, quarterly, annual. The system generates the work orders without anyone retyping the dates.
Handle exceptions without breaking the schedule. Skip a holiday, postpone an inspection, reassign a route. The next round still happens on the right cycle.
Reassign on the fly. When a worker is sick, the round goes to another worker, not to next week’s queue.
Audit trail built into the system. Every scheduled, completed, skipped, and reassigned work order is logged. The inspector gets the report in seconds, not minutes.

Miss any of these and you’re back to a spreadsheet with extra steps.

What Kanal ob Soči actually replaced

Before TagPlan, the team at Kanal manually planned hundreds of routine inspections across 130+ locations. Reservoirs, water plants, pumping stations, treatment plants, sewage pumping stations. All scheduled by hand.

After:

“Periodic work order planning tremendously simplifies the planning of regular rounds with a large number of facilities.”

— Jakob Merljak, Municipality of Kanal ob Soči

The team didn’t switch software because they wanted a fancier interface. They switched because the manual planning had become a job in itself. Service quality fluctuated. Regular data wasn’t there. Real analysis wasn’t possible.

The ROI nobody puts on the slide

Komunala Črnomelj quantified it more bluntly: up to 99% of the time previously spent on planning, reporting, and analysis. That’s their number, so take it with a grain of salt. The direction is consistent across every utility we’ve seen:

Coordination time between field and office: 30 minutes daily → effectively zero.
Mandatory report prep: 8+ hours saved monthly.
Inspection data retrieval: 15 minutes → 5 seconds.

Minutes saved per task add up. What those minutes free up matters more. Field supervisors who used to plan all morning can now walk the field, or take an urgent call when one comes in.

A practical playbook

If you’re sitting on a spreadsheet with 50+ rows, three steps in order:

Inventory your intervals. List every inspection type and how often it runs. Most utilities discover they have 6 to 10 distinct intervals, not 50.
Pilot one team for a month. Pick the most complex route. If automated scheduling holds up there, it holds up everywhere.
Audit the audit trail. Run a mock inspection in week two. Can you produce a full year of records for one site in under 30 seconds? If not, the system isn’t there yet.

What to expect after the switch

In every utility that’s made this switch, the same pattern shows up within the first quarter:

The wastewater team asks to be included after water supply rolls out (Kanal).
Workers start proposing new periodic checks the manager hadn’t planned (Hydrovod).
The supervisor stops doing route planning on Sunday nights.
Vacations stop being stressful, because anyone on the team can export an inspection report.

Scheduling stops being a job. It becomes a default.