LinewardenYour lead service line inventory, checked before November 2027.
Drop your service line spreadsheet. Linewarden classifies every line with EPA's rules, flags what your State will question and writes the customer letters. Nothing is uploaded.
Drop the spreadsheet you keep your service lines in: EPA's template or any export from billing, GIS or work orders. Linewarden classifies every line with EPA's split-ownership rules, flags the rows your State will question, counts your replacement pool and the 10% pace, and writes the customer letters and the public inventory. Your customer data never leaves your computer.
From $594 founding price$990 a year per water system · one payment · card or purchasing card
Founding price $594 instead of $990 a year: FOUNDING40 is applied automatically at checkout until 30 Nov 2026.
- Runs 100% in your browser
- EPA template or any export
- 8/8 of EPA's worked examples
- Connectors counted (new in LCRI)
- Letters with the required health text
- $990/yr per water system
- Customer data stays on your PCNothing is uploaded. Load the app, switch off Wi-Fi, run it.
- Paddle is the sellerPaddle.com is merchant of record: invoice, tax, receipts.
- 14-day refundFull refund if it does not work for your inventory.
- Support by emailsupport@atesensoftware.com, same business day.
- Built on the rule text40 CFR 141.84 and 141.85(e), cited in every download.
Why now
One year to a baseline inventory that includes connectors, a replacement plan and a letter to every affected address.
The Lead and Copper Rule Improvements require every community and non-transient non-community water system to submit a baseline inventory of all service lines and connectors and a service line replacement plan by 1 November 2027, to notify every customer served by a lead, galvanized requiring replacement or lead status unknown line within 30 days, and to replace lead and GRR lines at an average of at least 10% a year.
LCRR initial inventory due: the spreadsheet most systems now keep.
EPA publishes the LCRI (89 FR 86418); in effect since 30 Dec 2024.
Baseline inventory with connectors, replacement plan, public inventory.
Letters to every lead, GRR and unknown address; again after each annual update.
10% a year on average, assessed after program year 3; all replaced by 1 Nov 2037.
Sources: 40 CFR 141.80(a)(3), 141.84(a)–(d) and 141.85(e), text in force on 1 October 2026 (eCFR, read 30 October 2026); Federal Register 2024-23549.
How it works
Three steps. No upload, no install, no project.
Drop your inventory
EPA's Service Line Inventory Template is read by position. Any other CSV or Excel export, from billing, GIS or work orders, is matched by column name and you confirm the columns. Add last year's file to get the annual update.
Set your system
Name, PWSID, number of connections, who owns which part of the line and your lead ban year. Optionally let installation dates after the ban, or diameters over 2 inches, rule out lead where your State accepts those methods.
Fix, file and mail
Fix the rows marked Fix, review the ones marked Check, then download the workbook in EPA's Detailed Inventory columns, the public inventory page, the letters and mailing list, and the replacement numbers for your plan. If your State has its own workbook, copy the columns across (the exception list points to rows in your own file), or send us the form and we add the layout.
What it checks
The rules that are easy to get wrong in a spreadsheet, applied to every line.
- Entire-line classification: system and customer sides combined with EPA's split-ownership table: any lead portion makes the line Lead; galvanized after a line that is or may have been lead is GRR; unknown plus non-lead stays Unknown.
- Galvanized requiring replacement: a galvanized customer side counts as GRR unless your records show the system side was never lead. Linewarden says which lines are GRR only because that evidence is missing.
- Connectors: lead goosenecks and pigtails are new in the LCRI baseline. Every line gets Lead, Non-Lead, Unknown or No connector present, and the unknowns are counted.
- Evidence: non-lead without a recorded basis or verification, field verification without a method or date, and a "lead ban" basis on a line installed before the ban.
- Data that will be questioned: no address or location, duplicate IDs, materials it cannot read, "PB" (lead or polybutylene?), and replacement dates on lines still recorded as lead.
- Unknowns you can resolve: unknown lines installed after your ban year or wider than 2 inches, listed as candidates for the methods your State accepts.
- Replacement pool and pace: the pool from the baseline, at least 10% a year, the 39-per-1,000-connections test for a deferred deadline, and the program years to 2037.
- What it cannot know: what is in the ground. Classifications are only as good as your records; Linewarden shows where they are weak.
What you get
Real output from the made-up Example Valley sample.
1,761 service lines: 229 lead, 176 galvanized requiring replacement, 284 lead status unknown, 1,072 non-lead; 196 lead connectors; a replacement pool of 689 (at least 69 a year); 18 rows to fix. Against last year's file: 25 replaced and a pool change of -34. Computed by the same engine the app uses.
| ID | System side | Customer side | Classification | Connector | Found |
|---|---|---|---|---|---|
| EV-00151 | Lead | Unknown - Material Unknown | Lead | Lead | "PB": lead or plastic? |
| EV-00021 | Lead | Lead | Lead | Unknown | Replacement date, still lead |
| EV-00005 | Non-Lead - Copper | Galvanized | Galvanized requiring replacement | Non-Lead | GRR: no record the system side was never lead |
| EV-00211 | Non-Lead - Copper | Non-Lead - Copper | Non-lead | Unknown | No basis recorded |
| EV-00031 | Unknown - Likely Lead | Unknown - Material Unknown | Lead status unknown | Unknown | File said Non-lead |
| EV-00402 | Unknown - Material Unknown | Unknown - Material Unknown | Lead status unknown | Lead | Over 2 inches |
| EV-00041 | Unknown - Likely Lead | Unknown - Material Unknown | Lead status unknown | Unknown | No location |
Compared
The checking, counting and letters, without a platform contract.
| Linewarden | Inventory platforms | Field data apps | Spreadsheet + EPA template | |
|---|---|---|---|---|
| Where customer data goes | Nowhere: checked in your browser | The vendor's cloud | The vendor's cloud | Stays on your PC |
| Entire-line rule and GRR | Applied to every line, with the reason | Yes | You build the logic | By hand |
| Letters and public inventory | Generated from your file | Yes, usually | No | No |
| Field collection, maps | No: use what you have | Yes | Yes | No |
| Price seen in public records | $990 a year per system | $17,000–$20,280 a year (120Water, council records 2023–2026) | Fulcrum $43/user/month, 5-user minimum; Ziptility from $440/month | Free |
Sources read on 30 Oct 2026: Lewes Board of Public Works (DE) 2023 proposal; Dublin (GA) council, Aug 2026; fulcrumapp.com/pricing; ziptility.com/pricing. Use Linewarden alongside a field app or GIS; it does not collect data in the field.
Pricing
One payment, 12 months, unlimited lines and runs.
Run the sample and check your own inventory free: the counts, the problems and the first 25 lines show on screen. Buy when you want the workbook, letters, public inventory and plan files for your own data. Prices in USD; Paddle adds sales tax or VAT where it applies and shows the total before you pay.
Single system
- 1 water system (PWSID)
- Unlimited lines, runs and updates
- Workbook, letters, public inventory
- Updates when the rules change
Multi-system
- Up to 10 water systems
- Utilities and authorities with several PWSIDs
- One file set per system
- Everything in Single system
Consultant
- Unlimited client water systems
- Engineering firms, contract operators, rural water associations
- Priority email support
- Everything in Multi-system
FOUNDING40 (40% off the first payment, until 30 Nov 2026) is applied automatically in the Paddle checkout. Your license key appears on screen right after payment with a Copy button: paste it on any computer your team uses. Lost it? Reply to your Paddle receipt and we resend it the same business day. Your invoice comes from Paddle.com, our reseller and Merchant of Record. Pay by card, purchasing card or purchase order.
- Paying: Paddle.com is the merchant of record: card or purchasing card, charged in USD, invoice and receipt from Paddle, sales tax handled by Paddle. Purchase order: email the PO and we send a Paddle invoice, net 30, by bank transfer or card. Quote PDF, Paddle's W-9 and vendor details: procurement page.
- Data: customer names and addresses never leave the computer, so there is no upload to review and nothing to sign for data processing.
- Dates: baseline inventory and replacement plan 1 Nov 2027; letters within 30 days; replacements by 1 Nov 2037 (40 CFR 141.84, 141.85).
FAQ
Questions operators and engineers ask
Is Linewarden approved by EPA or our State?
No. It applies the published rule text and EPA's own template logic to the data you give it, and it reproduces the classification of all 8 worked examples in EPA's template. Your State reviews your inventory and plan; some States have their own forms. Linewarden gives you EPA's columns and plain CSVs to fill them.
Is our customer data uploaded anywhere?
No. Your file is read by your browser and processed by JavaScript in the tab. To confirm: open the app, let it load, switch off your network, run your file and download the results. The Network tab of your browser's developer tools shows no request carrying your data. Our server only sees page requests and, when you buy, the Paddle transaction ID and checkout email used to issue the key.
Which files can it read?
EPA's Service Line Inventory Template (.xlsx, sheet "Detailed Inventory"), and any CSV or .xlsx with one row per service line: billing, GIS or asset exports. Columns are matched by name and you can change any match. Up to about 80 MB per file; a 50,000-line inventory runs in seconds.
Our State uses its own template.
The workbook keeps EPA's Detailed Inventory columns, which most State templates follow, and the exception list points to the row in your own file. Copy the columns into your State's form, or send us the form: State layouts are added to the license as updates.
How does it decide GRR?
Galvanized pipe is GRR when it is or ever was downstream of a lead line, or is downstream of a line of unknown material (40 CFR 141.2). So a galvanized customer side is GRR unless the system side is known non-lead and your file says it was never lead. Linewarden marks every GRR that rests only on missing evidence, so you know where a record would change the count.
Are the letters ready to mail?
They contain the elements of 141.85(e)(3), with the health-effects paragraph of 141.85(a)(1)(ii) word for word, and your contacts, plan link and health department filled in. Read one of each before you mail: you may want to add your replacement program details, and some States review notice templates or require other languages.
Can our engineer or contract operator use it for several systems?
Yes. The Consultant license covers any number of client systems, and each run produces its own file set named by PWSID.
Our purchasing office needs paperwork.
Paddle.com is the merchant of record: you get a proper invoice and receipt and can pay by card, including a purchasing card. Paying by purchase order? Email the PO and we send a Paddle invoice, net 30, by bank transfer or card. The procurement page has the seller details, Paddle's W-9, a quote PDF and a sole-source letter. For a security questionnaire or vendor registration, email support@atesensoftware.com; we reply within one business day. The security note covers data flow and checksums.
What if it does not work for our file?
Run your own file first: the free check shows every count and the first 25 lines. If you buy and it still does not work for you, ask within 14 days for a full refund.
See your inventory checked before you buy.
Free sample and free check in your browser. Files from $990. Founding offer: $594 with FOUNDING40 until 30 Nov.