pest-control-ops
Value a pest control route from a recurring-customer CSV — feed in customer, plan, per-visit price, and visits per year, and get each customer's annual value plus the total monthly route value. Comes with a treatment log template. Use when buying, selling, or splitting a service route, or tracking recurring revenue.
$ skillbank install pest-control-ops@1.0.0 # pins exactly 1.0.0 · README + changelog included
Pest Control Ops
Overview
A route's worth is its recurring revenue, not its customer count. Pest Control Ops reads a CSV of your recurring customers — name, plan, per-visit price, visits per year — and prints each customer's annual value (price x visits) plus the total monthly route value (annual total / 12). That's the number that matters when you buy a route, sell one, split a tech's day, or check whether your recurring book is growing.
Everything runs on your own machine. The script reads your CSV and prints the valuation — nothing is uploaded anywhere.
Installation
1. Copy the pest-control-ops/ directory anywhere convenient. 2. Make the script executable (Unix):
chmod +x scripts/route.py
No pip install needed — standard library only.
Configuration
The only input is your customer CSV. Header row required, exactly these column names:
customer,plan,per_visit_price,visits_per_year
Maria Alvarez,quarterly-spray,89,4
Oak Street Deli,monthly-bait,120,12
Pinecrest Apartments,biweekly-common,150,26
customer— name or account label.plan— your plan name (free text; used for display only).per_visit_price— dollars per visit.visits_per_year— whole number of scheduled visits per year.
Annual value per customer = per_visit_price x visits_per_year. Total monthly route value = sum of annual values / 12.
Inputs
| Input | Required | Description | |--------|----------|----------------------------------------------------------| | csv | yes | Recurring-service customer CSV (columns above). |
Worked example
$ ./scripts/route.py customers.csv
CUSTOMER PLAN PRICE VISITS ANNUAL
-------------------------------------------------------------------
Maria Alvarez quarterly-spray $ 89.00 4 $ 356.00
Oak Street Deli monthly-bait $ 120.00 12 $ 1440.00
Pinecrest Apartments biweekly-common $ 150.00 26 $ 3900.00
Sam Whitfield one-time-flea $ 175.00 1 $ 175.00
-------------------------------------------------------------------
4 customers on route
Total annual route value: $5,871.00
Total MONTHLY route value: $489.25
Playbooks
- Treatment log — a per-visit log template
- Route-building playbook — growing monthly
(date, customer, products, dosage, notes) plus what to record for label compliance.
route value: plan tiers, when to upsell quarterly to monthly, and the customer math to check before buying a route.
Safety notes
This is a benign business tool. Pesticide application is regulated — follow product labels and your state licensing rules; the treatment log records what you did, it does not tell you what to apply. Customer data stays on your machine; the script makes no network calls and never uploads anything.
Version history
Changelog
1.0.0 — 2026-09-27
- Initial release:
scripts/route.pyroute valuation (recurring-service - Playbooks: treatment log template and route-building playbook.
CSV → per-customer annual value + total monthly route value).