Utilities must test their water on a legal schedule, and one missed test is a violation.
In 2023, 20 percent of US public water systems missed a required test or report, and 4 percent broke a health-based standard (EPA, 2023 National Public Water Systems Compliance Report).
Fixing a health violation can mean new equipment. Avoiding a missed test takes a schedule that tells the right person what is due.
The PNAS study (Allaire, Wu and Lall, 2018) covered 17,900 community water systems from 1982 to 2015 and found that health-based violations were more common in rural areas, and especially high in low-income rural areas. It counted health-based violations only, because monitoring and reporting data were too poor to compare.
81 percent of community water systems serve 3,300 people or fewer (Congressional Research Service, 2024).
One rule can mean 400 tasks a year.
Each task has one owner.
400sample tasks a year from one example rule
10 a month
80 a month
10 a month
One example rule from the state: 10 bacteria samples a month from October to May and 80 a month from June to September. That is 400 sample tasks in a year, each a dot on the chart.
Sampling Schedule
Click YearThe whole year, built from the rules.
Click AprilEach month opens as a calendar.
Click a taskSee its status, owner and due date.
Live
The rule, step by step
A state rule says what to sample, where and how often. Sample Manager turns it into a year of tasks, each with one owner.
01
The state's rule
What, where, how often.
02
Sampling period
One window of that rule.
03
Task
One sample, one owner, seven stages.
The example rule: 10 bacteria samples a month from October to May and 80 a month from June to September. That is 400 sample tasks in a year.
Try the whole rebuild.
atharvadnyanmote.com/sample-manager
Start with the daily briefCounted from today: 3 overdue, 2 due soon, 5 coming up.
Requirement windowsWhat opens next, from Mar 23 to Apr 1.
March progress60 of 200 samples collected. It needs 12 a day to finish.
The calendarArsenic Well Sample A3 has been overdue since March 4.
Click Review overdue tasksIt opens the task list, already filtered.
Click Arsenic Well Sample A3See its stage and due date.
Click View in scheduleThe same task, on the calendar.
It was the top gap in 9 sales demos. We probably would not be able to move forward without this step.UX research, on the PDF compare panel
Did
Staff upload the lab’s PDF and check what the system reads.
Still open
The upload isn’t built here. The success measures are only targets.
Count from today
AssumedTask counts follow the calendar month.
Calendar monthMonth endtoday
NowCount from today.
From today
Dashboard: Daily task brief
Pick a team memberIt recounts for that person, from today.
Live
Admins pick where done starts
AssumedDone means the state received the result.
DoneReceived
NowAdmins pick the done stage.
DoneSent to Lab
Settings: Task completion
Click ReceivedThe first version: done meant the state received the result.
Click Sent to LabAdmins pick the done stage. Finished work stops showing as overdue.
Live
Staff upload lab results
AssumedLabs send results by API or file upload.
NowStaff upload the PDF themselves.
Sampling Data
Click Import lab resultsStaff upload the lab’s PDF. The upload isn’t built here.
Click a resultSee its sample number, analyte and status.
Click ×Back to the list. Looking changes nothing.
Live
Targets, not results
18100+18 to 100+views in 30 days
40%self-serve uploads
0imports needing staff
99%accuracy on known formats
The targets, defined
Assumed: labs send results by API or file upload. Utilities get results in without waiting for a lab integration. The same principle as Predictive Modeling: the system suggests, a person decides.
Targets, not results: results page views per 30 days, from 18 to 100+; 40% of accounts on self-serve lab upload 90 days after launch; 0 lab imports needing staff 60 days after full launch; extraction accuracy on known formats 99%, and 95% on new formats.
Two layers of settings, and a check before every send.
Account rules, then personal choices
Settings: Notifications
Click the switchAn admin turns this reminder off for everyone.
It now reads Disabled by adminPeople can’t turn on what the admin turned off.
Click the switchOnly you unsubscribe. Everyone else keeps it.
Live
Every reminder checks its task before it sends
QueuedStill open?SentSkipped
Three reminder emails are queued. Before each one sends it checks whether its task is still open. Two are, so they send. One task was finished in the meantime, so that email is skipped.More on reminders
An admin sets what the account sends. Each person picks what they get, but can’t turn on what the admin turned off.
Seven days out means different things for monthly and annual samples.
Monthly sample7 days is about a quarter of the cycle
Annual sample7 days is about 2%
What I’d do differently.
A better design that doesn’t fit engineering’s schedule never ships.
Next timeAsk engineering how long each option takes to build.
With no agreed measure, I can’t say what the work saved.
Next timeWrite the success measure into the brief.
More on each
I pushed UX improvements hard and didn’t weigh how long each one would take engineering to build. Instead: ask engineering for the handoff cost of each option before I recommend one.
The facilities brief had no success measures. I proposed them only after the work shipped, so I can’t say whether those fixes saved anyone time. Instead: write the success measure into the brief before I design anything.
Live, and still changing.
On-time completion isn’t measured yet.
What we know so far
Live with 15 organizations in 18 states. The first facility fixes shipped in March and April 2026. We haven’t measured outcomes like on-time completion yet.
How I worked.
I worked from12 specs and requirementsa year of usage data9 sales demosUX research
These screens are my rebuild. 120Water owns the live product’s designs.
Who I worked with
Atharva Dnyanmote: UX Consultant, led UX 0-to-1.
Jon Ben-Haim: VP Product Strategy, product lead.
Julia Doyle: Product lead, email notifications.
Engineering leads by feature: Alecx Moritz and Dave Mason (email notifications), Ellie Leppert (sampling data) and David Sutton (lab result import).
Who made which call.
My call
Rule-based schedule,Count from today,Done stage,PDF upload,Email layers,Reminder check,Success measures
More calls, and why
My callBuild the schedule from each legal rule: rule, then sampling period, then task. One rule can mean 400 tasks a year.
My callCount tasks from today, not by calendar month. Month-based counts were confusing and wrong in real use.
My callLet admins choose the stage where a task counts as done. Finished work kept showing as overdue.
My callLet staff upload the lab’s PDF and check each value side by side. Manual lab import was the top gap in 9 sales demos.
My callTwo layers of email settings: the account’s rules, then personal choices. Admins decide what the account sends. People tune what they get.
My callEvery reminder re-checks its task before it sends. A reminder about finished work teaches people to ignore reminders.
My callPropose success measures for the facilities work, which had none. Searches and round trips show whether a page saves time.