Canada Pricing Engine

Upload Service Sheet Template For Pricing.

+Rate Data Management ▶

Download the current rate tables used by the pricing engine, or upload a new rate export to rebuild them. Any custom region assignments will be automatically preserved for cities that exist in both the current and newly uploaded data.

Drop a revised raw sheet here (CSV or XLSX) or click to browse

Expected columns: City, Province, Material, $/yd (or the original Business Task-at City / Business Task-at State / Material Description / $/yd headers).

Active Rate Data Version:

01Upload Service Sheet ▼

CSV with columns: City, Province, Material, Bin Size (yd), Quantity, Frequency, No. (optional), where Frequency represents pickups per week or "on call" for per-lift pricing.
No. indicates equipment type (TO = Tote, FL or blank = Front Load, CO = Compactor, OT = Open Top/Roll Off).

Drop CSV here or click to browse

Download Blank Template Load Sample Data

02Review & Calculate

0 lines loaded. Click Calculate To Estimate Pricing.

Prefer FMSA Rates

Nearest city max: 75 km

03Results

Total Monthly

Lines Priced

Direct City Match

No Data Found

Front Load bins by size

Compactors by size

Totes by size

GBC by size

Roll Off by size

Lines by material

City Match Nearest City Province Fallback No Data

Service ID	City	Prov	Material	Type	Bin Size	Qty	Freq/wk	Rate $/yd	Disposal $/mt	Source	Quoted City	Quoted Material	Quoted Size	Agreement Type	Price	Unit

Serviced Cities ▶

0 cities with coordinates

Pricing Analytics ▶

Highest real rate RTS is being charged in a province, with statistical outliers (both super high and super low) excluded before taking the max. Uses the same IQR bounds as the winsorized averaging elsewhere in this tool: values outside 1.5x the interquartile range are dropped, then the max of what remains is shown. Rebuilt on every raw data upload.

The actual averaged rates the pricing cascade uses for City Match, recomputed live from the underlying raw lines. Add one or more cities below; results combine into a single winsorized average per material/bin type, and you can uncheck specific haulers to exclude them and see the average recalculate instantly. If a city name matches more than one province you'll be asked to pick which one for that city.

Nearby within km

Winsorized average rate for a specific hauler (Task-at Name), recomputed live from the underlying raw lines, across every city that hauler services. Add one or more haulers below; results combine into a single average per material/bin type.

NYC Commercial Waste Zone Checker

Upload a spreadsheet of addresses to check current CWZ zone, phase, and rollout status.

+Single Address Search ▶

Check one address without uploading a spreadsheet. Uses the same live NYC data and logic as the bulk checker below.

01Upload Address Spreadsheet

CSV or XLSX with an address column (Full Address, or Address 1/2 + City/Borough + State + Zip), or existing Latitude/Longitude columns. Zone boundaries, DSNY rollout schedule, and geocoding are fetched live from NYC's own data sources on every check, nothing is hardcoded or cached beyond geocoded addresses.

Drop spreadsheet here or click to browse

02Run Check

File: none. This calls live NYC endpoints and can take a while for large files.

03Results

Matched

Needs Review

Not CWZ Location

Failed

Blank Rows

Republic Services Container Checker

Look up active containers and pickup schedules by address, without needing to be on Republic's site.

+Market Type Lookup ▶

Search an address or just a city/state to see whether it's a municipal contract or an open market (commercial/industrial), and which provider covers it. Geocoded via Mapbox, then checked against Republic's own GIS service.

One city/state per line (e.g. Denver, CO). Full addresses also work.

Matched

No Data

Filtered

Failed

01Addresses

One per line: Street, City, State ZIP (e.g. 9600 N Oak Trfy, Kansas City, MO 64155). Checks run against Republic's own public address/GIS/pickup endpoints server-side.

CSV or XLSX with either a single Address column, or separate Street / City / State / Zip columns.

Download Blank Template

Drop spreadsheet here or click to browse

02Results

Serviced

No Service

Failed

Waste Management Service Checker

Look up active services and pickup schedules by Customer ID or address.

01Lookup

One Customer ID per line or comma-separated.

02Results

Serviced

No Service

Failed

WM Price Lookup

Check whether Waste Management has service available at an address today, and what it would cost. Separate from the WM Checker above, which looks up existing WM customer accounts, not prospective service.

01Single Address

Full address

Format: Street, City, State/Province, Postal Code. Geocoded automatically via Mapbox.

02Bulk Lookup

One address per line. Availability plus a default (Trash, 1x/week) price for each, checked concurrently.

CSV or XLSX with Address, City, Province, plus Material Stream, Equipment Type (e.g. FL4, TO96), Size, and Frequency (0.5 = Every Other Week, 1/2/3/... = Nx per week) so each row is quoted at the requested combination. If WM doesn't offer that exact frequency, the closest one it does offer is used instead and clearly noted, never silently. Each row also gets that stream's overall Stream Average $/yd. Qty of Bins is optional. An optional Postal Code column is appended to the geocoded address, helps disambiguate towns with common names or similar-looking addresses. An optional Service ID column is carried straight through to the results and CSV (not used for matching) so you can VLOOKUP back against your own sheet. Cardboard falls back to a general recycling stream if a location has no dedicated cardboard pricing.

Download Blank Template

Drop spreadsheet here or click to browse

03Results

Available

No Service

Failed

v6.87 Debug Log

Release Notes

v6.87

The neighborhood/district geocode broadening from v6.85 didn't actually fix Lachenaie, QC (confirmed still ~2km from Levis after a full geo cache clear + re-geocode) — Mapbox genuinely returns a bad match for it regardless of search type. Added a manual coordinate override table (checked before Mapbox is ever queried, so it also overrides an already-bad cached entry) with Lachenaie's correct coordinates as the first confirmed entry; verified it now reports ~205km from Levis, matching the real ~240km driving distance

v6.86

Added a "Re-geocode All Cities" button to Rate Data Management, next to Clear Geo Cache. The endpoint behind it already existed but had no UI control, the only way to trigger it was re-uploading raw data. Now you can force every rate-card city through Mapbox again (e.g. after clearing the geo cache to pick up a geocoding fix) without needing to re-upload

v6.85

Fixed a real geocoding bug affecting distance-based features (nearby-city suggestions, map search, hauler distance): merged municipalities that no longer exist as independent places (e.g. Lachenaie, absorbed into Terrebonne years ago) were sometimes matching a wildly wrong, low-confidence Mapbox result, confirmed with a case ~2km from Levis, QC computed for a city that's actually ~240km/2.5hrs away. Mapbox queries now also search neighborhood/district types, not just place/locality, so merged municipalities resolve to their real coordinates. Existing cached coordinates for previously-affected cities need a geocode cache clear + re-geocode to pick up the fix

v6.84

Fixed Average per City's nearby-city suggestions expanding outward every time a suggested city was added. The radius is now always measured from the first city you added, not every currently-selected city, so "within 50km" stays anchored to your original search instead of compounding

v6.83

Grouped Max Pricing per Province, Average per City, and Average per Hauler into a single "Pricing Analytics" section with a tab bar, instead of three separate collapsible cards stacked on top of each other

v6.82

Average per Hauler's suggestion dropdown now has a "Select All" row at the top, adding every currently-filtered hauler at once (e.g. searching "wasteco" and clicking Select All adds every Wasteco entity in one click, without affecting unrelated haulers like a plain "Waste Management")

v6.81

Average per Hauler's suggestion dropdown now supports shift-click range select: click one hauler, then shift-click another to add every hauler between them in one go. Selected haulers show a checkmark in the list, and the dropdown stays open across clicks so a range can be extended with additional shift-clicks

v6.80

Added "Average per Hauler" to the bottom of the Pricing page: same winsorized-average, outlier-excluded breakdown as Average per City, but keyed by hauler (Task-at Name) across every city that hauler services instead of by city. Add one or more haulers as chips and results combine into a single average per material/bin type. Backed by a new `GET /rates/hauler-lines` endpoint, reusing the same per-line data as Average per City

v6.79

Fixed Average per City's hauler filter crashing with an Internal Server Error for high-volume cities. The underlying per-line table was storing one JSON object per raw transaction line, so a city with thousands of invoice lines could time out or exceed memory on that request; it's now grouped by hauler/material/bin type instead (a handful of groups per city, each carrying its full list of individual rates so the winsorized average is still exact), cutting a 5,000-line test city's payload from one-object-per-line down to 6 objects

v6.78

Average per City now suggests nearby cities to add: after searching, a "Nearby cities within Xkm" row shows other rate-card cities close to your selection, distance-sorted, one click to add. Radius is adjustable and respects the KM/MI toggle. Backed by a new `GET /rates/nearby-cities` endpoint (haversine distance against already-geocoded coordinates, no extra Mapbox calls)

v6.77

Average per City now shows a hauler checklist for the selected city/cities (from the raw data's Task-at Name column) and recalculates the winsorized average live, entirely client-side, when you uncheck a hauler to exclude it. Backed by a new per-line rate+hauler table (`city_material_lines.json`) persisted at raw upload time, and a new `GET /rates/city-lines` endpoint

v6.76

Average per City's multiple-city selection now combines results into a single weighted average per material/bin type (weighted by sample count, not a plain average of averages) instead of showing separate sections per city. Ambiguous city names still resolve inline before being folded into the combined average

v6.75

Average per City now supports selecting multiple cities at once, shown as removable chips, with results rendered as one section per city. If an added city name is ambiguous (matches more than one province), it's resolved inline without disturbing the other selected cities

v6.74

Fixed a real data quality bug: raw uploads with case-only city name variants (e.g. "Calgary" and "calgary" both present) were being aggregated as two separate cities with two separate averages, splitting the real rate data and showing duplicate cities in Average per City. Case variants are now merged into one city before aggregation, keeping whichever casing appears most often in the raw data
Fixed the city autocomplete dropdown in Average per City rendering behind the results table header instead of on top of it

v6.73

Removed the "Overall" row from Compactors (FL VIP) in Max Pricing per Province, since materials there stay genuinely distinct and a pooled figure isn't meaningful; Roll Off / Open Top keeps its Overall row since it already covers everything from small roll offs through large open-top compactors under a shared "ALL" material

v6.72

"Average per City" now shows a live dropdown of matching city names as you type, instead of requiring an exact typed match before searching

v6.71

Added "Average per City" to the bottom of the Pricing page: look up the actual averaged rates already used by the pricing cascade's City Match step for a specific city, broken out by bin type the same way as Max Pricing per Province. Search by city name with an optional province filter; if a city name exists in more than one province, you're shown a list to pick the right one
Roll Off and Compactor tables in Max Pricing per Province now also show an "Overall" row (pooled across all materials, fresh outlier bounds on the combined data) alongside the per-material breakdown, plus a separate Disposal Rate ($/mt) subsection for Roll Off

v6.70

Reworked the Max Pricing per Province tables to match how you'd naturally pivot this in Excel: Roll Off and Compactors now show a flat material-to-max-rate list (no size column, since those bin types don't have one), and Totes/Ground Bin Crane now show a matrix with material as rows and size as columns instead of a repeated row per size

v6.69

"Max Pricing per Province" now requires picking a province first (no more giant all-provinces table), then splits results into mini-sections by bin type (Front Load, Ground Bin Crane, Totes, Compactors, Roll Off) so it's easier to scan

v6.68

Added "Max Pricing per Province" to the bottom of the Pricing page: averages pricing per material and bin type for an entire province with statistical outliers excluded (IQR-based, both super high and super low), then reports the highest remaining real rate, so you can see the max RTS is being charged in a province without a single data-entry error or one-off job skewing the answer. Rebuilt on every raw data upload

v6.67

WM Price Lookup's spreadsheet upload now supports an optional Postal Code column, appended to the geocoded address to help Mapbox disambiguate towns with common names or similar-looking addresses

v6.66

Added a Qty selector to WM Price Lookup's single-address pricing table. Totals use WM's real bulk-quantity price tiers (confirmed non-linear, e.g. 2 bins isn't simply 2x the 1-bin price), not a flat multiply; quantities beyond WM's published tiers are extrapolated from the top tier and clearly marked "(est.)"
Bulk spreadsheet upload now prices Qty the same way: a new Qty Total Price column (plus a Qty Price Estimated flag) replaces the old naive per-bin x qty multiply
Bulk spreadsheet results' Matched / Frequency Substituted / Failed stat cards are now clickable filters, toggle any combination to narrow the results list and CSV export

v6.65

Fixed the main pricing engine's "Calculate Pricing" upload crashing with a raw 500 error on CSVs saved as Windows-1252 (very common from Excel once a French city name like Montreal, Trois-Rivieres, or Riviere-du-Loup is involved); now decodes cp1252 as a fallback when strict UTF-8 fails, instead of erroring out on an otherwise normal upload
Any other CSV parse failure now returns a clean, readable error message instead of a raw 500

v6.64

WM Price Lookup's spreadsheet upload no longer fails a row just because the exact requested frequency isn't offered; it now quotes at the closest frequency WM DOES offer for that material/type/size and clearly notes the substitution (never silent), both in the results view and CSV export
Each row's $/yd is calculated off whichever frequency the price actually came from, not the originally requested one
Relabeled the spreadsheet upload's result stat cards to fit that mode ("Matched" / "Frequency Substituted" / "Failed") instead of reusing the paste mode's "Available" / "No Service" labels, which didn't apply

v6.63

WM Price Lookup's spreadsheet upload now also returns each matched stream's Stream Average $/yd (the same outlier-excluded average shown on the single-address page), alongside the exact price/$-yd for the requested row, in both the results view and CSV export
Added optional Service ID column support: carried straight through to results/CSV, not used for address or material matching, so you can VLOOKUP the results back against your own spreadsheet
Removed the 30-address cap on the paste-addresses Bulk Lookup mode, verified with a 35-address batch

v6.62

WM Price Lookup's spreadsheet upload now distinguishes "WM has no pricing data at all for this address" (confirmed against WM's own API: an empty catalogs/products response, meaning the location isn't serviced or isn't in their system) from "WM has streams but none match the requested material" (lists the streams WM DID return)

v6.61

Renamed "Service Area Lookup" to "Market Type Lookup" on the Republic Checker
Fixed WM Checker's input box carrying over the same text when switching between By Customer ID and By Address, each mode now keeps its own typed text

v6.60

WM Price Lookup's Bulk Lookup now supports uploading a spreadsheet instead of just pasting addresses. Each row specifies its own Address/City/Province, Material Stream, Equipment Type (e.g. FL4, TO96), Size, and Frequency (0.5 = Every Other Week, 1/2/3/... = Nx per week), so every row gets the exact price WM returns for that combination instead of the paste mode's default (Trash, 1x/week)
Cardboard automatically falls back to a general recycling stream if a location has no dedicated cardboard pricing, clearly labeled as a fallback in the results and CSV export
If WM doesn't have pricing at the exact requested frequency for that material/type/size, that's reported as an error listing which frequencies ARE available, never a silently substituted price
Results and CSV export include the full fee breakdown (Base Amount, Fuel/Energy/Env/RCR Fees, All-In Price), $/yd for Front Load, and Qty of Bins x All-In Price as a total

v6.59

WM Price Lookup's $/yd averages now exclude outliers (IQR-based, same method used throughout this app for rate-card averaging) before averaging, per bin size, so one skewed frequency (e.g. a disproportionately high "Every Other Week" rate) no longer drags the whole average up

v6.58

WM Price Lookup now shows the Front Load $/yd average box for every material stream at once (Trash and Recycle side by side), instead of only the one currently selected in the dropdowns below

v6.57

WM Price Lookup's $/yd average is now shown two ways: a Stream Average (all Front Load sizes and frequencies pooled together) and a per-size average (e.g. 1yd, 4yd, 8yd each shown separately), instead of one blended number
Moved into a small box in the top-right corner of the result card instead of a full-width banner

v6.56

Added an average $/yd banner to WM Price Lookup, per material stream (Trash/Recycle): averages $/yd across every Front Load size and frequency combination the API returned, not just the currently-selected size's rows
Fixed an unhandled 500 error if geocoding fails or errors out (e.g. MAPBOX_TOKEN misconfigured), now returns a clean error message instead of a raw server error

v6.55

WM Price Lookup now geocodes via Mapbox (the same token already used elsewhere in this app) instead of Nominatim/OpenStreetMap, whose free data had real gaps: a real WM account address wasn't in OpenStreetMap's dataset at all, and Canadian postal codes were sometimes wrong
Bulk lookups now run concurrently (5 at a time) instead of one at a time, since Mapbox has no shared 1 req/sec limit like Nominatim did

v6.54

Fixed the version footer and Debug Log link not showing on any subpage except Pricing, they were nested inside the Pricing view's markup instead of sitting outside all views
The selected nav tab is now highlighted in the app's green (var(--moss)) instead of a barely-visible white overlay

v6.53

WM Price Lookup's single-address result now shows the geocoded, properly-cased address (e.g. "1375 Prince Of Wales Drive, Ottawa, ON K2C 3N5") instead of echoing back whatever raw text/casing was typed in
Fixed unreadable dark-on-dark header text in the pricing table (an inline style was overriding the theme's header color)
All-In Price and $/yd are now highlighted in green so they stand out from the fee breakdown columns

v6.52

Fixed WM Checker's address parser to handle addresses with no commas at all (e.g. "123 main st chicago il 60601"), previously only "Street, City, State ZIP" with commas parsed correctly, anything else left city/state/zip blank and WM's API rejected it with a 400
Now strips commas and treats them as plain whitespace, then peels zip/postal code, state/province, and street (using a trailing street-suffix match) off the end, leaving city as whatever's left, handles both US zips and Canadian postal codes

v6.51

WM Checker's address lookup no longer requires a Google Places API key, that field is gone from the UI entirely
Direct testing showed WM's account/search doesn't need a Google Place ID or coordinates at all, it just parses street/city/state/postalCode as plain text, so address mode now skips geocoding entirely instead of routing through Nominatim (which could fail on real accounts not in OpenStreetMap's data)
Known limitation: at multi-tenant addresses (e.g. a business inside a shared commercial building) WM's API returns "Narrow Search" since a street address alone can't disambiguate between multiple accounts there, now surfaced as a clear error suggesting Customer ID lookup instead

v6.50

WM Price Lookup's pricing table now shows WM's full fee breakdown per frequency: Base Amount, Fuel Fee, Energy Fee, Env Fee, RCR Fee, then All-In Price
The $/yd column (Front Load only) is now explicitly calculated off All-In Price: All-In Price / (4.33 x size x frequency)

v6.49

Added a $/yd column to WM Price Lookup's pricing display, Front Load only: monthly price / (4.33 x size x frequency)

v6.48

WM Price Lookup's frequency/price rows are now sorted low to high (Every Other Week, 1x, 2x, 3x per week) instead of whatever order WM's API returned them in

v6.47

WM Price Lookup's single-address pricing is now a cascading dropdown (Waste/Recycle > Type > Size) instead of one long table, type and size are parsed out of WM's product names (e.g. "1 Yard Trash Dumpster" → Front Load, 1yd; "96-Gallon Waste Bin" → Tote, 96gal)
Selecting a combination shows just that item's frequency/price options

v6.46

Added a new subpage, WM Price Lookup: checks whether Waste Management has service available at an address today and what it would cost, by proxying WM's own get-me-started and catalogs/products shop-flow APIs
Separate feature from the existing WM Checker tab, which looks up EXISTING WM customer accounts by Customer ID or address, not prospective service/pricing
Single address search plus a bulk mode (up to 30 addresses, one per line), with CSV export
Geocoded via Nominatim/OpenStreetMap, no API key required, rate-limited server-side to Nominatim's 1 req/sec usage policy

v6.45

Added a second, independent defense against the CWZ Checker's out-of-NYC false-match bug: a cross-check against Mapbox's general (non-NYC-scoped) US geocoder, catches addresses with no zip in them at all (the v6.44 fix only helped when a zip was present in the text)
If Mapbox and NYC GeoSearch disagree by more than 8km on where an address is, the result is now rejected as "Not CWZ Location" instead of returned as a false zone match

v6.44

Fixed a bug in the CWZ Checker's out-of-NYC guard: it only read a zip from a dedicated Zip spreadsheet column, so single-address search (and any upload using one combined Address field) never had a zip to check against and could return a bogus in-NYC match for an out-of-city address
Now falls back to pulling the zip straight out of the free-text address when no separate zip column matched, so the pre-geocode NYC-zip check and the post-geocode zip cross-check both fire correctly (e.g. "363 Hempstead Ave, Malverne, NY 11565" now correctly returns Not CWZ Location instead of a false match)

v6.43

Replaced the Commercial/Industrial-only toggle on Republic Service Area Lookup with a multi-select filter showing every service area type found in the results (Resi Trash, Comm. Recycling, Industrial Temp, etc.), pick any combination
Bulk Upload results can also be filtered by status (Matched, No Data, Filtered, Failed), with a new Filtered stat card showing results hidden by the type filter
Both filters apply to the bulk CSV export

v6.42

Fixed Commercial/Industrial filter incorrectly hiding commercial records that are delivered under a municipal contract (e.g. Albany, OR's Comm. Trash/Recycling)
Filter now checks the service area type (Comm/Industrial vs Resi) instead of who holds the contract

v6.41

Added "Commercial & Industrial only" filter to Republic Service Area Lookup, both Single Search and Bulk Upload
Filter also applies to the bulk CSV export

v6.40

Republic Service Area Lookup now has a Bulk Upload mode: paste a list of cities/states or addresses, check them all, download results as CSV

v6.39

Added a collapsible Single Address Search to the CWZ Checker, for one-off lookups without uploading a spreadsheet

v6.38

Service Area Lookup card is now collapsible (collapsed by default)
Republic container checker now supports uploading a CSV/XLSX spreadsheet as an alternative to pasting addresses
Added a Download Blank Template button for the spreadsheet upload

v6.37

Added a Service Area Lookup search to the Republic Checker: search any address or just a city/state to see whether it's municipal or open market (commercial/industrial), and which provider covers it

v6.36

Added Waste Management Service Checker as a fourth subpage
Toggle between looking up by Customer ID or by address
Address mode requires your own Google Places API key (stored only in your browser, never on the server), since WM's address search needs a Google Place ID to resolve an address

v6.35

CWZ Checker is much faster: addresses are now checked 8 at a time instead of one at a time (roughly 8x faster on large files)

v6.34

Added Republic Services Container Checker as a third subpage
Paste addresses, get back active containers and pickup schedules, no need to be on Republic's site (server-side lookup, not a browser bookmarklet anymore)

v6.33

Fixed CWZ Checker returning wrong zones/coordinates for addresses outside NYC (e.g. Long Island, upstate NY)
Non-NYC zip codes are now rejected before geocoding instead of being force-matched to a random NYC street
Geocoded zip is cross-checked against the input zip, mismatches are marked "Not CWZ Location"

v6.32

CWZ Checker progress bar is now real, live progress per address instead of a fake pulsing bar
New SSE endpoint /cwz/check-stream

v6.31

Added NYC Commercial Waste Zone Checker as a separate subpage (nav tab up top)
Upload an address spreadsheet, get back zone, phase, rollout status, and dates using live NYC Open Data + DSNY + GeoSearch, no AI involved

v6.30

Global KM/MI toggle in navbar controls all distance values
Geo-based hauler search: find nearest haulers by distance, not just city name
Hauler cities geocoded during raw data upload
Nearest city notes show miles when mi toggle is active

v6.25

Clickable version footer opens release notes

v6.24

Nearest city max distance slider (0-100km) in pricing section
km/mi unit toggle for distance display

v6.23

km/mi toggle added to map search slider

v6.22

Max distance slider (0-100km, default 75) for map search

v6.21

Map search shows nearest serviced city with distance and drive time
Serviced cities get green marker, unserviced get red with dashed line to nearest

v6.20

Updated background SVG pattern
Updated brand-bg CSS positioning

v6.19

Removed AI Nearest City from cascade entirely
Added material fallback groups (SST/OCC, SST/MXC/MXP)
Fixed geo matching crash (max_km vs max_distance_km)
SVG fill-opacity set to 0.035

Debug Log

Enter password

Canada Pricing Engine

+Rate Data Management ▶

01Upload Service Sheet ▼

02Review & Calculate

03Results

Front Load bins by size

Compactors by size

Totes by size

GBC by size

Roll Off by size

Lines by material

Serviced Cities ▶

Pricing Analytics ▶

NYC Commercial Waste Zone Checker

+Single Address Search ▶

01Upload Address Spreadsheet

02Run Check

03Results

Republic Services Container Checker

+Market Type Lookup ▶

01Addresses

02Results

Waste Management Service Checker

01Lookup

02Results

WM Price Lookup

01Single Address

02Bulk Lookup

03Results