pool-service-ops

v1.0.0 MIT trades updated 2026-09-27

Price a weekly pool-service route from a customer CSV — monthly price per stop from a base fee, marginal per-gallon tier pricing, and extras like salt systems or spas, plus the total route value. Use when building or re-pricing recurring pool-cleaning routes.

$ skillbank install pool-service-ops@1.0.0
# pins exactly 1.0.0 · README + changelog included

Pool Service Ops

Overview

Pool routes live or die on per-stop math. A flat monthly fee for every customer quietly loses money on the 25,000-gallon pool with a salt system and leaves money on the table on the small ones. Pool Service Ops prices each stop from three honest inputs: a base fee, a marginal per-gallon tier (bigger pools cost more in chemicals and time, but with diminishing marginal cost), and named extras — so every customer pays for what their pool actually costs you to service.

Everything runs on your own machine. The script reads a CSV and prints prices — nothing is uploaded anywhere.

Installation

1. Copy the pool-service-ops/ directory anywhere convenient. 2. Make the script executable (Unix):


   chmod +x scripts/route.py

No pip install needed — standard library only.

Configuration

There is no config file. The price model lives in the script header so it is always visible next to the math, and the base fee is overridable per run:

| Input | Default | Meaning | |--------------|--------------|----------------------------------------------------------| | csv_file | — | Customer CSV: name, gallons, extras columns. | | --base | 120.00 | Base monthly fee per stop. |

Gallon tiers (marginal — only the gallons inside each band pay that rate):

| Gallons band | Rate per gallon | |---------------------|-----------------| | First 10,000 | $0.005 | | Next 10,000 | $0.004 | | Above 20,000 | $0.003 |

Extras (per month): salt = $25 (salt chlorine generator), spa = $20 (attached spa needing its own balancing), twice-weekly = $60. List extras separated by semicolons or commas; leave the column empty for none.

Inputs

| Command | Arguments | Returns | |------------|------------------------------|------------------------------------------------| | route.py | <customers.csv> [--base F] | Monthly price per stop + total route value. |

The CSV needs name and gallons columns; extras is optional. Header case is tolerated (Name, Gallons work). Bad rows — missing name, non-numeric or non-positive gallons, unknown extras — stop the run with a clear message naming the row, not a traceback.

Worked example

customers.csv (the exact file this output was tested against):


name,gallons,extras
Aguilar Residence,12000,salt
Thompson,8500,
Park Home,25000,salt;spa

$ ./scripts/route.py customers.csv
Aguilar Residence
  Gallons  12000 -> $58.00
  Extras   salt -> $25.00
  Monthly  $120.00 base + $58.00 gallons + $25.00 extras = $203.00
Thompson
  Gallons  8500 -> $42.50
  Extras   none -> $0.00
  Monthly  $120.00 base + $42.50 gallons + $0.00 extras = $162.50
Park Home
  Gallons  25000 -> $105.00
  Extras   salt, spa -> $45.00
  Monthly  $120.00 base + $105.00 gallons + $45.00 extras = $270.00
ROUTE TOTAL: $635.50/mo (3 stops)

Check Aguilar by hand: 10,000 gal × $0.005 = $50.00 plus 2,000 gal × $0.004 = $8.00 → $58.00 gallon charge; $120.00 + $58.00 + $25.00 salt = $203.00. Park Home: $50.00 + (10,000 × $0.004 = $40.00) + (5,000 × $0.003 = $15.00) = $105.00 gallon charge; $120.00 + $105.00 + $45.00 = $270.00.

Playbooks

Safety notes

This is a benign business tool. All customer data stays on your machine; the script makes no network calls and never uploads anything. Prices are yours to give — the calculator shows the arithmetic behind them.

Version history

Changelog

1.0.0 — 2026-09-27

  • Initial release: scripts/route.py prices a pool-service route from a
  • customer CSV (name,gallons,extras) — monthly price per stop from a $120 base, marginal per-gallon tiers ($0.005/$0.004/$0.003), and extras (salt $25, spa $20, twice-weekly $60) — plus the total route value.

  • references/chemical-log.md: weekly chemical log template.

← back to catalog