coned-rate-optimizer

ConEd Rate Optimizer is a single-page, fully client-side calculator that answers one narrow question: for a given household's real electricity usage, would Con Edison's Residential Time-of-Use plan cost less than the Standard (SC1) plan? The user uploads a Con Edison "Download my data" Green Button export (CSV/TSV of 15-minute interval usage) and the page reports a verdict — stay on Standard or switch, with the dollar difference — without sending the data anywhere. What it does - Parses ConEd 15-minute interval Green Button CSV/TSV entirely in the browser. - Prices the uploaded usage under Standard (SC1) versus Residential Time-of-Use, month by month. - Displays a verdict (stay / switch plus a dollar amount), a per-plan comparison table, the peak/off-peak load shape, and a monthly bar chart. - The README describes the tool as deliberately conservative: for most peak-heavy NYC homes it will report "stay on Standard." - A built-in anonymized example is included, but it contains monthly aggregates only, so the interactive experience is meant to be driven by a real export. Structure and reuse - public/ is the deployable directory (index.html, styles.css, app.js for DOM glue, calc.js as the pure calculation core, sample.js, and an optional rates.json for live rate overrides). - calc.js is written to also run under Node, which makes the pricing logic testable outside the browser. - verify.js is a Node verification script; test/ holds an automated test suite for the calc core plus CSV fixtures. - The README points to docs/product-strategy.md for a documented path from this prototype toward a chargeable analysis, covering pricing, Green Button Connect, Meta acquisition assumptions, accuracy gates, and the month-over-month bill experience. Running and verifying locally - Serve statically, for example python3 -m http.server -d public 8000, then open http://localhost:8000. - node test/test.js runs the automated test suite and exits with a status code. - node verify.js recomputes the math against the bundled test fixture by default, or against a user-supplied export when given a path. Rate model and stated caveats - Standard components are described as ConEd's published 2025 SC1 NYC average, grossed up for GRT plus sales tax, and excluding the fixed customer charge; TOU supply rates are the currently published residential TOU supply rates. - Absolute totals are stated to be within roughly ±5%, because the monthly Market Supply Charge varies and 2026 months are priced at 2025 rates. - The model assumes delivery, MAC, RDM, and surcharges are identical under both plans, and folds super-peak into peak. - The author labels the output an estimate and states no affiliation with Con Edison; rate constants in public/calc.js (RATES) must be updated when ConEd rates change. Privacy - Usage data is never uploaded or stored; all parsing and pricing happen in the browser. - The live site uses Cloudflare Web Analytics, which the README describes as cookie-less and privacy-safe, to count pageviews and sample interaction events such as button clicks, successful parses, and parse errors. In short, it is a small, inspectable utility for a household decision: upload your own interval data, see the two plans priced side by side, and check the math yourself with the included Node scripts.